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>
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-lReceived on Fri Nov 14 2008 - 10:07:00 CST