215187.1 SQLT XECUTE 11.4.5.4  Report: sqlt_s53241_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-02-04/10:58:34

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 is one system level initialization parameter with a modified value in AWR. [+]
2 CBO PARAMETER NON-DEFAULT There are 3 CBO initialization parameters with a non-default value. [+]
3 CBO PARAMETER MODIFIED There are 7 CBO initialization parameters with a modified value. [+]
4 PLAN PLAN_HASH_VALUE 2 plans were found for this SQL. [+]
5 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.  
6 PLAN PLAN_HASH_VALUE Plan 657302870 has operations with Cost 0 and Card 1. Possible incorrect Selectivity. [+]
7 PLAN PLAN_HASH_VALUE Plan 2816325939 has operations with Cost 0 and Card 1. Possible incorrect Selectivity. [+]
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 12 milliseconds differs for more than 10% from actual db file sequential read wait time of 1.941 milliseconds. [+]
10 DBMS_STATS SYSTEM STATISTICS Multi-block read time of 26 milliseconds differs for more than 10% from actual db file scattered read wait time of .121 milliseconds. [+]
11 STATEMENT RESPONSE TIME Execution of this statement took +00 00:01:35.918702. This is wall clock time. [+]
12 MAT_VIEW REWRITE_ENABLED There is/are 3 materialized view(s) with rewrite enabled. [+]
13 TABLE QTUNE.CUSTOMER Table CBO statistics are 68 days old: 2012-11-28/09:55:33 [+]
14 TABLE QTUNE.CUSTOMER Table has 1 CBO statistics extension(s). [+]
15 TABLE QTUNE.ORDER_LINE Table CBO statistics are 68 days old: 2012-11-28/09:56:22 [+]
16 TABLE QTUNE.PART Table CBO statistics are 68 days old: 2012-11-28/09:55:44 [+]
17 TABLE QTUNE.PART Table has 1 CBO statistics extension(s). [+]
18 TABLE QTUNE.SALES_ORDER Table CBO statistics are 68 days old: 2012-11-28/09:55:54 [+]
19 TABLE QTUNE.SALES_ORDER Table has 1 CBO statistics extension(s). [+]
20 TABLE COLUMN SALES_ORDER.STATUS Column is referenced in predicate(s) and it is not included in any index. [+]
21 TABLE COLUMN SALES_ORDER.STATUS Column is candidate for NOT NULL constraint. [+]
Go to Top

SQL Text (gscwjswcdsqb3 417093987 D3AFF496873C8F1EA78429E59E3F78C3 17810495099954579021)

SELECT /*+ gather_plan_statistics monitor bind_aware */
       /* sqlt_s53241 */
       v.customer_name,
       v.orders_total,
       v.credit_limit,
       (orders_total - credit_limit) over_limit
  FROM customer_v v
 WHERE orders_total > credit_limit
   AND customer_type = :b1
 ORDER BY
       over_limit DESC
Go to Top

Stripped SQL Text (B2C3C4A8E292CBCAC2EB5F9482BA6514 1178211779310957485)

SQL Text: [-]
SELECT /*+ gather_plan_statistics monitor bind_aware */

       v.customer_name,
       v.orders_total,
       v.credit_limit,
       (orders_total - credit_limit) over_limit
  FROM customer_v v
 WHERE orders_total > credit_limit
   AND customer_type = :b1
 ORDER BY
       over_limit DESC

Go to Top

SQL Identification

SQL ID: gscwjswcdsqb3
Hash Value: 417093987
Signature for Stored Outlines: B2C3C4A8E292CBCAC2EB5F9482BA6514
Signature for SQL Profiles (force match FALSE): 1178211779310957485
Signature for SQL Profiles (force match TRUE): 1178211779310957485
Command Type: SELECT (3)
"EXPLAIN PLAN FOR" SQL ID for stripped sql_text: 37zj7jwpsqkpn
Signature for Stored Outlines for unstripped sql_text: D3AFF496873C8F1EA78429E59E3F78C3
Signature for SQL Profiles for unstripped sql_text (force match FALSE): 17810495099954579021
Signature for SQL Profiles for unstripped sql_text (force match TRUE): 17810495099954579021
Statement Response Time: +00 00:01:35.918702
Go to Top

Environment

