215187.1 SQLT XECUTE 11.4.5.10  Report: sqlt_s29544_main.html

Global

Cursor Sharing and Binds

SQL Tuning Advisor

    

Plans

Plan Control

SQL Execution

    

Tables

Objects

This report may include some content provided by the Oracle Diagnostic and/or the Oracle Tuning Packs (in particular SQL Tuning Advisor "STA", SQL Tuning Sets "STS", SQL Monitoring and/or Automatic Workload Repository "AWR"). Be aware that using this extended functionality requires a license for the corresponding pack. If you need to disable SQLT access to one of these packages, please execute one of the following commands: SQL> EXEC sqltxadmin.sqlt$a.disable_tuning_pack_access; or SQL> EXEC sqltxadmin.sqlt$a.disable_diagnostic_pack_access;

sqlt_start: 2013-07-29/18:17:24

Observations

List of concerns identified by the health-check module. Please review. Some may require further attention.
# Type Name Observation Details
1 SYSTEM PARAMETER MODIFIED There are 2 system level initialization parameters with a modified value in AWR. [+]
2 CBO PARAMETER NON-DEFAULT There is one CBO initialization parameter with a non-default value. [+]
3 CBO PARAMETER MODIFIED There is one CBO initialization parameter with a modified value. [+]
4 DBMS_STATS DBA_AUTOTASK_CLIENT Automatic gathering of CBO statistics is enabled. [+]
5 PLAN PLAN_HASH_VALUE 2 plans were found for this SQL. [+]
6 PLAN CONTROL PLAN_CONTROL None of the plans found was created using one of these: Stored Outline, SQL Profile, SQL Patch or SQL Plan Baseline.  
7 PLAN PLAN_HASH_VALUE Plan 3915546322 may have implicit data_type conversion functions in Filter Predicates. [+]
8 DBMS_STATS SYSTEM STATISTICS Workload CBO System Statistics are not gathered. CBO is using default values. [+]
9 DBMS_STATS SYSTEM STATISTICS Multi-block read time of 266 milliseconds differs for more than 10% from actual db file scattered read wait time of 3.318 milliseconds. [+]
10 STATEMENT RESPONSE TIME Execution of this statement took +00 00:00:01.463328. This is wall clock time. [+]
11 INDEX INVISIBLE There are 1 invisible index(es) in tables being accessed by your SQL. [+]
12 TABLE DMS.ACMTT_ACL_MEMBERS Table rebuild candidate. [+]
13 TABLE SUBPARTITION DMS.DOC_ATTR Table contains 22 subpartitions with fluctuating number of rows. [+]
14 TABLE DMS.DOC_ATTR Table contains 1 column(s) referenced in predicates with no popular values on a "HEIGHT BALANCED" histogram. [+]
15 TABLE DMS.DOC_RELATIONS Table has more empty blocks (187176) than actual blocks (169732) according to CBO statistics. [+]
16 TABLE SUBPARTITION DMS.DOC_RELATIONS Table contains 22 subpartitions with fluctuating number of rows. [+]
17 TABLE DMS.DOC_TEMPLATES Table rebuild candidate. [+]
18 TABLE DMS.GROUP_MEMBERS Table rebuild candidate. [+]
19 TABLE DMS.GROUP_MEMBERS Table contains 1 column(s) referenced in predicates with no popular values on a "HEIGHT BALANCED" histogram. [+]
20 INDEX DOC_RELATIONS.I_DRELS__CH_DI_ID_II Invisible index. [+]
21 TABLE PARTITION DMS.DOC_ATTR 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
22 TABLE PARTITION DMS.DOC_RELATIONS 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
23 INDEX PARTITION DOC_ATTR.PI_DATTR__DM_3V_DI 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
24 INDEX PARTITION DOC_ATTR.PI_DATTR__FCV_TI_DI 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
25 INDEX PARTITION DOC_ATTR.PI_DATTR__PI_DM_3V_DI 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
26 INDEX PARTITION DOC_ATTR.PI_DATTR__TA_3V_DI 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
27 INDEX PARTITION DOC_ATTR.PI_DATTR__TI_PI_DM_TA_3V 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
28 INDEX PARTITION DOC_RELATIONS.PI_DRELS__CH_CA_DI_2F_AR_AI_OI 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
29 INDEX PARTITION DOC_RELATIONS.PI_DRELS__DI_RI_FD_2RT 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
30 INDEX PARTITION DOC_RELATIONS.PI_DRELS__FD_RI 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
# Type Name Observation Details
31 INDEX PARTITION DOC_RELATIONS.PI_DRELS__RI_2RT_FD 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
32 INDEX PARTITION DOC_RELATIONS.PI_DRELS__RT_RT 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
33 TABLE COLUMN ACMTT_ACL_MEMBERS.ACCESS_MASK Column is referenced in predicate(s) and it is not included in any index. [+]
34 TABLE COLUMN ACMTT_ACL_MEMBERS.ACCESS_MASK Column is candidate for NOT NULL constraint. [+]
35 TABLE COLUMN ACMTT_ACL_MEMBERS.ACL_ID Column is candidate for NOT NULL constraint. [+]
36 TABLE COLUMN ACMTT_ACL_MEMBERS.OBJECT_TYPE Column is candidate for NOT NULL constraint. [+]
37 TABLE COLUMN DOC_ATTR.INSTANCE_ID Column is referenced in predicate(s) and it is not included in any index. [+]
38 TABLE COLUMN DOC_ATTR.PARENT_ID Column is candidate for NOT NULL constraint. [+]
39 TABLE COLUMN DOC_ATTR.TA_ID Height-balanced histogram with no popular values. [+]
40 TABLE COLUMN DOC_ATTR.TA_ID Column is candidate for NOT NULL constraint. [+]
41 TABLE COLUMN DOC_ATTR.TEMPLATE_ID Column is candidate for NOT NULL constraint. [+]
42 TABLE COLUMN DOC_MEMBERS.ACCESS_MASK Column is referenced in predicate(s) and it is not included in any index. [+]
43 TABLE COLUMN DOC_RELATIONS.DOC_ID Column is candidate for NOT NULL constraint. [+]
44 TABLE COLUMN DOC_RELATIONS.RELATED_ID Column is candidate for NOT NULL constraint. [+]
45 TABLE COLUMN DOC_RELATIONS.RELATED_TYPE Column is candidate for NOT NULL constraint. [+]
46 TABLE COLUMN DOC_RELATIONS.REL_TYPE Column is candidate for NOT NULL constraint. [+]
47 TABLE COLUMN DOC_TEMPLATES.TEMPLATE_ID Column is candidate for NOT NULL constraint. [+]
48 TABLE COLUMN GROUP_MEMBERS.USER_ID Height-balanced histogram with no popular values. [+]
Go to Top

SQL Text (0b2vmgwsxx9m3 836675171 1925D5012F05D52AB8EB459AC9CA2647 16518511276753892910)

 SELECT /*+ gather_plan_statistics monitor bind_aware */
       /* sqlt_s29544 */
       R.ID AJDI,(SELECT MIN(SUBSTR(DA.CVALUE,-6)||DA.CVALUE) FROM DMS.DOC_ATTR DA WHERE DOC_ID=R.RELATED_ID AND TA_ID=:B5 ) VAL FROM DMS.DOC_RELATIONS R WHERE R.CHANGED>(SYSDATE-:B4 )
 AND R.DOC_ID=:B3 AND R.RELATED_TYPE<>-1 AND INSTANCE_ID=:B2 AND FLG_DEL IS NULL AND REL_TYPE<>'X' AND R.FLG IN ('P','K','A','E')
 AND EXISTS( SELECT DOC_ID FROM DMS.DOC_TEMPLATES WHERE DOC_ID=R.RELATED_ID AND INSTANCE_ID=R.INSTANCE_ID AND TEMPLATE_ID=:B6 )
 AND EXISTS ( SELECT 1 FROM DMS.DOC_ATTR WHERE DOC_ID=R.RELATED_ID AND INSTANCE_ID=R.INSTANCE_ID AND TEMPLATE_ID=:B6 AND CVALUE='v pr??b??hu' AND PARENT_ID=23224)
 AND NOT EXISTS ( SELECT 1 FROM DOC_ATTR WHERE DOC_ID=R.RELATED_ID AND INSTANCE_ID=R.INSTANCE_ID AND TEMPLATE_ID=:B6 AND CVALUE='storno' AND PARENT_ID=23188)
 AND ( EXISTS ( SELECT 1 FROM DMS.ACL_MEMBERS WHERE ( OBJECT_ID=:B1 OR EXISTS ( SELECT GROUP_ID FROM DMS.GROUP_MEMBERS WHERE USER_ID=:B1 AND GROUP_ID=OBJECT_ID AND INSTANCE_ID=:B2 ))
 AND INSTANCE_ID=:B2 AND ACL_ID=R.ID_ACL AND ( ACCESS_MASK LIKE '1%' OR ACCESS_MASK LIKE '0__1%' ))
 OR ( R.ID_OWNER=:B1 AND EXISTS( SELECT 1 FROM DMS.ACL_MEMBERS WHERE ACL_ID=R.ID_ACL AND INSTANCE_ID=:B2 AND (ACCESS_MASK LIKE '1%' OR ACCESS_MASK LIKE '0__1%' ) AND OBJECT_TYPE = 'O'))
 OR ( EXISTS( SELECT 1 FROM DMS.DOC_MEMBERS WHERE USER_ID=:B1 AND INSTANCE_ID=:B2 AND DOC_ID=R.RELATED_ID AND (ACCESS_MASK LIKE '1%' OR ACCESS_MASK LIKE '0__1%' )))) ORDER BY 2 DESC
Go to Top

Stripped SQL Text (CF035F4C5DC1C6E40C3F88896FD9FBB4 8438898304652221775)

SQL Text: [+]
Go to Top

SQL Identification

SQL ID: 0b2vmgwsxx9m3
Hash Value: 836675171
Signature for Stored Outlines: CF035F4C5DC1C6E40C3F88896FD9FBB4
Signature for SQL Profiles (force match FALSE): 8438898304652221775
Signature for SQL Profiles (force match TRUE): 8438898304652221775
Command Type: SELECT (3)
"EXPLAIN PLAN FOR" SQL ID for stripped sql_text: 2zmqm8z8k9m6h
Signature for Stored Outlines for unstripped sql_text: 1925D5012F05D52AB8EB459AC9CA2647
Signature for SQL Profiles for unstripped sql_text (force match FALSE): 16518511276753892910
Signature for SQL Profiles for unstripped sql_text (force match TRUE): 16518511276753892910
Statement Response Time: +00 00:00:01.463328
Go to Top

Environment

Host Name: epdb2.katastr.int
CPUs: 16
Exadata: "null"
RAC: FALSE
NLS Characterset
(database_properties):
EE8MSWIN1250
DB Time Zone
(database_properties):
+02:00
DB Block Size
(db_block_size):
16384
Optim Peek User Binds
(_optim_peek_user_binds):
TRUE
DB Size in Terabytes
(dba_data_files):
4.288 TB
TC Data Size in Gigabytes
(dba_segments):
202.960 GB
Platform: Linux
Product Version: Oracle Database 11g Enterprise Edition (64bit Production)
RDBMS Version: 11.2.0.3.0
Language: US:AMERICAN_CZECH REPUBLIC.EE8MSWIN1250
Database Name and ID: EPVDS(1761613797)
Instance Name and ID: EPVDS(1)
EBS: NO
Siebel: NO
PSFT: NO
User Name and ID: DMS (54)
Input Filename: script2f.sql
STATID: s29544_epvds_epdb2
Go to Top

CBO Environment

Non-Default or Modified CBO Parameters

[-] Non-default or modified CBO initialization parameters in effect for the session where SQLT XECUTE was executed. Includes all instances.
# Is Default1 Is Modified2 Name Inst ID Value Display Value Modified on Is Adjusted Is Deprecated Is Basic Is Session Modifiable Is System Modifiable Is Instance Modifiable Type Description
1 FALSE FALSE pga_aggregate_target 1 "2147483648" "2G" FALSE FALSE TRUE FALSE IMMEDIATE TRUE 6 Target size for the aggregate PGA memory consumed by the instance
2 TRUE MODIFIED statistics_level 1 "TYPICAL"   FALSE FALSE FALSE TRUE IMMEDIATE TRUE 2 statistics level
(1) FALSE: Parameter value was specified in the parameter file.
(2) FALSE: Parameter has not been modified after instance startup. MODIFIED: Parameter has been modified with ALTER SESSION. SYSTEM_MOD: Parameter has been modified with ALTER SYSTEM.
Go to Top

Default Unmodifed CBO Parameters

[+]

Fix Control

Non-Default Fixes

[-] Non-default fixes in effect for the session where SQLT XECUTE was executed.

Default Fixes

[+]

CBO System Statistics

Go to Top

Info System Statistics

# Name Value
1 STATUS COMPLETED
2 DSTART 10-16-2009 16:24
3 DSTOP 10-16-2009 16:24
4 FLAGS

Current System Statistics

# Name Value
1 CPUSPEEDNW 2091.18176364727
2 IOSEEKTIM 10
3 IOTFRSPEED 4096
4 CPUSPEED
5 MBRC
6 SREADTIM
7 MREADTIM
8 MAXTHR
9 SLAVETHR

Basis and Synthesized Values

db_block_size: 16384
db_file_multiblock_read_count: 64
_db_file_optimizer_read_count: 8
_db_file_exec_read_count: -1
Estimated CPUSPEED: 2091.18176364727
Estimated MBRC: 64
Estimated SREADTIM: 14
Estimated MREADTIM: 266
CPU Cost Scaling Factor: 3.415704e-08
CPU Cost Scaling Factor (inverse): 29276545
Actual SREADTIM: 15.126
Actual MREADTIM: 3.318

System Statistics History

Go to Top

DBMS_STATS Setup

Go to Top

DBMS_STATS System Preferences

Approximate NDV: "null"
Auto Stats Target: AUTO
Cascade: DBMS_STATS.AUTO_CASCADE
Concurrent: "null"
Degree: NULL
Estimate Percent: DBMS_STATS.AUTO_SAMPLE_SIZE
Granularity: AUTO
Incremental Internal Control: "null"
Incremental: FALSE
Method Opt: FOR ALL COLUMNS SIZE AUTO
No Invalidate: DBMS_STATS.AUTO_INVALIDATE
Publish: TRUE
Stale Percent: 10
Stats Retention: "null"

DBMS_STATS Table Preferences

Auto Task "auto optimizer stats collection"

Client Name: auto optimizer stats collection
Status: ENABLED
Consumer Group: ORA$AUTOTASK_STATS_GROUP
Client Tag: OS
Priority Override: INVALID
Attributes: ON BY DEFAULT, VOLATILE, SAFE TO KILL
Window Group: ORA$AT_WGRP_OS
Resource Percentage: 25
Use Resource Estimates: FALSE
Mean Job Duration: +000000000 00:06:13.372029250
Mean Job CPU: +000000000 00:02:20.047879342
Mean Job Attempts: 0
Mean incoming Tasks 7 days: 1
Mean incoming Tasks 30 days: 1
Total CPU last 7 days: +000000000 00:50:28.470000000
Total CPU last 30 days: +000000000 03:05:00.390000000
Max duration last 7 days: +000 00:48:25
Max duration last 30 days: +000 00:48:25
Window duration last 7 days: +000000001 19:20:15.750245000
Window duration last 30 days: +000000005 15:20:11.907111000

