| Rollback-DBA doubts [message #18428] |
Wed, 30 January 2002 22:25  |
Gowrish,yogesh
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
1) How do i find the processes/tables being accessing
a Rollback segment ?
2) How can a extract a words from a file using PL/SQL?
3) What is the significance of ENQUEUE_PROCESS in
init.ora parameter file ?
|
|
|
|
| Re: Rollback-DBA doubts [message #18443 is a reply to message #18428] |
Thu, 31 January 2002 03:58  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
1)
SELECT r.name "RB NAME ", p.pid "ORACLE PID",
p.spid "SYSTEM PID ", NVL (p.username, 'NO TRANSACTION'), p.terminal
FROM v$lock l, v$process p, v$rollname r
WHERE l.sid = p.pid(+)
AND TRUNC (l.id1(+)/65536) = r.usn
AND l.type(+) = 'TX'
AND l.lmode(+) = 6
ORDER BY r.name
2) use utl_file package
3) enqueue_process or enqueue_resources?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
