Re: disable recyclebin?
- From: Nuno Souto <dbvision@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 20 Apr 2011 18:57:28 +1000
And that's one of the reasons why recycle bin is disabled in all my dbs.
--
Cheers
Nuno Souto
in overcast Sydney, Australia
dbvision@xxxxxxxxxxxx
Chitale, Hemant Krishnarao wrote,on my timestamp of 20/04/2011 1:27 PM:
When the database is under severe pressure to drop and create segments, the
presence of recyclebin may sometimes cause ORA-1652's because the
'auto-clearance' of the recyclebin isn't fast enough.
I've seen that twice.
See Oracle Support Article "***Bug 6977045 - ORA-1652 even though there is
sufficient space in RECYCLE BIN [ID 6977045.8]*"
and read the text for Bug 6977045-- there's a short explanation of a design
decision on "extend or wait"
Hemant K Chitale
***From:*oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]***On Behalf Of*TESTAJ3@xxxxxxxxxxxxxx
***Sent:*Tuesday, April 19, 2011 9:55 PM
***To:*Oracle-L@xxxxxxxxxxxxx
***Subject:*disable recyclebin?
I'm getting push to disable the recyclebin on a 10.2.0.4 database?
I'm pushing back that its not a good idea to disable it for the entire database
but to disable for the session or do a drop table <table_name> purge instead.
Your thoughts?
thanks, joe
--
//www.freelists.org/webpage/oracle-l
Other related posts:
