Re: EM, capacity planning and monitoring
Date: Tue, 14 Sep 2010 07:47:32 +0200
Message-ID: <AANLkTi=q=Au7Zwqnt+-heFHhoPHYuK2aJt2O7FCvdV3u_at_mail.gmail.com>
Quite sure.... recyclebin was about 25gb, with thousands object. Statement
purge recyclebin
has taken about 8 hours to complete...
Maybe was so big that database got problems in deleting objects... there're
no other reason for me....
ste
On 13 September 2010 22:55, D'Hooge Freek <Freek.DHooge_at_uptime.be> wrote:
> 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_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
> --
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> 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
>
-- http://www.stefanocislaghi.eu -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 14 2010 - 00:47:32 CDT