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: 306
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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
select start_time from v$transaction;

Report message to a moderator

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: 306
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.

Report message to a moderator

Previous Topic: Oracle NOT IN query is slow
Next Topic: How To Get Previous Version Of Stats Gathered
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 01:39:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.