Home » RDBMS Server » Performance Tuning » Data Statistics (oracle 10g)
Data Statistics [message #317780] Sat, 03 May 2008 07:41 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member



hi all,

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS( OWNNAME => ,METHOD_OPT=> 'FOR ALL INDEXED COLUMNS SIZE 1', GRANULARITY=> 'DEFAULT', DEGREE =>, CASCADE => TRUE);

DBMS_UTILITY.compile_schema('schema')


The above 2 packages is used to collect statistics for a partitcular schema.what is the main differences in these 2 packages ?

Re: Data Statistics [message #317786 is a reply to message #317780] Sat, 03 May 2008 09:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
One gather statistics, the other one compile procedures.
Just read the few first lines of procedure descriptions in documentation.

Regards
Michel

[Edit missing "read" word]

[Updated on: Mon, 05 May 2008 06:59]

Report message to a moderator

Re: Data Statistics [message #318028 is a reply to message #317786] Mon, 05 May 2008 06:41 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks michel
Previous Topic: Where can I download this Book?
Next Topic: Query Executing Every Second
Goto Forum:
  


Current Time: Sun Dec 04 16:37:29 CST 2016

Total time taken to generate the page: 0.18704 seconds