EM, capacity planning and monitoring

From: Stefano Cislaghi <s.cislaghi_at_gmail.com>
Date: Mon, 13 Sep 2010 21:38:20 +0200
Message-ID: <AANLkTi=h7OoMtqBFb-TApRqFYmBAnsEbewuKdpL8UUFG_at_mail.gmail.com>



Hi all,

does anyone know if, and maybe how, it's possibile with EM to monitor datafile space allocation, tablespace free space per minute... I've never used EM for this, instead I've always used and seen to be used few sql scripts and graphical tools as cacti, rrd, or custom ones...

I've also seen that EM in the report 'database usage' shows two lines:
- allocated space of all datafiles

  • space used by all objects No special attention to recycle_bin .... if space is exhausted due to full recyclebin the report still shows available space in db and also EM was not able to discover a tablespace full situation even if active sessions were getting ORA-1652 ...

Thanks
Stefano

-- 
http://www.stefanocislaghi.eu

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 13 2010 - 14:38:20 CDT

Original text of this message