Statistics for SYS Tables

# Last Analyzed Tables
1 NO STATS 59
2 2013-07 195
3 2013-06 21
4 2013-05 3
5 2013-04 1
6 2013-02 8
7 2012-11 2
8 2012-10 12
9 2012-09 296
10 2012-08 1
11 2012-03 1
12 2011-10 1
13 2011-08 1
14 2011-07 1
15 2011-06 1
16 2011-05 1
17 2010-07 6
18 2009-10 377

Statistics for Fixed Objects

# Last Analyzed Fixed Objects
1 NO STATS 935

DBMS_STATS Operations History

List restricted up to 300 rows as per tool parameter "r_rows_table_m".
SQL: [+]
# Start Time End Time Operation Target
1 2013-07-29/18:19:01.161747 +02:00 2013-07-29/18:19:01.257322 +02:00 export_table_stats DMS."GROUP_MEMBERS"
2 2013-07-29/18:19:01.082369 +02:00 2013-07-29/18:19:01.160633 +02:00 export_table_stats DMS."DOC_TEMPLATES"
3 2013-07-29/18:18:39.147677 +02:00 2013-07-29/18:19:01.081047 +02:00 export_table_stats DMS."DOC_RELATIONS"
4 2013-07-29/18:18:39.032590 +02:00 2013-07-29/18:18:39.146291 +02:00 export_table_stats DMS."DOC_MEMBERS"
5 2013-07-29/18:18:23.251361 +02:00 2013-07-29/18:18:39.031150 +02:00 export_table_stats DMS."DOC_ATTR"
6 2013-07-29/18:18:22.598563 +02:00 2013-07-29/18:18:23.205626 +02:00 export_table_stats DMS."ACMTT_ACL_MEMBERS"
7 2013-07-28/23:00:02.445545 +02:00 2013-07-28/23:05:17.208843 +02:00 gather_database_stats(auto)
8 2013-07-27/23:00:02.385786 +02:00 2013-07-27/23:08:49.680376 +02:00 gather_database_stats(auto)
9 2013-07-26/23:00:02.149416 +02:00 2013-07-26/23:19:09.552157 +02:00 gather_database_stats(auto)
10 2013-07-26/14:15:02.807608 +02:00 2013-07-26/14:15:05.096489 +02:00 gather_table_stats DMS.ACMTT_ACL_MEMBERS
11 2013-07-25/23:00:03.281731 +02:00 2013-07-25/23:15:03.058065 +02:00 gather_database_stats(auto)
12 2013-07-25/17:09:17.856849 +02:00 2013-07-25/17:30:07.419923 +02:00 gather_table_stats DMS.DOC_RELATIONS
13 2013-07-25/17:09:04.157599 +02:00 2013-07-25/20:49:52.570123 +02:00 gather_table_stats DMS.DOC_ATTR
14 2013-07-25/17:02:04.484296 +02:00 2013-07-25/17:03:12.525559 +02:00 gather_table_stats DMS.DOC_TEMPLATES
15 2013-07-25/17:01:49.750647 +02:00 2013-07-25/17:01:50.534877 +02:00 gather_table_stats DMS.GROUP_MEMBERS
16 2013-07-25/17:01:38.340829 +02:00 2013-07-25/17:01:39.243782 +02:00 gather_table_stats DMS.DOC_MEMBERS
17 2013-07-25/16:23:23.443631 +02:00 2013-07-25/16:23:23.473022 +02:00 export_table_stats DMS."GROUP_MEMBERS"
18 2013-07-25/16:23:23.430688 +02:00 2013-07-25/16:23:23.442809 +02:00 export_table_stats DMS."DOC_TEMPLATES"
19 2013-07-25/16:23:13.622635 +02:00 2013-07-25/16:23:23.429243 +02:00 export_table_stats DMS."DOC_RELATIONS"
20 2013-07-25/16:23:13.613606 +02:00 2013-07-25/16:23:13.621847 +02:00 export_table_stats DMS."DOC_MEMBERS"
21 2013-07-25/16:23:03.909625 +02:00 2013-07-25/16:23:13.612417 +02:00 export_table_stats DMS."DOC_ATTR"
22 2013-07-25/16:23:03.679450 +02:00 2013-07-25/16:23:03.908593 +02:00 export_table_stats DMS."ACMTT_ACL_MEMBERS"
23 2013-07-25/16:03:05.419034 +02:00 2013-07-25/16:03:05.501203 +02:00 export_table_stats DMS."GROUP_MEMBERS"
24 2013-07-25/16:03:05.335859 +02:00 2013-07-25/16:03:05.417649 +02:00 export_table_stats DMS."DOC_TEMPLATES"
25 2013-07-25/16:02:47.063900 +02:00 2013-07-25/16:03:05.334611 +02:00 export_table_stats DMS."DOC_RELATIONS"
26 2013-07-25/16:02:47.017338 +02:00 2013-07-25/16:02:47.062533 +02:00 export_table_stats DMS."DOC_MEMBERS"
27 2013-07-25/16:02:34.969032 +02:00 2013-07-25/16:02:47.015999 +02:00 export_table_stats DMS."DOC_ATTR"
28 2013-07-25/16:02:34.517606 +02:00 2013-07-25/16:02:34.918713 +02:00 export_table_stats DMS."ACMTT_ACL_MEMBERS"
29 2013-07-24/23:00:02.663507 +02:00 2013-07-24/23:48:27.423801 +02:00 gather_database_stats(auto)
30 2013-07-23/23:00:01.410318 +02:00 2013-07-23/23:22:09.622321 +02:00 gather_database_stats(auto)
# Start Time End Time Operation Target
31 2013-07-22/23:00:02.654415 +02:00 2013-07-22/23:22:30.663827 +02:00 gather_database_stats(auto)
32 2013-07-21/23:00:00.991979 +02:00 2013-07-21/23:06:23.894256 +02:00 gather_database_stats(auto)
33 2013-07-20/23:00:02.191318 +02:00 2013-07-20/23:06:29.405995 +02:00 gather_database_stats(auto)
34 2013-07-19/23:00:01.681935 +02:00 2013-07-19/23:22:17.424721 +02:00 gather_database_stats(auto)
35 2013-07-18/23:00:01.435204 +02:00 2013-07-18/23:28:28.667766 +02:00 gather_database_stats(auto)
36 2013-07-17/23:00:01.859087 +02:00 2013-07-17/23:18:01.345041 +02:00 gather_database_stats(auto)
37 2013-07-16/23:00:01.500654 +02:00 2013-07-16/23:15:52.967175 +02:00 gather_database_stats(auto)
38 2013-07-15/23:00:02.226830 +02:00 2013-07-15/23:15:27.953805 +02:00 gather_database_stats(auto)
Go to Top

Initialization Parameters

Non-Default or Modified Session Parameters

[-] Non-default or modified initialization parameters in effect for the session where SQLT XECUTE was executed. Includes all instances. Excludes CBO parameters.
# Is Default1 Is Modified2 Modified on3 Name Inst ID Ordinal Value Display Value Is Adjusted Is Deprecated Is Basic Is Session Modifiable Is System Modifiable Is Instance Modifiable Type Description
1 FALSE FALSE audit_file_dest 1 1 "/opt/oracle/admin/EPVDS/adump"   FALSE FALSE FALSE FALSE DEFERRED TRUE 2 Directory in which auditing files are to reside
2 FALSE FALSE audit_trail 1 1 "DB"   FALSE FALSE FALSE FALSE FALSE FALSE 2 enable system auditing
3 FALSE FALSE compatible 1 1 "11.1.0.0.0"   FALSE FALSE TRUE FALSE FALSE FALSE 2 Database will be completely compatible with this software version
4 FALSE FALSE control_file_record_keep_time 1 1 "21"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 3 control file record keep time in days
5 FALSE FALSE control_files 1 1 "/opt/oradata/olog1/EPVDS/ control01_EPVDS.ctl"   FALSE FALSE TRUE FALSE FALSE FALSE 2 control file names list
6 FALSE FALSE control_files 1 2 "/opt/oradata/olog2/EPVDS/ control02_EPVDS.ctl"   FALSE FALSE TRUE FALSE FALSE FALSE 2 control file names list
7 FALSE FALSE db_32k_cache_size 1 1 "67108864" "64M" FALSE FALSE FALSE FALSE IMMEDIATE TRUE 6 Size of cache for 32K buffers
8 FALSE FALSE db_block_size 1 1 "16384"   FALSE FALSE TRUE FALSE FALSE FALSE 3 Size of database block in bytes
9 FALSE FALSE db_domain 1 1 "katastr.int"   FALSE FALSE TRUE FALSE FALSE FALSE 2 directory part of global database name stored with CREATE DATABASE
10 FALSE FALSE db_name 1 1 "EPVDS"   FALSE FALSE TRUE FALSE FALSE FALSE 2 database name specified in CREATE DATABASE
11 FALSE FALSE db_recovery_file_dest 1 1 "/opt/oradata/odata1/flash_recovery_area"   FALSE FALSE TRUE FALSE IMMEDIATE FALSE 2 default database recovery file location
12 FALSE FALSE db_recovery_file_dest_size 1 1 "17179869184" "16G" FALSE FALSE TRUE FALSE IMMEDIATE FALSE 6 database recovery files size limit
13 FALSE FALSE diagnostic_dest 1 1 "/opt/oracle"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 2 diagnostic base directory
14 FALSE FALSE dispatchers 1 1 "(PROTOCOL=TCP) (SERVICE=EPVDSXDB)"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 2 specifications of dispatchers
15 FALSE FALSE event 1 1 ""   FALSE FALSE FALSE FALSE FALSE FALSE 2 debug event control - default null string
16 FALSE FALSE filesystemio_options 1 1 "SETALL"   FALSE FALSE FALSE FALSE FALSE FALSE 2 IO operations on filesystem files
17 FALSE FALSE java_pool_size 1 1 "134217728" "128M" FALSE FALSE FALSE FALSE IMMEDIATE TRUE 6 size in bytes of java pool
18 FALSE FALSE job_queue_processes 1 1 "10"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 3 maximum number of job queue slave processes
19 FALSE FALSE log_archive_dest_1 1 1 "LOCATION=/opt/oradata/archlogs1/EPVDS"   FALSE FALSE TRUE TRUE IMMEDIATE TRUE 2 archival destination #1 text string
20 FALSE FALSE log_archive_dest_2 1 1 "LOCATION=/opt/oradata/archlogs2/EPVDS"   FALSE FALSE TRUE TRUE IMMEDIATE TRUE 2 archival destination #2 text string
21 FALSE FALSE log_archive_dest_state_1 1 1 "ENABLE"   FALSE FALSE TRUE TRUE IMMEDIATE TRUE 2 archival destination #1 state text string
22 FALSE FALSE log_archive_dest_state_2 1 1 "ENABLE"   FALSE FALSE TRUE TRUE IMMEDIATE TRUE 2 archival destination #2 state text string
23 FALSE FALSE log_archive_format 1 1 "EPVDS_%r_%t_%s.arc"   FALSE FALSE FALSE FALSE FALSE FALSE 2 archival destination format
24 FALSE FALSE nls_territory 1 1 "CZECH REPUBLIC"   FALSE FALSE TRUE TRUE FALSE FALSE 2 NLS territory name
25 FALSE FALSE open_cursors 1 1 "300"   FALSE FALSE TRUE FALSE IMMEDIATE TRUE 3 max # cursors per session
26 FALSE FALSE processes 1 1 "400"   FALSE FALSE TRUE FALSE FALSE FALSE 3 user processes
27 FALSE FALSE recyclebin 1 1 "OFF"   FALSE FALSE FALSE TRUE DEFERRED TRUE 2 recyclebin processing
28 FALSE FALSE remote_login_passwordfile 1 1 "EXCLUSIVE"   FALSE FALSE TRUE FALSE FALSE FALSE 2 password file usage parameter
29 FALSE FALSE resource_limit 1 1 "TRUE"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 1 master switch for resource limit
30 FALSE FALSE sec_case_sensitive_logon 1 1 "TRUE"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 1 case sensitive password enabled for logon
# Is Default1 Is Modified2 Modified on3 Name Inst ID Ordinal Value Display Value Is Adjusted Is Deprecated Is Basic Is Session Modifiable Is System Modifiable Is Instance Modifiable Type Description
31 FALSE FALSE sessions 1 1 "624"   FALSE FALSE TRUE FALSE FALSE FALSE 3 user and system sessions
32 FALSE FALSE sga_max_size 1 1 "21474836480" "20G" FALSE FALSE FALSE FALSE FALSE FALSE 6 max total SGA size
33 FALSE FALSE sga_target 1 1 "21474836480" "20G" FALSE FALSE TRUE FALSE IMMEDIATE TRUE 6 Target size of SGA
34 FALSE FALSE undo_retention 1 1 "1200"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 3 undo retention in seconds
35 FALSE FALSE undo_tablespace 1 1 "UNDOTBS1"   FALSE FALSE TRUE FALSE IMMEDIATE TRUE 2 use/switch undo tablespace
36 TRUE MODIFIED max_dump_file_size 1 1 "200M"   FALSE FALSE FALSE TRUE IMMEDIATE TRUE 2 Maximum size (in bytes) of dump file
37 TRUE MODIFIED nls_numeric_characters 1 1 ".,"   FALSE FALSE FALSE TRUE FALSE FALSE 2 NLS numeric characters
38 TRUE MODIFIED timed_statistics 1 1 "TRUE"   FALSE FALSE FALSE TRUE IMMEDIATE TRUE 1 maintain internal timing statistics
39 TRUE MODIFIED tracefile_identifier 1 1 "S29544_SQLT_TRACE"   FALSE FALSE FALSE TRUE FALSE FALSE 2 trace file custom identifier
(1) FALSE: Parameter value was specified in the parameter file.
(2) FALSE: Parameter has not been modified after instance startup. MODIFIED: Parameter has been modified with ALTER SESSION. SYSTEM_MOD: Parameter has been modified with ALTER SYSTEM.
(3) Last time this parameter has been modified (if available in AWR).
Go to Top

Default Unmodifed Session Parameters

[+]

Modified System Parameters

[-] Historical values of modified initialization system-level parameters captured by AWR with no direct relation to the SQL being analyzed. Includes all instances. Excludes some parameters and all "__%" parameters
List restricted up to 300 rows as per tool parameter "r_rows_table_m".
SQL: [+]
# Parameter Name Inst ID Snapshot Time Snap ID Is Default1 Is Modified2 Value Oldest Value3 Newest Value4
1 dml_locks 1 2013-07-18/10:29:37.604 40036 TRUE FALSE "2744" N Y
2 dml_locks 1 2013-07-01/00:30:18.013 38369 TRUE FALSE "1476" Y N
3 parallel_max_servers 1 2013-07-18/10:29:37.604 40036 TRUE FALSE "385" N Y
4 parallel_max_servers 1 2013-07-01/00:30:18.013 38369 TRUE FALSE "185" Y N
(1) FALSE: Parameter value was specified in the parameter file.
(2) FALSE: Parameter has not been modified after instance startup. MODIFIED or SYSTEM_MOD: Parameter has been modified with ALTER SYSTEM.
(3) Y: Oldest Value on AWR for this Parameter Name and Inst ID.
(4) Y: Newest Value on AWR for this Parameter Name and Inst ID.
Go to Top

Historical Non-Default or Modified System Parameters

[-] Historical values of non-default or modified initialization system-level parameters, captured by AWR during snapshots of the SQL statement being analyzed. Includes all instances.
List restricted up to 300 rows as per tool parameter "r_rows_table_m".

NLS Parameters

NLS Session Parameters

[-] Captured when SQLT was executed. Includes other instances if the value is different to this instance.
# Name Inst ID Value
1 nls_calendar 1 GREGORIAN
2 nls_characterset 1 EE8MSWIN1250
3 nls_comp 1 BINARY
4 nls_currency 1 Kc
5 nls_date_format 1 DD.MM.RR
6 nls_date_language 1 AMERICAN
7 nls_dual_currency 1 Kc
8 nls_iso_currency 1 CZECH REPUBLIC
9 nls_language 1 AMERICAN
10 nls_length_semantics 1 BYTE
11 nls_nchar_characterset 1 AL16UTF16
12 nls_nchar_conv_excp 1 FALSE
13 nls_numeric_characters 1 .,
14 nls_sort 1 BINARY
15 nls_territory 1 CZECH REPUBLIC
16 nls_timestamp_format 1 DD.MM.RR HH24:MI:SSXFF
17 nls_timestamp_tz_format 1 DD.MM.RR HH24:MI:SSXFF TZR
18 nls_time_format 1 HH24:MI:SSXFF
19 nls_time_tz_format 1 HH24:MI:SSXFF TZR
Go to Top

NLS Instance Parameters

[-] Captured when SQLT was executed. Includes other instances if the value is different to this instance.
# Name Inst ID Value
1 nls_calendar 1
2 nls_comp 1 BINARY
3 nls_currency 1
4 nls_date_format 1
5 nls_date_language 1
6 nls_dual_currency 1
7 nls_iso_currency 1
8 nls_language 1 AMERICAN
9 nls_length_semantics 1 BYTE
10 nls_nchar_conv_excp 1 FALSE
11 nls_numeric_characters 1
12 nls_sort 1
13 nls_territory 1 CZECH REPUBLIC
14 nls_time_format 1
15 nls_time_tz_format 1
16 nls_timestamp_format 1
17 nls_timestamp_tz_format 1
Go to Top

NLS Database Parameters

[-] Captured when SQLT was executed.
# Name Value
1 nls_calendar GREGORIAN
2 nls_characterset EE8MSWIN1250
3 nls_comp BINARY
4 nls_currency Kc
5 nls_date_format DD.MM.RR
6 nls_date_language AMERICAN
7 nls_dual_currency Kc
8 nls_iso_currency CZECH REPUBLIC
9 nls_language AMERICAN
10 nls_length_semantics BYTE
11 nls_nchar_characterset AL16UTF16
12 nls_nchar_conv_excp FALSE
13 nls_numeric_characters ,.
14 nls_rdbms_version 11.2.0.3.0
15 nls_sort BINARY
16 nls_territory CZECH REPUBLIC
17 nls_timestamp_format DD.MM.RR HH24:MI:SSXFF
18 nls_timestamp_tz_format DD.MM.RR HH24:MI:SSXFF TZR
19 nls_time_format HH24:MI:SSXFF
20 nls_time_tz_format HH24:MI:SSXFF TZR
Go to Top

I/O Calibration

I/O calibration results for the latest calibration run

Status of I/O calibration in the instance

status: NOT AVAILABLE
Go to Top

Tool Configuration Parameters

# Is Default Name System Value1 Session Value2 Default Value Domain
1 FALSE connect_identifier @EPVDS @EPVDS Null, or @connect_identifier
2 TRUE addm_reports 6 6 6 0-9999
3 TRUE ash_reports 6 6 6 0-9999
4 TRUE ash_reports_source BOTH BOTH BOTH BOTH, MEM, AWR, NONE
5 TRUE automatic_workload_repository Y Y Y Y, N
6 TRUE awr_reports 6 6 6 0-9999
7 TRUE bde_chk_cbo Y Y Y Y, N
8 TRUE c_ash_hist_days 31 31 31 0-999
9 TRUE c_awr_hist_days 31 31 31 0-999
10 TRUE c_cbo_stats_vers_days 31 31 31 0-999
11 TRUE c_dba_hist_parameter Y Y Y Y, N
12 TRUE c_gran_cols SUBPARTITION SUBPARTITION SUBPARTITION SUBPARTITION, PARTITION, GLOBAL
13 TRUE c_gran_hgrm SUBPARTITION SUBPARTITION SUBPARTITION SUBPARTITION, PARTITION, GLOBAL
14 TRUE c_gran_segm SUBPARTITION SUBPARTITION SUBPARTITION SUBPARTITION, PARTITION, GLOBAL
15 TRUE collect_perf_stats Y Y Y Y, N
16 TRUE count_star_threshold 10000 10000 10000 0-1000000000
17 TRUE custom_sql_profile N N N N, Y
18 TRUE distributed_queries Y Y Y Y, N
19 TRUE domain_index_metadata Y Y Y Y, N, E
20 TRUE event_10046_level 12 12 12 12, 8, 4, 1, 0
21 TRUE event_10053_level 1 1 1 1, 0
22 TRUE event_10507_level 1023 1023 1023 0-1023
23 TRUE event_others N N N N, Y
24 TRUE export_repository Y Y Y Y, N
25 TRUE export_utility EXP EXP EXP EXP, EXPDP
26 TRUE generate_10053_xtract Y Y Y N, Y, E
27 TRUE healthcheck_blevel Y Y Y Y, N
28 TRUE healthcheck_endpoints Y Y Y Y, N
29 TRUE healthcheck_ndv Y Y Y Y, N
30 TRUE healthcheck_num_rows Y Y Y Y, N
# Is Default Name System Value1 Session Value2 Default Value Domain
31 TRUE keep_trace_10046_open Y Y Y Y, N
32 TRUE keyword_font_color crimson crimson crimson crimson, red, orange, green, none
33 TRUE mask_for_values CLEAR CLEAR CLEAR CLEAR, SECURE, COMPLETE
34 TRUE plan_stats BOTH BOTH BOTH BOTH, LAST, ALL
35 TRUE predicates_in_plan Y Y Y N, Y, E
36 TRUE r_gran_cols PARTITION PARTITION PARTITION PARTITION, GLOBAL
37 TRUE r_gran_hgrm PARTITION PARTITION PARTITION PARTITION, GLOBAL
38 TRUE r_gran_segm PARTITION PARTITION PARTITION PARTITION, GLOBAL
39 TRUE r_gran_vers COLUMN COLUMN COLUMN COLUMN, SEGMENT, HISTOGRAM
40 TRUE r_rows_table_l 1000 1000 1000 100-10000
41 TRUE r_rows_table_m 300 300 300 30-3000
42 TRUE r_rows_table_s 100 100 100 10-1000
43 TRUE r_rows_table_xs 10 10 10 1-100
44 TRUE refresh_directories Y Y Y Y, N
45 TRUE search_sql_by_sqltext Y Y Y Y, N
46 TRUE show_binds_in_predicates Y Y Y Y, N
47 TRUE skip_metadata_for_object Null, or full/partial object name
48 TRUE sql_monitor_reports 12 12 12 1-9999
49 TRUE sql_monitoring Y Y Y Y, N
50 TRUE sql_tuning_advisor Y Y Y Y, N
51 TRUE sql_tuning_set Y Y Y Y, N
52 TRUE sqldx_reports_format BOTH BOTH BOTH HTML, CSV, BOTH, NONE
53 TRUE sqlt_max_file_size_mb 200 200 200 1-1024
54 TRUE sta_time_limit_secs 1800 1800 1800 30-86400
55 TRUE tcb_export_data FALSE FALSE FALSE FALSE, TRUE
56 TRUE tcb_export_pkg_body FALSE FALSE FALSE FALSE, TRUE
57 TRUE tcb_sampling_percent 100 100 100 0-100
58 TRUE tcb_time_limit_secs 1800 1800 1800 30-86400
59 TRUE test_case_builder Y Y Y Y, N
60 TRUE trace_analyzer Y Y Y Y, N
# Is Default Name System Value1 Session Value2 Default Value Domain
61 TRUE traces_directory_path Null, valid directory path on server
62 TRUE upload_trace_size_mb 100 100 100 1-1024
63 TRUE validate_user Y Y Y Y, N
64 TRUE xecute_script_output KEEP KEEP KEEP KEEP, ZIP, DELETE
(1) To permanently set a tool parameter issue: SQL> EXEC sqltxadmin.sqlt$a.set_param('Name', 'Value');
(2) To temporarily set a tool parameter for a session issue: SQL> EXEC sqltxadmin.sqlt$a.set_sess_param('Name', 'Value');
Go to Top

Cursor Sharing

Go to Plans Summary
Go to Top

Cursor Sharing Summary

List grouped by instance.
# Inst ID Sharable
Cursors
Cursors
not Shared
Total
1 1 1 0 1

Reasons for not Sharing

List grouped by instance, phv and reasons for not sharing and ordered by count.

List of Cursors

List restricted up to 300 rows as per tool parameter "r_rows_table_m".
SQL: [+]
# Inst ID Child Child Address Is
Obsolete
Plan Hash Value Elapsed Time
in secs
CPU Time
in secs
User IO Time
in secs
Cluster Time
in secs
Concurrency Time
in secs
Application Time
in secs
Buffer Gets Disk Reads Direct Writes Rows Processed Executions Plan Timestamp Last Active Time Avg
Elapsed Time
in secs
Avg
CPU Time
in secs
Avg
User IO Time
in secs
Avg
Cluster Time
in secs
Avg
Concurrency Time
in secs
Avg
Application Time
in secs
Avg
Buffer Gets
Avg
Disk Reads
Avg
Direct Writes
Avg
Rows Processed
Is
Sharable
Reasons for not Sharing Reason
1 1 0 000000054E14EE08 FALSE 3915546322 [B] [W] 0.790 0.509 0.457 0.000 0.000 0.000 222 20 0 0 3 2013-07-29/18:17:32 2013-07-29/18:17:33 0.263 0.170 0.152 0.000 0.000 0.000 74 7 0 0 TRUE  
Go to Plans Summary
Go to Top

Adaptive Cursor Sharing

Go to Plans Summary
Go to Top

Cursors List

List restricted up to 300 rows as per tool parameter "r_rows_table_m".
SQL: [+]
# Is
Sharable
Inst ID Child Child Address Plan Hash Value Is
Bind
Sensitive
Is
Bind
Aware
Buffer Gets Executions
1 Y 1 0 000000054E14EE08 3915546322 [B] [W] Y Y 222 3

Histogram

List restricted up to 1000 rows as per tool parameter "r_rows_table_l".
SQL: [+]
# Is
Sharable
Inst ID Child Bucket ID1 Count
1 Y 1 0 0 3
2 Y 1 0 1 0
3 Y 1 0 2 0
(1) Rows Processed. 0:< 1K, 1:between 1K and 1M, 2:> 1M.

Selectivity

List restricted up to 1000 rows as per tool parameter "r_rows_table_l".
SQL: [+]
# Is
Sharable
Inst ID Child Predicate Low High Range ID
1 Y 1 0 =B1 0.000000 0.000000 0
2 Y 1 0 =B1 0.000195 0.000239 0
3 Y 1 0 =B1 0.000338 0.000413 0
4 Y 1 0 =B1 0.000379 0.000464 0
5 Y 1 0 =B2 0.000000 0.000000 0
6 Y 1 0 =B2 0.014581 0.017821 0
7 Y 1 0 =B2 0.014581 0.017821 0
8 Y 1 0 =B2 0.024470 0.029908 0
9 Y 1 0 =B2 0.027515 0.033630 0
10 Y 1 0 =B2 0.027981 0.034199 0
11 Y 1 0 =B2 0.035095 0.042894 0
12 Y 1 0 =B2 0.035095 0.042894 0
13 Y 1 0 =B3 0.000000 0.000000 0
14 Y 1 0 =B5 0.000090 0.000110 0
15 Y 1 0 =B6 0.000582 0.000711 0
16 Y 1 0 =B6 0.000582 0.000711 0
17 Y 1 0 =B6 0.000666 0.000814 0

Statistics

List restricted up to 300 rows as per tool parameter "r_rows_table_m".
SQL: [+]
# Is
Sharable
Inst ID Child Bind Set
Hash Value
Peeked Executions Rows Processed Buffer Gets CPU Time
1 Y 1 0 3267654123 Y 1 0 126 0
Go to Plans Summary
Go to Top

Peeked Binds

Lists of peeked binds are restricted up to 1000 per phv as per tool parameter "r_rows_table_l".
# Plan Hash Value
1 3915546322 [B] [W]
Go to Captured Binds
Go to Plans Summary
Go to Top

Peeked Binds for 3915546322 [B] [W]

SQL Text: [+]
Summary
SQL: [+]
# Name Type Values Peeked Non-null Values Distinct Values Minimum Value Maximum Value1
1 :B1 NUMBER 2 2 1 "15096"
2 :B2 NUMBER 2 2 1 "177"
3 :B3 NUMBER 2 2 1 "29440"
4 :B4 NUMBER 2 2 1 "7"
5 :B5 NUMBER 2 2 1 "3636688"
6 :B6 NUMBER 2 2 1 "5179"
(1) Only if different than Minimum Value.
Source: GV$SQL_PLAN
SQL: [+]
Details: [+]
Go to Captured Binds
Go to Peeked Binds
Go to Plans Summary
Go to Top

Captured Binds

Lists of captured binds are restricted up to 1000 per phv as per tool parameter "r_rows_table_l".
# Plan Hash Value
1 3915546322 [B] [W]
Go to Peeked Binds
Go to Plans Summary
Go to Top

Captured Binds for 3915546322 [B] [W]

SQL Text: [+]
Summary
SQL: [+]
# Name Type Values Captured Non-null Values Distinct Values Minimum Value Maximum Value1
1 :B1 NUMBER 1 1 1 "15096"
2 :B2 NUMBER 1 1 1 "177"
3 :B3 NUMBER 1 1 1 "29440"
4 :B4 NUMBER 1 1 1 "7"
5 :B5 NUMBER 1 1 1 "3636688"
6 :B6 NUMBER 1 1 1 "5179"
(1) Only if different than Minimum Value.
Source: GV$SQL_PLAN
SQL: [+]
Details: [+]
Go to Peeked Binds
Go to Captured Binds
Go to Plans Summary
Go to Top

Plans Summary

