ITPub博客

首页 > Linux操作系统 > Linux操作系统 > SQL执行次数过多的分析

SQL执行次数过多的分析

原创 Linux操作系统 作者:DataKW 时间:2013-07-01 19:36:56 0 删除 编辑
select pr.spid,ss.MACHINE,ss.MODULE,sq.sql_text,ss.SQL_ID,ss.PREV_SQL_ID
  from v$session ss, v$process pr, v$sql sq
 where ss.PADDR = pr.addr
   and sq.sql_id = ss.sql_id
   and (ss.SQL_ID in ('4s0vg4xmxufa4', '3thm40um6yqf9')      
       or ss.PREV_SQL_ID in ('4s0vg4xmxufa4', '3thm40um6yqf9'));
 
 
AWR分析一小时5,181,805次01-7月 -13 09:00:14到01-7月 -13 09:00:14
3thm40um6yqf9
select * from t_info_account where ACCOUNT_NO=:1 and STATUS!='9'
4s0vg4xmxufa4
select * from T_INFO_CARD where substr(INNER_CARD_NO, 0, 15)=:1
 
这两个视图为什么查出啦和awr不同呢?
SELECT  trunc(sample_time) "Date",
        to_char(sample_time, 'Dy') "Day",
        count(1) "Total",
        SUM(decode(to_char(sample_time, 'hh24'),'00',1,0)) "h0",
        SUM(decode(to_char(sample_time, 'hh24'),'01',1,0)) "h1",
        SUM(decode(to_char(sample_time, 'hh24'),'02',1,0)) "h2",
        SUM(decode(to_char(sample_time, 'hh24'),'03',1,0)) "h3",
        SUM(decode(to_char(sample_time, 'hh24'),'04',1,0)) "h4",
        SUM(decode(to_char(sample_time, 'hh24'),'05',1,0)) "h5",
        SUM(decode(to_char(sample_time, 'hh24'),'06',1,0)) "h6",
        SUM(decode(to_char(sample_time, 'hh24'),'07',1,0)) "h7",
        SUM(decode(to_char(sample_time, 'hh24'),'08',1,0)) "h8",
        SUM(decode(to_char(sample_time, 'hh24'),'09',1,0)) "h9",
        SUM(decode(to_char(sample_time, 'hh24'),'10',1,0)) "h10",
        SUM(decode(to_char(sample_time, 'hh24'),'11',1,0)) "h11",
        SUM(decode(to_char(sample_time, 'hh24'),'12',1,0)) "h12",
        SUM(decode(to_char(sample_time, 'hh24'),'13',1,0)) "h13",
        SUM(decode(to_char(sample_time, 'hh24'),'14',1,0)) "h14",
        SUM(decode(to_char(sample_time, 'hh24'),'15',1,0)) "h15",
        SUM(decode(to_char(sample_time, 'hh24'),'16',1,0)) "h16",
        SUM(decode(to_char(sample_time, 'hh24'),'17',1,0)) "h17",
        SUM(decode(to_char(sample_time, 'hh24'),'18',1,0)) "h18",
        SUM(decode(to_char(sample_time, 'hh24'),'19',1,0)) "h19",
        SUM(decode(to_char(sample_time, 'hh24'),'20',1,0)) "h20",
        SUM(decode(to_char(sample_time, 'hh24'),'21',1,0)) "h21",
        SUM(decode(to_char(sample_time, 'hh24'),'22',1,0)) "h22",
        SUM(decode(to_char(sample_time, 'hh24'),'23',1,0)) "h23"
FROM    gv$active_session_history
where sql_id='3thm40um6yqf9' and
trunc(sample_time)>sysdate-8
group by trunc(sample_time), to_char(sample_time, 'Dy')
Order by 1;

