Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Poor Performance on Oracle9i - 9.2.0.7
Hello,
Will you please execute the following command
SELECT EVENT, TOTAL_WAITS, TIME_WAITED from V$SYSTEM_EVENT
order by TIME_WAITED
/
and during facing the problem execute :-
select event, count(*) from v$session_wait group by event
/
Thanks !
Received on Tue May 09 2006 - 08:18:20 CDT