List of plans found ordered by average elapsed time.
# Plan Hash Value1 Avg Elapsed Time in secs Avg CPU Time in secs Avg User I/O Wait Time in secs Avg Other Wait Time in secs2 Avg Buffer Gets Avg Disk Reads Avg Direct Writes Avg Rows Processed Total Executions Total Fetches Total Version Count Total Loads Total Invalidations Src Source3 Plan Info3 Plan Stability3 Is Bind Sensitive Min Opt Env Max Opt Env Opt Cost Estimated Cardinality Estimated Time in secs Plan Timestamp First Load Time4 Last Load Time4
1 3915546322 [B] [W] 0.263 0.170 0.152 0.000 74 7 0 0 3 3 1 1 0 MEM GV$SQLAREA_PLAN_HASH Y 641027046 65 1 0.910 2013-07-29/18:17:32 2013-07-29/18:17:32 2013-07-29/18:17:32
2 1957132478 XPL EXPLAIN PLAN FOR 32 1 0.448 2013-07-29/18:17:40
(1) [B]est and [W]orst according to average elapsed time if available and had fetches, else by optimizer cost. [X]ecute Plan (only on XECUTE method).
(2) Made of these wait times: application, concurrency, cluster, plsql and java execution.
(3) Shows accurate Plan Info when source is actually "GV$SQLAREA_PLAN_HASH". For "DBA_HIST_SQLSTAT" source review "Plan Performance History" section. For "DBA_SQLTUNE_PLANS" or "EXPLAIN PLAN FOR" sources review Execution Plans section.
(4) For plans from DBA_HIST_SQLSTAT this is the time of the begin/end snapshot that first/last collected metrics for a phv as per current history.
Go to Cursor Sharing
Go to Adaptive Cursor Sharing
Go to Execution Plans
Go to Top

Plan Performance Statistics

List ordered by phv, source and instance.
# Plan Hash Value Src Source Plan Info Plan Stability Is Bind Sensitive Inst ID Stats Total Elapsed Time in secs Total CPU Time in secs Total User I/O Wait Time in secs Total Other Wait Time in secs1 Total Buffer Gets Total Disk Reads Total Direct Writes Total Rows Processed Total Executions Total Fetches Total Version Count Total Loads Total Invalidations Opt Env Cnt Min Opt Env Max Opt Env Cost Plan Timestamp First Load Time Last Load Time
1 3915546322 [B] [W] MEM GV$SQLAREA_PLAN_HASH Y 1 Stats 0.790 0.509 0.457 0.000 222 20 0 0 3 3 1 1 0 1 641027046 65 2013-07-29/18:17:32 2013-07-29/18:17:32 2013-07-29/18:17:32
(1) Made of these wait times: application, concurrency, cluster, plsql and java execution.
Go to Execution Plans
Go to Plans Summary
Go to Top

Plan Performance Statistics for 3915546322 [B] [W]

Plan Hash Value: 3915546322 [B] [W]
Src: MEM
Source: GV$SQLAREA_PLAN_HASH
Is Bind Sensitive: Y
Inst ID: 1
Version Count: 1
Executions: 3
Elapsed Time in secs: 0.790
CPU Time in secs: 0.509
User I/O Wait Time in secs: 0.457
Application Wait Time in secs: 0.000
Concurrency Wait Time in secs: 0.000
Cluster Wait Time in secs: 0.000
PL/SQL Exec Time in secs: 0.000
Java Exec Time in secs: 0.000
Buffer Gets: 222
Disk Reads: 20
Direct Writes: 0
Rows Processed: 0
Parse Calls: 3
Fetches: 3
End of Fetch count: 3
PX Servers Executions: 0
Loaded Versions: 1
Loads: 1
Invalidations: 0
Open Versions: 0
Kept Versions: 0
Users Executing: 0
Users Opening: 0
First Load Time: 2013-07-29/18:17:32
Last Load Time: 2013-07-29/18:17:32
Last Active Time: 2013-07-29/18:17:33
Plan Timestamp: 2013-07-29/18:17:32
Sharable Memory: 224721
Persistent Memory: 139040
Runtime Memory: 135008
Sorts: 6
Serializable Aborts: 0
Command Type: 3
Optimizer Mode: ALL_ROWS
Optimizer Env: 641027046
Optimizer Cost: 65
Parsing User ID: 54
Parsing Schema ID: 54
Parsing Schema Name: DMS
Module: sqltxadmin.sqlt$a (xecute)
Action: 29544 10398 ALTER SESSION SET EV
SQL Profile: "null"
Exact Matching Signature: 16518511276753892910
Force Matching Signature: 16518511276753892910
Outline Category: "null"
Remote: N
Object Status: VALID
Program ID: 0
Program Line #: 0
Typecheck Memory: 0
I/O Interconnect Bytes: 327680
Physical Read Requests: 20
Physical Read Bytes: 327680
Physical Write Requests: 0
Physical Write Bytes: 0
Optimized Physical Read Requests: 0
I/O Cell Uncompressed Bytes: 0
I/O Cell Offload Eligible Bytes: 0
I/O Cell Offload Returned Bytes: 0
Go to Plan Performance Statistics
Go to Plans Summary
Go to Top

Execution Plans

List ordered by phv and source.
# Plan Hash Value SQLT
Plan
Hash
Value1
SQLT
Plan
Hash
Value21
Src Source Plan Info Plan Stability Is
Bind
Sensitive
Optimizer Optimizer
Cost
Estimated
Cardinality
E-Rows
Rows
Processed
A-Rows
Plan Timestamp Child
Plans2
Plan ID Task ID Attribute
1 1957132478 83510 27307 XPL PLAN_TABLE ALL_ROWS 32 1 2013-07-29/18:17:40 164
2 3915546322 [B] [W] 96499 64834 MEM GV$SQL_PLAN Y ALL_ROWS 65 1 0 2013-07-29/18:17:32 1
(1) SQLT PHV considers id, parent_id, operation, options, index_columns and object_name. SQLT PHV2 includes also access and filter predicates.
(2) Display of child plans is restricted up to 100 per phv as per tool parameter "r_rows_table_s".
Go to Plan Performance Statistics
Go to Plans Summary
Go to Top

Execution Plan  phv:1957132478  sqlt_phv:83510  sqlt_phv2:27307  source:PLAN_TABLE  timestamp:2013-07-29/18:17:40

SQL Text: [+]
SQL: [+]
ID Exec Ord Operation Go To More Cost2 Estim Card PStart PStop
0 25 SELECT STATEMENT     32 1
1 2  SORT AGGREGATE   [+] 4 1
2 1 . INDEX RANGE SCAN PI_DATTR__DI_TA_3V [+] [+] 4 1
3 24  SORT ORDER BY   [+] 32 1
4 23 . FILTER   [+] 38
5 14 .. NESTED LOOPS SEMI   [+] 30 1
6 11 ... NESTED LOOPS ANTI   [+] 26 1
7 8 .... NESTED LOOPS SEMI   [+] 22 1
8 6 ....+ PARTITION RANGE SINGLE   [+] 21 1 KEY KEY
9 5 ....+. PARTITION RANGE ALL   [+] 21 1 1 18
10 4 ....+.. TABLE ACCESS BY LOCAL INDEX ROWID DOC_RELATIONS [+] [+] 21 1 KEY KEY
11 3 ....+... INDEX RANGE SCAN PI_DRELS__DI_RI_FD_2RT [+] [+] 19 2 KEY KEY
12 7 ....+ INDEX UNIQUE SCAN UQ_DOC_TEMPLATES__TID_DID_IID [+] [+] 1 2012
13 10 .... TABLE ACCESS BY GLOBAL INDEX ROWID DOC_ATTR [+] [+] 4 1 ROW LOCATION ROW LOCATION
14 9 ....+ INDEX RANGE SCAN PI_DATTR__DI_TA_3V [+] [+] 3 1
15 13 ... TABLE ACCESS BY GLOBAL INDEX ROWID DOC_ATTR [+] [+] 4 1 ROW LOCATION ROW LOCATION
16 12 .... INDEX RANGE SCAN PI_DATTR__DI_TA_3V [+] [+] 3 1
17 18 .. FILTER   [+] 4
18 16 ... TABLE ACCESS BY INDEX ROWID ACMTT_ACL_MEMBERS [+] [+] 3 1
19 15 .... INDEX RANGE SCAN I_ACL_MBRS__AI_II_OI_OT [+] [+] 2 1
20 17 ... INDEX UNIQUE SCAN UQ_GR_MBRS__UI_II_GI [+] [+] 1 1
21 20 .. TABLE ACCESS BY INDEX ROWID DOC_MEMBERS [+] [+] 1 1
22 19 ... INDEX RANGE SCAN I_DOC_MBRS__DI_UI_II [+] [+] 1 1
23 22 .. TABLE ACCESS BY INDEX ROWID ACMTT_ACL_MEMBERS [+] [+] 3 1
24 21 ... INDEX RANGE SCAN I_ACL_MBRS__AI_II_OI_OT [+] [+] 2 1
(1) If estim_card * starts < output_rows then under-estimate. If estim_card * starts > output_rows then over-estimate. Color highlights when exceeding * 10x, ** 100x and *** 1000x over/under-estimates.
(2) Largest contributors for cumulative-statistics columns are shown in red.
Other XML (id=3): [+]
Outline Data (id=3): [+]
Leading (id=3): [+]
Go to Tables
Go to Indexes
Go to Top

Plan Info

# Type Value
1 db_version 11.2.0.3
2 parse_schema "DMS"
3 plan_hash 1957132478
Go to Execution Plans
Go to Plan Performance Statistics
Go to Plans Summary
Go to Tables
Go to Indexes
Go to Top

Execution Plan  phv:3915546322 [B] [W]  sqlt_phv:96499  sqlt_phv2:64834  source:GV$SQL_PLAN  inst:1  child:0(000000054E14EE08)  executions:3  is_sharable:Y  timestamp:2013-07-29/18:17:32

SQL Text: [+]
SQL: [+]
ID Exec Ord Operation Go To More Peek Bind Capt Bind Cost2 Estim Card LAST
Starts
LAST
Output Rows
LAST
CR Buffer Gets2
LAST
Elapsed Time in secs2
ALL
Starts
ALL
Output Rows
ALL
CR Buffer Gets2
ALL
Disk Reads2
ALL
Elapsed Time in secs2
PStart PStop Work Area
0 28 SELECT STATEMENT         65 1 0 0  
1 2  SORT AGGREGATE   [+]     4 1 0 0 0 0.000 0 0 0 0 0.000  
2 1 . INDEX RANGE SCAN PI_DATTR__DI_TA_3V [+] [+] [+] [+] 4 1 0 0 0 0.000 0 0 0 0 0.000  
3 27  SORT ORDER BY   [+]     65 1 1 0 48 0.000 3 0 144 18 0.445 [+]
4 26 . FILTER   [+] [+] [+] 71 1 0 48 0.000 3 0 144 18 0.445  
5 17 .. NESTED LOOPS ANTI   [+]     63 1 1 0 48 0.000 3 0 144 18 0.445  
6 14 ... NESTED LOOPS SEMI   [+]     59 1 1 0 48 0.000 3 0 144 18 0.445  
7 12 .... NESTED LOOPS   [+]     58 1 1 0 48 0.000 3 0 144 18 0.445  
8 7 ....+ SORT UNIQUE   [+]     38 1 1 0 48 0.000 3 0 144 18 0.445 [+]
9 6 ....+. PARTITION RANGE SINGLE   [+]     38 1 1 0 48 0.000 3 0 144 18 0.445 KEY KEY  
10 5 ....+.. PARTITION RANGE ALL   [+]     38 1 1 0 48 0.000 3 0 144 18 0.445 1 18  
11 4 ....+... TABLE ACCESS BY LOCAL INDEX ROWID DOC_ATTR [+] [+] [+] [+] 38 1 18 0 48 0.000 54 0 144 18 0.445 KEY KEY  
12 3 ....+.... INDEX RANGE SCAN PI_DATTR__TI_PI_DM_TA_3V [+] [+] [+] [+] 37 1 18 0 48 0.000 54 0 144 18 0.445 KEY KEY  
13 11 ....+ PARTITION RANGE SINGLE   [+]     19 2 0 0 0 0.000 0 0 0 0 0.000 KEY(AP) KEY(AP)  
14 10 ....+. PARTITION RANGE ALL   [+]     19 2 0 0 0 0.000 0 0 0 0 0.000 1 18  
15 9 ....+.. TABLE ACCESS BY LOCAL INDEX ROWID DOC_RELATIONS [+] [+] [+] [+] 19 2 0 0 0 0.000 0 0 0 0 0.000 KEY KEY  
16 8 ....+... INDEX RANGE SCAN PI_DRELS__DI_RI_FD_2RT [+] [+] [+] [+] 18 1 0 0 0 0.000 0 0 0 0 0.000 KEY KEY  
17 13 .... INDEX UNIQUE SCAN UQ_DOC_TEMPLATES__TID_DID_IID [+] [+] [+] [+] 1 1 0 0 0 0.000 0 0 0 0 0.000  
18 16 ... TABLE ACCESS BY GLOBAL INDEX ROWID DOC_ATTR [+] [+] [+] [+] 4 1 0 0 0 0.000 0 0 0 0 0.000 ROW LOCATION ROW LOCATION  
19 15 .... INDEX RANGE SCAN PI_DATTR__DI_TA_3V [+] [+]     3 1 0 0 0 0.000 0 0 0 0 0.000  
20 21 .. FILTER   [+] [+] [+] 4 0 0 0 0.000 0 0 0 0 0.000  
21 19 ... TABLE ACCESS BY INDEX ROWID ACMTT_ACL_MEMBERS [+] [+]     3 1 0 0 0 0.000 0 0 0 0 0.000  
22 18 .... INDEX RANGE SCAN I_ACL_MBRS__AI_II_OI_OT [+] [+] [+] [+] 2 1 0 0 0 0.000 0 0 0 0 0.000  
23 20 ... INDEX UNIQUE SCAN UQ_GR_MBRS__UI_II_GI [+] [+] [+] [+] 1 1 0 0 0 0.000 0 0 0 0 0.000  
24 23 .. TABLE ACCESS BY INDEX ROWID DOC_MEMBERS [+] [+]     1 1 0 0 0 0.000 0 0 0 0 0.000  
25 22 ... INDEX RANGE SCAN I_DOC_MBRS__DI_UI_II [+] [+] [+] [+] 1 1 0 0 0 0.000 0 0 0 0 0.000  
26 25 .. TABLE ACCESS BY INDEX ROWID ACMTT_ACL_MEMBERS [+] [+]     3 1 0 0 0 0.000 0 0 0 0 0.000  
27 24 ... INDEX RANGE SCAN I_ACL_MBRS__AI_II_OI_OT [+] [+] [+] [+] 2 1 0 0 0 0.000 0 0 0 0 0.000  
Performance statistics are only available when parameter "statistics_level" was set to "ALL" at hard-parse time, or SQL contains "gather_plan_statistics" hint.
(1) If estim_card * starts < output_rows then under-estimate. If estim_card * starts > output_rows then over-estimate. Color highlights when exceeding * 10x, ** 100x and *** 1000x over/under-estimates.
(2) Largest contributors for cumulative-statistics columns are shown in red.
Other XML (id=3): [+]
Outline Data (id=3): [+]
Leading (id=3): [+]
Go to Tables
Go to Indexes
Go to Top

Plan Info

