PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How to know that the statistics of a table where gathered with this two method?

edited Jul 1, 2013 11:47AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered
How to know that the statistics of a table where gathered with this two method?
DBMS_STATS.GATHER_TABLE_STATS(
        ownname => <table owner>
        ,tabname =><table_name>
        ,estimate_percent => NULL
        ,block_sample => FALSE
        ,degree => DBMS_STATS.AUTO_DEGREE
        ,cascade => TRUE

And:

DBMS_STATS.GATHER_TABLE_STATS(
        ownname =><table owner>
        ,tabname => <table_name>
        ,estimate_percent => NULL
        ,block_sample => FALSE
        ,method_opt => ''FOR ALL INDEXED COLUMNS''
        ,degree => DBMS_STATS.AUTO_DEGREE
        ,cascade => FALSE

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