215187.1 SQLT XPLAIN 11.4.5.4  Report: sqlt_s53242_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/11:01:28

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 One plan was 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 DBMS_STATS SYSTEM STATISTICS Workload CBO System Statistics are not gathered. CBO is using default values. [+]
8 MAT_VIEW REWRITE_ENABLED There is/are 3 materialized view(s) with rewrite enabled. [+]
9 TABLE QTUNE.CUSTOMER Table CBO statistics are 68 days old: 2012-11-28/09:55:33 [+]
10 TABLE QTUNE.CUSTOMER Table has 1 CBO statistics extension(s). [+]
11 TABLE QTUNE.ORDER_LINE Table CBO statistics are 68 days old: 2012-11-28/09:56:22 [+]
12 TABLE QTUNE.PART Table CBO statistics are 68 days old: 2012-11-28/09:55:44 [+]
13 TABLE QTUNE.PART Table has 1 CBO statistics extension(s). [+]
14 TABLE QTUNE.SALES_ORDER Table CBO statistics are 68 days old: 2012-11-28/09:55:54 [+]
15 TABLE QTUNE.SALES_ORDER Table has 1 CBO statistics extension(s). [+]
16 TABLE COLUMN SALES_ORDER.STATUS Column is referenced in predicate(s) and it is not included in any index. [+]
17 TABLE COLUMN SALES_ORDER.STATUS Column is candidate for NOT NULL constraint. [+]
Go to Top

SQL Text (f7sjyykn6n73j 2825526385 14C8DC4AA3A329661EC81E65596CA900 9761941148170960647)

EXPLAIN PLAN SET statement_id = '53242' INTO SQLTXPLAIN.sqlt$_sql_plan_table FOR
SELECT 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 (36FB5A95EAB389A05B72C48D11DD7254 11649897069791544186)

SQL Text: [-]
SELECT 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: f7sjyykn6n73j
Hash Value: 2825526385
Signature for Stored Outlines: 36FB5A95EAB389A05B72C48D11DD7254
Signature for SQL Profiles (force match FALSE): 11649897069791544186
Signature for SQL Profiles (force match TRUE): 11649897069791544186
Command Type: EXPLAIN (50)
Signature for Stored Outlines for unstripped sql_text: 14C8DC4AA3A329661EC81E65596CA900
Signature for SQL Profiles for unstripped sql_text (force match FALSE): 9761941148170960647
Signature for SQL Profiles for unstripped sql_text (force match TRUE): 9761941148170960647
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/sql2.sql
STATID: s53242_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 XPLAIN 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 XPLAIN 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

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:01:59.772952 -05:00 2013-02-04/11:01:59.834065 -05:00 export_table_stats QTUNE."SALES_ORDER"
2 2013-02-04/11:01:59.761808 -05:00 2013-02-04/11:01:59.772148 -05:00 export_table_stats QTUNE."PART"
3 2013-02-04/11:01:59.750448 -05:00 2013-02-04/11:01:59.760976 -05:00 export_table_stats QTUNE."ORDER_LINE"
4 2013-02-04/11:01:59.626513 -05:00 2013-02-04/11:01:59.749161 -05:00 export_table_stats QTUNE."CUSTOMER"
5 2013-02-04/10:52:29.618689 -05:00 2013-02-04/10:52:30.492602 -05:00 export_table_stats QTUNE."SALES_ORDER"
6 2013-02-04/10:52:28.868235 -05:00 2013-02-04/10:52:29.617837 -05:00 export_table_stats QTUNE."PART"
7 2013-02-04/10:52:28.856967 -05:00 2013-02-04/10:52:28.867424 -05:00 export_table_stats QTUNE."ORDER_LINE"
8 2013-02-04/10:52:27.095657 -05:00 2013-02-04/10:52:28.349870 -05:00 export_table_stats QTUNE."CUSTOMER"
9 2013-02-04/10:08:26.446577 -05:00 2013-02-04/10:08:26.458379 -05:00 export_table_stats QTUNE."SALES_ORDER"
10 2013-02-04/10:08:26.434530 -05:00 2013-02-04/10:08:26.445703 -05:00 export_table_stats QTUNE."PART"
11 2013-02-04/10:08:26.421487 -05:00 2013-02-04/10:08:26.433251 -05:00 export_table_stats QTUNE."ORDER_LINE"
12 2013-02-04/10:08:26.363906 -05:00 2013-02-04/10:08:26.414464 -05:00 export_table_stats QTUNE."CUSTOMER"
13 2013-02-04/10:02:39.675798 -05:00 2013-02-04/10:02:39.721205 -05:00 export_table_stats QTUNE."SALES_ORDER"
14 2013-02-04/10:02:39.664805 -05:00 2013-02-04/10:02:39.674859 -05:00 export_table_stats QTUNE."PART"
15 2013-02-04/10:02:39.619262 -05:00 2013-02-04/10:02:39.663970 -05:00 export_table_stats QTUNE."ORDER_LINE"
16 2013-02-04/10:02:39.454232 -05:00 2013-02-04/10:02:39.617839 -05:00 export_table_stats QTUNE."CUSTOMER"
17 2013-02-04/08:59:50.940089 -05:00 2013-02-04/08:59:51.039062 -05:00 export_table_stats QTUNE."SALES_ORDER"
18 2013-02-04/08:59:50.930375 -05:00 2013-02-04/08:59:50.939298 -05:00 export_table_stats QTUNE."PART"
19 2013-02-04/08:59:50.919435 -05:00 2013-02-04/08:59:50.929589 -05:00 export_table_stats QTUNE."ORDER_LINE"
20 2013-02-04/08:59:50.811007 -05:00 2013-02-04/08:59:50.918451 -05:00 export_table_stats QTUNE."CUSTOMER"
21 2013-02-04/08:52:20.443700 -05:00 2013-02-04/08:52:20.455380 -05:00 export_table_stats QTUNE."SALES_ORDER"
22 2013-02-04/08:52:20.433175 -05:00 2013-02-04/08:52:20.442751 -05:00 export_table_stats QTUNE."PART"
23 2013-02-04/08:52:20.420477 -05:00 2013-02-04/08:52:20.432173 -05:00 export_table_stats QTUNE."ORDER_LINE"
24 2013-02-04/08:52:20.313423 -05:00 2013-02-04/08:52:20.419346 -05:00 export_table_stats QTUNE."CUSTOMER"
25 2013-02-04/08:30:14.130086 -05:00 2013-02-04/08:30:14.140512 -05:00 export_table_stats QTUNE."SALES_ORDER"
26 2013-02-04/08:30:14.118764 -05:00 2013-02-04/08:30:14.129185 -05:00 export_table_stats QTUNE."PART"
27 2013-02-04/08:30:14.105043 -05:00 2013-02-04/08:30:14.117790 -05:00 export_table_stats QTUNE."ORDER_LINE"
28 2013-02-04/08:30:13.875775 -05:00 2013-02-04/08:30:14.100576 -05:00 export_table_stats QTUNE."CUSTOMER"
29 2013-01-25/13:20:11.593683 -05:00 2013-01-25/13:20:11.605838 -05:00 export_table_stats QTUNE."SALES_ORDER"
30 2013-01-25/13:20:11.581945 -05:00 2013-01-25/13:20:11.591764 -05:00 export_table_stats QTUNE."PART"
# Start Time End Time Operation Target
31 2013-01-25/13:20:11.570329 -05:00 2013-01-25/13:20:11.581023 -05:00 export_table_stats QTUNE."ORDER_LINE"
32 2013-01-25/13:20:11.450504 -05:00 2013-01-25/13:20:11.569114 -05:00 export_table_stats QTUNE."CUSTOMER"
33 2013-01-25/13:10:54.790161 -05:00 2013-01-25/13:10:54.853434 -05:00 export_table_stats QTUNE."SALES_ORDER"
34 2013-01-25/13:10:54.780153 -05:00 2013-01-25/13:10:54.789350 -05:00 export_table_stats QTUNE."PART"
35 2013-01-25/13:10:54.768929 -05:00 2013-01-25/13:10:54.779261 -05:00 export_table_stats QTUNE."ORDER_LINE"
36 2013-01-25/13:10:54.627590 -05:00 2013-01-25/13:10:54.739286 -05:00 export_table_stats QTUNE."CUSTOMER"
37 2013-01-25/04:49:07.849281 -05:00 2013-01-25/04:49:07.905418 -05:00 export_table_stats QTUNE."SALES_ORDER"
38 2013-01-25/04:49:07.832432 -05:00 2013-01-25/04:49:07.848292 -05:00 export_table_stats QTUNE."PART"
39 2013-01-25/04:49:07.755086 -05:00 2013-01-25/04:49:07.831416 -05:00 export_table_stats QTUNE."ORDER_LINE"
40 2013-01-25/04:49:07.612581 -05:00 2013-01-25/04:49:07.753699 -05:00 export_table_stats QTUNE."CUSTOMER"
41 2013-01-25/03:37:02.453940 -05:00 2013-01-25/03:37:02.505718 -05:00 export_table_stats QTUNE."SALES_ORDER"
42 2013-01-25/03:37:02.315897 -05:00 2013-01-25/03:37:02.452888 -05:00 export_table_stats QTUNE."PART"
43 2013-01-25/03:37:02.172448 -05:00 2013-01-25/03:37:02.314858 -05:00 export_table_stats QTUNE."ORDER_LINE"
44 2013-01-25/03:37:01.540468 -05:00 2013-01-25/03:37:02.171069 -05:00 export_table_stats QTUNE."CUSTOMER"
45 2013-01-16/04:59:49.325720 -05:00 2013-01-16/04:59:49.371230 -05:00 delete_system_stats
46 2013-01-15/09:47:19.884626 -05:00 2013-01-15/09:47:19.932191 -05:00 delete_system_stats
47 2013-01-15/07:32:03.564744 -05:00 2013-01-15/07:32:03.707957 -05:00 delete_system_stats
48 2013-01-14/08:15:32.926657 -05:00 2013-01-14/08:15:32.960903 -05:00 delete_system_stats
49 2013-01-14/07:26:43.645082 -05:00 2013-01-14/07:26:43.647696 -05:00 set_system_stats
50 2013-01-14/07:26:43.632399 -05:00 2013-01-14/07:26:43.635050 -05:00 set_system_stats
51 2013-01-14/07:26:43.618574 -05:00 2013-01-14/07:26:43.621259 -05:00 set_system_stats
52 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 XPLAIN 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_numeric_characters 1 1 ".,"   FALSE FALSE FALSE TRUE FALSE FALSE 2 NLS numeric characters
21 TRUE MODIFIED timed_statistics 1 1 "TRUE"   FALSE FALSE FALSE TRUE IMMEDIATE TRUE 1 maintain internal timing statistics
22 TRUE MODIFIED tracefile_identifier 1 1 "S53242_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: [+]

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 3DEF9424 657302870 [B] [W] 0.288 0.280 0.000 0.000 0.000 0.000 102 2 0 0 1 2013-02-04/11:01:28 0.288 0.280 0.000 0.000 0.000 0.000 102 2 0 0 TRUE  
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 657302870 [B] [W] 0.288 0.280 0.000 0.000 102 2 0 0 1 0 1 1 0 MEM GV$SQLAREA_PLAN_HASH N 1504581476 21392 256.704 2013-02-04/11:01:29 2013-02-04/11:01:29
(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 657302870 MEM GV$SQLAREA_PLAN_HASH N 1 Stats 0.288 0.280 0.000 0.000 102 2 0 0 1 0 1 1 0 1 1504581476 21392 2013-02-04/11:01:29 2013-02-04/11:01:29
(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 657302870

Plan Hash Value: 657302870
Src: MEM
Source: GV$SQLAREA_PLAN_HASH
Is Bind Sensitive: N
Inst ID: 1
Version Count: 1
Executions: 1
Elapsed Time in secs: 0.288
CPU Time in secs: 0.280
User I/O Wait Time in secs: 0.000
Application Wait Time in secs: 0.000
Concurrency Wait Time in secs: 0.000
Cluster Wait Time in secs: 0.000
PL/SQL Exec Time in secs: 0.000
Java Exec Time in secs: 0.000
Buffer Gets: 102
Disk Reads: 2
Direct Writes: 0
Rows Processed: 0
Parse Calls: 1
Fetches: 0
End of Fetch count: 1
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/11:01:29
Last Load Time: 2013-02-04/11:01:29
Last Active Time: 2013-02-04/11:01:28
Sharable Memory: 83914
Persistent Memory: 21780
Runtime Memory: 20992
Sorts: 0
Serializable Aborts: 0
Command Type: 50
Optimizer Mode: ALL_ROWS
Optimizer Env: 1504581476
Optimizer Cost: 21392
Parsing User ID: 92
Parsing Schema ID: 92
Parsing Schema Name: QTUNE
Module: sqltxadmin.sqlt$a (xplain)
Action: 53242 45159 ALTER SESSION SET EV
SQL Profile: "null"
Exact Matching Signature: 11649897069791544186
Force Matching Signature: 11649897069791544186
Outline Category: "null"
Remote: N
Object Status: VALID
Program ID: 0
Program Line #: 0
Typecheck Memory: 815536
I/O Interconnect Bytes: 16384
Physical Read Requests: 2
Physical Read Bytes: 16384
Physical Write Requests: 0
Physical Write Bytes: 0
Optimized Physical Read Requests: 0
I/O Cell Uncompressed Bytes: 0
I/O Cell Offload Eligible Bytes: 0
I/O Cell Offload Returned Bytes: 0
Go to Plan Performance Statistics
Go to Plans Summary
Go to Top

Execution Plans

List ordered by phv and source.
# Plan Hash Value SQLT
Plan
Hash
Value1
SQLT
Plan
Hash
Value21
Src Source Plan Info Plan Stability Is
Bind
Sensitive
Optimizer Optimizer
Cost
Estimated
Cardinality
E-Rows
Rows
Processed
A-Rows
Plan Timestamp Child
Plans2
Plan ID Task ID Attribute
1 657302870 [B] [W] 92811 38096 XPL PLAN_TABLE ALL_ROWS 21392 2102 2013-02-04/11:01:29 1163
(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 [B] [W]  sqlt_phv:92811  sqlt_phv2:38096  source:PLAN_TABLE  timestamp:2013-02-04/11:01:29

SQL Text: [-]
EXPLAIN PLAN SET statement_id = '53242' INTO SQLTXPLAIN.sqlt$_sql_plan_table FOR
SELECT 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

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 657302870 [B] [W] 1
Go to Top

SQL Statistics for 657302870 [B] [W]

Inst ID: 1
Child Number: 0
Child Address: 3DEF9424
Executions: 1
Elapsed Time in secs: 0.288
CPU Time in secs: 0.280
User I/O Wait Time in secs: 0.000
Application Wait Time in secs: 0.000
Concurrency Wait Time in secs: 0.000
Cluster Wait Time in secs: 0.000
PL/SQL Exec Time in secs: 0.000
Java Exec Time in secs: 0.000
Buffer Gets: 102
Disk Reads: 2
Direct Writes: 0
Rows Processed: 0
Parse Calls: 1
Fetches: 0
End of Fetch count: 1
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: 1
Pinned Total: 2
First Load Time: 2013-02-04/11:01:29
Last Load Time: 2013-02-04/11:01:29
Last Active Time: 2013-02-04/11:01:28
Sharable Memory: 83914
Persistent Memory: 21780
Runtime Memory: 20992
Sorts: 0
Serializable Aborts: 0
SQL Type: 6
Command Type: 50
Optimizer Mode: ALL_ROWS
Optimizer Env: 1504581476
Optimizer Cost: 21392
Parsing User ID: 92
Parsing Schema ID: 92
Parsing Schema Name: QTUNE
Service: SYS$USERS
Module: sqltxadmin.sqlt$a (xplain)
Action: 53242 45159 ALTER SESSION SET EV
Is Binds Aware: N
Is Bind Sensitive: N
Is Obsolete: N
Is Sharable: Y
Literal Hash Value: 0
SQL Patch: "null"
SQL Plan Baseline: "null"
SQL Profile: "null"
Exact Matching Signature: 11649897069791544186
Force Matching Signature: 11649897069791544186
Outline Category: "null"
Remote: N
Object Status: VALID
Program ID: 0
Program Line #: 0
Type Check Memory: 815536
Type Check Heap: 103D26B4
I/O Interconnect Bytes: 16384
Physical Read Requests: 2
Physical Read Bytes: 16384
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

Parallel Processing

Go to Top

PX Instance Groups

Parallel-execution instance groups available to current session (SID=13).
Go to Parallel Processing
Go to Top

Active PX Servers

Statistics for active parallel-execution servers.
SQL: [+]

PX Processes

Parallel-execution processes, and sessions running on them.
SQL: [+]

PX Sessions

Sessions running on parallel-execution servers.
SQL: [+]

PX System Statistics - Summary

System statistics for parallel-execution servers.
Statistic Inst ID Value
Servers Busy : 1 0
Servers Idle : 1 0
Servers Highwater : 1 8
Server Sessions : 1 154
Servers Started : 1 46
Servers Shutdown : 1 46
Servers Cleaned Up : 1 0
Queries Queued : 1 0
Queries Initiated : 1 65
Queries Initiated (IPQ) : 1 0
DML Initiated : 1 0
DML Initiated (IPQ) : 1 0
DDL Initiated : 1 3
DDL Initiated (IPQ) : 1 0
DFO Trees : 1 68
Sessions Active : 1 0
Local Msgs Sent : 1 6602
Distr Msgs Sent : 1 0
Local Msgs Recv'd : 1 6602
Distr Msgs Recv'd : 1 0
Go to Parallel Processing
Go to Top

PX Process System Statistics - Summary

Process system statistics for parallel-execution servers.
Statistic Inst ID Value
Servers In Use : 1 0
Servers Available : 1 0
Servers Started : 1 46
Servers Shutdown : 1 46
Servers Highwater : 1 8
Servers Cleaned Up : 1 0
Server Sessions : 1 154
Memory Chunks Allocated : 1 19
Memory Chunks Freed : 1 15
Memory Chunks Current : 1 4
Memory Chunks HWM : 1 15
Buffers Allocated : 1 870
Buffers Freed : 1 870
Buffers Current : 1 0
Buffers HWM : 1 101
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 97200 100000 100000 802 28-NOV-12 Stats 1 Prop Phys 3 5 5 2 4 Meta
2 ORDER_LINE QTUNE 3487000 3450201 3450201 13157 28-NOV-12 Stats   Prop Phys 8 6 3   3 Meta
3 PART QTUNE 195900 200000 200000 1430 28-NOV-12 Stats 1 Prop Phys 4 6 2   2 Meta
4 SALES_ORDER QTUNE 293900 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 97200 100000 100000 100.0 2012-11-28/09:55:33 22 896 896 1280 802 0 0 92 0 YES NO NO 0 0 220
2 ORDER_LINE QTUNE NO N 3487000 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 195900 200000 200000 100.0 2012-11-28/09:55:44 27 1536 1536 1664 1430 0 0 58 0 YES NO NO 0 0 392
4 SALES_ORDER QTUNE NO N 293900 300000 300000 100.0 2012-11-28/09:55:54 29 1792 1792 1664 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 97200 100000 100000 802 28-NOV-12 5 3 Prop 2
2 ORDER_LINE QTUNE 3487000 3450201 3450201 13157 28-NOV-12 6 2 Prop  
3 PART QTUNE 195900 200000 200000 1430 28-NOV-12 6 3 Prop  
4 SALES_ORDER QTUNE 293900 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   54 61 0 0 0 1 2013-02-04/11:01:10
2 TRUE TRUE TRUE 4 CREDIT_LIMIT   0 0 0 56 0 0 2013-02-04/11:01:10
3 TRUE TRUE FALSE 3 CUSTOMER_TYPE   61 0 0 0 0 1 2013-02-04/11:01:10

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   54 57 0 0 0 0 2013-02-04/11:01:10
2 TRUE TRUE TRUE 4 PART_ID   0 57 0 0 0 0 2013-02-04/11:01:10

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 62 0 0 0 1 2013-02-04/11:01:10
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 57 0 0 0 1 2013-02-04/11:01:10
2 TRUE TRUE TRUE 4 CUSTOMER_ID   54 56 0 0 0 1 2013-02-04/11:01:10
3 TRUE FALSE FALSE 5 STATUS   56 0 0 0 0 0 2013-02-04/11:01:10
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 97200 100000 100000 802 28-NOV-12 4
2 ORDER_LINE QTUNE 3487000 3450201 3450201 13157 28-NOV-12 3
3 PART QTUNE 195900 200000 200000 1430 28-NOV-12 2
4 SALES_ORDER QTUNE 293900 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 97200 100000 100000 802 28-NOV-12 4
2 ORDER_LINE QTUNE 3487000 3450201 3450201 13157 28-NOV-12 3
3 PART QTUNE 195900 200000 200000 1430 28-NOV-12 2
4 SALES_ORDER QTUNE 293900 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   54 61 0 0 0 1 2013-02-04/11:01:10

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   61 0 0 0 0 1 2013-02-04/11:01:10
2 2 TRUE TRUE 4 CREDIT_LIMIT   0 0 0 56 0 0 2013-02-04/11:01:10

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   54 57 0 0 0 0 2013-02-04/11:01:10

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 57 0 0 0 0 2013-02-04/11:01:10

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 62 0 0 0 1 2013-02-04/11:01:10

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   54 56 0 0 0 1 2013-02-04/11:01:10

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 57 0 0 0 1 2013-02-04/11:01:10

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 XPLAIN 11.4.5.4 secs: 99.000 sqlt_end: 2013-02-04/11:03:07 tool_date: 2013-02-04  install_date: 2013-02-04/07:34:24