OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » DBMS Package (Oracle 10G)

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

DBMS Package [message #332957]

Thu, 10 July 2008 03:33

saagar
Messages: 79
Registered: December 2007

Member

dear all
i want to know what are the packages are there in dbms

eg

execu dbms_stats.gather_database_stats(
options=> 'GATHER AUTO');

then after that i have see DBA_TABLES , DBA_INDEXES all that
to see the changes
hgope i am right

i want to know what more packages are there in oracle with example ...
can some one help me with the link of exact documentation on gather stats...

Cheers

Report message to a moderator