Home » RDBMS Server » Performance Tuning » query perfomance
query perfomance [message #143532] Thu, 20 October 2005 14:48 Go to next message
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 Go to previous message
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.
Previous Topic: How do I force a hash join
Next Topic: Reading Output of Plan Table
Goto Forum:
  


Current Time: Sat Nov 23 16:28:37 CST 2024