Huge MMON traces

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Fri, 14 Nov 2008 11:07:00 -0500
Message-ID: <0B43A9298955E14183B7AFAD4A11FC21057A37A2@USHQEXVS.polanet.polaroid.com>


Greetings,

This is a HP-UX 11.23 machine with 30 or so 10g & 9i databases on it.

The problem was one volume's space maxing out. Found 4 10.2.0.3 db's with 2Gb+ MMON trace files with date stamps over 1 month old. Deleted these files and cleaned house on several others db's. Checking disk space shows the MMON trace file space was not released. I will look into note 422954.1 to try to avoid a recurrence, but in the mean time I would rather not have to shutdown a dozen db's to find the 4 that had the MMON problem.

Is there any method for finding which databases have these deleted trace files still open? Is there a way to close out a MMON trace without shutting down the db?

Thanks,
Mike Hand

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 14 2008 - 10:07:00 CST

Original text of this message