# Type Value
1 db_version 11.2.0.3
2 parse_schema "DMS"
3 plan_hash 3915546322

Peeked Binds  timestamp:2013-07-29/18:17:32

# Name Type Value
1 :B5 NUMBER "3636688"
2 :B4 NUMBER "7"
3 :B3 NUMBER "29440"
4 :B2 NUMBER "177"
5 :B6 NUMBER "5179"
6 :B1 NUMBER "15096"

Captured Binds

List of captured binds is restricted up to 300 rows per Plan as per tool parameter "r_rows_table_m".
SQL: [+]
# Last Captured Name Type Value
1 2013-07-29/18:17:32 :B5 NUMBER "3636688"
2 2013-07-29/18:17:32 :B4 NUMBER "7"
3 2013-07-29/18:17:32 :B3 NUMBER "29440"
4 2013-07-29/18:17:32 :B2 NUMBER "177"
5 2013-07-29/18:17:32 :B6 NUMBER "5179"
6 2013-07-29/18:17:32 :B1 NUMBER "15096"

Optimizer Environment

# Name Value
1 _pga_max_size 429486080
2 sqlstat_enabled true
3 statistics_level all
Go to Execution Plans
Go to Plan Performance Statistics
Go to Plans Summary
Go to Tables
Go to Indexes
Go to Top

Active Session History

Go to Top

Active Session History by Plan

List below is restricted up to 300 recent plan lines (as per tool parameter "r_rows_table_m").
SQL: [+]
# Plan
Hash
Value
Session
State
Wait
Class
Event Snaps
Count
1 3915546322 ON CPU 1

Active Session History by Plan Line

List below is restricted up to 1000 recent plan lines (as per tool parameter "r_rows_table_l").
SQL: [+]

Active Session History by Session

List below is restricted up to 20 recent sessions (as per 2x tool parameter "r_rows_table_xs") and up to 20 snapshots per session (as per 2x tool parameter "r_rows_table_xs").
SQL: [+]
# Inst ID SID Serial# Sample Time SQL Exec Start Is SQL_ID Current SQL Child Num Force Matching Signature SQL Plan Hash Value SQL Plan Line ID SQL Plan Operation SQL Plan Options Event P1 Text P1 P2 Text P2 P3 Text P3 Wait Class Wait Time Session State Time Waited Blocking Session Status Blocking SID Blocking Serial# Blocking Inst ID Blocking Hang Chain Info Current Obj# Current File# Current Block# Current Row# Remote Inst# Program Module Action Client ID Machine TM Delta Time TM Delta CPU Time TM Delta DB Time Delta Time Delta Read I/O Requests Delta Write I/O Requests Delta Read I/O Bytes Delta Write I/O Bytes Delta Inter Connect I/O Bytes PGA Allocated Temp Space Allocated
1 1 55 53271 2013-07-29/18:17:33.164 Y 0 16518511276753892910 3915546322 0 SELECT STATEMENT file# 1 block# 29918 blocks 1 7823 ON CPU 0 NOT IN WAIT 523 1 1725 0 sqlplus@epdb2.katastr.int (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 29544 10398 ALTER SESSION SET EV epdb2.katastr.int 2142457 1459777 2121767 1000989 24 0 393216 0 393216 5398528 2097152
Go to Top

SQL Statistics

List of child cursors is restricted up to 100 per phv as per tool parameter "r_rows_table_s".
# Plan Hash Value Child
Cursors
1 3915546322 [B] [W] 1
Go to Top

SQL Statistics for 3915546322 [B] [W]

Inst ID: 1
Child Number: 0
Child Address: 000000054E14EE08
Executions: 3
Elapsed Time in secs: 0.790
CPU Time in secs: 0.509
User I/O Wait Time in secs: 0.457
Application Wait Time in secs: 0.000
Concurrency Wait Time in secs: 0.000
Cluster Wait Time in secs: 0.000
PL/SQL Exec Time in secs: 0.000
Java Exec Time in secs: 0.000
Buffer Gets: 222
Disk Reads: 20
Direct Writes: 0
Rows Processed: 0
Parse Calls: 3
Fetches: 3
End of Fetch count: 3
PX Servers Executions: 0
Loaded Versions: 1
Loads: 1
Invalidations: 0
Open Versions: 0
Kept Versions: 0
Users Executing: 0
Users Opening: 0
Locked Total: 3
Pinned Total: 4
First Load Time: 2013-07-29/18:17:32
Last Load Time: 2013-07-29/18:17:32
Last Active Time: 2013-07-29/18:17:33
Sharable Memory: 224721
Persistent Memory: 139040
Runtime Memory: 135008
Sorts: 6
Serializable Aborts: 0
SQL Type: 6
Command Type: 3
Optimizer Mode: ALL_ROWS
Optimizer Env: 641027046
Optimizer Cost: 65
Parsing User ID: 54
Parsing Schema ID: 54
Parsing Schema Name: DMS
Service: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 29544 10398 ALTER SESSION SET EV
Is Binds Aware: Y
Is Bind Sensitive: Y
Is Obsolete: N
Is Sharable: Y
Literal Hash Value: 0
SQL Patch: "null"
SQL Plan Baseline: "null"
SQL Profile: "null"
Exact Matching Signature: 16518511276753892910
Force Matching Signature: 16518511276753892910
Outline Category: "null"
Remote: N
Object Status: VALID
Program ID: 0
Program Line #: 0
Type Check Memory: 0
Type Check Heap: 00
I/O Interconnect Bytes: 327680
Physical Read Requests: 20
Physical Read Bytes: 327680
Physical Write Requests: 0
Physical Write Bytes: 0
Optimized Physical Read Requests: 0
I/O Cell Uncompressed Bytes: 0
I/O Cell Offload Eligible Bytes: 0
I/O Cell Offload Returned Bytes: 0
Go to SQL Statistics
Go to Top

SQL Monitor Statistics

List of monitored executions is restricted up to 100 per phv as per tool parameter "r_rows_table_s".
# Plan Hash Value Monitored
Executions
1 3915546322 [B] [W] 3
Go to Top

SQL Monitoring for 3915546322 [B] [W] DONE (ALL ROWS) 2013-07-29/18:17:33

Status: DONE (ALL ROWS)
SQL Exec Start Time: 2013-07-29/18:17:33
SQL Exec ID: 16777217
Inst ID: 1
Process Name: ora
Key: 2993592245963
Child Address: 000000054E14EE08
Child Number: 0
Elapsed Time in secs: 0.002
Queuing Time in secs: 0.000
CPU Time in secs: 0.002
User I/O Wait Time in secs: 0.000
Application Wait Time in secs: 0.000
Concurrency Wait Time in secs: 0.000
Cluster Wait Time in secs: 0.000
PL/SQL Exec Time in secs: 0.000
Java Exec Time in secs: 0.000
Buffer Gets: 48
Disk Reads: 0
Direct Writes: 0
Fetches: 1
PX is Cross Instance: N
Refresh Count: 4
First Refresh Time: 2013-07-29/18:17:33
Last Refresh Time: 2013-07-29/18:17:33
User #: 54
User Name: DMS
Service Name: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 29544 10398 ALTER SESSION SET EV
SID: 55
Session Serial#: 53271
Exact Matching Signature: 16518511276753892910
Force Matching Signature: 16518511276753892910
Program: sqlplus@epdb2.katastr.int (TNS V1-V3)
I/O Interconnect Bytes: 0
Physical Read Requests: 0
Physical Read Bytes: 0
Physical Write Requests: 0
Physical Write Bytes: 0
Go to SQL Monitor
Go to Top

SQL Monitoring for 3915546322 [B] [W] DONE (ALL ROWS) 2013-07-29/18:17:33

Status: DONE (ALL ROWS)
SQL Exec Start Time: 2013-07-29/18:17:33
SQL Exec ID: 16777218
Inst ID: 1
Process Name: ora
Key: 592705527500
Child Address: 000000054E14EE08
Child Number: 0
Elapsed Time in secs: 0.002
Queuing Time in secs: 0.000
CPU Time in secs: 0.002
User I/O Wait Time in secs: 0.000
Application Wait Time in secs: 0.000
Concurrency Wait Time in secs: 0.000
Cluster Wait Time in secs: 0.000
PL/SQL Exec Time in secs: 0.000
Java Exec Time in secs: 0.000
Buffer Gets: 48
Disk Reads: 0
Direct Writes: 0
Fetches: 1
PX is Cross Instance: N
Refresh Count: 4
First Refresh Time: 2013-07-29/18:17:33
Last Refresh Time: 2013-07-29/18:17:33
User #: 54
User Name: DMS
Service Name: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 29544 10398 ALTER SESSION SET EV
SID: 55
Session Serial#: 53271
Exact Matching Signature: 16518511276753892910
Force Matching Signature: 16518511276753892910
Program: sqlplus@epdb2.katastr.int (TNS V1-V3)
I/O Interconnect Bytes: 0
Physical Read Requests: 0
Physical Read Bytes: 0
Physical Write Requests: 0
Physical Write Bytes: 0
Go to SQL Monitor
Go to Top

SQL Monitoring for 3915546322 [B] [W] DONE (ALL ROWS) 2013-07-29/18:17:32

Status: DONE (ALL ROWS)
SQL Exec Start Time: 2013-07-29/18:17:32
SQL Exec ID: 16777216
Inst ID: 1
Process Name: ora
Key: 4256312630986
Child Address: 000000054E14EE08
Child Number: 0
Elapsed Time in secs: 0.785
Queuing Time in secs: 0.000
CPU Time in secs: 0.505
User I/O Wait Time in secs: 0.457
Application Wait Time in secs: 0.000
Concurrency Wait Time in secs: 0.000
Cluster Wait Time in secs: 0.000
PL/SQL Exec Time in secs: 0.000
Java Exec Time in secs: 0.000
Buffer Gets: 126
Disk Reads: 20
Direct Writes: 0
Fetches: 1
PX is Cross Instance: N
Refresh Count: 4
First Refresh Time: 2013-07-29/18:17:32
Last Refresh Time: 2013-07-29/18:17:33
User #: 54
User Name: DMS
Service Name: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 29544 10398 ALTER SESSION SET EV
SID: 55
Session Serial#: 53271
Exact Matching Signature: 16518511276753892910
Force Matching Signature: 16518511276753892910
Program: sqlplus@epdb2.katastr.int (TNS V1-V3)
I/O Interconnect Bytes: 327680
Physical Read Requests: 20
Physical Read Bytes: 327680
Physical Write Requests: 0
Physical Write Bytes: 0
Go to SQL Monitor
Go to Top

Segment Statistics

