Database Tuning (MOSC)

MOSC Banner

dbms_stats.set_index_stats usage issues

edited Aug 7, 2011 7:43PM in Database Tuning (MOSC) 2 commentsAnswered
 Hi ,

I am trying to update the index statistics for a table in my dummy database using the dbms_stats.set_index_stats. The environment is as below :

1. Production data base is on Sun Solaris Oracle 10gR2

2. My Dummy Databases is on a Dell Laptop Windows 7 SP1 using Oracle 11gR2

3. I am trying to issue the below command to set the index stats for a table :

DBMS_STATS.SET_INDEX_STATS ( ownname =>'DAMSMGR',
                             indname =>'DAMS_TP_GFA_INVO_REASON_AK1',
                             partname =>null,
                             stattab => null,
                             statid=>null,
                             numrows =>0,
                             numblks =>0,
                             numdist =>0,
                             clstfct =>0,
                             avglblk =>0,
                             avgdblk =>0,
                             indlevel =>0,
                             no_invalidate => true,
                             guessq => NULL ,
                             cachedblk =>NULL,

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