RE: EM, capacity planning and monitoring

  • From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
  • To: "s.cislaghi@xxxxxxxxx" <s.cislaghi@xxxxxxxxx>, Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 13 Sep 2010 22:55:52 +0200

Stefano,

Not an answer to your question, but the recycle bin is supposed to be cleaned 
automatically when Oracle needs space in that tablespace. I even think that 
Oracle will first clean out the recycle bin and only after that increase the 
datafile (if autoextend has been enabled).
In that sense it is normal that no special attention is set to the recycle bin.

Are you sure that the errors you got where caused by the recycle bin?


Regards,


Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
--
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Stefano Cislaghi
Sent: maandag 13 september 2010 21:38
To: Oracle L
Subject: EM, capacity planning and monitoring

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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2010