Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Degragment table in 10gR2

Rahul RamanDec 12 2016 — edited Dec 13 2016

Hi All,

Can someone please suggest suitable approach to handle this fragmentation.

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi

PL/SQL Release 10.2.0.3.0 - Production

CORE 10.2.0.3.0 Production

TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Productio

NLSRTL Version 10.2.0.3.0 - Production

TABLE NAME	Segment Size in GB	*NUM_ROWSAVG_ROW_LEN**
PSIBLOGIBINFO	572.809	2.017

Name Null? Type

----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------

GUID NOT NULL VARCHAR2(36)

LOGTYPE NOT NULL VARCHAR2(1)

PUBDATALONG LONG RAW

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 10 2017

Added on Dec 12 2016

#general-database-discussions

22 comments

959 views