Statistics below include the execution of your SQL within "script2f.sql".
SQLT XECUTE took snapshots of GV$SEGMENT_STATISTICS right before and after your script was executed. Metrics below are for that interval.
Be aware that segment statistics are not session specific. Therefore, use the statitics below with caution since they may include work from other active sessions.
Content below is driven by tables discovered in prior executions of SQLT. Thus, you may need to repeat this SQLT XECUTE in order to get all segments related to your SQL.
List restricted up to 300 rows as per tool parameter "r_rows_table_m".
SQL: [+]
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
1 1948036064 logical reads PI_DATTR__DI_TA_3V DMS INDEX 1 DMS_IND 197188 197188
2 357015120 logical reads UQ_GR_MBRS__UI_II_GI DMS INDEX 1 DMS_IND 62506 236813
3 335544320 space allocated PI_DATTR__DI_TA_3V DMS INDEX 1 DMS_IND 197188 197188
4 180885856 space used PI_DATTR__DI_TA_3V DMS INDEX 1 DMS_IND 197188 197188
5 81465744 logical reads DOC_RELATIONS I577_P0 DMS TABLE SUBPARTITION 1 DMS_TAB_0 200481 200481
6 67752160 db block changes I_DRELS__CH_DI_ID_II DMS INDEX 1 DMS_IND 247059 247059
7 67108864 space allocated I_DRELS__CA_DI_2F_AR_AI_OI DMS INDEX 1 DMS_IND 247058 247058
8 50331648 space allocated PI_DATTR__TI_PI_DM_TA_3V I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198730 198730
9 50331648 space allocated PI_DATTR__TI_PI_DM_TA_3V I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198874 198874
10 45088768 space allocated PI_DATTR__DM_3V_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197588 197588
11 44040192 space allocated PI_DATTR__FCV_TI_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198303 198303
12 44040192 space allocated PI_DATTR__TA_3V_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199872 199872
13 43937616 logical reads ACMTT_ACL_MEMBERS DMS TABLE 1 DMS_TAB 61893 236397
14 42325360 db block changes PI_DATTR__DI_TA_3V DMS INDEX 1 DMS_IND 197188 197188
15 41943040 space allocated DOC_ATTR I577_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196988 196988
16 41943040 space allocated PI_DATTR__FCV_TI_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198159 198159
17 41943040 space allocated PI_DATTR__PI_DM_3V_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199445 199445
18 41943040 space allocated PI_DATTR__PI_DM_3V_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199301 199301
19 41943040 space allocated PI_DATTR__TI_PI_DM_TA_3V I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198964 198964
20 39845888 space allocated PI_DATTR__FCV_TI_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198393 198393
21 39845888 space allocated PI_DATTR__TA_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200106 200106
22 37748736 space allocated PI_DATTR__PI_DM_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199535 199535
23 36527020 space used DOC_ATTR I577_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196988 196988
24 33554432 space allocated DOC_ATTR I587_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197078 197078
25 33554432 space allocated DOC_ATTR I597_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197168 197168
26 33554432 space allocated DOC_ATTR I571_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196934 196934
27 33554432 space allocated I_DRELS__CH_DI_ID_II DMS INDEX 1 DMS_IND 247059 247059
28 33554432 space allocated PI_DATTR__DM_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197822 197822
29 33554432 space allocated PI_DATTR__DM_3V_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197732 197732
30 33554432 space allocated PI_DATTR__PI_DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199355 199355
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
31 33554432 space allocated PI_DATTR__TA_3V_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200016 200016
32 33554432 space allocated PI_DATTR__TA_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199926 199926
33 33554432 space allocated PI_DATTR__TI_PI_DM_TA_3V I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198784 198784
34 33333434 space used DOC_ATTR I587_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197078 197078
35 32885820 space used DOC_ATTR I571_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196934 196934
36 32702090 space used I_DRELS__CA_DI_2F_AR_AI_OI DMS INDEX 1 DMS_IND 247058 247058
37 31457280 space allocated PI_DATTR__DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197642 197642
38 30762080 db block changes DOC_RELATIONS I177_P0 DMS TABLE SUBPARTITION 1 DMS_TAB_0 200391 200391
39 30408704 space allocated PI_DATTR__TI_PI_DM_TA_3V I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198856 198856
40 30408704 space allocated PI_DATTR__TI_PI_DM_TA_3V I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198838 198838
41 29933280 space used PI_DATTR__TI_PI_DM_TA_3V I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198730 198730
42 29915220 space used DOC_ATTR I597_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197168 197168
43 29360128 space allocated PI_DATTR__FCV_TI_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198213 198213
44 29360128 space allocated PI_DATTR__PI_DM_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199427 199427
45 29360128 space allocated PI_DATTR__TI_PI_DM_TA_3V I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198928 198928
46 28080247 space used PI_DATTR__DM_3V_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197588 197588
47 27630302 space used PI_DATTR__TI_PI_DM_TA_3V I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198874 198874
48 25889682 space used PI_DATTR__FCV_TI_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198159 198159
49 25165824 space allocated DOC_ATTR I585_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197060 197060
50 25165824 space allocated DOC_ATTR I593_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197132 197132
51 25165824 space allocated DOC_ATTR I583_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197042 197042
52 24606560 space used PI_DATTR__PI_DM_3V_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199301 199301
53 24314540 space used PI_DATTR__PI_DM_3V_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199445 199445
54 24117248 space allocated PI_DATTR__DM_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197714 197714
55 24117248 space allocated PI_DATTR__TA_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199998 199998
56 23380574 space used PI_DATTR__FCV_TI_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198393 198393
57 23068672 space allocated PI_DATTR__FCV_TI_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198285 198285
58 22821074 space used PI_DATTR__FCV_TI_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198303 198303
59 22052824 space used DOC_ATTR I585_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197060 197060
60 22020096 space allocated PI_DATTR__PI_DM_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199499 199499
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
61 22020096 space allocated PI_DATTR__TI_PI_DM_TA_3V I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198892 198892
62 20349412 space used PI_DATTR__TA_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200106 200106
63 20023052 space used PI_DATTR__TA_3V_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200016 200016
64 19922944 space allocated PI_DATTR__DM_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197786 197786
65 19922944 space allocated PI_DATTR__FCV_TI_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198357 198357
66 19922944 space allocated PI_DATTR__PI_DM_3V_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199409 199409
67 19922944 space allocated PI_DATTR__TA_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200070 200070
68 19922944 space allocated PI_DATTR__TI_PI_DM_TA_3V I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198766 198766
69 19067070 space used PI_DATTR__TI_PI_DM_TA_3V I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198964 198964
70 19036254 space used PI_DATTR__TA_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199926 199926
71 18906258 space used DOC_ATTR I583_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197042 197042
72 18874368 space allocated PI_DATTR__DM_3V_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197696 197696
73 18874368 space allocated PI_DATTR__FCV_TI_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198267 198267
74 18874368 space allocated PI_DATTR__TA_3V_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199980 199980
75 18789112 space used DOC_ATTR I593_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197132 197132
76 18304850 space used PI_DATTR__FCV_TI_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198213 198213
77 18090266 space used PI_DATTR__PI_DM_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199535 199535
78 17825792 space allocated PI_DATTR__DM_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197750 197750
79 17825792 space allocated PI_DATTR__PI_DM_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199463 199463
80 17825792 space allocated PI_DATTR__TA_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200034 200034
81 17825792 space allocated PI_DATTR__TI_PI_DM_TA_3V I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198910 198910
82 17785554 space used PI_DATTR__DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197642 197642
83 17686062 space used PI_DATTR__PI_DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199355 199355
84 17579424 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2011Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2011 201630 201630
85 16777216 space allocated DOC_ATTR I581_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197024 197024
86 16777216 space allocated DOC_ATTR I591_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197114 197114
87 16777216 space allocated DOC_ATTR I589_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197096 197096
88 16777216 space allocated DOC_ATTR I569_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196916 196916
89 16777216 space allocated DOC_ATTR I575_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196970 196970
90 16777216 space allocated PI_DATTR__FCV_TI_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198321 198321
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
91 16777216 space allocated PI_DATTR__PI_DM_3V_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199337 199337
92 16777216 space allocated PI_DATTR__TI_PI_DM_TA_3V I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198712 198712
93 16777216 space allocated UQ_DOC_TEMPLATES__DID_TID_IID DMS INDEX 1 DMS_IND 62293 236810
94 16777216 space allocated UQ_DOC_TEMPLATES__TID_DID_IID DMS INDEX 1 DMS_IND 62294 236811
95 16362956 space used DOC_ATTR I589_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197096 197096
96 15985820 space used PI_DATTR__PI_DM_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199427 199427
97 15971860 space used I_DRELS__CH_DI_ID_II DMS INDEX 1 DMS_IND 247059 247059
98 15728640 space allocated PI_DATTR__DM_3V_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197624 197624
99 15728640 space allocated PI_DATTR__TA_3V_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199908 199908
100 15728640 space allocated PI_DATTR__TI_PI_DM_TA_3V I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198820 198820
101 15600863 space used PI_DATTR__TI_PI_DM_TA_3V I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198928 198928
102 14967008 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2011Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2011 201629 201629
103 14962912 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2010Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2010 201628 201628
104 14812467 space used PI_DATTR__TI_PI_DM_TA_3V I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198856 198856
105 14680064 space allocated PI_DATTR__FCV_TI_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198195 198195
106 14680064 space allocated PI_DATTR__PI_DM_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199283 199283
107 14680064 space allocated PI_DATTR__PI_DM_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199481 199481
108 14680064 space allocated PI_DATTR__TA_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200052 200052
109 14680064 space allocated PI_DATTR__TI_PI_DM_TA_3V I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198748 198748
110 14413412 space used DOC_ATTR I591_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197114 197114
111 14263648 db block changes I_DRELS__CA_DI_2F_AR_AI_OI DMS INDEX 1 DMS_IND 247058 247058
112 14028714 space used DOC_ATTR I575_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196970 196970
113 13827136 logical reads I_ACL_MBRS__AI_II_OI_OT DMS INDEX 1 DMS_IND 148405 236691
114 13631488 space allocated PI_DATTR__PI_DM_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199319 199319
115 13631488 space allocated PI_DATTR__PI_DM_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199391 199391
116 13631488 space allocated PI_DATTR__TA_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199854 199854
117 12986618 space used PI_DATTR__FCV_TI_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198285 198285
118 12943432 space used DOC_ATTR I569_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196916 196916
119 12582912 space allocated PI_DATTR__DM_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197768 197768
120 12582912 space allocated PI_DATTR__DM_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197678 197678
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
121 12582912 space allocated PI_DATTR__DM_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197570 197570
122 12582912 space allocated PI_DATTR__FCV_TI_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198339 198339
123 12582912 space allocated PI_DATTR__FCV_TI_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198141 198141
124 12582912 space allocated PI_DATTR__TA_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199962 199962
125 12496787 space used PI_DATTR__TA_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199998 199998
126 12463542 space used DOC_ATTR I573_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196952 196952
127 11977571 space used PI_DATTR__TI_PI_DM_TA_3V I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198766 198766
128 11604688 space used DOC_ATTR I581_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197024 197024
129 11534336 space allocated PI_DATTR__DM_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197606 197606
130 11534336 space allocated PI_DATTR__FCV_TI_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198249 198249
131 11534336 space allocated PI_DATTR__TA_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199890 199890
132 11534336 space allocated PI_DATTR__TI_PI_DM_TA_3V I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198802 198802
133 11508336 logical reads DOC_RELATIONS I573_P0 DMS TABLE SUBPARTITION 1 DMS_TAB_0 200445 200445
134 11207682 space used PI_DATTR__FCV_TI_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198267 198267
135 10776423 space used PI_DATTR__FCV_TI_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198357 198357
136 10685330 space used UQ_DOC_TEMPLATES__TID_DID_IID DMS INDEX 1 DMS_IND 62294 236811
137 10507109 space used PI_DATTR__PI_DM_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199499 199499
138 10485760 space allocated PI_DATTR__FCV_TI_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198177 198177
139 10485760 space allocated PI_DATTR__PI_DM_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199373 199373
140 10479791 space used PI_DATTR__TI_PI_DM_TA_3V I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198892 198892
141 10394940 space used UQ_DOC_TEMPLATES__DID_TID_IID DMS INDEX 1 DMS_IND 62293 236810
142 9925574 space used PI_DATTR__PI_DM_3V_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199337 199337
143 9617641 space used PI_DATTR__PI_DM_3V_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199409 199409
144 9556291 space used PI_DATTR__DM_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197786 197786
145 9507425 space used PI_DATTR__DM_3V_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197624 197624
146 9437184 space allocated PI_DATTR__TA_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199944 199944
147 9371272 space used PI_DATTR__TA_3V_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199980 199980
148 8831606 space used PI_DATTR__FCV_TI_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198195 198195
149 8822243 space used PI_DATTR__TI_PI_DM_TA_3V I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198910 198910
150 8782809 space used PI_DATTR__PI_DM_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199463 199463
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
151 8680405 space used PI_DATTR__DM_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197750 197750
152 8672225 space used PI_DATTR__TA_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200034 200034
153 8536286 space used PI_DATTR__FCV_TI_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198321 198321
154 8465330 space used PI_DATTR__TI_PI_DM_TA_3V I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198838 198838
155 8388608 space allocated DOC_ATTR I177_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196898 196898
156 8388608 space allocated DOC_ATTR I573_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196952 196952
157 8388608 space allocated DOC_ATTR I579_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197006 197006
158 8388608 space allocated DOC_TEMPLATES DMS TABLE 1 DMS_TAB 61925 236485
159 8388608 space allocated PI_DATTR__DM_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197660 197660
160 8388608 space allocated PI_DATTR__FCV_TI_DI I591_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198335 198335
161 8388608 space allocated PI_DATTR__FCV_TI_DI I591_P2012Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198336 198336
162 8388608 space allocated PI_DATTR__FCV_TI_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198231 198231
163 8388608 space allocated PI_DATTR__PI_DM_3V_DI I591_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 199476 199476
164 8388608 space allocated PPK_DRELS__ID_II DMS INDEX 1 DMS_IND 203552 203552
165 7715036 space used PI_DATTR__TI_PI_DM_TA_3V I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198748 198748
166 7671015 space used PI_DATTR__TI_PI_DM_TA_3V I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198820 198820
167 7478467 space used PI_DATTR__PI_DM_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199481 199481
168 7404539 space used PI_DATTR__PI_DM_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199319 199319
169 7340068 space used PI_DATTR__TA_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200052 200052
170 7168736 db block changes PI_DATTR__TA_3V_DI I577_P2013Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199925 199925
171 7053152 db block changes PI_DATTR__DM_3V_DI I577_P2013Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197641 197641
172 6996416 db block changes PI_DATTR__PI_DM_3V_DI I577_P2013Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199354 199354
173 6901469 space used PI_DATTR__PI_DM_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199391 199391
174 6901126 space used PI_DATTR__PI_DM_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199283 199283
175 6892080 db block changes PI_DATTR__FCV_TI_DI I577_P2013Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198212 198212
176 6888208 db block changes DOC_ATTR I577_P2013Q2 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196987 196987
177 6842112 db block changes PI_DATTR__TI_PI_DM_TA_3V I577_P2013Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198783 198783
178 6781547 space used PI_DATTR__TA_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199854 199854
179 6715635 space used PI_DATTR__FCV_TI_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198249 198249
180 6592438 space used PI_DATTR__TA_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199962 199962
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
181 6527813 space used PI_DATTR__FCV_TI_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198141 198141
182 6468769 space used PI_DATTR__DM_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197606 197606
183 6291456 space allocated PI_DATTR__PI_DM_3V_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199265 199265
184 6291456 space allocated PI_DATTR__TI_PI_DM_TA_3V I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198694 198694
185 6278056 space used DOC_ATTR I177_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196898 196898
186 6264269 space used PI_DATTR__TI_PI_DM_TA_3V I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198802 198802
187 6214846 space used PI_DATTR__DM_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197768 197768
188 6208475 space used PI_DATTR__DM_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197678 197678
189 6007568 space used PI_DATTR__DM_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197570 197570
190 5964730 space used PI_DATTR__PI_DM_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199373 199373
191 5867310 space used PI_DATTR__DM_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197822 197822
192 5752050 space used PI_DATTR__FCV_TI_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198177 198177
193 5541104 logical reads DOC_ATTR I577_P2013Q2 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196987 196987
194 5525808 logical reads PPK_DRELS__ID_II DMS INDEX 1 DMS_IND 203552 203552
195 5242880 space allocated PI_DATTR__FCV_TI_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198123 198123
196 5242880 space allocated PI_DATTR__TA_3V_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199836 199836
197 5193072 space used PPK_DRELS__ID_II DMS INDEX 1 DMS_IND 203552 203552
198 4674442 space used PI_DATTR__FCV_TI_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198231 198231
199 4506752 space used PI_DATTR__DM_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197660 197660
200 4411744 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 201634 201634
201 4395728 logical reads UQ_DOC_TEMPLATES__TID_DID_IID DMS INDEX 1 DMS_IND 62294 236811
202 4395648 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2012Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 201633 201633
203 4241072 logical reads DOC_RELATIONS I177_P0 DMS TABLE SUBPARTITION 1 DMS_TAB_0 200391 200391
204 4194304 space allocated PI_DATTR__DM_3V_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197552 197552
205 4194304 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I577_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201052 201052
206 3905312 space used DOC_TEMPLATES DMS TABLE 1 DMS_TAB 61925 236485
207 3896064 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2011Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2011 201632 201632
208 3892528 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201639 201639
209 3719534 space used PI_DATTR__TI_PI_DM_TA_3V I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198694 198694
210 3695491 space used PI_DATTR__PI_DM_3V_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199265 199265
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
211 3654770 space used PI_DATTR__FCV_TI_DI I591_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198335 198335
212 3424085 space used PI_DATTR__FCV_TI_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198123 198123
213 3246560 logical reads DOC_ATTR I577_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196988 196988
214 3145728 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201014 201014
215 3063456 db block changes DOC_ATTR I577_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196988 196988
216 2933782 space used PI_DATTR__DM_3V_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197552 197552
217 2887659 space used PI_DATTR__TI_PI_DM_TA_3V I591_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198906 198906
218 2852976 space used PI_DATTR__TI_PI_DM_TA_3V I591_P2012Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198904 198904
219 2771808 logical reads PI_DRELS__DI_RI_FD_2RT I577_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201623 201623
220 2761505 space used PI_DATTR__TA_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200070 200070
221 2724832 db block changes PI_DATTR__FCV_TI_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198213 198213
222 2669888 db block changes PI_DATTR__TA_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199926 199926
223 2639056 db block changes PI_DATTR__PI_DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199355 199355
224 2637744 db block changes PI_DATTR__DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197642 197642
225 2503696 space used PI_DATTR__TA_3V_DI I591_P2012Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 200049 200049
226 2491426 space used PI_DATTR__DM_3V_DI I591_P2012Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 197762 197762
227 2409954 space used PI_DATTR__PI_DM_3V_DI I591_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 199476 199476
228 2317424 logical reads DOC_ATTR I571_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196934 196934
229 2286160 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2010Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2010 201626 201626
230 2251592 space used PI_DATTR__TA_3V_DI I591_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 200047 200047
231 2208704 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2013Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201637 201637
232 2206864 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2011Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2011 201631 201631
233 2203056 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2010Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2010 201627 201627
234 2170640 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2013Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201638 201638
235 2168798 space used PI_DATTR__FCV_TI_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198339 198339
236 2125836 space used DOC_ATTR I579_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197006 197006
237 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I571_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 200998 200998
238 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201158 201158
239 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201122 201122
240 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I587_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201142 201142
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
241 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201068 201068
242 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201248 201248
243 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I597_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201232 201232
244 2093230 space used PI_DATTR__TA_3V_DI I591_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 200048 200048
245 2088960 logical reads PI_DRELS__DI_RI_FD_2RT I597_P2012Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 201813 201813
246 2074574 space used PI_DATTR__DM_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197714 197714
247 1960240 logical reads DOC_ATTR I177_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196898 196898
248 1950992 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2013Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201640 201640
249 1881529 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201014 201014
250 1642028 space used PI_DATTR__DM_3V_DI I591_P2013Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197767 197767
251 1602662 physical read requests PI_DATTR__DI_TA_3V DMS INDEX 1 DMS_IND 197188 197188
252 1600964 space used PI_DATTR__FCV_TI_DI I591_P2012Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198333 198333
253 1598504 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201158 201158
254 1564704 logical reads PI_DRELS__DI_RI_FD_2RT I177_P2011Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2011 201542 201542
255 1494445 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I577_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201052 201052
256 1441792 space allocated PI_DRELS__RT_RT I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 203298 203298
257 1417078 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201248 201248
258 1414720 logical reads DOC_ATTR I573_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196952 196952
259 1335411 physical writes PI_DATTR__DI_TA_3V DMS INDEX 1 DMS_IND 197188 197188
260 1320896 logical reads PI_DATTR__TA_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199926 199926
261 1310720 space allocated PI_DRELS__RI_2RT_FD I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 202853 202853
262 1282681 physical write requests PI_DATTR__DI_TA_3V DMS INDEX 1 DMS_IND 197188 197188
263 1245184 space allocated PI_DRELS__DI_RI_FD_2RT I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201711 201711
264 1245184 space allocated PI_DRELS__RI_2RT_FD I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 202961 202961
265 1228287 space used PI_DATTR__TI_PI_DM_TA_3V I591_P2012Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198907 198907
266 1179648 space allocated PI_DRELS__DI_RI_FD_2RT I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201819 201819
267 1179648 space allocated PI_DRELS__FD_RI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 202300 202300
268 1121132 space used PI_DATTR__DM_3V_DI I591_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 197764 197764
269 1115233 space used PI_DATTR__TA_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199890 199890
270 1114112 space allocated PI_DRELS__DI_RI_FD_2RT I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201639 201639
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
271 1114112 space allocated PI_DRELS__RI_2RT_FD I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 202781 202781
272 1108816 logical reads PI_DRELS__DI_RI_FD_2RT I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201585 201585
273 1108592 logical reads I_DOC_MBRS__DI_UI_II DMS INDEX 1 DMS_IND 184043 184043
274 1098480 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 201635 201635
275 1098368 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2010Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2010 201625 201625
276 1092112 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2012Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 201636 201636
277 1079056 space used DOC_RELATIONS I587_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 200587 200587
278 1077608 space used PI_DATTR__TI_PI_DM_TA_3V I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198712 198712
279 1075978 space used PI_DATTR__PI_DM_3V_DI I591_P2012Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 199478 199478
280 1048576 space allocated PI_DATTR__FCV_TI_DI I177_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198118 198118
281 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I177_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 200962 200962
282 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I573_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201016 201016
283 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I585_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201124 201124
284 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I593_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201196 201196
285 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201212 201212
286 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201176 201176
287 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I583_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201106 201106
288 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I589_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201160 201160
289 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I581_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201088 201088
290 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I591_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201178 201178
291 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201050 201050
292 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201140 201140
293 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I575_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201034 201034
294 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200996 200996
295 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I569_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 200980 200980
296 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201032 201032
297 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200978 200978
298 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I123_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 200818 200818
299 1048576 space allocated PI_DRELS__DI_RI_FD_2RT I585_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201695 201695
300 1048576 space allocated PI_DRELS__FD_RI I177_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 202104 202104
Go to Top

