Tuesday, May 19, 2009 |
Sessions RAC |
Hello Everyone!!!
Displays information on all database sessions for whole RAC. -- ---------------------------------------------------------------------------------- SET LINESIZE 500 SET PAGESIZE 1000
COLUMN username FORMAT A15 COLUMN machine FORMAT A25 COLUMN logon_time FORMAT A20
SELECT NVL(s.username, '(oracle)') AS username, s.inst_id, s.osuser, s.sid, s.serial#, p.spid, s.lockwait, s.status, s.module, s.machine, s.program, TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time FROM gv$session s, gv$process p WHERE s.paddr = p.addr AND s.inst_id = p.inst_id ORDER BY s.username, s.osuser;
SET PAGESIZE 14 -- ---------------------------------------------------------------------------------- Happy Learning, --SreeneLabels: Sessions RAC |
posted by Srinivasan .R @ 3:24 AM |
|
2 Comments: |
-
Thanks for sharing informative article . It helped me to understand the career prospects in iOS Training in Chennai
-
Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care.Keep update,,..
Android Training in Chennai
|
|
<< Home |
|
|
|
Thanks for sharing informative article . It helped me to understand the career prospects in
iOS Training in Chennai