Using the report name awrrpt_1_20298_20309.html AWR Report

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

UNSPAY 254218744 unspay 1 10.2.0.1.0 NO unspay

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
UNSPAY	254218744	unspay	1	10.2.0.1.0	NO	unspay

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 20298 21-Apr-13 22:00:10 125 1.1

End Snap: 20309 22-Apr-13 09:00:27 125 .3

Elapsed: 660.28 (mins)

DB Time: 47.03 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	20298	21-Apr-13 22:00:10	125	1.1
End Snap:	20309	22-Apr-13 09:00:27	125	.3
Elapsed:		660.28 (mins)
DB Time:		47.03 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,312M 1,312M Std Block Size: 8K

Shared Pool Size: 160M 160M Log Buffer: 15,192K

	Begin	End
Buffer Cache:	1,312M	1,312M	Std Block Size:	8K
Shared Pool Size:	160M	160M	Log Buffer:	15,192K

Load Profile

Per Second Per Transaction

Redo size: 1,266.79 48,630.17

Logical reads: 5,419.85 208,059.96

Block changes: 7.85 301.34

Physical reads: 5.75 220.79

Physical writes: 0.35 13.33

User calls: 89.87 3,449.98

Parses: 17.72 680.35

Hard parses: 0.06 2.24

Sorts: 1.53 58.68

Logons: 0.15 5.66

Executes: 20.26 777.56

Transactions: 0.03

	Per Second	Per Transaction
Redo size:	1,266.79	48,630.17
Logical reads:	5,419.85	208,059.96
Block changes:	7.85	301.34
Physical reads:	5.75	220.79
Physical writes:	0.35	13.33
User calls:	89.87	3,449.98
Parses:	17.72	680.35
Hard parses:	0.06	2.24
Sorts:	1.53	58.68
Logons:	0.15	5.66
Executes:	20.26	777.56
Transactions:	0.03

% Blocks changed per Read: 0.14 Recursive Call %: 20.64

Rollback per transaction %: 0.00 Rows per Sort: 54.49

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

Buffer Hit %: 99.94 In-memory Sort %: 100.00

Library Hit %: 99.33 Soft Parse %: 99.67

Execute to Parse %: 12.50 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 57.46 % Non-Parse CPU: 99.30

Shared Pool Statistics

Begin End

Memory Usage %: 76.22 77.45

% SQL with executions>1: 85.09 63.35

% Memory for SQL w/exec>1: 87.44 80.19

	Begin	End
Memory Usage %:	76.22	77.45
% SQL with executions>1:	85.09	63.35
% Memory for SQL w/exec>1:	87.44	80.19

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 2,647 93.8

control file parallel write 13,291 554 42 19.6 System I/O

RMAN backup & recovery I/O 19,227 217 11 7.7 System I/O

db file parallel write 5,275 50 9 1.8 System I/O

SQL*Net more data from client 244,054 47 0 1.7 Network

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		2,647		93.8
control file parallel write	13,291	554	42	19.6	System I/O
RMAN backup & recovery I/O	19,227	217	11	7.7	System I/O
db file parallel write	5,275	50	9	1.8	System I/O
SQL*Net more data from client	244,054	47	0	1.7	Network

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

Time Model Statistics

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

Statistic Name	Time (s)	% of DB Time
DB CPU	2,646.52	93.80
sql execute elapsed time	2,571.81	91.15
parse time elapsed	42.60	1.51
connection management call elapsed time	28.50	1.01
hard parse elapsed time	18.64	0.66
inbound PL/SQL rpc elapsed time	9.18	0.33
PL/SQL execution elapsed time	7.22	0.26
RMAN cpu time (backup/restore)	2.71	0.10
Java execution elapsed time	2.40	0.09
sequence load elapsed time	1.57	0.06
PL/SQL compilation elapsed time	0.95	0.03
hard parse (sharing criteria) elapsed time	0.14	0.00
repeated bind elapsed time	0.11	0.00
hard parse (bind mismatch) elapsed time	0.03	0.00
DB time	2,821.55
background elapsed time	981.67
background cpu time	61.60

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
System I/O	97,086	0.00	898	9	94.08
User I/O	89,594	0.00	100	1	86.82
Network	4,270,091	0.00	67	0	4,137.69
Commit	2,017	0.00	21	10	1.95
Concurrency	159	0.00	3	22	0.15
Other	153	0.00	2	12	0.15
Configuration	2	50.00	1	492	0.00
Administrative	2	0.00	0	221	0.00
Application	96	0.00	0	0	0.09

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)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
control file parallel write	13,291	0.00	554	42	12.88
RMAN backup & recovery I/O	19,227	0.00	217	11	18.63
db file parallel write	5,275	0.00	50	9	5.11
SQL*Net more data from client	244,054	0.00	47	0	236.49
log file parallel write	3,172	0.00	43	13	3.07
db file sequential read	18,962	0.00	42	2	18.37
read by other session	8,855	0.00	31	4	8.58
control file sequential read	55,916	0.00	28	0	54.18
db file scattered read	14,644	0.00	27	2	14.19
log file sync	2,017	0.00	21	10	1.95
SQL*Net more data to client	972,800	0.00	17	0	942.64
SQL*Net message to client	3,053,237	0.00	4	0	2,958.56
Log archive I/O	77	0.00	3	34	0.07
log file sequential read	84	0.00	2	29	0.08
latch: cache buffers chains	36	0.00	2	54	0.03
os thread startup	46	0.00	2	33	0.04
latch free	63	0.00	1	17	0.06
log buffer space	2	50.00	1	492	0.00
control file single write	40	0.00	1	22	0.04
enq: TC - contention	2	0.00	1	278	0.00
switch logfile command	2	0.00	0	221	0.00
recovery area: computing obsolete files	3	0.00	0	72	0.00
direct path read	47,097	0.00	0	0	45.64
db file single write	5	0.00	0	11	0.00
enq: CF - contention	4	0.00	0	11	0.00
log file single write	4	0.00	0	9	0.00
direct path write	31	0.00	0	1	0.03
latch: session allocation	6	0.00	0	5	0.01
latch: library cache	64	0.00	0	0	0.06
recovery area: computing identical files	3	0.00	0	2	0.00
SQL*Net break/reset to client	96	0.00	0	0	0.09
LGWR wait for redo copy	61	0.00	0	0	0.06
recovery area: computing applied logs	3	0.00	0	0	0.00
recovery area: computing backed up files	3	0.00	0	0	0.00
recovery area: computing dropped files	3	0.00	0	0	0.00
latch: shared pool	13	0.00	0	0	0.01
rdbms ipc reply	2	0.00	0	0	0.00
SQL*Net message from client	3,053,237	0.00	3,969,993	1300	2,958.56
Streams AQ: qmn slave idle wait	1,413	0.00	38,546	27280	1.37
Streams AQ: qmn coordinator idle wait	2,842	50.28	38,546	13563	2.75
virtual circuit status	1,320	100.00	38,527	29187	1.28
Streams AQ: waiting for time management or cleanup tasks	10	100.00	4,694	469391	0.01
jobq slave wait	452	99.78	1,324	2930	0.44
class slave wait	16	100.00	78	4882	0.02
SGA: MMAN sleep for component shrink	23	17.39	0	4	0.02

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
control file parallel write	13,063	0.00	549	42	12.66
db file parallel write	5,275	0.00	50	9	5.11
log file parallel write	3,173	0.00	43	13	3.07
control file sequential read	11,357	0.00	15	1	11.00
os thread startup	46	0.00	2	33	0.04
db file sequential read	1,719	0.00	1	0	1.67
log file sync	2	0.00	0	20	0.00
events in waitclass Other	65	0.00	0	1	0.06
log file single write	4	0.00	0	9	0.00
direct path write	5	0.00	0	7	0.00
log file sequential read	9	0.00	0	2	0.01
direct path read	5	0.00	0	0	0.00
rdbms ipc message	130,067	97.95	414,575	3187	126.03
pmon timer	13,850	100.00	38,668	2792	13.42
Streams AQ: qmn slave idle wait	1,413	0.00	38,546	27280	1.37
Streams AQ: qmn coordinator idle wait	2,842	50.28	38,546	13563	2.75
smon timer	133	98.50	37,096	278915	0.13
Streams AQ: waiting for time management or cleanup tasks	10	100.00	4,694	469391	0.01
SGA: MMAN sleep for component shrink	23	17.39	0	4	0.02

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	280,469
IDLE_TIME	7,559,022
NICE_TIME	8
SYS_TIME	28,912
USER_TIME	251,549
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	730,840
NUM_CPUS	2

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	2,637.40	2,517.10	20,230	211,941,879
unspay	184.20	129.40	201,259	2,250,070
SYS$BACKGROUND	0.00	0.00	6,377	523,781
unspayXDB	0.00	0.00	0	0

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)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	18912	5295	90	195	2	44	1968975	5720
unspay	64384	3291	22	1	0	0	2278059	999
SYS$BACKGROUND	6299	1461	47	154	0	0	0	0

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
2,337	2,266	3,600	0.65	82.84	5712nr1b46uuu		select transactio0_.ID as ID18...
18	18	115,610	0.00	0.65	f7vq3cngfzx4g		select account0_.ID as ID17_3_...
17	17	11	1.55	0.61	bunssq950snhf		insert into wrh$_sga_target_ad...
14	14	167,144	0.00	0.51	csfrmw47298yt		select childprodu0_.PARENT as ...
13	13	115,606	0.00	0.45	7c78dfacskv69		select subaccount0_.ID as ID28...
10	6	1	9.53	0.34	165tjwc317ksz		select t.trans_id, t.amount as...
8	4	1	7.90	0.28	299gaqtz96qfy	MMON_SLAVE	delete from WRI$_SEGADV_OBJLIS...
7	7	115,528	0.00	0.24	8szzyjdgh5qy3		select accountrna0_.ACCOUNT_SE...
6	0	2	2.95	0.21	03amf67aqhjfw	rman@unspay (TNS V1-V3)	alter system archive log curre...
5	0	1	5.40	0.19	42ts6pukwt3pu		select count(*) as col_0_0_ fr...

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
2,266	2,337	3,600	0.63	82.84	5712nr1b46uuu		select transactio0_.ID as ID18...
18	18	115,610	0.00	0.65	f7vq3cngfzx4g		select account0_.ID as ID17_3_...
17	17	11	1.54	0.61	bunssq950snhf		insert into wrh$_sga_target_ad...
14	14	167,144	0.00	0.51	csfrmw47298yt		select childprodu0_.PARENT as ...
13	13	115,606	0.00	0.45	7c78dfacskv69		select subaccount0_.ID as ID28...
7	7	115,528	0.00	0.24	8szzyjdgh5qy3		select accountrna0_.ACCOUNT_SE...
6	10	1	6.25	0.34	165tjwc317ksz		select t.trans_id, t.amount as...
5	5	5,808	0.00	0.19	0k8522rmdzg4k		select privilege# from sysauth...
4	8	1	3.97	0.28	299gaqtz96qfy	MMON_SLAVE	delete from WRI$_SEGADV_OBJLIS...
4	4	18,074	0.00	0.14	0h6b2sajwb74n		select privilege#, level from ...

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: 214,717,876
Captured SQL account for 99.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
207,601,339	3,600	57,667.04	96.69	2266.31	2337.42	5712nr1b46uuu		select transactio0_.ID as ID18...
1,170,008	167,144	7.00	0.54	14.48	14.48	csfrmw47298yt		select childprodu0_.PARENT as ...
1,040,454	115,606	9.00	0.48	12.64	12.78	7c78dfacskv69		select subaccount0_.ID as ID28...
462,440	115,610	4.00	0.22	18.42	18.42	f7vq3cngfzx4g		select account0_.ID as ID17_3_...
140,747	115,528	1.22	0.07	6.88	6.88	8szzyjdgh5qy3		select accountrna0_.ACCOUNT_SE...
90,303	18,029	5.01	0.04	1.22	1.22	95nvamhj37kmz	exp@rmandb (TNS V1-V3)	SELECT NAMESPACE, ATTRIBUTE ...
90,255	18,029	5.01	0.04	1.10	1.10	fj695q4p2ysg2	exp@rmandb (TNS V1-V3)	SELECT POLGRP FROM SYS....
88,630	119	744.79	0.04	1.15	1.30	aha2u0n7zp2ur		select * from ( select transac...
77,798	19,440	4.00	0.04	0.63	0.63	4z6jfdhm5uxr7	exp@rmandb (TNS V1-V3)	select longname from javasnm$ ...
77,727	1	77,727.00	0.04	6.25	9.53	165tjwc317ksz		select t.trans_id, t.amount as...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 227,856
Captured SQL account for 11.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
12,944	1	12,944.00	5.68	6.25	9.53	165tjwc317ksz	select t.trans_id, t.amount as...
2,850	3,600	0.79	1.25	2266.31	2337.42	5712nr1b46uuu	select transactio0_.ID as ID18...
2,553	1	2,553.00	1.12	0.37	5.40	42ts6pukwt3pu	select count(*) as col_0_0_ fr...
1,656	1	1,656.00	0.73	0.04	0.73	b7jn4mf49n569	select o.name, u.name from ob...
1,023	1	1,023.00	0.45	0.40	1.75	b3ys9bs1v9cch	delete from WRH$_SYSMETRIC_SUM...
738	19	38.84	0.32	0.08	1.96	14v5zufhsv6pj	select acctbalhis0_.BALANCE as...
596	170	3.51	0.26	1.03	3.16	4zzjwu4x3rcyr	select count(*) as count from ...
533	1	533.00	0.23	0.19	0.97	4ng4xn7jw3dbb	delete from WRH$_ENQUEUE_STAT ...
441	1	441.00	0.19	0.22	1.98	c2p32r5mzv8hb	BEGIN prvt_advisor.delete_e...
353	406	0.87	0.15	0.31	0.43	cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_id...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 802,442
Captured SQL account for 89.7% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
167,144	164,346	0.98	csfrmw47298yt		select childprodu0_.PARENT as ...
115,610	115,610	1.00	f7vq3cngfzx4g		select account0_.ID as ID17_3_...
115,606	115,606	1.00	7c78dfacskv69		select subaccount0_.ID as ID28...
115,528	25,219	0.22	8szzyjdgh5qy3		select accountrna0_.ACCOUNT_SE...
21,613	21,613	1.00	a1as9muhfawcx		select actiontype0_.ID as ID19...
19,440	19,440	1.00	4z6jfdhm5uxr7	exp@rmandb (TNS V1-V3)	select longname from javasnm$ ...
18,376	0	0.00	7fprcxd5040cz	exp@rmandb (TNS V1-V3)	SELECT POLGRP, POLICY, POLOW...
18,074	1,128	0.06	0h6b2sajwb74n		select privilege#, level from ...
18,029	0	0.00	95nvamhj37kmz	exp@rmandb (TNS V1-V3)	SELECT NAMESPACE, ATTRIBUTE ...
18,029	0	0.00	fj695q4p2ysg2	exp@rmandb (TNS V1-V3)	SELECT POLGRP FROM SYS....

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 702,118
Captured SQL account for 91.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
167,144	167,144	23.81	csfrmw47298yt		select childprodu0_.PARENT as ...
115,610	115,610	16.47	f7vq3cngfzx4g		select account0_.ID as ID17_3_...
115,606	115,606	16.47	7c78dfacskv69		select subaccount0_.ID as ID28...
115,528	115,528	16.45	8szzyjdgh5qy3		select accountrna0_.ACCOUNT_SE...
21,613	21,613	3.08	a1as9muhfawcx		select actiontype0_.ID as ID19...
18,376	18,376	2.62	7fprcxd5040cz	exp@rmandb (TNS V1-V3)	SELECT POLGRP, POLICY, POLOW...
18,074	18,074	2.57	0h6b2sajwb74n		select privilege#, level from ...
7,270	7,270	1.04	d33wr2f2d9qk9		select productcla0_.ID as ID97...
5,808	5,808	0.83	0k8522rmdzg4k		select privilege# from sysauth...
5,510	5,510	0.78	84ab4hmg8u6dm		ALTER SESSION SET TIME_ZONE='+...

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

03amf67aqhjfw alter system archive log current

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

14v5zufhsv6pj select acctbalhis0_.BALANCE as col_0_0_ from ACCT_BAL_HIS acctbalhis0_, SUB_ACCOUNT subaccount1_ where acctbalhis0_.SUB_ACCT_SEQ=subaccount1_.ID and subaccount1_.ID=:1 and subaccount1_.SUB_ACCOUNT_TYPE='0' and subaccount1_.VALID_FLAG='Y' and acctbalhis0_.ID=(select max(acctbalhis2_.ID) from ACCT_BAL_HIS acctbalhis2_ where acctbalhis2_.SUB_ACCT_SEQ=:2 and acctbalhis2_.UPDATE_TIME<=:3) order by acctbalhis0_.UPDATE_TIME desc

165tjwc317ksz select t.trans_id, t.amount as trans_amount, t.credit_fee, t.debit_fee, incorrect.sub_acct_seq, incorrect.id as abh_seq, incorrect.amount, incorrect.fee, incorrect.flag, incorrect.balance, incorrect.begin_balance from (select t.sub_acct_seq, t.amount, t.lock_amount, t.fee, t.flag, t.balance, t.id, t.update_time, trans_id, sum(t.balance)over(partition by t.sub_acct_seq order by t.id asc rows between 1 preceding and 0 following)-t.balance begin_balance from acct_bal_his t where t.sub_acct_seq not in (1, 2, 3, 4, 5, 6, 7, 8, 9) group by t.sub_acct_seq, t.amount, t.lock_amount, t.fee, t.flag, t.balance, t.id, t.update_time, trans_id order by t.sub_acct_seq asc, id asc ) incorrect, transaction t where t.trans_id = incorrect.trans_id and incorrect.begin_balance + (incorrect.flag * incorrect.amount)-fee != balance and incorrect.update_time >= to_date('2013-04-21 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and incorrect.update_time <= to_date('2013-04-21 23:59:59', 'yyyy-mm-dd hh24:mi:ss') order by incorrect.id desc

299gaqtz96qfy delete from WRI$_SEGADV_OBJLIST where creation_time < :1

42ts6pukwt3pu select count(*) as col_0_0_ from TRANSACTION transactio0_ where transactio0_.TRANS_STATUS=:1 and transactio0_.AUDIT_TRANS=:2 and (transactio0_.ACTION_SEQ in (4 , 7)) and transactio0_.AMOUNT>0 and (transactio0_.TRANS_ID not in (select adjustrequ1_.TRANSACTIONCODE from ADJUSTREQUSITION adjustrequ1_ where adjustrequ1_.APPLYSTATE<>5 and adjustrequ1_.APPLYSTATE<>4 and (adjustrequ1_.TRANSACTIONCODE is not null)))

4ng4xn7jw3dbb delete from WRH$_ENQUEUE_STAT tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))

