OraFAQ Forum: General » Clean Database

Home » Other » General » Clean Database (Oracle 11g - Sun Solaris 64 Bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Clean Database [message #591559]

Mon, 29 July 2013 14:17

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;

Report message to a moderator

Re: Clean Database [message #591561 is a reply to message #591559]

Mon, 29 July 2013 14:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I used the commands below
OK, what can we do for you now?

Report message to a moderator

Re: Clean Database [message #591562 is a reply to message #591559]

Mon, 29 July 2013 14:23

John Watson
Messages: 8960
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.

Report message to a moderator

Re: Clean Database [message #591566 is a reply to message #591561]

Mon, 29 July 2013 14:40

akinur
Messages: 12
Registered: July 2013
Location: Canada

Junior Member

any thing else?

Report message to a moderator

Re: Clean Database [message #591569 is a reply to message #591566]

Mon, 29 July 2013 14:43

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Anything else for what?

Regards
Michel

Report message to a moderator

Re: Clean Database [message #591571 is a reply to message #591569]

Mon, 29 July 2013 14:48

akinur
Messages: 12
Registered: July 2013
Location: Canada

Junior Member

Anything else for clean the database?

Report message to a moderator

Re: Clean Database [message #591574 is a reply to message #591571]

Mon, 29 July 2013 14:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

Previous Topic:	Oracle V12.1 released
Next Topic:	Oracle Temp Tablespace is too BIG

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 16:24:22 CST 2024