Date        Day            Total         h0         h1         h2         h3         h4         h5         h6         h7         h8         h9        h10        h11        h12        h13        h14        h15        h16        h17        h18        h19        h20        h21        h22        h23
----------- --------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
2013-7-1    星期一         34965          0          0          0          0          0         91       1526       1733       2318       4114       3878       3824       3714       3671       3914       3800       2382          0          0          0          0          0          0          0
 
 
 SELECT  trunc(sample_time) "Date",
        to_char(sample_time, 'Dy') "Day",
        count(1) "Total",
        SUM(decode(to_char(sample_time, 'hh24'),'00',1,0)) "h0",
        SUM(decode(to_char(sample_time, 'hh24'),'01',1,0)) "h1",
        SUM(decode(to_char(sample_time, 'hh24'),'02',1,0)) "h2",
        SUM(decode(to_char(sample_time, 'hh24'),'03',1,0)) "h3",
        SUM(decode(to_char(sample_time, 'hh24'),'04',1,0)) "h4",
        SUM(decode(to_char(sample_time, 'hh24'),'05',1,0)) "h5",
        SUM(decode(to_char(sample_time, 'hh24'),'06',1,0)) "h6",
        SUM(decode(to_char(sample_time, 'hh24'),'07',1,0)) "h7",
        SUM(decode(to_char(sample_time, 'hh24'),'08',1,0)) "h8",
        SUM(decode(to_char(sample_time, 'hh24'),'09',1,0)) "h9",
        SUM(decode(to_char(sample_time, 'hh24'),'10',1,0)) "h10",
        SUM(decode(to_char(sample_time, 'hh24'),'11',1,0)) "h11",
        SUM(decode(to_char(sample_time, 'hh24'),'12',1,0)) "h12",
        SUM(decode(to_char(sample_time, 'hh24'),'13',1,0)) "h13",
        SUM(decode(to_char(sample_time, 'hh24'),'14',1,0)) "h14",
        SUM(decode(to_char(sample_time, 'hh24'),'15',1,0)) "h15",
        SUM(decode(to_char(sample_time, 'hh24'),'16',1,0)) "h16",
        SUM(decode(to_char(sample_time, 'hh24'),'17',1,0)) "h17",
        SUM(decode(to_char(sample_time, 'hh24'),'18',1,0)) "h18",
        SUM(decode(to_char(sample_time, 'hh24'),'19',1,0)) "h19",
        SUM(decode(to_char(sample_time, 'hh24'),'20',1,0)) "h20",
        SUM(decode(to_char(sample_time, 'hh24'),'21',1,0)) "h21",
        SUM(decode(to_char(sample_time, 'hh24'),'22',1,0)) "h22",
        SUM(decode(to_char(sample_time, 'hh24'),'23',1,0)) "h23"
FROM    dba_hist_active_sess_history
where   sql_id='3thm40um6yqf9' and
 trunc(sample_time)>sysdate-2
group by trunc(sample_time), to_char(sample_time, 'Dy')
Order by 1;
 Date        Day            Total         h0         h1         h2         h3         h4         h5         h6         h7         h8         h9        h10        h11        h12        h13        h14        h15        h16        h17        h18        h19        h20        h21        h22        h23
----------- --------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
2013-6-30   星期日          8519        383        351        324        378        328        316        329        341        337        357        407        376        371        366        386        359        359        345        364        368        354        321        363        336
2013-7-1    星期一          5838        365        342        325        317        306        353        326        348        418        421        403        381        377        362        400        394          0          0          0          0          0          0          0          0
 
 
SQL> select * from v$sqlarea where sql_id='3thm40um6yqf9';
 
SQL_TEXT                                                                         SQL_FULLTEXT                                                                     SQL_ID        SHARABLE_MEM PERSISTENT_MEM RUNTIME_MEM      SORTS VERSION_COUNT LOADED_VERSIONS OPEN_VERSIONS USERS_OPENING    FETCHES EXECUTIONS PX_SERVERS_EXECUTIONS END_OF_FETCH_COUNT USERS_EXECUTING      LOADS FIRST_LOAD_TIME                                           INVALIDATIONS PARSE_CALLS DISK_READS DIRECT_WRITES BUFFER_GETS APPLICATION_WAIT_TIME CONCURRENCY_WAIT_TIME CLUSTER_WAIT_TIME USER_IO_WAIT_TIME PLSQL_EXEC_TIME JAVA_EXEC_TIME ROWS_PROCESSED COMMAND_TYPE OPTIMIZER_MODE OPTIMIZER_COST OPTIMIZER_ENV                                                                    OPTIMIZER_ENV_HASH_VALUE PARSING_USER_ID PARSING_SCHEMA_ID PARSING_SCHEMA_NAME            KEPT_VERSIONS ADDRESS          HASH_VALUE OLD_HASH_VALUE PLAN_HASH_VALUE MODULE                                                           MODULE_HASH ACTION                                                           ACTION_HASH SERIALIZABLE_ABORTS OUTLINE_CATEGORY                                                   CPU_TIME ELAPSED_TIME OUTLINE_SID                              LAST_ACTIVE_CHILD_ADDRESS REMOTE OBJECT_STATUS       LITERAL_HASH_VALUE LAST_LOAD_TIME IS_OBSOLETE CHILD_LATCH SQL_PROFILE                                                      PROGRAM_ID PROGRAM_LINE# EXACT_MATCHING_SIGNATURE FORCE_MATCHING_SIGNATURE LAST_ACTIVE_TIME BIND_DATA                                                                        TYPECHECK_MEM
-------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------- ------------ -------------- ----------- ---------- ------------- --------------- ------------- ------------- ---------- ---------- --------------------- ------------------ --------------- ---------- --------------------------------------------------------- ------------- ----------- ---------- ------------- ----------- --------------------- --------------------- ----------------- ----------------- --------------- -------------- -------------- ------------ -------------- -------------- -------------------------------------------------------------------------------- ------------------------ --------------- ----------------- ------------------------------ ------------- ---------------- ---------- -------------- --------------- ---------------------------------------------------------------- ----------- ---------------------------------------------------------------- ----------- ------------------- ---------------------------------------------------------------- ---------- ------------ ---------------------------------------- ------------------------- ------ ------------------- ------------------ -------------- ----------- ----------- ---------------------------------------------------------------- ---------- ------------- ------------------------ ------------------------ ---------------- -------------------------------------------------------------------------------- -------------
select * from t_info_account   where   ACCOUNT_NO=:1 and STATUS!='9'             select * from t_info_account   where   ACCOUNT_NO=:1 and STATUS!='9'             3thm40um6yqf9        51167          19208       12832          0             2               1             1             2  383929770  383971306                     0          383930825               0          2 2013-06-28/01:46:58                                                   0   383974555        168             0  2305392202                     0             366645762        2874743236            672641               0              0      383748677            3 ALL_ROWS                    4 E289FB89A4E49800CE001000AEFAC3E2CFFA33105641455551952110555555154554555859155544               3825549676              59                59 BTUPAYPROD                                 0 0700000A5B91ADB0 2792315337     3500186316      3705630241                                                                            0                                                                            0                   0                                                                  2852199273  30286802208                                          0700000B8B8E1098          N      VALID                                0 2013-6-28 15:3 N                    15                                                                        5377         11286      1.36332155607827E19      1.36332155607827E19 2013-7-1 16:42:5 BEDA0A20040051D13FF9000101F0018003671038383939303030303037373034373135                       0
 
 
 
 SQL> select * from v$sql where sql_id='3thm40um6yqf9';
 
