215187.1 SQLT XECUTE 11.4.5.10  Report: sqlt_s29545_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:38:05

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 Single-block read time of 14 milliseconds differs for more than 10% from actual db file sequential read wait time of 41.137 milliseconds. [+]
10 STATEMENT RESPONSE TIME Execution of this statement took +00 00:00:00.440514. This is wall clock time. [+]
11 TABLE DMS.ACMTT_ACL_MEMBERS Table rebuild candidate. [+]
12 TABLE SUBPARTITION DMS.DOC_ATTR Table contains 22 subpartitions with fluctuating number of rows. [+]
13 TABLE DMS.DOC_ATTR Table contains 1 column(s) referenced in predicates with no popular values on a "HEIGHT BALANCED" histogram. [+]
14 TABLE DMS.DOC_RELATIONS Table has more empty blocks (187176) than actual blocks (169732) according to CBO statistics. [+]
15 TABLE SUBPARTITION DMS.DOC_RELATIONS Table contains 22 subpartitions with fluctuating number of rows. [+]
16 TABLE DMS.DOC_TEMPLATES Table rebuild candidate. [+]
17 TABLE DMS.GROUP_MEMBERS Table rebuild candidate. [+]
18 TABLE DMS.GROUP_MEMBERS Table contains 1 column(s) referenced in predicates with no popular values on a "HEIGHT BALANCED" histogram. [+]
19 TABLE PARTITION DMS.DOC_ATTR 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
20 TABLE PARTITION DMS.DOC_RELATIONS 1 out of 30 partition(s) with number of rows equal to zero according to partition's CBO statistics. [+]
21 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. [+]
22 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. [+]
23 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. [+]
24 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. [+]
25 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. [+]
26 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. [+]
27 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. [+]
28 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. [+]
29 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. [+]
30 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. [+]
# Type Name Observation Details
31 TABLE COLUMN ACMTT_ACL_MEMBERS.ACCESS_MASK Column is referenced in predicate(s) and it is not included in any index. [+]
32 TABLE COLUMN ACMTT_ACL_MEMBERS.ACCESS_MASK Column is candidate for NOT NULL constraint. [+]
33 TABLE COLUMN ACMTT_ACL_MEMBERS.ACL_ID Column is candidate for NOT NULL constraint. [+]
34 TABLE COLUMN ACMTT_ACL_MEMBERS.OBJECT_TYPE Column is candidate for NOT NULL constraint. [+]
35 TABLE COLUMN DOC_ATTR.INSTANCE_ID Column is referenced in predicate(s) and it is not included in any index. [+]
36 TABLE COLUMN DOC_ATTR.PARENT_ID Column is candidate for NOT NULL constraint. [+]
37 TABLE COLUMN DOC_ATTR.TA_ID Height-balanced histogram with no popular values. [+]
38 TABLE COLUMN DOC_ATTR.TA_ID Column is candidate for NOT NULL constraint. [+]
39 TABLE COLUMN DOC_ATTR.TEMPLATE_ID Column is candidate for NOT NULL constraint. [+]
40 TABLE COLUMN DOC_MEMBERS.ACCESS_MASK Column is referenced in predicate(s) and it is not included in any index. [+]
41 TABLE COLUMN DOC_RELATIONS.DOC_ID Column is candidate for NOT NULL constraint. [+]
42 TABLE COLUMN DOC_RELATIONS.RELATED_ID Column is candidate for NOT NULL constraint. [+]
43 TABLE COLUMN DOC_RELATIONS.RELATED_TYPE Column is candidate for NOT NULL constraint. [+]
44 TABLE COLUMN DOC_RELATIONS.REL_TYPE Column is candidate for NOT NULL constraint. [+]
45 TABLE COLUMN DOC_TEMPLATES.TEMPLATE_ID Column is candidate for NOT NULL constraint. [+]
46 TABLE COLUMN GROUP_MEMBERS.USER_ID Height-balanced histogram with no popular values. [+]
Go to Top

SQL Text (fa3q72kmdnc2y 2799317086 1D57B8D10F6D902F935EA627C9144C8D 14743530462716630101)

 SELECT /*+ gather_plan_statistics monitor bind_aware */
       /* sqlt_s29545 */
       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: fa3q72kmdnc2y
