
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:       1395 18-Dec-06 13:27:03      241
   End Snap:       1396 18-Dec-06 13:49:52      241
    Elapsed:                  22.82 (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:             22,478.24              5,526.71
              Logical reads:             14,411.01              3,543.22
              Block changes:                 98.54                 24.23
             Physical reads:              8,643.57              2,125.19
            Physical writes:                 31.65                  7.78
                 User calls:                203.36                 50.00
                     Parses:                 56.97                 14.01
                Hard parses:                  0.74                  0.18
                      Sorts:                 22.20                  5.46
                     Logons:                  0.13                  0.03
                   Executes:                 87.24                 21.45
               Transactions:                  4.07

  % Blocks changed per Read:    0.68    Recursive Call %:   22.95
 Rollback per transaction %:    1.33       Rows per Sort:   32.34

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:   99.95       Redo NoWait %:  100.00
            Buffer  Hit   %:   40.02    In-memory Sort %:   99.99
            Library Hit   %:   99.66        Soft Parse %:   98.70
         Execute to Parse %:   34.70         Latch Hit %:   99.96
Parse CPU to Parse Elapsd %:   91.37     % Non-Parse CPU:   97.06

 Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   95.11   95.12
    % SQL with executions>1:   30.67   30.84
  % Memory for SQL w/exec>1:   32.30   32.06

Top 5 Wait Events
~~~~~~~~~~~~~~~~~                                             Wait     % Total
Event                                               Waits  Time (cs)   Wt Time
-------------------------------------------- ------------ ------------ -------
enqueue                                             1,116      341,808   74.53
db file sequential read                           788,140       56,390   12.30
db file scattered read                          1,751,795       26,741    5.83
log file sync                                       5,580       14,075    3.07
db file parallel write                                571       12,059    2.63
          -------------------------------------------------------------
Wait Events for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
-> 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
---------------------------- ------------ ---------- ----------- ------ ------
enqueue                             1,116      1,110     341,808   3063    0.2
db file sequential read           788,140          0      56,390      1  141.5
db file scattered read          1,751,795          0      26,741      0  314.6
log file sync                       5,580          0      14,075     25    1.0
db file parallel write                571          0      12,059    211    0.1
log file parallel write             5,576          0       5,153      9    1.0
control file parallel write           441          0         990     22    0.1
direct path write                     210          0         613     29    0.0
latch free                            443        354         287      6    0.1
direct path read                      210          0         257     12    0.0
buffer busy waits                   9,187          0          59      0    1.6
SQL*Net more data to client         5,169          0          33      0    0.9
SQL*Net break/reset to clien           69          0          31      4    0.0
file open                           1,002          0          29      0    0.2
SQL*Net message from dblink           288          0          27      1    0.1
SQL*Net more data from dblin          314          0          12      0    0.1
local write wait                        3          0          11     37    0.0
control file sequential read           97          0           5      1    0.0
SQL*Net message to dblink             288          0           1      0    0.1
LGWR wait for redo copy                20          0           0      0    0.0
refresh controlfile command            10          0           0      0    0.0
SQL*Net message from client       282,263          0  18,434,026    653   50.7
SQL*Net more data from clien        6,770          0       1,117      2    1.2
SQL*Net message to client         282,275          0          67      0   50.7
          -------------------------------------------------------------
Background Wait Events for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
-> 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                571          0      12,059    211    0.1
log file parallel write             5,576          0       5,153      9    1.0
control file parallel write           441          0         990     22    0.1
db file scattered read                 64          0          93     15    0.0
db file sequential read                14          0          11      8    0.0
latch free                              4          4           5     13    0.0
LGWR wait for redo copy                20          0           0      0    0.0
control file sequential read           20          0           0      0    0.0
rdbms ipc message                  18,273      1,254     488,349    267    3.3
pmon timer                            450        442     136,749   3039    0.1
smon timer                              4          4      92,160 ######    0.0
          -------------------------------------------------------------
SQL ordered by Gets for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
-> 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
--------------- ------------ -------------- ------- ------------
     11,153,488          642       17,373.0    56.5    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


      2,328,953          134       17,380.2    11.8   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


        965,113          642        1,503.3     4.9    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

        903,589           52       17,376.7     4.6   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

        835,747        1,312          637.0     4.2    613859289
select count(REQUEST) into :b0  from VMD_QUEUE where (STATUS>0 a
nd DEVICE=:b1)

        395,580          621          637.0     2.0   3198971203
select REQUEST ,EVENT_CODE ,SENDER ,CMD_FNAME ,MARKET ,STATUS  f
rom VMD_QUEUE where ((STATUS<0 and STATUS>:b0) and DEVICE=:b1) o
rder by INDATE asc

        294,408           23       12,800.3     1.5    352378993
SELECT NVL(MAX(CAXACT),0)   FROM CASHRECEIPTS_ALL  WHERE CAUSERN
AME = :b1

        261,113            1      261,113.0     1.3   3376831664
BEGIN statspack.snap; END;

        247,730            1      247,730.0     1.3    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

SQL ordered by Gets for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
-> 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
--------------- ------------ -------------- ------- ------------
        225,498          354          637.0     1.1   2350359349
select REQUEST ,EVENT_CODE ,SENDER ,CMD_FNAME ,MARKET ,STATUS  f
rom VMD_QUEUE where ((STATUS<0 and STATUS>:b0) and DEVICE=:b1) o
rder by Priority desc ,INDATE asc

        216,514           33        6,561.0     1.1    282035397
SELECT MAX(PRINTDATE),COUNT(*) CNT   FROM MY_PRINT_STATUS  WHERE
 REPNO = :b1  AND VOUCHERNO = NVL(:b2,VOUCHERNO)  AND VOUCHTYPE
= :b3

        191,102           11       17,372.9     1.0     87657542
SELECT status, COUNT(*)  FROM  mdsrrtab  GROUP BY status

        118,926           18        6,607.0     0.6   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 ))


         87,270          137          637.0     0.4   3478223632
select REQUEST ,SENDER  from VMD_QUEUE where STATUS=:b0


         76,140        4,230           18.0     0.4   4110753279
SELECT PARAMETER_ID, PRM_NO, PREDECESSOR_DEPENDENT FROM SERVICE_
PARAMETER   WHERE  SCCODE = :1
                 AND SVCODE = :2

                                ORDER BY 2 ASC

         48,384           18        2,688.0     0.2    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)

         48,384           18        2,688.0     0.2   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)

         48,384           18        2,688.0     0.2   3598406351