SQL_TEXT                                                                         SQL_FULLTEXT                                                                     SQL_ID        SHARABLE_MEM PERSISTENT_MEM RUNTIME_MEM      SORTS LOADED_VERSIONS OPEN_VERSIONS USERS_OPENING    FETCHES EXECUTIONS PX_SERVERS_EXECUTIONS END_OF_FETCH_COUNT USERS_EXECUTING      LOADS FIRST_LOAD_TIME                                           INVALIDATIONS PARSE_CALLS DISK_READS DIRECT_WRITES BUFFER_GETS APPLICATION_WAIT_TIME CONCURRENCY_WAIT_TIME CLUSTER_WAIT_TIME USER_IO_WAIT_TIME PLSQL_EXEC_TIME JAVA_EXEC_TIME ROWS_PROCESSED COMMAND_TYPE OPTIMIZER_MODE OPTIMIZER_COST OPTIMIZER_ENV                                                                    OPTIMIZER_ENV_HASH_VALUE PARSING_USER_ID PARSING_SCHEMA_ID PARSING_SCHEMA_NAME            KEPT_VERSIONS ADDRESS          TYPE_CHK_HEAP    HASH_VALUE OLD_HASH_VALUE PLAN_HASH_VALUE CHILD_NUMBER SERVICE                                                          SERVICE_HASH MODULE                                                           MODULE_HASH ACTION                                                           ACTION_HASH SERIALIZABLE_ABORTS OUTLINE_CATEGORY                                                   CPU_TIME ELAPSED_TIME OUTLINE_SID CHILD_ADDRESS       SQLTYPE REMOTE OBJECT_STATUS       LITERAL_HASH_VALUE LAST_LOAD_TIME                                            IS_OBSOLETE CHILD_LATCH SQL_PROFILE                                                      PROGRAM_ID PROGRAM_LINE# EXACT_MATCHING_SIGNATURE FORCE_MATCHING_SIGNATURE LAST_ACTIVE_TIME BIND_DATA                                                                        TYPECHECK_MEM
-------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------- ------------ -------------- ----------- ---------- --------------- ------------- ------------- ---------- ---------- --------------------- ------------------ --------------- ---------- --------------------------------------------------------- ------------- ----------- ---------- ------------- ----------- --------------------- --------------------- ----------------- ----------------- --------------- -------------- -------------- ------------ -------------- -------------- -------------------------------------------------------------------------------- ------------------------ --------------- ----------------- ------------------------------ ------------- ---------------- ---------------- ---------- -------------- --------------- ------------ ---------------------------------------------------------------- ------------ ---------------------------------------------------------------- ----------- ---------------------------------------------------------------- ----------- ------------------- ---------------------------------------------------------------- ---------- ------------ ----------- ---------------- ---------- ------ ------------------- ------------------ --------------------------------------------------------- ----------- ----------- ---------------------------------------------------------------- ---------- ------------- ------------------------ ------------------------ ---------------- -------------------------------------------------------------------------------- -------------
select * from t_info_account   where   ACCOUNT_NO=:1 and STATUS!='9'             select * from t_info_account   where   ACCOUNT_NO=:1 and STATUS!='9'             3thm40um6yqf9        51167          19208       12832          0               1             1             4  384579842  384621501                     0          384580900               2          2 2013-06-28/01:46:58                                                   0   384624748        168             0  2309308372                     0             366715908        2884429464            672663               0              0      384398448            3 ALL_ROWS                    4 E289FB89A4E49800CE001000AEFAC3E2CFFA33105641455551952110555555154554555859155544               3825549676              59                59 BTUPAYPROD                                 0 0700000A5B91ADB0 00               2792315337     3500186316      3705630241            1 spay                                                                        0                                                                            0                                                                            0                   0                                                                  2857296425  30341899741             0700000B8B8E1098          6 N      VALID                                0 2013-06-28/15:31:55                                       N                    15                                                                        5377         11286      1.36332155607827E19      1.36332155607827E19 2013-7-1 16:50:1 BEDA0A20040051D13FF9000101F0018003671038383939303030303037373034373135                       0
 
 
 
 
SQL> select position,LAST_CAPTURED,datatype_string,value_string from gv$sql_bind_capture where sql_id='3thm40um6yqf9';
 
  POSITION LAST_CAPTURED DATATYPE_STRING                               VALUE_STRING
