Retail Predictive Application Server (MOSC)

MOSC Banner

Reindex Domain - Suggested Defragmentation

edited Apr 21, 2013 9:03PM in Retail Predictive Application Server (MOSC) 2 commentsAnswered
Hi,While running reindex domain utility, the analyze option generated the report given below.

Dim Name   :  prcp

DimRegistry  BitSize:  8

DimInfo      BitSize:  8

Capacity         (C):  256

MaxPhyId         (M):  249

MaxLogId         (L):  167

Threshold        (T):  25 

Action Required   :  No need to increase the BitSize. Defrag the dimension to free up unused space. 


Now, it is suggesting defragmentation, I tried defragmentation using Optimize Domain -d domain path, without any options.

But still no luck, it is not freeing up the space. 


Also, as per above, C - M < T, shouldn't the suggestion be to increase bit size??  


Could you please suggest, how to proceed with defragmentation and if bit size increase is needed?

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