| Segment users [message #64364] |
Mon, 17 January 2005 05:03  |
Mohammed Abubakker
Messages: 3
Registered: December 2004
|
Junior Member |
|
|
Please tell me how to see which user is using the segments or which transaction is going on in a particular segments
Abu
|
|
|
|
| Re: Segment users [message #64372 is a reply to message #64364] |
Wed, 19 January 2005 23:41  |
Depa
Messages: 30
Registered: June 2002
|
Member |
|
|
to find which user is using the rollback segment
SELECT r.name "RB NAME ", p.pid "ORACLE PID", p.spid "SYSTEM PID ", NVL (p.username, 'NO TRANSACTION') "OS USER", p.terminal FROM v$lock l, v$process p, v$rollname r, v$session s WHERE l.sid = s.sid(+) AND s.paddr = p.addr AND TRUNC (l.id1(+)/65536) = r.usn AND l.type(+) = 'TX' AND l.lmode(+) = 6 ORDER BY r.name;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
