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
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
# | 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 |
# | Reason | Inst | Cursors |
---|---|---|---|
# | Reason | Inst | Cursors |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |