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.

Report message to a moderator

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: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Post your SQL statement here, including tracing

Report message to a moderator

Re: EXECUTION TIME [message #289998 is a reply to message #289963] Thu, 27 December 2007 01:28 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Many reasons, concurrent server cpu workload, disk workload, network workload, client workload...

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 05:31:11 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.