SELECT TMCODE, PLCODE, TM_PRG_DEF     FROM MPULKNXG    WHERE TMC
ODE IS NOT NULL       AND PLCODE IS NOT NULL   UNION   SELECT TM
.TMCODE, -1, ''     FROM MPUTMTAB TM    WHERE TM.STATUS = 'P'

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

 Physical Reads  Executions  Reads per Exec % Total  Hash Value
--------------- ------------ -------------- ------- ------------
      8,824,548          642       13,745.4    74.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,617,986          134       12,074.5    13.7   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


        686,533           52       13,202.6     5.8   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

        198,760           33        6,023.0     1.7    282035397
SELECT MAX(PRINTDATE),COUNT(*) CNT   FROM MY_PRINT_STATUS  WHERE
 REPNO = :b1  AND VOUCHERNO = NVL(:b2,VOUCHERNO)  AND VOUCHTYPE
= :b3

        172,074           11       15,643.1     1.5     87657542
SELECT status, COUNT(*)  FROM  mdsrrtab  GROUP BY status

         15,870            1       15,870.0     0.1   4137143779
select M1.REQUEST ,M1.STATUS  from MDSRRTAB M1 where M1.WORKER_P
ID=:b0 order by M1.REQUEST

         15,868            1       15,868.0     0.1   4076196495
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)))))

          7,550          121           62.4     0.1   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

          7,157            1        7,157.0     0.1   3376831664
BEGIN statspack.snap; END;

          4,297          100           43.0     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

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

 Physical Reads  Executions  Reads per Exec % Total  Hash Value
--------------- ------------ -------------- ------- ------------
          3,848          100           38.5     0.0    587606118
SELECT OHXACT,   OHINVTYPE,OHINVAMT_DOC,OHINVAMT_GL,NVL(OHOPNAMT
_DOC,OHINVAMT_DOC),NVL(OHOPNAMT_GL,OHINVAMT_GL), DOCUMENT_CURREN
CY,GL_CURRENCY,to_char(OHREFDATE,'YYYYMMDD'), to_char(OHENTDATE,
'YYYYMMDD'),to_char(CONVDATE_EXCHANGE,'YYYYMMDD'), OHGLAR,OHREFN
UM,OHSTATUS,GL_CONVRATETYPE_ID, 0,0,0,0,0,0,0,'','',0,0,'','', '

          3,618            1        3,618.0     0.0   3337740287
INSERT INTO STATS$SQL_STATISTICS ( SNAP_ID,DBID,INSTANCE_NUMBER,
TOTAL_SQL,TOTAL_SQL_MEM,SINGLE_USE_SQL,SINGLE_USE_SQL_MEM )  SEL
ECT :b1,:b2,:b3,COUNT(1),SUM(SHARABLE_MEM),SUM(DECODE(EXECUTIONS
,1,1,0)),SUM(DECODE(EXECUTIONS,1,SHARABLE_MEM,0))   FROM V$SQLXS


          3,570            1        3,570.0     0.0   2064955574
INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID,DBID,INSTANCE_NUMBER,TEX
T_SUBSET,SHARABLE_MEM,SORTS,MODULE,LOADED_VERSIONS,EXECUTIONS,LO
ADS,INVALIDATIONS,PARSE_CALLS,DISK_READS,BUFFER_GETS,ROWS_PROCES
SED,ADDRESS,HASH_VALUE,VERSION_COUNT )  SELECT :b1,:b2,:b3,SUBST
RB(SQL_TEXT,1,31),SHARABLE_MEM,SORTS,MODULE,LOADED_VERSIONS,EXEC

          2,840          121           23.5     0.0     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

          2,806           12          233.8     0.0    517849157
SELECT tr.customer_id,   tr.tickler_number, tr.tickler_code,   t
r.tickler_status, tr.priority,   tr.follow_up_user, tr.follow_up
_date,   tr.FOLLOW_UP_CODE, tr.short_description,   tr.x_coordin
ate, tr.y_coordinate,tr.tr_code,   tr.co_id   FROM tickler_recor
ds tr

          2,742           23          119.2     0.0    352378993
SELECT NVL(MAX(CAXACT),0)   FROM CASHRECEIPTS_ALL  WHERE CAUSERN
AME = :b1

          2,130          406            5.2     0.0   1092836282
SELECT DISTINCT CS.CUSTCODE, CS.CUSTOMER_ID, CC.CCLNAME,CC.CCFNA
ME, CO.CO_ID, DN.DN_NUM,  '', ''  , CC.CCBILL, CC.CCBILLTEMP, CC

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

 Executions   Rows Processed    Rows per Exec   Hash Value
------------ ---------------- ---------------- ------------
       9,124            2,743              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

       4,883            4,883              1.0    226434519
SELECT CUSTCODE FROM CUSTOMER WHERE CUSTOMER_ID=:1


       4,883            4,883              1.0   1063886973
SELECT TICKL_STAT_WEIGHT FROM tickler_status WHERE TICKLER_STATU
S=:1


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


       4,230           13,302              3.1   4110753279
SELECT PARAMETER_ID, PRM_NO, PREDECESSOR_DEPENDENT FROM SERVICE_
PARAMETER   WHERE  SCCODE = :1
                 AND SVCODE = :2

                                ORDER BY 2 ASC

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

       2,998            2,998              1.0   2016510618
SELECT USER   FROM SYS.DUAL

       2,711            2,711              1.0   2091761008
select condition from cdef$ where rowid=:1

       1,909            4,631              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

       1,909            1,113              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

       1,908            1,173              0.6   1025810705
 SELECT  CR.CONSISTENCY_CODE, CR.DESCRIPTION, MPC.CONSISTENCY_ID
, MPC.CONSISTENCY_SEQNO     FROM  MKT_PARAMETER_CONSISTENCY MPC,
SQL ordered by Executions for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -139
-> End Executions Threshold:     100

 Executions   Rows Processed    Rows per Exec   Hash Value
------------ ---------------- ---------------- ------------
 CONSISTENCY_RULE CR     WHERE  MPC.SCCODE = :1
                                      AND MPC.PARAMETER_ID = :2
                                                           AND M

       1,908              810              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

       1,908            1,762              0.9   3297863247
 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

       1,689                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

       1,360            1,360              1.0    243615965