4z6jfdhm5uxr7 select longname from javasnm$ where short = :1

4zzjwu4x3rcyr select count(*) as count from ( select trans.credit_seq, trans.debit_fee, trans.credit_fee, trans.action_seq, trans.RELATING_SEQ, trans.order_id, trans.order_url, trans.trans_id, sb.list_name as status, trans.begin_date, trans.update_time, trans.amount, sb1.list_name as trade, trans.id, trans.bank_seq, trans.downloadstate, trans.commodity_info, case when trans.debit_seq in (:1) then trans.credit_seq when trans.credit_seq in (:2) then trans.debit_seq end as offsize , case when trans.debit_seq in (:3) then '0' when trans.credit_seq in (:4) then '1' end as comeorgo, trans.trans_status, case when trans.debit_seq in (:5) then trans.debit_seq when trans.credit_seq in (:6) then trans.credit_seq end as selfsize from transaction trans left join sysbook sb on sb.type_id='TRANS_STATUS' and trans.trans_status = sb.list_id left join sysbook sb1 on sb1.type_id='TRADE_TYPE' and trans.trade_type= sb1.list_id where 1=1 and trans.action_seq != 25 and trans.trans_status in (:7, :8, :9, :10, :11, :12) and 1= (case when trans.credit_seq in (:13) and trans.trans_status = 0 then 0 else 1 end) and (trans.debit_seq in (:14) or trans.credit_seq in (:15)) ) v_t left join sub_account sub_1 on sub_1.id = v_t.selfsize , account acc, sub_account sa where sa.main_account_seq = acc.id and sa.id = v_t.offsize order by v_t.id desc, v_t.begin_date desc

5712nr1b46uuu select transactio0_.ID as ID18_, transactio0_.ACTION_SEQ as ACTION2_18_, transactio0_.CREDIT_RATIO_SEQ as CREDIT3_18_, transactio0_.DEBIT_RATIO_SEQ as DEBIT4_18_, transactio0_.DEBIT_SEQ as DEBIT5_18_, transactio0_.CREDIT_SEQ as CREDIT6_18_, transactio0_.ORDER_ID as ORDER7_18_, transactio0_.SERVICE_FLAG as SERVICE8_18_, transactio0_.SERVICE_DATE as SERVICE9_18_, transactio0_.SERVICE_PERSON as SERVICE10_18_, transactio0_.AMOUNT as AMOUNT18_, transactio0_.CURRENCY as CURRENCY18_, transactio0_.EXCHANGE_RATE as EXCHANGE13_18_, transactio0_.REVERSE_FLAG as REVERSE14_18_, transactio0_.RELATING_SEQ as RELATING15_18_, transactio0_.TRANS_ID as TRANS16_18_, transactio0_.TRANS_STATUS as TRANS17_18_, transactio0_.BEGIN_DATE as BEGIN18_18_, transactio0_.END_DATE as END19_18_, transactio0_.DEBIT_FEE as DEBIT20_18_, transactio0_.CREDIT_FEE as CREDIT21_18_, transactio0_.SELLER_URL as SELLER22_18_, transactio0_.OPER_SOURCE as OPER23_18_, transactio0_.COMMODITY_INFO as COMMODITY24_18_, transactio0_.SELLER_PARAM as SELLER25_18_, transactio0_.DES_FLAG as DES26_18_, transactio0_.MAC as MAC18_, transactio0_.VERSION as VERSION18_, transactio0_.CREATE_USER as CREATE29_18_, transactio0_.CREATE_TIME as CREATE30_18_, transactio0_.UPDATE_USER as UPDATE31_18_, transactio0_.UPDATE_USER_SYSTEM as UPDATE32_18_, transactio0_.UPDATE_TIME as UPDATE33_18_, transactio0_.TRADE_TYPE as TRADE34_18_, transactio0_.BANK_SEQ as BANK35_18_, transactio0_.CARD_NO as CARD36_18_, transacti o0_.BANK_NAME as BANK37_18_, transactio0_.BANK_PROV_SEQ as BANK38_18_, transactio0_.BANK_CITY_SEQ as BANK39_18_, transactio0_.PERSON_NAME as PERSON40_18_, transactio0_.PERSON_MAIL as PERSON41_18_, transactio0_.PERSON_PHONE as PERSON42_18_, transactio0_.PERSON_MOBILE as PERSON43_18_, transactio0_.REMARK as REMARK18_, transactio0_.ACCOUNT_BANK_SEQ as ACCOUNT45_18_, transactio0_.VERIFY_CODE as VERIFY46_18_, transactio0_.BARCODE as BARCODE18_, transactio0_.AUDIT_TRANS as AUDIT48_18_, transactio0_.encryptCode as encrypt49_18_, transactio0_.PURPOSE as PURPOSE18_, transactio0_.INSIDE_STATUS as INSIDE51_18_, transactio0_.BANK_RESPONSE as BANK52_18_, transactio0_.DOWNLOADSTATE as DOWNLOA53_18_, transactio0_.OPERATOR_SEQ as OPERATOR54_18_, transactio0_.BANK_INFO_SEQ as BANK55_18_, transactio0_.VOUCHER_CODE as VOUCHER56_18_, transactio0_.VNV_ACCOUNT_ID as VNV57_18_, transactio0_.BATCH_NO as BATCH58_18_ from TRANSACTION transactio0_ where transactio0_.END_DATE>=:1 and transactio0_.END_DATE<=:2 and transactio0_.ACTION_SEQ<>5

7c78dfacskv69 select subaccount0_.ID as ID28_2_, subaccount0_.VERSION as VERSION28_2_, subaccount0_.MAIN_ACCOUNT_SEQ as MAIN3_28_2_, subaccount0_.ACCOUNT_BANK as ACCOUNT4_28_2_, subaccount0_.ACCOUNT_MONEY_TYPE as ACCOUNT5_28_2_, subaccount0_.VALID_FLAG as VALID6_28_2_, subaccount0_.ACCOUNT_ID as ACCOUNT7_28_2_, subaccount0_.ACCOUNT_NAME as ACCOUNT8_28_2_, subaccount0_.SUP_ACCOUNT_ID as SUP9_28_2_, subaccount0_.SUB_ACCOUNT_TYPE as SUB10_28_2_, subaccount0_.INSIDE_ID as INSIDE11_28_2_, subaccount0_.ACCOUNT_LEVEL as ACCOUNT12_28_2_, subaccount0_.REMARK as REMARK28_2_, subaccount0_.LIST_SEQ as LIST14_28_2_, subaccount0_.CREATE_USER as CREATE15_28_2_, subaccount0_.CREATE_TIME as CREATE16_28_2_, subaccount0_.UPDATE_USER as UPDATE17_28_2_, subaccount0_.UPDATE_TIME as UPDATE18_28_2_, subaccount0_.IVR_FLAG as IVR19_28_2_, subaccount0_.detail_flag as detail20_28_2_, accountbal1_.ID as ID23_0_, accountbal1_.VERSION as VERSION23_0_, accountbal1_.BALANCE as BALANCE23_0_, accountbal1_.LOCK_AMOUNT as LOCK4_23_0_, accountbal1_.CREATE_USER as CREATE5_23_0_, accountbal1_.CREATE_TIME as CREATE6_23_0_, accountbal1_.UPDATE_USER as UPDATE7_23_0_, accountbal1_.UPDATE_TIME as UPDATE8_23_0_, accountbal1_.accumulation as accumula9_23_0_, accountbal1_.BANKROLL_UPDATE_TIME as BANKROLL10_23_0_, accountbal1_.encryptCode as encrypt11_23_0_, subaccount2_.ID as ID28_1_, subaccount2_.VERSION as VERSION28_1_, subaccount2_.MAIN_ACCOUNT_SEQ as MAIN3_28_1_, subaccount2_.ACCOUNT_BANK as ACCOUNT 4_28_1_, subaccount2_.ACCOUNT_MONEY_TYPE as ACCOUNT5_28_1_, subaccount2_.VALID_FLAG as VALID6_28_1_, subaccount2_.ACCOUNT_ID as ACCOUNT7_28_1_, subaccount2_.ACCOUNT_NAME as ACCOUNT8_28_1_, subaccount2_.SUP_ACCOUNT_ID as SUP9_28_1_, subaccount2_.SUB_ACCOUNT_TYPE as SUB10_28_1_, subaccount2_.INSIDE_ID as INSIDE11_28_1_, subaccount2_.ACCOUNT_LEVEL as ACCOUNT12_28_1_, subaccount2_.REMARK as REMARK28_1_, subaccount2_.LIST_SEQ as LIST14_28_1_, subaccount2_.CREATE_USER as CREATE15_28_1_, subaccount2_.CREATE_TIME as CREATE16_28_1_, subaccount2_.UPDATE_USER as UPDATE17_28_1_, subaccount2_.UPDATE_TIME as UPDATE18_28_1_, subaccount2_.IVR_FLAG as IVR19_28_1_, subaccount2_.detail_flag as detail20_28_1_ from SUB_ACCOUNT subaccount0_, ACCOUNT_BALANCE accountbal1_, SUB_ACCOUNT subaccount2_ where subaccount0_.ID=accountbal1_.ID(+) and accountbal1_.ID=subaccount2_.ID(+) and subaccount0_.ID=:1

