1366133.1 SQLHC 12.1.06 Report: sqlhc_20150304_114844_00pspjfdy328d_2_diagnostics.html

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

SQL Text

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) )

SQL Plan Baselines (DBA_SQL_PLAN_BASELINES)

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

SQL Profiles (DBA_SQL_PROFILES)

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

SQL Patches (DBA_SQL_PATCHES)

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

Cursor Sharing and Reason

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

Cursor Sharing List

Collected from GV$SQL_SHARED_CURSOR.

Current Plans Summary (GV$SQL)

Execution Plans performance metrics for 00pspjfdy328d while still in memory. Plans ordered by average elapsed time.
# Plan HV Avg
Elapsed
Time
(secs)
Avg
CPU
Time
(secs)
Avg
IO
Time
(secs)
Avg
Conc
Time
(secs)
Avg
Appl
Time
(secs)
Avg
Clus
Time
(secs)
Avg
PLSQL
Time
(secs)
Avg
Java
Time
(secs)
Avg
Buffer
Gets
Avg
Disk
Reads
Avg
Direct
Writes
Avg
Rows
Proc
Total
Execs
Total
Fetch
Total
Loads
Total
Inval
Total
Parse
Calls
Total
Child
Cursors
Min
Cost
Max
Cost
Min
Opt Env HV
Max
Opt Env HV
First Load Last Load Last Active
# Plan HV Avg
Elapsed
Time
(secs)
Avg
CPU
Time
(secs)
Avg
IO
Time
(secs)
Avg
Conc
Time
(secs)
Avg
Appl
Time
(secs)
Avg
Clus
Time
(secs)
Avg
PLSQL
Time
(secs)
Avg
Java
Time
(secs)
Avg
Buffer
Gets
Avg
Disk
Reads
Avg
Direct
Writes
Avg
Rows
Proc
Total
Execs
Total
Fetch
Total
Loads
Total
Inval
Total
Parse
Calls
Total
Child
Cursors
Min
Cost
Max
Cost
Min
Opt Env HV
Max
Opt Env HV
First Load Last Load Last Active

Current SQL Statistics (GV$SQL)

Performance metrics of child cursors of 00pspjfdy328d while still in memory.
# Inst
ID
Child
Num
Plan HV Execs Fetch Loads Inval Parse
Calls
Buffer
Gets
Disk
Reads
Direct
Writes
Rows
Proc
Elapsed
Time
(secs)
CPU
Time
(secs)
IO
Time
(secs)
Conc
Time
(secs)
Appl
Time
(secs)
Clus
Time
(secs)
PLSQL
Time
(secs)
Java
Time
(secs)
Optimizer
Mode
Cost Opt Env HV Parsing
Schema
Name
Module Action Outline Profile First Load Last Load Last Active
# Inst
ID
Child
Num
Plan HV Execs Fetch Loads Inval Parse
Calls
Buffer
Gets
Disk
Reads
Direct
Writes
Rows
Proc
Elapsed
Time
(secs)
CPU
Time
(secs)
IO
Time
(secs)
Conc
Time
(secs)
Appl
Time
(secs)
Clus
Time
(secs)
PLSQL
Time
(secs)
Java
Time
(secs)
Optimizer
Mode
Cost Opt Env HV Parsing
Schema
Name
Module Action Outline Profile First Load Last Load Last Active

Historical Plans Summary (DBA_HIST_SQLSTAT)

Performance metrics of Execution Plans of 00pspjfdy328d. Plans ordered by average elapsed time.
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.
# Plan HV Avg
Elapsed
Time
(secs)
Avg
CPU
Time
(secs)
Avg
IO
Time
(secs)
Avg
Conc
Time
(secs)
Avg
Appl
Time
(secs)
Avg
Clus
Time
(secs)
Avg
PLSQL
Time
(secs)
Avg
Java
Time
(secs)
Avg
Buffer
Gets
Avg
Disk
Reads
Avg
Direct
Writes
Avg
Rows
Proc
Total
Execs
Min
Cost
Max
Cost
Min
Opt Env HV
Max
Opt Env HV
First Snapshot Last Snapshot
1 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

Historical SQL Statistics - Delta (DBA_HIST_SQLSTAT)