INSERT INTO MY_SERVICES_HISTORY ( CO_ID,SNCODE,TRANS_DATE,VAL_BE
FORE,VAL_AFTER,USER_NAME,OLD_STATUS,NEW_STATUS,FIRST_TIME,REQUES
T )  VALUES ( :b1,:b2,SYSDATE,SUBSTR(:b3,-7,7),SUBSTR(:b4,-7,7),
USER,SUBSTR(:b3,-1,1),SUBSTR(:b4,-1,1),DECODE(LENGTH(:b4), NULL
,1,7,1,0),:b8  )

       1,312            1,312              1.0    613859289
select count(REQUEST) into :b0  from VMD_QUEUE where (STATUS>0 a
nd DEVICE=:b1)

       1,176                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

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

Sharable Mem (b)  Executions  % Total  Hash Value
---------------- ------------ ------- ------------
       3,988,540           54     0.4    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,164,544           56     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: 1395 -
-> End Version Count Threshold:        20

 Version
   Count  Executions   Hash Value
-------- ------------ ------------
      44           54    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                 ,

      25           43   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: 1395 -1396

Statistic                                    Total   per Second    per Trans
--------------------------------- ---------------- ------------ ------------
CPU used by this session                    72,740         53.1         13.1
CPU used when call started                  72,687         53.1         13.1
CR blocks created                            7,339          5.4          1.3
DBWR buffers scanned                       126,619         92.5         22.7
DBWR checkpoint buffers written             17,342         12.7          3.1
DBWR checkpoints                                 0          0.0          0.0
DBWR free buffers found                    123,218         90.0         22.1
DBWR lru scans                                 138          0.1          0.0
DBWR make free requests                        194          0.1          0.0
DBWR revisited being-written buff              113          0.1          0.0
DBWR summed scan depth                     126,619         92.5         22.7
DBWR transaction table writes                  234          0.2          0.0
DBWR undo block writes                       1,277          0.9          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          281,571        205.7         50.6
SQL*Net roundtrips to/from dblink              288          0.2          0.1
background checkpoints completed                 0          0.0          0.0
background checkpoints started                   0          0.0          0.0
background timeouts                          1,319          1.0          0.2
branch node splits                               1          0.0          0.0
buffer is not pinned count              17,720,341     12,944.0      3,182.5
buffer is pinned count                  17,854,521     13,042.0      3,206.6
bytes received via SQL*Net from c       63,697,190     46,528.3     11,439.9
bytes received via SQL*Net from d          662,029        483.6        118.9
bytes sent via SQL*Net to client        48,309,228     35,288.0      8,676.2
bytes sent via SQL*Net to dblink            37,160         27.1          6.7
calls to get snapshot scn: kcmgss          185,305        135.4         33.3
calls to kcmgas                              5,804          4.2          1.0
calls to kcmgcs                              2,979          2.2          0.5
change write time                              250          0.2          0.0
cleanouts and rollbacks - consist            6,532          4.8          1.2
cleanouts only - consistent read               360          0.3          0.1
cluster key scan block gets                  9,259          6.8          1.7
cluster key scans                              213          0.2          0.0
commit cleanout failures: block l              120          0.1          0.0
commit cleanout failures: buffer                80          0.1          0.0
commit cleanout failures: callbac                4          0.0          0.0
commit cleanout failures: cannot                 5          0.0          0.0
commit cleanouts                            28,977         21.2          5.2
commit cleanouts successfully com           28,768         21.0          5.2
consistent changes                          47,674         34.8          8.6
consistent gets                         19,268,712     14,075.0      3,460.6
current blocks converted for CR
cursor authentications                         290          0.2          0.1
data blocks consistent reads - un           47,270         34.5          8.5
db block changes                           134,897         98.5         24.2
db block gets                              459,959        336.0         82.6
deferred (CURRENT) block cleanout           13,358          9.8          2.4
dirty buffers inspected                        320          0.2          0.1
enqueue conversions                          2,978          2.2          0.5
enqueue deadlocks                                0          0.0          0.0
enqueue releases                            18,995         13.9          3.4
enqueue requests                            19,002         13.9          3.4
enqueue timeouts                                 1          0.0          0.0
enqueue waits                                    2          0.0          0.0
Instance Activity Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396

Statistic                                    Total   per Second    per Trans
--------------------------------- ---------------- ------------ ------------
execute count                              119,435         87.2         21.5
free buffer inspected                          732          0.5          0.1
free buffer requested                   11,820,929      8,634.7      2,123.0
hot buffers moved to head of LRU            77,993         57.0         14.0
immediate (CR) block cleanout app            6,892          5.0          1.2
immediate (CURRENT) block cleanou            2,671          2.0          0.5
index fast full scans (full)                    22          0.0          0.0
leaf node splits                               198          0.1          0.0
logons cumulative                              182          0.1          0.0
messages received                            8,120          5.9          1.5
messages sent                                8,120          5.9          1.5
no buffer to keep pinned count                   0          0.0          0.0
no work - consistent read gets          18,575,018     13,568.3      3,336.0
opened cursors cumulative                    7,138          5.2          1.3
parse count (hard)                           1,014          0.7          0.2
parse count (total)                         77,988         57.0         14.0
parse time cpu                               2,138          1.6          0.4
parse time elapsed                           2,340          1.7          0.4
physical reads                          11,833,048      8,643.6      2,125.2
physical reads direct                       22,292         16.3          4.0
physical writes                             43,324         31.7          7.8
physical writes direct                      22,292         16.3          4.0
physical writes non checkpoint              29,501         21.6          5.3
pinned buffers inspected                       133          0.1          0.0
prefetched blocks                        9,271,317      6,772.3      1,665.1
prefetched blocks aged out before                8          0.0          0.0
process last non-idle time         148,137,755,445 ############ ############
recursive calls                             82,946         60.6         14.9
recursive cpu usage                          1,766          1.3          0.3
redo blocks written                         64,702         47.3         11.6
redo buffer allocation retries                   0          0.0          0.0
redo entries                                72,451         52.9         13.0
redo log space requests                          0          0.0          0.0
redo log space wait time                         0          0.0          0.0
redo ordering marks                              0          0.0          0.0
redo size                               30,772,716     22,478.2      5,526.7
redo synch time                             14,065         10.3          2.5
redo synch writes                            5,542          4.1          1.0
redo wastage                             1,477,908      1,079.6        265.4
redo write time                             13,735         10.0          2.5
redo writer latching time                        0          0.0          0.0
redo writes                                  5,572          4.1          1.0
rollback changes - undo records a               30          0.0          0.0
rollbacks only - consistent read               807          0.6          0.1
rows fetched via callback                   71,084         51.9         12.8
session connect time               148,137,670,965 ############ ############
session logical reads                   19,728,671     14,411.0      3,543.2
session pga memory                     629,799,008    460,043.1    113,110.5
session pga memory max                 640,351,104    467,751.0    115,005.6
session uga memory                      18,311,168     13,375.6      3,288.6
session uga memory max                 575,236,080    420,187.1    103,311.1
sorts (disk)                                     2          0.0          0.0
sorts (memory)                              30,386         22.2          5.5
sorts (rows)                               982,841        717.9        176.5
summed dirty queue length                   20,102         14.7          3.6
switch current to new buffer
Instance Activity Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396

