SQL statement in the SGA [message #303478] |
Fri, 29 February 2008 08:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rsreddy28
Messages: 295 Registered: May 2007
|
Senior Member |
|
|
Hello All,
How can I find out which user's SQL statement is in the SGA either Library Cache or the Database buffer Cache ,be it the Select or the Insert.
I've tried in v$SQL,v$SQLAREA,v$SQLTEXT using the hash_value but I could'nt succeed. Don't know if I'm right or wrong in this.
Any help on this please.
Regards,
Raj
[Updated on: Fri, 29 February 2008 08:48] Report message to a moderator
|
|
|
|
Re: SQL statement in the SGA [message #303500 is a reply to message #303487] |
Fri, 29 February 2008 10:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rsreddy28
Messages: 295 Registered: May 2007
|
Senior Member |
|
|
Ok,
Is there anyway where we can find out the presence of SQL statements what we are passing which we can identify by the hash_value .
I was asked , what SQL statements are present in the Library cache or buffer cache? Is that possible in any of the possible way(if available)
|
|
|
|
|