- 论坛徽章:
- 0
|
帮忙分析Statspack报告
STATSPACK report for
DB Name DB Id Instance Inst Num Release OPS Host
------------ ----------- ------------ -------- ----------- --- ------------
YDMIS 2855197922 ydmis 1 8.1.7.0.0 NO JYTEST
Snap Id Snap Time Sessions
------- ------------------ --------
Begin Snap: 1 09-7月 -04 11:44:29 #######
End Snap: 7 09-7月 -04 13:36:25 #######
Elapsed: 111.93 (mins)
Cache Sizes
~~~~~~~~~~~
db_block_buffers: 38400 log_buffer: 32768
db_block_size: 8192 shared_pool_size: 957286400
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 2,796.65 149,065.62
Logical reads: 3,231.87 172,263.97
Block changes: 3.81 202.87
Physical reads: 162.51 8,662.18
Physical writes: 64.54 3,440.29
User calls: 4.20 223.71
Parses: 0.81 42.97
Hard parses: 0.04 2.19
Sorts: 0.17 8.93
Logons: 0.14 7.53
Executes: 0.59 31.18
Transactions: 0.02
% Blocks changed per Read: 0.12 Recursive Call %: 56.41
Rollback per transaction %: 6.35 Rows per Sort: #######
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 99.96 Redo NoWait %: 99.69
Buffer Hit %: 94.97 In-memory Sort %: 97.24
Library Hit %: 96.52 Soft Parse %: 94.90
Execute to Parse %: -37.80 Latch Hit %: 99.97
Parse CPU to Parse Elapsd %: 3.93 % Non-Parse CPU: 100.00
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 39.09 39.62
% SQL with executions>;1: 52.76 52.77
% Memory for SQL w/exec>;1: 45.16 45.14
Top 5 Wait Events
~~~~~~~~~~~~~~~~~ Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
direct path read 223,565 146,283 32.85
db file scattered read 331,008 134,574 30.22
direct path write 169,352 101,427 22.78
PX Deq: Execution Msg 1,512 29,474 6.62
control file parallel write 2,303 10,988 2.47
-------------------------------------------------------------
Wait Events for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; 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
---------------------------- ------------ ---------- ----------- ------ ------
direct path read 223,565 0 146,283 7 ######
db file scattered read 331,008 0 134,574 4 ######
direct path write 169,352 0 101,427 6 ######
PX Deq: Execution Msg 1,512 115 29,474 195 12.0
control file parallel write 2,303 0 10,988 48 18.3
buffer busy waits 9,398 2 4,091 4 74.6
db file parallel write 160 0 3,296 206 1.3
db file sequential read 5,556 0 3,163 6 44.1
log file switch completion 40 20 2,987 747 0.3
file open 1,040 0 2,536 24 8.3
latch free 1,718 1,266 2,510 15 13.6
control file sequential read 567 0 1,025 18 4.5
log file parallel write 1,437 0 631 4 11.4
enqueue 473 0 459 10 3.8
log file sync 143 0 381 27 1.1
log buffer space 83 0 254 31 0.7
library cache pin 214 0 220 10 1.7
refresh controlfile command 36 0 183 51 0.3
PX Deq: Execute Reply 218 0 167 8 1.7
PX Deq: Signal ACK 244 104 153 6 1.9
SQL*Net more data to client 6,736 0 151 0 53.5
file identify 41 0 135 33 0.3
PX Deq: Join ACK 333 0 57 2 2.6
PX Deq: Parse Reply 261 0 41 2 2.1
log file single write 38 0 33 9 0.3
process startup 1 0 32 320 0.0
log file sequential read 19 0 26 14 0.2
LGWR wait for redo copy 52 1 17 3 0.4
SQL*Net break/reset to clien 23 0 2 1 0.2
SQL*Net message from client 23,603 0 8,089,576 3427 187.3
virtual circuit status 219 219 673,257 30742 1.7
PX Idle Wait 2,967 2,860 596,481 2010 23.5
pipe get 32 5 2,253 704 0.3
SQL*Net message to client 23,611 0 79 0 187.4
SQL*Net more data from clien 2,586 0 26 0 20.5
-------------------------------------------------------------
Background Wait Events for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (cs) (ms) /txn
---------------------------- ------------ ---------- ----------- ------ ------
control file parallel write 2,303 0 10,988 48 18.3
db file parallel write 160 0 3,296 206 1.3
file open 931 0 1,008 11 7.4
control file sequential read 450 0 856 19 3.6
log file parallel write 1,436 0 631 4 11.4
enqueue 4 0 241 603 0.0
direct path read 285 0 188 7 2.3
file identify 38 0 114 30 0.3
db file scattered read 234 0 64 3 1.9
db file sequential read 134 0 47 4 1.1
log file single write 38 0 33 9 0.3
log file sequential read 19 0 26 14 0.2
latch free 31 31 25 8 0.2
LGWR wait for redo copy 52 1 17 3 0.4
direct path write 285 0 3 0 2.3
rdbms ipc message 9,074 6,443 1,989,312 2192 72.0
smon timer 22 22 675,974 ###### 0.2
pmon timer 2,207 2,172 671,081 3041 17.5
-------------------------------------------------------------
SQL ordered by Gets for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; 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
--------------- ------------ -------------- ------- ------------
5,331,874 11 484,715.8 24.6 2609700514
select * from (select null table_catalog, ac.owner table_schema,
ac.table_name table_name, acc.column_name column_name, null col
umn_guid, null column_propid, acc.position ordinal, ac.constrain
t_name pk_name from all_constraints ac, all_cons_columns acc whe
re ac.owner=acc.owner and ac.constraint_type='P' and ac.constrai
4,300,906 1 4,300,906.0 19.8 2556906023
SELECT NULL AS PKQUALIFIER, PKCOLS.OWNER AS PKOWNER, PKCOLS.TABL
E_NAME AS PKTABLE, PKCOLS.COLUMN_NAME AS PKCOLUMN, FKCOLS.TABLE_
NAME AS FKTABLE, FKCOLS.COLUMN_NAME AS FKCOLUMN, FKCOLS.POSITION
AS ORDINAL, FCON.CONSTRAINT_NAME AS FKNAME FROM ALL_CONS_COLUMN
S PKCOLS, ALL_CONS_COLUMNS FKCOLS, ALL_CONSTRAINTS FCON, ALL_CON
4,300,906 1 4,300,906.0 19.8 3880451911
SELECT NULL AS PKQUALIFIER, PKCOLS.OWNER AS PKOWNER, PKCOLS.TABL
E_NAME AS PKTABLE, PKCOLS.COLUMN_NAME AS PKCOLUMN, FKCOLS.TABLE_
NAME AS FKTABLE, FKCOLS.COLUMN_NAME AS FKCOLUMN, FKCOLS.POSITION
AS ORDINAL, FCON.CONSTRAINT_NAME AS FKNAME FROM ALL_CONS_COLUMN
S PKCOLS, ALL_CONS_COLUMNS FKCOLS, ALL_CONSTRAINTS FCON, ALL_CON
3,286,106 5 657,221.2 15.1 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
2,658,044 4 664,511.0 12.2 3376831664
BEGIN statspack.snap; END;
1,454,182 3 484,727.3 6.7 2027989771
select * from (select null table_catalog, ac.owner table_schema,
ac.table_name table_name, acc.column_name column_name, null col
umn_guid, null column_propid, acc.position ordinal, ac.constrain
t_name pk_name from all_constraints ac, all_cons_columns acc whe
re ac.owner=acc.owner and ac.constraint_type='P' and ac.constrai
663,325 1 663,325.0 3.1 2301846564
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_d
ate; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
484,688 1 484,688.0 2.2 4062111432
select * from (select null table_catalog, ac.owner table_schema,
ac.table_name table_name, acc.column_name column_name, null col
umn_guid, null column_propid, acc.position ordinal, ac.constrain
t_name pk_name from all_constraints ac, all_cons_columns acc whe
re ac.owner=acc.owner and ac.constraint_type='P' and ac.constrai
431,788 9 47,976.4 2.0 3103854733
SQL ordered by Gets for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; 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
--------------- ------------ -------------- ------- ------------
select object_name, owner object_owner, status, object_type, cre
ated, last_ddl_time from sys.all_objects where object_type =  b
ject_type and (owner not in ('SYS', 'SYSTEM')) order by decode(o
wner, user, 0, 1), owner, object_name
157,532 1 157,532.0 0.7 1126324808
select * from (select null table_catalog, decode (o1.owner, 'PUB
LIC', NULL, o1.owner) table_schema, o1.object_name table_name, d
ecode(o1.owner,'SYS',decode(o1.object_type,'TABLE','SYSTEM TABLE
','VIEW','SYSTEM VIEW',o1.object_type),'SYSTEM',decode(o1.object
_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type
157,478 1 157,478.0 0.7 88265135
select * from (select null table_catalog, decode (o1.owner, 'PUB
LIC', NULL, o1.owner) table_schema, o1.object_name table_name, d
ecode(o1.owner,'SYS',decode(o1.object_type,'TABLE','SYSTEM TABLE
','VIEW','SYSTEM VIEW',o1.object_type),'SYSTEM',decode(o1.object
_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type
157,478 1 157,478.0 0.7 1315515514
select * from (select null table_catalog, decode (o1.owner, 'PUB
LIC', NULL, o1.owner) table_schema, o1.object_name table_name, d
ecode(o1.owner,'SYS',decode(o1.object_type,'TABLE','SYSTEM TABLE
','VIEW','SYSTEM VIEW',o1.object_type),'SYSTEM',decode(o1.object
_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type
157,478 1 157,478.0 0.7 2490270045
select * from (select null table_catalog, decode (o1.owner, 'PUB
LIC', NULL, o1.owner) table_schema, o1.object_name table_name, d
ecode(o1.owner,'SYS',decode(o1.object_type,'TABLE','SYSTEM TABLE
','VIEW','SYSTEM VIEW',o1.object_type),'SYSTEM',decode(o1.object
_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type
115,153 1 115,153.0 0.5 4111834861
select s.synonym_name object_name, o.object_type from sys.all_sy
nonyms s, sys.all_objects o where s.owner in ('PUBLIC', use
r) and o.owner = s.table_owner and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCED
URE', 'FUNCTION', 'SEQUENCE')
99,764 1 99,764.0 0.5 1115543279
select * from (select null table_catalog, decode (o1.owner, 'PUB
-------------------------------------------------------------
SQL ordered by Reads for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; End Disk Reads Threshold: 1000
Physical Reads Executions Reads per Exec % Total Hash Value
--------------- ------------ -------------- ------- ------------
325,610 4 81,402.5 29.8 3376831664
BEGIN statspack.snap; END;
244,338 6 40,723.0 22.4 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
203,474 5 40,694.8 18.6 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
81,335 1 81,335.0 7.5 2301846564
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_d
ate; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
61,632 4 15,408.0 5.6 14982107
SELECT DISTINCT X.YWLBDM, C.YWLBMC, X.YWDM, A.YWMC, X.GCDM, X.GC
MC FROM XT_CZYQXDA Y, ZH_YWLCDYB X,ZH_YWLBDMB C,ZH_YWMCDMB A WH
ERE X.KJBM = Y.MKBM AND Y.KJBM = X.MKBM AND X.YWLBDM = C.YWLBDM
AND X.YWLBDM = A.YWLBDM AND X.YWDM = A.YWDM AND X.GCDM = '100000
00000000000000' AND Y.CZYDM = '000350' ORDER BY X.YWLBDM, X.YWDM
40,780 8 5,097.5 3.7 1484809473
select YLWJMC,BBH,FBSJ from XT_MKYLWJB
36,591 6 6,098.5 3.4 1452374678
select YLWJMC,BBH from XT_MKYLWJB
21,990 6 3,665.0 2.0 553636889
select XTMC,ZXTMC,MKBM,MKMC,BBH,MKWJMC,MMKJMC,ZCTLM,MKGNSM,FBSJ
from XT_MKDA where XTMC='电力企业MIS'
20,522 6 3,420.3 1.9 2616899337
select YLWJNR from XT_MKYLWJB where YLWJMC='BMDefult.ini'
18,478 5 3,695.6 1.7 4124625808
select YLWJNR from XT_MKYLWJB where YLWJMC='打印模板.xls'
18,446 3 6,148.7 1.7 2907875207
select * from XT_MKYLWJB where YLWJMC='MIS_SC_QXGL.UI.dll'
18,433 3 6,144.3 1.7 2917277056
select * from XT_MKYLWJB where YLWJMC='MIS_SC_QXGL.DataAccess.dl
l'
18,349 5 3,669.8 1.7 459038197
select YLWJNR from XT_MKYLWJB where YLWJMC='CfgOfFrame.xml'
SQL ordered by Reads for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; End Disk Reads Threshold: 1000
Physical Reads Executions Reads per Exec % Total Hash Value
--------------- ------------ -------------- ------- ------------
18,010 7 2,572.9 1.7 2086588553
select YLWJNR from XT_MKYLWJB where YLWJMC='用电普查检查表.xls'
17,651 6 2,941.8 1.6 866258579
select YLWJNR from XT_MKYLWJB where YLWJMC='DevieceReport.xls'
17,618 6 2,936.3 1.6 1175809595
select YLWJNR from XT_MKYLWJB where YLWJMC='用电检查工单.xls'
17,192 5 3,438.4 1.6 3955744914
select YLWJNR from XT_MKYLWJB where YLWJMC='newemail.wav'
17,123 5 3,424.6 1.6 1597068332
select YLWJNR from XT_MKYLWJB where YLWJMC='CXZT.xml'
17,122 5 3,424.4 1.6 1782824629
select YLWJNR from XT_MKYLWJB where YLWJMC='Report.xls'
17,120 5 3,424.0 1.6 333064577
select YLWJNR from XT_MKYLWJB where YLWJMC='tmpCZRZ.xls'
17,118 5 3,423.6 1.6 966069869
select YLWJNR from XT_MKYLWJB where YLWJMC='HELP.HLP'
17,116 5 3,423.2 1.6 1313476020
select YLWJNR from XT_MKYLWJB where YLWJMC='DDRZReprot.xls'
17,112 5 3,422.4 1.6 3265818240
select YLWJNR from XT_MKYLWJB where YLWJMC='CZRZReprot.xls'
15,847 3 5,282.3 1.5 2522805834
select YLWJNR from XT_MKYLWJB where YLWJMC='BUSY.avi'
15,583 3 5,194.3 1.4 1619726113
select YLWJNR from XT_MKYLWJB where YLWJMC='QXJL.xls'
14,819 3 4,939.7 1.4 3169435143
select YLWJNR from XT_MKYLWJB where YLWJMC='ZD.xml'
14,382 4 3,595.5 1.3 3291272953
select DISTINCT MKWJMC,BBH,MKBM from XT_MKDA
13,679 4 3,419.8 1.3 3965112848
select YLWJNR from XT_MKYLWJB where YLWJMC='MIS_RS_DataAccess.x
ml'
13,241 3 4,413.7 1.2 1995537357
select YLWJNR from XT_MKYLWJB where YLWJMC='DeviceService.xls'
12,894 4 3,223.5 1.2 1743982111
select distinct MKBM,MKMC,ZXTMC,BBH,MKWJMC,MMKJMC,ZCTLM from XT_
MKDA where XTMC='电力企业MIS' order by ZXTMC
11,946 4 2,986.5 1.1 2687477803
SQL ordered by Reads for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; End Disk Reads Threshold: 1000
Physical Reads Executions Reads per Exec % Total Hash Value
--------------- ------------ -------------- ------- ------------
select YLWJMC,BBH from XT_MKYLWJB
11,260 2 5,630.0 1.0 1763173761
select YLWJNR from XT_MKYLWJB where YLWJMC='个人简历模板.xls'
6,247 7 892.4 0.6 1168768785
select YLWJNR from XT_MKYLWJB where YLWJMC='业务工作单.xls'
5,407 7 772.4 0.5 2869770404
select YLWJNR from XT_MKYLWJB where YLWJMC='Cclib.dot'
5,349 1 5,349.0 0.5 674687686
select wybsm,sbglbh,wzdymc from zh_sbtyjbda where sbglbh is not
null and sbytdm=5 and sbmcdm=68 order by sbglbh
5,349 1 5,349.0 0.5 3003050823
select distinct wzdymc from zh_sbtyjbda where wzdymc is not null
and sbytdm=5 and sbmcdm=68 order by wzdymc
5,349 1 5,349.0 0.5 3217608905
select wybsm,sbglbh,wzdymc from zh_sbtyjbda where fsbdm='8029270
7' and sbytdm=5 and sbmcdm=321 and sbglbh is not null
3,852 4 963.0 0.4 3317323525
SELECT DISTINCT X.YWLBDM,X.YWDM,X.YWLSH,X.GCDM,X.GCXLH,X.YWJYMS,
X.LXBMDM,X.LXRDM,X.LXSJ,X.ZRBMDM,X.YQWCSJ,X.ZXRDM,X.SJWCSJ,X.CLJ
GSM,X.GCQDSJ,X.GCZT,X.BLGCBH,Y.GCMC,A.XM,B.XM,C.XZJGMC,D.XZJGMC,
E.YWLBMC,F.YWMC FROM ZH_YWGCXLB X,ZH_YWLCDYB Y,XT_CZYQXDA Z,RS_R
YGXJBXX A,RS_RYGXJBXX B,RS_XZJGDMB C,RS_XZJGDMB D,ZH_YWLBDMB E,Z
-------------------------------------------------------------
SQL ordered by Executions for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; End Executions Threshold: 100
Executions Rows Processed Rows per Exec Hash Value
------------ ---------------- ---------------- ------------
560 560 1.0 2867117002
SELECT * FROM dual
412 92 0.2 313510536
select job from sys.job$ where next_date < sysdate and (field1
= :1 or (field1 = 0 and 'Y' = :2)) order by next_date, job
110 10 0.1 2097488208
SELECT /*+ Q2489000 NO_EXPAND ROWID(A1) */ A1."ID",A1."QXBH",A1.
"XQSJ",A1."XQDW",A1."XQR",A1."BZ",A1."EDITDATE",A1."XQNR" FROM "
SC_QX_WCQK" PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1 WHERE A1."QX
BH"=15
98 90 0.9 1576697787
select u1.user#, u2.user#, u3.user#, failures, flag, interval#,
what, nlsenv, env from sys.job$ j, sys.user$ u1, sys.user$ u
2, sys.user$ u3 where job=:1 and (next_date < sysdate or :2 !=
0) and lowner = u1.name and powner = u2.name and cowner = u3.na
me for update nowait
90 836 9.3 3013728279
select privilege#,level from sysauth$ connect by grantee#=prior
privilege# and privilege#>;0 start with (grantee#=:1 or grantee#=
1) and privilege#>;0
75 75 1.0 3783443424
select '00.00.0000 '||banner, user, 99/100 from v$version where
banner like 'Oracle%'
72 0 0.0 2811272309
ALTER SESSION SET NLS_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_TERRITO
RY= 'CHINA' NLS_CURRENCY= 'RMB' NLS_ISO_CURRENCY= 'CHINA' NLS_NU
MERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT
= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_SORT=
'BINARY'
54 54 1.0 411033441
insert into dependency$(d_obj#,d_timestamp,order#,p_obj#,p_times
tamp,d_owner#, property)values (:1,:2,:3,:4,:5,:6, :7)
52 71 1.4 1705880752
select file# from file$ where ts#=:1
50 50 1.0 1966425544
select text from view$ where rowid=:1
49 49 1.0 3517412409
begin :id := sys.dbms_transaction.local_transaction_id; end;
40 40 1.0 1425443843
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,
order$=:6,cache=:7,highwater=:8,audit$=:9 where obj#=:1
36 36 1.0 1908503079
SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL
SQL ordered by Executions for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; End Executions Threshold: 100
Executions Rows Processed Rows per Exec Hash Value
------------ ---------------- ---------------- ------------
36 36 1.0 3313905788
insert into col$(obj#,name,intcol#,segcol#,type#,length,precisio
n#,scale,null$,offset,fixedstorage,segcollength,deflength,defaul
t$,col#,property,charsetid,charsetform,spare1,spare2)values(:1,:
2,:3,:4,:5,:6,decode(:7,0,null,:7),decode(:5,2,decode(:8,-127/*M
AXSB1MINAL*/,null,: ,178,:8,179,:8,180,:8,181,:8,182,:8,183,:8,
30 5 0.2 955191413
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$,
spare1 from obj$ where owner#=:1 and name=:2 and namespace=:3 an
d(remoteowner=:4 or remoteowner is null and :4 is null)and(linkn
ame=:5 or linkname is null and :5 is null)and(subname=:6 or subn
ame is null and :6 is null)
30 3 0.1 1443158872
SELECT /*+ Q2486000 NO_EXPAND ROWID(A1) */ A1."ID",A1."QXBH",A1.
"XQDW",A1."XQQX",A1."XQYJ",A1."JLR",A1."JLDW",A1."EDITDATE" FROM
"SC_QX_XQGZD" PX_GRANULE(0, BLOCK_RANGE, DYNAMIC) A1 WHERE A1.
"QXBH"=15
29 29 1.0 154303060
select * from sys.all_objects where object_type = bject_type a
nd owner = bject_owner and object_name = bject_name and :sub
_object is null
29 29 1.0 2116980823
insert into access$(d_obj#,order#,columns,types) values (:1,:2,:
3,:4)
22 4,642 211.0 1674384472
select value from v$sesstat where sid = :sid order by statistic#
22 31 1.4 2085632044
select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1
22 22 1.0 2524236541
SELECT COUNT(*) FROM ZH_YWGCXLB X,ZH_YWLCDYB Y,XT_CZYQXDA Z WHER
E ZRBMDM='3403221801' AND GCZT IN('新到','待办') AND Z.MKBM=Y.KJ
BM AND Z.KJBM=Y.MKBM AND X.YWLBDM=Y.YWLBDM AND X.YWDM=Y.YWDM AND
X.GCDM=Y.GCDM AND Z.CZYDM='000350'
22 22 1.0 3363386146
SELECT COUNT(*) FROM ZH_XXB WHERE JSRDM='000350' AND ZT='新到'
21 21 1.0 114083071
update obj$ set obj#=:6,type#=:7,ctime=:8,mtime=:9,stime=:10,sta
tus=:11,dataobj#=:13,flags=:14,oid$=:15,spare1=:16 where owner#=
:1 and name=:2 and namespace=:3 and(remoteowner=:4 or remoteowne
r is null and :4 is null)and(linkname=:5 or linkname is null and
:5 is null)and(subname=:12 or subname is null and :12 is null)
21 861 41.0 1714733582
select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t whe
SQL ordered by Executions for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; End Executions Threshold: 100
Executions Rows Processed Rows per Exec Hash Value
------------ ---------------- ---------------- ------------
re t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0
-------------------------------------------------------------
Instance Activity Stats for DB: YDMIS Instance: ydmis Snaps: 1 -7
Statistic Total per Second per Trans
--------------------------------- ---------------- ------------ ------------
CPU used by this session 596,828 88.9 4,736.7
CPU used when call started 16,005 2.4 127.0
CR blocks created 311 0.1 2.5
DBWR buffers scanned 0 0.0 0.0
DBWR checkpoint buffers written 4,208 0.6 33.4
DBWR checkpoints 23 0.0 0.2
DBWR free buffers found 0 0.0 0.0
DBWR lru scans 0 0.0 0.0
DBWR make free requests 0 0.0 0.0
DBWR revisited being-written buff 0 0.0 0.0
DBWR summed scan depth 0 0.0 0.0
DBWR transaction table writes 68 0.0 0.5
DBWR undo block writes 1,763 0.3 14.0
DFO trees parallelized 67 0.0 0.5
PX local messages recv'd 1,470 0.2 11.7
PX local messages sent 1,468 0.2 11.7
Parallel operations downgraded 25 67 0.0 0.5
Parallel operations downgraded 50 0 0.0 0.0
Parallel operations downgraded to 84 0.0 0.7
SQL*Net roundtrips to/from client 23,374 3.5 185.5
background checkpoints completed 19 0.0 0.2
background checkpoints started 19 0.0 0.2
background timeouts 6,902 1.0 54.8
branch node splits 0 0.0 0.0
buffer is not pinned count 14,727,648 2,192.9 116,886.1
buffer is pinned count 312,962 46.6 2,483.8
bytes received via SQL*Net from c 6,057,032 901.9 48,071.7
bytes sent via SQL*Net to client 36,453,477 5,427.9 289,313.3
calls to get snapshot scn: kcmgss 4,342 0.7 34.5
calls to kcmgas 404 0.1 3.2
calls to kcmgcs 2,349 0.4 18.6
change write time 472 0.1 3.8
cleanouts and rollbacks - consist 3 0.0 0.0
cleanouts only - consistent read 169 0.0 1.3
cluster key scan block gets 1,365,003 203.3 10,833.4
cluster key scans 587,136 87.4 4,659.8
commit cleanout failures: block l 1 0.0 0.0
commit cleanout failures: buffer 27 0.0 0.2
commit cleanout failures: callbac 8 0.0 0.1
commit cleanout failures: cannot 1 0.0 0.0
commit cleanouts 2,770 0.4 22.0
commit cleanouts successfully com 2,733 0.4 21.7
consistent changes 546 0.1 4.3
consistent gets 21,645,175 3,222.9 171,787.1
cursor authentications 116 0.0 0.9
data blocks consistent reads - un 546 0.1 4.3
db block changes 25,562 3.8 202.9
db block gets 60,153 9.0 477.4
deferred (CURRENT) block cleanout 2,179 0.3 17.3
dirty buffers inspected 0 0.0 0.0
enqueue conversions 692 0.1 5.5
enqueue releases 3,744 0.6 29.7
enqueue requests 4,237 0.6 33.6
enqueue timeouts 483 0.1 3.8
enqueue waits 2 0.0 0.0
execute count 3,929 0.6 31.2
Instance Activity Stats for DB: YDMIS Instance: ydmis Snaps: 1 -7
Statistic Total per Second per Trans
--------------------------------- ---------------- ------------ ------------
free buffer inspected 793 0.1 6.3
free buffer requested 668,505 99.5 5,305.6
hot buffers moved to head of LRU 6,697 1.0 53.2
immediate (CR) block cleanout app 172 0.0 1.4
immediate (CURRENT) block cleanou 543 0.1 4.3
index fast full scans (full) 7 0.0 0.1
leaf node splits 136 0.0 1.1
logons cumulative 949 0.1 7.5
logons current
messages received 1,808 0.3 14.4
messages sent 1,808 0.3 14.4
no buffer to keep pinned count 6,672,791 993.6 52,958.7
no work - consistent read gets 7,461,779 1,111.1 59,220.5
opened cursors cumulative 5,354 0.8 42.5
opened cursors current
parse count (hard) 276 0.0 2.2
parse count (total) 5,414 0.8 43.0
parse time cpu 163 0.0 1.3
parse time elapsed 4,144 0.6 32.9
physical reads 1,091,435 162.5 8,662.2
physical reads direct 423,850 63.1 3,363.9
physical writes 433,477 64.5 3,440.3
physical writes direct 429,267 63.9 3,406.9
physical writes non checkpoint 430,648 64.1 3,417.8
pinned buffers inspected 449 0.1 3.6
prefetched blocks 331,015 49.3 2,627.1
prefetched blocks aged out before 0 0.0 0.0
process last non-idle time 8,984,609,673 1,337,791.8 ############
queries parallelized 67 0.0 0.5
recovery array read time 0 0.0 0.0
recovery array reads 0 0.0 0.0
recovery blocks read 0 0.0 0.0
recursive calls 36,476 5.4 289.5
recursive cpu usage 7,859 1.2 62.4
redo blocks written 38,393 5.7 304.7
redo buffer allocation retries 102 0.0 0.8
redo entries 13,047 1.9 103.6
redo log space requests 40 0.0 0.3
redo log space wait time 2,987 0.4 23.7
redo size 18,782,268 2,796.7 149,065.6
redo synch time 381 0.1 3.0
redo synch writes 162 0.0 1.3
redo wastage 383,544 57.1 3,044.0
redo write time 1,632 0.2 13.0
redo writer latching time 18 0.0 0.1
redo writes 1,438 0.2 11.4
rollback changes - undo records a 1 0.0 0.0
rollbacks only - consistent read 308 0.1 2.4
rows fetched via callback 3,582,808 533.5 28,435.0
session connect time 9,026,798,768 1,344,073.7 ############
session logical reads 21,705,260 3,231.9 172,264.0
session pga memory 210,650,984 31,365.5 1,671,833.2
session pga memory max 199,254,360 29,668.6 1,581,383.8
session uga memory 7,585,116 1,129.4 60,199.3
session uga memory max 38,009,896 5,659.6 301,665.8
sorts (disk) 31 0.0 0.3
Instance Activity Stats for DB: YDMIS Instance: ydmis Snaps: 1 -7
Statistic Total per Second per Trans
--------------------------------- ---------------- ------------ ------------
sorts (memory) 1,094 0.2 8.7
sorts (rows) 1,797,151 267.6 14,263.1
summed dirty queue length 0 0.0 0.0
switch current to new buffer
table fetch by rowid 5,664,705 843.5 44,958.0
table fetch continued row 5,948 0.9 47.2
table scan blocks gotten 725,712 108.1 5,759.6
table scan rows gotten 2,217,517 330.2 17,599.3
table scans (direct read) 67 0.0 0.5
table scans (long tables) 342 0.1 2.7
table scans (rowid ranges) 67 0.0 0.5
table scans (short tables) 1,051 0.2 8.3
total file opens 1,040 0.2 8.3
transaction rollbacks 0 0.0 0.0
user calls 28,188 4.2 223.7
user commits 118 0.0 0.9
user rollbacks 8 0.0 0.1
write clones created in backgroun 6 0.0 0.1
write clones created in foregroun 24 0.0 0.2
-------------------------------------------------------------
Tablespace IO Stats for DB: YDMIS Instance: ydmis Snaps: 1 -7
->;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
390,716 58 0.0 1.1 428,965 64 0 0.0
USERS
336,300 50 4.1 2.0 1,490 0 9,393 4.4
RBS
19 0 0.0 1.0 1,850 0 0 0.0
SYSTEM
418 0 3.3 1.6 327 0 5 0.0
STATSPACK
19 0 0.0 1.0 695 0 0 0.0
INDX
38 0 0.0 1.0 38 0 0 0.0
TMPMIS
38 0 0.0 1.0 38 0 0 0.0
DRSYS
19 0 0.0 1.0 19 0 0 0.0
TOOLS
19 0 0.0 1.0 19 0 0 0.0
-------------------------------------------------------------
File IO Stats for DB: YDMIS Instance: ydmis Snaps: 1 -7
->;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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
DRSYS D:\ORACLE\ORADATA\YDMIS\DR01.DBF
19 0 0.0 1.0 19 0 0
INDX D:\ORACLE\ORADATA\YDMIS\INDX01.DBF
19 0 0.0 1.0 19 0 0
G:\ORADATA\INDX02.DBF
19 0 0.0 1.0 19 0 0
RBS D:\ORACLE\ORADATA\YDMIS\RBS01.DBF
19 0 0.0 1.0 1,850 0 0
STATSPACK G:\ORADATA\STATSPACK.DBF
19 0 0.0 1.0 695 0 0
SYSTEM D:\ORACLE\ORADATA\YDMIS\SYS002.ORA
33 0 1.8 1.2 32 0 0
D:\ORACLE\ORADATA\YDMIS\SYSTEM01.DBF
385 0 3.5 1.6 295 0 5 0.0
TEMP D:\ORACLE\ORADATA\YDMIS\TEMP01.DBF
390,716 58 0.0 1.1 428,965 64 0
TMPMIS D:\ORACLE\ORADATA\YDMIS\TMPMIS.ORA
19 0 0.0 1.0 19 0 0
D:\ORACLE\ORADATA\YDMIS\TMPMIS_DF1.ORA
19 0 0.0 1.0 19 0 0
TOOLS D:\ORACLE\ORADATA\YDMIS\TOOLS01.DBF
19 0 0.0 1.0 19 0 0
USERS C:\ORADATA\YDMIS\USERS02.DBF
4,097 1 6.0 1.9 26 0 336 2.6
C:\ORADATA\YDMIS\USERS03.DBF
279,055 42 4.2 2.0 70 0 8,686 4.5
D:\ORACLE\ORADATA\YDMIS\USERS01.DBF
13,036 2 3.2 2.0 44 0 371 2.7
G:\ORADATA\USERS04.DBF
40,112 6 3.4 2.0 1,350 0 0
-------------------------------------------------------------
Buffer Pool Statistics for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; 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 668,488 0 667,562 4,210 0 0 9,398
-------------------------------------------------------------
Buffer wait Statistics for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; ordered by wait time desc, waits desc
Tot Wait Avg
Class Waits Time (cs) Time (cs)
------------------ ----------- ---------- ---------
data block 9,398 4,092 0
-------------------------------------------------------------
Enqueue activity for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; ordered by waits desc, gets desc
Enqueue Gets Waits
---------- ------------ ----------
CF 80 2
-------------------------------------------------------------
Rollback Segment Stats for DB: YDMIS Instance: ydmis Snaps: 1 -7
->;A high value for " ct Waits" suggests more rollback segments may be required
Trans Table Pct Undo Bytes
RBS No Gets Waits Written Wraps Shrinks Extends
------ ------------ ------- --------------- -------- -------- --------
0 28.0 0.00 0 0 0 0
1 248.0 0.00 584,254 2 0 0
2 332.0 0.00 905,234 3 0 0
3 145.0 0.00 246,338 1 0 0
4 779.0 0.00 2,257,410 8 0 0
5 529.0 0.00 1,791,232 7 0 0
6 461.0 0.00 1,480,236 5 0 0
7 370.0 0.00 601,418 2 0 0
-------------------------------------------------------------
Rollback Segment Storage for DB: YDMIS Instance: ydmis Snaps: 1 -7
->;Optimal Size should be larger than Avg Active
RBS No Segment Size Avg Active Optimal Size Maximum Size
------ --------------- --------------- --------------- ---------------
0 401,408 0 401,408
1 4,186,112 2,212,574 4,194,304 9,428,992
2 4,186,112 1,600,222 4,194,304 8,380,416
3 4,186,112 2,065,246 4,194,304 5,234,688
4 4,186,112 940,001 4,194,304 4,186,112
5 4,186,112 1,463,742 4,194,304 40,361,984
6 4,186,112 7,162,739 4,194,304 139,452,416
7 4,186,112 1,999,061 4,194,304 40,361,984
-------------------------------------------------------------
Latch Activity for DB: YDMIS Instance: ydmis Snaps: 1 -7
->;"Get Requests", "ct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->;"NoWait Requests", "ct NoWait Miss" are for no-wait latch get requests
->;"ct 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 826 0.0 0
active checkpoint queue latch 2,499 0.0 0
cache buffer handles 2,661 0.0 0
cache buffers chains 30,690,782 0.0 0.0 1,003,836 0.0
cache buffers lru chain 690,536 0.1 0.0 668,414 0.0
channel handle pool latch 105 0.0 96 13.5
channel operations parent lat 210 0.0 96 5.2
checkpoint queue latch 33,340 0.6 0.0 0
dictionary lookup 9 0.0 0
dml lock allocation 1,310 0.0 0
enqueue hash chains 9,152 1.8 0.0 0
enqueues 16,394 1.9 0.0 0
error message lists 737 9.0 0.0 0
event group latch 105 0.0 0
file number translation table 151 0.0 0
job_queue_processes parameter 122 0.0 0
ktm global data 22 0.0 0
latch wait list 457 0.0 460 2.6
library cache 807,265 0.8 0.2 0
library cache load lock 116 0.0 0
list of block allocation 948 0.0 0
loader state object freelist 284 0.0 0
longop free list 20,774 0.1 0.0 0
messages 21,657 0.6 0.0 0
multiblock read objects 669,921 0.0 0.0 0
ncodef allocation latch 122 0.0 0
parallel query alloc buffer 3,320 4.6 0.0 0
parallel query stats 609 18.4 0.0 0
process allocation 105 0.0 105 0.0
process group creation 201 2.0 1.5 0
process queue 1,642 2.4 0.0 0
process queue reference 41,703 0.0 0.0 3,122 0.2
query server freelists 1,823 3.3 0.0 0
query server process 15 0.0 15 0.0
redo allocation 18,180 0.1 0.1 0
redo writing 12,398 0.1 0.0 0
row cache objects 120,841 0.0 5.6 0
sequence cache 365 0.0 0
session allocation 10,716 5.9 0.0 0
session idle bit 59,993 0.1 0.0 0
session switching 122 0.0 0
session timer 2,200 0.0 0
shared pool 20,514 1.1 0.1 0
sort extent pool 223 0.0 0
transaction allocation 1,225 0.0 0
transaction branch allocation 122 0.0 0
undo global data 3,409 0.0 0
user lock 336 1.8 0.0 0
virtual circuit queues 329 0.0 0
Latch Activity for DB: YDMIS Instance: ydmis Snaps: 1 -7
->;"Get Requests", "ct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->;"NoWait Requests", "ct NoWait Miss" are for no-wait latch get requests
->;"ct 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
----------------------------- -------------- ------ ------ ------------ ------
-------------------------------------------------------------
Latch Sleep breakdown for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; ordered by misses desc
Get Spin &
Latch Name Requests Misses Sleeps Sleeps 1->;4
-------------------------- -------------- ----------- ----------- ------------
library cache 807,265 6,192 1,535 5750/6/95/34
1/0
cache buffers chains 30,690,782 2,178 76 2150/2/12/14
/0
session allocation 10,716 629 4 625/4/0/0/0
cache buffers lru chain 690,536 476 3 475/0/0/1/0
enqueues 16,394 316 15 313/0/0/3/0
shared pool 20,514 229 23 221/3/0/5/0
checkpoint queue latch 33,340 208 4 204/4/0/0/0
redo allocation 18,180 25 3 24/0/0/1/0
row cache objects 120,841 9 50 1/0/0/8/0
process group creation 201 4 6 2/0/0/2/0
-------------------------------------------------------------
Latch Miss Sources for DB: YDMIS Instance: ydmis Snaps: 1 -7
->; only latches with sleeps are shown
->; ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- -------
cache buffers chains kcbgtcr: kslbegin 0 47 49
cache buffers chains kcbget: pin buffer 0 25 0
cache buffers chains kcbesc: escalate 0 3 0
cache buffers lru chain kcbzgb: multiple sets nowa 0 3 0
checkpoint queue latch kcbk0rrd: update recovery 0 4 0
enqueues ksqgel: create enqueue 0 11 14
enqueues ksqgtl2 0 3 0
library cache kglic 0 1,235 372
library cache kglpnal: child: alloc spac 0 103 66
library cache kglhdgn: child: 0 71 489
library cache kglhdgc: child: 0 36 25
library cache kgldti: 2child 0 26 21
library cache kglpnal: child: before pro 0 25 78
library cache kgllkdl: child: free pin 0 20 103
library cache kgllkdl: child: cleanup 0 11 4
library cache kglpnal: child: check gran 0 2 0
process group creation ksupgprem 0 6 6
redo allocation kcrfwr: redo allocation 0 3 0
row cache objects kqrpre: find obj 0 38 35
row cache objects kqrso 0 12 15
session allocation ksuxds: KSUSFCLC not set 0 3 4
shared pool kghfre 0 11 15
shared pool kghupr1 0 10 8
-------------------------------------------------------------
Dictionary Cache Stats for DB: YDMIS Instance: ydmis Snaps: 1 -7
->;"ct Misses" should be very low (< 2% in most cases)
->;"Cache Usage" is the number of cache entries being used
->;"ct 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 4 50.0 0 4 2,109 99
dc_database_links 0 0 0 4 80
dc_files 0 0 0 8 80
dc_free_extents 917 0.5 8 0.0 13 1,819 95
dc_global_oids 0 0 0 15 65
dc_histogram_data 0 0 0 0 0
dc_histogram_data_valu 0 0 0 0 0
dc_histogram_defs 935 1.9 0 0 1,252 99
dc_object_ids 655 2.0 0 7 2,434 100
dc_objects 1,087 2.4 0 31 4,448 100
dc_outlines 0 0 0 0 0
dc_profiles 98 0.0 0 0 1 17
dc_rollback_segments 352 0.0 0 0 9 75
dc_segments 574 2.8 0 21 2,353 100
dc_sequence_grants 0 0 0 0 0
dc_sequences 40 0.0 0 40 35 83
dc_synonyms 73 13.7 0 0 136 93
dc_tablespace_quotas 50 0.0 0 20 11 39
dc_tablespaces 129 0.0 0 0 11 46
dc_used_extents 11 63.6 0 11 2,194 94
dc_user_grants 25,703 0.0 0 0 28 60
dc_usernames 598 0.0 0 0 48 80
dc_users 26,144 0.0 0 0 43 83
ifs_acl_cache_entries 0 0 0 0 0
-------------------------------------------------------------
Library Cache Activity for DB: YDMIS Instance: ydmis Snaps: 1 -7
->;"ct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 71 1.4 72 4.2 2 0
CLUSTER 150 0.0 77 0.0 0 0
INDEX 1 100.0 1 100.0 0 0
OBJECT 0 0 0 0
PIPE 60 3.3 87 2.3 0 0
SQL AREA 5,394 3.5 13,940 3.3 17 0
TABLE/PROCEDURE 2,406 0.8 2,931 4.3 14 0
TRIGGER 8 0.0 8 0.0 0 0
-------------------------------------------------------------
SGA Memory Summary for DB: YDMIS Instance: ydmis Snaps: 1 -7
SGA regions Size in Bytes
------------------------------ ----------------
Database Buffers 314,572,800
Fixed Size 75,804
Redo Buffers 77,824
Variable Size 988,315,648
----------------
sum 1,303,042,076
-------------------------------------------------------------
SGA breakdown difference for DB: YDMIS Instance: ydmis Snaps: 1 -7
Pool Name Begin value End value Difference
----------- ------------------------ -------------- -------------- -----------
java pool free memory 15,388,672 15,388,672 0
java pool memory in use 5,582,848 5,582,848 0
large pool free memory 614,400 614,400 0
shared pool KGFF heap 11,768 11,768 0
shared pool KGK heap 17,532 17,532 0
shared pool KQLS heap 6,879,628 6,967,576 87,948
shared pool PL/SQL DIANA 5,341,508 5,408,308 66,800
shared pool PL/SQL MPCODE 1,599,024 1,637,080 38,056
shared pool PL/SQL PPCODE 251,272 279,948 28,676
shared pool PL/SQL SOURCE 13,696 13,696 0
shared pool PLS non-lib hp 2,096 2,096 0
shared pool PX msg pool 69,460 69,460 0
shared pool PX subheap 9,192 9,192 0
shared pool VIRTUAL CIRCUITS 364,632 364,632 0
shared pool db_block_buffers 5,222,400 5,222,400 0
shared pool db_block_hash_buckets 745,480 745,480 0
shared pool db_files 370,988 370,988 0
shared pool dictionary cache 5,749,164 5,773,568 24,404
shared pool errors 153,144 153,144 0
shared pool event statistics per ses 774,000 774,000 0
shared pool fixed allocation callbac 960 960 0
shared pool free memory 588,864,916 583,666,096 -5,198,820
shared pool joxlod: in ehe 115,264 115,264 0
shared pool joxlod: in phe 152,220 152,220 0
shared pool joxlod: init P 776 776 0
shared pool joxs heap init 4,248 4,248 0
shared pool library cache 188,662,132 189,144,004 481,872
shared pool miscellaneous 3,811,216 3,877,740 66,524
shared pool sessions 485,100 485,100 0
shared pool sql area 156,591,788 160,993,488 4,401,700
shared pool table columns 229,008 230,808 1,800
shared pool table definiti 20,816 21,856 1,040
shared pool trigger defini 25,812 25,812 0
shared pool trigger inform 1,240 1,240 0
shared pool trigger source 3,012 3,012 0
shared pool type object de 27,156 27,156 0
shared pool view columns d 138,912 138,912 0
db_block_buffers 314,572,800 314,572,800 0
fixed_sga 75,804 75,804 0
log_buffer 66,560 66,560 0
-------------------------------------------------------------
init.ora Parameters for DB: YDMIS Instance: ydmis Snaps: 1 -7
End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
background_dump_dest D:\oracle\admin\YDMIS\bdump
compatible 8.1.0
control_files D:\oracle\oradata\YDMIS\control01
db_block_buffers 38400
db_block_size 8192
db_file_multiblock_read_count 2
db_files 1024
db_name YDMIS
distributed_transactions 0
global_names TRUE
instance_name YDMIS
java_pool_size 20971520
job_queue_interval 60
job_queue_processes 4
large_pool_size 614400
log_buffer 32768
log_checkpoint_interval 10000
log_checkpoint_timeout 1800
max_dump_file_size 10240
max_enabled_roles 30
mts_dispatchers (PROTOCOL=TCP)(PRE=oracle.aurora.
open_cursors 300
open_links 4
oracle_trace_collection_name
os_authent_prefix
parallel_max_servers 5
processes 200
remote_login_passwordfile EXCLUSIVE
service_names YDMIS
shared_pool_size 957286400
sort_area_retained_size 65536
sort_area_size 65536
timed_statistics TRUE
user_dump_dest D:\oracle\admin\YDMIS\udump
-------------------------------------------------------------
End of Report |
|
免费注册
发表于 2004-07-09 14:56