Hash Value: 2799317086
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: 9nhga314g9ryr
Signature for Stored Outlines for unstripped sql_text: 1D57B8D10F6D902F935EA627C9144C8D
Signature for SQL Profiles for unstripped sql_text (force match FALSE): 14743530462716630101
Signature for SQL Profiles for unstripped sql_text (force match TRUE): 14743530462716630101
Statement Response Time: +00 00:00:00.440514
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: s29545_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: 41.137

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:39:46.086789000
Window duration last 30 days: +000000005 15:39:42.243655000

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:39:10.653494 +02:00 2013-07-29/18:39:10.681462 +02:00 export_table_stats DMS."GROUP_MEMBERS"
2 2013-07-29/18:39:10.640079 +02:00 2013-07-29/18:39:10.652713 +02:00 export_table_stats DMS."DOC_TEMPLATES"
3 2013-07-29/18:38:58.021048 +02:00 2013-07-29/18:39:10.638842 +02:00 export_table_stats DMS."DOC_RELATIONS"
4 2013-07-29/18:38:58.013686 +02:00 2013-07-29/18:38:58.020276 +02:00 export_table_stats DMS."DOC_MEMBERS"
5 2013-07-29/18:38:46.603819 +02:00 2013-07-29/18:38:58.012458 +02:00 export_table_stats DMS."DOC_ATTR"
6 2013-07-29/18:38:46.544239 +02:00 2013-07-29/18:38:46.602662 +02:00 export_table_stats DMS."ACMTT_ACL_MEMBERS"
7 2013-07-29/18:19:01.161747 +02:00 2013-07-29/18:19:01.257322 +02:00 export_table_stats DMS."GROUP_MEMBERS"
8 2013-07-29/18:19:01.082369 +02:00 2013-07-29/18:19:01.160633 +02:00 export_table_stats DMS."DOC_TEMPLATES"
9 2013-07-29/18:18:39.147677 +02:00 2013-07-29/18:19:01.081047 +02:00 export_table_stats DMS."DOC_RELATIONS"
10 2013-07-29/18:18:39.032590 +02:00 2013-07-29/18:18:39.146291 +02:00 export_table_stats DMS."DOC_MEMBERS"
11 2013-07-29/18:18:23.251361 +02:00 2013-07-29/18:18:39.031150 +02:00 export_table_stats DMS."DOC_ATTR"
12 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"
13 2013-07-28/23:00:02.445545 +02:00 2013-07-28/23:05:17.208843 +02:00 gather_database_stats(auto)
14 2013-07-27/23:00:02.385786 +02:00 2013-07-27/23:08:49.680376 +02:00 gather_database_stats(auto)
15 2013-07-26/23:00:02.149416 +02:00 2013-07-26/23:19:09.552157 +02:00 gather_database_stats(auto)
16 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
17 2013-07-25/23:00:03.281731 +02:00 2013-07-25/23:15:03.058065 +02:00 gather_database_stats(auto)
18 2013-07-25/17:09:17.856849 +02:00 2013-07-25/17:30:07.419923 +02:00 gather_table_stats DMS.DOC_RELATIONS
19 2013-07-25/17:09:04.157599 +02:00 2013-07-25/20:49:52.570123 +02:00 gather_table_stats DMS.DOC_ATTR
20 2013-07-25/17:02:04.484296 +02:00 2013-07-25/17:03:12.525559 +02:00 gather_table_stats DMS.DOC_TEMPLATES
21 2013-07-25/17:01:49.750647 +02:00 2013-07-25/17:01:50.534877 +02:00 gather_table_stats DMS.GROUP_MEMBERS
22 2013-07-25/17:01:38.340829 +02:00 2013-07-25/17:01:39.243782 +02:00 gather_table_stats DMS.DOC_MEMBERS
23 2013-07-25/16:23:23.443631 +02:00 2013-07-25/16:23:23.473022 +02:00 export_table_stats DMS."GROUP_MEMBERS"
24 2013-07-25/16:23:23.430688 +02:00 2013-07-25/16:23:23.442809 +02:00 export_table_stats DMS."DOC_TEMPLATES"
25 2013-07-25/16:23:13.622635 +02:00 2013-07-25/16:23:23.429243 +02:00 export_table_stats DMS."DOC_RELATIONS"
26 2013-07-25/16:23:13.613606 +02:00 2013-07-25/16:23:13.621847 +02:00 export_table_stats DMS."DOC_MEMBERS"
27 2013-07-25/16:23:03.909625 +02:00 2013-07-25/16:23:13.612417 +02:00 export_table_stats DMS."DOC_ATTR"
28 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"
29 2013-07-25/16:03:05.419034 +02:00 2013-07-25/16:03:05.501203 +02:00 export_table_stats DMS."GROUP_MEMBERS"
30 2013-07-25/16:03:05.335859 +02:00 2013-07-25/16:03:05.417649 +02:00 export_table_stats DMS."DOC_TEMPLATES"
# Start Time End Time Operation Target
31 2013-07-25/16:02:47.063900 +02:00 2013-07-25/16:03:05.334611 +02:00 export_table_stats DMS."DOC_RELATIONS"
32 2013-07-25/16:02:47.017338 +02:00 2013-07-25/16:02:47.062533 +02:00 export_table_stats DMS."DOC_MEMBERS"
33 2013-07-25/16:02:34.969032 +02:00 2013-07-25/16:02:47.015999 +02:00 export_table_stats DMS."DOC_ATTR"
34 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"
35 2013-07-24/23:00:02.663507 +02:00 2013-07-24/23:48:27.423801 +02:00 gather_database_stats(auto)
36 2013-07-23/23:00:01.410318 +02:00 2013-07-23/23:22:09.622321 +02:00 gather_database_stats(auto)
37 2013-07-22/23:00:02.654415 +02:00 2013-07-22/23:22:30.663827 +02:00 gather_database_stats(auto)
38 2013-07-21/23:00:00.991979 +02:00 2013-07-21/23:06:23.894256 +02:00 gather_database_stats(auto)
39 2013-07-20/23:00:02.191318 +02:00 2013-07-20/23:06:29.405995 +02:00 gather_database_stats(auto)
40 2013-07-19/23:00:01.681935 +02:00 2013-07-19/23:22:17.424721 +02:00 gather_database_stats(auto)
41 2013-07-18/23:00:01.435204 +02:00 2013-07-18/23:28:28.667766 +02:00 gather_database_stats(auto)
42 2013-07-17/23:00:01.859087 +02:00 2013-07-17/23:18:01.345041 +02:00 gather_database_stats(auto)
43 2013-07-16/23:00:01.500654 +02:00 2013-07-16/23:15:52.967175 +02:00 gather_database_stats(auto)
44 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 "S29545_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 Y
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 Y
(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 0000000553411E70 FALSE 3915546322 [B] [W] 0.278 0.276 0.000 0.000 0.000 0.000 180 0 0 0 3 2013-07-29/18:38:11 2013-07-29/18:38:11 0.093 0.092 0.000 0.000 0.000 0.000 60 0 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 0000000553411E70 3915546322 [B] [W] Y Y 180 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 84 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.093 0.092 0.000 0.000 60 0 0 0 3 3 1 1 0 MEM GV$SQLAREA_PLAN_HASH Y 641027046 65 1 0.910 2013-07-29/18:38:11 2013-07-29/18:38:11 2013-07-29/18:38:11
2 1957132478 XPL EXPLAIN PLAN FOR 32 1 0.448 2013-07-29/18:38:17
(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.278 0.276 0.000 0.000 180 0 0 0 3 3 1 1 0 1 641027046 65 2013-07-29/18:38:11 2013-07-29/18:38:11 2013-07-29/18:38:11
(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.278
CPU Time in secs: 0.276
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: 180
Disk Reads: 0
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:38:11
Last Load Time: 2013-07-29/18:38:11
Last Active Time: 2013-07-29/18:38:11
Plan Timestamp: 2013-07-29/18:38:11
Sharable Memory: 228745
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: 29545 16409 ALTER SESSION SET EV
SQL Profile: "null"
Exact Matching Signature: 14743530462716630101
Force Matching Signature: 14743530462716630101
Outline Category: "null"
Remote: N
Object Status: VALID
Program ID: 0
Program Line #: 0
Typecheck Memory: 0
I/O Interconnect Bytes: 0
Physical Read Requests: 0
Physical Read Bytes: 0
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:38:17 182
2 3915546322 [B] [W] 96499 64834 MEM GV$SQL_PLAN Y ALL_ROWS 65 1 0 2013-07-29/18:38:11 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:38:17

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(0000000553411E70)  executions:3  is_sharable:Y  timestamp:2013-07-29/18:38:11

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
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.000  
2 1 . INDEX RANGE SCAN PI_DATTR__DI_TA_3V [+] [+] [+] [+] 4 1 0 0 0 0.000 0 0 0 0.000  
3 27  SORT ORDER BY   [+]     65 1 1 0 48 0.000 3 0 144 0.001 [+]
4 26 . FILTER   [+] [+] [+] 71 1 0 48 0.000 3 0 144 0.001  
5 17 .. NESTED LOOPS ANTI   [+]     63 1 1 0 48 0.000 3 0 144 0.001  
6 14 ... NESTED LOOPS SEMI   [+]     59 1 1 0 48 0.000 3 0 144 0.001  
7 12 .... NESTED LOOPS   [+]     58 1 1 0 48 0.000 3 0 144 0.001  
8 7 ....+ SORT UNIQUE   [+]     38 1 1 0 48 0.000 3 0 144 0.001 [+]
9 6 ....+. PARTITION RANGE SINGLE   [+]     38 1 1 0 48 0.000 3 0 144 0.001 KEY KEY  
10 5 ....+.. PARTITION RANGE ALL   [+]     38 1 1 0 48 0.000 3 0 144 0.001 1 18  
11 4 ....+... TABLE ACCESS BY LOCAL INDEX ROWID DOC_ATTR [+] [+] [+] [+] 38 1 18 0 48 0.000 54 0 144 0.001 KEY KEY  
12 3 ....+.... INDEX RANGE SCAN PI_DATTR__TI_PI_DM_TA_3V [+] [+] [+] [+] 37 1 18 0 48 0.000 54 0 144 0.001 KEY KEY  
13 11 ....+ PARTITION RANGE SINGLE   [+]     19 2 0 0 0 0.000 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.000 1 18  
15 9 ....+.. TABLE ACCESS BY LOCAL INDEX ROWID DOC_RELATIONS [+] [+] [+] [+] 19 2 0 0 0 0.000 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.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.000  
18 16 ... TABLE ACCESS BY GLOBAL INDEX ROWID DOC_ATTR [+] [+] [+] [+] 4 1 0 0 0 0.000 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.000  
20 21 .. FILTER   [+] [+] [+] 4 0 0 0 0.000 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.000  
22 18 .... INDEX RANGE SCAN I_ACL_MBRS__AI_II_OI_OT [+] [+] [+] [+] 2 1 0 0 0 0.000 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.000  
24 23 .. TABLE ACCESS BY INDEX ROWID DOC_MEMBERS [+] [+]     1 1 0 0 0 0.000 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.000  
26 25 .. TABLE ACCESS BY INDEX ROWID ACMTT_ACL_MEMBERS [+] [+]     3 1 0 0 0 0.000 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.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:38:11

# 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:38:11 :B5 NUMBER "3636688"
2 2013-07-29/18:38:11 :B4 NUMBER "7"
3 2013-07-29/18:38:11 :B3 NUMBER "29440"
4 2013-07-29/18:38:11 :B2 NUMBER "177"
5 2013-07-29/18:38:11 :B6 NUMBER "5179"
6 2013-07-29/18:38:11 :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

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: 0000000553411E70
Executions: 3
Elapsed Time in secs: 0.278
CPU Time in secs: 0.276
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: 180
Disk Reads: 0
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:38:11
Last Load Time: 2013-07-29/18:38:11
Last Active Time: 2013-07-29/18:38:11
Sharable Memory: 228745
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: 29545 16409 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: 14743530462716630101
Force Matching Signature: 14743530462716630101
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: 0
Physical Read Requests: 0
Physical Read Bytes: 0
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:38:11

Status: DONE (ALL ROWS)
SQL Exec Start Time: 2013-07-29/18:38:11
SQL Exec ID: 16777216
Inst ID: 1
Process Name: ora
Key: 1185411014624
Child Address: 0000000553411E70
Child Number: 0
Elapsed Time in secs: 0.273
Queuing Time in secs: 0.000
CPU Time in secs: 0.271
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: 84
Disk Reads: 0
Direct Writes: 0
Fetches: 1
PX is Cross Instance: N
Refresh Count: 4
First Refresh Time: 2013-07-29/18:38:11
Last Refresh Time: 2013-07-29/18:38:11
User #: 54
User Name: DMS
Service Name: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 29545 16409 ALTER SESSION SET EV
SID: 396
Session Serial#: 48411
Exact Matching Signature: 14743530462716630101
Force Matching Signature: 14743530462716630101
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:38:11

Status: DONE (ALL ROWS)
SQL Exec Start Time: 2013-07-29/18:38:11
SQL Exec ID: 16777217
Inst ID: 1
Process Name: ora
Key: 2954937540577
Child Address: 0000000553411E70
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:38:11
Last Refresh Time: 2013-07-29/18:38:11
User #: 54
User Name: DMS
Service Name: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 29545 16409 ALTER SESSION SET EV
SID: 396
Session Serial#: 48411
Exact Matching Signature: 14743530462716630101
Force Matching Signature: 14743530462716630101
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:38:11

Status: DONE (ALL ROWS)
SQL Exec Start Time: 2013-07-29/18:38:11
SQL Exec ID: 16777218
Inst ID: 1
Process Name: ora
Key: 3345779564514
Child Address: 0000000553411E70
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:38:11
Last Refresh Time: 2013-07-29/18:38:11
User #: 54
User Name: DMS
Service Name: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 29545 16409 ALTER SESSION SET EV
SID: 396
Session Serial#: 48411
Exact Matching Signature: 14743530462716630101
Force Matching Signature: 14743530462716630101
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

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 335544320 space allocated PI_DATTR__DI_TA_3V DMS INDEX 1 DMS_IND 197188 197188
2 180873586 space used PI_DATTR__DI_TA_3V DMS INDEX 1 DMS_IND 197188 197188
3 81588480 logical reads DOC_RELATIONS I577_P0 DMS TABLE SUBPARTITION 1 DMS_TAB_0 200481 200481
4 67752160 db block changes I_DRELS__CH_DI_ID_II DMS INDEX 1 DMS_IND 247059 247059
5 67108864 space allocated I_DRELS__CA_DI_2F_AR_AI_OI DMS INDEX 1 DMS_IND 247058 247058
6 50331648 space allocated PI_DATTR__TI_PI_DM_TA_3V I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198874 198874
7 50331648 space allocated PI_DATTR__TI_PI_DM_TA_3V I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198730 198730
8 45088768 space allocated PI_DATTR__DM_3V_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197588 197588
9 44040192 space allocated PI_DATTR__FCV_TI_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198303 198303
10 44040192 space allocated PI_DATTR__TA_3V_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199872 199872
11 41943040 space allocated DOC_ATTR I577_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196988 196988
12 41943040 space allocated PI_DATTR__FCV_TI_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198159 198159
13 41943040 space allocated PI_DATTR__PI_DM_3V_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199445 199445
14 41943040 space allocated PI_DATTR__PI_DM_3V_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199301 199301
15 41943040 space allocated PI_DATTR__TI_PI_DM_TA_3V I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198964 198964
16 39845888 space allocated PI_DATTR__FCV_TI_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198393 198393
17 39845888 space allocated PI_DATTR__TA_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200106 200106
18 37748736 space allocated PI_DATTR__PI_DM_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199535 199535
19 36524890 space used DOC_ATTR I577_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196988 196988
20 33554432 space allocated DOC_ATTR I571_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196934 196934
21 33554432 space allocated DOC_ATTR I597_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197168 197168
22 33554432 space allocated DOC_ATTR I587_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197078 197078
23 33554432 space allocated I_DRELS__CH_DI_ID_II DMS INDEX 1 DMS_IND 247059 247059
24 33554432 space allocated PI_DATTR__DM_3V_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197732 197732
25 33554432 space allocated PI_DATTR__DM_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197822 197822
26 33554432 space allocated PI_DATTR__PI_DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199355 199355
27 33554432 space allocated PI_DATTR__TA_3V_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200016 200016
28 33554432 space allocated PI_DATTR__TA_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199926 199926
29 33554432 space allocated PI_DATTR__TI_PI_DM_TA_3V I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198784 198784
30 33333434 space used DOC_ATTR I587_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197078 197078
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
31 32885820 space used DOC_ATTR I571_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196934 196934
32 32702090 space used I_DRELS__CA_DI_2F_AR_AI_OI DMS INDEX 1 DMS_IND 247058 247058
33 31457280 space allocated PI_DATTR__DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197642 197642
34 30762080 db block changes DOC_RELATIONS I177_P0 DMS TABLE SUBPARTITION 1 DMS_TAB_0 200391 200391
35 30408704 space allocated PI_DATTR__TI_PI_DM_TA_3V I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198838 198838
36 30408704 space allocated PI_DATTR__TI_PI_DM_TA_3V I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198856 198856
37 29935864 space used DOC_ATTR I597_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197168 197168
38 29933280 space used PI_DATTR__TI_PI_DM_TA_3V I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198730 198730
39 29360128 space allocated PI_DATTR__FCV_TI_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198213 198213
40 29360128 space allocated PI_DATTR__PI_DM_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199427 199427
41 29360128 space allocated PI_DATTR__TI_PI_DM_TA_3V I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198928 198928
42 28080247 space used PI_DATTR__DM_3V_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197588 197588
43 27630302 space used PI_DATTR__TI_PI_DM_TA_3V I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198874 198874
44 25889682 space used PI_DATTR__FCV_TI_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198159 198159
45 25165824 space allocated DOC_ATTR I585_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197060 197060
46 25165824 space allocated DOC_ATTR I593_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197132 197132
47 25165824 space allocated DOC_ATTR I583_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197042 197042
48 24606560 space used PI_DATTR__PI_DM_3V_DI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199301 199301
49 24314540 space used PI_DATTR__PI_DM_3V_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199445 199445
50 24117248 space allocated PI_DATTR__DM_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197714 197714
51 24117248 space allocated PI_DATTR__TA_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199998 199998
52 23368304 space used PI_DATTR__FCV_TI_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198393 198393
53 23068672 space allocated PI_DATTR__FCV_TI_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198285 198285
54 22821074 space used PI_DATTR__FCV_TI_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198303 198303
55 22056920 space used DOC_ATTR I585_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197060 197060
56 22020096 space allocated PI_DATTR__PI_DM_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199499 199499
57 22020096 space allocated PI_DATTR__TI_PI_DM_TA_3V I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198892 198892
58 20788508 space used PI_DATTR__TA_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200106 200106
59 20023052 space used PI_DATTR__TA_3V_DI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200016 200016
60 19922944 space allocated PI_DATTR__DM_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197786 197786
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
61 19922944 space allocated PI_DATTR__FCV_TI_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198357 198357
62 19922944 space allocated PI_DATTR__PI_DM_3V_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199409 199409
63 19922944 space allocated PI_DATTR__TA_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200070 200070
64 19922944 space allocated PI_DATTR__TI_PI_DM_TA_3V I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198766 198766
65 19058890 space used PI_DATTR__TI_PI_DM_TA_3V I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198964 198964
66 19036254 space used PI_DATTR__TA_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199926 199926
67 18906258 space used DOC_ATTR I583_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197042 197042
68 18874368 space allocated PI_DATTR__DM_3V_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197696 197696
69 18874368 space allocated PI_DATTR__FCV_TI_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198267 198267
70 18874368 space allocated PI_DATTR__TA_3V_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199980 199980
71 18789112 space used DOC_ATTR I593_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197132 197132
72 18352512 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2011Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2011 201630 201630
73 18300760 space used PI_DATTR__FCV_TI_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198213 198213
74 18094356 space used PI_DATTR__PI_DM_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199535 199535
75 17825792 space allocated PI_DATTR__DM_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197750 197750
76 17825792 space allocated PI_DATTR__PI_DM_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199463 199463
77 17825792 space allocated PI_DATTR__TA_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200034 200034
78 17825792 space allocated PI_DATTR__TI_PI_DM_TA_3V I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198910 198910
79 17777374 space used PI_DATTR__DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197642 197642
80 17673792 space used PI_DATTR__PI_DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199355 199355
81 16777216 space allocated DOC_ATTR I581_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197024 197024
82 16777216 space allocated DOC_ATTR I575_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196970 196970
83 16777216 space allocated DOC_ATTR I591_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197114 197114
84 16777216 space allocated DOC_ATTR I569_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196916 196916
85 16777216 space allocated DOC_ATTR I589_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197096 197096
86 16777216 space allocated PI_DATTR__FCV_TI_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198321 198321
87 16777216 space allocated PI_DATTR__PI_DM_3V_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199337 199337
88 16777216 space allocated PI_DATTR__TI_PI_DM_TA_3V I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198712 198712
89 16777216 space allocated UQ_DOC_TEMPLATES__DID_TID_IID DMS INDEX 1 DMS_IND 62293 236810
90 16777216 space allocated UQ_DOC_TEMPLATES__TID_DID_IID DMS INDEX 1 DMS_IND 62294 236811
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
91 16362956 space used DOC_ATTR I589_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197096 197096
92 15971860 space used I_DRELS__CH_DI_ID_II DMS INDEX 1 DMS_IND 247059 247059
93 15961280 space used PI_DATTR__PI_DM_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199427 199427
94 15735056 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2011Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2011 201629 201629
95 15731680 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2010Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2010 201628 201628
96 15728640 space allocated PI_DATTR__DM_3V_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197624 197624
97 15728640 space allocated PI_DATTR__TA_3V_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199908 199908
98 15728640 space allocated PI_DATTR__TI_PI_DM_TA_3V I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198820 198820
99 15600863 space used PI_DATTR__TI_PI_DM_TA_3V I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198928 198928
100 14816557 space used PI_DATTR__TI_PI_DM_TA_3V I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198856 198856
101 14680064 space allocated PI_DATTR__FCV_TI_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198195 198195
102 14680064 space allocated PI_DATTR__PI_DM_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199481 199481
103 14680064 space allocated PI_DATTR__PI_DM_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199283 199283
104 14680064 space allocated PI_DATTR__TA_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200052 200052
105 14680064 space allocated PI_DATTR__TI_PI_DM_TA_3V I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198748 198748
106 14413412 space used DOC_ATTR I591_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197114 197114
107 14263680 db block changes I_DRELS__CA_DI_2F_AR_AI_OI DMS INDEX 1 DMS_IND 247058 247058
108 14028714 space used DOC_ATTR I575_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196970 196970
109 13631488 space allocated PI_DATTR__PI_DM_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199319 199319
110 13631488 space allocated PI_DATTR__PI_DM_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199391 199391
111 13631488 space allocated PI_DATTR__TA_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199854 199854
112 12990708 space used PI_DATTR__FCV_TI_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198285 198285
113 12943432 space used DOC_ATTR I569_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196916 196916
114 12582912 space allocated PI_DATTR__DM_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197768 197768
115 12582912 space allocated PI_DATTR__DM_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197678 197678
116 12582912 space allocated PI_DATTR__DM_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197570 197570
117 12582912 space allocated PI_DATTR__FCV_TI_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198141 198141
118 12582912 space allocated PI_DATTR__FCV_TI_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198339 198339
119 12582912 space allocated PI_DATTR__TA_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199962 199962
120 12488607 space used PI_DATTR__TA_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199998 199998
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
121 12463542 space used DOC_ATTR I573_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196952 196952
122 11977571 space used PI_DATTR__TI_PI_DM_TA_3V I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198766 198766
123 11604688 space used DOC_ATTR I581_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197024 197024
124 11534336 space allocated PI_DATTR__DM_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197606 197606
125 11534336 space allocated PI_DATTR__FCV_TI_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198249 198249
126 11534336 space allocated PI_DATTR__TA_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199890 199890
127 11534336 space allocated PI_DATTR__TI_PI_DM_TA_3V I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198802 198802
128 11519056 logical reads DOC_RELATIONS I573_P0 DMS TABLE SUBPARTITION 1 DMS_TAB_0 200445 200445
129 11207682 space used PI_DATTR__FCV_TI_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198267 198267
130 10776423 space used PI_DATTR__FCV_TI_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198357 198357
131 10685330 space used UQ_DOC_TEMPLATES__TID_DID_IID DMS INDEX 1 DMS_IND 62294 236811
132 10507109 space used PI_DATTR__PI_DM_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199499 199499
133 10485760 space allocated PI_DATTR__FCV_TI_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198177 198177
134 10485760 space allocated PI_DATTR__PI_DM_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199373 199373
135 10479791 space used PI_DATTR__TI_PI_DM_TA_3V I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198892 198892
136 10394940 space used UQ_DOC_TEMPLATES__DID_TID_IID DMS INDEX 1 DMS_IND 62293 236810
137 9925574 space used PI_DATTR__PI_DM_3V_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199337 199337
138 9617641 space used PI_DATTR__PI_DM_3V_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199409 199409
139 9556291 space used PI_DATTR__DM_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197786 197786
140 9507425 space used PI_DATTR__DM_3V_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197624 197624
141 9437184 space allocated PI_DATTR__TA_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199944 199944
142 9371272 space used PI_DATTR__TA_3V_DI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199980 199980
143 8831606 space used PI_DATTR__FCV_TI_DI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198195 198195
144 8822243 space used PI_DATTR__TI_PI_DM_TA_3V I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198910 198910
145 8782809 space used PI_DATTR__PI_DM_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199463 199463
146 8680405 space used PI_DATTR__DM_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197750 197750
147 8672225 space used PI_DATTR__TA_3V_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200034 200034
148 8536286 space used PI_DATTR__FCV_TI_DI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198321 198321
149 8465330 space used PI_DATTR__TI_PI_DM_TA_3V I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198838 198838
150 8388608 space allocated DOC_ATTR I579_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197006 197006
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
151 8388608 space allocated DOC_ATTR I177_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196898 196898
152 8388608 space allocated DOC_ATTR I573_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196952 196952
153 8388608 space allocated DOC_TEMPLATES DMS TABLE 1 DMS_TAB 61925 236485
154 8388608 space allocated PI_DATTR__DM_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197660 197660
155 8388608 space allocated PI_DATTR__FCV_TI_DI I591_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198335 198335
156 8388608 space allocated PI_DATTR__FCV_TI_DI I591_P2012Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198336 198336
157 8388608 space allocated PI_DATTR__FCV_TI_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198231 198231
158 8388608 space allocated PI_DATTR__PI_DM_3V_DI I591_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 199476 199476
159 8388608 space allocated PPK_DRELS__ID_II DMS INDEX 1 DMS_IND 203552 203552
160 7715036 space used PI_DATTR__TI_PI_DM_TA_3V I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198748 198748
161 7671015 space used PI_DATTR__TI_PI_DM_TA_3V I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198820 198820
162 7478467 space used PI_DATTR__PI_DM_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199481 199481
163 7404539 space used PI_DATTR__PI_DM_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199319 199319
164 7340068 space used PI_DATTR__TA_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200052 200052
165 6901469 space used PI_DATTR__PI_DM_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199391 199391
166 6901126 space used PI_DATTR__PI_DM_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199283 199283
167 6781547 space used PI_DATTR__TA_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199854 199854
168 6715635 space used PI_DATTR__FCV_TI_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198249 198249
169 6592438 space used PI_DATTR__TA_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199962 199962
170 6527813 space used PI_DATTR__FCV_TI_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198141 198141
171 6468769 space used PI_DATTR__DM_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197606 197606
172 6291456 space allocated PI_DATTR__PI_DM_3V_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199265 199265
173 6291456 space allocated PI_DATTR__TI_PI_DM_TA_3V I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198694 198694
174 6278056 space used DOC_ATTR I177_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196898 196898
175 6264269 space used PI_DATTR__TI_PI_DM_TA_3V I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198802 198802
176 6214846 space used PI_DATTR__DM_3V_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197768 197768
177 6208475 space used PI_DATTR__DM_3V_DI I581_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197678 197678
178 6007568 space used PI_DATTR__DM_3V_DI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197570 197570
179 5964730 space used PI_DATTR__PI_DM_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199373 199373
180 5879580 space used PI_DATTR__DM_3V_DI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197822 197822
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
181 5752050 space used PI_DATTR__FCV_TI_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198177 198177
182 5264928 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2012Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 201633 201633
183 5242880 space allocated PI_DATTR__FCV_TI_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198123 198123
184 5242880 space allocated PI_DATTR__TA_3V_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199836 199836
185 5193072 space used PPK_DRELS__ID_II DMS INDEX 1 DMS_IND 203552 203552
186 5176752 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 201634 201634
187 4674442 space used PI_DATTR__FCV_TI_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198231 198231
188 4664736 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2011Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2011 201632 201632
189 4661840 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201639 201639
190 4506752 space used PI_DATTR__DM_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197660 197660
191 4283904 logical reads DOC_RELATIONS I177_P0 DMS TABLE SUBPARTITION 1 DMS_TAB_0 200391 200391
192 4194304 space allocated PI_DATTR__DM_3V_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197552 197552
193 4194304 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I577_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201052 201052
194 3905312 space used DOC_TEMPLATES DMS TABLE 1 DMS_TAB 61925 236485
195 3898688 logical reads DOC_ATTR I577_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196988 196988
196 3719534 space used PI_DATTR__TI_PI_DM_TA_3V I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198694 198694
197 3695491 space used PI_DATTR__PI_DM_3V_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199265 199265
198 3654770 space used PI_DATTR__FCV_TI_DI I591_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198335 198335
199 3548576 logical reads PI_DRELS__DI_RI_FD_2RT I577_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201623 201623
200 3424085 space used PI_DATTR__FCV_TI_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198123 198123
201 3145728 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201014 201014
202 3066416 db block changes DOC_ATTR I577_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196988 196988
203 3050096 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2010Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2010 201626 201626
204 2979632 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2013Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201637 201637
205 2975520 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2011Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2011 201631 201631
206 2971456 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2010Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2010 201627 201627
207 2933782 space used PI_DATTR__DM_3V_DI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197552 197552
208 2887659 space used PI_DATTR__TI_PI_DM_TA_3V I591_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198906 198906
209 2852976 space used PI_DATTR__TI_PI_DM_TA_3V I591_P2012Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198904 198904
210 2761505 space used PI_DATTR__TA_3V_DI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200070 200070
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
211 2727712 db block changes PI_DATTR__FCV_TI_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198213 198213
212 2672480 db block changes PI_DATTR__TA_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199926 199926
213 2640656 db block changes PI_DATTR__DM_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197642 197642
214 2503696 space used PI_DATTR__TA_3V_DI I591_P2012Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 200049 200049
215 2491426 space used PI_DATTR__DM_3V_DI I591_P2012Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 197762 197762
216 2409954 space used PI_DATTR__PI_DM_3V_DI I591_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 199476 199476
217 2341408 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2013Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201640 201640
218 2319072 logical reads DOC_ATTR I571_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196934 196934
219 2251592 space used PI_DATTR__TA_3V_DI I591_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 200047 200047
220 2168798 space used PI_DATTR__FCV_TI_DI I591_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198339 198339
221 2125836 space used DOC_ATTR I579_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 197006 197006
222 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201158 201158
223 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I571_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 200998 200998
224 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201248 201248
225 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201122 201122
226 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I587_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201142 201142
227 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I597_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201232 201232
228 2097152 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201068 201068
229 2093230 space used PI_DATTR__TA_3V_DI I591_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 200048 200048
230 2070484 space used PI_DATTR__DM_3V_DI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197714 197714
231 1961056 logical reads DOC_ATTR I177_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196898 196898
232 1881529 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201014 201014
233 1866000 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 201635 201635
234 1862240 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2010Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2010 201625 201625
235 1859760 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2012Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 201636 201636
236 1642028 space used PI_DATTR__DM_3V_DI I591_P2013Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 197767 197767
237 1603230 physical read requests PI_DATTR__DI_TA_3V DMS INDEX 1 DMS_IND 197188 197188
238 1600964 space used PI_DATTR__FCV_TI_DI I591_P2012Q1 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198333 198333
239 1598504 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201158 201158
240 1564832 logical reads PI_DRELS__DI_RI_FD_2RT I177_P2011Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2011 201542 201542
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
241 1494445 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I577_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201052 201052
242 1457952 logical reads DOC_ATTR I573_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196952 196952
243 1441792 space allocated PI_DRELS__RT_RT I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 203298 203298
244 1417078 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201248 201248
245 1329760 logical reads PI_DATTR__TA_3V_DI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199926 199926
246 1310720 space allocated PI_DRELS__RI_2RT_FD I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 202853 202853
247 1280688 logical reads DOC_ATTR I577_P2013Q1 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 196986 196986
248 1245184 space allocated PI_DRELS__DI_RI_FD_2RT I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201711 201711
249 1245184 space allocated PI_DRELS__RI_2RT_FD I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 202961 202961
250 1228287 space used PI_DATTR__TI_PI_DM_TA_3V I591_P2012Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198907 198907
251 1179648 space allocated PI_DRELS__DI_RI_FD_2RT I597_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201819 201819
252 1179648 space allocated PI_DRELS__FD_RI I587_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 202300 202300
253 1121132 space used PI_DATTR__DM_3V_DI I591_P2012Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 197764 197764
254 1115233 space used PI_DATTR__TA_3V_DI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199890 199890
255 1114112 space allocated PI_DRELS__DI_RI_FD_2RT I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201639 201639
256 1114112 space allocated PI_DRELS__RI_2RT_FD I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 202781 202781
257 1108992 logical reads PI_DRELS__DI_RI_FD_2RT I571_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201585 201585
258 1108624 logical reads I_DOC_MBRS__DI_UI_II DMS INDEX 1 DMS_IND 184043 184043
259 1079056 space used DOC_RELATIONS I587_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 200587 200587
260 1077608 space used PI_DATTR__TI_PI_DM_TA_3V I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 198712 198712
261 1075978 space used PI_DATTR__PI_DM_3V_DI I591_P2012Q4 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 199478 199478
262 1050640 logical reads PI_DRELS__DI_RI_FD_2RT I591_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201749 201749
263 1048576 space allocated PI_DATTR__FCV_TI_DI I177_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198118 198118
264 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I589_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201160 201160
265 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I593_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201196 201196
266 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I591_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201178 201178
267 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I177_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 200962 200962
268 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I575_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201050 201050
269 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I589_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201176 201176
270 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I569_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 200980 200980
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
271 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I573_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201016 201016
272 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I583_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201106 201106
273 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I585_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201124 201124
274 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I593_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201212 201212
275 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I569_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200996 200996
276 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I575_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201034 201034
277 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201140 201140
278 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I123_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 200818 200818
279 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I581_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201088 201088
280 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I573_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201032 201032
281 1048576 space allocated PI_DRELS__CH_CA_DI_2F_AR_AI_OI I177_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 200978 200978
282 1048576 space allocated PI_DRELS__DI_RI_FD_2RT I585_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201695 201695
283 1048576 space allocated PI_DRELS__FD_RI I177_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 202104 202104
284 1048576 space allocated PI_DRELS__FD_RI I577_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 202194 202194
285 1048576 space allocated PI_DRELS__RI_2RT_FD I579_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 202783 202783
286 1048576 space allocated PI_DRELS__RI_2RT_FD I589_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 202873 202873
287 1048576 space allocated PI_DRELS__RI_2RT_FD I577_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 202765 202765
288 1048576 space allocated PI_DRELS__RI_2RT_FD I571_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 202711 202711
289 1029840 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I597_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201232 201232
290 1028528 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I577_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201068 201068
291 1023678 space used DOC_RELATIONS I571_P2013Q3 DMS TABLE SUBPARTITION 1 DMS_TAB_2013 200443 200443
292 1016755 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I583_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201122 201122
293 1014000 logical reads DOC_ATTR I591_P2010Q2 DMS TABLE SUBPARTITION 1 DMS_TAB_2010 197101 197101
294 947225 space used PI_DATTR__TA_3V_DI I579_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 199944 199944
295 929798 space used DOC_RELATIONS I577_P0 DMS TABLE SUBPARTITION 1 DMS_TAB_0 200481 200481
296 929168 logical reads PI_DRELS__DI_RI_FD_2RT I577_P2009 DMS INDEX SUBPARTITION 1 DMS_TAB_2009 201624 201624
297 916145 space used PI_DRELS__DI_RI_FD_2RT I585_P2013Q3 DMS INDEX SUBPARTITION 1 DMS_TAB_2013 201711 201711
298 901738 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I571_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 200998 200998
299 853652 space used PI_DATTR__FCV_TI_DI I569_P2012Q2 DMS INDEX SUBPARTITION 1 DMS_TAB_2012 198136 198136
300 844478 space used PI_DRELS__CH_CA_DI_2F_AR_AI_OI I587_P0 DMS INDEX SUBPARTITION 1 DMS_TAB_0 201142 201142
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 894 1
3 Cache commit cleanouts successfully completed 893 1
4 Cache consistent gets 230 1
5 Cache consistent gets - examination 57 1
6 Cache consistent gets from cache 230 1
7 Cache consistent gets from cache (fastpath) 169 1
8 Cache db block changes 104 1
9 Cache db block gets 121 1
10 Cache db block gets from cache 121 1
11 Cache db block gets from cache (fastpath) 33 1
12 Cache free buffer requested 11 1
13 Cache logical read bytes from cache 5750784 1
14 Cache physical read IO requests 5 1
15 Cache physical read bytes 81920 1
16 Cache physical read total IO requests 5 1
17 Cache physical read total bytes 81920 1
18 Cache physical reads 5 1
19 Cache physical reads cache 5 1
20 Cache shared hash latch upgrades - no wait 1 1
21 Cache switch current to new buffer 1 1
22 Cache, SQL buffer is not pinned count 70 1
23 Debug CPU used when call started 557 1
24 Debug IMU Flushes 2 1
25 Debug IMU Redo allocation size 41684 1
26 Debug IMU commits 6 1
27 Debug IMU undo allocation size 11008 1
28 Debug active txn count during cleanout 3 1
29 Debug calls to kcmgas 13 1
30 Debug calls to kcmgcs 39 1
# Class Name Statistic Name Value Inst ID
31 Debug cleanout - number of ktugct calls 3 1
32 Debug commit txn count during cleanout 1 1
33 Debug cursor authentications 3 1
34 Debug deferred (CURRENT) block cleanout applications 6 1
35 Debug immediate (CURRENT) block cleanout applications 2 1
36 Debug index fetch by key 3 1
37 Debug index scans kdiixs1 55 1
38 Debug leaf node 90-10 splits 1 1
39 Debug leaf node splits 1 1
40 Debug messages sent 4 1
41 Debug no work - consistent read gets 124 1
42 Debug redo synch time (usec) 2258 1
43 Debug undo change vector size 34808 1
44 Enqueue enqueue releases 38 1
45 Enqueue enqueue requests 25 1
46 RAC calls to get snapshot scn: kcmgss 54 1
47 Redo redo entries 56 1
48 Redo redo ordering marks 3 1
49 Redo redo size 105640 1
50 Redo redo subscn max counts 10 1
51 Redo redo synch writes 1 1
52 SQL HSC Heap Segment Block Changes 12 1
53 SQL Heap Segment Array Inserts 5 1
54 SQL Heap Segment Array Updates 1 1
55 SQL cell physical IO interconnect bytes 81920 1
56 SQL cluster key scan block gets 1 1
57 SQL cluster key scans 1 1
58 SQL execute count 54 1
59 SQL parse count (hard) 3 1
60 SQL parse count (total) 29 1
# Class Name Statistic Name Value Inst ID
61 SQL parse time cpu 10 1
62 SQL parse time elapsed 10 1
63 SQL rows fetched via callback 2 1
64 SQL session cursor cache hits 41 1
65 SQL sorts (memory) 7 1
66 SQL sorts (rows) 1 1
67 SQL table fetch by rowid 9 1
68 SQL table scan blocks gotten 16 1
69 SQL table scan rows gotten 304 1
70 SQL table scans (short tables) 16 1
71 SQL workarea executions - optimal 1 1
72 User CPU used by this session 44 1
73 User DB time 613 1
74 User Requests to/from client 22 1
75 User SQL*Net roundtrips to/from client 23 1
76 User bytes received via SQL*Net from client 12963 1
77 User bytes sent via SQL*Net to client 9135 1
78 User file io wait time 268854 1
79 User non-idle wait count 30 1
80 User non-idle wait time 27 1
81 User opened cursors cumulative 72 1
82 User recursive calls 248 1
83 User recursive cpu usage 39 1
84 User session logical reads 351 1
85 User session pga memory 3039344 1
86 User user I/O wait time 27 1
87 User user calls 40 1
88 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.543830 Disk file operations I/O 1 6 0.090638 0
2 0.329095 db file sequential read 1 8 0.041137 0
3 0.112691 log file switch completion 1 1 0.112691 0
4 0.033938 control file sequential read 1 42 0.000808 0
5 0.030647 utl_file I/O 1 54 0.000568 0
6 0.010415 SQL*Net message from client 1 23 0.000453 0
7 0.002214 log file sync 1 1 0.002214 0
8 0.001175 direct path write temp 1 2 0.000588 0
9 0.000901 events in waitclass Other 1 29 0.000031 5
10 0.000176 SQL*Net break/reset to client 1 2 0.000088 0
11 0.000072 BFILE read 1 6 0.000012 0
12 0.000021 SQL*Net message to client 1 23 0.000001 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=396). 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=396).
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=396).
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=396).
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 36760 36760 0
Servers Started : 1 564 564 0
Servers Shutdown : 1 564 564 0
Servers Cleaned Up : 1 0 0 0
Queries Queued : 1 0 0 0
Queries Initiated : 1 859 859 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 859 859 0
Sessions Active : 1 0 0 0
Local Msgs Sent : 1 164618028 164618028 0
Distr Msgs Sent : 1 0 0 0
Local Msgs Recv'd : 1 164652033 164652033 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 564 564 0
Servers Shutdown : 1 564 564 0
Servers Highwater : 1 128 128 0
Servers Cleaned Up : 1 0 0 0
Server Sessions : 1 36760 36760 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 1660671 1660671 0
Buffers Freed : 1 1660671 1660671 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 396. 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 396. 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 13900 14079 14079 32 26-JUL-13 Stats 2 Modif Prop Phys 2 6 5 4     2 Meta
2 DOC_ATTR DMS 313200000 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 17530000 17181186 17181186 169732 25-JUL-13 Stats 3 Modif Prop Phys 2 18 13 12 PKey 30 8 Meta
5 DOC_TEMPLATES DMS 18940000 19609772 19609772 30712 25-JUL-13 Stats 2 Modif Prop Phys 2 4 3 3     2 Meta
6 GROUP_MEMBERS DMS 33500 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 13900 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 313200000 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 17530000 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 18940000 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 33500 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 8 4 0 12 0.1 NO 2013-07-29/18:20:25 NO 0
2 DOC_ATTR DMS 317078196 2654996 426710 1984022 5065728 1.6 NO 2013-07-29/18:20:25 NO 0
3 DOC_MEMBERS DMS 0 NO
4 DOC_RELATIONS DMS 17181186 60002 268719 21766 350487 2.0 NO 2013-07-29/18:13:13 NO 0
5 DOC_TEMPLATES DMS 19609772 54826 6497 13491 74814 0.4 NO 2013-07-29/18:13:13 NO 0
6 GROUP_MEMBERS DMS 33911 199 0 122 321 0.9 NO 2013-07-29/14:45:11 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 13900 14079 14079 32 26-JUL-13 6 6 6 Prop 4
2 DOC_ATTR DMS 313200000 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 17530000 17181186 17181186 169732 25-JUL-13 18 13 18 Prop 12
5 DOC_TEMPLATES DMS 18940000 19609772 19609772 30712 25-JUL-13 4 3 4 Prop 3
6 GROUP_MEMBERS DMS 33500 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 [+] [+]