| finding users query [message #60703] |
Thu, 26 February 2004 21:00  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
hi all, i need some info regarding users session.
for example if a user executed or executing a statement, and if it is just going on for long time without any O/P which it doesnt do normally, how to find out what the query was without asking the user, what is the query currently doing, what are tables it is accessing and info abt the locks?
i heard about v$views(session,session_event,sql etc) but dont know how to do it. this is the problem i normally face.
so pls can anyone explain and also suggest like if query is going on forever what to do, without asking the user to stop and execute again.
thanx in advance.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
