Database Reference
In-Depth Information
SCHEMA_NAME COMP_ID COMP_NAME
------------------ ------- ----------------------------------
SYS APS OLAP Analytic Workspace
SYS CATALOG Oracle Database Catalog Views
SYS CATJAVA Oracle Database Java Packages
APPQOSSYS CATPROC Oracle Database Packages and Types
DBSNMP CATPROC Oracle Database Packages and Types
DIP CATPROC Oracle Database Packages and Types
GSMADMIN_INTERNAL CATPROC Oracle Database Packages and Types
ORACLE_OCM CATPROC Oracle Database Packages and Types
OUTLN CATPROC Oracle Database Packages and Types
SYS CATPROC Oracle Database Packages and Types
SYSTEM CATPROC Oracle Database Packages and Types
CTXSYS CONTEXT Oracle Text
SYS JAVAVM JServer JAVA Virtual Machine
LBACSYS OLS Oracle Label Security
MDSYS ORDIM Oracle Multimedia
ORDDATA ORDIM Oracle Multimedia
ORDPLUGINS ORDIM Oracle Multimedia
ORDSYS ORDIM Oracle Multimedia
SI_INFORMTN_SCHEMA ORDIM Oracle Multimedia
WMSYS OWM Oracle Workspace Manager
MDSYS SDO Spatial
ANONYMOUS XDB Oracle XML Database
XDB XDB Oracle XML Database
XS$NULL XDB Oracle XML Database
SYS XML Oracle XDK
SYS XOQ Oracle OLAP API
granularity specifies at which level statistics for partitioned objects are processed. This
parameter accepts the value listed in Table 8-4 . The default value is auto (this default value
can be changed—see the “Configuring the dbms_stats Package” section later in this chapter).
For additional information about managing object statistics for partitioned objects, refer to the
“Working with Partitioned Objects” section later in this chapter.
Table 8-4. Values Accepted by the granularity Parameter
Value
Meaning
all
Table/index, partition, and subpartition statistics are gathered.
auto
Table/index and partition statistics are gathered. Subpartition statistics are
gathered only if the table is subpartitioned by list or range.
global
Only table/index statistics are gathered.
global and partition
Table/index and partition statistics are gathered.
approx_global and partition
Similar to global and partition , but uses derived statistics at the table/index
level. Available in version 10.2.0.5 and from version 11.1.0.7 onward.
partition
Only partition statistics are gathered.
 
Search WWH ::




Custom Search