Database Administration (MOSC)

MOSC Banner

Huge table level Fragmentation caused in one table

edited Sep 4, 2013 4:36AM in Database Administration (MOSC) 7 commentsAnswered

Hi All,

we have an oracle 11.1.0.7.0 database.

In one of the tables, there is only INSERT happening on weekdays (load) and weekend purge (DELETE). But the fragmentation due to the DML is very huge compared to other tables in the same DB.

Below are the table creation parameters for the table:


PCTUSED    0
PCTFREE    10
INITRANS   11
MAXTRANS   255
STORAGE    (
            INITIAL          152M
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )

    
We had done a defragmentation before 4 months. The table has grown upto 75GB compared to actual size of 3.5 GB.

Note: The table has only NUMBER, VARCHAR, TIMESTAMP columns. Any information will be really helpful.

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