Query to tie Rollback to Session ID/Process ID 
Author Message
 Query to tie Rollback to Session ID/Process ID
Does anyone have a query that can identify what rollback segment a
session/process is using?

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 Query to tie Rollback to Session ID/Process ID


Quote:

> Does anyone have a query that can identify what rollback segment a
> session/process is using?

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Try this:

SELECT     r.name rr,
           nvl(s.username,'no transaction') us,
           s.osuser os,
           s.terminal te
FROM       v$lock  l, v$session  s,v$rollname  r
WHERE      l.sid = s.sid(+) AND
           trunc(l.id1/65536) = r.usn AND
           l.type = 'TX' AND
    l.lmode = 6
ORDER BY   r.name
/

--
David Fitzjarrell
Oracle Certified DBA

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Linking Unix Process Id's back to Session Id's

2. Error: Process ID %d is not an active process ID

3. Msg 6106,Sev 16: Process ID 67 is not an active process ID.

4. Msg 6106,Process ID %d is not an active process ID.

5. Tying Oracle to NT process id's ?

6. How the Number of the session opened (process ID) impact the different sesstion

7. Current Session ID (SID) v$session

8. Session ID -- Again (How to implement single session login)

9. getting query execution time for a process id

10. Process ID 216:1112 owns resources that are blocking processes on Scheduler

11. WHILE ID='::ID::' has me confused

12. event ID 64001 File replacement in a cluster and event ID 64004


 
Powered by phpBB® Forum Software