Home » RDBMS Server » Performance Tuning » Elapsed time (oracle 10g)
Elapsed time [message #505827] Thu, 05 May 2011 03:38 Go to next message
fowjil
Messages: 1
Registered: April 2009
Location: Bangalore
Junior Member
why different elapsed time in oracle 9i and oracle 10g for the same query ?

Report message to a moderator

Re: Elapsed time [message #505828 is a reply to message #505827] Thu, 05 May 2011 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because you didn't do it in the same environment.

Regards
Michel

Report message to a moderator

Re: Elapsed time [message #505903 is a reply to message #505828] Thu, 05 May 2011 09:47 Go to previous message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Moreover, if you run the same query many times in the same database, elapsed times would most probably differ as well.

Report message to a moderator

Previous Topic: Procedure code taking longer time to execute
Next Topic: After trigger causing performance bottleneck
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 17 20:39:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.