WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

PORTAL 4084336433 portal2 2 10.2.0.4.0 YES rbt_db2

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
PORTAL	4084336433	portal2	2	10.2.0.4.0	YES	rbt_db2

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 21940 09-May-12 14:59:56 58 1.8

End Snap: 21941 09-May-12 16:00:38 39 2.1

Elapsed: 60.69 (mins)

DB Time: 0.73 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	21940	09-May-12 14:59:56	58	1.8
End Snap:	21941	09-May-12 16:00:38	39	2.1
Elapsed:		60.69 (mins)
DB Time:		0.73 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 2,416M 2,416M Std Block Size: 8K

Shared Pool Size: 3,664M 3,664M Log Buffer: 14,336K

	Begin	End
Buffer Cache:	2,416M	2,416M	Std Block Size:	8K
Shared Pool Size:	3,664M	3,664M	Log Buffer:	14,336K

Load Profile

Per Second Per Transaction

Redo size: 749.43 637.65

Logical reads: 2,241.00 1,906.74

Block changes: 3.18 2.71

Physical reads: 1.90 1.62

Physical writes: 0.58 0.49

User calls: 16.73 14.23

Parses: 7.62 6.48

Hard parses: 0.27 0.23

Sorts: 4.09 3.48

Logons: 0.03 0.03

Executes: 8.29 7.05

Transactions: 1.18

	Per Second	Per Transaction
Redo size:	749.43	637.65
Logical reads:	2,241.00	1,906.74
Block changes:	3.18	2.71
Physical reads:	1.90	1.62
Physical writes:	0.58	0.49
User calls:	16.73	14.23
Parses:	7.62	6.48
Hard parses:	0.27	0.23
Sorts:	4.09	3.48
Logons:	0.03	0.03
Executes:	8.29	7.05
Transactions:	1.18

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

Rollback per transaction %: 86.75 Rows per Sort: 7.12

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 92.89 Soft Parse %: 96.44

Execute to Parse %: 8.04 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 6.97 % Non-Parse CPU: 99.37

Shared Pool Statistics

Begin End

Memory Usage %: 9.58 10.10

% SQL with executions>1: 64.49 80.93

% Memory for SQL w/exec>1: 70.17 81.10

	Begin	End
Memory Usage %:	9.58	10.10
% SQL with executions>1:	64.49	80.93
% Memory for SQL w/exec>1:	70.17	81.10

Top 5 Timed Events

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

SQL*Net more data from client 3,094 167 54 380.5 Network

CPU time 27 61.1

Streams AQ: qmn coordinator waiting for slave to start 3 15 5,147 35.1 Other

db file sequential read 2,272 10 5 23.7 User I/O

db file scattered read 802 4 5 10.0 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
SQL*Net more data from client	3,094	167	54	380.5	Network
CPU time		27		61.1
Streams AQ: qmn coordinator waiting for slave to start	3	15	5,147	35.1	Other
db file sequential read	2,272	10	5	23.7	User I/O
db file scattered read	802	4	5	10.0	User I/O

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 1.61 1.37

Global Cache blocks served: 1.47 1.25

GCS/GES messages received: 5.75 4.89

GCS/GES messages sent: 6.04 5.14

DBWR Fusion writes: 0.08 0.07

Estd Interconnect traffic (KB) 26.93

	Per Second	Per Transaction
Global Cache blocks received:	1.61	1.37
Global Cache blocks served:	1.47	1.25
GCS/GES messages received:	5.75	4.89
GCS/GES messages sent:	6.04	5.14
DBWR Fusion writes:	0.08	0.07
Estd Interconnect traffic (KB)	26.93

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 99.84

Buffer access - remote cache %: 0.07

Buffer access - disk %: 0.08

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0

Avg global cache cr block receive time (ms): 0.3

Avg global cache current block receive time (ms): 0.5

Avg global cache cr block build time (ms): 0.0

Avg global cache cr block send time (ms): 0.0

Global cache log flushes for cr blocks served %: 0.5

Avg global cache cr block flush time (ms): 0.0

Avg global cache current block pin time (ms): 0.0

Avg global cache current block send time (ms): 0.0

Global cache log flushes for current blocks served %: 0.0

Avg global cache current block flush time (ms): 5.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

Avg message sent queue time on ksxp (ms): 0.1

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 50.77

% of indirect sent messages: 28.95

% of flow controlled messages: 20.29

Main Report

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

Wait Events Statistics

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

Time Model Statistics

