Data dictionary for DBMS_STATS.GATHER_TABLE_STATS

Welcome Guest ( Log In | Register )

Data dictionary for DBMS_STATS.GATHER_TABLE_STATS

traveller View Member Profile	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.

kamal View Member Profile	Aug 21 2007, 08:36 PM Post #2
Member Group: Members Posts: 12 Joined: 10-July 07 Member No.: 10,023	from dba_tables

Steve View Member Profile	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

traveller View Member Profile	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

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)

0 Members:

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Time is now: 24th May 2013 - 01:09 AM