Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


Table defragmentation


Hello Everyone,  I have few question about table defragmentation. We are planning to do de fragmentation of the table,   1.	Do we have t take tablespace off line for that?  2.	Are the tables available for select during defragmentation? 3.	Are the tables available for inserts during defragmentation period?  4.	How is this going to help database?

 I have few question about table defragmentation. We are planning to do de fragmentation of the table,    You have decided to do something called "table defragmentation". Now why ask then? First explain fragmentation and defragmentation.

4.	How is this going to help database?  It's probably not going to help and most likely will be a wasted effort. Why do you want to defragment your table? What do you hope to gain? Note....I never defragment my tables or indexes as I do not see any benefit from that effort.   HTH, Brian

if u r using  oracle version10g and above you can use the move table command.

DK2010 wrote: if u r using  oracle version10g and above you can use the move table command. How to decide which table(s) to move?  Is the result like rearranging the deck chairs on the  Titanic?

It could hurt in a couple of circumstances:  If you do an import/export, a table that is dense may get less dense whilst honoring pctfree or large initial values.  This could slow down full table scans, if you have such things.  If there is some implicit data distribution that helps your performance, this could go away.  It may help to tell us what version/patch level you are on, where you got the idea you should defragment, and what exactly you were told.  Do you have a performance issue?


Related Links

oracle database 11g daily changes
ORA-12518: TNS:listener could not hand off client connection
sql is running very slow
Oracle database product feature matrix
Unable to extend
Change default spool extension
ORA-00904: "OCT": invalid identifier
FAILED - ORA-01031: insufficient privileges
ORA-19815: WARNING: db_recovery_file_dest_size of 4070572032 bytes is 100.0
Can we use PRAGMA RESTRICT_REFERENCES in either procedure or Function.
TEMP tablespace
Searching Criteria to find out the friends of friend
Local Partitioned indexes (adding additional partitions)
database freezed for row cache lock
Simple archive issue
V$SQL.CHILD_NUMBER