On Jul 10, 3:51 am, newhorizon <mehmete..._at_gmail.com> wrote:
> 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;"
I am experiencing similar situations. I have GC 10.2.0.2 on a seperate
machine from the host, so the only thing running on the host (other
than two databases) that the CPU is getting hammered is the management
agent. The host is running AIX5L and one 10.2.0.2 db, and one 9.2.0.5
db. Was there something that you did to control how ofter it executed
that statement?
Received on Tue Jul 10 2007 - 06:59:20 CDT
