
STATSPACK report for

DB Name         DB Id    Instance     Inst Num Release     OPS Host
------------ ----------- ------------ -------- ----------- --- ------------
STY_PROD      3285921907 STY_PROD            1 8.1.7.4.0   NO  spaceserverE
                                                               2900

                Snap Id     Snap Time      Sessions
                ------- ------------------ --------
 Begin Snap:       1397 18-Dec-06 16:22:02      273
   End Snap:       1398 18-Dec-06 16:44:47      273
    Elapsed:                  22.75 (mins)

Cache Sizes
~~~~~~~~~~~
           db_block_buffers:     286720          log_buffer:    1048576
              db_block_size:       8192    shared_pool_size:  838860800

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:             44,015.92              4,685.47
              Logical reads:             18,908.11              2,012.76
              Block changes:                235.09                 25.03
             Physical reads:             12,154.06              1,293.79
            Physical writes:                125.71                 13.38
                 User calls:                516.45                 54.98
                     Parses:                160.39                 17.07
                Hard parses:                  1.25                  0.13
                      Sorts:                 56.03                  5.96
                     Logons:                  0.23                  0.02
                   Executes:                226.26                 24.09
               Transactions:                  9.39

  % Blocks changed per Read:    1.24    Recursive Call %:   32.58
 Rollback per transaction %:    0.82       Rows per Sort:   22.60

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:   99.84       Redo NoWait %:  100.00
            Buffer  Hit   %:   35.72    In-memory Sort %:  100.00
            Library Hit   %:   99.80        Soft Parse %:   99.22
         Execute to Parse %:   29.11         Latch Hit %:   99.93
Parse CPU to Parse Elapsd %:   84.61     % Non-Parse CPU:   97.91

 Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   95.16   95.17
    % SQL with executions>1:   26.84   27.47
  % Memory for SQL w/exec>1:   34.48   35.00

Top 5 Wait Events
~~~~~~~~~~~~~~~~~                                             Wait     % Total
Event                                               Waits  Time (cs)   Wt Time
-------------------------------------------- ------------ ------------ -------
db file sequential read                           708,803      304,884   28.38
enqueue                                               816      243,997   22.71
db file scattered read                          1,908,734      176,265   16.41
library cache lock                                    362      111,398   10.37
log file sync                                      12,977      109,498   10.19
          -------------------------------------------------------------
Wait Events for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> cs - centisecond -  100th of a second
-> ms - millisecond - 1000th of a second
-> ordered by wait time desc, waits desc (idle events last)

                                                                    Avg
                                                     Total Wait    wait  Waits
Event                               Waits   Timeouts  Time (cs)    (ms)   /txn
---------------------------- ------------ ---------- ----------- ------ ------
db file sequential read           708,803          0     304,884      4   55.3
enqueue                               816        787     243,997   2990    0.1
db file scattered read          1,908,734          0     176,265      1  148.9
library cache lock                    362        361     111,398   3077    0.0
log file sync                      12,977          0     109,498     84    1.0
db file parallel write                839          0      68,090    812    0.1
log file parallel write            12,945          0      36,053     28    1.0
direct path read                    4,281          0       9,549     22    0.3
buffer busy waits                  40,045          0       3,274      1    3.1
direct path write                   1,184          0       2,926     25    0.1
log file sequential read            3,204          0       2,684      8    0.2
control file parallel write           460          0       2,551     55    0.0
SQL*Net more data to client         7,308          0       1,338      2    0.6
latch free                          1,604      1,197         819      5    0.1
log file switch completion              7          0         369    527    0.0
file open                           3,295          0         284      1    0.3
SQL*Net message from dblink           657          0          78      1    0.1
control file sequential read          165          0          74      4    0.0
SQL*Net more data from dblin          598          0          35      1    0.0
log file single write                   4          0          24     60    0.0
SQL*Net break/reset to clien           19          0          19     10    0.0
log buffer space                        3          0           8     27    0.0
LGWR wait for redo copy                63          0           3      0    0.0
refresh controlfile command            10          0           3      3    0.0
SQL*Net message to dblink             657          0           0      0    0.1
file identify                           8          0           0      0    0.0
SQL*Net message from client       711,548          0  32,852,783    462   55.5
SQL*Net more data from clien       11,179          0       5,201      5    0.9
SQL*Net message to client         711,611          0         191      0   55.5
          -------------------------------------------------------------
Background Wait Events for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> ordered by wait time desc, waits desc (idle events last)

                                                                    Avg
                                                     Total Wait    wait  Waits
Event                               Waits   Timeouts  Time (cs)    (ms)   /txn
---------------------------- ------------ ---------- ----------- ------ ------
db file parallel write                839          0      68,090    812    0.1
log file parallel write            12,947          0      36,057     28    1.0
log file sequential read            3,204          0       2,684      8    0.2
control file parallel write           460          0       2,551     55    0.0
direct path read                      395          0       1,941     49    0.0
db file scattered read                 63          0         158     25    0.0
db file sequential read                39          0          61     16    0.0
control file sequential read           88          0          55      6    0.0
file open                             867          0          24      0    0.1
log file single write                   4          0          24     60    0.0
latch free                              9          9          13     14    0.0
LGWR wait for redo copy                63          0           3      0    0.0
direct path write                     155          0           2      0    0.0
file identify                           8          0           0      0    0.0
rdbms ipc message                  31,289        868     445,131    142    2.4
pmon timer                            448        440     136,428   3045    0.0
smon timer                              4          3     120,123 ######    0.0
          -------------------------------------------------------------
SQL ordered by Gets for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> End Buffer Gets Threshold:   10000
-> Note that resources reported for PL/SQL includes the resources used by
   all SQL statements called within the PL/SQL code.  As individual SQL
   statements are also reported, it is possible and valid for the summed
   total % to exceed 100

  Buffer Gets    Executions  Gets per Exec  % Total  Hash Value
--------------- ------------ -------------- ------- ------------
     14,541,062          837       17,372.8    56.3    663098444
select M1.REQUEST ,M1.STATUS ,M1.ACTION_ID ,M1.PRIORITY ,TO_CHAR
(M1.ACTION_DATE,'YYYYMMDDHH24MISS') ,M1.GMD_MARKET_ID ,M1.SCCODE
 ,M1.PLCODE ,M1.SWITCH_ID ,M1.CO_ID ,M1.DATA_1 ,M1.DATA_2 ,M1.DA
TA_3  from MDSRRTAB M1 where WORKER_PID=:b0 order by M1.REQUEST


      3,988,892            1    3,988,892.0    15.5   2807323215
SELECT DISTINCT CS.CUSTCODE, CS.CUSTOMER_ID, CC.CCLNAME,CC.CCFNA
ME, CO.CO_ID, DN.DN_NUM, '', ''  , CC.CCBILL, CC.CCBILLTEMP, CC.
CCBILL_PREVIOUS, CC.CCBILLDETAILS, CC.CCUSER     , CC.CCCONTRACT
, CC.CCSHIP, CC.CCMAGAZINE, CC.CCDIRECTORY  FROM CUSTOMER_ALL CS
, CONTRACT_ALL CO, CONTR_SERVICES_CAP CSC, DIRECTORY_NUMBER DN,

      2,191,244          126       17,390.8     8.5   1719834099
select M1.REQUEST ,M1.STATUS ,M1.ACTION_ID ,M1.CO_ID ,M1.CUSTOME
R_ID ,GM.CLEAN_UP_LEVEL ,GA.ACTION_DES  from MDSRRTAB M1 ,GMD_MP
DSCTAB GM ,GMD_ACTION GA where ((M1.WORKER_PID=:b0 and GM.SCCODE
=M1.SCCODE) and GA.ACTION_ID=M1.ACTION_ID) order by REQUEST


      1,460,292           84       17,384.4     5.7   3803431912
select M1.REQUEST ,M1.STATUS ,M1.VMD_RETRY ,M1.ERROR_RETRY ,M1.S
WITCH_ID ,M1.CO_ID ,M1.CUSTOMER_ID ,GA.ACTION_ID ,GA.ACTION_DES
,GM.BYPASS_IND  from MDSRRTAB M1 ,GMD_ACTION GA ,GMD_MPDSCTAB GM
 where ((M1.WORKER_PID=:b0 and M1.ACTION_ID=GA.ACTION_ID) and M1
.SCCODE=GM.SCCODE) order by M1.REQUEST

        822,574          838          981.6     3.2    612157230
