Database Tuning (MOSC)

MOSC Banner

Segment tuning

edited Mar 8, 2013 4:48AM in Database Tuning (MOSC) 12 commentsAnswered
I have a table need segment tuning, here are two advices from oracle, what's the difference for these solutions? Can I be allowd to run them online? This table has 16 indexes, after these solutions, should I rebuild the indexes? Thanks

SEGMENT_NAME     : PRT_PROCESS

ALLOCATED_SPACE  : 60817408000

RECLAIMABLE_SPACE: 1621829174

RECOMMENDATIONS  : Enable row movement of the table ENERGYDB.PRT_PROCESS and perform shrink, estimated savings is 1621829174 bytes.

SOLUTION 1       : alter table "ENERGYDB"."PRT_PROCESS" shrink space

SOLUTION 2       : alter table "ENERGYDB"."PRT_PROCESS" shrink space COMPACT

SOLUTION 3       : alter table "ENERGYDB"."PRT_PROCESS" enable row movement

TABLESPACE_NAME  : DATA1_1G

SEGMENT_OWNER    : ENERGYDB

SEGMENT_NAME     : PRT_PROCESS

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