OraFAQ Forum: Performance Tuning » dbms

Home » RDBMS Server » Performance Tuning » dbms_stats (10.2.0.1 Solaris)

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

dbms_stats [message #348748]

Wed, 17 September 2008 18:42

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Experts,

sys.dbms_stats.gather_schema_stats(ownname => NULL)
When do we use ownname =>Null.
 I  want to gather statistics of newely
created schema.Is ownname => NULL is good option to
gather statistics after login as that schema user.

Regards,
Varun Punj

Report message to a moderator

Re: dbms_stats [message #348812 is a reply to message #348748]

Thu, 18 September 2008 00:19

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>When do we use ownname =>Null.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_stats.htm#sthref6735

Quoting docs

ownname Schema to analyze (NULL means current schema)

Report message to a moderator

Re: dbms_stats [message #348985 is a reply to message #348812]

Thu, 18 September 2008 08:38

varunvir
Messages: 389
Registered: November 2007

Senior Member

Thank you Mahesh fot clearing my doubt.
Regards,
Varun Punj,

Report message to a moderator

Previous Topic:	query performance related
Next Topic:	How the Query works

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 09:27:32 CST 2024