7fprcxd5040cz SELECT POLGRP, POLICY, POLOWN, POLSCH, POLFUN, STMT, CHKOPT, ENABLED, SPOLICY FROM SYS.EXU9RLS WHERE OBJOWN = :1 AND OBJNAM = :2

84ab4hmg8u6dm ALTER SESSION SET TIME_ZONE='+8:00'

8szzyjdgh5qy3 select accountrna0_.ACCOUNT_SEQ as ACCOUNT1_93_0_, accountrna0_.METHOD as METHOD93_0_, accountrna0_.PAY_STATUS as PAY3_93_0_, accountrna0_.AMOUNT as AMOUNT93_0_, accountrna0_.PAY_DATE as PAY5_93_0_, accountrna0_.RETURN_PHOTO as RETURN6_93_0_, accountrna0_.RNA_STATUS as RNA7_93_0_, accountrna0_.MIS_COUNT as MIS8_93_0_, accountrna0_.BANK_TRANS_ID as BANK9_93_0_ from ACCOUNT_RNA accountrna0_ where accountrna0_.ACCOUNT_SEQ=:1

95nvamhj37kmz SELECT NAMESPACE, ATTRIBUTE FROM SYS.EXU9PCT WHERE OBJOWN = :1 AND OBJNAM = :2

a1as9muhfawcx select actiontype0_.ID as ID19_0_, actiontype0_.ACTION_ID as ACTION2_19_0_, actiontype0_.ACTION_NAME as ACTION3_19_0_, actiontype0_.FLAG as FLAG19_0_, actiontype0_.VERSION as VERSION19_0_, actiontype0_.CREATE_USER as CREATE6_19_0_, actiontype0_.CREATE_TIME as CREATE7_19_0_, actiontype0_.UPDATE_USER as UPDATE8_19_0_, actiontype0_.UPDATE_TIME as UPDATE9_19_0_, actiontype0_.STATUS as STATUS19_0_ from ACTION_TYPE actiontype0_ where actiontype0_.ID=:1

aha2u0n7zp2ur select * from ( select transactio0_.ID as ID10_, transactio0_.ACTION_SEQ as ACTION2_10_, transactio0_.CREDIT_RATIO_SEQ as CREDIT3_10_, transactio0_.DEBIT_RATIO_SEQ as DEBIT4_10_, transactio0_.DEBIT_SEQ as DEBIT5_10_, transactio0_.CREDIT_SEQ as CREDIT6_10_, transactio0_.ORDER_ID as ORDER7_10_, transactio0_.SERVICE_FLAG as SERVICE8_10_, transactio0_.SERVICE_DATE as SERVICE9_10_, transactio0_.SERVICE_PERSON as SERVICE10_10_, transactio0_.AMOUNT as AMOUNT10_, transactio0_.CURRENCY as CURRENCY10_, transactio0_.EXCHANGE_RATE as EXCHANGE13_10_, transactio0_.REVERSE_FLAG as REVERSE14_10_, transactio0_.RELATING_SEQ as RELATING15_10_, transactio0_.TRANS_ID as TRANS16_10_, transactio0_.TRANS_STATUS as TRANS17_10_, transactio0_.BEGIN_DATE as BEGIN18_10_, transactio0_.END_DATE as END19_10_, transactio0_.DEBIT_FEE as DEBIT20_10_, transactio0_.CREDIT_FEE as CREDIT21_10_, transactio0_.SELLER_URL as SELLER22_10_, transactio0_.OPER_SOURCE as OPER23_10_, transactio0_.COMMODITY_INFO as COMMODITY24_10_, transactio0_.SELLER_PARAM as SELLER25_10_, transactio0_.DES_FLAG as DES26_10_, transactio0_.MAC as MAC10_, transactio0_.VERSION as VERSION10_, transactio0_.CREATE_USER as CREATE29_10_, transactio0_.CREATE_TIME as CREATE30_10_, transactio0_.UPDATE_USER as UPDATE31_10_, transactio0_.UPDATE_USER_SYSTEM as UPDATE32_10_, transactio0_.UPDATE_TIME as UPDATE33_10_, transactio0_.TRADE_TYPE as TRADE34_10_, transactio0_.BANK_SEQ as BANK35_10_, transactio0_.CARD_NO as CARD36 _10_, transactio0_.BANK_NAME as BANK37_10_, transactio0_.BANK_PROV_SEQ as BANK38_10_, transactio0_.BANK_CITY_SEQ as BANK39_10_, transactio0_.PERSON_NAME as PERSON40_10_, transactio0_.PERSON_MAIL as PERSON41_10_, transactio0_.PERSON_PHONE as PERSON42_10_, transactio0_.PERSON_MOBILE as PERSON43_10_, transactio0_.REMARK as REMARK10_, transactio0_.ACCOUNT_BANK_SEQ as ACCOUNT45_10_, transactio0_.VERIFY_CODE as VERIFY46_10_, transactio0_.BARCODE as BARCODE10_, transactio0_.AUDIT_TRANS as AUDIT48_10_, transactio0_.encryptCode as encrypt49_10_, transactio0_.PURPOSE as PURPOSE10_, transactio0_.INSIDE_STATUS as INSIDE51_10_, transactio0_.BANK_RESPONSE as BANK52_10_, transactio0_.DOWNLOADSTATE as DOWNLOA53_10_, transactio0_.OPERATOR_SEQ as OPERATOR54_10_, transactio0_.BANK_INFO_SEQ as BANK55_10_, transactio0_.RETURN_AMOUNT as RETURN56_10_, transactio0_.VOUCHER_CODE as VOUCHER57_10_, transactio0_.VNV_ACCOUNT_ID as VNV58_10_, transactio0_.BATCH_NO as BATCH59_10_, transactio0_.ORDER_URL as ORDER60_10_, transactio0_.IP as IP10_, transactio0_.PAY_TRANS_SEQ as PAY62_10_ from TRANSACTION transactio0_, SUB_ACCOUNT subaccount1_, SUB_ACCOUNT subaccount2_ where transactio0_.DEBIT_SEQ=subaccount1_.ID and transactio0_.CREDIT_SEQ=subaccount2_.ID and (subaccount1_.MAIN_ACCOUNT_SEQ=:1 or subaccount2_.MAIN_ACCOUNT_SEQ=:2) and (transactio0_.ACTION_SEQ in (33 , 3 , 6 , 7 , 23 , 26 , 24)) order by transactio0_.UPDATE_TIME desc ) where rownum <= :3

b3ys9bs1v9cch delete from WRH$_SYSMETRIC_SUMMARY tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))

b7jn4mf49n569 select o.name, u.name from obj$ o, type$ t, user$ u where o.oid$ = t.tvoid and u.user#=o.owner# and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

c2p32r5mzv8hb BEGIN prvt_advisor.delete_expired_tasks; END;

csfrmw47298yt select childprodu0_.PARENT as PARENT1_, childprodu0_.ID as ID1_, childprodu0_.ID as ID97_0_, childprodu0_.VERSION as VERSION97_0_, childprodu0_.NAME as NAME97_0_, childprodu0_.URL as URL97_0_, childprodu0_.STATUS as STATUS97_0_, childprodu0_.NOTES as NOTES97_0_, childprodu0_.PARENT as PARENT97_0_ from PRODUCT_CLASS childprodu0_ where childprodu0_.status=1 and childprodu0_.PARENT=:1

cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

d33wr2f2d9qk9 select productcla0_.ID as ID97_0_, productcla0_.VERSION as VERSION97_0_, productcla0_.NAME as NAME97_0_, productcla0_.URL as URL97_0_, productcla0_.STATUS as STATUS97_0_, productcla0_.NOTES as NOTES97_0_, productcla0_.PARENT as PARENT97_0_ from PRODUCT_CLASS productcla0_ where productcla0_.ID=:1