Statistic                                    Total   per Second    per Trans
--------------------------------- ---------------- ------------ ------------
table fetch by rowid                     9,339,763      6,822.3      1,677.4
table fetch continued row                   46,163         33.7          8.3
table scan blocks gotten                16,571,040     12,104.5      2,976.1
table scan rows gotten                  19,584,627     14,305.8      3,517.4
table scans (long tables)                      878          0.6          0.2
table scans (short tables)                  26,394         19.3          4.7
total file opens                             1,002          0.7          0.2
transaction rollbacks                            7          0.0          0.0
transaction tables consistent rea                2          0.0          0.0
transaction tables consistent rea              394          0.3          0.1
user calls                                 278,398        203.4         50.0
user commits                                 5,494          4.0          1.0
user rollbacks                                  74          0.1          0.0
write clones created in backgroun                3          0.0          0.0
write clones created in foregroun              933          0.7          0.2
          -------------------------------------------------------------
Tablespace IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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,387,854   1,744    0.1     4.8          200        0      9,172    0.1
CONTRACT_LM
        41,981      31    0.6     1.0          349        0          0    0.0
SPACETELDATA
        24,535      18    0.2     8.4          156        0          0    0.0
CONTR_SERVICES_LM
        10,060       7    2.2     1.0        2,767        2          0    0.0
I_CONTRACT_LM
         9,840       7    1.2     1.0           45        0          0    0.0
ORDHDR_LM
         8,701       6    8.8     1.0          833        1          0    0.0
CASHREC_TBS
         9,211       7    7.1     1.0           38        0          0    0.0
CONTACT_LM
         7,528       5    5.3    10.0          209        0          0    0.0
STORMED_LM
         4,042       3    3.6    12.7           40        0          0    0.0
DIRECTORY
         4,071       3    8.7     1.0            4        0          0    0.0
CASHDET_TBS
         3,741       3    8.9     1.0           43        0          0    0.0
I_CONTR_SERVICES_LM
         2,965       2    7.8     1.0          583        0          0    0.0
MY_TBS
         1,668       1   10.3     1.0        1,864        1          0    0.0
DOCUMENT_LM
             1       0   50.0     1.0        3,327        2          0    0.0
PK_TBS3
         3,028       2    9.4     1.0           67        0          0    0.0
TICKLER_LM
         2,788       2    8.6     1.0           85        0          0    0.0
CONTRS_TBS
         2,428       2    6.5     5.8           22        0          0    0.0
CUSTOMER_LM
         1,208       1    9.1     1.0          551        0          0    0.0
N_I_DATA
           677       0    8.4     1.0        1,037        1          0    0.0
I_CONTACT_LM
           556       0   10.1     1.0          866        1          0    0.0
CASH2_TBS
           436       0   10.5     1.0          897        1          0    0.0
RBS
             1       0    0.0     1.0        1,187        1         12    0.8
I_CONTR_DEVICES_LM
           923       1    9.7     1.0           66        0          0    0.0
CONTR_DEVICES_LM
           893       1   10.2     1.0           40        0          0    0.0
I_TICKLER_LM
           365       0   11.2     1.0          566        0          0    0.0
IX_TBS
           269       0   10.7     1.0          596        0          0    0.0
Tablespace IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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
            59       0    7.8     2.5          712        1          0    0.0
PORT_LM
           666       0    9.6     1.0           38        0          0    0.0
RATE_TBS
           651       0    9.6     1.0           30        0          0    0.0
PK_TBS8
           518       0   10.0     1.0          149        0          0    0.0
VMD_TBS
           609       0    9.3     1.1           48        0          1    0.0
I_ORDHDR_LM
           321       0    9.5     1.0          307        0          0    0.0
MPU_TBS
           445       0   10.0     1.0           90        0          0    0.0
PARAM_TBS
           512       0   10.3     1.0           23        0          0    0.0
PK_TBS4
           423       0   10.0     1.0          110        0          0    0.0
USER_TBS
           244       0    8.1     1.3          280        0          0    0.0
CONTR_HISTORY_LM
           505       0    9.6     1.0            9        0          0    0.0
I_CUSTOMER_LM
           478       0   11.3     1.0           28        0          0    0.0
SYSTEM
           277       0   10.3     3.1          224        0          0    0.0
I_PORT_LM
           434       0   11.5     1.0           23        0          0    0.0
FK_TBS1
           418       0   10.4     1.0           35        0          0    0.0
IN_TBS
           400       0   10.2     1.0           45        0          0    0.0
PK_TBS36
           416       0    9.7     1.0            7        0          0    0.0
FK_TBS2
            78       0    8.7     1.0          333        0          0    0.0
PK_TBS22
           329       0   10.1     1.0           60        0          0    0.0
I_STORMED_LM
           382       0    9.9     1.0            0        0          0    0.0
PK_TBS17
           356       0   11.1     1.0            4        0          0    0.0
PAY_TBS
           344       0   10.3     1.0            4        0          0    0.0
CALLSDETRBS
             0       0    0.0                  324        0          0    0.0
STYTEMPTBS
           152       0   22.2    99.7          152        0          0    0.0
PK_TBS18
           240       0   10.4     1.0           63        0          0    0.0
