Scrum a Arte de Fazer o Dobro

SELECT s.saddr, s.SID, s.serial#, s.audsid, s.paddr, s.USER#, s.username,

s.command, s.ownerid, s.taddr, s.lockwait, s.status, s.server,

s.SCHEMA#, s.schemaname, s.osuser, s.process, s.machine, s.port,

s.terminal, UPPER (s.program) program, s.TYPE, s.sql_address,

s.sql_hash_value, s.sql_id, s.sql_child_number, s.prev_sql_addr,

s.prev_hash_value, s.prev_sql_id, s.prev_child_number,

s.plsql_entry_object_id, s.plsql_entry_subprogram_id,

s.plsql_object_id, s.plsql_subprogram_id, s.module, s.module_hash,

s.action, s.action_hash, s.client_info, s.fixed_table_sequence,

s.row_wait_obj#, s.row_wait_file#, s.row_wait_block#,

s.row_wait_row#, s.logon_time, s.last_call_et, s.pdml_enabled,

s.failover_type, s.failover_method, s.failed_over,

s.resource_consumer_group, s.pdml_status, s.pddl_status, s.pq_status,

s.current_queue_duration, s.client_identifier,

s.blocking_session_status, s.blocking_instance, s.blocking_session,

s.seq#, s.event#, s.event, s.p1text, s.p1, s.p1raw, s.p2text, s.p2,

s.p2raw, s.p3text, s.p3, s.p3raw, s.wait_class_id, s.wait_class#,

s.wait_class, s.wait_time, s.seconds_in_wait, s.state,

s.service_name, s.SQL_TRACE, s.sql_trace_waits, s.sql_trace_binds,

s.ecid

FROM v$session s

WHERE ( (s.username IS NOT NULL)

AND (NVL (s.osuser, 'x') <> 'SYSTEM')

AND (s.TYPE <> 'BACKGROUND')

)

ORDER BY "STATUS", ownerid

...