f7vq3cngfzx4g select account0_.ID as ID17_3_, account0_.VERSION as VERSION17_3_, account0_.SUMAMOUNT as SUMAMOUNT17_3_, account0_.TRAN_AMOUNT as TRAN4_17_3_, account0_.ACCOUNT_ID as ACCOUNT5_17_3_, account0_.UPDATE_USER_SYSTEM as UPDATE6_17_3_, account0_.GENDER as GENDER17_3_, account0_.EMAIL as EMAIL17_3_, account0_.NAME as NAME17_3_, account0_.KEY as KEY17_3_, account0_.LOGIN_PASSWORD as LOGIN11_17_3_, account0_.PAY_PASSWORD as PAY12_17_3_, account0_.QUESTION as QUESTION17_3_, account0_.ANSWER as ANSWER17_3_, account0_.CARD_PHOTO as CARD15_17_3_, account0_.CARDPHOTE_BACK as CARDPHOTE16_17_3_, account0_.TEMP_CARDPHOTO as TEMP17_17_3_, account0_.TEMP_CARDPHOTE_BACK as TEMP18_17_3_, account0_.PHOTO as PHOTO17_3_, account0_.ID_TYPE as ID20_17_3_, account0_.ID_CODE as ID21_17_3_, account0_.TEL as TEL17_3_, account0_.ADDR as ADDR17_3_, account0_.ACCOUNT_TYPE as ACCOUNT24_17_3_, account0_.IVR_STATUS as IVR25_17_3_, account0_.IVR_LOGIN_PASSWORD as IVR26_17_3_, account0_.IVR_PAY_PASSWORD as IVR27_17_3_, account0_.AUTHENTICATION_STATUS as AUTHENT28_17_3_, account0_.INTRODUCE_ACCOUNT_ID as INTRODUCE29_17_3_, account0_.ACTIVATE_STATUS as ACTIVATE30_17_3_, account0_.TOTAL_SCORES as TOTAL31_17_3_, account0_.PROV_SEQ as PROV32_17_3_, account0_.CITY_SEQ as CITY33_17_3_, account0_.ZIP_CODE as ZIP34_17_3_, account0_.FLAG as FLAG17_3_, account0_.ACTIVE_CODE as ACTIVE36_17_3_, account0_.EM_STATUS as EM37_17_3_, account0_.OFFER_PERSON as OFFER38_17_3_, account0_.MOBILE a s MOBILE17_3_, account0_.STATUS as STATUS17_3_, account0_.REMARK as REMARK17_3_, account0_.CREATE_USER as CREATE42_17_3_, account0_.CREATE_TIME as CREATE43_17_3_, account0_.UPDATE_USER as UPDATE44_17_3_, account0_.INFORM_MOBILE as INFORM45_17_3_, account0_.CHAIN_URL as CHAIN46_17_3_, account0_.CHAIN_REMARK as CHAIN47_17_3_, account0_.UPDATE_TIME as UPDATE48_17_3_, account0_.BIRTHDAY as BIRTHDAY17_3_, account0_.AUDIT_STATUS as AUDIT50_17_3_, account0_.MOB_STATUS as MOB51_17_3_, account0_.MOB_ACTIVE_CODE as MOB52_17_3_, account0_.MOB_LOGIN_PASS as MOB53_17_3_, account0_.MOB_PAY_PASS as MOB54_17_3_, account0_.encryptCode as encrypt55_17_3_, account0_.AUTHENTICATION_NAME as AUTHENT56_17_3_, account0_.AUTHENTICATION_ID_CODE as AUTHENT57_17_3_, account0_.RESET_PWD_CODE as RESET58_17_3_, account0_.COMPANY_TYPE as COMPANY59_17_3_, account0_.AUTHENTICATION_REJECT as AUTHENT60_17_3_, account0_.DEFAULT_SUB_SEQ as DEFAULT61_17_3_, accountcom1_.ACCOUNT_SEQ as ACCOUNT1_24_0_, accountcom1_.COMPANY_NAME as COMPANY2_24_0_, accountcom1_.REGI_ADDR as REGI3_24_0_, accountcom1_.REGI_ZIP as REGI4_24_0_, accountcom1_.TAX_ID as TAX5_24_0_, accountcom1_.BANK_NAME as BANK6_24_0_, accountcom1_.BANK_ACCOUNT as BANK7_24_0_, accountcom1_.INVO_ADDR as INVO8_24_0_, accountcom1_.INVO_ZIP as INVO9_24_0_, accountcom1_.KEY as KEY24_0_, accountcom1_.INTERFACE_URL as INTERFACE11_24_0_, accountcom1_.COMPANY_URL as COMPANY12_24_0_, accountcom1_.INVO_TEL as INVO13_24_0_, accountco m1_.FOUNDED_DATE as FOUNDED14_24_0_, accountcom1_.TURNOVER_AMOUNT as TURNOVER15_24_0_, accountcom1_.CAPITAL_AMOUNT as CAPITAL16_24_0_, accountcom1_.PRIN_NAME as PRIN17_24_0_, accountcom1_.PRIN_TEL as PRIN18_24_0_, accountcom1_.LINK_MAN as LINK19_24_0_, accountcom1_.LINK_TEL as LINK20_24_0_, accountcom1_.FAX as FAX24_0_, accountcom1_.LICENCE_NO as LICENCE22_24_0_, accountcom1_.ORGANIZE_NO as ORGANIZE23_24_0_, accountcom1_.DEAL_RANGE as DEAL24_24_0_, accountcom1_.FIELD_TYPE as FIELD25_24_0_, accountcom1_.BOSS_ID as BOSS26_24_0_, accountcom1_.ACCOUNT_LICENCE_NO as ACCOUNT27_24_0_, accountcom1_.CORPORATION_ID as CORPORA28_24_0_, accountcom1_.CERTIFICATE_PIC_ID as CERTIFI29_24_0_, accountcom1_.FINANCE_ID as FINANCE30_24_0_, accountcom1_.FINANCE_NAME as FINANCE31_24_0_, accountcom1_.B2CABLE as B32_24_0_, account2_.ID as ID17_1_, account2_.VERSION as VERSION17_1_, account2_.SUMAMOUNT as SUMAMOUNT17_1_, account2_.TRAN_AMOUNT as TRAN4_17_1_, account2_.ACCOUNT_ID as ACCOUNT5_17_1_, account2_.UPDATE_USER_SYSTEM as UPDATE6_17_1_, account2_.GENDER as GENDER17_1_, account2_.EMAIL as EMAIL17_1_, account2_.NAME as NAME17_1_, account2_.KEY as KEY17_1_, account2_.LOGIN_PASSWORD as LOGIN11_17_1_, account2_.PAY_PASSWORD as PAY12_17_1_, account2_.QUESTION as QUESTION17_1_, account2_.ANSWER as ANSWER17_1_, account2_.CARD_PHOTO as CARD15_17_1_, account2_.CARDPHOTE_BACK as CARDPHOTE16_17_1_, account2_.TEMP_CARDPHOTO as TEMP17_17_1_, account2_.TEMP_CARDPHOTE_BACK a s TEMP18_17_1_, account2_.PHOTO as PHOTO17_1_, account2_.ID_TYPE as ID20_17_1_, account2_.ID_CODE as ID21_17_1_, account2_.TEL as TEL17_1_, account2_.ADDR as ADDR17_1_, account2_.ACCOUNT_TYPE as ACCOUNT24_17_1_, account2_.IVR_STATUS as IVR25_17_1_, account2_.IVR_LOGIN_PASSWORD as IVR26_17_1_, account2_.IVR_PAY_PASSWORD as IVR27_17_1_, account2_.AUTHENTICATION_STATUS as AUTHENT28_17_1_, account2_.INTRODUCE_ACCOUNT_ID as INTRODUCE29_17_1_, account2_.ACTIVATE_STATUS as ACTIVATE30_17_1_, account2_.TOTAL_SCORES as TOTAL31_17_1_, account2_.PROV_SEQ as PROV32_17_1_, account2_.CITY_SEQ as CITY33_17_1_, account2_.ZIP_CODE as ZIP34_17_1_, account2_.FLAG as FLAG17_1_, account2_.ACTIVE_CODE as ACTIVE36_17_1_, account2_.EM_STATUS as EM37_17_1_, account2_.OFFER_PERSON as OFFER38_17_1_, account2_.MOBILE as MOBILE17_1_, account2_.STATUS as STATUS17_1_, account2_.REMARK as REMARK17_1_, account2_.CREATE_USER as CREATE42_17_1_, account2_.CREATE_TIME as CREATE43_17_1_, account2_.UPDATE_USER as UPDATE44_17_1_, account2_.INFORM_MOBILE as INFORM45_17_1_, account2_.CHAIN_URL as CHAIN46_17_1_, account2_.CHAIN_REMARK as CHAIN47_17_1_, account2_.UPDATE_TIME as UPDATE48_17_1_, account2_.BIRTHDAY as BIRTHDAY17_1_, account2_.AUDIT_STATUS as AUDIT50_17_1_, account2_.MOB_STATUS as MOB51_17_1_, account2_.MOB_ACTIVE_CODE as MOB52_17_1_, account2_.MOB_LOGIN_PASS as MOB53_17_1_, account2_.MOB_PAY_PASS as MOB54_17_1_, account2_.encryptCode as encrypt55_17_1_, account2_.AUTHE NTICATION_NAME as AUTHENT56_17_1_, account2_.AUTHENTICATION_ID_CODE as AUTHENT57_17_1_, account2_.RESET_PWD_CODE as RESET58_17_1_, account2_.COMPANY_TYPE as COMPANY59_17_1_, account2_.AUTHENTICATION_REJECT as AUTHENT60_17_1_, account2_.DEFAULT_SUB_SEQ as DEFAULT61_17_1_, accountrna3_.ACCOUNT_SEQ as ACCOUNT1_93_2_, accountrna3_.METHOD as METHOD93_2_, accountrna3_.PAY_STATUS as PAY3_93_2_, accountrna3_.AMOUNT as AMOUNT93_2_, accountrna3_.PAY_DATE as PAY5_93_2_, accountrna3_.RETURN_PHOTO as RETURN6_93_2_, accountrna3_.RNA_STATUS as RNA7_93_2_, accountrna3_.MIS_COUNT as MIS8_93_2_, accountrna3_.BANK_TRANS_ID as BANK9_93_2_ from ACCOUNT account0_, ACCOUNT_COMPANY accountcom1_, ACCOUNT account2_, ACCOUNT_RNA accountrna3_ where account0_.ID=accountcom1_.ACCOUNT_SEQ(+) and accountcom1_.ACCOUNT_SEQ=account2_.ID(+) and account2_.ID=accountrna3_.ACCOUNT_SEQ(+) and account0_.ID=:1

fj695q4p2ysg2 SELECT POLGRP FROM SYS.EXU9PGP WHERE OBJOWN = :1 AND OBJNAM = :2

