• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

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
0
LindaC
Asked:
LindaC
  • 2
  • 2
2 Solutions
 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now