Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CPU 100% when using the grid control

Re: CPU 100% when using the grid control

From: newhorizon <mehmeteser_at_gmail.com>
Date: Tue, 10 Jul 2007 07:51:26 -0000
Message-ID: <1184053886.749914.204680@57g2000hsv.googlegroups.com> 





I guess I found something.



Grid Control runs the following query for every 3 or 4 seconds.



It executed 278 times in 70 min,  took total 5 CPU seconds.



"SELECT s.sid, s.sql_address, s.sql_hash_value, sw.event, sw.p1,
DECODE(sw.wait_time, 0, 'W', 'C'), s.serial#, s.user#, s.program FROM v
$session s, v$session_wait sw WHERE s.sid = sw.sid;"
Received on Tue Jul 10 2007 - 02:51:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US