---------- ------------- --------------------------------------------- --------------------------------------------------------------------------------
         1 2013-7-1 16:5 VARCHAR2(128)                                 8899000007704715
         1 2013-6-30 2:5 VARCHAR2(128)                                 8899000007704715
SQL> select * from t_info_account a where a.account_no='8899000007704715';
 
ACCOUNT_NO           ACCOUNT_NAME                                                                     CUSTOMER_NO      OPEN_DATE   CLOSE_DATE  VALID_DATE  TXN_PASSWD                       INIT_PASSWD INIT_PASSWD_MODIFIED PASSWD_ERR_NUM PASSWD_ERR_LOCK_TIME                                                             STATUS COMM_STATUS TYPE GRADE IS_REALNAME APANAGE         UNIT_ID                        AREA_CODE CITY_CODE  OPEN_CHANNEL                                 BALANCE                            LAST_DAY_BAL                          LAST_MONTH_BAL                       AVAILABLE_BALANCE                     UNAVAILABLE_BALANCE                        WITHDRAW_BALANCE                           FROZEN_AMOUNT                    PREAUTHORIZED_AMOUNT LAST_TXN_DATE DAY_SUM_CONS_AMT DAY_SUM_CONS_CNT                         DAY_SUM_OUT_AMT DAY_SUM_OUT_CNT                          DAY_SUM_IN_AMT DAY_SUM_IN_CNT                        DAY_SUM_CASH_AMT DAY_SUM_CASH_CNT                         DAY_SUM_CHG_AMT DAY_SUM_CHG_CNT                      MONTH_SUM_CONS_AMT                       MONTH_SUM_OUT_AMT                        MONTH_SUM_IN_AMT                      MONTH_SUM_CASH_AMT                       MONTH_SUM_CHG_AMT IS_ALLOWED_CLOSE IS_CLOSE_RTN_CASH ENCRYPTED_MSG                    LAST_UPDATE_TIME                                                                 LAST_TXN_TIME                                                                                                  RSVD_AMT1                               RSVD_AMT2 RSVD_TEXT1                                         RSVD_TEXT2                                         MONTH_SUM_CONS_CNT MONTH_SUM_OUT_CNT MONTH_SUM_IN_CNT MONTH_SUM_CASH_CNT MONTH_SUM_CHG_CNT MASTER_ACCOUNT_NO    FORBIDDEN_TXN                                                                    EXTEND_TIMES FORBIDDEN_CHANNEL
-------------------- -------------------------------------------------------------------------------- ---------------- ----------- ----------- ----------- -------------------------------- ----------- -------------------- -------------- -------------------------------------------------------------------------------- ------ ----------- ---- ----- ----------- --------------- ------------------------------ --------- ---------- ------------ --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- ------------- ---------------- ---------------- --------------------------------------- --------------- --------------------------------------- -------------- --------------------------------------- ---------------- --------------------------------------- --------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- ---------------- ----------------- -------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------------------------------------- -------------------------------------------------- ------------------ ----------------- ---------------- ------------------ ----------------- -------------------- -------------------------------------------------------------------------------- ------------ --------------------------------------------------
8899000007704715     我的天翼预付卡                                                                   8899000007704715 2013-6-28               2016-3-31   A570500E73F98217                 898978      0                                 0                                                                                  1                  B    1     3           002110000010000                                610000    610100     00                                             50000                                       0                                       0                                   50000                                       0                                       0                                       0                                       0 20130628                     0                0                                       0               0                                       0              0                                       0                0                                       0               0                                       0                                       0                                       0                                       0                                       0 1                0                 DC018A9878F24139F20D7733F0FFDF19 28-6月 -13 05.50.17.558000 下午                                                  28-6月 -13 04.18.12.023000 下午                                                                                        0                                       0                                                                                                                        0                 0                0                  0                 0                                                                                                                  0
SQL> select * from t_info_customer b where b.customer_no='8899000007704715';
 