ORDTRL_LM
             0       0    0.0                  292        0          0    0.0
Tablespace IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
PK_TBS9
            99       0   11.3     1.0          190        0          0    0.0
PK_TBS6
           260       0   10.2     1.0            0        0          0    0.0
INFO_TBS
           113       0    9.6     1.0          142        0          0    0.0
PK_TBS10
           176       0   11.3     1.0           51        0          0    0.0
I_DOCUMENT_LM
             9       0   11.1     1.0          215        0          0    0.0
TEMP
            86       0   40.5    83.0          116        0          0    0.0
FK_TBS3
            92       0   10.7     1.0           96        0          0    0.0
PK_TBS5
            93       0    8.2     1.0           91        0          0    0.0
I_DIRECTORY
            87       0    9.7     1.0            8        0          0    0.0
GMD_TBS
             4       0   10.0     1.0           84        0          0    0.0
I_ORDERTXTTR_LM
             0       0    0.0                   85        0          0    0.0
FK_TBS4
            17       0   10.6     1.0           47        0          0    0.0
PK_TBS26
            27       0   10.0     1.0           35        0          0    0.0
APP_TBS
             0       0    0.0                   51        0          2    0.0
PK_TBS32
             0       0    0.0                   47        0          0    0.0
PK_TBS27
             0       0    0.0                   46        0          0    0.0
I_CASH_LM
             4       0   12.5     1.0           36        0          0    0.0
I_ORDTRL_LM
             0       0    0.0                   39        0          0    0.0
PK_TBS35
            37       0   10.0     3.1            0        0          0    0.0
PK_TBS30
            30       0   10.7     1.0            4        0          0    0.0
PK_TBS33
             0       0    0.0                   31        0          0    0.0
IU_TBS
            23       0    8.7     1.0            4        0          0    0.0
PK_TBS13
            16       0    8.8     1.0            4        0          0    0.0
ORDERTXTTR_LM
             0       0    0.0                   12        0          0    0.0
PK_TBS31
             0       0    0.0                    9        0          0    0.0
GL_TBS
             4       0   10.0     3.3            4        0          0    0.0
Tablespace IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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_TBS10
             3       0    6.7     1.0            4        0          0    0.0
PK_TBS37
             0       0    0.0                    6        0          0    0.0
CONTR_TBS
             0       0    0.0                    5        0          0    0.0
MPS_TBS
             3       0   10.0     1.7            2        0          0    0.0
PK_TBS29
             1       0   20.0     1.0            4        0          0    0.0
BILLCYCLE_TBS
             4       0   10.0     1.0            0        0          0    0.0
CAS
             2       0   20.0     1.0            1        0          0    0.0
CUST_TBS
             2       0   10.0     1.0            1        0          0    0.0
MPD_TBS
             3       0   13.3     1.3            0        0          0    0.0
NLS_TBS
             3       0   16.7     1.3            0        0          0    0.0
RES_TBS
             3       0   10.0     1.0            0        0          0    0.0
SERVICE_TBS
             3       0   10.0     1.0            0        0          0    0.0
ADR_TBS
             2       0   15.0     1.0            0        0          0    0.0
MKT_TBS
             2       0   20.0     1.0            0        0          0    0.0
PK_TBS28
             0       0    0.0                    2        0          0    0.0
NET_TBS
             1       0    0.0     1.0            0        0          0    0.0
          -------------------------------------------------------------
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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
             2       0   15.0     1.0            0        0          0

APP_TBS                  /STY_PROD/data/APP_TBS.dbf
             0       0                          51        0          2    0.0

BCH_TBS                  /STY_PROD/data/BCH_TBS.dbf
            59       0    7.8     2.5          712        1          0

BILLCYCLE_TBS            /STY_PROD/data/BILLCYCLE_TBS.dbf
             4       0   10.0     1.0            0        0          0

CALLSDETRBS              /STY_PROD/rbs/callsdetrbs.dbf
             0       0                         324        0          0

CAS                      /STY_PROD/data/CAS.dbf
             2       0   20.0     1.0            1        0          0

CASH2_TBS                /STY_PROD/data/CASH2_TBS.dbf
           436       0   10.5     1.0          897        1          0

CASHDET_TBS              /STY_PROD/data/CASHDET_TBS.dbf
         3,741       3    8.9     1.0           43        0          0

CASHREC_TBS              /STY_PROD/data/CASHREC_TBS.dbf
         9,211       7    7.1     1.0           38        0          0

CONTACT_LM               /STY_PROD/data/CONTACT_LM.dbf
         7,528       5    5.3    10.0          209        0          0

CONTRACT_LM              /STY_PROD/data/CONTRACT.dbf
        41,981      31    0.6     1.0          349        0          0

CONTRS_TBS               /STY_PROD/data/CONTRS_TBS.dbf
         2,428       2    6.5     5.8           22        0          0

CONTR_DEVICES_LM         /STY_PROD/data/CONTR_DEVICES_LM.dbf
           893       1   10.2     1.0           40        0          0

CONTR_HISTORY_LM         /STY_PROD/data/CONTR_HISTORY_LM.dbf
           505       0    9.6     1.0            9        0          0

CONTR_SERVICES_LM        /STY_PROD/data/CONTR_SERVICES_LM.dbf
        10,060       7    2.2     1.0        2,767        2          0

CONTR_TBS                /STY_PROD/data/CONTR_TBS.dbf
             0       0                           5        0          0

CUSTOMER_LM              /STY_PROD/data/CUSTOMER_LM.dbf
         1,208       1    9.1     1.0          551        0          0

CUST_TBS                 /STY_PROD/data/CUST_TBS.dbf
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
             2       0   10.0     1.0            1        0          0

DIRECTORY                /STY_PROD/data/DIRECTORY.dbf
         4,071       3    8.7     1.0            4        0          0

DOCUMENT_LM              /STY_PROD/data/DOCUMENT_LM.dbf
             1       0   50.0     1.0        3,327        2          0

FK_TBS1                  /STY_PROD/index/FK_TBS1.dbf
           418       0   10.4     1.0           35        0          0

FK_TBS10                 /STY_PROD/index/FK_TBS10.dbf
             3       0    6.7     1.0            4        0          0

FK_TBS2                  /STY_PROD/index/FK_TBS2.dbf
            78       0    8.7     1.0          333        0          0

