WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
HUOYING	1356268626	HUOYING	1	28-Oct-11 16:10	11.2.0.2.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dbserver6	Linux x86 64-bit	8	4	1	23.52

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	6896	23-Apr-12 00:30:05	537	5.6
End Snap:	6897	23-Apr-12 01:00:06	535	5.7
Elapsed:		30.02 (mins)
DB Time:		51.87 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	6,592M	6,592M	Std Block Size:	8K
Shared Pool Size:	1,024M	1,024M	Log Buffer:	44,616K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.7	0.0	0.00	0.00
DB CPU(s):	1.2	0.0	0.00	0.00
Redo size:	160,989.2	388.9
Logical reads:	768,223.3	1,855.6
Block changes:	962.7	2.3
Physical reads:	1,510.1	3.7
Physical writes:	372.7	0.9
User calls:	1,944.0	4.7
Parses:	74.3	0.2
Hard parses:	0.1	0.0
W/A MB processed:	6.3	0.0
Logons:	0.4	0.0
Executes:	2,054.7	5.0
Rollbacks:	389.2	0.9
Transactions:	414.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.92	Soft Parse %:	99.93
Execute to Parse %:	96.38	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	110.53	% Non-Parse CPU:	99.92

Shared Pool Statistics

	Begin	End
Memory Usage %:	75.91	76.14
% SQL with executions>1:	90.44	90.37
% Memory for SQL w/exec>1:	89.17	86.33

Top 5 Timed Foreground Events

Host CPU (CPUs: 8 Cores: 4 Sockets: 1)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.31	0.29	14.9	0.5	1.9	84.4

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
15.3	97.9	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	24,081.3	24,081.3
SGA use (MB):	8,000.0	8,000.0
PGA use (MB):	1,656.8	1,653.0
% Host Mem used for SGA+PGA:	40.10	40.09

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
• Shared Server Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 3112.2s
• 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

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 100.2% of Total DB time 3,112.16 (s)
• Total FG Wait Time: 940.15 (s) DB CPU time: 2,178.70 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

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 seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• 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
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 67.3% of Total DB Time (s): 3,112
• Captured PL/SQL account for 61.4% of Total DB Time (s): 3,112

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 - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 86.7% of Total CPU Time (s): 2,179
• Captured PL/SQL account for 79.1% of Total CPU Time (s): 2,179

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 80.1% of Total User I/O Wait Time (s): 221
• Captured PL/SQL account for 83.3% of Total User I/O Wait Time (s): 221

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 as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 1,383,637,748
• Captured SQL account for 99.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 2,719,888
• Captured SQL account for 99.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 72,842
• Captured SQL account for 46.8% of Total
• Total UnOptimized Read Requests: 72,842
• Captured SQL account for 46.8% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 3,700,721
• Captured SQL account for 70.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 133,892
• Captured SQL account for 91.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
02q3mut9fssmq	SELECT FUND_LOG_ID AS DETAIL_ID, USER_ID, RATING_ID, SUBJECT_ID, CHARGE_AMOUNT, CHARGE_TIME, RETRY_TIMES, GAME_ID FROM( SELECT FUND_LOG_ID, USER_ID, RATING_ID, SUBJECT_ID, CHARGE_AMOUNT, CHARGE_TIME, RETRY_TIMES, GAME_ID FROM SYS_USER_CHARGE_INFO WHERE RATING_ID = :B4 AND SUBJECT_ID = :B3 AND FUND_LOG_ID > :B2 AND GAME_ID = :B1 ORDER BY FUND_LOG_ID ) WHERE ROWNUM <= :B5
0a0wq7w9qaurr	MERGE INTO STAT_CEO_INFO_REGION T1 USING (SELECT TRUNC(:B1 ) AS STAT_DATE, GAME_ID, NVL(PROVINCE_CODE, '--') AS PROVINCE_CODE, NVL(CITY_CODE, '--') AS CITY_CODE, SUM(USER_ONLINE_COUNT) AS MAX_COUNT, :B1 AS MAX_COUNT_TIME, 0 AS AVG_COUNT FROM LOG_RT_USER_ONLINE_COUNT GROUP BY GAME_ID, ROLLUP(PROVINCE_CODE, CITY_CODE)) T2 ON (T1.GAME_ID = T2.GAME_ID AND T1.STAT_DATE = T2.STAT_DATE AND T1.PROVINCE_CODE = T2.PROVINCE_CODE AND T1.CITY_CODE = T2.CITY_CODE) WHEN MATCHED THEN UPDATE SET T1.MAX_COUNT = T2.MAX_COUNT, T1.MAX_COUNT_TIME = T2.MAX_COUNT_TIME WHERE T1.STAT_DATE = T2.STAT_DATE AND T1.PROVINCE_CODE = T2.PROVINCE_CODE AND T1.CITY_CODE = T2.CITY_CODE AND T1.MAX_COUNT < T2.MAX_COUNT AND T1.GAME_ID = T2.GAME_ID WHEN NOT MATCHED THEN INSERT VALUES (T2.STAT_DATE, T2.GAME_ID, T2.PROVINCE_CODE, T2.CITY_CODE, T2.MAX_COUNT, T2.MAX_COUNT_TIME, T2.AVG_COUNT)
0jmy1z5qqw47v	SELECT /*+ */ "A2"."GAME_ID", "A2"."USER_ID", "A2"."USER_NAME", "A2"."PASSWORD", "A2"."USER_TYPE", "A2"."GATEWAY_ID", "A2"."SERVER_ID", "A2"."USER_POINT", "A2"."USER_CLASS", "A2"."PROMOTER_ID", "A2"."BIRTHDAY", "A2"."ID_CODE", "A2"."ID_VERIFY_FLAG", "A2"."USER_FLAG", "A2"."USER_STATE", "A2"."AD_ID" FROM "ERATING_HYMX"."UMS_USER" "A2", (SELECT DISTINCT "A3"."GAME_ID" "GAME_ID", "A3"."USER_ID" "USER_ID" FROM "ERATING_HYMX"."MLOG$_UMS_USER" "A3" WHERE "A3"."SNAPTIME$$">:1 AND "A3"."DMLTYPE$$"<>'D') "A1" WHERE "A2"."GAME_ID"="A1"."GAME_ID" AND "A2"."USER_ID"="A1"."USER_ID"
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0p71tn1njkyf4	SELECT R.GAME_ID, R.USER_ID, MIN(ROLE_ID) FROM LOG_NEVER_ENTER_USERS F, LOG_ROLE_FIRST_LOGIN R WHERE R.GAME_ID = F.GAME_ID AND R.USER_ID = F.USER_ID AND R.LOG_ID >= :B2 AND R.LOG_ID < :B1 GROUP BY R.GAME_ID, R.USER_ID
0vkxcwgn7r98p	SELECT C.GATEWAY_ID, C.GATEWAY_CODE, C.GATEWAY_PASSWORD, C.GATEWAY_IP, C.GATEWAY_PORT, G.GATEWAY_NAME, G.GATEWAY_MAC, G.ZONE_ID, C.GATEWAY_TYPE, C.STATE FROM SYS_GATEWAY_SETTING C, SYS_GATEWAY G WHERE C.GATEWAY_ID = G.GATEWAY_ID AND C.STATE IN ( :B5 , :B4 , :B3 ) AND C.GATEWAY_TYPE = :B2 AND C.GAME_ID = G.GAME_ID AND G.GAME_ID = :B1 FOR UPDATE
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0xya4pu784gnk	SELECT NVL(PROMOTER_ID, 0), NVL(AD_ID, 0) FROM UMS_USER WHERE USER_ID = :B2 AND GAME_ID = :B1
1b7c5307wat14	SELECT COUNT(T.ACTIVITY_ID) FROM UMS_USER_ITEM T WHERE ( (GATEWAY_ID IN(SELECT SRC_GATEWAY_ID FROM SYS_GATEWAY_UNITE WHERE DEST_GATEWAY_ID = :B6 ))OR (GATEWAY_ID IN (:B6 , 0)) ) AND (USER_ID = :B5 ) AND (TRUNC(ACTIVITY_ID, -8) = TRUNC(:B4 , -8)) AND (ROLE_ID IN ( :B3 , 0) ) AND (ITEM_NUM > 0 ) AND (BEGIN_TIME <= :B2 ) AND (END_TIME > :B2 ) AND (GAME_ID = :B1 )
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
24h9v7jv3g280	SELECT GATEWAY_STATE FROM SYS_GATEWAY WHERE GATEWAY_ID = :B2 AND GAME_ID = :B1
2jfqzrxhrm93b	select /*+ rule */ 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#
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#
2skwhauh2cwky	select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
2whgymprzqt9g	UPDATE LOG_RECORD_DETAIL SET LOGOUT_TIME = :B3 , ROLE_LEVEL = :B2 , MONEY1 = 0, MONEY2 = 0, EXPERIENCE = 0 WHERE LOGIN_ID = :B1 RETURNING GATEWAY_ID, SERVER_ID, PROVINCE_CODE, CITY_CODE INTO :O0 , :O1 , :O2 , :O3
2x391bwzbmm3a	SELECT OPTION_VALUE FROM SYS_OPTION WHERE OPTION_CODE = :B2 AND GAME_ID = :B1
32cq1hgrt1r7d	INSERT INTO LOG_RECORD_DETAIL( LOGIN_ID, USER_ID, ROLE_ID, ROLE_LEVEL, MONEY1, MONEY2, EXPERIENCE, GATEWAY_ID, SERVER_ID, LOGIN_TIME, LOGOUT_TIME, LOGIN_IP, LOGIN_PORT, STAT_DATE, PROVINCE_CODE, CITY_CODE, MAC, HARDWARE_SN1, HARDWARE_SN2, GAME_ID ) VALUES( :B15 , :B14 , :B13 , :B12 , 0, 0, 0, :B11 , :B10 , :B7 , NULL, :B9 , :B8 , TRUNC(:B7 ), :B6 , :B5 , :B4 , UPPER(:B3 ), UPPER(:B2 ), :B1 )
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
3r70dwusbq7my	INSERT INTO UMS_USER_PURCHASE_DETAIL( PURCHASE_ID, USER_ID, ROLE_ID, ROLE_GENDER, ROLE_OCCUPATION, ROLE_LEVEL, RATING_ID, GATEWAY_ID, PACKAGE_ID, PRODUCT_ID, PRODUCT_USE_TYPE, PRODUCT_NUM, PURCHASE_IP, PURCHASE_TIME, SUBJECT_ID, COST_AMOUNT, PROMOTER_ID, EXPIRE_TIME, USE_USER_ID, USE_ROLE_ID, USE_TIME, PROVINCE_CODE, CITY_CODE, AD_ID, LOG_ID, PRODUCT_CODE, PRICE_ORIGIN, PRICE_DISCOUNT, LOG_TIME, GAME_ID ) VALUES( :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , 0, :B15 , :B14 , :B11 , :B13 , :B9 , :B12 , :B11 *:B3 , :B10 , :B9 + :B8 / 86400, 0, 0, NULL, '--', '--', :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
3w4qs0tbpmxr6	select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4phryfn5vrycw	begin :1 := PKG_ROLE.enterGameEx(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16);end;
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :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)
520mkxqpf15q8	select 1 from dual
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
60mwj5fxv4ur9	update tab$ set spare3 = :1, spare5 = :3 where obj# = :2
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#
6bnrfx89fuv7b	begin :1 := PKG_STAT.regionalonlineusercount; end;
6n2qxynkbu5u2	SELECT /*+ */ "A2"."GAME_ID", "A2"."ROLE_ID", "A2"."USER_ID", "A2"."ROLE_NAME", "A2"."GATEWAY_ID", "A2"."NATIONALITY_ID", "A2"."ROLE_GENDER", "A2"."ROLE_OCCUPATION", "A2"."ROLE_LEVEL", "A2"."ROLE_STATE", "A2"."CREATE_TIME", "A2"."DELETE_TIME", "A2"."LAST_LOGOUT_TIME", "A2"."TOTAL_ONLINE_SECOND", "A2"."LOGIN_ID", "A2"."MONEY1", "A2"."MONEY2", "A2"."EXPERIENCE", "A2"."AD_ID" FROM "ERATING_HYMX"."UMS_ROLE" "A2", (SELECT DISTINCT "A3"."GAME_ID" "GAME_ID", "A3"."ROLE_ID" "ROLE_ID" FROM "ERATING_HYMX"."MLOG$_UMS_ROLE" "A3" WHERE "A3"."SNAPTIME$$">:1 AND "A3"."DMLTYPE$$"<>'D') "A1" WHERE "A2"."GAME_ID"="A1"."GAME_ID" AND "A2"."ROLE_ID"="A1"."ROLE_ID"
74anujtt8zw4h	select o.owner#, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property, 0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o where d.p_obj#=:1 and (d.p_timestamp=nvl(:2, d.p_timestamp) or d.property=2) and o.owner#=nvl(:3, o.owner#) and d.d_obj#=o.obj# order by o.obj#
7d28212jkwcb6	begin :1 := PKG_GATEWAY.GWDataReport(:2, :3, :4, :5, :6);end;
7fa69cgtwscgb	begin :1 := PKG_STAT.regionalPCU; end;
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
85wj41g0yzmyn	begin :1 := PKG_IB.userIBPay(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21);end;
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
8f89bfp1zakz6	SELECT SID, REQUEST, BLOCK, LMODE, CTIME, a.TYPE || ': ' || b.name lock_type_name, REPLACE (b.id1_tag || ': ' || a.ID1, '|', '#') id1_value, b.id2_tag || ': ' || a.ID2 id2_value, b.description lock_type_description FROM v$lock a, v$lock_type b WHERE a.TYPE = b.TYPE(+) AND a.sid IN (SELECT DISTINCT sid FROM v$lock WHERE block = 1 OR request <> 0) ORDER BY 1
8g7pmmq74h1xx	SELECT COUNT (*) FROM v$lock WHERE block = 1 OR request <> 0
96g93hntrzjtr	select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9g273vqsd620y	UPDATE UMS_USER_FUND_SUMMARY SET TOTAL_EXCHANGE_OUT = TOTAL_EXCHANGE_OUT + :B5 WHERE (GAME_ID = :B4 ) AND (USER_ID = :B3 ) AND (RATING_ID = :B2 ) AND (SUBJECT_ID = :B1 )
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
9tjj8uhym6sdy	SELECT * FROM( SELECT T.ACTIVITY_ID, T.ITEM_CODE, T.ITEM_NUM, T.BEGIN_TIME, T.END_TIME, ROWNUM ROWNO FROM UMS_USER_ITEM T WHERE ( (GATEWAY_ID IN(SELECT SRC_GATEWAY_ID FROM SYS_GATEWAY_UNITE WHERE DEST_GATEWAY_ID = :B6 ))OR (GATEWAY_ID IN (:B6 , 0)) ) AND (USER_ID = :B5 ) AND (TRUNC(ACTIVITY_ID, -8) = TRUNC(:B4 , -8)) AND (ROLE_ID IN (:B3 , 0) ) AND (ITEM_NUM > 0 ) AND (BEGIN_TIME <= :B2 ) AND (END_TIME > :B2 ) AND (GAME_ID = :B1 ) ) WHERE ROWNO <= :B7
9z1aua1jnmzdn	INSERT INTO LOG_NEVER_ENTER_USERS ( USER_ID, GATEWAY_ID, AUTHEN_TIME, GAME_ID ) SELECT R.USER_ID, R.GATEWAY_ID, R.FIRST_LOGIN_TIME, R.GAME_ID FROM LOG_USER_FIRST_LOGIN_INFO R WHERE R.GAME_ID = :B2 AND R.USER_ID = :B1 AND R.LOG_ID >= :B4 AND R.LOG_ID < :B3
a9u0s3g93f47z	select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj#
ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
abu7n1wkuqn2f	begin :1 := PKG_CHECKBILL.GetChargeMsg(:2, :3, :4, :5, :6, :7); end;
ayswmjqa3f8vz	SELECT C.GATEWAY_ID, C.GATEWAY_CODE, C.GATEWAY_PASSWORD, C.GATEWAY_IP, C.GATEWAY_PORT, G.GATEWAY_NAME, G.GATEWAY_MAC, G.ZONE_ID, C.GATEWAY_TYPE, :B4 FROM SYS_GATEWAY_SETTING C, SYS_GATEWAY G WHERE C.GATEWAY_ID = G.GATEWAY_ID AND C.STATE IN ( :B5 , :B4 , :B3 ) AND C.GATEWAY_TYPE = :B2 AND C.GAME_ID = G.GAME_ID AND G.GAME_ID = :B1 FOR UPDATE
b0f2jmamqj8zc	begin :1 := PKG_ITEM.itemList(:2, :3, :4, :5, :6, :7, :8, :9, :10);end;
bs7ba268152fb	UPDATE LOG_USER_ONLINE_COUNT SET USER_ONLINE_COUNT = :B4 WHERE (GATEWAY_ID = :B3 ) AND (SERVER_ID = :B2 ) AND (GAME_ID = :B1 )
bxbnazjkww2kh	UPDATE UMS_USER SET PASSWORD = NVL(:B6 , '0'), ID_CODE = NVL(:B5 , :B2 ), USER_STATE = :B4 , BIRTHDAY = :B3 WHERE USER_ID = :B2 AND GAME_ID = :B1
ch8crpz8wsck0	SELECT T.PURCHASE_ID FROM UMS_USER_PURCHASE_DETAIL T WHERE T.PURCHASE_ID = :B2 AND T.GAME_ID = :B1
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
ct4y5m17hmghq	SELECT T.PRODUCT_ID, T.PRODUCT_USE_TYPE, T.PRODUCT_STATE, T.PRODUCT_PERIOD, T.EXPIRE_TIME FROM SYS_PRODUCT T WHERE T.PRODUCT_CODE = :B2 AND T.GAME_ID = :B1
dacrsgppcnkzq	SELECT T.MASK FROM UMS_USER_ACTIVITY_FLAG T WHERE T.USER_ID = :B3 AND T.GATEWAY_ID = :B2 AND T.GAME_ID = :B1 FOR UPDATE
dhngh6vsddfrb	SELECT T.ACTIVITY_ID, T.ACTIVITY_TYPE, T.FLAG_BIT, T.GIFT_BEGIN_TIME, T.EFFECT_PERIOD, T.ROLE_BEGIN_TIME, T.ROLE_END_TIME, T.BEGIN_TIME, T.END_TIME, T.MASK FROM SYS_ACTIVITY_INFO T WHERE (T.BEGIN_TIME <= :B6 ) AND (T.END_TIME > :B6 ) AND (T.ACTIVITY_STATE = 1 ) AND (T.GAME_ID = :B5 ) AND (T.ACTIVITY_TYPE NOT IN ( :B4 , :B3 , :B2 , :B1 ) )
druk61dn87x31	SELECT R.GAME_ID, R.USER_ID, MIN(ROLE_ID) FROM LOG_USER_FIRST_LOGIN_INFO F, LOG_ROLE_FIRST_LOGIN R WHERE R.GAME_ID = F.GAME_ID AND R.USER_ID = F.USER_ID AND R.LOG_ID >= :B4 AND R.LOG_ID < :B3 AND F.LOG_ID >= :B2 AND F.LOG_ID < :B1 GROUP BY R.GAME_ID, R.USER_ID
f39vadk8t9ttx	begin :1 := PKG_ROLE.leaveGame(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14);end;
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
g4gfjqqsnxm60	UPDATE LOG_RECORD_DETAIL SET LOGOUT_TIME = :B1 , ROLE_LEVEL = :B6 , MONEY1 = :B5 , MONEY2 = :B4 , EXPERIENCE = :B3 WHERE LOGIN_ID = :B2 RETURNING SERVER_ID, (:B1 - LOGIN_TIME) * 86400, LOGIN_IP, PROVINCE_CODE, CITY_CODE INTO :O0 , :O1 , :O2 , :O3 , :O4
g78rxycd3wtqu	begin :1 := PKG_JOINT.JointAuthen(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17);end;
gx4mv66pvj3xz	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1
gzrqbw9tk645c	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN declare v_temp integer; begin v_temp := PKG_STAT.getFirstRole(null); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

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

• Ordered by statistic name

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

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

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

• Buffer Pool Statistics
• Checkpoint Activity

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 Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 671,254

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

• Instance Recovery Stats
• MTTR Advisory
• 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

MTTR Advisory

No data exists for this section of the report.

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

No data exists for this section of the report.

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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
• Mutex Sleep Summary
• 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