SQL Id	SQL Text
03amf67aqhjfw	alter system archive log current
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
14v5zufhsv6pj	select acctbalhis0_.BALANCE as col_0_0_ from ACCT_BAL_HIS acctbalhis0_, SUB_ACCOUNT subaccount1_ where acctbalhis0_.SUB_ACCT_SEQ=subaccount1_.ID and subaccount1_.ID=:1 and subaccount1_.SUB_ACCOUNT_TYPE='0' and subaccount1_.VALID_FLAG='Y' and acctbalhis0_.ID=(select max(acctbalhis2_.ID) from ACCT_BAL_HIS acctbalhis2_ where acctbalhis2_.SUB_ACCT_SEQ=:2 and acctbalhis2_.UPDATE_TIME<=:3) order by acctbalhis0_.UPDATE_TIME desc
165tjwc317ksz	select t.trans_id, t.amount as trans_amount, t.credit_fee, t.debit_fee, incorrect.sub_acct_seq, incorrect.id as abh_seq, incorrect.amount, incorrect.fee, incorrect.flag, incorrect.balance, incorrect.begin_balance from (select t.sub_acct_seq, t.amount, t.lock_amount, t.fee, t.flag, t.balance, t.id, t.update_time, trans_id, sum(t.balance)over(partition by t.sub_acct_seq order by t.id asc rows between 1 preceding and 0 following)-t.balance begin_balance from acct_bal_his t where t.sub_acct_seq not in (1, 2, 3, 4, 5, 6, 7, 8, 9) group by t.sub_acct_seq, t.amount, t.lock_amount, t.fee, t.flag, t.balance, t.id, t.update_time, trans_id order by t.sub_acct_seq asc, id asc ) incorrect, transaction t where t.trans_id = incorrect.trans_id and incorrect.begin_balance + (incorrect.flag * incorrect.amount)-fee != balance and incorrect.update_time >= to_date('2013-04-21 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and incorrect.update_time <= to_date('2013-04-21 23:59:59', 'yyyy-mm-dd hh24:mi:ss') order by incorrect.id desc
299gaqtz96qfy	delete from WRI$_SEGADV_OBJLIST where creation_time < :1
42ts6pukwt3pu	select count(*) as col_0_0_ from TRANSACTION transactio0_ where transactio0_.TRANS_STATUS=:1 and transactio0_.AUDIT_TRANS=:2 and (transactio0_.ACTION_SEQ in (4 , 7)) and transactio0_.AMOUNT>0 and (transactio0_.TRANS_ID not in (select adjustrequ1_.TRANSACTIONCODE from ADJUSTREQUSITION adjustrequ1_ where adjustrequ1_.APPLYSTATE<>5 and adjustrequ1_.APPLYSTATE<>4 and (adjustrequ1_.TRANSACTIONCODE is not null)))
4ng4xn7jw3dbb	delete from WRH$_ENQUEUE_STAT tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))
4z6jfdhm5uxr7	select longname from javasnm$ where short = :1
4zzjwu4x3rcyr	select count(*) as count from ( select trans.credit_seq, trans.debit_fee, trans.credit_fee, trans.action_seq, trans.RELATING_SEQ, trans.order_id, trans.order_url, trans.trans_id, sb.list_name as status, trans.begin_date, trans.update_time, trans.amount, sb1.list_name as trade, trans.id, trans.bank_seq, trans.downloadstate, trans.commodity_info, case when trans.debit_seq in (:1) then trans.credit_seq when trans.credit_seq in (:2) then trans.debit_seq end as offsize , case when trans.debit_seq in (:3) then '0' when trans.credit_seq in (:4) then '1' end as comeorgo, trans.trans_status, case when trans.debit_seq in (:5) then trans.debit_seq when trans.credit_seq in (:6) then trans.credit_seq end as selfsize from transaction trans left join sysbook sb on sb.type_id='TRANS_STATUS' and trans.trans_status = sb.list_id left join sysbook sb1 on sb1.type_id='TRADE_TYPE' and trans.trade_type= sb1.list_id where 1=1 and trans.action_seq != 25 and trans.trans_status in (:7, :8, :9, :10, :11, :12) and 1= (case when trans.credit_seq in (:13) and trans.trans_status = 0 then 0 else 1 end) and (trans.debit_seq in (:14) or trans.credit_seq in (:15)) ) v_t left join sub_account sub_1 on sub_1.id = v_t.selfsize , account acc, sub_account sa where sa.main_account_seq = acc.id and sa.id = v_t.offsize order by v_t.id desc, v_t.begin_date desc
5712nr1b46uuu	select transactio0_.ID as ID18_, transactio0_.ACTION_SEQ as ACTION2_18_, transactio0_.CREDIT_RATIO_SEQ as CREDIT3_18_, transactio0_.DEBIT_RATIO_SEQ as DEBIT4_18_, transactio0_.DEBIT_SEQ as DEBIT5_18_, transactio0_.CREDIT_SEQ as CREDIT6_18_, transactio0_.ORDER_ID as ORDER7_18_, transactio0_.SERVICE_FLAG as SERVICE8_18_, transactio0_.SERVICE_DATE as SERVICE9_18_, transactio0_.SERVICE_PERSON as SERVICE10_18_, transactio0_.AMOUNT as AMOUNT18_, transactio0_.CURRENCY as CURRENCY18_, transactio0_.EXCHANGE_RATE as EXCHANGE13_18_, transactio0_.REVERSE_FLAG as REVERSE14_18_, transactio0_.RELATING_SEQ as RELATING15_18_, transactio0_.TRANS_ID as TRANS16_18_, transactio0_.TRANS_STATUS as TRANS17_18_, transactio0_.BEGIN_DATE as BEGIN18_18_, transactio0_.END_DATE as END19_18_, transactio0_.DEBIT_FEE as DEBIT20_18_, transactio0_.CREDIT_FEE as CREDIT21_18_, transactio0_.SELLER_URL as SELLER22_18_, transactio0_.OPER_SOURCE as OPER23_18_, transactio0_.COMMODITY_INFO as COMMODITY24_18_, transactio0_.SELLER_PARAM as SELLER25_18_, transactio0_.DES_FLAG as DES26_18_, transactio0_.MAC as MAC18_, transactio0_.VERSION as VERSION18_, transactio0_.CREATE_USER as CREATE29_18_, transactio0_.CREATE_TIME as CREATE30_18_, transactio0_.UPDATE_USER as UPDATE31_18_, transactio0_.UPDATE_USER_SYSTEM as UPDATE32_18_, transactio0_.UPDATE_TIME as UPDATE33_18_, transactio0_.TRADE_TYPE as TRADE34_18_, transactio0_.BANK_SEQ as BANK35_18_, transactio0_.CARD_NO as CARD36_18_, transacti o0_.BANK_NAME as BANK37_18_, transactio0_.BANK_PROV_SEQ as BANK38_18_, transactio0_.BANK_CITY_SEQ as BANK39_18_, transactio0_.PERSON_NAME as PERSON40_18_, transactio0_.PERSON_MAIL as PERSON41_18_, transactio0_.PERSON_PHONE as PERSON42_18_, transactio0_.PERSON_MOBILE as PERSON43_18_, transactio0_.REMARK as REMARK18_, transactio0_.ACCOUNT_BANK_SEQ as ACCOUNT45_18_, transactio0_.VERIFY_CODE as VERIFY46_18_, transactio0_.BARCODE as BARCODE18_, transactio0_.AUDIT_TRANS as AUDIT48_18_, transactio0_.encryptCode as encrypt49_18_, transactio0_.PURPOSE as PURPOSE18_, transactio0_.INSIDE_STATUS as INSIDE51_18_, transactio0_.BANK_RESPONSE as BANK52_18_, transactio0_.DOWNLOADSTATE as DOWNLOA53_18_, transactio0_.OPERATOR_SEQ as OPERATOR54_18_, transactio0_.BANK_INFO_SEQ as BANK55_18_, transactio0_.VOUCHER_CODE as VOUCHER56_18_, transactio0_.VNV_ACCOUNT_ID as VNV57_18_, transactio0_.BATCH_NO as BATCH58_18_ from TRANSACTION transactio0_ where transactio0_.END_DATE>=:1 and transactio0_.END_DATE<=:2 and transactio0_.ACTION_SEQ<>5
7c78dfacskv69	select subaccount0_.ID as ID28_2_, subaccount0_.VERSION as VERSION28_2_, subaccount0_.MAIN_ACCOUNT_SEQ as MAIN3_28_2_, subaccount0_.ACCOUNT_BANK as ACCOUNT4_28_2_, subaccount0_.ACCOUNT_MONEY_TYPE as ACCOUNT5_28_2_, subaccount0_.VALID_FLAG as VALID6_28_2_, subaccount0_.ACCOUNT_ID as ACCOUNT7_28_2_, subaccount0_.ACCOUNT_NAME as ACCOUNT8_28_2_, subaccount0_.SUP_ACCOUNT_ID as SUP9_28_2_, subaccount0_.SUB_ACCOUNT_TYPE as SUB10_28_2_, subaccount0_.INSIDE_ID as INSIDE11_28_2_, subaccount0_.ACCOUNT_LEVEL as ACCOUNT12_28_2_, subaccount0_.REMARK as REMARK28_2_, subaccount0_.LIST_SEQ as LIST14_28_2_, subaccount0_.CREATE_USER as CREATE15_28_2_, subaccount0_.CREATE_TIME as CREATE16_28_2_, subaccount0_.UPDATE_USER as UPDATE17_28_2_, subaccount0_.UPDATE_TIME as UPDATE18_28_2_, subaccount0_.IVR_FLAG as IVR19_28_2_, subaccount0_.detail_flag as detail20_28_2_, accountbal1_.ID as ID23_0_, accountbal1_.VERSION as VERSION23_0_, accountbal1_.BALANCE as BALANCE23_0_, accountbal1_.LOCK_AMOUNT as LOCK4_23_0_, accountbal1_.CREATE_USER as CREATE5_23_0_, accountbal1_.CREATE_TIME as CREATE6_23_0_, accountbal1_.UPDATE_USER as UPDATE7_23_0_, accountbal1_.UPDATE_TIME as UPDATE8_23_0_, accountbal1_.accumulation as accumula9_23_0_, accountbal1_.BANKROLL_UPDATE_TIME as BANKROLL10_23_0_, accountbal1_.encryptCode as encrypt11_23_0_, subaccount2_.ID as ID28_1_, subaccount2_.VERSION as VERSION28_1_, subaccount2_.MAIN_ACCOUNT_SEQ as MAIN3_28_1_, subaccount2_.ACCOUNT_BANK as ACCOUNT 4_28_1_, subaccount2_.ACCOUNT_MONEY_TYPE as ACCOUNT5_28_1_, subaccount2_.VALID_FLAG as VALID6_28_1_, subaccount2_.ACCOUNT_ID as ACCOUNT7_28_1_, subaccount2_.ACCOUNT_NAME as ACCOUNT8_28_1_, subaccount2_.SUP_ACCOUNT_ID as SUP9_28_1_, subaccount2_.SUB_ACCOUNT_TYPE as SUB10_28_1_, subaccount2_.INSIDE_ID as INSIDE11_28_1_, subaccount2_.ACCOUNT_LEVEL as ACCOUNT12_28_1_, subaccount2_.REMARK as REMARK28_1_, subaccount2_.LIST_SEQ as LIST14_28_1_, subaccount2_.CREATE_USER as CREATE15_28_1_, subaccount2_.CREATE_TIME as CREATE16_28_1_, subaccount2_.UPDATE_USER as UPDATE17_28_1_, subaccount2_.UPDATE_TIME as UPDATE18_28_1_, subaccount2_.IVR_FLAG as IVR19_28_1_, subaccount2_.detail_flag as detail20_28_1_ from SUB_ACCOUNT subaccount0_, ACCOUNT_BALANCE accountbal1_, SUB_ACCOUNT subaccount2_ where subaccount0_.ID=accountbal1_.ID(+) and accountbal1_.ID=subaccount2_.ID(+) and subaccount0_.ID=:1
7fprcxd5040cz	SELECT POLGRP, POLICY, POLOWN, POLSCH, POLFUN, STMT, CHKOPT, ENABLED, SPOLICY FROM SYS.EXU9RLS WHERE OBJOWN = :1 AND OBJNAM = :2
84ab4hmg8u6dm	ALTER SESSION SET TIME_ZONE='+8:00'
8szzyjdgh5qy3	select accountrna0_.ACCOUNT_SEQ as ACCOUNT1_93_0_, accountrna0_.METHOD as METHOD93_0_, accountrna0_.PAY_STATUS as PAY3_93_0_, accountrna0_.AMOUNT as AMOUNT93_0_, accountrna0_.PAY_DATE as PAY5_93_0_, accountrna0_.RETURN_PHOTO as RETURN6_93_0_, accountrna0_.RNA_STATUS as RNA7_93_0_, accountrna0_.MIS_COUNT as MIS8_93_0_, accountrna0_.BANK_TRANS_ID as BANK9_93_0_ from ACCOUNT_RNA accountrna0_ where accountrna0_.ACCOUNT_SEQ=:1
95nvamhj37kmz	SELECT NAMESPACE, ATTRIBUTE FROM SYS.EXU9PCT WHERE OBJOWN = :1 AND OBJNAM = :2
a1as9muhfawcx	select actiontype0_.ID as ID19_0_, actiontype0_.ACTION_ID as ACTION2_19_0_, actiontype0_.ACTION_NAME as ACTION3_19_0_, actiontype0_.FLAG as FLAG19_0_, actiontype0_.VERSION as VERSION19_0_, actiontype0_.CREATE_USER as CREATE6_19_0_, actiontype0_.CREATE_TIME as CREATE7_19_0_, actiontype0_.UPDATE_USER as UPDATE8_19_0_, actiontype0_.UPDATE_TIME as UPDATE9_19_0_, actiontype0_.STATUS as STATUS19_0_ from ACTION_TYPE actiontype0_ where actiontype0_.ID=:1
aha2u0n7zp2ur	select * from ( select transactio0_.ID as ID10_, transactio0_.ACTION_SEQ as ACTION2_10_, transactio0_.CREDIT_RATIO_SEQ as CREDIT3_10_, transactio0_.DEBIT_RATIO_SEQ as DEBIT4_10_, transactio0_.DEBIT_SEQ as DEBIT5_10_, transactio0_.CREDIT_SEQ as CREDIT6_10_, transactio0_.ORDER_ID as ORDER7_10_, transactio0_.SERVICE_FLAG as SERVICE8_10_, transactio0_.SERVICE_DATE as SERVICE9_10_, transactio0_.SERVICE_PERSON as SERVICE10_10_, transactio0_.AMOUNT as AMOUNT10_, transactio0_.CURRENCY as CURRENCY10_, transactio0_.EXCHANGE_RATE as EXCHANGE13_10_, transactio0_.REVERSE_FLAG as REVERSE14_10_, transactio0_.RELATING_SEQ as RELATING15_10_, transactio0_.TRANS_ID as TRANS16_10_, transactio0_.TRANS_STATUS as TRANS17_10_, transactio0_.BEGIN_DATE as BEGIN18_10_, transactio0_.END_DATE as END19_10_, transactio0_.DEBIT_FEE as DEBIT20_10_, transactio0_.CREDIT_FEE as CREDIT21_10_, transactio0_.SELLER_URL as SELLER22_10_, transactio0_.OPER_SOURCE as OPER23_10_, transactio0_.COMMODITY_INFO as COMMODITY24_10_, transactio0_.SELLER_PARAM as SELLER25_10_, transactio0_.DES_FLAG as DES26_10_, transactio0_.MAC as MAC10_, transactio0_.VERSION as VERSION10_, transactio0_.CREATE_USER as CREATE29_10_, transactio0_.CREATE_TIME as CREATE30_10_, transactio0_.UPDATE_USER as UPDATE31_10_, transactio0_.UPDATE_USER_SYSTEM as UPDATE32_10_, transactio0_.UPDATE_TIME as UPDATE33_10_, transactio0_.TRADE_TYPE as TRADE34_10_, transactio0_.BANK_SEQ as BANK35_10_, transactio0_.CARD_NO as CARD36 _10_, transactio0_.BANK_NAME as BANK37_10_, transactio0_.BANK_PROV_SEQ as BANK38_10_, transactio0_.BANK_CITY_SEQ as BANK39_10_, transactio0_.PERSON_NAME as PERSON40_10_, transactio0_.PERSON_MAIL as PERSON41_10_, transactio0_.PERSON_PHONE as PERSON42_10_, transactio0_.PERSON_MOBILE as PERSON43_10_, transactio0_.REMARK as REMARK10_, transactio0_.ACCOUNT_BANK_SEQ as ACCOUNT45_10_, transactio0_.VERIFY_CODE as VERIFY46_10_, transactio0_.BARCODE as BARCODE10_, transactio0_.AUDIT_TRANS as AUDIT48_10_, transactio0_.encryptCode as encrypt49_10_, transactio0_.PURPOSE as PURPOSE10_, transactio0_.INSIDE_STATUS as INSIDE51_10_, transactio0_.BANK_RESPONSE as BANK52_10_, transactio0_.DOWNLOADSTATE as DOWNLOA53_10_, transactio0_.OPERATOR_SEQ as OPERATOR54_10_, transactio0_.BANK_INFO_SEQ as BANK55_10_, transactio0_.RETURN_AMOUNT as RETURN56_10_, transactio0_.VOUCHER_CODE as VOUCHER57_10_, transactio0_.VNV_ACCOUNT_ID as VNV58_10_, transactio0_.BATCH_NO as BATCH59_10_, transactio0_.ORDER_URL as ORDER60_10_, transactio0_.IP as IP10_, transactio0_.PAY_TRANS_SEQ as PAY62_10_ from TRANSACTION transactio0_, SUB_ACCOUNT subaccount1_, SUB_ACCOUNT subaccount2_ where transactio0_.DEBIT_SEQ=subaccount1_.ID and transactio0_.CREDIT_SEQ=subaccount2_.ID and (subaccount1_.MAIN_ACCOUNT_SEQ=:1 or subaccount2_.MAIN_ACCOUNT_SEQ=:2) and (transactio0_.ACTION_SEQ in (33 , 3 , 6 , 7 , 23 , 26 , 24)) order by transactio0_.UPDATE_TIME desc ) where rownum <= :3
b3ys9bs1v9cch	delete from WRH$_SYSMETRIC_SUMMARY tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))
b7jn4mf49n569	select o.name, u.name from obj$ o, type$ t, user$ u where o.oid$ = t.tvoid and u.user#=o.owner# and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c2p32r5mzv8hb	BEGIN prvt_advisor.delete_expired_tasks; END;
csfrmw47298yt	select childprodu0_.PARENT as PARENT1_, childprodu0_.ID as ID1_, childprodu0_.ID as ID97_0_, childprodu0_.VERSION as VERSION97_0_, childprodu0_.NAME as NAME97_0_, childprodu0_.URL as URL97_0_, childprodu0_.STATUS as STATUS97_0_, childprodu0_.NOTES as NOTES97_0_, childprodu0_.PARENT as PARENT97_0_ from PRODUCT_CLASS childprodu0_ where childprodu0_.status=1 and childprodu0_.PARENT=:1
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d33wr2f2d9qk9	select productcla0_.ID as ID97_0_, productcla0_.VERSION as VERSION97_0_, productcla0_.NAME as NAME97_0_, productcla0_.URL as URL97_0_, productcla0_.STATUS as STATUS97_0_, productcla0_.NOTES as NOTES97_0_, productcla0_.PARENT as PARENT97_0_ from PRODUCT_CLASS productcla0_ where productcla0_.ID=:1
f7vq3cngfzx4g	select account0_.ID as ID17_3_, account0_.VERSION as VERSION17_3_, account0_.SUMAMOUNT as SUMAMOUNT17_3_, account0_.TRAN_AMOUNT as TRAN4_17_3_, account0_.ACCOUNT_ID as ACCOUNT5_17_3_, account0_.UPDATE_USER_SYSTEM as UPDATE6_17_3_, account0_.GENDER as GENDER17_3_, account0_.EMAIL as EMAIL17_3_, account0_.NAME as NAME17_3_, account0_.KEY as KEY17_3_, account0_.LOGIN_PASSWORD as LOGIN11_17_3_, account0_.PAY_PASSWORD as PAY12_17_3_, account0_.QUESTION as QUESTION17_3_, account0_.ANSWER as ANSWER17_3_, account0_.CARD_PHOTO as CARD15_17_3_, account0_.CARDPHOTE_BACK as CARDPHOTE16_17_3_, account0_.TEMP_CARDPHOTO as TEMP17_17_3_, account0_.TEMP_CARDPHOTE_BACK as TEMP18_17_3_, account0_.PHOTO as PHOTO17_3_, account0_.ID_TYPE as ID20_17_3_, account0_.ID_CODE as ID21_17_3_, account0_.TEL as TEL17_3_, account0_.ADDR as ADDR17_3_, account0_.ACCOUNT_TYPE as ACCOUNT24_17_3_, account0_.IVR_STATUS as IVR25_17_3_, account0_.IVR_LOGIN_PASSWORD as IVR26_17_3_, account0_.IVR_PAY_PASSWORD as IVR27_17_3_, account0_.AUTHENTICATION_STATUS as AUTHENT28_17_3_, account0_.INTRODUCE_ACCOUNT_ID as INTRODUCE29_17_3_, account0_.ACTIVATE_STATUS as ACTIVATE30_17_3_, account0_.TOTAL_SCORES as TOTAL31_17_3_, account0_.PROV_SEQ as PROV32_17_3_, account0_.CITY_SEQ as CITY33_17_3_, account0_.ZIP_CODE as ZIP34_17_3_, account0_.FLAG as FLAG17_3_, account0_.ACTIVE_CODE as ACTIVE36_17_3_, account0_.EM_STATUS as EM37_17_3_, account0_.OFFER_PERSON as OFFER38_17_3_, account0_.MOBILE a s MOBILE17_3_, account0_.STATUS as STATUS17_3_, account0_.REMARK as REMARK17_3_, account0_.CREATE_USER as CREATE42_17_3_, account0_.CREATE_TIME as CREATE43_17_3_, account0_.UPDATE_USER as UPDATE44_17_3_, account0_.INFORM_MOBILE as INFORM45_17_3_, account0_.CHAIN_URL as CHAIN46_17_3_, account0_.CHAIN_REMARK as CHAIN47_17_3_, account0_.UPDATE_TIME as UPDATE48_17_3_, account0_.BIRTHDAY as BIRTHDAY17_3_, account0_.AUDIT_STATUS as AUDIT50_17_3_, account0_.MOB_STATUS as MOB51_17_3_, account0_.MOB_ACTIVE_CODE as MOB52_17_3_, account0_.MOB_LOGIN_PASS as MOB53_17_3_, account0_.MOB_PAY_PASS as MOB54_17_3_, account0_.encryptCode as encrypt55_17_3_, account0_.AUTHENTICATION_NAME as AUTHENT56_17_3_, account0_.AUTHENTICATION_ID_CODE as AUTHENT57_17_3_, account0_.RESET_PWD_CODE as RESET58_17_3_, account0_.COMPANY_TYPE as COMPANY59_17_3_, account0_.AUTHENTICATION_REJECT as AUTHENT60_17_3_, account0_.DEFAULT_SUB_SEQ as DEFAULT61_17_3_, accountcom1_.ACCOUNT_SEQ as ACCOUNT1_24_0_, accountcom1_.COMPANY_NAME as COMPANY2_24_0_, accountcom1_.REGI_ADDR as REGI3_24_0_, accountcom1_.REGI_ZIP as REGI4_24_0_, accountcom1_.TAX_ID as TAX5_24_0_, accountcom1_.BANK_NAME as BANK6_24_0_, accountcom1_.BANK_ACCOUNT as BANK7_24_0_, accountcom1_.INVO_ADDR as INVO8_24_0_, accountcom1_.INVO_ZIP as INVO9_24_0_, accountcom1_.KEY as KEY24_0_, accountcom1_.INTERFACE_URL as INTERFACE11_24_0_, accountcom1_.COMPANY_URL as COMPANY12_24_0_, accountcom1_.INVO_TEL as INVO13_24_0_, accountco m1_.FOUNDED_DATE as FOUNDED14_24_0_, accountcom1_.TURNOVER_AMOUNT as TURNOVER15_24_0_, accountcom1_.CAPITAL_AMOUNT as CAPITAL16_24_0_, accountcom1_.PRIN_NAME as PRIN17_24_0_, accountcom1_.PRIN_TEL as PRIN18_24_0_, accountcom1_.LINK_MAN as LINK19_24_0_, accountcom1_.LINK_TEL as LINK20_24_0_, accountcom1_.FAX as FAX24_0_, accountcom1_.LICENCE_NO as LICENCE22_24_0_, accountcom1_.ORGANIZE_NO as ORGANIZE23_24_0_, accountcom1_.DEAL_RANGE as DEAL24_24_0_, accountcom1_.FIELD_TYPE as FIELD25_24_0_, accountcom1_.BOSS_ID as BOSS26_24_0_, accountcom1_.ACCOUNT_LICENCE_NO as ACCOUNT27_24_0_, accountcom1_.CORPORATION_ID as CORPORA28_24_0_, accountcom1_.CERTIFICATE_PIC_ID as CERTIFI29_24_0_, accountcom1_.FINANCE_ID as FINANCE30_24_0_, accountcom1_.FINANCE_NAME as FINANCE31_24_0_, accountcom1_.B2CABLE as B32_24_0_, account2_.ID as ID17_1_, account2_.VERSION as VERSION17_1_, account2_.SUMAMOUNT as SUMAMOUNT17_1_, account2_.TRAN_AMOUNT as TRAN4_17_1_, account2_.ACCOUNT_ID as ACCOUNT5_17_1_, account2_.UPDATE_USER_SYSTEM as UPDATE6_17_1_, account2_.GENDER as GENDER17_1_, account2_.EMAIL as EMAIL17_1_, account2_.NAME as NAME17_1_, account2_.KEY as KEY17_1_, account2_.LOGIN_PASSWORD as LOGIN11_17_1_, account2_.PAY_PASSWORD as PAY12_17_1_, account2_.QUESTION as QUESTION17_1_, account2_.ANSWER as ANSWER17_1_, account2_.CARD_PHOTO as CARD15_17_1_, account2_.CARDPHOTE_BACK as CARDPHOTE16_17_1_, account2_.TEMP_CARDPHOTO as TEMP17_17_1_, account2_.TEMP_CARDPHOTE_BACK a s TEMP18_17_1_, account2_.PHOTO as PHOTO17_1_, account2_.ID_TYPE as ID20_17_1_, account2_.ID_CODE as ID21_17_1_, account2_.TEL as TEL17_1_, account2_.ADDR as ADDR17_1_, account2_.ACCOUNT_TYPE as ACCOUNT24_17_1_, account2_.IVR_STATUS as IVR25_17_1_, account2_.IVR_LOGIN_PASSWORD as IVR26_17_1_, account2_.IVR_PAY_PASSWORD as IVR27_17_1_, account2_.AUTHENTICATION_STATUS as AUTHENT28_17_1_, account2_.INTRODUCE_ACCOUNT_ID as INTRODUCE29_17_1_, account2_.ACTIVATE_STATUS as ACTIVATE30_17_1_, account2_.TOTAL_SCORES as TOTAL31_17_1_, account2_.PROV_SEQ as PROV32_17_1_, account2_.CITY_SEQ as CITY33_17_1_, account2_.ZIP_CODE as ZIP34_17_1_, account2_.FLAG as FLAG17_1_, account2_.ACTIVE_CODE as ACTIVE36_17_1_, account2_.EM_STATUS as EM37_17_1_, account2_.OFFER_PERSON as OFFER38_17_1_, account2_.MOBILE as MOBILE17_1_, account2_.STATUS as STATUS17_1_, account2_.REMARK as REMARK17_1_, account2_.CREATE_USER as CREATE42_17_1_, account2_.CREATE_TIME as CREATE43_17_1_, account2_.UPDATE_USER as UPDATE44_17_1_, account2_.INFORM_MOBILE as INFORM45_17_1_, account2_.CHAIN_URL as CHAIN46_17_1_, account2_.CHAIN_REMARK as CHAIN47_17_1_, account2_.UPDATE_TIME as UPDATE48_17_1_, account2_.BIRTHDAY as BIRTHDAY17_1_, account2_.AUDIT_STATUS as AUDIT50_17_1_, account2_.MOB_STATUS as MOB51_17_1_, account2_.MOB_ACTIVE_CODE as MOB52_17_1_, account2_.MOB_LOGIN_PASS as MOB53_17_1_, account2_.MOB_PAY_PASS as MOB54_17_1_, account2_.encryptCode as encrypt55_17_1_, account2_.AUTHE NTICATION_NAME as AUTHENT56_17_1_, account2_.AUTHENTICATION_ID_CODE as AUTHENT57_17_1_, account2_.RESET_PWD_CODE as RESET58_17_1_, account2_.COMPANY_TYPE as COMPANY59_17_1_, account2_.AUTHENTICATION_REJECT as AUTHENT60_17_1_, account2_.DEFAULT_SUB_SEQ as DEFAULT61_17_1_, accountrna3_.ACCOUNT_SEQ as ACCOUNT1_93_2_, accountrna3_.METHOD as METHOD93_2_, accountrna3_.PAY_STATUS as PAY3_93_2_, accountrna3_.AMOUNT as AMOUNT93_2_, accountrna3_.PAY_DATE as PAY5_93_2_, accountrna3_.RETURN_PHOTO as RETURN6_93_2_, accountrna3_.RNA_STATUS as RNA7_93_2_, accountrna3_.MIS_COUNT as MIS8_93_2_, accountrna3_.BANK_TRANS_ID as BANK9_93_2_ from ACCOUNT account0_, ACCOUNT_COMPANY accountcom1_, ACCOUNT account2_, ACCOUNT_RNA accountrna3_ where account0_.ID=accountcom1_.ACCOUNT_SEQ(+) and accountcom1_.ACCOUNT_SEQ=account2_.ID(+) and account2_.ID=accountrna3_.ACCOUNT_SEQ(+) and account0_.ID=:1
fj695q4p2ysg2	SELECT POLGRP FROM SYS.EXU9PGP WHERE OBJOWN = :1 AND OBJNAM = :2

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

