query perfomance [message #143532] |
Thu, 20 October 2005 14:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nitin_228
Messages: 29 Registered: May 2005 Location: RICHMOND, VA
|
Junior Member |
![nitin_228](/forum/theme/orafaq/images/yahoo.png)
|
|
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|