WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
BAANDB	1512237885	baandb	1	10.2.0.1.0	NO	baanoradb

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	786	06-Mar-07 09:00:44	190	17.2
End Snap:	792	06-Mar-07 12:00:45	536	18.7
Elapsed:		180.01 (mins)
DB Time:		688.40 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	3,104M	3,040M	Std Block Size:	8K
Shared Pool Size:	432M	496M	Log Buffer:	14,440K

Load Profile

	Per Second	Per Transaction
Redo size:	146,273.50	6,464.86
Logical reads:	19,810.45	875.56
Block changes:	1,029.78	45.51
Physical reads:	42.52	1.88
Physical writes:	30.18	1.33
User calls:	2,424.84	107.17
Parses:	189.97	8.40
Hard parses:	4.39	0.19
Sorts:	20.56	0.91
Logons:	0.62	0.03
Executes:	1,104.75	48.83
Transactions:	22.63

% Blocks changed per Read:	5.20	Recursive Call %:	38.20
Rollback per transaction %:	1.31	Rows per Sort:	8.00

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.79	In-memory Sort %:	100.00
Library Hit %:	94.24	Soft Parse %:	97.69
Execute to Parse %:	82.80	Latch Hit %:	99.80
Parse CPU to Parse Elapsd %:	69.91	% Non-Parse CPU:	94.26

Shared Pool Statistics

	Begin	End
Memory Usage %:	91.61	93.04
% SQL with executions>1:	85.59	85.45
% Memory for SQL w/exec>1:	88.29	77.19

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
log file sync	411,246	17,529	43	42.4	Commit
CPU time		9,740		23.6
db file sequential read	445,012	8,526	19	20.6	User I/O
log file parallel write	271,894	6,430	24	15.6	System I/O
db file parallel write	82,602	2,358	29	5.7	System I/O

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Wait Class
• Wait Events
• Background Wait Events
• Operating System Statistics
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 41304.1s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Wait Class

• s - second
• cs - centisecond - 100th of a second
• ms - millisecond - 1000th of a second
• us - microsecond - 1000000th of a second
• ordered by wait time desc, waits desc

Back to Wait Events Statistics
Back to Top

Wait Events

• s - second
• cs - centisecond - 100th of a second
• ms - millisecond - 1000th of a second
• us - microsecond - 1000000th of a second
• ordered by wait time desc, waits desc (idle events last)

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in centisecond (100th of a second)

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• Total Buffer Gets: 213,961,577
• Captured SQL account for 72.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 459,197
• Captured SQL account for 56.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 11,931,818
• Captured SQL account for 36.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 2,051,772
• Captured SQL account for 50.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0916h1xpc91cv	SELECT /*+ FIRST_ROWS index(a ttppss975730$idx1) */ a.t$cprj, a.t$cspa, a.t$cuni, a.t$date, a.t$ddat, a.t$item, a.t$koor, a.t$kotr, a.t$orno, a.t$podt, a.t$pono, a.t$quan, a.t$reft, a.t$sern, a.t$srno, a.t$trdt FROM baan.ttppss975730 a WHERE a.t$koor = :1 AND a.t$cprj = :2
0bcbz1mf2phfc	SELECT /*+ FIRST_ROWS index(a ttfacp200730$idx1) */ a.t$ttyp, a.t$ninv, a.t$suno FROM baan.ttfacp200730 a WHERE (a.t$ninv >= :1) AND (a.t$ninv <= :2) AND a.t$docn = :3 AND (a.t$ttyp >= :4) AND (a.t$ttyp <= :4)
1jbf42xgfcryg	SELECT /*+ index(a ttfacp965930$idx1) */ t$ttyp, t$ninv, t$line, t$tdoc, t$docn, t$lino, t$cuno, t$docd, t$trec, t$ccur, t$amnt, t$amth, t$dued, t$leac, t$agan, t$ficu, t$balh, t$year, t$prod, t$btno, t$agn1, t$agn2, t$agn3, t$agn4, t$agn5, t$agn6, t$basd, t$desc, t$nama, t$namb, t$namc, t$namd, t$name, t$desf, t$amtr, t$baln, t$dbdt, t$dbti, t$creg, t$cfsg, t$cprj, t$orno, t$Refcntd, t$Refcntu FROM baan.ttfacp965930 a WHERE t$ttyp= :1 AND t$ninv= :2 AND t$line= :3 AND t$tdoc= :4 AND t$docn= :5 AND t$lino= :6 FOR UPDATE WAIT 999
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2qcdh8up4th0m	SELECT /*+ FIRST_ROWS index(a ttpppc215730$idx5) */ a.t$amoc, a.t$amos, a.t$cact, a.t$ccco, a.t$cdoc, a.t$cdru, a.t$comf, a.t$cpla, a.t$cprj, a.t$cser, a.t$cspa, a.t$cstl, a.t$cuni, a.t$desc, a.t$drun, a.t$fper, a.t$fyea, a.t$invo, a.t$item, a.t$ltdt, a.t$ncmp, a.t$ninv, a.t$ocmp, a.t$orno, a.t$peri, a.t$pono, a.t$pric, a.t$pris, a.t$quan, a.t$rgdt, a.t$serb, a.t$sern, a.t$snec, a.t$srnb, a.t$srni, a.t$stin, a.t$sttl, a.t$suno, a.t$tetd, a.t$txta, a.t$year FROM baan.ttpppc215730 a WHERE a.t$tetd = :1 AND a.t$cprj = :2 AND a.t$orno = :3 AND a.t$pono = :4 AND a.t$srnb = :5
2skwhauh2cwky	select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
2vfq88cs0aybx	INSERT INTO baan.ttpppc215730 (t$cprj, t$cspa, t$item, t$sern, t$cpla, t$cact, t$ltdt, t$rgdt, t$quan, t$cuni, t$pric, t$amoc, t$pris, t$amos, t$cdoc, t$desc, t$snec, t$year, t$peri, t$fyea, t$fper, t$suno, t$ocmp, t$ncmp, t$invo, t$stin, t$ninv, t$comf, t$orno, t$pono, t$srnb, t$srni, t$cstl, t$tetd, t$drun, t$serb, t$cdru, t$cser, t$ccco, t$sttl, t$txta, t$Refcntd, t$Refcntu) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43)
2wdnmpj5rz7p0	SELECT /*+ FIRST_ROWS INDEX(a ttfgld205730$idx3) */ a.t$ccur, a.t$cono, a.t$dim1, a.t$dim2, a.t$dim3, a.t$dim4, a.t$dim5, a.t$fcah, a.t$fcam, a.t$fdah, a.t$fdam, a.t$fqt1, a.t$fqt2, a.t$leac, a.t$ncah, a.t$ncam, a.t$ndah, a.t$ndam, a.t$nqt1, a.t$nqt2, a.t$olap, a.t$prno, a.t$ptyp, a.t$year FROM baan.ttfgld205730 a WHERE (((a.t$year * :1) + a.t$prno) >= :2) AND (((a.t$year * :1) + a.t$prno) <= :3) AND a.t$cono = :4 AND a.t$ptyp = :5 AND a.t$year >= :6 AND a.t$leac >= :7 AND a.t$dim1 >= :8 AND a.t$dim2 >= :9 AND a.t$dim3 >= :10 AND a.t$dim4 >= :11 AND a.t$dim5 >= :12 AND a.t$ccur >= :13 AND a.t$year <= :14 AND a.t$leac <= :15 AND a.t$dim1 <= :16 AND a.t$dim2 <= :17 AND a.t$dim3 <= :18 AND a.t$dim4 <= :19 AND a.t$dim5 <= :20 AND a.t$ccur <= :21 ORDER BY 2, 23, 24, 14, 3, 4, 5, 6, 7, 1, 22
3a6nup6dhcfuv	SELECT /*+ index(a ttipcs021730$idx1) */ t$cprj, t$item, t$dsca, t$dscb, t$dscc, t$dscd, t$wght, t$seak, t$dfit, t$cpvr, t$opts, t$kitm, t$citg, t$csel, t$cvat, t$ltac, t$uset, t$cuni, t$stgu, t$cvsu, t$cwar, t$pslc, t$kltc, t$obpr, t$kpsl, t$npsl, t$stoc, t$blck, t$ordr, t$allo, t$hall, t$alpl, t$uscu, t$ltdt, t$aoqc, t$aoqa, t$uaoq, t$oltm, t$cpha, t$bfcp, t$bfep, t$bfhr, t$nnts, t$qpnt, t$runi, t$unom, t$scpf, t$tmps, t$ncst, t$nsfc, t$llcd, t$llci, t$cuqp, t$cvqp, t$cupp, t$cvpp, t$csgp, t$ccur, t$prip, t$ltpp, t$suno, t$qual, t$csgs, t$ccde, t$ctyo, t$cpcp, t$cpre, t$mtce, t$opce, t$ltcp, t$cpra, t$mtca, t$opca, t$buyr, t$cplb, t$eitm, t$umer, t$txta, t$ffsi, t$qbsi, t$lsid, t$Refcntd, t$Refcntu FROM baan.ttipcs021730 a WHERE t$cprj= :1 AND t$item= :2
4wq2sgq54tyzf	SELECT /*+ FIRST_ROWS index(a ttdpur041730$idx4) */ a.t$amta, a.t$bqua, a.t$btsp, a.t$cact, a.t$ccco, a.t$ccty, a.t$cdis$1, a.t$cdis$2, a.t$cdis$3, a.t$citg, a.t$citt, a.t$clot, a.t$cntr, a.t$cono, a.t$cpla, a.t$cprj, a.t$csgp, a.t$cspa, a.t$cstl, a.t$ctrj, a.t$cupp, a.t$cuqp, a.t$cvat, a.t$cvpp, a.t$cvqp, a.t$cwar, a.t$ddta, a.t$ddtb, a.t$ddtc, a.t$ddtd, a.t$dim1, a.t$dim2, a.t$dim3, a.t$dim4, a.t$dim5, a.t$disc$1, a.t$disc$2, a.t$disc$3, a.t$dlev$1, a.t$dlev$2, a.t$dlev$3, a.t$dmth$1, a.t$dmth$2, a.t$dmth$3, a.t$dqua, a.t$item, a.t$ldam$1, a.t$ldam$2, a.t$ldam$3, a.t$leng, a.t$lsel, a.t$odat, a.t$opno, a.t$opol, a.t$oqua, a.t$orno, a.t$pacn, a.t$pdno, a.t$plev, a.t$pono, a.t$posi, a.t$pric, a.t$quad, a.t$qual, a.t$quap, a.t$revi, a.t$sdsc, a.t$sorn, a.t$spon, a.t$srvo, a.t$srvp, a.t$suno, a.t$thic, a.t$txta, a.t$typ1, a.t$typ2, a.t$typ3, a.t$typ4, a.t$typ5, a.t$widt FROM baan.ttdpur041730 a WHERE (a.t$suno >= :1) AND (a.t$suno <= :2) AND a.t$pdno = :3
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6jr1kw5bst173	INSERT INTO baan.ttipcs530730 (t$cprj, t$orno, t$kood, t$sitm, t$revs, t$citm, t$revc, t$swar, t$cwar, t$prjt, t$itmt, t$revt, t$wart, t$oqan, t$obqn, t$clot, t$pddt, t$pric, t$cpcp, t$osta, t$prts, t$trdt, t$cspa, t$cpla, t$cact, t$cstl, t$ccco, t$txta, t$Refcntd, t$Refcntu) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30)
6k7wy5k225ggv	SELECT /*+ FIRST_ROWS index(a ttppss975730$idx2) */ a.t$cprj, a.t$cspa, a.t$cuni, a.t$date, a.t$ddat, a.t$item, a.t$koor, a.t$kotr, a.t$orno, a.t$podt, a.t$pono, a.t$quan, a.t$reft, a.t$sern, a.t$srno, a.t$trdt FROM baan.ttppss975730 a WHERE a.t$cprj = :1 AND a.t$item = :2 AND a.t$orno = :3 AND a.t$pono = :4
6rmxgsachppwt	SELECT /*+ index(a ttcmcs001730$idx1) */ t$cuni FROM baan.ttcmcs001730 a WHERE t$cuni= :1
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
80m0b7sabmgxv	SELECT /*+ FIRST_ROWS index(a ttfgld410730$idx2) */ a.t$amnt, a.t$amth, a.t$btno, a.t$ccty, a.t$ccur, a.t$cpcp, a.t$cprj, a.t$crdt, a.t$crtm, a.t$crus, a.t$cuni, a.t$cuno, a.t$cvat, a.t$cwar, a.t$dbcr, a.t$dcdt, a.t$dim1, a.t$dim2, a.t$dim3, a.t$dim4, a.t$dim5, a.t$docn, a.t$fact, a.t$fcom, a.t$fitr, a.t$fprd, a.t$fyer, a.t$inpo, a.t$item, a.t$leac, a.t$line, a.t$lino, a.t$nper, a.t$nuni, a.t$ocom, a.t$orno, a.t$podt, a.t$pono, a.t$potm, a.t$pous, a.t$qty1, a.t$qty2, a.t$rate, a.t$refr, a.t$rprd, a.t$ryer, a.t$sern, a.t$sint, a.t$srno, a.t$suno, a.t$tmpk, a.t$trdt, a.t$tror, a.t$trtm, a.t$tsls, a.t$ttyp, a.t$vamh, a.t$vamt, a.t$vprd, a.t$vtyp, a.t$vyer FROM baan.ttfgld410730 a WHERE a.t$line = :1 AND a.t$ocom = :2 AND a.t$cprj = :3
86708bvah4akq	select name from undo$ where file#=:1 and block#=:2 and ts#=:3 and status$ != 1
91p43wcm8t04p	SELECT /*+ index(a ttcmcs002730$idx1) */ t$ccur FROM baan.ttcmcs002730 a WHERE t$ccur= :1
95mxk00npbhga	SELECT /*+ FIRST_ROWS index(a ttfgld004730$idx1) */ a.t$gcmp FROM baan.ttfgld004730 a WHERE a.t$gcmp != :1 AND a.t$srno = :2
9gmr63fpy7ntq	INSERT INTO baan.ttfgld418730 (t$ocom, t$tror, t$fitr, t$trdt, t$trtm, t$sern, t$line, t$ttyp, t$docn, t$fcom, t$orno, t$pono, t$cprj, t$prin, t$sint, t$lino, t$tmpk, t$Refcntd, t$Refcntu) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19)
adfb57ynjf1dp	SELECT /*+ FIRST_ROWS INDEX_DESC(b ttfcmg101730$idx1) */ b.t$amnt, b.t$amth, b.t$amti, b.t$bank, b.t$basu, b.t$blac, b.t$btno, b.t$ccur, b.t$comp, b.t$cvat, b.t$disa, b.t$dish, b.t$lapa, b.t$laph, b.t$ninv, b.t$oinv, b.t$otyp, b.t$padh, b.t$paym, b.t$pdam, b.t$pdat, b.t$pdoc, b.t$plan, b.t$post, b.t$ptyp, b.t$ragr, b.t$rate, b.t$ratf, b.t$reas, b.t$refr, b.t$scom, b.t$sort, b.t$srno, b.t$suno, b.t$tadv, b.t$ttyp, b.t$vata, b.t$vatc, c.t$badr, c.t$bank, c.t$bano, c.t$bldd, c.t$blpm, c.t$bnid, c.t$btyp, c.t$ccur, c.t$desc, c.t$dstb, c.t$gacc, c.t$iban, c.t$mcur, c.t$osrn, c.t$otyp, c.t$paeb, c.t$patb, c.t$prid, c.t$prip, c.t$pstb, c.t$swft, c.t$ttyp, d.t$desc, d.t$reas, e.t$alpm, e.t$auto, e.t$badr, e.t$bank, e.t$bodd, e.t$cact, e.t$ccur, e.t$cheq, e.t$clim, e.t$copt, e.t$desc, e.t$dev1, e.t$dev2, e.t$dnum, e.t$erpm, e.t$fctr, e.t$fcur, e.t$maxa, e.t$numb, e.t$odv1, e.t$pacu, e.t$paym, e.t$ps01, e.t$ps02, e.t$repa, e.t$rgr2, e.t$rgrp, e.t$rs01, e.t$rs02, e.t$rs03, e.t$sess, e.t$typp, e.t$uiba, f.t$cadr, f.t$ccty, f.t$ccur, f.t$city, f.t$clan, f.t$cmai, f.t$euro, f.t$geoc$l, f.t$nama, f.t$namb, f.t$namc, f.t$namd, f.t$name, f.t$namf, f.t$ncmp, f.t$pstc, f.t$tria, f.t$vath, f.t$vatl, f.t$vatn, g.t$buin, g.t$buor, g.t$cadr, g.t$cban, g.t$cbrn, g.t$ccon, g.t$ccor, g.t$ccrs, g.t$ccty, g.t$ccur, g.t$cdec, g.t$cfcc, g.t$cfsg, g.t$clan, g.t$comp, g.t$cotp, g.t$cpay, g.t$cplp, g.t$creg, g.t$cryr, g.t$ctit, g.t$cuno, g.t$cvyn, g.t$cwar, g.t$eded, g.t$fano, g.t$fovn, g.t$geoc$l, g.t$inrl, g.t$iscn, g.t$nama, g.t$namb, g.t$namc, g.t$namd, g.t$name, g.t$namf, g.t$ocus, g.t$odis, g.t$paym, g.t$pspr, g.t$pstc, g.t$pstx, g.t$qual, g.t$refa, g.t$refs, g.t$scus, g.t$seak, g.t$sndr, g.t$subc, g.t$suno, g.t$sust, g.t$tefx, g.t$telp, g.t$telx, g.t$tovr$1, g.t$tovr$2, g.t$tovr$3, g.t$tovr$4, g.t$tovr$5, g.t$txta FROM baan.ttfcmg101730 b, baan.ttfcmg001730 c, baan.ttfcmg002730 d, baan.ttfcmg003730 e, baan.ttccom000730 f, baan.ttccom020730 g WHERE (b.t$ttyp = :1 OR b.t$srno = :2) AND b.t$btno IN (SELECT a.t$btno FROM baan.ttfcmg109730 a WHERE a.t$stpp != :3 AND a.t$user = :4) AND g.t$suno (+) = b.t$suno AND f.t$ncmp (+) = b.t$comp AND e.t$paym (+) = b.t$paym AND d.t$reas (+) = b.t$reas AND c.t$bank (+) = b.t$bank AND (b.t$btno < :5) ORDER BY 7 DESC, 34 DESC, 9 DESC, 35 DESC, 36 DESC, 15 DESC, 33 DESC
ah6jc193yc3qr	SELECT /*+ FIRST_ROWS index(a ttfgld003730$idx1) */ a.t$bcmp, a.t$dhcu, a.t$dim1, a.t$dim2, a.t$dim3, a.t$dim4, a.t$dim5, a.t$mcst, a.t$nfpr, a.t$nrpr, a.t$nvpr, a.t$psep, a.t$rper, a.t$sdat, a.t$srno FROM baan.ttfgld003730 a WHERE a.t$srno = :1
b8xqray2x1xc1	SELECT /*+ index(a ttipcs021730$idx1) */ t$cprj, t$item, t$dsca, t$dscb, t$dscc, t$dscd, t$wght, t$seak, t$dfit, t$cpvr, t$opts, t$kitm, t$citg, t$csel, t$cvat, t$ltac, t$uset, t$cuni, t$stgu, t$cvsu, t$cwar, t$pslc, t$kltc, t$obpr, t$kpsl, t$npsl, t$stoc, t$blck, t$ordr, t$allo, t$hall, t$alpl, t$uscu, t$ltdt, t$aoqc, t$aoqa, t$uaoq, t$oltm, t$cpha, t$bfcp, t$bfep, t$bfhr, t$nnts, t$qpnt, t$runi, t$unom, t$scpf, t$tmps, t$ncst, t$nsfc, t$llcd, t$llci, t$cuqp, t$cvqp, t$cupp, t$cvpp, t$csgp, t$ccur, t$prip, t$ltpp, t$suno, t$qual, t$csgs, t$ccde, t$ctyo, t$cpcp, t$cpre, t$mtce, t$opce, t$ltcp, t$cpra, t$mtca, t$opca, t$buyr, t$cplb, t$eitm, t$umer, t$txta, t$ffsi, t$qbsi, t$lsid, t$Refcntd, t$Refcntu FROM baan.ttipcs021730 a WHERE t$cprj= :1 AND t$item= :2 FOR UPDATE WAIT 999
bsa0wjtftg3uw	select file# from file$ where ts#=:1
bwdc05jjwk143	SELECT /*+ FIRST_ROWS index(a ttppss610730$idx1) */ a.t$amoc, a.t$cact, a.t$ccco, a.t$ccur, a.t$cono, a.t$cpla, a.t$cprj, a.t$cspa, a.t$cstl, a.t$cupp, a.t$cuqp, a.t$disc, a.t$item, a.t$oqan, a.t$orno, a.t$osta, a.t$pddt, a.t$podt, a.t$posi, a.t$pric, a.t$suno, a.t$trdt, a.t$txta FROM baan.ttppss610730 a WHERE a.t$cprj = :1 AND a.t$orno = :2
cq82b3xwpxgb6	SELECT /*+ FIRST_ROWS index(a ttdpur041730$idx2) */ a.t$amta, a.t$bqua, a.t$btsp, a.t$cact, a.t$ccco, a.t$ccty, a.t$cdis$1, a.t$cdis$2, a.t$cdis$3, a.t$citg, a.t$citt, a.t$clot, a.t$cntr, a.t$cono, a.t$cpla, a.t$cprj, a.t$csgp, a.t$cspa, a.t$cstl, a.t$ctrj, a.t$cupp, a.t$cuqp, a.t$cvat, a.t$cvpp, a.t$cvqp, a.t$cwar, a.t$ddta, a.t$ddtb, a.t$ddtc, a.t$ddtd, a.t$dim1, a.t$dim2, a.t$dim3, a.t$dim4, a.t$dim5, a.t$disc$1, a.t$disc$2, a.t$disc$3, a.t$dlev$1, a.t$dlev$2, a.t$dlev$3, a.t$dmth$1, a.t$dmth$2, a.t$dmth$3, a.t$dqua, a.t$item, a.t$ldam$1, a.t$ldam$2, a.t$ldam$3, a.t$leng, a.t$lsel, a.t$odat, a.t$opno, a.t$opol, a.t$oqua, a.t$orno, a.t$pacn, a.t$pdno, a.t$plev, a.t$pono, a.t$posi, a.t$pric, a.t$quad, a.t$qual, a.t$quap, a.t$revi, a.t$sdsc, a.t$sorn, a.t$spon, a.t$srvo, a.t$srvp, a.t$suno, a.t$thic, a.t$txta, a.t$typ1, a.t$typ2, a.t$typ3, a.t$typ4, a.t$typ5, a.t$widt FROM baan.ttdpur041730 a WHERE a.t$cprj = :1 AND a.t$pdno = :2
djbg7dssthp2z	INSERT INTO baan.ttfacp965930 (t$ttyp, t$ninv, t$line, t$tdoc, t$docn, t$lino, t$cuno, t$docd, t$trec, t$ccur, t$amnt, t$amth, t$dued, t$leac, t$agan, t$ficu, t$balh, t$year, t$prod, t$btno, t$agn1, t$agn2, t$agn3, t$agn4, t$agn5, t$agn6, t$basd, t$desc, t$nama, t$namb, t$namc, t$namd, t$name, t$desf, t$amtr, t$baln, t$dbdt, t$dbti, t$creg, t$cfsg, t$cprj, t$orno, t$Refcntd, t$Refcntu) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44)
g8jy0py9qwwt4	INSERT INTO baan.ttpptc960730 (t$cprj, t$cspa, t$item, t$ccco, t$cstl, t$leng, t$widt, t$noun, t$quan, t$cuni, t$scpf, t$pric, t$pris, t$dfpc, t$stat, t$cpla, t$cact, t$snab, t$txta, t$Refcntd, t$Refcntu) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21)
gd05g7k4jxznx	SELECT /*+ index(a ttfgld018730$idx1) */ t$ttyp, t$docn, t$dcdt, t$year, t$btno, t$ccur, t$rate, t$ratf, t$ccty, t$vprd, t$vyer, t$stat, t$time, t$date, t$user, t$trun, t$free, t$modu, t$teyr, t$proc, t$prot, t$Refcntd, t$Refcntu FROM baan.ttfgld018730 a WHERE t$ttyp= :1 AND t$docn= :2 FOR UPDATE WAIT 999
gqngmkyfcky0g	INSERT INTO baan.ttipcs520730 (t$cprj, t$orno, t$item, t$oqan, t$cpla, t$podt, t$pddt, t$subc, t$suno, t$cuqp, t$cvqp, t$cupp, t$cvpp, t$ccur, t$pric, t$plev, t$disc$1, t$disc$2, t$disc$3, t$ldam$1, t$ldam$2, t$ldam$3, t$dlev$1, t$dlev$2, t$dlev$3, t$cdis$1, t$cdis$2, t$cdis$3, t$dmth$1, t$dmth$2, t$dmth$3, t$amnt, t$cono, t$posi, t$mdul, t$osta, t$trdt, t$txta, t$buyr, t$cplb, t$Refcntd, t$Refcntu) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• Tablespace IO Stats
• File IO Stats

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Top

Advisory Statistics

• Instance Recovery Stats
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin snapshot, E: End snapshot

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

• B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
• Auto PGA Target - actual workarea memory target
• W/A PGA Used - amount of memory used for all Workareas (manual + auto)
• %PGA W/A Mem - percentage of PGA memory allocated to workareas
• %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
• %Man W/A Mem - percentage of workarea memory under manual control

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
• Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Wait Statistics
Back to Top

Enqueue Activity

• only enqueues with waits are shown
• Enqueue stats gathered prior to 10g should not be compared with 10g data
• ordered by Wait Time desc, Waits desc

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

• Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
• STO - Snapshot Too Old count, OOS - Out of Space count
• Undo segment block stats:
• uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
• eS - expired Stolen, eR - expired Released, eU - expired reUsed

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

Back to Undo Statistics
Back to Top

Latch Statistics

• Latch Activity
• Latch Sleep Breakdown
• Latch Miss Sources
• Parent Latch Statistics
• Child Latch Statistics

Latch Activity

• "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

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

• ordered by misses desc

Back to Latch Statistics
Back to Top

Latch Miss Sources

• only latches with sleeps are shown
• ordered by name, sleeps desc

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

• Segments by Logical Reads
• Segments by Physical Reads
• Segments by Row Lock Waits
• Segments by ITL Waits
• Segments by Buffer Busy Waits

Segments by Logical Reads

• Total Logical Reads: 213,961,577
• Captured Segments account for 71.7% of Total

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 459,197
• Captured Segments account for 20.5% of Total

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

• % of Capture shows % of row lock waits for each top segment compared
• with total row lock waits for all segments captured by the Snapshot

Back to Segment Statistics
Back to Top

Segments by ITL Waits

• % of Capture shows % of ITL waits for each top segment compared
• with total ITL waits for all segments captured by the Snapshot

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

• % of Capture shows % of Buffer Busy Waits for each top segment compared
• with total Buffer Busy Waits for all segments captured by the Snapshot

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

• "Pct Misses" should be very low (< 2% in most cases)
• "Final Usage" is the number of cache entries being used

Back to Top

Library Cache Activity

• "Pct Misses" should be very low

Back to Top

Memory Statistics

• Process Memory Summary
• SGA Memory Summary
• SGA breakdown difference

Process Memory Summary

• B: Begin snap E: End snap
• All rows below contain absolute values (i.e. not diffed over the interval)
• Max Alloc is Maximum PGA Allocation size at snapshot time
• Hist Max Alloc is the Historical Max Allocation for still-connected processes
• ordered by Begin/End snapshot, Alloc (MB) desc

Back to Memory Statistics
Back to Top

SGA Memory Summary

Back to Memory Statistics
Back to Top

SGA breakdown difference

• ordered by Pool, Name
• N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Back to Memory Statistics
Back to Top

Streams Statistics

• Streams CPU/IO Usage
• Streams Capture
• Streams Apply
• Buffered Queues
• Buffered Subscribers
• Rule Set

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Back to Top

init.ora Parameters

Back to Top

End of Report