Re: Open cursors growing out of control

Gordon wrote:

> Hi,
>
> I have recently upgraded the Oracle Server to 10g, and now Oracle has some
> 400ish open cursors owned by SYSMAN and DBSNMP.
> My guess is that they are created by the OEM. I never used OEM in Oracle 9i
> so this problem did not occur before.
>
> Is there a way to shut down the OEM, or force OEM to close these cursors?
>
> Thanks
>
> Gordon

Rather than guess ... check. Make sure they are created by OEM first.

Then ... what operating system?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)