Statistic	Total	per Second	per Trans
CPU used by this session	248,995	6.29	241.27
CPU used when call started	248,498	6.27	240.79
CR blocks created	345	0.01	0.33
Cached Commit SCN referenced	860	0.02	0.83
Commit SCN cached	10	0.00	0.01
DB time	429,118	10.83	415.81
DBWR checkpoint buffers written	13,639	0.34	13.22
DBWR checkpoints	3	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	1,252	0.03	1.21
DBWR tablespace checkpoint buffers written	149	0.00	0.14
DBWR transaction table writes	840	0.02	0.81
DBWR undo block writes	3,956	0.10	3.83
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	188	0.00	0.18
IMU Redo allocation size	1,689,620	42.65	1,637.23
IMU commits	844	0.02	0.82
IMU contention	1	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	5	0.00	0.00
IMU undo allocation size	7,441,148	187.83	7,210.41
IMU- failed to get a private strand	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	3,030,180	76.49	2,936.22
active txn count during cleanout	560	0.01	0.54
application wait time	0	0.00	0.00
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	127,413	3.22	123.46
branch node splits	0	0.00	0.00
buffer is not pinned count	3,444,612	86.95	3,337.80
buffer is pinned count	828,260	20.91	802.58
bytes received via SQL*Net from client	1,363,280,464	34,411.56	1,321,008.20
bytes sent via SQL*Net to client	3,674,746,753	92,756.97	3,560,801.12
calls to get snapshot scn: kcmgss	1,356,639	34.24	1,314.57
calls to kcmgas	9,776	0.25	9.47
calls to kcmgcs	730	0.02	0.71
change write time	348	0.01	0.34
cleanout - number of ktugct calls	774	0.02	0.75
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	83	0.00	0.08
cluster key scan block gets	115,311	2.91	111.74
cluster key scans	43,601	1.10	42.25
commit batch/immediate performed	1	0.00	0.00
commit batch/immediate requested	1	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	32	0.00	0.03
commit cleanout failures: callback failure	48	0.00	0.05
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	17,178	0.43	16.65
commit cleanouts successfully completed	17,098	0.43	16.57
commit immediate performed	1	0.00	0.00
commit immediate requested	1	0.00	0.00
commit txn count during cleanout	685	0.02	0.66
concurrency wait time	349	0.01	0.34
consistent changes	2,811	0.07	2.72
consistent gets	214,430,653	5,412.60	207,781.64
consistent gets - examination	2,385,495	60.21	2,311.53
consistent gets direct	47,673	1.20	46.19
consistent gets from cache	214,382,980	5,411.40	207,735.45
current blocks converted for CR	0	0.00	0.00
cursor authentications	905	0.02	0.88
data blocks consistent reads - undo records applied	1,781	0.04	1.73
db block changes	310,986	7.85	301.34
db block gets	287,223	7.25	278.32
db block gets direct	14	0.00	0.01
db block gets from cache	287,209	7.25	278.30
deferred (CURRENT) block cleanout applications	9,494	0.24	9.20
dirty buffers inspected	49	0.00	0.05
enqueue conversions	7,988	0.20	7.74
enqueue releases	357,160	9.02	346.09
enqueue requests	357,164	9.02	346.09
enqueue timeouts	5	0.00	0.00
enqueue waits	5	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	802,442	20.26	777.56
frame signature mismatch	0	0.00	0.00
free buffer inspected	177,649	4.48	172.14
free buffer requested	185,116	4.67	179.38
heap block compress	914	0.02	0.89
hot buffers moved to head of LRU	13,584	0.34	13.16
immediate (CR) block cleanout applications	83	0.00	0.08
immediate (CURRENT) block cleanout applications	2,426	0.06	2.35
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	6	0.00	0.01
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	1,067,435	26.94	1,034.34
index scans kdiixs1	184,016	4.64	178.31
leaf node 90-10 splits	102	0.00	0.10
leaf node splits	185	0.00	0.18
lob reads	7,456	0.19	7.22
lob writes	473	0.01	0.46
lob writes unaligned	473	0.01	0.46
logons cumulative	5,839	0.15	5.66
messages received	8,033	0.20	7.78
messages sent	8,033	0.20	7.78
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	211,344,706	5,334.71	204,791.38
opened cursors cumulative	710,241	17.93	688.22
parse count (failures)	3	0.00	0.00
parse count (hard)	2,314	0.06	2.24
parse count (total)	702,118	17.72	680.35
parse time cpu	1,860	0.05	1.80
parse time elapsed	3,237	0.08	3.14
physical read IO requests	80,594	2.03	78.09
physical read bytes	1,866,596,352	47,116.13	1,808,717.40
physical read total IO requests	153,343	3.87	148.59
physical read total bytes	11,719,726,592	295,826.20	11,356,324.22
physical read total multi block requests	31,696	0.80	30.71
physical reads	227,856	5.75	220.79
physical reads cache	180,178	4.55	174.59
physical reads cache prefetch	146,694	3.70	142.15
physical reads direct	47,678	1.20	46.20
physical reads direct (lob)	47,660	1.20	46.18
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	11,293	0.29	10.94
physical write bytes	112,664,576	2,843.85	109,171.10
physical write total IO requests	52,270	1.32	50.65
physical write total bytes	964,900,352	24,355.76	934,980.96
physical write total multi block requests	4,350	0.11	4.22
physical writes	13,753	0.35	13.33
physical writes direct	19	0.00	0.02
physical writes direct (lob)	14	0.00	0.01
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	13,734	0.35	13.31
physical writes non checkpoint	5,250	0.13	5.09
pinned buffers inspected	54	0.00	0.05
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	39,592	1.00	38.36
queries parallelized	0	0.00	0.00
recursive calls	926,050	23.38	897.34
recursive cpu usage	6,119	0.15	5.93
redo blocks written	103,278	2.61	100.08
redo buffer allocation retries	0	0.00	0.00
redo entries	151,772	3.83	147.07
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	2,826	0.07	2.74
redo size	50,186,332	1,266.79	48,630.17
redo synch time	2,262	0.06	2.19
redo synch writes	12,415	0.31	12.03
redo wastage	897,964	22.67	870.12
redo write time	4,524	0.11	4.38
redo writer latching time	0	0.00	0.00
redo writes	3,171	0.08	3.07
rollback changes - undo records applied	1,072	0.03	1.04
rollbacks only - consistent read gets	345	0.01	0.33
rows fetched via callback	689,816	17.41	668.43
session connect time	36,589	0.92	35.45
session cursor cache hits	664,323	16.77	643.72
session logical reads	214,717,876	5,419.85	208,059.96
session pga memory	22,260,752	561.90	21,570.50
session pga memory max	17,935,376	452.72	17,379.24
session uga memory	98,929,547,400	2,497,153.17	95,861,964.53
session uga memory max	1,411,010,220	35,616.34	1,367,257.97
shared hash latch upgrades - no wait	131,416	3.32	127.34
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	60,555	1.53	58.68
sorts (rows)	3,299,673	83.29	3,197.36
sql area purged	0	0.00	0.00
summed dirty queue length	390	0.01	0.38
switch current to new buffer	1,070	0.03	1.04
table fetch by rowid	1,164,511	29.39	1,128.40
table fetch continued row	538	0.01	0.52
table scan blocks gotten	210,787,125	5,320.63	204,251.09
table scan rows gotten	2,333,423,931	58,899.66	2,261,069.70
table scans (direct read)	0	0.00	0.00
table scans (long tables)	3,609	0.09	3.50
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	218,530	5.52	211.75
total number of times SMON posted	2	0.00	0.00
transaction rollbacks	1	0.00	0.00
undo change vector size	22,842,448	576.58	22,134.16
user I/O wait time	10,046	0.25	9.73
user calls	3,560,376	89.87	3,449.98
user commits	1,032	0.03	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	34,143	0.86	33.08
write clones created in background	1	0.00	0.00
write clones created in foreground	81	0.00	0.08

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	2,295,841	2,316,123
opened cursors current	140	42
logons current	125	125

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	2	0.18

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

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
VNVBANKDATA	72,456	2	2.84	3.02	1,881	8,855	3.78
SYSAUX	4,459	0	12.42	1.06	4,660	0	0.00
SYSTEM	3,680	0	13.85	1.18	1,049	0	0.00
UNDOTBS1	1	0	31610.00	1.00	3,702	0	0.00
USERS	8	0	32.50	2.50	1	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/oradata/unspay/sysaux01.dbf	4,459	0	12.42	1.06	4,660	0	0.00
SYSTEM	/oradata/unspay/system01.dbf	3,680	0	13.85	1.18	1,049	0	0.00
UNDOTBS1	/oradata/unspay/undotbs01.dbf	1	0	31610.00	1.00	3,702	0	0.00
USERS	/oradata/unspay/users01.dbf	8	0	32.50	2.50	1	0	0.00
VNVBANKDATA	/oradata/unspay/vnvbankdata01.dbf	72,456	2	2.84	3.02	1,881	8,855	3.78

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	164,164	100	214,668,965	180,192	13,734	0	0	8,855

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

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	44	14	173	271	1049	737280	1049
E	47	14	162	215	399	737280	399

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

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	128	0.10	16,016	4.22	171,254,486
D	256	0.20	32,032	4.18	169,902,125
D	384	0.29	48,048	1.74	70,691,894
D	512	0.39	64,064	1.01	40,940,853
D	640	0.49	80,080	1.01	40,839,577
D	768	0.59	96,096	1.00	40,816,238
D	896	0.68	112,112	1.00	40,801,450
D	1,024	0.78	128,128	1.00	40,771,643
D	1,152	0.88	144,144	1.00	40,703,211
D	1,280	0.98	160,160	1.00	40,620,761
D	1,312	1.00	164,164	1.00	40,616,666
D	1,408	1.07	176,176	1.00	40,604,377
D	1,536	1.17	192,192	1.00	40,589,370
D	1,664	1.27	208,208	1.00	40,582,098
D	1,792	1.37	224,224	1.00	40,580,183
D	1,920	1.46	240,240	1.00	40,577,528
D	2,048	1.56	256,256	1.00	40,577,260
D	2,176	1.66	272,272	1.00	40,575,618
D	2,304	1.76	288,288	1.00	40,574,786
D	2,432	1.85	304,304	0.95	38,391,752
D	2,560	1.95	320,320	0.54	21,909,963

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	1,473	0

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	876	714	172.41	0.00	0.00	0.00	0.00	102,400
E	876	717	159.05	0.00	0.00	0.00	0.00	102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	32,097	32,097
64K	128K	19	19
128K	256K	456	456
256K	512K	11	11
512K	1024K	1,529	1,529
1M	2M	7	7
2M	4M	2	2
16M	32M	1	1
32M	64M	4	4

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
110	0.13	4,671.21	273.55	94.00	9
219	0.25	4,671.21	187.96	96.00	0
438	0.50	4,671.21	0.00	100.00	0
657	0.75	4,671.21	0.00	100.00	0
876	1.00	4,671.21	0.00	100.00	0
1,051	1.20	4,671.21	0.00	100.00	0
1,226	1.40	4,671.21	0.00	100.00	0
1,402	1.60	4,671.21	0.00	100.00	0
1,577	1.80	4,671.21	0.00	100.00	0
1,752	2.00	4,671.21	0.00	100.00	0
2,628	3.00	4,671.21	0.00	100.00	0
3,504	4.00	4,671.21	0.00	100.00	0
5,256	6.00	4,671.21	0.00	100.00	0
7,008	8.00	4,671.21	0.00	100.00	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.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
112	0.70	16	1,451	401,093	1.00	6,561	1.25	58,685,102
128	0.80	31	2,317	401,533	1.00	6,121	1.17	58,765,228
144	0.90	46	4,340	401,972	1.00	5,682	1.08	58,844,603
160	1.00	61	6,229	402,411	1.00	5,243	1.00	58,923,546
176	1.10	76	7,582	402,850	1.00	4,804	0.92	59,002,883
192	1.20	91	9,564	403,015	1.00	4,639	0.88	59,030,780
208	1.30	106	11,218	403,179	1.00	4,475	0.85	59,057,577
224	1.40	121	12,954	403,282	1.00	4,372	0.83	59,077,491
240	1.50	136	14,153	403,385	1.00	4,269	0.81	59,097,402
256	1.60	151	15,512	403,412	1.00	4,242	0.81	59,103,313
272	1.70	152	15,621	403,439	1.00	4,215	0.80	59,109,218
288	1.80	152	15,621	403,464	1.00	4,190	0.80	59,114,997
304	1.90	152	15,621	403,489	1.00	4,165	0.79	59,120,776
320	2.00	152	15,621	403,501	1.00	4,153	0.79	59,125,181

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
384	0.25	272,140	40,616,643
768	0.50	271,624	40,616,643
1,152	0.75	271,624	40,616,643
1,536	1.00	271,624	40,616,643
1,920	1.25	271,624	40,616,643
2,304	1.50	271,624	40,616,643
2,688	1.75	271,624	40,616,643
3,072	2.00	271,624	40,616,643

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)	JP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
16	1.00	0	192	4	1.00	5,243	1.00	192
32	2.00	0	192	4	1.00	5,243	1.00	192

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	8,855	34	4

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TC-Tablespace Checkpoint	3	3	0	1	1	570.00
CF-Controlfile Transaction	18,940	18,940	0	4	0	10.00

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	3.07	5,281	811	3	180/180	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
22-Apr 08:52	4	146	0	1	180	0/0	0/0/0/0/0/0
22-Apr 08:42	2	6	811	1	180	0/0	0/0/0/0/0/0
22-Apr 08:32	3	164	207	1	180	0/0	0/0/0/0/0/0
22-Apr 08:22	0	7	0	0	180	0/0	0/0/0/0/0/0
22-Apr 08:12	3	109	0	1	180	0/0	0/0/0/0/0/0
22-Apr 08:02	60	49	0	3	180	0/0	0/0/0/0/0/0
22-Apr 07:52	5	84	0	2	180	0/0	0/0/0/0/0/0
22-Apr 07:42	1	7	0	1	180	0/0	0/0/0/0/0/0
22-Apr 07:32	2	205	0	1	180	0/0	0/0/0/0/0/0
22-Apr 07:22	2,274	566	0	3	180	0/0	0/0/0/0/0/0
22-Apr 07:12	0	62	0	0	180	0/0	0/0/0/0/0/0
22-Apr 07:02	40	39	0	3	180	0/0	0/0/0/0/0/0
22-Apr 06:52	0	13	0	0	180	0/0	0/0/0/0/0/0
22-Apr 06:42	1	8	0	1	180	0/0	0/0/0/0/0/0
22-Apr 06:32	1	20	0	1	180	0/0	0/0/0/0/0/0
22-Apr 06:22	0	6	0	0	180	0/0	0/0/0/0/0/0
22-Apr 06:12	0	66	0	0	180	0/0	0/0/0/0/0/0
22-Apr 06:02	46	44	0	3	180	0/0	0/0/0/0/0/0
22-Apr 05:52	0	11	0	0	180	0/0	0/0/0/0/0/0
22-Apr 05:42	1	12	0	1	180	0/0	0/0/0/0/0/0
22-Apr 05:32	1	13	0	1	180	0/0	0/0/0/0/0/0
22-Apr 05:22	1	8	0	1	180	0/0	0/0/0/0/0/0
22-Apr 05:12	2	66	0	1	180	0/0	0/0/0/0/0/0
22-Apr 05:02	30	38	0	2	180	0/0	0/0/0/0/0/0
22-Apr 04:52	1	17	0	1	180	0/0	0/0/0/0/0/0
22-Apr 04:42	1	12	0	1	180	0/0	0/0/0/0/0/0
22-Apr 04:32	1	11	0	1	180	0/0	0/0/0/0/0/0
22-Apr 04:22	0	6	0	0	180	0/0	0/0/0/0/0/0
22-Apr 04:12	0	67	0	0	180	0/0	0/0/0/0/0/0
22-Apr 04:02	40	39	0	2	180	0/0	0/0/0/0/0/0
22-Apr 03:52	2	15	0	1	180	0/0	0/0/0/0/0/0
22-Apr 03:42	1	15	0	1	180	0/0	0/0/0/0/0/0
22-Apr 03:32	1	64	0	1	180	0/0	0/0/0/0/0/0
22-Apr 03:22	119	79	0	3	180	0/0	0/0/0/0/0/0

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	204,230	0.00		0	0
Consistent RBA	3,173	0.00		0	0
FAL request queue	798	0.00		0	0
FAL subheap alocation	798	0.00		0	0
FIB s.o chain latch	296	0.00		0	0
FOB s.o list latch	1,061	0.00		0	0
In memory undo latch	30,571	0.00		0	9,534	0.00
JOX SGA heap latch	12	0.00		0	0
JS mem alloc latch	149	0.00		0	0
JS queue access latch	149	0.00		0	0
JS queue state obj latch	286,370	0.00		0	0
JS slv state obj latch	1,205	0.00		0	0
KMG MMAN ready and startup request latch	13,227	0.00		0	0
KMG resize request state object freelist	20	0.00		0	0
KTF sga latch	70	0.00		0	12,803	0.00
KWQMN job cache list latch	10	0.00		0	0
KWQP Prop Status	22	0.00		0	0
MQL Tracking Latch	0			0	786	0.00
Memory Management Latch	223	0.00		0	13,227	0.00
OS process	17,724	0.00		0	0
OS process allocation	25,020	0.04	0.45	0	0
OS process: request allocation	11,632	0.09	0.90	0	0
PL/SQL warning settings	53,355	0.00		0	0
SGA IO buffer pool latch	257	0.00		0	388	0.00
SQL memory manager latch	11	0.00		0	13,030	0.00
SQL memory manager workarea list latch	902,739	0.00		0	0
Shared B-Tree	1,446	0.00		0	0
X$KSFQP	21	0.00		0	0
active checkpoint queue latch	18,493	0.00		0	0
active service list	103,088	0.00		0	13,850	0.00
archive control	887	0.00		0	0
archive process latch	13,826	0.00		0	0
begin backup scn array	19	0.00		0	0
buffer pool	20	0.00		0	0
cache buffer handles	3,250	0.00		0	0
cache buffers chains	427,869,892	0.00	0.00	2	564,521	0.00
cache buffers lru chain	238,086	0.00	0.00	0	15,224,471	0.00
cache table scan latch	0			0	14,644	0.00
channel handle pool latch	11,634	0.03	0.75	0	0
channel operations parent latch	201,510	0.00	0.75	0	0
checkpoint queue latch	295,879	0.00		0	20,856	0.00
client/application info	30,141	0.00		0	0
commit callback allocation	36	0.00		0	0
compile environment latch	26,280	0.00		0	0
device information	15	0.00		0	0
dictionary lookup	90	0.00		0	0
dml lock allocation	20,999	0.00		0	0
dummy allocation	11,678	0.00		0	0
enqueue hash chains	722,314	0.00		0	35	0.00
enqueues	697,347	0.00	0.00	0	0
event group latch	5,816	0.00		0	0
file cache latch	892	0.00		0	0
global KZLD latch for mem in SGA	5,762	0.00		0	0
hash table column usage latch	1,262	0.00		0	320,959	0.00
hash table modification latch	737	0.00		0	0
job workq parent latch	0			0	46	0.00
job_queue_processes parameter latch	683	0.00		0	0
kks stats	7,038	0.00		0	0
kmcptab latch	3	0.00		0	0
kmcpvec latch	0			0	3	0.00
krbmrosl	207	0.00		0	0
ksuosstats global area	2,663	0.00		0	0
ktm global data	133	0.00		0	0
kwqbsn:qsga	1,435	0.00		0	0
lgwr LWN SCN	15,164	0.00		0	0
library cache	2,959,450	0.00	0.46	0	5,067	0.04
library cache load lock	8,096	0.00		0	0
library cache lock	372,259	0.00		0	0
library cache lock allocation	7,840	0.00		0	0
library cache pin	2,388,844	0.00	0.00	0	0
library cache pin allocation	2,071	0.00		0	0
list of block allocation	1,777	0.00		0	0
loader state object freelist	10,458	0.00		0	0
logminer context allocation	11	0.00		0	0
longop free list parent	17	0.00		0	17	0.00
message pool operations parent latch	2	0.00		0	0
messages	279,610	0.02	0.00	0	0
mostly latch-free SCN	15,164	0.00		0	0
multiblock read objects	48,252	0.00		0	4	0.00
ncodef allocation latch	659	0.00		0	0
object queue header heap	370	0.00		0	98	0.00
object queue header operation	430,137	0.00	0.00	0	0
object stats modification	63	0.00		0	1	0.00
parallel query alloc buffer	5,212	0.00		0	0
parameter list	11	0.00		0	0
parameter table allocation management	5,888	0.00		0	0
post/wait queue	3,193	0.00		0	2,021	0.00
process allocation	11,632	0.00		0	5,816	0.00
process group creation	11,632	0.07	0.38	0	0
qmn task queue latch	5,652	0.00		0	0
redo allocation	52,949	0.01	0.00	0	151,832	0.00
redo copy	0			0	151,833	0.04
redo writing	60,591	0.00		0	0
resmgr group change latch	6,195	0.00		0	0
resmgr:actses active list	11,641	0.00		0	0
resmgr:actses change group	5,793	0.00		0	0
resmgr:free threads list	11,630	0.00		0	0
resmgr:schema config	11	0.00		0	0
row cache objects	1,900,986	0.00		0	0
rules engine rule set statistics	1,100	0.00		0	0
sequence cache	20,526	0.00		0	0
session allocation	464,330	0.01	0.10	0	0
session idle bit	7,143,734	0.00	0.08	0	0
session state list latch	11,842	0.00		0	0
session switching	659	0.00		0	0
session timer	13,850	0.00		0	0
shared pool	663,719	0.00	0.50	0	0
sim partition latch	11	0.00		0	49	0.00
simulator hash latch	15,528,200	0.00		0	0
simulator lru latch	14,353,969	0.01	0.02	1	11,449	0.00
slave class	24	0.00		0	0
slave class create	96	7.29	1.00	0	0
sort extent pool	996	0.00		0	0
state object free list	132	0.00		0	0
statistics aggregation	1,540	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	1,697	0.00		0	0
transaction allocation	1,659	0.00		0	0
transaction branch allocation	659	0.00		0	0
undo global data	27,921	0.00		0	0
user lock	23,094	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	427,869,892	11,631	36	11,599
simulator lru latch	14,353,969	1,413	29	1,386
library cache	2,959,450	139	64	78
session allocation	464,330	60	6	54
shared pool	663,719	26	13	13
session idle bit	7,143,734	12	1	11
OS process allocation	25,020	11	5	6
OS process: request allocation	11,632	10	9	1
channel operations parent latch	201,510	8	6	2
process group creation	11,632	8	3	5
slave class create	96	7	7	0
channel handle pool latch	11,634	4	3	1

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
OS process allocation	kso_delete_process:1	5	5
OS process: request allocation	ksoreqholder_delete	9	9
cache buffers chains	kcbgtcr: kslbegin excl	32	40
cache buffers chains	kcbrls: kslbegin	8	1
cache buffers chains	kcbgtcr: fast path	3	2
channel handle pool latch	ksrchdelete()	3	3
channel operations parent latch	ksrchdelete()	6	6
library cache	kglhdgc: child:	15	0
library cache	kglpin: child: heap processing	14	29
library cache	kglhdgn: child:	10	1
library cache	kglpndl: child: before processing	7	28
library cache	kglobpn: child:	5	0
library cache	kglpndl: child: after processing	3	0
library cache	kgldte: child 0	1	1
library cache	kglic	1	0
library cache	kglpnc: child	1	4
library cache	kglpnp: child	1	0
library cache lock	kgllkdl: child: no lock handle	1	1
process group creation	ksupgprem	3	3
session allocation	ksudlp	4	3
session allocation	ksuxds: KSUSFCLC not set	2	0
session idle bit	ksupuc: set busy	1	0
shared pool	kghalo	11	0
shared pool	kghfrunp: clatch: nowait	5	0
shared pool	kghfre	1	0
shared pool	kghupr1	1	13
simulator lru latch	kcbs_simulate: simulate set	29	29
slave class create	ksvcreate	7	0

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: 214,717,876
Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
VNV	VNVBANKDATA	TRANSACTION	TABLE	208,133,296	96.93
VNV	VNVBANKDATA	PRODUCT_CLASS	TABLE	1,182,496	0.55
VNV	VNVBANKDATA	ACCOUNT_HIS	TABLE	591,936	0.28
VNV	VNVBANKDATA	PK_SUB_ACCOUNT	INDEX	477,248	0.22
VNV	VNVBANKDATA	SCORES_HIS	TABLE	378,448	0.18

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 227,856
Captured Segments account for 96.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
VNV	VNVBANKDATA	ACCOUNT_HIS	TABLE	64,335	28.23
VNV	VNVBANKDATA	TRANSACTION_HIS	TABLE	36,564	16.05
VNV	VNVBANKDATA	TRANS_DETAIL	TABLE	31,556	13.85
VNV	VNVBANKDATA	ACCT_BAL_HIS	TABLE	28,435	12.48
VNV	VNVBANKDATA	SYS_LOB0000051798C00032$$	LOB	14,863	6.52

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
VNV	VNVBANKDATA	PK_TRANSACTION		INDEX	57	100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	750	0.00	24	1
dc_files	4	0.00	0	4
dc_global_oids	79,636	0.00	0	109
dc_histogram_data	43,966	1.61	359	6,887
dc_histogram_defs	32,876	7.07	293	8,610
dc_object_grants	48	0.00	0	24
dc_object_ids	131,110	0.19	56	2,001
dc_objects	21,640	1.29	194	1,721
dc_profiles	5,808	0.00	0	1
dc_rollback_segments	7,096	0.00	0	22
dc_segments	7,182	1.52	109	1,930
dc_sequences	1,476	0.27	1,476	33
dc_tablespaces	77,980	0.00	0	6
dc_usernames	13,980	0.01	0	14
dc_users	272,631	0.00	0	19
global database name	17	0.00	0	1
outstanding_alerts	462	0.00	0	6

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	241	2.07	55,382	0.28	150	0
CLUSTER	174	0.00	445	1.35	6	0
INDEX	71	30.99	273	21.98	37	0
JAVA DATA	1	0.00	0		0	0
SQL AREA	2,965	31.50	950,452	0.41	1,430	94
TABLE/PROCEDURE	11,310	1.69	166,518	2.26	1,592	0
TRIGGER	72	5.56	72	5.56	0	0

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	158.70		1.25	4.31	33	35	127	127
	Freeable	12.63	0.00	0.74	0.34	1		17	17
	SQL	0.62	0.26	0.01	0.02	0	1	118	30
	PL/SQL	0.54	0.28	0.00	0.01	0	0	125	125
