Home » RDBMS Server » Performance Tuning » help!!->resolving "cpu time" problem
help!!->resolving "cpu time" problem [message #162120] Wed, 08 March 2006 19:05 Go to next message
rzmni
Messages: 8
Registered: May 2005
Junior Member
running on 9.2.0.1.0

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~
%Total
Event Waits Time (s) Ela Time
------------------------------ ------------ ----------- --------
CPU time 467 63.01
latch free 7,431 124 16.73
direct path write 5,865 86 11.55
direct path read 7,250 43 5.80
log file sync 252 5 .70

how can I further reveal the cause and finally obtain a solution

Report message to a moderator

Re: help!!->resolving "cpu time" problem [message #164720 is a reply to message #162120] Sat, 25 March 2006 01:03 Go to previous message
Frank Naude
Messages: 4596
Registered: April 1998
Senior Member
Why is "CPU Time" a problem? Some event must be on top of the list. If you "solve" CPU Time, would you want to "solve" latch free next?

Report message to a moderator

Previous Topic: where is UGA stored ??
Next Topic: Function taking very long to execute
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 02 07:52:27 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.