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
------------
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: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.
Previous Topic: Top 5 long running using DBA_* hist views
Next Topic: Bloom filters
Goto Forum:
  


Current Time: Thu Mar 28 17:18:33 CDT 2024