FK_TBS3                  /STY_PROD/index/FK_TBS3.dbf
            92       0   10.7     1.0           96        0          0

FK_TBS4                  /STY_PROD/index/FK_TBS4.dbf
            17       0   10.6     1.0           47        0          0

GL_TBS                   /STY_PROD/data/GL_TBS.dbf
             4       0   10.0     3.3            4        0          0

GMD_TBS                  /STY_PROD/data/GMD_TBS.dbf
             4       0   10.0     1.0           84        0          0

INFO_TBS                 /STY_PROD/data/INFO_TBS.dbf
           113       0    9.6     1.0          142        0          0

IN_TBS                   /STY_PROD/index/IN_TBS.dbf
           400       0   10.2     1.0           45        0          0

IU_TBS                   /STY_PROD/index/IU_TBS.dbf
            23       0    8.7     1.0            4        0          0

IX_TBS                   /STY_PROD/index/IX_TBS.dbf
           269       0   10.7     1.0          596        0          0

I_CASH_LM                /STY_PROD/index/I_CASH_LM.dbf
             4       0   12.5     1.0           36        0          0

I_CONTACT_LM             /STY_PROD/index/I_CONTACT_LM.dbf
           556       0   10.1     1.0          866        1          0

I_CONTRACT_LM            /STY_PROD/index/I_CONTRACT_LM.dbf
         9,840       7    1.2     1.0           45        0          0

I_CONTR_DEVICES_LM       /STY_PROD/index/I_CONTR_DEVICES_LM.dbf
           923       1    9.7     1.0           66        0          0
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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_CONTR_SERVICES_LM      /STY_PROD/index/I_CONTR_SERVICES_LM.dbf
         2,965       2    7.8     1.0          583        0          0

I_CUSTOMER_LM            /STY_PROD/index/I_CUSTOMER_LM.dbf
           478       0   11.3     1.0           28        0          0

I_DIRECTORY              /STY_PROD/index/I_DIRECTORY.dbf
            87       0    9.7     1.0            8        0          0

I_DOCUMENT_LM            /STY_PROD/index/I_DOCUMENT_LM.dbf
             9       0   11.1     1.0          215        0          0

I_ORDERTXTTR_LM          /STY_PROD/index/I_ORDERTXTTR_LM.dbf
             0       0                          85        0          0

I_ORDHDR_LM              /STY_PROD/index/I_ORDHDR_LM.dbf
           321       0    9.5     1.0          307        0          0

I_ORDTRL_LM              /STY_PROD/index/I_ORDTRL_LM.dbf
             0       0                          39        0          0

I_PORT_LM                /STY_PROD/index/I_PORT_LM.dbf
           434       0   11.5     1.0           23        0          0

I_STORMED_LM             /STY_PROD/index/I_STORMED_LM.dbf
           382       0    9.9     1.0            0        0          0

I_TICKLER_LM             /STY_PROD/index/I_TICKLER_LM.dbf
           365       0   11.2     1.0          566        0          0

MKT_TBS                  /STY_PROD/data/MKT_TBS.dbf
             2       0   20.0     1.0            0        0          0

MPD_TBS                  /STY_PROD/data/MPD_TBS.dbf
             3       0   13.3     1.3            0        0          0

MPS_TBS                  /STY_PROD/data/MPS_TBS.dbf
             3       0   10.0     1.7            2        0          0

MPU_TBS                  /STY_PROD/data/MPU_TBS.dbf
           445       0   10.0     1.0           90        0          0

MY_TBS                   /STY_PROD/data/MY_TBS.dbf
         1,017       1   10.3     1.0        1,409        1          0
                         /STY_PROD/data/MY_TBS2.dbf
           651       0   10.3     1.0          455        0          0

NET_TBS                  /STY_PROD/data/NET_TBS.dbf
             1       0    0.0     1.0            0        0          0

NLS_TBS                  /STY_PROD/data/NLS_TBS.dbf
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
             3       0   16.7     1.3            0        0          0

N_DATA                   /STY_PROD/data/N_DATA.dbf
     2,387,854   1,744    0.1     4.8          200        0      9,172    0.1

N_I_DATA                 /STY_PROD/index/N_I_DATA.dbf
           677       0    8.4     1.0        1,037        1          0

ORDERTXTTR_LM            /STY_PROD/data/ORDERTXTTR_LM.dbf
             0       0                          12        0          0

ORDHDR_LM                /STY_PROD/data/ORDHDR_LM.dbf
         8,701       6    8.8     1.0          833        1          0

ORDTRL_LM                /STY_PROD/data/ORDTRL_LM.dbf
             0       0                         292        0          0

PARAM_TBS                /STY_PROD/data/PARAM_TBS.dbf
           512       0   10.3     1.0           23        0          0

PAY_TBS                  /STY_PROD/data/PAY_TBS.dbf
           344       0   10.3     1.0            4        0          0

PK_TBS10                 /STY_PROD/index/PK_TBS10.dbf
           176       0   11.3     1.0           51        0          0

PK_TBS13                 /STY_PROD/index/PK_TBS13.dbf
            16       0    8.8     1.0            4        0          0

PK_TBS17                 /STY_PROD/index/PK_TBS17.dbf
           356       0   11.1     1.0            4        0          0

PK_TBS18                 /STY_PROD/index/PK_TBS18.dbf
           240       0   10.4     1.0           63        0          0

PK_TBS22                 /STY_PROD/index/PK_TBS22.dbf
           329       0   10.1     1.0           60        0          0

PK_TBS26                 /STY_PROD/index/PK_TBS26.dbf
            27       0   10.0     1.0           35        0          0

PK_TBS27                 /STY_PROD/index/PK_TBS27.dbf
             0       0                          46        0          0

PK_TBS28                 /STY_PROD/index/PK_TBS28.dbf
             0       0                           2        0          0

PK_TBS29                 /STY_PROD/index/PK_TBS29.dbf
             1       0   20.0     1.0            4        0          0

PK_TBS3                  /STY_PROD/index/PK_TBS3.dbf
         3,028       2    9.4     1.0           67        0          0
File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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_TBS30                 /STY_PROD/index/PK_TBS30.dbf
            30       0   10.7     1.0            4        0          0

PK_TBS31                 /STY_PROD/index/PK_TBS31.dbf
             0       0                           9        0          0

