Home » SQL & PL/SQL » SQL & PL/SQL » how to use DBMS STATS (oracle 9.2.0 solaris 8)
how to use DBMS STATS [message #351743] Thu, 02 October 2008 15:32 Go to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
I'm trying to use DBMS STATS command to get statistics about a table and index .
I know I can launch this command below :

dbms_stats.gather_table_stats
(ownname => user,
tabname => 'MYTAB' ,
estimate_percent => 100,
method_opt => 'for all indexed columns size auto');



But after that How to get the statistics ?
Is someone can explain me how to implement DBMS STATS ?

thanks

koff
Re: how to use DBMS STATS [message #351745 is a reply to message #351743] Thu, 02 October 2008 15:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
your statement will collect stats only for indexed columns and indexes are excluded.

add
cascade=>true


>>But after that How to get the statistics ?
You mean, view the statistics?
http://cs.ifmo.ru/~ad/Documentation/oracle-10g-lib-doc/server.101/b10752/stats.htm#41106

[Updated on: Thu, 02 October 2008 15:36]

Report message to a moderator

Re: how to use DBMS STATS [message #351746 is a reply to message #351745] Thu, 02 October 2008 15:48 Go to previous messageGo to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
Mahesh Rajendran wrote on Thu, 02 October 2008 22:35
your statement will collect stats only for indexed columns and indexes are excluded.

add
cascade=>true


>>But after that How to get the statistics ?
You mean, view the statistics?
http://cs.ifmo.ru/~ad/Documentation/oracle-10g-lib-doc/server.101/b10752/stats.htm#41106


Thanks,

Yes, I mean to view statistics
you mean "cascade=>true" will collect indexes too ?
Re: how to use DBMS STATS [message #351759 is a reply to message #351746] Thu, 02 October 2008 19:55 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yes. Give it a try.
Previous Topic: Problem when using Collection
Next Topic: How to declare a cursor with dynamic query
Goto Forum:
  


Current Time: Thu Dec 08 08:36:51 CST 2016

Total time taken to generate the page: 0.17416 seconds