Session Statistics

Statistics below include the execution of your SQL within "script2f.sql".
SQLT XECUTE took snapshots of GV$SESSTAT right before and after your script was executed.
Metrics below are for that interval. List is restricted up to 1000 rows as per tool parameter "r_rows_table_l".
SQL: [+]
# Class Name Statistic Name Value Inst ID
1 Cache commit cleanout failures: callback failure 1 1
2 Cache commit cleanouts 742 1
3 Cache commit cleanouts successfully completed 741 1
4 Cache consistent gets 520 1
5 Cache consistent gets - examination 190 1
6 Cache consistent gets from cache 520 1
7 Cache consistent gets from cache (fastpath) 300 1
8 Cache db block changes 135 1
9 Cache db block gets 153 1
10 Cache db block gets from cache 153 1
11 Cache db block gets from cache (fastpath) 37 1
12 Cache free buffer requested 52 1
13 Cache logical read bytes from cache 11026432 1
14 Cache physical read IO requests 41 1
15 Cache physical read bytes 671744 1
16 Cache physical read total IO requests 41 1
17 Cache physical read total bytes 671744 1
18 Cache physical reads 41 1
19 Cache physical reads cache 41 1
20 Cache shared hash latch upgrades - no wait 22 1
21 Cache switch current to new buffer 2 1
22 Cache, SQL buffer is not pinned count 281 1
23 Cache, SQL buffer is pinned count 22 1
24 Debug CPU used when call started 650 1
25 Debug Commit SCN cached 1 1
26 Debug IMU Flushes 1 1
27 Debug IMU Redo allocation size 35100 1
28 Debug IMU commits 4 1
29 Debug IMU pool not allocated 3 1
30 Debug IMU undo allocation size 9872 1
# Class Name Statistic Name Value Inst ID
31 Debug IMU- failed to get a private strand 3 1
32 Debug active txn count during cleanout 3 1
33 Debug calls to kcmgas 19 1
34 Debug calls to kcmgcs 53 1
35 Debug cleanout - number of ktugct calls 3 1
36 Debug commit txn count during cleanout 1 1
37 Debug cursor authentications 3 1
38 Debug deferred (CURRENT) block cleanout applications 7 1
39 Debug immediate (CURRENT) block cleanout applications 2 1
40 Debug index fetch by key 44 1
41 Debug index scans kdiixs1 107 1
42 Debug leaf node 90-10 splits 1 1
43 Debug leaf node splits 1 1
44 Debug messages sent 6 1
45 Debug no work - consistent read gets 242 1
46 Debug undo change vector size 34908 1
47 Enqueue enqueue releases 64 1
48 Enqueue enqueue requests 51 1
49 RAC calls to get snapshot scn: kcmgss 143 1
50 Redo redo entries 77 1
51 Redo redo ordering marks 5 1
52 Redo redo size 108472 1
53 Redo redo subscn max counts 15 1
54 Redo redo synch writes 1 1
55 SQL HSC Heap Segment Block Changes 13 1
56 SQL Heap Segment Array Inserts 5 1
57 SQL Heap Segment Array Updates 1 1
58 SQL cell physical IO interconnect bytes 671744 1
59 SQL cluster key scan block gets 29 1
60 SQL cluster key scans 25 1
# Class Name Statistic Name Value Inst ID
61 SQL execute count 131 1
62 SQL parse count (hard) 22 1
63 SQL parse count (total) 44 1
64 SQL parse time cpu 11 1
65 SQL parse time elapsed 40 1
66 SQL rows fetched via callback 13 1
67 SQL session cursor cache hits 107 1
68 SQL sorts (memory) 43 1
69 SQL sorts (rows) 75 1
70 SQL table fetch by rowid 62 1
71 SQL table scan blocks gotten 16 1
72 SQL table scan rows gotten 304 1
73 SQL table scans (short tables) 16 1
74 SQL workarea executions - optimal 17 1
75 User CPU used by this session 80 1
76 User DB time 931 1
77 User Requests to/from client 22 1
78 User SQL*Net roundtrips to/from client 23 1
79 User bytes received via SQL*Net from client 12963 1
80 User bytes sent via SQL*Net to client 9135 1
81 User file io wait time 585554 1
82 User non-idle wait count 70 1
83 User non-idle wait time 82 1
84 User opened cursors cumulative 147 1
85 User recursive calls 643 1
86 User recursive cpu usage 55 1
87 User session logical reads 673 1
88 User session pga memory 3367024 1
89 User session uga memory 1697184 1
90 User user I/O wait time 82 1
# Class Name Statistic Name Value Inst ID
91 User user calls 40 1
92 User user commits 7 1
Go to Top

Session Events

Statistics below include the execution of your SQL within "script2f.sql".
SQLT XECUTE took snapshots of GV$SESSION_EVENT right before and after your script was executed. Metrics below are for that interval.
# Seconds Waited Event Name Inst ID Total Waits Avg Wait in seconds Total Timeouts
1 0.741186 db file sequential read 1 49 0.015126 0
2 0.234579 Disk file operations I/O 1 6 0.039097 0
3 0.072996 db file scattered read 1 22 0.003318 0
4 0.061015 db file parallel read 1 2 0.030508 0
5 0.031412 control file sequential read 1 42 0.000748 0
6 0.028576 SQL*Net message from client 1 23 0.001242 0
7 0.020223 undo segment extension 1 4 0.005056 3
8 0.017555 utl_file I/O 1 54 0.000325 0
9 0.009840 direct path read 1 4 0.002460 0
10 0.007414 SQL*Net break/reset to client 1 2 0.003707 0
11 0.001244 direct path write temp 1 2 0.000622 0
12 0.000734 buffer busy waits 1 12 0.000061 0
13 0.000722 events in waitclass Other 1 33 0.000022 9
14 0.000365 log file sync 1 1 0.000365 0
15 0.000069 BFILE read 1 6 0.000012 0
16 0.000044 SQL*Net message to client 1 23 0.000002 0
Go to Top

Parallel Processing

Go to Top

PX Operation Statistics

Statistics for parallel-execution operations within the execution plan. Captured after the execution of your SQL within "script2f.sql".
List restricted up to 1000 rows as per tool parameter "r_rows_table_l".
SQL: [+]
Go to Parallel Processing
Go to Top

PX Instance Groups

Parallel-execution instance groups available to current session (SID=55). Captured after the execution of your SQL within "script2f.sql".
Go to Parallel Processing
Go to Top

Active PX Servers

Statistics for active parallel-execution servers. Captured before and after the execution of your SQL within "script2f.sql".
SQLT XECUTE took snapshots of GV$PQ_SLAVE right before and after your script was executed. Metrics below are for that interval.
Be aware that GV$PQ_SLAVE statistics are restricted to your session (SID=55).
SQL: [+]
Go to Parallel Processing
Go to Top

PX Processes

Parallel-execution processes, and sessions running on them. Captured after the execution of your SQL within "script2f.sql".
SQLT XECUTE took a snapshot of GV$PX_PROCESS right after your script was executed. Metrics below are for that snapshot.
Be aware that GV$PX_PROCESS statistics are not restricted to your session (SID=55).
SQL: [+]
(1) If the PX Server is in use.
Go to Parallel Processing
Go to Top

PX Sessions

Sessions running on parallel-execution servers. Captured after the execution of your SQL within "script2f.sql".
SQLT XECUTE took a snapshot of GV$PX_SESSION right after your script was executed. Metrics below are for that snapshot.
Be aware that GV$PX_SESSION statistics are not restricted to your session (SID=55).
SQL: [+]
(1) NULL for Query Coordinator.
Go to Parallel Processing
Go to Top

PX System Statistics - Summary

System statistics for parallel-execution servers. Captured before and after the execution of your SQL within "script2f.sql".
SQLT XECUTE took snapshots of GV$PQ_SYSSTAT right before and after your script was executed. Metrics below are for that interval.
Be aware that GV$PQ_SYSSTAT statistics are not session specific. Therefore, use the statitics below with caution since they may include work from other active sessions.
Statistic Inst ID Value Before Value After Difference
Servers Busy : 1 0 0 0
Servers Idle : 1 0 0 0
Servers Highwater : 1 128 128 0
Server Sessions : 1 36600 36600 0
Servers Started : 1 532 532 0
Servers Shutdown : 1 532 532 0
Servers Cleaned Up : 1 0 0 0
Queries Queued : 1 0 0 0
Queries Initiated : 1 854 854 0
Queries Initiated (IPQ) : 1 0 0 0
DML Initiated : 1 0 0 0
DML Initiated (IPQ) : 1 0 0 0
DDL Initiated : 1 0 0 0
DDL Initiated (IPQ) : 1 0 0 0
DFO Trees : 1 854 854 0
Sessions Active : 1 0 0 0
Local Msgs Sent : 1 164612007 164612007 0
Distr Msgs Sent : 1 0 0 0
Local Msgs Recv'd : 1 164645692 164645692 0
Distr Msgs Recv'd : 1 0 0 0
Go to Parallel Processing
Go to Top

PX Process System Statistics - Summary

Process system statistics for parallel-execution servers. Captured before and after the execution of your SQL within "script2f.sql".
SQLT XECUTE took snapshots of GV$PX_PROCESS_SYSSTAT right before and after your script was executed. Metrics below are for that interval.
Be aware that GV$PX_PROCESS_SYSSTAT statistics are not session specific. Therefore, use the statitics below with caution since they may include work from other active sessions.
Statistic Inst ID Value Before Value After Difference
Servers In Use : 1 0 0 0
Servers Available : 1 0 0 0
Servers Started : 1 532 532 0
Servers Shutdown : 1 532 532 0
Servers Highwater : 1 128 128 0
Servers Cleaned Up : 1 0 0 0
Server Sessions : 1 36600 36600 0
Memory Chunks Allocated : 1 790 790 0
Memory Chunks Freed : 1 786 786 0
Memory Chunks Current : 1 4 4 0
Memory Chunks HWM : 1 58 58 0
Buffers Allocated : 1 1659871 1659871 0
Buffers Freed : 1 1659871 1659871 0
Buffers Current : 1 0 0 0
Buffers HWM : 1 6898 6898 0
Go to Parallel Processing
Go to Top

PX Session Statistics - Summary

Session statistics for Query Coordinator with SID of 55. Captured after the execution of your SQL within "script2f.sql".
SQLT XECUTE took snapshots of GV$PQ_SESSTAT right after your script was executed. Metrics below are for that snapshot.
Statistic Inst ID Last Query Session Total
Queries Parallelized: 1 0 0
DML Parallelized: 1 0 0
DDL Parallelized: 1 0 0
DFO Trees: 1 0 0
Server Threads: 1 0 0
Allocation Height: 1 0 0
Allocation Width: 1 0 0
Local Msgs Sent: 1 0 0
Distr Msgs Sent: 1 0 0
Local Msgs Recv'd: 1 0 0
Distr Msgs Recv'd: 1 0 0
Go to Parallel Processing
Go to Top

PX Session Statistics - Detail

Session statistics for parallel-execution servers under Query Coordinator with SID of 55. Captured before and after the execution of your SQL within "script2f.sql".
SQLT XECUTE took snapshots of GV$PX_SESSTAT right before and after your script was executed. Metrics below are for that interval.
List restricted up to 1000 rows as per tool parameter "r_rows_table_l".
SQL: [+]
(1) NULL for Query Coordinator.
Go to Parallel Processing
Go to Top

Tables

