License : T Input : 00pspjfdy328d SIGNATURE : 16432764016050952009 SIGNATUREF : 13626564656978028 RDBMS : 11.2.0.3.0 Platform : IBM/AIX RISC SYSTEM/6000 Database : bdpdb DBID : 3936693823 Host : bdpdbserver Instance : 1 CPU_Count : 24 Num CPUs : 24 Num Cores : 6 Num Sockets: Block Size : 16384 OFE : 11.2.0.3 DYN_SAMP : 2 EBS : "" SIEBEL : "" PSFT : "" Date : 2015-03-04/11:48:44 User : SYS
DELETE FROM DDS.CUP_ACCOUNT T1 WHERE EXISTS( SELECT 1 FROM ODS.CUP_ACCOUNT T2 WHERE T2.BDP_ETL_DATE = '20150201' AND T1.ACCT_NMBR = SUBSTR(T2.CARD_NMBR,1,13) AND T1.CURR_CODE = TRIM(T2.CURR_CODE) )
# | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | 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 | 2786671412 | 3449.216 | 16.286 | 3422.406 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1516926 | 976935 | 0 | 406743 | 6 | 199791 | 2204445976 | 2015-02-02/06:00:35 | 2015-02-02/11:00:01 | ||
# | 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 | 7344 | 2015-02-02/06:00:35 | 1 | 2786671412 | 1 | 0 | 0 | 0 | 0 | 1 | 796218 | 796083 | 0 | 0 | 2877.589 | 9.284 | 2863.896 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
2 | 7345 | 2015-02-02/07:00:18 | 1 | 2786671412 | 1 | 0 | 0 | 0 | 0 | 0 | 506401 | 506297 | 0 | 0 | 3687.617 | 5.375 | 3679.885 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
3 | 7346 | 2015-02-02/08:00:06 | 1 | 2786671412 | 1 | 0 | 0 | 0 | 0 | 0 | 557790 | 557710 | 0 | 0 | 3570.965 | 5.052 | 3559.855 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
4 | 7347 | 2015-02-02/09:00:05 | 1 | 2786671412 | 1 | 0 | 0 | 0 | 0 | 0 | 172748 | 172731 | 0 | 0 | 3723.554 | 1.588 | 3720.851 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
5 | 7348 | 2015-02-02/10:00:59 | 1 | 2786671412 | 1 | 0 | 0 | 0 | 0 | 0 | 1841347 | 1806772 | 0 | 0 | 3563.122 | 17.285 | 3530.204 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
6 | 7349 | 2015-02-02/11:00:01 | 1 | 2786671412 | 1 | 1 | 0 | 0 | 0 | 0 | 5227051 | 2022015 | 0 | 2440460 | 3272.448 | 59.129 | 3179.747 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
# | 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 |
# | 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 | 7344 | 2015-02-02/06:00:35 | 1 | 2786671412 | 1 | 0 | 0 | 1 | 0 | 1 | 796218 | 796083 | 0 | 0 | 2877.589 | 9.284 | 2863.896 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
2 | 7345 | 2015-02-02/07:00:18 | 1 | 2786671412 | 1 | 0 | 0 | 1 | 0 | 1 | 1303002 | 1302763 | 0 | 0 | 6567.145 | 14.664 | 6545.714 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
3 | 7346 | 2015-02-02/08:00:06 | 1 | 2786671412 | 1 | 0 | 0 | 1 | 0 | 1 | 1861264 | 1860971 | 0 | 0 | 10142.120 | 19.721 | 10109.572 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
4 | 7347 | 2015-02-02/09:00:05 | 1 | 2786671412 | 1 | 0 | 0 | 1 | 0 | 1 | 2034524 | 2034214 | 0 | 0 | 13873.697 | 21.314 | 13838.439 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
5 | 7348 | 2015-02-02/10:00:59 | 1 | 2786671412 | 1 | 0 | 0 | 1 | 0 | 1 | 3875999 | 3841114 | 0 | 0 | 17440.606 | 38.600 | 17372.428 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
6 | 7349 | 2015-02-02/11:00:01 | 1 | 2786671412 | 1 | 1 | 0 | 1 | 0 | 1 | 9103178 | 5863257 | 0 | 2440460 | 20714.715 | 97.731 | 20553.833 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ALL_ROWS | 199791 | 2204445976 | DDS | pmdtm@bdpappserver (TNS V1-V3) | ||
# | 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 |
---|---|---|---|---|---|
# | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
# | 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 | 2786671412 | WAITING | User I/O | db file scattered read | 2048 |
2 | 2786671412 | WAITING | User I/O | db file sequential read | 14 |
3 | 2786671412 | ON CPU | 6 | ||
4 | 2786671412 | WAITING | Configuration | log buffer space | 2 |
# | 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 | 2786671412 | 1 | DELETE | DDS | CUP_ACCOUNT | ON CPU | 4 | |||||
2 | 2786671412 | 1 | DELETE | DDS | CUP_ACCOUNT | WAITING | User I/O | db file sequential read | 18563 | DDS.CUP_ACCOUNT_20150228_BAK | 3 | |
3 | 2786671412 | 4 | TABLE ACCESS | FULL | DDS | CUP_ACCOUNT | WAITING | User I/O | db file scattered read | 18563 | DDS.CUP_ACCOUNT_20150228_BAK | 2048 |
4 | 2786671412 | 4 | TABLE ACCESS | FULL | DDS | CUP_ACCOUNT | WAITING | User I/O | db file sequential read | 0 | 7 | |
5 | 2786671412 | 4 | TABLE ACCESS | FULL | DDS | CUP_ACCOUNT | WAITING | User I/O | db file sequential read | 18563 | DDS.CUP_ACCOUNT_20150228_BAK | 4 |
6 | 2786671412 | 4 | TABLE ACCESS | FULL | DDS | CUP_ACCOUNT | ON CPU | 2 | ||||
7 | 2786671412 | 4 | TABLE ACCESS | FULL | DDS | CUP_ACCOUNT | WAITING | Configuration | log buffer space | 2 | ||
# | 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 |
# | Parameter Name | Parameter Value | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | APPROXIMATE_NDV | TRUE | |||||||||||||||||||||
13 | AUTOSTATS_TARGET | AUTO | |||||||||||||||||||||
3 | CASCADE | TRUE | |||||||||||||||||||||
14 | CONCURRENT | FALSE | |||||||||||||||||||||
5 | DEGREE | 2 | |||||||||||||||||||||
4 | ESTIMATE_PERCENT | 10 | |||||||||||||||||||||
8 | GRANULARITY | ALL | |||||||||||||||||||||
11 | INCREMENTAL | FALSE | |||||||||||||||||||||
12 | INCREMENTAL_INTERNAL_CONTROL | TRUE | |||||||||||||||||||||
6 | METHOD_OPT | FOR ALL COLUMNS SIZE AUTO | |||||||||||||||||||||
7 | NO_INVALIDATE | DBMS_STATS.AUTO_INVALIDATE | |||||||||||||||||||||
9 | PUBLISH | TRUE | |||||||||||||||||||||
10 | STALE_PERCENT | 10 | |||||||||||||||||||||
1 | STATS_RETENTION | ||||||||||||||||||||||
# | Preference Name | Preference Value |
# | 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 |
Stat Versions |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CUP_ACCOUNT | DDS | NO | 1 | N | 14027490 | 1402749 | 10.0 | 2015-03-04/03:04:07 | 777516 | 449 | YES | NO | NO | 167 | 2 | 3 | Versions | ||
2 | CUP_ACCOUNT | ODS | NO | 1 | N | NO | NO | 165 | 2 | 4 | Versions | |||||||||
# | 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 |
Stat Versions |
# | Owner | Table Name | Obj# | Parameter Name | Parameter Value | Change Time | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | Owner | Table Name | Obj# | Parameter Name | Parameter Value | Change Time |
# | 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 | 36 | CURR_CODE | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 2 | 313536 | 383430 | 2015-03-04/03:04:07 | 4 | 3.564430e-08 | 2 | FREQUENCY | YES | NO |
2 | 1 | 157 | ACCT_NMBR | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 13971840 | 34343530353530303030303130 | 36323832313235303930393439 | 2015-03-04/03:04:07 | 14 | 7.157253e-08 | 1 | NONE | YES | NO |
3 | 1 | 162 | BDP_MODIFY_DATE | CHAR | 14027490 | 0 | 1402749 | 10.0 | 23 | 3230313530323039 | 3230313530333033 | 2015-03-04/03:04:07 | 9 | 3.564430e-08 | 23 | FREQUENCY | YES | NO |
4 | 0 | 1 | CARD_NMBR | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 13971850 | 34343530353530303030303130313039 | 36323832313235303930393439313039 | 2015-03-04/03:04:07 | 17 | 7.157248e-08 | 1 | NONE | YES | NO |
5 | 0 | 2 | ACCT_NO | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 4322751 | 30303030303031 | 39393930303137 | 2015-03-04/03:04:07 | 8 | 2.313342e-07 | 1 | NONE | YES | NO |
6 | 0 | 3 | ADDR_MODIFY_DATE | VARCHAR2 | 14027490 | 7984760 | 604273 | 10.0 | 3620 | 3230303430333239 | 3230313530333033 | 2015-03-04/03:04:07 | 5 | 2.762431e-04 | 1 | NONE | YES | NO |
7 | 0 | 4 | ACCT_ADDR_TYPE | VARCHAR2 | 14027490 | 554680 | 1347281 | 10.0 | 4 | 42 | 57 | 2015-03-04/03:04:07 | 2 | 2.500000e-01 | 1 | NONE | YES | NO |
8 | 0 | 5 | CARD_TYPE | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 246 | 30303030 | 31323735 | 2015-03-04/03:04:07 | 5 | 4.065041e-03 | 1 | NONE | YES | NO |
9 | 0 | 6 | BRANCH_CODE | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 2461 | 30303030 | 39383233 | 2015-03-04/03:04:07 | 5 | 4.063389e-04 | 1 | NONE | YES | NO |
10 | 0 | 7 | COMP_NMBR | VARCHAR2 | 14027490 | 14026230 | 126 | 10.0 | 137 | 30363130333130303031 | 584D5A46303030303035 | 2015-03-04/03:04:07 | 2 | 7.299270e-03 | 1 | NONE | YES | NO |
11 | 0 | 8 | OPEN_DATE | VARCHAR2 | 14027490 | 554680 | 1347281 | 10.0 | 3006 | 3230303430333233 | 3230313530333033 | 2015-03-04/03:04:07 | 9 | 3.326680e-04 | 1 | NONE | YES | NO |
12 | 0 | 9 | CREDLIMIT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 2526 | 80 | C404 | 2015-03-04/03:04:07 | 4 | 3.958828e-04 | 1 | NONE | YES | NO |
13 | 0 | 10 | CREDLIMIT_CURR2 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
14 | 0 | 11 | INSTALL_CREDIT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
15 | 0 | 12 | AUTH_NOTBEG_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1076 | 80 | C30D2F | 2015-03-04/03:04:07 | 3 | 9.293680e-04 | 1 | NONE | YES | NO |
16 | 0 | 13 | RETURN_DEADLINE_DATE | VARCHAR2 | 14027490 | 9356590 | 467090 | 10.0 | 19 | 3230313530313330 | 3230313530333033 | 2015-03-04/03:04:07 | 4 | 5.263158e-02 | 1 | NONE | YES | NO |
17 | 0 | 14 | LAST_RETURN_DATE | VARCHAR2 | 14027490 | 4680720 | 934677 | 10.0 | 3727 | 3230303430373134 | 3230313530333034 | 2015-03-04/03:04:07 | 7 | 2.683123e-04 | 1 | NONE | YES | NO |
18 | 0 | 15 | PAYED_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 55567 | 80 | C40262 | 2015-03-04/03:04:07 | 3 | 1.799629e-05 | 1 | NONE | YES | NO |
19 | 0 | 16 | POS_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 110115 | 3D602166 | C3622F2339 | 2015-03-04/03:04:07 | 3 | 9.081415e-06 | 1 | NONE | YES | NO |
20 | 0 | 17 | POS_AMT_IND | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 2 | 2B | 2D | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
21 | 0 | 18 | YEAR_FEE | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 2 | 80 | C115 | 2015-03-04/03:04:07 | 3 | 5.000000e-01 | 1 | NONE | YES | NO |
22 | 0 | 19 | UNTRN_CASH_CHARGE | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 619 | 80 | C21F | 2015-03-04/03:04:07 | 3 | 1.615509e-03 | 1 | NONE | YES | NO |
23 | 0 | 20 | UNTRN_CASH_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1084 | 80 | C402615B | 2015-03-04/03:04:07 | 3 | 9.225092e-04 | 1 | NONE | YES | NO |
24 | 0 | 21 | OTHER_CHARGE | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 195 | 80 | C3021D47 | 2015-03-04/03:04:07 | 3 | 5.128205e-03 | 1 | NONE | YES | NO |
25 | 0 | 22 | UNTRN_PUNISH_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 6570 | 80 | C304144D2C | 2015-03-04/03:04:07 | 3 | 1.522070e-04 | 1 | NONE | YES | NO |
26 | 0 | 23 | OVERDUE_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 21822 | 80 | C4020D563F63 | 2015-03-04/03:04:07 | 3 | 4.582531e-05 | 1 | NONE | YES | NO |
27 | 0 | 24 | OVERDUE_DAYS | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
28 | 0 | 25 | DISPUTED_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 4 | 80 | C302455F | 2015-03-04/03:04:07 | 3 | 2.500000e-01 | 1 | NONE | YES | NO |
29 | 0 | 26 | DEBIT_ADJUST_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 225 | 80 | C33D010B1D | 2015-03-04/03:04:07 | 3 | 4.444444e-03 | 1 | NONE | YES | NO |
30 | 0 | 27 | LOAN_ADJUST_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 5942 | 80 | C327 | 2015-03-04/03:04:07 | 3 | 1.682935e-04 | 1 | NONE | YES | NO |
31 | 0 | 28 | ACCT_STATUS | VARCHAR2 | 14027490 | 10855260 | 317223 | 10.0 | 10 | 31 | 5A | 2015-03-04/03:04:07 | 2 | 1.000000e-01 | 1 | NONE | YES | NO |
32 | 0 | 29 | ACCT_STATUS_DATE | VARCHAR2 | 14027490 | 10847690 | 317980 | 10.0 | 3365 | 3230303430343233 | 3230313530333033 | 2015-03-04/03:04:07 | 3 | 2.971768e-04 | 1 | NONE | YES | NO |
33 | 0 | 30 | POS_YESTERDAY_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 140598 | 80 | C352380513 | 2015-03-04/03:04:07 | 3 | 7.112477e-06 | 1 | NONE | YES | NO |
34 | 0 | 31 | CASH_YESTERDAY_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 16493 | 3C585D0D66 | C310 | 2015-03-04/03:04:07 | 3 | 6.063178e-05 | 1 | NONE | YES | NO |
35 | 0 | 32 | CASH_YESTERDAY_AMT_IND | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 2 | 2B | 2D | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
36 | 0 | 33 | CHARGE_YESTERDAY_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1088 | 80 | C302144802 | 2015-03-04/03:04:07 | 3 | 9.191176e-04 | 1 | NONE | YES | NO |
37 | 0 | 34 | INTEREST_YESTERDAY_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
38 | 0 | 35 | OCT_IN_DATE | VARCHAR2 | 14027490 | 13851400 | 17609 | 10.0 | 760 | 3230303730333131 | 3230313530333033 | 2015-03-04/03:04:07 | 2 | 1.315789e-03 | 1 | NONE | YES | NO |
39 | 0 | 37 | INTEREST_LATEST_DATE | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 29 | 2020202020202020 | 3230313530333033 | 2015-03-04/03:04:07 | 9 | 3.448276e-02 | 1 | NONE | YES | NO |
40 | 0 | 38 | INTEREST | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 28209 | 80 | C302132842 | 2015-03-04/03:04:07 | 3 | 3.544968e-05 | 1 | NONE | YES | NO |
41 | 0 | 39 | STMT_PAY_NUM | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 32 | 80 | C142 | 2015-03-04/03:04:07 | 3 | 3.125000e-02 | 1 | NONE | YES | NO |
42 | 0 | 40 | STMT_POS_NUM | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 95 | 80 | C20D1D | 2015-03-04/03:04:07 | 3 | 1.052632e-02 | 1 | NONE | YES | NO |
43 | 0 | 41 | STMT_TRANS_NUM | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 103 | 80 | C21921 | 2015-03-04/03:04:07 | 3 | 9.708738e-03 | 1 | NONE | YES | NO |
44 | 0 | 42 | ADJUSTED_BONUS | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 8667 | 3B64171A66 | C402353860 | 2015-03-04/03:04:07 | 3 | 1.153802e-04 | 1 | NONE | YES | NO |
45 | 0 | 43 | BEGCHANGE_BONUS | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 516 | 80 | C404060660 | 2015-03-04/03:04:07 | 3 | 1.937984e-03 | 1 | NONE | YES | NO |
46 | 0 | 44 | ACCUM_BONUS | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 168765 | 3C3F4B5C66 | C43213080D | 2015-03-04/03:04:07 | 4 | 5.925399e-06 | 1 | NONE | YES | NO |
47 | 0 | 45 | POS_GET_BONUS | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 19536 | 80 | C3622F24 | 2015-03-04/03:04:07 | 3 | 5.118755e-05 | 1 | NONE | YES | NO |
48 | 0 | 46 | AUTOKEAP_CODE | VARCHAR2 | 14027490 | 11918630 | 210886 | 10.0 | 2 | 4D | 54 | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
49 | 0 | 47 | LASTSTMT_NOTINTEREST_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 33369 | 80 | C313104C38 | 2015-03-04/03:04:07 | 3 | 2.996793e-05 | 1 | NONE | YES | NO |
50 | 0 | 48 | LASTSTMT_POS_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 219602 | 80 | C4030B3A461A | 2015-03-04/03:04:07 | 3 | 4.553693e-06 | 1 | NONE | YES | NO |
51 | 0 | 49 | LASTSTMT_INTEREST_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 42117 | 80 | C306601D56 | 2015-03-04/03:04:07 | 3 | 2.374338e-05 | 1 | NONE | YES | NO |
52 | 0 | 50 | LASTSTMT_CASH_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 55150 | 3C0E06073266 | C3234D4362 | 2015-03-04/03:04:07 | 3 | 1.813237e-05 | 1 | NONE | YES | NO |
53 | 0 | 51 | LASTSTMT_CASH_IND | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 2 | 2B | 2D | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
54 | 0 | 52 | LASTSTMT_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 377621 | 80 | C4030B3A461A | 2015-03-04/03:04:07 | 4 | 2.648158e-06 | 1 | NONE | YES | NO |
55 | 0 | 53 | LASTSTMT_LOWEST_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 199510 | 80 | C40210442F43 | 2015-03-04/03:04:07 | 3 | 5.012280e-06 | 1 | NONE | YES | NO |
56 | 0 | 54 | STMT_CODE | VARCHAR2 | 14027490 | 555260 | 1347223 | 10.0 | 4 | 454D | 4C54 | 2015-03-04/03:04:07 | 3 | 2.500000e-01 | 1 | NONE | YES | NO |
57 | 0 | 55 | OVERDUE_AMT1 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 14722 | 80 | C328106153 | 2015-03-04/03:04:07 | 3 | 6.792555e-05 | 1 | NONE | YES | NO |
58 | 0 | 56 | OVERDUE_AMT2 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 8809 | 80 | C31861405C | 2015-03-04/03:04:07 | 3 | 1.135203e-04 | 1 | NONE | YES | NO |
59 | 0 | 57 | OVERDUE_AMT3 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 7106 | 80 | C31D372B2C | 2015-03-04/03:04:07 | 3 | 1.407261e-04 | 1 | NONE | YES | NO |
60 | 0 | 58 | OVERDUE_AMT4 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 6131 | 80 | C328504E47 | 2015-03-04/03:04:07 | 3 | 1.631055e-04 | 1 | NONE | YES | NO |
61 | 0 | 59 | OVERDUE_AMT5 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 5381 | 80 | C322524434 | 2015-03-04/03:04:07 | 3 | 1.858391e-04 | 1 | NONE | YES | NO |
62 | 0 | 60 | OVERDUE_AMT6 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 4710 | 80 | C363370D50 | 2015-03-04/03:04:07 | 3 | 2.123142e-04 | 1 | NONE | YES | NO |
63 | 0 | 61 | OVERDUE_MAXNUM | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 55 | 80 | C161 | 2015-03-04/03:04:07 | 3 | 1.818182e-02 | 1 | NONE | YES | NO |
64 | 0 | 62 | COMP_INTEREST_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 9721 | 80 | C32936513E | 2015-03-04/03:04:07 | 3 | 1.028701e-04 | 1 | NONE | YES | NO |
65 | 0 | 63 | CANCL_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 3942 | 80 | C307506464 | 2015-03-04/03:04:07 | 3 | 2.536783e-04 | 1 | NONE | YES | NO |
66 | 0 | 64 | STMT_DATE | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 29 | 3030 | 3238 | 2015-03-04/03:04:07 | 3 | 3.564430e-08 | 29 | FREQUENCY | YES | NO |
67 | 0 | 65 | EXCHANGE_OPTION | VARCHAR2 | 14027490 | 13780150 | 24734 | 10.0 | 3 | 46 | 54 | 2015-03-04/03:04:07 | 2 | 3.333333e-01 | 1 | NONE | YES | NO |
68 | 0 | 66 | INSTALL_AUTH_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 27 | 80 | C306 | 2015-03-04/03:04:07 | 3 | 3.703704e-02 | 1 | NONE | YES | NO |
69 | 0 | 67 | INSTALL_LEFT_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 78681 | 80 | C3615E3B4C | 2015-03-04/03:04:07 | 3 | 1.270955e-05 | 1 | NONE | YES | NO |
70 | 0 | 68 | STMT_ADDR_1 | VARCHAR2 | 14027490 | 554680 | 1347281 | 10.0 | 34649 | 28B1B1BEA9CAD0BAA3B5EDC7F8 | F5B7C1EACAD0F5B7C1EAC7F8 | 2015-03-04/03:04:07 | 12 | 2.886086e-05 | 1 | NONE | YES | NO |
71 | 0 | 69 | STMT_ADDR_2 | VARCHAR2 | 14027490 | 554680 | 1347281 | 10.0 | 953703 | 22 | FD9DCBAEBAD3D2BBBDD638BAC5 | 2015-03-04/03:04:07 | 13 | 1.048544e-06 | 1 | NONE | YES | NO |
72 | 0 | 70 | STMT_ADDR_3 | VARCHAR2 | 14027490 | 4684450 | 934304 | 10.0 | 1398510 | 22 | FD9DB9FBBDD632BAC5C6DFD4BA31B6B036B5A5D4AA333031CAD2 | 2015-03-04/03:04:07 | 11 | 7.150467e-07 | 1 | NONE | YES | NO |
73 | 0 | 71 | STMT_ADDR_4 | VARCHAR2 | 14027490 | 3924500 | 1010299 | 10.0 | 1075470 | 23 | FD9DB3C7BDD6B5C0D0E3D4B7BED3CEAFBBE1 | 2015-03-04/03:04:07 | 16 | 9.298260e-07 | 1 | NONE | YES | NO |
74 | 0 | 72 | STMT_ADDR_5 | VARCHAR2 | 14027490 | 13712190 | 31530 | 10.0 | 21909 | 2831303929CAD2 | F97BC5F4BEABC3DC | 2015-03-04/03:04:07 | 2 | 4.564334e-05 | 1 | NONE | YES | NO |
75 | 0 | 73 | STMT_ADDR_POST | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 17329 | 303030303030 | 393939393939 | 2015-03-04/03:04:07 | 7 | 5.770673e-05 | 1 | NONE | YES | NO |
76 | 0 | 74 | YESTERDAY_NOINTEREST_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 193 | 80 | C319054863 | 2015-03-04/03:04:07 | 3 | 5.181347e-03 | 1 | NONE | YES | NO |
77 | 0 | 75 | LASTSTMT_NOINTEREST_AMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 39694 | 80 | C332513233 | 2015-03-04/03:04:07 | 3 | 2.519272e-05 | 1 | NONE | YES | NO |
78 | 0 | 76 | RELATE_ACCT1 | VARCHAR2 | 14027490 | 11916760 | 211073 | 10.0 | 1704894 | 3030323135353134363036394E | 3F3F3F3F3F3F3F31363334363633353233314E | 2015-03-04/03:04:07 | 3 | 5.865467e-07 | 1 | NONE | YES | NO |
79 | 0 | 77 | RELATE_ACCT2 | VARCHAR2 | 14027490 | 13953160 | 7433 | 10.0 | 73960 | 3131303531303132363230323337303432324E | 393834333031303131333134313238384E | 2015-03-04/03:04:07 | 2 | 1.352082e-05 | 1 | NONE | YES | NO |
80 | 0 | 78 | RELATE_ACCT3 | VARCHAR2 | 14027490 | 14027490 | 100.0 | 0 | 2015-03-04/03:04:07 | 0 | 0.000000e+00 | 0 | NONE | YES | NO | |||
81 | 0 | 79 | RELATE_ACCT4 | VARCHAR2 | 14027490 | 14027490 | 100.0 | 0 | 2015-03-04/03:04:07 | 0 | 0.000000e+00 | 0 | NONE | YES | NO | |||
82 | 0 | 80 | RELATE_ACCT1_CODE | VARCHAR2 | 14027490 | 11916760 | 211073 | 10.0 | 3 | 44 | 58 | 2015-03-04/03:04:07 | 2 | 3.333333e-01 | 1 | NONE | YES | NO |
83 | 0 | 81 | RELATE_ACCT1_CODE2 | VARCHAR2 | 14027490 | 13953160 | 7433 | 10.0 | 3 | 44 | 58 | 2015-03-04/03:04:07 | 2 | 3.333333e-01 | 1 | NONE | YES | NO |
84 | 0 | 82 | RELATE_ACCT1_CODE3 | VARCHAR2 | 14027490 | 14027490 | 100.0 | 0 | 2015-03-04/03:04:07 | 0 | 0.000000e+00 | 0 | NONE | YES | NO | |||
85 | 0 | 83 | RELATE_ACCT1_CODE4 | VARCHAR2 | 14027490 | 14027490 | 100.0 | 0 | 2015-03-04/03:04:07 | 0 | 0.000000e+00 | 0 | NONE | YES | NO | |||
86 | 0 | 84 | RMB_AUTOKEAP_IND | VARCHAR2 | 14027490 | 11918630 | 210886 | 10.0 | 2 | 4D | 54 | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
87 | 0 | 85 | USD_AUTOKEAP_IND | VARCHAR2 | 14027490 | 13990760 | 3673 | 10.0 | 2 | 4D | 54 | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
88 | 0 | 86 | EXCHANGE_OPTION2 | VARCHAR2 | 14027490 | 559620 | 1346787 | 10.0 | 3 | 30 | 33 | 2015-03-04/03:04:07 | 2 | 3.333333e-01 | 1 | NONE | YES | NO |
89 | 0 | 87 | EXCHANGE_AMT_IND | VARCHAR2 | 14027490 | 13780150 | 24734 | 10.0 | 3 | 46 | 54 | 2015-03-04/03:04:07 | 2 | 3.333333e-01 | 1 | NONE | YES | NO |
90 | 0 | 88 | LASTEST_STMT_DATE | VARCHAR2 | 14027490 | 4901300 | 912619 | 10.0 | 1678 | 3230303431313138 | 3230313530333033 | 2015-03-04/03:04:07 | 7 | 5.959476e-04 | 1 | NONE | YES | NO |
91 | 0 | 89 | ADJUSTED_BONUS_IND | VARCHAR2 | 14027490 | 554680 | 1347281 | 10.0 | 2 | 2B | 2D | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
92 | 0 | 90 | ACCUM_BONUS_IND | VARCHAR2 | 14027490 | 554680 | 1347281 | 10.0 | 2 | 2B | 2D | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
93 | 0 | 91 | ACCT_DUTY_PC | VARCHAR2 | 14027490 | 1055820 | 1297167 | 10.0 | 115 | 2B3131 | A3B2A3B0 | 2015-03-04/03:04:07 | 3 | 8.695652e-03 | 1 | NONE | YES | NO |
94 | 0 | 92 | ACCT_PROJ_SC | VARCHAR2 | 14027490 | 11553820 | 247367 | 10.0 | 116 | 2B41 | B6E3 | 2015-03-04/03:04:07 | 2 | 8.620690e-03 | 1 | NONE | YES | NO |
95 | 0 | 93 | ACCT_IND | VARCHAR2 | 14027490 | 14027490 | 100.0 | 0 | 2015-03-04/03:04:07 | 0 | 0.000000e+00 | 0 | NONE | YES | NO | |||
96 | 0 | 94 | CASH_RATE | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 36 | 80 | C202 | 2015-03-04/03:04:07 | 3 | 2.777778e-02 | 1 | NONE | YES | NO |
97 | 0 | 95 | BRANCH_INTR | VARCHAR2 | 14027490 | 5696690 | 833080 | 10.0 | 4 | 30 | 33 | 2015-03-04/03:04:07 | 2 | 2.500000e-01 | 1 | NONE | YES | NO |
98 | 0 | 96 | BRANCH_CRLMT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 49 | 80 | C20A5B | 2015-03-04/03:04:07 | 3 | 2.040816e-02 | 1 | NONE | YES | NO |
99 | 0 | 97 | VRF_CNTNT | VARCHAR2 | 14027490 | 5695520 | 833197 | 10.0 | 37 | 3030303030 | 32303030 | 2015-03-04/03:04:07 | 4 | 2.702703e-02 | 1 | NONE | YES | NO |
100 | 0 | 98 | SMS_FREE_FLAG | VARCHAR2 | 14027490 | 12061410 | 196608 | 10.0 | 2 | 30 | 31 | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
101 | 0 | 99 | TEMP_CREDLIMIT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1717 | 80 | C404 | 2015-03-04/03:04:07 | 3 | 5.824112e-04 | 1 | NONE | YES | NO |
102 | 0 | 100 | TEMP_TO_DT | VARCHAR2 | 14027490 | 11033570 | 299392 | 10.0 | 2859 | 3230303630343039 | 3230313530343232 | 2015-03-04/03:04:07 | 3 | 3.497726e-04 | 1 | NONE | YES | NO |
103 | 0 | 101 | TEMP_FROM_DT | VARCHAR2 | 14027490 | 11033570 | 299392 | 10.0 | 2993 | 3230303630333039 | 3230313530333033 | 2015-03-04/03:04:07 | 3 | 3.341129e-04 | 1 | NONE | YES | NO |
104 | 0 | 102 | BONUS_CREDLIMIT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 4 | 80 | C315 | 2015-03-04/03:04:07 | 3 | 2.500000e-01 | 1 | NONE | YES | NO |
105 | 0 | 103 | PAY_FLAG | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 2 | 30 | 31 | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
106 | 0 | 104 | INT_CHDCMP | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 18555 | 80 | C20C1E1E37 | 2015-03-04/03:04:07 | 3 | 5.389383e-05 | 1 | NONE | YES | NO |
107 | 0 | 105 | INT_NOTION | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 205214 | 80 | C3022715125D | 2015-03-04/03:04:07 | 3 | 4.872962e-06 | 1 | NONE | YES | NO |
108 | 0 | 106 | INT_CUNOT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 128274 | 80 | C235264309 | 2015-03-04/03:04:07 | 3 | 7.795812e-06 | 1 | NONE | YES | NO |
109 | 0 | 107 | INT_CURCMP | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
110 | 0 | 108 | INT_CMPOND | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 14482 | 80 | C204341961 | 2015-03-04/03:04:07 | 3 | 6.905124e-05 | 1 | NONE | YES | NO |
111 | 0 | 109 | IMP_FLAG | VARCHAR2 | 14027490 | 14020290 | 720 | 10.0 | 4 | 3030 | 3131 | 2015-03-04/03:04:07 | 2 | 2.500000e-01 | 1 | NONE | YES | NO |
112 | 0 | 110 | NCRED_RSN | VARCHAR2 | 14027490 | 14025850 | 164 | 10.0 | 1 | 31 | 31 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
113 | 0 | 111 | MONTR_CODE | VARCHAR2 | 14027490 | 14027440 | 5 | 10.0 | 4 | 31 | 42 | 2015-03-04/03:04:07 | 2 | 2.500000e-01 | 1 | NONE | YES | NO |
114 | 0 | 112 | CRED_LMT2 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 651 | 80 | C402 | 2015-03-04/03:04:07 | 3 | 1.536098e-03 | 1 | NONE | YES | NO |
115 | 0 | 113 | CRED_FLAG | VARCHAR2 | 14027490 | 3101740 | 1092575 | 10.0 | 2 | 30 | 31 | 2015-03-04/03:04:07 | 2 | 5.000000e-01 | 1 | NONE | YES | NO |
116 | 0 | 114 | BAL_CHARGE01 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 840 | 80 | C21F | 2015-03-04/03:04:07 | 3 | 1.190476e-03 | 1 | NONE | YES | NO |
117 | 0 | 115 | BAL_CHARGE02 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 12 | 80 | C25B | 2015-03-04/03:04:07 | 3 | 8.333333e-02 | 1 | NONE | YES | NO |
118 | 0 | 116 | BAL_CHARGE03 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
119 | 0 | 117 | BAL_CHARGE04 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
120 | 0 | 118 | BAL_CHARGE05 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 167 | 80 | C302144802 | 2015-03-04/03:04:07 | 3 | 5.988024e-03 | 1 | NONE | YES | NO |
121 | 0 | 119 | BAL_CHARGE06 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
122 | 0 | 120 | BAL_CHARGE07 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
123 | 0 | 121 | BAL_CHARGE08 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 107 | 80 | C202 | 2015-03-04/03:04:07 | 3 | 9.345794e-03 | 1 | NONE | YES | NO |
124 | 0 | 122 | BAL_CHARGE09 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
125 | 0 | 123 | BAL_CHARGE10 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
126 | 0 | 124 | LAST_CHARGE01 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 2012 | 80 | C309490B30 | 2015-03-04/03:04:07 | 3 | 4.970179e-04 | 1 | NONE | YES | NO |
127 | 0 | 125 | LAST_CHARGE02 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1001 | 80 | C30233 | 2015-03-04/03:04:07 | 3 | 9.990010e-04 | 1 | NONE | YES | NO |
128 | 0 | 126 | LAST_CHARGE03 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 16128 | 80 | C312132B36 | 2015-03-04/03:04:07 | 3 | 6.200397e-05 | 1 | NONE | YES | NO |
129 | 0 | 127 | LAST_CHARGE04 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
130 | 0 | 128 | LAST_CHARGE05 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 21380 | 80 | C30530411B | 2015-03-04/03:04:07 | 3 | 4.677268e-05 | 1 | NONE | YES | NO |
131 | 0 | 129 | LAST_CHARGE06 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
132 | 0 | 130 | LAST_CHARGE07 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 340 | 80 | C11C | 2015-03-04/03:04:07 | 3 | 2.941176e-03 | 1 | NONE | YES | NO |
133 | 0 | 131 | LAST_CHARGE08 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 196 | 80 | C15B | 2015-03-04/03:04:07 | 3 | 5.102041e-03 | 1 | NONE | YES | NO |
134 | 0 | 132 | LAST_CHARGE09 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
135 | 0 | 133 | LAST_CHARGE10 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
136 | 0 | 134 | DES_FLAG | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 4 | 30 | 39 | 2015-03-04/03:04:07 | 2 | 2.500000e-01 | 1 | NONE | YES | NO |
137 | 0 | 135 | DESRESN_CODE | VARCHAR2 | 14027490 | 14027490 | 100.0 | 0 | 2015-03-04/03:04:07 | 0 | 0.000000e+00 | 0 | NONE | YES | NO | |||
138 | 0 | 136 | STP_NOT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
139 | 0 | 137 | STP_CMP | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
140 | 0 | 138 | STP_CHRG | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
141 | 0 | 139 | BAL_CMPFEE | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 6880 | 80 | C312132B36 | 2015-03-04/03:04:07 | 3 | 1.453488e-04 | 1 | NONE | YES | NO |
142 | 0 | 140 | NOINTEREST_FLAG | VARCHAR2 | 14027490 | 14027490 | 100.0 | 0 | 2015-03-04/03:04:07 | 0 | 0.000000e+00 | 0 | NONE | YES | NO | |||
143 | 0 | 141 | NOINTEREST_LIMIT | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
144 | 0 | 142 | NOINTEREST_PERC | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
145 | 0 | 143 | NOINTEREST_MAX | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
146 | 0 | 144 | NOINTEREST_MIN | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
147 | 0 | 145 | MP_REM_PPL | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 74710 | 80 | C3614A224C | 2015-03-04/03:04:07 | 3 | 1.338509e-05 | 1 | NONE | YES | NO |
148 | 0 | 146 | CRED_LMT3 | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 89 | 80 | C31433 | 2015-03-04/03:04:07 | 3 | 1.123596e-02 | 1 | NONE | YES | NO |
149 | 0 | 147 | MPAUTO_GW_PRSNT_PLAN | NUMBER | 14027490 | 13777910 | 24958 | 10.0 | 68 | 80 | C2211C | 2015-03-04/03:04:07 | 2 | 1.470588e-02 | 1 | NONE | YES | NO |
150 | 0 | 148 | MPAUTO_GW_PRSNT_NUM | NUMBER | 14027490 | 13777910 | 24958 | 10.0 | 7 | 80 | C125 | 2015-03-04/03:04:07 | 2 | 1.428571e-01 | 1 | NONE | YES | NO |
151 | 0 | 149 | MPAUTO_GW_NEXT_PLAN | NUMBER | 14027490 | 13777900 | 24959 | 10.0 | 68 | 80 | C2211C | 2015-03-04/03:04:07 | 2 | 1.470588e-02 | 1 | NONE | YES | NO |
152 | 0 | 150 | MPAUTO_GW_NEXT_NUM | NUMBER | 14027490 | 13777900 | 24959 | 10.0 | 7 | 80 | C125 | 2015-03-04/03:04:07 | 2 | 1.428571e-01 | 1 | NONE | YES | NO |
153 | 0 | 151 | MPAUTO_GW_MODIFY_DT | NUMBER | 14027490 | 13777900 | 24959 | 10.0 | 1215 | C302632A | C3030D2E | 2015-03-04/03:04:07 | 2 | 8.230453e-04 | 1 | NONE | YES | NO |
154 | 0 | 152 | INT_CODE | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 2 | 80 | C102 | 2015-03-04/03:04:07 | 3 | 5.000000e-01 | 1 | NONE | YES | NO |
155 | 0 | 153 | CRED_CHDAY | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 3160 | 3030303030303030 | 3230313530333034 | 2015-03-04/03:04:07 | 9 | 3.164557e-04 | 1 | NONE | YES | NO |
156 | 0 | 154 | ADJ_FLAG | VARCHAR2 | 14027490 | 14027490 | 100.0 | 0 | 2015-03-04/03:04:07 | 0 | 0.000000e+00 | 0 | NONE | YES | NO | |||
157 | 0 | 155 | NOTE_RST | VARCHAR2 | 14027490 | 5943750 | 808374 | 10.0 | 3 | 41 | 44 | 2015-03-04/03:04:07 | 2 | 3.333333e-01 | 1 | NONE | YES | NO |
158 | 0 | 156 | NOTE_RSN | VARCHAR2 | 14027490 | 5943750 | 808374 | 10.0 | 20 | 42373739 | 54313033 | 2015-03-04/03:04:07 | 4 | 5.000000e-02 | 1 | NONE | YES | NO |
159 | 0 | 158 | CURR_BALANCE | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 374228 | 3C0E06073266 | C4030B3A461A | 2015-03-04/03:04:07 | 4 | 2.672168e-06 | 1 | NONE | YES | NO |
160 | 0 | 159 | PPL | NUMBER | 14027490 | 0 | 1402749 | 10.0 | 373064 | 3C0E06073266 | C4030B3A461A | 2015-03-04/03:04:07 | 4 | 2.680505e-06 | 1 | NONE | YES | NO |
161 | 0 | 160 | OVERDUE_LEVEL | VARCHAR2 | 14027490 | 0 | 1402749 | 10.0 | 8 | 4D30 | 4D37 | 2015-03-04/03:04:07 | 3 | 1.250000e-01 | 1 | NONE | YES | NO |
162 | 0 | 161 | RECLA_CODE | VARCHAR2 | 14027490 | 13545920 | 48157 | 10.0 | 18 | 36 | 5A | 2015-03-04/03:04:07 | 2 | 5.555556e-02 | 1 | NONE | YES | NO |
163 | 0 | 163 | BDP_LOAD_TIME | DATE | 14027490 | 0 | 1402749 | 10.0 | 5018 | 7873020A082D1A | 78730304033B22 | 2015-03-04/03:04:07 | 8 | 1.992826e-04 | 1 | NONE | YES | NO |
164 | 0 | 164 | POINT_CUM2 | NUMBER | 14027490 | 5207120 | 882037 | 10.0 | 325 | 80 | C30A3363 | 2015-03-04/03:04:07 | 2 | 3.076923e-03 | 1 | NONE | YES | NO |
165 | 0 | 165 | POINT_REV | NUMBER | 14027490 | 5207120 | 882037 | 10.0 | 2664 | 80 | C4022F5C26 | 2015-03-04/03:04:07 | 2 | 3.753754e-04 | 1 | NONE | YES | NO |
166 | 0 | 166 | PAYMT_UNCL | NUMBER | 14027490 | 5207120 | 882037 | 10.0 | 1 | 80 | 80 | 2015-03-04/03:04:07 | 2 | 1.000000e+00 | 1 | NONE | YES | NO |
167 | 0 | 167 | QUERY_CODE | VARCHAR2 | 14027490 | 14015320 | 0 | 2015-03-04/03:04:33 | 0 | 0.000000e+00 | 0 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
168 | 2 | 158 | BDP_ETL_DATE | CHAR | NONE | NO | NO | |||||||||||
169 | 1 | SYS_NC00164$ | VARCHAR2 | NONE | NO | NO | ||||||||||||
170 | 1 | SYS_NC00165$ | VARCHAR2 | NONE | NO | NO | ||||||||||||
171 | 0 | 1 | CARD_NMBR | VARCHAR2 | NONE | NO | NO | |||||||||||
172 | 0 | 2 | ACCT_NO | VARCHAR2 | NONE | NO | NO | |||||||||||
173 | 0 | 3 | ADDR_MODIFY_DATE | VARCHAR2 | NONE | NO | NO | |||||||||||
174 | 0 | 4 | ACCT_ADDR_TYPE | VARCHAR2 | NONE | NO | NO | |||||||||||
175 | 0 | 5 | CARD_TYPE | VARCHAR2 | NONE | NO | NO | |||||||||||
176 | 0 | 6 | BRANCH_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
177 | 0 | 7 | COMP_NMBR | VARCHAR2 | NONE | NO | NO | |||||||||||
178 | 0 | 8 | OPEN_DATE | VARCHAR2 | NONE | NO | NO | |||||||||||
179 | 0 | 9 | CREDLIMIT | VARCHAR2 | NONE | NO | NO | |||||||||||
180 | 0 | 10 | CREDLIMIT_CURR2 | VARCHAR2 | NONE | NO | NO | |||||||||||
181 | 0 | 11 | INSTALL_CREDIT | VARCHAR2 | NONE | NO | NO | |||||||||||
182 | 0 | 12 | AUTH_NOTBEG_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
183 | 0 | 13 | RETURN_DEADLINE_DATE | VARCHAR2 | NONE | NO | NO | |||||||||||
184 | 0 | 14 | LAST_RETURN_DATE | VARCHAR2 | NONE | NO | NO | |||||||||||
185 | 0 | 15 | PAYED_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
186 | 0 | 16 | POS_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
187 | 0 | 17 | POS_AMT_IND | VARCHAR2 | NONE | NO | NO | |||||||||||
188 | 0 | 18 | YEAR_FEE | VARCHAR2 | NONE | NO | NO | |||||||||||
189 | 0 | 19 | UNTRN_CASH_CHARGE | VARCHAR2 | NONE | NO | NO | |||||||||||
190 | 0 | 20 | UNTRN_CASH_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
191 | 0 | 21 | OTHER_CHARGE | VARCHAR2 | NONE | NO | NO | |||||||||||
192 | 0 | 22 | UNTRN_PUNISH_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
193 | 0 | 23 | OVERDUE_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
194 | 0 | 24 | OVERDUE_DAYS | VARCHAR2 | NONE | NO | NO | |||||||||||
195 | 0 | 25 | DISPUTED_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
196 | 0 | 26 | DEBIT_ADJUST_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
197 | 0 | 27 | LOAN_ADJUST_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
198 | 0 | 28 | ACCT_STATUS | VARCHAR2 | NONE | NO | NO | |||||||||||
199 | 0 | 29 | ACCT_STATUS_DATE | VARCHAR2 | NONE | NO | NO | |||||||||||
200 | 0 | 30 | POS_YESTERDAY_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
201 | 0 | 31 | CASH_YESTERDAY_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
202 | 0 | 32 | CASH_YESTERDAY_AMT_IND | VARCHAR2 | NONE | NO | NO | |||||||||||
203 | 0 | 33 | CHARGE_YESTERDAY_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
204 | 0 | 34 | INTEREST_YESTERDAY_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
205 | 0 | 35 | OCT_IN_DATE | VARCHAR2 | NONE | NO | NO | |||||||||||
206 | 0 | 36 | CURR_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
207 | 0 | 37 | INTEREST_LATEST_DATE | VARCHAR2 | NONE | NO | NO | |||||||||||
208 | 0 | 38 | INTEREST | VARCHAR2 | NONE | NO | NO | |||||||||||
209 | 0 | 39 | STMT_PAY_NUM | VARCHAR2 | NONE | NO | NO | |||||||||||
210 | 0 | 40 | STMT_POS_NUM | VARCHAR2 | NONE | NO | NO | |||||||||||
211 | 0 | 41 | STMT_TRANS_NUM | VARCHAR2 | NONE | NO | NO | |||||||||||
212 | 0 | 42 | ADJUSTED_BONUS | VARCHAR2 | NONE | NO | NO | |||||||||||
213 | 0 | 43 | BEGCHANGE_BONUS | VARCHAR2 | NONE | NO | NO | |||||||||||
214 | 0 | 44 | ACCUM_BONUS | VARCHAR2 | NONE | NO | NO | |||||||||||
215 | 0 | 45 | POS_GET_BONUS | VARCHAR2 | NONE | NO | NO | |||||||||||
216 | 0 | 46 | AUTOKEAP_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
217 | 0 | 47 | LASTSTMT_NOTINTEREST_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
218 | 0 | 48 | LASTSTMT_POS_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
219 | 0 | 49 | LASTSTMT_INTEREST_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
220 | 0 | 50 | LASTSTMT_CASH_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
221 | 0 | 51 | LASTSTMT_CASH_IND | VARCHAR2 | NONE | NO | NO | |||||||||||
222 | 0 | 52 | LASTSTMT_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
223 | 0 | 53 | LASTSTMT_LOWEST_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
224 | 0 | 54 | STMT_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
225 | 0 | 55 | OVERDUE_AMT1 | VARCHAR2 | NONE | NO | NO | |||||||||||
226 | 0 | 56 | OVERDUE_AMT2 | VARCHAR2 | NONE | NO | NO | |||||||||||
227 | 0 | 57 | OVERDUE_AMT3 | VARCHAR2 | NONE | NO | NO | |||||||||||
228 | 0 | 58 | OVERDUE_AMT4 | VARCHAR2 | NONE | NO | NO | |||||||||||
229 | 0 | 59 | OVERDUE_AMT5 | VARCHAR2 | NONE | NO | NO | |||||||||||
230 | 0 | 60 | OVERDUE_AMT6 | VARCHAR2 | NONE | NO | NO | |||||||||||
231 | 0 | 61 | OVERDUE_MAXNUM | VARCHAR2 | NONE | NO | NO | |||||||||||
232 | 0 | 62 | COMP_INTEREST_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
233 | 0 | 63 | CANCL_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
234 | 0 | 64 | STMT_DATE | VARCHAR2 | NONE | NO | NO | |||||||||||
235 | 0 | 65 | EXCHANGE_OPTION | VARCHAR2 | NONE | NO | NO | |||||||||||
236 | 0 | 66 | INSTALL_AUTH_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
237 | 0 | 67 | INSTALL_LEFT_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
238 | 0 | 68 | STMT_ADDR_1 | VARCHAR2 | NONE | NO | NO | |||||||||||
239 | 0 | 69 | STMT_ADDR_2 | VARCHAR2 | NONE | NO | NO | |||||||||||
240 | 0 | 70 | STMT_ADDR_3 | VARCHAR2 | NONE | NO | NO | |||||||||||
241 | 0 | 71 | STMT_ADDR_4 | VARCHAR2 | NONE | NO | NO | |||||||||||
242 | 0 | 72 | STMT_ADDR_5 | VARCHAR2 | NONE | NO | NO | |||||||||||
243 | 0 | 73 | STMT_ADDR_POST | VARCHAR2 | NONE | NO | NO | |||||||||||
244 | 0 | 74 | YESTERDAY_NOINTEREST_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
245 | 0 | 75 | LASTSTMT_NOINTEREST_AMT | VARCHAR2 | NONE | NO | NO | |||||||||||
246 | 0 | 76 | RELATE_ACCT1 | VARCHAR2 | NONE | NO | NO | |||||||||||
247 | 0 | 77 | RELATE_ACCT2 | VARCHAR2 | NONE | NO | NO | |||||||||||
248 | 0 | 78 | RELATE_ACCT3 | VARCHAR2 | NONE | NO | NO | |||||||||||
249 | 0 | 79 | RELATE_ACCT4 | VARCHAR2 | NONE | NO | NO | |||||||||||
250 | 0 | 80 | RELATE_ACCT1_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
251 | 0 | 81 | RELATE_ACCT2_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
252 | 0 | 82 | RELATE_ACCT3_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
253 | 0 | 83 | RELATE_ACCT4_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
254 | 0 | 84 | RMB_AUTOKEAP_IND | VARCHAR2 | NONE | NO | NO | |||||||||||
255 | 0 | 85 | USD_AUTOKEAP_IND | VARCHAR2 | NONE | NO | NO | |||||||||||
256 | 0 | 86 | EXCHANGE_OPTION2 | VARCHAR2 | NONE | NO | NO | |||||||||||
257 | 0 | 87 | EXCHANGE_AMT_IND | VARCHAR2 | NONE | NO | NO | |||||||||||
258 | 0 | 88 | LASTEST_STMT_DATE | VARCHAR2 | NONE | NO | NO | |||||||||||
259 | 0 | 89 | ADJUSTED_BONUS_IND | VARCHAR2 | NONE | NO | NO | |||||||||||
260 | 0 | 90 | ACCUM_BONUS_IND | VARCHAR2 | NONE | NO | NO | |||||||||||
261 | 0 | 91 | ACCT_DUTY_PC | VARCHAR2 | NONE | NO | NO | |||||||||||
262 | 0 | 92 | ACCT_PROJ_SC | VARCHAR2 | NONE | NO | NO | |||||||||||
263 | 0 | 93 | ACCT_IND | VARCHAR2 | NONE | NO | NO | |||||||||||
264 | 0 | 94 | CASH_RATE | VARCHAR2 | NONE | NO | NO | |||||||||||
265 | 0 | 95 | BRANCH_INTR | VARCHAR2 | NONE | NO | NO | |||||||||||
266 | 0 | 96 | BRANCH_CRLMT | VARCHAR2 | NONE | NO | NO | |||||||||||
267 | 0 | 97 | VRF_CNTNT | VARCHAR2 | NONE | NO | NO | |||||||||||
268 | 0 | 98 | SMS_FREE_FLAG | VARCHAR2 | NONE | NO | NO | |||||||||||
269 | 0 | 99 | TEMP_CREDLIMIT | VARCHAR2 | NONE | NO | NO | |||||||||||
270 | 0 | 100 | TEMP_TO_DT | VARCHAR2 | NONE | NO | NO | |||||||||||
271 | 0 | 101 | TEMP_FROM_DT | VARCHAR2 | NONE | NO | NO | |||||||||||
272 | 0 | 102 | BONUS_CREDLIMIT | VARCHAR2 | NONE | NO | NO | |||||||||||
273 | 0 | 103 | PAY_FLAG | VARCHAR2 | NONE | NO | NO | |||||||||||
274 | 0 | 104 | INT_CHDCMP | VARCHAR2 | NONE | NO | NO | |||||||||||
275 | 0 | 105 | INT_NOTION | VARCHAR2 | NONE | NO | NO | |||||||||||
276 | 0 | 106 | INT_CUNOT | VARCHAR2 | NONE | NO | NO | |||||||||||
277 | 0 | 107 | INT_CURCMP | VARCHAR2 | NONE | NO | NO | |||||||||||
278 | 0 | 108 | INT_CMPOND | VARCHAR2 | NONE | NO | NO | |||||||||||
279 | 0 | 109 | IMP_FLAG | VARCHAR2 | NONE | NO | NO | |||||||||||
280 | 0 | 110 | NCRED_RSN | VARCHAR2 | NONE | NO | NO | |||||||||||
281 | 0 | 111 | MONTR_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
282 | 0 | 112 | CRED_LMT2 | VARCHAR2 | NONE | NO | NO | |||||||||||
283 | 0 | 113 | CRED_FLAG | VARCHAR2 | NONE | NO | NO | |||||||||||
284 | 0 | 114 | BAL_CHARGE01 | VARCHAR2 | NONE | NO | NO | |||||||||||
285 | 0 | 115 | BAL_CHARGE02 | VARCHAR2 | NONE | NO | NO | |||||||||||
286 | 0 | 116 | BAL_CHARGE03 | VARCHAR2 | NONE | NO | NO | |||||||||||
287 | 0 | 117 | BAL_CHARGE04 | VARCHAR2 | NONE | NO | NO | |||||||||||
288 | 0 | 118 | BAL_CHARGE05 | VARCHAR2 | NONE | NO | NO | |||||||||||
289 | 0 | 119 | BAL_CHARGE06 | VARCHAR2 | NONE | NO | NO | |||||||||||
290 | 0 | 120 | BAL_CHARGE07 | VARCHAR2 | NONE | NO | NO | |||||||||||
291 | 0 | 121 | BAL_CHARGE08 | VARCHAR2 | NONE | NO | NO | |||||||||||
292 | 0 | 122 | BAL_CHARGE09 | VARCHAR2 | NONE | NO | NO | |||||||||||
293 | 0 | 123 | BAL_CHARGE10 | VARCHAR2 | NONE | NO | NO | |||||||||||
294 | 0 | 124 | LAST_CHARGE01 | VARCHAR2 | NONE | NO | NO | |||||||||||
295 | 0 | 125 | LAST_CHARGE02 | VARCHAR2 | NONE | NO | NO | |||||||||||
296 | 0 | 126 | LAST_CHARGE03 | VARCHAR2 | NONE | NO | NO | |||||||||||
297 | 0 | 127 | LAST_CHARGE04 | VARCHAR2 | NONE | NO | NO | |||||||||||
298 | 0 | 128 | LAST_CHARGE05 | VARCHAR2 | NONE | NO | NO | |||||||||||
299 | 0 | 129 | LAST_CHARGE06 | VARCHAR2 | NONE | NO | NO | |||||||||||
300 | 0 | 130 | LAST_CHARGE07 | VARCHAR2 | NONE | NO | NO | |||||||||||
301 | 0 | 131 | LAST_CHARGE08 | VARCHAR2 | NONE | NO | NO | |||||||||||
302 | 0 | 132 | LAST_CHARGE09 | VARCHAR2 | NONE | NO | NO | |||||||||||
303 | 0 | 133 | LAST_CHARGE10 | VARCHAR2 | NONE | NO | NO | |||||||||||
304 | 0 | 134 | DES_FLAG | VARCHAR2 | NONE | NO | NO | |||||||||||
305 | 0 | 135 | DESRESN_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
306 | 0 | 136 | STP_NOT | VARCHAR2 | NONE | NO | NO | |||||||||||
307 | 0 | 137 | STP_CMP | VARCHAR2 | NONE | NO | NO | |||||||||||
308 | 0 | 138 | STP_CHRG | VARCHAR2 | NONE | NO | NO | |||||||||||
309 | 0 | 139 | BAL_CMPFEE | VARCHAR2 | NONE | NO | NO | |||||||||||
310 | 0 | 140 | NOINTEREST_FLAG | VARCHAR2 | NONE | NO | NO | |||||||||||
311 | 0 | 141 | NOINTEREST_LIMIT | VARCHAR2 | NONE | NO | NO | |||||||||||
312 | 0 | 142 | NOINTEREST_PERC | VARCHAR2 | NONE | NO | NO | |||||||||||
313 | 0 | 143 | NOINTEREST_MAX | VARCHAR2 | NONE | NO | NO | |||||||||||
314 | 0 | 144 | NOINTEREST_MIN | VARCHAR2 | NONE | NO | NO | |||||||||||
315 | 0 | 145 | MP_REM_PPL | VARCHAR2 | NONE | NO | NO | |||||||||||
316 | 0 | 146 | CRED_LMT3 | VARCHAR2 | NONE | NO | NO | |||||||||||
317 | 0 | 147 | MPAUTO_GW_PRSNT_PLAN | VARCHAR2 | NONE | NO | NO | |||||||||||
318 | 0 | 148 | MPAUTO_GW_PRSNT_NUM | VARCHAR2 | NONE | NO | NO | |||||||||||
319 | 0 | 149 | MPAUTO_GW_NEXT_PLAN | VARCHAR2 | NONE | NO | NO | |||||||||||
320 | 0 | 150 | MPAUTO_GW_NEXT_NUM | VARCHAR2 | NONE | NO | NO | |||||||||||
321 | 0 | 151 | MPAUTO_GW_MODIFY_DT | VARCHAR2 | NONE | NO | NO | |||||||||||
322 | 0 | 152 | INT_CODE | VARCHAR2 | NONE | NO | NO | |||||||||||
323 | 0 | 153 | CRED_CHDAY | CHAR | NONE | NO | NO | |||||||||||
324 | 0 | 154 | ADJ_FLAG | VARCHAR2 | NONE | NO | NO | |||||||||||
325 | 0 | 155 | NOTE_RST | VARCHAR2 | NONE | NO | NO | |||||||||||
326 | 0 | 156 | NOTE_RSN | VARCHAR2 | NONE | NO | NO | |||||||||||
327 | 0 | 157 | RECLA_CODE | CHAR | NONE | NO | NO | |||||||||||
328 | 0 | 159 | BDP_LOAD_TIME | DATE | NONE | NO | NO | |||||||||||
329 | 0 | 160 | POINT_CUM2 | VARCHAR2 | NONE | NO | NO | |||||||||||
330 | 0 | 161 | POINT_REV | VARCHAR2 | NONE | NO | NO | |||||||||||
331 | 0 | 162 | PAYMT_UNCL | VARCHAR2 | NONE | NO | NO | |||||||||||
332 | 0 | 163 | QUERY_CODE | VARCHAR2 | NONE | NO | 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 |
# | Partition Position |
Partition Name |
Composite | Subpartition Count |
Num Rows |
Sample Size |
Perc | Last Analyzed | Blocks | Avg Row Len |
Global Stats |
User Stats |
Staleness Perc |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | Partition Position |
Partition Name |
Composite | Subpartition Count |
Num Rows |
Sample Size |
Perc | Last Analyzed | Blocks | Avg Row Len |
Global Stats |
User Stats |
Staleness Perc |
# | Constraint Name |
Constraint Type |
R Owner | R Constraint Name |
Delete Rule |
Status | Defferable | Deferred | Validated | Generated | Rely | Last Change |
Index Owner |
Index Name |
Invalid | View Related |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SYS_C00218196 | C | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | 28-FEB-15 | ||||||||
2 | SYS_C00218197 | C | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | GENERATED NAME | 28-FEB-15 | ||||||||
# | Constraint Name |
Constraint Type |
R Owner | R Constraint Name |
Delete Rule |
Status | Defferable | Deferred | Validated | Generated | Rely | Last Change |
Index Owner |
Index Name |
Invalid | View Related |
# | Constraint Name |
Constraint Type |
R Owner | R Constraint Name |
Delete Rule |
Status | Defferable | Deferred | Validated | Generated | Rely | Last Change |
Index Owner |
Index Name |
Invalid | View Related |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | Constraint Name |
Constraint Type |
R Owner | R Constraint Name |
Delete Rule |
Status | Defferable | Deferred | Validated | Generated | Rely | Last Change |
Index Owner |
Index Name |
Invalid | View Related |
# | Table Name | Owner | Version Type | Save Time | Last Analyzed | Num Rows | Sample Size |
Perc | Blocks | Avg Row Len |
---|---|---|---|---|---|---|---|---|---|---|
1 | CUP_ACCOUNT | DDS | CURRENT | 04-MAR-15 | 14027490 | 1402749 | 10.0 | 777516 | 449 | |
2 | CUP_ACCOUNT | DDS | HISTORY | 04-MAR-15 03.04.33.662844 AM +08:00 | 03-MAR-15 | 14023440 | 1402344 | 10.0 | 705305 | 448 |
3 | CUP_ACCOUNT | DDS | HISTORY | 03-MAR-15 03.53.43.746504 AM +08:00 | 02-MAR-15 | 14015820 | 1401582 | 10.0 | 606137 | 446 |
4 | CUP_ACCOUNT | DDS | HISTORY | 02-MAR-15 04.20.39.578723 AM +08:00 | 01-MAR-15 | 14014550 | 1401455 | 10.0 | 512837 | 448 |
5 | CUP_ACCOUNT | DDS | HISTORY | 01-MAR-15 02.49.54.971100 AM +08:00 | 28-FEB-15 | 14018950 | 1401895 | 10.0 | 450435 | 447 |
6 | CUP_ACCOUNT | DDS | HISTORY | 28-FEB-15 03.29.31.734655 PM +08:00 | ||||||
7 | CUP_ACCOUNT | ODS | CURRENT | |||||||
# | Table Name | Owner | Version Type | Save Time | Last Analyzed | Num Rows | Sample Size |
Perc | Blocks | Avg Row Len |
# | 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 |
Stats Versions |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | IDX_CUP_ACCOUNT_ANBR_CC | DDS | NORMAL | NO | 1 | N | NONUNIQUE | 2 | 13966690 | 1396669 | 10.0 | 2015-03-04/03:04:44 | 13966690 | 2 | 27880 | 1 | 1 | 3864290 | YES | NO | NO | Versions | |
2 | IDX_CUP_ACCOUNT_MDT | DDS | BITMAP | NO | 1 | N | NONUNIQUE | 1 | 478 | 478 | 100.0 | 2015-03-04/03:04:40 | 24 | 1 | 238 | 9 | 19 | 478 | YES | NO | NO | Versions | |
# | 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 |
Stats Versions |
# | 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 |
Stats Versions |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | IDX_CUP_ACCOUNT_EDT | ODS | BITMAP | NO | 1 | N | NONUNIQUE | 1 | 614 | 614 | 100.0 | 2015-03-04/06:12:55 | 3 | 1 | 307 | 102 | 204 | 614 | NO | NO | Versions | ||
4 | IDX_CUP_ACCOUNT_EDT_CNMBR_CCD | ODS | FUNCTION-BASED NORMAL | NO | 1 | N | NONUNIQUE | 3 | 7924442 | 7924442 | 100.0 | 2015-03-04/06:13:42 | 7924442 | 2 | 20745 | 1 | 1 | 929320 | NO | NO | Versions | ||
# | 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 |
Stats Versions |
# | Index Name | Owner | Partition Position |
Partition Name |
Subpartition Count |
Num Rows |
Sample Size |
Perc | Last Analyzed | Distinct Keys |
Blevel | Leaf Blocks |
Avg Leaf Blocks per Key |
Avg Data Blocks per Key |
Clustering Factor |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | Index Name | Owner | Partition Position |
Partition Name |
Subpartition Count |
Num Rows |
Sample Size |
Perc | Last Analyzed | Distinct Keys |
Blevel | Leaf Blocks |
Avg Leaf Blocks per Key |
Avg Data Blocks per Key |
Clustering Factor |
# | Index Name | Owner | Version Type | Save Time | Last Analyzed | Num Rows |
Sample Size |
Perc | Distinct Keys |
Blevel | Leaf Blocks |
Avg Leaf Blocks per Key |
Avg Data Blocks per Key |
Clustering Factor |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | IDX_CUP_ACCOUNT_ANBR_CC | DDS | CURRENT | 2015-03-04/03:04:44 | 13966690 | 1396669 | 10.0 | 13966690 | 2 | 27880 | 1 | 1 | 3864290 | |
2 | IDX_CUP_ACCOUNT_ANBR_CC | DDS | HISTORY | 04-MAR-15 03.04.44.176890 AM +08:00 | 2015-03-04/03:02:00 | 14029885 | 14029885 | 100.0 | 14029885 | 2 | 28004 | 1 | 1 | 3966243 |
5 | IDX_CUP_ACCOUNT_MDT | DDS | CURRENT | 2015-03-04/03:04:40 | 478 | 478 | 100.0 | 24 | 1 | 238 | 9 | 19 | 478 | |
6 | IDX_CUP_ACCOUNT_MDT | DDS | HISTORY | 04-MAR-15 03.04.40.093102 AM +08:00 | 2015-03-04/03:00:57 | 478 | 478 | 100.0 | 24 | 1 | 238 | 9 | 19 | 478 |
# | Index Name | Owner | Version Type | Save Time | Last Analyzed | Num Rows |
Sample Size |
Perc | Distinct Keys |
Blevel | Leaf Blocks |
Avg Leaf Blocks per Key |
Avg Data Blocks per Key |
Clustering Factor |
# | Index Name | Owner | Version Type | Save Time | Last Analyzed | Num Rows |
Sample Size |
Perc | Distinct Keys |
Blevel | Leaf Blocks |
Avg Leaf Blocks per Key |
Avg Data Blocks per Key |
Clustering Factor |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | IDX_CUP_ACCOUNT_EDT | ODS | CURRENT | 2015-03-04/06:12:55 | 614 | 614 | 100.0 | 3 | 1 | 307 | 102 | 204 | 614 | |
4 | IDX_CUP_ACCOUNT_EDT_CNMBR_CCD | ODS | CURRENT | 2015-03-04/06:13:42 | 7924442 | 7924442 | 100.0 | 7924442 | 2 | 20745 | 1 | 1 | 929320 | |
# | Index Name | Owner | Version Type | Save Time | Last Analyzed | Num Rows |
Sample Size |
Perc | Distinct Keys |
Blevel | Leaf Blocks |
Avg Leaf Blocks per Key |
Avg Data Blocks per Key |
Clustering Factor |
# | Name | Inst | Ord | Is Default |
Is Modified |
Value | Display Value |
Description |
---|---|---|---|---|---|---|---|---|
1 | _datafile_write_errors_crash_instance | 1 | 1 | FALSE | FALSE | FALSE | datafile write errors crash instance | |
2 | _diag_hm_rc_enabled | 1 | 1 | FALSE | FALSE | FALSE | Parameter to enable/disable Diag HM Reactive Checks | |
3 | _optimizer_distinct_agg_transform | 1 | 1 | FALSE | FALSE | FALSE | Transforms Distinct Aggregates to non-distinct aggregates | |
4 | _optimizer_use_feedback | 1 | 1 | FALSE | FALSE | FALSE | optimizer use feedback | |
5 | audit_file_dest | 1 | 1 | FALSE | FALSE | /oracle/app/oracle/admin/bdpdb/adump | Directory in which auditing files are to reside | |
6 | audit_sys_operations | 1 | 1 | FALSE | FALSE | TRUE | enable sys auditing | |
7 | audit_trail | 1 | 1 | FALSE | FALSE | OS | enable system auditing | |
8 | compatible | 1 | 1 | FALSE | FALSE | 11.2.0.0.0 | Database will be completely compatible with this software version | |
9 | control_files | 1 | 1 | FALSE | FALSE | /oradata/bdpdb/control01.ctl | control file names list | |
10 | control_files | 1 | 2 | FALSE | FALSE | /oradata/bdpdb/control02.ctl | control file names list | |
11 | control_files | 1 | 3 | FALSE | FALSE | /oradata/bdpdb/control03.ctl | control file names list | |
12 | db_block_size | 1 | 1 | FALSE | FALSE | 16384 | Size of database block in bytes | |
13 | db_cache_size | 1 | 1 | FALSE | FALSE | 10737418240 | 10G | Size of DEFAULT buffer pool for standard block size buffers |
14 | db_domain | 1 | 1 | FALSE | FALSE | directory part of global database name stored with CREATE DATABASE | ||
15 | db_files | 1 | 1 | FALSE | FALSE | 2000 | max allowable # db files | |
16 | db_lost_write_protect | 1 | 1 | FALSE | FALSE | TYPICAL | enable lost write detection | |
17 | db_name | 1 | 1 | FALSE | FALSE | bdpdb | database name specified in CREATE DATABASE | |
18 | db_writer_processes | 1 | 1 | FALSE | FALSE | 2 | number of background database writer processes to start | |
19 | deferred_segment_creation | 1 | 1 | FALSE | FALSE | FALSE | defer segment creation to first insert | |
20 | diagnostic_dest | 1 | 1 | FALSE | FALSE | /oracle/app/oracle | diagnostic base directory | |
21 | event | 1 | 1 | FALSE | FALSE | 28401 TRACE NAME CONTEXT FOREVER, LEVEL 1 | debug event control - default null string | |
22 | filesystemio_options | 1 | 1 | FALSE | FALSE | SETALL | IO operations on filesystem files | |
23 | java_pool_size | 1 | 1 | FALSE | FALSE | 0 | size in bytes of java pool | |
24 | large_pool_size | 1 | 1 | FALSE | FALSE | 134217728 | 128M | size in bytes of large pool |
25 | log_archive_dest_1 | 1 | 1 | FALSE | FALSE | LOCATION=/archivelog | archival destination #1 text string | |
26 | log_archive_format | 1 | 1 | FALSE | FALSE | %t_%s_%r.arc | archival destination format | |
27 | log_buffer | 1 | 1 | FALSE | FALSE | 52428800 | redo circular buffer size | |
28 | memory_target | 1 | 1 | FALSE | FALSE | 0 | Target size of Oracle SGA and PGA memory | |
29 | open_cursors | 1 | 1 | FALSE | FALSE | 300 | max # cursors per session | |
30 | os_authent_prefix | 1 | 1 | FALSE | FALSE | prefix for auto-logon accounts | ||
31 | parallel_max_servers | 1 | 1 | FALSE | FALSE | 10 | maximum parallel query servers per instance | |
32 | pga_aggregate_target | 1 | 1 | FALSE | FALSE | 16106127360 | 15G | Target size for the aggregate PGA memory consumed by the instance |
33 | processes | 1 | 1 | FALSE | FALSE | 600 | user processes | |
34 | remote_login_passwordfile | 1 | 1 | FALSE | FALSE | EXCLUSIVE | password file usage parameter | |
35 | resource_limit | 1 | 1 | FALSE | FALSE | TRUE | master switch for resource limit | |
36 | result_cache_max_size | 1 | 1 | FALSE | FALSE | 0 | maximum amount of memory to be used by the cache | |
37 | sec_case_sensitive_logon | 1 | 1 | FALSE | FALSE | FALSE | case sensitive password enabled for logon | |
38 | sessions | 1 | 1 | FALSE | FALSE | 936 | user and system sessions | |
39 | sga_target | 1 | 1 | FALSE | FALSE | 0 | Target size of SGA | |
40 | shared_pool_size | 1 | 1 | FALSE | FALSE | 2147483648 | 2G | size in bytes of shared pool |
41 | undo_retention | 1 | 1 | FALSE | FALSE | 10800 | undo retention in seconds | |
42 | 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 | _datafile_write_errors_crash_instance | 1 | FALSE | FALSE | FALSE | datafile write errors crash instance | |
3 | _diag_hm_rc_enabled | 1 | FALSE | FALSE | FALSE | Parameter to enable/disable Diag HM Reactive Checks | |
4 | _optimizer_distinct_agg_transform | 1 | FALSE | FALSE | FALSE | Transforms Distinct Aggregates to non-distinct aggregates | |
5 | _optimizer_use_feedback | 1 | FALSE | FALSE | FALSE | optimizer use feedback | |
6 | active_instance_count | 0 | TRUE | FALSE | number of active instances in the cluster database | ||
7 | aq_tm_processes | 1 | TRUE | FALSE | 1 | number of AQ Time Managers to start | |
8 | archive_lag_target | 1 | TRUE | FALSE | 0 | Maximum number of seconds of redos the standby could lose | |
9 | asm_diskgroups | 0 | TRUE | FALSE | disk groups to mount automatically | ||
10 | asm_diskstring | 0 | TRUE | FALSE | disk set locations for discovery | ||
11 | asm_power_limit | 1 | TRUE | FALSE | 1 | number of parallel relocations for disk rebalancing | |
12 | asm_preferred_read_failure_groups | 0 | TRUE | FALSE | preferred read failure groups | ||
13 | audit_file_dest | 1 | FALSE | FALSE | /oracle/app/oracle/admin/bdpdb/adump | Directory in which auditing files are to reside | |
14 | audit_sys_operations | 1 | FALSE | FALSE | TRUE | enable sys auditing | |
15 | audit_syslog_level | 0 | TRUE | FALSE | Syslog facility and level | ||
16 | audit_trail | 1 | FALSE | FALSE | OS | enable system auditing | |
17 | awr_snapshot_time_offset | 1 | TRUE | FALSE | 0 | Setting for AWR Snapshot Time Offset | |
18 | background_core_dump | 1 | TRUE | FALSE | partial | Core Size for Background Processes | |
19 | background_dump_dest | 1 | TRUE | FALSE | /oracle/app/oracle/diag/rdbms/bdpdb/bdpdb/trace | Detached process dump directory | |
20 | backup_tape_io_slaves | 1 | TRUE | FALSE | FALSE | BACKUP Tape I/O slaves | |
21 | bitmap_merge_area_size | 1 | TRUE | FALSE | 1048576 | maximum memory allow for BITMAP MERGE | |
22 | blank_trimming | 1 | TRUE | FALSE | FALSE | blank trimming semantics parameter | |
23 | buffer_pool_keep | 1 | TRUE | FALSE | Number of database blocks/latches in keep buffer pool | ||
24 | buffer_pool_recycle | 1 | TRUE | FALSE | Number of database blocks/latches in recycle buffer pool | ||
25 | cell_offload_compaction | 1 | TRUE | FALSE | ADAPTIVE | Cell packet compaction strategy | |
26 | cell_offload_decryption | 1 | TRUE | FALSE | TRUE | enable SQL processing offload of encrypted data to cells | |
27 | cell_offload_parameters | 1 | TRUE | FALSE | Additional cell offload parameters | ||
28 | cell_offload_plan_display | 1 | TRUE | FALSE | AUTO | Cell offload explain plan display | |
29 | cell_offload_processing | 1 | TRUE | FALSE | TRUE | enable SQL processing offload to cells | |
30 | circuits | 0 | TRUE | FALSE | max number of circuits | ||
31 | client_result_cache_lag | 1 | TRUE | FALSE | 3000 | client result cache maximum lag in milliseconds | |
32 | client_result_cache_size | 1 | TRUE | FALSE | 0 | client result cache max size in bytes | |
33 | clonedb | 1 | TRUE | FALSE | FALSE | clone database | |
34 | cluster_database | 1 | TRUE | FALSE | FALSE | if TRUE startup in cluster database mode | |
35 | cluster_database_instances | 1 | TRUE | FALSE | 1 | number of instances to use for sizing cluster db SGA structures | |
36 | cluster_interconnects | 0 | TRUE | FALSE | interconnects for RAC use | ||
37 | commit_logging | 0 | TRUE | FALSE | transaction commit log write behaviour | ||
38 | commit_point_strength | 1 | TRUE | FALSE | 1 | Bias this node has toward not preparing in a two-phase commit | |
39 | commit_wait | 0 | TRUE | FALSE | transaction commit log wait behaviour | ||
40 | commit_write | 0 | TRUE | FALSE | transaction commit log write behaviour | ||
41 | compatible | 1 | FALSE | FALSE | 11.2.0.0.0 | Database will be completely compatible with this software version | |
42 | control_file_record_keep_time | 1 | TRUE | FALSE | 7 | control file record keep time in days | |
43 | control_files | 1 | FALSE | FALSE | /oradata/bdpdb/control01.ctl | control file names list | |
44 | control_files | 2 | FALSE | FALSE | /oradata/bdpdb/control02.ctl | control file names list | |
45 | control_files | 3 | FALSE | FALSE | /oradata/bdpdb/control03.ctl | control file names list | |
46 | control_management_pack_access | 1 | TRUE | FALSE | DIAGNOSTIC+TUNING | declares which manageability packs are enabled | |
47 | core_dump_dest | 1 | TRUE | FALSE | /oracle/app/oracle/diag/rdbms/bdpdb/bdpdb/cdump | Core dump directory | |
48 | cpu_count | 1 | TRUE | FALSE | 24 | number of CPUs for this instance | |
49 | create_bitmap_area_size | 1 | TRUE | FALSE | 8388608 | size of create bitmap buffer for bitmap index | |
50 | create_stored_outlines | 0 | TRUE | FALSE | create stored outlines for DML statements | ||
51 | cursor_bind_capture_destination | 1 | TRUE | FALSE | memory+disk | Allowed destination for captured bind variables | |
52 | cursor_sharing | 1 | TRUE | FALSE | EXACT | cursor sharing mode | |
53 | cursor_space_for_time | 1 | TRUE | FALSE | FALSE | use more memory in order to get faster execution | |
54 | db_16k_cache_size | 1 | TRUE | FALSE | 0 | Size of cache for 16K buffers | |
55 | db_2k_cache_size | 1 | TRUE | FALSE | 0 | Size of cache for 2K buffers | |
56 | db_32k_cache_size | 1 | TRUE | FALSE | 0 | Size of cache for 32K buffers | |
57 | db_4k_cache_size | 1 | TRUE | FALSE | 0 | Size of cache for 4K buffers | |
58 | db_8k_cache_size | 1 | TRUE | FALSE | 0 | Size of cache for 8K buffers | |
59 | db_block_buffers | 1 | TRUE | FALSE | 0 | Number of database blocks cached in memory | |
60 | db_block_checking | 1 | TRUE | FALSE | FALSE | header checking and data and index block checking | |
61 | db_block_checksum | 1 | TRUE | FALSE | TYPICAL | store checksum in db blocks and check during reads | |
62 | db_block_size | 1 | FALSE | FALSE | 16384 | Size of database block in bytes | |
63 | db_cache_advice | 1 | TRUE | FALSE | ON | Buffer cache sizing advisory | |
64 | db_cache_size | 1 | FALSE | FALSE | 10737418240 | 10G | Size of DEFAULT buffer pool for standard block size buffers |
65 | db_create_file_dest | 1 | TRUE | FALSE | default database location | ||
66 | db_create_online_log_dest_1 | 1 | TRUE | FALSE | online log/controlfile destination #1 | ||
67 | db_create_online_log_dest_2 | 1 | TRUE | FALSE | online log/controlfile destination #2 | ||
68 | db_create_online_log_dest_3 | 1 | TRUE | FALSE | online log/controlfile destination #3 | ||
69 | db_create_online_log_dest_4 | 1 | TRUE | FALSE | online log/controlfile destination #4 | ||
70 | db_create_online_log_dest_5 | 1 | TRUE | FALSE | online log/controlfile destination #5 | ||
71 | db_domain | 1 | FALSE | FALSE | directory part of global database name stored with CREATE DATABASE | ||
72 | db_file_multiblock_read_count | 1 | TRUE | FALSE | 64 | db block to be read each IO | |
73 | db_file_name_convert | 0 | TRUE | FALSE | datafile name convert patterns and strings for standby/clone db | ||
74 | db_files | 1 | FALSE | FALSE | 2000 | max allowable # db files | |
75 | db_flash_cache_file | 1 | TRUE | FALSE | flash cache file for default block size | ||
76 | db_flash_cache_size | 1 | TRUE | FALSE | 0 | flash cache size for db_flash_cache_file | |
77 | db_flashback_retention_target | 1 | TRUE | FALSE | 1440 | Maximum Flashback Database log retention time in minutes. | |
78 | db_keep_cache_size | 1 | TRUE | FALSE | 0 | Size of KEEP buffer pool for standard block size buffers | |
79 | db_lost_write_protect | 1 | FALSE | FALSE | TYPICAL | enable lost write detection | |
80 | db_name | 1 | FALSE | FALSE | bdpdb | database name specified in CREATE DATABASE | |
81 | db_recovery_file_dest | 1 | TRUE | FALSE | default database recovery file location | ||
82 | db_recovery_file_dest_size | 1 | TRUE | FALSE | 0 | database recovery files size limit | |
83 | db_recycle_cache_size | 1 | TRUE | FALSE | 0 | Size of RECYCLE buffer pool for standard block size buffers | |
84 | db_securefile | 1 | TRUE | FALSE | PERMITTED | permit securefile storage during lob creation | |
85 | db_ultra_safe | 1 | TRUE | FALSE | OFF | Sets defaults for other parameters that control protection levels | |
86 | db_unique_name | 1 | TRUE | FALSE | bdpdb | Database Unique Name | |
87 | db_unrecoverable_scn_tracking | 1 | TRUE | FALSE | TRUE | Track nologging SCN in controlfile | |
88 | db_writer_processes | 1 | FALSE | FALSE | 2 | number of background database writer processes to start | |
89 | dbwr_io_slaves | 1 | TRUE | FALSE | 0 | DBWR I/O slaves | |
90 | ddl_lock_timeout | 1 | TRUE | FALSE | 0 | timeout to restrict the time that ddls wait for dml lock | |
91 | deferred_segment_creation | 1 | FALSE | FALSE | FALSE | defer segment creation to first insert | |
92 | dg_broker_config_file1 | 1 | TRUE | FALSE | /oracle/app/oracle/product/11.2.0/dbhome_1/dbs/dr1bdpdb.dat | data guard broker configuration file #1 | |
93 | dg_broker_config_file2 | 1 | TRUE | FALSE | /oracle/app/oracle/product/11.2.0/dbhome_1/dbs/dr2bdpdb.dat | data guard broker configuration file #2 | |
94 | dg_broker_start | 1 | TRUE | FALSE | FALSE | start Data Guard broker (DMON process) | |
95 | diagnostic_dest | 1 | FALSE | FALSE | /oracle/app/oracle | diagnostic base directory | |
96 | disk_asynch_io | 1 | TRUE | FALSE | TRUE | Use asynch I/O for random access devices | |
97 | dispatchers | 0 | TRUE | FALSE | specifications of dispatchers | ||
98 | distributed_lock_timeout | 1 | TRUE | FALSE | 60 | number of seconds a distributed transaction waits for a lock | |
99 | dml_locks | 1 | TRUE | FALSE | 4116 | dml locks - one for each table modified in a transaction | |
100 | dst_upgrade_insert_conv | 1 | TRUE | FALSE | TRUE | Enables/Disables internal conversions during DST upgrade | |
101 | enable_ddl_logging | 1 | TRUE | FALSE | FALSE | enable ddl logging | |
102 | event | 1 | FALSE | FALSE | 28401 TRACE NAME CONTEXT FOREVER, LEVEL 1 | debug event control - default null string | |
103 | fal_client | 1 | TRUE | FALSE | FAL client | ||
104 | fal_server | 1 | TRUE | FALSE | FAL server list | ||
105 | fast_start_io_target | 1 | TRUE | FALSE | 0 | Upper bound on recovery reads | |
106 | fast_start_mttr_target | 1 | TRUE | FALSE | 0 | MTTR target in seconds | |
107 | fast_start_parallel_rollback | 1 | TRUE | FALSE | LOW | max number of parallel recovery slaves that may be used | |
108 | file_mapping | 1 | TRUE | FALSE | FALSE | enable file mapping | |
109 | fileio_network_adapters | 0 | TRUE | FALSE | Network Adapters for File I/O | ||
110 | filesystemio_options | 1 | FALSE | FALSE | SETALL | IO operations on filesystem files | |
111 | fixed_date | 1 | TRUE | FALSE | fixed SYSDATE value | ||
112 | gcs_server_processes | 1 | TRUE | FALSE | 0 | number of background gcs server processes to start | |
113 | global_context_pool_size | 1 | TRUE | FALSE | Global Application Context Pool Size in Bytes | ||
114 | global_names | 1 | TRUE | FALSE | FALSE | enforce that database links have same name as remote database | |
115 | global_txn_processes | 1 | TRUE | FALSE | 1 | number of background global transaction processes to start | |
116 | hash_area_size | 1 | TRUE | FALSE | 131072 | size of in-memory hash work area | |
117 | hi_shared_memory_address | 1 | TRUE | FALSE | 0 | SGA starting address (high order 32-bits on 64-bit platforms) | |
118 | hs_autoregister | 1 | TRUE | FALSE | TRUE | enable automatic server DD updates in HS agent self-registration | |
119 | ifile | 0 | TRUE | FALSE | include file in init.ora | ||
120 | instance_groups | 0 | TRUE | FALSE | list of instance group names | ||
121 | instance_name | 1 | TRUE | FALSE | bdpdb | instance name supported by the instance | |
122 | instance_number | 1 | TRUE | FALSE | 0 | instance number | |
123 | instance_type | 1 | TRUE | FALSE | RDBMS | type of instance to be executed | |
124 | java_jit_enabled | 1 | TRUE | FALSE | TRUE | Java VM JIT enabled | |
125 | java_max_sessionspace_size | 1 | TRUE | FALSE | 0 | max allowed size in bytes of a Java sessionspace | |
126 | java_pool_size | 1 | FALSE | FALSE | 0 | size in bytes of java pool | |
127 | java_soft_sessionspace_limit | 1 | TRUE | FALSE | 0 | warning limit on size in bytes of a Java sessionspace | |
128 | job_queue_processes | 1 | TRUE | FALSE | 1000 | maximum number of job queue slave processes | |
129 | large_pool_size | 1 | FALSE | FALSE | 134217728 | 128M | size in bytes of large pool |
130 | ldap_directory_access | 1 | TRUE | FALSE | NONE | RDBMS's LDAP access option | |
131 | ldap_directory_sysauth | 1 | TRUE | FALSE | no | OID usage parameter | |
132 | license_max_sessions | 1 | TRUE | FALSE | 0 | maximum number of non-system user sessions allowed | |
133 | license_max_users | 1 | TRUE | FALSE | 0 | maximum number of named users that can be created in the database | |
134 | license_sessions_warning | 1 | TRUE | FALSE | 0 | warning level for number of non-system user sessions | |
135 | listener_networks | 0 | TRUE | FALSE | listener registration networks | ||
136 | local_listener | 0 | TRUE | FALSE | local listener | ||
137 | lock_name_space | 0 | TRUE | FALSE | lock name space used for generating lock names for standby/clone database | ||
138 | lock_sga | 1 | TRUE | FALSE | FALSE | Lock entire SGA in physical memory | |
139 | log_archive_config | 1 | TRUE | FALSE | log archive config parameter | ||
140 | log_archive_dest | 1 | TRUE | FALSE | archival destination text string | ||
141 | log_archive_dest_1 | 1 | FALSE | FALSE | LOCATION=/archivelog | archival destination #1 text string | |
142 | log_archive_dest_10 | 1 | TRUE | FALSE | archival destination #10 text string | ||
143 | log_archive_dest_11 | 1 | TRUE | FALSE | archival destination #11 text string | ||
144 | log_archive_dest_12 | 1 | TRUE | FALSE | archival destination #12 text string | ||
145 | log_archive_dest_13 | 1 | TRUE | FALSE | archival destination #13 text string | ||
146 | log_archive_dest_14 | 1 | TRUE | FALSE | archival destination #14 text string | ||
147 | log_archive_dest_15 | 1 | TRUE | FALSE | archival destination #15 text string | ||
148 | log_archive_dest_16 | 1 | TRUE | FALSE | archival destination #16 text string | ||
149 | log_archive_dest_17 | 1 | TRUE | FALSE | archival destination #17 text string | ||
150 | log_archive_dest_18 | 1 | TRUE | FALSE | archival destination #18 text string | ||
151 | log_archive_dest_19 | 1 | TRUE | FALSE | archival destination #19 text string | ||
152 | log_archive_dest_2 | 1 | TRUE | FALSE | archival destination #2 text string | ||
153 | log_archive_dest_20 | 1 | TRUE | FALSE | archival destination #20 text string | ||
154 | log_archive_dest_21 | 1 | TRUE | FALSE | archival destination #21 text string | ||
155 | log_archive_dest_22 | 1 | TRUE | FALSE | archival destination #22 text string | ||
156 | log_archive_dest_23 | 1 | TRUE | FALSE | archival destination #23 text string | ||
157 | log_archive_dest_24 | 1 | TRUE | FALSE | archival destination #24 text string | ||
158 | log_archive_dest_25 | 1 | TRUE | FALSE | archival destination #25 text string | ||
159 | log_archive_dest_26 | 1 | TRUE | FALSE | archival destination #26 text string | ||
160 | log_archive_dest_27 | 1 | TRUE | FALSE | archival destination #27 text string | ||
161 | log_archive_dest_28 | 1 | TRUE | FALSE | archival destination #28 text string | ||
162 | log_archive_dest_29 | 1 | TRUE | FALSE | archival destination #29 text string | ||
163 | log_archive_dest_3 | 1 | TRUE | FALSE | archival destination #3 text string | ||
164 | log_archive_dest_30 | 1 | TRUE | FALSE | archival destination #30 text string | ||
165 | log_archive_dest_31 | 1 | TRUE | FALSE | archival destination #31 text string | ||
166 | log_archive_dest_4 | 1 | TRUE | FALSE | archival destination #4 text string | ||
167 | log_archive_dest_5 | 1 | TRUE | FALSE | archival destination #5 text string | ||
168 | log_archive_dest_6 | 1 | TRUE | FALSE | archival destination #6 text string | ||
169 | log_archive_dest_7 | 1 | TRUE | FALSE | archival destination #7 text string | ||
170 | log_archive_dest_8 | 1 | TRUE | FALSE | archival destination #8 text string | ||
171 | log_archive_dest_9 | 1 | TRUE | FALSE | archival destination #9 text string | ||
172 | log_archive_dest_state_1 | 1 | TRUE | FALSE | enable | archival destination #1 state text string | |
173 | log_archive_dest_state_10 | 1 | TRUE | FALSE | enable | archival destination #10 state text string | |
174 | log_archive_dest_state_11 | 1 | TRUE | FALSE | enable | archival destination #11 state text string | |
175 | log_archive_dest_state_12 | 1 | TRUE | FALSE | enable | archival destination #12 state text string | |
176 | log_archive_dest_state_13 | 1 | TRUE | FALSE | enable | archival destination #13 state text string | |
177 | log_archive_dest_state_14 | 1 | TRUE | FALSE | enable | archival destination #14 state text string | |
178 | log_archive_dest_state_15 | 1 | TRUE | FALSE | enable | archival destination #15 state text string | |
179 | log_archive_dest_state_16 | 1 | TRUE | FALSE | enable | archival destination #16 state text string | |
180 | log_archive_dest_state_17 | 1 | TRUE | FALSE | enable | archival destination #17 state text string | |
181 | log_archive_dest_state_18 | 1 | TRUE | FALSE | enable | archival destination #18 state text string | |
182 | log_archive_dest_state_19 | 1 | TRUE | FALSE | enable | archival destination #19 state text string | |
183 | log_archive_dest_state_2 | 1 | TRUE | FALSE | enable | archival destination #2 state text string | |
184 | log_archive_dest_state_20 | 1 | TRUE | FALSE | enable | archival destination #20 state text string | |
185 | log_archive_dest_state_21 | 1 | TRUE | FALSE | enable | archival destination #21 state text string | |
186 | log_archive_dest_state_22 | 1 | TRUE | FALSE | enable | archival destination #22 state text string | |
187 | log_archive_dest_state_23 | 1 | TRUE | FALSE | enable | archival destination #23 state text string | |
188 | log_archive_dest_state_24 | 1 | TRUE | FALSE | enable | archival destination #24 state text string | |
189 | log_archive_dest_state_25 | 1 | TRUE | FALSE | enable | archival destination #25 state text string | |
190 | log_archive_dest_state_26 | 1 | TRUE | FALSE | enable | archival destination #26 state text string | |
191 | log_archive_dest_state_27 | 1 | TRUE | FALSE | enable | archival destination #27 state text string | |
192 | log_archive_dest_state_28 | 1 | TRUE | FALSE | enable | archival destination #28 state text string | |
193 | log_archive_dest_state_29 | 1 | TRUE | FALSE | enable | archival destination #29 state text string | |
194 | log_archive_dest_state_3 | 1 | TRUE | FALSE | enable | archival destination #3 state text string | |
195 | log_archive_dest_state_30 | 1 | TRUE | FALSE | enable | archival destination #30 state text string | |
196 | log_archive_dest_state_31 | 1 | TRUE | FALSE | enable | archival destination #31 state text string | |
197 | log_archive_dest_state_4 | 1 | TRUE | FALSE | enable | archival destination #4 state text string | |
198 | log_archive_dest_state_5 | 1 | TRUE | FALSE | enable | archival destination #5 state text string | |
199 | log_archive_dest_state_6 | 1 | TRUE | FALSE | enable | archival destination #6 state text string | |
200 | log_archive_dest_state_7 | 1 | TRUE | FALSE | enable | archival destination #7 state text string | |
201 | log_archive_dest_state_8 | 1 | TRUE | FALSE | enable | archival destination #8 state text string | |
202 | log_archive_dest_state_9 | 1 | TRUE | FALSE | enable | archival destination #9 state text string | |
203 | log_archive_duplex_dest | 1 | TRUE | FALSE | duplex archival destination text string | ||
204 | log_archive_format | 1 | FALSE | FALSE | %t_%s_%r.arc | archival destination format | |
205 | log_archive_local_first | 1 | TRUE | FALSE | TRUE | Establish EXPEDITE attribute default value | |
206 | log_archive_max_processes | 1 | TRUE | FALSE | 4 | maximum number of active ARCH processes | |
207 | log_archive_min_succeed_dest | 1 | TRUE | FALSE | 1 | minimum number of archive destinations that must succeed | |
208 | log_archive_start | 1 | TRUE | FALSE | FALSE | start archival process on SGA initialization | |
209 | log_archive_trace | 1 | TRUE | FALSE | 0 | Establish archivelog operation tracing level | |
210 | log_buffer | 1 | FALSE | FALSE | 52428800 | redo circular buffer size | |
211 | log_checkpoint_interval | 1 | TRUE | FALSE | 0 | # redo blocks checkpoint threshold | |
212 | log_checkpoint_timeout | 1 | TRUE | FALSE | 1800 | Maximum time interval between checkpoints in seconds | |
213 | log_checkpoints_to_alert | 1 | TRUE | FALSE | FALSE | log checkpoint begin/end to alert file | |
214 | log_file_name_convert | 0 | TRUE | FALSE | logfile name convert patterns and strings for standby/clone db | ||
215 | max_dispatchers | 0 | TRUE | FALSE | max number of dispatchers | ||
216 | max_dump_file_size | 1 | TRUE | FALSE | unlimited | Maximum size (in bytes) of dump file | |
217 | max_enabled_roles | 1 | TRUE | FALSE | 150 | max number of roles a user can have enabled | |
218 | max_shared_servers | 0 | TRUE | FALSE | max number of shared servers | ||
219 | memory_max_target | 1 | TRUE | FALSE | 0 | Max size for Memory Target | |
220 | memory_target | 1 | FALSE | FALSE | 0 | Target size of Oracle SGA and PGA memory | |
221 | nls_calendar | 1 | TRUE | FALSE | NLS calendar system name | ||
222 | nls_comp | 1 | TRUE | FALSE | BINARY | NLS comparison | |
223 | nls_currency | 1 | TRUE | FALSE | NLS local currency symbol | ||
224 | nls_date_format | 1 | TRUE | FALSE | NLS Oracle date format | ||
225 | nls_date_language | 1 | TRUE | FALSE | NLS date language name | ||
226 | nls_dual_currency | 1 | TRUE | FALSE | Dual currency symbol | ||
227 | nls_iso_currency | 1 | TRUE | FALSE | NLS ISO currency territory name | ||
228 | nls_language | 1 | TRUE | FALSE | AMERICAN | NLS language name | |
229 | nls_length_semantics | 1 | TRUE | FALSE | BYTE | create columns using byte or char semantics by default | |
230 | nls_nchar_conv_excp | 1 | TRUE | FALSE | FALSE | NLS raise an exception instead of allowing implicit conversion | |
231 | nls_numeric_characters | 1 | TRUE | FALSE | NLS numeric characters | ||
232 | nls_sort | 1 | TRUE | FALSE | NLS linguistic definition name | ||
233 | nls_territory | 1 | TRUE | FALSE | AMERICA | NLS territory name | |
234 | nls_time_format | 1 | TRUE | FALSE | time format | ||
235 | nls_time_tz_format | 1 | TRUE | FALSE | time with timezone format | ||
236 | nls_timestamp_format | 1 | TRUE | FALSE | time stamp format | ||
237 | nls_timestamp_tz_format | 1 | TRUE | FALSE | timestamp with timezone format | ||
238 | object_cache_max_size_percent | 1 | TRUE | FALSE | 10 | percentage of maximum size over optimal of the user session's object cache | |
239 | object_cache_optimal_size | 1 | TRUE | FALSE | 102400 | optimal size of the user session's object cache in bytes | |
240 | olap_page_pool_size | 1 | TRUE | FALSE | 0 | size of the olap page pool in bytes | |
241 | open_cursors | 1 | FALSE | FALSE | 300 | max # cursors per session | |
242 | open_links | 1 | TRUE | FALSE | 4 | max # open links per session | |
243 | open_links_per_instance | 1 | TRUE | FALSE | 4 | max # open links per instance | |
244 | optimizer_capture_sql_plan_baselines | 1 | TRUE | FALSE | FALSE | automatic capture of SQL plan baselines for repeatable statements | |
245 | optimizer_dynamic_sampling | 1 | TRUE | FALSE | 2 | optimizer dynamic sampling | |
246 | optimizer_features_enable | 1 | TRUE | FALSE | 11.2.0.3 | optimizer plan compatibility parameter | |
247 | optimizer_index_caching | 1 | TRUE | FALSE | 0 | optimizer percent index caching | |
248 | optimizer_index_cost_adj | 1 | TRUE | FALSE | 100 | optimizer index cost adjustment | |
249 | optimizer_mode | 1 | TRUE | FALSE | ALL_ROWS | optimizer mode | |
250 | optimizer_secure_view_merging | 1 | TRUE | FALSE | TRUE | optimizer secure view merging and predicate pushdown/movearound | |
251 | optimizer_use_invisible_indexes | 1 | TRUE | FALSE | FALSE | Usage of invisible indexes (TRUE/FALSE) | |
252 | optimizer_use_pending_statistics | 1 | TRUE | FALSE | FALSE | Control whether to use optimizer pending statistics | |
253 | optimizer_use_sql_plan_baselines | 1 | TRUE | FALSE | TRUE | use of SQL plan baselines for captured sql statements | |
254 | os_authent_prefix | 1 | FALSE | FALSE | prefix for auto-logon accounts | ||
255 | os_roles | 1 | TRUE | FALSE | FALSE | retrieve roles from the operating system | |
256 | parallel_adaptive_multi_user | 1 | TRUE | FALSE | TRUE | enable adaptive setting of degree for multiple user streams | |
257 | parallel_automatic_tuning | 1 | TRUE | FALSE | FALSE | enable intelligent defaults for parallel execution parameters | |
258 | parallel_degree_limit | 1 | TRUE | FALSE | CPU | limit placed on degree of parallelism | |
259 | parallel_degree_policy | 1 | TRUE | FALSE | MANUAL | policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO) | |
260 | parallel_execution_message_size | 1 | TRUE | FALSE | 16384 | message buffer size for parallel execution | |
261 | parallel_force_local | 1 | TRUE | FALSE | FALSE | force single instance execution | |
262 | parallel_instance_group | 1 | TRUE | FALSE | instance group to use for all parallel operations | ||
263 | parallel_io_cap_enabled | 1 | TRUE | FALSE | FALSE | enable capping DOP by IO bandwidth | |
264 | parallel_max_servers | 1 | FALSE | FALSE | 10 | maximum parallel query servers per instance | |
265 | parallel_min_percent | 1 | TRUE | FALSE | 0 | minimum percent of threads required for parallel query | |
266 | parallel_min_servers | 1 | TRUE | FALSE | 0 | minimum parallel query servers per instance | |
267 | parallel_min_time_threshold | 1 | TRUE | FALSE | AUTO | threshold above which a plan is a candidate for parallelization (in seconds) | |
268 | parallel_server | 1 | TRUE | FALSE | FALSE | if TRUE startup in parallel server mode | |
269 | parallel_server_instances | 1 | TRUE | FALSE | 1 | number of instances to use for sizing OPS SGA structures | |
270 | parallel_servers_target | 1 | TRUE | FALSE | 10 | instance target in terms of number of parallel servers | |
271 | parallel_threads_per_cpu | 1 | TRUE | FALSE | 2 | number of parallel execution threads per CPU | |
272 | permit_92_wrap_format | 1 | TRUE | FALSE | TRUE | allow 9.2 or older wrap format in PL/SQL | |
273 | pga_aggregate_target | 1 | FALSE | FALSE | 16106127360 | 15G | Target size for the aggregate PGA memory consumed by the instance |
274 | 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 | |
275 | plsql_ccflags | 1 | TRUE | FALSE | PL/SQL ccflags | ||
276 | plsql_code_type | 1 | TRUE | FALSE | INTERPRETED | PL/SQL code-type | |
277 | plsql_debug | 1 | TRUE | FALSE | FALSE | PL/SQL debug | |
278 | plsql_optimize_level | 1 | TRUE | FALSE | 2 | PL/SQL optimize level | |
279 | plsql_v2_compatibility | 1 | TRUE | FALSE | FALSE | PL/SQL version 2.x compatibility flag | |
280 | plsql_warnings | 1 | TRUE | FALSE | DISABLE:ALL | PL/SQL compiler warnings settings | |
281 | pre_page_sga | 1 | TRUE | FALSE | FALSE | pre-page sga for process | |
282 | processes | 1 | FALSE | FALSE | 600 | user processes | |
283 | processor_group_name | 0 | TRUE | FALSE | Name of the processor group that this instance should run in. | ||
284 | query_rewrite_enabled | 1 | TRUE | FALSE | TRUE | allow rewrite of queries using materialized views if enabled | |
285 | query_rewrite_integrity | 1 | TRUE | FALSE | enforced | perform rewrite using materialized views with desired integrity | |
286 | rdbms_server_dn | 1 | TRUE | FALSE | RDBMS's Distinguished Name | ||
287 | read_only_open_delayed | 1 | TRUE | FALSE | FALSE | if TRUE delay opening of read only files until first access | |
288 | recovery_parallelism | 1 | TRUE | FALSE | 0 | number of server processes to use for parallel recovery | |
289 | recyclebin | 1 | TRUE | FALSE | on | recyclebin processing | |
290 | redo_transport_user | 1 | TRUE | FALSE | Data Guard transport user when using password file | ||
291 | remote_dependencies_mode | 1 | TRUE | FALSE | TIMESTAMP | remote-procedure-call dependencies mode parameter | |
292 | remote_listener | 0 | TRUE | FALSE | remote listener | ||
293 | remote_login_passwordfile | 1 | FALSE | FALSE | EXCLUSIVE | password file usage parameter | |
294 | remote_os_authent | 1 | TRUE | FALSE | FALSE | allow non-secure remote clients to use auto-logon accounts | |
295 | remote_os_roles | 1 | TRUE | FALSE | FALSE | allow non-secure remote clients to use os roles | |
296 | replication_dependency_tracking | 1 | TRUE | FALSE | TRUE | tracking dependency for Replication parallel propagation | |
297 | resource_limit | 1 | FALSE | FALSE | TRUE | master switch for resource limit | |
298 | resource_manager_cpu_allocation | 1 | TRUE | FALSE | 24 | Resource Manager CPU allocation | |
299 | resource_manager_plan | 1 | TRUE | FALSE | resource mgr top plan | ||
300 | result_cache_max_result | 1 | TRUE | FALSE | 5 | maximum result size as percent of cache size | |
301 | result_cache_max_size | 1 | FALSE | FALSE | 0 | maximum amount of memory to be used by the cache | |
302 | result_cache_mode | 1 | TRUE | FALSE | MANUAL | result cache operator usage mode | |
303 | result_cache_remote_expiration | 1 | TRUE | FALSE | 0 | maximum life time (min) for any result using a remote object | |
304 | resumable_timeout | 1 | TRUE | FALSE | 0 | set resumable_timeout | |
305 | rollback_segments | 0 | TRUE | FALSE | undo segment list | ||
306 | sec_case_sensitive_logon | 1 | FALSE | FALSE | FALSE | case sensitive password enabled for logon | |
307 | sec_max_failed_login_attempts | 1 | TRUE | FALSE | 10 | maximum number of failed login attempts on a connection | |
308 | sec_protocol_error_further_action | 1 | TRUE | FALSE | CONTINUE | TTC protocol error continue action | |
309 | sec_protocol_error_trace_action | 1 | TRUE | FALSE | TRACE | TTC protocol error action | |
310 | sec_return_server_release_banner | 1 | TRUE | FALSE | FALSE | whether the server retruns the complete version information | |
311 | serial_reuse | 1 | TRUE | FALSE | disable | reuse the frame segments | |
312 | service_names | 1 | TRUE | FALSE | bdpdb | service names supported by the instance | |
313 | session_cached_cursors | 1 | TRUE | FALSE | 50 | Number of cursors to cache in a session. | |
314 | session_max_open_files | 1 | TRUE | FALSE | 10 | maximum number of open files allowed per session | |
315 | sessions | 1 | FALSE | FALSE | 936 | user and system sessions | |
316 | sga_max_size | 1 | TRUE | FALSE | 13153337344 | 12544M | max total SGA size |
317 | sga_target | 1 | FALSE | FALSE | 0 | Target size of SGA | |
318 | shadow_core_dump | 1 | TRUE | FALSE | partial | Core Size for Shadow Processes | |
319 | shared_memory_address | 1 | TRUE | FALSE | 0 | SGA starting address (low order 32-bits on 64-bit platforms) | |
320 | shared_pool_reserved_size | 1 | TRUE | FALSE | 107374182 | size in bytes of reserved area of shared pool | |
321 | shared_pool_size | 1 | FALSE | FALSE | 2147483648 | 2G | size in bytes of shared pool |
322 | shared_server_sessions | 0 | TRUE | FALSE | max number of shared server sessions | ||
323 | shared_servers | 1 | TRUE | FALSE | 0 | number of shared servers to start up | |
324 | skip_unusable_indexes | 1 | TRUE | FALSE | TRUE | skip unusable indexes if set to TRUE | |
325 | smtp_out_server | 0 | TRUE | FALSE | utl_smtp server and port configuration parameter | ||
326 | sort_area_retained_size | 1 | TRUE | FALSE | 0 | size of in-memory sort work area retained between fetch calls | |
327 | sort_area_size | 1 | TRUE | FALSE | 65536 | size of in-memory sort work area | |
328 | spfile | 1 | TRUE | FALSE | /oracle/app/oracle/product/11.2.0/dbhome_1/dbs/spfilebdpdb.ora | server parameter file | |
329 | sql92_security | 1 | TRUE | FALSE | FALSE | require select privilege for searched update/delete | |
330 | sql_trace | 1 | TRUE | FALSE | FALSE | enable SQL trace | |
331 | sqltune_category | 1 | TRUE | FALSE | DEFAULT | Category qualifier for applying hintsets | |
332 | standby_archive_dest | 1 | TRUE | FALSE | ?/dbs/arch | standby database archivelog destination text string | |
333 | standby_file_management | 1 | TRUE | FALSE | MANUAL | if auto then files are created/dropped automatically on standby | |
334 | star_transformation_enabled | 1 | TRUE | FALSE | FALSE | enable the use of star transformation | |
335 | statistics_level | 1 | TRUE | FALSE | TYPICAL | statistics level | |
336 | streams_pool_size | 1 | TRUE | FALSE | 0 | size in bytes of the streams pool | |
337 | tape_asynch_io | 1 | TRUE | FALSE | TRUE | Use asynch I/O requests for tape devices | |
338 | thread | 1 | TRUE | FALSE | 0 | Redo thread to mount | |
339 | timed_os_statistics | 1 | TRUE | FALSE | 0 | internal os statistic gathering interval in seconds | |
340 | timed_statistics | 1 | TRUE | FALSE | TRUE | maintain internal timing statistics | |
341 | trace_enabled | 1 | TRUE | FALSE | TRUE | enable in memory tracing | |
342 | tracefile_identifier | 0 | TRUE | FALSE | trace file custom identifier | ||
343 | transactions | 1 | TRUE | FALSE | 1029 | max. number of concurrent active transactions | |
344 | transactions_per_rollback_segment | 1 | TRUE | FALSE | 5 | number of active transactions per rollback segment | |
345 | undo_management | 1 | TRUE | FALSE | AUTO | instance runs in SMU mode if TRUE, else in RBU mode | |
346 | undo_retention | 1 | FALSE | FALSE | 10800 | undo retention in seconds | |
347 | undo_tablespace | 1 | FALSE | FALSE | UNDOTBS1 | use/switch undo tablespace | |
348 | use_indirect_data_buffers | 1 | TRUE | FALSE | FALSE | Enable indirect data buffers (very large SGA on 32-bit platforms) | |
349 | use_large_pages | 1 | TRUE | FALSE | TRUE | Use large pages if available (TRUE/FALSE/ONLY) | |
350 | use_sigio | 1 | TRUE | FALSE | TRUE | Use SIGIO signal | |
351 | user_dump_dest | 1 | TRUE | FALSE | /oracle/app/oracle/diag/rdbms/bdpdb/bdpdb/trace | User process dump directory | |
352 | utl_file_dir | 0 | TRUE | FALSE | utl_file accessible directories list | ||
353 | workarea_size_policy | 1 | TRUE | FALSE | AUTO | policy used to size SQL working areas (MANUAL/AUTO) | |
354 | xml_db_events | 1 | TRUE | FALSE | enable | are XML DB events enabled | |
# | Name | Ord | Is Default |
Is Modified |
Value | Display Value |
Description |