Home » Other » General » Clean Database (Oracle 11g - Sun Solaris 64 Bit)
Clean Database [message #591559] Mon, 29 July 2013 14:17 Go to next message
akinur
Messages: 12
Registered: July 2013
Location: Canada
Junior Member
How to clean the Oracle Database? I used the commands bellow

SHOW RECYCLEBIN

SELECT * FROM RECYCLEBIN;
SELECT * FROM USER_RECYCLEBIN;
SELECT * FROM DBA_RECYCLEBIN;

PURGE RECYCLEBIN;
PURGE DBA_RECYCLEBIN;
Re: Clean Database [message #591561 is a reply to message #591559] Mon, 29 July 2013 14:21 Go to previous messageGo to next message
BlackSwan
Messages: 22521
Registered: January 2009
Senior Member
>I used the commands below
OK, what can we do for you now?
Re: Clean Database [message #591562 is a reply to message #591559] Mon, 29 July 2013 14:23 Go to previous messageGo to next message
John Watson
Messages: 4400
Registered: January 2010
Location: Global Village
Senior Member
Well, OK. But why did you bother to do it? Dropped objects don't cause any harm. If you really don't want to keep them until their space is needed, ALTER SYSTEM SET RECYCLEBIN = 'OFF' SCOPE=SPFILE and bounce the instance.
Re: Clean Database [message #591566 is a reply to message #591561] Mon, 29 July 2013 14:40 Go to previous messageGo to next message
akinur
Messages: 12
Registered: July 2013
Location: Canada
Junior Member
any thing else?
Re: Clean Database [message #591569 is a reply to message #591566] Mon, 29 July 2013 14:43 Go to previous messageGo to next message
Michel Cadot
Messages: 58610
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Anything else for what?

Regards
Michel
Re: Clean Database [message #591571 is a reply to message #591569] Mon, 29 July 2013 14:48 Go to previous messageGo to next message
akinur
Messages: 12
Registered: July 2013
Location: Canada
Junior Member
Anything else for clean the database?
Re: Clean Database [message #591574 is a reply to message #591571] Mon, 29 July 2013 14:55 Go to previous message
BlackSwan
Messages: 22521
Registered: January 2009
Senior Member
>Anything else for clean the database?

which metric measures "clean"

post SQL & results that shows the difference between clean & not clean database.

What problem are you trying to solve?
How will you know when this problem has actually been solved?
Previous Topic: Oracle V12.1 released
Next Topic: Oracle Temp Tablespace is too BIG
Goto Forum:
  


Current Time: Tue Jul 29 10:46:22 CDT 2014

Total time taken to generate the page: 0.08819 seconds