Total time in database user-calls (DB Time): 44s
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
sql execute elapsed time	29.81	67.74
DB CPU	26.87	61.07
parse time elapsed	1.93	4.40
hard parse elapsed time	1.23	2.79
sequence load elapsed time	0.08	0.19
connection management call elapsed time	0.07	0.17
failed parse elapsed time	0.01	0.03
PL/SQL execution elapsed time	0.01	0.02
hard parse (bind mismatch) elapsed time	0.00	0.01
hard parse (sharing criteria) elapsed time	0.00	0.01
repeated bind elapsed time	0.00	0.00
DB time	44.00
background elapsed time	45.75
background cpu time	28.33

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
Network	39,200	0.00	167	4	9.16
User I/O	3,333	0.00	17	5	0.78
Other	44,595	95.63	16	0	10.42
System I/O	13,502	0.00	4	0	3.15
Cluster	8,525	0.00	2	0	1.99
Commit	570	0.00	0	1	0.13
Concurrency	476	0.00	0	1	0.11
Application	136	0.00	0	0	0.03
Configuration	4	0.00	0	0	0.00

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
SQL*Net more data from client	3,094	0.00	167	54	0.72
Streams AQ: qmn coordinator waiting for slave to start	3	100.00	15	5147	0.00
db file sequential read	2,272	0.00	10	5	0.53
db file scattered read	802	0.00	4	5	0.19
control file sequential read	9,399	0.00	2	0	2.20
db file parallel read	257	0.00	2	8	0.06
control file parallel write	1,213	0.00	1	1	0.28
db file parallel write	1,831	0.00	1	0	0.43
gc current block 2-way	2,680	0.00	1	0	0.63
gc cr multi block request	3,536	0.00	1	0	0.83
log file parallel write	1,059	0.00	0	0	0.25
log file sync	570	0.00	0	1	0.13
CGS wait for IPC msg	36,120	100.00	0	0	8.44
gc cr block 2-way	753	0.00	0	0	0.18
enq: WF - contention	13	0.00	0	10	0.00
gc cr grant 2-way	787	0.00	0	0	0.18
row cache lock	424	0.00	0	0	0.10
os thread startup	5	0.00	0	22	0.00
gc current grant 2-way	459	0.00	0	0	0.11
latch free	4	0.00	0	13	0.00
enq: PS - contention	152	0.00	0	0	0.04
reliable message	269	0.00	0	0	0.06
PX Deq: reap credit	3,507	93.13	0	0	0.82
SQL*Net message to client	34,821	0.00	0	0	8.14
gc current grant busy	189	0.00	0	0	0.04
DFS lock handle	138	0.00	0	0	0.03
gc current multi block request	100	0.00	0	0	0.02
ksxr poll remote instances	3,745	81.92	0	0	0.88
enq: TQ - TM contention	97	0.00	0	0	0.02
enq: TM - contention	110	0.00	0	0	0.03
PX Deq Credit: send blkd	141	63.12	0	0	0.03
rdbms ipc reply	140	0.00	0	0	0.03
SQL*Net more data to client	1,285	0.00	0	0	0.30
read by other session	2	0.00	0	6	0.00
gc current block busy	8	0.00	0	1	0.00
gcs log flush sync	18	11.11	0	1	0.00
PX Deq: Signal ACK	192	34.38	0	0	0.04
gc cr block busy	11	0.00	0	1	0.00
IPC send completion sync	30	100.00	0	0	0.01
library cache lock	24	0.00	0	0	0.01
library cache pin	23	0.00	0	0	0.01
SQL*Net break/reset to client	26	0.00	0	0	0.01
enq: TA - contention	13	0.00	0	0	0.00
enq: FB - contention	4	0.00	0	0	0.00
enq: HW - contention	3	0.00	0	0	0.00
gc buffer busy	2	0.00	0	0	0.00
enq: DR - contention	2	0.00	0	0	0.00
enq: TX - allocate ITL entry	1	0.00	0	0	0.00
LGWR wait for redo copy	6	0.00	0	0	0.00
latch: session allocation	1	0.00	0	0	0.00
SQL*Net message from client	34,840	0.00	73,467	2109	8.14
gcs remote message	252,081	99.37	7,110	28	58.90
Streams AQ: qmn slave idle wait	144	2.78	3,722	25849	0.03
DIAG idle wait	18,209	0.00	3,556	195	4.25
ges remote message	47,677	98.00	3,556	75	11.14
PX Idle Wait	1,498	93.86	3,555	2373	0.35
Streams AQ: waiting for messages in the queue	749	96.80	3,543	4731	0.18
Streams AQ: qmn coordinator idle wait	264	49.24	3,529	13369	0.06
virtual circuit status	121	100.00	3,518	29071	0.03
Streams AQ: waiting for time management or cleanup tasks	202	92.08	3,489	17273	0.05
PX Deq: Execution Msg	390	6.15	0	1	0.09
PX Deq: Join ACK	201	35.82	0	0	0.05
PX Deq: Parse Reply	154	18.83	0	0	0.04
PX Deq: Execute Reply	164	34.15	0	0	0.04
PX Deq: Msg Fragment	92	10.87	0	0	0.02
Streams AQ: RAC qmn coordinator idle wait	264	100.00	0	0	0.06
class slave wait	5	0.00	0	0	0.00

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
events in waitclass Other	40,575	97.10	16	0	9.48
control file sequential read	8,205	0.00	2	0	1.92
control file parallel write	1,213	0.00	1	1	0.28
db file parallel write	1,831	0.00	1	0	0.43
log file parallel write	1,059	0.00	0	0	0.25
os thread startup	5	0.00	0	22	0.00
row cache lock	111	0.00	0	0	0.03
enq: TM - contention	102	0.00	0	0	0.02
gc cr block 2-way	42	0.00	0	0	0.01
gc current block 2-way	50	0.00	0	0	0.01
gc current grant busy	11	0.00	0	0	0.00
gc cr block busy	1	0.00	0	1	0.00
gc current multi block request	12	0.00	0	0	0.00
rdbms ipc message	53,950	94.20	39,048	724	12.61
gcs remote message	252,081	99.37	7,110	28	58.90
smon timer	13	100.00	3,752	288595	0.00
pmon timer	1,268	100.00	3,556	2804	0.30
DIAG idle wait	18,208	0.00	3,556	195	4.25
ges remote message	47,679	97.99	3,556	75	11.14
Streams AQ: qmn coordinator idle wait	264	49.24	3,529	13369	0.06
Streams AQ: waiting for time management or cleanup tasks	202	92.08	3,489	17273	0.05
PX Deq: Join ACK	27	44.44	0	0	0.01
PX Deq: Parse Reply	23	43.48	0	0	0.01
PX Deq: Execute Reply	20	30.00	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	264	100.00	0	0	0.06

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	2,780
AVG_IDLE_TIME	362,238
AVG_IOWAIT_TIME	267
AVG_SYS_TIME	1,491
AVG_USER_TIME	1,179
BUSY_TIME	23,128
IDLE_TIME	2,898,737
IOWAIT_TIME	2,983
SYS_TIME	12,851
USER_TIME	10,277
LOAD	0
OS_CPU_WAIT_TIME	151,100
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	16,441,671,680
NUM_CPUS	8
NUM_CPU_CORES	4

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
portal	33.70	17.80	6,606	333,139
SYS$USERS	10.30	9.00	0	3,844,231
SYS$BACKGROUND	0.00	0.00	325	3,983,623
portalXDB	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	Network Total Wts	Network Wt Time
portal	3002	1595	199	5	34465	16448
SYS$USERS	0	0	0	0	4573	1
SYS$BACKGROUND	340	87	277	19	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
SQL ordered by Cluster Wait Time
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
5	0	137	0.04	12.19	69zbya7t6q35n	JDBC Thin Client	insert into T_SYS_ACCESSLOGS (...
5	5	97	0.05	10.56	4cvqvs489pd6k		select min(next_date) from "SY...
4	2	1,056	0.00	8.94	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
2	2	1,282	0.00	4.16	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
1	1	1	0.95	2.16	1wm04r5z1ftkw	JDBC Thin Client	select * from ( select t12580a...
1	1	1	0.93	2.12	bnfyb2q7jp308	JDBC Thin Client	select count(*) as col_0_0_ fr...
1	1	25	0.03	1.64	190unkpdg99p7	JDBC Thin Client	select * from ( select news0_....
1	1	6,032	0.00	1.54	953hsjnbvbrcb	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
1	1	1,011	0.00	1.32	c4wx2rkhsgvm5	JDBC Thin Client	select t.id, t.name, t.bussi...
1	1	1	0.52	1.19	bunssq950snhf		insert into wrh$_sga_target_ad...

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
5	5	97	0.05	10.56	4cvqvs489pd6k		select min(next_date) from "SY...
2	4	1,056	0.00	8.94	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
2	2	1,282	0.00	4.16	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
1	1	1	0.95	2.16	1wm04r5z1ftkw	JDBC Thin Client	select * from ( select t12580a...
1	1	1	0.93	2.12	bnfyb2q7jp308	JDBC Thin Client	select count(*) as col_0_0_ fr...
1	1	6,032	0.00	1.54	953hsjnbvbrcb	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
1	1	1,011	0.00	1.32	c4wx2rkhsgvm5	JDBC Thin Client	select t.id, t.name, t.bussi...
1	1	1	0.52	1.19	bunssq950snhf		insert into wrh$_sga_target_ad...
1	1	25	0.02	1.64	190unkpdg99p7	JDBC Thin Client	select * from ( select news0_....
0	5	137	0.00	12.19	69zbya7t6q35n	JDBC Thin Client	insert into T_SYS_ACCESSLOGS (...

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: 8,160,847
Captured SQL account for 27.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,982,554	97	20,438.70	24.29	4.51	4.65	4cvqvs489pd6k		select min(next_date) from "SY...
64,704	1,011	64.00	0.79	0.58	0.58	c4wx2rkhsgvm5	JDBC Thin Client	select t.id, t.name, t.bussi...
42,210	6,032	7.00	0.52	0.68	0.68	953hsjnbvbrcb	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
18,255	25	730.20	0.22	0.51	0.72	190unkpdg99p7	JDBC Thin Client	select * from ( select news0_....
17,168	1,073	16.00	0.21	0.13	0.13	8sqysbs1s8hrr	JDBC Thin Client	select count(*) as col_0_0_ fr...
16,506	2,358	7.00	0.20	0.29	0.29	5cqctydwqs1w2	JDBC Thin Client	select activity0_.ID as ID5_, ...
11,398	1,056	10.79	0.14	1.78	3.93	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
10,332	2	5,166.00	0.13	0.29	0.30	g8qgtaw19n82d	JDBC Thin Client	select * from ( select news0_....
10,094	1,442	7.00	0.12	0.15	0.15	4p1sd0jvasbz0	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
9,345	2,336	4.00	0.11	0.34	0.35	2ckbmh5m8pd68	JDBC Thin Client	select user0_.PHONE_NUMBER as ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 6,922
Captured SQL account for 38.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
877	1,056	0.83	12.67	1.78	3.93	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
660	137	4.82	9.53	0.38	5.36	69zbya7t6q35n	JDBC Thin Client	insert into T_SYS_ACCESSLOGS (...
616	1,282	0.48	8.90	1.72	1.83	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
100	1	100.00	1.44	0.19	0.41	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
87	1	87.00	1.26	0.01	0.13	f3sas2qvxujnx	JDBC Thin Client	select count(*) from T_FC_FIRS...
68	2	34.00	0.98	0.03	0.15	23ycj099jhc46	JDBC Thin Client	select count(*) from T_FC_FIRS...
60	2	30.00	0.87	0.01	0.13	84qyg0m594wcv	JDBC Thin Client	select count(*) from T_FC_FIRS...
48	303	0.16	0.69	0.27	0.30	03164c4t3c5xw	JDBC Thin Client	insert into T_FC_FIRST_LOGIN_L...
45	1	45.00	0.65	0.02	0.09	31a13pnjps7j3		SELECT source, (case w...
37	7	5.29	0.53	0.03	0.16	f147hvknkr0s2	JDBC Thin Client	insert into T_FC_IP_ADDRESS (U...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 30,175
Captured SQL account for 82.5% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
6,032	21,730	3.60	953hsjnbvbrcb	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
2,358	0	0.00	5cqctydwqs1w2	JDBC Thin Client	select activity0_.ID as ID5_, ...
2,336	2,336	1.00	2ckbmh5m8pd68	JDBC Thin Client	select user0_.PHONE_NUMBER as ...
2,329	0	0.00	ax0z40kwrxhu4	JDBC Thin Client	select operations0_.PHONE_NUMB...
1,445	1,445	1.00	cmqhvqu3u4hd6	JDBC Thin Client	select SEQ_SYS_ACCESSLOGS.next...
1,442	1,442	1.00	4p1sd0jvasbz0	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
1,282	1,244	0.97	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
1,073	1,073	1.00	8sqysbs1s8hrr	JDBC Thin Client	select count(*) as col_0_0_ fr...
1,056	3,913	3.71	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
1,011	9,072	8.97	c4wx2rkhsgvm5	JDBC Thin Client	select t.id, t.name, t.bussi...
728	0	0.00	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
558	3,906	7.00	816dsfgbhqq3u	JDBC Thin Client	select categories0_.ID as ID82...
303	303	1.00	03164c4t3c5xw	JDBC Thin Client	insert into T_FC_FIRST_LOGIN_L...
303	303	1.00	dm3h4zdprmsch	JDBC Thin Client	select SEQ_FIRST_LOGIN_LOGS.ne...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 27,749
Captured SQL account for 86.5% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
6,033	6,032	21.74	953hsjnbvbrcb	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
2,358	2,358	8.50	5cqctydwqs1w2	JDBC Thin Client	select activity0_.ID as ID5_, ...
2,336	2,336	8.42	2ckbmh5m8pd68	JDBC Thin Client	select user0_.PHONE_NUMBER as ...
2,333	2,329	8.41	ax0z40kwrxhu4	JDBC Thin Client	select operations0_.PHONE_NUMB...
1,445	1,445	5.21	cmqhvqu3u4hd6	JDBC Thin Client	select SEQ_SYS_ACCESSLOGS.next...
1,442	1,442	5.20	4p1sd0jvasbz0	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
1,282	1,282	4.62	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
1,073	1,073	3.87	8sqysbs1s8hrr	JDBC Thin Client	select count(*) as col_0_0_ fr...
1,056	1,056	3.81	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
1,011	1,011	3.64	c4wx2rkhsgvm5	JDBC Thin Client	select t.id, t.name, t.bussi...
558	558	2.01	816dsfgbhqq3u	JDBC Thin Client	select categories0_.ID as ID82...
303	303	1.09	03164c4t3c5xw	JDBC Thin Client	insert into T_FC_FIRST_LOGIN_L...
303	303	1.09	dm3h4zdprmsch	JDBC Thin Client	select SEQ_FIRST_LOGIN_LOGS.ne...
279	279	1.01	7djxb2a6x996p	JDBC Thin Client	select refoperati0_.OPERATION_...

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

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)	CWT % of Elapsd Time	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
0.22	11.93	1.83	1.72	1,282	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
0.12	3.09	3.93	1.78	1,056	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
0.12	34.19	0.35	0.34	2,336	2ckbmh5m8pd68	JDBC Thin Client	select user0_.PHONE_NUMBER as ...
0.09	30.70	0.30	0.27	303	03164c4t3c5xw	JDBC Thin Client	insert into T_FC_FIRST_LOGIN_L...
0.09	1.63	5.36	0.38	137	69zbya7t6q35n	JDBC Thin Client	insert into T_SYS_ACCESSLOGS (...
0.03	18.35	0.15	0.03	2	23ycj099jhc46	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.02	16.34	0.14	0.01	1	bp304k2yqv789	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.02	23.63	0.10	0.10	77	a4c6qvukwpabv	JDBC Thin Client	update T_FC_USER set MOBILE_TY...
0.02	12.63	0.13	0.01	2	84qyg0m594wcv	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.01	3.13	0.41	0.19	1	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0.01	7.71	0.16	0.03	7	f147hvknkr0s2	JDBC Thin Client	insert into T_FC_IP_ADDRESS (U...
0.01	5.43	0.13	0.01	1	f3sas2qvxujnx	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.01	16.70	0.03	0.03	95	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
0.01	5.28	0.10	0.08	52	db78fxqxwxt7r		select /+ rule / bucket, en...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

03164c4t3c5xw insert into T_FC_FIRST_LOGIN_LOGS (PHONE_NUMBER, CHANNEL, ACTIVITY_TYPE, LOGIN_TIME, ID) values (:1, :2, :3, :4, :5)

190unkpdg99p7 select * from ( select news0_.ID as ID34_, news0_.CATEGORY as CATEGORY34_, news0_.AREA_ID as AREA3_34_, news0_.TITLE as TITLE34_, news0_.AUTHOR as AUTHOR34_, news0_.SOURCE as SOURCE34_, news0_.IS_IMAGE_NEWS as IS7_34_, news0_.IMAGE as IMAGE34_, news0_.IMAGE_FORMAT as IMAGE9_34_, news0_.SIMPLE_CONTENT as SIMPLE10_34_, news0_.CONTENT as CONTENT34_, news0_.IS_HOT as IS12_34_, news0_.UPLOAD_TIME as UPLOAD13_34_, news0_.IS_AUDIT as IS14_34_, news0_.OPERATOR as OPERATOR34_, news0_.AUDIT_OPER as AUDIT16_34_, news0_.AUDIT_TIME as AUDIT17_34_, news0_.OVERRULE_CAUSE as OVERRULE18_34_, news0_.STATUS as STATUS34_, news0_.SEARCH_TYPE as SEARCH20_34_, news0_.SEARCH_KEY as SEARCH21_34_, news0_.STAT_NUMS as STAT22_34_, news0_.REMARK as REMARK34_, news0_.IS_URL as IS24_34_, news0_.OPERATIONID as OPERATI25_34_, news0_.END_DATE as END26_34_, news0_.NEWS_IFS_ID as NEWS27_34_ from T_CMS_NEWS news0_ where news0_.CATEGORY=:1 and news0_.AREA_ID=:2 and news0_.STATUS=:3 and news0_.END_DATE>:4 order by news0_.UPLOAD_TIME desc ) where rownum <= :5

1wm04r5z1ftkw select * from ( select t12580all0_.ID as ID65_, t12580all0_.CITY as CITY65_, t12580all0_.TYPES as TYPES65_, t12580all0_.NAMES as NAMES65_, t12580all0_.PHONENUMBER as PHONENUM5_65_, t12580all0_.ADDRESS as ADDRESS65_, t12580all0_.LEVELES as LEVELES65_, t12580all0_.SHOP_SUMMARY as SHOP8_65_, t12580all0_.QUERY_NUM as QUERY9_65_ from T_FC_12580_ALL t12580all0_ where 1=1 and (t12580all0_.NAMES like :1) order by t12580all0_.QUERY_NUM desc ) where rownum <= :2

23ycj099jhc46 select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13959023682' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')

2ckbmh5m8pd68 select user0_.PHONE_NUMBER as PHONE1_48_, user0_.BLOG_NAME as BLOG2_48_, user0_.NICK_NAME as NICK3_48_, user0_.WEL_TITLE as WEL4_48_, user0_.AREA_ID as AREA5_48_, user0_.BRAND as BRAND48_, user0_.PAY_KIND as PAY7_48_, user0_.IS_ARREAR as IS8_48_, user0_.MOBILE_TYPE as MOBILE9_48_, user0_.USER_AGENT as USER10_48_, user0_.CREATE_DATE as CREATE11_48_, user0_.UPDATE_TIME as UPDATE12_48_, user0_.VISIT_COUNT as VISIT13_48_, user0_.THEME_NAME as THEME14_48_, user0_.MOOD as MOOD48_, user0_.FLAG as FLAG48_, user0_.VERSION as VERSION48_ from T_FC_USER user0_ where user0_.PHONE_NUMBER=:1

31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC

4cvqvs489pd6k select min(next_date) from "SYS"."AQ$_ALERT_QT_T"

4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1

4p1sd0jvasbz0 select zhangtingb0_.ID as ID6_, zhangtingb0_.NAME as NAME6_, zhangtingb0_.CBURL as CBURL6_, zhangtingb0_.URL as URL6_, zhangtingb0_.TYPE as TYPE6_, zhangtingb0_.DISPLAY_ORDER as DISPLAY6_6_ from T_FC_ZHANGTING zhangtingb0_ where zhangtingb0_.TYPE=:1 and (zhangtingb0_.NAME like :2) order by zhangtingb0_.DISPLAY_ORDER

59q9puwma9gnp select viewnotes0_.ID as ID81_, viewnotes0_.PHONE_NUMBER as PHONE2_81_, viewnotes0_.CATEGORY_ID as CATEGORY3_81_, viewnotes0_.CONTENT as CONTENT81_, viewnotes0_.ORDER_CONTENT as ORDER5_81_, viewnotes0_.ORDER_TIME as ORDER6_81_, viewnotes0_.RANKING as RANKING81_, viewnotes0_.SETTED as SETTED81_, viewnotes0_.SHOW_TYPE as SHOW9_81_ from T_FC_VIEW_NOTES viewnotes0_, T_FC_CATEGORIES categories1_ where viewnotes0_.CATEGORY_ID=categories1_.ID and viewnotes0_.PHONE_NUMBER=:1 and categories1_.STATUS=:2 order by viewnotes0_.ID

5cqctydwqs1w2 select activity0_.ID as ID5_, activity0_.TOPIC as TOPIC5_, activity0_.STARTTIME as STARTTIME5_, activity0_.ENDTIME as ENDTIME5_, activity0_.STATUS as STATUS5_, activity0_.BANNERTYPE as BANNERTYPE5_, activity0_.BANNER as BANNER5_, activity0_.CONTENT as CONTENT5_, activity0_.ACTIVITYURL as ACTIVITY9_5_, activity0_.CITY as CITY5_ from T_FC_ACTIVITY activity0_ where activity0_.BANNERTYPE=:1 and to_char(activity0_.STARTTIME, 'yyyy-MM-dd')<=to_char(:2, 'yyyy-MM-dd') and to_char(activity0_.ENDTIME, 'yyyy-MM-dd')>=to_char(:3, 'yyyy-MM-dd') and activity0_.STATUS=:4 and (activity0_.CITY like :5) order by activity0_.ID

69zbya7t6q35n insert into T_SYS_ACCESSLOGS (URL_ID, OPERATION_NAME, ACCESSDATE, IP, PHONENUMBER, URL, UA, SESSIONID, REMARKS, AREA, WAP_OR_NET, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)

6sgbxr6bgs7pa select MOBILE_TYPE, USER_AGENT, AREA_ID from T_FC_USER where PHONE_NUMBER = :1

6ssrk2dqj7jbx select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job

7djxb2a6x996p select refoperati0_.OPERATION_ID as OPERATION1_1_, refoperati0_.SUB_OPERATION_ID as SUB2_1_, operation1_.ID as ID40_0_, operation1_.SUPERIOR as SUPERIOR40_0_, operation1_.CODE as CODE40_0_, operation1_.TYPE as TYPE40_0_, operation1_.NAME as NAME40_0_, operation1_.URL as URL40_0_, operation1_.DES_PIC as DES7_40_0_, operation1_.STATUS as STATUS40_0_, operation1_.INFO as INFO40_0_, operation1_.SP_INFO as SP10_40_0_, operation1_.FOCUS as FOCUS40_0_, operation1_.FAVORITE as FAVORITE40_0_, operation1_.MY_PLACE as MY13_40_0_, operation1_.PLACE as PLACE40_0_, operation1_.RECENT as RECENT40_0_, operation1_.CREATE_DATE as CREATE16_40_0_, operation1_.END_DATE as END17_40_0_, operation1_.FLAG as FLAG40_0_, operation1_.USAGE_MODE as USAGE19_40_0_, operation1_.COST_EXPLAIN as COST20_40_0_, operation1_.WAP_CALL_URL as WAP21_40_0_, operation1_.IVR_CALL_URL as IVR22_40_0_, operation1_.HELP_FAQ as HELP23_40_0_, operation1_.EXT_ACCESS as EXT24_40_0_, operation1_.TITLE_COLOR as TITLE25_40_0_, operation1_.BUSINESS_IFS_TYPE as BUSINESS26_40_0_, operation1_.SERVICE_OPTION as SERVICE27_40_0_, operation1_.BIZ_TYPE as BIZ28_40_0_, operation1_.SP_ID as SP29_40_0_, operation1_.SP_BIZ_CODE as SP30_40_0_, operation1_.HOME_DOMAIN as HOME31_40_0_, operation1_.ORIG_DOMAIN as ORIG32_40_0_, operation1_.SUCCESS_INFO as SUCCESS33_40_0_, operation1_.OPR_CODE_OPEN as OPR34_40_0_, operation1_.OPR_CODE_CLOSE as OPR35_40_0_, operation1_.PRICE as PRICE40_0_, operation1_.ORDER_TYPE as ORDER37_40_0_, operation1_.SHORT_DES as SHORT38_40_0_, operation1_.LONG_DES as LONG39_40_0_, operation1_.FAINT_WORD as FAINT40_40_0_, operation1_.SIMPLE_DES as SIMPLE41_40_0_, operation1_.bg_pic as bg42_40_0_, operation1_.ACTION_URL as ACTION43_40_0_, operation1_.OPEN_URL as OPEN44_40_0_, operation1_.BUSSINESS_TYPE as BUSSINESS45_40_0_, operation1_.DISPLAY_ORDER as DISPLAY46_40_0_, operation1_.BUSSINESS_TYPE_ORDER as BUSSINESS47_40_0_ from T_FC_OPERATION_OPERATION refoperati0_ left outer join T_FC_OPERATION operation1_ on refoperati0_.SUB_OPERATION_ID=operation1_.ID where refoperati0_.OPERATION_ID in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10) order by refoperati0_.place asc

816dsfgbhqq3u select categories0_.ID as ID82_0_, categories0_.NAME as NAME82_0_, categories0_.TYPE as TYPE82_0_, categories0_.STATUS as STATUS82_0_, categories0_.DEF_LOCATION as DEF5_82_0_, categories0_.ALLOW_SET as ALLOW6_82_0_ from T_FC_CATEGORIES categories0_ where categories0_.ID in (:1, :2, :3, :4, :5, :6, :7)

84qyg0m594wcv select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13850584468' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')

8sqysbs1s8hrr select count(*) as col_0_0_ from T_FC_HOT_BUSINESS hotbusines0_ where hotbusines0_.STARTTIME<=:1 and hotbusines0_.ENDTIME>=:2 and hotbusines0_.STATUS=1

953hsjnbvbrcb select zhangtingb0_.ID as ID6_, zhangtingb0_.NAME as NAME6_, zhangtingb0_.CBURL as CBURL6_, zhangtingb0_.URL as URL6_, zhangtingb0_.TYPE as TYPE6_, zhangtingb0_.DISPLAY_ORDER as DISPLAY6_6_ from T_FC_ZHANGTING zhangtingb0_ where zhangtingb0_.TYPE=:1 order by zhangtingb0_.DISPLAY_ORDER

a4c6qvukwpabv update T_FC_USER set MOBILE_TYPE = :1 , USER_AGENT = :2, AREA_ID=:3 , UPDATE_TIME = sysdate where PHONE_NUMBER = :4

ax0z40kwrxhu4 select operations0_.PHONE_NUMBER as PHONE1_1_, operations0_.OPERATION_ID as OPERATION2_1_, operation1_.ID as ID40_0_, operation1_.SUPERIOR as SUPERIOR40_0_, operation1_.CODE as CODE40_0_, operation1_.TYPE as TYPE40_0_, operation1_.NAME as NAME40_0_, operation1_.URL as URL40_0_, operation1_.DES_PIC as DES7_40_0_, operation1_.STATUS as STATUS40_0_, operation1_.INFO as INFO40_0_, operation1_.SP_INFO as SP10_40_0_, operation1_.FOCUS as FOCUS40_0_, operation1_.FAVORITE as FAVORITE40_0_, operation1_.MY_PLACE as MY13_40_0_, operation1_.PLACE as PLACE40_0_, operation1_.RECENT as RECENT40_0_, operation1_.CREATE_DATE as CREATE16_40_0_, operation1_.END_DATE as END17_40_0_, operation1_.FLAG as FLAG40_0_, operation1_.USAGE_MODE as USAGE19_40_0_, operation1_.COST_EXPLAIN as COST20_40_0_, operation1_.WAP_CALL_URL as WAP21_40_0_, operation1_.IVR_CALL_URL as IVR22_40_0_, operation1_.HELP_FAQ as HELP23_40_0_, operation1_.EXT_ACCESS as EXT24_40_0_, operation1_.TITLE_COLOR as TITLE25_40_0_, operation1_.BUSINESS_IFS_TYPE as BUSINESS26_40_0_, operation1_.SERVICE_OPTION as SERVICE27_40_0_, operation1_.BIZ_TYPE as BIZ28_40_0_, operation1_.SP_ID as SP29_40_0_, operation1_.SP_BIZ_CODE as SP30_40_0_, operation1_.HOME_DOMAIN as HOME31_40_0_, operation1_.ORIG_DOMAIN as ORIG32_40_0_, operation1_.SUCCESS_INFO as SUCCESS33_40_0_, operation1_.OPR_CODE_OPEN as OPR34_40_0_, operation1_.OPR_CODE_CLOSE as OPR35_40_0_, operation1_.PRICE as PRICE40_0_, operation1_.ORDER_TYPE a s ORDER37_40_0_, operation1_.SHORT_DES as SHORT38_40_0_, operation1_.LONG_DES as LONG39_40_0_, operation1_.FAINT_WORD as FAINT40_40_0_, operation1_.SIMPLE_DES as SIMPLE41_40_0_, operation1_.bg_pic as bg42_40_0_, operation1_.ACTION_URL as ACTION43_40_0_, operation1_.OPEN_URL as OPEN44_40_0_, operation1_.BUSSINESS_TYPE as BUSSINESS45_40_0_, operation1_.DISPLAY_ORDER as DISPLAY46_40_0_, operation1_.BUSSINESS_TYPE_ORDER as BUSSINESS47_40_0_ from T_FC_USER_COLLECT operations0_ left outer join T_FC_OPERATION operation1_ on operations0_.OPERATION_ID=operation1_.ID where operations0_.PHONE_NUMBER=:1 order by operations0_.OPERATION_ID ASC

bnfyb2q7jp308 select count(*) as col_0_0_ from T_FC_12580_ALL t12580all0_ where 1=1 and (t12580all0_.NAMES like :1) order by t12580all0_.QUERY_NUM desc

bp304k2yqv789 select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13507501292' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')

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

c4wx2rkhsgvm5 select t.id, t.name, t.bussiness_type, t.url, t.simple_des from t_fc_operation t, t_fc_operation_access t1 where t.id = t1.operation_id and t1.area_id = :1 and t.display_order is not null and t.bussiness_type is not null and t.status = :2 and (t.end_date > sysdate or t.end_date is null) order by t.display_order

cmqhvqu3u4hd6 select SEQ_SYS_ACCESSLOGS.nextval from dual

d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

dm3h4zdprmsch select SEQ_FIRST_LOGIN_LOGS.nextval from dual

f147hvknkr0s2 insert into T_FC_IP_ADDRESS (URL, ACCESS_DATE, PHONENUMBER, UA, WAP_OR_NET, REMOTE_ADDRESS, ID) values (:1, :2, :3, :4, :5, :6, :7)

f3sas2qvxujnx select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13860666277' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')

g8qgtaw19n82d select * from ( select news0_.ID as ID34_, news0_.CATEGORY as CATEGORY34_, news0_.AREA_ID as AREA3_34_, news0_.TITLE as TITLE34_, news0_.AUTHOR as AUTHOR34_, news0_.SOURCE as SOURCE34_, news0_.IS_IMAGE_NEWS as IS7_34_, news0_.IMAGE as IMAGE34_, news0_.IMAGE_FORMAT as IMAGE9_34_, news0_.SIMPLE_CONTENT as SIMPLE10_34_, news0_.CONTENT as CONTENT34_, news0_.IS_HOT as IS12_34_, news0_.UPLOAD_TIME as UPLOAD13_34_, news0_.IS_AUDIT as IS14_34_, news0_.OPERATOR as OPERATOR34_, news0_.AUDIT_OPER as AUDIT16_34_, news0_.AUDIT_TIME as AUDIT17_34_, news0_.OVERRULE_CAUSE as OVERRULE18_34_, news0_.STATUS as STATUS34_, news0_.SEARCH_TYPE as SEARCH20_34_, news0_.SEARCH_KEY as SEARCH21_34_, news0_.STAT_NUMS as STAT22_34_, news0_.REMARK as REMARK34_, news0_.IS_URL as IS24_34_, news0_.OPERATIONID as OPERATI25_34_, news0_.END_DATE as END26_34_, news0_.NEWS_IFS_ID as NEWS27_34_ from T_CMS_NEWS news0_ where news0_.AREA_ID=:1 and news0_.CATEGORY=:2 and news0_.STATUS=:3 and news0_.END_DATE>:4 and news0_.ID<:5 and news0_.ID<>:6 order by news0_.UPLOAD_TIME desc ) where rownum <= :7

SQL Id	SQL Text
03164c4t3c5xw	insert into T_FC_FIRST_LOGIN_LOGS (PHONE_NUMBER, CHANNEL, ACTIVITY_TYPE, LOGIN_TIME, ID) values (:1, :2, :3, :4, :5)
190unkpdg99p7	select * from ( select news0_.ID as ID34_, news0_.CATEGORY as CATEGORY34_, news0_.AREA_ID as AREA3_34_, news0_.TITLE as TITLE34_, news0_.AUTHOR as AUTHOR34_, news0_.SOURCE as SOURCE34_, news0_.IS_IMAGE_NEWS as IS7_34_, news0_.IMAGE as IMAGE34_, news0_.IMAGE_FORMAT as IMAGE9_34_, news0_.SIMPLE_CONTENT as SIMPLE10_34_, news0_.CONTENT as CONTENT34_, news0_.IS_HOT as IS12_34_, news0_.UPLOAD_TIME as UPLOAD13_34_, news0_.IS_AUDIT as IS14_34_, news0_.OPERATOR as OPERATOR34_, news0_.AUDIT_OPER as AUDIT16_34_, news0_.AUDIT_TIME as AUDIT17_34_, news0_.OVERRULE_CAUSE as OVERRULE18_34_, news0_.STATUS as STATUS34_, news0_.SEARCH_TYPE as SEARCH20_34_, news0_.SEARCH_KEY as SEARCH21_34_, news0_.STAT_NUMS as STAT22_34_, news0_.REMARK as REMARK34_, news0_.IS_URL as IS24_34_, news0_.OPERATIONID as OPERATI25_34_, news0_.END_DATE as END26_34_, news0_.NEWS_IFS_ID as NEWS27_34_ from T_CMS_NEWS news0_ where news0_.CATEGORY=:1 and news0_.AREA_ID=:2 and news0_.STATUS=:3 and news0_.END_DATE>:4 order by news0_.UPLOAD_TIME desc ) where rownum <= :5
1wm04r5z1ftkw	select * from ( select t12580all0_.ID as ID65_, t12580all0_.CITY as CITY65_, t12580all0_.TYPES as TYPES65_, t12580all0_.NAMES as NAMES65_, t12580all0_.PHONENUMBER as PHONENUM5_65_, t12580all0_.ADDRESS as ADDRESS65_, t12580all0_.LEVELES as LEVELES65_, t12580all0_.SHOP_SUMMARY as SHOP8_65_, t12580all0_.QUERY_NUM as QUERY9_65_ from T_FC_12580_ALL t12580all0_ where 1=1 and (t12580all0_.NAMES like :1) order by t12580all0_.QUERY_NUM desc ) where rownum <= :2
23ycj099jhc46	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13959023682' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
2ckbmh5m8pd68	select user0_.PHONE_NUMBER as PHONE1_48_, user0_.BLOG_NAME as BLOG2_48_, user0_.NICK_NAME as NICK3_48_, user0_.WEL_TITLE as WEL4_48_, user0_.AREA_ID as AREA5_48_, user0_.BRAND as BRAND48_, user0_.PAY_KIND as PAY7_48_, user0_.IS_ARREAR as IS8_48_, user0_.MOBILE_TYPE as MOBILE9_48_, user0_.USER_AGENT as USER10_48_, user0_.CREATE_DATE as CREATE11_48_, user0_.UPDATE_TIME as UPDATE12_48_, user0_.VISIT_COUNT as VISIT13_48_, user0_.THEME_NAME as THEME14_48_, user0_.MOOD as MOOD48_, user0_.FLAG as FLAG48_, user0_.VERSION as VERSION48_ from T_FC_USER user0_ where user0_.PHONE_NUMBER=:1
31a13pnjps7j3	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
4cvqvs489pd6k	select min(next_date) from "SYS"."AQ$_ALERT_QT_T"
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4p1sd0jvasbz0	select zhangtingb0_.ID as ID6_, zhangtingb0_.NAME as NAME6_, zhangtingb0_.CBURL as CBURL6_, zhangtingb0_.URL as URL6_, zhangtingb0_.TYPE as TYPE6_, zhangtingb0_.DISPLAY_ORDER as DISPLAY6_6_ from T_FC_ZHANGTING zhangtingb0_ where zhangtingb0_.TYPE=:1 and (zhangtingb0_.NAME like :2) order by zhangtingb0_.DISPLAY_ORDER
59q9puwma9gnp	select viewnotes0_.ID as ID81_, viewnotes0_.PHONE_NUMBER as PHONE2_81_, viewnotes0_.CATEGORY_ID as CATEGORY3_81_, viewnotes0_.CONTENT as CONTENT81_, viewnotes0_.ORDER_CONTENT as ORDER5_81_, viewnotes0_.ORDER_TIME as ORDER6_81_, viewnotes0_.RANKING as RANKING81_, viewnotes0_.SETTED as SETTED81_, viewnotes0_.SHOW_TYPE as SHOW9_81_ from T_FC_VIEW_NOTES viewnotes0_, T_FC_CATEGORIES categories1_ where viewnotes0_.CATEGORY_ID=categories1_.ID and viewnotes0_.PHONE_NUMBER=:1 and categories1_.STATUS=:2 order by viewnotes0_.ID
5cqctydwqs1w2	select activity0_.ID as ID5_, activity0_.TOPIC as TOPIC5_, activity0_.STARTTIME as STARTTIME5_, activity0_.ENDTIME as ENDTIME5_, activity0_.STATUS as STATUS5_, activity0_.BANNERTYPE as BANNERTYPE5_, activity0_.BANNER as BANNER5_, activity0_.CONTENT as CONTENT5_, activity0_.ACTIVITYURL as ACTIVITY9_5_, activity0_.CITY as CITY5_ from T_FC_ACTIVITY activity0_ where activity0_.BANNERTYPE=:1 and to_char(activity0_.STARTTIME, 'yyyy-MM-dd')<=to_char(:2, 'yyyy-MM-dd') and to_char(activity0_.ENDTIME, 'yyyy-MM-dd')>=to_char(:3, 'yyyy-MM-dd') and activity0_.STATUS=:4 and (activity0_.CITY like :5) order by activity0_.ID
69zbya7t6q35n	insert into T_SYS_ACCESSLOGS (URL_ID, OPERATION_NAME, ACCESSDATE, IP, PHONENUMBER, URL, UA, SESSIONID, REMARKS, AREA, WAP_OR_NET, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
6sgbxr6bgs7pa	select MOBILE_TYPE, USER_AGENT, AREA_ID from T_FC_USER where PHONE_NUMBER = :1
6ssrk2dqj7jbx	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
7djxb2a6x996p	select refoperati0_.OPERATION_ID as OPERATION1_1_, refoperati0_.SUB_OPERATION_ID as SUB2_1_, operation1_.ID as ID40_0_, operation1_.SUPERIOR as SUPERIOR40_0_, operation1_.CODE as CODE40_0_, operation1_.TYPE as TYPE40_0_, operation1_.NAME as NAME40_0_, operation1_.URL as URL40_0_, operation1_.DES_PIC as DES7_40_0_, operation1_.STATUS as STATUS40_0_, operation1_.INFO as INFO40_0_, operation1_.SP_INFO as SP10_40_0_, operation1_.FOCUS as FOCUS40_0_, operation1_.FAVORITE as FAVORITE40_0_, operation1_.MY_PLACE as MY13_40_0_, operation1_.PLACE as PLACE40_0_, operation1_.RECENT as RECENT40_0_, operation1_.CREATE_DATE as CREATE16_40_0_, operation1_.END_DATE as END17_40_0_, operation1_.FLAG as FLAG40_0_, operation1_.USAGE_MODE as USAGE19_40_0_, operation1_.COST_EXPLAIN as COST20_40_0_, operation1_.WAP_CALL_URL as WAP21_40_0_, operation1_.IVR_CALL_URL as IVR22_40_0_, operation1_.HELP_FAQ as HELP23_40_0_, operation1_.EXT_ACCESS as EXT24_40_0_, operation1_.TITLE_COLOR as TITLE25_40_0_, operation1_.BUSINESS_IFS_TYPE as BUSINESS26_40_0_, operation1_.SERVICE_OPTION as SERVICE27_40_0_, operation1_.BIZ_TYPE as BIZ28_40_0_, operation1_.SP_ID as SP29_40_0_, operation1_.SP_BIZ_CODE as SP30_40_0_, operation1_.HOME_DOMAIN as HOME31_40_0_, operation1_.ORIG_DOMAIN as ORIG32_40_0_, operation1_.SUCCESS_INFO as SUCCESS33_40_0_, operation1_.OPR_CODE_OPEN as OPR34_40_0_, operation1_.OPR_CODE_CLOSE as OPR35_40_0_, operation1_.PRICE as PRICE40_0_, operation1_.ORDER_TYPE as ORDER37_40_0_, operation1_.SHORT_DES as SHORT38_40_0_, operation1_.LONG_DES as LONG39_40_0_, operation1_.FAINT_WORD as FAINT40_40_0_, operation1_.SIMPLE_DES as SIMPLE41_40_0_, operation1_.bg_pic as bg42_40_0_, operation1_.ACTION_URL as ACTION43_40_0_, operation1_.OPEN_URL as OPEN44_40_0_, operation1_.BUSSINESS_TYPE as BUSSINESS45_40_0_, operation1_.DISPLAY_ORDER as DISPLAY46_40_0_, operation1_.BUSSINESS_TYPE_ORDER as BUSSINESS47_40_0_ from T_FC_OPERATION_OPERATION refoperati0_ left outer join T_FC_OPERATION operation1_ on refoperati0_.SUB_OPERATION_ID=operation1_.ID where refoperati0_.OPERATION_ID in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10) order by refoperati0_.place asc
816dsfgbhqq3u	select categories0_.ID as ID82_0_, categories0_.NAME as NAME82_0_, categories0_.TYPE as TYPE82_0_, categories0_.STATUS as STATUS82_0_, categories0_.DEF_LOCATION as DEF5_82_0_, categories0_.ALLOW_SET as ALLOW6_82_0_ from T_FC_CATEGORIES categories0_ where categories0_.ID in (:1, :2, :3, :4, :5, :6, :7)
84qyg0m594wcv	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13850584468' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
8sqysbs1s8hrr	select count(*) as col_0_0_ from T_FC_HOT_BUSINESS hotbusines0_ where hotbusines0_.STARTTIME<=:1 and hotbusines0_.ENDTIME>=:2 and hotbusines0_.STATUS=1
953hsjnbvbrcb	select zhangtingb0_.ID as ID6_, zhangtingb0_.NAME as NAME6_, zhangtingb0_.CBURL as CBURL6_, zhangtingb0_.URL as URL6_, zhangtingb0_.TYPE as TYPE6_, zhangtingb0_.DISPLAY_ORDER as DISPLAY6_6_ from T_FC_ZHANGTING zhangtingb0_ where zhangtingb0_.TYPE=:1 order by zhangtingb0_.DISPLAY_ORDER
a4c6qvukwpabv	update T_FC_USER set MOBILE_TYPE = :1 , USER_AGENT = :2, AREA_ID=:3 , UPDATE_TIME = sysdate where PHONE_NUMBER = :4
ax0z40kwrxhu4	select operations0_.PHONE_NUMBER as PHONE1_1_, operations0_.OPERATION_ID as OPERATION2_1_, operation1_.ID as ID40_0_, operation1_.SUPERIOR as SUPERIOR40_0_, operation1_.CODE as CODE40_0_, operation1_.TYPE as TYPE40_0_, operation1_.NAME as NAME40_0_, operation1_.URL as URL40_0_, operation1_.DES_PIC as DES7_40_0_, operation1_.STATUS as STATUS40_0_, operation1_.INFO as INFO40_0_, operation1_.SP_INFO as SP10_40_0_, operation1_.FOCUS as FOCUS40_0_, operation1_.FAVORITE as FAVORITE40_0_, operation1_.MY_PLACE as MY13_40_0_, operation1_.PLACE as PLACE40_0_, operation1_.RECENT as RECENT40_0_, operation1_.CREATE_DATE as CREATE16_40_0_, operation1_.END_DATE as END17_40_0_, operation1_.FLAG as FLAG40_0_, operation1_.USAGE_MODE as USAGE19_40_0_, operation1_.COST_EXPLAIN as COST20_40_0_, operation1_.WAP_CALL_URL as WAP21_40_0_, operation1_.IVR_CALL_URL as IVR22_40_0_, operation1_.HELP_FAQ as HELP23_40_0_, operation1_.EXT_ACCESS as EXT24_40_0_, operation1_.TITLE_COLOR as TITLE25_40_0_, operation1_.BUSINESS_IFS_TYPE as BUSINESS26_40_0_, operation1_.SERVICE_OPTION as SERVICE27_40_0_, operation1_.BIZ_TYPE as BIZ28_40_0_, operation1_.SP_ID as SP29_40_0_, operation1_.SP_BIZ_CODE as SP30_40_0_, operation1_.HOME_DOMAIN as HOME31_40_0_, operation1_.ORIG_DOMAIN as ORIG32_40_0_, operation1_.SUCCESS_INFO as SUCCESS33_40_0_, operation1_.OPR_CODE_OPEN as OPR34_40_0_, operation1_.OPR_CODE_CLOSE as OPR35_40_0_, operation1_.PRICE as PRICE40_0_, operation1_.ORDER_TYPE a s ORDER37_40_0_, operation1_.SHORT_DES as SHORT38_40_0_, operation1_.LONG_DES as LONG39_40_0_, operation1_.FAINT_WORD as FAINT40_40_0_, operation1_.SIMPLE_DES as SIMPLE41_40_0_, operation1_.bg_pic as bg42_40_0_, operation1_.ACTION_URL as ACTION43_40_0_, operation1_.OPEN_URL as OPEN44_40_0_, operation1_.BUSSINESS_TYPE as BUSSINESS45_40_0_, operation1_.DISPLAY_ORDER as DISPLAY46_40_0_, operation1_.BUSSINESS_TYPE_ORDER as BUSSINESS47_40_0_ from T_FC_USER_COLLECT operations0_ left outer join T_FC_OPERATION operation1_ on operations0_.OPERATION_ID=operation1_.ID where operations0_.PHONE_NUMBER=:1 order by operations0_.OPERATION_ID ASC
bnfyb2q7jp308	select count(*) as col_0_0_ from T_FC_12580_ALL t12580all0_ where 1=1 and (t12580all0_.NAMES like :1) order by t12580all0_.QUERY_NUM desc
bp304k2yqv789	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13507501292' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
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
c4wx2rkhsgvm5	select t.id, t.name, t.bussiness_type, t.url, t.simple_des from t_fc_operation t, t_fc_operation_access t1 where t.id = t1.operation_id and t1.area_id = :1 and t.display_order is not null and t.bussiness_type is not null and t.status = :2 and (t.end_date > sysdate or t.end_date is null) order by t.display_order
cmqhvqu3u4hd6	select SEQ_SYS_ACCESSLOGS.nextval from dual
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dm3h4zdprmsch	select SEQ_FIRST_LOGIN_LOGS.nextval from dual
f147hvknkr0s2	insert into T_FC_IP_ADDRESS (URL, ACCESS_DATE, PHONENUMBER, UA, WAP_OR_NET, REMOTE_ADDRESS, ID) values (:1, :2, :3, :4, :5, :6, :7)
f3sas2qvxujnx	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13860666277' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
g8qgtaw19n82d	select * from ( select news0_.ID as ID34_, news0_.CATEGORY as CATEGORY34_, news0_.AREA_ID as AREA3_34_, news0_.TITLE as TITLE34_, news0_.AUTHOR as AUTHOR34_, news0_.SOURCE as SOURCE34_, news0_.IS_IMAGE_NEWS as IS7_34_, news0_.IMAGE as IMAGE34_, news0_.IMAGE_FORMAT as IMAGE9_34_, news0_.SIMPLE_CONTENT as SIMPLE10_34_, news0_.CONTENT as CONTENT34_, news0_.IS_HOT as IS12_34_, news0_.UPLOAD_TIME as UPLOAD13_34_, news0_.IS_AUDIT as IS14_34_, news0_.OPERATOR as OPERATOR34_, news0_.AUDIT_OPER as AUDIT16_34_, news0_.AUDIT_TIME as AUDIT17_34_, news0_.OVERRULE_CAUSE as OVERRULE18_34_, news0_.STATUS as STATUS34_, news0_.SEARCH_TYPE as SEARCH20_34_, news0_.SEARCH_KEY as SEARCH21_34_, news0_.STAT_NUMS as STAT22_34_, news0_.REMARK as REMARK34_, news0_.IS_URL as IS24_34_, news0_.OPERATIONID as OPERATI25_34_, news0_.END_DATE as END26_34_, news0_.NEWS_IFS_ID as NEWS27_34_ from T_CMS_NEWS news0_ where news0_.AREA_ID=:1 and news0_.CATEGORY=:2 and news0_.STATUS=:3 and news0_.END_DATE>:4 and news0_.ID<:5 and news0_.ID<>:6 order by news0_.UPLOAD_TIME desc ) where rownum <= :7

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	3,062	0.84	0.72
CPU used when call started	1,512	0.42	0.35
CR blocks created	55	0.02	0.01
DB time	367,692	100.97	85.91
DBWR checkpoint buffers written	1,883	0.52	0.44
DBWR fusion writes	284	0.08	0.07
DBWR transaction table writes	91	0.02	0.02
DBWR undo block writes	245	0.07	0.06
DFO trees parallelized	73	0.02	0.02
PX local messages recv'd	396	0.11	0.09
PX local messages sent	396	0.11	0.09
PX remote messages recv'd	188	0.05	0.04
PX remote messages sent	310	0.09	0.07
Parallel operations not downgraded	73	0.02	0.02
SMON posted for instance recovery	0	0.00	0.00
SQL*Net roundtrips to/from client	34,718	9.53	8.11
active txn count during cleanout	215	0.06	0.05
application wait time	3	0.00	0.00
background timeouts	12,779	3.51	2.99
buffer is not pinned count	99,631	27.36	23.28
buffer is pinned count	132,482	36.38	30.95
bytes received via SQL*Net from client	17,294,385	4,749.10	4,040.74
bytes sent via SQL*Net to client	21,707,608	5,960.99	5,071.87
calls to get snapshot scn: kcmgss	66,461	18.25	15.53
calls to kcmgas	4,760	1.31	1.11
calls to kcmgcs	83	0.02	0.02
change write time	14	0.00	0.00
cleanout - number of ktugct calls	138	0.04	0.03
cleanouts and rollbacks - consistent read gets	24	0.01	0.01
cleanouts only - consistent read gets	11	0.00	0.00
cluster key scan block gets	3,460	0.95	0.81
cluster key scans	651	0.18	0.15
cluster wait time	187	0.05	0.04
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	11	0.00	0.00
commit batch/immediate requested	11	0.00	0.00
commit cleanout failures: block lost	5	0.00	0.00
commit cleanout failures: callback failure	4	0.00	0.00
commit cleanouts	3,206	0.88	0.75
commit cleanouts successfully completed	3,197	0.88	0.75
commit immediate performed	11	0.00	0.00
commit immediate requested	11	0.00	0.00
commit txn count during cleanout	179	0.05	0.04
concurrency wait time	23	0.01	0.01
consistent changes	56	0.02	0.01
consistent gets	8,145,760	2,236.86	1,903.21
consistent gets - examination	46,402	12.74	10.84
consistent gets direct	0	0.00	0.00
consistent gets from cache	8,145,760	2,236.86	1,903.21
cursor authentications	596	0.16	0.14
data blocks consistent reads - undo records applied	52	0.01	0.01
db block changes	11,585	3.18	2.71
db block gets	15,087	4.14	3.53
db block gets direct	0	0.00	0.00
db block gets from cache	15,087	4.14	3.53
deferred (CURRENT) block cleanout applications	2,109	0.58	0.49
enqueue conversions	1,010	0.28	0.24
enqueue releases	46,671	12.82	10.90
enqueue requests	46,668	12.82	10.90
enqueue timeouts	0	0.00	0.00
enqueue waits	394	0.11	0.09
execute count	30,175	8.29	7.05
free buffer inspected	1	0.00	0.00
free buffer requested	18,529	5.09	4.33
gc CPU used by this session	890	0.24	0.21
gc cr block build time	0	0.00	0.00
gc cr block flush time	0	0.00	0.00
gc cr block receive time	23	0.01	0.01
gc cr block send time	2	0.00	0.00
gc cr blocks received	815	0.22	0.19
gc cr blocks served	882	0.24	0.21
gc current block flush time	1	0.00	0.00
gc current block pin time	2	0.00	0.00
gc current block receive time	235	0.06	0.05
gc current block send time	14	0.00	0.00
gc current blocks received	5,060	1.39	1.18
gc current blocks served	4,453	1.22	1.04
gc local grants	3,359	0.92	0.78
gc remote grants	4,083	1.12	0.95
gcs messages sent	19,846	5.45	4.64
ges messages sent	2,164	0.59	0.51
global enqueue get time	57	0.02	0.01
global enqueue gets async	460	0.13	0.11
global enqueue gets sync	12,123	3.33	2.83
global enqueue releases	11,564	3.18	2.70
heap block compress	60	0.02	0.01
immediate (CR) block cleanout applications	35	0.01	0.01
immediate (CURRENT) block cleanout applications	180	0.05	0.04
index crx upgrade (found)	5	0.00	0.00
index crx upgrade (positioned)	3,152	0.87	0.74
index fetch by key	18,314	5.03	4.28
index scans kdiixs1	14,691	4.03	3.43
leaf node 90-10 splits	10	0.00	0.00
leaf node splits	22	0.01	0.01
lob reads	0	0.00	0.00
lob writes	13	0.00	0.00
lob writes unaligned	13	0.00	0.00
logons cumulative	116	0.03	0.03
messages received	3,724	1.02	0.87
messages sent	3,724	1.02	0.87
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	8,062,407	2,213.97	1,883.74
opened cursors cumulative	27,997	7.69	6.54
parse count (failures)	2	0.00	0.00
parse count (hard)	988	0.27	0.23
parse count (total)	27,749	7.62	6.48
parse time cpu	17	0.00	0.00
parse time elapsed	244	0.07	0.06
physical read IO requests	4,464	1.23	1.04
physical read bytes	56,705,024	15,571.41	13,248.84
physical read total IO requests	13,905	3.82	3.25
physical read total bytes	211,042,304	57,953.01	49,308.95
physical read total multi block requests	802	0.22	0.19
physical reads	6,922	1.90	1.62
physical reads cache	6,922	1.90	1.62
physical reads cache prefetch	3,636	1.00	0.85
physical reads direct	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	2,715	0.75	0.63
physical write IO requests	1,904	0.52	0.44
physical write bytes	17,326,080	4,757.81	4,048.15
physical write total IO requests	7,661	2.10	1.79
physical write total bytes	83,375,104	22,895.12	19,480.16
physical write total multi block requests	1,805	0.50	0.42
physical writes	2,115	0.58	0.49
physical writes direct	0	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes from cache	2,115	0.58	0.49
physical writes non checkpoint	1,471	0.40	0.34
process last non-idle time	3,498	0.96	0.82
queries parallelized	73	0.02	0.02
recursive calls	43,202	11.86	10.09
recursive cpu usage	1,078	0.30	0.25
redo blocks written	6,277	1.72	1.47
redo entries	8,259	2.27	1.93
redo ordering marks	124	0.03	0.03
redo size	2,729,128	749.43	637.65
redo subscn max counts	165	0.05	0.04
redo synch time	37	0.01	0.01
redo synch writes	583	0.16	0.14
redo wastage	310,496	85.26	72.55
redo write time	65	0.02	0.02
redo writes	1,059	0.29	0.25
rollback changes - undo records applied	18	0.00	0.00
rollbacks only - consistent read gets	28	0.01	0.01
rows fetched via callback	5,454	1.50	1.27
session connect time	0	0.00	0.00
session cursor cache hits	23,564	6.47	5.51
session logical reads	8,160,847	2,241.00	1,906.74
session pga memory	79,535,392	21,840.72	18,583.04
session pga memory max	65,362,560	17,948.80	15,271.63
session uga memory max	36,201,480	9,941.06	8,458.29
shared hash latch upgrades - no wait	4,993	1.37	1.17
shared hash latch upgrades - wait	5	0.00	0.00
sorts (memory)	14,898	4.09	3.48
sorts (rows)	106,031	29.12	24.77
sql area evicted	0	0.00	0.00
sql area purged	2	0.00	0.00
switch current to new buffer	39	0.01	0.01
table fetch by rowid	92,011	25.27	21.50
table fetch continued row	5	0.00	0.00
table scan blocks gotten	173,901	47.75	40.63
table scan rows gotten	3,099,710	851.19	724.23
table scans (long tables)	0	0.00	0.00
table scans (short tables)	15,328	4.21	3.58
total number of times SMON posted	0	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	11	0.00	0.00
undo change vector size	743,340	204.12	173.68
user I/O wait time	1,678	0.46	0.39
user calls	60,910	16.73	14.23
user commits	567	0.16	0.13
user rollbacks	3,713	1.02	0.87
workarea executions - optimal	11,194	3.07	2.62

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	1,415	1,973
opened cursors current	104	81
workarea memory allocated	0	904
logons current	58	39

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)	0	0.00

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)
FC	3,485	1	6.62	1.54	1,204	2	0.00
FCINDEX	688	0	5.23	1.81	80	2	5.00
SYSAUX	264	0	2.88	1.11	402	0	0.00
UNDOTBS2	0	0	0.00	0.00	196	0	0.00
SYSTEM	36	0	4.17	1.00	22	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
FC	/dev/rora_data002	121	6.03	1.50	31	0	0.00
FC	/dev/rora_data003	94	6.06	1.78	42	0	0.00
FC	/dev/rora_data004	132	6.21	1.50	31	0	0.00
FC	/dev/rora_data005	97	7.42	1.81	21	0	0.00
FC	/dev/rora_data006	106	6.23	1.57	25	0	0.00
FC	/dev/rora_data007	102	5.20	1.60	28	0	0.00
FC	/dev/rora_data009	113	6.46	1.90	24	0	0.00
FC	/dev/rora_data010	104	7.40	1.83	32	0	0.00
FC	/dev/rora_data011	121	4.71	1.92	45	0	0.00
FC	/dev/rora_data016	235	5.45	1.51	78	0	0.00
FC	/dev/rora_data017	220	6.91	1.37	116	0	0.00
FC	/dev/rora_data018	232	5.69	1.42	59	0	0.00
FC	/dev/rora_data019	235	6.13	1.47	79	0	0.00
FC	/dev/rora_data020	189	6.61	1.46	110	1	0.00
FC	/dev/rora_data021	221	6.70	1.31	70	0	0.00
FC	/dev/rora_data022	246	5.81	1.30	127	1	0.00
FC	/dev/rora_data023	225	7.91	1.49	61	0	0.00
FC	/dev/rora_data031	206	7.33	1.56	70	0	0.00
FC	/dev/rora_data032	245	9.80	1.40	78	0	0.00
FC	/dev/rora_data033	241	6.47	1.86	77	0	0.00
FCINDEX	/dev/rora_data008	332	5.30	1.81	32	2	5.00
FCINDEX	/dev/rora_data015	356	5.17	1.81	48	0	0.00
SYSAUX	/dev/rlv_sysaux_02	141	2.98	1.00	233	0	0.00
SYSAUX	/dev/rlv_sysaux_2046m	123	2.76	1.24	169	0	0.00
SYSTEM	/dev/rlv_system_2046m	34	3.53	1.00	21	0	0.00
SYSTEM	/dev/rlv_system_2g	2	15.00	1.00	1	0	0.00
UNDOTBS2	/dev/rlv_undo2_4094m	0			148	0	0.00
UNDOTBS2	/dev/rlv_undo2a_2046m	0			48	0	0.00

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	289,769	100	8,160,890	6,924	2,115	0	0	4

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	0	0	379	982	3505	5651190	3505
E	0	0	215	356	527	5651190	527

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	240	0.10	28,785	2.41	431,941
D	480	0.20	57,570	1.07	190,888
D	720	0.30	86,355	1.00	179,330
D	960	0.40	115,140	1.00	179,170
D	1,200	0.50	143,925	1.00	179,170
D	1,440	0.60	172,710	1.00	179,170
D	1,680	0.70	201,495	1.00	179,170
D	1,920	0.79	230,280	1.00	179,170
D	2,160	0.89	259,065	1.00	179,170
D	2,400	0.99	287,850	1.00	179,170
D	2,416	1.00	289,769	1.00	179,170
D	2,640	1.09	316,635	1.00	179,170
D	2,880	1.19	345,420	1.00	179,170
D	3,120	1.29	374,205	1.00	179,170
D	3,360	1.39	402,990	1.00	179,170
D	3,600	1.49	431,775	1.00	179,170
D	3,840	1.59	460,560	1.00	179,170
D	4,080	1.69	489,345	1.00	179,170
D	4,320	1.79	518,130	1.00	179,170
D	4,560	1.89	546,915	1.00	179,170
D	4,800	1.99	575,700	1.00	179,170

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	254	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	1,558	1,335	170.16	0.00	0.00	0.00	0.00	159,530
E	1,558	1,345	143.38	0.88	0.62	100.00	0.00	159,530

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	10,988	10,988
64K	128K	11	11
128K	256K	2	2
512K	1024K	12	12
1M	2M	181	181

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 PGA Cache Hit %
195	0.13	603.58	100.00
390	0.25	603.58	100.00
779	0.50	603.58	100.00
1,169	0.75	603.58	100.00
1,558	1.00	603.58	100.00
1,870	1.20	603.58	100.00
2,181	1.40	603.58	100.00
2,493	1.60	603.58	100.00
2,804	1.80	603.58	100.00
3,116	2.00	603.58	100.00
4,674	3.00	603.58	100.00
6,232	4.00	603.58	100.00
9,348	6.00	603.58	100.00
12,464	8.00	603.58	100.00

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
720	0.20	68	7,266	2,121	1.00	9	1.00	114,923
1,088	0.30	68	7,266	2,121	1.00	9	1.00	114,923
1,456	0.40	68	7,266	2,121	1.00	9	1.00	114,923
1,824	0.50	68	7,266	2,121	1.00	9	1.00	114,923
2,192	0.60	68	7,266	2,121	1.00	9	1.00	114,923
2,560	0.70	68	7,266	2,121	1.00	9	1.00	114,923
2,928	0.80	68	7,266	2,121	1.00	9	1.00	114,923
3,296	0.90	68	7,266	2,121	1.00	9	1.00	114,923
3,664	1.00	68	7,266	2,121	1.00	9	1.00	114,923
4,032	1.10	68	7,266	2,121	1.00	9	1.00	114,923
4,400	1.20	68	7,266	2,121	1.00	9	1.00	114,923
4,768	1.30	68	7,266	2,121	1.00	9	1.00	114,923
5,136	1.40	68	7,266	2,121	1.00	9	1.00	114,923
5,504	1.50	68	7,266	2,121	1.00	9	1.00	114,923
5,872	1.60	68	7,266	2,121	1.00	9	1.00	114,923
6,240	1.70	68	7,266	2,121	1.00	9	1.00	114,923
6,608	1.80	68	7,266	2,121	1.00	9	1.00	114,923
6,976	1.90	68	7,266	2,121	1.00	9	1.00	114,923
7,344	2.00	68	7,266	2,121	1.00	9	1.00	114,923

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,536	0.25	168	179,291
3,072	0.50	168	179,130
4,608	0.75	168	179,130
6,144	1.00	168	179,130
7,680	1.25	168	179,130
9,216	1.50	168	179,130
10,752	1.75	168	179,130
12,288	2.00	168	179,130

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

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	4	0	3

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	Waits	Av Wt Time(ms)
WF-AWR Flush	24	24	13	10.54
PS-PX Process Reservation	499	499	152	0.32
TQ-Queue table enqueue (TM contention)	97	97	97	0.46
TM-DML	7,562	7,562	108	0.27
TA-Instance Undo	13	13	13	0.31
HW-Segment High Water Mark	219	219	3	0.67
FB-Format Block	6	6	5	0.00
DR-Distributed Recovery	2	2	2	0.00
TX-Transaction (allocate ITL entry)	1	1	1	0.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
5	0.14	981	1,842	4	5760/5760	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
09-May 15:55	1	51	210	1	5,760	0/0	0/0/0/0/0/0
09-May 15:45	3	39	99	1	5,760	0/0	0/0/0/0/0/0
09-May 15:35	12	122	96	3	5,760	0/0	0/0/0/0/0/0
09-May 15:25	40	353	74	3	5,760	0/0	0/0/0/0/0/0
09-May 15:15	16	242	929	3	5,760	0/0	0/0/0/0/0/0
09-May 15:05	65	174	1,842	4	5,760	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	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,439	0.00		0
AWR Alerted Metric Element list	15,757	0.00		0
Consistent RBA	1,059	0.00		0
FOB s.o list latch	657	1.07	0.00	0
JS broadcast add buf latch	832	0.00		0
JS broadcast drop buf latch	832	0.00		0
JS broadcast load blnc latch	728	0.00		0
JS queue state obj latch	26,208	0.00		0
KCL gc element parent latch	51,829	0.00		113	0.00
KJC message pool free list	3,948	0.03	0.00	1,252	0.00
KJCT flow control latch	23,824	0.00	0.00	0
KMG MMAN ready and startup request latch	1,213	0.00		0
KTF sga latch	7	0.00		1,027	0.00
KWQMN job cache list latch	749	0.00		0
KWQP Prop Status	2	0.00		0
MQL Tracking Latch	0			73	0.00
Memory Management Latch	0			1,213	0.00
OS process	198	0.00		0
OS process allocation	1,326	0.15	0.00	0
OS process: request allocation	93	0.00		0
PL/SQL warning settings	259	0.00		0
SGA IO buffer pool latch	5	0.00		5	0.00
SQL memory manager latch	1	0.00		1,213	0.00
SQL memory manager workarea list latch	84,401	0.00		0
Shared B-Tree	132	0.00		0
active checkpoint queue latch	3,356	0.00		0
active service list	8,094	0.07	0.00	1,829	0.00
archive control	71	0.00		0
business card	146	0.00		0
cache buffer handles	129	0.00		0
cache buffers chains	16,342,345	0.00	0.00	59,659	0.00
cache buffers lru chain	23,501	0.01	0.00	48,119	0.01
cache table scan latch	0			10	0.00
channel handle pool latch	93	0.00		0
channel operations parent latch	148,471	0.00	0.00	0
checkpoint queue latch	126,104	0.00		2,330	0.00
client/application info	538	0.00		0
commit callback allocation	132	0.00		0
compile environment latch	116	0.00		0
dml lock allocation	15,186	0.00		0
dummy allocation	251	0.80	0.00	0
enqueue hash chains	111,186	0.00	0.00	116	0.00
enqueues	81,200	0.01	0.00	0
error message lists	353	0.00		0
event group latch	37	0.00		0
file cache latch	649	0.00		0
gcs opaque info freelist	8,784	0.13	0.00	0
gcs partitioned table hash	101,642	0.00		125	0.00
gcs remastering latch	1,034	0.00		0
gcs resource freelist	3,280	0.00		3,559	0.00
gcs resource hash	46,831	0.04	0.00	0
gcs shadows freelist	1,543	0.00		6,845	0.00
ges caches resource lists	7,069	0.03	0.00	37,665	0.00
ges deadlock list	62	0.00		0
ges domain table	26,390	0.00		0
ges enqueue table freelist	27,182	0.01	0.00	0
ges group table	34,610	0.00		0
ges process hash list	1,740	0.00		0
ges process parent latch	53,073	0.00		0
ges process table freelist	93	2.15	0.00	0
ges resource hash list	35,283	0.01	0.00	1,352	0.15
ges resource scan list	4	0.00		0
ges resource table freelist	1,068	0.00		0
ges timeout list	672	0.00		948	0.00
global KZLD latch for mem in SGA	32	0.00		0
hash table column usage latch	88	0.00		3,194	0.00
hash table modification latch	64	0.00		0
job_queue_processes parameter latch	61	0.00		0
kks stats	1,933	0.00		0
kokc descriptor allocation latch	16	0.00		0
ksuosstats global area	245	0.00		0
ktm global data	13	0.00		0
kwqbsn:qsga	131	0.00		0
lgwr LWN SCN	1,666	0.00		0
library cache	70,539	0.03	0.00	237	0.00
library cache load lock	96	0.00		0
library cache lock	30,412	0.05	0.00	0
library cache lock allocation	343	0.00		0
library cache pin	24,984	0.01	0.00	0
library cache pin allocation	23	0.00		0
list of block allocation	128	0.78	0.00	0
logminer context allocation	1	0.00		0
message pool operations parent latch	1,065	0.00		0
messages	113,982	0.00	0.00	0
mostly latch-free SCN	1,665	0.00		0
multiblock read objects	7,238	0.00		0
name-service memory objects	2,298	0.00		0
name-service namespace bucket	37,696	0.00		0
name-service pending queue	1,212	0.00		0
name-service request queue	37,867	0.00		0
ncodef allocation latch	60	0.00		0
object queue header heap	13,506	0.00		34	0.00
object queue header operation	45,060	0.00		0
object stats modification	17	0.00		0
parallel query alloc buffer	1,928	0.00		0
parallel query stats	298	0.00		0
parallel txn reco latch	702	0.00		0
parameter list	382	0.52	0.00	0
parameter table allocation management	256	0.00		0
post/wait queue	907	0.00		590	0.00
process allocation	36,047	0.01	1.00	37	0.00
process group creation	93	2.15	0.00	0
process queue	791	0.00		0
process queue reference	13,280	0.01	0.00	1,290	0.00
qmn state object latch	6	0.00		0
qmn task queue latch	549	0.00		0
query server freelists	657	0.00		0
queued dump request	18,208	0.00		0
redo allocation	4,389	0.00		8,293	0.00
redo copy	0			8,293	0.08
redo writing	9,082	0.00		0
resmgr group change latch	174	0.00		0
resmgr:active threads	242	0.00		0
resmgr:actses change group	111	0.00		0
resmgr:free threads list	241	1.24	0.00	0
resmgr:schema config	1	0.00		0
row cache objects	72,000	0.18	0.00	1	0.00
rules engine aggregate statistics	10	0.00		0
rules engine rule set statistics	120	0.00		0
sequence cache	5,836	0.05	0.00	0
session allocation	19,197	0.14	0.04	0
session idle bit	126,599	0.00	0.00	0
session state list latch	242	0.83	0.00	0
session switching	60	0.00		0
session timer	1,268	0.00		0
shared pool	49,047	0.11	0.00	0
shared pool sim alloc	77	0.00		0
shared pool simulator	28,285	0.00		0
simulator hash latch	543,474	0.00		0
simulator lru latch	0			542,204	0.00
slave class	5	0.00		0
slave class create	20	5.00	1.00	0
sort extent pool	109	0.00		0
state object free list	2	0.00		0
statistics aggregation	448	0.00		0
threshold alerts latch	356	0.00		0
transaction allocation	57	0.00		0
transaction branch allocation	1,268	0.00		0
undo global data	5,085	0.00		0
user lock	166	3.61	0.00	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
session allocation	19,197	27	1	26
process allocation	36,047	3	3	0
slave class create	20	1	1	0

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
active service list	ksws_event: ksws event	4	4
process allocation	ksucrp	2	0
process allocation	ksufap: active procs	1	2
session allocation	ksuxds: KSUSFCLC not set	1	1
slave class create	ksvcreate	1	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 Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 8,160,847
Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSAUX	SYS_IOT_TOP_8864	INDEX	3,965,504	48.59
SYS	SYSAUX	SYS_IOT_TOP_8871	INDEX	3,844,128	47.10
FJFC	FC	T_FC_OPERATION	TABLE	61,792	0.76
FJFC	FC	T_FC_ZHANGTING	TABLE	52,080	0.64
FJFC	FC	T_FC_FIRST_LOGIN_LOGS	TABLE	42,144	0.52

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 6,922
Captured Segments account for 96.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
FJFC	FC	T_FC_FIRST_LOGIN_LOGS	TABLE	3,086	44.58
FJFC	FCINDEX	PK_FC_USER	INDEX	662	9.56
FJFC	FC	INDEX_FIRST_LOGIN_PHONENUMBER	INDEX	593	8.57
FJFC	FC	IDX_SYSA_PHONE	INDEX	589	8.51
FJFC	FC	SYS_C0067038	INDEX	569	8.22

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
FJFC	FC	SYS_C0067033		INDEX	1	100.00

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

Segments by Global Cache Buffer Busy

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	GC Buffer Busy	% of Capture
FJFC	FC	T_FC_FIRST_LOGIN_LOGS		TABLE	1	50.00
FJFC	FC	T_FC_USER		TABLE	1	50.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 815
Captured Segments account for 95.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
FJFC	FC	INDEX_FIRST_LOGIN_PHONENUMBER	INDEX	222	27.24
FJFC	FC	T_FC_USER	TABLE	170	20.86
FJFC	FC	T_FC_FIRST_LOGIN_LOGS	TABLE	141	17.30
FJFC	FCINDEX	PK_FC_USER	INDEX	61	7.48
FJFC	FC	SYS_C0067038	INDEX	27	3.31

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 5,060
Captured Segments account for 98.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
FJFC	FC	T_FC_FIRST_LOGIN_LOGS	TABLE	3,296	65.14
FJFC	FC	T_FC_USER	TABLE	521	10.30
FJFC	FCINDEX	PK_FC_USER	INDEX	234	4.62
FJFC	FC	IDX_SYSA_PHONE	INDEX	152	3.00
FJFC	FC	SYS_C0067038	INDEX	139	2.75

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Dictionary Cache Stats
Dictionary Cache Stats (RAC)

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	63	3.17	0	1
dc_database_links	66	0.00	0	1
dc_global_oids	21	0.00	0	30
dc_histogram_data	719	7.23	0	1,311
dc_histogram_defs	2,478	4.24	0	3,495
dc_object_grants	16	0.00	0	58
dc_object_ids	7,166	0.42	0	744
dc_objects	1,275	2.75	0	755
dc_profiles	32	0.00	0	2
dc_rollback_segments	1,376	0.00	0	56
dc_segments	3,247	0.62	1	557
dc_sequences	95	25.26	95	5
dc_tablespace_quotas	1	100.00	1	1
dc_tablespaces	2,141	0.00	0	11
dc_usernames	192	0.00	0	13
dc_users	4,400	0.00	0	26
outstanding_alerts	150	76.67	10	4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts
dc_awr_control	2	2
dc_histogram_defs	105	0
dc_object_ids	30	0
dc_objects	35	0
dc_segments	22	0
dc_sequences	190	25
dc_tablespace_quotas	2	0
outstanding_alerts	285	111

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Library Cache Activity
Library Cache Activity (RAC)

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	14	14.29	176	1.14	0
CLUSTER	4	0.00	8	0.00	0
INDEX	1	0.00	3	0.00	0
SQL AREA	5,375	35.20	33,478	8.73	1
TABLE/PROCEDURE	152	13.82	8,128	0.57	2

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests	GES Inval Requests
CLUSTER	8	0	0
INDEX	3	0	0
TABLE/PROCEDURE	2,155	21	17

Back to Library Cache Statistics
Back to Top

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

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

	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	140.46		2.30	5.31	22	22	61	61
	Freeable	28.19	0.00	1.08	0.88	5		26	26
	SQL	1.09	0.59	0.02	0.04	0	2	47	41
	PL/SQL	0.44	0.26	0.01	0.01	0	0	59	59
E	Other	126.69		3.02	6.29	22	22	42	42
	Freeable	14.69	0.00	1.34	1.32	5		11	11
	SQL	1.70	1.36	0.06	0.18	1	2	28	24
	PL/SQL	0.31	0.20	0.01	0.01	0	0	40	40

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,533,359,616
Fixed Size	2,093,688
Redo Buffers	14,680,064
Variable Size	3,892,317,576

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	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	free memory	3,312.93	3,294.10	-0.57
shared	gcs resources	50.74	50.74	0.00
shared	sql area		43.32
streams	free memory	16.00	16.00	0.00
	buffer_cache	2,416.00	2,416.00	0.00
	fixed_sga	2.00	2.00	0.00
	log_buffer	14.00	14.00	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 Slaves	9,408,005	399	0
QMON Coordinator	47,956	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	10	0	0	0	0

Back to Streams Statistics
Back to Top

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
gcs_resources	219,593	302,934	328308	328308
gcs_shadows	292,609	319,435	328308	328308

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/admin/portal/adump
background_dump_dest	/oracle/admin/portal/bdump
cluster_database	TRUE
cluster_database_instances	2
compatible	10.2.0.3.0
control_files	/oracle/product/10.2/rdbms/dbs/control1.ctl, /dev/rlv_ctl2_320m, /dev/rlv_ctl3_320m
core_dump_dest	/oracle/admin/portal/cdump
db_block_size	8192
db_file_multiblock_read_count	16
db_flashback_retention_target	10080
db_name	portal
db_recovery_file_dest	/nfsflashrecovery
db_recovery_file_dest_size	161061273600
dispatchers	(PROTOCOL=TCP) (SERVICE=portalXDB)
instance_number	2
job_queue_processes	10
local_listener	(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.202)(PORT = 1521))
log_archive_dest
log_archive_dest_1	location=/nfsarchiveLog
log_archive_dest_2	location=/nfsarchiveLog1
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_format	ARC_%S_%T_%a_%d_%r.dbf
log_archive_max_processes	4
open_cursors	700
pga_aggregate_target	1633681408
processes	1500
remote_listener	LISTENERS_PORTAL
remote_login_passwordfile	EXCLUSIVE
sessions	1655
sga_max_size	6442450944
sga_target	6442450944
spfile	/dev/rlv_spfile_128m
thread	2
undo_management	AUTO
undo_tablespace	UNDOTBS2
user_dump_dest	/oracle/admin/portal/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	885	0.24	0.21
acks for commit broadcast(logical)	893	0.25	0.21
broadcast msgs on commit(actual)	1,059	0.29	0.25
broadcast msgs on commit(logical)	1,059	0.29	0.25
broadcast msgs on commit(wasted)	23	0.01	0.01
broadcast on commit wait time(ms)	10	0.00	0.00
broadcast on commit waits	22	0.01	0.01
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	2,052	0.56	0.48
gcs ast xid	0	0.00	0.00
gcs blocked converts	572	0.16	0.13
gcs blocked cr converts	572	0.16	0.13
gcs compatible basts	12	0.00	0.00
gcs compatible cr basts (global)	24	0.01	0.01
gcs compatible cr basts (local)	3,846	1.06	0.90
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	269	0.07	0.06
gcs dbwr write request msgs	215	0.06	0.05
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	285	0.08	0.07
gcs immediate (null) converts	768	0.21	0.18
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	6,045	1.66	1.41
gcs indirect ast	1,000	0.27	0.23
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	44	0.01	0.01
gcs msgs process time(ms)	385	0.11	0.09
gcs msgs received	19,094	5.24	4.46
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	1	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	1,301	0.36	0.30
gcs side channel msgs actual	1,974	0.54	0.46
gcs side channel msgs logical	7,231	1.99	1.69
gcs stale cr	1	0.00	0.00
gcs undo cr	0	0.00	0.00
gcs write notification msgs	30	0.01	0.01
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	21	0.01	0.00
ges msgs received	1,854	0.51	0.43
global posts dropped	0	0.00	0.00
global posts queue time	49	0.01	0.01
global posts queued	39	0.01	0.01
global posts requested	39	0.01	0.01
global posts sent	39	0.01	0.01
implicit batch messages received	277	0.08	0.06
implicit batch messages sent	340	0.09	0.08
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	1,896	0.52	0.44
messages queue sent actual	5,022	1.38	1.17
messages queue sent logical	5,444	1.49	1.27
messages received actual	13,794	3.79	3.22
messages received logical	20,948	5.75	4.89
messages sent directly	4,744	1.30	1.11
messages sent indirectly	2,705	0.74	0.63
messages sent not implicit batched	4,682	1.29	1.09
messages sent pbatched	12,847	3.53	3.00
msgs causing lmd to send msgs	671	0.18	0.16
msgs causing lms(s) to send msgs	1,636	0.45	0.38
msgs received queue time (ms)	78	0.02	0.02
msgs received queued	20,948	5.75	4.89
msgs sent queue time (ms)	172	0.05	0.04
msgs sent queue time on ksxp (ms)	2,112	0.58	0.49
msgs sent queued	5,372	1.48	1.26
msgs sent queued on ksxp	14,202	3.90	3.32
process batch messages received	5,798	1.59	1.35
process batch messages sent	5,391	1.48	1.26

Global CR Served Stats

Statistic	Total
CR Block Requests	853
CURRENT Block Requests	29
Data Block Requests	853
Undo Block Requests	0
TX Block Requests	17
Current Results	882
Private results	0
Zero Results	0
Disk Read Results	0
Fail Results	0
Fairness Down Converts	125
Fairness Clears	0
Free GC Elements	0
Flushes	4
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	0
Errors	0

Global CURRENT Served Stats

Pins = CURRENT Block Pin Operations
Flushes = Redo Flush before CURRENT Block Served Operations
Writes = CURRENT Block Fusion Write Operations

Statistic	Total	% <1ms	% <10ms
Pins	4,444	100.00	0.00
Flushes	2	50.00	50.00
Writes	284	96.13	3.87

Global Cache Transfer Stats

Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
Busy (Busy) - Block Transfer impacted by Remote Contention
Congested (Congst) - Block Transfer impacted by Remote System Load
ordered by CR + Current Blocks Received desc

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
1	data block	779	98.84	1.16	0.00	5,043	99.86	0.14	0.00
1	Others	18	100.00	0.00	0.00	18	100.00	0.00	0.00
1	undo header	17	94.12	5.88	0.00	5	80.00	20.00	0.00
1	undo block	1	100.00	0.00	0.00	0

End of Report

% Blocks changed per Read:	0.14	Recursive Call %:	41.50
Rollback per transaction %:	86.75	Rows per Sort:	7.12

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.92	In-memory Sort %:	100.00
Library Hit %:	92.89	Soft Parse %:	96.44
Execute to Parse %:	8.04	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	6.97	% Non-Parse CPU:	99.37

Buffer access - local cache %:	99.84
Buffer access - remote cache %:	0.07
Buffer access - disk %:	0.08

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	0.3
Avg global cache current block receive time (ms):	0.5
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	0.5
Avg global cache cr block flush time (ms):	0.0
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):	5.0

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.1
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	50.77
% of indirect sent messages:	28.95
% of flow controlled messages:	20.29