update MDSRRTAB M1  set M1.WORKER_PID=:b0,TS=SYSDATE where (((((
(M1.STATUS in (2,10) and M1.ACTION_DATE<=SYSDATE) and M1.REQUEST
>:b1) and M1.WORKER_PID=0) and M1.SWITCH_ID not  in (select GSS.
SWITCH_ID  from GMD_SWITCH_STATE GSS where (GSS.SWITCH_LOCK_STAT
E='D' or GSS.SWITCH_LOCK_STATE='R'))) and ROWNUM<=:b2) and  not

        784,800        1,232          637.0     3.0    613859289
select count(REQUEST) into :b0  from VMD_QUEUE where (STATUS>0 a
nd DEVICE=:b1)

        354,397           54        6,562.9     1.4    282035397
SELECT MAX(PRINTDATE),COUNT(*) CNT   FROM MY_PRINT_STATUS  WHERE
 REPNO = :b1  AND VOUCHERNO = NVL(:b2,VOUCHERNO)  AND VOUCHTYPE
= :b3

        350,171           53        6,607.0     1.4   1981681273
SELECT u.username FROM users u WHERE EXISTS( SELECT USERNAME FRO
M   USERACCESS WHERE USERNAME=u.USERNAME and (modulename LIKE 'K
V%' OR   modulename LIKE 'DB%' ) AND ( UAPERM != 0 ))


        265,545            1      265,545.0     1.0   3376831664
SQL ordered by Gets for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> End Buffer Gets Threshold:   10000
-> Note that resources reported for PL/SQL includes the resources used by
   all SQL statements called within the PL/SQL code.  As individual SQL
   statements are also reported, it is possible and valid for the summed
   total % to exceed 100

  Buffer Gets    Executions  Gets per Exec  % Total  Hash Value
--------------- ------------ -------------- ------- ------------
BEGIN statspack.snap; END;

        260,383            1      260,383.0     1.0    625421128
INSERT INTO STATS$SQLTEXT ( HASH_VALUE,TEXT_SUBSET,PIECE,SQL_TEX
T,ADDRESS,COMMAND_TYPE,LAST_SNAP_ID )  SELECT ST1.HASH_VALUE,SS.
TEXT_SUBSET,ST1.PIECE,ST1.SQL_TEXT,ST1.ADDRESS,ST1.COMMAND_TYPE,
SS.SNAP_ID   FROM V$SQLTEXT ST1,STATS$SQL_SUMMARY SS  WHERE SS.S
NAP_ID = :b1  AND SS.DBID = :b2  AND SS.INSTANCE_NUMBER = :b3  A

        248,470           44        5,647.0     1.0    352378993
SELECT NVL(MAX(CAXACT),0)   FROM CASHRECEIPTS_ALL  WHERE CAUSERN
AME = :b1

        222,714       12,373           18.0     0.9   4110753279
SELECT PARAMETER_ID, PRM_NO, PREDECESSOR_DEPENDENT FROM SERVICE_
PARAMETER   WHERE  SCCODE = :1
                 AND SVCODE = :2

                                ORDER BY 2 ASC

        186,742           32        5,835.7     0.7   3138085453
begin Param_Dependent_Charges . BuildArrayOfPrmStrAndDes ( :loiC
ontractIndex , :lalContractId , :lalParamValueId , :lachStartDat
e , :lachEndDate , :loiOutputArraySize , :laiStartWithElem , :la
chParamStringOut , :lachParamDescrOut , :lachParamDateOut , :lai
NumberOfParamOut , :laiMoreElementOut , :laiErrorCode , :loiNumC

        142,464           53        2,688.0     0.6    313558601
SELECT TMCODE, SUBM_ID, TM_PRG_DEF     FROM MPULKNXG    WHERE TM
CODE IS NOT NULL       AND SUBM_ID IS NOT NULL   UNION   SELECT
TM.TMCODE, -1, ''     FROM MPUTMTAB TM    WHERE TM.STATUS = 'P'
      AND TM.TMGLOBAL != 'Y'       AND TM.GLOBAL_IOT_IND != 'Y'
      AND TM.VSDATE = (SELECT MAX (T.VSDATE)

        142,464           53        2,688.0     0.6   1074414104
SELECT TMCODE, PRGCODE, TM_PRG_DEF     FROM MPULKNXG    WHERE TM
CODE IS NOT NULL      AND PRGCODE IS NOT NULL   UNION   SELECT T
M.TMCODE, -1, ''     FROM MPUTMTAB TM    WHERE TM.STATUS = 'P'
    AND TM.TMGLOBAL != 'Y'      AND TM.GLOBAL_IOT_IND != 'Y'
  AND TM.VSDATE = (SELECT MAX (T.VSDATE)

        142,464           53        2,688.0     0.6   3598406351
SELECT TMCODE, PLCODE, TM_PRG_DEF     FROM MPULKNXG    WHERE TMC
ODE IS NOT NULL       AND PLCODE IS NOT NULL   UNION   SELECT TM

          -------------------------------------------------------------
SQL ordered by Reads for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> End Disk Reads Threshold:    1000

 Physical Reads  Executions  Reads per Exec % Total  Hash Value
--------------- ------------ -------------- ------- ------------
     12,044,444          837       14,390.0    72.6    663098444
select M1.REQUEST ,M1.STATUS ,M1.ACTION_ID ,M1.PRIORITY ,TO_CHAR
(M1.ACTION_DATE,'YYYYMMDDHH24MISS') ,M1.GMD_MARKET_ID ,M1.SCCODE
 ,M1.PLCODE ,M1.SWITCH_ID ,M1.CO_ID ,M1.DATA_1 ,M1.DATA_2 ,M1.DA
TA_3  from MDSRRTAB M1 where WORKER_PID=:b0 order by M1.REQUEST


      1,884,922          126       14,959.7    11.4   1719834099
select M1.REQUEST ,M1.STATUS ,M1.ACTION_ID ,M1.CO_ID ,M1.CUSTOME
R_ID ,GM.CLEAN_UP_LEVEL ,GA.ACTION_DES  from MDSRRTAB M1 ,GMD_MP
DSCTAB GM ,GMD_ACTION GA where ((M1.WORKER_PID=:b0 and GM.SCCODE
=M1.SCCODE) and GA.ACTION_ID=M1.ACTION_ID) order by REQUEST


      1,117,872           84       13,308.0     6.7   3803431912
select M1.REQUEST ,M1.STATUS ,M1.VMD_RETRY ,M1.ERROR_RETRY ,M1.S
WITCH_ID ,M1.CO_ID ,M1.CUSTOMER_ID ,GA.ACTION_ID ,GA.ACTION_DES
,GM.BYPASS_IND  from MDSRRTAB M1 ,GMD_ACTION GA ,GMD_MPDSCTAB GM
 where ((M1.WORKER_PID=:b0 and M1.ACTION_ID=GA.ACTION_ID) and M1
.SCCODE=GM.SCCODE) order by M1.REQUEST

        321,462           54        5,953.0     1.9    282035397
SELECT MAX(PRINTDATE),COUNT(*) CNT   FROM MY_PRINT_STATUS  WHERE
 REPNO = :b1  AND VOUCHERNO = NVL(:b2,VOUCHERNO)  AND VOUCHTYPE
= :b3

        221,313            1      221,313.0     1.3   2807323215
SELECT DISTINCT CS.CUSTCODE, CS.CUSTOMER_ID, CC.CCLNAME,CC.CCFNA
ME, CO.CO_ID, DN.DN_NUM, '', ''  , CC.CCBILL, CC.CCBILLTEMP, CC.
CCBILL_PREVIOUS, CC.CCBILLDETAILS, CC.CCUSER     , CC.CCCONTRACT
, CC.CCSHIP, CC.CCMAGAZINE, CC.CCDIRECTORY  FROM CUSTOMER_ALL CS
, CONTRACT_ALL CO, CONTR_SERVICES_CAP CSC, DIRECTORY_NUMBER DN,

         57,542            1       57,542.0     0.3    851037341
SELECT C1.CUSTCODE CUSTOMER_CODE,C2.CAXACT CACHKNUM,C2.CACHKDATE
 TRANS_DATE,C2.CAUSERNAME NAME,C2.CACHKAMT_PAY AMOUNTL,DECODE(CA
TYPE,1,'Cash Assignment',2,'Assign Overpayment',3,'Cash Overpaym
ent',4,'Write off',5,'Cash to General Ledger',7,'Transfer Out',8
,'Transfer In',9,'Further Charge',10,'Deposit Entry',12,'Deposit

         32,951            1       32,951.0     0.2   2352421953
SELECT C1.CUSTOMER_ID,C1.CUSTCODE,C1.ID_TYPE ID_DOCUMENT,C1.PASS
PORTNO ID_DOCUMENT_NO,C3.CCLINE2,C5.CO_ID,C6.DN_NUM,TRUNC(C8.CH_
VALIDFROM) ACTIVATION_DATE,C8.USERLASTMOD USER_NAME,C8.CH_STATUS
 FIRST_STATUS,C2.CH_STATUS LAST_STATUS,C1.CSCURBALANCE CURRENT_B
ALANCE,C1.BILLCYCLE,RS_DESC CH_REASON,C4.PRGNAME,C10.DES   FROM

         25,408          413           61.5     0.2   2042146178
SELECT  DECODE(CA.CATYPE, '1', 'ACE', '2', 'AO', '6', 'REV', '3'
, 'CO', '4', 'WR', '7', 'TO', '8', 'TI', '9', 'ADJ', '10', 'DE',
 '12', 'DR', '13', 'CN', '14', 'PR', '?') , CA.CARECDATE, CA.CAC
HKNUM, CA.CACHKDATE, CA.PAYMENT_CURRENCY, CD.CADAMT_PAY, CD.CADC
URAMT_PAY, CA.CAXACT, CU.CUSTCODE, CD.CADOXACT FROM CASHRECEIPTS

         17,229            1       17,229.0     0.1   4076196495
SQL ordered by Reads for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> End Disk Reads Threshold:    1000

 Physical Reads  Executions  Reads per Exec % Total  Hash Value
--------------- ------------ -------------- ------- ------------
update MDSRRTAB  set WORKER_PID=:b0 where ((STATUS in (7,8,11,12
,1,2,4,10,14) and WORKER_PID>0) and TS<=(SYSDATE-(3600* (1/((24*
 60)* 60)))))

         17,229            1       17,229.0     0.1   4137143779
select M1.REQUEST ,M1.STATUS  from MDSRRTAB M1 where M1.WORKER_P
ID=:b0 order by M1.REQUEST

         10,914          413           26.4     0.1     70441554
SELECT OHSTATUS, OHREFDATE, OHREFNUM, OHENTDATE, OH.DOCUMENT_CUR
RENCY, OHINVAMT_DOC, OHOPNAMT_DOC, OH.CUSTOMER_ID,  DECODE(OHINV
TYPE, 1, 'Contract based', 2, 'Installation', 3, 'Repair', 4, 'P
hone & accessories', 5, 'Periodic', 6, 'Storno', 7, 'Hot billing
', 8, 'Customer to Company', '') , OHINVTYPE, OHXACT, OH.COMPLAI

          9,391            1        9,391.0     0.1   3376831664
BEGIN statspack.snap; END;

          7,734          189           40.9     0.0   1174582104
SELECT 0,   0,0,0,0,0,0,0,'','','','','','',1, CAXACT,CACHKAMT_P
AY,CACHKAMT_GL,CACURAMT_PAY,CACURAMT_GL, CADISAMT_PAY,CADISAMT_G
L,to_char(CACHKDATE,'YYYYMMDD'), CAPP,CAREASONCODE,0, to_char(CA
ENTDATE,'YYYYMMDD'),to_char(CARECDATE,'YYYYMMDD'), CAGLCASH, CAG
LDIS, PAYMENT_CURRENCY,GL_CURRENCY,CONVRATETYPE_DOC,CONVRATETYPE

          5,807            1        5,807.0     0.0   3200678145
SELECT SUM(RECORD_NUM) RECORD_NUM ,TO_DATE(received,'dd/mm/yyyy'
) FROM imp_file_statistic g,thufitab a  --WHERE TRUNC(received)=
TRUNC(SYSDATE) -1  WHERE TRUNC(received) >=TO_DATE('14/11/2006',
'dd/mm/yyyy') AND TRUNC(received) < =TO_DATE('21/11/2006','dd/mm
/yyyy')  --WHERE TRUNC(PROCESS_DATE)<=TO_DATE('05/08/2006','dd/m

          5,668            1        5,668.0     0.0   2940213182
SELECT SUM(RECORD_NUM) RECORD_NUM ,TO_DATE(received,'dd/mm/yyyy'
) FROM imp_file_statistic g,thufitab a  --WHERE TRUNC(received)=
TRUNC(SYSDATE) -1  WHERE TRUNC(received) >=TO_DATE('21/11/2006',
'dd/mm/yyyy') AND TRUNC(received) < =TO_DATE('17/12/2006','dd/mm
/yyyy')  --WHERE TRUNC(PROCESS_DATE)<=TO_DATE('05/08/2006','dd/m

          -------------------------------------------------------------
SQL ordered by Executions for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -139
-> End Executions Threshold:     100

 Executions   Rows Processed    Rows per Exec   Hash Value
------------ ---------------- ---------------- ------------
      33,759           10,847              0.3   4076695772
SELECT VALUE_SEQNO, PRM_VALUE_DATE,  PRM_VALUE_STRING, PRM_VALUE
_NUMBER, PRM_DESCRIPTION   FROM PARAMETER_VALUE   WHERE PRM_VALU
E_ID = :1               AND PARAMETER_ID = :2
                 AND PRM_NO = :3                               A
ND PRM_SEQNO = :4                                  AND COMPLEX_S

      12,373           38,853              3.1   4110753279
SELECT PARAMETER_ID, PRM_NO, PREDECESSOR_DEPENDENT FROM SERVICE_
PARAMETER   WHERE  SCCODE = :1
                 AND SVCODE = :2

                                ORDER BY 2 ASC

      11,001                0              0.0   2955772585
SELECT COPIES, COPIES     FROM CUST_IMAGES    WHERE CUSTOMER_ID
= :1                 AND TYPE_ID = :2


      10,357           10,357              1.0   3652597466
SELECT SNCODE FROM MPULKNXC WHERE SNCODE = :1         AND SCCODE
 IN  ( 1, 2, 3 )

       6,594            6,594              1.0   2016510618
SELECT USER   FROM SYS.DUAL

       5,471            3,180              0.6   3658062784
 SELECT  PL.PARAMETER_LEVEL_CODE     FROM  MKT_PARAMETER_LEVEL M
PL, PARAMETER_LEVEL PL     WHERE  MPL.PARAMETER_ID = :1
                                                   AND  MPL.SCCO
DE = :2                                                       AN
D PL.PARAMETER_LEVEL_ID = MPL.PARAMETER_LEVEL_ID    AND PL.PARAM

       5,470           13,280              2.4    664860669
 SELECT  MPA.ACTION     FROM  MKT_PARAMETER_ACTION MPA     WHERE
  MPA.PARAMETER_ID = :1
                   AND  MPA.SCCODE = :2
                                                    ORDER BY 1 A
SC

       5,470            3,380              0.6   1025810705
 SELECT  CR.CONSISTENCY_CODE, CR.DESCRIPTION, MPC.CONSISTENCY_ID
, MPC.CONSISTENCY_SEQNO     FROM  MKT_PARAMETER_CONSISTENCY MPC,
 CONSISTENCY_RULE CR     WHERE  MPC.SCCODE = :1
                                      AND MPC.PARAMETER_ID = :2
                                                           AND M

       5,470            2,340              0.4   3028935843
 SELECT  MPC.CHILD_PARAMETER_ID, MPC.COMPLEX_SEQNO     FROM  MKT
_PARAMETER_COMPLEX MPC     WHERE  MPC.SCCODE = :1
                                         START  WITH PARENT_PARA
METER_ID = :2
            CONNECT BY CHILD_PARAMETER_ID = PARENT_PARAMETER_ID

       5,470            5,054              0.9   3297863247
SQL ordered by Executions for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -139
-> End Executions Threshold:     100

 Executions   Rows Processed    Rows per Exec   Hash Value
------------ ---------------- ---------------- ------------
 SELECT  MPD.PRM_VALUE_SEQNO, MPD.PRM_VALUE_STRING, MPD.PRM_VALU
E_NUMBER,     MPD.PRM_VALUE_DATE, MPD.PRM_VALUE_DES, MPD.PRM_VAL
UE_DEF, MPD.REC_VERSION     FROM  MKT_PARAMETER_DOMAIN MPD     W
HERE  MPD.PARAMETER_ID = :1
                       AND  MPD.SCCODE = :2

       4,299            4,299              1.0   2091761008
select condition from cdef$ where rowid=:1

       4,256            2,098              0.5   2913840444
select length from fet$ where file#=:1 and block#=:2 and ts#=:3

       4,086                0              0.0   1423215774
SELECT  SEQ_NO, VALID_FROM, EXPIRATION_DATE, REASON   FROM  TAX_
EXEMPT
                                        WHERE  CUSTOMER_ID = :1
              AND  TAXTYPE_ID  = :2               AND  EXPIRATIO
N_DATE is NULL  UNION  SELECT  SEQ_NO, VALID_FROM, EXPIRATION_DA

       3,380                0              0.0   2927738995
 SELECT  MPR.PARAMETER_ID_RELATED, MPR.RELATED_SEQNO     FROM  M
KT_PARAMETER_RELATED MPR     WHERE  MPR.SCCODE = :1            A
ND MPR.PARAMETER_ID = :2                 AND MPR.CONSISTENCY_ID
= :3
               ORDER BY 2 ASC

       2,902            5,804              2.0   1569019576
SELECT  TAXTYPE_ID, DESCRIPTION    FROM  TAXTYPE   ORDER BY DESC
RIPTION ASC

       2,825           16,950              6.0   2750041397
SELECT IT.TYPE_ID, IT.DES, IT.DEFAULT_COPIES, IT.DEFAULT_COPIES
    FROM IMG_TYPES IT, IMG_TYPES_LEVEL ITL    WHERE ITL.CSLEVEL
= :1          AND IT.TYPE_ID = ITL.TYPE_ID AND IT.DEFAULT_COPIES
 > 0


       2,742           35,793             13.1    915989167
SELECT CO_ID          FROM   CONTR_SERVICES        WHERE  CO_ID
= :1

       2,699            2,699              1.0   4209383936
SELECT MP.MULTIPLE_VALUES_IND,PT.PARAMETER_TYPE_ID,MP.PRM_DES,MP
.RESOURCE_LIKE   FROM MKT_PARAMETER MP,PARAMETER_AREA PA,PARAMET

          -------------------------------------------------------------
SQL ordered by Sharable Memory for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397
-> End Sharable Memory Threshold:   1048576

Sharable Mem (b)  Executions  % Total  Hash Value
---------------- ------------ ------- ------------
       5,065,169           20     0.6    816330795
UPDATE CCONTACT SET REC_VERSION = :1                     ,    CC
MOD = :2               , CCNAME = :3                ,    CCTITLE
 = :4                 , CCFNAME = :5                 ,    CCMNAM
E = :6                 , CCLNAME = :7                 ,    CCLNA
MEMC = :8                   , CCADDR1 = :9                 ,

       1,296,089            2     0.1   3424456422
INSERT INTO CCONTACT   ( CUSTOMER_ID, CCNAME, CCTITLE, CCFNAME,
CCMNAME,    CCLNAME, CCLNAMEMC, CCADDR1, CCADDR2, CCADDR3, CCSTR
EETNO,     CCSTREET, CCCITY, CCSTATE, CCZIP, COUNTRY, CCCOUNTY,
    CCADDRYEARS, CCURGENT, CCFORWARD, CCJOBDESC, CCTN_AREA, CCTN
,     CCTN2_AREA, CCTN2, CCFAX_AREA, CCFAX, CCEMAIL, CCSMSNO,

       1,164,544           20     0.1   3698279462
 UPDATE CUSTOMER     SET  REC_VERSION = :1             + 1,    C
SCUSTTYPE = :2            ,    CSMOD = 'X',    USER_LASTMOD = :3
                   , BIRTHDATE = :4                ,    CSNATION
ALITY = :5                             , CSEMPLOYER = :6
      ,    CSREMARK_1 = :7              , CSREMARK_2 = :8

          -------------------------------------------------------------
SQL ordered by Version Count for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -
-> End Version Count Threshold:        20

 Version
   Count  Executions   Hash Value
-------- ------------ ------------
      55           20    816330795
UPDATE CCONTACT SET REC_VERSION = :1                     ,    CC
MOD = :2               , CCNAME = :3                ,    CCTITLE
 = :4                 , CCFNAME = :5                 ,    CCMNAM
E = :6                 , CCLNAME = :7                 ,    CCLNA
MEMC = :8                   , CCADDR1 = :9                 ,

      26           73   1464076433
SELECT BLID FROM BLACKLIST WHERE BLTAXREGNO = :sTaxRegNo OR BLNA
ME = :sName OR (BLZIP = :sZip AND BLSTREET = :sStreet)

          -------------------------------------------------------------
Instance Activity Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398

Statistic                                    Total   per Second    per Trans
--------------------------------- ---------------- ------------ ------------
CPU used by this session                   193,495        141.8         15.1
CPU used when call started                 145,907        106.9         11.4
CR blocks created                           25,022         18.3          2.0
DBWR buffers scanned                       162,897        119.3         12.7
DBWR checkpoint buffers written             41,559         30.5          3.2
DBWR checkpoints                                 1          0.0          0.0
DBWR free buffers found                    160,435        117.5         12.5
DBWR lru scans                                 124          0.1          0.0
DBWR make free requests                        152          0.1          0.0
DBWR revisited being-written buff              875          0.6          0.1
DBWR summed scan depth                     162,897        119.3         12.7
DBWR transaction table writes                  607          0.4          0.1
DBWR undo block writes                       2,663          2.0          0.2
PX local messages recv'd                         0          0.0          0.0
PX local messages sent                           0          0.0          0.0
SQL*Net roundtrips to/from client          710,409        520.5         55.4
SQL*Net roundtrips to/from dblink              657          0.5          0.1
background checkpoints completed                 1          0.0          0.0
background checkpoints started                   1          0.0          0.0
background timeouts                          1,144          0.8          0.1
branch node splits                               1          0.0          0.0
buffer is not pinned count              22,786,603     16,693.5      1,777.0
buffer is pinned count                  31,238,280     22,885.2      2,436.1
bytes received via SQL*Net from c      164,551,809    120,550.8     12,832.6
bytes received via SQL*Net from d        1,275,069        934.1         99.4
bytes sent via SQL*Net to client       116,681,896     85,481.2      9,099.4
bytes sent via SQL*Net to dblink            86,982         63.7          6.8
calls to get snapshot scn: kcmgss          484,911        355.3         37.8
calls to kcmgas                             14,040         10.3          1.1
calls to kcmgcs                              2,757          2.0          0.2
change write time                              730          0.5          0.1
cleanouts and rollbacks - consist           17,937         13.1          1.4
cleanouts only - consistent read             1,542          1.1          0.1
cluster key scan block gets                368,396        269.9         28.7
cluster key scans                           10,774          7.9          0.8
commit cleanout failures: block l              273          0.2          0.0
commit cleanout failures: buffer               137          0.1          0.0
commit cleanout failures: callbac                0          0.0          0.0
commit cleanout failures: cannot                13          0.0          0.0
commit cleanouts                            58,312         42.7          4.6
commit cleanouts successfully com           57,889         42.4          4.5
consistent changes                          74,005         54.2          5.8
consistent gets                         24,785,811     18,158.1      1,932.9
current blocks converted for CR
cursor authentications                         457          0.3          0.0
data blocks consistent reads - un           64,880         47.5          5.1
db block changes                           320,902        235.1         25.0
db block gets                            1,023,754        750.0         79.8
deferred (CURRENT) block cleanout           24,291         17.8          1.9
dirty buffers inspected                        804          0.6          0.1
enqueue conversions                          4,764          3.5          0.4
enqueue deadlocks                                0          0.0          0.0
enqueue releases                            44,690         32.7          3.5
enqueue requests                            44,696         32.7          3.5
enqueue timeouts                                 1          0.0          0.0
enqueue waits                                    7          0.0          0.0
Instance Activity Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398

Statistic                                    Total   per Second    per Trans
--------------------------------- ---------------- ------------ ------------
execute count                              308,847        226.3         24.1
free buffer inspected                        3,492          2.6          0.3
free buffer requested                   16,155,113     11,835.3      1,259.9
hot buffers moved to head of LRU           128,519         94.2         10.0
immediate (CR) block cleanout app           19,479         14.3          1.5
immediate (CURRENT) block cleanou            4,863          3.6          0.4
index fast full scans (full)                    54          0.0          0.0
leaf node splits                               287          0.2          0.0
logons cumulative                              309          0.2          0.0
logons current
messages received                           14,152         10.4          1.1
messages sent                               14,151         10.4          1.1
no buffer to keep pinned count                   0          0.0          0.0
no work - consistent read gets          23,293,464     17,064.8      1,816.5
opened cursors cumulative                   27,513         20.2          2.2
opened cursors current
parse count (hard)                           1,701          1.3          0.1
parse count (total)                        218,935        160.4         17.1
parse time cpu                               4,045          3.0          0.3
parse time elapsed                           4,781          3.5          0.4
physical reads                          16,590,289     12,154.1      1,293.8
physical reads direct                      469,879        344.2         36.6
physical writes                            171,597        125.7         13.4
physical writes direct                     126,865         92.9          9.9
physical writes non checkpoint             148,127        108.5         11.6
pinned buffers inspected                     1,144          0.8          0.1
prefetched blocks                       13,503,825      9,892.9      1,053.1
prefetched blocks aged out before                3          0.0          0.0
process last non-idle time         311,442,003,718 ############ ############
recursive calls                            340,665        249.6         26.6
recursive cpu usage                          8,706          6.4          0.7
redo blocks written                        127,950         93.7         10.0
redo buffer allocation retries                  10          0.0          0.0
redo entries                               175,729        128.7         13.7
redo log space requests                          7          0.0          0.0
redo log space wait time                       369          0.3          0.0
redo ordering marks                              2          0.0          0.0
redo size                               60,081,728     44,015.9      4,685.5
redo synch time                            109,421         80.2          8.5
redo synch writes                           12,815          9.4          1.0
redo wastage                             3,394,360      2,486.7        264.7
redo write time                             97,298         71.3          7.6
redo writer latching time                        3          0.0          0.0
redo writes                                 12,942          9.5          1.0
rollback changes - undo records a           26,632         19.5          2.1
rollbacks only - consistent read             7,545          5.5          0.6
rows fetched via callback                  158,137        115.9         12.3
session connect time               311,441,845,498 ############ ############
session logical reads                   25,809,565     18,908.1      2,012.8
session pga memory                   1,549,288,336  1,135,009.8    120,821.1
session pga memory max               1,549,638,016  1,135,266.0    120,848.3
session uga memory max               1,355,909,768    993,340.5    105,740.5
sorts (disk)                                     2          0.0          0.0
sorts (memory)                              76,485         56.0          6.0
sorts (rows)                             1,728,431      1,266.3        134.8
summed dirty queue length                    6,637          4.9          0.5
Instance Activity Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398

Statistic                                    Total   per Second    per Trans
--------------------------------- ---------------- ------------ ------------
switch current to new buffer
table fetch by rowid                    16,433,918     12,039.5      1,281.6
table fetch continued row                    5,942          4.4          0.5
table scan blocks gotten                20,294,684     14,867.9      1,582.7
table scan rows gotten                  55,645,102     40,765.6      4,339.5
table scans (long tables)                    1,107          0.8          0.1
table scans (short tables)                  63,706         46.7          5.0
total file opens                             3,296          2.4          0.3
transaction rollbacks                            9          0.0          0.0
transaction tables consistent rea                8          0.0          0.0
transaction tables consistent rea            8,222          6.0          0.6
user calls                                 704,960        516.5         55.0
user commits                                12,718          9.3          1.0
user rollbacks                                 105          0.1          0.0
write clones created in backgroun                0          0.0          0.0
write clones created in foregroun            4,052          3.0          0.3
          -------------------------------------------------------------
Tablespace IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
N_DATA
     2,393,799   1,754    0.3     6.3        1,020        1     39,878    0.8
ORDHDR_LM
        41,794      31   23.9     4.1        3,290        2          0    0.0
SPACETELDATA
        40,815      30    0.8     7.8          107        0         48   24.8
CASHREC_TBS
        22,649      17   20.2     1.0           54        0          0    0.0
ORDTRL_LM
        17,641      13   23.2    16.0        1,019        1          0    0.0
CONTR_SERVICES_LM
         6,230       5   43.0     1.0        8,697        6          0    0.0
CUSTOMER_LM
        10,608       8   20.2     5.6        2,181        2          0    0.0
CASHDET_TBS
        11,853       9   23.1     1.0           64        0          0    0.0
CONTACT_LM
        11,322       8   19.1     5.0          171        0          0    0.0
MY_TBS
         2,890       2   27.6     1.0        4,294        3          1   10.0
PK_TBS3
         6,853       5   22.0     1.0           99        0          0    0.0
CONTR_HISTORY_LM
         5,662       4   22.3     5.6           14        0          0    0.0
STYTEMPTBS
         3,494       3   70.9   #####          547        0          0    0.0
I_CONTR_SERVICES_LM
         2,662       2   26.2     1.0        1,318        1          0    0.0
N_I_DATA
         1,556       1   25.3     1.0        2,363        2          1    0.0
DOCUMENT_LM
             8       0  195.0     1.0        3,781        3          0    0.0
RBS
           406       0   22.4     1.0        2,884        2         22    7.3
PARAM_TBS
         2,630       2   24.8     1.0          184        0          0    0.0
DIRECTORY
         2,685       2   22.8     2.0            3        0          0    0.0
SYSTEM
         1,430       1   80.5    27.7        1,116        1          0    0.0
CONTRACT_LM
         1,814       1   25.7     1.0          681        0          0    0.0
I_CONTRACT_LM
         2,412       2   25.5     1.0           41        0          0    0.0
I_TICKLER_LM
         1,057       1   26.6     1.0        1,326        1          0    0.0
CONTRS_TBS
         2,293       2   29.2     3.3           32        0          0    0.0
IX_TBS
           523       0   35.4     1.0        1,605        1          0    0.0
IN_TBS
         1,696       1   27.4     1.0          236        0          0    0.0
Tablespace IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
BCH_TBS
           161       0   46.3     1.7        1,738        1          0    0.0
TICKLER_LM
         1,702       1   21.8     1.0          153        0          0    0.0
CASH2_TBS
           996       1   40.4     1.0          813        1          0    0.0
CONTR_DEVICES_LM
         1,732       1   32.7     1.0           64        0          0    0.0
PK_TBS36
         1,743       1   26.7     1.0            9        0          0    0.0
RATE_TBS
         1,655       1   26.5     1.0           22        0          0    0.0
I_CONTR_DEVICES_LM
         1,493       1   26.0     1.0          124        0          0    0.0
I_ORDHDR_LM
           914       1   27.7     1.0          658        0          0    0.0
I_CONTACT_LM
           566       0   27.2     1.0          755        1          0    0.0
PORT_LM
         1,226       1   25.3     1.0           64        0          0    0.0
VMD_TBS
           842       1   41.4     1.0          250        0         72   11.5
PK_TBS8
           958       1   28.9     1.0           90        0          0    0.0
FK_TBS1
           965       1   28.5     1.0           47        0          0    0.0
USER_TBS
           383       0   66.9     1.2          618        0          7   30.0
PK_TBS22
           794       1   31.4     1.0           27        0          0    0.0
PAY_TBS
           804       1   28.3     1.0            2        0          0    0.0
PK_TBS4
           675       0   29.1     1.0          126        0          0    0.0
I_PORT_LM
           699       1   26.3     1.0           32        0          0    0.0
MPU_TBS
           642       0   29.6     1.0           87        0          0    0.0
PK_TBS18
           583       0   33.3     1.0          115        0          0    0.0
STORMED_LM
           606       0   27.5     1.0           64        0          0    0.0
I_DOCUMENT_LM
            57       0   56.1     1.0          485        0          0    0.0
I_STORMED_LM
           521       0   26.5     1.0            1        0          0    0.0
PK_TBS10
           360       0   35.8     1.0          120        0          3    0.0
CALLSDETRBS
            45       0   38.0     1.0          420        0          6    0.0
PK_TBS17
           422       0   33.9     1.0            2        0          0    0.0
Tablespace IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
I_DIRECTORY
           391       0   38.3     1.0            5        0          0    0.0
I_CUSTOMER_LM
           378       0   30.5     1.0           11        0          0    0.0
PK_TBS9
           108       0   61.6     1.0          199        0          0    0.0
GMD_TBS
            16       0  271.9     1.0          260        0          0    0.0
INFO_TBS
           125       0   53.0     1.0          144        0          0    0.0
FK_TBS2
            69       0   85.7     1.0          191        0          0    0.0
TEMP
           115       0  109.8    74.3          143        0          0    0.0
FK_TBS3
            99       0   69.3     1.0          113        0          0    0.0
PK_TBS33
            16       0  311.9     1.0          186        0          0    0.0
PK_TBS5
           102       0   60.0     1.0           97        0          0    0.0
PK_TBS35
           131       0   55.7     1.2            1        0          0    0.0
I_ORDERTXTTR_LM
            11       0  137.3     1.0          119        0          0    0.0
APP_TBS
             5       0  902.0     1.0          117        0          1    0.0
PK_TBS32
             5       0  934.0     1.0          108        0          0    0.0
PK_TBS27
             2       0 ######     1.0          106        0          1    0.0
I_ORDTRL_LM
             4       0  425.0     1.0           66        0          0    0.0
I_CASH_LM
             7       0  282.9     1.0           49        0          0    0.0
PK_TBS30
            52       0  112.3     1.0            2        0          0    0.0
PK_TBS26
             2       0 ######     1.0           49        0          0    0.0
PK_TBS6
            47       0  117.7     1.0            1        0          0    0.0
PK_TBS13
            36       0  144.7     1.0            3        0          0    0.0
PK_TBS28
            17       0  284.7     1.0           20        0          0    0.0
PK_TBS31
             6       0  761.7     1.0           30        0          0    0.0
ORDERTXTTR_LM
             2       0  735.0     1.0           30        0          0    0.0
FK_TBS4
            11       0  433.6     1.0           16        0          0    0.0
GL_TBS
            15       0  295.3     1.2            8        0          0    0.0
Tablespace IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
MPD_TBS
            16       0  282.5     1.2            1        0          0    0.0
MPS_TBS
            14       0  306.4     1.0            2        0          0    0.0
IU_TBS
            12       0  358.3     1.0            3        0          0    0.0
CONTR_TBS
             7       0 ######     1.0            6        0          0    0.0
RULE_TBS
            12       0  412.5     1.1            1        0          0    0.0
SERVICE_TBS
            10       0  483.0     1.0            1        0          0    0.0
PK_TBS37
             1       0 ######     1.0            9        0          0    0.0
BILLCYCLE_TBS
             8       0  557.5     1.0            1        0          0    0.0
MKT_TBS
             8       0  531.3     1.0            1        0          0    0.0
NLS_TBS
             8       0  520.0     1.3            1        0          0    0.0
CUST_TBS
             6       0 ######     1.0            2        0          0    0.0
PK_TBS29
             5       0  930.0     1.0            3        0          0    0.0
RES_TBS
             7       0 ######     1.0            1        0          0    0.0
ER_TBS
             6       0  753.3     1.0            1        0          0    0.0
ADR_TBS
             5       0  906.0     1.0            1        0          0    0.0
BATCH_TBS
             5       0  902.0     1.0            1        0          0    0.0
BUSINESS_TBS
             5       0  904.0     1.0            1        0          0    0.0
CAS
             5       0  896.0     1.0            1        0          0    0.0
DOCREF_TBS
             5       0  906.0     1.0            1        0          0    0.0
FK_TBS10
             4       0 ######     1.0            2        0          0    0.0
NET_TBS
             5       0  830.0     1.0            1        0          0    0.0
FK_TBS11
             4       0 ######     1.0            1        0          0    0.0
FK_TBS5
             4       0 ######     1.0            1        0          0    0.0
FK_TBS6
             4       0 ######     1.0            1        0          0    0.0
FK_TBS7
             4       0 ######     1.0            1        0          0    0.0
FK_TBS8
             4       0 ######     1.0            1        0          0    0.0
Tablespace IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
FK_TBS9
             4       0 ######     1.0            1        0          0    0.0
FUP_TBS
             4       0 ######     1.0            1        0          0    0.0
MIG_TBS
             4       0 ######     1.0            1        0          0    0.0
PK_TBS11
             4       0 ######     1.0            1        0          0    0.0
PK_TBS12
             4       0 ######     1.0            1        0          0    0.0
CASHCOLL
             3       0 ######     1.0            1        0          0    0.0
CASHTRL
             3       0 ######     1.0            1        0          0    0.0
I_BILLIMAGE_LM
             3       0  656.7     1.0            1        0          0    0.0
ORD_TBS
             3       0 ######     1.0            1        0          0    0.0
PK_TBS1
             3       0 ######     1.0            1        0          0    0.0
PK_TBS14
             3       0 ######     1.0            1        0          0    0.0
PK_TBS15
             3       0 ######     1.0            1        0          0    0.0
PK_TBS2
             3       0 ######     1.0            1        0          0    0.0
PK_TBS24
             3       0 ######     1.0            1        0          0    0.0
PK_TBS25
             3       0 ######     1.0            1        0          0    0.0
PK_TBS7
             3       0 ######     1.0            1        0          0    0.0
VEND_TBS
             3       0 ######     1.0            1        0          0    0.0
I_MPSEC_LM
             2       0  860.0     1.0            1        0          0    0.0
MPSEC_LM
             2       0  780.0     1.0            1        0          0    0.0
PK_TBS16
             2       0 ######     1.0            1        0          0    0.0
PK_TBS19
             2       0 ######     1.0            1        0          0    0.0
PK_TBS20
             2       0 ######     1.0            1        0          0    0.0
PK_TBS21
             2       0 ######     1.0            1        0          0    0.0
PK_TBS23
             2       0 ######     1.0            1        0          0    0.0
PK_TBS34
             2       0 ######     1.0            1        0          0    0.0
PK_TBS40
             2       0 ######     1.0            1        0          0    0.0
Tablespace IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
BILLIMAGE
             1       0 ######     1.0            1        0          0    0.0
MY_SERVICES_HISTORY
             1       0 ######     1.0            1        0          0    0.0
PK_TBS38
             1       0 ######     1.0            1        0          0    0.0
PK_TBS39
             1       0 ######     1.0            1        0          0    0.0
PK_TBS41
             1       0 ######     1.0            1        0          0    0.0
PK_TBS42
             1       0 ######     1.0            1        0          0    0.0
PK_TBS43
             1       0 ######     1.0            1        0          0    0.0
PK_TBS44
             1       0 ######     1.0            1        0          0    0.0
PORT_LM_1
             1       0 ######     1.0            1        0          0    0.0
PROMO_TBS
             1       0 ######     1.0            1        0          0    0.0
RAP_TBS
             1       0 ######     1.0            1        0          0    0.0
RA_TBS
             1       0 ######     1.0            1        0          0    0.0
SIMTBS
             1       0 ######     1.0            1        0          0    0.0
SPACETELTMP
             1       0 ######     1.0            1        0          0    0.0
SPACETEL_DAY_TWO
             1       0 ######     1.0            1        0          0    0.0
STORMED_LM_1
             1       0 ######     1.0            1        0          0    0.0
SYSRBS
             1       0 ######     1.0            1        0          0    0.0
TOOL
             1       0 ######     1.0            1        0          0    0.0
UC_TBS
             1       0 ######     1.0            1        0          0    0.0
UDC_TBS
             1       0 ######     1.0            1        0          0    0.0
UDS_TBS
             1       0 ######     1.0            1        0          0    0.0
UK_TBS
             1       0 ######     1.0            1        0          0    0.0
USERSDAT
             1       0 ######     1.0            1        0          0    0.0
USERSTMP
             1       0 ######     1.0            1        0          0    0.0
          -------------------------------------------------------------
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
ADR_TBS                  /STY_PROD/data/ADR_TBS.dbf
             5       0  906.0     1.0            1        0          0

APP_TBS                  /STY_PROD/data/APP_TBS.dbf
             5       0  902.0     1.0          117        0          1    0.0

BATCH_TBS                /STY_PROD/data/BATCH_TBS.dbf
             5       0  902.0     1.0            1        0          0

BCH_TBS                  /STY_PROD/data/BCH_TBS.dbf
           161       0   46.3     1.7        1,738        1          0

BILLCYCLE_TBS            /STY_PROD/data/BILLCYCLE_TBS.dbf
             8       0  557.5     1.0            1        0          0

BILLIMAGE                /STY_PROD/data/BILLIMAGE_1.dbf
             1       0 ######     1.0            1        0          0

BUSINESS_TBS             /STY_PROD/data/BUSINESS_TBS.dbf
             5       0  904.0     1.0            1        0          0

CALLSDETRBS              /STY_PROD/rbs/callsdetrbs.dbf
            45       0   38.0     1.0          420        0          6    0.0

CAS                      /STY_PROD/data/CAS.dbf
             5       0  896.0     1.0            1        0          0

CASH2_TBS                /STY_PROD/data/CASH2_TBS.dbf
           996       1   40.4     1.0          813        1          0

CASHCOLL                 /STY_PROD/data/CASHCOLL.dbf
             3       0 ######     1.0            1        0          0

CASHDET_TBS              /STY_PROD/data/CASHDET_TBS.dbf
        11,853       9   23.1     1.0           64        0          0

CASHREC_TBS              /STY_PROD/data/CASHREC_TBS.dbf
        22,649      17   20.2     1.0           54        0          0

CASHTRL                  /STY_PROD/data/CASHTRL.dbf
             3       0 ######     1.0            1        0          0

CONTACT_LM               /STY_PROD/data/CONTACT_LM.dbf
        11,322       8   19.1     5.0          171        0          0

CONTRACT_LM              /STY_PROD/data/CONTRACT.dbf
         1,814       1   25.7     1.0          681        0          0

CONTRS_TBS               /STY_PROD/data/CONTRS_TBS.dbf
         2,293       2   29.2     3.3           32        0          0

CONTR_DEVICES_LM         /STY_PROD/data/CONTR_DEVICES_LM.dbf
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
         1,732       1   32.7     1.0           64        0          0

CONTR_HISTORY_LM         /STY_PROD/data/CONTR_HISTORY_LM.dbf
         5,662       4   22.3     5.6           14        0          0

CONTR_SERVICES_LM        /STY_PROD/data/CONTR_SERVICES_LM.dbf
         6,230       5   43.0     1.0        8,697        6          0

CONTR_TBS                /STY_PROD/data/CONTR_TBS.dbf
             7       0 ######     1.0            6        0          0

CUSTOMER_LM              /STY_PROD/data/CUSTOMER_LM.dbf
        10,608       8   20.2     5.6        2,181        2          0

CUST_TBS                 /STY_PROD/data/CUST_TBS.dbf
             6       0 ######     1.0            2        0          0

DIRECTORY                /STY_PROD/data/DIRECTORY.dbf
         2,685       2   22.8     2.0            3        0          0

DOCREF_TBS               /STY_PROD/data/DOCREF_TBS.dbf
             5       0  906.0     1.0            1        0          0

DOCUMENT_LM              /STY_PROD/data/DOCUMENT_LM.dbf
             8       0  195.0     1.0        3,781        3          0

ER_TBS                   /STY_PROD/data/ER_TBS.dbf
             6       0  753.3     1.0            1        0          0

FK_TBS1                  /STY_PROD/index/FK_TBS1.dbf
           965       1   28.5     1.0           47        0          0

FK_TBS10                 /STY_PROD/index/FK_TBS10.dbf
             4       0 ######     1.0            2        0          0

FK_TBS11                 /STY_PROD/index/FK_TBS11.dbf
             4       0 ######     1.0            1        0          0

FK_TBS2                  /STY_PROD/index/FK_TBS2.dbf
            69       0   85.7     1.0          191        0          0

FK_TBS3                  /STY_PROD/index/FK_TBS3.dbf
            99       0   69.3     1.0          113        0          0

FK_TBS4                  /STY_PROD/index/FK_TBS4.dbf
            11       0  433.6     1.0           16        0          0

FK_TBS5                  /STY_PROD/index/FK_TBS5.dbf
             4       0 ######     1.0            1        0          0

FK_TBS6                  /STY_PROD/index/FK_TBS6.dbf
             4       0 ######     1.0            1        0          0
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------

FK_TBS7                  /STY_PROD/index/FK_TBS7.dbf
             4       0 ######     1.0            1        0          0

FK_TBS8                  /STY_PROD/index/FK_TBS8.dbf
             4       0 ######     1.0            1        0          0

FK_TBS9                  /STY_PROD/index/FK_TBS9.dbf
             4       0 ######     1.0            1        0          0

FUP_TBS                  /STY_PROD/data/FUP_TBS.dbf
             4       0 ######     1.0            1        0          0

GL_TBS                   /STY_PROD/data/GL_TBS.dbf
            15       0  295.3     1.2            8        0          0

GMD_TBS                  /STY_PROD/data/GMD_TBS.dbf
            16       0  271.9     1.0          260        0          0

INFO_TBS                 /STY_PROD/data/INFO_TBS.dbf
           125       0   53.0     1.0          144        0          0

IN_TBS                   /STY_PROD/index/IN_TBS.dbf
         1,696       1   27.4     1.0          236        0          0

IU_TBS                   /STY_PROD/index/IU_TBS.dbf
            12       0  358.3     1.0            3        0          0

IX_TBS                   /STY_PROD/index/IX_TBS.dbf
           523       0   35.4     1.0        1,605        1          0

I_BILLIMAGE_LM           /STY_PROD/index/I_BILLIMAGE_LM.dbf
             3       0  656.7     1.0            1        0          0

I_CASH_LM                /STY_PROD/index/I_CASH_LM.dbf
             7       0  282.9     1.0           49        0          0

I_CONTACT_LM             /STY_PROD/index/I_CONTACT_LM.dbf
           566       0   27.2     1.0          755        1          0

I_CONTRACT_LM            /STY_PROD/index/I_CONTRACT_LM.dbf
         2,412       2   25.5     1.0           41        0          0

I_CONTR_DEVICES_LM       /STY_PROD/index/I_CONTR_DEVICES_LM.dbf
         1,493       1   26.0     1.0          124        0          0

I_CONTR_SERVICES_LM      /STY_PROD/index/I_CONTR_SERVICES_LM.dbf
         2,662       2   26.2     1.0        1,318        1          0

I_CUSTOMER_LM            /STY_PROD/index/I_CUSTOMER_LM.dbf
           378       0   30.5     1.0           11        0          0

File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
I_DIRECTORY              /STY_PROD/index/I_DIRECTORY.dbf
           391       0   38.3     1.0            5        0          0

I_DOCUMENT_LM            /STY_PROD/index/I_DOCUMENT_LM.dbf
            57       0   56.1     1.0          485        0          0

I_MPSEC_LM               /STY_PROD/index/I_MPSEC_LM.dbf
             2       0  860.0     1.0            1        0          0

I_ORDERTXTTR_LM          /STY_PROD/index/I_ORDERTXTTR_LM.dbf
            11       0  137.3     1.0          119        0          0

I_ORDHDR_LM              /STY_PROD/index/I_ORDHDR_LM.dbf
           914       1   27.7     1.0          658        0          0

I_ORDTRL_LM              /STY_PROD/index/I_ORDTRL_LM.dbf
             4       0  425.0     1.0           66        0          0

I_PORT_LM                /STY_PROD/index/I_PORT_LM.dbf
           699       1   26.3     1.0           32        0          0

I_STORMED_LM             /STY_PROD/index/I_STORMED_LM.dbf
           521       0   26.5     1.0            1        0          0

I_TICKLER_LM             /STY_PROD/index/I_TICKLER_LM.dbf
         1,057       1   26.6     1.0        1,326        1          0

MIG_TBS                  /STY_PROD/data/MIG_TBS.dbf
             4       0 ######     1.0            1        0          0

MKT_TBS                  /STY_PROD/data/MKT_TBS.dbf
             8       0  531.3     1.0            1        0          0

MPD_TBS                  /STY_PROD/data/MPD_TBS.dbf
            16       0  282.5     1.2            1        0          0

MPSEC_LM                 /STY_PROD/data/MPSEC_LM.dbf
             2       0  780.0     1.0            1        0          0

MPS_TBS                  /STY_PROD/data/MPS_TBS.dbf
            14       0  306.4     1.0            2        0          0

MPU_TBS                  /STY_PROD/data/MPU_TBS.dbf
           642       0   29.6     1.0           87        0          0

MY_SERVICES_HISTORY      /STY_PROD/data/MY_SERVICES_HISTORY.dbf
             1       0 ######     1.0            1        0          0

MY_TBS                   /STY_PROD/data/MY_TBS.dbf
         1,794       1   28.4     1.0        3,199        2          1   10.0
                         /STY_PROD/data/MY_TBS2.dbf
         1,096       1   26.2     1.0        1,095        1          0
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------

NET_TBS                  /STY_PROD/data/NET_TBS.dbf
             5       0  830.0     1.0            1        0          0

NLS_TBS                  /STY_PROD/data/NLS_TBS.dbf
             8       0  520.0     1.3            1        0          0

N_DATA                   /STY_PROD/data/N_DATA.dbf
     2,393,799   1,754    0.3     6.3        1,020        1     39,878    0.8

N_I_DATA                 /STY_PROD/index/N_I_DATA.dbf
         1,556       1   25.3     1.0        2,363        2          1    0.0

ORDERTXTTR_LM            /STY_PROD/data/ORDERTXTTR_LM.dbf
             2       0  735.0     1.0           30        0          0

ORDHDR_LM                /STY_PROD/data/ORDHDR_LM.dbf
        41,794      31   23.9     4.1        3,290        2          0

ORDTRL_LM                /STY_PROD/data/ORDTRL_LM.dbf
        17,641      13   23.2    16.0        1,019        1          0

ORD_TBS                  /STY_PROD/data/ORD_TBS_TBS.dbf
             3       0 ######     1.0            1        0          0

PARAM_TBS                /STY_PROD/data/PARAM_TBS.dbf
         2,630       2   24.8     1.0          184        0          0

PAY_TBS                  /STY_PROD/data/PAY_TBS.dbf
           804       1   28.3     1.0            2        0          0

PK_TBS1                  /STY_PROD/index/PK_TBS1.dbf
             3       0 ######     1.0            1        0          0

PK_TBS10                 /STY_PROD/index/PK_TBS10.dbf
           360       0   35.8     1.0          120        0          3    0.0

PK_TBS11                 /STY_PROD/index/PK_TBS11.dbf
             4       0 ######     1.0            1        0          0

PK_TBS12                 /STY_PROD/index/PK_TBS12.dbf
             4       0 ######     1.0            1        0          0

PK_TBS13                 /STY_PROD/index/PK_TBS13.dbf
            36       0  144.7     1.0            3        0          0

PK_TBS14                 /STY_PROD/index/PK_TBS14.dbf
             3       0 ######     1.0            1        0          0

PK_TBS15                 /STY_PROD/index/PK_TBS15.dbf
             3       0 ######     1.0            1        0          0

File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
PK_TBS16                 /STY_PROD/index/PK_TBS16.dbf
             2       0 ######     1.0            1        0          0

PK_TBS17                 /STY_PROD/index/PK_TBS17.dbf
           422       0   33.9     1.0            2        0          0

PK_TBS18                 /STY_PROD/index/PK_TBS18.dbf
           583       0   33.3     1.0          115        0          0

PK_TBS19                 /STY_PROD/index/PK_TBS19.dbf
             2       0 ######     1.0            1        0          0

PK_TBS2                  /STY_PROD/index/PK_TBS2.dbf
             3       0 ######     1.0            1        0          0

PK_TBS20                 /STY_PROD/index/PK_TBS20.dbf
             2       0 ######     1.0            1        0          0

PK_TBS21                 /STY_PROD/index/PK_TBS21.dbf
             2       0 ######     1.0            1        0          0

PK_TBS22                 /STY_PROD/index/PK_TBS22.dbf
           794       1   31.4     1.0           27        0          0

PK_TBS23                 /STY_PROD/index/PK_TBS23.dbf
             2       0 ######     1.0            1        0          0

PK_TBS24                 /STY_PROD/index/PK_TBS24.dbf
             3       0 ######     1.0            1        0          0

PK_TBS25                 /STY_PROD/index/PK_TBS25.dbf
             3       0 ######     1.0            1        0          0

PK_TBS26                 /STY_PROD/index/PK_TBS26.dbf
             2       0 ######     1.0           49        0          0

PK_TBS27                 /STY_PROD/index/PK_TBS27.dbf
             2       0 ######     1.0          106        0          1    0.0

PK_TBS28                 /STY_PROD/index/PK_TBS28.dbf
            17       0  284.7     1.0           20        0          0

PK_TBS29                 /STY_PROD/index/PK_TBS29.dbf
             5       0  930.0     1.0            3        0          0

PK_TBS3                  /STY_PROD/index/PK_TBS3.dbf
         6,853       5   22.0     1.0           99        0          0

PK_TBS30                 /STY_PROD/index/PK_TBS30.dbf
            52       0  112.3     1.0            2        0          0

PK_TBS31                 /STY_PROD/index/PK_TBS31.dbf
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
             6       0  761.7     1.0           30        0          0

PK_TBS32                 /STY_PROD/index/PK_TBS32.dbf
             5       0  934.0     1.0          108        0          0

PK_TBS33                 /STY_PROD/index/PK_TBS33.dbf
            16       0  311.9     1.0          186        0          0

PK_TBS34                 /STY_PROD/index/PK_TBS34.dbf
             2       0 ######     1.0            1        0          0

PK_TBS35                 /STY_PROD/index/PK_TBS35.dbf
           131       0   55.7     1.2            1        0          0

PK_TBS36                 /STY_PROD/index/PK_TBS36.dbf
         1,743       1   26.7     1.0            9        0          0

PK_TBS37                 /STY_PROD/index/PK_TBS37.dbf
             1       0 ######     1.0            9        0          0

PK_TBS38                 /STY_PROD/index/PK_TBS38.dbf
             1       0 ######     1.0            1        0          0

PK_TBS39                 /STY_PROD/index/PK_TBS39.dbf
             1       0 ######     1.0            1        0          0

PK_TBS4                  /STY_PROD/index/PK_TBS4.dbf
           675       0   29.1     1.0          126        0          0

PK_TBS40                 /STY_PROD/index/PK_TBS40.dbf
             2       0 ######     1.0            1        0          0

PK_TBS41                 /STY_PROD/index/PK_TBS41.dbf
             1       0 ######     1.0            1        0          0

PK_TBS42                 /STY_PROD/index/PK_TBS42.dbf
             1       0 ######     1.0            1        0          0

PK_TBS43                 /STY_PROD/index/PK_TBS43.dbf
             1       0 ######     1.0            1        0          0

PK_TBS44                 /STY_PROD/index/PK_TBS44.dbf
             1       0 ######     1.0            1        0          0

PK_TBS5                  /STY_PROD/index/PK_TBS5.dbf
           102       0   60.0     1.0           97        0          0

PK_TBS6                  /STY_PROD/index/PK_TBS6.dbf
            47       0  117.7     1.0            1        0          0

PK_TBS7                  /STY_PROD/index/PK_TBS7.dbf
             3       0 ######     1.0            1        0          0
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------

PK_TBS8                  /STY_PROD/index/PK_TBS8.dbf
           958       1   28.9     1.0           90        0          0

PK_TBS9                  /STY_PROD/index/PK_TBS9.dbf
           108       0   61.6     1.0          199        0          0

PORT_LM                  /STY_PROD/data/PORT_LM.dbf
         1,226       1   25.3     1.0           64        0          0

PORT_LM_1                /STY_PROD/data/PORT_LM_1.dbf
             1       0 ######     1.0            1        0          0

PROMO_TBS                /STY_PROD/data/PROMO_TBS.dbf
             1       0 ######     1.0            1        0          0

RAP_TBS                  /STY_PROD/data/RAP_TBS.dbf
             1       0 ######     1.0            1        0          0

RATE_TBS                 /STY_PROD/data/RATE_TBS.dbf
         1,655       1   26.5     1.0           22        0          0

RA_TBS                   /STY_PROD/data/RA_TBS.dbf
             1       0 ######     1.0            1        0          0

RBS                      /STY_PROD/rbs/RBS_1.dbf
           406       0   22.4     1.0        2,884        2         22    7.3

RES_TBS                  /STY_PROD/data/RES_TBS.dbf
             7       0 ######     1.0            1        0          0

RULE_TBS                 /STY_PROD/data/RULE_TBS.dbf
            12       0  412.5     1.1            1        0          0

SERVICE_TBS              /STY_PROD/data/SERVICE_TBS.dbf
            10       0  483.0     1.0            1        0          0

SIMTBS                   /STY_PROD/data/SIMTBS.dbf
             1       0 ######     1.0            1        0          0

SPACETELDATA             /STY_PROD/data/SPACETELDATA_1.dbf
        40,815      30    0.8     7.8          107        0         48   24.8

SPACETELTMP              /STY_PROD/tmp/SPACETELTMP.dbf
             1       0 ######     1.0            1        0          0

SPACETEL_DAY_TWO         /STY_PROD/data/spacetel_day_two.dbf
             1       0 ######     1.0            1        0          0

STORMED_LM               /STY_PROD/data/STORMED.dbf
           606       0   27.5     1.0           64        0          0

File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
STORMED_LM_1             /STY_PROD/data/STORMED_1.dbf
             1       0 ######     1.0            1        0          0

STYTEMPTBS               /STY_PROD/tmp/STYTEMPTBS.TDF
         3,494       3   70.9   #####          547        0          0

SYSRBS                   /STY_PROD/data/SYSRBS.dbf
             1       0 ######     1.0            1        0          0

SYSTEM                   /STY_PROD/sys/system_1.dbf
           928       1  110.2    42.1          899        1          0
                         /STY_PROD/sys/system_2.dbf
           502       0   25.7     1.1          217        0          0

TEMP                     /STY_PROD/tmp/TEMP_1.dbf
           115       0  109.8    74.3          143        0          0

TICKLER_LM               /STY_PROD/data/TICKLER.dbf
         1,702       1   21.8     1.0          153        0          0

TOOL                     /STY_PROD/data/TOOL_1.dbf
             1       0 ######     1.0            1        0          0

UC_TBS                   /STY_PROD/index/UC_TBS.dbf
             1       0 ######     1.0            1        0          0

UDC_TBS                  /STY_PROD/data/UDC_TBS.dbf
             1       0 ######     1.0            1        0          0

UDS_TBS                  /STY_PROD/data/UDS_TBS.dbf
             1       0 ######     1.0            1        0          0

UK_TBS                   /STY_PROD/index/UK_TBS.dbf
             1       0 ######     1.0            1        0          0

USERSDAT                 /STY_PROD/data/usersdat.dbf
             1       0 ######     1.0            1        0          0

USERSTMP                 /STY_PROD/data/userstmp.dbf
             1       0 ######     1.0            1        0          0

USER_TBS                 /STY_PROD/data/USER_TBS.dbf
           383       0   66.9     1.2          618        0          7   30.0

VEND_TBS                 /STY_PROD/data/VEND_TBS.dbf
             3       0 ######     1.0            1        0          0

VMD_TBS                  /STY_PROD/data/VMD_TBS.dbf
           842       1   41.4     1.0          250        0         72   11.5

          -------------------------------------------------------------
Buffer Pool Statistics for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> Pools   D: default pool,  K: keep pool,  R: recycle pool

                                                      Free    Write     Buffer
       Buffer    Consistent    Physical   Physical  Buffer Complete       Busy
P        Gets          Gets       Reads     Writes   Waits    Waits      Waits
- ----------- ------------- ----------- ---------- ------- -------- ----------
D  16,164,366    23,802,225  16,128,527     44,919       0        0     40,043
          -------------------------------------------------------------





Buffer wait Statistics for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> ordered by wait time desc, waits desc

                                 Tot Wait    Avg
Class                    Waits  Time (cs) Time (cs)
------------------ ----------- ---------- ---------
data block              40,013      3,276         0
undo header                 19         16         1
undo block                   9          0         0
          -------------------------------------------------------------





Enqueue activity for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> ordered by waits desc, gets desc

Enqueue            Gets      Waits
---------- ------------ ----------
TX               14,053          6
ST                  943          1
          -------------------------------------------------------------
Rollback Segment Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->A high value for "Pct Waits" suggests more rollback segments may be required

       Trans Table      Pct   Undo Bytes
RBS No     Gets       Waits     Written        Wraps  Shrinks  Extends
------ ------------ ------- --------------- -------- -------- --------
     0          5.0    0.00               0        0        0        0
     1     14,115.0    0.00         453,062        1        0        0
     2      1,308.0    0.00         282,114        0        0        0
     3      4,292.0    0.00         239,392        0        0        0
     4      3,010.0    0.00       2,472,718        7        0        0
     5     35,816.0    0.03       2,445,364        6        0        0
     6     62,259.0    0.00         126,724        0        0        0
     7      9,555.0    0.00       2,424,368        5        0        0
     8     14,841.0    0.00         116,896        1        0        0
     9      3,276.0    0.00         495,306        1        0        0
    10     25,448.0    0.01       1,037,956        2        0        0
    11      2,388.0    0.00       1,187,824        3        0        0
    47      6,639.0    0.00       2,105,880        0        0        0
          -------------------------------------------------------------
Rollback Segment Storage for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->Optimal Size should be larger than Avg Active

RBS No    Segment Size      Avg Active    Optimal Size    Maximum Size
------ --------------- --------------- --------------- ---------------
     0       4,907,008           8,192                       4,907,008
     1     200,220,672       1,125,863                     200,220,672
     2       6,258,688       9,987,827       6,144,000      26,738,688
     3       6,258,688       1,582,183       6,144,000      16,498,688
     4       6,504,448       1,576,946       6,144,000       6,504,448
     5       6,504,448         781,618       6,144,000      15,024,128
     6     675,700,736       1,104,975                     675,700,736
     7     911,179,776         547,985                     911,179,776
     8     315,744,256       1,717,147                     315,744,256
     9     158,670,848       1,046,349                     158,670,848
    10     947,290,112       1,665,499                     947,290,112
    11     648,536,064      10,934,996                     648,536,064
    47      10,477,568       2,454,577      10,485,760      10,477,568
          -------------------------------------------------------------
Latch Activity for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
  willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

                                                Pct    Avg                 Pct
                                   Get          Get   Slps       NoWait NoWait
Latch Name                       Requests      Miss  /Miss     Requests   Miss
----------------------------- -------------- ------ ------ ------------ ------
Token Manager                          2,742    0.0                 682    0.0
active checkpoint queue latch          1,210    0.0                   0
archive control                            2    0.0                   0
archive process latch                      2    0.0                   0
begin backup scn array                    15    0.0                   0
cache buffer handles                  27,354    0.0    0.0            0
cache buffers chains              68,118,106    0.0    0.0   31,594,145    0.0
cache buffers lru chain           21,029,728    0.2    0.0   16,149,167    0.2
channel handle pool latch                555    0.0                   0
channel operations parent lat            858    0.0                   0
checkpoint queue latch               174,472    0.0    0.6            0
dml lock allocation                   47,343    0.0    0.0            0
enqueue hash chains                   95,006    0.0    0.0            0
enqueues                             111,372    0.0    0.0            0
event group latch                        303    0.0                   0
global transaction                    18,757    0.0                   0
global tx free list                      938    0.0                   0
global tx hash mapping                 4,427    0.0                   1    0.0
job_queue_processes parameter             24    0.0                   0
ktm global data                            4    0.0                   0
latch wait list                          723    1.7    0.0          713    0.0
library cache                      6,467,322    0.3    0.0       14,128    0.4
library cache load lock                  162    0.0                   0
list of block allocation              28,992    0.0    0.0            0
loader state object freelist              30    0.0                   0
longop free list                      76,330    0.0    0.0            0
messages                             273,569    0.1    0.0            0
multiblock read objects            4,971,455    0.1    0.0            0
ncodef allocation latch                   24    0.0                   0
process allocation                       303    0.0                 303    0.0
process group creation                   555    0.0                   0
redo allocation                      201,709    0.0    0.0            0
redo writing                          67,818    1.3    0.0            0
row cache objects                  2,309,694    0.1    0.0            0
sequence cache                           948    0.0                   0
session allocation                    43,497    0.1    0.0            0
session idle bit                   1,430,903    0.0    0.0           19    0.0
session switching                         45    0.0                   0
shared pool                          219,164    0.1    0.8            0
sort extent pool                         158    0.0                   0
transaction allocation                42,767    0.0    0.0            0
transaction branch allocation          9,122    0.0                   0
undo global data                     255,127    0.0    0.0            0
user lock                              1,118    0.0                   0
          -------------------------------------------------------------
Latch Sleep breakdown for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> ordered by misses desc

                                Get                                  Spin &
Latch Name                    Requests         Misses      Sleeps Sleeps 1->4
-------------------------- -------------- ----------- ----------- ------------
cache buffers lru chain        21,029,728      38,237         388 37854/378/5/
                                                                  0/0
library cache                   6,467,322      16,869         821 16255/424/17
                                                                  3/17/0
cache buffers chains           68,118,106      11,873         131 11760/96/16/
                                                                  1/0
multiblock read objects         4,971,455       4,468          38 4430/38/0/0/
                                                                  0
row cache objects               2,309,694       1,694          18 1676/18/0/0/
                                                                  0
redo writing                       67,818         901           2 899/2/0/0/0
shared pool                       219,164         224         190 129/8/79/8/0
messages                          273,569         219           2 217/2/0/0/0
session idle bit                1,430,903          66           2 64/2/0/0/0
session allocation                 43,497          53           2 51/2/0/0/0
enqueues                          111,372          36           1 35/1/0/0/0
checkpoint queue latch            174,472          13           8 5/8/0/0/0
          -------------------------------------------------------------
Latch Miss Sources for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait             Waiter
Latch Name               Where                       Misses     Sleeps  Sleeps
------------------------ -------------------------- ------- ---------- -------
cache buffers chains     kcbrls: kslbegin                 0         79      13
cache buffers chains     kcbgtcr: kslbegin                0         39     100
cache buffers chains     kcbzib: multi-block read:        0          5       0
cache buffers chains     kcbgcur: kslbegin                0          2       1
cache buffers chains     kcbzwb                           0          2       5
cache buffers chains     kcbzib: finish free bufs         0          2       6
cache buffers chains     kcbchg: kslbegin: bufs not       0          1       1
cache buffers chains     kcbzgb: scan from tail. no       0          1       0
cache buffers lru chain  kcbzgb: multiple sets nowa       0        244       0
cache buffers lru chain  kcbbiop: lru scan                0         67       0
cache buffers lru chain  kcbzar: KSLNBEGIN                0         60     346
cache buffers lru chain  kcbzgm                           0         15      38
cache buffers lru chain  kcbzgb: posted for free bu       0          2       0
checkpoint queue latch   kcbk0rrd: update recovery        0          8       0
enqueues                 ksqgtl2                          0          1       0
library cache            kglhdgn: child:                  0        243      66
library cache            kglic                            0        182      40
library cache            kglpnal: child: before pro       0         24     122
library cache            kgllkdl: child: cleanup          0         23      14
library cache            kglpnal: child: alloc spac       0         17      93
library cache            kglhdgc: child:                  0         13      34
library cache            kglpndl: parent: purge           0         13       0
library cache            kglpnc: child                    0          9     110
library cache            kglupc: child                    0          9     164
library cache            kgldti: 2child                   0          8       2
library cache            kgllkdl: child: free pin         0          3     128
library cache            kglati                           0          1       0
library cache            kgldte: child 0                  0          1      12
library cache            kgllkal: parent                  0          1       0
messages                 ksaamb: after wakeup             0          1       2
messages                 ksarcv: after wait               0          1       0
multiblock read objects  kcbzib: MBRFRE                   0         22      20
multiblock read objects  kcbzib: MBRGET                   0         16      18
redo writing             kcrfsr                           0          2       0
row cache objects        kqrpsc: incr stat                0         11       0
row cache objects        kqrpre: find obj                 0          5      12
row cache objects        kqreqd: rel enqueue              0          1       0
row cache objects        kqrplk                           0          1       0
session allocation       ksuxds: not user session         0          2       2
session idle bit         kqp327i                          0          1       0
session idle bit         ksupuc: set busy                 0          1       0
shared pool              kghfrunp: clatch: nowait         0        265       0
shared pool              kghfrunp: alloc: clatch no       0        182       0
shared pool              kghfrunp: clatch: wait           0          9      13
shared pool              kghalo                           0          7      24
shared pool              kghfre                           0          1       0
          -------------------------------------------------------------
Dictionary Cache Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->"Pct Misses"  should be very low (< 2% in most cases)
->"Cache Usage" is the number of cache entries being used
->"Pct SGA"     is the ratio of usage to allocated size for that cache

                           Get         Pct     Scan   Pct      Mod  Final  Pct
Cache                    Requests     Miss Requests  Miss      Req  Usage  SGA
---------------------- ------------ ------ -------- ----- -------- ------ ----
dc_constraints                    0               0              0     23   77
dc_database_links               226    0.4        0              0    107   99
dc_files                          0               0              0      0    0
dc_free_extents             104,134    4.1      928   0.0    4,755  6,779  100
dc_global_oids                    0               0              0      0    0
dc_histogram_data                 0               0              0      0    0
dc_histogram_data_valu            0               0              0      0    0
dc_histogram_defs            37,813    0.0        0              0  3,414  100
dc_object_ids               413,917    0.0        0              0  1,361  100
dc_objects                   20,502    1.2        0              2 ######  100
dc_outlines                       0               0              0      0    0
dc_profiles                     566    0.0        0              0      7   54
dc_rollback_segments            384    0.0        0              0     49   94
dc_segments                  43,881    0.0        0            823  1,230   99
dc_sequence_grants                0               0              0      0    0
dc_sequences                     15    0.0        0             15      4   80
dc_synonyms                   6,310    0.0        0              0    528  100
dc_tablespace_quotas             73    0.0        0             28     26   74
dc_tablespaces               29,150    0.0        0              0     60   91
dc_used_extents               1,811   45.1        0          1,811    165    5
dc_user_grants                1,862    0.1        0              0    272   91
dc_usernames                  6,848    0.0        0              0    269   99
dc_users                     55,794    0.0        0              0    275   97
ifs_acl_cache_entries             0               0              0      0    0
          -------------------------------------------------------------


Library Cache Activity for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398
->"Pct Misses"  should be very low

                    Get       Pct        Pin        Pct               Invali-
Namespace         Requests    Miss     Requests     Miss     Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY                   1,087    0.0          1,087    0.0          0        0
CLUSTER                    2    0.0              3    0.0          0        0
INDEX                      0                     0                 0        0
OBJECT                     0                     0                 0        0
PIPE                       0                     0                 0        0
SQL AREA             217,316    0.8      1,560,975    0.2         74        1
TABLE/PROCEDURE       44,241    0.9        104,682    0.1         40        0
TRIGGER                1,493    0.0          1,493    0.0          0        0
          -------------------------------------------------------------
SGA Memory Summary for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398

SGA regions                       Size in Bytes
------------------------------ ----------------
Database Buffers                  2,348,810,240
Fixed Size                              102,076
Redo Buffers                          1,064,960
Variable Size                       938,811,392
                               ----------------
sum                               3,288,788,668
          -------------------------------------------------------------


SGA breakdown difference for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398

Pool        Name                        Begin value      End value  Difference
----------- ------------------------ -------------- -------------- -----------
java pool   free memory                      32,768         32,768           0
large pool  free memory                  20,010,528     20,010,528           0
shared pool Checkpoint queue              1,344,672      1,344,672           0
shared pool DML locks                       385,728        385,728           0
shared pool KGFF heap                       113,256        113,256           0
shared pool KGK heap                         40,496         40,496           0
shared pool KQLS heap                     9,107,584      8,277,832    -829,752
shared pool PL/SQL DIANA                  1,460,744      1,328,968    -131,776
shared pool PL/SQL MPCODE                 1,130,136      1,125,408      -4,728
shared pool PLS non-lib hp                    2,136          2,136           0
shared pool PX msg pool                      97,272         97,272           0
shared pool PX subheap                        9,168          9,168           0
shared pool State objects                 1,068,576      1,068,576           0
shared pool db_block_buffers             59,637,760     59,637,760           0
shared pool db_block_hash_buckets         9,928,880      9,928,880           0
shared pool db_files                        402,328        402,328           0
shared pool db_handles                      413,600        413,600           0
shared pool dictionary cache             35,039,768     35,892,768     853,000
shared pool enqueue_resources               344,864        344,864           0
shared pool event statistics per ses      1,812,384      1,812,384           0
shared pool fixed allocation callbac          4,200          4,200           0
shared pool free memory                  44,466,368     44,391,016     -75,352
shared pool ktlbk state objects             307,664        307,664           0
shared pool library cache               181,864,360    182,616,512     752,152
shared pool miscellaneous                 4,793,264      5,299,864     506,600
shared pool processes                       503,840        503,840           0
shared pool sessions                      1,269,504      1,269,504           0
shared pool simulator trace entries         240,000        240,000           0
shared pool sql area                    561,727,160    560,661,376  -1,065,784
shared pool table columns                    59,896         57,240      -2,656
shared pool table definiti                   12,800         10,984      -1,816
shared pool transaction_branches            230,400        230,400           0
shared pool transactions                    872,480        872,480           0
shared pool trigger defini                    4,768          4,768           0
shared pool trigger inform                   30,136         30,248         112
shared pool trigger source                    1,088          1,088           0
            db_block_buffers          2,348,810,240  2,348,810,240           0
            fixed_sga                       102,076        102,076           0
            log_buffer                    1,048,576      1,048,576           0
          -------------------------------------------------------------
init.ora Parameters for DB: STY_PROD  Instance: STY_PROD  Snaps: 1397 -1398

                                                                  End value
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
_trace_files_public           TRUE
background_dump_dest          /STY_PROD/sys/bdmp
compatible                    8.1.7.4
control_files                 /STY_PROD/logcntl/cntl_1.ctl, /ST
core_dump_dest                /STY_PROD/sys/cdmp
cursor_space_for_time         FALSE
db_block_buffers              286720
db_block_lru_latches          12
db_block_size                 8192
db_file_multiblock_read_count 16
db_files                      1000
db_name                       STY_PROD
distributed_transactions      300
ifile                         /oracle/product/8.1.7/dbs/configS
java_pool_size                32768
large_pool_size               20010522
log_archive_dest              /STY_PROD/arch
log_archive_format            T%TS%S.ARC
log_archive_start             TRUE
log_buffer                    1048576
log_checkpoint_interval       512
log_checkpoint_timeout        600
max_dump_file_size            UNLIMITED
max_enabled_roles             32
max_rollback_segments         32
nls_date_format               YYYYMMDD-HH24.MI.SS
nls_language                  AMERICAN
nls_numeric_characters        .
nls_territory                 AMERICA
open_cursors                  750
open_links                    8
optimizer_mode                CHOOSE
os_authent_prefix
partition_view_enabled        TRUE
processes                     470
query_rewrite_enabled         TRUE
query_rewrite_integrity       TRUSTED
remote_login_passwordfile     EXCLUSIVE
resource_limit                TRUE
rollback_segments             r01, r02, r03, r04
shared_pool_size              838860800
sort_area_retained_size       10485760
sort_area_size                10485760
sql_trace                     FALSE
timed_statistics              TRUE
user_dump_dest                /STY_PROD/sys/udmp
utl_file_dir                  *
          -------------------------------------------------------------

End of Report

