Home » SQL & PL/SQL » SQL & PL/SQL » computing statistics at the schema level (11g)
computing statistics at the schema level [message #610745] Mon, 24 March 2014 01:16 Go to next message
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 #610751 is a reply to message #610745] Mon, 24 March 2014 02:14 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Statistics are stored in the data dictionary, you can see them in views such as DBA_TABLES, DBA_TAB_COLUMNS, DBA_TAB_HISTOGRAMS.
There is no particular next step.

[Updated on: Mon, 24 March 2014 02:14]

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 Go to previous message
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.
Previous Topic: comparing the result of multiple SELECT statements
Next Topic: generate xls file through pl/sql
Goto Forum:
  


Current Time: Thu Mar 28 05:02:01 CDT 2024