# Table Name Owner Count1 Num
Rows2
Sample
Size2
Blocks2 Last
Analyzed2
Table
Stats
Table
Stats
Versn
Table
Modif
Table
Prop
Table
Phys
Prop
Table
Cons
Table
Cols
Idxed
Cols
Table
Hgrm
Part
Key
Cols
Table
Part
Indexes Table
Meta
1 ACMTT_ACL_MEMBERS DMS 14100 14079 14079 32 26-JUL-13 Stats 2   Prop Phys 2 6 5 4     2 Meta
2 DOC_ATTR DMS 323900000 317078196 317078196 2416604 25-JUL-13 Stats 3 Modif Prop Phys 3 14 8 10 PKey 30 6 Meta
3 DOC_MEMBERS DMS 0 0 0 0 25-JUL-13 Stats 2   Prop Phys 4 5 3       1 Meta
4 DOC_RELATIONS DMS 16590000 17181186 17181186 169732 25-JUL-13 Stats 3 Modif Prop Phys 2 18 13 12 PKey 30 8 Meta
5 DOC_TEMPLATES DMS 18920000 19609772 19609772 30712 25-JUL-13 Stats 2 Modif Prop Phys 2 4 3 3     2 Meta
6 GROUP_MEMBERS DMS 34140 33911 33911 51 25-JUL-13 Stats 2 Modif Prop Phys 5 6 4 3     2 Meta
(1) SELECT COUNT(*) performed in Table as per tool parameter "count_star_threshold" with current value of 10000.
(2) CBO Statistics.
Go to Indexed Columns
Go to Indexes
Go to Top

Table Statistics

# Table Name Owner Part Temp Count1 Num Rows2 Sample Size2 Perc Last Analyzed2 Segment Extents Segment Blocks Total Segment Blocks3 DBMS_SPACE Allocated Blocks4 Blocks2 Empty Blocks Avg Space Avg Row Len2 Chain Cnt Global Stats2 User Stats2 Stat Type Locked Stale Stats Avg Space Freelist Blocks Num Freelist Blocks Avg Cached Blocks Avg Cache Hit Ratio Full Table Scan Cost
1 ACMTT_ACL_MEMBERS DMS NO N 14100 14079 14079 100.0 2013-07-26/14:15:03 7 32 32 24 32 0 0 21 0 YES NO NO 0 0 13
2 DOC_ATTR DMS YES N 323900000 317078196 317078196 100.0 2013-07-25/19:46:33 2582592 2416604 176117 1799 102 0 YES NO NO 0 0 911473
3 DOC_MEMBERS DMS NO N 0 0 0 2013-07-25/17:01:38 2 12 12 0 0 0 0 0 YES NO NO 0 0 2
4 DOC_RELATIONS DMS YES N 16590000 17181186 17181186 100.0 2013-07-25/17:27:03 339968 169732 187176 2643 99 0 YES NO NO 0 0 63995
5 DOC_TEMPLATES DMS NO N 18920000 19609772 19609772 100.0 2013-07-25/17:03:04 130 30720 30720 26112 30712 0 0 17 0 YES NO NO 0 0 11669
6 GROUP_MEMBERS DMS NO N 34140 33911 33911 100.0 2013-07-25/17:01:49 12 52 52 44 51 0 0 15 0 YES NO NO 0 0 21
(1) SELECT COUNT(*) performed in Table as per tool parameter "count_star_threshold" with current value of 10000.
(2) CBO Statistics.
(3) It considers the blocks from all partitions (if the table is partitioned).
(4) This is the estimated size of the table if it were rebuilt, as computed by DBMS_SPACE.CREATE_TABLE_COST.
Go to Table Statistics Versions
Go to Tables
Go to Top

Table Statistics Versions

List of pending, current and historic CBO statistics, restricted up to 1000 rows as per tool parameter "r_rows_table_l".
SQL: [+]
# Table Name Owner Version Type Save Time Last Analyzed Num Rows Sample Size Perc Blocks Avg Row Len
1 ACMTT_ACL_MEMBERS DMS CURRENT 2013-07-26/14:15:03 14079 14079 100.0 32 21
2 ACMTT_ACL_MEMBERS DMS HISTORY 2013-07-26/14:15:03.790706 +02:00 2013-02-21/23:01:06 13754 13754 100.0 28 21
3 DOC_ATTR DMS CURRENT 2013-07-25/19:46:33 317078196 317078196 100.0 2416604 102
4 DOC_ATTR DMS HISTORY 2013-07-25/19:46:33.746239 +02:00 2013-07-24/23:30:07 316791891 316791891 100.0 2414072 102
5 DOC_ATTR DMS HISTORY 2013-07-24/23:30:08.013847 +02:00 2013-07-01/23:28:30 311084018 311084018 100.0 2366664 102
6 DOC_MEMBERS DMS CURRENT 2013-07-25/17:01:38 0 0 0 0
7 DOC_MEMBERS DMS HISTORY 2013-07-25/17:01:38.930286 +02:00 2012-11-22/23:00:09 0 0 0 0
8 DOC_RELATIONS DMS CURRENT 2013-07-25/17:27:03 17181186 17181186 100.0 169732 99
9 DOC_RELATIONS DMS HISTORY 2013-07-25/17:27:03.599309 +02:00 2013-07-22/23:04:36 17119063 17119063 100.0 169284 99
10 DOC_RELATIONS DMS HISTORY 2013-07-22/23:04:36.632407 +02:00 2013-07-09/23:03:34 16929155 16929155 100.0 167574 99
11 DOC_TEMPLATES DMS CURRENT 2013-07-25/17:03:04 19609772 19609772 100.0 30712 17
12 DOC_TEMPLATES DMS HISTORY 2013-07-25/17:03:04.296293 +02:00 2013-06-17/23:04:40 18985420 18985420 100.0 29692 17
13 GROUP_MEMBERS DMS CURRENT 2013-07-25/17:01:49 33911 33911 100.0 51 15
14 GROUP_MEMBERS DMS HISTORY 2013-07-25/17:01:49.934074 +02:00 2013-06-07/23:01:08 33346 33346 100.0 51 15
Go to Table Statistics
Go to Tables
Go to Top

Table Modifications

# Table Name Owner Num Rows Inserts Updates Deletes Total Perc Stale Stats Timestamp Truncated Drop Segments
1 ACMTT_ACL_MEMBERS DMS 14079 NO
2 DOC_ATTR DMS 317078196 1893358 282109 1633150 3808617 1.2 NO 2013-07-29/00:10:23 NO 0
3 DOC_MEMBERS DMS 0 NO
4 DOC_RELATIONS DMS 17181186 31307 135278 16678 183263 1.1 NO 2013-07-29/00:10:23 NO 0
5 DOC_TEMPLATES DMS 19609772 29169 2900 12929 44998 0.2 NO 2013-07-29/00:10:23 NO 0
6 GROUP_MEMBERS DMS 33911 37 0 122 159 0.5 NO 2013-07-26/14:15:02 NO 0
Go to Tables
Go to Top

Table Properties

# Table Name Owner Part Degree Instances Temp Duration IOT Name IOT Type Cluster Name Cluster Owner Nested Secondary Cache Result Cache Table Lock Read Only Row Movement Skip Corrupt Dependencies Monitoring Status Dropped Segment Created
1 ACMTT_ACL_MEMBERS DMS NO 1 1 N NO N N DEFAULT ENABLED NO DISABLED DISABLED DISABLED YES VALID NO YES
2 DOC_ATTR DMS YES 1 1 N NO N N DEFAULT ENABLED NO DISABLED DISABLED DISABLED YES VALID NO N/A
3 DOC_MEMBERS DMS NO 1 1 N NO N N DEFAULT ENABLED NO DISABLED DISABLED DISABLED YES VALID NO YES
4 DOC_RELATIONS DMS YES 1 1 N NO N N DEFAULT ENABLED NO DISABLED DISABLED DISABLED YES VALID NO N/A
5 DOC_TEMPLATES DMS NO 1 1 N NO N N DEFAULT ENABLED NO DISABLED DISABLED DISABLED YES VALID NO YES
6 GROUP_MEMBERS DMS NO 1 1 N NO N N DEFAULT ENABLED NO DISABLED DISABLED DISABLED YES VALID NO YES
Go to Tables
Go to Top

Table Physical Properties

# Table Name Owner Pct Free Pct Used Ini Trans Max Trans Initial Extent Next Extent Min Extents Max Extents Pct Increase Free Lists Free List Groups Logging Backed Up Buffer Pool Flash Cache Cell Flash Cache TableSpace Name Compression Compress for
1 ACMTT_ACL_MEMBERS DMS 10 1 255 163840 163840 1 2147483645 YES N DEFAULT DEFAULT DEFAULT DMS_TAB DISABLED
2 DOC_ATTR DMS N DEFAULT DEFAULT DEFAULT
3 DOC_MEMBERS DMS 10 1 255 163840 163840 1 2147483645 YES N DEFAULT DEFAULT DEFAULT DMS_TAB DISABLED
4 DOC_RELATIONS DMS N DEFAULT DEFAULT DEFAULT
5 DOC_TEMPLATES DMS 10 1 255 163840 163840 1 2147483645 YES N DEFAULT DEFAULT DEFAULT DMS_TAB DISABLED
6 GROUP_MEMBERS DMS 10 1 255 81920 65536 1 2147483645 YES N DEFAULT DEFAULT DEFAULT DMS_TAB DISABLED
Go to Tables
Go to Top

Table Constraints

Go to Tables
Go to Top

DMS.ACMTT_ACL_MEMBERS - Table Constraints

# Type Constraint Name Search Condition Last Change Status Deferrable Deferred Validated Generated Refer Owner Refer Constr Name Refer Table Delete Rule Index Owner Index Name Bad Rely Invalid View Related
1 C SYS_C004422"INSTANCE_ID" IS NOT NULL 2009-10-22/10:42:38 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
2 R FK_ACL_MBRS__AID_IID 2009-10-22/10:43:04 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME DMS PK_ACL__AID_IID CASCADE
Go to Table Constraints

DMS.DOC_ATTR - Table Constraints

# Type Constraint Name Search Condition Last Change Status Deferrable Deferred Validated Generated Refer Owner Refer Constr Name Refer Table Delete Rule Index Owner Index Name Bad Rely Invalid View Related
1 C SYS_C0069708"DOC_ID" IS NOT NULL 2013-02-01/17:44:24 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
2 C SYS_C0069709"DOMAIN_ID" IS NOT NULL 2013-02-01/17:44:24 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
3 C SYS_C0069710"INSTANCE_ID" IS NOT NULL 2013-02-01/17:44:24 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
Go to Table Constraints

DMS.DOC_MEMBERS - Table Constraints

# Type Constraint Name Search Condition Last Change Status Deferrable Deferred Validated Generated Refer Owner Refer Constr Name Refer Table Delete Rule Index Owner Index Name Bad Rely Invalid View Related
1 C SYS_C0063470"DOC_ID" IS NOT NULL 2012-11-22/16:45:42 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
2 C SYS_C0063471"USER_ID" IS NOT NULL 2012-11-22/16:45:42 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
3 C SYS_C0063472"ACCESS_MASK" IS NOT NULL 2012-11-22/16:45:42 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
4 C SYS_C0063473"INSTANCE_ID" IS NOT NULL 2012-11-22/16:45:42 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
Go to Table Constraints

DMS.DOC_RELATIONS - Table Constraints

# Type Constraint Name Search Condition Last Change Status Deferrable Deferred Validated Generated Refer Owner Refer Constr Name Refer Table Delete Rule Index Owner Index Name Bad Rely Invalid View Related
1 C SYS_C0069711"INSTANCE_ID" IS NOT NULL 2013-02-03/01:14:25 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
2 P PPK_DRELS__ID_II 2013-02-03/01:51:04 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME   DMS PPK_DRELS__ID_II
Go to Table Constraints

DMS.DOC_TEMPLATES - Table Constraints

# Type Constraint Name Search Condition Last Change Status Deferrable Deferred Validated Generated Refer Owner Refer Constr Name Refer Table Delete Rule Index Owner Index Name Bad Rely Invalid View Related
1 C SYS_C004485"INSTANCE_ID" IS NOT NULL 2009-10-22/10:42:40 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
2 R FK_DOC_TEMPLATES__TID_IID 2009-10-22/12:26:57 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME DMS PK_TEMPLATE__TID_IID NO ACTION
Go to Table Constraints

DMS.GROUP_MEMBERS - Table Constraints

# Type Constraint Name Search Condition Last Change Status Deferrable Deferred Validated Generated Refer Owner Refer Constr Name Refer Table Delete Rule Index Owner Index Name Bad Rely Invalid View Related
1 C SYS_C004503"GROUP_ID" IS NOT NULL 2009-10-22/10:42:40 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
2 C SYS_C004504"USER_ID" IS NOT NULL 2009-10-22/10:42:40 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
3 C SYS_C004505"INSTANCE_ID" IS NOT NULL 2009-10-22/10:42:40 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
4 R FK_GMBRS_UI_II__USERS_UI_II 2009-10-22/10:43:04 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME DMS PK_USERS__UID_IID NO ACTION
5 R FK_GROUP_MEMBERS__GID_IID 2009-10-22/10:43:04 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME DMS PK_GROUPS__GID_IID CASCADE
Go to Table Constraints
Go to Tables
Go to Top

Table Columns

# Table Name Owner Count1 Num
Rows2
Sample
Size2
Blocks2 Last
Analyzed2
Column
Stats
Column
Stats
Versn
Column
Usage
Column
Prop
Hgrm
1 ACMTT_ACL_MEMBERS DMS 14100 14079 14079 32 26-JUL-13 6 6 6 Prop 4
2 DOC_ATTR DMS 323900000 317078196 317078196 2416604 25-JUL-13 14 9 13 Prop 10
3 DOC_MEMBERS DMS 0 0 0 0 25-JUL-13 5 4 4 Prop  
4 DOC_RELATIONS DMS 16590000 17181186 17181186 169732 25-JUL-13 18 13 18 Prop 12
5 DOC_TEMPLATES DMS 18920000 19609772 19609772 30712 25-JUL-13 4 3 4 Prop 3
6 GROUP_MEMBERS DMS 34140 33911 33911 51 25-JUL-13 6 4 5 Prop 3
(1) SELECT COUNT(*) performed in Table as per tool parameter "count_star_threshold" with current value of 10000.
(2) CBO Statistics.
Go to Tables
Go to Top

DMS.ACMTT_ACL_MEMBERS - Table Column

Go to Table Columns
Go to Tables
Go to Top

DMS.ACMTT_ACL_MEMBERS - Column Statistics

# In Pred In Index In Proj Col ID Column Name Data Default Not Null with Default Value Num Rows Num Nulls Sample Size Perc Num Distinct Fluctuating NDV1 Low Value2 High Value2 Last Analyzed Avg Col Len Density Num Buckets Histogram Fluctuating Endpoint Count3 Popular Values Global Stats User Stats Equality Predicate Selectivity Equality Predicate Cardinality
1 [+] [+] TRUE 3 OBJECT_ID   14079 1360 12719 100.0 1773 FALSE"-23""17976" 2013-07-26/14:15:03 4 1.157510e-03 254 HEIGHT BALANCED FALSE 8 YES NO 0.000510 8
2 [+]