Data Statistics [message #317780] |
Sat, 03 May 2008 07:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balaji1482
Messages: 312 Registered: July 2007 Location: INDIA
|
Senior Member |
![YES](/forum/theme/orafaq/images/yahoo.png)
|
|
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|
|