CUSTOMER_NO      PASSPORT_ID                              IS_REALNAME NAME                                                                             IS_REQUEST_CERTIFICATE GRADE TYPE REGISTER_TYPE PRODUCT_NO                     MOBILE_PHONE                   EMAIL_ADDRESS                                                                    LOGIN_ID                                                                         NICK_NAME                                                                        PINKEY                           IVR_PINKEY                       QUERY_PINKEY                     GENDER ID_TYPE ID_NO                                                                            HOME_PHONE                     OFFICE_PHONE                   OTHER_PHONE                    APANAGE         AREA_CODE CITY_CODE CONTACT_ADDRESS                                                                  CONTACT_ZIPCODE UNIT_ADDRESS                                                                     UNIT_ZIPCODE PWD_ERR_NUM LOCK_TIME_LIMIT                                                                  UNIT_CODE                      QUESTION                                                                         ANSWER                                                                           ACTIVE_ADDRESS                                                                   ACTIVE_CODE                                                                      ACTIVE_STATUS REGISTER_TIME                                                                    PORTRAIT IS_CLOSED ACCEPT_ORG_CODE ACCEPT_UID           MANAGER              LAST_SUCCESS_LOGIN_TIME                                                          LAST_SUCCESS_LOGIN_IP          LAST_FAIL_LOGIN_TIME                                                             LAST_FAIL_LOGIN_IP             LAST_UPDATE_TIME                                                                 STATUS CLOSE_TIME                                      
---------------- ---------------------------------------- ----------- -------------------------------------------------------------------------------- ---------------------- ----- ---- ------------- ------------------------------ ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------- -------------------------------- -------------------------------- ------ ------- -------------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ --------------- --------- --------- -------------------------------------------------------------------------------- --------------- -------------------------------------------------------------------------------- ------------ ----------- -------------------------------------------------------------------------------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------- -------- --------- --------------- -------------------- -------------------- -------------------------------------------------------------------------------- ------------------------------ -------------------------------------------------------------------------------- ------------------------------ -------------------------------------------------------------------------------- ------ -------------------------------------------------
8899000007704715                                          3           8899000007704715      
 
select * from dba_hist_sqlbind where  sql_id='3thm40um6yqf9' order by last_captured desc;
select * from dba_hist_sqltext where sql_id='3thm40um6yqf9';
select * from DBA_HIST_SQL_BIND_METADATA where sql_id='3thm40um6yqf9';
 
SQL> select * from dba_hist_sqlbind where  sql_id='3thm40um6yqf9' order by last_captured desc;
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31221 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 16:5 8899000007704715                                                                
     31220 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 15:5 8899000007704715                                                                
     31219 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 14:5 8899000007704724                                                                
     31218 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 13:5 8899000007704715                                                                
     31217 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 12:5 8899000007704715                                                                
     31216 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 11:5 8899000007704715                                                                
     31215 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 10:5 8899000007704715                                                                
     31214 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 9:53 8899000007704715                                                                
     31213 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 8:53 8899000007704715                                                                
     31212 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 7:53 8899000007704724                                                                
     31211 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 6:53 8899000007704715                                                                
     31210 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 5:53 8899000007704724                                                                
     31209 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 4:53 8899000007704724                                                                
     31208 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 3:53 8899000007704715                                                                
     31207 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 2:53 8899000007704715                                                                
     31206 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 1:53 8899000007704715                                                                
     31205 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-7-1 0:53 8899000007704715                                                                
     31204 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 23: 8899000007704715                                                                
     31203 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 22: 8899000007704724                                                                
     31202 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 21: 8899000007704724                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31201 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 20: 8899000007704715                                                                
     31200 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 19: 8899000007704724                                                                
     31199 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 18: 8899000007704715                                                                
     31198 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 17: 8899000007704724                                                                
     31197 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 16: 8899000007704715                                                                
     31196 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 15: 8899000007704715                                                                
     31195 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 14: 8899000007704715                                                                
     31194 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 13: 8899000007704724                                                                
     31193 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 12: 8899000007704724                                                                
     31192 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 11: 8899000007704715                                                                
     31191 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 10: 8899000007704724                                                                
     31190 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 9:5 8899000007704715                                                                
     31189 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 8:5 8899000007704715                                                                
     31188 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 7:5 8899000007704715                                                                
     31187 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 6:5 8899000007704715                                                                
     31186 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 5:5 8899000007704715                                                                
     31185 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 4:5 8899000007704715                                                                
     31184 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 3:5 8899000007704724                                                                
     31203 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31201 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31191 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31214 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31210 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31217 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31196 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31198 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31186 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31183 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31185 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31194 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31212 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31221 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31207 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31213 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31188 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31211 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31216 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31218 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31220 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31187 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31215 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31219 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31208 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31193 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31195 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31199 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31202 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31190 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31204 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31206 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31192 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31197 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31200 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31205 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31209 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31184 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31189 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704715                                                                
     31183 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 2:5 8899000007704724                                                                
     31182 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 1:5 8899000007704715                                                                
     31182 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 1:5 8899000007704715                                                                
     31181 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 0:5 8899000007704715                                                                
     31181 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-30 0:5 8899000007704715                                                                
     31180 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 23: 8899000007704715                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31180 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 23: 8899000007704724                                                                
     31179 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 22: 8899000007704715                                                                
     31179 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 22: 8899000007704715                                                                
     31178 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 21: 8899000007704715                                                                
     31178 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 21: 8899000007704724                                                                
     31177 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 20: 8899000007704715                                                                
     31177 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 20: 8899000007704724                                                                
     31176 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 19: 8899000007704715                                                                
     31176 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 19: 8899000007704715                                                                
     31175 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 18: 8899000007704715                                                                
     31175 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 18: 8899000007704715                                                                
     31174 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 17: 8899000007704715                                                                
     31174 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 17: 8899000007704724                                                                
     31173 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 16: 8899000007704715                                                                
     31173 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 16: 8899000007704715                                                                
     31172 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 15: 8899000007704715                                                                
     31172 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 15: 8899000007704715                                                                
     31171 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 14: 8899000007704715                                                                
     31171 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 14: 8899000007704715                                                                
     31170 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 13: 8899000007704715                                                                
     31170 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 13: 8899000007704715                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31169 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 12: 8899000007704715                                                                
     31169 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 12: 8899000007704715                                                                
     31168 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 11: 8899000007704715                                                                
     31168 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 11: 8899000007704715                                                                
     31167 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 10: 8899000007704715                                                                
     31167 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 10: 8899000007704724                                                                
     31166 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 9:5 8899000007704715                                                                
     31166 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 9:5 8899000007704715                                                                
     31165 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 8:5 8899000007704715                                                                
     31165 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 8:5 8899000007704715                                                                
     31164 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 7:5 8899000007704715                                                                
     31164 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 7:5 8899000007704715                                                                
     31163 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 6:5 8899000007704715                                                                
     31163 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 6:5 8899000007704724                                                                
     31162 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 5:5 8899000007704715                                                                
     31162 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 5:5 8899000007704715                                                                
     31161 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 4:5 8899000007704715                                                                
     31161 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 4:5 8899000007704715                                                                
     31160 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 3:5 8899000007704715                                                                
     31160 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 3:5 8899000007704715                                                                
     31159 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 2:5 8899000007704715                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31159 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 2:5 8899000007704715                                                                
     31158 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 1:5 8899000007704715                                                                
     31158 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 1:5 8899000007704715                                                                
     31157 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 0:5 8899000007704715                                                                
     31157 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-29 0:5 8899000007704715                                                                
     31156 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 23: 8899000007704715                                                                
     31156 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 23: 8899000007704715                                                                
     31155 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 22: 8899000007704715                                                                
     31155 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 22: 8899000007704715                                                                
     31154 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 21: 8899000007704715                                                                
     31154 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 21: 8899000007704715                                                                
     31153 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 20: 8899000007704715                                                                
     31153 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 20: 8899000007704724                                                                
     31152 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 19: 8899000007704715                                                                
     31152 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 19: 8899000007704715                                                                
     31151 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 18: 8899000007704715                                                                
     31151 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 18: 8899000007704715                                                                
     31150 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 17: 8899000007704715                                                                
     31150 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-28 17: 8899000007704724                                                                
     31128 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 19: 8631772000834228                                                                
     31127 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 18: 8899000011776024                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31126 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 17: 8899000011776024                                                                
     31125 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 16: 8899000011776024                                                                
     31124 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 15: 8899000011776024                                                                
     31123 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 14: 8899000011776024                                                                
     31122 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 13: 8899000011776024                                                                
     31121 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 12: 8899000011776024                                                                
     31120 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 11: 8899000011776024                                                                
     31119 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 10: 8899000011776024                                                                
     31118 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 9:5 8899000011776024                                                                
     31117 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 8:5 8899000011776024                                                                
     31116 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 7:5 8899000011776024                                                                
     31115 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 6:5 8899000011776024                                                                
     31114 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 5:5 8899000011776024                                                                
     31113 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 4:5 8899000011776024                                                                
     31112 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 3:5 8899000011776024                                                                
     31111 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 2:5 8899000011776024                                                                
     31110 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 1:5 8899000011776024                                                                
     31109 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-27 0:5 8899000011776024                                                                
     31108 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 23: 8899000011776024                                                                
     31107 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 22: 8899000011776024                                                                
     31106 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 21: 8899000011776024                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31105 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 20: 8899000011776024                                                                
     31104 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 19: 8899000011776024                                                                
     31103 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 18: 8899000011776024                                                                
     31102 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 17: 8899000011776024                                                                
     31101 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 16: 8899000011776024                                                                
     31100 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 15: 8899000011776024                                                                
     31099 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 14: 8899000011776024                                                                
     31098 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 13: 8899000011776024                                                                
     31097 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 12: 8899000011776024                                                                
     31096 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 11: 8899000011776024                                                                
     31095 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 10: 8899000011776024                                                                
     31094 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 9:5 8899000011776024                                                                
     31093 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 8:5 8899000011776024                                                                
     31092 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 7:5 8899000011776024                                                                
     31091 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 6:5 8899000011776024                                                                
     31090 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 5:5 8899000011776024                                                                
     31089 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 4:5 8899000011776024                                                                
     31088 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 3:5 8899000011776024                                                                
     31087 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 2:5 8899000011776024                                                                
     31086 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 1:5 8899000011776024                                                                
     31085 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-26 0:5 8899000011776024                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31084 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 23: 8899000011776024                                                                
     31083 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 22: 8899000011776024                                                                
     31082 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 21: 8899000011776024                                                                
     31081 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 20: 8899000011776024                                                                
     31080 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 19: 8899000011776024                                                                
     31079 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 18: 8899000011776024                                                                
     31078 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 17: 8899000011776024                                                                
     31077 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 16: 8899000011776024                                                                
     31076 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 15: 8899000011776024                                                                
     31075 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 14: 8899000011776024                                                                
     31074 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 13: 8899000011776024                                                                
     31073 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 12: 8899000011776024                                                                
     31072 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 11: 8899000011776024                                                                
     31071 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 10: 8899000011776024                                                                
     31070 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 9:5 8899000011776024                                                                
     31069 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 8:5 8899000011776024                                                                
     31068 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 7:5 8899000011776024                                                                
     31067 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 6:5 8899000011776024                                                                
     31066 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 5:5 8899000011776024                                                                
     31065 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 4:5 8899000011776024                                                                
     31064 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 3:5 8899000011776024                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31063 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 2:5 8899000011776024                                                                
     31062 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 1:5 8899000011776024                                                                
     31061 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-25 0:5 8899000011776024                                                                
     31060 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 23: 8899000011776024                                                                
     31059 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 22: 8899000011776024                                                                
     31058 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 21: 8899000011776024                                                                
     31057 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 20: 8899000011776024                                                                
     31056 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 19: 8899000011776024                                                                
     31055 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 18: 8899000011776024                                                                
     31054 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 17: 8899000011776024                                                                
     31053 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 16: 8899000011776024                                                                
     31052 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 15: 8899000011776024                                                                
     31051 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 14: 8899000011776024                                                                
     31050 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 13: 8899000011776024                                                                
     31049 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 12: 8899000011776024                                                                
     31048 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 11: 8899000011776024                                                                
     31047 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 10: 8899000011776024                                                                
     31046 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 9:5 8899000011776024                                                                
     31045 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 8:5 8899000011776024                                                                
     31044 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 7:5 8899000011776024                                                                
     31043 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 6:5 8899000011776024                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31042 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 5:5 8899000011776024                                                                
     31041 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 4:5 8899000011776024                                                                
     31040 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 3:5 8899000011776024                                                                
     31039 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 2:5 8899000011776024                                                                
     31038 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 1:5 8899000011776024                                                                
     31037 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-24 0:5 8899000011776024                                                                
     31036 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 23: 8899000011776024                                                                
     31035 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 22: 8899000011776024                                                                
     31034 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 21: 8899000011776024                                                                
     31033 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 20: 8899000011776024                                                                
     31032 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 19: 8899000011776024                                                                
     31031 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 18: 8899000011776024                                                                
     31030 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 17: 8899000011776024                                                                
     31029 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 16: 8899000011776024                                                                
     31028 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 15: 8899000011776024                                                                
     31027 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 14: 8899000011776024                                                                
     31026 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 13: 8899000011776024                                                                
     31025 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 12: 8899000011776024                                                                
     31024 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 11: 8899000011776024                                                                
     31023 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 10: 8899000011776024                                                                
     31022 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 9:4 8899000011776024                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31021 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 8:4 8899000011776024                                                                
     31020 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 7:4 8899000011776024                                                                
     31019 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 6:4 8899000011776024                                                                
     31018 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 5:4 8899000011776024                                                                
     31017 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 4:4 8899000011776024                                                                
     31016 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 3:4 8899000011776024                                                                
     31015 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 2:4 8899000011776024                                                                
     31014 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 1:4 8899000011776024                                                                
     31013 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-23 0:4 8899000011776024                                                                
     31012 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 23: 8899000011776024                                                                
     31011 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 22: 8899000011776024                                                                
     31010 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 21: 8899000011776024                                                                
     31009 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 20: 8899000011776024                                                                
     31008 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 19: 8899000011776024                                                                
     31007 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 18: 8899000011776024                                                                
     31006 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 17: 8899000011776024                                                                
     31005 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 16: 8210000003789318                                                                
     31005 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 16: 8899000011776024                                                                
     31004 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 15: 8899000011776024                                                                
     31003 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 14: 8899000011776024                                                                
     31002 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 13: 8899000011776033                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     31001 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 12: 8899000011776024                                                                
     31000 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 11: 8899000011776024                                                                
     30999 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 10: 8899000011776024                                                                
     30998 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 9:5 8899000011776024                                                                
     30997 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 8:5 8899000011776024                                                                
     30996 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 7:5 8899000011776024                                                                
     30995 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 6:5 8899000011776024                                                                
     30994 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 5:5 8899000011776024                                                                
     30993 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 4:5 8899000011776024                                                                
     30992 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 3:5 8899000011776033                                                                
     30991 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     31003 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     30992 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     31001 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     31002 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     30994 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     30995 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     30997 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     30996 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     30999 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     30998 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     30993 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     31004 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     31000 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     30991 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 2:5 8899000011776024                                                                
     30990 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 1:5 8899000011776024                                                                
     30990 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 1:5 8899000011776024                                                                
     30989 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 0:5 8899000011776024                                                                
     30989 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-22 0:5 8899000011776024                                                                
     30988 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 23: 8899000011776024                                                                
     30988 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 23: 8899000011776033                                                                
     30987 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 22: 8899000011776024                                                                
     30987 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 22: 8899000011776024                                                                
     30986 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 21: 8899000011776024                                                                
     30986 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 21: 8899000011776024                                                                
     30985 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 20: 8899000011776024                                                                
     30985 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 20: 8899000011776024                                                                
     30984 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 19: 8899000011776024                                                                
     30984 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 19: 8899000011776024                                                                
     30983 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 18: 8899000011776024                                                                
     30983 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 18: 8899000011776024                                                                
     30982 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 17: 8899000011776024                                                                
 
   SNAP_ID       DBID INSTANCE_NUMBER SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH WAS_CAPTURED LAST_CAPTURED VALUE_STRING                                                                     VALUE_ANYDATA
