OraFAQ Forum: Performance Tuning » How to Generate Statistics of a table and how to see in oracle 10g

Home » RDBMS Server » Performance Tuning » How to Generate Statistics of a table and how to see in oracle 10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Generate Statistics of a table and how to see in oracle 10g [message #255952]

Thu, 02 August 2007 09:25

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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

Report message to a moderator

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

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 22:38:54 CST 2024