| commit wait time [message #56294] |
Mon, 17 March 2003 12:07  |
tt
Messages: 16
Registered: September 2000
|
Junior Member |
|
|
How do you set how long to wait for a lock again in a session?
Like i wait for someone to commit, where do i query to see how long I ll wait and how to change it?
Thanks
|
|
|
|
| Re: commit wait time [message #56297 is a reply to message #56294] |
Mon, 17 March 2003 13:49  |
Michel Bartov
Messages: 35
Registered: February 2003
|
Member |
|
|
SELECT a.name, l.sid, b.username, l.type, l.lmode,
l.request, l.ctime, l.id2
from v$lock l, sys.obj$ a, v$session b
where l.id1=a.obj#(+)
and l.sid=b.sid
and l.type in ('TX', 'TM', 'RW', 'UL')
order by l.sid, l.type, l.lmode;
(ctime will give the elapsed time in seconds)
I just posted an integrated set of GUI tools to administer the Oracle database. One of the performance functions allows you to monitor database locks. You can see which table is locked, who is locking it, how long it is locked and the SQL statement issued to lock the table. You may need same help to get started, so feel free to contact me.(michelbartov@go.com). The link is http://www.barsoft.net/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
