details

gistfile1.txt

   SID NAME                                                             SQLID                    OBJECT       Held       Gets  Held %     Held ms Avg hold ms
---------- ---------------------------------------------------------------- ------------- ----------------- ---------- ---------- ------- ----------- -----------
       583 cache buffers chains                                             3jxk6zqc868jd           6C001C7        367         11     .37      36.113       3.283
      3707 cache buffers chains                                             3jxk6zqc868jd           6C001C7         19          3     .02       1.870        .623
      4288 cache buffers chains                                             3jxk6zqc868jd           6C001C7         19          5     .02       1.870        .374
      1145 cache buffers chains                                             3jxk6zqc868jd           6C001C7          3          3     .00        .295        .098
       284 cache buffers chains                                                                           0          2          2     .00        .197        .098

OWNER              SEGMENT_NAME                         PARTITION_NAME     TABLESPACE_NAME
------------------ ------------------------------------ ------------------ ------------------------------
DELIVERY           SYS_LOB0000096092C00003$$                               DELIVERYD


SQL> desc delivery.RESULT
 Name                                            Null?    Type
 ----------------------------------------------- -------- --------------------------------
 RESULT_GUID                                     NOT NULL VARCHAR2(33 CHAR)
 DELIVERY_GUID                                   NOT NULL VARCHAR2(33 CHAR)
 CONTENT                                         NOT NULL BLOB
 LAST_UPDATED                                             TIMESTAMP(6)
 USER_ID                                         NOT NULL VARCHAR2(33 CHAR)
 PRODUCT_CODE                                    NOT NULL NUMBER(6)
 ENCRYPTED                                                CHAR(1 CHAR)
 CHANGED_DATE                                             TIMESTAMP(6)


SQL_FULLTEXT
------------------------------------------------------------------------------------------------------------------------
INSERT INTO delivery.RESULT (RESULT_GUID,DELIVERY_GUID,CONTENT,LAST_UPDATED,USER_ID,PRODUC
T_CODE,ENCRYPTED,CHANGED_DATE) VALUES(:1 ,:2 ,:3 ,:4 ,:5 ,:6
 ,:7 ,:8 )