Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Data dictionary for DBMS_STATS.GATHER_TABLE_STATS
traveller
post Aug 21 2007, 06:54 PM
Post #1


Advanced Member
***

Group: Members
Posts: 67
Joined: 4-January 06
Member No.: 3,485



I am seeking help. If I execute DBMS_STATS.GATHER_TABLE_STATS procedure. After that, which table in dictionary should I query for the results? Please give the details. Thanks.
Go to the top of the page
 
+Quote Post
kamal
post Aug 21 2007, 08:36 PM
Post #2


Member
**

Group: Members
Posts: 12
Joined: 10-July 07
Member No.: 10,023



from dba_tables
Go to the top of the page
 
+Quote Post
Steve
post Aug 22 2007, 12:21 AM
Post #3


Advanced Member
***

Group: Members
Posts: 618
Joined: 22-January 06
From: Virginia Beach, VA
Member No.: 3,560



That is, if you need to see the results. The purpose behind statistics is really to assist Oracle's optimizer.

http://www.dba-oracle.com/concepts/tables_..._statistics.htm


--------------------
Steve Karam
Sr. Consultant - Burleson Consulting
Oracle 10g Certified Master / Oracle ACE
http://www.OracleAlchemist.com
steve@orcldba.com
Go to the top of the page
 
+Quote Post
traveller
post Aug 22 2007, 09:37 AM
Post #4


Advanced Member
***

Group: Members
Posts: 67
Joined: 4-January 06
Member No.: 3,485



Steve and kamal:

Thanks for your advice.


QUOTE (Steve @ Aug 22 2007, 05:22 AM) *
That is, if you need to see the results. The purpose behind statistics is really to assist Oracle's optimizer.

http://www.dba-oracle.com/concepts/tables_..._statistics.htm
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 26th November 2014 - 11:04 AM