Home » RDBMS Server » Performance Tuning » Database Reorganisation (Oracle 10g, IBM AIX 5.3)
Database Reorganisation [message #527076] Sat, 15 October 2011 00:32 Go to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member

Hi all,


Greetings!. could you guys send me the details steps or any Url which illustrate more to perfome Database reorganization. does it meaning rebuilding/recreate indexs & shrinking database objects etc ..



Best Regards
------------

Report message to a moderator

Re: Database Reorganisation [message #527092 is a reply to message #527076] Sat, 15 October 2011 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You do NOT perform database reorganisation (unless you have a very good and objective reason to do it).

Regards
Michel

[Updated on: Sat, 15 October 2011 02:01]

Report message to a moderator

Re: Database Reorganisation [message #571756 is a reply to message #527092] Fri, 30 November 2012 01:09 Go to previous message
atcharao
Messages: 1
Registered: November 2012
Location: hyderabad
Junior Member
The following methods are used to reorganise the tables/tablespaces/users
1. by using export/import datapumps
2. query like alter table tname rebuild online
3. alter procedure proc_name compile
4. by running utlrp compile invalid objects
5. by using shrink command -->alter table tname enable rowmovement;
and alter table tname shrink space keep

Please correct the my answer if nay mistake.

Report message to a moderator

Previous Topic: Top 5 long running using DBA_* hist views
Next Topic: Bloom filters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 31 22:51:46 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.