Performance metrics of Execution Plans of 00pspjfdy328d.
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.
# Snap
ID
Snaphot Inst
ID
Plan HV Vers
Cnt
Execs Fetch Loads Inval Parse
Calls
Buffer
Gets
Disk
Reads
Direct
Writes
Rows
Proc
Elapsed
Time
(secs)
CPU
Time
(secs)
IO
Time
(secs)
Conc
Time
(secs)
Appl
Time
(secs)
Clus
Time
(secs)
PLSQL
Time
(secs)
Java
Time
(secs)
Optimizer
Mode
Cost Opt Env HV Parsing
Schema
Name
Module Action Profile
1 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

Historical SQL Statistics - Total (DBA_HIST_SQLSTAT)

Performance metrics of Execution Plans of 00pspjfdy328d.
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.
# Snap
ID
Snaphot Inst
ID
Plan HV Vers
Cnt
Execs Fetch Loads Inval Parse
Calls
Buffer
Gets
Disk
Reads
Direct
Writes
Rows
Proc
Elapsed
Time
(secs)
CPU
Time
(secs)
IO
Time
(secs)
Conc
Time
(secs)
Appl
Time
(secs)
Clus
Time
(secs)
PLSQL
Time
(secs)
Java
Time
(secs)
Optimizer
Mode
Cost Opt Env HV Parsing
Schema
Name
Module Action Profile
1 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

Active Session History by Plan (GV$ACTIVE_SESSION_HISTORY)

Snapshots counts per Plan and Wait Event for 00pspjfdy328d.
This section includes data captured by AWR.
# Plan
Hash
Value
Session
State
Wait
Class
Event Snaps
Count
# Plan
Hash
Value
Session
State
Wait
Class
Event Snaps
Count

Active Session History by Plan Line (GV$ACTIVE_SESSION_HISTORY)

Snapshots counts per Plan Line and Wait Event for 00pspjfdy328d.
This section includes data captured by AWR.
Available on 11g or higher..
# Plan
Hash
Value
Plan
Line
ID
Plan
Operation
Plan
Options
Plan
Object
Owner
Plan
Object
Name
Session
State
Wait
Class
Event Curr
Obj
ID
Curr
Object
Name
Snaps
Count
# Plan
Hash
Value
Plan
Line
ID
Plan
Operation
Plan
Options
Plan
Object
Owner
Plan
Object
Name
Session
State
Wait
Class
Event Curr
Obj
ID
Curr
Object
Name
Snaps
Count

AWR Active Session History by Plan (DBA_HIST_ACTIVE_SESS_HISTORY)

Snapshots counts per Plan and Wait Event for 00pspjfdy328d.
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.
# Plan
Hash
Value
Session
State
Wait
Class
Event Snaps
Count
1 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

AWR Active Session History by Plan Line (DBA_HIST_ACTIVE_SESS_HISTORY)

Snapshots counts per Plan Line and Wait Event for 00pspjfdy328d.
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.
Available on 11g or higher..
# Plan
Hash
Value
Plan
Line
ID
Plan
Operation
Plan
Options
Plan
Object
Owner
Plan
Object
Name
Session
State
Wait
Class
Event Curr
Obj
ID
Curr
Object
Name
Snaps
Count
1 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

DBMS_STATS System Preferences

DBMS_STATS System Preferences.
# 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

Tables

CBO Statistics and relevant attributes.
# Table Name Owner Part DoP Temp Num Rows Sample
Size
Perc Last Analyzed Blocks Avg
Row
Len
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats
Perc Table
Cols
Indexes Index
Cols
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

DBMS_STATS Table Preferences

DBMS_STATS Table Preferences.
# Owner Table Name Obj# Parameter Name Parameter Value Change Time
# Owner Table Name Obj# Parameter Name Parameter Value Change Time

Table Columns

Table Columns: CUP_ACCOUNT (DDS)

CBO Statistics and relevant attributes.
# Indexes Col
ID
Column Name Data
Type
Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
1 1 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

Table Columns: CUP_ACCOUNT (ODS)

CBO Statistics and relevant attributes.
# Indexes Col
ID
Column Name Data
Type
Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
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

Table Partitions

Table Partitions: CUP_ACCOUNT (ODS)

Table partitions and relevant attributes (only the first and last 100).
# 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

Table Constraints

Table Constraints: CUP_ACCOUNT (DDS)

