Database Reference
In-Depth Information
Table 8-3.
(
continued
)
Parameter
Database
Dictionary
Fixed Objects
Schema
Table
Index
Backup Table
stattab
•
•
•
•
•
•
statid
•
•
•
•
•
•
statown
•
•
•
•
•
•
*Available as of version 12.1.
Target Objects
Target object parameters specify which objects you gather object statistics for:
ownname
specifies the name of the schema to be processed. This parameter is mandatory.
•
indname
specifies the name of the index to be processed. This parameter is mandatory.
•
tabname
specifies the name of the table to be processed. This parameter is mandatory.
•
partname
specifies the name of the partition or subpartition to be processed. If no value is
specified, object statistics for all partitions and subpartitions might be gathered, depending on
the value of the
granularity
parameter (see below). The default value is
NULL
.
•
comp_id
specifies the ID of the component to be processed. Because the ID of a component
can't be used for gathering statistics, it's transformed internally into a list of schema. To know
which schemas are processed for a given component, you can use the following query.
1
Note that the output of the query depends on several factors, such as the version and the
actual components that are installed. Independently of this parameter,
sys
and
system
schemas are always processed. If an invalid value is specified, no error message is returned,
and the
sys
and
system
schemas are processed regularly. With the default value
NULL
, all
components are processed:
•
SQL> SELECT u.username AS schema_name, r.cid AS comp_id, r.cname AS comp_name
2 FROM dba_users u,
3 (SELECT schema#, cid, cname
4 FROM sys.registry$
5 WHERE status IN (1, 3, 5)
6 AND namespace = 'SERVER'
7 UNION ALL
8 SELECT s.schema#, s.cid, cname
9 FROM sys.registry$ r, sys.registry$schemas s
10 WHERE r.status IN (1,3,5)
11 AND r.namespace = 'SERVER'
12 AND r.cid = s.cid) r
13 WHERE u.user_id = r.schema#
14 ORDER BY r.cid, u.username;