Home » RDBMS Server » Performance Tuning » Find the query running time (oracle9i)
Find the query running time [message #320941] Fri, 16 May 2008 16:24 Go to next message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Hello all,

I am using oracle9i. I wanted to find out how long the SQL queries are running currently in database? We can enable trace and find out this info from trace file. But is there any other appraoch to get the answer for this..

Let us assume, we are not using any tools like TOAD..

Thanks
Govind
Re: Find the query running time [message #320943 is a reply to message #320941] Fri, 16 May 2008 16:44 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
select start_time from v$transaction;
Re: Find the query running time [message #320944 is a reply to message #320943] Fri, 16 May 2008 17:03 Go to previous message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Hello, Thank you for your quick reply. In my experience, this is the only place i get the quick answer. Thank you and appriciate your time.
Previous Topic: Oracle NOT IN query is slow
Next Topic: How To Get Previous Version Of Stats Gathered
Goto Forum:
  


Current Time: Sun Dec 04 02:49:13 CST 2016

Total time taken to generate the page: 0.07937 seconds