OraFAQ Forum: Server Administration » How to write DBMS

Home » RDBMS Server » Server Administration » How to write DBMS_STATS package?

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

How to write DBMS_STATS package? [message #168943]

Mon, 24 April 2006 05:19

anandhi
Messages: 31
Registered: April 2006
Location: Chennai

Member

Hi

I want to write a DBMS_STATS package

Table name:SNI_BMA_DRY_FCT
Schema name: SNI_WHSE

Can u help me how to write the dbms_stats package?

Thanks
Anandhi

Report message to a moderator

Re: How to write DBMS_STATS package? [message #168949 is a reply to message #168943]

Mon, 24 April 2006 05:52

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

I thinks you want to collect statistics.

SQL>exec dbms_stats.gather_table_stats('SNI_WHSE','SNI_BMA_DRY_FCT');

SALIH KM

Report message to a moderator

Re: How to write DBMS_STATS package? [message #168961 is a reply to message #168949]

Mon, 24 April 2006 06:55

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Or if you searched,

http://www.lc.leidenuniv.nl/awcourse/oracle/appdev.920/a96612/d_stats.htm

http://www.dba-oracle.com/art_builder_dbms_stats.htm

Report message to a moderator

Previous Topic:	How to reduce size of Temporary TableSpace
Next Topic:	Ora-12913

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:42:58 CDT 2024