Table constraints and relevant attributes.
# 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

Table Constraints: CUP_ACCOUNT (ODS)

Table constraints and relevant attributes.
# 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

Tables Statistics Versions

CBO Statistics and relevant attributes.
# 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

Indexes

Indexes: CUP_ACCOUNT (DDS)

CBO Statistics and relevant attributes.
# Index Name Owner Index Type Part DoP Temp Uniqueness Cols Num
Rows
Sample
Size
Perc Last Analyzed Distinct
Keys
Blevel Leaf
Blocks
Avg
Leaf
Blocks
per Key
Avg
Data
Blocks
per Key
Clustering
Factor
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats
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

Indexes: CUP_ACCOUNT (ODS)

CBO Statistics and relevant attributes.
# Index Name Owner Index Type Part DoP Temp Uniqueness Cols Num
Rows
Sample
Size
Perc Last Analyzed Distinct
Keys
Blevel Leaf
Blocks
Avg
Leaf
Blocks
per Key
Avg
Data
Blocks
per Key
Clustering
Factor
Global
Stats
User
Stats
Stat
Type
Locked
Stale
Stats
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 Columns

Index Columns: CUP_ACCOUNT (DDS)

CBO Statistics and relevant attributes.
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
1 IDX_CUP_ACCOUNT_ANBR_CC 1 157 ACCT_NMBR ASC 14027490 0 1402749 10.0 13971840 34343530353530303030303130 36323832313235303930393439 2015-03-04/03:04:07 14 7.157253e-08 1 NONE YES NO
2 IDX_CUP_ACCOUNT_ANBR_CC 2 36 CURR_CODE ASC 14027490 0 1402749 10.0 2 313536 383430 2015-03-04/03:04:07 4 3.564430e-08 2 FREQUENCY YES NO
3 IDX_CUP_ACCOUNT_MDT 1 162 BDP_MODIFY_DATE ASC 14027490 0 1402749 10.0 23 3230313530323039 3230313530333033 2015-03-04/03:04:07 9 3.564430e-08 23 FREQUENCY YES NO
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats

Index Columns: CUP_ACCOUNT (ODS)

CBO Statistics and relevant attributes.
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats
4 IDX_CUP_ACCOUNT_EDT 1 158 BDP_ETL_DATE ASC NONE NO NO
5 IDX_CUP_ACCOUNT_EDT_CNMBR_CCD 1 158 BDP_ETL_DATE ASC NONE NO NO
6 IDX_CUP_ACCOUNT_EDT_CNMBR_CCD 2 SYS_NC00164$ ASC NONE NO NO
7 IDX_CUP_ACCOUNT_EDT_CNMBR_CCD 3 SYS_NC00165$ ASC NONE NO NO
# Index Name Col
Pos
Col
ID
Column Name Descend Num
Rows
Num
Nulls
Sample
Size
Perc Num
Distinct
Low Value High Value Last Analyzed Avg
Col
Len
Density Num
Buckets
Histogram Global
Stats
User
Stats

Index Partitions

Index Partitions: CUP_ACCOUNT (ODS)

CBO Statistics and relevant attributes.
# 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

Indexes Statistics Versions

Indexes Statistics Versions: CUP_ACCOUNT (DDS)

CBO Statistics and relevant attributes.
# 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

Indexes Statistics Versions: CUP_ACCOUNT (ODS)

CBO Statistics and relevant attributes.
# 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

System Parameters with Non-Default or Modified Values

Collected from GV$SYSTEM_PARAMETER2 where isdefault = 'FALSE' OR ismodified != 'FALSE'. "Is Default" = FALSE means the parameter was set in the spfile.
# Name Inst Ord Is
Default
Is
Modified
Value Display
Value
Description
1 _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

Instance Parameters

System Parameters collected from V$SYSTEM_PARAMETER2 for Instance number 1.
# Name Ord Is
Default
Is
Modified
Value Display
Value
Description
1 O7_DICTIONARY_ACCESSIBILITY 1 TRUE FALSE FALSE Version 7 Dictionary Accessibility Support
2 _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

Metadata

Table and Index Metadata of the objects involved in the plan and their dependent objects

Table: DDS.CUP_ACCOUNT


