query perfomance [message #143532] |
Thu, 20 October 2005 14:48 |
nitin_228
Messages: 29 Registered: May 2005 Location: RICHMOND, VA
|
Junior Member |
|
|
I have a basic question with query perfomance
I have a query which loads a lob in one of my datafiles.
query is kind of hanging.
Can some one pls tell me how can i do perfomance tuning
of that query
|
|
|
Re: query perfomance [message #143773 is a reply to message #143532] |
Sat, 22 October 2005 05:23 |
girish.rohini
Messages: 744 Registered: April 2005 Location: Delhi (India)
|
Senior Member |
|
|
did you checked v$session_longops for ascertaining what is exactly happening in the query?
Also check for the explain plan for this query.
|
|
|