PK_TBS32                 /STY_PROD/index/PK_TBS32.dbf
             0       0                          47        0          0

PK_TBS33                 /STY_PROD/index/PK_TBS33.dbf
             0       0                          31        0          0

PK_TBS35                 /STY_PROD/index/PK_TBS35.dbf
            37       0   10.0     3.1            0        0          0

PK_TBS36                 /STY_PROD/index/PK_TBS36.dbf
           416       0    9.7     1.0            7        0          0

PK_TBS37                 /STY_PROD/index/PK_TBS37.dbf
             0       0                           6        0          0

PK_TBS4                  /STY_PROD/index/PK_TBS4.dbf
           423       0   10.0     1.0          110        0          0

PK_TBS5                  /STY_PROD/index/PK_TBS5.dbf
            93       0    8.2     1.0           91        0          0

PK_TBS6                  /STY_PROD/index/PK_TBS6.dbf
           260       0   10.2     1.0            0        0          0

PK_TBS8                  /STY_PROD/index/PK_TBS8.dbf
           518       0   10.0     1.0          149        0          0

PK_TBS9                  /STY_PROD/index/PK_TBS9.dbf
            99       0   11.3     1.0          190        0          0

PORT_LM                  /STY_PROD/data/PORT_LM.dbf
           666       0    9.6     1.0           38        0          0

RATE_TBS                 /STY_PROD/data/RATE_TBS.dbf
           651       0    9.6     1.0           30        0          0

RBS                      /STY_PROD/rbs/RBS_1.dbf
             1       0    0.0     1.0        1,187        1         12    0.8

RES_TBS                  /STY_PROD/data/RES_TBS.dbf
             3       0   10.0     1.0            0        0          0

SERVICE_TBS              /STY_PROD/data/SERVICE_TBS.dbf
             3       0   10.0     1.0            0        0          0

File IO Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
SPACETELDATA             /STY_PROD/data/SPACETELDATA_1.dbf
        24,535      18    0.2     8.4          156        0          0

STORMED_LM               /STY_PROD/data/STORMED.dbf
         4,042       3    3.6    12.7           40        0          0

STYTEMPTBS               /STY_PROD/tmp/STYTEMPTBS.TDF
           152       0   22.2    99.7          152        0          0

SYSTEM                   /STY_PROD/sys/system_1.dbf
           252       0   10.3     3.0          138        0          0
                         /STY_PROD/sys/system_2.dbf
            25       0   10.8     4.4           86        0          0

TEMP                     /STY_PROD/tmp/TEMP_1.dbf
            86       0   40.5    83.0          116        0          0

TICKLER_LM               /STY_PROD/data/TICKLER.dbf
         2,788       2    8.6     1.0           85        0          0

USER_TBS                 /STY_PROD/data/USER_TBS.dbf
           244       0    8.1     1.3          280        0          0

VMD_TBS                  /STY_PROD/data/VMD_TBS.dbf
           609       0    9.3     1.1           48        0          1    0.0

          -------------------------------------------------------------
Buffer Pool Statistics for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
-> 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  11,829,016    18,773,602  11,818,438     21,032       0        0      9,187
          -------------------------------------------------------------





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

                                 Tot Wait    Avg
Class                    Waits  Time (cs) Time (cs)
------------------ ----------- ---------- ---------
data block               9,175         59         0
undo header                 11          1         0
undo block                   1          0         0
          -------------------------------------------------------------





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

Enqueue            Gets      Waits
---------- ------------ ----------
TX                5,815          2
          -------------------------------------------------------------
Rollback Segment Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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      4,973.0    0.00               0        0        0        0
     2        333.0    0.00               0        0        0        0
     3      1,494.0    0.00               0        0        0        0
     4      3,810.0    0.00       1,542,734        4        0        0
     5     12,303.0    0.02         511,102        2        0        0
     6     23,984.0    0.03       1,242,830        3        0        0
     7        457.0    0.00           1,250        0        0        0
     8      5,789.0    0.00               0        0        0        0
     9      1,830.0    0.11       2,055,648        5        0        0
    10      9,845.0    0.00         702,874        1        0        0
    11        713.0    0.00               0        0        0        0
    47      3,568.0    0.00       1,613,772        0        0        0
          -------------------------------------------------------------
Rollback Segment Storage for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->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,404,521                     200,220,672
     2       6,258,688       1,344,458       6,144,000       6,258,688
     3       6,258,688       1,530,426       6,144,000      16,498,688
     4       6,504,448         933,524       6,144,000       6,504,448
     5       6,504,448       1,270,849       6,144,000      15,024,128
     6     675,700,736         561,242                     675,700,736
     7     911,179,776         660,051                     911,179,776
     8     315,744,256       1,909,949                     315,744,256
     9     158,670,848       1,408,273                     158,670,848
    10     947,290,112       6,768,114                     947,290,112
    11     648,536,064      18,554,204                     648,536,064
    47      10,477,568       1,801,543      10,485,760      10,477,568
          -------------------------------------------------------------
Latch Activity for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->"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                            992    0.0                 439    0.0
active checkpoint queue latch          2,843    0.0                   0
cache buffer handles                  11,730    0.0                   0
cache buffers chains              51,293,149    0.0    0.0   23,267,048    0.0
cache buffers lru chain           17,083,708    0.1    0.0   11,819,342    0.1
channel handle pool latch                359    0.0                   0
channel operations parent lat            533    0.0                   0
checkpoint queue latch               141,786    0.0    0.5            0
dictionary lookup                          2    0.0                   0
dml lock allocation                   19,074    0.0    0.0            0
enqueue hash chains                   43,041    0.0    0.0            0
enqueues                              47,742    0.0    0.0            0
event group latch                        174    0.0                   0
file number translation table              2    0.0                   0
global transaction                    14,003    0.0                   0
global tx free list                      849    0.0                   0
global tx hash mapping                 3,504    0.0                   0
job_queue_processes parameter             25    0.0                   0
ktm global data                            4    0.0                   0
latch wait list                          160    0.6    0.0          159    0.0
library cache                      2,439,576    0.1    0.1        8,699    0.1
library cache load lock                  162    0.0                   0
list of block allocation              12,224    0.0                   0
loader state object freelist              13    0.0                   0
longop free list                       3,990    0.0    0.0            0
messages                             130,734    0.1    0.0            0
multiblock read objects            4,811,084    0.1    0.0            0
ncodef allocation latch                   25    0.0                   0
process allocation                       174    0.0                 174    0.0
process group creation                   359    0.0                   0
redo allocation                       83,649    0.0    0.0            0
redo writing                          31,703    1.2    0.0            0
row cache objects                    879,027    0.0    0.0            0
sequence cache                           555    0.0                   0
session allocation                    21,789    0.0    0.1            0
session idle bit                     567,548    0.0    0.1           37    0.0
session switching                         85    0.0                   0
shared pool                          126,629    0.0    0.8            0
sort extent pool                          79    0.0                   0
transaction allocation                19,070    0.0    0.0            0
transaction branch allocation          6,428    0.0                   0
undo global data                      90,838    0.0    0.0            0
user lock                                710    0.0                   0
          -------------------------------------------------------------
