Global
Cursor Sharing and BindsSQL Tuning Advisor |
Plans
Plan ControlSQL Execution |
Tables
Objects |
# | Type | Name | Observation | Details |
---|---|---|---|---|
1 | SYSTEM PARAMETER | MODIFIED | There is one system level initialization parameter with a modified value in AWR. | [+] |
2 | CBO PARAMETER | NON-DEFAULT | There are 3 CBO initialization parameters with a non-default value. | [+] |
3 | CBO PARAMETER | MODIFIED | There are 7 CBO initialization parameters with a modified value. | [+] |
4 | PLAN | PLAN_HASH_VALUE | 2 plans were found for this SQL. | [+] |
5 | PLAN CONTROL | PLAN_CONTROL | None of the plans found was created using one of these: Stored Outline, SQL Profile, SQL Patch or SQL Plan Baseline. | |
6 | PLAN | PLAN_HASH_VALUE | Plan 657302870 has operations with Cost 0 and Card 1. Possible incorrect Selectivity. | [+] |
7 | PLAN | PLAN_HASH_VALUE | Plan 2816325939 has operations with Cost 0 and Card 1. Possible incorrect Selectivity. | [+] |
8 | DBMS_STATS | SYSTEM STATISTICS | Workload CBO System Statistics are not gathered. CBO is using default values. | [+] |
9 | DBMS_STATS | SYSTEM STATISTICS | Single-block read time of 12 milliseconds differs for more than 10% from actual db file sequential read wait time of 1.941 milliseconds. | [+] |
10 | DBMS_STATS | SYSTEM STATISTICS | Multi-block read time of 26 milliseconds differs for more than 10% from actual db file scattered read wait time of .121 milliseconds. | [+] |
11 | STATEMENT | RESPONSE TIME | Execution of this statement took +00 00:01:35.918702. This is wall clock time. | [+] |
12 | MAT_VIEW | REWRITE_ENABLED | There is/are 3 materialized view(s) with rewrite enabled. | [+] |
13 | TABLE | QTUNE.CUSTOMER | Table CBO statistics are 68 days old: 2012-11-28/09:55:33 | [+] |
14 | TABLE | QTUNE.CUSTOMER | Table has 1 CBO statistics extension(s). | [+] |
15 | TABLE | QTUNE.ORDER_LINE | Table CBO statistics are 68 days old: 2012-11-28/09:56:22 | [+] |
16 | TABLE | QTUNE.PART | Table CBO statistics are 68 days old: 2012-11-28/09:55:44 | [+] |
17 | TABLE | QTUNE.PART | Table has 1 CBO statistics extension(s). | [+] |
18 | TABLE | QTUNE.SALES_ORDER | Table CBO statistics are 68 days old: 2012-11-28/09:55:54 | [+] |
19 | TABLE | QTUNE.SALES_ORDER | Table has 1 CBO statistics extension(s). | [+] |
20 | TABLE COLUMN | SALES_ORDER.STATUS | Column is referenced in predicate(s) and it is not included in any index. | [+] |
21 | TABLE COLUMN | SALES_ORDER.STATUS | Column is candidate for NOT NULL constraint. | [+] |
SELECT /*+ gather_plan_statistics monitor bind_aware */ /* sqlt_s53241 */ v.customer_name, v.orders_total, v.credit_limit, (orders_total - credit_limit) over_limit FROM customer_v v WHERE orders_total > credit_limit AND customer_type = :b1 ORDER BY over_limit DESCGo to Top
SELECT /*+ gather_plan_statistics monitor bind_aware */ v.customer_name, v.orders_total, v.credit_limit, (orders_total - credit_limit) over_limit FROM customer_v v WHERE orders_total > credit_limit AND customer_type = :b1 ORDER BY over_limit DESC
SQL ID: | gscwjswcdsqb3 |
Hash Value: | 417093987 |
Signature for Stored Outlines: | B2C3C4A8E292CBCAC2EB5F9482BA6514 |
Signature for SQL Profiles (force match FALSE): | 1178211779310957485 |
Signature for SQL Profiles (force match TRUE): | 1178211779310957485 |
Command Type: | SELECT (3) |
"EXPLAIN PLAN FOR" SQL ID for stripped sql_text: | 37zj7jwpsqkpn |
Signature for Stored Outlines for unstripped sql_text: | D3AFF496873C8F1EA78429E59E3F78C3 |
Signature for SQL Profiles for unstripped sql_text (force match FALSE): | 17810495099954579021 |
Signature for SQL Profiles for unstripped sql_text (force match TRUE): | 17810495099954579021 |
Statement Response Time: | +00 00:01:35.918702 |
Host Name: | host01.example.com |
CPUs: | 2 |
Exadata: | "null" |
RAC: | FALSE |
NLS Characterset (database_properties): |
WE8MSWIN1252 |
DB Time Zone (database_properties): |
00:00 |
DB Block Size (db_block_size): |
8192 |
Optim Peek User Binds (_optim_peek_user_binds): |
TRUE |
DB Size in Terabytes (dba_data_files): |
0.007 TB |
TC Data Size in Gigabytes (dba_segments): |
0.394 GB |
Platform: | Linux |
Product Version: | Oracle Database 11g Enterprise Edition (Production) |
RDBMS Version: | 11.2.0.3.0 |
Language: | US:AMERICAN_AMERICA.WE8MSWIN1252 |
Database Name and ID: | V1123(4223793606) |
Instance Name and ID: | V1123(1) |
EBS: | NO |
Siebel: | NO |
PSFT: | NO |
User Name and ID: | QTUNE (92) |
Input Filename: | input/sample/script2.sql |
STATID: | s53241_v1123_host01 |
# | 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 |
# | Name | Value |
---|---|---|
1 | STATUS | COMPLETED |
2 | DSTART | 01-16-2013 04:59 |
3 | DSTOP | 01-16-2013 04:59 |
4 | FLAGS |
# | Name | Value |
---|---|---|
1 | CPUSPEEDNW | 1796 |
2 | IOSEEKTIM | 10 |
3 | IOTFRSPEED | 4096 |
4 | CPUSPEED | |
5 | MBRC | |
6 | SREADTIM | |
7 | MREADTIM | |
8 | MAXTHR | |
9 | SLAVETHR |
db_block_size: | 8192 |
db_file_multiblock_read_count: | 94 |
_db_file_optimizer_read_count: | 8 |
Estimated CPUSPEED: | 1796 |
Estimated MBRC: | 8 |
Estimated SREADTIM: | 12 |
Estimated MREADTIM: | 26 |
CPU Cost Scaling Factor: | 4.639941e-08 |
CPU Cost Scaling Factor (inverse): | 21552000 |
Actual SREADTIM: | 1.941 |
Actual MREADTIM: | .121 |
# | 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 |
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" |
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 |
# | 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 |
# | Last Analyzed | Fixed Objects |
---|---|---|
1 | NO STATS | 935 |
# | Start Time | End Time | Operation | Target |
---|---|---|---|---|
1 | 2013-02-04/11:13:20.009638 -05:00 | 2013-02-04/11:13:20.022515 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
2 | 2013-02-04/11:13:19.997169 -05:00 | 2013-02-04/11:13:20.008854 -05:00 | export_table_stats | QTUNE."PART" |
3 | 2013-02-04/11:13:19.981833 -05:00 | 2013-02-04/11:13:19.996338 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
4 | 2013-02-04/11:13:19.616548 -05:00 | 2013-02-04/11:13:19.979685 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
5 | 2013-02-04/11:01:59.772952 -05:00 | 2013-02-04/11:01:59.834065 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
6 | 2013-02-04/11:01:59.761808 -05:00 | 2013-02-04/11:01:59.772148 -05:00 | export_table_stats | QTUNE."PART" |
7 | 2013-02-04/11:01:59.750448 -05:00 | 2013-02-04/11:01:59.760976 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
8 | 2013-02-04/11:01:59.626513 -05:00 | 2013-02-04/11:01:59.749161 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
9 | 2013-02-04/10:52:29.618689 -05:00 | 2013-02-04/10:52:30.492602 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
10 | 2013-02-04/10:52:28.868235 -05:00 | 2013-02-04/10:52:29.617837 -05:00 | export_table_stats | QTUNE."PART" |
11 | 2013-02-04/10:52:28.856967 -05:00 | 2013-02-04/10:52:28.867424 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
12 | 2013-02-04/10:52:27.095657 -05:00 | 2013-02-04/10:52:28.349870 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
13 | 2013-02-04/10:08:26.446577 -05:00 | 2013-02-04/10:08:26.458379 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
14 | 2013-02-04/10:08:26.434530 -05:00 | 2013-02-04/10:08:26.445703 -05:00 | export_table_stats | QTUNE."PART" |
15 | 2013-02-04/10:08:26.421487 -05:00 | 2013-02-04/10:08:26.433251 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
16 | 2013-02-04/10:08:26.363906 -05:00 | 2013-02-04/10:08:26.414464 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
17 | 2013-02-04/10:02:39.675798 -05:00 | 2013-02-04/10:02:39.721205 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
18 | 2013-02-04/10:02:39.664805 -05:00 | 2013-02-04/10:02:39.674859 -05:00 | export_table_stats | QTUNE."PART" |
19 | 2013-02-04/10:02:39.619262 -05:00 | 2013-02-04/10:02:39.663970 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
20 | 2013-02-04/10:02:39.454232 -05:00 | 2013-02-04/10:02:39.617839 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
21 | 2013-02-04/08:59:50.940089 -05:00 | 2013-02-04/08:59:51.039062 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
22 | 2013-02-04/08:59:50.930375 -05:00 | 2013-02-04/08:59:50.939298 -05:00 | export_table_stats | QTUNE."PART" |
23 | 2013-02-04/08:59:50.919435 -05:00 | 2013-02-04/08:59:50.929589 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
24 | 2013-02-04/08:59:50.811007 -05:00 | 2013-02-04/08:59:50.918451 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
25 | 2013-02-04/08:52:20.443700 -05:00 | 2013-02-04/08:52:20.455380 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
26 | 2013-02-04/08:52:20.433175 -05:00 | 2013-02-04/08:52:20.442751 -05:00 | export_table_stats | QTUNE."PART" |
27 | 2013-02-04/08:52:20.420477 -05:00 | 2013-02-04/08:52:20.432173 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
28 | 2013-02-04/08:52:20.313423 -05:00 | 2013-02-04/08:52:20.419346 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
29 | 2013-02-04/08:30:14.130086 -05:00 | 2013-02-04/08:30:14.140512 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
30 | 2013-02-04/08:30:14.118764 -05:00 | 2013-02-04/08:30:14.129185 -05:00 | export_table_stats | QTUNE."PART" |
# | Start Time | End Time | Operation | Target |
31 | 2013-02-04/08:30:14.105043 -05:00 | 2013-02-04/08:30:14.117790 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
32 | 2013-02-04/08:30:13.875775 -05:00 | 2013-02-04/08:30:14.100576 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
33 | 2013-01-25/13:20:11.593683 -05:00 | 2013-01-25/13:20:11.605838 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
34 | 2013-01-25/13:20:11.581945 -05:00 | 2013-01-25/13:20:11.591764 -05:00 | export_table_stats | QTUNE."PART" |
35 | 2013-01-25/13:20:11.570329 -05:00 | 2013-01-25/13:20:11.581023 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
36 | 2013-01-25/13:20:11.450504 -05:00 | 2013-01-25/13:20:11.569114 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
37 | 2013-01-25/13:10:54.790161 -05:00 | 2013-01-25/13:10:54.853434 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
38 | 2013-01-25/13:10:54.780153 -05:00 | 2013-01-25/13:10:54.789350 -05:00 | export_table_stats | QTUNE."PART" |
39 | 2013-01-25/13:10:54.768929 -05:00 | 2013-01-25/13:10:54.779261 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
40 | 2013-01-25/13:10:54.627590 -05:00 | 2013-01-25/13:10:54.739286 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
41 | 2013-01-25/04:49:07.849281 -05:00 | 2013-01-25/04:49:07.905418 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
42 | 2013-01-25/04:49:07.832432 -05:00 | 2013-01-25/04:49:07.848292 -05:00 | export_table_stats | QTUNE."PART" |
43 | 2013-01-25/04:49:07.755086 -05:00 | 2013-01-25/04:49:07.831416 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
44 | 2013-01-25/04:49:07.612581 -05:00 | 2013-01-25/04:49:07.753699 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
45 | 2013-01-25/03:37:02.453940 -05:00 | 2013-01-25/03:37:02.505718 -05:00 | export_table_stats | QTUNE."SALES_ORDER" |
46 | 2013-01-25/03:37:02.315897 -05:00 | 2013-01-25/03:37:02.452888 -05:00 | export_table_stats | QTUNE."PART" |
47 | 2013-01-25/03:37:02.172448 -05:00 | 2013-01-25/03:37:02.314858 -05:00 | export_table_stats | QTUNE."ORDER_LINE" |
48 | 2013-01-25/03:37:01.540468 -05:00 | 2013-01-25/03:37:02.171069 -05:00 | export_table_stats | QTUNE."CUSTOMER" |
49 | 2013-01-16/04:59:49.325720 -05:00 | 2013-01-16/04:59:49.371230 -05:00 | delete_system_stats | |
50 | 2013-01-15/09:47:19.884626 -05:00 | 2013-01-15/09:47:19.932191 -05:00 | delete_system_stats | |
51 | 2013-01-15/07:32:03.564744 -05:00 | 2013-01-15/07:32:03.707957 -05:00 | delete_system_stats | |
52 | 2013-01-14/08:15:32.926657 -05:00 | 2013-01-14/08:15:32.960903 -05:00 | delete_system_stats | |
53 | 2013-01-14/07:26:43.645082 -05:00 | 2013-01-14/07:26:43.647696 -05:00 | set_system_stats | |
54 | 2013-01-14/07:26:43.632399 -05:00 | 2013-01-14/07:26:43.635050 -05:00 | set_system_stats | |
55 | 2013-01-14/07:26:43.618574 -05:00 | 2013-01-14/07:26:43.621259 -05:00 | set_system_stats | |
56 | 2013-01-14/07:26:43.518763 -05:00 | 2013-01-14/07:26:43.607996 -05:00 | delete_system_stats |
# | Is Default1 | Is Modified2 | Name | Inst ID | Ordinal | Value | Display Value | Is Adjusted | Is Deprecated | Is Basic | Is Session Modifiable | Is System Modifiable | Is Instance Modifiable | Type | Description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | FALSE | SYSTEM_MOD | _cursor_bind_capture_interval | 1 | 1 | "900" | FALSE | FALSE | FALSE | FALSE | IMMEDIATE | TRUE | 3 | interval (in seconds) between two bind capture for a cursor | |
2 | FALSE | FALSE | audit_file_dest | 1 | 1 | "/u01/app/oracle/admin/V1123/adump" | FALSE | FALSE | FALSE | FALSE | DEFERRED | TRUE | 2 | Directory in which auditing files are to reside | |
3 | FALSE | FALSE | audit_trail | 1 | 1 | "DB" | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | 2 | enable system auditing | |
4 | FALSE | FALSE | compatible | 1 | 1 | "11.2.0.0.0" | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | 2 | Database will be completely compatible with this software version | |
5 | FALSE | FALSE | control_files | 1 | 1 | "/u01/app/oracle/oradata/V1123/ control01.ctl" | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | 2 | control file names list | |
6 | FALSE | FALSE | control_files | 1 | 2 | "/u01/app/oracle/fast_recovery_area/ V1123/control02.ctl" | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | 2 | control file names list | |
7 | FALSE | FALSE | db_block_size | 1 | 1 | "8192" | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | 3 | Size of database block in bytes | |
8 | FALSE | FALSE | db_name | 1 | 1 | "V1123" | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | 2 | database name specified in CREATE DATABASE | |
9 | FALSE | FALSE | db_recovery_file_dest | 1 | 1 | "/u01/app/oracle/fast_recovery_area" | FALSE | FALSE | TRUE | FALSE | IMMEDIATE | FALSE | 2 | default database recovery file location | |
10 | FALSE | FALSE | db_recovery_file_dest_size | 1 | 1 | "4322230272" | "4122M" | FALSE | FALSE | TRUE | FALSE | IMMEDIATE | FALSE | 6 | database recovery files size limit |
11 | FALSE | FALSE | diagnostic_dest | 1 | 1 | "/u01/app/oracle" | FALSE | FALSE | FALSE | FALSE | IMMEDIATE | TRUE | 2 | diagnostic base directory | |
12 | FALSE | FALSE | dispatchers | 1 | 1 | "(PROTOCOL=TCP) (SERVICE=V1123XDB)" | FALSE | FALSE | FALSE | FALSE | IMMEDIATE | TRUE | 2 | specifications of dispatchers | |
13 | FALSE | FALSE | open_cursors | 1 | 1 | "300" | FALSE | FALSE | TRUE | FALSE | IMMEDIATE | TRUE | 3 | max # cursors per session | |
14 | FALSE | FALSE | processes | 1 | 1 | "150" | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | 3 | user processes | |
15 | FALSE | FALSE | remote_login_passwordfile | 1 | 1 | "EXCLUSIVE" | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | 2 | password file usage parameter | |
16 | FALSE | FALSE | sga_target | 1 | 1 | "645922816" | "616M" | FALSE | FALSE | TRUE | FALSE | IMMEDIATE | TRUE | 6 | Target size of SGA |
17 | FALSE | FALSE | streams_pool_size | 1 | 1 | "41943040" | "40M" | FALSE | FALSE | FALSE | FALSE | IMMEDIATE | TRUE | 6 | size in bytes of the streams pool |
18 | FALSE | FALSE | undo_tablespace | 1 | 1 | "UNDOTBS1" | FALSE | FALSE | TRUE | FALSE | IMMEDIATE | TRUE | 2 | use/switch undo tablespace | |
19 | TRUE | MODIFIED | max_dump_file_size | 1 | 1 | "UNLIMITED" | FALSE | FALSE | FALSE | TRUE | IMMEDIATE | TRUE | 2 | Maximum size (in bytes) of dump file | |
20 | TRUE | MODIFIED | nls_date_format | 1 | 1 | "DD-MON-RR" | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | 2 | NLS Oracle date format | |
21 | TRUE | MODIFIED | nls_numeric_characters | 1 | 1 | ".," | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | 2 | NLS numeric characters | |
22 | TRUE | MODIFIED | nls_timestamp_format | 1 | 1 | "DD-MON-RR HH.MI.SSXFF AM" | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | 2 | time stamp format | |
23 | TRUE | MODIFIED | nls_timestamp_tz_format | 1 | 1 | "DD-MON-RR HH.MI.SSXFF AM TZR" | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | 2 | timestamp with timezone format | |
24 | TRUE | MODIFIED | timed_statistics | 1 | 1 | "TRUE" | FALSE | FALSE | FALSE | TRUE | IMMEDIATE | TRUE | 1 | maintain internal timing statistics | |
25 | TRUE | MODIFIED | tracefile_identifier | 1 | 1 | "S53241_SQLT_TRACE" | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | 2 | trace file custom identifier |
# | 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 |
# | Snapshot Time | Snap ID | Is Default1 | Is Modified2 | Parameter Name | Inst ID | Value |
---|---|---|---|---|---|---|---|
1 | 2013-02-04/11:00:06.236 | 6058 | FALSE | MODIFIED | _cursor_bind_capture_interval | 1 | "900" |
2 | 2013-02-04/11:00:06.236 | 6058 | FALSE | MODIFIED | _optimizer_use_feedback | 1 | "TRUE" |
3 | 2013-02-04/11:00:06.236 | 6058 | FALSE | MODIFIED | statistics_level | 1 | "ALL" |
4 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | __db_cache_size | 1 | "201326592" |
5 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | __java_pool_size | 1 | "4194304" |
6 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | __large_pool_size | 1 | "4194304" |
7 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | __oracle_base | 1 | "/u01/app/oracle" |
8 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | __pga_aggregate_target | 1 | "213909504" |
9 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | __sga_target | 1 | "645922816" |
10 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | __shared_io_pool_size | 1 | "" |
11 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | __shared_pool_size | 1 | "385875968" |
12 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | __streams_pool_size | 1 | "41943040" |
13 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | audit_file_dest | 1 | "/u01/app/oracle/admin/V1123/adump" |
14 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | audit_trail | 1 | "DB" |
15 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | compatible | 1 | "11.2.0.0.0" |
16 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | control_files | 1 | "/u01/app/oracle/oradata/V1123/ control01.ctl, /u01/app/oracle/fast_recovery_area/ V1123/control02.ctl" |
17 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | db_block_size | 1 | "8192" |
18 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | db_name | 1 | "V1123" |
19 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | db_recovery_file_dest | 1 | "/u01/app/oracle/fast_recovery_area" |
20 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | db_recovery_file_dest_size | 1 | "4322230272" |
21 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | diagnostic_dest | 1 | "/u01/app/oracle" |
22 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | dispatchers | 1 | "(PROTOCOL=TCP) (SERVICE=V1123XDB)" |
23 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | open_cursors | 1 | "300" |
24 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | pga_aggregate_target | 1 | "213909504" |
25 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | processes | 1 | "150" |
26 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | remote_login_passwordfile | 1 | "EXCLUSIVE" |
27 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | sga_target | 1 | "645922816" |
28 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | streams_pool_size | 1 | "41943040" |
29 | 2013-02-04/11:00:06.236 | 6058 | FALSE | FALSE | undo_tablespace | 1 | "UNDOTBS1" |
30 | 2013-02-04/11:00:06.236 | 6058 | TRUE | MODIFIED | _dml_frequency_tracking | 1 | "FALSE" |
# | Snapshot Time | Snap ID | Is Default1 | Is Modified2 | Parameter Name | Inst ID | Value |
31 | 2013-02-04/11:00:06.236 | 6058 | TRUE | MODIFIED | _dml_monitoring_enabled | 1 | "TRUE" |
32 | 2013-02-04/11:00:06.236 | 6058 | TRUE | MODIFIED | _pga_max_size | 1 | "1717985280" |
33 | 2013-02-04/11:00:06.236 | 6058 | TRUE | MODIFIED | optimizer_secure_view_merging | 1 | "TRUE" |
34 | 2013-02-04/11:00:06.236 | 6058 | TRUE | MODIFIED | parallel_threads_per_cpu | 1 | "" |
# | 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 |
# | 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 |
# | 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 |
status: | NOT AVAILABLE |
# | 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 |
# | Inst ID | Sharable Cursors |
Cursors not Shared |
Total |
---|---|---|---|---|
1 | 1 | 1 | 0 | 1 |
# | Inst ID | Child | Child Address | Plan Hash Value | Elapsed Time in secs |
CPU Time in secs |
User IO Time in secs |
Cluster Time in secs |
Concurrency Time in secs |
Application Time in secs |
Buffer Gets | Disk Reads | Direct Writes | Rows Processed | Executions | Plan Timestamp | Last Active Time | Avg Elapsed Time in secs |
Avg CPU Time in secs |
Avg User IO Time in secs |
Avg Cluster Time in secs |
Avg Concurrency Time in secs |
Avg Application Time in secs |
Avg Buffer Gets |
Avg Disk Reads |
Avg Direct Writes |
Avg Rows Processed |
Is Sharable |
Reasons for not Sharing | Reason |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 0 | 3F94442C | 2816325939 [B] [W] | 91.720 | 87.717 | 0.460 | 0.000 | 0.000 | 0.000 | 62498 | 44795 | 0 | 2766 | 3 | 2013-02-04/10:59:09 | 2013-02-04/11:00:41 | 30.573 | 29.239 | 0.153 | 0.000 | 0.000 | 0.000 | 20833 | 14932 | 0 | 922 | TRUE |
# | Is Sharable |
Inst ID | Child | Child Address | Plan Hash Value | Is Bind Sensitive |
Is Bind Aware |
Buffer Gets | Executions |
---|---|---|---|---|---|---|---|---|---|
1 | Y | 1 | 0 | 3F94442C | 2816325939 [B] [W] | Y | Y | 62498 | 3 |
# | Is Sharable |
Inst ID | Child | Bucket ID1 | Count |
---|---|---|---|---|---|
1 | Y | 1 | 0 | 0 | 0 |
2 | Y | 1 | 0 | 1 | 0 |
3 | Y | 1 | 0 | 2 | 3 |
# | Is Sharable |
Inst ID | Child | Predicate | Low | High | Range ID |
---|---|---|---|---|---|---|---|
1 | Y | 1 | 0 | =B1 | 0.010974 | 0.013413 | 0 |
# | Is Sharable |
Inst ID | Child | Bind Set Hash Value |
Peeked | Executions | Rows Processed | Buffer Gets | CPU Time |
---|---|---|---|---|---|---|---|---|---|
1 | Y | 1 | 0 | 4215520196 | Y | 1 | 20234000 | 21218 | 0 |
# | Plan Hash Value |
---|---|
1 | 2816325939 [B] [W] |
SELECT /*+ gather_plan_statistics monitor bind_aware */ /* sqlt_s53241 */ v.customer_name, v.orders_total, v.credit_limit, (orders_total - credit_limit) over_limit FROM customer_v v WHERE orders_total > credit_limit AND customer_type = :b1 ORDER BY over_limit DESC
Summary
SQL: [+]
|
Source: GV$SQL_PLAN
SQL: [+] Details: [+] |
Source: DBA_HIST_SQL_PLAN
SQL: [+] Details: [+] |
Source: DBA_SQLTUNE_PLANS
SQL: [+] Details: [+] |
# | Plan Hash Value |
---|---|
1 | 2816325939 [B] [W] |
SELECT /*+ gather_plan_statistics monitor bind_aware */ /* sqlt_s53241 */ v.customer_name, v.orders_total, v.credit_limit, (orders_total - credit_limit) over_limit FROM customer_v v WHERE orders_total > credit_limit AND customer_type = :b1 ORDER BY over_limit DESC
Summary
SQL: [+]
|
Source: GV$SQL_PLAN
SQL: [+] Details: [+] |
Source: DBA_HIST_SQL_PLAN
SQL: [+] Details: [+] |
# | Plan Hash Value1 | Avg Elapsed Time in secs | Avg CPU Time in secs | Avg User I/O Wait Time in secs | Avg Other Wait Time in secs2 | Avg Buffer Gets | Avg Disk Reads | Avg Direct Writes | Avg Rows Processed | Total Executions | Total Fetches | Total Version Count | Total Loads | Total Invalidations | Src | Source3 | Plan Info3 | Plan Stability3 | Is Bind Sensitive | Min Opt Env | Max Opt Env | Opt Cost | Estimated Cardinality | Estimated Time in secs | Plan Timestamp | First Load Time4 | Last Load Time4 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2816325939 [B] [W] | 30.573 | 29.239 | 0.153 | 0.000 | 20833 | 14932 | 0 | 922 | 3 | 189 | 1 | 1 | 0 | MEM | GV$SQLAREA_PLAN_HASH | Y | 1504581476 | 19528 | 154 | 234.336 | 2013-02-04/10:59:09 | 2013-02-04/10:59:09 | 2013-02-04/10:59:09 | |||
2 | 657302870 | XPL | EXPLAIN PLAN FOR | 21392 | 2102 | 256.704 | 2013-02-04/11:00:49 |
# | Plan Hash Value | Src | Source | Plan Info | Plan Stability | Is Bind Sensitive | Inst ID | Stats | Total Elapsed Time in secs | Total CPU Time in secs | Total User I/O Wait Time in secs | Total Other Wait Time in secs1 | Total Buffer Gets | Total Disk Reads | Total Direct Writes | Total Rows Processed | Total Executions | Total Fetches | Total Version Count | Total Loads | Total Invalidations | Opt Env Cnt | Min Opt Env | Max Opt Env | Cost | Plan Timestamp | First Load Time | Last Load Time |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2816325939 [B] [W] | MEM | GV$SQLAREA_PLAN_HASH | Y | 1 | Stats | 91.720 | 87.717 | 0.460 | 0.000 | 62498 | 44795 | 0 | 2766 | 3 | 189 | 1 | 1 | 0 | 1 | 1504581476 | 19528 | 2013-02-04/10:59:09 | 2013-02-04/10:59:09 | 2013-02-04/10:59:09 | |||
2 | 2816325939 [B] [W] | AWR | DBA_HIST_SQLSTAT | 1 | Stats | 68.225 | 65.864 | 0.356 | 0.000 | 51794 | 34276 | 0 | 1844 | 3 | 126 | 1 | 1 | 0 | 1 | 1504581476 | 19528 | 2013-02-04/10:59:09 | 2013-02-04/10:00:39 | 2013-02-04/11:00:06 |
|
|
# | Snap ID | Begin Time | End Time | Startup Time | Inst ID | Plan Hash Value | Opt Env Hash Value | Cost | Opt Mode | Vers Count | Sharable Mem | Loaded Versions | SQL Profile | Parsing Schema ID | Parsing Schema Name | Parsing User ID | Executions (delta) | Elapsed Time in secs (delta) | CPU Time in secs (delta) | I/O Wait Time in secs (delta) | Appl Wait Time in secs (delta) | Conc Wait Time in secs (delta) | Clust Wait Time in secs (delta) | PL/SQL Wait Time in secs (delta) | Java Wait Time in secs (delta) | Buffer Gets (delta) | Disk Reads (delta) | Direct Writes (delta) | Rows Processed (delta) | Parse Calls (delta) | Fetches (delta) | End of Fetch Count (delta) | PX Server Execs (delta) | Loads (delta) | Invalidations (delta) | Sorts (delta) | Physical Read Requests (delta) | Physical Read Bytes (delta) | Physical Write Requests (delta) | Physical Write Bytes (delta) | Optimizer Physical Reads (delta) | Cell Uncompressed Bytes (delta) | I/O Offload Elig Bytes (delta) | I/O Offload Return Bytes (delta) | I/O Interconnect Bytes (delta) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 6058 | 2013-02-04/10:00:39 | 2013-02-04/11:00:06 | 2013-01-03/08:23:56.000 | 1 | 2816325939 [B][W] | 1504581476 | 19528 | ALL_ROWS | 1 | 45234 | 1 | 92 | QTUNE | 92 | 3 | 68.225 | 65.864 | 0.356 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 51794 | 34276 | 0 | 1844 | 3 | 126 | 2 | 0 | 0 | 0 | 3 | 1096 | 280788992 | 0 | 0 | 0 | 0 | 0 | 0 | 280788992 |
# | Snap ID | Begin Time | End Time | Startup Time | Inst ID | Plan Hash Value | Opt Env Hash Value | Cost | Opt Mode | Vers Count | Sharable Mem | Loaded Versions | SQL Profile | Parsing Schema ID | Parsing Schema Name | Parsing User ID | Executions (total) | Elapsed Time in secs (total) | CPU Time in secs (total) | I/O Wait Time in secs (total) | Appl Wait Time in secs (total) | Conc Wait Time in secs (total) | Clust Wait Time in secs (total) | PL/SQL Wait Time in secs (total) | Java Wait Time in secs (total) | Buffer Gets (total) | Disk Reads (total) | Direct Writes (total) | Rows Processed (total) | Parse Calls (total) | Fetches (total) | End of Fetch Count (total) | PX Server Execs (total) | Loads (total) | Invalidations (total) | Sorts (total) | Physical Read Requests (total) | Physical Read Bytes (total) | Physical Write Requests (total) | Physical Write Bytes (total) | Optimizer Physical Reads (total) | Cell Uncompressed Bytes (total) | I/O Offload Elig Bytes (total) | I/O Offload Return Bytes (total) | I/O Interconnect Bytes (total) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 6058 | 2013-02-04/10:00:39 | 2013-02-04/11:00:06 | 2013-01-03/08:23:56.000 | 1 | 2816325939 [B][W] | 1504581476 | 19528 | ALL_ROWS | 1 | 45234 | 1 | 92 | QTUNE | 92 | 3 | 68.225 | 65.864 | 0.356 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 51794 | 34276 | 0 | 1844 | 3 | 126 | 2 | 0 | 1 | 0 | 3 | 1096 | 280788992 | 0 | 0 | 0 | 0 | 0 | 0 | 280788992 |
# | Plan Hash Value | SQLT Plan Hash Value1 |
SQLT Plan Hash Value21 |
Src | Source | Plan Info | Plan Stability | Is Bind Sensitive |
Optimizer | Optimizer Cost |
Estimated Cardinality E-Rows |
Rows Processed A-Rows |
Plan Timestamp | Child Plans2 |
Plan ID | Task ID | Attribute |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 657302870 | 92811 | 38096 | XPL | PLAN_TABLE | ALL_ROWS | 21392 | 2102 | 2013-02-04/11:00:49 | 1162 | |||||||
2 | 2816325939 [B] [W] | 25354 | 56337 | MEM | GV$SQL_PLAN | Y | ALL_ROWS | 19528 | 154 | 922 | 2013-02-04/10:59:09 | 1 | |||||
3 | 2816325939 [B] [W] | 25354 | 25354 | AWR | DBA_HIST_SQL_PLAN | ALL_ROWS | 19528 | 154 | 615 | 2013-02-04/10:59:09 | |||||||
4 | 2816325939 [B] [W] | 25354 | 70639 | STA | DBA_SQLTUNE_PLANS | ALL_ROWS | 19528 | 154 | 2013-02-04/11:13:30 | 31365 | 7120 | Original |
SELECT /*+ gather_plan_statistics monitor bind_aware */ /* sqlt_s53241 */ v.customer_name, v.orders_total, v.credit_limit, (orders_total - credit_limit) over_limit FROM customer_v v WHERE orders_total > credit_limit AND customer_type = :b1 ORDER BY over_limit DESC
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 |
# | Type | Value |
---|---|---|
1 | db_version | 11.2.0.3 |
2 | parse_schema | "QTUNE" |
3 | plan_hash | 657302870 |
SELECT /*+ gather_plan_statistics monitor bind_aware */ /* sqlt_s53241 */ v.customer_name, v.orders_total, v.credit_limit, (orders_total - credit_limit) over_limit FROM customer_v v WHERE orders_total > credit_limit AND customer_type = :b1 ORDER BY over_limit DESC
ID | Exec Ord | Operation | Go To | More | Peek Bind | Capt Bind | Cost2 | Estim Card | LAST Starts |
LAST Output Rows |
LAST Over/Under Estimate1 |
LAST CR Buffer Gets2 |
LAST CU Buffer Gets2 |
LAST Disk Reads2 |
LAST Elapsed Time in secs2 |
ALL Starts |
ALL Output Rows |
ALL Over/Under Estimate1 |
ALL CR Buffer Gets2 |
ALL CU Buffer Gets2 |
ALL Disk Reads2 |
ALL Elapsed Time in secs2 |
Work Area |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 15 | SELECT STATEMENT | 19528 | 154 | 1 | 922 | 6x under | ||||||||||||||||
1 | 14 | SORT ORDER BY | [+] | 19528 | 154 | 1 | 922 | 6x under | 20639 | 1 | 14843 | 31.320 | 3 | 2766 | 6x under | 61917 | 3 | 44786 | 91.210 | [+] | |||
2 | 13 | . FILTER | [+] | 19528 | 1 | 922 | 20639 | 1 | 14843 | 31.318 | 3 | 2766 | 61917 | 3 | 44786 | 91.201 | |||||||
3 | 12 | .. HASH GROUP BY | [+] | 19528 | 154 | 1 | 1176 | 8x under | 20639 | 1 | 14843 | 31.316 | 3 | 3528 | 8x under | 61917 | 3 | 44786 | 91.195 | [+] | |||
4 | 11 | ... HASH JOIN | [+] | 19526 | 3587 | 1 | 3484 | 1x | 20639 | 1 | 14843 | 31.308 | 3 | 10452 | 1x | 61917 | 3 | 44786 | 91.170 | [+] | |||
5 | 5 | .... NESTED LOOPS | [+] | 688 | 3587 | 1 | 3484 | 1x | 5931 | 0 | 288 | 1.299 | 3 | 10452 | 1x | 17793 | 0 | 973 | 3.730 | ||||
6 | 3 | ....+ HASH JOIN | [+] | 687 | 3587 | 1 | 3484 | 1x | 2445 | 0 | 288 | 1.262 | 3 | 10452 | 1x | 7335 | 0 | 764 | 3.596 | [+] | |||
7 | 1 | ....+. TABLE ACCESS FULL CUSTOMER | [+] | [+] | [+] | [+] | 220 | 1219 | 1 | 1239 | 1x | 784 | 0 | 0 | 0.008 | 3 | 3717 | 1x | 2352 | 0 | 3 | 0.028 | |
8 | 2 | ....+. TABLE ACCESS FULL SALES_ORDER | [+] | [+] | 465 | 282210 | 1 | 281792 | 1x | 1661 | 0 | 288 | 0.384 | 3 | 845376 | 1x | 4983 | 0 | 761 | 1.018 | |||
9 | 4 | ....+ INDEX UNIQUE SCAN CUSTOMER_PK | [+] | [+] | 0 | 1 | 3484 | 3484 | 1x | 3486 | 0 | 0 | 0.020 | 10452 | 10452 | 1x | 10458 | 0 | 209 | 0.082 | |||
10 | 10 | .... VIEW | [+] | 18836 | 302976 | 1 | 299998 | 1x | 14708 | 1 | 14555 | 29.164 | 3 | 899994 | 1x | 44124 | 3 | 43813 | 84.856 | ||||
11 | 9 | ....+ HASH GROUP BY | [+] | 18836 | 302976 | 1 | 299998 | 1x | 14708 | 1 | 14555 | 28.617 | 3 | 899994 | 1x | 44124 | 3 | 43813 | 83.161 | [+] | |||
12 | 8 | ....+. HASH JOIN | [+] | 8648 | 3416582 | 1 | 3450201 | 1x | 14708 | 1 | 14555 | 20.172 | 3 | 10350603 | 1x | 44124 | 3 | 43813 | 58.452 | [+] | |||
13 | 6 | ....+.. TABLE ACCESS FULL PART | [+] | [+] | 392 | 200000 | 1 | 200000 | 1x | 1400 | 0 | 1398 | 0.230 | 3 | 600000 | 1x | 4200 | 0 | 4195 | 0.697 | |||
14 | 7 | ....+.. TABLE ACCESS FULL ORDER_LINE | [+] | [+] | 3609 | 3450201 | 1 | 3450201 | 1x | 13308 | 1 | 13157 | 3.897 | 3 | 10350603 | 1x | 39924 | 3 | 39618 | 11.199 |
# | Type | Value |
---|---|---|
1 | db_version | 11.2.0.3 |
2 | parse_schema | "QTUNE" |
3 | plan_hash | 2816325939 |
# | Name | Type | Value |
---|---|---|---|
1 | :B1 | VARCHAR2(32) | "4" |
# | Last Captured | Name | Type | Value |
---|---|---|---|---|
1 | 2013-02-04/10:59:10 | :B1 | VARCHAR2(32) | "4" |
# | Name | Value |
---|---|---|
1 | parallel_threads_per_cpu | 1 |
2 | _pga_max_size | 1717985280 |
3 | sqlstat_enabled | true |
4 | statistics_level | all |
5 | parallel_max_degree | 2 |
SELECT /*+ gather_plan_statistics monitor bind_aware */ /* sqlt_s53241 */ v.customer_name, v.orders_total, v.credit_limit, (orders_total - credit_limit) over_limit FROM customer_v v WHERE orders_total > credit_limit AND customer_type = :b1 ORDER BY over_limit DESC
ID | Exec Ord | Operation | Go To | More | Cost2 | Estim Card |
---|---|---|---|---|---|---|
0 | 15 | SELECT STATEMENT | 19528 | 154 | ||
1 | 14 | SORT ORDER BY | 19528 | 154 | ||
2 | 13 | . FILTER | 19528 | |||
3 | 12 | .. HASH GROUP BY | 19528 | 154 | ||
4 | 11 | ... HASH JOIN | 19526 | 3587 | ||
5 | 5 | .... NESTED LOOPS | 688 | 3587 | ||
6 | 3 | ....+ HASH JOIN | 687 | 3587 | ||
7 | 1 | ....+. TABLE ACCESS FULL CUSTOMER | [+] | 220 | 1219 | |
8 | 2 | ....+. TABLE ACCESS FULL SALES_ORDER | [+] | 465 | 282210 | |
9 | 4 | ....+ INDEX UNIQUE SCAN CUSTOMER_PK | [+] | [+] | 0 | 1 |
10 | 10 | .... VIEW | 18836 | 302976 | ||
11 | 9 | ....+ HASH GROUP BY | [+] | 18836 | 302976 | |
12 | 8 | ....+. HASH JOIN | [+] | 8648 | 3416582 | |
13 | 6 | ....+.. TABLE ACCESS FULL PART | [+] | 392 | 200000 | |
14 | 7 | ....+.. TABLE ACCESS FULL ORDER_LINE | [+] | 3609 | 3450201 |
# | Type | Value |
---|---|---|
1 | db_version | 11.2.0.3 |
2 | parse_schema | "QTUNE" |
3 | plan_hash | 2816325939 |
# | Name | Type | Value |
---|---|---|---|
1 | :B1 | VARCHAR2(32) | "4" |
# | Last Captured | Name | Type | Value |
---|---|---|---|---|
1 | 2013-02-04/10:59:10 | :B1 | VARCHAR2(32) | "4" |
SELECT /*+ gather_plan_statistics monitor bind_aware */ /* sqlt_s53241 */ v.customer_name, v.orders_total, v.credit_limit, (orders_total - credit_limit) over_limit FROM customer_v v WHERE orders_total > credit_limit AND customer_type = :b1 ORDER BY over_limit DESC
ID | Exec Ord | Operation | Go To | More | Peek Bind | Cost2 | Estim Card |
---|---|---|---|---|---|---|---|
0 | 15 | SELECT STATEMENT | 19528 | 154 | |||
1 | 14 | SORT ORDER BY | [+] | 19528 | 154 | ||
2 | 13 | . FILTER | [+] | 19528 | |||
3 | 12 | .. HASH GROUP BY | [+] | 19528 | 154 | ||
4 | 11 | ... HASH JOIN | [+] | 19526 | 3587 | ||
5 | 5 | .... NESTED LOOPS | [+] | 688 | 3587 | ||
6 | 3 | ....+ HASH JOIN | [+] | 687 | 3587 | ||
7 | 1 | ....+. TABLE ACCESS FULL CUSTOMER | [+] | [+] | [+] | 220 | 1219 |
8 | 2 | ....+. TABLE ACCESS FULL SALES_ORDER | [+] | [+] | 465 | 282210 | |
9 | 4 | ....+ INDEX UNIQUE SCAN CUSTOMER_PK | [+] | [+] | 0 | 1 | |
10 | 10 | .... VIEW | [+] | 18836 | 302976 | ||
11 | 9 | ....+ HASH GROUP BY | [+] | 18836 | 302976 | ||
12 | 8 | ....+. HASH JOIN | [+] | 8648 | 3416582 | ||
13 | 6 | ....+.. TABLE ACCESS FULL PART | [+] | [+] | 392 | 200000 | |
14 | 7 | ....+.. TABLE ACCESS FULL ORDER_LINE | [+] | [+] | 3609 | 3450201 |
# | Type | Value |
---|---|---|
1 | db_version | 11.2.0.3 |
2 | parse_schema | "QTUNE" |
3 | plan_hash | 2816325939 |
# | Name | Type | Value |
---|---|---|---|
1 | :B1 | VARCHAR2(32) | "4" |
# | Plan Hash Value |
Session State |
Wait Class |
Event | Snaps Count |
---|---|---|---|---|---|
1 | 2816325939 | ON CPU | 92 |
# | Plan Hash Value |
Plan Line ID |
Plan Operation |
Plan Options |
Plan Object Owner |
Plan Object Name |
Session State |
Wait Class |
Event | Curr Obj ID |
Curr Object Name |
Snaps Count |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2816325939 | 4 | HASH JOIN | ON CPU | 4 | |||||||
2 | 2816325939 | 6 | HASH JOIN | ON CPU | 3 | |||||||
3 | 2816325939 | 10 | VIEW | ON CPU | 1 | |||||||
4 | 2816325939 | 11 | HASH | GROUP BY | ON CPU | 39 | ||||||
5 | 2816325939 | 12 | HASH JOIN | ON CPU | 40 | |||||||
6 | 2816325939 | 12 | HASH JOIN | ON CPU | 3 |
# | Inst ID | SID | Serial# | Sample Time | SQL Exec Start | Is SQL_ID Current | SQL Child Num | Force Matching Signature | SQL Plan Hash Value | SQL Plan Line ID | SQL Plan Operation | SQL Plan Options | Event | P1 Text | P1 | P2 Text | P2 | P3 Text | P3 | Wait Class | Wait Time | Session State | Time Waited | Blocking Session Status | Blocking SID | Blocking Serial# | Blocking Inst ID | Blocking Hang Chain Info | Current Obj# | Current File# | Current Block# | Current Row# | Remote Inst# | Program | Module | Action | Client ID | Machine | TM Delta Time | TM Delta CPU Time | TM Delta DB Time | Delta Time | Delta Read I/O Requests | Delta Write I/O Requests | Delta Read I/O Bytes | Delta Write I/O Bytes | Delta Inter Connect I/O Bytes | PGA Allocated | Temp Space Allocated |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 142 | 39231 | 2013-02-04/11:00:41.728 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 10 | VIEW | file number | 4 | first dba | 120768 | block cnt | 64 | 355 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 120831 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 1001500 | 0 | 0 | 0 | 0 | 0 | 33996800 | 2097152 | ||||||||||||
2 | 1 | 142 | 39231 | 2013-02-04/11:00:40.728 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 4 | HASH JOIN | file number | 4 | first dba | 120768 | block cnt | 64 | 355 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 120831 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 1998981 | 1972123 | 1998981 | 1000257 | 3 | 0 | 1572864 | 0 | 1572864 | 36880384 | 2097152 | |||||||||
3 | 1 | 142 | 39231 | 2013-02-04/11:00:39.728 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 120576 | block cnt | 64 | 358 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 120560 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 1000236 | 12 | 0 | 6291456 | 0 | 6291456 | 44285952 | 2097152 | |||||||||||
4 | 1 | 142 | 39231 | 2013-02-04/11:00:38.728 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 12 | HASH JOIN | file number | 4 | first dba | 119872 | block cnt | 64 | 775 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 119813 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 2000883 | 1984124 | 2000883 | 1010270 | 8 | 0 | 4161536 | 0 | 4161536 | 44285952 | 2097152 | |||||||||
5 | 1 | 142 | 39231 | 2013-02-04/11:00:37.718 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 12 | HASH JOIN | file number | 4 | first dba | 119296 | block cnt | 64 | 790 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 119288 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 1000241 | 8 | 0 | 4194304 | 0 | 4194304 | 44285952 | 2097152 | ||||||||||||
6 | 1 | 142 | 39231 | 2013-02-04/11:00:36.718 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 12 | HASH JOIN | file number | 4 | first dba | 118788 | block cnt | 60 | 660 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 118766 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 2012942 | 1744109 | 2012942 | 999793 | 8 | 0 | 4161536 | 0 | 4161536 | 44285952 | 2097152 | |||||||||
7 | 1 | 142 | 39231 | 2013-02-04/11:00:35.718 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 118336 | block cnt | 64 | 792 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 118290 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 1002573 | 6 | 0 | 3145728 | 0 | 3145728 | 44285952 | 2097152 | |||||||||||
8 | 1 | 142 | 39231 | 2013-02-04/11:00:34.718 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 117888 | block cnt | 64 | 800 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 117851 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 2008182 | 1856116 | 2008182 | 1008869 | 9 | 0 | 4685824 | 0 | 4685824 | 44285952 | 2097152 | ||||||||
9 | 1 | 142 | 39231 | 2013-02-04/11:00:33.708 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 117376 | block cnt | 64 | 791 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 117369 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 999232 | 6 | 0 | 3145728 | 0 | 3145728 | 44285952 | 2097152 | |||||||||||
10 | 1 | 142 | 39231 | 2013-02-04/11:00:32.708 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 116928 | block cnt | 64 | 792 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 116887 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 2011387 | 1732108 | 2011387 | 999634 | 8 | 0 | 4161536 | 0 | 4161536 | 44285952 | 2097152 | ||||||||
11 | 1 | 142 | 39231 | 2013-02-04/11:00:31.708 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 12 | HASH JOIN | file number | 4 | first dba | 111488 | block cnt | 64 | 480 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 111424 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 1003351 | 6 | 0 | 3145728 | 0 | 3145728 | 44285952 | 2097152 | ||||||||||||
12 | 1 | 142 | 39231 | 2013-02-04/11:00:30.708 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 111040 | block cnt | 64 | 775 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 110995 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 2006579 | 1824115 | 2006579 | 999759 | 8 | 0 | 4153344 | 0 | 4153344 | 44285952 | 2097152 | ||||||||
13 | 1 | 142 | 39231 | 2013-02-04/11:00:29.708 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 110528 | block cnt | 64 | 502 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 110524 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 1012331 | 8 | 0 | 4128768 | 0 | 4128768 | 44285952 | 2097152 | |||||||||||
14 | 1 | 142 | 39231 | 2013-02-04/11:00:28.688 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 12 | HASH JOIN | file number | 4 | first dba | 110082 | block cnt | 62 | 763 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 110032 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 2008859 | 1908119 | 2008859 | 999210 | 8 | 0 | 4128768 | 0 | 4128768 | 44285952 | 2097152 | |||||||||
15 | 1 | 142 | 39231 | 2013-02-04/11:00:27.688 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 109570 | block cnt | 62 | 667 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 109548 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 1003189 | 8 | 0 | 4128768 | 0 | 4128768 | 44285952 | 2097152 | |||||||||||
16 | 1 | 142 | 39231 | 2013-02-04/11:00:26.688 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 12 | HASH JOIN | file number | 4 | first dba | 109058 | block cnt | 62 | 302 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 109039 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 2001261 | 1984123 | 2001261 | 1000114 | 8 | 0 | 4128768 | 0 | 4128768 | 44285952 | 2097152 | |||||||||
17 | 1 | 142 | 39231 | 2013-02-04/11:00:25.688 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 12 | HASH JOIN | file number | 4 | first dba | 108546 | block cnt | 62 | 292 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 108510 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 1000139 | 8 | 0 | 4128768 | 0 | 4128768 | 44285952 | 2097152 | ||||||||||||
18 | 1 | 142 | 39231 | 2013-02-04/11:00:24.688 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 12 | HASH JOIN | file number | 4 | first dba | 108034 | block cnt | 62 | 320 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 107984 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 2004493 | 1920121 | 2004493 | 1000155 | 8 | 0 | 4128768 | 0 | 4128768 | 44285952 | 2097152 | |||||||||
19 | 1 | 142 | 39231 | 2013-02-04/11:00:23.688 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 107522 | block cnt | 62 | 292 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 107456 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 1010143 | 8 | 0 | 4128768 | 0 | 4128768 | 44023808 | 2097152 | |||||||||||
20 | 1 | 142 | 39231 | 2013-02-04/11:00:22.678 | 2013-02-04/11:00:10 | Y | 0 | 17810495099954579021 | 2816325939 | 12 | HASH JOIN | file number | 4 | first dba | 106944 | block cnt | 64 | 1120 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 106941 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 2014788 | 1828114 | 2014788 | 1005538 | 8 | 0 | 4128768 | 0 | 4128768 | 43237376 | 2097152 |
# | Plan Hash Value |
Session State |
Wait Class |
Event | Snaps Count |
---|---|---|---|---|---|
1 | 2816325939 | ON CPU | 4 |
# | Plan Hash Value |
Plan Line ID |
Plan Operation |
Plan Options |
Plan Object Owner |
Plan Object Name |
Session State |
Wait Class |
Event | Curr Obj ID |
Curr Object Name |
Snaps Count |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2816325939 | 11 | HASH | GROUP BY | ON CPU | 3 | ||||||
2 | 2816325939 | 12 | HASH JOIN | ON CPU | 1 |
# | Inst ID | SID | Serial# | Sample Time | SQL Exec Start | Is SQL_ID Current | SQL Child Num | Force Matching Signature | SQL Plan Hash Value | SQL Plan Line ID | SQL Plan Operation | SQL Plan Options | Event | P1 Text | P1 | P2 Text | P2 | P3 Text | P3 | Wait Class | Wait Time | Session State | Time Waited | Blocking Session Status | Blocking SID | Blocking Serial# | Blocking Inst ID | Blocking Hang Chain Info | Current Obj# | Current File# | Current Block# | Current Row# | Remote Inst# | Program | Module | Action | Client ID | Machine | TM Delta Time | TM Delta CPU Time | TM Delta DB Time | Delta Time | Delta Read I/O Requests | Delta Write I/O Requests | Delta Read I/O Bytes | Delta Write I/O Bytes | Delta Inter Connect I/O Bytes | PGA Allocated | Temp Space Allocated |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 142 | 39231 | 2013-02-04/10:59:47.598 | 2013-02-04/10:59:40 | Y | 0 | 17810495099954579021 | 2816325939 | 12 | HASH JOIN | file number | 4 | first dba | 104962 | block cnt | 62 | 357 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 104930 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 9012968 | 1460499265 | 84398340758391018 | 10010742 | 188 | 41517056 | 41517056 | 37994496 | 2097152 | |||||||||||
2 | 1 | 142 | 39231 | 2013-02-04/10:59:37.588 | 2013-02-04/10:59:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 119936 | block cnt | 64 | 807 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 119928 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 10002866 | 13822583253855860492 | 13873223069183266797 | 9997975 | 79 | 41164800 | 41164800 | 41467904 | 2097152 | ||||||||||
3 | 1 | 142 | 39231 | 2013-02-04/10:59:27.597 | 2013-02-04/10:59:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 109888 | block cnt | 64 | 463 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 109842 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 10011444 | 1461779345 | 84398340759405364 | 10012555 | 98 | 41951232 | 41951232 | 42516480 | 2097152 | ||||||||||
4 | 1 | 142 | 39231 | 2013-02-04/10:59:17.577 | 2013-02-04/10:59:10 | Y | 0 | 17810495099954579021 | 2816325939 | 11 | HASH | GROUP BY | file number | 4 | first dba | 104706 | block cnt | 62 | 324 | ON CPU | 0 | NOT IN WAIT | 107094 | 4 | 104715 | 0 | sqlplus@host01.example.com (TNS V1-V3) | sqltxadmin.sqlt$a (xecute) | 53241 44707 ALTER SESSION SET EV | host01.example.com | 10994459 | 587567916 | 33759336308656997 | 10007348 | 442 | 32497664 | 32497664 | 38322176 | 2097152 |
# | Plan Hash Value | Child Cursors |
---|---|---|
1 | 2816325939 [B] [W] | 1 |
|
# | Plan Hash Value | Monitored Executions |
---|---|---|
1 | 2816325939 [B] [W] | 3 |
|
|
|
# | Value | Statistic Name | Object Name | Suboject Name | Owner | Object Type | Inst ID | TableSpace Name | Obj# | Data Obj# |
---|---|---|---|---|---|---|---|---|---|---|
1 | 34649488 | logical reads | PART_PK | QTUNE | INDEX | 1 | USERS | 107088 | 107088 | |
2 | 178956 | physical reads direct | SALES_ORDER | QTUNE | TABLE | 1 | USERS | 107090 | 107090 | |
3 | 94850 | physical reads | ORDER_LINE_PK | QTUNE | INDEX | 1 | USERS | 107095 | 107095 | |
4 | 75580 | physical reads direct | ORDER_LINE_PK | QTUNE | INDEX | 1 | USERS | 107095 | 107095 | |
5 | 63872 | logical reads | ORDER_LINE_PK | QTUNE | INDEX | 1 | USERS | 107095 | 107095 | |
6 | 53040 | physical reads direct | CUSTOMER | QTUNE | TABLE | 1 | USERS | 107082 | 107082 | |
7 | 50768 | logical reads | ORDER_LINE_N1 | QTUNE | INDEX | 1 | USERS | 107096 | 107096 | |
8 | 39920 | logical reads | ORDER_LINE | QTUNE | TABLE | 1 | USERS | 107094 | 107094 | |
9 | 39618 | physical reads | ORDER_LINE | QTUNE | TABLE | 1 | USERS | 107094 | 107094 | |
10 | 39471 | physical reads direct | ORDER_LINE | QTUNE | TABLE | 1 | USERS | 107094 | 107094 | |
11 | 28352 | logical reads | SALES_ORDER_PK | QTUNE | INDEX | 1 | USERS | 107091 | 107091 | |
12 | 24128 | logical reads | SALES_ORDER_N2 | QTUNE | INDEX | 1 | USERS | 107093 | 107093 | |
13 | 22878 | physical reads | SALES_ORDER_PK | QTUNE | INDEX | 1 | USERS | 107091 | 107091 | |
14 | 20586 | physical reads | ORDER_LINE_N2 | QTUNE | INDEX | 1 | USERS | 107097 | 107097 | |
15 | 19257 | physical reads | ORDER_LINE_N1 | QTUNE | INDEX | 1 | USERS | 107096 | 107096 | |
16 | 19136 | logical reads | ORDER_LINE_N2 | QTUNE | INDEX | 1 | USERS | 107097 | 107097 | |
17 | 13574 | physical read requests | ORDER_LINE_N2 | QTUNE | INDEX | 1 | USERS | 107097 | 107097 | |
18 | 12883 | physical reads | SALES_ORDER_N2 | QTUNE | INDEX | 1 | USERS | 107093 | 107093 | |
19 | 12828 | physical read requests | ORDER_LINE_N1 | QTUNE | INDEX | 1 | USERS | 107096 | 107096 | |
20 | 11760 | logical reads | SALES_ORDER_N1 | QTUNE | INDEX | 1 | USERS | 107092 | 107092 | |
21 | 10464 | logical reads | CUSTOMER_PK | QTUNE | INDEX | 1 | USERS | 107083 | 107083 | |
22 | 10157 | physical read requests | SALES_ORDER_PK | QTUNE | INDEX | 1 | USERS | 107091 | 107091 | |
23 | 10074 | physical read requests | ORDER_LINE_PK | QTUNE | INDEX | 1 | USERS | 107095 | 107095 | |
24 | 7593 | physical reads | PART_PK | QTUNE | INDEX | 1 | USERS | 107088 | 107088 | |
25 | 6764 | physical read requests | PART_PK | QTUNE | INDEX | 1 | USERS | 107088 | 107088 | |
26 | 6480 | logical reads | CUSTOMER_N2 | QTUNE | INDEX | 1 | USERS | 107085 | 107085 | |
27 | 6270 | physical reads direct | SALES_ORDER_PK | QTUNE | INDEX | 1 | USERS | 107091 | 107091 | |
28 | 5977 | physical read requests | SALES_ORDER_N2 | QTUNE | INDEX | 1 | USERS | 107093 | 107093 | |
29 | 4992 | logical reads | SALES_ORDER | QTUNE | TABLE | 1 | USERS | 107090 | 107090 | |
30 | 4221 | physical reads | CUSTOMER_N2 | QTUNE | INDEX | 1 | USERS | 107085 | 107085 | |
# | Value | Statistic Name | Object Name | Suboject Name | Owner | Object Type | Inst ID | TableSpace Name | Obj# | Data Obj# |
31 | 4195 | physical reads | PART | QTUNE | TABLE | 1 | USERS | 107087 | 107087 | |
32 | 4194 | physical reads direct | PART | QTUNE | TABLE | 1 | USERS | 107087 | 107087 | |
33 | 4192 | logical reads | PART | QTUNE | TABLE | 1 | USERS | 107087 | 107087 | |
34 | 2640 | logical reads | PART_N1 | QTUNE | INDEX | 1 | USERS | 107089 | 107089 | |
35 | 2566 | physical read requests | CUSTOMER_N2 | QTUNE | INDEX | 1 | USERS | 107085 | 107085 | |
36 | 2352 | logical reads | CUSTOMER | QTUNE | TABLE | 1 | USERS | 107082 | 107082 | |
37 | 846 | physical read requests | PART_N1 | QTUNE | INDEX | 1 | USERS | 107089 | 107089 | |
38 | 846 | physical reads | PART_N1 | QTUNE | INDEX | 1 | USERS | 107089 | 107089 | |
39 | 834 | physical read requests | CUSTOMER_N1 | QTUNE | INDEX | 1 | USERS | 107084 | 107084 | |
40 | 834 | physical reads | CUSTOMER_N1 | QTUNE | INDEX | 1 | USERS | 107084 | 107084 | |
41 | 792 | physical read requests | ORDER_LINE | QTUNE | TABLE | 1 | USERS | 107094 | 107094 | |
42 | 761 | physical reads | SALES_ORDER | QTUNE | TABLE | 1 | USERS | 107090 | 107090 | |
43 | 209 | physical read requests | CUSTOMER_PK | QTUNE | INDEX | 1 | USERS | 107083 | 107083 | |
44 | 209 | physical reads | CUSTOMER_PK | QTUNE | INDEX | 1 | USERS | 107083 | 107083 | |
45 | 158 | physical read requests | SALES_ORDER | QTUNE | TABLE | 1 | USERS | 107090 | 107090 | |
46 | 91 | physical read requests | PART | QTUNE | TABLE | 1 | USERS | 107087 | 107087 | |
47 | 45 | segment scans | CUSTOMER_N2 | QTUNE | INDEX | 1 | USERS | 107085 | 107085 | |
48 | 29 | segment scans | SALES_ORDER_N2 | QTUNE | INDEX | 1 | USERS | 107093 | 107093 | |
49 | 18 | segment scans | CUSTOMER_PK | QTUNE | INDEX | 1 | USERS | 107083 | 107083 | |
50 | 18 | segment scans | PART_PK | QTUNE | INDEX | 1 | USERS | 107088 | 107088 | |
51 | 18 | segment scans | SALES_ORDER_PK | QTUNE | INDEX | 1 | USERS | 107091 | 107091 | |
52 | 13 | segment scans | ORDER_LINE_N1 | QTUNE | INDEX | 1 | USERS | 107096 | 107096 | |
53 | 13 | segment scans | ORDER_LINE_N2 | QTUNE | INDEX | 1 | USERS | 107097 | 107097 | |
54 | 7 | segment scans | ORDER_LINE_PK | QTUNE | INDEX | 1 | USERS | 107095 | 107095 | |
55 | 6 | physical read requests | SALES_ORDER_N1 | QTUNE | INDEX | 1 | USERS | 107092 | 107092 | |
56 | 6 | physical reads | SALES_ORDER_N1 | QTUNE | INDEX | 1 | USERS | 107092 | 107092 | |
57 | 3 | physical read requests | CUSTOMER | QTUNE | TABLE | 1 | USERS | 107082 | 107082 | |
58 | 3 | physical reads | CUSTOMER | QTUNE | TABLE | 1 | USERS | 107082 | 107082 | |
59 | 3 | segment scans | ORDER_LINE | QTUNE | TABLE | 1 | USERS | 107094 | 107094 | |
60 | 1 | segment scans | CUSTOMER | QTUNE | TABLE | 1 | USERS | 107082 | 107082 | |
# | Value | Statistic Name | Object Name | Suboject Name | Owner | Object Type | Inst ID | TableSpace Name | Obj# | Data Obj# |
61 | 1 | segment scans | PART | QTUNE | TABLE | 1 | USERS | 107087 | 107087 | |
62 | 1 | segment scans | SALES_ORDER | QTUNE | TABLE | 1 | USERS | 107090 | 107090 |
# | Class Name | Statistic Name | Value | Inst ID |
---|---|---|---|---|
1 | Cache | Number of read IOs issued | 735 | 1 |
2 | Cache | commit cleanout failures: callback failure | 2 | 1 |
3 | Cache | commit cleanouts | 69 | 1 |
4 | Cache | commit cleanouts successfully completed | 67 | 1 |
5 | Cache | consistent gets | 62757 | 1 |
6 | Cache | consistent gets - examination | 10797 | 1 |
7 | Cache | consistent gets direct | 43665 | 1 |
8 | Cache | consistent gets from cache | 19092 | 1 |
9 | Cache | consistent gets from cache (fastpath) | 8110 | 1 |
10 | Cache | db block changes | 138 | 1 |
11 | Cache | db block gets | 155 | 1 |
12 | Cache | db block gets from cache | 155 | 1 |
13 | Cache | db block gets from cache (fastpath) | 36 | 1 |
14 | Cache | dirty buffers inspected | 69 | 1 |
15 | Cache | free buffer inspected | 1885 | 1 |
16 | Cache | free buffer requested | 1154 | 1 |
17 | Cache | hot buffers moved to head of LRU | 2038 | 1 |
18 | Cache | logical read bytes from cache | 157671424 | 1 |
19 | Cache | physical read IO requests | 1271 | 1 |
20 | Cache | physical read bytes | 367034368 | 1 |
21 | Cache | physical read total IO requests | 1271 | 1 |
22 | Cache | physical read total bytes | 367034368 | 1 |
23 | Cache | physical read total multi block requests | 687 | 1 |
24 | Cache | physical reads | 44804 | 1 |
25 | Cache | physical reads cache | 1139 | 1 |
26 | Cache | physical reads cache prefetch | 745 | 1 |
27 | Cache | physical reads direct | 43665 | 1 |
28 | Cache | shared hash latch upgrades - no wait | 216 | 1 |
29 | Cache | switch current to new buffer | 1 | 1 |
30 | Cache, SQL | buffer is not pinned count | 674 | 1 |
# | Class Name | Statistic Name | Value | Inst ID |
31 | Cache, SQL | buffer is pinned count | 10517 | 1 |
32 | Debug | CPU used when call started | 9860 | 1 |
33 | Debug | Commit SCN cached | 1 | 1 |
34 | Debug | IMU Flushes | 3 | 1 |
35 | Debug | IMU Redo allocation size | 8008 | 1 |
36 | Debug | IMU commits | 5 | 1 |
37 | Debug | IMU undo allocation size | 4300 | 1 |
38 | Debug | active txn count during cleanout | 6 | 1 |
39 | Debug | calls to kcmgas | 15 | 1 |
40 | Debug | calls to kcmgcs | 514 | 1 |
41 | Debug | cleanout - number of ktugct calls | 6 | 1 |
42 | Debug | commit txn count during cleanout | 2 | 1 |
43 | Debug | cursor authentications | 3 | 1 |
44 | Debug | deferred (CURRENT) block cleanout applications | 6 | 1 |
45 | Debug | immediate (CURRENT) block cleanout applications | 4 | 1 |
46 | Debug | index fetch by key | 10527 | 1 |
47 | Debug | index scans kdiixs1 | 170 | 1 |
48 | Debug | leaf node 90-10 splits | 2 | 1 |
49 | Debug | leaf node splits | 2 | 1 |
50 | Debug | messages sent | 3 | 1 |
51 | Debug | no work - consistent read gets | 51438 | 1 |
52 | Debug | redo synch time (usec) | 1699000 | 1 |
53 | Debug | undo change vector size | 35364 | 1 |
54 | Enqueue | enqueue releases | 46 | 1 |
55 | Enqueue | enqueue requests | 33 | 1 |
56 | OS | OS Involuntary context switches | 11296 | 1 |
57 | OS | OS Page faults | 1 | 1 |
58 | OS | OS Page reclaims | 66570 | 1 |
59 | OS | OS System time used | 5340 | 1 |
60 | OS | OS User time used | 4687 | 1 |
# | Class Name | Statistic Name | Value | Inst ID |
61 | OS | OS Voluntary context switches | 297 | 1 |
62 | RAC | calls to get snapshot scn: kcmgss | 258 | 1 |
63 | Redo | redo entries | 76 | 1 |
64 | Redo | redo ordering marks | 3 | 1 |
65 | Redo | redo size | 109252 | 1 |
66 | Redo | redo subscn max counts | 18 | 1 |
67 | Redo | redo synch time | 170 | 1 |
68 | Redo | redo synch writes | 1 | 1 |
69 | SQL | HSC Heap Segment Block Changes | 16 | 1 |
70 | SQL | Heap Segment Array Inserts | 8 | 1 |
71 | SQL | Heap Segment Array Updates | 2 | 1 |
72 | SQL | cell physical IO interconnect bytes | 367034368 | 1 |
73 | SQL | cluster key scan block gets | 58 | 1 |
74 | SQL | cluster key scans | 55 | 1 |
75 | SQL | execute count | 256 | 1 |
76 | SQL | parse count (hard) | 17 | 1 |
77 | SQL | parse count (total) | 27 | 1 |
78 | SQL | parse time cpu | 14 | 1 |
79 | SQL | parse time elapsed | 13 | 1 |
80 | SQL | rows fetched via callback | 8 | 1 |
81 | SQL | session cursor cache count | 48 | 1 |
82 | SQL | session cursor cache hits | 248 | 1 |
83 | SQL | sorts (memory) | 72 | 1 |
84 | SQL | sorts (rows) | 3013 | 1 |
85 | SQL | sql area evicted | 4 | 1 |
86 | SQL | table fetch by rowid | 185 | 1 |
87 | SQL | table scan blocks gotten | 50980 | 1 |
88 | SQL | table scan rows gotten | 12150623 | 1 |
89 | SQL | table scans (direct read) | 6 | 1 |
90 | SQL | table scans (long tables) | 6 | 1 |
# | Class Name | Statistic Name | Value | Inst ID |
91 | SQL | table scans (short tables) | 7 | 1 |
92 | SQL | workarea executions - optimal | 69 | 1 |
93 | User | CPU used by this session | 8803 | 1 |
94 | User | DB time | 12606 | 1 |
95 | User | Requests to/from client | 203 | 1 |
96 | User | SQL*Net roundtrips to/from client | 204 | 1 |
97 | User | bytes received via SQL*Net from client | 6660 | 1 |
98 | User | bytes sent via SQL*Net to client | 190956 | 1 |
99 | User | file io wait time | 102753 | 1 |
100 | User | non-idle wait count | 1342 | 1 |
101 | User | non-idle wait time | 163 | 1 |
102 | User | opened cursors cumulative | 267 | 1 |
103 | User | recursive calls | 814 | 1 |
104 | User | recursive cpu usage | 70 | 1 |
105 | User | session logical reads | 62912 | 1 |
106 | User | session pga memory | 2343716 | 1 |
107 | User | session pga memory max | 34603008 | 1 |
108 | User | session uga memory max | 34617300 | 1 |
109 | User | user I/O wait time | 103 | 1 |
110 | User | user calls | 216 | 1 |
111 | User | user commits | 7 | 1 |
# | Seconds Waited | Event Name | Inst ID | Total Waits | Avg Wait in seconds | Total Timeouts |
---|---|---|---|---|---|---|
1 | 10.187626 | direct path sync | 1 | 1 | 10.187626 | 0 |
2 | 2.494785 | log file switch completion | 1 | 1 | 2.494785 | 0 |
3 | 2.155506 | SQL*Net message from client | 1 | 204 | 0.010566 | 0 |
4 | 0.622938 | db file sequential read | 1 | 321 | 0.001941 | 0 |
5 | 0.596090 | log file sync | 1 | 1 | 0.596090 | 0 |
6 | 0.439566 | direct path read | 1 | 735 | 0.000598 | 0 |
7 | 0.009719 | db file scattered read | 1 | 80 | 0.000121 | 0 |
8 | 0.002783 | db file parallel read | 1 | 2 | 0.001392 | 0 |
9 | 0.002071 | utl_file I/O | 1 | 54 | 0.000038 | 0 |
10 | 0.001053 | control file sequential read | 1 | 42 | 0.000025 | 0 |
11 | 0.000612 | Disk file operations I/O | 1 | 7 | 0.000087 | 0 |
12 | 0.000271 | SQL*Net message to client | 1 | 204 | 0.000001 | 0 |
13 | 0.000195 | SQL*Net break/reset to client | 1 | 2 | 0.000098 | 0 |
14 | 0.000144 | BFILE read | 1 | 6 | 0.000024 | 0 |
15 | 0.000068 | direct path write temp | 1 | 1 | 0.000068 | 0 |
16 | 0.000004 | events in waitclass Other | 1 | 1 | 0.000004 | 1 |
Statistic | Inst ID | Value Before | Value After | Difference |
---|---|---|---|---|
Servers Busy : | 1 | 0 | 0 | 0 |
Servers Idle : | 1 | 2 | 0 | -2 |
Servers Highwater : | 1 | 8 | 8 | 0 |
Server Sessions : | 1 | 154 | 154 | 0 |
Servers Started : | 1 | 46 | 46 | 0 |
Servers Shutdown : | 1 | 44 | 46 | 2 |
Servers Cleaned Up : | 1 | 0 | 0 | 0 |
Queries Queued : | 1 | 0 | 0 | 0 |
Queries Initiated : | 1 | 65 | 65 | 0 |
Queries Initiated (IPQ) : | 1 | 0 | 0 | 0 |
DML Initiated : | 1 | 0 | 0 | 0 |
DML Initiated (IPQ) : | 1 | 0 | 0 | 0 |
DDL Initiated : | 1 | 3 | 3 | 0 |
DDL Initiated (IPQ) : | 1 | 0 | 0 | 0 |
DFO Trees : | 1 | 68 | 68 | 0 |
Sessions Active : | 1 | 0 | 0 | 0 |
Local Msgs Sent : | 1 | 6602 | 6602 | 0 |
Distr Msgs Sent : | 1 | 0 | 0 | 0 |
Local Msgs Recv'd : | 1 | 6602 | 6602 | 0 |
Distr Msgs Recv'd : | 1 | 0 | 0 | 0 |
Statistic | Inst ID | Value Before | Value After | Difference |
---|---|---|---|---|
Servers In Use : | 1 | 0 | 0 | 0 |
Servers Available : | 1 | 2 | 0 | -2 |
Servers Started : | 1 | 46 | 46 | 0 |
Servers Shutdown : | 1 | 44 | 46 | 2 |
Servers Highwater : | 1 | 8 | 8 | 0 |
Servers Cleaned Up : | 1 | 0 | 0 | 0 |
Server Sessions : | 1 | 154 | 154 | 0 |
Memory Chunks Allocated : | 1 | 19 | 19 | 0 |
Memory Chunks Freed : | 1 | 15 | 15 | 0 |
Memory Chunks Current : | 1 | 4 | 4 | 0 |
Memory Chunks HWM : | 1 | 15 | 15 | 0 |
Buffers Allocated : | 1 | 870 | 870 | 0 |
Buffers Freed : | 1 | 870 | 870 | 0 |
Buffers Current : | 1 | 0 | 0 | 0 |
Buffers HWM : | 1 | 101 | 101 | 0 |
Statistic | Inst ID | Last Query | Session Total |
---|---|---|---|
Queries Parallelized: | 1 | 0 | 0 |
DML Parallelized: | 1 | 0 | 0 |
DDL Parallelized: | 1 | 0 | 0 |
DFO Trees: | 1 | 0 | 0 |
Server Threads: | 1 | 0 | 0 |
Allocation Height: | 1 | 0 | 0 |
Allocation Width: | 1 | 0 | 0 |
Local Msgs Sent: | 1 | 0 | 0 |
Distr Msgs Sent: | 1 | 0 | 0 |
Local Msgs Recv'd: | 1 | 0 | 0 |
Distr Msgs Recv'd: | 1 | 0 | 0 |
# | Table Name | Owner | Count1 | Num Rows2 |
Sample Size2 |
Blocks2 | Last Analyzed2 |
Table Stats |
Table Stats Exten |
Table Prop |
Table Phys Prop |
Table Cons |
Table Cols |
Idxed Cols |
Table Hgrm |
Indexes |
Table Meta |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CUSTOMER | QTUNE | 101800 | 100000 | 100000 | 802 | 28-NOV-12 | Stats | 1 | Prop | Phys | 3 | 5 | 5 | 2 | 4 | Meta |
2 | ORDER_LINE | QTUNE | 3440000 | 3450201 | 3450201 | 13157 | 28-NOV-12 | Stats | Prop | Phys | 8 | 6 | 3 | 3 | Meta | ||
3 | PART | QTUNE | 204600 | 200000 | 200000 | 1430 | 28-NOV-12 | Stats | 1 | Prop | Phys | 4 | 6 | 2 | 2 | Meta | |
4 | SALES_ORDER | QTUNE | 302600 | 300000 | 300000 | 1693 | 28-NOV-12 | Stats | 1 | Prop | Phys | 4 | 6 | 4 | 1 | 3 | Meta |
# | Table Name | Owner | Part | Temp | Count1 | Num Rows2 | Sample Size2 | Perc | Last Analyzed2 | Segment Extents | Segment Blocks | Total Segment Blocks3 | DBMS_SPACE Allocated Blocks4 | Blocks2 | Empty Blocks | Avg Space | Avg Row Len2 | Chain Cnt | Global Stats2 | User Stats2 | Stat Type Locked | Stale Stats | Avg Space Freelist Blocks | Num Freelist Blocks | Avg Cached Blocks | Avg Cache Hit Ratio | Full Table Scan Cost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CUSTOMER | QTUNE | NO | N | 101800 | 100000 | 100000 | 100.0 | 2012-11-28/09:55:33 | 22 | 896 | 896 | 1408 | 802 | 0 | 0 | 92 | 0 | YES | NO | NO | 0 | 0 | 220 | |||
2 | ORDER_LINE | QTUNE | NO | N | 3440000 | 3450201 | 3450201 | 100.0 | 2012-11-28/09:56:22 | 84 | 13312 | 13312 | 13312 | 13157 | 0 | 0 | 23 | 0 | YES | NO | NO | 0 | 0 | 3609 | |||
3 | PART | QTUNE | NO | N | 204600 | 200000 | 200000 | 100.0 | 2012-11-28/09:55:44 | 27 | 1536 | 1536 | 1792 | 1430 | 0 | 0 | 58 | 0 | YES | NO | NO | 0 | 0 | 392 | |||
4 | SALES_ORDER | QTUNE | NO | N | 302600 | 300000 | 300000 | 100.0 | 2012-11-28/09:55:54 | 29 | 1792 | 1792 | 1792 | 1693 | 0 | 0 | 38 | 0 | YES | NO | NO | 0 | 0 | 464 |
# | 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)) |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | Table Name | Owner | Count1 | Num Rows2 |
Sample Size2 |
Blocks2 | Last Analyzed2 |
Column Stats |
Column Usage |
Column Prop |
Hgrm |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | CUSTOMER | QTUNE | 101800 | 100000 | 100000 | 802 | 28-NOV-12 | 5 | 3 | Prop | 2 |
2 | ORDER_LINE | QTUNE | 3440000 | 3450201 | 3450201 | 13157 | 28-NOV-12 | 6 | 2 | Prop | |
3 | PART | QTUNE | 204600 | 200000 | 200000 | 1430 | 28-NOV-12 | 6 | 3 | Prop | |
4 | SALES_ORDER | QTUNE | 302600 | 300000 | 300000 | 1693 | 28-NOV-12 | 6 | 4 | Prop | 1 |
# | 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 |
# | In Pred | In Index | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TRUE | TRUE | TRUE | 1 | CUSTOMER_ID | 55 | 62 | 0 | 0 | 0 | 1 | 2013-02-04/11:06:47 | |
2 | TRUE | TRUE | TRUE | 4 | CREDIT_LIMIT | 0 | 0 | 0 | 57 | 0 | 0 | 2013-02-04/11:06:47 | |
3 | TRUE | TRUE | FALSE | 3 | CUSTOMER_TYPE | 62 | 0 | 0 | 0 | 0 | 1 | 2013-02-04/11:06:47 |
# | 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 | 1 | CUSTOMER_ID | ||||||||||
2 | TRUE | TRUE | TRUE | 4 | CREDIT_LIMIT | NUMBER | 22 | Y | 0 | NO | YES | NO | NO | 4 | 4 | CREDIT_LIMIT | ||||||||||
3 | TRUE | TRUE | FALSE | 3 | CUSTOMER_TYPE | VARCHAR2 | 40 | N | CHAR_CS | 40 | 40 | B | NO | YES | NO | NO | 3 | 3 | CUSTOMER_TYPE | |||||||
4 | FALSE | TRUE | TRUE | 2 | CUSTOMER_NAME | VARCHAR2 | 4000 | Y | CHAR_CS | 4000 | 4000 | B | NO | YES | NO | NO | 2 | 2 | CUSTOMER_NAME | |||||||
5 | FALSE | TRUE | FALSE | SYS_NC00005$ | VARCHAR2 | 4000 | Y | 22 | LOWER("CUSTOMER_NAME") | CHAR_CS | 4000 | 4000 | B | NO | YES | YES | YES | 5 | SYS_NC00005$ |
# | 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 |
# | In Pred | In Index | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TRUE | TRUE | TRUE | 2 | ORDER_ID | 55 | 58 | 0 | 0 | 0 | 0 | 2013-02-04/11:06:47 | |
2 | TRUE | TRUE | TRUE | 4 | PART_ID | 0 | 58 | 0 | 0 | 0 | 0 | 2013-02-04/11:06:47 |
# | 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 | 2 | ORDER_ID | ||||||||||
2 | TRUE | TRUE | TRUE | 4 | PART_ID | NUMBER | 22 | N | 0 | NO | YES | NO | NO | 4 | 4 | PART_ID | ||||||||||
3 | FALSE | TRUE | FALSE | 1 | LINE_ID | NUMBER | 22 | N | 0 | NO | YES | NO | NO | 1 | 1 | LINE_ID | ||||||||||
4 | FALSE | FALSE | TRUE | 5 | QUANTITY | NUMBER | 22 | N | 0 | NO | YES | NO | NO | 5 | 5 | QUANTITY | ||||||||||
5 | FALSE | FALSE | TRUE | 6 | DISCOUNT_PERC | NUMBER | 22 | Y | 0 | NO | YES | NO | NO | 6 | 6 | DISCOUNT_PERC | ||||||||||
6 | FALSE | FALSE | FALSE | 3 | LINE_NUM | NUMBER | 22 | N | 0 | NO | YES | NO | NO | 3 | 3 | LINE_NUM |
# | 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$CFTBUVDQ | SYS_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 |
# | In Pred | In Index | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TRUE | TRUE | TRUE | 1 | PART_ID | 0 | 63 | 0 | 0 | 0 | 1 | 2013-02-04/11:06:47 | |
2 | FALSE | FALSE | TRUE | 4 | PART_PRICE | 0 | 0 | 0 | 0 | 0 | 1 | 2012-11-20/06:47:33 | |
3 | FALSE | FALSE | FALSE | 3 | PART_TYPE | 0 | 0 | 0 | 0 | 0 | 1 | 2012-11-20/06:47:33 |
# | 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 | 1 | PART_ID | ||||||||||
2 | FALSE | TRUE | FALSE | 2 | PART_NAME | VARCHAR2 | 4000 | Y | CHAR_CS | 4000 | 4000 | B | NO | YES | NO | NO | 2 | 2 | PART_NAME | |||||||
3 | FALSE | FALSE | TRUE | 4 | PART_PRICE | NUMBER | 22 | N | 0 | NO | YES | NO | NO | 4 | 4 | PART_PRICE | ||||||||||
4 | FALSE | FALSE | FALSE | 3 | PART_TYPE | VARCHAR2 | 1 | N | CHAR_CS | 1 | 1 | B | NO | YES | NO | NO | 3 | 3 | PART_TYPE | |||||||
5 | FALSE | FALSE | FALSE | 5 | ON_HAND | NUMBER | 22 | Y | 0 | NO | YES | NO | NO | 5 | 5 | ON_HAND | ||||||||||
6 | FALSE | FALSE | FALSE | SYS_STUUS4P4NZTNB5ELB$CFTBUVDQ | NUMBER | 22 | Y | 43 | SYS_OP_COMBINED_HASH("PART_TYPE","ON_HAND") | 0 | NO | YES | YES | YES | 6 | SYS_STUUS4P4NZTNB5ELB$CFTBUVDQ |
# | 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#WQA | SUBSTR("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 |
# | In Pred | In Index | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TRUE | TRUE | TRUE | 1 | ORDER_ID | 0 | 58 | 0 | 0 | 0 | 1 | 2013-02-04/11:06:47 | |
2 | TRUE | TRUE | TRUE | 4 | CUSTOMER_ID | 55 | 57 | 0 | 0 | 0 | 1 | 2013-02-04/11:06:47 | |
3 | TRUE | FALSE | FALSE | 5 | STATUS | 57 | 0 | 0 | 0 | 0 | 0 | 2013-02-04/11:06:47 | |
4 | FALSE | TRUE | FALSE | 2 | ORDER_NUM | 0 | 0 | 0 | 0 | 0 | 1 | 2012-11-20/06:48:17 |
# | 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 | 1 | ORDER_ID | ||||||||||
2 | TRUE | TRUE | TRUE | 4 | CUSTOMER_ID | NUMBER | 22 | N | 0 | NO | YES | NO | NO | 4 | 4 | CUSTOMER_ID | ||||||||||
3 | TRUE | FALSE | FALSE | 5 | STATUS | VARCHAR2 | 1 | Y | CHAR_CS | 1 | 1 | B | NO | YES | NO | NO | 5 | 5 | STATUS | |||||||
4 | FALSE | TRUE | FALSE | 2 | ORDER_NUM | VARCHAR2 | 4000 | N | CHAR_CS | 4000 | 4000 | B | NO | YES | NO | NO | 2 | 2 | ORDER_NUM | |||||||
5 | FALSE | TRUE | FALSE | 3 | ORDER_DATE | DATE | 7 | Y | 0 | NO | YES | NO | NO | 3 | 3 | ORDER_DATE | ||||||||||
6 | FALSE | FALSE | FALSE | SYS_STUK0XJTEZVXUTGW1H0VTZ#WQA | VARCHAR2 | 2 | Y | 23 | SUBSTR("ORDER_NUM",1,2) | CHAR_CS | 2 | 2 | B | NO | YES | YES | YES | 6 | SYS_STUK0XJTEZVXUTGW1H0VTZ#WQA |
# | Table Name | Owner | Count1 | Num Rows2 |
Sample Size2 |
Blocks2 | Last Analyzed2 |
Indexes |
---|---|---|---|---|---|---|---|---|
1 | CUSTOMER | QTUNE | 101800 | 100000 | 100000 | 802 | 28-NOV-12 | 4 |
2 | ORDER_LINE | QTUNE | 3440000 | 3450201 | 3450201 | 13157 | 28-NOV-12 | 3 |
3 | PART | QTUNE | 204600 | 200000 | 200000 | 1430 | 28-NOV-12 | 2 |
4 | SALES_ORDER | QTUNE | 302600 | 300000 | 300000 | 1693 | 28-NOV-12 | 3 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | Table Name | Owner | Count1 | Num Rows2 |
Sample Size2 |
Blocks2 | Last Analyzed2 |
Indexes |
---|---|---|---|---|---|---|---|---|
1 | CUSTOMER | QTUNE | 101800 | 100000 | 100000 | 802 | 28-NOV-12 | 4 |
2 | ORDER_LINE | QTUNE | 3440000 | 3450201 | 3450201 | 13157 | 28-NOV-12 | 3 |
3 | PART | QTUNE | 204600 | 200000 | 200000 | 1430 | 28-NOV-12 | 2 |
4 | SALES_ORDER | QTUNE | 302600 | 300000 | 300000 | 1693 | 28-NOV-12 | 3 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | Col Pos | In Pred | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | TRUE | TRUE | 1 | CUSTOMER_ID | 55 | 62 | 0 | 0 | 0 | 1 | 2013-02-04/11:06:47 |
# | 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 | 1 | CUSTOMER_ID |
# | 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 |
# | 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 | 22 | LOWER("CUSTOMER_NAME") | CHAR_CS | 4000 | 4000 | B | NO | YES | YES | YES | 5 | SYS_NC00005$ |
# | 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 |
# | 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 | 2 | CUSTOMER_NAME |
# | 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 |
# | Col Pos | In Pred | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | TRUE | FALSE | 3 | CUSTOMER_TYPE | 62 | 0 | 0 | 0 | 0 | 1 | 2013-02-04/11:06:47 | |
2 | 2 | TRUE | TRUE | 4 | CREDIT_LIMIT | 0 | 0 | 0 | 57 | 0 | 0 | 2013-02-04/11:06:47 |
# | 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 | 3 | CUSTOMER_TYPE | |||||||
2 | 2 | TRUE | TRUE | 4 | CREDIT_LIMIT | NUMBER | 22 | Y | 0 | NO | YES | NO | NO | 4 | 4 | CREDIT_LIMIT |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | Col Pos | In Pred | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | TRUE | TRUE | 2 | ORDER_ID | 55 | 58 | 0 | 0 | 0 | 0 | 2013-02-04/11:06:47 |
# | 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 | 2 | ORDER_ID |
# | 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 |
# | Col Pos | In Pred | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | TRUE | TRUE | 4 | PART_ID | 0 | 58 | 0 | 0 | 0 | 0 | 2013-02-04/11:06:47 |
# | 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 | 4 | PART_ID |
# | 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 |
# | 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 | 1 | LINE_ID |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 | 2 | PART_NAME |
# | 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 |
# | Col Pos | In Pred | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | TRUE | TRUE | 1 | PART_ID | 0 | 63 | 0 | 0 | 0 | 1 | 2013-02-04/11:06:47 |
# | 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 | 1 | PART_ID |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 | 2 | ORDER_NUM |
# | 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 |
# | Col Pos | In Pred | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | TRUE | TRUE | 4 | CUSTOMER_ID | 55 | 57 | 0 | 0 | 0 | 1 | 2013-02-04/11:06:47 |
# | 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 | 4 | CUSTOMER_ID | ||||||||||
2 | 2 | FALSE | FALSE | 3 | ORDER_DATE | DATE | 7 | Y | 0 | NO | YES | NO | NO | 3 | 3 | ORDER_DATE |
# | 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 |
# | Col Pos | In Pred | In Proj | Col ID | Column Name | Data Default | Equality Preds | Equijoin Preds | Non-equijoin Preds | Range Preds | LIKE Preds | NULL Preds | Timestamp |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | TRUE | TRUE | 1 | ORDER_ID | 0 | 58 | 0 | 0 | 0 | 1 | 2013-02-04/11:06:47 |
# | 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 | 1 | ORDER_ID |
# | 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 |
# | 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 |
# | 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 |
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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
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"
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"
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"
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
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
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_idGo to Metadata