| SQL statement in the SGA [message #303478] |
Fri, 29 February 2008 08:41  |
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  |
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)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
