Database Administration (MOSC)

MOSC Banner

We need help on the table reorg?

edited Feb 22, 2010 9:38AM in Database Administration (MOSC) 5 commentsAnswered
if we have  10  mil rows in a table and the size is 4G. We purge the table deleting about 200000 rows from the table every weekend.
Then after 3 months it has about seven mill rows.
After six months it has 4 mill rows.  T
The table size is still 4gb.
Is this due to fragmentation?
When should I do  reorg for this table after two months ,four, when?

by doing purge we mean "delete". after deleting rows from a table how will size go down?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center