orcl_Sessiions

SELECT  AUDSID, Client_Info, Command, Last_Call_ET, LockWait, Logon_Time, Machine, Module, OSUser, PADDR, Process, Program, SchemaName, Serial#, Server, SID, Status, Terminal, Type, Action, UserName, Failover_Method, Failed_Over, Failover_Type, PDML_Enabled, PDDL_Status, PDML_Status, PQ_Status, Resource_Consumer_Group, SQL_Child_Number, SQL_ID
FROM V$SESSION s
WHERE ( sid = '38')
 AND  ( (s.USERNAME is not null) and (NVL(s.osuser,'x') <> 'SYSTEM') and (s.type <> 'BACKGROUND') )
 
SELECT  * FROM V$PROCESS WHERE  (addr = '3FD35D44')
 
SELECT  * FROM V$SESS_IO WHERE  sid = '38'
 
SELECT  SID, SEQ#,EVENT,WAIT_TIME,SECONDS_IN_WAIT, STATE FROM v$session_wait WHERE  sid = '38'
 
SELECT  ROWNUM, EVENT,TOTAL_WAITS,TOTAL_TIMEOUTS,TIME_WAITED,AVERAGE_WAIT , MAX_WAIT, TIME_WAITED_MICRO FROM v$session_event WHERE  sid = '38'
 
select decode(sql_hash_value, 0, prev_hash_value, sql_hash_value) hash
       , decode(sql_id, null, prev_sql_id, sql_id) sql_id
from v$session
where sid = :sid
sid = '38'
 
SELECT SQL_TEXT FROM  V$SQLTEXT_WITH_NEWLINES WHERE
HASH_VALUE=TO_NUMBER(:hash) ORDER BY PIECE
hash = '2380370066'
 
select 
       o.sid, o.sql_text, o.address, o.hash_value, o.user_name, s.schemaname
from   v$open_cursor o, v$session s
where  o.saddr = s.saddr
and    o.sid = s.sid
and   ( O.SID = '38')
 
SELECT SQL_TEXT FROM V$SQLTEXT_WITH_NEWLINES WHERE 
HASH_VALUE=TO_NUMBER(:hash) ORDER BY PIECE
hash = '4060026339'
 
alter session set current_schema = SYS
 
Select *
from v$sql_plan
Where hash_value = :sqlhv
and child_number =:cn
order by id
sqlhv = '4060026339'
cn = 0
 
alter session set current_schema = HAINKURT
 
SELECT  sid, owner, type, object FROM v$access WHERE  sid = '38'
 
Select         lk.SID, se.username, se.OSUser, se.Machine,  DECODE(lk.TYPE,         'TX', 'Transaction',         'TM', 'DML',         'UL', 'PL/SQL User Lock',          lk.TYPE  ) lock_type,  DECODE(lk.lmode,         0, 'None',         1, 'Null',         2, 'Row-S (SS)',         3, 'Row-X (SX)',         4, 'Share',         5, 'S/Row-X (SSX)',         6, 'Exclusive',         TO_CHAR(lk.lmode)  ) mode_held,  DECODE(lk.request,         0, 'None',         1, 'Null',         2, 'Row-S (SS)',         3, 'Row-X (SX)',         4, 'Share',         5, 'S/Row-X (SSX)',         6, 'Exclusive',         TO_CHAR(lk.request)  ) mode_requested,  TO_CHAR(lk.id1) lock_id1,  TO_CHAR(lk.id2) lock_id2,  decode(block, 0, 'No', 1, 'Yes', 2, 'Global') block, se.lockwait FROM v$lock lk, v$session se WHERE (lk.type = 'TX')  AND (lk.SID = se.SID) AND ( lk.sid = '38')
 
Select         lk.SID, se.username, se.OSUser, se.Machine,        DECODE (lk.TYPE,                'TX', 'Transaction',                'TM', 'DML',                'UL', 'PL/SQL User Lock',                lk.TYPE               ) lock_type,        DECODE (lk.lmode,                0, 'None',                1, 'Null',                2, 'Row-S (SS)',                3, 'Row-X (SX)',                4, 'Share',                5, 'S/Row-X (SSX)',                6, 'Exclusive',                TO_CHAR (lk.lmode)               ) mode_held,        DECODE (lk.request,                0, 'None',                1, 'Null',                2, 'Row-S (SS)',                3, 'Row-X (SX)',                4, 'Share',                5, 'S/Row-X (SSX)',                6, 'Exclusive',                TO_CHAR (lk.request)               ) mode_requested,        TO_CHAR (lk.id1) lock_id1, TO_CHAR (lk.id2) lock_id2, ob.owner,        ob.object_type, ob.object_name, decode(lk.Block, 0, 'No', 1, 'Yes', 2, 'Global') block, se.lockwait   FROM v$lock lk, dba_objects ob, v$session se  WHERE    lk.TYPE IN ('TM','UL')    AND lk.SID = se.SID    AND lk.id1 = ob.object_id (+)  AND ( lk.sid = '38')
 
SELECT  SID,  decode(totalwork, 0, 0, round(100 * sofar/totalwork, 2)) "Percent", message "Message", start_time, elapsed_seconds, time_remaining  from v$Session_longops where  ( sid = 38 and serial# = 23)  ORDER BY SID
 
SELECT  a.sid, decode(b.class,1,'User',2,'Redo',4,'Enqueue',8,'Cache',16,'OS',32,'ParallelServer',64,'SQL',128,'Debug',72,'SQL & Cache',40,'ParallelServer & Cache')  class,b.name,a.value from v$sesstat a, v$statname b where (a.statistic#=b.statistic#) and  sid = '38'
 
SELECT  a.sid, decode(b.class,1,'User',2,'Redo',4,'Enqueue',8,'Cache',16,'OS',32,'ParallelServer',64,'SQL',128,'Debug',72,'SQL & Cache',40,'ParallelServer & Cache')  class,b.name,a.value from v$sesstat a, v$statname b where (a.statistic#=b.statistic#) and  sid = '29'
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57: