STATSPACK report for DB Name DB Id Instance Inst Num Release OPS Host ------------ ----------- ------------ -------- ----------- --- ------------ ARS 3121022242 ARS 1 8.1.7.4.0 NO ttmdbars Snap Id Snap Time Sessions ------- ------------------ -------- Begin Snap: 2156 14-Apr-03 16:05:27 168 End Snap: 2157 14-Apr-03 16:11:47 168 Elapsed: 6.33 (mins) Cache Sizes ~~~~~~~~~~~ db_block_buffers: 600000 log_buffer: 1048576 db_block_size: 4096 shared_pool_size: 3000000000 Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 58,010.02 5,538.65 Logical reads: 18,624.92 1,778.26 Block changes: 367.76 35.11 Physical reads: 203.76 19.45 Physical writes: 211.44 20.19 User calls: 1,178.79 112.55 Parses: 294.35 28.10 Hard parses: 27.55 2.63 Sorts: 81.41 7.77 Logons: 0.08 0.01 Executes: 189.25 18.07 Transactions: 10.47 % Blocks changed per Read: 1.97 Recursive Call %: 14.98 Rollback per transaction %: 0.00 Rows per Sort: 37.80 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 98.91 In-memory Sort %: 99.99 Library Hit %: 90.48 Soft Parse %: 90.64 Execute to Parse %: -55.53 Latch Hit %: 99.93 Parse CPU to Parse Elapsd %: 70.94 % Non-Parse CPU: 93.06 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 95.48 95.53 % SQL with executions>1: 7.93 7.97 % Memory for SQL w/exec>1: 4.47 4.49 Top 5 Wait Events ~~~~~~~~~~~~~~~~~ Wait % Total Event Waits Time (cs) Wt Time -------------------------------------------- ------------ ------------ ------- SQL*Net message from dblink 129,058 6,734 66.59 log file sync 25,352 1,388 13.72 log file parallel write 25,300 1,174 11.61 SQL*Net more data to client 131,295 427 4.22 latch free 2,240 201 1.99 ------------------------------------------------------------- Wait Events for DB: ARS Instance: ARS Snaps: 2156 -2157 -> 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 ---------------------------- ------------ ---------- ----------- ------ ------ SQL*Net message from dblink 129,058 0 6,734 1 32.4 log file sync 25,352 0 1,388 1 6.4 log file parallel write 25,300 0 1,174 0 6.4 SQL*Net more data to client 131,295 0 427 0 33.0 latch free 2,240 1,459 201 1 0.6 db file sequential read 88 0 143 16 0.0 SQL*Net message to dblink 129,062 0 39 0 32.4 control file sequential read 95 0 2 0 0.0 enqueue 1 0 2 20 0.0 direct path read 4,148 0 1 0 1.0 SQL*Net break/reset to clien 30 0 1 0 0.0 log file switch completion 1 0 1 10 0.0 db file parallel write 362 0 0 0 0.1 control file parallel write 130 0 0 0 0.0 refresh controlfile command 12 0 0 0 0.0 LGWR wait for redo copy 8 0 0 0 0.0 direct path write 4 0 0 0 0.0 direct path write (lob) 2 0 0 0 0.0 file identify 2 0 0 0 0.0 file open 2 0 0 0 0.0 log file single write 2 0 0 0 0.0 buffer busy waits 1 0 0 0 0.0 log file sequential read 1 0 0 0 0.0 SQL*Net message from client 422,534 0 3,105,045 73 106.2 pipe get 74 74 37,962 5130 0.0 SQL*Net message to client 422,538 0 119 0 106.2 SQL*Net more data from clien 762 0 3 0 0.2 ------------------------------------------------------------- Background Wait Events for DB: ARS Instance: ARS Snaps: 2156 -2157 -> ordered by wait time desc, waits desc (idle events last) Avg Total Wait wait Waits Event Waits Timeouts Time (cs) (ms) /txn ---------------------------- ------------ ---------- ----------- ------ ------ log file parallel write 25,295 0 1,174 0 6.4 latch free 1 1 2 20 0.0 control file sequential read 35 0 1 0 0.0 db file parallel write 362 0 0 0 0.1 control file parallel write 130 0 0 0 0.0 LGWR wait for redo copy 8 0 0 0 0.0 file identify 2 0 0 0 0.0 file open 2 0 0 0 0.0 log file single write 2 0 0 0 0.0 log file sequential read 1 0 0 0 0.0 rdbms ipc message 25,781 709 226,467 88 6.5 pmon timer 123 123 37,884 3080 0.0 smon timer 1 1 30,721 ###### 0.0 ------------------------------------------------------------- SQL ordered by Gets for DB: ARS Instance: ARS Snaps: 2156 -2157 -> 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 --------------- ------------ -------------- ------- ------------ 1,271,660 1 1,271,660.0 18.0 3376831664 BEGIN statspack.snap; END; 1,267,208 1 1,267,208.0 17.9 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 634,880 5,120 124.0 9.0 2590974356 SELECT /*+ */ "A1"."IDENTIFICATORENTT","A1"."CENTRALE","A1"."IDA RMADIO","A1"."DECADE","A1"."CENTRALE_RC","A1"."COD_LOCALITA_A"," A1"."COD_LOCALITA_B","A1"."COD_PROPRIETA","A1"."COD_TECNICA_TRAS M","A1"."NUM_PROGRESSIVO","A1"."IMPIANTO","A1"."PROGR_IMPIANTO", "A1"."MODULO","A1"."PIASTRA","A1"."STATO" FROM "TTM_WEB_NTT_NMT" 255,042 9,742 26.2 3.6 158775678 SELECT /*+ */ "A2"."NOMEGRUPPO" FROM "TTM_ASSOCIAZIONE_OPER_GRUP PI" "A2","TTM_GRUPPI" "A1" WHERE "A2"."LOGINNAME"=:1 AND "A1"."W EB"='3' AND "A2"."NOMEGRUPPO"="A1"."NOMEGRUPPO" 46,440 514 90.4 0.7 2431286835 select distinct priorita into :b0 from ttm_priorita_ctt where ( ((((((((decode(cod_sla,null ,0,:b1)+decode(tipo_servizio,null ,0 ,:b2))+decode(segm_cliente,null ,0,:b3))+decode(velocita,null ,0 ,:b4))+decode(utr,null ,0,:b5))=(select max(((((decode(cod_sla,n ull ,0,:b1)+decode(tipo_servizio,null ,0,:b2))+decode(segm_clien 32,357 527 61.4 0.5 4147644963 update TTM_RICHIESTE_GMP set FLAG_UPDATE=:b0 where (ID_PROVA=:b 1 and STATO=:b2) 29,094 2,238 13.0 0.4 2167152996 SELECT /*+ */ DISTINCT "A2"."CODICETIPODIAGNOSI","A2"."DESCRIZIO NETIPODIAGNOSI" FROM "TTM_TIPO_DIAGNOSI_NORM" "A2","TTM_FAMIGLIA _DIAGNOSI_SOTTOFAM" "A1" WHERE "A2"."CODICETIPODIAGNOSI"="A1"."C OD_DIAGNOSI" AND "A1"."COD_FAM_APPARATO"=:1 AND "A2"."SOTTOTIPOA TTIVITA"='16' ORDER BY "A2"."CODICETIPODIAGNOSI" 24,616 3,077 8.0 0.3 2024169103 SELECT /*+ */ DISTINCT "A1"."DESCRIZIONETIPODIAGNOSI" FROM "TTM_ TIPO_DIAGNOSI_NORM" "A1" WHERE "A1"."CODICETIPODIAGNOSI"=:1 24,616 3,077 8.0 0.3 2244068559 SELECT /*+ */ DISTINCT "A1"."DESC_EVENTO" FROM "YS_EVENTO" "A1" WHERE "A1"."COD_EVENTO"=:1 22,576 2,822 8.0 0.3 2969510057 SELECT /*+ */ DISTINCT "A1"."COD_EVENTO","A1"."DESC_EVENTO" FROM "YS_EVENTO" "A1" WHERE "A1"."COD_EVENTO" LIKE '1%' ORDER BY "A1 SQL ordered by Gets for DB: ARS Instance: ARS Snaps: 2156 -2157 -> 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 --------------- ------------ -------------- ------- ------------ "."COD_EVENTO" 18,350 2 9,175.0 0.3 1562600461 update TTM_RICHIESTE_GMP set STATO='TIME OUT',FLAG_UPDATE='S' w here (TO_DATE(DATA_RICHIESTA_TTM,'DD/MM/YYYY hh24:mi:ss')<=rever se_date(:b0) and (STATO='NUOVA' or STATO='IN ELABORAZIONE')) 14,025 1,753 8.0 0.2 2367161261 UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = 5284 12,780 426 30.0 0.2 619801615 SELECT /*+ */ DISTINCT "A2"."CODICETIPODIAGNOSI","A2"."DESCRIZIO NETIPODIAGNOSI" FROM "TTM_TIPO_DIAGNOSI_NORM" "A2","TTM_FAMIGLIA _DIAGNOSI_SOTTOFAM" "A1" WHERE "A2"."CODICETIPODIAGNOSI"="A1"."C OD_DIAGNOSI" AND "A1"."COD_FAM_APPARATO"=:1 AND "A2"."SOTTOTIPOA TTIVITA"='16' AND ("A2"."VALIDO_PER"='B' OR "A2"."VALIDO_PER" IS 10,265 24 427.7 0.1 758507433 select b.name name , e.gets - b.gets gets , to_number(decode(e.gets, b.gets, null, (e.misses - b.m isses) * 100/(e.gets - b.gets))) missed , to_number(decod e(e.misses, b.misses, null, (e.sleeps - b.sleeps)/(e.miss 10,215 24 425.6 0.1 2000513981 select b.name name , e .gets - b.gets gets , e.misses - b.misses misses , e.sleeps - b.sleeps sleeps , to_char(e.spin_gets - b.spin_gets) ||'/'||to_char(e.sleep1 - b.s 9,588 4,316 2.2 0.1 1966425544 select text from view$ where rowid=:1 9,018 167 54.0 0.1 2297588231 select distinct priorita into :b0 from ttm_priorita_ctt where ( (((((((decode(cod_sla,null ,0,:b1)+decode(segm_cliente,null ,0,: b2))+decode(velocita,null ,0,:b3))+decode(utr,null ,0,:b4))=(sel ect max((((decode(cod_sla,null ,0,:b1)+decode(segm_cliente,null ,0,:b2))+decode(velocita,null ,0,:b3))+decode(utr,null ,0,:b4))) 8,736 1,248 7.0 0.1 471818481 SELECT /*+ */ DISTINCT "A1"."PRIORITA","A1"."COD_FAM_APP" FROM " TTM_CIC_FAM_APP" "A1" WHERE "A1"."CODE_CIC"=:1 8,544 1 8,544.0 0.1 117935777 SELECT T6452.C1,T6452.C1 FROM T6452 WHERE (T6452.C5368709 15 = '051201001') ORDER BY 1 ASC 8,544 1 8,544.0 0.1 597503311 SELECT T6452.C1,T6452.C1 FROM T6452 WHERE (T6452.C5368709 SQL ordered by Gets for DB: ARS Instance: ARS Snaps: 2156 -2157 -> 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 --------------- ------------ -------------- ------- ------------ 13 = 'MONITOR_CHIU') ORDER BY 1 ASC ------------------------------------------------------------- SQL ordered by Reads for DB: ARS Instance: ARS Snaps: 2156 -2157 -> End Disk Reads Threshold: 1000 Physical Reads Executions Reads per Exec % Total Hash Value --------------- ------------ -------------- ------- ------------ 77,149 1 77,149.0 99.6 3376831664 BEGIN statspack.snap; END; 38,575 1 38,575.0 49.8 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 38,553 1 38,553.0 49.8 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 1 1 1.0 0.0 4028505723 select aa, hv from ( select /*+ ordered */ decode( s t.piece , 0 , lpad(to_char((e.bu ffer_gets - nvl(b.buffer_gets,0)) ,'99,999,999,999') ,15)||' '|| lpad(to_char((e.executions - nvl(b.executions,0)) 0 35 0.0 0.0 6906306 SELECT DISTINCT cod_cem,cod_sgu from ttm_impianto WHERE (cod_cen trale = '01104106' AND cod_impianto = '0125' AND cod_prog_imp = '1') OR (cod_centrale = '' AND cod_impianto = '' AND cod_prog_im p = '' ) 0 26 0.0 0.0 13138409 SELECT C60104,C60103,C536870913,C60101,C60104,C60101,C60103,C601 03,C60103,C60102,C60102,C60104,C60102,C60102,C60104 FROM T3259 W HERE C1 = '000000000000920' 0 7 0.0 0.0 29403187 SELECT DISTINCT cod_csot FROM ttm_cc_impianto WHERE cod_centrale = '01103802' AND cod_impianto = '0125' AND cod_prog_imp = '1' AND cod_tipo = 'CSC' 0 57 0.0 0.0 36025203 SELECT DISTINCT desc_fam_app FROM TTM_FAMIGLIA_APPAR_FONIA WHER E cod_fam_app = 'IB' 0 1 0.0 0.0 42331702 select /* +rule */ name, df.file#, phyrds, phywrts, phyblkrd, ph yblkwrt,readtim,writetim from v$dbfile df, v$filestat fs where d f.file# = fs.file# order by file# 0 48 0.0 0.0 45459046 SELECT DISTINCT cod_centr_sg,cod_imp_sg,cod_progr_imp_sg FROM sc timpianto_centr where cod_centrale = '01105002' AND cod_impianto = '0125' AND cod_progr_imp = '2' 0 1 0.0 0.0 48315761 SQL ordered by Reads for DB: ARS Instance: ARS Snaps: 2156 -2157 -> End Disk Reads Threshold: 1000 Physical Reads Executions Reads per Exec % Total Hash Value --------------- ------------ -------------- ------- ------------ SELECT nextId FROM arschema WHERE schemaId = 3221 0 7 0.0 0.0 50327585 SELECT SUM(DECODE(TYPE,'BACKGROUND',1,0)) SYSTEM_SESSIONS,SUM(DE CODE(TYPE,'BACKGROUND',0,DECODE(STATUS,'ACTIVE',1,0))) ACTIVE_US ERS,SUM(DECODE(TYPE,'BACKGROUND',0,DECODE(STATUS,'ACTIVE',0,1))) INACTIVE_USERS FROM V$SESSION 0 1 0.0 0.0 77466655 SELECT ROUND(SUM(BYTES) / (1024 * 1024 ) ,2) FROM V$SGASTAT W HERE (V$SGASTAT.POOL = 'shared pool' ) AND (V$SGASTAT.NAME = 'sq l area' ) 0 52 0.0 0.0 89060835 SELECT DISTINCT cod_tipo_modulo FROM SCTMODULO_IMP_PV WHERE cod _centrale = '01103604' AND cod_impianto = '0125' AND cod_progr_i mp = '1' AND cod_progr_modulo = '' 0 682 0.0 0.0 93812472 SELECT /*+ */ DISTINCT "A1"."CODICETIPODIAGNOSI","A1"."DESCRIZIO NETIPODIAGNOSI" FROM "TTM_TIPO_DIAGNOSI_NORM" "A1" WHERE "A1"."S OTTOTIPOATTIVITA"='16' ORDER BY "A1"."CODICETIPODIAGNOSI" 0 60 0.0 0.0 95999450 SELECT DISTINCT TIPO_MODULO_NEW FROM TTM_DEC_MODULI WHERE TIPO_M ODULO_OLD = 'M2' AND flag_sgu = '1' 0 31 0.0 0.0 105964430 Select DISTINCT codice_RR from ttm_associazione_gat_rr where cod ice_rr is not null and codice_rc = '011037' 0 5 0.0 0.0 114078687 select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where rob j#=:1 0 1 0.0 0.0 117935777 SELECT T6452.C1,T6452.C1 FROM T6452 WHERE (T6452.C5368709 15 = '051201001') ORDER BY 1 ASC 0 51 0.0 0.0 135552022 SELECT nextId FROM arschema WHERE schemaId = 6297 0 59 0.0 0.0 137839935 SELECT DISTINCT cod_csot FROM ttm_cc_impianto WHERE cod_centrale = '01105402' AND cod_impianto = '0125' AND cod_prog_imp = '1' AND cod_tipo = 'CSC' 0 6 0.0 0.0 139071034 SELECT SUM(DECODE(EVENT,'control file sequential read',TOTAL_WAI TS,'control file single write',TOTAL_WAITS,'control file paralle l write',TOTAL_WAITS,0)) CONTROLFILEIO,SUM(DECODE(EVENT,'db file sequential read',TOTAL_WAITS,0)) SINGLEBLOCKREAD,SUM(DECODE(EVE ------------------------------------------------------------- SQL ordered by Executions for DB: ARS Instance: ARS Snaps: 2156 -2157 -> End Executions Threshold: 100 Executions Rows Processed Rows per Exec Hash Value ------------ ---------------- ---------------- ------------ 9,742 13,337 1.4 158775678 SELECT /*+ */ "A2"."NOMEGRUPPO" FROM "TTM_ASSOCIAZIONE_OPER_GRUP PI" "A2","TTM_GRUPPI" "A1" WHERE "A2"."LOGINNAME"=:1 AND "A1"."W EB"='3' AND "A2"."NOMEGRUPPO"="A1"."NOMEGRUPPO" 5,120 4,618,240 902.0 2590974356 SELECT /*+ */ "A1"."IDENTIFICATORENTT","A1"."CENTRALE","A1"."IDA RMADIO","A1"."DECADE","A1"."CENTRALE_RC","A1"."COD_LOCALITA_A"," A1"."COD_LOCALITA_B","A1"."COD_PROPRIETA","A1"."COD_TECNICA_TRAS M","A1"."NUM_PROGRESSIVO","A1"."IMPIANTO","A1"."PROGR_IMPIANTO", "A1"."MODULO","A1"."PIASTRA","A1"."STATO" FROM "TTM_WEB_NTT_NMT" 4,316 4,316 1.0 1966425544 select text from view$ where rowid=:1 3,077 6,128 2.0 2024169103 SELECT /*+ */ DISTINCT "A1"."DESCRIZIONETIPODIAGNOSI" FROM "TTM_ TIPO_DIAGNOSI_NORM" "A1" WHERE "A1"."CODICETIPODIAGNOSI"=:1 3,077 3,077 1.0 2244068559 SELECT /*+ */ DISTINCT "A1"."DESC_EVENTO" FROM "YS_EVENTO" "A1" WHERE "A1"."COD_EVENTO"=:1 2,822 67,728 24.0 2969510057 SELECT /*+ */ DISTINCT "A1"."COD_EVENTO","A1"."DESC_EVENTO" FROM "YS_EVENTO" "A1" WHERE "A1"."COD_EVENTO" LIKE '1%' ORDER BY "A1 "."COD_EVENTO" 2,238 32,314 14.4 2167152996 SELECT /*+ */ DISTINCT "A2"."CODICETIPODIAGNOSI","A2"."DESCRIZIO NETIPODIAGNOSI" FROM "TTM_TIPO_DIAGNOSI_NORM" "A2","TTM_FAMIGLIA _DIAGNOSI_SOTTOFAM" "A1" WHERE "A2"."CODICETIPODIAGNOSI"="A1"."C OD_DIAGNOSI" AND "A1"."COD_FAM_APPARATO"=:1 AND "A2"."SOTTOTIPOA TTIVITA"='16' ORDER BY "A2"."CODICETIPODIAGNOSI" 1,753 1,753 1.0 1272841353 SELECT nextId FROM arschema WHERE schemaId = 5284 1,753 1,753 1.0 2367161261 UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = 5284 1,291 272,401 211.0 714846653 select value from v$sesstat t where sid = :1 1,248 8 0.0 471818481 SELECT /*+ */ DISTINCT "A1"."PRIORITA","A1"."COD_FAM_APP" FROM " TTM_CIC_FAM_APP" "A1" WHERE "A1"."CODE_CIC"=:1 682 17,732 26.0 93812472 SELECT /*+ */ DISTINCT "A1"."CODICETIPODIAGNOSI","A1"."DESCRIZIO NETIPODIAGNOSI" FROM "TTM_TIPO_DIAGNOSI_NORM" "A1" WHERE "A1"."S OTTOTIPOATTIVITA"='16' ORDER BY "A1"."CODICETIPODIAGNOSI" 527 0 0.0 620899965 update TTM_TROUBLE_TICKET set PROVAGMP=:b0,DATAPROVAGMP=:b1,URL SQL ordered by Executions for DB: ARS Instance: ARS Snaps: 2156 -2157 -> End Executions Threshold: 100 Executions Rows Processed Rows per Exec Hash Value ------------ ---------------- ---------------- ------------ PROVAGMP=:b2 where IDENTIFICATIVOTT=:b3 527 527 1.0 4147644963 update TTM_RICHIESTE_GMP set FLAG_UPDATE=:b0 where (ID_PROVA=:b 1 and STATO=:b2) 514 346 0.7 2431286835 select distinct priorita into :b0 from ttm_priorita_ctt where ( ((((((((decode(cod_sla,null ,0,:b1)+decode(tipo_servizio,null ,0 ,:b2))+decode(segm_cliente,null ,0,:b3))+decode(velocita,null ,0 ,:b4))+decode(utr,null ,0,:b5))=(select max(((((decode(cod_sla,n ull ,0,:b1)+decode(tipo_servizio,null ,0,:b2))+decode(segm_clien 512 512 1.0 2743024965 SELECT /*+ */ DISTINCT "A1"."TCOP" FROM "TTM_FASCIA_TCOP" "A1" W HERE "A1"."FASCIA"=:1 511 0 0.0 2710722465 SELECT T4833.C1,T4833.C1 FROM T4833 WHERE (T4833.C5368709 15 = 'N') ORDER BY 1 ASC 510 0 0.0 428054857 select IdentificativoTT ,DescrizioneTipoUtilizzo ,TipoServizio , SegmentazioneCliente ,CodiceCIC ,DescrizioneCIC ,UtenteDisservit o into :b0:b1,:b2:b3,:b4:b5,:b6:b7,:b8:b9,:b10:b11,:b12:b13 fro m TTM__CTT_COMMUTAZIONE_ where REQUEST_ID=:b14 510 510 1.0 1872165305 SELECT DISTINCT cod_dr FROM sctsede WHERE cod_distretto = '011' 510 0 0.0 1978475092 SELECT DISTINCT cod_distretto FROM sctsede WHERE cod_distretto = '001' 510 510 1.0 2702415183 SELECT DISTINCT codice FROM TTM_ASSOCIAZ_CODICI_REG WHERE numero = '01' 510 510 1.0 3102119193 SELECT DISTINCT cod_distretto FROM sctsede WHERE cod_distretto = '011' 510 510 1.0 4056540434 SELECT DISTINCT cod_sigla_dtre FROM TTM_CENTRO WHERE cod_dtre = '10' 509 509 1.0 690670766 SELECT "CODICEDTRE","NOMEGRUPPO" FROM "TTM_GRUPPI" "TTM_GRUPPI" WHERE "NOMEGRUPPO"=:1 507 507 1.0 4081032591 SELECT nextId FROM arschema WHERE schemaId = 6452 506 506 1.0 559358015 UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = 6452 SQL ordered by Executions for DB: ARS Instance: ARS Snaps: 2156 -2157 -> End Executions Threshold: 100 Executions Rows Processed Rows per Exec Hash Value ------------ ---------------- ---------------- ------------ 459 459 1.0 642377959 UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = 6298 459 459 1.0 3771714502 SELECT nextId FROM arschema WHERE schemaId = 6298 426 3,648 8.6 619801615 SELECT /*+ */ DISTINCT "A2"."CODICETIPODIAGNOSI","A2"."DESCRIZIO NETIPODIAGNOSI" FROM "TTM_TIPO_DIAGNOSI_NORM" "A2","TTM_FAMIGLIA _DIAGNOSI_SOTTOFAM" "A1" WHERE "A2"."CODICETIPODIAGNOSI"="A1"."C ------------------------------------------------------------- Instance Activity Stats for DB: ARS Instance: ARS Snaps: 2156 -2157 Statistic Total per Second per Trans --------------------------------- ---------------- ------------ ------------ CPU used by this session 35,188 92.6 8.8 CPU used when call started 35,185 92.6 8.8 CR blocks created 181 0.5 0.1 DBWR checkpoint buffers written 3,102 8.2 0.8 DBWR checkpoints 1 0.0 0.0 DBWR transaction table writes 36 0.1 0.0 DBWR undo block writes 2,307 6.1 0.6 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 422,809 1,112.7 106.2 SQL*Net roundtrips to/from dblink 129,070 339.7 32.4 background checkpoints completed 0 0.0 0.0 background checkpoints started 1 0.0 0.0 background timeouts 757 2.0 0.2 branch node splits 0 0.0 0.0 buffer is not pinned count 5,393,269 14,192.8 1,355.1 buffer is pinned count 1,240,817 3,265.3 311.8 bytes received via SQL*Net from c 53,999,986 142,105.2 13,567.8 bytes received via SQL*Net from d 16,766,462 44,122.3 4,212.7 bytes sent via SQL*Net to client 316,174,330 832,037.7 79,440.8 bytes sent via SQL*Net to dblink 15,724,848 41,381.2 3,951.0 calls to get snapshot scn: kcmgss 115,169 303.1 28.9 calls to kcmgas 14,864 39.1 3.7 calls to kcmgcs 2,026 5.3 0.5 change write time 161 0.4 0.0 cleanouts and rollbacks - consist 104 0.3 0.0 cleanouts only - consistent read 34 0.1 0.0 cluster key scan block gets 2,397 6.3 0.6 cluster key scans 203 0.5 0.1 commit cleanout failures: block l 0 0.0 0.0 commit cleanout failures: buffer 0 0.0 0.0 commit cleanout failures: callbac 0 0.0 0.0 commit cleanout failures: cannot 1 0.0 0.0 commit cleanouts 22,848 60.1 5.7 commit cleanouts successfully com 22,847 60.1 5.7 consistent changes 2,409 6.3 0.6 consistent gets 6,719,772 17,683.6 1,688.4 cursor authentications 984 2.6 0.3 data blocks consistent reads - un 2,409 6.3 0.6 db block changes 139,749 367.8 35.1 db block gets 357,928 941.9 89.9 deferred (CURRENT) block cleanout 12,223 32.2 3.1 enqueue conversions 147,331 387.7 37.0 enqueue releases 174,371 458.9 43.8 enqueue requests 174,376 458.9 43.8 enqueue timeouts 1 0.0 0.0 execute count 71,916 189.3 18.1 free buffer requested 2,665 7.0 0.7 immediate (CR) block cleanout app 138 0.4 0.0 immediate (CURRENT) block cleanou 2,182 5.7 0.6 index fast full scans (full) 0 0.0 0.0 leaf node splits 137 0.4 0.0 logons cumulative 29 0.1 0.0 logons current messages received 25,684 67.6 6.5 messages sent 25,684 67.6 6.5 Instance Activity Stats for DB: ARS Instance: ARS Snaps: 2156 -2157 Statistic Total per Second per Trans --------------------------------- ---------------- ------------ ------------ no buffer to keep pinned count 0 0.0 0.0 no work - consistent read gets 5,955,054 15,671.2 1,496.2 opened cursors cumulative 48,434 127.5 12.2 opened cursors current parse count (hard) 10,468 27.6 2.6 parse count (total) 111,854 294.4 28.1 parse time cpu 2,441 6.4 0.6 parse time elapsed 3,441 9.1 0.9 physical reads 77,429 203.8 19.5 physical reads direct 77,149 203.0 19.4 physical reads direct (lob) 192 0.5 0.1 physical writes 80,347 211.4 20.2 physical writes direct 77,149 203.0 19.4 physical writes direct (lob) 96 0.3 0.0 physical writes non checkpoint 79,859 210.2 20.1 prefetched blocks 0 0.0 0.0 process last non-idle time 2,100,658,606 5,528,049.0 527,803.7 recursive calls 78,949 207.8 19.8 recursive cpu usage 3,471 9.1 0.9 redo blocks written 35,353 93.0 8.9 redo buffer allocation retries 1 0.0 0.0 redo entries 87,128 229.3 21.9 redo log space requests 1 0.0 0.0 redo log space wait time 1 0.0 0.0 redo size 22,043,808 58,010.0 5,538.7 redo synch time 1,425 3.8 0.4 redo synch writes 25,303 66.6 6.4 redo wastage 13,593,568 35,772.6 3,415.5 redo write time 1,169 3.1 0.3 redo writer latching time 0 0.0 0.0 redo writes 25,291 66.6 6.4 rollback changes - undo records a 0 0.0 0.0 rollbacks only - consistent read 77 0.2 0.0 rows fetched via callback 10,827 28.5 2.7 session connect time 2,100,658,606 5,528,049.0 527,803.7 session cursor cache count 122 0.3 0.0 session cursor cache hits 88,789 233.7 22.3 session logical reads 7,077,470 18,624.9 1,778.3 session pga memory 153,058,912 402,786.6 38,457.0 session pga memory max 153,058,912 402,786.6 38,457.0 session uga memory 517,728 1,362.4 130.1 session uga memory max 1,436,144 3,779.3 360.8 sorts (disk) 2 0.0 0.0 sorts (memory) 30,935 81.4 7.8 sorts (rows) 1,169,537 3,077.7 293.9 switch current to new buffer table fetch by rowid 346,091 910.8 87.0 table fetch continued row 3,417 9.0 0.9 table scan blocks gotten 5,290,882 13,923.4 1,329.4 table scan rows gotten 86,543,019 227,744.8 21,744.5 table scans (long tables) 0 0.0 0.0 table scans (short tables) 37,576 98.9 9.4 total file opens 2 0.0 0.0 transaction rollbacks 0 0.0 0.0 user calls 447,942 1,178.8 112.6 user commits 3,980 10.5 1.0 Instance Activity Stats for DB: ARS Instance: ARS Snaps: 2156 -2157 Statistic Total per Second per Trans --------------------------------- ---------------- ------------ ------------ user rollbacks 0 0.0 0.0 write clones created in foregroun 2 0.0 0.0 ------------------------------------------------------------- Tablespace IO Stats for DB: ARS Instance: ARS Snaps: 2156 -2157 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ TEMP 8,537 22 3.5 9.0 2,206 6 0 0.0 RBS_1 0 0 0.0 1,662 4 0 0.0 RBS 0 0 0.0 681 2 0 0.0 ARSYSTEM 195 1 8.2 1.4 376 1 1 0.0 TOOLS 1 0 20.0 1.0 251 1 0 0.0 ARINDICI 0 0 0.0 147 0 0 0.0 ARANAG 0 0 0.0 31 0 0 0.0 SYSTEM 0 0 0.0 7 0 0 0.0 ------------------------------------------------------------- File IO Stats for DB: ARS Instance: ARS Snaps: 2156 -2157 ->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) -------------- ------- ------ ------- ------------ -------- ---------- ------ ARANAG /db_ARS_DAT_1/database/ars/aranag1.dbf 0 0 31 0 0 ARINDICI /db_ARS_IND_1/database/ars/arindici1.dbf 0 0 68 0 0 /db_ARS_IND_1/database/ars/arindici2.dbf 0 0 74 0 0 /db_ARS_IND_1/database/ars/arindici3.dbf 0 0 5 0 0 ARSYSTEM /db_ARS_DAT_1/database/ars/arsys1.dbf 94 0 7.9 1.4 80 0 1 0.0 /db_ARS_DAT_1/database/ars/arsys2.dbf 51 0 10.2 1.2 140 0 0 /db_ARS_DAT_1/database/ars/arsys3.dbf 50 0 6.8 1.6 156 0 0 RBS /db_ARS_IND_1/database/ars/rbs1.dbf 0 0 501 1 0 /db_ARS_IND_1/database/ars/rbs2.dbf 0 0 180 0 0 RBS_1 /db_ARS_IND_1/database/ars/rbs_1_3.dbf 0 0 354 1 0 /db_ARS_IND_1/database/ars/rbs_1_4.dbf 0 0 531 1 0 /db_ARS_IND_1/database/ars/rbs_1_5.dbf 0 0 475 1 0 /db_ARS_IND_2/database/ars/rbs_1_6.dbf 0 0 302 1 0 SYSTEM /db_ARS_DAT_1/database/ars/system.dbf 0 0 7 0 0 TEMP /db_ARS_IND_1/database/ars/temp.dbf 6,775 18 3.0 8.6 1,683 4 0 /db_ARS_IND_1/database/ars/temp1.dbf 1,762 5 5.7 10.6 523 1 0 TOOLS /db_ARS_DAT_1/database/ars/tools.dbf 1 0 20.0 1.0 86 0 0 /db_ARS_DAT_1/database/ars/tools_01.dbf 0 0 78 0 0 /db_ARS_DAT_1/database/ars/tools_02.dbf 0 0 4 0 0 /db_ARS_DAT_1/database/ars/tools_03.dbf 0 0 34 0 0 /db_ARS_DAT_1/database/ars/tools_04.dbf 0 0 49 0 0 ------------------------------------------------------------- Buffer Pool Statistics for DB: ARS Instance: ARS Snaps: 2156 -2157 -> 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 2,662 5,969,617 88 3,102 0 0 1 ------------------------------------------------------------- Buffer wait Statistics for DB: ARS Instance: ARS Snaps: 2156 -2157 -> ordered by wait time desc, waits desc Tot Wait Avg Class Waits Time (cs) Time (cs) ------------------ ----------- ---------- --------- data block 1 0 0 ------------------------------------------------------------- Rollback Segment Stats for DB: ARS Instance: ARS Snaps: 2156 -2157 ->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 2.0 0.00 0 0 0 0 2 2,932.0 0.00 220,506 0 0 0 3 2,950.0 0.00 236,466 0 0 0 4 2,860.0 0.00 233,806 0 0 0 5 2,866.0 0.00 229,442 0 0 0 6 2,921.0 0.00 225,288 0 0 0 7 2,914.0 0.00 275,690 0 0 0 8 1,849.0 0.00 160,596 0 0 0 9 2,958.0 0.00 233,728 0 0 0 10 2,779.0 0.00 251,780 0 0 0 11 2,952.0 0.00 216,348 0 0 0 12 2,887.0 0.00 242,086 0 0 0 13 2,949.0 0.00 234,446 0 0 0 14 2,865.0 0.00 231,086 0 0 0 15 3,089.0 0.00 259,970 0 0 0 16 2,992.0 0.00 231,332 0 0 0 17 3,102.0 0.00 240,906 0 0 0 18 3,068.0 0.00 223,226 0 0 0 19 3,057.0 0.00 214,118 0 0 0 20 3,111.0 0.00 231,244 0 0 0 21 3,085.0 0.00 231,936 0 0 0 22 3,105.0 0.00 220,342 0 0 0 23 3,048.0 0.00 235,132 0 0 0 24 3,139.0 0.00 212,372 0 0 0 25 3,101.0 0.00 209,684 0 0 0 26 3,066.0 0.00 236,864 0 0 0 27 3,076.0 0.00 210,876 0 0 0 28 3,128.0 0.00 215,404 0 0 0 29 2,997.0 0.00 396,680 0 0 0 30 3,184.0 0.00 210,240 0 0 0 31 3,106.0 0.00 227,098 0 0 0 32 3,090.0 0.00 243,026 0 0 0 33 3,040.0 0.00 220,318 0 0 0 34 860.0 0.00 100,978 0 0 0 35 3,079.0 0.00 269,516 0 0 0 36 2,962.0 0.00 236,188 0 0 0 37 3,068.0 0.00 228,398 0 0 0 ------------------------------------------------------------- Rollback Segment Storage for DB: ARS Instance: ARS Snaps: 2156 -2157 ->Optimal Size should be larger than Avg Active RBS No Segment Size Avg Active Optimal Size Maximum Size ------ --------------- --------------- --------------- --------------- 0 52,547,584 0 52,547,584 2 56,623,104 1,048,576 52,428,800 56,623,104 3 56,623,104 1,048,576 52,428,800 56,623,104 4 54,530,048 796,917 52,428,800 54,530,048 5 56,623,104 419,430 52,428,800 56,623,104 6 56,623,104 1,048,576 52,428,800 56,623,104 7 56,623,104 1,048,576 52,428,800 56,623,104 8 54,550,528 797,327 52,428,800 54,550,528 9 54,525,952 796,917 52,428,800 54,525,952 10 54,525,952 1,048,576 52,428,800 54,525,952 11 52,428,800 419,430 52,428,800 52,428,800 12 54,525,952 1,363,148 52,428,800 54,525,952 13 52,436,992 1,048,576 52,428,800 52,436,992 14 56,623,104 1,363,148 52,428,800 56,623,104 15 56,623,104 1,048,576 52,428,800 56,623,104 16 56,623,104 1,048,576 52,428,800 56,623,104 17 56,623,104 1,048,576 52,428,800 56,623,104 18 52,432,896 1,048,576 52,428,800 52,432,896 19 56,623,104 1,048,576 52,428,800 56,623,104 20 54,554,624 419,430 52,428,800 54,554,624 21 54,546,432 1,364,787 52,428,800 54,546,432 22 54,571,008 797,696 52,428,800 54,571,008 23 54,542,336 796,917 52,428,800 54,542,336 24 54,554,624 1,137,766 52,428,800 54,554,624 25 56,623,104 0 52,428,800 56,623,104 26 52,424,704 1,048,576 52,428,800 52,424,704 27 52,424,704 0 52,428,800 52,424,704 28 52,424,704 1,048,166 52,428,800 52,424,704 29 52,424,704 1,048,576 52,428,800 52,424,704 30 52,424,704 0 52,428,800 52,424,704 31 52,424,704 1,048,576 52,428,800 52,424,704 32 52,424,704 0 52,428,800 52,424,704 33 52,424,704 0 52,428,800 52,424,704 34 52,424,704 1,048,576 52,428,800 52,424,704 35 52,424,704 204,223,110 52,428,800 304,082,944 36 52,424,704 82,560,566 52,428,800 167,768,064 37 115,339,264 1,048,576 115,339,264 ------------------------------------------------------------- Latch Activity for DB: ARS Instance: ARS Snaps: 2156 -2157 ->"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 ----------------------------- -------------- ------ ------ ------------ ------ active checkpoint queue latch 860 0.0 0 begin backup scn array 53 0.0 0 cache buffer handles 177 0.0 0 cache buffers chains 13,726,824 0.0 0.0 2,656 0.0 cache buffers lru chain 5,673 0.0 2,649 0.0 channel handle pool latch 1 0.0 0 channel operations parent lat 2 0.0 0 checkpoint queue latch 136,278 0.0 0.0 0 dml lock allocation 19,420 0.0 0 enqueue hash chains 496,061 0.0 0.0 0 enqueues 692,015 0.2 0.0 0 event group latch 1 0.0 0 global transaction 634,611 0.0 0 global tx free list 42,629 0.0 0.0 0 global tx hash mapping 190,296 0.0 0.0 0 job_queue_processes parameter 6 0.0 0 ktm global data 1 0.0 0 latch wait list 1,612 0.4 0.0 1,610 0.1 library cache 3,711,955 0.1 0.3 169,324 0.3 library cache load lock 56 0.0 0 list of block allocation 8,409 0.0 0 loader state object freelist 20 0.0 0 longop free list 430 0.0 0 messages 88,979 0.0 0.1 0 mostly latch-free SCN 161,465 0.0 0.0 0 ncodef allocation latch 6 0.0 0 process allocation 1 0.0 1 0.0 process group creation 1 0.0 0 redo allocation 137,710 0.0 0.0 0 redo writing 127,637 0.1 0.0 0 row cache objects 1,866,008 0.5 0.0 0 sequence cache 11 0.0 0 session allocation 87,483 0.0 0.0 0 session idle bit 939,599 0.0 0.0 0 session switching 6 0.0 0 shared pool 445,112 0.3 0.4 0 sort extent pool 55 0.0 0 transaction allocation 55,241 0.0 0.0 0 transaction branch allocation 400,225 0.0 0.0 0 undo global data 98,932 0.0 0.0 0 user lock 2 0.0 0 ------------------------------------------------------------- Latch Sleep breakdown for DB: ARS Instance: ARS Snaps: 2156 -2157 -> ordered by misses desc Get Spin & Latch Name Requests Misses Sleeps Sleeps 1->4 -------------------------- -------------- ----------- ----------- ------------ row cache objects 1,866,008 9,390 76 9314/76/0/0/ 0 library cache 3,711,955 4,656 1,629 3350/987/315 /4/0 shared pool 445,112 1,302 534 1001/73/224/ 4/0 cache buffers chains 13,726,824 253 3 250/3/0/0/0 redo writing 127,637 84 2 82/2/0/0/0 messages 88,979 11 1 10/1/0/0/0 ------------------------------------------------------------- Latch Miss Sources for DB: ARS Instance: ARS Snaps: 2156 -2157 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- ------- cache buffers chains kcbchg: kslbegin: bufs not 0 1 0 cache buffers chains kcbgcur: kslbegin 0 1 1 cache buffers chains kcbget: pin buffer 0 1 0 library cache kglic 0 1,280 1,232 library cache kglhdgn: child: 0 51 30 library cache kglhdgc: child: 0 40 4 library cache kglpnal: child: before pro 0 28 39 library cache kgldti: 2child 0 11 11 library cache kglupc: child 0 4 35 library cache kgllkdl: child: cleanup 0 3 6 library cache kglpnal: child: alloc spac 0 2 60 messages ksaamb: after wakeup 0 1 0 redo writing kcrfsr 0 2 0 row cache objects kqrpre: find obj 0 66 30 row cache objects kqreqd: rel enqueue 0 6 4 row cache objects kqreqd 0 4 40 shared pool kghfrunp: alloc: clatch no 0 508 0 shared pool kghfrunp: clatch: nowait 0 205 0 shared pool kghalo 0 15 180 shared pool kghfrunp: alloc: wait 0 7 24 shared pool kghfrunp: clatch: wait 0 5 135 shared pool kghfnd: get next extent 0 2 0 shared pool kghalp 0 1 21 shared pool kghfrunp: batch min scan 0 1 0 ------------------------------------------------------------- Dictionary Cache Stats for DB: ARS Instance: ARS Snaps: 2156 -2157 ->"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 0 0 dc_database_links 10,686 0.0 0 0 4 80 dc_files 0 0 0 30 94 dc_free_extents 975 0.5 5 0.0 11 1,041 98 dc_global_oids 0 0 0 0 0 dc_histogram_data 50 0.0 0 0 122 94 dc_histogram_data_valu 9,040 0.0 0 0 260 100 dc_histogram_defs 484,963 0.0 0 0 3,486 100 dc_object_ids 70,243 0.0 0 0 668 100 dc_objects 12,592 0.0 0 0 656 100 dc_outlines 0 0 0 0 0 dc_profiles 2 0.0 0 0 1 17 dc_rollback_segments 76 0.0 0 0 39 93 dc_segments 30,947 0.0 0 5 787 100 dc_sequence_grants 0 0 0 0 0 dc_sequences 1 0.0 0 1 3 27 dc_synonyms 22 0.0 0 0 82 99 dc_tablespace_quotas 5 0.0 0 5 4 80 dc_tablespaces 19 0.0 0 0 9 75 dc_used_extents 5 100.0 0 5 248 97 dc_user_grants 5,071 0.0 0 0 15 28 dc_usernames 1,196 0.0 0 0 7 58 dc_users 5,103 0.0 0 0 16 73 ifs_acl_cache_entries 0 0 0 0 0 ------------------------------------------------------------- Library Cache Activity for DB: ARS Instance: ARS Snaps: 2156 -2157 ->"Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 1 0.0 1 0.0 0 0 CLUSTER 0 0 0 0 INDEX 0 0 0 0 OBJECT 0 0 0 0 PIPE 0 0 0 0 SQL AREA 23,074 45.4 174,104 12.0 15 0 TABLE/PROCEDURE 20,886 0.0 46,153 0.1 20 0 TRIGGER 0 0 0 0 ------------------------------------------------------------- SGA Memory Summary for DB: ARS Instance: ARS Snaps: 2156 -2157 SGA regions Size in Bytes ------------------------------ ---------------- Database Buffers 2,457,600,000 Fixed Size 104,936 Redo Buffers 1,056,768 Variable Size 3,183,423,488 ---------------- sum 5,642,185,192 ------------------------------------------------------------- SGA breakdown difference for DB: ARS Instance: ARS Snaps: 2156 -2157 Pool Name Begin value End value Difference ----------- ------------------------ -------------- -------------- ----------- java pool free memory 20,000,768 20,000,768 0 shared pool Checkpoint queue 650,496 650,496 0 shared pool KGFF heap 23,544 23,544 0 shared pool KGK heap 4,440 4,440 0 shared pool KQLS heap 2,266,936 2,279,688 12,752 shared pool PL/SQL DIANA 918,880 918,880 0 shared pool PL/SQL MPCODE 489,584 501,640 12,056 shared pool PLS non-lib hp 2,136 2,136 0 shared pool PX msg pool 50,336 50,336 0 shared pool PX subheap 14,280 14,280 0 shared pool State objects 2,068,992 2,068,992 0 shared pool branches 358,560 358,560 0 shared pool db_block_buffers 124,800,000 124,800,000 0 shared pool db_block_hash_buckets 20,838,512 20,838,512 0 shared pool db_handles 901,120 901,120 0 shared pool dictionary cache 4,166,504 4,169,144 2,640 shared pool distributed_transactions 164,448 164,448 0 shared pool event statistics per ses 3,926,832 3,926,832 0 shared pool fixed allocation callbac 12,936 12,936 0 shared pool free memory 143,014,800 141,442,384 -1,572,416 shared pool ktlbk state objects 666,784 666,784 0 shared pool library cache 818,866,352 821,809,640 2,943,288 shared pool message pool freequeue 191,192 191,192 0 shared pool messages 212,992 212,992 0 shared pool miscellaneous 2,788,992 2,797,320 8,328 shared pool processes 1,097,728 1,097,728 0 shared pool sessions 2,750,592 2,750,592 0 shared pool simulator trace entries 1,920,000 1,920,000 0 shared pool sql area 2,027,727,960 2,026,320,624 -1,407,336 shared pool state objects 331,240 331,240 0 shared pool table columns 36,712 37,552 840 shared pool table definiti 9,664 9,512 -152 shared pool transaction_branches 238,848 238,848 0 shared pool transactions 1,890,880 1,890,880 0 shared pool trigger inform 896 896 0 db_block_buffers 2,457,600,000 2,457,600,000 0 fixed_sga 104,936 104,936 0 log_buffer 1,048,576 1,048,576 0 ------------------------------------------------------------- init.ora Parameters for DB: ARS Instance: ARS Snaps: 2156 -2157 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- _kgl_latch_count 35 _row_cache_buffer_size 2800 _spin_count 7000 background_dump_dest /products/oracle8/rdbms/log/ARS bitmap_merge_area_size 2097152 compatible 8.1.7.0.0 control_files /db_ARS_DAT_1/database/ars/ctrl1A core_dump_dest /products/oracle8/rdbms/log/ARS db_block_buffers 600000 db_block_lru_latches 96 db_block_size 4096 db_file_multiblock_read_count 16 db_files 60 db_name ARS db_writer_processes 4 dml_locks 400 enqueue_resources 800 global_names FALSE hash_area_size 393216 hash_join_enabled TRUE hash_multiblock_io_count 8 job_queue_processes 2 log_archive_start FALSE log_buffer 1048576 log_checkpoint_interval 30720 max_dump_file_size 10240 open_cursors 500 optimizer_mode CHOOSE plsql_v2_compatibility TRUE processes 1024 rollback_segments RB1, RB2, RB3, RB4, RB5, RB6, RB7 session_cached_cursors 100 shared_pool_reserved_size 150000000 shared_pool_size 3000000000 sort_area_retained_size 393216 sort_area_size 3231744 timed_statistics TRUE user_dump_dest /products/oracle8/rdbms/log/ARS utl_file_dir /products/oracle8/file ------------------------------------------------------------- End of Report