Home » RDBMS Server » Performance Tuning » Reclaiming free space questions (Oracle g10)
icon5.gif  Reclaiming free space questions [message #303890] Mon, 03 March 2008 02:43 Go to next message
kian.tern
Messages: 3
Registered: March 2008
Junior Member
Hi all.

I'm fairly new to oracle and database administration.
Currently I have a huge database (1TB+).
There is a weekly cleanup running. But the space is not reclaimed.
I found this article
http://www.oracle.com/technology/pub/articles/10gdba/week15_10gdba.html

It seems that the space reclaim should not a problem.
But still I have some questions.

1. The database has a bad design and most of the data is located in 2-3 tables. Can this cause in a failure to reclaim free space?
2. Can this process "kill" the database if failed?
3. Can I run this on entire tablespace or do I have to run it on each table separately?

Thanks in advance.
Re: Reclaiming free space questions [message #303893 is a reply to message #303890] Mon, 03 March 2008 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without you posting what you did how can we what is wrong?

Regards
Michel
Re: Reclaiming free space questions [message #303894 is a reply to message #303893] Mon, 03 March 2008 03:01 Go to previous messageGo to next message
kian.tern
Messages: 3
Registered: March 2008
Junior Member
You must have misunderstood me.
I have not done anything yet. There is nothing wrong currently
with database expect I need to reclaim the free space.
I just asked some theoretical questions.
Re: Reclaiming free space questions [message #303898 is a reply to message #303894] Mon, 03 March 2008 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oh! OK.

1. No and you dont have to matter if you use LMT.
2. If you mean reclaiming can "kill" database, yes it can cause lost of service
3. It depends on what you want to do.

Search here on "reclaiming space" there are severak topics on it.

Regards
Michel
Re: Reclaiming free space questions [message #303899 is a reply to message #303898] Mon, 03 March 2008 03:15 Go to previous messageGo to next message
kian.tern
Messages: 3
Registered: March 2008
Junior Member
By "killing" the database I mean, corruption of the dbf files.
Re: Reclaiming free space questions [message #303903 is a reply to message #303899] Mon, 03 March 2008 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Corruptions (normally) can't happen but lost of service, yes.

Regards
Michel
Re: Reclaiming free space questions [message #304733 is a reply to message #303903] Thu, 06 March 2008 07:22 Go to previous message
hd999
Messages: 2
Registered: March 2008
Location: Austria
Junior Member
Hi,

if you use the "shrink space": don't do it on tables/partitions with LOBs. If there is some action concerning lobs while you do the shrink, it might corrupt your LOB-data. At least, in 10.2.0.3 we saw that happening.

Also, if about all of the data is in a view tables, you will face problems with UNDO (very likely. which, after all, is no corruption).

regards,
Heimo
Previous Topic: Tuning Suggestion
Next Topic: Impact of NLS Sort
Goto Forum:
  


Current Time: Fri Dec 02 16:20:04 CST 2016

Total time taken to generate the page: 0.32469 seconds