computing statistics at the schema level [message #610745] |
Mon, 24 March 2014 01:16 |
|
ashwanth77
Messages: 95 Registered: April 2013 Location: India
|
Member |
|
|
Where are the schema level statistics stored .where can i retrieve the details of schema level statistics?and what is next step after gathering the statistics?
what i tried?
BEGIN
DBMS_STATS.gather_schema_stats ('staging',estimate_percent => 20,method_opt => 'FOR ALL INDEXED COLUMNS SIZE 1',block_sample => FALSE,DEGREE => 32,GRANULARITY => 'ALL',CASCADE => TRUE);
END;
/
what is the next step after this
[Updated on: Mon, 24 March 2014 02:01] Report message to a moderator
|
|
|
|
Re: computing statistics at the schema level [message #610799 is a reply to message #610745] |
Mon, 24 March 2014 07:40 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
There are not 'schema level stats'. GATHER_SCHEMA_STATS is just a convenient way of gather stats for all of the objects in the schema. The end result of GATHER_SCHEMA_STATS is no different than a series of GATHER_TABLE_STATS (and GATHER_INDEX_STATS). Actual stats only exist for a given segment, not a schema.
|
|
|