Host Name: host01.example.com
CPUs: 2
Exadata: "null"
RAC: FALSE
NLS Characterset
(database_properties):
WE8MSWIN1252
DB Time Zone
(database_properties):
00:00
DB Block Size
(db_block_size):
8192
Optim Peek User Binds
(_optim_peek_user_binds):
TRUE
DB Size in Terabytes
(dba_data_files):
0.007 TB
TC Data Size in Gigabytes
(dba_segments):
0.394 GB
Platform: Linux
Product Version: Oracle Database 11g Enterprise Edition (Production)
RDBMS Version: 11.2.0.3.0
Language: US:AMERICAN_AMERICA.WE8MSWIN1252
Database Name and ID: V1123(4223793606)
Instance Name and ID: V1123(1)
EBS: NO
Siebel: NO
PSFT: NO
User Name and ID: QTUNE (92)
Input Filename: input/sample/script2.sql
STATID: s53241_v1123_host01
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 Is Adjusted Is Deprecated Is Basic Is Session Modifiable Is System Modifiable Is Instance Modifiable Type Description
1 FALSE SYSTEM_MOD _optimizer_use_feedback 1 "TRUE"   FALSE FALSE FALSE TRUE IMMEDIATE TRUE 1 optimizer use feedback
2 FALSE SYSTEM_MOD statistics_level 1 "ALL"   FALSE FALSE FALSE TRUE IMMEDIATE TRUE 2 statistics level
3 FALSE FALSE pga_aggregate_target 1 "213909504" "204M" FALSE FALSE TRUE FALSE IMMEDIATE TRUE 6 Target size for the aggregate PGA memory consumed by the instance
4 TRUE SYSTEM_MOD _dml_frequency_tracking 1 "FALSE"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 1 Control DML frequency tracking
5 TRUE SYSTEM_MOD _dml_monitoring_enabled 1 "TRUE"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 1 enable modification monitoring
6 TRUE SYSTEM_MOD _pga_max_size 1 "1717985280" "1677720K" FALSE FALSE FALSE FALSE IMMEDIATE TRUE 6 Maximum size of the PGA memory for one process
7 TRUE SYSTEM_MOD optimizer_secure_view_merging 1 "TRUE"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 1 optimizer secure view merging and predicate pushdown/movearound
8 TRUE SYSTEM_MOD parallel_threads_per_cpu 1 "1"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 3 number of parallel execution threads per CPU
(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 01-16-2013 04:59
3 DSTOP 01-16-2013 04:59
4 FLAGS

Current System Statistics

# Name Value
1 CPUSPEEDNW 1796
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: 8192
db_file_multiblock_read_count: 94
_db_file_optimizer_read_count: 8
Estimated CPUSPEED: 1796
Estimated MBRC: 8
Estimated SREADTIM: 12
Estimated MREADTIM: 26
CPU Cost Scaling Factor: 4.639941e-08
CPU Cost Scaling Factor (inverse): 21552000
Actual SREADTIM: 1.941
Actual MREADTIM: .121

System Statistics History

# Save Time CPUSPEEDNW IOSEEKTIM IOTFRSPEED CPUSPEED MBRC SREADTIM MREADTIM MAXTHR SLAVETHR
1 2013-01-16/04:59:49.334730 -05:00 1804 10 4096
2 2013-01-15/09:47:19.891935 -05:00 1803 10 4096
3 2013-01-15/07:32:03.645351 -05:00 1800 10 4096
4 2013-01-14/08:15:32.929517 -05:00 2720.24970737417 10 4096
5 2013-01-14/07:26:43.646234 -05:00 2720.24970737417 10 4096
6 2013-01-14/07:26:43.633556 -05:00 2720.24970737417 10 4096
7 2013-01-14/07:26:43.619739 -05:00 1800 10 4096
8 2013-01-14/07:26:43.581037 -05:00 1510.07147498376 10 4096
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: DISABLED
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:02:08.185714286
Mean Job CPU: +000000000 00:00:35.947428571

Statistics for SYS Tables

# Last Analyzed Tables
1 NO STATS 53
2 2013-02 20
3 2012-12 3
4 2012-06 1
5 2012-05 179
6 2012-04 24
7 2012-03 100
8 2011-09 607

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-02-04/11:13:20.009638 -05:00 2013-02-04/11:13:20.022515 -05:00 export_table_stats QTUNE."SALES_ORDER"
2 2013-02-04/11:13:19.997169 -05:00 2013-02-04/11:13:20.008854 -05:00 export_table_stats QTUNE."PART"
3 2013-02-04/11:13:19.981833 -05:00 2013-02-04/11:13:19.996338 -05:00 export_table_stats QTUNE."ORDER_LINE"
4 2013-02-04/11:13:19.616548 -05:00 2013-02-04/11:13:19.979685 -05:00 export_table_stats QTUNE."CUSTOMER"
5 2013-02-04/11:01:59.772952 -05:00 2013-02-04/11:01:59.834065 -05:00 export_table_stats QTUNE."SALES_ORDER"
6 2013-02-04/11:01:59.761808 -05:00 2013-02-04/11:01:59.772148 -05:00 export_table_stats QTUNE."PART"
7 2013-02-04/11:01:59.750448 -05:00 2013-02-04/11:01:59.760976 -05:00 export_table_stats QTUNE."ORDER_LINE"
8 2013-02-04/11:01:59.626513 -05:00 2013-02-04/11:01:59.749161 -05:00 export_table_stats QTUNE."CUSTOMER"
9 2013-02-04/10:52:29.618689 -05:00 2013-02-04/10:52:30.492602 -05:00 export_table_stats QTUNE."SALES_ORDER"
10 2013-02-04/10:52:28.868235 -05:00 2013-02-04/10:52:29.617837 -05:00 export_table_stats QTUNE."PART"
11 2013-02-04/10:52:28.856967 -05:00 2013-02-04/10:52:28.867424 -05:00 export_table_stats QTUNE."ORDER_LINE"
12 2013-02-04/10:52:27.095657 -05:00 2013-02-04/10:52:28.349870 -05:00 export_table_stats QTUNE."CUSTOMER"
13 2013-02-04/10:08:26.446577 -05:00 2013-02-04/10:08:26.458379 -05:00 export_table_stats QTUNE."SALES_ORDER"
14 2013-02-04/10:08:26.434530 -05:00 2013-02-04/10:08:26.445703 -05:00 export_table_stats QTUNE."PART"
15 2013-02-04/10:08:26.421487 -05:00 2013-02-04/10:08:26.433251 -05:00 export_table_stats QTUNE."ORDER_LINE"
16 2013-02-04/10:08:26.363906 -05:00 2013-02-04/10:08:26.414464 -05:00 export_table_stats QTUNE."CUSTOMER"
17 2013-02-04/10:02:39.675798 -05:00 2013-02-04/10:02:39.721205 -05:00 export_table_stats QTUNE."SALES_ORDER"
18 2013-02-04/10:02:39.664805 -05:00 2013-02-04/10:02:39.674859 -05:00 export_table_stats QTUNE."PART"
19 2013-02-04/10:02:39.619262 -05:00 2013-02-04/10:02:39.663970 -05:00 export_table_stats QTUNE."ORDER_LINE"
20 2013-02-04/10:02:39.454232 -05:00 2013-02-04/10:02:39.617839 -05:00 export_table_stats QTUNE."CUSTOMER"
21 2013-02-04/08:59:50.940089 -05:00 2013-02-04/08:59:51.039062 -05:00 export_table_stats QTUNE."SALES_ORDER"
22 2013-02-04/08:59:50.930375 -05:00 2013-02-04/08:59:50.939298 -05:00 export_table_stats QTUNE."PART"
23 2013-02-04/08:59:50.919435 -05:00 2013-02-04/08:59:50.929589 -05:00 export_table_stats QTUNE."ORDER_LINE"
24 2013-02-04/08:59:50.811007 -05:00 2013-02-04/08:59:50.918451 -05:00 export_table_stats QTUNE."CUSTOMER"
25 2013-02-04/08:52:20.443700 -05:00 2013-02-04/08:52:20.455380 -05:00 export_table_stats QTUNE."SALES_ORDER"
26 2013-02-04/08:52:20.433175 -05:00 2013-02-04/08:52:20.442751 -05:00 export_table_stats QTUNE."PART"
27 2013-02-04/08:52:20.420477 -05:00 2013-02-04/08:52:20.432173 -05:00 export_table_stats QTUNE."ORDER_LINE"
28 2013-02-04/08:52:20.313423 -05:00 2013-02-04/08:52:20.419346 -05:00 export_table_stats QTUNE."CUSTOMER"
29 2013-02-04/08:30:14.130086 -05:00 2013-02-04/08:30:14.140512 -05:00 export_table_stats QTUNE."SALES_ORDER"
30 2013-02-04/08:30:14.118764 -05:00 2013-02-04/08:30:14.129185 -05:00 export_table_stats QTUNE."PART"
# Start Time End Time Operation Target
31 2013-02-04/08:30:14.105043 -05:00 2013-02-04/08:30:14.117790 -05:00 export_table_stats QTUNE."ORDER_LINE"
32 2013-02-04/08:30:13.875775 -05:00 2013-02-04/08:30:14.100576 -05:00 export_table_stats QTUNE."CUSTOMER"
33 2013-01-25/13:20:11.593683 -05:00 2013-01-25/13:20:11.605838 -05:00 export_table_stats QTUNE."SALES_ORDER"
34 2013-01-25/13:20:11.581945 -05:00 2013-01-25/13:20:11.591764 -05:00 export_table_stats QTUNE."PART"
35 2013-01-25/13:20:11.570329 -05:00 2013-01-25/13:20:11.581023 -05:00 export_table_stats QTUNE."ORDER_LINE"
36 2013-01-25/13:20:11.450504 -05:00 2013-01-25/13:20:11.569114 -05:00 export_table_stats QTUNE."CUSTOMER"
37 2013-01-25/13:10:54.790161 -05:00 2013-01-25/13:10:54.853434 -05:00 export_table_stats QTUNE."SALES_ORDER"
38 2013-01-25/13:10:54.780153 -05:00 2013-01-25/13:10:54.789350 -05:00 export_table_stats QTUNE."PART"
39 2013-01-25/13:10:54.768929 -05:00 2013-01-25/13:10:54.779261 -05:00 export_table_stats QTUNE."ORDER_LINE"
40 2013-01-25/13:10:54.627590 -05:00 2013-01-25/13:10:54.739286 -05:00 export_table_stats QTUNE."CUSTOMER"
41 2013-01-25/04:49:07.849281 -05:00 2013-01-25/04:49:07.905418 -05:00 export_table_stats QTUNE."SALES_ORDER"
42 2013-01-25/04:49:07.832432 -05:00 2013-01-25/04:49:07.848292 -05:00 export_table_stats QTUNE."PART"
43 2013-01-25/04:49:07.755086 -05:00 2013-01-25/04:49:07.831416 -05:00 export_table_stats QTUNE."ORDER_LINE"
44 2013-01-25/04:49:07.612581 -05:00 2013-01-25/04:49:07.753699 -05:00 export_table_stats QTUNE."CUSTOMER"
45 2013-01-25/03:37:02.453940 -05:00 2013-01-25/03:37:02.505718 -05:00 export_table_stats QTUNE."SALES_ORDER"
46 2013-01-25/03:37:02.315897 -05:00 2013-01-25/03:37:02.452888 -05:00 export_table_stats QTUNE."PART"
47 2013-01-25/03:37:02.172448 -05:00 2013-01-25/03:37:02.314858 -05:00 export_table_stats QTUNE."ORDER_LINE"
48 2013-01-25/03:37:01.540468 -05:00 2013-01-25/03:37:02.171069 -05:00 export_table_stats QTUNE."CUSTOMER"
49 2013-01-16/04:59:49.325720 -05:00 2013-01-16/04:59:49.371230 -05:00 delete_system_stats
50 2013-01-15/09:47:19.884626 -05:00 2013-01-15/09:47:19.932191 -05:00 delete_system_stats
51 2013-01-15/07:32:03.564744 -05:00 2013-01-15/07:32:03.707957 -05:00 delete_system_stats
52 2013-01-14/08:15:32.926657 -05:00 2013-01-14/08:15:32.960903 -05:00 delete_system_stats
53 2013-01-14/07:26:43.645082 -05:00 2013-01-14/07:26:43.647696 -05:00 set_system_stats
54 2013-01-14/07:26:43.632399 -05:00 2013-01-14/07:26:43.635050 -05:00 set_system_stats
55 2013-01-14/07:26:43.618574 -05:00 2013-01-14/07:26:43.621259 -05:00 set_system_stats
56 2013-01-14/07:26:43.518763 -05:00 2013-01-14/07:26:43.607996 -05:00 delete_system_stats
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 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 SYSTEM_MOD _cursor_bind_capture_interval 1 1 "900"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 3 interval (in seconds) between two bind capture for a cursor
2 FALSE FALSE audit_file_dest 1 1 "/u01/app/oracle/admin/V1123/adump"   FALSE FALSE FALSE FALSE DEFERRED TRUE 2 Directory in which auditing files are to reside
3 FALSE FALSE audit_trail 1 1 "DB"   FALSE FALSE FALSE FALSE FALSE FALSE 2 enable system auditing
4 FALSE FALSE compatible 1 1 "11.2.0.0.0"   FALSE FALSE TRUE FALSE FALSE FALSE 2 Database will be completely compatible with this software version
5 FALSE FALSE control_files 1 1 "/u01/app/oracle/oradata/V1123/ control01.ctl"   FALSE FALSE TRUE FALSE FALSE FALSE 2 control file names list
6 FALSE FALSE control_files 1 2 "/u01/app/oracle/fast_recovery_area/ V1123/control02.ctl"   FALSE FALSE TRUE FALSE FALSE FALSE 2 control file names list
7 FALSE FALSE db_block_size 1 1 "8192"   FALSE FALSE TRUE FALSE FALSE FALSE 3 Size of database block in bytes
8 FALSE FALSE db_name 1 1 "V1123"   FALSE FALSE TRUE FALSE FALSE FALSE 2 database name specified in CREATE DATABASE
9 FALSE FALSE db_recovery_file_dest 1 1 "/u01/app/oracle/fast_recovery_area"   FALSE FALSE TRUE FALSE IMMEDIATE FALSE 2 default database recovery file location
10 FALSE FALSE db_recovery_file_dest_size 1 1 "4322230272" "4122M" FALSE FALSE TRUE FALSE IMMEDIATE FALSE 6 database recovery files size limit
11 FALSE FALSE diagnostic_dest 1 1 "/u01/app/oracle"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 2 diagnostic base directory
12 FALSE FALSE dispatchers 1 1 "(PROTOCOL=TCP) (SERVICE=V1123XDB)"   FALSE FALSE FALSE FALSE IMMEDIATE TRUE 2 specifications of dispatchers
13 FALSE FALSE open_cursors 1 1 "300"   FALSE FALSE TRUE FALSE IMMEDIATE TRUE 3 max # cursors per session
14 FALSE FALSE processes 1 1 "150"   FALSE FALSE TRUE FALSE FALSE FALSE 3 user processes
15 FALSE FALSE remote_login_passwordfile 1 1 "EXCLUSIVE"   FALSE FALSE TRUE FALSE FALSE FALSE 2 password file usage parameter
16 FALSE FALSE sga_target 1 1 "645922816" "616M" FALSE FALSE TRUE FALSE IMMEDIATE TRUE 6 Target size of SGA
17 FALSE FALSE streams_pool_size 1 1 "41943040" "40M" FALSE FALSE FALSE FALSE IMMEDIATE TRUE 6 size in bytes of the streams pool
18 FALSE FALSE undo_tablespace 1 1 "UNDOTBS1"   FALSE FALSE TRUE FALSE IMMEDIATE TRUE 2 use/switch undo tablespace
19 TRUE MODIFIED max_dump_file_size 1 1 "UNLIMITED"   FALSE FALSE FALSE TRUE IMMEDIATE TRUE 2 Maximum size (in bytes) of dump file
20 TRUE MODIFIED nls_date_format 1 1 "DD-MON-RR"   FALSE FALSE FALSE TRUE FALSE FALSE 2 NLS Oracle date format
21 TRUE MODIFIED nls_numeric_characters 1 1 ".,"   FALSE FALSE FALSE TRUE FALSE FALSE 2 NLS numeric characters
22 TRUE MODIFIED nls_timestamp_format 1 1 "DD-MON-RR HH.MI.SSXFF AM"   FALSE FALSE FALSE TRUE FALSE FALSE 2 time stamp format
23 TRUE MODIFIED nls_timestamp_tz_format 1 1 "DD-MON-RR HH.MI.SSXFF AM TZR"   FALSE FALSE FALSE TRUE FALSE FALSE 2 timestamp with timezone format
24 TRUE MODIFIED timed_statistics 1 1 "TRUE"   FALSE FALSE FALSE TRUE IMMEDIATE TRUE 1 maintain internal timing statistics
25 TRUE MODIFIED tracefile_identifier 1 1 "S53241_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.
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
1 _cursor_bind_capture_interval 1 2013-02-04/08:00:48.825 6055 FALSE MODIFIED "900" N
2 _cursor_bind_capture_interval 1 2013-02-04/06:30:45.999 6049 FALSE MODIFIED "10" N
3 _cursor_bind_capture_interval 1 2013-01-26/23:00:29.146 5849 FALSE FALSE "900" 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.
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".
SQL: [+]
# Snapshot Time Snap ID Is Default1 Is Modified2 Parameter Name Inst ID Value
1 2013-02-04/11:00:06.236 6058 FALSE MODIFIED _cursor_bind_capture_interval 1 "900"
2 2013-02-04/11:00:06.236 6058 FALSE MODIFIED _optimizer_use_feedback 1 "TRUE"
3 2013-02-04/11:00:06.236 6058 FALSE MODIFIED statistics_level 1 "ALL"
4 2013-02-04/11:00:06.236 6058 FALSE FALSE __db_cache_size 1 "201326592"
5 2013-02-04/11:00:06.236 6058 FALSE FALSE __java_pool_size 1 "4194304"
6 2013-02-04/11:00:06.236 6058 FALSE FALSE __large_pool_size 1 "4194304"
7 2013-02-04/11:00:06.236 6058 FALSE FALSE __oracle_base 1 "/u01/app/oracle"
8 2013-02-04/11:00:06.236 6058 FALSE FALSE __pga_aggregate_target 1 "213909504"
9 2013-02-04/11:00:06.236 6058 FALSE FALSE __sga_target 1 "645922816"
10 2013-02-04/11:00:06.236 6058 FALSE FALSE __shared_io_pool_size 1 ""
11 2013-02-04/11:00:06.236 6058 FALSE FALSE __shared_pool_size 1 "385875968"
12 2013-02-04/11:00:06.236 6058 FALSE FALSE __streams_pool_size 1 "41943040"
13 2013-02-04/11:00:06.236 6058 FALSE FALSE audit_file_dest 1 "/u01/app/oracle/admin/V1123/adump"
14 2013-02-04/11:00:06.236 6058 FALSE FALSE audit_trail 1 "DB"
15 2013-02-04/11:00:06.236 6058 FALSE FALSE compatible 1 "11.2.0.0.0"
16 2013-02-04/11:00:06.236 6058 FALSE FALSE control_files 1 "/u01/app/oracle/oradata/V1123/ control01.ctl,  /u01/app/oracle/fast_recovery_area/ V1123/control02.ctl"
17 2013-02-04/11:00:06.236 6058 FALSE FALSE db_block_size 1 "8192"
18 2013-02-04/11:00:06.236 6058 FALSE FALSE db_name 1 "V1123"
19 2013-02-04/11:00:06.236 6058 FALSE FALSE db_recovery_file_dest 1 "/u01/app/oracle/fast_recovery_area"
20 2013-02-04/11:00:06.236 6058 FALSE FALSE db_recovery_file_dest_size 1 "4322230272"
21 2013-02-04/11:00:06.236 6058 FALSE FALSE diagnostic_dest 1 "/u01/app/oracle"
22 2013-02-04/11:00:06.236 6058 FALSE FALSE dispatchers 1 "(PROTOCOL=TCP) (SERVICE=V1123XDB)"
23 2013-02-04/11:00:06.236 6058 FALSE FALSE open_cursors 1 "300"
24 2013-02-04/11:00:06.236 6058 FALSE FALSE pga_aggregate_target 1 "213909504"
25 2013-02-04/11:00:06.236 6058 FALSE FALSE processes 1 "150"
26 2013-02-04/11:00:06.236 6058 FALSE FALSE remote_login_passwordfile 1 "EXCLUSIVE"
27 2013-02-04/11:00:06.236 6058 FALSE FALSE sga_target 1 "645922816"
28 2013-02-04/11:00:06.236 6058 FALSE FALSE streams_pool_size 1 "41943040"
29 2013-02-04/11:00:06.236 6058 FALSE FALSE undo_tablespace 1 "UNDOTBS1"
30 2013-02-04/11:00:06.236 6058 TRUE MODIFIED _dml_frequency_tracking 1 "FALSE"
# Snapshot Time Snap ID Is Default1 Is Modified2 Parameter Name Inst ID Value
31 2013-02-04/11:00:06.236 6058 TRUE MODIFIED _dml_monitoring_enabled 1 "TRUE"
32 2013-02-04/11:00:06.236 6058 TRUE MODIFIED _pga_max_size 1 "1717985280"
33 2013-02-04/11:00:06.236 6058 TRUE MODIFIED optimizer_secure_view_merging 1 "TRUE"
34 2013-02-04/11:00:06.236 6058 TRUE MODIFIED parallel_threads_per_cpu 1 ""
(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.
Go to Top

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 WE8MSWIN1252
3 nls_comp 1 BINARY
4 nls_currency 1 $
5 nls_date_format 1 DD-MON-RR
6 nls_date_language 1 AMERICAN
7 nls_dual_currency 1 $
8 nls_iso_currency 1 AMERICA
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 AMERICA
16 nls_timestamp_format 1 DD-MON-RR HH.MI.SSXFF AM
17 nls_timestamp_tz_format 1 DD-MON-RR HH.MI.SSXFF AM TZR
18 nls_time_format 1 HH.MI.SSXFF AM
19 nls_time_tz_format 1 HH.MI.SSXFF AM 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 AMERICA
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 WE8MSWIN1252
3 nls_comp BINARY
4 nls_currency $
5 nls_date_format DD-MON-RR
6 nls_date_language AMERICAN
7 nls_dual_currency $
8 nls_iso_currency AMERICA
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 AMERICA
17 nls_timestamp_format DD-MON-RR HH.MI.SSXFF AM
18 nls_timestamp_tz_format DD-MON-RR HH.MI.SSXFF AM TZR
19 nls_time_format HH.MI.SSXFF AM
20 nls_time_tz_format HH.MI.SSXFF AM 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 TRUE addm_reports 6 6 6 0-9999
2 TRUE ash_reports BOTH BOTH BOTH BOTH, MEM, AWR, NONE
3 TRUE automatic_workload_repository Y Y Y Y, N
4 TRUE awr_reports 6 6 6 0-9999
5 TRUE bde_chk_cbo Y Y Y Y, N
6 TRUE c_awr_hist_days 31 31 31 0-999
7 TRUE c_cbo_stats_vers_days 31 31 31 0-999
8 TRUE c_dba_hist_parameter Y Y Y Y, N
9 TRUE c_gran_cols SUBPARTITION SUBPARTITION SUBPARTITION SUBPARTITION, PARTITION, GLOBAL
10 TRUE c_gran_hgrm SUBPARTITION SUBPARTITION SUBPARTITION SUBPARTITION, PARTITION, GLOBAL
11 TRUE c_gran_segm SUBPARTITION SUBPARTITION SUBPARTITION SUBPARTITION, PARTITION, GLOBAL
12 TRUE collect_perf_stats Y Y Y Y, N
13 TRUE connect_identifier Null, or @connect_identifier
14 TRUE count_star_threshold 10000 10000 10000 0-1000000000
15 TRUE custom_sql_profile N N N N, Y
16 TRUE distributed_queries Y Y Y Y, N
17 TRUE domain_index_metadata Y Y Y Y, N, E
18 TRUE event_10046_level 12 12 12 12, 8, 4, 1, 0
19 TRUE event_10053_level 1 1 1 1, 0
20 TRUE event_10507_level 1023 1023 1023 0-1023
21 TRUE event_others N N N N, Y
22 TRUE export_repository Y Y Y Y, N
23 TRUE export_utility EXP EXP EXP EXP, EXPDP
24 TRUE generate_10053_xtract Y Y Y N, Y, E
25 TRUE healthcheck_blevel Y Y Y Y, N
26 TRUE healthcheck_endpoints Y Y Y Y, N
27 TRUE healthcheck_ndv Y Y Y Y, N
28 TRUE healthcheck_num_rows Y Y Y Y, N
29 TRUE keep_trace_10046_open Y Y Y Y, N
30 TRUE keyword_font_color crimson crimson crimson crimson, red, orange, green, none
# Is Default Name System Value1 Session Value2 Default Value Domain
31 TRUE mask_for_values CLEAR CLEAR CLEAR CLEAR, SECURE, COMPLETE
32 TRUE plan_stats BOTH BOTH BOTH BOTH, LAST, ALL
33 TRUE predicates_in_plan Y Y Y N, Y, E
34 TRUE r_gran_cols PARTITION PARTITION PARTITION PARTITION, GLOBAL
35 TRUE r_gran_hgrm PARTITION PARTITION PARTITION PARTITION, GLOBAL
36 TRUE r_gran_segm PARTITION PARTITION PARTITION PARTITION, GLOBAL
37 TRUE r_gran_vers COLUMN COLUMN COLUMN COLUMN, SEGMENT, HISTOGRAM
38 TRUE r_rows_table_l 1000 1000 1000 100-10000
39 TRUE r_rows_table_m 300 300 300 30-3000
40 TRUE r_rows_table_s 100 100 100 10-1000
41 TRUE r_rows_table_xs 10 10 10 1-100
42 TRUE refresh_directories Y Y Y Y, N
43 TRUE search_sql_by_sqltext Y Y Y Y, N
44 TRUE show_binds_in_predicates Y Y Y Y, N
45 TRUE skip_metadata_for_object Null, or full/partial object name
46 TRUE sql_monitor_reports 12 12 12 1-9999
47 TRUE sql_monitoring Y Y Y Y, N
48 TRUE sql_tuning_advisor Y Y Y Y, N
49 TRUE sql_tuning_set Y Y Y Y, N
50 TRUE sqldx_reports_format BOTH BOTH BOTH HTML, CSV, BOTH, NONE
51 TRUE sqlt_max_file_size_mb 100 100 100 1-1024
52 TRUE sta_time_limit_secs 1800 1800 1800 30-86400
53 TRUE tcb_export_data FALSE FALSE FALSE FALSE, TRUE
54 TRUE tcb_time_limit_secs 1800 1800 1800 30-86400
55 TRUE test_case_builder Y Y Y Y, N
56 TRUE trace_analyzer Y Y Y Y, N
57 TRUE traces_directory_path Null, valid directory path on server
58 TRUE upload_trace_size_mb 100 100 100 1-1024
59 TRUE validate_user Y Y Y Y, N
60 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 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 3F94442C 2816325939 [B] [W] 91.720 87.717 0.460 0.000 0.000 0.000 62498 44795 0 2766 3 2013-02-04/10:59:09 2013-02-04/11:00:41 30.573 29.239 0.153 0.000 0.000 0.000 20833 14932 0 922 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 3F94442C 2816325939 [B] [W] Y Y 62498 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 0
2 Y 1 0 1 0
3 Y 1 0 2 3
(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.010974 0.013413 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 4215520196 Y 1 20234000 21218 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 2816325939 [B] [W]
Go to Captured Binds
Go to Plans Summary
Go to Top

Peeked Binds for 2816325939 [B] [W]

SQL Text: [-]
SELECT /*+ gather_plan_statistics monitor bind_aware */
       /* sqlt_s53241 */
       v.customer_name,
       v.orders_total,
       v.credit_limit,
       (orders_total - credit_limit) over_limit
  FROM customer_v v
 WHERE orders_total > credit_limit
   AND customer_type = :b1
 ORDER BY
       over_limit DESC

Summary
SQL: [+]
# Name Type Values Peeked Non-null Values Distinct Values Minimum Value Maximum Value1
1 :B1 VARCHAR2(32) 7 7 1 "4"
(1) Only if different than Minimum Value.
Source: GV$SQL_PLAN
SQL: [+]
Details: [+]
Source: DBA_HIST_SQL_PLAN
SQL: [+]
Details: [+]
Source: DBA_SQLTUNE_PLANS
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 2816325939 [B] [W]
Go to Peeked Binds
Go to Plans Summary
Go to Top

Captured Binds for 2816325939 [B] [W]

SQL Text: [-]
SELECT /*+ gather_plan_statistics monitor bind_aware */
       /* sqlt_s53241 */
       v.customer_name,
       v.orders_total,
       v.credit_limit,
       (orders_total - credit_limit) over_limit
  FROM customer_v v
 WHERE orders_total > credit_limit
   AND customer_type = :b1
 ORDER BY
       over_limit DESC

Summary
SQL: [+]
# Name Type Values Captured Non-null Values Distinct Values Minimum Value Maximum Value1
1 :B1 VARCHAR2(32) 2 2 1 "4"
(1) Only if different than Minimum Value.
Source: GV$SQL_PLAN
SQL: [+]
Details: [+]
Source: DBA_HIST_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 2816325939 [B] [W] 30.573 29.239 0.153 0.000 20833 14932 0 922 3 189 1 1 0 MEM GV$SQLAREA_PLAN_HASH Y 1504581476 19528 154 234.336 2013-02-04/10:59:09 2013-02-04/10:59:09 2013-02-04/10:59:09
2 657302870 XPL EXPLAIN PLAN FOR 21392 2102 256.704 2013-02-04/11:00:49
(1) [B]est and [W]orst according to average elapsed time if available, 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 2816325939 [B] [W] MEM GV$SQLAREA_PLAN_HASH Y 1 Stats 91.720 87.717 0.460 0.000 62498 44795 0 2766 3 189 1 1 0 1 1504581476 19528 2013-02-04/10:59:09 2013-02-04/10:59:09 2013-02-04/10:59:09
2 2816325939 [B] [W] AWR DBA_HIST_SQLSTAT 1 Stats 68.225 65.864 0.356 0.000 51794 34276 0 1844 3 126 1 1 0 1 1504581476 19528 2013-02-04/10:59:09 2013-02-04/10:00:39 2013-02-04/11:00:06
(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 2816325939 [B] [W]

Plan Hash Value: 2816325939 [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: 91.720
CPU Time in secs: 87.717
User I/O Wait Time in secs: 0.460
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: 62498
Disk Reads: 44795
Direct Writes: 0
Rows Processed: 2766
Parse Calls: 3
Fetches: 189
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-02-04/10:59:09
Last Load Time: 2013-02-04/10:59:09
Last Active Time: 2013-02-04/11:00:41
Plan Timestamp: 2013-02-04/10:59:09
Sharable Memory: 45234
Persistent Memory: 25296
Runtime Memory: 24508
Sorts: 3
Serializable Aborts: 0
Command Type: 3
Optimizer Mode: ALL_ROWS
Optimizer Env: 1504581476
Optimizer Cost: 19528
Parsing User ID: 92
Parsing Schema ID: 92
Parsing Schema Name: QTUNE
Module: sqltxadmin.sqlt$a (xecute)
Action: 53241 44707 ALTER SESSION SET EV
SQL Profile: "null"
Exact Matching Signature: 17810495099954579021
Force Matching Signature: 17810495099954579021
Outline Category: "null"
Remote: N
Object Status: VALID
Program ID: 0
Program Line #: 0
Typecheck Memory: 0
I/O Interconnect Bytes: 366960640
Physical Read Requests: 1262
Physical Read Bytes: 366960640
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
Plan Hash Value: 2816325939 [B] [W]
Src: AWR
Source: DBA_HIST_SQLSTAT
Inst ID: 1
Version Count: 1
Executions: 3
Elapsed Time in secs: 68.225
CPU Time in secs: 65.864
User I/O Wait Time in secs: 0.356
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: 51794
Disk Reads: 34276
Direct Writes: 0
Rows Processed: 1844
Parse Calls: 3
Fetches: 126
End of Fetch count: 2
PX Servers Executions: 0
Loaded Versions: 1
Loads: 1
Invalidations: 0
First Load Time: 2013-02-04/10:00:39
Last Load Time: 2013-02-04/11:00:06
Snap ID: 6058
Snap Begin Date: 2013-02-04/10:00:39
Snap End Date: 2013-02-04/11:00:06
Plan Timestamp: 2013-02-04/10:59:09
Sharable Memory: 45234
Sorts: 3
Optimizer Mode: ALL_ROWS
Optimizer Env: 1504581476
Optimizer Cost: 19528
Parsing User ID: 92
Parsing Schema ID: 92
Parsing Schema Name: QTUNE
Module: sqltxadmin.sqlt$a (xecute)
Action: 53241 44707 ALTER SESSION SET EV
SQL Profile: "null"
Force Matching Signature: 17810495099954579021
Outline Category: "null"
I/O Interconnect Bytes: 280788992
Physical Read Requests: 1096
Physical Read Bytes: 280788992
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

Plan Performance History (delta)

List restricted up to 1000 rows as per tool parameter "r_rows_table_l".
SQL: [+]
# Snap ID Begin Time End Time Startup Time Inst ID Plan Hash Value Opt Env Hash Value Cost Opt Mode Vers Count Sharable Mem Loaded Versions SQL Profile Parsing Schema ID Parsing Schema Name Parsing User ID Executions (delta) Elapsed Time in secs (delta) CPU Time in secs (delta) I/O Wait Time in secs (delta) Appl Wait Time in secs (delta) Conc Wait Time in secs (delta) Clust Wait Time in secs (delta) PL/SQL Wait Time in secs (delta) Java Wait Time in secs (delta) Buffer Gets (delta) Disk Reads (delta) Direct Writes (delta) Rows Processed (delta) Parse Calls (delta) Fetches (delta) End of Fetch Count (delta) PX Server Execs (delta) Loads (delta) Invalidations (delta) Sorts (delta) Physical Read Requests (delta) Physical Read Bytes (delta) Physical Write Requests (delta) Physical Write Bytes (delta) Optimizer Physical Reads (delta) Cell Uncompressed Bytes (delta) I/O Offload Elig Bytes (delta) I/O Offload Return Bytes (delta) I/O Interconnect Bytes (delta)
1 6058 2013-02-04/10:00:39 2013-02-04/11:00:06 2013-01-03/08:23:56.000 1 2816325939 [B][W] 1504581476 19528 ALL_ROWS 1 45234 1 92 QTUNE 92 3 68.225 65.864 0.356 0.000 0.000 0.000 0.000 0.000 51794 34276 0 1844 3 126 2 0 0 0 3 1096 280788992 0 0 0 0 0 0 280788992
Go to Execution Plans
Go to Plans Summary
Go to Top

Plan Performance History (total)

List restricted up to 1000 rows as per tool parameter "r_rows_table_l".
SQL: [+]
# Snap ID Begin Time End Time Startup Time Inst ID Plan Hash Value Opt Env Hash Value Cost Opt Mode Vers Count Sharable Mem Loaded Versions SQL Profile Parsing Schema ID Parsing Schema Name Parsing User ID Executions (total) Elapsed Time in secs (total) CPU Time in secs (total) I/O Wait Time in secs (total) Appl Wait Time in secs (total) Conc Wait Time in secs (total) Clust Wait Time in secs (total) PL/SQL Wait Time in secs (total) Java Wait Time in secs (total) Buffer Gets (total) Disk Reads (total) Direct Writes (total) Rows Processed (total) Parse Calls (total) Fetches (total) End of Fetch Count (total) PX Server Execs (total) Loads (total) Invalidations (total) Sorts (total) Physical Read Requests (total) Physical Read Bytes (total) Physical Write Requests (total) Physical Write Bytes (total) Optimizer Physical Reads (total) Cell Uncompressed Bytes (total) I/O Offload Elig Bytes (total) I/O Offload Return Bytes (total) I/O Interconnect Bytes (total)
1 6058 2013-02-04/10:00:39 2013-02-04/11:00:06 2013-01-03/08:23:56.000 1 2816325939 [B][W] 1504581476 19528 ALL_ROWS 1 45234 1 92 QTUNE 92 3 68.225 65.864 0.356 0.000 0.000 0.000 0.000 0.000 51794 34276 0 1844 3 126 2 0 1 0 3 1096 280788992 0 0 0 0 0 0 280788992
Go to Execution Plans
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 657302870 92811 38096 XPL PLAN_TABLE ALL_ROWS 21392 2102 2013-02-04/11:00:49 1162
2 2816325939 [B] [W] 25354 56337 MEM GV$SQL_PLAN Y ALL_ROWS 19528 154 922 2013-02-04/10:59:09 1
3 2816325939 [B] [W] 25354 25354 AWR DBA_HIST_SQL_PLAN ALL_ROWS 19528 154 615 2013-02-04/10:59:09
4 2816325939 [B] [W] 25354 70639 STA DBA_SQLTUNE_PLANS ALL_ROWS 19528 154 2013-02-04/11:13:30 31365 7120 Original
(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 10 per phv as per tool parameter "r_rows_table_xs".
Go to Plan Performance Statistics
Go to Plans Summary
Go to Top

Execution Plan  phv:657302870  sqlt_phv:92811  sqlt_phv2:38096  source:PLAN_TABLE  timestamp:2013-02-04/11:00:49

SQL Text: [-]
SELECT /*+ gather_plan_statistics monitor bind_aware */
       /* sqlt_s53241 */
       v.customer_name,
       v.orders_total,
       v.credit_limit,
       (orders_total - credit_limit) over_limit
  FROM customer_v v
 WHERE orders_total > credit_limit
   AND customer_type = :b1
 ORDER BY
       over_limit DESC

SQL: [+]
ID Exec Ord Operation Go To More Cost2 Estim Card
0 17 SELECT STATEMENT     21392 2102
1 16  SORT ORDER BY   [+] 21392 2102
2 15 . FILTER   [+] 21392
3 14 .. HASH GROUP BY   [+] 21392 2102
4 13 ... NESTED LOOPS   [+] 20548 49026
5 11 .... HASH JOIN   [+] 20544 49026
6 4 ....+ JOIN FILTER CREATE :BF0000   [+] 1070 49026
7 3 ....+. HASH JOIN   [+] 1070 49026
8 1 ....+.. TABLE ACCESS FULL CUSTOMER [+] [+] 220 16667
9 2 ....+.. TABLE ACCESS FULL SALES_ORDER [+] [+] 465 282210
10 10 ....+ VIEW   [+] 18836 302976
11 9 ....+. HASH GROUP BY   [+] 18836 302976
12 8 ....+.. JOIN FILTER USE :BF0000   [+] 8648 3416582
13 7 ....+... HASH JOIN   [+] 8648 3416582
14 5 ....+.... TABLE ACCESS FULL PART [+] [+] 392 200000
15 6 ....+.... TABLE ACCESS FULL ORDER_LINE [+] [+] 3609 3450201
16 12 .... INDEX UNIQUE SCAN CUSTOMER_PK [+] [+] 0 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=1): [+]
Outline Data (id=1): [+]
Leading (id=1): [+]
Go to Tables
Go to Indexes
Go to Top

Plan Info

# Type Value
1 db_version 11.2.0.3
2 parse_schema "QTUNE"
3 plan_hash 657302870
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:2816325939 [B] [W]  sqlt_phv:25354  sqlt_phv2:56337  source:GV$SQL_PLAN  inst:1  child:0(3F94442C)  executions:3  is_sharable:Y  timestamp:2013-02-04/10:59:09

SQL Text: [-]
SELECT /*+ gather_plan_statistics monitor bind_aware */
       /* sqlt_s53241 */
       v.customer_name,
       v.orders_total,
       v.credit_limit,
       (orders_total - credit_limit) over_limit
  FROM customer_v v
 WHERE orders_total > credit_limit
   AND customer_type = :b1
 ORDER BY
       over_limit DESC

SQL: [+]
ID Exec Ord Operation Go To More Peek Bind Capt Bind Cost2 Estim Card LAST
Starts
LAST
Output Rows
LAST
Over/Under Estimate1
LAST
CR Buffer Gets2
LAST
CU Buffer Gets2
LAST
Disk Reads2
LAST
Elapsed Time in secs2
ALL
Starts
ALL
Output Rows
ALL
Over/Under Estimate1
ALL
CR Buffer Gets2
ALL
CU Buffer Gets2
ALL
Disk Reads2
ALL
Elapsed Time in secs2
Work Area
0 15 SELECT STATEMENT         19528 154 1 922 6x under  
1 14  SORT ORDER BY   [+]     19528 154 1 922 6x under 20639 1 14843 31.320 3 2766 6x under 61917 3 44786 91.210 [+]
2 13 . FILTER   [+]     19528 1 922 20639 1 14843 31.318 3 2766 61917 3 44786 91.201  
3 12 .. HASH GROUP BY   [+]     19528 154 1 1176 8x under 20639 1 14843 31.316 3 3528 8x under 61917 3 44786 91.195 [+]
4 11 ... HASH JOIN   [+]     19526 3587 1 3484 1x 20639 1 14843 31.308 3 10452 1x 61917 3 44786 91.170 [+]
5 5 .... NESTED LOOPS   [+]     688 3587 1 3484 1x 5931 0 288 1.299 3 10452 1x 17793 0 973 3.730  
6 3 ....+ HASH JOIN   [+]     687 3587 1 3484 1x 2445 0 288 1.262 3 10452 1x 7335 0 764 3.596 [+]
7 1 ....+. TABLE ACCESS FULL CUSTOMER [+] [+] [+] [+] 220 1219 1 1239 1x 784 0 0 0.008 3 3717 1x 2352 0 3 0.028  
8 2 ....+. TABLE ACCESS FULL SALES_ORDER [+] [+]     465 282210 1 281792 1x 1661 0 288 0.384 3 845376 1x 4983 0 761 1.018  
9 4 ....+ INDEX UNIQUE SCAN CUSTOMER_PK [+] [+]     0 1 3484 3484 1x 3486 0 0 0.020 10452 10452 1x 10458 0 209 0.082  
10 10 .... VIEW   [+]     18836 302976 1 299998 1x 14708 1 14555 29.164 3 899994 1x 44124 3 43813 84.856  
11 9 ....+ HASH GROUP BY   [+]     18836 302976 1 299998 1x 14708 1 14555 28.617 3 899994 1x 44124 3 43813 83.161 [+]
12 8 ....+. HASH JOIN   [+]     8648 3416582 1 3450201 1x 14708 1 14555 20.172 3 10350603 1x 44124 3 43813 58.452 [+]
13 6 ....+.. TABLE ACCESS FULL PART [+] [+]     392 200000 1 200000 1x 1400 0 1398 0.230 3 600000 1x 4200 0 4195 0.697  
14 7 ....+.. TABLE ACCESS FULL ORDER_LINE [+] [+]     3609 3450201 1 3450201 1x 13308 1 13157 3.897 3 10350603 1x 39924 3 39618 11.199  
Performance statistics is 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=1): [+]
Outline Data (id=1): [+]
Leading (id=1): [+]
Go to Tables
Go to Indexes
Go to Top

Plan Info

# Type Value
1 db_version 11.2.0.3
2 parse_schema "QTUNE"
3 plan_hash 2816325939

Peeked Binds  timestamp:2013-02-04/10:59:09

# Name Type Value
1 :B1 VARCHAR2(32) "4"

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-02-04/10:59:10 :B1 VARCHAR2(32) "4"

Optimizer Environment

# Name Value
1 parallel_threads_per_cpu 1
2 _pga_max_size 1717985280
3 sqlstat_enabled true
4 statistics_level all
5 parallel_max_degree 2
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:2816325939 [B] [W]  sqlt_phv:25354  sqlt_phv2:25354  source:DBA_HIST_SQL_PLAN  timestamp:2013-02-04/10:59:09  oldest_snapshot:2013-02-04/10:00:39

SQL Text: [-]
SELECT /*+ gather_plan_statistics monitor bind_aware */
       /* sqlt_s53241 */
       v.customer_name,
       v.orders_total,
       v.credit_limit,
       (orders_total - credit_limit) over_limit
  FROM customer_v v
 WHERE orders_total > credit_limit
   AND customer_type = :b1
 ORDER BY
       over_limit DESC

SQL: [+]
ID Exec Ord Operation Go To More Cost2 Estim Card
0 15 SELECT STATEMENT     19528 154
1 14  SORT ORDER BY     19528 154
2 13 . FILTER     19528
3 12 .. HASH GROUP BY     19528 154
4 11 ... HASH JOIN     19526 3587
5 5 .... NESTED LOOPS     688 3587
6 3 ....+ HASH JOIN     687 3587
7 1 ....+. TABLE ACCESS FULL CUSTOMER [+]   220 1219
8 2 ....+. TABLE ACCESS FULL SALES_ORDER [+]   465 282210
9 4 ....+ INDEX UNIQUE SCAN CUSTOMER_PK [+] [+] 0 1
10 10 .... VIEW     18836 302976
11 9 ....+ HASH GROUP BY   [+] 18836 302976
12 8 ....+. HASH JOIN   [+] 8648 3416582
13 6 ....+.. TABLE ACCESS FULL PART [+]   392 200000
14 7 ....+.. TABLE ACCESS FULL ORDER_LINE [+]   3609 3450201
(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=1): [+]
Outline Data (id=1): [+]
Leading (id=1): [+]
Go to Tables
Go to Indexes
Go to Top

Plan Info

# Type Value
1 db_version 11.2.0.3
2 parse_schema "QTUNE"
3 plan_hash 2816325939

Peeked Binds  timestamp:2013-02-04/10:59:09

# Name Type Value
1 :B1 VARCHAR2(32) "4"

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-02-04/10:59:10 :B1 VARCHAR2(32) "4"
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:2816325939 [B] [W]  sqlt_phv:25354  sqlt_phv2:70639  source:DBA_SQLTUNE_PLANS  "Original"  timestamp:2013-02-04/11:13:30

SQL Text: [-]
SELECT /*+ gather_plan_statistics monitor bind_aware */
       /* sqlt_s53241 */
       v.customer_name,
       v.orders_total,
       v.credit_limit,
       (orders_total - credit_limit) over_limit
  FROM customer_v v
 WHERE orders_total > credit_limit
   AND customer_type = :b1
 ORDER BY
       over_limit DESC

SQL: [+]
ID Exec Ord Operation Go To More Peek Bind Cost2 Estim Card
0 15 SELECT STATEMENT       19528 154
1 14  SORT ORDER BY   [+]   19528 154
2 13 . FILTER   [+]   19528
3 12 .. HASH GROUP BY   [+]   19528 154
4 11 ... HASH JOIN   [+]   19526 3587
5 5 .... NESTED LOOPS   [+]   688 3587
6 3 ....+ HASH JOIN   [+]   687 3587
7 1 ....+. TABLE ACCESS FULL CUSTOMER [+] [+] [+] 220 1219
8 2 ....+. TABLE ACCESS FULL SALES_ORDER [+] [+]   465 282210
9 4 ....+ INDEX UNIQUE SCAN CUSTOMER_PK [+] [+]   0 1
10 10 .... VIEW   [+]   18836 302976
11 9 ....+ HASH GROUP BY   [+]   18836 302976
12 8 ....+. HASH JOIN   [+]   8648 3416582
13 6 ....+.. TABLE ACCESS FULL PART [+] [+]   392 200000
14 7 ....+.. TABLE ACCESS FULL ORDER_LINE [+] [+]   3609 3450201
(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=1): [+]
Outline Data (id=1): [+]
Leading (id=1): [+]
Go to Tables
Go to Indexes
Go to Top

Plan Info

# Type Value
1 db_version 11.2.0.3
2 parse_schema "QTUNE"
3 plan_hash 2816325939

Peeked Binds  timestamp:2013-02-04/11:13:30

# Name Type Value
1 :B1 VARCHAR2(32) "4"
Go to Execution Plans
Go to Plan Performance Statistics
Go to Plans Summary
Go to Tables
Go to Indexes
Go to Top

Active Session History

Go to Top

Active Session History by Plan

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

Active Session History by Plan Line

List below is restricted up to 1000 recent plan lines (as per tool parameter "r_rows_table_l").
SQL: [+]
# Plan
Hash
Value
Plan
Line
ID
Plan
Operation
Plan
Options
Plan
Object
Owner
Plan
Object
Name
Session
State
Wait
Class
Event Curr
Obj
ID
Curr
Object
Name
Snaps
Count
1 2816325939 4 HASH JOIN ON CPU 4
2 2816325939 6 HASH JOIN ON CPU 3
3 2816325939 10 VIEW ON CPU 1
4 2816325939 11 HASH GROUP BY ON CPU 39
5 2816325939 12 HASH JOIN ON CPU 40
6 2816325939 12 HASH JOIN ON CPU 3

Active Session History by Session

List below is restricted up to 20 recent sessions (as per 2x tool parameter "r_rows_table_xs") and up to 20 snapshots per session (as per 2x tool parameter "r_rows_table_xs").
SQL: [+]
# Inst ID SID Serial# Sample Time SQL Exec Start Is SQL_ID Current SQL Child Num Force Matching Signature SQL Plan Hash Value SQL Plan Line ID SQL Plan Operation SQL Plan Options Event P1 Text P1 P2 Text P2 P3 Text P3 Wait Class Wait Time Session State Time Waited Blocking Session Status Blocking SID Blocking Serial# Blocking Inst ID Blocking Hang Chain Info Current Obj# Current File# Current Block# Current Row# Remote Inst# Program Module Action Client ID Machine TM Delta Time TM Delta CPU Time TM Delta DB Time Delta Time Delta Read I/O Requests Delta Write I/O Requests Delta Read I/O Bytes Delta Write I/O Bytes Delta Inter Connect I/O Bytes PGA Allocated Temp Space Allocated
1 1 142 39231 2013-02-04/11:00:41.728 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 10 VIEW file number 4 first dba 120768 block cnt 64 355 ON CPU 0 NOT IN WAIT 107094 4 120831 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 1001500 0 0 0 0 0 33996800 2097152
2 1 142 39231 2013-02-04/11:00:40.728 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 4 HASH JOIN file number 4 first dba 120768 block cnt 64 355 ON CPU 0 NOT IN WAIT 107094 4 120831 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 1998981 1972123 1998981 1000257 3 0 1572864 0 1572864 36880384 2097152
3 1 142 39231 2013-02-04/11:00:39.728 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 120576 block cnt 64 358 ON CPU 0 NOT IN WAIT 107094 4 120560 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 1000236 12 0 6291456 0 6291456 44285952 2097152
4 1 142 39231 2013-02-04/11:00:38.728 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 12 HASH JOIN file number 4 first dba 119872 block cnt 64 775 ON CPU 0 NOT IN WAIT 107094 4 119813 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 2000883 1984124 2000883 1010270 8 0 4161536 0 4161536 44285952 2097152
5 1 142 39231 2013-02-04/11:00:37.718 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 12 HASH JOIN file number 4 first dba 119296 block cnt 64 790 ON CPU 0 NOT IN WAIT 107094 4 119288 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 1000241 8 0 4194304 0 4194304 44285952 2097152
6 1 142 39231 2013-02-04/11:00:36.718 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 12 HASH JOIN file number 4 first dba 118788 block cnt 60 660 ON CPU 0 NOT IN WAIT 107094 4 118766 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 2012942 1744109 2012942 999793 8 0 4161536 0 4161536 44285952 2097152
7 1 142 39231 2013-02-04/11:00:35.718 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 118336 block cnt 64 792 ON CPU 0 NOT IN WAIT 107094 4 118290 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 1002573 6 0 3145728 0 3145728 44285952 2097152
8 1 142 39231 2013-02-04/11:00:34.718 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 117888 block cnt 64 800 ON CPU 0 NOT IN WAIT 107094 4 117851 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 2008182 1856116 2008182 1008869 9 0 4685824 0 4685824 44285952 2097152
9 1 142 39231 2013-02-04/11:00:33.708 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 117376 block cnt 64 791 ON CPU 0 NOT IN WAIT 107094 4 117369 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 999232 6 0 3145728 0 3145728 44285952 2097152
10 1 142 39231 2013-02-04/11:00:32.708 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 116928 block cnt 64 792 ON CPU 0 NOT IN WAIT 107094 4 116887 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 2011387 1732108 2011387 999634 8 0 4161536 0 4161536 44285952 2097152
11 1 142 39231 2013-02-04/11:00:31.708 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 12 HASH JOIN file number 4 first dba 111488 block cnt 64 480 ON CPU 0 NOT IN WAIT 107094 4 111424 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 1003351 6 0 3145728 0 3145728 44285952 2097152
12 1 142 39231 2013-02-04/11:00:30.708 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 111040 block cnt 64 775 ON CPU 0 NOT IN WAIT 107094 4 110995 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 2006579 1824115 2006579 999759 8 0 4153344 0 4153344 44285952 2097152
13 1 142 39231 2013-02-04/11:00:29.708 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 110528 block cnt 64 502 ON CPU 0 NOT IN WAIT 107094 4 110524 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 1012331 8 0 4128768 0 4128768 44285952 2097152
14 1 142 39231 2013-02-04/11:00:28.688 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 12 HASH JOIN file number 4 first dba 110082 block cnt 62 763 ON CPU 0 NOT IN WAIT 107094 4 110032 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 2008859 1908119 2008859 999210 8 0 4128768 0 4128768 44285952 2097152
15 1 142 39231 2013-02-04/11:00:27.688 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 109570 block cnt 62 667 ON CPU 0 NOT IN WAIT 107094 4 109548 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 1003189 8 0 4128768 0 4128768 44285952 2097152
16 1 142 39231 2013-02-04/11:00:26.688 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 12 HASH JOIN file number 4 first dba 109058 block cnt 62 302 ON CPU 0 NOT IN WAIT 107094 4 109039 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 2001261 1984123 2001261 1000114 8 0 4128768 0 4128768 44285952 2097152
17 1 142 39231 2013-02-04/11:00:25.688 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 12 HASH JOIN file number 4 first dba 108546 block cnt 62 292 ON CPU 0 NOT IN WAIT 107094 4 108510 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 1000139 8 0 4128768 0 4128768 44285952 2097152
18 1 142 39231 2013-02-04/11:00:24.688 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 12 HASH JOIN file number 4 first dba 108034 block cnt 62 320 ON CPU 0 NOT IN WAIT 107094 4 107984 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 2004493 1920121 2004493 1000155 8 0 4128768 0 4128768 44285952 2097152
19 1 142 39231 2013-02-04/11:00:23.688 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 107522 block cnt 62 292 ON CPU 0 NOT IN WAIT 107094 4 107456 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 1010143 8 0 4128768 0 4128768 44023808 2097152
20 1 142 39231 2013-02-04/11:00:22.678 2013-02-04/11:00:10 Y 0 17810495099954579021 2816325939 12 HASH JOIN file number 4 first dba 106944 block cnt 64 1120 ON CPU 0 NOT IN WAIT 107094 4 106941 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 2014788 1828114 2014788 1005538 8 0 4128768 0 4128768 43237376 2097152
Go to Top

AWR Active Session History

Go to Top

AWR Active Session History by Plan

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

AWR Active Session History by Plan Line

List below is restricted up to 1000 recent plan lines (as per tool parameter "r_rows_table_l").
SQL: [+]
# Plan
Hash
Value
Plan
Line
ID
Plan
Operation
Plan
Options
Plan
Object
Owner
Plan
Object
Name
Session
State
Wait
Class
Event Curr
Obj
ID
Curr
Object
Name
Snaps
Count
1 2816325939 11 HASH GROUP BY ON CPU 3
2 2816325939 12 HASH JOIN ON CPU 1

AWR Active Session History by Session

List below is restricted up to 20 historical sessions (as per 2x tool parameter "r_rows_table_xs") and up to 20 snapshots per session (as per 2x tool parameter "r_rows_table_xs").
SQL: [+]
# Inst ID SID Serial# Sample Time SQL Exec Start Is SQL_ID Current SQL Child Num Force Matching Signature SQL Plan Hash Value SQL Plan Line ID SQL Plan Operation SQL Plan Options Event P1 Text P1 P2 Text P2 P3 Text P3 Wait Class Wait Time Session State Time Waited Blocking Session Status Blocking SID Blocking Serial# Blocking Inst ID Blocking Hang Chain Info Current Obj# Current File# Current Block# Current Row# Remote Inst# Program Module Action Client ID Machine TM Delta Time TM Delta CPU Time TM Delta DB Time Delta Time Delta Read I/O Requests Delta Write I/O Requests Delta Read I/O Bytes Delta Write I/O Bytes Delta Inter Connect I/O Bytes PGA Allocated Temp Space Allocated
1 1 142 39231 2013-02-04/10:59:47.598 2013-02-04/10:59:40 Y 0 17810495099954579021 2816325939 12 HASH JOIN file number 4 first dba 104962 block cnt 62 357 ON CPU 0 NOT IN WAIT 107094 4 104930 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 9012968 1460499265 84398340758391018 10010742 188 41517056 41517056 37994496 2097152
2 1 142 39231 2013-02-04/10:59:37.588 2013-02-04/10:59:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 119936 block cnt 64 807 ON CPU 0 NOT IN WAIT 107094 4 119928 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 10002866 13822583253855860492 13873223069183266797 9997975 79 41164800 41164800 41467904 2097152
3 1 142 39231 2013-02-04/10:59:27.597 2013-02-04/10:59:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 109888 block cnt 64 463 ON CPU 0 NOT IN WAIT 107094 4 109842 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 10011444 1461779345 84398340759405364 10012555 98 41951232 41951232 42516480 2097152
4 1 142 39231 2013-02-04/10:59:17.577 2013-02-04/10:59:10 Y 0 17810495099954579021 2816325939 11 HASH GROUP BY file number 4 first dba 104706 block cnt 62 324 ON CPU 0 NOT IN WAIT 107094 4 104715 0 sqlplus@host01.example.com (TNS V1-V3) sqltxadmin.sqlt$a (xecute) 53241 44707 ALTER SESSION SET EV host01.example.com 10994459 587567916 33759336308656997 10007348 442 32497664 32497664 38322176 2097152
Go to Top

SQL Statistics

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

SQL Statistics for 2816325939 [B] [W]

Inst ID: 1
Child Number: 0
Child Address: 3F94442C
Executions: 3
Elapsed Time in secs: 91.720
CPU Time in secs: 87.717
User I/O Wait Time in secs: 0.460
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: 62498
Disk Reads: 44795
Direct Writes: 0
Rows Processed: 2766
Parse Calls: 3
Fetches: 189
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-02-04/10:59:09
Last Load Time: 2013-02-04/10:59:09
Last Active Time: 2013-02-04/11:00:41
Sharable Memory: 45234
Persistent Memory: 25296
Runtime Memory: 24508
Sorts: 3
Serializable Aborts: 0
SQL Type: 6
Command Type: 3
Optimizer Mode: ALL_ROWS
Optimizer Env: 1504581476
Optimizer Cost: 19528
Parsing User ID: 92
Parsing Schema ID: 92
Parsing Schema Name: QTUNE
Service: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 53241 44707 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: 17810495099954579021
Force Matching Signature: 17810495099954579021
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: 366960640
Physical Read Requests: 1262
Physical Read Bytes: 366960640
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 10 per phv as per tool parameter "r_rows_table_xs".
# Plan Hash Value Monitored
Executions
1 2816325939 [B] [W] 3
Go to Top

SQL Monitoring for 2816325939 [B] [W] DONE (ALL ROWS) 2013-02-04/11:00:10

Status: DONE (ALL ROWS)
SQL Exec Start Time: 2013-02-04/11:00:10
SQL Exec ID: 16777218
Inst ID: 1
Process Name: ora
Key: 541165880258
Child Address: 3F94442C
Child Number: 0
Elapsed Time in secs: 31.324
Queuing Time in secs: 0.000
CPU Time in secs: 28.974
User I/O Wait Time in secs: 0.157
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: 20640
Disk Reads: 285
Direct Writes: 0
Fetches: 63
PX is Cross Instance: N
Refresh Count: 81
First Refresh Time: 2013-02-04/11:00:10
Last Refresh Time: 2013-02-04/11:00:41
User #: 92
User Name: QTUNE
Service Name: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 53241 44707 ALTER SESSION SET EV
SID: 142
Session Serial#: 39231
Exact Matching Signature: 17810495099954579021
Force Matching Signature: 17810495099954579021
Program: sqlplus@host01.example.com (TNS V1-V3)
I/O Interconnect Bytes: 121593856
Physical Read Requests: 285
Physical Read Bytes: 121593856
Physical Write Requests: 0
Physical Write Bytes: 0
Go to SQL Monitor
Go to Top

SQL Monitoring for 2816325939 [B] [W] DONE (ALL ROWS) 2013-02-04/10:59:40

Status: DONE (ALL ROWS)
SQL Exec Start Time: 2013-02-04/10:59:40
SQL Exec ID: 16777217
Inst ID: 1
Process Name: ora
Key: 21474837441
Child Address: 3F94442C
Child Number: 0
Elapsed Time in secs: 29.843
Queuing Time in secs: 0.000
CPU Time in secs: 28.834
User I/O Wait Time in secs: 0.152
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: 20640
Disk Reads: 345
Direct Writes: 0
Fetches: 63
PX is Cross Instance: N
Refresh Count: 81
First Refresh Time: 2013-02-04/10:59:40
Last Refresh Time: 2013-02-04/11:00:10
User #: 92
User Name: QTUNE
Service Name: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 53241 44707 ALTER SESSION SET EV
SID: 142
Session Serial#: 39231
Exact Matching Signature: 17810495099954579021
Force Matching Signature: 17810495099954579021
Program: sqlplus@host01.example.com (TNS V1-V3)
I/O Interconnect Bytes: 122937344
Physical Read Requests: 345
Physical Read Bytes: 122937344
Physical Write Requests: 0
Physical Write Bytes: 0
Go to SQL Monitor
Go to Top

SQL Monitoring for 2816325939 [B] [W] DONE (ALL ROWS) 2013-02-04/10:59:10

Status: DONE (ALL ROWS)
SQL Exec Start Time: 2013-02-04/10:59:10
SQL Exec ID: 16777216
Inst ID: 1
Process Name: ora
Key: 128849019839
Child Address: 3F94442C
Child Number: 0
Elapsed Time in secs: 30.553
Queuing Time in secs: 0.000
CPU Time in secs: 29.910
User I/O Wait Time in secs: 0.151
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: 21218
Disk Reads: 632
Direct Writes: 0
Fetches: 63
PX is Cross Instance: N
Refresh Count: 81
First Refresh Time: 2013-02-04/10:59:10
Last Refresh Time: 2013-02-04/10:59:40
User #: 92
User Name: QTUNE
Service Name: SYS$USERS
Module: sqltxadmin.sqlt$a (xecute)
Action: 53241 44707 ALTER SESSION SET EV
SID: 142
Session Serial#: 39231
Exact Matching Signature: 17810495099954579021
Force Matching Signature: 17810495099954579021
Program: sqlplus@host01.example.com (TNS V1-V3)
I/O Interconnect Bytes: 122429440
Physical Read Requests: 632
Physical Read Bytes: 122429440
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 "input/sample/script2.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 34649488 logical reads PART_PK QTUNE INDEX 1 USERS 107088 107088
2 178956 physical reads direct SALES_ORDER QTUNE TABLE 1 USERS 107090 107090
3 94850 physical reads ORDER_LINE_PK QTUNE INDEX 1 USERS 107095 107095
4 75580 physical reads direct ORDER_LINE_PK QTUNE INDEX 1 USERS 107095 107095
5 63872 logical reads ORDER_LINE_PK QTUNE INDEX 1 USERS 107095 107095
6 53040 physical reads direct CUSTOMER QTUNE TABLE 1 USERS 107082 107082
7 50768 logical reads ORDER_LINE_N1 QTUNE INDEX 1 USERS 107096 107096
8 39920 logical reads ORDER_LINE QTUNE TABLE 1 USERS 107094 107094
9 39618 physical reads ORDER_LINE QTUNE TABLE 1 USERS 107094 107094
10 39471 physical reads direct ORDER_LINE QTUNE TABLE 1 USERS 107094 107094
11 28352 logical reads SALES_ORDER_PK QTUNE INDEX 1 USERS 107091 107091
12 24128 logical reads SALES_ORDER_N2 QTUNE INDEX 1 USERS 107093 107093
13 22878 physical reads SALES_ORDER_PK QTUNE INDEX 1 USERS 107091 107091
14 20586 physical reads ORDER_LINE_N2 QTUNE INDEX 1 USERS 107097 107097
15 19257 physical reads ORDER_LINE_N1 QTUNE INDEX 1 USERS 107096 107096
16 19136 logical reads ORDER_LINE_N2 QTUNE INDEX 1 USERS 107097 107097
17 13574 physical read requests ORDER_LINE_N2 QTUNE INDEX 1 USERS 107097 107097
18 12883 physical reads SALES_ORDER_N2 QTUNE INDEX 1 USERS 107093 107093
19 12828 physical read requests ORDER_LINE_N1 QTUNE INDEX 1 USERS 107096 107096
20 11760 logical reads SALES_ORDER_N1 QTUNE INDEX 1 USERS 107092 107092
21 10464 logical reads CUSTOMER_PK QTUNE INDEX 1 USERS 107083 107083
22 10157 physical read requests SALES_ORDER_PK QTUNE INDEX 1 USERS 107091 107091
23 10074 physical read requests ORDER_LINE_PK QTUNE INDEX 1 USERS 107095 107095
24 7593 physical reads PART_PK QTUNE INDEX 1 USERS 107088 107088
25 6764 physical read requests PART_PK QTUNE INDEX 1 USERS 107088 107088
26 6480 logical reads CUSTOMER_N2 QTUNE INDEX 1 USERS 107085 107085
27 6270 physical reads direct SALES_ORDER_PK QTUNE INDEX 1 USERS 107091 107091
28 5977 physical read requests SALES_ORDER_N2 QTUNE INDEX 1 USERS 107093 107093
29 4992 logical reads SALES_ORDER QTUNE TABLE 1 USERS 107090 107090
30 4221 physical reads CUSTOMER_N2 QTUNE INDEX 1 USERS 107085 107085
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
31 4195 physical reads PART QTUNE TABLE 1 USERS 107087 107087
32 4194 physical reads direct PART QTUNE TABLE 1 USERS 107087 107087
33 4192 logical reads PART QTUNE TABLE 1 USERS 107087 107087
34 2640 logical reads PART_N1 QTUNE INDEX 1 USERS 107089 107089
35 2566 physical read requests CUSTOMER_N2 QTUNE INDEX 1 USERS 107085 107085
36 2352 logical reads CUSTOMER QTUNE TABLE 1 USERS 107082 107082
37 846 physical read requests PART_N1 QTUNE INDEX 1 USERS 107089 107089
38 846 physical reads PART_N1 QTUNE INDEX 1 USERS 107089 107089
39 834 physical read requests CUSTOMER_N1 QTUNE INDEX 1 USERS 107084 107084
40 834 physical reads CUSTOMER_N1 QTUNE INDEX 1 USERS 107084 107084
41 792 physical read requests ORDER_LINE QTUNE TABLE 1 USERS 107094 107094
42 761 physical reads SALES_ORDER QTUNE TABLE 1 USERS 107090 107090
43 209 physical read requests CUSTOMER_PK QTUNE INDEX 1 USERS 107083 107083
44 209 physical reads CUSTOMER_PK QTUNE INDEX 1 USERS 107083 107083
45 158 physical read requests SALES_ORDER QTUNE TABLE 1 USERS 107090 107090
46 91 physical read requests PART QTUNE TABLE 1 USERS 107087 107087
47 45 segment scans CUSTOMER_N2 QTUNE INDEX 1 USERS 107085 107085
48 29 segment scans SALES_ORDER_N2 QTUNE INDEX 1 USERS 107093 107093
49 18 segment scans CUSTOMER_PK QTUNE INDEX 1 USERS 107083 107083
50 18 segment scans PART_PK QTUNE INDEX 1 USERS 107088 107088
51 18 segment scans SALES_ORDER_PK QTUNE INDEX 1 USERS 107091 107091
52 13 segment scans ORDER_LINE_N1 QTUNE INDEX 1 USERS 107096 107096
53 13 segment scans ORDER_LINE_N2 QTUNE INDEX 1 USERS 107097 107097
54 7 segment scans ORDER_LINE_PK QTUNE INDEX 1 USERS 107095 107095
55 6 physical read requests SALES_ORDER_N1 QTUNE INDEX 1 USERS 107092 107092
56 6 physical reads SALES_ORDER_N1 QTUNE INDEX 1 USERS 107092 107092
57 3 physical read requests CUSTOMER QTUNE TABLE 1 USERS 107082 107082
58 3 physical reads CUSTOMER QTUNE TABLE 1 USERS 107082 107082
59 3 segment scans ORDER_LINE QTUNE TABLE 1 USERS 107094 107094
60 1 segment scans CUSTOMER QTUNE TABLE 1 USERS 107082 107082
# Value Statistic Name Object Name Suboject Name Owner Object Type Inst ID TableSpace Name Obj# Data Obj#
61 1 segment scans PART QTUNE TABLE 1 USERS 107087 107087
62 1 segment scans SALES_ORDER QTUNE TABLE 1 USERS 107090 107090
Go to Top

Session Statistics

Statistics below include the execution of your SQL within "input/sample/script2.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 Number of read IOs issued 735 1
2 Cache commit cleanout failures: callback failure 2 1
3 Cache commit cleanouts 69 1
4 Cache commit cleanouts successfully completed 67 1
5 Cache consistent gets 62757 1
6 Cache consistent gets - examination 10797 1
7 Cache consistent gets direct 43665 1
8 Cache consistent gets from cache 19092 1
9 Cache consistent gets from cache (fastpath) 8110 1
10 Cache db block changes 138 1
11 Cache db block gets 155 1
12 Cache db block gets from cache 155 1
13 Cache db block gets from cache (fastpath) 36 1
14 Cache dirty buffers inspected 69 1
15 Cache free buffer inspected 1885 1
16 Cache free buffer requested 1154 1
17 Cache hot buffers moved to head of LRU 2038 1
18 Cache logical read bytes from cache 157671424 1
19 Cache physical read IO requests 1271 1
20 Cache physical read bytes 367034368 1
21 Cache physical read total IO requests 1271 1
22 Cache physical read total bytes 367034368 1
23 Cache physical read total multi block requests 687 1
24 Cache physical reads 44804 1
25 Cache physical reads cache 1139 1
26 Cache physical reads cache prefetch 745 1
27 Cache physical reads direct 43665 1
28 Cache shared hash latch upgrades - no wait 216 1
29 Cache switch current to new buffer 1 1
30 Cache, SQL buffer is not pinned count 674 1
# Class Name Statistic Name Value Inst ID
31 Cache, SQL buffer is pinned count 10517 1
32 Debug CPU used when call started 9860 1
33 Debug Commit SCN cached 1 1
34 Debug IMU Flushes 3 1
35 Debug IMU Redo allocation size 8008 1
36 Debug IMU commits 5 1
37 Debug IMU undo allocation size 4300 1
38 Debug active txn count during cleanout 6 1
39 Debug calls to kcmgas 15 1
40 Debug calls to kcmgcs 514 1
41 Debug cleanout - number of ktugct calls 6 1
42 Debug commit txn count during cleanout 2 1
43 Debug cursor authentications 3 1
44 Debug deferred (CURRENT) block cleanout applications 6 1
45 Debug immediate (CURRENT) block cleanout applications 4 1
46 Debug index fetch by key 10527 1
47 Debug index scans kdiixs1 170 1
48 Debug leaf node 90-10 splits 2 1
49 Debug leaf node splits 2 1
50 Debug messages sent 3 1
51 Debug no work - consistent read gets 51438 1
52 Debug redo synch time (usec) 1699000 1
53 Debug undo change vector size 35364 1
54 Enqueue enqueue releases 46 1
55 Enqueue enqueue requests 33 1
56 OS OS Involuntary context switches 11296 1
57 OS OS Page faults 1 1
58 OS OS Page reclaims 66570 1
59 OS OS System time used 5340 1
60 OS OS User time used 4687 1
# Class Name Statistic Name Value Inst ID
61 OS OS Voluntary context switches 297 1
62 RAC calls to get snapshot scn: kcmgss 258 1
63 Redo redo entries 76 1
64 Redo redo ordering marks 3 1
65 Redo redo size 109252 1
66 Redo redo subscn max counts 18 1
67 Redo redo synch time 170 1
68 Redo redo synch writes 1 1
69 SQL HSC Heap Segment Block Changes 16 1
70 SQL Heap Segment Array Inserts 8 1
71 SQL Heap Segment Array Updates 2 1
72 SQL cell physical IO interconnect bytes 367034368 1
73 SQL cluster key scan block gets 58 1
74 SQL cluster key scans 55 1
75 SQL execute count 256 1
76 SQL parse count (hard) 17 1
77 SQL parse count (total) 27 1
78 SQL parse time cpu 14 1
79 SQL parse time elapsed 13 1
80 SQL rows fetched via callback 8 1
81 SQL session cursor cache count 48 1
82 SQL session cursor cache hits 248 1
83 SQL sorts (memory) 72 1
84 SQL sorts (rows) 3013 1
85 SQL sql area evicted 4 1
86 SQL table fetch by rowid 185 1
87 SQL table scan blocks gotten 50980 1
88 SQL table scan rows gotten 12150623 1
89 SQL table scans (direct read) 6 1
90 SQL table scans (long tables) 6 1
# Class Name Statistic Name Value Inst ID
91 SQL table scans (short tables) 7 1
92 SQL workarea executions - optimal 69 1
93 User CPU used by this session 8803 1
94 User DB time 12606 1
95 User Requests to/from client 203 1
96 User SQL*Net roundtrips to/from client 204 1
97 User bytes received via SQL*Net from client 6660 1
98 User bytes sent via SQL*Net to client 190956 1
99 User file io wait time 102753 1
100 User non-idle wait count 1342 1
101 User non-idle wait time 163 1
102 User opened cursors cumulative 267 1
103 User recursive calls 814 1
104 User recursive cpu usage 70 1
105 User session logical reads 62912 1
106 User session pga memory 2343716 1
107 User session pga memory max 34603008 1
108 User session uga memory max 34617300 1
109 User user I/O wait time 103 1
110 User user calls 216 1
111 User user commits 7 1
Go to Top

Session Events

Statistics below include the execution of your SQL within "input/sample/script2.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 10.187626 direct path sync 1 1 10.187626 0
2 2.494785 log file switch completion 1 1 2.494785 0
3 2.155506 SQL*Net message from client 1 204 0.010566 0
4 0.622938 db file sequential read 1 321 0.001941 0
5 0.596090 log file sync 1 1 0.596090 0
6 0.439566 direct path read 1 735 0.000598 0
7 0.009719 db file scattered read 1 80 0.000121 0
8 0.002783 db file parallel read 1 2 0.001392 0
9 0.002071 utl_file I/O 1 54 0.000038 0
10 0.001053 control file sequential read 1 42 0.000025 0
11 0.000612 Disk file operations I/O 1 7 0.000087 0
12 0.000271 SQL*Net message to client 1 204 0.000001 0
13 0.000195 SQL*Net break/reset to client 1 2 0.000098 0
14 0.000144 BFILE read 1 6 0.000024 0
15 0.000068 direct path write temp 1 1 0.000068 0
16 0.000004 events in waitclass Other 1 1 0.000004 1
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 "input/sample/script2.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=142). Captured after the execution of your SQL within "input/sample/script2.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 "input/sample/script2.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=142).
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 "input/sample/script2.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=142).
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 "input/sample/script2.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=142).
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 "input/sample/script2.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 2 0 -2
Servers Highwater : 1 8 8 0
Server Sessions : 1 154 154 0
Servers Started : 1 46 46 0
Servers Shutdown : 1 44 46 2
Servers Cleaned Up : 1 0 0 0
Queries Queued : 1 0 0 0
Queries Initiated : 1 65 65 0
Queries Initiated (IPQ) : 1 0 0 0
DML Initiated : 1 0 0 0
DML Initiated (IPQ) : 1 0 0 0
DDL Initiated : 1 3 3 0
DDL Initiated (IPQ) : 1 0 0 0
DFO Trees : 1 68 68 0
Sessions Active : 1 0 0 0
Local Msgs Sent : 1 6602 6602 0
Distr Msgs Sent : 1 0 0 0
Local Msgs Recv'd : 1 6602 6602 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 "input/sample/script2.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 2 0 -2
Servers Started : 1 46 46 0
Servers Shutdown : 1 44 46 2
Servers Highwater : 1 8 8 0
Servers Cleaned Up : 1 0 0 0
Server Sessions : 1 154 154 0
Memory Chunks Allocated : 1 19 19 0
Memory Chunks Freed : 1 15 15 0
Memory Chunks Current : 1 4 4 0
Memory Chunks HWM : 1 15 15 0
Buffers Allocated : 1 870 870 0
Buffers Freed : 1 870 870 0
Buffers Current : 1 0 0 0
Buffers HWM : 1 101 101 0
Go to Parallel Processing
Go to Top

PX Session Statistics - Summary

Session statistics for Query Coordinator with SID of 142. Captured after the execution of your SQL within "input/sample/script2.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 142. Captured before and after the execution of your SQL within "input/sample/script2.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
Exten
Table
Prop
Table
Phys
Prop
Table
Cons
Table
Cols
Idxed
Cols
Table
Hgrm
Indexes Table
Meta
1 CUSTOMER QTUNE 101800 100000 100000 802 28-NOV-12 Stats 1 Prop Phys 3 5 5 2 4 Meta
2 ORDER_LINE QTUNE 3440000 3450201 3450201 13157 28-NOV-12 Stats   Prop Phys 8 6 3   3 Meta
3 PART QTUNE 204600 200000 200000 1430 28-NOV-12 Stats 1 Prop Phys 4 6 2   2 Meta
4 SALES_ORDER QTUNE 302600 300000 300000 1693 28-NOV-12 Stats 1 Prop Phys 4 6 4 1 3 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 CUSTOMER QTUNE NO N 101800 100000 100000 100.0 2012-11-28/09:55:33 22 896 896 1408 802 0 0 92 0 YES NO NO 0 0 220
2 ORDER_LINE QTUNE NO N 3440000 3450201 3450201 100.0 2012-11-28/09:56:22 84 13312 13312 13312 13157 0 0 23 0 YES NO NO 0 0 3609
3 PART QTUNE NO N 204600 200000 200000 100.0 2012-11-28/09:55:44 27 1536 1536 1792 1430 0 0 58 0 YES NO NO 0 0 392
4 SALES_ORDER QTUNE NO N 302600 300000 300000 100.0 2012-11-28/09:55:54 29 1792 1792 1792 1693 0 0 38 0 YES NO NO 0 0 464
(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 Extensions

# Table Name Owner Extension Name Creator Droppable Extension
1 CUSTOMER QTUNE SYS_NC00005$ SYSTEM NO(LOWER("CUSTOMER_NAME"))
2 PART QTUNE SYS_STUUS4P4NZTNB5ELB$CFTBUVDQ USER YES("PART_TYPE","ON_HAND")
3 SALES_ORDER QTUNE SYS_STUK0XJTEZVXUTGW1H0VTZ#WQA USER YES(SUBSTR("ORDER_NUM",1,2))
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 CUSTOMER QTUNE NO 1 1 N NO N N DEFAULT ENABLED NO DISABLED DISABLED DISABLED YES VALID NO YES
2 ORDER_LINE QTUNE NO 1 1 N NO N N DEFAULT ENABLED NO DISABLED DISABLED DISABLED YES VALID NO YES
3 PART QTUNE NO 1 1 N NO N N DEFAULT ENABLED NO DISABLED DISABLED DISABLED YES VALID NO YES
4 SALES_ORDER QTUNE 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 CUSTOMER QTUNE 10 1 255 65536 1048576 1 2147483645 YES N DEFAULT DEFAULT DEFAULT USERS DISABLED
2 ORDER_LINE QTUNE 10 1 255 65536 1048576 1 2147483645 YES N DEFAULT DEFAULT DEFAULT USERS DISABLED
3 PART QTUNE 10 1 255 65536 1048576 1 2147483645 YES N DEFAULT DEFAULT DEFAULT USERS DISABLED
4 SALES_ORDER QTUNE 10 1 255 65536 1048576 1 2147483645 YES N DEFAULT DEFAULT DEFAULT USERS DISABLED
Go to Tables
Go to Top

Table Constraints

Go to Tables
Go to Top

QTUNE.CUSTOMER - 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_C0024028"CUSTOMER_ID" IS NOT NULL 2012-11-20/06:46:39 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
2 C SYS_C0024029"CUSTOMER_TYPE" IS NOT NULL 2012-11-20/06:46:39 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
3 P CUSTOMER_PK 2012-11-20/06:46:41 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME   QTUNE CUSTOMER_PK
Go to Table Constraints

QTUNE.ORDER_LINE - 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_C0024039"LINE_ID" IS NOT NULL 2012-11-20/06:48:23 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
2 C SYS_C0024040"ORDER_ID" IS NOT NULL 2012-11-20/06:48:23 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
3 C SYS_C0024041"LINE_NUM" IS NOT NULL 2012-11-20/06:48:23 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
4 C SYS_C0024042"PART_ID" IS NOT NULL 2012-11-20/06:48:23 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
5 C SYS_C0024043"QUANTITY" IS NOT NULL 2012-11-20/06:48:23 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
6 P ORDER_LINE_PK 2012-11-20/06:58:08 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME   QTUNE ORDER_LINE_PK
7 R ORDER_FK 2012-11-20/06:59:44 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME QTUNE SALES_ORDER_PK SALES_ORDER NO ACTION
8 R PART_FK 2012-11-20/07:00:19 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME QTUNE PART_PK PART NO ACTION
Go to Table Constraints

QTUNE.PART - 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_C0024031"PART_ID" IS NOT NULL 2012-11-20/06:47:21 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
2 C SYS_C0024032"PART_TYPE" IS NOT NULL 2012-11-20/06:47:21 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
3 C SYS_C0024033"PART_PRICE" IS NOT NULL 2012-11-20/06:47:21 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
4 P PART_PK 2012-11-20/06:47:24 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME   QTUNE PART_PK
Go to Table Constraints

QTUNE.SALES_ORDER - 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_C0024035"ORDER_ID" IS NOT NULL 2012-11-20/06:48:01 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
2 C SYS_C0024036"ORDER_NUM" IS NOT NULL 2012-11-20/06:48:01 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
3 C SYS_C0024037"CUSTOMER_ID" IS NOT NULL 2012-11-20/06:48:01 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED GENERATED NAME  
4 P SALES_ORDER_PK 2012-11-20/06:48:05 ENABLED NOT DEFERRABLE IMMEDIATE VALIDATED USER NAME   QTUNE SALES_ORDER_PK
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
Usage
Column
Prop
Hgrm
1 CUSTOMER QTUNE 101800 100000 100000 802 28-NOV-12 5 3 Prop 2
2 ORDER_LINE QTUNE 3440000 3450201 3450201 13157 28-NOV-12 6 2 Prop  
3 PART QTUNE 204600 200000 200000 1430 28-NOV-12 6 3 Prop  
4 SALES_ORDER QTUNE 302600 300000 300000 1693 28-NOV-12 6 4 Prop 1
(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

QTUNE.CUSTOMER - Table Column

Go to Table Columns
Go to Tables
Go to Top

QTUNE.CUSTOMER - 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 1 CUSTOMER_ID   100000 0 100000 100.0 100000 FALSE"1""100000" 2012-11-28/09:55:31 5 1.000000e-05 1 NONE FALSE YES NO 0.000010 1
2 [+] [+] TRUE 4 CREDIT_LIMIT   100000 14285 5430 6.3 101 FALSE"1000""101000" 2012-11-28/09:55:31 4 5.908484e-06 101 FREQUENCY FALSE 0 YES NO 0.008487 849
3 [+] [+] FALSE 3 CUSTOMER_TYPE   100000 0 6315 6.3 6 FALSE"1""6" 2012-11-28/09:55:31 2 5.080454e-06 6 FREQUENCY FALSE 0 YES NO 0.166667 16667
4 FALSE [+] TRUE 2 CUSTOMER_NAME   100000 0 100000 100.0 99624 FALSE"AAAEGJQPRNJLYOSWRLICMZRKJVANPMQA""ZZZVQZYRQVBCEZLJJJRAIXVRNKAMEXAI" 2012-11-28/09:55:31 41 1.003774e-05 1 NONE FALSE YES NO 0.000010 2
5 FALSE [+] FALSE SYS_NC00005$LOWER("CUSTOMER_NAME") 100000 0 100000 100.0 99728 FALSE"aaaegjqprnjlyoswrlicmzrkjvanpmqa""zzzvqzyrqvbcezljjjraixvrnkamexai" 2012-11-28/09:55:31 41 1.002727e-05 1 NONE FALSE YES NO 0.000010 2
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.CUSTOMER - Column Usage

# In Pred In Index In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 TRUE TRUE TRUE 1 CUSTOMER_ID   55 62 0 0 0 1 2013-02-04/11:06:47
2 TRUE TRUE TRUE 4 CREDIT_LIMIT   0 0 0 57 0 0 2013-02-04/11:06:47
3 TRUE TRUE FALSE 3 CUSTOMER_TYPE   62 0 0 0 0 1 2013-02-04/11:06:47

QTUNE.CUSTOMER - Column Properties

# In Pred In Index In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 TRUE TRUE TRUE 1 CUSTOMER_ID NUMBER 22 N   0 NO YES NO NO 1 1CUSTOMER_ID
2 TRUE TRUE TRUE 4 CREDIT_LIMIT NUMBER 22 Y   0 NO YES NO NO 4 4CREDIT_LIMIT
3 TRUE TRUE FALSE 3 CUSTOMER_TYPE VARCHAR2 40 N   CHAR_CS 40 40 B NO YES NO NO 3 3CUSTOMER_TYPE
4 FALSE TRUE TRUE 2 CUSTOMER_NAME VARCHAR2 4000 Y   CHAR_CS 4000 4000 B NO YES NO NO 2 2CUSTOMER_NAME
5 FALSE TRUE FALSE SYS_NC00005$ VARCHAR2 4000 Y 22LOWER("CUSTOMER_NAME") CHAR_CS 4000 4000 B NO YES YES YES 5SYS_NC00005$
Go to Table Columns
Go to Tables
Go to Top

QTUNE.ORDER_LINE - Table Column

Go to Table Columns
Go to Tables
Go to Top

QTUNE.ORDER_LINE - 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 2 ORDER_ID   3450201 0 3450201 100.0 302976 FALSE"1""300000" 2012-11-28/09:56:06 5 3.300591e-06 1 NONE FALSE YES NO 0.000003 12
2 [+] [+] TRUE 4 PART_ID   3450201 0 3450201 100.0 201968 FALSE"1""200000" 2012-11-28/09:56:06 5 4.951279e-06 1 NONE FALSE YES NO 0.000005 18
3 FALSE [+] FALSE 1 LINE_ID   3450201 0 3450201 100.0 3450201 FALSE"1""3450201" 2012-11-28/09:56:06 6 2.898382e-07 1 NONE FALSE YES NO 0.000000 1
4 FALSE FALSE TRUE 5 QUANTITY   3450201 0 3450201 100.0 52 FALSE"0""51" 2012-11-28/09:56:06 3 1.923077e-02 1 NONE FALSE YES NO 0.019231 66351
5 FALSE FALSE TRUE 6 DISCOUNT_PERC   3450201 2760161 690040 100.0 11 FALSE"5""55" 2012-11-28/09:56:06 2 9.090909e-02 1 NONE FALSE YES NO 0.018182 62731
6 FALSE FALSE FALSE 3 LINE_NUM   3450201 0 3450201 100.0 21 FALSE"1""21" 2012-11-28/09:56:06 3 4.761905e-02 1 NONE FALSE YES NO 0.047619 164296
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.ORDER_LINE - Column Usage

# In Pred In Index In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 TRUE TRUE TRUE 2 ORDER_ID   55 58 0 0 0 0 2013-02-04/11:06:47
2 TRUE TRUE TRUE 4 PART_ID   0 58 0 0 0 0 2013-02-04/11:06:47

QTUNE.ORDER_LINE - Column Properties

# In Pred In Index In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 TRUE TRUE TRUE 2 ORDER_ID NUMBER 22 N   0 NO YES NO NO 2 2ORDER_ID
2 TRUE TRUE TRUE 4 PART_ID NUMBER 22 N   0 NO YES NO NO 4 4PART_ID
3 FALSE TRUE FALSE 1 LINE_ID NUMBER 22 N   0 NO YES NO NO 1 1LINE_ID
4 FALSE FALSE TRUE 5 QUANTITY NUMBER 22 N   0 NO YES NO NO 5 5QUANTITY
5 FALSE FALSE TRUE 6 DISCOUNT_PERC NUMBER 22 Y   0 NO YES NO NO 6 6DISCOUNT_PERC
6 FALSE FALSE FALSE 3 LINE_NUM NUMBER 22 N   0 NO YES NO NO 3 3LINE_NUM
Go to Table Columns
Go to Tables
Go to Top

QTUNE.PART - Table Column

Go to Table Columns
Go to Tables
Go to Top

QTUNE.PART - 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 1 PART_ID   200000 0 200000 100.0 200000 FALSE"1""200000" 2012-11-28/09:55:41 5 5.000000e-06 1 NONE FALSE YES NO 0.000005 1
2 FALSE [+] FALSE 2 PART_NAME   200000 0 200000 100.0 200000 FALSE"0004S6EOFFEEVRMBSW3NQ791PVPZ3R""ZZZUCN4U8VWW9FLMIGPB99E5QH4745" 2012-11-28/09:55:41 31 5.000000e-06 1 NONE FALSE YES NO 0.000005 1
3 FALSE FALSE TRUE 4 PART_PRICE   200000 0 200000 100.0 124536 FALSE"0""4875.71" 2012-11-28/09:55:41 5 8.029807e-06 1 NONE FALSE YES NO 0.000008 2
4 FALSE FALSE FALSE 3 PART_TYPE   200000 0 200000 100.0 10 FALSE"A""J" 2012-11-28/09:55:41 2 1.000000e-01 1 NONE FALSE YES NO 0.100000 20000
5 FALSE FALSE FALSE 5 ON_HAND   200000 0 200000 100.0 6 FALSE"0""5" 2012-11-28/09:55:41 3 1.666667e-01 1 NONE FALSE YES NO 0.166667 33334
6 FALSE FALSE FALSE SYS_STUUS4P4NZTNB5ELB$CFTBUVDQSYS_OP_COMBINED_HASH("PART_TYPE","ON_HAND") 200000 0 200000 100.0 46 FALSE"842114462060574410""18358508360126232577" 2012-11-28/09:55:41 12 2.173913e-02 1 NONE FALSE YES NO 0.021739 4348
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.PART - Column Usage

# In Pred In Index In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 TRUE TRUE TRUE 1 PART_ID   0 63 0 0 0 1 2013-02-04/11:06:47
2 FALSE FALSE TRUE 4 PART_PRICE   0 0 0 0 0 1 2012-11-20/06:47:33
3 FALSE FALSE FALSE 3 PART_TYPE   0 0 0 0 0 1 2012-11-20/06:47:33

QTUNE.PART - Column Properties

# In Pred In Index In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 TRUE TRUE TRUE 1 PART_ID NUMBER 22 N   0 NO YES NO NO 1 1PART_ID
2 FALSE TRUE FALSE 2 PART_NAME VARCHAR2 4000 Y   CHAR_CS 4000 4000 B NO YES NO NO 2 2PART_NAME
3 FALSE FALSE TRUE 4 PART_PRICE NUMBER 22 N   0 NO YES NO NO 4 4PART_PRICE
4 FALSE FALSE FALSE 3 PART_TYPE VARCHAR2 1 N   CHAR_CS 1 1 B NO YES NO NO 3 3PART_TYPE
5 FALSE FALSE FALSE 5 ON_HAND NUMBER 22 Y   0 NO YES NO NO 5 5ON_HAND
6 FALSE FALSE FALSE SYS_STUUS4P4NZTNB5ELB$CFTBUVDQ NUMBER 22 Y 43SYS_OP_COMBINED_HASH("PART_TYPE","ON_HAND") 0 NO YES YES YES 6SYS_STUUS4P4NZTNB5ELB$CFTBUVDQ
Go to Table Columns
Go to Tables
Go to Top

QTUNE.SALES_ORDER - Table Column

Go to Table Columns
Go to Tables
Go to Top

QTUNE.SALES_ORDER - 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 1 ORDER_ID   300000 0 300000 100.0 300000 FALSE"1""300000" 2012-11-28/09:55:51 5 3.333333e-06 1 NONE FALSE YES NO 0.000003 1
2 [+] [+] TRUE 4 CUSTOMER_ID   300000 0 300000 100.0 95952 FALSE"1""99999" 2012-11-28/09:55:51 5 1.042188e-05 1 NONE FALSE YES NO 0.000010 4
3 [+] FALSE FALSE 5 STATUS   300000 0 5464 1.8 10 FALSE"Q""Z" 2012-11-28/09:55:51 2 1.677648e-06 10 FREQUENCY FALSE 0 YES NO 0.100000 30000
4 FALSE [+] FALSE 2 ORDER_NUM   300000 0 300000 100.0 299840 FALSE"AA003667020574""ZZ999041716303" 2012-11-28/09:55:51 15 3.335112e-06 1 NONE FALSE YES NO 0.000003 2
5 FALSE [+] FALSE 3 ORDER_DATE   300000 0 300000 100.0 1002 FALSE" 2010/02/23 00:00:00"" 2012/11/20 00:00:00" 2012-11-28/09:55:51 8 9.980040e-04 1 NONE FALSE YES NO 0.000998 300
6 FALSE FALSE FALSE SYS_STUK0XJTEZVXUTGW1H0VTZ#WQASUBSTR("ORDER_NUM",1,2) 300000 0 300000 100.0 676 FALSE"AA""ZZ" 2012-11-28/09:55:51 3 1.479290e-03 1 NONE FALSE YES NO 0.001479 444
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.SALES_ORDER - Column Usage

# In Pred In Index In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 TRUE TRUE TRUE 1 ORDER_ID   0 58 0 0 0 1 2013-02-04/11:06:47
2 TRUE TRUE TRUE 4 CUSTOMER_ID   55 57 0 0 0 1 2013-02-04/11:06:47
3 TRUE FALSE FALSE 5 STATUS   57 0 0 0 0 0 2013-02-04/11:06:47
4 FALSE TRUE FALSE 2 ORDER_NUM   0 0 0 0 0 1 2012-11-20/06:48:17

QTUNE.SALES_ORDER - Column Properties

# In Pred In Index In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 TRUE TRUE TRUE 1 ORDER_ID NUMBER 22 N   0 NO YES NO NO 1 1ORDER_ID
2 TRUE TRUE TRUE 4 CUSTOMER_ID NUMBER 22 N   0 NO YES NO NO 4 4CUSTOMER_ID
3 TRUE FALSE FALSE 5 STATUS VARCHAR2 1 Y   CHAR_CS 1 1 B NO YES NO NO 5 5STATUS
4 FALSE TRUE FALSE 2 ORDER_NUM VARCHAR2 4000 N   CHAR_CS 4000 4000 B NO YES NO NO 2 2ORDER_NUM
5 FALSE TRUE FALSE 3 ORDER_DATE DATE 7 Y   0 NO YES NO NO 3 3ORDER_DATE
6 FALSE FALSE FALSE SYS_STUK0XJTEZVXUTGW1H0VTZ#WQA VARCHAR2 2 Y 23SUBSTR("ORDER_NUM",1,2) CHAR_CS 2 2 B NO YES YES YES 6SYS_STUK0XJTEZVXUTGW1H0VTZ#WQA
Go to Table Columns
Go to Tables
Go to Top

Indexed Columns

# Table Name Owner Count1 Num
Rows2
Sample
Size2
Blocks2 Last
Analyzed2
Indexes
1 CUSTOMER QTUNE 101800 100000 100000 802 28-NOV-12 4
2 ORDER_LINE QTUNE 3440000 3450201 3450201 13157 28-NOV-12 3
3 PART QTUNE 204600 200000 200000 1430 28-NOV-12 2
4 SALES_ORDER QTUNE 302600 300000 300000 1693 28-NOV-12 3
(1) SELECT COUNT(*) performed in Table as per tool parameter "count_star_threshold" with current value of 10000.
(2) CBO Statistics.
Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER - Indexed Columns

Go to Indexed Columns
Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER - Single-Column Indexes

# In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend Index Name Index Owner Index Type Uniqueness In Plan
1 [+] TRUE 1 CUSTOMER_ID   ASC CUSTOMER_PK QTUNE NORMAL UNIQUE TRUE
2 FALSE TRUE 2 CUSTOMER_NAME   ASC CUSTOMER_N1 QTUNE NORMAL NONUNIQUE FALSE
3 FALSE FALSE SYS_NC00005$LOWER("CUSTOMER_NAME") ASC CUSTOMER_F1 QTUNE FUNCTION-BASED NORMAL NONUNIQUE FALSE

QTUNE.CUSTOMER - Multi-Column Indexes

# In Pred In Proj Col ID Column Name Data Default Not Null with Default Value CUSTOMER_N2 Column Name
1 [+] TRUE 4 CREDIT_LIMIT   2 CREDIT_LIMIT
2 [+] FALSE 3 CUSTOMER_TYPE   1 CUSTOMER_TYPE
Index names are displayed vertical in IE.
Go to Indexed Columns
Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE - Indexed Columns

Go to Indexed Columns
Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE - Single-Column Indexes

# In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend Index Name Index Owner Index Type Uniqueness In Plan
1 [+] TRUE 2 ORDER_ID   ASC ORDER_LINE_N1 QTUNE NORMAL NONUNIQUE FALSE
2 [+] TRUE 4 PART_ID   ASC ORDER_LINE_N2 QTUNE NORMAL NONUNIQUE FALSE
3 FALSE FALSE 1 LINE_ID   ASC ORDER_LINE_PK QTUNE NORMAL UNIQUE FALSE
Go to Indexed Columns
Go to Indexes
Go to Tables
Go to Top

QTUNE.PART - Indexed Columns

Go to Indexed Columns
Go to Indexes
Go to Tables
Go to Top

QTUNE.PART - Single-Column Indexes

# In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend Index Name Index Owner Index Type Uniqueness In Plan
1 [+] TRUE 1 PART_ID   ASC PART_PK QTUNE NORMAL UNIQUE FALSE
2 FALSE FALSE 2 PART_NAME   ASC PART_N1 QTUNE NORMAL NONUNIQUE FALSE
Go to Indexed Columns
Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER - Indexed Columns

Go to Indexed Columns
Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER - Single-Column Indexes

# In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend Index Name Index Owner Index Type Uniqueness In Plan
1 [+] TRUE 1 ORDER_ID   ASC SALES_ORDER_PK QTUNE NORMAL UNIQUE FALSE
2 FALSE FALSE 2 ORDER_NUM   ASC SALES_ORDER_N1 QTUNE NORMAL NONUNIQUE FALSE

QTUNE.SALES_ORDER - Multi-Column Indexes

# In Pred In Proj Col ID Column Name Data Default Not Null with Default Value SALES_ORDER_N2 Column Name
1 [+] TRUE 4 CUSTOMER_ID   1 CUSTOMER_ID
2 FALSE FALSE 3 ORDER_DATE   2 ORDER_DATE
Index names are displayed vertical in IE.
Go to Indexed Columns
Go to Indexes
Go to Tables
Go to Top

Table Column Histograms

Go to Table Columns
Go to Tables
Go to Top

QTUNE.CUSTOMER - Histograms

Go to Table Columns
Go to Tables
Go to Top

QTUNE.CUSTOMER.CREDIT_LIMIT - Histogram

"Frequency" histogram with 101 buckets. Number of rows in this table is 100000. Number of nulls in this column is 14285 and its sample size was 5430.
SQL: [+]
# Endpoint Number Endpoint Value1 Endpoint Actual Value1 Estimated Endpoint Value1 Estimated Cardinality Estimated Selectivity
1 38 1000"""1000" 600 0.005998
2 89 2000"""2000" 805 0.008051
3 147 3000"""3000" 916 0.009156
4 199 4000"""4000" 821 0.008208
5 244 5000"""5000" 710 0.007103
6 305 6000"""6000" 963 0.009629
7 363 7000"""7000" 916 0.009156
8 422 8000"""8000" 931 0.009313
9 485 9000"""9000" 994 0.009945
10 531 10000"""10000" 726 0.007261
11 589 11000"""11000" 916 0.009156
12 640 12000"""12000" 805 0.008051
13 696 13000"""13000" 884 0.008840
14 756 14000"""14000" 947 0.009471
15 806 15000"""15000" 789 0.007893
16 859 16000"""16000" 837 0.008366
17 911 17000"""17000" 821 0.008208
18 966 18000"""18000" 868 0.008682
19 1024 19000"""19000" 916 0.009156
20 1078 20000"""20000" 852 0.008524
21 1131 21000"""21000" 837 0.008366
22 1170 22000"""22000" 616 0.006156
23 1219 23000"""23000" 773 0.007735
24 1293 24000"""24000" 1168 0.011681
25 1343 25000"""25000" 789 0.007893
26 1400 26000"""26000" 900 0.008998
27 1450 27000"""27000" 789 0.007893
28 1501 28000"""28000" 805 0.008051
29 1544 29000"""29000" 679 0.006788
30 1595 30000"""30000" 805 0.008051
# Endpoint Number Endpoint Value1 Endpoint Actual Value1 Estimated Endpoint Value1 Estimated Cardinality Estimated Selectivity
31 1641 31000"""31000" 726 0.007261
32 1689 32000"""32000" 758 0.007577
33 1750 33000"""33000" 963 0.009629
34 1795 34000"""34000" 710 0.007103
35 1840 35000"""35000" 710 0.007103
36 1888 36000"""36000" 758 0.007577
37 1946 37000"""37000" 916 0.009156
38 2001 38000"""38000" 868 0.008682
39 2067 39000"""39000" 1042 0.010418
40 2122 40000"""40000" 868 0.008682
41 2179 41000"""41000" 900 0.008998
42 2222 42000"""42000" 679 0.006788
43 2271 43000"""43000" 773 0.007735
44 2323 44000"""44000" 821 0.008208
45 2383 45000"""45000" 947 0.009471
46 2440 46000"""46000" 900 0.008998
47 2505 47000"""47000" 1026 0.010261
48 2561 48000"""48000" 884 0.008840
49 2617 49000"""49000" 884 0.008840
50 2683 50000"""50000" 1042 0.010418
51 2735 51000"""51000" 821 0.008208
52 2786 52000"""52000" 805 0.008051
53 2843 53000"""53000" 900 0.008998
54 2883 54000"""54000" 631 0.006314
55 2937 55000"""55000" 852 0.008524
56 2999 56000"""56000" 979 0.009787
57 3053 57000"""57000" 852 0.008524
58 3120 58000"""58000" 1058 0.010576
59 3167 59000"""59000" 742 0.007419
60 3215 60000"""60000" 758 0.007577
# Endpoint Number Endpoint Value1 Endpoint Actual Value1 Estimated Endpoint Value1 Estimated Cardinality Estimated Selectivity
61 3274 61000"""61000" 931 0.009313
62 3319 62000"""62000" 710 0.007103
63 3371 63000"""63000" 821 0.008208
64 3438 64000"""64000" 1058 0.010576
65 3486 65000"""65000" 758 0.007577
66 3535 66000"""66000" 773 0.007735
67 3589 67000"""67000" 852 0.008524
68 3631 68000"""68000" 663 0.006630
69 3683 69000"""69000" 821 0.008208
70 3739 70000"""70000" 884 0.008840
71 3791 71000"""71000" 821 0.008208
72 3847 72000"""72000" 884 0.008840
73 3901 73000"""73000" 852 0.008524
74 3959 74000"""74000" 916 0.009156
75 4013 75000"""75000" 852 0.008524
76 4077 76000"""76000" 1010 0.010103
77 4135 77000"""77000" 916 0.009156
78 4201 78000"""78000" 1042 0.010418
79 4260 79000"""79000" 931 0.009313
80 4319 80000"""80000" 931 0.009313
81 4375 81000"""81000" 884 0.008840
82 4427 82000"""82000" 821 0.008208
83 4490 83000"""83000" 994 0.009945
84 4551 84000"""84000" 963 0.009629
85 4601 85000"""85000" 789 0.007893
86 4660 86000"""86000" 931 0.009313
87 4704 87000"""87000" 695 0.006946
88 4762 88000"""88000" 916 0.009156
89 4810 89000"""89000" 758 0.007577
90 4860 90000"""90000" 789 0.007893
# Endpoint Number Endpoint Value1 Endpoint Actual Value1 Estimated Endpoint Value1 Estimated Cardinality Estimated Selectivity
91 4906 91000"""91000" 726 0.007261
92 4964 92000"""92000" 916 0.009156
93 5005 93000"""93000" 647 0.006472
94 5061 94000"""94000" 884 0.008840
95 5112 95000"""95000" 805 0.008051
96 5170 96000"""96000" 916 0.009156
97 5228 97000"""97000" 916 0.009156
98 5283 98000"""98000" 868 0.008682
99 5347 99000"""99000" 1010 0.010103
100 5404 100000"""100000" 900 0.008998
101 5430 101000"""101000" 410 0.004104
(1) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
Remarks for this "Frequency" histogram:
a) Estimated cardinality for values not present in histogram is 1/2 the cardinality of the smallest bucket (after fix 5483301).
b) Smallest bucket shows an estimated cardinality of 410 rows, thus for equality predicates on values not in this histogram an estimated cardinality of 205 rows would be considered.
Go to Table Columns

QTUNE.CUSTOMER.CUSTOMER_TYPE - Histogram

"Frequency" histogram with 6 buckets. Number of rows in this table is 100000. Number of nulls in this column is 0 and its sample size was 6315.
SQL: [+]
# Endpoint Number Endpoint Value1 Endpoint Actual Value1 Estimated Endpoint Value1 Estimated Cardinality Estimated Selectivity
1 2436 254422546068207000000000000000000000"""1" 38575 0.385748
2 5492 259614842926741000000000000000000000"""2" 48393 0.483927
3 6231 264807139785276000000000000000000000"""3" 11702 0.117023
4 6308 269999436643811000000000000000000000"""4" 1219 0.012193
5 6314 275191733502346000000000000000000000"""5" 95 0.000950
6 6315 280384030360881000000000000000000000"""6" 16 0.000158
(1) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
Remarks for this "Frequency" histogram:
a) Estimated cardinality for values not present in histogram is 1/2 the cardinality of the smallest bucket (after fix 5483301).
b) Smallest bucket shows an estimated cardinality of 16 rows, thus for equality predicates on values not in this histogram an estimated cardinality of 8 rows would be considered.
Go to Table Columns
Go to Tables
Go to Top

QTUNE.SALES_ORDER - Histograms

Go to Table Columns
Go to Tables
Go to Top

QTUNE.SALES_ORDER.STATUS - Histogram

"Frequency" histogram with 10 buckets. Number of rows in this table is 300000. Number of nulls in this column is 0 and its sample size was 5464.
SQL: [+]
# Endpoint Number Endpoint Value1 Endpoint Actual Value1 Estimated Endpoint Value1 Estimated Cardinality Estimated Selectivity
1 1 420576045541321000000000000000000000"""Q" 55 0.000183
2 33 425768342399856000000000000000000000"""R" 1757 0.005857
3 357 430960639258391000000000000000000000"""S" 17789 0.059297
4 1667 436152936116926000000000000000000000"""T" 71925 0.239751
5 3764 441345232975460000000000000000000000"""U" 115135 0.383785
6 5089 446537529833995000000000000000000000"""V" 72749 0.242496
7 5432 451729826692530000000000000000000000"""W" 18832 0.062775
8 5461 456922123551065000000000000000000000"""X" 1592 0.005307
9 5463 462114420409600000000000000000000000"""Y" 110 0.000366
10 5464 467306717268135000000000000000000000"""Z" 55 0.000183
(1) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
Remarks for this "Frequency" histogram:
a) Estimated cardinality for values not present in histogram is 1/2 the cardinality of the smallest bucket (after fix 5483301).
b) Smallest bucket shows an estimated cardinality of 55 rows, thus for equality predicates on values not in this histogram an estimated cardinality of 27 rows would be considered.
Go to Table Columns
Go to Tables
Go to Top

Indexes

# Table Name Owner Count1 Num
Rows2
Sample
Size2
Blocks2 Last
Analyzed2
Indexes
1 CUSTOMER QTUNE 101800 100000 100000 802 28-NOV-12 4
2 ORDER_LINE QTUNE 3440000 3450201 3450201 13157 28-NOV-12 3
3 PART QTUNE 204600 200000 200000 1430 28-NOV-12 2
4 SALES_ORDER QTUNE 302600 300000 300000 1693 28-NOV-12 3
(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 Tables
Go to Top

QTUNE.CUSTOMER - Indexes

# In Plan Index Name Owner Index Type Uniqueness Col ID Column Name Column Name1 Num
Rows2
Sample
Size2
Last
Analyzed2
Index
Stats
Index
Prop
Index
Phys
Prop
Index
Cols
Index
Meta
1 TRUE CUSTOMER_PK QTUNE NORMAL UNIQUE 1 CUSTOMER_ID CUSTOMER_ID 100000 100000 28-NOV-12 Stats Prop Phys Cols Meta
2 FALSE CUSTOMER_F1 QTUNE FUNCTION-BASED NORMAL NONUNIQUE 5 LOWER(CUSTOMER_NAME) SYS_NC00005$ 100000 100000 28-NOV-12 Stats Prop Phys Cols Meta
3 FALSE CUSTOMER_N1 QTUNE NORMAL NONUNIQUE 2 CUSTOMER_NAME CUSTOMER_NAME 100000 100000 28-NOV-12 Stats Prop Phys Cols Meta
4 FALSE CUSTOMER_N2 QTUNE NORMAL NONUNIQUE 3
4
CUSTOMER_TYPE
CREDIT_LIMIT
CUSTOMER_TYPE
CREDIT_LIMIT
100000 100000 28-NOV-12 Stats Prop Phys Cols Meta
(1) Column names including system-generated names.
(2) CBO Statistics.
Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER - Index Statistics

# In Plan Index Name Owner Index Type Part Temp Num Rows1 Sample Size1 Perc Last Analyzed1 Distinct Keys1 Blevel1 Segment Extents Segment Blocks Total Segment Blocks2 DBMS_SPACE Allocated Blocks3 Leaf Blocks1 Leaf Estimate Target Size4 Avg Leaf Blocks per Key1 Avg Data Blocks per Key1 Clustering Factor1 Global Stats1 User Stats1 Stat Type Locked Stale Stats Avg Cached Blocks Avg Cache Hit Ratio Clustering Factor Quality5 Full Index Scan Cost6 Max Index Selectivity7
1 TRUE CUSTOMER_PK QTUNE NORMAL NO N 100000 100000 100.0 2012-11-28/09:55:34 100000 1 17 256 256 384 208 1 1 780 YES NO NO BEST 988 0.222672
2 FALSE CUSTOMER_F1 QTUNE FUNCTION-BASED NORMAL NO N 100000 100000 100.0 2012-11-28/09:55:41 99728 2 21 768 768 768 725 1 1 99881 YES NO NO WORST 100608 0.002187
3 FALSE CUSTOMER_N1 QTUNE NORMAL NO N 100000 100000 100.0 2012-11-28/09:55:37 99624 2 21 768 768 768 725 1 1 99881 YES NO NO WORST 100608 0.002187
4 FALSE CUSTOMER_N2 QTUNE NORMAL NO N 100000 100000 100.0 2012-11-28/09:55:37 446 1 17 256 256 384 229 1 162 72410 YES NO NO POOR 72639 0.003029
(1) CBO Statistics.
(2) It considers the blocks from all partitions (if the index is partitioned).
(3) This is the estimated size of the index if it were rebuilt, as computed by DBMS_SPACE.CREATE_INDEX_COST.
(4) Estimated leaf blocks with a 90% index efficiency. Only evaluated for non-partitioned normal indexes with more than 10000 leaf blocks.
(5) BEST:less than 25602. GOOD:between 25602 and 50401. POOR:between 50401 and 75201. WORST:greater than 75201.
(6) It assumes default CBO environment, including optimizer_index_cost_adj=100 and optimizer_index_caching=0 among others.
(7) Index Selectivity where Full Index Scan Cost meets Full Table Scan Cost. A value of 0.02 means that if selecting 2% of the rows or less, an index scan is cheaper than a FTS.
Go to Index Statistics Versions
Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER - Index Properties

# In Plan Index Name Owner Index Type Uniqueness Table Type Part Degree Instances Temp Duration Incl Col Pct Direct Access IOT Redundant PKey Elim Join Index Secondary Domain Index Type Owner Domain Index Type Name Domain Index Params Domain Index Status Domain Index Oper Status Domain Index Mgment Function Based Index Status Generated Visibility Status Dropped Segment Created
1 TRUE CUSTOMER_PK QTUNE NORMAL UNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
2 FALSE CUSTOMER_F1 QTUNE FUNCTION-BASED NORMAL NONUNIQUE TABLE NO 1 1 N NO NO N ENABLED N VISIBLE VALID NO YES
3 FALSE CUSTOMER_N1 QTUNE NORMAL NONUNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
4 FALSE CUSTOMER_N2 QTUNE NORMAL NONUNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER - Index Physical Properties

# In Plan Index Name Owner Index Type Part Temp Pct Free Ini Trans Max Trans Initial Extent Next Extent Min Extents Max Extents Pct Increase Pct Threshold Free Lists Free List Groups Logging Buffer Pool Flash Cache Cell Flash Cache TableSpace Name Compression Prefix Length
1 TRUE CUSTOMER_PK QTUNE NORMAL NO N 10 2 255 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
2 FALSE CUSTOMER_F1 QTUNE FUNCTION-BASED NORMAL NO N 10 2 167 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
3 FALSE CUSTOMER_N1 QTUNE NORMAL NO N 10 2 167 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
4 FALSE CUSTOMER_N2 QTUNE NORMAL NO N 10 2 255 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER_PK - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER_PK - Column Statistics

Index type:NORMAL rows:100000 smpl:100000 lvls:1 #lb:208 #dk:100000 cluf:780 anlz:2012-11-28/09:55:34
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 [+] TRUE 1 CUSTOMER_ID   ASC 100000 0 100000 100.0 100000 FALSE"1""100000" 2012-11-28/09:55:31 5 1.000000e-05 1 NONE FALSE YES NO 0.000010 1
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.CUSTOMER_PK - Column Usage

# Col Pos In Pred In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 1 TRUE TRUE 1 CUSTOMER_ID   55 62 0 0 0 1 2013-02-04/11:06:47

QTUNE.CUSTOMER_PK - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 TRUE TRUE 1 CUSTOMER_ID NUMBER 22 N   0 NO YES NO NO 1 1CUSTOMER_ID
Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER_F1 - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER_F1 - Column Statistics

Index type:FUNCTION-BASED NORMAL rows:100000 smpl:100000 lvls:2 #lb:725 #dk:99728 cluf:99881 anlz:2012-11-28/09:55:41
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 FALSE FALSE SYS_NC00005$LOWER("CUSTOMER_NAME") ASC 100000 0 100000 100.0 99728 FALSE"aaaegjqprnjlyoswrlicmzrkjvanpmqa""zzzvqzyrqvbcezljjjraixvrnkamexai" 2012-11-28/09:55:31 41 1.002727e-05 1 NONE FALSE YES NO 0.000010 2
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.CUSTOMER_F1 - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 FALSE FALSE SYS_NC00005$ VARCHAR2 4000 Y 22LOWER("CUSTOMER_NAME") CHAR_CS 4000 4000 B NO YES YES YES 5SYS_NC00005$
Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER_N1 - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER_N1 - Column Statistics

Index type:NORMAL rows:100000 smpl:100000 lvls:2 #lb:725 #dk:99624 cluf:99881 anlz:2012-11-28/09:55:37
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 FALSE TRUE 2 CUSTOMER_NAME   ASC 100000 0 100000 100.0 99624 FALSE"AAAEGJQPRNJLYOSWRLICMZRKJVANPMQA""ZZZVQZYRQVBCEZLJJJRAIXVRNKAMEXAI" 2012-11-28/09:55:31 41 1.003774e-05 1 NONE FALSE YES NO 0.000010 2
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.CUSTOMER_N1 - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 FALSE TRUE 2 CUSTOMER_NAME VARCHAR2 4000 Y   CHAR_CS 4000 4000 B NO YES NO NO 2 2CUSTOMER_NAME
Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER_N2 - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.CUSTOMER_N2 - Column Statistics

Index type:NORMAL rows:100000 smpl:100000 lvls:1 #lb:229 #dk:446 cluf:72410 anlz:2012-11-28/09:55:37
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 [+] FALSE 3 CUSTOMER_TYPE   ASC 100000 0 6315 6.3 6 FALSE"1""6" 2012-11-28/09:55:31 2 5.080454e-06 6 FREQUENCY FALSE 0 YES NO 0.166667 16667
2 2 [+] TRUE 4 CREDIT_LIMIT   ASC 100000 14285 5430 6.3 101 FALSE"1000""101000" 2012-11-28/09:55:31 4 5.908484e-06 101 FREQUENCY FALSE 0 YES NO 0.008487 849
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.CUSTOMER_N2 - Column Usage

# Col Pos In Pred In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 1 TRUE FALSE 3 CUSTOMER_TYPE   62 0 0 0 0 1 2013-02-04/11:06:47
2 2 TRUE TRUE 4 CREDIT_LIMIT   0 0 0 57 0 0 2013-02-04/11:06:47

QTUNE.CUSTOMER_N2 - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 TRUE FALSE 3 CUSTOMER_TYPE VARCHAR2 40 N   CHAR_CS 40 40 B NO YES NO NO 3 3CUSTOMER_TYPE
2 2 TRUE TRUE 4 CREDIT_LIMIT NUMBER 22 Y   0 NO YES NO NO 4 4CREDIT_LIMIT

QTUNE.CUSTOMER_N2 - Histograms

Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE - Indexes

# In Plan Index Name Owner Index Type Uniqueness Col ID Column Name Column Name1 Num
Rows2
Sample
Size2
Last
Analyzed2
Index
Stats
Index
Prop
Index
Phys
Prop
Index
Cols
Index
Meta
1 FALSE ORDER_LINE_N1 QTUNE NORMAL NONUNIQUE 2 ORDER_ID ORDER_ID 3402652 499399 28-NOV-12 Stats Prop Phys Cols Meta
2 FALSE ORDER_LINE_N2 QTUNE NORMAL NONUNIQUE 4 PART_ID PART_ID 3438118 505056 28-NOV-12 Stats Prop Phys Cols Meta
3 FALSE ORDER_LINE_PK QTUNE NORMAL UNIQUE 1 LINE_ID LINE_ID 3387371 506145 28-NOV-12 Stats Prop Phys Cols Meta
(1) Column names including system-generated names.
(2) CBO Statistics.
Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE - Index Statistics

# In Plan Index Name Owner Index Type Part Temp Num Rows1 Sample Size1 Perc Last Analyzed1 Distinct Keys1 Blevel1 Segment Extents Segment Blocks Total Segment Blocks2 DBMS_SPACE Allocated Blocks3 Leaf Blocks1 Leaf Estimate Target Size4 Avg Leaf Blocks per Key1 Avg Data Blocks per Key1 Clustering Factor1 Global Stats1 User Stats1 Stat Type Locked Stale Stats Avg Cached Blocks Avg Cache Hit Ratio Clustering Factor Quality5 Full Index Scan Cost6 Max Index Selectivity7
1 FALSE ORDER_LINE_N1 QTUNE NORMAL NO N 3402652 499399 14.7 2012-11-28/09:57:05 302976 2 77 7936 7936 10240 7570 1 11 3401234 YES NO NO WORST 3408806 0.001059
2 FALSE ORDER_LINE_N2 QTUNE NORMAL NO N 3438118 505056 14.7 2012-11-28/09:57:28 201968 2 77 7936 7936 10240 7645 1 17 3435899 YES NO NO WORST 3443546 0.001048
3 FALSE ORDER_LINE_PK QTUNE NORMAL NO N 3387371 506145 14.9 2012-11-28/09:56:44 3387371 2 76 7808 7808 10240 7395 1 1 18873 YES NO NO BEST 26270 0.137381
(1) CBO Statistics.
(2) It considers the blocks from all partitions (if the index is partitioned).
(3) This is the estimated size of the index if it were rebuilt, as computed by DBMS_SPACE.CREATE_INDEX_COST.
(4) Estimated leaf blocks with a 90% index efficiency. Only evaluated for non-partitioned normal indexes with more than 10000 leaf blocks.
(5) BEST:less than 872418. GOOD:between 872418 and 1731679. POOR:between 1731679 and 2590940. WORST:greater than 2590940.
(6) It assumes default CBO environment, including optimizer_index_cost_adj=100 and optimizer_index_caching=0 among others.
(7) Index Selectivity where Full Index Scan Cost meets Full Table Scan Cost. A value of 0.02 means that if selecting 2% of the rows or less, an index scan is cheaper than a FTS.
Go to Index Statistics Versions
Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE - Index Properties

# In Plan Index Name Owner Index Type Uniqueness Table Type Part Degree Instances Temp Duration Incl Col Pct Direct Access IOT Redundant PKey Elim Join Index Secondary Domain Index Type Owner Domain Index Type Name Domain Index Params Domain Index Status Domain Index Oper Status Domain Index Mgment Function Based Index Status Generated Visibility Status Dropped Segment Created
1 FALSE ORDER_LINE_N1 QTUNE NORMAL NONUNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
2 FALSE ORDER_LINE_N2 QTUNE NORMAL NONUNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
3 FALSE ORDER_LINE_PK QTUNE NORMAL UNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE - Index Physical Properties

# In Plan Index Name Owner Index Type Part Temp Pct Free Ini Trans Max Trans Initial Extent Next Extent Min Extents Max Extents Pct Increase Pct Threshold Free Lists Free List Groups Logging Buffer Pool Flash Cache Cell Flash Cache TableSpace Name Compression Prefix Length
1 FALSE ORDER_LINE_N1 QTUNE NORMAL NO N 10 2 255 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
2 FALSE ORDER_LINE_N2 QTUNE NORMAL NO N 10 2 255 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
3 FALSE ORDER_LINE_PK QTUNE NORMAL NO N 10 2 255 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE_N1 - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE_N1 - Column Statistics

Index type:NORMAL rows:3402652 smpl:499399 lvls:2 #lb:7570 #dk:302976 cluf:3401234 anlz:2012-11-28/09:57:05
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 [+] TRUE 2 ORDER_ID   ASC 3450201 0 3450201 100.0 302976 FALSE"1""300000" 2012-11-28/09:56:06 5 3.300591e-06 1 NONE FALSE YES NO 0.000003 12
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.ORDER_LINE_N1 - Column Usage

# Col Pos In Pred In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 1 TRUE TRUE 2 ORDER_ID   55 58 0 0 0 0 2013-02-04/11:06:47

QTUNE.ORDER_LINE_N1 - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 TRUE TRUE 2 ORDER_ID NUMBER 22 N   0 NO YES NO NO 2 2ORDER_ID
Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE_N2 - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE_N2 - Column Statistics

Index type:NORMAL rows:3438118 smpl:505056 lvls:2 #lb:7645 #dk:201968 cluf:3435899 anlz:2012-11-28/09:57:28
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 [+] TRUE 4 PART_ID   ASC 3450201 0 3450201 100.0 201968 FALSE"1""200000" 2012-11-28/09:56:06 5 4.951279e-06 1 NONE FALSE YES NO 0.000005 18
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.ORDER_LINE_N2 - Column Usage

# Col Pos In Pred In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 1 TRUE TRUE 4 PART_ID   0 58 0 0 0 0 2013-02-04/11:06:47

QTUNE.ORDER_LINE_N2 - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 TRUE TRUE 4 PART_ID NUMBER 22 N   0 NO YES NO NO 4 4PART_ID
Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE_PK - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.ORDER_LINE_PK - Column Statistics

Index type:NORMAL rows:3387371 smpl:506145 lvls:2 #lb:7395 #dk:3387371 cluf:18873 anlz:2012-11-28/09:56:44
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 FALSE FALSE 1 LINE_ID   ASC 3450201 0 3450201 100.0 3450201 FALSE"1""3450201" 2012-11-28/09:56:06 6 2.898382e-07 1 NONE FALSE YES NO 0.000000 1
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.ORDER_LINE_PK - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 FALSE FALSE 1 LINE_ID NUMBER 22 N   0 NO YES NO NO 1 1LINE_ID
Go to Indexes
Go to Tables
Go to Top

QTUNE.PART - Indexes

# In Plan Index Name Owner Index Type Uniqueness Col ID Column Name Column Name1 Num
Rows2
Sample
Size2
Last
Analyzed2
Index
Stats
Index
Prop
Index
Phys
Prop
Index
Cols
Index
Meta
1 FALSE PART_N1 QTUNE NORMAL NONUNIQUE 2 PART_NAME PART_NAME 200000 200000 28-NOV-12 Stats Prop Phys Cols Meta
2 FALSE PART_PK QTUNE NORMAL UNIQUE 1 PART_ID PART_ID 200000 200000 28-NOV-12 Stats Prop Phys Cols Meta
(1) Column names including system-generated names.
(2) CBO Statistics.
Go to Indexes
Go to Tables
Go to Top

QTUNE.PART - Index Statistics

# In Plan Index Name Owner Index Type Part Temp Num Rows1 Sample Size1 Perc Last Analyzed1 Distinct Keys1 Blevel1 Segment Extents Segment Blocks Total Segment Blocks2 DBMS_SPACE Allocated Blocks3 Leaf Blocks1 Leaf Estimate Target Size4 Avg Leaf Blocks per Key1 Avg Data Blocks per Key1 Clustering Factor1 Global Stats1 User Stats1 Stat Type Locked Stale Stats Avg Cached Blocks Avg Cache Hit Ratio Clustering Factor Quality5 Full Index Scan Cost6 Max Index Selectivity7
1 FALSE PART_N1 QTUNE NORMAL NO N 200000 200000 100.0 2012-11-28/09:55:51 200000 2 25 1280 1280 1280 1177 1 1 199846 YES NO NO WORST 201025 0.001950
2 FALSE PART_PK QTUNE NORMAL NO N 200000 200000 100.0 2012-11-28/09:55:46 200000 1 19 512 512 640 417 1 1 1398 YES NO NO BEST 1815 0.215978
(1) CBO Statistics.
(2) It considers the blocks from all partitions (if the index is partitioned).
(3) This is the estimated size of the index if it were rebuilt, as computed by DBMS_SPACE.CREATE_INDEX_COST.
(4) Estimated leaf blocks with a 90% index efficiency. Only evaluated for non-partitioned normal indexes with more than 10000 leaf blocks.
(5) BEST:less than 51073. GOOD:between 51073 and 100715. POOR:between 100715 and 150358. WORST:greater than 150358.
(6) It assumes default CBO environment, including optimizer_index_cost_adj=100 and optimizer_index_caching=0 among others.
(7) Index Selectivity where Full Index Scan Cost meets Full Table Scan Cost. A value of 0.02 means that if selecting 2% of the rows or less, an index scan is cheaper than a FTS.
Go to Index Statistics Versions
Go to Indexes
Go to Tables
Go to Top

QTUNE.PART - Index Properties

# In Plan Index Name Owner Index Type Uniqueness Table Type Part Degree Instances Temp Duration Incl Col Pct Direct Access IOT Redundant PKey Elim Join Index Secondary Domain Index Type Owner Domain Index Type Name Domain Index Params Domain Index Status Domain Index Oper Status Domain Index Mgment Function Based Index Status Generated Visibility Status Dropped Segment Created
1 FALSE PART_N1 QTUNE NORMAL NONUNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
2 FALSE PART_PK QTUNE NORMAL UNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
Go to Indexes
Go to Tables
Go to Top

QTUNE.PART - Index Physical Properties

# In Plan Index Name Owner Index Type Part Temp Pct Free Ini Trans Max Trans Initial Extent Next Extent Min Extents Max Extents Pct Increase Pct Threshold Free Lists Free List Groups Logging Buffer Pool Flash Cache Cell Flash Cache TableSpace Name Compression Prefix Length
1 FALSE PART_N1 QTUNE NORMAL NO N 10 2 167 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
2 FALSE PART_PK QTUNE NORMAL NO N 10 2 255 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
Go to Indexes
Go to Tables
Go to Top

QTUNE.PART_N1 - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.PART_N1 - Column Statistics

Index type:NORMAL rows:200000 smpl:200000 lvls:2 #lb:1177 #dk:200000 cluf:199846 anlz:2012-11-28/09:55:51
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 FALSE FALSE 2 PART_NAME   ASC 200000 0 200000 100.0 200000 FALSE"0004S6EOFFEEVRMBSW3NQ791PVPZ3R""ZZZUCN4U8VWW9FLMIGPB99E5QH4745" 2012-11-28/09:55:41 31 5.000000e-06 1 NONE FALSE YES NO 0.000005 1
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.PART_N1 - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 FALSE FALSE 2 PART_NAME VARCHAR2 4000 Y   CHAR_CS 4000 4000 B NO YES NO NO 2 2PART_NAME
Go to Indexes
Go to Tables
Go to Top

QTUNE.PART_PK - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.PART_PK - Column Statistics

Index type:NORMAL rows:200000 smpl:200000 lvls:1 #lb:417 #dk:200000 cluf:1398 anlz:2012-11-28/09:55:46
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 [+] TRUE 1 PART_ID   ASC 200000 0 200000 100.0 200000 FALSE"1""200000" 2012-11-28/09:55:41 5 5.000000e-06 1 NONE FALSE YES NO 0.000005 1
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.PART_PK - Column Usage

# Col Pos In Pred In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 1 TRUE TRUE 1 PART_ID   0 63 0 0 0 1 2013-02-04/11:06:47

QTUNE.PART_PK - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 TRUE TRUE 1 PART_ID NUMBER 22 N   0 NO YES NO NO 1 1PART_ID
Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER - Indexes

# In Plan Index Name Owner Index Type Uniqueness Col ID Column Name Column Name1 Num
Rows2
Sample
Size2
Last
Analyzed2
Index
Stats
Index
Prop
Index
Phys
Prop
Index
Cols
Index
Meta
1 FALSE SALES_ORDER_N1 QTUNE NORMAL NONUNIQUE 2 ORDER_NUM ORDER_NUM 300000 300000 28-NOV-12 Stats Prop Phys Cols Meta
2 FALSE SALES_ORDER_N2 QTUNE NORMAL NONUNIQUE 4
3
CUSTOMER_ID
ORDER_DATE
CUSTOMER_ID
ORDER_DATE
300000 300000 28-NOV-12 Stats Prop Phys Cols Meta
3 FALSE SALES_ORDER_PK QTUNE NORMAL UNIQUE 1 ORDER_ID ORDER_ID 300000 300000 28-NOV-12 Stats Prop Phys Cols Meta
(1) Column names including system-generated names.
(2) CBO Statistics.
Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER - Index Statistics

# In Plan Index Name Owner Index Type Part Temp Num Rows1 Sample Size1 Perc Last Analyzed1 Distinct Keys1 Blevel1 Segment Extents Segment Blocks Total Segment Blocks2 DBMS_SPACE Allocated Blocks3 Leaf Blocks1 Leaf Estimate Target Size4 Avg Leaf Blocks per Key1 Avg Data Blocks per Key1 Clustering Factor1 Global Stats1 User Stats1 Stat Type Locked Stale Stats Avg Cached Blocks Avg Cache Hit Ratio Clustering Factor Quality5 Full Index Scan Cost6 Max Index Selectivity7
1 FALSE SALES_ORDER_N1 QTUNE NORMAL NO N 300000 300000 100.0 2012-11-28/09:55:58 299840 2 24 1152 1152 1152 1087 1 1 299837 YES NO NO WORST 300926 0.001542
2 FALSE SALES_ORDER_N2 QTUNE NORMAL NO N 300000 300000 100.0 2012-11-28/09:56:03 299546 2 24 1152 1152 1024 1000 1 1 299799 YES NO NO WORST 300801 0.001543
3 FALSE SALES_ORDER_PK QTUNE NORMAL NO N 300000 300000 100.0 2012-11-28/09:56:06 300000 1 21 768 768 896 626 1 1 1657 YES NO NO BEST 2283 0.203241
(1) CBO Statistics.
(2) It considers the blocks from all partitions (if the index is partitioned).
(3) This is the estimated size of the index if it were rebuilt, as computed by DBMS_SPACE.CREATE_INDEX_COST.
(4) Estimated leaf blocks with a 90% index efficiency. Only evaluated for non-partitioned normal indexes with more than 10000 leaf blocks.
(5) BEST:less than 76270. GOOD:between 76270 and 150847. POOR:between 150847 and 225423. WORST:greater than 225423.
(6) It assumes default CBO environment, including optimizer_index_cost_adj=100 and optimizer_index_caching=0 among others.
(7) Index Selectivity where Full Index Scan Cost meets Full Table Scan Cost. A value of 0.02 means that if selecting 2% of the rows or less, an index scan is cheaper than a FTS.
Go to Index Statistics Versions
Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER - Index Properties

# In Plan Index Name Owner Index Type Uniqueness Table Type Part Degree Instances Temp Duration Incl Col Pct Direct Access IOT Redundant PKey Elim Join Index Secondary Domain Index Type Owner Domain Index Type Name Domain Index Params Domain Index Status Domain Index Oper Status Domain Index Mgment Function Based Index Status Generated Visibility Status Dropped Segment Created
1 FALSE SALES_ORDER_N1 QTUNE NORMAL NONUNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
2 FALSE SALES_ORDER_N2 QTUNE NORMAL NONUNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
3 FALSE SALES_ORDER_PK QTUNE NORMAL UNIQUE TABLE NO 1 1 N NO NO N N VISIBLE VALID NO YES
Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER - Index Physical Properties

# In Plan Index Name Owner Index Type Part Temp Pct Free Ini Trans Max Trans Initial Extent Next Extent Min Extents Max Extents Pct Increase Pct Threshold Free Lists Free List Groups Logging Buffer Pool Flash Cache Cell Flash Cache TableSpace Name Compression Prefix Length
1 FALSE SALES_ORDER_N1 QTUNE NORMAL NO N 10 2 167 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
2 FALSE SALES_ORDER_N2 QTUNE NORMAL NO N 10 2 255 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
3 FALSE SALES_ORDER_PK QTUNE NORMAL NO N 10 2 255 65536 1048576 1 2147483645 YES DEFAULT DEFAULT DEFAULT USERS DISABLED
Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER_N1 - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER_N1 - Column Statistics

Index type:NORMAL rows:300000 smpl:300000 lvls:2 #lb:1087 #dk:299840 cluf:299837 anlz:2012-11-28/09:55:58
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 FALSE FALSE 2 ORDER_NUM   ASC 300000 0 300000 100.0 299840 FALSE"AA003667020574""ZZ999041716303" 2012-11-28/09:55:51 15 3.335112e-06 1 NONE FALSE YES NO 0.000003 2
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.SALES_ORDER_N1 - Column Usage

# Col Pos In Pred In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 1 FALSE FALSE 2 ORDER_NUM   0 0 0 0 0 1 2012-11-20/06:48:17

QTUNE.SALES_ORDER_N1 - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 FALSE FALSE 2 ORDER_NUM VARCHAR2 4000 N   CHAR_CS 4000 4000 B NO YES NO NO 2 2ORDER_NUM
Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER_N2 - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER_N2 - Column Statistics

Index type:NORMAL rows:300000 smpl:300000 lvls:2 #lb:1000 #dk:299546 cluf:299799 anlz:2012-11-28/09:56:03
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 [+] TRUE 4 CUSTOMER_ID   ASC 300000 0 300000 100.0 95952 FALSE"1""99999" 2012-11-28/09:55:51 5 1.042188e-05 1 NONE FALSE YES NO 0.000010 4
2 2 FALSE FALSE 3 ORDER_DATE   ASC 300000 0 300000 100.0 1002 FALSE" 2010/02/23 00:00:00"" 2012/11/20 00:00:00" 2012-11-28/09:55:51 8 9.980040e-04 1 NONE FALSE YES NO 0.000998 300
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.SALES_ORDER_N2 - Column Usage

# Col Pos In Pred In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 1 TRUE TRUE 4 CUSTOMER_ID   55 57 0 0 0 1 2013-02-04/11:06:47

QTUNE.SALES_ORDER_N2 - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 TRUE TRUE 4 CUSTOMER_ID NUMBER 22 N   0 NO YES NO NO 4 4CUSTOMER_ID
2 2 FALSE FALSE 3 ORDER_DATE DATE 7 Y   0 NO YES NO NO 3 3ORDER_DATE
Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER_PK - Index Columns

Go to Indexes
Go to Tables
Go to Top

QTUNE.SALES_ORDER_PK - Column Statistics

Index type:NORMAL rows:300000 smpl:300000 lvls:1 #lb:626 #dk:300000 cluf:1657 anlz:2012-11-28/09:56:06
# Col Pos In Pred In Proj Col ID Column Name Data Default Not Null with Default Value Descend 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 1 [+] TRUE 1 ORDER_ID   ASC 300000 0 300000 100.0 300000 FALSE"1""300000" 2012-11-28/09:55:51 5 3.333333e-06 1 NONE FALSE YES NO 0.000003 1
(1) A value of TRUE means that section "Column Statistics Versions" shows "Number of Distinct Values" changing more than 10% between two consecutive versions.
(2) The display of values in this column is controlled by tool parameter "s_mask_for_values". Its current value is "CLEAR".
(3) A value of TRUE means that section "Column Statistics Versions" shows "Endpoint Count" changing more than 10% between two consecutive versions.

QTUNE.SALES_ORDER_PK - Column Usage

# Col Pos In Pred In Proj Col ID Column Name Data Default Equality Preds Equijoin Preds Non-equijoin Preds Range Preds LIKE Preds NULL Preds Timestamp
1 1 TRUE TRUE 1 ORDER_ID   0 58 0 0 0 1 2013-02-04/11:06:47

QTUNE.SALES_ORDER_PK - Column Properties

# Col Pos In Pred In Proj Col ID Column Name Data Type Data Type Modifier Data Type Owner Data Length Data Precision Data Scale Nullable Default Length Data Default Not Null with Default Value Character Set Name Char Col Decl Length Char Length Char Used V80 Fmt Image Data Upgraded Hidden Column Virtual Column Segment Column ID Internal Column ID Qualified Col Name
1 1 TRUE TRUE 1 ORDER_ID NUMBER 22 N   0 NO YES NO NO 1 1ORDER_ID
Go to Indexes
Go to Tables
Go to Top

Objects

Restricted list of objects related to the SQL being analyzed. Partitions and Subpartitions are excluded.
Further restricted up to 1000 rows as per tool parameter "r_rows_table_l".
SQL: [+]
# Object Type Object Name Object Owner Object ID Data Object ID Created Last DDL Time Timestamp Status T G S Name Space Edition Name Metadata Metadata Error
1 INDEX CUSTOMER_F1 QTUNE 107086 107086 2012-11-20/06:46:46 2012-11-20/06:46:46 2012-11-20:06:46:46 VALID N N N 4 Metadata
2 INDEX CUSTOMER_N1 QTUNE 107084 107084 2012-11-20/06:46:41 2012-11-20/06:46:41 2012-11-20:06:46:41 VALID N N N 4 Metadata
3 INDEX CUSTOMER_N2 QTUNE 107085 107085 2012-11-20/06:46:45 2012-11-20/06:46:45 2012-11-20:06:46:45 VALID N N N 4 Metadata
4 INDEX CUSTOMER_PK QTUNE 107083 107083 2012-11-20/06:46:39 2012-11-20/06:46:39 2012-11-20:06:46:39 VALID N N N 4 Metadata
5 INDEX ORDER_LINE_N1 QTUNE 107096 107096 2012-11-20/06:58:08 2012-11-20/06:58:08 2012-11-20:06:58:08 VALID N N N 4 Metadata
6 INDEX ORDER_LINE_N2 QTUNE 107097 107097 2012-11-20/06:58:55 2012-11-20/06:58:55 2012-11-20:06:58:55 VALID N N N 4 Metadata
7 INDEX ORDER_LINE_PK QTUNE 107095 107095 2012-11-20/06:57:22 2012-11-20/06:57:22 2012-11-20:06:57:22 VALID N N N 4 Metadata
8 INDEX PART_N1 QTUNE 107089 107089 2012-11-20/06:47:24 2012-11-20/06:47:24 2012-11-20:06:47:24 VALID N N N 4 Metadata
9 INDEX PART_PK QTUNE 107088 107088 2012-11-20/06:47:21 2012-11-20/06:47:21 2012-11-20:06:47:21 VALID N N N 4 Metadata
10 INDEX SALES_ORDER_N1 QTUNE 107092 107092 2012-11-20/06:48:05 2012-11-20/06:48:05 2012-11-20:06:48:05 VALID N N N 4 Metadata
11 INDEX SALES_ORDER_N2 QTUNE 107093 107093 2012-11-20/06:48:12 2012-11-20/06:48:12 2012-11-20:06:48:12 VALID N N N 4 Metadata
12 INDEX SALES_ORDER_PK QTUNE 107091 107091 2012-11-20/06:48:01 2012-11-20/06:48:01 2012-11-20:06:48:01 VALID N N N 4 Metadata
13 TABLE CUSTOMER QTUNE 107082 107082 2012-11-20/06:46:20 2012-11-20/06:46:50 2012-11-20:06:46:40 VALID N N N 1 Metadata
14 TABLE ORDER_LINE QTUNE 107094 107094 2012-11-20/06:48:23 2012-11-20/07:00:19 2012-11-20:06:48:23 VALID N N N 1 Metadata
15 TABLE PART QTUNE 107087 107087 2012-11-20/06:46:50 2012-11-20/06:47:32 2012-11-20:06:47:32 VALID N N N 1 Metadata
16 TABLE SALES_ORDER QTUNE 107090 107090 2012-11-20/06:47:37 2012-11-20/06:48:17 2012-11-20:06:48:17 VALID N N N 1 Metadata
17 VIEW CUSTOMER_V QTUNE 78539 2012-04-05/15:52:52 2012-11-20/07:00:57 2012-04-05:15:52:52 VALID N N N 1 Metadata
18 VIEW SALES_ORDER_V QTUNE 78538 2012-04-05/15:52:52 2012-11-20/07:00:57 2012-11-20:07:00:57 VALID N N N 1 Metadata
Go to Top

Object Dependency

# Object Type Object Name Object Owner Metadata
1 TABLE CUSTOMER QTUNE Metadata
2 TABLE ORDER_LINE QTUNE Metadata
3 TABLE PART QTUNE Metadata
4 TABLE SALES_ORDER QTUNE Metadata
5 VIEW CUSTOMER_V QTUNE Metadata
6 VIEW SALES_ORDER_V QTUNE Metadata
Go to Top

Tablespaces

# Tablespace Name Block Size Initial Extent Next Extent Min Extents Max Extents Max Size Pct Increase Min Extent Length Status Contents Logging Force Logging Extent Management Allocation Type Plugged in Segment Space Management Default Table Compression Retention Big File Predicate Evaluation Encrypted Compress for Total Terabytes
1 SYSAUX 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO 0.001 TB
2 SYSTEM 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOT APPLY NO HOST NO 0.001 TB
3 TEMP 8192 1048576 1048576 1 2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO 0.000 TB
4 UNDOTBS1 8192 65536 1 2147483645 2147483645 65536 ONLINE UNDO LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO 0.001 TB
5 USERS 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO 0.004 TB
Go to Top

Metadata

Go to Top

Index - Metadata

Go to Metadata
Go to Top

QTUNE.CUSTOMER_F1 - Index Metadata

  CREATE INDEX "QTUNE"."CUSTOMER_F1" ON "QTUNE"."CUSTOMER" (LOWER("CUSTOMER_NAME"))
  PCTFREE 10 INITRANS 2 MAXTRANS 167 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.CUSTOMER_N1 - Index Metadata

  CREATE INDEX "QTUNE"."CUSTOMER_N1" ON "QTUNE"."CUSTOMER" ("CUSTOMER_NAME")
  PCTFREE 10 INITRANS 2 MAXTRANS 167 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.CUSTOMER_N2 - Index Metadata

  CREATE INDEX "QTUNE"."CUSTOMER_N2" ON "QTUNE"."CUSTOMER" ("CUSTOMER_TYPE", "CREDIT_LIMIT")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.CUSTOMER_PK - Index Metadata

  CREATE UNIQUE INDEX "QTUNE"."CUSTOMER_PK" ON "QTUNE"."CUSTOMER" ("CUSTOMER_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.ORDER_LINE_N1 - Index Metadata

  CREATE INDEX "QTUNE"."ORDER_LINE_N1" ON "QTUNE"."ORDER_LINE" ("ORDER_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.ORDER_LINE_N2 - Index Metadata

  CREATE INDEX "QTUNE"."ORDER_LINE_N2" ON "QTUNE"."ORDER_LINE" ("PART_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.ORDER_LINE_PK - Index Metadata

  CREATE UNIQUE INDEX "QTUNE"."ORDER_LINE_PK" ON "QTUNE"."ORDER_LINE" ("LINE_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.PART_N1 - Index Metadata

  CREATE INDEX "QTUNE"."PART_N1" ON "QTUNE"."PART" ("PART_NAME")
  PCTFREE 10 INITRANS 2 MAXTRANS 167 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.PART_PK - Index Metadata

  CREATE UNIQUE INDEX "QTUNE"."PART_PK" ON "QTUNE"."PART" ("PART_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.SALES_ORDER_N1 - Index Metadata

  CREATE INDEX "QTUNE"."SALES_ORDER_N1" ON "QTUNE"."SALES_ORDER" ("ORDER_NUM")
  PCTFREE 10 INITRANS 2 MAXTRANS 167 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.SALES_ORDER_N2 - Index Metadata

  CREATE INDEX "QTUNE"."SALES_ORDER_N2" ON "QTUNE"."SALES_ORDER" ("CUSTOMER_ID", "ORDER_DATE")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.SALES_ORDER_PK - Index Metadata

  CREATE UNIQUE INDEX "QTUNE"."SALES_ORDER_PK" ON "QTUNE"."SALES_ORDER" ("ORDER_ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"
Go to Metadata
Go to Top

Table - Metadata

Go to Metadata
Go to Top

QTUNE.CUSTOMER - Table Metadata

  CREATE TABLE "QTUNE"."CUSTOMER"
   (	"CUSTOMER_ID" NUMBER NOT NULL ENABLE,
	"CUSTOMER_NAME" VARCHAR2(4000),
	"CUSTOMER_TYPE" VARCHAR2(40) NOT NULL ENABLE,
	"CREDIT_LIMIT" NUMBER,
	 CONSTRAINT "CUSTOMER_PK" PRIMARY KEY ("CUSTOMER_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.ORDER_LINE - Table Metadata

  CREATE TABLE "QTUNE"."ORDER_LINE"
   (	"LINE_ID" NUMBER NOT NULL ENABLE,
	"ORDER_ID" NUMBER NOT NULL ENABLE,
	"LINE_NUM" NUMBER NOT NULL ENABLE,
	"PART_ID" NUMBER NOT NULL ENABLE,
	"QUANTITY" NUMBER NOT NULL ENABLE,
	"DISCOUNT_PERC" NUMBER,
	 CONSTRAINT "ORDER_LINE_PK" PRIMARY KEY ("LINE_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE,
	 CONSTRAINT "ORDER_FK" FOREIGN KEY ("ORDER_ID")
	  REFERENCES "QTUNE"."SALES_ORDER" ("ORDER_ID") ENABLE,
	 CONSTRAINT "PART_FK" FOREIGN KEY ("PART_ID")
	  REFERENCES "QTUNE"."PART" ("PART_ID") ENABLE
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.PART - Table Metadata

  CREATE TABLE "QTUNE"."PART"
   (	"PART_ID" NUMBER NOT NULL ENABLE,
	"PART_NAME" VARCHAR2(4000),
	"PART_TYPE" VARCHAR2(1) NOT NULL ENABLE,
	"PART_PRICE" NUMBER NOT NULL ENABLE,
	"ON_HAND" NUMBER,
	 CONSTRAINT "PART_PK" PRIMARY KEY ("PART_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"

QTUNE.SALES_ORDER - Table Metadata

  CREATE TABLE "QTUNE"."SALES_ORDER"
   (	"ORDER_ID" NUMBER NOT NULL ENABLE,
	"ORDER_NUM" VARCHAR2(4000) NOT NULL ENABLE,
	"ORDER_DATE" DATE,
	"CUSTOMER_ID" NUMBER NOT NULL ENABLE,
	"STATUS" VARCHAR2(1),
	 CONSTRAINT "SALES_ORDER_PK" PRIMARY KEY ("ORDER_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"
Go to Metadata
Go to Top

View - Metadata

Go to Metadata
Go to Top

QTUNE.CUSTOMER_V - View Metadata

  CREATE OR REPLACE FORCE VIEW "QTUNE"."CUSTOMER_V" ("CUSTOMER_ID", "CUSTOMER_NAME", "CUSTOMER_TYPE", "CREDIT_LIMIT", "ORDERS_COUNT", "ORDERS_TOTAL") AS
  SELECT c.customer_id,
       c.customer_name,
       c.customer_type,
       c.credit_limit,
       orders.orders_count,
       orders.orders_total
  FROM customer c,
       (SELECT /*+ QB_NAME (open_orders_rollup_qb) */
               o.customer_id,
               COUNT(*) orders_count,
               SUM(o.order_total) orders_total
          FROM sales_order_v o
         WHERE o.status NOT IN ('C', 'S')
         GROUP BY
               o.customer_id) orders
 WHERE c.customer_id = orders.customer_id

QTUNE.SALES_ORDER_V - View Metadata

  CREATE OR REPLACE FORCE VIEW "QTUNE"."SALES_ORDER_V" ("CUSTOMER_ID", "CUSTOMER_NAME", "CUSTOMER_TYPE", "CREDIT_LIMIT", "ORDER_NUM", "ORDER_DATE", "STATUS", "ORDER_LINES", "ITEMS_TOTAL", "ORDER_TOTAL") AS
  SELECT o.customer_id,
       c.customer_name,
       c.customer_type,
       c.credit_limit,
       o.order_num,
       o.order_date,
       o.status,
       lines_total.order_lines,
       lines_total.items_total,
       lines_total.order_total
  FROM sales_order o,
       customer    c,
       (SELECT /*+ QB_NAME (lines_rollup_qb) */
               l.order_id,
               COUNT(*) order_lines,
               SUM(l.quantity) items_total,
               SUM(ROUND(l.quantity * p.part_price * (100 - NVL(l.discount_perc, 0)) / 100, 2)) order_total
          FROM order_line l,
               part       p
         WHERE l.part_id = p.part_id
         GROUP BY
               l.order_id) lines_total
 WHERE o.customer_id = c.customer_id
   AND o.order_id    = lines_total.order_id
Go to Metadata
Go to Top
215187.1 SQLT XECUTE 11.4.5.4 secs: 949.000 sqlt_end: 2013-02-04/11:14:23 tool_date: 2013-02-04  install_date: 2013-02-04/07:34:24