execute dbms_stats.gather_schema_stats (ownname => 'SCHEMA_NAME', degree => 6, cascade => true);

-----Original Message-----
From: Purusottam Kaushik [mailto:oracledba-ezmlmshield-x40000452.[Email address protected]
Sent: Wednesday, May 30, 2007 10:45 AM
To: LazyDBA Discussion
Subject: collecting statistics

Hi all Oracle GURUS,



Can any body please tell me the method of collecting statistics for a
complete schema for a given user.

I am new to this field.



Any help will be highly appreciated..



Thanks

Purusottam Kaushik





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page