Sql

select osuser, username, machine, program 
  from v$session 
  order by osuser

-- Sessions by user
select username Usuario_Oracle, count(username) Numero_Sesiones
from v$session
group by username
order by Numero_Sesiones desc

-- Order sessions by app
select program Aplicacion, count(program) Numero_Sesiones
from v$session
group by program 
order by Numero_Sesiones desc

PREVIOUS	NEXT

Code Example
Sql :: postgresql filter on
Sql :: mysql delete data in table
Sql :: sql count total by foreign key
Sql :: mysql load sql from file
Sql :: mysql datetime with timezone offset
Sql :: get max salary from each department sql
Sql :: data formate in sql
Sql :: insert into select mysql
Sql :: mysql select count
Sql :: how to find average in sql
Sql :: object dependencies in oracle
Sql :: SQL Add Column in a Table
Sql :: how to find all children of a record with only parent ID in sql
Sql :: sql rtrim
Sql :: sql convert datetime
Sql :: pivot
Sql :: sql left
Sql :: NVL() Functions
Sql :: mysqldump database
Sql :: mysql not equal
Sql :: create table from existing table in sql
Sql :: sql alchemy or
Sql :: auto increment column in mysql query results
Sql :: stuff sql server
Sql :: auto increment in postgresql
Sql :: pgadmin see indexes
Sql :: between
Sql :: sql query to create table in database
Sql :: tsql pad left
Sql :: postgres having