EM, capacity planning and monitoring

  • From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 13 Sep 2010 21:38:20 +0200

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

Other related posts: