1366133.1 SQLHC 11.4.5.2 Report: sqlhc_20121226_180358_f995z9antmhxn_2_diagnostics.html

License   : T
Input     : f995z9antmhxn
SIGNATURE : 1178211779310957485
SIGNATUREF: 1178211779310957485
RDBMS     : 11.2.0.3.0
Platform  : 64-BIT WINDOWS
Database  : orcl
DBID      : 1311055076
Host      : csierraus
Instance  : 1
CPU Count : 4
Block Size: 8192
OFE       : 11.2.0.3
DYN_SAMP  : 2
EBS       : ""
SIEBEL    : ""
PSFT      : ""
Date      : 2012-12-26/18:03:59

SQL Text

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

SQL Plan Baselines (DBA_SQL_PLAN_BASELINES)

Available on 11g or higher. If this section is empty that means there are no plans in plan history for this SQL.

# SIGNATURE SQL_HANDLE SQL_TEXT PLAN_NAME CREATOR ORIGIN PARSING_SCHEMA_NAME DESCRIPTION VERSION CREATED LAST_MODIFIED LAST_EXECUTED LAST_VERIFIED ENA ACC FIX REP AUT OPTIMIZER_COST MODULE ACTION EXECUTIONS ELAPSED_TIME CPU_TIME BUFFER_GETS DISK_READS DIRECT_WRITES ROWS_PROCESSED FETCHES END_OF_FETCH_COUNT
1 1178211779310957485 SQL_1059d95ef002b3ad 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 S90852_24296316_MEM SYS MANUAL-LOAD QTUNE 001 S90852_ORCL_CSIERRAUS_F995Z9ANTMHXN_24296316_MEM (ET:0.015S, CPU:0.012S, BUFFERS:5061, ROWS:42) 11.2.0.3.0 22-DEC-12 07.02.24.000000 AM 22-DEC-12 07.11.19.000000 AM 22-DEC-12 07.11.19.000000 AM   YES YES NO NO YES 2769 sqlplus - Copy.exe   5 75920 62400 25306 0 0 210 20 5
2 1178211779310957485 SQL_1059d95ef002b3ad 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_PLAN_10qftbvs05cxdedd77aad QTUNE AUTO-CAPTURE QTUNE   11.2.0.3.0 22-DEC-12 07.03.32.000000 AM 22-DEC-12 07.03.32.000000 AM     YES NO NO YES YES 21136 SQL*Plus   0 0 0 0 0 0 0 0 0
3 1178211779310957485 SQL_1059d95ef002b3ad 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_PLAN_10qftbvs05cxd396bc481 QTUNE AUTO-CAPTURE QTUNE   11.2.0.3.0 22-DEC-12 07.04.03.000000 AM 22-DEC-12 07.04.03.000000 AM     YES NO NO YES YES 20990 SQL*Plus   0 0 0 0 0 0 0 0 0
4 1178211779310957485 SQL_1059d95ef002b3ad 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_PLAN_10qftbvs05cxd7b03166a QTUNE AUTO-CAPTURE QTUNE   11.2.0.3.0 22-DEC-12 07.05.23.000000 AM 22-DEC-12 07.05.23.000000 AM     YES NO NO YES YES 20199 SQL*Plus   0 0 0 0 0 0 0 0 0
5 1178211779310957485 SQL_1059d95ef002b3ad 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_PLAN_10qftbvs05cxdaab9aea9 QTUNE AUTO-CAPTURE QTUNE   11.2.0.3.0 22-DEC-12 07.05.37.000000 AM 22-DEC-12 07.05.37.000000 AM     YES NO NO YES YES 19614 SQL*Plus   0 0 0 0 0 0 0 0 0
6 1178211779310957485 SQL_1059d95ef002b3ad 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_PLAN_10qftbvs05cxd30c6a0f1 QTUNE AUTO-CAPTURE QTUNE   11.2.0.3.0 22-DEC-12 07.05.47.000000 AM 22-DEC-12 07.05.47.000000 AM     YES NO NO YES YES 2591 SQL*Plus   0 0 0 0 0 0 0 0 0
7 1178211779310957485 SQL_1059d95ef002b3ad 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_PLAN_10qftbvs05cxdb41925f7 QTUNE AUTO-CAPTURE QTUNE   11.2.0.3.0 22-DEC-12 07.08.11.000000 AM 22-DEC-12 07.08.11.000000 AM     YES NO NO YES YES 20062 SQL*Plus   0 0 0 0 0 0 0 0 0
8 1178211779310957485 SQL_1059d95ef002b3ad 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_PLAN_10qftbvs05cxdf056965f QTUNE AUTO-CAPTURE QTUNE   11.2.0.3.0 22-DEC-12 07.10.53.000000 AM 22-DEC-12 07.10.53.000000 AM     YES NO NO YES YES 21704 SQL*Plus   0 0 0 0 0 0 0 0 0
9 1178211779310957485 SQL_1059d95ef002b3ad 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_PLAN_10qftbvs05cxdf878351f QTUNE AUTO-CAPTURE QTUNE   11.2.0.3.0 22-DEC-12 07.11.09.000000 AM 22-DEC-12 07.11.09.000000 AM     YES NO NO YES YES 21704 SQL*Plus   0 0 0 0 0 0 0 0 0

SQL Profiles (DBA_SQL_PROFILES)

Available on 10g or higher. If this section is empty that means there are no profiles for this SQL.

SQL Patches (DBA_SQL_PATCHES)

Available on 11g or higher. If this section is empty that means there are no patches for this SQL.

Cursor Sharing and Reason

Collected from GV$SQL_SHARED_CURSOR.
# Reason Inst Cursors
# Reason Inst Cursors

Cursor Sharing List

Collected from GV$SQL_SHARED_CURSOR.

Current Plans Summary (GV$SQL)

Execution Plans performance metrics for f995z9antmhxn while still in memory. Plans ordered by average elapsed time.
# Plan HV Avg
Elapsed
Time
(secs)
Avg
CPU
Time
(secs)
Avg
IO
Time
(secs)
Avg
Conc
Time
(secs)
Avg
Appl
Time
(secs)
Avg
Clus
Time
(secs)
Avg
PLSQL
Time
(secs)
Avg
Java
Time
(secs)
Avg
Buffer
Gets
Avg
Disk
Reads
Avg
Direct
Writes
Avg
Rows
Proc
Total
Execs
Total
Fetch
Total
Loads
Total
Inval
Total
Parse
Calls
Total
Child
Cursors
Min
Cost
Max
Cost
Min
Opt Env HV
Max
Opt Env HV
First Load Last Load Last Active
1 2816325939 4.751 4.134 0.618 0.000 0.000 0.000 0.000 0.000 21036 15275 0 922 2 126 1 0 2 1 19614 1788880094 2012-12-26/15:35:13 2012-12-26/15:35:13 2012-12-26/15:35:24
# Plan HV Avg
Elapsed
Time
(secs)
Avg
CPU
Time
(secs)
Avg
IO
Time
(secs)
Avg
Conc
Time
(secs)
Avg
Appl
Time
(secs)
Avg
Clus
Time
(secs)
Avg
PLSQL
Time
(secs)
Avg
Java
Time
(secs)
Avg
Buffer
Gets
Avg
Disk
Reads
Avg
Direct
Writes
Avg
Rows
Proc
Total
Execs
Total
Fetch
Total
Loads
Total
Inval
Total
Parse
Calls
Total
Child
Cursors
Min
Cost
Max
Cost
Min
Opt Env HV
Max
Opt Env HV
First Load Last Load Last Active

Current SQL Statistics (GV$SQL)

Performance metrics of child cursors of f995z9antmhxn while still in memory.
# Inst
ID
Child
Num
Plan HV Execs Fetch Loads Inval Parse
Calls
Buffer
Gets
Disk
Reads
Direct
Writes
Rows
Proc
Elapsed
Time
(secs)
CPU
Time
(secs)
IO
Time
(secs)
Conc
Time
(secs)
Appl
Time
(secs)
Clus
Time
(secs)
PLSQL
Time
(secs)
Java
Time
(secs)
Optimizer
Mode
Cost Opt Env HV Parsing
Schema
Name
Module Action Outline Profile First Load Last Load Last Active
1 1 0 2816325939 2 126 1 0 2 42071 30549 0 1844 9.502 8.268 1.237 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1788880094 QTUNE SQL*Plus 2012-12-26/15:35:13 2012-12-26/15:35:13 2012-12-26/15:35:24
# Inst
ID
Child
Num
Plan HV Execs Fetch Loads Inval Parse
Calls
Buffer
Gets
Disk
Reads
Direct
Writes
Rows
Proc
Elapsed
Time
(secs)
CPU
Time
(secs)
IO
Time
(secs)
Conc
Time
(secs)
Appl
Time
(secs)
Clus
Time
(secs)
PLSQL
Time
(secs)
Java
Time
(secs)
Optimizer
Mode
Cost Opt Env HV Parsing
Schema
Name
Module Action Outline Profile First Load Last Load Last Active

Historical Plans Summary (DBA_HIST_SQLSTAT)

Performance metrics of Execution Plans of f995z9antmhxn. Plans ordered by average elapsed time.
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.
# Plan HV Avg
Elapsed
Time
(secs)
Avg
CPU
Time
(secs)
Avg
IO
Time
(secs)
Avg
Conc
Time
(secs)
Avg
Appl
Time
(secs)
Avg
Clus
Time
(secs)
Avg
PLSQL
Time
(secs)
Avg
Java
Time
(secs)
Avg
Buffer
Gets
Avg
Disk
Reads
Avg
Direct
Writes
Avg
Rows
Proc
Total
Execs
Min
Cost
Max
Cost
Min
Opt Env HV
Max
Opt Env HV
First Snapshot Last Snapshot
1 24296316 0.006 0.005 0.000 0.000 0.000 0.000 0.000 0.000 1787 0 0 15 17 2683 2769 1763851670 2012-12-21/09:57:32 2012-12-22/08:00:34
2 1637264670 0.550 0.512 0.027 0.000 0.000 0.000 0.000 0.000 15323 2471 0 2279 16 20062 20072 1552172736 2012-12-21/09:57:04 2012-12-22/08:00:34
3 142578110 0.947 0.942 0.000 0.000 0.000 0.000 0.000 0.000 23836 0 0 1953 14 21701 1763851670 2012-12-21/09:57:32 2012-12-21/10:12:31
4 3427378629 1.206 1.202 0.000 0.000 0.000 0.000 0.000 0.000 29662 0 0 246 15 21701 1763851670 2012-12-21/09:57:32 2012-12-21/10:12:31
5 657302870 1.604 1.518 0.084 0.000 0.000 0.000 0.000 0.000 32377 2454 6 4966 43 20199 20259 294135021 1788880094 2012-12-21/09:52:15 2012-12-22/08:00:34
6 3267771367 1.846 0.088 1.772 0.000 0.000 0.000 0.000 0.000 16600 695 0 115 59 192 2623 294135021 1788880094 2012-12-21/09:52:15 2012-12-22/08:00:34
7 1503269649 2.155 2.132 0.014 0.000 0.000 0.000 0.000 0.000 59479 2506 0 13529 21 20990 20997 1788880094 2012-12-21/09:52:15 2012-12-22/08:00:34
8 1186590923 2.844 2.770 0.058 0.000 0.000 0.000 0.000 0.000 90553 3182 0 21370 22 21128 21136 1788880094 2012-12-21/09:50:24 2012-12-22/08:00:34
9 2903038705 2.970 2.964 0.000 0.000 0.000 0.000 0.000 0.000 11350 0 0 32 4 19129 1327401543 2012-12-21/10:11:36 2012-12-21/10:12:31
10 2816325939 3.636 3.563 0.063 0.000 0.000 0.000 0.000 0.000 17051 2979 0 533 56 19614 19662 294135021 1788880094 2012-12-19/20:00:29 2012-12-26/16:00:07
11 3314618365 8.257 8.221 0.000 0.000 0.000 0.000 0.000 0.000 298216 0 0 42 3 15863 1219798382 2012-12-21/10:12:31 2012-12-21/10:12:31
12 737414948 8.308 8.268 0.000 0.000 0.000 0.000 0.000 0.000 298953 0 0 3653 3 15964 1219798382 2012-12-21/10:12:31 2012-12-21/10:12:31
13 3322900607 22.828 4.631 18.108 0.000 0.000 0.000 0.000 0.000 83085 9868 0 15041 8 3180 806877927 2012-12-21/10:11:08 2012-12-21/10:12:31
# Plan HV Avg
Elapsed
Time
(secs)
Avg
CPU
Time
(secs)
Avg
IO
Time
(secs)
Avg
Conc
Time
(secs)
Avg
Appl
Time
(secs)
Avg
Clus
Time
(secs)
Avg
PLSQL
Time
(secs)
Avg
Java
Time
(secs)
Avg
Buffer
Gets
Avg
Disk
Reads
Avg
Direct
Writes
Avg
Rows
Proc
Total
Execs
Min
Cost
Max
Cost
Min
Opt Env HV
Max
Opt Env HV
First Snapshot Last Snapshot

Historical SQL Statistics (DBA_HIST_SQLSTAT)

Performance metrics of Execution Plans of f995z9antmhxn.
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.
# Snap
ID
Snaphot Inst
ID
Plan HV Vers
Cnt
Execs Fetch Loads Inval Parse
Calls
Buffer
Gets
Disk
Reads
Direct
Writes
Rows
Proc
Elapsed
Time
(secs)
CPU
Time
(secs)
IO
Time
(secs)
Conc
Time
(secs)
Appl
Time
(secs)
Clus
Time
(secs)
PLSQL
Time
(secs)
Java
Time
(secs)
Optimizer
Mode
Cost Opt Env HV Parsing
Schema
Name
Module Action Profile
1 1969 2012-12-19/20:00:29 1 2816325939 1 2 126 0 0 2 41857 30530 0 1844 9.432 8.190 1.086 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1553258451 QTUNE SQL*Plus
2 1992 2012-12-21/09:50:24 1 1186590923 1 1 2412 0 0 1 153758 17378 0 36164 5.993 5.008 0.973 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
3 1993 2012-12-21/09:52:15 1 657302870 7 2 1218 1 0 2 103102 26314 0 18228 4.635 4.352 0.299 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20205 1788880094 QTUNE sqlplus - Copy.exe
4 1993 2012-12-21/09:52:15 1 1186590923 7 2 4824 0 0 1 306396 26314 0 72328 9.300 9.142 0.137 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
5 1993 2012-12-21/09:52:15 1 1503269649 7 2 3792 1 0 4 249810 26314 0 56822 9.214 9.064 0.132 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
6 1993 2012-12-21/09:52:15 1 2816325939 7 2 126 1 0 2 41290 26314 0 1844 8.441 8.190 0.189 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1788880094 QTUNE sqlplus - Copy.exe
7 1993 2012-12-21/09:52:15 1 3267771367 7 6 12 3 0 5 10598 3722 0 84 11.353 0.343 11.150 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2623 1788880094 QTUNE sqlplus - Copy.exe
8 1994 2012-12-21/09:54:16 1 657302870 15 4 2436 2 0 3 206204 52628 0 36456 8.794 8.471 0.414 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20205 1788880094 QTUNE sqlplus - Copy.exe
9 1994 2012-12-21/09:54:16 1 1186590923 15 2 4824 1 0 2 306402 26314 0 72328 9.543 9.329 0.160 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
10 1994 2012-12-21/09:54:16 1 1503269649 15 2 3792 1 0 2 249810 26314 0 56822 9.135 8.908 0.170 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
11 1994 2012-12-21/09:54:16 1 2816325939 15 4 252 2 0 4 82580 52628 0 3688 16.534 16.302 0.261 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1788880094 QTUNE sqlplus - Copy.exe
12 1994 2012-12-21/09:54:16 1 3267771367 15 6 18 2 0 6 20880 0 0 168 0.082 0.094 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2623 1788880094 QTUNE sqlplus - Copy.exe
13 1995 2012-12-21/09:57:04 1 657302870 21 2 1218 0 0 5 103098 0 0 18228 4.085 4.056 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20205 1788880094 QTUNE sqlplus - Copy.exe
14 1995 2012-12-21/09:57:04 1 1186590923 21 2 4824 1 0 0 306398 0 0 72328 9.141 9.064 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
15 1995 2012-12-21/09:57:04 1 1503269649 21 2 3792 1 0 0 249806 0 0 56822 8.813 8.767 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
16 1995 2012-12-21/09:57:04 1 1637264670 21 2 1218 0 0 3 122574 26343 0 18228 4.468 4.134 0.261 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
17 1995 2012-12-21/09:57:04 1 2816325939 21 6 136 2 0 6 110204 235 0 1928 24.539 24.321 0.223 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19662 861957822 QTUNE sqlplus - Copy.exe
18 1995 2012-12-21/09:57:04 1 3267771367 21 4 134 2 0 3 284734 16773 0 1928 41.582 1.669 40.263 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 192 1552172736 QTUNE sqlplus - Copy.exe
19 1996 2012-12-21/09:57:32 1 24296316 24 2 8 1 0 1 10126 0 0 84 0.038 0.016 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
20 1996 2012-12-21/09:57:32 1 142578110 24 2 1218 0 0 3 222468 0 0 18228 8.813 8.798 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
21 1996 2012-12-21/09:57:32 1 657302870 24 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20205 1788880094 QTUNE sqlplus - Copy.exe
22 1996 2012-12-21/09:57:32 1 1186590923 24 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
23 1996 2012-12-21/09:57:32 1 1503269649 24 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
24 1996 2012-12-21/09:57:32 1 1637264670 24 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
25 1996 2012-12-21/09:57:32 1 2816325939 24 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19662 861957822 QTUNE sqlplus - Copy.exe
26 1996 2012-12-21/09:57:32 1 3267771367 24 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 192 1552172736 QTUNE sqlplus - Copy.exe
27 1996 2012-12-21/09:57:32 1 3427378629 24 2 126 1 0 2 222468 0 0 1844 9.125 9.095 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
28 1997 2012-12-21/09:57:54 1 24296316 27 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
29 1997 2012-12-21/09:57:54 1 142578110 27 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
30 1997 2012-12-21/09:57:54 1 657302870 27 2 1218 0 0 3 103104 0 0 18228 4.030 3.994 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20205 1783579615 QTUNE sqlplus - Copy.exe
31 1997 2012-12-21/09:57:54 1 1186590923 27 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
32 1997 2012-12-21/09:57:54 1 1503269649 27 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
33 1997 2012-12-21/09:57:54 1 1637264670 27 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
34 1997 2012-12-21/09:57:54 1 2816325939 27 2 126 1 0 2 41292 0 0 1844 8.074 8.081 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1783579615 QTUNE sqlplus - Copy.exe
35 1997 2012-12-21/09:57:54 1 3267771367 27 2 8 1 0 1 10298 0 0 84 0.041 0.047 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2623 1783579615 QTUNE sqlplus - Copy.exe
36 1997 2012-12-21/09:57:54 1 3427378629 27 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
37 1998 2012-12-21/10:04:46 1 24296316 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
38 1998 2012-12-21/10:04:46 1 142578110 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
39 1998 2012-12-21/10:04:46 1 657302870 28 1 1 1 0 1 6 0 0 0 0.021 0.031 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20259 1788880094 QTUNE sqlplus - Copy.exe
40 1998 2012-12-21/10:04:46 1 1186590923 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
41 1998 2012-12-21/10:04:46 1 1503269649 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
42 1998 2012-12-21/10:04:46 1 1637264670 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
43 1998 2012-12-21/10:04:46 1 2816325939 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1783579615 QTUNE sqlplus - Copy.exe
44 1998 2012-12-21/10:04:46 1 3267771367 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2623 1783579615 QTUNE sqlplus - Copy.exe
45 1998 2012-12-21/10:04:46 1 3427378629 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
46 1999 2012-12-21/10:05:18 1 24296316 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
47 1999 2012-12-21/10:05:18 1 142578110 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
48 1999 2012-12-21/10:05:18 1 657302870 28 6 679 0 0 3 108210 0 0 10078 6.584 6.568 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20259 1788880094 QTUNE sqlplus - Copy.exe
49 1999 2012-12-21/10:05:18 1 1186590923 28 1 2412 1 0 0 153199 0 0 36164 4.793 4.696 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
50 1999 2012-12-21/10:05:18 1 1503269649 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
51 1999 2012-12-21/10:05:18 1 1637264670 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
52 1999 2012-12-21/10:05:18 1 2816325939 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1783579615 QTUNE sqlplus - Copy.exe
53 1999 2012-12-21/10:05:18 1 3267771367 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2623 1783579615 QTUNE sqlplus - Copy.exe
54 1999 2012-12-21/10:05:18 1 3427378629 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
55 2000 2012-12-21/10:06:01 1 24296316 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
56 2000 2012-12-21/10:06:01 1 142578110 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
57 2000 2012-12-21/10:06:01 1 657302870 28 6 679 0 0 2 108210 255 255 10078 6.655 6.614 0.014 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20259 1788880094 QTUNE sqlplus - Copy.exe
58 2000 2012-12-21/10:06:01 1 1186590923 28 1 2412 1 0 0 153199 0 0 36164 4.999 4.961 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
59 2000 2012-12-21/10:06:01 1 1503269649 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
60 2000 2012-12-21/10:06:01 1 1637264670 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
61 2000 2012-12-21/10:06:01 1 2816325939 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1783579615 QTUNE sqlplus - Copy.exe
62 2000 2012-12-21/10:06:01 1 3267771367 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2623 1783579615 QTUNE sqlplus - Copy.exe
63 2000 2012-12-21/10:06:01 1 3427378629 28 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
64 2001 2012-12-21/10:07:17 1 24296316 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
65 2001 2012-12-21/10:07:17 1 142578110 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
66 2001 2012-12-21/10:07:17 1 657302870 30 7 1356 2 0 9 196260 0 0 20198 12.331 12.230 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20199 1788880094 QTUNE sqlplus - Copy.exe
67 2001 2012-12-21/10:07:17 1 1186590923 30 1 2412 1 0 0 153199 0 0 36164 4.701 4.696 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
68 2001 2012-12-21/10:07:17 1 1503269649 30 1 1896 1 0 0 124903 0 0 28411 4.676 4.602 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
69 2001 2012-12-21/10:07:17 1 1637264670 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
70 2001 2012-12-21/10:07:17 1 2816325939 30 3 189 1 0 0 61929 0 0 2766 12.579 12.480 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1788880094 QTUNE sqlplus - Copy.exe
71 2001 2012-12-21/10:07:17 1 3267771367 30 9 21 1 0 0 21294 0 0 168 0.061 0.047 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 1301 1788880094 QTUNE sqlplus - Copy.exe
72 2001 2012-12-21/10:07:17 1 3427378629 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
73 2002 2012-12-21/10:08:59 1 24296316 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
74 2002 2012-12-21/10:08:59 1 142578110 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
75 2002 2012-12-21/10:08:59 1 657302870 30 1 609 0 0 3 51549 0 0 9114 2.071 2.059 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20199 1788880094 QTUNE sqlplus - Copy.exe
76 2002 2012-12-21/10:08:59 1 1186590923 30 1 2412 1 0 0 153199 0 0 36164 4.845 4.836 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
77 2002 2012-12-21/10:08:59 1 1503269649 30 1 1896 1 0 0 124903 0 0 28411 4.515 4.493 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
78 2002 2012-12-21/10:08:59 1 1637264670 30 1 609 1 0 0 61285 0 0 9114 2.052 2.012 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
79 2002 2012-12-21/10:08:59 1 2816325939 30 12 210 0 0 2 216891 0 0 2934 49.275 49.109 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19662 861957822 QTUNE sqlplus - Copy.exe
80 2002 2012-12-21/10:08:59 1 3267771367 30 5 138 0 0 2 289868 0 0 1970 0.679 0.671 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 192 1552172736 QTUNE sqlplus - Copy.exe
81 2002 2012-12-21/10:08:59 1 3427378629 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
82 2003 2012-12-21/10:09:18 1 24296316 30 3 12 0 0 3 15180 0 0 126 0.038 0.047 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
83 2003 2012-12-21/10:09:18 1 142578110 30 1 609 1 0 0 111231 0 0 9114 4.447 4.384 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
84 2003 2012-12-21/10:09:18 1 657302870 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20199 1788880094 QTUNE sqlplus - Copy.exe
85 2003 2012-12-21/10:09:18 1 1186590923 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
86 2003 2012-12-21/10:09:18 1 1503269649 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
87 2003 2012-12-21/10:09:18 1 1637264670 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
88 2003 2012-12-21/10:09:18 1 2816325939 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19662 861957822 QTUNE sqlplus - Copy.exe
89 2003 2012-12-21/10:09:18 1 3267771367 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 192 1552172736 QTUNE sqlplus - Copy.exe
90 2003 2012-12-21/10:09:18 1 3427378629 30 2 126 1 0 0 222462 0 0 1844 8.960 8.939 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
91 2004 2012-12-21/10:09:34 1 24296316 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
92 2004 2012-12-21/10:09:34 1 142578110 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
93 2004 2012-12-21/10:09:34 1 657302870 30 1 609 1 0 0 51549 0 0 9114 2.048 2.044 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20205 1783579615 QTUNE sqlplus - Copy.exe
94 2004 2012-12-21/10:09:34 1 1186590923 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
95 2004 2012-12-21/10:09:34 1 1503269649 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
96 2004 2012-12-21/10:09:34 1 1637264670 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
97 2004 2012-12-21/10:09:34 1 2816325939 30 2 126 1 0 0 41286 0 0 1844 7.981 7.925 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1783579615 QTUNE sqlplus - Copy.exe
98 2004 2012-12-21/10:09:34 1 3267771367 30 3 12 0 0 3 15438 0 0 126 0.039 0.047 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2623 1783579615 QTUNE sqlplus - Copy.exe
99 2004 2012-12-21/10:09:34 1 3427378629 30 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
100 2005 2012-12-21/10:09:50 1 24296316 33 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
101 2005 2012-12-21/10:09:50 1 142578110 33 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
102 2005 2012-12-21/10:09:50 1 657302870 33 1 609 0 0 2 51555 0 0 9114 2.044 2.044 0.000 0.000 0.000 0.000 0.000 0.000 FIRST_ROWS 20199 294135021 QTUNE sqlplus - Copy.exe
103 2005 2012-12-21/10:09:50 1 1186590923 33 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
104 2005 2012-12-21/10:09:50 1 1503269649 33 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
105 2005 2012-12-21/10:09:50 1 1637264670 33 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
106 2005 2012-12-21/10:09:50 1 2816325939 33 2 126 1 0 2 41292 0 0 1844 8.090 8.034 0.000 0.000 0.000 0.000 0.000 0.000 FIRST_ROWS 19614 294135021 QTUNE sqlplus - Copy.exe
107 2005 2012-12-21/10:09:50 1 3267771367 33 3 12 1 0 2 15444 0 0 126 0.066 0.062 0.000 0.000 0.000 0.000 0.000 0.000 FIRST_ROWS 2591 294135021 QTUNE sqlplus - Copy.exe
108 2005 2012-12-21/10:09:50 1 3427378629 33 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
109 2006 2012-12-21/10:11:08 1 24296316 35 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
110 2006 2012-12-21/10:11:08 1 142578110 35 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
111 2006 2012-12-21/10:11:08 1 657302870 35 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 FIRST_ROWS 20199 294135021 QTUNE sqlplus - Copy.exe
112 2006 2012-12-21/10:11:08 1 1186590923 35 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
113 2006 2012-12-21/10:11:08 1 1503269649 35 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
114 2006 2012-12-21/10:11:08 1 1637264670 35 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
115 2006 2012-12-21/10:11:08 1 2816325939 35 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 FIRST_ROWS 19614 294135021 QTUNE sqlplus - Copy.exe
116 2006 2012-12-21/10:11:08 1 3267771367 35 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 FIRST_ROWS 2591 294135021 QTUNE sqlplus - Copy.exe
117 2006 2012-12-21/10:11:08 1 3322900607 35 6 8031 0 0 97 664682 78942 0 120328 182.622 37.050 144.868 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 3180 806877927 QTUNE sqlplus - Copy.exe
118 2006 2012-12-21/10:11:08 1 3427378629 35 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
119 2007 2012-12-21/10:11:36 1 24296316 38 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
120 2007 2012-12-21/10:11:36 1 142578110 38 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
121 2007 2012-12-21/10:11:36 1 657302870 38 1 609 0 0 2 51555 0 0 9114 2.072 2.028 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20199 1327401543 QTUNE sqlplus - Copy.exe
122 2007 2012-12-21/10:11:36 1 1186590923 38 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
123 2007 2012-12-21/10:11:36 1 1503269649 38 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
124 2007 2012-12-21/10:11:36 1 1637264670 38 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
125 2007 2012-12-21/10:11:36 1 2816325939 38 2 126 1 0 2 41292 0 0 1844 8.194 8.221 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1327401543 QTUNE sqlplus - Copy.exe
126 2007 2012-12-21/10:11:36 1 2903038705 38 3 12 1 0 2 45399 0 0 126 11.880 11.856 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19129 1327401543 QTUNE sqlplus - Copy.exe
127 2007 2012-12-21/10:11:36 1 3267771367 38 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 FIRST_ROWS 2591 294135021 QTUNE sqlplus - Copy.exe
128 2007 2012-12-21/10:11:36 1 3322900607 38 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 3180 806877927 QTUNE sqlplus - Copy.exe
129 2007 2012-12-21/10:11:36 1 3427378629 38 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
130 2008 2012-12-21/10:12:31 1 24296316 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2769 1763851670 QTUNE sqlplus - Copy.exe
131 2008 2012-12-21/10:12:31 1 142578110 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
132 2008 2012-12-21/10:12:31 1 657302870 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20199 1327401543 QTUNE sqlplus - Copy.exe
133 2008 2012-12-21/10:12:31 1 737414948 41 3 735 1 0 4 896859 0 0 10958 24.925 24.804 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 15964 1219798382 QTUNE sqlplus - Copy.exe
134 2008 2012-12-21/10:12:31 1 1186590923 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21128 1788880094 QTUNE sqlplus - Copy.exe
135 2008 2012-12-21/10:12:31 1 1503269649 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20997 1788880094 QTUNE sqlplus - Copy.exe
136 2008 2012-12-21/10:12:31 1 1637264670 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20072 1552172736 QTUNE sqlplus - Copy.exe
137 2008 2012-12-21/10:12:31 1 2816325939 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1327401543 QTUNE sqlplus - Copy.exe
138 2008 2012-12-21/10:12:31 1 2903038705 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19129 1327401543 QTUNE sqlplus - Copy.exe
139 2008 2012-12-21/10:12:31 1 3267771367 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 FIRST_ROWS 2591 294135021 QTUNE sqlplus - Copy.exe
140 2008 2012-12-21/10:12:31 1 3314618365 41 3 12 1 0 2 894648 0 0 126 24.771 24.664 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 15863 1219798382 QTUNE sqlplus - Copy.exe
141 2008 2012-12-21/10:12:31 1 3322900607 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 3180 806877927 QTUNE sqlplus - Copy.exe
142 2008 2012-12-21/10:12:31 1 3427378629 41 0 0 0 0 0 0 0 0 0 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21701 1763851670 QTUNE sqlplus - Copy.exe
143 2022 2012-12-22/08:00:34 1 24296316 19 1 4 0 1 1 5066 0 0 42 0.026 0.016 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2683 1763851670 QTUNE SQL*Plus
144 2022 2012-12-22/08:00:34 1 657302870 19 5 3045 3 3 5 257797 26314 0 45570 13.621 10.764 2.875 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20199 1783579615 QTUNE SQL*Plus
145 2022 2012-12-22/08:00:34 1 1186590923 19 2 4824 2 2 2 306416 0 0 72328 9.264 9.220 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 21136 1788880094 QTUNE SQL*Plus
146 2022 2012-12-22/08:00:34 1 1503269649 19 2 3792 0 1 3 249824 0 0 56822 8.902 8.939 0.000 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20990 1788880094 QTUNE SQL*Plus
147 2022 2012-12-22/08:00:34 1 1637264670 19 1 609 0 1 2 61302 13189 0 9114 2.273 2.044 0.175 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 20062 1552172736 QTUNE SQL*Plus
148 2022 2012-12-22/08:00:34 1 2816325939 19 10 388 4 4 10 192846 26562 0 5616 41.003 40.420 0.531 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1783579615 QTUNE SQL*Plus
149 2022 2012-12-22/08:00:34 1 3267771367 19 13 158 10 10 12 310866 20488 0 2138 54.995 2.231 53.130 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 2591 1783579615 QTUNE SQL*Plus
150 2080 2012-12-26/16:00:07 1 2816325939 1 2 126 0 0 2 42071 30549 0 1844 9.502 8.268 1.237 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 19614 1788880094 QTUNE SQL*Plus
# Snap
ID
Snaphot Inst
ID
Plan HV Vers
Cnt
Execs Fetch Loads Inval Parse
Calls
Buffer
Gets
Disk
Reads
Direct
Writes
Rows
Proc
Elapsed
Time
(secs)
CPU
Time
(secs)
IO
Time
(secs)
Conc
Time
(secs)
Appl
Time
(secs)
Clus
Time
(secs)
PLSQL
Time
(secs)
Java
Time
(secs)
Optimizer
Mode
Cost Opt Env HV Parsing
Schema
Name
Module Action Profile

Active Session History by Plan (GV$ACTIVE_SESSION_HISTORY)

Snapshots counts per Plan and Wait Event for f995z9antmhxn.
This section includes data captured by AWR.
# Plan
Hash
Value
Session
State
Wait
Class
Event Snaps
Count
1 2816325939 ON CPU 9
# Plan
Hash
Value
Session
State
Wait
Class
Event Snaps
Count

Active Session History by Plan Line (GV$ACTIVE_SESSION_HISTORY)

Snapshots counts per Plan Line and Wait Event for f995z9antmhxn.
This section includes data captured by AWR.
Available on 11g or higher..
# 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 8 TABLE ACCESS FULL QTUNE SALES_ORDER ON CPU 1
2 2816325939 11 HASH GROUP BY ON CPU 5
3 2816325939 12 HASH JOIN ON CPU 3
# 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

AWR Active Session History by Plan (DBA_HIST_ACTIVE_SESS_HISTORY)

Snapshots counts per Plan and Wait Event for f995z9antmhxn.
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.
# Plan
Hash
Value
Session
State
Wait
Class
Event Snaps
Count
1 142578110 ON CPU 5
2 657302870 ON CPU 5
3 657302870 WAITING User I/O direct path read 1
4 737414948 ON CPU 2
5 1186590923 ON CPU 15
6 1186590923 WAITING User I/O db file parallel read 1
7 1503269649 ON CPU 5
8 1503269649 WAITING User I/O db file parallel read 1
9 1637264670 ON CPU 2
10 2816325939 ON CPU 27
11 2903038705 ON CPU 2
12 3267771367 WAITING User I/O db file sequential read 7
13 3267771367 WAITING User I/O db file scattered read 5
14 3314618365 ON CPU 2
15 3322900607 WAITING User I/O direct path read 30
16 3427378629 ON CPU 3
# Plan
Hash
Value
Session
State
Wait
Class
Event Snaps
Count

AWR Active Session History by Plan Line (DBA_HIST_ACTIVE_SESS_HISTORY)

Snapshots counts per Plan Line and Wait Event for f995z9antmhxn.
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.
Available on 11g or higher..
# 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 142578110 14 HASH GROUP BY ON CPU 2
2 142578110 15 HASH JOIN ON CPU 2
3 142578110 17 TABLE ACCESS FULL QTUNE ORDER_LINE ON CPU 1
4 657302870 11 HASH GROUP BY ON CPU 1
5 657302870 12 JOIN FILTER USE SYS :BF0000 ON CPU 1
6 657302870 13 HASH JOIN ON CPU 2
7 657302870 15 TABLE ACCESS FULL QTUNE ORDER_LINE ON CPU 1
8 657302870 15 TABLE ACCESS FULL QTUNE ORDER_LINE WAITING User I/O direct path read 85128 QTUNE.ORDER_LINE 1
9 737414948 9 SORT GROUP BY ON CPU 1
10 737414948 14 INDEX UNIQUE SCAN QTUNE CUSTOMER_PK ON CPU 1
11 1186590923 10 HASH GROUP BY ON CPU 10
12 1186590923 11 HASH JOIN ON CPU 3
13 1186590923 13 TABLE ACCESS FULL QTUNE ORDER_LINE ON CPU 2
14 1186590923 13 TABLE ACCESS FULL QTUNE ORDER_LINE WAITING User I/O db file parallel read 85128 QTUNE.ORDER_LINE 1
15 1503269649 7 HASH GROUP BY ON CPU 1
16 1503269649 8 HASH JOIN ON CPU 4
17 1503269649 10 TABLE ACCESS FULL QTUNE ORDER_LINE WAITING User I/O db file parallel read 85128 QTUNE.ORDER_LINE 1
18 1637264670 12 HASH GROUP BY ON CPU 1
19 1637264670 13 JOIN FILTER USE SYS :BF0000 ON CPU 1
20 2816325939 11 HASH GROUP BY ON CPU 17
21 2816325939 12 HASH JOIN ON CPU 8
22 2816325939 14 TABLE ACCESS FULL QTUNE ORDER_LINE ON CPU 2
23 2903038705 13 HASH GROUP BY ON CPU 2
24 3267771367 10 INDEX RANGE SCAN QTUNE SALES_ORDER_N2 WAITING User I/O db file scattered read 85126 QTUNE.SALES_ORDER_N2 1
25 3267771367 17 TABLE ACCESS BY INDEX ROWID QTUNE ORDER_LINE WAITING User I/O db file sequential read 85128 QTUNE.ORDER_LINE 5
26 3267771367 17 TABLE ACCESS BY INDEX ROWID QTUNE ORDER_LINE WAITING User I/O db file scattered read 85128 QTUNE.ORDER_LINE 3
27 3267771367 18 INDEX RANGE SCAN QTUNE ORDER_LINE_N1 WAITING User I/O db file scattered read 85130 QTUNE.ORDER_LINE_N1 1
28 3267771367 18 INDEX RANGE SCAN QTUNE ORDER_LINE_N1 WAITING User I/O db file sequential read 85130 QTUNE.ORDER_LINE_N1 1
29 3267771367 19 INDEX UNIQUE SCAN QTUNE PART_PK WAITING User I/O db file sequential read 85121 QTUNE.PART_PK 1
30 3314618365 10 SORT GROUP BY ON CPU 1
31 3314618365 11 HASH JOIN ON CPU 1
32 3322900607 24 TABLE ACCESS FULL QTUNE ORDER_LINE WAITING User I/O direct path read 85128 QTUNE.ORDER_LINE 30
33 3427378629 12 HASH GROUP BY ON CPU 1
34 3427378629 13 HASH JOIN ON CPU 1
35 3427378629 15 TABLE ACCESS FULL QTUNE ORDER_LINE ON CPU 1
# 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

Tables

CBO Statistics and relevant attributes.
# Table Name Owner Part DoP Temp Num Rows Sample
Size
Perc Last Analyzed Blocks Avg
Row
Len
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats
Perc Table
Cols
Indexes Index
Cols
1 CUSTOMER QTUNE NO 1 N 100000 100000 100.0 2012-12-21/10:05:20 802 92 YES NO NO 5 4 5
2 ORDER_LINE QTUNE NO 1 N 3450201 3450201 100.0 2012-12-21/10:05:26 13157 23 YES NO NO 6 3 3
3 PART QTUNE NO 1 N 200000 200000 100.0 2012-12-21/10:05:23 1430 58 YES NO NO 6 2 2
4 SALES_ORDER QTUNE NO 1 N 300000 300000 100.0 2012-12-21/10:05:23 1693 38 YES NO NO 6 3 4
# Table Name Owner Part DoP Temp Num Rows Sample
Size
Perc Last Analyzed Blocks Avg
Row
Len
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats
Perc Table
Cols
Indexes Index
Cols

Table Columns

Table Columns: CUSTOMER (QTUNE)

CBO Statistics and relevant attributes.
# Indexes Col
ID
Column Name Data
Type
Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
1 1 1 CUSTOMER_ID NUMBER 100000 0 100000 100.0 100000 C102 C30B 2012-12-21/10:05:19 5 1.000000e-05 1 NONE YES NO
2 1 2 CUSTOMER_NAME VARCHAR2 100000 0 100000 100.0 99624 41414145474A5150524E4A4C594F5357524C49434D5A524B4A56414E504D5141 5A5A5A56515A595251564243455A4C4A4A4A5241495856524E4B414D45584149 2012-12-21/10:05:19 41 1.003774e-05 1 NONE YES NO
3 1 3 CUSTOMER_TYPE VARCHAR2 100000 0 6385 6.4 6 31 36 2012-12-21/10:05:19 2 5.024756e-06 6 FREQUENCY YES NO
4 1 4 CREDIT_LIMIT NUMBER 100000 14285 5451 6.4 101 C20B C30B0B 2012-12-21/10:05:19 4 5.885721e-06 101 FREQUENCY YES NO
5 1 SYS_NC00005$ VARCHAR2 100000 0 100000 100.0 99728 61616165676A7170726E6A6C796F7377726C69636D7A726B6A76616E706D7161 7A7A7A76717A797271766263657A6C6A6A6A7261697876726E6B616D65786169 2012-12-21/10:05:19 41 1.002727e-05 1 NONE YES NO
# Indexes Col
ID
Column Name Data
Type
Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats

Table Columns: ORDER_LINE (QTUNE)

CBO Statistics and relevant attributes.
# Indexes Col
ID
Column Name Data
Type
Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
6 1 1 LINE_ID NUMBER 3450201 0 3450201 100.0 3450201 C102 C4042E0302 2012-12-21/10:05:25 6 2.898382e-07 1 NONE YES NO
7 1 2 ORDER_ID NUMBER 3450201 0 3450201 100.0 302976 C102 C31F 2012-12-21/10:05:25 5 3.300591e-06 1 NONE YES NO
8 1 4 PART_ID NUMBER 3450201 0 3450201 100.0 201968 C102 C315 2012-12-21/10:05:25 5 4.951279e-06 1 NONE YES NO
9 0 3 LINE_NUM NUMBER 3450201 0 3450201 100.0 21 C102 C116 2012-12-21/10:05:25 3 4.761905e-02 1 NONE YES NO
10 0 5 QUANTITY NUMBER 3450201 0 3450201 100.0 52 80 C134 2012-12-21/10:05:25 3 1.923077e-02 1 NONE YES NO
11 0 6 DISCOUNT_PERC NUMBER 3450201 2760161 690040 100.0 11 C106 C138 2012-12-21/10:05:25 2 9.090909e-02 1 NONE YES NO
# Indexes Col
ID
Column Name Data
Type
Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats

Table Columns: PART (QTUNE)

CBO Statistics and relevant attributes.
# Indexes Col
ID
Column Name Data
Type
Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
12 1 1 PART_ID NUMBER 200000 0 200000 100.0 200000 C102 C315 2012-12-21/10:05:22 5 5.000000e-06 1 NONE YES NO
13 1 2 PART_NAME VARCHAR2 200000 0 200000 100.0 200000 303030345336454F4646454556524D425357334E513739315056505A3352 5A5A5A55434E34553856575739464C4D4947504239394535514834373435 2012-12-21/10:05:22 31 5.000000e-06 1 NONE YES NO
14 0 3 PART_TYPE VARCHAR2 200000 0 200000 100.0 10 41 4A 2012-12-21/10:05:22 2 1.000000e-01 1 NONE YES NO
15 0 4 PART_PRICE NUMBER 200000 0 200000 100.0 124536 80 C2314C48 2012-12-21/10:05:22 5 8.029807e-06 1 NONE YES NO
16 0 5 ON_HAND NUMBER 200000 0 200000 100.0 6 80 C106 2012-12-21/10:05:22 3 1.666667e-01 1 NONE YES NO
17 0 SYS_STUUS4P4NZTNB5ELB$CFTBUVDQ NUMBER 200000 0 200000 100.0 46 C955160F2F153D3A2D0B CA1324560925021B181A4E 2012-12-21/10:05:22 12 2.173913e-02 1 NONE YES NO
# Indexes Col
ID
Column Name Data
Type
Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats

Table Columns: SALES_ORDER (QTUNE)

CBO Statistics and relevant attributes.
# Indexes Col
ID
Column Name Data
Type
Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
18 1 1 ORDER_ID NUMBER 300000 0 300000 100.0 300000 C102 C31F 2012-12-21/10:05:23 5 3.333333e-06 1 NONE YES NO
19 1 2 ORDER_NUM VARCHAR2 300000 0 300000 100.0 299840 4141303033363637303230353734 5A5A393939303431373136333033 2012-12-21/10:05:23 15 3.335112e-06 1 NONE YES NO
20 1 3 ORDER_DATE DATE 300000 0 300000 100.0 1002 786E020A010101 78700B07010101 2012-12-21/10:05:23 8 9.980040e-04 1 NONE YES NO
21 1 4 CUSTOMER_ID NUMBER 300000 0 300000 100.0 95952 C102 C30A6464 2012-12-21/10:05:23 5 1.042188e-05 1 NONE YES NO
22 0 5 STATUS VARCHAR2 300000 0 5366 1.8 10 51 5A 2012-12-21/10:05:23 2 1.708287e-06 9 FREQUENCY YES NO
23 0 SYS_STUK0XJTEZVXUTGW1H0VTZ#WQA VARCHAR2 300000 0 300000 100.0 676 4141 5A5A 2012-12-21/10:05:23 3 1.479290e-03 1 NONE YES NO
# Indexes Col
ID
Column Name Data
Type
Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats

Indexes

Indexes: CUSTOMER (QTUNE)

CBO Statistics and relevant attributes.
# Index Name Owner Index Type Part DoP Temp Uniqueness Cols Num
Rows
Sample
Size
Perc Last Analyzed Distinct
Keys
Blevel Leaf
Blocks
Avg
Leaf
Blocks
per Key
Avg
Data
Blocks
per Key
Clustering
Factor
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats
1 CUSTOMER_F1 QTUNE FUNCTION-BASED NORMAL NO 1 N NONUNIQUE 1 100000 100000 100.0 2012-12-21/10:05:22 99728 2 725 1 1 99881 YES NO NO
2 CUSTOMER_N1 QTUNE NORMAL NO 1 N NONUNIQUE 1 100000 100000 100.0 2012-12-21/10:05:22 99624 2 725 1 1 99881 YES NO NO
3 CUSTOMER_N2 QTUNE NORMAL NO 1 N NONUNIQUE 2 100000 100000 100.0 2012-12-21/10:05:22 446 1 229 1 162 72410 YES NO NO
4 CUSTOMER_PK QTUNE NORMAL NO 1 N UNIQUE 1 100000 100000 100.0 2012-12-21/10:05:22 100000 1 208 1 1 780 YES NO NO
# Index Name Owner Index Type Part DoP Temp Uniqueness Cols Num
Rows
Sample
Size
Perc Last Analyzed Distinct
Keys
Blevel Leaf
Blocks
Avg
Leaf
Blocks
per Key
Avg
Data
Blocks
per Key
Clustering
Factor
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats

Indexes: ORDER_LINE (QTUNE)

CBO Statistics and relevant attributes.
# Index Name Owner Index Type Part DoP Temp Uniqueness Cols Num
Rows
Sample
Size
Perc Last Analyzed Distinct
Keys
Blevel Leaf
Blocks
Avg
Leaf
Blocks
per Key
Avg
Data
Blocks
per Key
Clustering
Factor
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats
5 ORDER_LINE_N1 QTUNE NORMAL NO 1 N NONUNIQUE 1 3400013 499714 14.7 2012-12-21/10:05:28 302976 2 7559 1 11 3398414 YES NO NO
6 ORDER_LINE_N2 QTUNE NORMAL NO 1 N NONUNIQUE 1 3555812 523416 14.7 2012-12-21/10:05:29 201968 2 7887 1 17 3553488 YES NO NO
7 ORDER_LINE_PK QTUNE NORMAL NO 1 N UNIQUE 1 3366619 503175 14.9 2012-12-21/10:05:27 3366619 2 7353 1 1 18895 YES NO NO
# Index Name Owner Index Type Part DoP Temp Uniqueness Cols Num
Rows
Sample
Size
Perc Last Analyzed Distinct
Keys
Blevel Leaf
Blocks
Avg
Leaf
Blocks
per Key
Avg
Data
Blocks
per Key
Clustering
Factor
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats

Indexes: PART (QTUNE)

CBO Statistics and relevant attributes.
# Index Name Owner Index Type Part DoP Temp Uniqueness Cols Num
Rows
Sample
Size
Perc Last Analyzed Distinct
Keys
Blevel Leaf
Blocks
Avg
Leaf
Blocks
per Key
Avg
Data
Blocks
per Key
Clustering
Factor
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats
8 PART_N1 QTUNE NORMAL NO 1 N NONUNIQUE 1 200000 200000 100.0 2012-12-21/10:05:23 200000 2 1170 1 1 199846 YES NO NO
9 PART_PK QTUNE NORMAL NO 1 N UNIQUE 1 200000 200000 100.0 2012-12-21/10:05:23 200000 1 417 1 1 1398 YES NO NO
# Index Name Owner Index Type Part DoP Temp Uniqueness Cols Num
Rows
Sample
Size
Perc Last Analyzed Distinct
Keys
Blevel Leaf
Blocks
Avg
Leaf
Blocks
per Key
Avg
Data
Blocks
per Key
Clustering
Factor
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats

Indexes: SALES_ORDER (QTUNE)

CBO Statistics and relevant attributes.
# Index Name Owner Index Type Part DoP Temp Uniqueness Cols Num
Rows
Sample
Size
Perc Last Analyzed Distinct
Keys
Blevel Leaf
Blocks
Avg
Leaf
Blocks
per Key
Avg
Data
Blocks
per Key
Clustering
Factor
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats
10 SALES_ORDER_N1 QTUNE NORMAL NO 1 N NONUNIQUE 1 300000 300000 100.0 2012-12-21/10:05:24 299840 2 1087 1 1 299837 YES NO NO
11 SALES_ORDER_N2 QTUNE NORMAL NO 1 N NONUNIQUE 2 300000 300000 100.0 2012-12-21/10:05:25 299533 2 1000 1 1 299800 YES NO NO
12 SALES_ORDER_PK QTUNE NORMAL NO 1 N UNIQUE 1 300000 300000 100.0 2012-12-21/10:05:24 300000 1 625 1 1 1657 YES NO NO
# Index Name Owner Index Type Part DoP Temp Uniqueness Cols Num
Rows
Sample
Size
Perc Last Analyzed Distinct
Keys
Blevel Leaf
Blocks
Avg
Leaf
Blocks
per Key
Avg
Data
Blocks
per Key
Clustering
Factor
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats

Index Columns

Index Columns: CUSTOMER (QTUNE)

CBO Statistics and relevant attributes.
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
1 CUSTOMER_F1 1 SYS_NC00005$ ASC 100000 0 100000 100.0 99728 61616165676A7170726E6A6C796F7377726C69636D7A726B6A76616E706D7161 7A7A7A76717A797271766263657A6C6A6A6A7261697876726E6B616D65786169 2012-12-21/10:05:19 41 1.002727e-05 1 NONE YES NO
2 CUSTOMER_N1 1 2 CUSTOMER_NAME ASC 100000 0 100000 100.0 99624 41414145474A5150524E4A4C594F5357524C49434D5A524B4A56414E504D5141 5A5A5A56515A595251564243455A4C4A4A4A5241495856524E4B414D45584149 2012-12-21/10:05:19 41 1.003774e-05 1 NONE YES NO
3 CUSTOMER_N2 1 3 CUSTOMER_TYPE ASC 100000 0 6385 6.4 6 31 36 2012-12-21/10:05:19 2 5.024756e-06 6 FREQUENCY YES NO
4 CUSTOMER_N2 2 4 CREDIT_LIMIT ASC 100000 14285 5451 6.4 101 C20B C30B0B 2012-12-21/10:05:19 4 5.885721e-06 101 FREQUENCY YES NO
5 CUSTOMER_PK 1 1 CUSTOMER_ID ASC 100000 0 100000 100.0 100000 C102 C30B 2012-12-21/10:05:19 5 1.000000e-05 1 NONE YES NO
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats

Index Columns: ORDER_LINE (QTUNE)

CBO Statistics and relevant attributes.
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
6 ORDER_LINE_N1 1 2 ORDER_ID ASC 3450201 0 3450201 100.0 302976 C102 C31F 2012-12-21/10:05:25 5 3.300591e-06 1 NONE YES NO
7 ORDER_LINE_N2 1 4 PART_ID ASC 3450201 0 3450201 100.0 201968 C102 C315 2012-12-21/10:05:25 5 4.951279e-06 1 NONE YES NO
8 ORDER_LINE_PK 1 1 LINE_ID ASC 3450201 0 3450201 100.0 3450201 C102 C4042E0302 2012-12-21/10:05:25 6 2.898382e-07 1 NONE YES NO
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats

Index Columns: PART (QTUNE)

CBO Statistics and relevant attributes.
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
9 PART_N1 1 2 PART_NAME ASC 200000 0 200000 100.0 200000 303030345336454F4646454556524D425357334E513739315056505A3352 5A5A5A55434E34553856575739464C4D4947504239394535514834373435 2012-12-21/10:05:22 31 5.000000e-06 1 NONE YES NO
10 PART_PK 1 1 PART_ID ASC 200000 0 200000 100.0 200000 C102 C315 2012-12-21/10:05:22 5 5.000000e-06 1 NONE YES NO
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats

Index Columns: SALES_ORDER (QTUNE)

CBO Statistics and relevant attributes.
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
11 SALES_ORDER_N1 1 2 ORDER_NUM ASC 300000 0 300000 100.0 299840 4141303033363637303230353734 5A5A393939303431373136333033 2012-12-21/10:05:23 15 3.335112e-06 1 NONE YES NO
12 SALES_ORDER_N2 1 4 CUSTOMER_ID ASC 300000 0 300000 100.0 95952 C102 C30A6464 2012-12-21/10:05:23 5 1.042188e-05 1 NONE YES NO
13 SALES_ORDER_N2 2 3 ORDER_DATE ASC 300000 0 300000 100.0 1002 786E020A010101 78700B07010101 2012-12-21/10:05:23 8 9.980040e-04 1 NONE YES NO
14 SALES_ORDER_PK 1 1 ORDER_ID ASC 300000 0 300000 100.0 300000 C102 C31F 2012-12-21/10:05:23 5 3.333333e-06 1 NONE YES NO
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats

System Parameters with Non-Default or Modified Values

Collected from GV$SYSTEM_PARAMETER2 where isdefault = 'FALSE' OR ismodified != 'FALSE'. "Is Default" = FALSE means the parameter was set in the spfile.
# Name Inst Ord Is
Default
Is
Modified
Value Display
Value
Description
1 _cursor_bind_capture_interval 1 1 FALSE FALSE 900 interval (in seconds) between two bind capture for a cursor
2 audit_file_dest 1 1 FALSE FALSE D:\APP\CSIERRA\ADMIN\ORCL\ADUMP Directory in which auditing files are to reside
3 audit_trail 1 1 FALSE FALSE DB enable system auditing
4 compatible 1 1 FALSE FALSE 11.2.0.0.0 Database will be completely compatible with this software version
5 control_files 1 1 FALSE FALSE D:\APP\CSIERRA\ORADATA\ORCL\CONTROL01.CTL control file names list
6 control_files 1 2 FALSE FALSE D:\APP\CSIERRA\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL control file names list
7 db_block_size 1 1 FALSE FALSE 8192 Size of database block in bytes
8 db_domain 1 1 FALSE FALSE us.oracle.com directory part of global database name stored with CREATE DATABASE
9 db_name 1 1 FALSE FALSE orcl database name specified in CREATE DATABASE
10 db_recovery_file_dest 1 1 FALSE FALSE D:\app\csierra\fast_recovery_area default database recovery file location
11 db_recovery_file_dest_size 1 1 FALSE FALSE 4322230272 4122M database recovery files size limit
12 diagnostic_dest 1 1 FALSE FALSE D:\APP\CSIERRA diagnostic base directory
13 dispatchers 1 1 FALSE FALSE (PROTOCOL=TCP) (SERVICE=orclXDB) specifications of dispatchers
14 local_listener 1 1 FALSE FALSE LISTENER_ORCL local listener
15 open_cursors 1 1 FALSE FALSE 300 max # cursors per session
16 optimizer_secure_view_merging 1 1 FALSE FALSE TRUE optimizer secure view merging and predicate pushdown/movearound
17 pga_aggregate_target 1 1 FALSE FALSE 846200832 807M Target size for the aggregate PGA memory consumed by the instance
18 processes 1 1 FALSE FALSE 150 user processes
19 remote_login_passwordfile 1 1 FALSE FALSE EXCLUSIVE password file usage parameter
20 sga_target 1 1 FALSE FALSE 2550136832 2432M Target size of SGA
21 undo_tablespace 1 1 FALSE FALSE UNDOTBS1 use/switch undo tablespace
# Name Inst Ord Is
Default
Is
Modified
Value Display
Value
Description

Instance Parameters

System Parameters collected from V$SYSTEM_PARAMETER2 for Instance number 1.
# Name Ord Is
Default
Is
Modified
Value Display
Value
Description
1 O7_DICTIONARY_ACCESSIBILITY 1 TRUE FALSE FALSE Version 7 Dictionary Accessibility Support
2 _cursor_bind_capture_interval 1 FALSE FALSE 900 interval (in seconds) between two bind capture for a cursor
3 active_instance_count 0 TRUE FALSE number of active instances in the cluster database
4 aq_tm_processes 1 TRUE FALSE 1 number of AQ Time Managers to start
5 archive_lag_target 1 TRUE FALSE 0 Maximum number of seconds of redos the standby could lose
6 asm_diskgroups 0 TRUE FALSE disk groups to mount automatically
7 asm_diskstring 0 TRUE FALSE disk set locations for discovery
8 asm_power_limit 1 TRUE FALSE 1 number of parallel relocations for disk rebalancing
9 asm_preferred_read_failure_groups 0 TRUE FALSE preferred read failure groups
10 audit_file_dest 1 FALSE FALSE D:\APP\CSIERRA\ADMIN\ORCL\ADUMP Directory in which auditing files are to reside
11 audit_sys_operations 1 TRUE FALSE FALSE enable sys auditing
12 audit_trail 1 FALSE FALSE DB enable system auditing
13 awr_snapshot_time_offset 1 TRUE FALSE 0 Setting for AWR Snapshot Time Offset
14 background_core_dump 1 TRUE FALSE partial Core Size for Background Processes
15 background_dump_dest 1 TRUE FALSE D:\app\csierra\diag\rdbms\orcl\orcl\trace Detached process dump directory
16 backup_tape_io_slaves 1 TRUE FALSE FALSE BACKUP Tape I/O slaves
17 bitmap_merge_area_size 1 TRUE FALSE 1048576 maximum memory allow for BITMAP MERGE
18 blank_trimming 1 TRUE FALSE FALSE blank trimming semantics parameter
19 buffer_pool_keep 1 TRUE FALSE Number of database blocks/latches in keep buffer pool
20 buffer_pool_recycle 1 TRUE FALSE Number of database blocks/latches in recycle buffer pool
21 cell_offload_compaction 1 TRUE FALSE ADAPTIVE Cell packet compaction strategy
22 cell_offload_decryption 1 TRUE FALSE TRUE enable SQL processing offload of encrypted data to cells
23 cell_offload_parameters 1 TRUE FALSE Additional cell offload parameters
24 cell_offload_plan_display 1 TRUE FALSE AUTO Cell offload explain plan display
25 cell_offload_processing 1 TRUE FALSE TRUE enable SQL processing offload to cells
26 circuits 0 TRUE FALSE max number of circuits
27 client_result_cache_lag 1 TRUE FALSE 3000 client result cache maximum lag in milliseconds
28 client_result_cache_size 1 TRUE FALSE 0 client result cache max size in bytes
29 clonedb 1 TRUE FALSE FALSE clone database
30 cluster_database 1 TRUE FALSE FALSE if TRUE startup in cluster database mode
31 cluster_database_instances 1 TRUE FALSE 1 number of instances to use for sizing cluster db SGA structures
32 cluster_interconnects 0 TRUE FALSE interconnects for RAC use
33 commit_logging 0 TRUE FALSE transaction commit log write behaviour
34 commit_point_strength 1 TRUE FALSE 1 Bias this node has toward not preparing in a two-phase commit
35 commit_wait 0 TRUE FALSE transaction commit log wait behaviour
36 commit_write 0 TRUE FALSE transaction commit log write behaviour
37 compatible 1 FALSE FALSE 11.2.0.0.0 Database will be completely compatible with this software version
38 control_file_record_keep_time 1 TRUE FALSE 7 control file record keep time in days
39 control_files 1 FALSE FALSE D:\APP\CSIERRA\ORADATA\ORCL\CONTROL01.CTL control file names list
40 control_files 2 FALSE FALSE D:\APP\CSIERRA\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL control file names list
41 control_management_pack_access 1 TRUE FALSE DIAGNOSTIC+TUNING declares which manageability packs are enabled
42 core_dump_dest 1 TRUE FALSE D:\app\csierra\diag\rdbms\orcl\orcl\cdump Core dump directory
43 cpu_count 1 TRUE FALSE 4 number of CPUs for this instance
44 create_bitmap_area_size 1 TRUE FALSE 8388608 size of create bitmap buffer for bitmap index
45 create_stored_outlines 0 TRUE FALSE create stored outlines for DML statements
46 cursor_bind_capture_destination 1 TRUE FALSE memory+disk Allowed destination for captured bind variables
47 cursor_sharing 1 TRUE FALSE EXACT cursor sharing mode
48 cursor_space_for_time 1 TRUE FALSE FALSE use more memory in order to get faster execution
49 db_16k_cache_size 1 TRUE FALSE 0 Size of cache for 16K buffers
50 db_2k_cache_size 1 TRUE FALSE 0 Size of cache for 2K buffers
51 db_32k_cache_size 1 TRUE FALSE 0 Size of cache for 32K buffers
52 db_4k_cache_size 1 TRUE FALSE 0 Size of cache for 4K buffers
53 db_8k_cache_size 1 TRUE FALSE 0 Size of cache for 8K buffers
54 db_block_buffers 1 TRUE FALSE 0 Number of database blocks cached in memory
55 db_block_checking 1 TRUE FALSE FALSE header checking and data and index block checking
56 db_block_checksum 1 TRUE FALSE TYPICAL store checksum in db blocks and check during reads
57 db_block_size 1 FALSE FALSE 8192 Size of database block in bytes
58 db_cache_advice 1 TRUE FALSE ON Buffer cache sizing advisory
59 db_cache_size 1 TRUE FALSE 0 Size of DEFAULT buffer pool for standard block size buffers
60 db_create_file_dest 1 TRUE FALSE default database location
61 db_create_online_log_dest_1 1 TRUE FALSE online log/controlfile destination #1
62 db_create_online_log_dest_2 1 TRUE FALSE online log/controlfile destination #2
63 db_create_online_log_dest_3 1 TRUE FALSE online log/controlfile destination #3
64 db_create_online_log_dest_4 1 TRUE FALSE online log/controlfile destination #4
65 db_create_online_log_dest_5 1 TRUE FALSE online log/controlfile destination #5
66 db_domain 1 FALSE FALSE us.oracle.com directory part of global database name stored with CREATE DATABASE
67 db_file_multiblock_read_count 1 TRUE FALSE 128 db block to be read each IO
68 db_file_name_convert 0 TRUE FALSE datafile name convert patterns and strings for standby/clone db
69 db_files 1 TRUE FALSE 200 max allowable # db files
70 db_flash_cache_file 1 TRUE FALSE flash cache file for default block size
71 db_flash_cache_size 1 TRUE FALSE 0 flash cache size for db_flash_cache_file
72 db_flashback_retention_target 1 TRUE FALSE 1440 Maximum Flashback Database log retention time in minutes.
73 db_keep_cache_size 1 TRUE FALSE 0 Size of KEEP buffer pool for standard block size buffers
74 db_lost_write_protect 1 TRUE FALSE NONE enable lost write detection
75 db_name 1 FALSE FALSE orcl database name specified in CREATE DATABASE
76 db_recovery_file_dest 1 FALSE FALSE D:\app\csierra\fast_recovery_area default database recovery file location
77 db_recovery_file_dest_size 1 FALSE FALSE 4322230272 4122M database recovery files size limit
78 db_recycle_cache_size 1 TRUE FALSE 0 Size of RECYCLE buffer pool for standard block size buffers
79 db_securefile 1 TRUE FALSE PERMITTED permit securefile storage during lob creation
80 db_ultra_safe 1 TRUE FALSE OFF Sets defaults for other parameters that control protection levels
81 db_unique_name 1 TRUE FALSE orcl Database Unique Name
82 db_unrecoverable_scn_tracking 1 TRUE FALSE TRUE Track nologging SCN in controlfile
83 db_writer_processes 1 TRUE FALSE 1 number of background database writer processes to start
84 dbwr_io_slaves 1 TRUE FALSE 0 DBWR I/O slaves
85 ddl_lock_timeout 1 TRUE FALSE 0 timeout to restrict the time that ddls wait for dml lock
86 deferred_segment_creation 1 TRUE FALSE TRUE defer segment creation to first insert
87 dg_broker_config_file1 1 TRUE FALSE D:\APP\CSIERRA\PRODUCT\11.2.0\DBHOME_1\DATABASE\DR1ORCL.DAT data guard broker configuration file #1
88 dg_broker_config_file2 1 TRUE FALSE D:\APP\CSIERRA\PRODUCT\11.2.0\DBHOME_1\DATABASE\DR2ORCL.DAT data guard broker configuration file #2
89 dg_broker_start 1 TRUE FALSE FALSE start Data Guard broker (DMON process)
90 diagnostic_dest 1 FALSE FALSE D:\APP\CSIERRA diagnostic base directory
91 disk_asynch_io 1 TRUE FALSE TRUE Use asynch I/O for random access devices
92 dispatchers 1 FALSE FALSE (PROTOCOL=TCP) (SERVICE=orclXDB) specifications of dispatchers
93 distributed_lock_timeout 1 TRUE FALSE 60 number of seconds a distributed transaction waits for a lock
94 dml_locks 1 TRUE FALSE 1088 dml locks - one for each table modified in a transaction
95 dst_upgrade_insert_conv 1 TRUE FALSE TRUE Enables/Disables internal conversions during DST upgrade
96 enable_ddl_logging 1 TRUE FALSE FALSE enable ddl logging
97 event 1 TRUE FALSE debug event control - default null string
98 fal_client 1 TRUE FALSE FAL client
99 fal_server 1 TRUE FALSE FAL server list
100 fast_start_io_target 1 TRUE FALSE 0 Upper bound on recovery reads
101 fast_start_mttr_target 1 TRUE FALSE 0 MTTR target in seconds
102 fast_start_parallel_rollback 1 TRUE FALSE LOW max number of parallel recovery slaves that may be used
103 file_mapping 1 TRUE FALSE FALSE enable file mapping
104 fileio_network_adapters 0 TRUE FALSE Network Adapters for File I/O
105 filesystemio_options 0 TRUE FALSE IO operations on filesystem files
106 fixed_date 1 TRUE FALSE fixed SYSDATE value
107 gcs_server_processes 1 TRUE FALSE 0 number of background gcs server processes to start
108 global_context_pool_size 1 TRUE FALSE Global Application Context Pool Size in Bytes
109 global_names 1 TRUE FALSE FALSE enforce that database links have same name as remote database
110 global_txn_processes 1 TRUE FALSE 1 number of background global transaction processes to start
111 hash_area_size 1 TRUE FALSE 131072 size of in-memory hash work area
112 hi_shared_memory_address 1 TRUE FALSE 0 SGA starting address (high order 32-bits on 64-bit platforms)
113 hs_autoregister 1 TRUE FALSE TRUE enable automatic server DD updates in HS agent self-registration
114 ifile 0 TRUE FALSE include file in init.ora
115 instance_groups 0 TRUE FALSE list of instance group names
116 instance_name 1 TRUE FALSE orcl instance name supported by the instance
117 instance_number 1 TRUE FALSE 0 instance number
118 instance_type 1 TRUE FALSE RDBMS type of instance to be executed
119 java_jit_enabled 1 TRUE FALSE TRUE Java VM JIT enabled
120 java_max_sessionspace_size 1 TRUE FALSE 0 max allowed size in bytes of a Java sessionspace
121 java_pool_size 1 TRUE FALSE 0 size in bytes of java pool
122 java_soft_sessionspace_limit 1 TRUE FALSE 0 warning limit on size in bytes of a Java sessionspace
123 job_queue_processes 1 TRUE FALSE 1000 maximum number of job queue slave processes
124 large_pool_size 1 TRUE FALSE 0 size in bytes of large pool
125 ldap_directory_access 1 TRUE FALSE NONE RDBMS's LDAP access option
126 ldap_directory_sysauth 1 TRUE FALSE no OID usage parameter
127 license_max_sessions 1 TRUE FALSE 0 maximum number of non-system user sessions allowed
128 license_max_users 1 TRUE FALSE 0 maximum number of named users that can be created in the database
129 license_sessions_warning 1 TRUE FALSE 0 warning level for number of non-system user sessions
130 listener_networks 0 TRUE FALSE listener registration networks
131 local_listener 1 FALSE FALSE LISTENER_ORCL local listener
132 lock_name_space 0 TRUE FALSE lock name space used for generating lock names for standby/clone database
133 lock_sga 1 TRUE FALSE FALSE Lock entire SGA in physical memory
134 log_archive_config 1 TRUE FALSE log archive config parameter
135 log_archive_dest 1 TRUE FALSE archival destination text string
136 log_archive_dest_1 1 TRUE FALSE archival destination #1 text string
137 log_archive_dest_10 1 TRUE FALSE archival destination #10 text string
138 log_archive_dest_11 1 TRUE FALSE archival destination #11 text string
139 log_archive_dest_12 1 TRUE FALSE archival destination #12 text string
140 log_archive_dest_13 1 TRUE FALSE archival destination #13 text string
141 log_archive_dest_14 1 TRUE FALSE archival destination #14 text string
142 log_archive_dest_15 1 TRUE FALSE archival destination #15 text string
143 log_archive_dest_16 1 TRUE FALSE archival destination #16 text string
144 log_archive_dest_17 1 TRUE FALSE archival destination #17 text string
145 log_archive_dest_18 1 TRUE FALSE archival destination #18 text string
146 log_archive_dest_19 1 TRUE FALSE archival destination #19 text string
147 log_archive_dest_2 1 TRUE FALSE archival destination #2 text string
148 log_archive_dest_20 1 TRUE FALSE archival destination #20 text string
149 log_archive_dest_21 1 TRUE FALSE archival destination #21 text string
150 log_archive_dest_22 1 TRUE FALSE archival destination #22 text string
151 log_archive_dest_23 1 TRUE FALSE archival destination #23 text string
152 log_archive_dest_24 1 TRUE FALSE archival destination #24 text string
153 log_archive_dest_25 1 TRUE FALSE archival destination #25 text string
154 log_archive_dest_26 1 TRUE FALSE archival destination #26 text string
155 log_archive_dest_27 1 TRUE FALSE archival destination #27 text string
156 log_archive_dest_28 1 TRUE FALSE archival destination #28 text string
157 log_archive_dest_29 1 TRUE FALSE archival destination #29 text string
158 log_archive_dest_3 1 TRUE FALSE archival destination #3 text string
159 log_archive_dest_30 1 TRUE FALSE archival destination #30 text string
160 log_archive_dest_31 1 TRUE FALSE archival destination #31 text string
161 log_archive_dest_4 1 TRUE FALSE archival destination #4 text string
162 log_archive_dest_5 1 TRUE FALSE archival destination #5 text string
163 log_archive_dest_6 1 TRUE FALSE archival destination #6 text string
164 log_archive_dest_7 1 TRUE FALSE archival destination #7 text string
165 log_archive_dest_8 1 TRUE FALSE archival destination #8 text string
166 log_archive_dest_9 1 TRUE FALSE archival destination #9 text string
167 log_archive_dest_state_1 1 TRUE FALSE enable archival destination #1 state text string
168 log_archive_dest_state_10 1 TRUE FALSE enable archival destination #10 state text string
169 log_archive_dest_state_11 1 TRUE FALSE enable archival destination #11 state text string
170 log_archive_dest_state_12 1 TRUE FALSE enable archival destination #12 state text string
171 log_archive_dest_state_13 1 TRUE FALSE enable archival destination #13 state text string
172 log_archive_dest_state_14 1 TRUE FALSE enable archival destination #14 state text string
173 log_archive_dest_state_15 1 TRUE FALSE enable archival destination #15 state text string
174 log_archive_dest_state_16 1 TRUE FALSE enable archival destination #16 state text string
175 log_archive_dest_state_17 1 TRUE FALSE enable archival destination #17 state text string
176 log_archive_dest_state_18 1 TRUE FALSE enable archival destination #18 state text string
177 log_archive_dest_state_19 1 TRUE FALSE enable archival destination #19 state text string
178 log_archive_dest_state_2 1 TRUE FALSE enable archival destination #2 state text string
179 log_archive_dest_state_20 1 TRUE FALSE enable archival destination #20 state text string
180 log_archive_dest_state_21 1 TRUE FALSE enable archival destination #21 state text string
181 log_archive_dest_state_22 1 TRUE FALSE enable archival destination #22 state text string
182 log_archive_dest_state_23 1 TRUE FALSE enable archival destination #23 state text string
183 log_archive_dest_state_24 1 TRUE FALSE enable archival destination #24 state text string
184 log_archive_dest_state_25 1 TRUE FALSE enable archival destination #25 state text string
185 log_archive_dest_state_26 1 TRUE FALSE enable archival destination #26 state text string
186 log_archive_dest_state_27 1 TRUE FALSE enable archival destination #27 state text string
187 log_archive_dest_state_28 1 TRUE FALSE enable archival destination #28 state text string
188 log_archive_dest_state_29 1 TRUE FALSE enable archival destination #29 state text string
189 log_archive_dest_state_3 1 TRUE FALSE enable archival destination #3 state text string
190 log_archive_dest_state_30 1 TRUE FALSE enable archival destination #30 state text string
191 log_archive_dest_state_31 1 TRUE FALSE enable archival destination #31 state text string
192 log_archive_dest_state_4 1 TRUE FALSE enable archival destination #4 state text string
193 log_archive_dest_state_5 1 TRUE FALSE enable archival destination #5 state text string
194 log_archive_dest_state_6 1 TRUE FALSE enable archival destination #6 state text string
195 log_archive_dest_state_7 1 TRUE FALSE enable archival destination #7 state text string
196 log_archive_dest_state_8 1 TRUE FALSE enable archival destination #8 state text string
197 log_archive_dest_state_9 1 TRUE FALSE enable archival destination #9 state text string
198 log_archive_duplex_dest 1 TRUE FALSE duplex archival destination text string
199 log_archive_format 1 TRUE FALSE ARC%S_%R.%T archival destination format
200 log_archive_local_first 1 TRUE FALSE TRUE Establish EXPEDITE attribute default value
201 log_archive_max_processes 1 TRUE FALSE 4 maximum number of active ARCH processes
202 log_archive_min_succeed_dest 1 TRUE FALSE 1 minimum number of archive destinations that must succeed
203 log_archive_start 1 TRUE FALSE FALSE start archival process on SGA initialization
204 log_archive_trace 1 TRUE FALSE 0 Establish archivelog operation tracing level
205 log_buffer 1 TRUE FALSE 19193856 redo circular buffer size
206 log_checkpoint_interval 1 TRUE FALSE 0 # redo blocks checkpoint threshold
207 log_checkpoint_timeout 1 TRUE FALSE 1800 Maximum time interval between checkpoints in seconds
208 log_checkpoints_to_alert 1 TRUE FALSE FALSE log checkpoint begin/end to alert file
209 log_file_name_convert 0 TRUE FALSE logfile name convert patterns and strings for standby/clone db
210 max_dispatchers 0 TRUE FALSE max number of dispatchers
211 max_dump_file_size 1 TRUE FALSE unlimited Maximum size (in bytes) of dump file
212 max_enabled_roles 1 TRUE FALSE 150 max number of roles a user can have enabled
213 max_shared_servers 0 TRUE FALSE max number of shared servers
214 memory_max_target 1 TRUE FALSE 0 Max size for Memory Target
215 memory_target 1 TRUE FALSE 0 Target size of Oracle SGA and PGA memory
216 nls_calendar 1 TRUE FALSE NLS calendar system name
217 nls_comp 1 TRUE FALSE BINARY NLS comparison
218 nls_currency 1 TRUE FALSE NLS local currency symbol
219 nls_date_format 1 TRUE FALSE NLS Oracle date format
220 nls_date_language 1 TRUE FALSE NLS date language name
221 nls_dual_currency 1 TRUE FALSE Dual currency symbol
222 nls_iso_currency 1 TRUE FALSE NLS ISO currency territory name
223 nls_language 1 TRUE FALSE AMERICAN NLS language name
224 nls_length_semantics 1 TRUE FALSE BYTE create columns using byte or char semantics by default
225 nls_nchar_conv_excp 1 TRUE FALSE FALSE NLS raise an exception instead of allowing implicit conversion
226 nls_numeric_characters 1 TRUE FALSE NLS numeric characters
227 nls_sort 1 TRUE FALSE NLS linguistic definition name
228 nls_territory 1 TRUE FALSE AMERICA NLS territory name
229 nls_time_format 1 TRUE FALSE time format
230 nls_time_tz_format 1 TRUE FALSE time with timezone format
231 nls_timestamp_format 1 TRUE FALSE time stamp format
232 nls_timestamp_tz_format 1 TRUE FALSE timestamp with timezone format
233 object_cache_max_size_percent 1 TRUE FALSE 10 percentage of maximum size over optimal of the user session's object cache
234 object_cache_optimal_size 1 TRUE FALSE 102400 optimal size of the user session's object cache in bytes
235 olap_page_pool_size 1 TRUE FALSE 0 size of the olap page pool in bytes
236 open_cursors 1 FALSE FALSE 300 max # cursors per session
237 open_links 1 TRUE FALSE 4 max # open links per session
238 open_links_per_instance 1 TRUE FALSE 4 max # open links per instance
239 optimizer_capture_sql_plan_baselines 1 TRUE FALSE FALSE automatic capture of SQL plan baselines for repeatable statements
240 optimizer_dynamic_sampling 1 TRUE FALSE 2 optimizer dynamic sampling
241 optimizer_features_enable 1 TRUE FALSE 11.2.0.3 optimizer plan compatibility parameter
242 optimizer_index_caching 1 TRUE FALSE 0 optimizer percent index caching
243 optimizer_index_cost_adj 1 TRUE FALSE 100 optimizer index cost adjustment
244 optimizer_mode 1 TRUE FALSE ALL_ROWS optimizer mode
245 optimizer_secure_view_merging 1 FALSE FALSE TRUE optimizer secure view merging and predicate pushdown/movearound
246 optimizer_use_invisible_indexes 1 TRUE FALSE FALSE Usage of invisible indexes (TRUE/FALSE)
247 optimizer_use_pending_statistics 1 TRUE FALSE FALSE Control whether to use optimizer pending statistics
248 optimizer_use_sql_plan_baselines 1 TRUE FALSE TRUE use of SQL plan baselines for captured sql statements
249 os_authent_prefix 1 TRUE FALSE OPS$ prefix for auto-logon accounts
250 os_roles 1 TRUE FALSE FALSE retrieve roles from the operating system
251 parallel_adaptive_multi_user 1 TRUE FALSE TRUE enable adaptive setting of degree for multiple user streams
252 parallel_automatic_tuning 1 TRUE FALSE FALSE enable intelligent defaults for parallel execution parameters
253 parallel_degree_limit 1 TRUE FALSE CPU limit placed on degree of parallelism
254 parallel_degree_policy 1 TRUE FALSE MANUAL policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)
255 parallel_execution_message_size 1 TRUE FALSE 16384 message buffer size for parallel execution
256 parallel_force_local 1 TRUE FALSE FALSE force single instance execution
257 parallel_instance_group 1 TRUE FALSE instance group to use for all parallel operations
258 parallel_io_cap_enabled 1 TRUE FALSE FALSE enable capping DOP by IO bandwidth
259 parallel_max_servers 1 TRUE FALSE 135 maximum parallel query servers per instance
260 parallel_min_percent 1 TRUE FALSE 0 minimum percent of threads required for parallel query
261 parallel_min_servers 1 TRUE FALSE 0 minimum parallel query servers per instance
262 parallel_min_time_threshold 1 TRUE FALSE AUTO threshold above which a plan is a candidate for parallelization (in seconds)
263 parallel_server 1 TRUE FALSE FALSE if TRUE startup in parallel server mode
264 parallel_server_instances 1 TRUE FALSE 1 number of instances to use for sizing OPS SGA structures
265 parallel_servers_target 1 TRUE FALSE 64 instance target in terms of number of parallel servers
266 parallel_threads_per_cpu 1 TRUE FALSE 2 number of parallel execution threads per CPU
267 permit_92_wrap_format 1 TRUE FALSE TRUE allow 9.2 or older wrap format in PL/SQL
268 pga_aggregate_target 1 FALSE FALSE 846200832 807M Target size for the aggregate PGA memory consumed by the instance
269 plscope_settings 1 TRUE FALSE IDENTIFIERS:NONE plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data
270 plsql_ccflags 1 TRUE FALSE PL/SQL ccflags
271 plsql_code_type 1 TRUE FALSE INTERPRETED PL/SQL code-type
272 plsql_debug 1 TRUE FALSE FALSE PL/SQL debug
273 plsql_optimize_level 1 TRUE FALSE 2 PL/SQL optimize level
274 plsql_v2_compatibility 1 TRUE FALSE FALSE PL/SQL version 2.x compatibility flag
275 plsql_warnings 1 TRUE FALSE DISABLE:ALL PL/SQL compiler warnings settings
276 pre_page_sga 1 TRUE FALSE FALSE pre-page sga for process
277 processes 1 FALSE FALSE 150 user processes
278 processor_group_name 0 TRUE FALSE Name of the processor group that this instance should run in.
279 query_rewrite_enabled 1 TRUE FALSE TRUE allow rewrite of queries using materialized views if enabled
280 query_rewrite_integrity 1 TRUE FALSE enforced perform rewrite using materialized views with desired integrity
281 rdbms_server_dn 1 TRUE FALSE RDBMS's Distinguished Name
282 read_only_open_delayed 1 TRUE FALSE FALSE if TRUE delay opening of read only files until first access
283 recovery_parallelism 1 TRUE FALSE 0 number of server processes to use for parallel recovery
284 recyclebin 1 TRUE FALSE on recyclebin processing
285 redo_transport_user 1 TRUE FALSE Data Guard transport user when using password file
286 remote_dependencies_mode 1 TRUE FALSE TIMESTAMP remote-procedure-call dependencies mode parameter
287 remote_listener 0 TRUE FALSE remote listener
288 remote_login_passwordfile 1 FALSE FALSE EXCLUSIVE password file usage parameter
289 remote_os_authent 1 TRUE FALSE FALSE allow non-secure remote clients to use auto-logon accounts
290 remote_os_roles 1 TRUE FALSE FALSE allow non-secure remote clients to use os roles
291 replication_dependency_tracking 1 TRUE FALSE TRUE tracking dependency for Replication parallel propagation
292 resource_limit 1 TRUE FALSE FALSE master switch for resource limit
293 resource_manager_cpu_allocation 1 TRUE FALSE 4 Resource Manager CPU allocation
294 resource_manager_plan 0 TRUE FALSE resource mgr top plan
295 result_cache_max_result 1 TRUE FALSE 5 maximum result size as percent of cache size
296 result_cache_max_size 1 TRUE FALSE 12779520 12480K maximum amount of memory to be used by the cache
297 result_cache_mode 1 TRUE FALSE MANUAL result cache operator usage mode
298 result_cache_remote_expiration 1 TRUE FALSE 0 maximum life time (min) for any result using a remote object
299 resumable_timeout 1 TRUE FALSE 0 set resumable_timeout
300 rollback_segments 0 TRUE FALSE undo segment list
301 sec_case_sensitive_logon 1 TRUE FALSE TRUE case sensitive password enabled for logon
302 sec_max_failed_login_attempts 1 TRUE FALSE 10 maximum number of failed login attempts on a connection
303 sec_protocol_error_further_action 1 TRUE FALSE CONTINUE TTC protocol error continue action
304 sec_protocol_error_trace_action 1 TRUE FALSE TRACE TTC protocol error action
305 sec_return_server_release_banner 1 TRUE FALSE FALSE whether the server retruns the complete version information
306 serial_reuse 1 TRUE FALSE disable reuse the frame segments
307 service_names 1 TRUE FALSE orcl.us.oracle.com service names supported by the instance
308 session_cached_cursors 1 TRUE FALSE 50 Number of cursors to cache in a session.
309 session_max_open_files 1 TRUE FALSE 10 maximum number of open files allowed per session
310 sessions 1 TRUE FALSE 248 user and system sessions
311 sga_max_size 1 TRUE FALSE 2550136832 2432M max total SGA size
312 sga_target 1 FALSE FALSE 2550136832 2432M Target size of SGA
313 shadow_core_dump 1 TRUE FALSE none Core Size for Shadow Processes
314 shared_memory_address 1 TRUE FALSE 0 SGA starting address (low order 32-bits on 64-bit platforms)
315 shared_pool_reserved_size 1 TRUE FALSE 38587596 size in bytes of reserved area of shared pool
316 shared_pool_size 1 TRUE FALSE 0 size in bytes of shared pool
317 shared_server_sessions 0 TRUE FALSE max number of shared server sessions
318 shared_servers 1 TRUE FALSE 1 number of shared servers to start up
319 skip_unusable_indexes 1 TRUE FALSE TRUE skip unusable indexes if set to TRUE
320 smtp_out_server 0 TRUE FALSE utl_smtp server and port configuration parameter
321 sort_area_retained_size 1 TRUE FALSE 0 size of in-memory sort work area retained between fetch calls
322 sort_area_size 1 TRUE FALSE 65536 size of in-memory sort work area
323 spfile 1 TRUE FALSE D:\APP\CSIERRA\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA server parameter file
324 sql92_security 1 TRUE FALSE FALSE require select privilege for searched update/delete
325 sql_trace 1 TRUE FALSE FALSE enable SQL trace
326 sqltune_category 1 TRUE FALSE DEFAULT Category qualifier for applying hintsets
327 standby_archive_dest 1 TRUE FALSE %ORACLE_HOME%\RDBMS standby database archivelog destination text string
328 standby_file_management 1 TRUE FALSE MANUAL if auto then files are created/dropped automatically on standby
329 star_transformation_enabled 1 TRUE FALSE FALSE enable the use of star transformation
330 statistics_level 1 TRUE FALSE TYPICAL statistics level
331 streams_pool_size 1 TRUE FALSE 0 size in bytes of the streams pool
332 tape_asynch_io 1 TRUE FALSE TRUE Use asynch I/O requests for tape devices
333 thread 1 TRUE FALSE 0 Redo thread to mount
334 timed_os_statistics 1 TRUE FALSE 0 internal os statistic gathering interval in seconds
335 timed_statistics 1 TRUE FALSE TRUE maintain internal timing statistics
336 trace_enabled 1 TRUE FALSE TRUE enable in memory tracing
337 tracefile_identifier 0 TRUE FALSE trace file custom identifier
338 transactions 1 TRUE FALSE 272 max. number of concurrent active transactions
339 transactions_per_rollback_segment 1 TRUE FALSE 5 number of active transactions per rollback segment
340 undo_management 1 TRUE FALSE AUTO instance runs in SMU mode if TRUE, else in RBU mode
341 undo_retention 1 TRUE FALSE 900 undo retention in seconds
342 undo_tablespace 1 FALSE FALSE UNDOTBS1 use/switch undo tablespace
343 use_indirect_data_buffers 1 TRUE FALSE FALSE Enable indirect data buffers (very large SGA on 32-bit platforms)
344 use_large_pages 1 TRUE FALSE TRUE Use large pages if available (TRUE/FALSE/ONLY)
345 user_dump_dest 1 TRUE FALSE D:\app\csierra\diag\rdbms\orcl\orcl\trace User process dump directory
346 utl_file_dir 0 TRUE FALSE utl_file accessible directories list
347 workarea_size_policy 1 TRUE FALSE AUTO policy used to size SQL working areas (MANUAL/AUTO)
348 xml_db_events 1 TRUE FALSE enable are XML DB events enabled
# Name Ord Is
Default
Is
Modified
Value Display
Value
Description

1366133.1 SQLHC 11.4.5.2 2012-12-26/18:03:59