Home » RDBMS Server » Performance Tuning » How to Generate Statistics of a table and how to see in oracle 10g
How to Generate Statistics of a table and how to see in oracle 10g [message #255952] Thu, 02 August 2007 09:25 Go to next message
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
Member
Pls Tell me

How to Generate Statistics of a table and how to see in oracle 10g.

thanks
Re: How to Generate Statistics of a table and how to see in oracle 10g [message #255964 is a reply to message #255952] Thu, 02 August 2007 10:20 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
execute DBMS_STATS.GATHER_DATABASE_STATS (NULL, FALSE, 'FOR ALL COLUMNS SIZE 1', NULL, 'DEFAULT', TRUE, NULL, NULL, 'GATHER STALE', 'LIST' );

SQL> DESC DBA_TABLES
Re: How to Generate Statistics of a table and how to see in oracle 10g [message #255966 is a reply to message #255964] Thu, 02 August 2007 10:22 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Documentation

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_stats.htm#i1036461
Previous Topic: performance problem when use parallel and hash join on large tables
Next Topic: CAN WE USE HINT IN VIEW QUERY STATEMENT
Goto Forum:
  


Current Time: Wed Dec 07 12:41:07 CST 2016

Total time taken to generate the page: 0.11075 seconds