---------- ---------- --------------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ---------- ------------ ------------- -------------------------------------------------------------------------------- -------------
     30982 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 17: 8899000011776024                                                                
     30981 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 16: 8899000011776024                                                                
     30981 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 16: 8899000011776024                                                                
     30980 3757631531               1 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 15: 8899000011776024                                                                
     30980 3757631531               2 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128 YES          2013-6-21 15: 8631571003557911                                                                
 
319 rows selected
SQL> select * from dba_hist_sqltext where sql_id='3thm40um6yqf9';
 
      DBID SQL_ID        SQL_TEXT                                                                         COMMAND_TYPE
---------- ------------- -------------------------------------------------------------------------------- ------------
3757631531 3thm40um6yqf9 select * from t_info_account   where   ACCOUNT_NO=:1 and STATUS!='9'                        3
SQL> select * from DBA_HIST_SQL_BIND_METADATA where sql_id='3thm40um6yqf9';
 
      DBID SQL_ID        NAME                             POSITION DUP_POSITION   DATATYPE DATATYPE_STRING CHARACTER_SID  PRECISION      SCALE MAX_LENGTH
---------- ------------- ------------------------------ ---------- ------------ ---------- --------------- ------------- ---------- ---------- ----------
3757631531 3thm40um6yqf9 :1                                      1                       1 VARCHAR2(128)             871                              128
 
SQL>
        
        
        

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27573546/viewspace-765222/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论