Latch Sleep breakdown for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
-> ordered by misses desc

                                Get                                  Spin &
Latch Name                    Requests         Misses      Sleeps Sleeps 1->4
-------------------------- -------------- ----------- ----------- ------------
cache buffers lru chain        17,083,708      24,955         147 24808/147/0/
                                                                  0/0
multiblock read objects         4,811,084       4,295          33 4262/33/0/0/
                                                                  0
cache buffers chains           51,293,149       2,312          28 2284/28/0/0/
                                                                  0
library cache                   2,439,576       2,125         190 1987/89/46/3
                                                                  /0
row cache objects                 879,027         345           1 344/1/0/0/0
shared pool                       126,629          53          40 33/0/20/0/0
session idle bit                  567,548          12           1 11/1/0/0/0
session allocation                 21,789           9           1 8/1/0/0/0
checkpoint queue latch            141,786           4           2 2/2/0/0/0
          -------------------------------------------------------------
Latch Miss Sources for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
-> 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         18       3
cache buffers chains     kcbgtcr: kslbegin                0          5      18
cache buffers chains     kcbzib: multi-block read:        0          4       0
cache buffers chains     kcbzib: finish free bufs         0          1       3
cache buffers lru chain  kcbzgb: multiple sets nowa       0         82       0
cache buffers lru chain  kcbbiop: lru scan                0         32       0
cache buffers lru chain  kcbzar: KSLNBEGIN                0         29     130
cache buffers lru chain  kcbzgm                           0          3      17
cache buffers lru chain  kcbgtcr:CR Scan:KCBRSKIP         0          1       6
checkpoint queue latch   kcbk0rrd: update recovery        0          2       0
library cache            kglic                            0         67       9
library cache            kglhdgn: child:                  0         35      20
library cache            kglpnal: child: before pro       0          9      17
library cache            kglidp: parent                   0          5       0
library cache            kglpnal: child: alloc spac       0          3      25
library cache            kgllkdl: child: cleanup          0          2       1
library cache            kglhdgc: child:                  0          1       7
library cache            kglupc: child                    0          1      36
multiblock read objects  kcbzib: MBRGET                   0         17      16
multiblock read objects  kcbzib: MBRFRE                   0         16      17
row cache objects        kqrpsc: incr stat                0          1       0
session allocation       ksuxds: KSUSFCLC not set         0          1       0
session idle bit         kqp327i                          0          1       0
shared pool              kghfrunp: clatch: nowait         0         63       0
shared pool              kghfrunp: alloc: clatch no       0         40       0
shared pool              kghfrunp: clatch: wait           0          4       2
          -------------------------------------------------------------
Dictionary Cache Stats for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396
->"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     21   70
dc_database_links               104    2.9        0              0     88   99
dc_files                          0               0              0      0    0
dc_free_extents               1,642    1.1       15   0.0       37  3,372  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            34,807    0.0        0              0  3,255  100
dc_object_ids               184,285    0.0        0              0  1,277   99
dc_objects                   17,104    1.8        0              2 ######  100
dc_outlines                       0               0              0      0    0
dc_profiles                     297    0.0        0              0      7   54
dc_rollback_segments            384    0.0        0              0     49   94
dc_segments                  31,608    0.0        0             23  1,183  100
dc_sequence_grants                0               0              0      0    0
dc_sequences                      9    0.0        0              9      4   80
dc_synonyms                   5,401    0.1        0              0    474   99
dc_tablespace_quotas             32    0.0        0             11     23   66
dc_tablespaces                  105    0.0        0              0     56   97
dc_used_extents                  27   55.6        0             27    130   96
dc_user_grants                  892    0.2        0              0    252   98
dc_usernames                  5,639    0.1        0              0    247   97
dc_users                      9,361    0.0        0              0    254   99
ifs_acl_cache_entries             0               0              0      0    0
          -------------------------------------------------------------


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

                    Get       Pct        Pin        Pct               Invali-
Namespace         Requests    Miss     Requests     Miss     Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY                     455    0.0            455    0.0          0        0
CLUSTER                    2    0.0              2    0.0          0        0
INDEX                      2    0.0              2    0.0          0        0
OBJECT                     0                     0                 0        0
PIPE                       0                     0                 0        0
SQL AREA              77,071    1.3        555,374    0.4         33        3
TABLE/PROCEDURE       30,594    1.0         56,405    0.1          9        0
TRIGGER                  926    0.0            926    0.0          0        0
          -------------------------------------------------------------
SGA Memory Summary for DB: STY_PROD  Instance: STY_PROD  Snaps: 1395 -1396

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: 1395 -1396

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                    11,633,280     10,275,920  -1,357,360
shared pool PL/SQL DIANA                  1,892,928      1,877,048     -15,880
shared pool PL/SQL MPCODE                 1,342,800      1,349,784       6,984
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             29,965,128     30,213,456     248,328
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,921,944     44,832,808     -89,136
shared pool ktlbk state objects             307,664        307,664           0
shared pool library cache               163,164,024    163,838,312     674,288
shared pool miscellaneous                 4,504,024      4,427,736     -76,288
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                    582,147,080    582,770,272     623,192
shared pool table columns                    69,512         59,080     -10,432
shared pool table definiti                   17,704         16,880        -824
shared pool transaction_branches            230,400        230,400           0
shared pool transactions                    872,480        872,480           0
shared pool trigger defini                    7,672          6,560      -1,112
shared pool trigger inform                   30,888         29,128      -1,760
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: 1395 -1396

                                                                  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

