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

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
LVL 8
LindaCAsked:
Who is Participating?
 
sventhanCommented:
You can find it using dba_stat*** tables.
0
 
sventhanCommented:
Its dba_tab_statistics view. There are few other STAT views you could query as well.
0
 
LindaCAuthor Commented:
It doesn't tell me.  Only it has rows but I can't know if both methods where executed.
0
 
LindaCAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.