Home » RDBMS Server » Performance Tuning » dbms_stats (10.2.0.1 Solaris)
dbms_stats [message #348748] Wed, 17 September 2008 18:42 Go to next message
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
Re: dbms_stats [message #348812 is a reply to message #348748] Thu, 18 September 2008 00:19 Go to previous messageGo to next message
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)
Re: dbms_stats [message #348985 is a reply to message #348812] Thu, 18 September 2008 08:38 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thank you Mahesh fot clearing my doubt.
Regards,
Varun Punj,
Previous Topic: query performance related
Next Topic: How the Query works
Goto Forum:
  


Current Time: Thu Dec 05 13:40:18 CST 2024