Home » RDBMS Server » Performance Tuning » EXECUTION TIME
EXECUTION TIME [message #289963] Wed, 26 December 2007 22:54 Go to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
I m using oracle 10gr2 in solaris, i m executing a SQL and the execution time is little bit interesting ...its like 4s then 10sec then 4 sec then 11sec then 4 sec then 10sec like this...

is there any reason for that???

thanx.
Re: EXECUTION TIME [message #289992 is a reply to message #289963] Thu, 27 December 2007 01:01 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Post your SQL statement here, including tracing
Re: EXECUTION TIME [message #289998 is a reply to message #289963] Thu, 27 December 2007 01:28 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many reasons, concurrent server cpu workload, disk workload, network workload, client workload...

Regards
Michel
Previous Topic: CLOB usage and issue with TEMP tablespace
Next Topic: Entries are getting very slow.
Goto Forum:
  


Current Time: Sat Dec 03 12:00:41 CST 2016

Total time taken to generate the page: 0.05072 seconds