CREATE TABLE "DDS"."CUP_ACCOUNT"
( "CARD_NMBR" VARCHAR2(19) NOT NULL ENABLE,
"ACCT_NO" VARCHAR2(7),
"ADDR_MODIFY_DATE" VARCHAR2(8),
"ACCT_ADDR_TYPE" VARCHAR2(1),
"CARD_TYPE" VARCHAR2(4),
"BRANCH_CODE" VARCHAR2(4),
"COMP_NMBR" VARCHAR2(10),
"OPEN_DATE" VARCHAR2(8),
"CREDLIMIT" NUMBER(12,2),
"CREDLIMIT_CURR2" NUMBER(12,2),
"INSTALL_CREDIT" NUMBER(12,2),
"AUTH_NOTBEG_AMT" NUMBER(12,2),
"RETURN_DEADLINE_DATE" VARCHAR2(8),
"LAST_RETURN_DATE" VARCHAR2(8),
"PAYED_AMT" NUMBER(12,2),
"POS_AMT" NUMBER(12,2),
"POS_AMT_IND" VARCHAR2(1),
"YEAR_FEE" NUMBER(12,2),
"UNTRN_CASH_CHARGE" NUMBER(12,2),
"UNTRN_CASH_AMT" NUMBER(12,2),
"OTHER_CHARGE" NUMBER(12,2),
"UNTRN_PUNISH_AMT" NUMBER(12,2),
"OVERDUE_AMT" NUMBER(12,2),
"OVERDUE_DAYS" NUMBER(6,0),
"DISPUTED_AMT" NUMBER(12,2),
"DEBIT_ADJUST_AMT" NUMBER(12,2),
"LOAN_ADJUST_AMT" NUMBER(12,2),
"ACCT_STATUS" VARCHAR2(1),
"ACCT_STATUS_DATE" VARCHAR2(8),
"POS_YESTERDAY_AMT" NUMBER(12,2),
"CASH_YESTERDAY_AMT" NUMBER(12,2),
"CASH_YESTERDAY_AMT_IND" VARCHAR2(1),
"CHARGE_YESTERDAY_AMT" NUMBER(12,2),
"INTEREST_YESTERDAY_AMT" NUMBER(12,2),
"OCT_IN_DATE" VARCHAR2(8),
"CURR_CODE" VARCHAR2(3) NOT NULL ENABLE,
"INTEREST_LATEST_DATE" VARCHAR2(8),
"INTEREST" NUMBER(12,2),
"STMT_PAY_NUM" NUMBER(6,0),
"STMT_POS_NUM" NUMBER(6,0),
"STMT_TRANS_NUM" NUMBER(6,0),
"ADJUSTED_BONUS" NUMBER(10,0),
"BEGCHANGE_BONUS" NUMBER(10,0),
"ACCUM_BONUS" NUMBER(10,0),
"POS_GET_BONUS" NUMBER(10,0),
"AUTOKEAP_CODE" VARCHAR2(1),
"LASTSTMT_NOTINTEREST_AMT" NUMBER(12,2),
"LASTSTMT_POS_AMT" NUMBER(12,2),
"LASTSTMT_INTEREST_AMT" NUMBER(12,2),
"LASTSTMT_CASH_AMT" NUMBER(12,2),
"LASTSTMT_CASH_IND" VARCHAR2(1),
"LASTSTMT_AMT" NUMBER(12,2),
"LASTSTMT_LOWEST_AMT" NUMBER(12,2),
"STMT_CODE" VARCHAR2(2),
"OVERDUE_AMT1" NUMBER(12,2),
"OVERDUE_AMT2" NUMBER(12,2),
"OVERDUE_AMT3" NUMBER(12,2),
"OVERDUE_AMT4" NUMBER(12,2),
"OVERDUE_AMT5" NUMBER(12,2),
"OVERDUE_AMT6" NUMBER(12,2),
"OVERDUE_MAXNUM" NUMBER(3,0),
"COMP_INTEREST_AMT" NUMBER(12,2),
"CANCL_AMT" NUMBER(12,2),
"STMT_DATE" VARCHAR2(2),
"EXCHANGE_OPTION" VARCHAR2(1),
"INSTALL_AUTH_AMT" NUMBER(12,2),
"INSTALL_LEFT_AMT" NUMBER(12,2),
"STMT_ADDR_1" VARCHAR2(30),
"STMT_ADDR_2" VARCHAR2(30),
"STMT_ADDR_3" VARCHAR2(30),
"STMT_ADDR_4" VARCHAR2(30),
"STMT_ADDR_5" VARCHAR2(30),
"STMT_ADDR_POST" VARCHAR2(6),
"YESTERDAY_NOINTEREST_AMT" NUMBER(12,2),
"LASTSTMT_NOINTEREST_AMT" NUMBER(12,2),
"RELATE_ACCT1" VARCHAR2(20),
"RELATE_ACCT2" VARCHAR2(20),
"RELATE_ACCT3" VARCHAR2(20),
"RELATE_ACCT4" VARCHAR2(20),
"RELATE_ACCT1_CODE" VARCHAR2(1),
"RELATE_ACCT1_CODE2" VARCHAR2(1),
"RELATE_ACCT1_CODE3" VARCHAR2(1),
"RELATE_ACCT1_CODE4" VARCHAR2(1),
"RMB_AUTOKEAP_IND" VARCHAR2(1),
"USD_AUTOKEAP_IND" VARCHAR2(1),
"EXCHANGE_OPTION2" VARCHAR2(1),
"EXCHANGE_AMT_IND" VARCHAR2(1),
"LASTEST_STMT_DATE" VARCHAR2(8),
"ADJUSTED_BONUS_IND" VARCHAR2(1),
"ACCUM_BONUS_IND" VARCHAR2(1),
"ACCT_DUTY_PC" VARCHAR2(4),
"ACCT_PROJ_SC" VARCHAR2(4),
"ACCT_IND" VARCHAR2(1),
"CASH_RATE" NUMBER(5,2),
"BRANCH_INTR" VARCHAR2(1),
"BRANCH_CRLMT" NUMBER(12,2),
"VRF_CNTNT" VARCHAR2(6),
"SMS_FREE_FLAG" VARCHAR2(1),
"TEMP_CREDLIMIT" NUMBER(12,2),
"TEMP_TO_DT" VARCHAR2(8),
"TEMP_FROM_DT" VARCHAR2(8),
"BONUS_CREDLIMIT" NUMBER(10,0),
"PAY_FLAG" VARCHAR2(1),
"INT_CHDCMP" NUMBER(11,4),
"INT_NOTION" NUMBER(11,4),
"INT_CUNOT" NUMBER(11,4),
"INT_CURCMP" NUMBER(11,4),
"INT_CMPOND" NUMBER(11,4),
"IMP_FLAG" VARCHAR2(6),
"NCRED_RSN" VARCHAR2(1),
"MONTR_CODE" VARCHAR2(1),
"CRED_LMT2" NUMBER(12,2),
"CRED_FLAG" VARCHAR2(1),
"BAL_CHARGE01" NUMBER(12,2),
"BAL_CHARGE02" NUMBER(12,2),
"BAL_CHARGE03" NUMBER(12,2),
"BAL_CHARGE04" NUMBER(12,2),
"BAL_CHARGE05" NUMBER(12,2),
"BAL_CHARGE06" NUMBER(12,2),
"BAL_CHARGE07" NUMBER(12,2),
"BAL_CHARGE08" NUMBER(12,2),
"BAL_CHARGE09" NUMBER(12,2),
"BAL_CHARGE10" NUMBER(12,2),
"LAST_CHARGE01" NUMBER(12,2),
"LAST_CHARGE02" NUMBER(12,2),
"LAST_CHARGE03" NUMBER(12,2),
"LAST_CHARGE04" NUMBER(12,2),
"LAST_CHARGE05" NUMBER(12,2),
"LAST_CHARGE06" NUMBER(12,2),
"LAST_CHARGE07" NUMBER(12,2),
"LAST_CHARGE08" NUMBER(12,2),
"LAST_CHARGE09" NUMBER(12,2),
"LAST_CHARGE10" NUMBER(12,2),
"DES_FLAG" VARCHAR2(1),
"DESRESN_CODE" VARCHAR2(2),
"STP_NOT" NUMBER(12,2),
"STP_CMP" NUMBER(12,2),
"STP_CHRG" NUMBER(12,2),
"BAL_CMPFEE" NUMBER(12,2),
"NOINTEREST_FLAG" VARCHAR2(1),
"NOINTEREST_LIMIT" NUMBER(12,2),
"NOINTEREST_PERC" NUMBER(5,2),
"NOINTEREST_MAX" NUMBER(12,2),
"NOINTEREST_MIN" NUMBER(12,2),
"MP_REM_PPL" NUMBER(12,2),
"CRED_LMT3" NUMBER(12,2),
"MPAUTO_GW_PRSNT_PLAN" NUMBER(4,0),
"MPAUTO_GW_PRSNT_NUM" NUMBER(2,0),
"MPAUTO_GW_NEXT_PLAN" NUMBER(4,0),
"MPAUTO_GW_NEXT_NUM" NUMBER(2,0),
"MPAUTO_GW_MODIFY_DT" NUMBER(5,0),
"INT_CODE" NUMBER(2,0),
"CRED_CHDAY" VARCHAR2(8),
"ADJ_FLAG" VARCHAR2(1),
"NOTE_RST" VARCHAR2(4),
"NOTE_RSN" VARCHAR2(4),
"ACCT_NMBR" VARCHAR2(13),
"CURR_BALANCE" NUMBER(12,2),
"PPL" NUMBER(12,2),
"OVERDUE_LEVEL" VARCHAR2(2),
"RECLA_CODE" VARCHAR2(1),
"BDP_MODIFY_DATE" CHAR(8),
"BDP_LOAD_TIME" DATE,
"POINT_CUM2" NUMBER(10,0),
"POINT_REV" NUMBER(10,0),
"PAYMT_UNCL" NUMBER(12,2),
"QUERY_CODE" VARCHAR2(2)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_DDS_DATA"

Table: ODS.CUP_ACCOUNT


CREATE TABLE "ODS"."CUP_ACCOUNT"
( "CARD_NMBR" VARCHAR2(19),
"ACCT_NO" VARCHAR2(7),
"ADDR_MODIFY_DATE" VARCHAR2(8),
"ACCT_ADDR_TYPE" VARCHAR2(1),
"CARD_TYPE" VARCHAR2(4),
"BRANCH_CODE" VARCHAR2(4),
"COMP_NMBR" VARCHAR2(10),
"OPEN_DATE" VARCHAR2(8),
"CREDLIMIT" VARCHAR2(12),
"CREDLIMIT_CURR2" VARCHAR2(12),
"INSTALL_CREDIT" VARCHAR2(12),
"AUTH_NOTBEG_AMT" VARCHAR2(12),
"RETURN_DEADLINE_DATE" VARCHAR2(8),
"LAST_RETURN_DATE" VARCHAR2(8),
"PAYED_AMT" VARCHAR2(12),
"POS_AMT" VARCHAR2(12),
"POS_AMT_IND" VARCHAR2(1),
"YEAR_FEE" VARCHAR2(12),
"UNTRN_CASH_CHARGE" VARCHAR2(12),
"UNTRN_CASH_AMT" VARCHAR2(12),
"OTHER_CHARGE" VARCHAR2(12),
"UNTRN_PUNISH_AMT" VARCHAR2(12),
"OVERDUE_AMT" VARCHAR2(12),
"OVERDUE_DAYS" VARCHAR2(3),
"DISPUTED_AMT" VARCHAR2(12),
"DEBIT_ADJUST_AMT" VARCHAR2(12),
"LOAN_ADJUST_AMT" VARCHAR2(12),
"ACCT_STATUS" VARCHAR2(1),
"ACCT_STATUS_DATE" VARCHAR2(8),
"POS_YESTERDAY_AMT" VARCHAR2(12),
"CASH_YESTERDAY_AMT" VARCHAR2(12),
"CASH_YESTERDAY_AMT_IND" VARCHAR2(1),
"CHARGE_YESTERDAY_AMT" VARCHAR2(12),
"INTEREST_YESTERDAY_AMT" VARCHAR2(12),
"OCT_IN_DATE" VARCHAR2(8),
"CURR_CODE" VARCHAR2(3),
"INTEREST_LATEST_DATE" VARCHAR2(8),
"INTEREST" VARCHAR2(12),
"STMT_PAY_NUM" VARCHAR2(6),
"STMT_POS_NUM" VARCHAR2(6),
"STMT_TRANS_NUM" VARCHAR2(6),
"ADJUSTED_BONUS" VARCHAR2(10),
"BEGCHANGE_BONUS" VARCHAR2(10),
"ACCUM_BONUS" VARCHAR2(10),
"POS_GET_BONUS" VARCHAR2(10),
"AUTOKEAP_CODE" VARCHAR2(1),
"LASTSTMT_NOTINTEREST_AMT" VARCHAR2(12),
"LASTSTMT_POS_AMT" VARCHAR2(12),
"LASTSTMT_INTEREST_AMT" VARCHAR2(12),
"LASTSTMT_CASH_AMT" VARCHAR2(12),
"LASTSTMT_CASH_IND" VARCHAR2(1),
"LASTSTMT_AMT" VARCHAR2(12),
"LASTSTMT_LOWEST_AMT" VARCHAR2(12),
"STMT_CODE" VARCHAR2(2),
"OVERDUE_AMT1" VARCHAR2(11),
"OVERDUE_AMT2" VARCHAR2(11),
"OVERDUE_AMT3" VARCHAR2(11),
"OVERDUE_AMT4" VARCHAR2(11),
"OVERDUE_AMT5" VARCHAR2(11),
"OVERDUE_AMT6" VARCHAR2(11),
"OVERDUE_MAXNUM" VARCHAR2(3),
"COMP_INTEREST_AMT" VARCHAR2(11),
"CANCL_AMT" VARCHAR2(11),
"STMT_DATE" VARCHAR2(2),
"EXCHANGE_OPTION" VARCHAR2(1),
"INSTALL_AUTH_AMT" VARCHAR2(11),
"INSTALL_LEFT_AMT" VARCHAR2(11),
"STMT_ADDR_1" VARCHAR2(30),
"STMT_ADDR_2" VARCHAR2(30),
"STMT_ADDR_3" VARCHAR2(30),
"STMT_ADDR_4" VARCHAR2(30),
"STMT_ADDR_5" VARCHAR2(30),
"STMT_ADDR_POST" VARCHAR2(6),
"YESTERDAY_NOINTEREST_AMT" VARCHAR2(12),
"LASTSTMT_NOINTEREST_AMT" VARCHAR2(12),
"RELATE_ACCT1" VARCHAR2(20),
"RELATE_ACCT2" VARCHAR2(20),
"RELATE_ACCT3" VARCHAR2(20),
"RELATE_ACCT4" VARCHAR2(20),
"RELATE_ACCT1_CODE" VARCHAR2(1),
"RELATE_ACCT2_CODE" VARCHAR2(1),
"RELATE_ACCT3_CODE" VARCHAR2(1),
"RELATE_ACCT4_CODE" VARCHAR2(1),
"RMB_AUTOKEAP_IND" VARCHAR2(1),
"USD_AUTOKEAP_IND" VARCHAR2(1),
"EXCHANGE_OPTION2" VARCHAR2(1),
"EXCHANGE_AMT_IND" VARCHAR2(1),
"LASTEST_STMT_DATE" VARCHAR2(8),
"ADJUSTED_BONUS_IND" VARCHAR2(1),
"ACCUM_BONUS_IND" VARCHAR2(1),
"ACCT_DUTY_PC" VARCHAR2(4),
"ACCT_PROJ_SC" VARCHAR2(4),
"ACCT_IND" VARCHAR2(1),
"CASH_RATE" VARCHAR2(5),
"BRANCH_INTR" VARCHAR2(1),
"BRANCH_CRLMT" VARCHAR2(3),
"VRF_CNTNT" VARCHAR2(6),
"SMS_FREE_FLAG" VARCHAR2(1),
"TEMP_CREDLIMIT" VARCHAR2(10),
"TEMP_TO_DT" VARCHAR2(8),
"TEMP_FROM_DT" VARCHAR2(8),
"BONUS_CREDLIMIT" VARCHAR2(10),
"PAY_FLAG" VARCHAR2(1),
"INT_CHDCMP" VARCHAR2(11),
"INT_NOTION" VARCHAR2(11),
"INT_CUNOT" VARCHAR2(11),
"INT_CURCMP" VARCHAR2(11),
"INT_CMPOND" VARCHAR2(11),
"IMP_FLAG" VARCHAR2(6),
"NCRED_RSN" VARCHAR2(1),
"MONTR_CODE" VARCHAR2(1),
"CRED_LMT2" VARCHAR2(10),
"CRED_FLAG" VARCHAR2(3),
"BAL_CHARGE01" VARCHAR2(11),
"BAL_CHARGE02" VARCHAR2(11),
"BAL_CHARGE03" VARCHAR2(11),
"BAL_CHARGE04" VARCHAR2(11),
"BAL_CHARGE05" VARCHAR2(11),
"BAL_CHARGE06" VARCHAR2(11),
"BAL_CHARGE07" VARCHAR2(11),
"BAL_CHARGE08" VARCHAR2(11),
"BAL_CHARGE09" VARCHAR2(11),
"BAL_CHARGE10" VARCHAR2(11),
"LAST_CHARGE01" VARCHAR2(11),
"LAST_CHARGE02" VARCHAR2(11),
"LAST_CHARGE03" VARCHAR2(11),
"LAST_CHARGE04" VARCHAR2(11),
"LAST_CHARGE05" VARCHAR2(11),
"LAST_CHARGE06" VARCHAR2(11),
"LAST_CHARGE07" VARCHAR2(11),
"LAST_CHARGE08" VARCHAR2(11),
"LAST_CHARGE09" VARCHAR2(11),
"LAST_CHARGE10" VARCHAR2(11),
"DES_FLAG" VARCHAR2(1),
"DESRESN_CODE" VARCHAR2(2),
"STP_NOT" VARCHAR2(11),
"STP_CMP" VARCHAR2(11),
"STP_CHRG" VARCHAR2(11),
"BAL_CMPFEE" VARCHAR2(11),
"NOINTEREST_FLAG" VARCHAR2(1),
"NOINTEREST_LIMIT" VARCHAR2(11),
"NOINTEREST_PERC" VARCHAR2(4),
"NOINTEREST_MAX" VARCHAR2(11),
"NOINTEREST_MIN" VARCHAR2(11),
"MP_REM_PPL" VARCHAR2(11),
"CRED_LMT3" VARCHAR2(10),
"MPAUTO_GW_PRSNT_PLAN" VARCHAR2(4),
"MPAUTO_GW_PRSNT_NUM" VARCHAR2(2),
"MPAUTO_GW_NEXT_PLAN" VARCHAR2(4),
"MPAUTO_GW_NEXT_NUM" VARCHAR2(2),
"MPAUTO_GW_MODIFY_DT" VARCHAR2(5),
"INT_CODE" VARCHAR2(2),
"CRED_CHDAY" CHAR(8),
"ADJ_FLAG" VARCHAR2(1),
"NOTE_RST" VARCHAR2(4),
"NOTE_RSN" VARCHAR2(4),
"RECLA_CODE" CHAR(1),
"BDP_ETL_DATE" CHAR(8),
"BDP_LOAD_TIME" DATE,
"POINT_CUM2" VARCHAR2(10),
"POINT_REV" VARCHAR2(10),
"PAYMT_UNCL" VARCHAR2(11),
"QUERY_CODE" VARCHAR2(2)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_ODS_DATA"

Index: DDS.IDX_CUP_ACCOUNT_ANBR_CC


CREATE INDEX "DDS"."IDX_CUP_ACCOUNT_ANBR_CC" ON "DDS"."CUP_ACCOUNT" ("ACCT_NMBR", "CURR_CODE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_DDS_IDX"

Index: DDS.IDX_CUP_ACCOUNT_MDT


CREATE BITMAP INDEX "DDS"."IDX_CUP_ACCOUNT_MDT" ON "DDS"."CUP_ACCOUNT" ("BDP_MODIFY_DATE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_DDS_IDX"

Index: ODS.IDX_CUP_ACCOUNT_EDT


CREATE BITMAP INDEX "ODS"."IDX_CUP_ACCOUNT_EDT" ON "ODS"."CUP_ACCOUNT" ("BDP_ETL_DATE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_ODS_IDX"

Index: ODS.IDX_CUP_ACCOUNT_EDT_CNMBR_CCD


CREATE INDEX "ODS"."IDX_CUP_ACCOUNT_EDT_CNMBR_CCD" ON "ODS"."CUP_ACCOUNT" ("BDP_ETL_DATE", SUBSTR("CARD_NMBR",1,13), TRIM("CURR_CODE"))
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_ODS_IDX"
1366133.1 SQLHC 12.1.06 2015-03-04/11:48:44