E	Other	153.43		1.21	4.31	33	35	127	127
	Freeable	5.06	0.00	0.84	0.45	1		6	6
	SQL	0.35	0.16	0.00	0.01	0	1	118	12
	PL/SQL	0.29	0.03	0.00	0.00	0	0	125	125

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,375,731,712
Fixed Size	1,219,664
Redo Buffers	15,556,608
Variable Size	218,104,752

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	11.18	11.18	0.00
java	joxlod exec hp	4.73	4.73	0.00
large	PX msg pool	0.86	0.86	0.00
large	free memory	15.14	15.14	0.00
shared	ASH buffers	4.00	4.00	0.00
shared	CCursor	2.32	2.23	-3.52
shared	FileOpenBlock	1.58	1.58	0.00
shared	Heap0: KGL	1.69	1.48	-12.28
shared	KCB Table Scan Buffer	4.00	4.00	0.00
shared	KGLS heap	3.50	3.02	-13.73
shared	KQR M PO	5.69	6.07	6.57
shared	KQR M SO	2.40	2.83	17.98
shared	KSFD SGA I/O b	4.00	4.00	0.00
shared	KTI-UNDO	2.36	2.36	0.00
shared	PCursor	1.71	1.70	-0.69
shared	PL/SQL MPCODE	2.74	3.09	12.80
shared	XDB Schema Cac	4.06	4.83	18.71
shared	db_block_hash_buckets	4.25	4.25	0.00
shared	event statistics per sess	2.56	2.56	0.00
shared	free memory	38.05	36.07	-5.20
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kglsim heap	1.61	1.61	0.00
shared	kglsim object batch	2.01	2.01	0.00
shared	krbmror	1.91	1.94	1.82
shared	library cache	7.23	8.23	13.83
shared	private strands	2.29	2.29	0.00
shared	row cache	3.57	3.57	0.00
shared	sessions	1.53	1.53	0.00
shared	sql area	9.94	9.12	-8.20
shared	trace buffer	2.36	2.36	0.00
streams	free memory	16.00	16.00	0.00
	buffer_cache	1,312.00	1,312.00	0.00
	fixed_sga	1.16	1.16	0.00
	log_buffer	14.84	14.84	0.00

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

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Coordinator	138,103	0	0
QMON Slaves	60,907	0	0

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

Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	0	0	0	0	0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
_kgl_large_heap_warning_threshold	52428800
audit_file_dest	/u01/app/oracle/admin/unspay/adump
background_dump_dest	/u01/app/oracle/admin/unspay/bdump
compatible	10.2.0.1.0
control_files	/u01/app/oracle/product/10.2.0/db_1/control01.ctl, /u01/app/oracle/product/10.2.0/db_1/control02.ctl, /u01/app/oracle/product/10.2.0/db_1/control03.ctl
core_dump_dest	/u01/app/oracle/admin/unspay/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	unspay
db_recovery_file_dest	/oradata/flash_recovery_area
db_recovery_file_dest_size	4294967296
dispatchers	(PROTOCOL=TCP) (SERVICE=unspayXDB)
fast_start_mttr_target	900
filesystemio_options	SETALL
job_queue_processes	10
log_archive_dest_1	location=/oradata/unspay_archlog1 mandatory
log_archive_dest_2	location=/oradata/unspay_archlog2 optional
log_archive_format	arch_%d_%t_%r_%s.log
open_cursors	300
optimizer_mode	FIRST_ROWS_100
pga_aggregate_target	918552576
processes	300
remote_login_passwordfile	EXCLUSIVE
sga_target	1610612736
undo_management	AUTO
undo_retention	10800
undo_tablespace	UNDOTBS1
user_dump_dest	/u01/app/oracle/admin/unspay/udump

End of Report Report written to awrrpt_1_20298_20309.html SQL>

% Blocks changed per Read:	0.14	Recursive Call %:	20.64
Rollback per transaction %:	0.00	Rows per Sort:	54.49

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.94	In-memory Sort %:	100.00
Library Hit %:	99.33	Soft Parse %:	99.67
Execute to Parse %:	12.50	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	57.46	% Non-Parse CPU:	99.30