WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

PORTAL 4084336433 portal1 1 10.2.0.4.0 YES rbt_db1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
PORTAL	4084336433	portal1	1	10.2.0.4.0	YES	rbt_db1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 21940 09-May-12 15:00:21 55 1.3

End Snap: 21941 09-May-12 16:01:03 47 1.1

Elapsed: 60.69 (mins)

DB Time: 0.52 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	21940	09-May-12 15:00:21	55	1.3
End Snap:	21941	09-May-12 16:01:03	47	1.1
Elapsed:		60.69 (mins)
DB Time:		0.52 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 581.06 509.52

Logical reads: 100.88 88.46

Block changes: 2.28 2.00

Physical reads: 1.92 1.68

Physical writes: 0.43 0.38

User calls: 13.54 11.87

Parses: 6.02 5.28

Hard parses: 0.27 0.23

Sorts: 3.42 2.99

Logons: 0.04 0.03

Executes: 6.68 5.86

Transactions: 1.14

	Per Second	Per Transaction
Redo size:	581.06	509.52
Logical reads:	100.88	88.46
Block changes:	2.28	2.00
Physical reads:	1.92	1.68
Physical writes:	0.43	0.38
User calls:	13.54	11.87
Parses:	6.02	5.28
Hard parses:	0.27	0.23
Sorts:	3.42	2.99
Logons:	0.04	0.03
Executes:	6.68	5.86
Transactions:	1.14

% Blocks changed per Read: 2.26 Recursive Call %: 44.14

Rollback per transaction %: 89.33 Rows per Sort: 9.38

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 91.23 Soft Parse %: 95.59

Execute to Parse %: 9.86 Latch Hit %: 99.98

Parse CPU to Parse Elapsd %: 14.01 % Non-Parse CPU: 98.70

Shared Pool Statistics

Begin End

Memory Usage %: 11.31 11.96

% SQL with executions>1: 60.67 79.18

% Memory for SQL w/exec>1: 66.50 78.39

	Begin	End
Memory Usage %:	11.31	11.96
% SQL with executions>1:	60.67	79.18
% Memory for SQL w/exec>1:	66.50	78.39

Top 5 Timed Events

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

SQL*Net more data from client 3,934 143 36 462.0 Network

CPU time 17 54.6

reliable message 293 17 57 53.7 Other

db file sequential read 1,886 9 5 29.2 User I/O

db file scattered read 1,054 5 5 17.2 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
SQL*Net more data from client	3,934	143	36	462.0	Network
CPU time		17		54.6
reliable message	293	17	57	53.7	Other
db file sequential read	1,886	9	5	29.2	User I/O
db file scattered read	1,054	5	5	17.2	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.46 1.28

Global Cache blocks served: 1.61 1.42

GCS/GES messages received: 6.05 5.30

GCS/GES messages sent: 5.75 5.04

DBWR Fusion writes: 0.07 0.07

Estd Interconnect traffic (KB) 26.93

	Per Second	Per Transaction
Global Cache blocks received:	1.46	1.28
Global Cache blocks served:	1.61	1.42
GCS/GES messages received:	6.05	5.30
GCS/GES messages sent:	5.75	5.04
DBWR Fusion writes:	0.07	0.07
Estd Interconnect traffic (KB)	26.93

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

Buffer access - local cache %: 96.65

Buffer access - remote cache %: 1.45

Buffer access - disk %: 1.90

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

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

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

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 %: 1.2

Avg global cache cr block flush time (ms): 1.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.1

Avg global cache current block flush time (ms): 0.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.2

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: 49.12

% of indirect sent messages: 33.92

% of flow controlled messages: 16.96

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): 31s
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	26.84	86.45
DB CPU	16.94	54.55
parse time elapsed	1.97	6.35
hard parse elapsed time	1.36	4.39
connection management call elapsed time	0.11	0.36
sequence load elapsed time	0.06	0.20
PL/SQL execution elapsed time	0.00	0.01
PL/SQL compilation elapsed time	0.00	0.01
hard parse (bind mismatch) elapsed time	0.00	0.00
hard parse (sharing criteria) elapsed time	0.00	0.00
repeated bind elapsed time	0.00	0.00
DB time	31.04
background elapsed time	37.49
background cpu time	18.79

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	33,735	0.00	143	4	8.12
Other	43,596	95.83	18	0	10.50
User I/O	3,195	0.00	16	5	0.77
System I/O	12,235	0.00	4	0	2.95
Cluster	7,603	0.00	2	0	1.83
Concurrency	547	0.00	0	0	0.13
Commit	437	0.00	0	1	0.11
Application	744	0.00	0	0	0.18
Configuration	1	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,934	0.00	143	36	0.95
reliable message	293	5.12	17	57	0.07
db file sequential read	1,886	0.00	9	5	0.45
db file scattered read	1,054	0.00	5	5	0.25
control file sequential read	8,778	0.00	2	0	2.11
db file parallel read	252	0.00	2	6	0.06
control file parallel write	1,213	0.00	1	1	0.29
gc current block 2-way	2,666	0.00	1	0	0.64
db file parallel write	1,351	0.00	1	0	0.33
gc cr multi block request	2,983	0.00	1	0	0.72
log file parallel write	893	0.00	0	0	0.22
enq: WF - contention	17	0.00	0	21	0.00
gc cr block 2-way	834	0.00	0	0	0.20
CGS wait for IPC msg	36,067	100.00	0	0	8.68
log file sync	437	0.00	0	1	0.11
row cache lock	469	0.00	0	0	0.11
gc cr grant 2-way	640	0.00	0	0	0.15
os thread startup	4	0.00	0	22	0.00
IPC send completion sync	218	100.00	0	0	0.05
gc current grant 2-way	264	0.00	0	0	0.06
SQL*Net break/reset to client	740	0.00	0	0	0.18
DFS lock handle	156	0.00	0	0	0.04
SQL*Net message to client	28,711	0.00	0	0	6.91
gc current grant busy	114	0.00	0	0	0.03
ksxr poll remote instances	3,706	76.50	0	0	0.89
enq: PS - contention	91	0.00	0	0	0.02
latch free	2	0.00	0	12	0.00
gc current multi block request	91	0.00	0	0	0.02
rdbms ipc reply	161	0.00	0	0	0.04
PX Deq: reap credit	2,706	96.86	0	0	0.65
enq: TX - index contention	1	0.00	0	17	0.00
SQL*Net more data to client	1,090	0.00	0	0	0.26
read by other session	2	0.00	0	6	0.00
library cache pin	48	0.00	0	0	0.01
gcs log flush sync	31	9.68	0	0	0.01
gc current block busy	5	0.00	0	2	0.00
library cache lock	25	0.00	0	0	0.01
gc cr block busy	4	0.00	0	1	0.00
PX Deq Credit: send blkd	18	77.78	0	0	0.00
enq: TA - contention	12	0.00	0	0	0.00
LGWR wait for redo copy	87	0.00	0	0	0.02
enq: TD - KTF dump entries	6	0.00	0	0	0.00
PX Deq: Signal ACK	18	33.33	0	0	0.00
enq: TM - contention	4	0.00	0	0	0.00
enq: DR - contention	2	0.00	0	0	0.00
direct path write	1	0.00	0	0	0.00
enq: MW - contention	2	0.00	0	0	0.00
gc cr disk read	1	0.00	0	0	0.00
enq: TX - allocate ITL entry	1	0.00	0	0	0.00
gc current split	1	0.00	0	0	0.00
enq: FB - contention	1	0.00	0	0	0.00
enq: AF - task serialization	1	0.00	0	0	0.00
latch: session allocation	1	0.00	0	0	0.00
SQL*Net message from client	28,719	0.00	71,266	2482	6.92
gcs remote message	251,889	99.47	7,110	28	60.65
virtual circuit status	122	100.00	3,568	29243	0.03
Streams AQ: qmn slave idle wait	141	0.00	3,556	25223	0.03
Streams AQ: qmn coordinator idle wait	266	48.12	3,556	13370	0.06
DIAG idle wait	18,205	0.00	3,556	195	4.38
ges remote message	47,603	98.54	3,556	75	11.46
PX Idle Wait	1,499	93.93	3,555	2371	0.36
Streams AQ: waiting for messages in the queue	376	100.00	3,550	9441	0.09
Streams AQ: waiting for time management or cleanup tasks	12	0.00	3,373	281112	0.00
jobq slave wait	40	100.00	117	2930	0.01
PX Deq: Execution Msg	461	31.67	0	0	0.11
PX Deq: Join ACK	30	40.00	0	0	0.01
PX Deq: Parse Reply	30	40.00	0	0	0.01
PX Deq: Msg Fragment	105	30.48	0	0	0.03
PX Deq: Execute Reply	24	25.00	0	0	0.01
Streams AQ: RAC qmn coordinator idle wait	271	100.00	0	0	0.07
class slave wait	2	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,779	96.02	17	0	9.82
control file sequential read	8,012	0.00	2	0	1.93
control file parallel write	1,213	0.00	1	1	0.29
db file parallel write	1,351	0.00	1	0	0.33
log file parallel write	893	0.00	0	0	0.22
os thread startup	4	0.00	0	22	0.00
row cache lock	116	0.00	0	0	0.03
db file sequential read	5	0.00	0	5	0.00
gc current block 2-way	85	0.00	0	0	0.02
gc cr block 2-way	19	0.00	0	0	0.00
gc current grant busy	15	0.00	0	0	0.00
enq: TM - contention	2	0.00	0	0	0.00
gc cr disk read	1	0.00	0	0	0.00
gc current grant 2-way	10	0.00	-0	-0	0.00
rdbms ipc message	53,414	95.01	38,936	729	12.86
gcs remote message	251,890	99.47	7,110	28	60.65
Streams AQ: qmn slave idle wait	141	0.00	3,556	25223	0.03
Streams AQ: qmn coordinator idle wait	266	48.12	3,556	13370	0.06
DIAG idle wait	18,205	0.00	3,556	195	4.38
ges remote message	47,603	98.54	3,556	75	11.46
pmon timer	1,285	100.00	3,552	2764	0.31
Streams AQ: waiting for time management or cleanup tasks	12	0.00	3,373	281112	0.00
smon timer	12	100.00	3,263	271890	0.00
PX Deq: Join ACK	30	40.00	0	0	0.01
PX Deq: Parse Reply	30	40.00	0	0	0.01
PX Deq: Execute Reply	24	25.00	0	0	0.01
Streams AQ: RAC qmn coordinator idle wait	271	100.00	0	0	0.07

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	2,419
AVG_IDLE_TIME	362,571
AVG_IOWAIT_TIME	160
AVG_SYS_TIME	1,456
AVG_USER_TIME	850
BUSY_TIME	20,113
IDLE_TIME	2,901,382
IOWAIT_TIME	2,021
SYS_TIME	12,490
USER_TIME	7,623
LOAD	0
OS_CPU_WAIT_TIME	95,500
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	30.40	16.30	6,582	346,113
SYS$USERS	0.60	0.60	1	3,094
SYS$BACKGROUND	0.00	0.00	400	18,364
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	2937	1520	138	4	27632	13807
SYS$USERS	1	1	0	0	5849	58
SYS$BACKGROUND	256	77	409	21	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
2	1	611	0.00	6.97	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
2	0	56	0.04	6.90	69zbya7t6q35n	JDBC Thin Client	insert into T_SYS_ACCESSLOGS (...
2	2	1	1.83	5.90	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
2	1	77	0.02	5.59	190unkpdg99p7	JDBC Thin Client	select * from ( select news0_....
2	1	1,225	0.00	5.19	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
1	1	1	0.65	2.10	bunssq950snhf		insert into wrh$_sga_target_ad...
1	1	4,869	0.00	1.78	953hsjnbvbrcb	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
0	0	1	0.37	1.19	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0	0	640	0.00	1.16	c4wx2rkhsgvm5	JDBC Thin Client	select t.id, t.name, t.bussi...
0	0	94	0.00	1.14	fjsd3cxawv4u0	JDBC Thin Client	select * from ( select receive...

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	2	1	1.74	5.90	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
1	2	1,225	0.00	5.19	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
1	2	77	0.02	5.59	190unkpdg99p7	JDBC Thin Client	select * from ( select news0_....
1	2	611	0.00	6.97	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
1	1	1	0.65	2.10	bunssq950snhf		insert into wrh$_sga_target_ad...
1	1	4,869	0.00	1.78	953hsjnbvbrcb	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
0	0	640	0.00	1.16	c4wx2rkhsgvm5	JDBC Thin Client	select t.id, t.name, t.bussi...
0	0	94	0.00	1.14	fjsd3cxawv4u0	JDBC Thin Client	select * from ( select receive...
0	0	2	0.14	0.95	fa3d0a77x71rs	JDBC Thin Client	select * from ( select news0_....
0	0	1,882	0.00	0.87	2ckbmh5m8pd68	JDBC Thin Client	select user0_.PHONE_NUMBER as ...
0	0	1	0.26	1.19	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0	2	56	0.00	6.90	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: 367,384
Captured SQL account for 81.6% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
50,289	1	50,289.00	13.69	1.74	1.83	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
40,960	640	64.00	11.15	0.36	0.36	c4wx2rkhsgvm5	JDBC Thin Client	select t.id, t.name, t.bussi...
34,090	4,869	7.00	9.28	0.55	0.55	953hsjnbvbrcb	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
33,934	94	361.00	9.24	0.35	0.35	fjsd3cxawv4u0	JDBC Thin Client	select * from ( select receive...
31,928	77	414.65	8.69	1.30	1.73	190unkpdg99p7	JDBC Thin Client	select * from ( select news0_....
14,032	877	16.00	3.82	0.11	0.11	8sqysbs1s8hrr	JDBC Thin Client	select count(*) as col_0_0_ fr...
12,460	1,780	7.00	3.39	0.21	0.21	5cqctydwqs1w2	JDBC Thin Client	select activity0_.ID as ID5_, ...
10,332	2	5,166.00	2.81	0.29	0.29	fa3d0a77x71rs	JDBC Thin Client	select * from ( select news0_....
7,528	1,882	4.00	2.05	0.27	0.27	2ckbmh5m8pd68	JDBC Thin Client	select user0_.PHONE_NUMBER as ...
7,489	277	27.04	2.04	0.15	0.15	fvkudysvjxcyp	JDBC Thin Client	select areas0_.OPERATION_ID as...
7,007	1,001	7.00	1.91	0.10	0.10	4p1sd0jvasbz0	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
6,611	611	10.82	1.80	1.03	2.16	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
6,552	277	23.65	1.78	0.11	0.11	36ga3f2jft2vu	JDBC Thin Client	select operations0_.SUPERIOR a...
5,626	1	5,626.00	1.53	0.26	0.37	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
5,166	1	5,166.00	1.41	0.14	0.15	g8qgtaw19n82d	JDBC Thin Client	select * from ( select news0_....
4,874	1,225	3.98	1.33	1.43	1.61	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 6,989
Captured SQL account for 34.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
516	1,225	0.42	7.38	1.43	1.61	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
451	611	0.74	6.45	1.03	2.16	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
260	56	4.64	3.72	0.15	2.14	69zbya7t6q35n	JDBC Thin Client	insert into T_SYS_ACCESSLOGS (...
206	5	41.20	2.95	0.02	0.27	3hrub1q8j155s	JDBC Thin Client	select count(*) from T_FC_FIRS...
169	1	169.00	2.42	0.03	0.27	01g9akznfp9ps	JDBC Thin Client	select count(*) from T_FC_FIRS...
139	2	69.50	1.99	0.02	0.25	2mr87ujsvvf64	JDBC Thin Client	select count(*) from T_FC_FIRS...
95	1	95.00	1.36	0.00	0.15	1uua0ypkwq7m0	JDBC Thin Client	select count(*) from T_FC_FIRS...
94	2	47.00	1.34	0.02	0.17	amrdtvct0vv1d	JDBC Thin Client	select count(*) from T_FC_FIRS...
94	1	94.00	1.34	0.01	0.17	cbf4vuua64c0h	JDBC Thin Client	select count(*) from T_FC_FIRS...
81	2	40.50	1.16	0.02	0.18	3h4acqvc1du2q	JDBC Thin Client	select count(*) from T_FC_FIRS...
78	5	15.60	1.12	0.00	0.15	3a00n9tycsrds	JDBC Thin Client	select count(*) from T_FC_FIRS...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 24,332
Captured SQL account for 79.8% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
4,869	17,486	3.59	953hsjnbvbrcb	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
1,882	1,882	1.00	2ckbmh5m8pd68	JDBC Thin Client	select user0_.PHONE_NUMBER as ...
1,882	0	0.00	ax0z40kwrxhu4	JDBC Thin Client	select operations0_.PHONE_NUMB...
1,780	0	0.00	5cqctydwqs1w2	JDBC Thin Client	select activity0_.ID as ID5_, ...
1,225	1,199	0.98	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
1,001	1,001	1.00	4p1sd0jvasbz0	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
877	877	1.00	8sqysbs1s8hrr	JDBC Thin Client	select count(*) as col_0_0_ fr...
728	2	0.00	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
640	5,742	8.97	c4wx2rkhsgvm5	JDBC Thin Client	select t.id, t.name, t.bussi...
611	2,233	3.65	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
522	522	1.00	cmqhvqu3u4hd6	JDBC Thin Client	select SEQ_SYS_ACCESSLOGS.next...
319	2,233	7.00	816dsfgbhqq3u	JDBC Thin Client	select categories0_.ID as ID82...
277	2,387	8.62	36ga3f2jft2vu	JDBC Thin Client	select operations0_.SUPERIOR a...
277	18,276	65.98	fvkudysvjxcyp	JDBC Thin Client	select areas0_.OPERATION_ID as...
276	52	0.19	7djxb2a6x996p	JDBC Thin Client	select refoperati0_.OPERATION_...
248	248	1.00	03164c4t3c5xw	JDBC Thin Client	insert into T_FC_FIRST_LOGIN_L...
248	248	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: 21,933
Captured SQL account for 83.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
4,871	4,869	22.21	953hsjnbvbrcb	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
1,882	1,882	8.58	2ckbmh5m8pd68	JDBC Thin Client	select user0_.PHONE_NUMBER as ...
1,881	1,882	8.58	ax0z40kwrxhu4	JDBC Thin Client	select operations0_.PHONE_NUMB...
1,780	1,780	8.12	5cqctydwqs1w2	JDBC Thin Client	select activity0_.ID as ID5_, ...
1,225	1,225	5.59	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
1,001	1,001	4.56	4p1sd0jvasbz0	JDBC Thin Client	select zhangtingb0_.ID as ID6_...
877	877	4.00	8sqysbs1s8hrr	JDBC Thin Client	select count(*) as col_0_0_ fr...
640	640	2.92	c4wx2rkhsgvm5	JDBC Thin Client	select t.id, t.name, t.bussi...
611	611	2.79	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
522	522	2.38	cmqhvqu3u4hd6	JDBC Thin Client	select SEQ_SYS_ACCESSLOGS.next...
319	319	1.45	816dsfgbhqq3u	JDBC Thin Client	select categories0_.ID as ID82...
277	277	1.26	36ga3f2jft2vu	JDBC Thin Client	select operations0_.SUPERIOR a...
277	277	1.26	fvkudysvjxcyp	JDBC Thin Client	select areas0_.OPERATION_ID as...
276	276	1.26	7djxb2a6x996p	JDBC Thin Client	select refoperati0_.OPERATION_...
248	248	1.13	03164c4t3c5xw	JDBC Thin Client	insert into T_FC_FIRST_LOGIN_L...
248	248	1.13	dm3h4zdprmsch	JDBC Thin Client	select SEQ_FIRST_LOGIN_LOGS.ne...

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.10	4.84	2.16	1.03	611	59q9puwma9gnp	JDBC Thin Client	select viewnotes0_.ID as ID81_...
0.10	37.77	0.27	0.27	1,882	2ckbmh5m8pd68	JDBC Thin Client	select user0_.PHONE_NUMBER as ...
0.09	5.54	1.61	1.43	1,225	6sgbxr6bgs7pa	JDBC Thin Client	select MOBILE_TYPE, USER_AGENT...
0.07	30.70	0.24	0.22	248	03164c4t3c5xw	JDBC Thin Client	insert into T_FC_FIRST_LOGIN_L...
0.06	2.93	2.14	0.15	56	69zbya7t6q35n	JDBC Thin Client	insert into T_SYS_ACCESSLOGS (...
0.04	10.34	0.37	0.26	1	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0.03	15.70	0.17	0.01	1	cbf4vuua64c0h	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.02	13.85	0.16	0.03	4	7z9gu6rr3k6tg	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.02	5.85	0.27	0.03	1	01g9akznfp9ps	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.02	11.61	0.14	0.03	5	8y5ubbb3zb6th	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.02	16.77	0.09	0.08	70	a4c6qvukwpabv	JDBC Thin Client	update T_FC_USER set MOBILE_TY...
0.01	5.47	0.27	0.02	5	3hrub1q8j155s	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.01	4.76	0.25	0.02	2	2mr87ujsvvf64	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.01	7.67	0.13	0.00	2	23j6wrhspr095	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.01	5.31	0.17	0.02	2	amrdtvct0vv1d	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.01	4.25	0.18	0.02	2	3h4acqvc1du2q	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.01	4.97	0.15	0.00	1	1uua0ypkwq7m0	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.01	13.87	0.05	0.04	1	31a13pnjps7j3		SELECT source, (case w...
0.01	15.29	0.04	0.04	248	dm3h4zdprmsch	JDBC Thin Client	select SEQ_FIRST_LOGIN_LOGS.ne...
0.01	3.90	0.15	0.00	5	3a00n9tycsrds	JDBC Thin Client	select count(*) from T_FC_FIRS...
0.01	45.94	0.01	0.01	117	c4nhd1ntptxq7		select message_level, sequenc...
0.01	0.79	0.65	0.65	1	bunssq950snhf		insert into wrh$_sga_target_ad...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

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

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

23j6wrhspr095 select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '15905013589' 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

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

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

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

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

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

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

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

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

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)

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

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

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

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

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

bd502nbh9abbs select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

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

c4nhd1ntptxq7 select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4

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

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

cmqhvqu3u4hd6 select SEQ_SYS_ACCESSLOGS.nextval from dual

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

dm3h4zdprmsch select SEQ_FIRST_LOGIN_LOGS.nextval from dual

fa3d0a77x71rs 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_.STATUS=:2 and news0_.END_DATE>:3 and news0_.ID<>:4 and news0_.AREA_ID=:5 order by news0_.UPLOAD_TIME desc ) where rownum <= :6

fjsd3cxawv4u0 select * from ( select receiversm0_.MSG_ID as MSG1_29_, receiversm0_.SERVICE_ID as SERVICE2_29_, receiversm0_.SERVICE_NO as SERVICE3_29_, receiversm0_.MSG_FORMAT as MSG4_29_, receiversm0_.CONTENT as CONTENT29_, receiversm0_.SRC_TERMINAL_ID as SRC6_29_, receiversm0_.DEST_TERMINAL_ID as DEST7_29_, receiversm0_.RECEIVE_TIME as RECEIVE8_29_, receiversm0_.RETURN_CODE as RETURN9_29_, receiversm0_.RETURN_INFO as RETURN10_29_, receiversm0_.STATUS as STATUS29_ from T_SYS_RECEIVE_SM receiversm0_ where receiversm0_.STATUS=:1 order by receiversm0_.RECEIVE_TIME ) where rownum <= :2

fvkudysvjxcyp select areas0_.OPERATION_ID as OPERATION1_1_, areas0_.AREA_ID as AREA2_1_, area1_.ID as ID14_0_, area1_.AREA_NAME as AREA2_14_0_, area1_.REMARK as REMARK14_0_, area1_.SUPER_AREA as SUPER4_14_0_ from T_FC_OPERATION_ACCESS areas0_ left outer join T_SYS_AREA area1_ on areas0_.AREA_ID=area1_.ID where areas0_.OPERATION_ID in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)

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
01g9akznfp9ps	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13506065534' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
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
1uua0ypkwq7m0	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13606979378' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
23j6wrhspr095	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '15905013589' 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
2mr87ujsvvf64	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13806958875' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
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
36ga3f2jft2vu	select operations0_.SUPERIOR as SUPERIOR1_, operations0_.ID as ID1_, operations0_.ID as ID40_0_, operations0_.SUPERIOR as SUPERIOR40_0_, operations0_.CODE as CODE40_0_, operations0_.TYPE as TYPE40_0_, operations0_.NAME as NAME40_0_, operations0_.URL as URL40_0_, operations0_.DES_PIC as DES7_40_0_, operations0_.STATUS as STATUS40_0_, operations0_.INFO as INFO40_0_, operations0_.SP_INFO as SP10_40_0_, operations0_.FOCUS as FOCUS40_0_, operations0_.FAVORITE as FAVORITE40_0_, operations0_.MY_PLACE as MY13_40_0_, operations0_.PLACE as PLACE40_0_, operations0_.RECENT as RECENT40_0_, operations0_.CREATE_DATE as CREATE16_40_0_, operations0_.END_DATE as END17_40_0_, operations0_.FLAG as FLAG40_0_, operations0_.USAGE_MODE as USAGE19_40_0_, operations0_.COST_EXPLAIN as COST20_40_0_, operations0_.WAP_CALL_URL as WAP21_40_0_, operations0_.IVR_CALL_URL as IVR22_40_0_, operations0_.HELP_FAQ as HELP23_40_0_, operations0_.EXT_ACCESS as EXT24_40_0_, operations0_.TITLE_COLOR as TITLE25_40_0_, operations0_.BUSINESS_IFS_TYPE as BUSINESS26_40_0_, operations0_.SERVICE_OPTION as SERVICE27_40_0_, operations0_.BIZ_TYPE as BIZ28_40_0_, operations0_.SP_ID as SP29_40_0_, operations0_.SP_BIZ_CODE as SP30_40_0_, operations0_.HOME_DOMAIN as HOME31_40_0_, operations0_.ORIG_DOMAIN as ORIG32_40_0_, operations0_.SUCCESS_INFO as SUCCESS33_40_0_, operations0_.OPR_CODE_OPEN as OPR34_40_0_, operations0_.OPR_CODE_CLOSE as OPR35_40_0_, operations0_.PRICE as PRICE40_0_, operations 0_.ORDER_TYPE as ORDER37_40_0_, operations0_.SHORT_DES as SHORT38_40_0_, operations0_.LONG_DES as LONG39_40_0_, operations0_.FAINT_WORD as FAINT40_40_0_, operations0_.SIMPLE_DES as SIMPLE41_40_0_, operations0_.bg_pic as bg42_40_0_, operations0_.ACTION_URL as ACTION43_40_0_, operations0_.OPEN_URL as OPEN44_40_0_, operations0_.BUSSINESS_TYPE as BUSSINESS45_40_0_, operations0_.DISPLAY_ORDER as DISPLAY46_40_0_, operations0_.BUSSINESS_TYPE_ORDER as BUSSINESS47_40_0_ from T_FC_OPERATION operations0_ where operations0_.SUPERIOR in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10) order by nvl(operations0_.MY_PLACE, 0) desc, operations0_.PLACE asc
3a00n9tycsrds	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13805010598' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
3h4acqvc1du2q	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '15959000527' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
3hrub1q8j155s	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '15160756880' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
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
7z9gu6rr3k6tg	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13805992995' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
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)
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
8y5ubbb3zb6th	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13850029631' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
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
amrdtvct0vv1d	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '13635207727' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
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
bd502nbh9abbs	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
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
c4nhd1ntptxq7	select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
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
cbf4vuua64c0h	select count(*) from T_FC_FIRST_LOGIN_LOGS t where t.phone_number = '18359556390' and to_char(t.login_time, 'yyyy-MM-dd') = to_char(sysdate, 'yyyy-MM-dd')
cmqhvqu3u4hd6	select SEQ_SYS_ACCESSLOGS.nextval from dual
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dm3h4zdprmsch	select SEQ_FIRST_LOGIN_LOGS.nextval from dual
fa3d0a77x71rs	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_.STATUS=:2 and news0_.END_DATE>:3 and news0_.ID<>:4 and news0_.AREA_ID=:5 order by news0_.UPLOAD_TIME desc ) where rownum <= :6
fjsd3cxawv4u0	select * from ( select receiversm0_.MSG_ID as MSG1_29_, receiversm0_.SERVICE_ID as SERVICE2_29_, receiversm0_.SERVICE_NO as SERVICE3_29_, receiversm0_.MSG_FORMAT as MSG4_29_, receiversm0_.CONTENT as CONTENT29_, receiversm0_.SRC_TERMINAL_ID as SRC6_29_, receiversm0_.DEST_TERMINAL_ID as DEST7_29_, receiversm0_.RECEIVE_TIME as RECEIVE8_29_, receiversm0_.RETURN_CODE as RETURN9_29_, receiversm0_.RETURN_INFO as RETURN10_29_, receiversm0_.STATUS as STATUS29_ from T_SYS_RECEIVE_SM receiversm0_ where receiversm0_.STATUS=:1 order by receiversm0_.RECEIVE_TIME ) where rownum <= :2
fvkudysvjxcyp	select areas0_.OPERATION_ID as OPERATION1_1_, areas0_.AREA_ID as AREA2_1_, area1_.ID as ID14_0_, area1_.AREA_NAME as AREA2_14_0_, area1_.REMARK as REMARK14_0_, area1_.SUPER_AREA as SUPER4_14_0_ from T_FC_OPERATION_ACCESS areas0_ left outer join T_SYS_AREA area1_ on areas0_.AREA_ID=area1_.ID where areas0_.OPERATION_ID in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
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	1,490	0.41	0.36
CPU used when call started	905	0.25	0.22
CR blocks created	10	0.00	0.00
DB time	379,043	104.09	91.27
DBWR checkpoint buffers written	1,352	0.37	0.33
DBWR fusion writes	270	0.07	0.07
DBWR transaction table writes	92	0.03	0.02
DBWR undo block writes	218	0.06	0.05
DFO trees parallelized	12	0.00	0.00
PX local messages recv'd	30	0.01	0.01
PX local messages sent	30	0.01	0.01
PX remote messages recv'd	310	0.09	0.07
PX remote messages sent	188	0.05	0.05
Parallel operations not downgraded	12	0.00	0.00
RowCR attempts	1	0.00	0.00
RowCR hits	1	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	28,550	7.84	6.87
active txn count during cleanout	77	0.02	0.02
application wait time	3	0.00	0.00
background timeouts	12,761	3.50	3.07
branch node splits	1	0.00	0.00
buffer is not pinned count	123,291	33.86	29.69
buffer is pinned count	190,620	52.34	45.90
bytes received via SQL*Net from client	16,646,031	4,571.05	4,008.19
bytes sent via SQL*Net to client	18,033,001	4,951.91	4,342.16
calls to get snapshot scn: kcmgss	53,040	14.56	12.77
calls to kcmgas	3,842	1.06	0.93
calls to kcmgcs	48	0.01	0.01
change write time	5	0.00	0.00
cleanout - number of ktugct calls	114	0.03	0.03
cleanouts and rollbacks - consistent read gets	6	0.00	0.00
cleanouts only - consistent read gets	9	0.00	0.00
cluster key scan block gets	2,142	0.59	0.52
cluster key scans	281	0.08	0.07
cluster wait time	180	0.05	0.04
commit batch/immediate performed	7	0.00	0.00
commit batch/immediate requested	7	0.00	0.00
commit cleanout failures: block lost	20	0.01	0.00
commit cleanout failures: buffer being written	1	0.00	0.00
commit cleanout failures: callback failure	4	0.00	0.00
commit cleanouts	2,187	0.60	0.53
commit cleanouts successfully completed	2,162	0.59	0.52
commit immediate performed	7	0.00	0.00
commit immediate requested	7	0.00	0.00
commit txn count during cleanout	172	0.05	0.04
concurrency wait time	25	0.01	0.01
consistent changes	15	0.00	0.00
consistent gets	357,415	98.15	86.06
consistent gets - examination	35,332	9.70	8.51
consistent gets direct	1	0.00	0.00
consistent gets from cache	357,414	98.15	86.06
cursor authentications	494	0.14	0.12
data blocks consistent reads - undo records applied	7	0.00	0.00
db block changes	8,315	2.28	2.00
db block gets	9,969	2.74	2.40
db block gets direct	1	0.00	0.00
db block gets from cache	9,968	2.74	2.40
deferred (CURRENT) block cleanout applications	1,465	0.40	0.35
enqueue conversions	767	0.21	0.18
enqueue releases	42,239	11.60	10.17
enqueue requests	42,239	11.60	10.17
enqueue timeouts	0	0.00	0.00
enqueue waits	138	0.04	0.03
exchange deadlocks	1	0.00	0.00
execute count	24,332	6.68	5.86
free buffer inspected	0	0.00	0.00
free buffer requested	19,192	5.27	4.62
gc CPU used by this session	896	0.25	0.22
gc cr block build time	0	0.00	0.00
gc cr block flush time	1	0.00	0.00
gc cr block receive time	25	0.01	0.01
gc cr block send time	2	0.00	0.00
gc cr blocks received	882	0.24	0.21
gc cr blocks served	816	0.22	0.20
gc current block pin time	4	0.00	0.00
gc current block receive time	178	0.05	0.04
gc current block send time	15	0.00	0.00
gc current blocks received	4,445	1.22	1.07
gc current blocks served	5,065	1.39	1.22
gc local grants	3,537	0.97	0.85
gc remote grants	3,735	1.03	0.90
gcs messages sent	19,082	5.24	4.59
ges messages sent	1,859	0.51	0.45
global enqueue get time	63	0.02	0.02
global enqueue gets async	525	0.14	0.13
global enqueue gets sync	9,140	2.51	2.20
global enqueue releases	8,879	2.44	2.14
heap block compress	25	0.01	0.01
immediate (CR) block cleanout applications	15	0.00	0.00
immediate (CURRENT) block cleanout applications	99	0.03	0.02
index crx upgrade (found)	2	0.00	0.00
index crx upgrade (positioned)	3,771	1.04	0.91
index fetch by key	14,200	3.90	3.42
index scans kdiixs1	37,728	10.36	9.08
leaf node 90-10 splits	10	0.00	0.00
leaf node splits	23	0.01	0.01
lob reads	0	0.00	0.00
lob writes	15	0.00	0.00
lob writes unaligned	15	0.00	0.00
logons cumulative	135	0.04	0.03
messages received	3,070	0.84	0.74
messages sent	3,070	0.84	0.74
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	291,521	80.05	70.20
opened cursors cumulative	22,295	6.12	5.37
parse count (failures)	0	0.00	0.00
parse count (hard)	967	0.27	0.23
parse count (total)	21,933	6.02	5.28
parse time cpu	22	0.01	0.01
parse time elapsed	157	0.04	0.04
physical read IO requests	4,074	1.12	0.98
physical read bytes	57,253,888	15,722.08	13,786.15
physical read total IO requests	12,894	3.54	3.10
physical read total bytes	201,416,704	55,309.58	48,499.09
physical read total multi block requests	1,057	0.29	0.25
physical reads	6,989	1.92	1.68
physical reads cache	6,988	1.92	1.68
physical reads cache prefetch	3,839	1.05	0.92
physical reads direct	1	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	3,444	0.95	0.83
physical write IO requests	1,446	0.40	0.35
physical write bytes	12,951,552	3,556.53	3,118.60
physical write total IO requests	6,875	1.89	1.66
physical write total bytes	77,747,200	21,349.60	18,720.73
physical write total multi block requests	1,348	0.37	0.32
physical writes	1,581	0.43	0.38
physical writes direct	1	0.00	0.00
physical writes direct (lob)	1	0.00	0.00
physical writes from cache	1,580	0.43	0.38
physical writes non checkpoint	1,062	0.29	0.26
process last non-idle time	3,321	0.91	0.80
queries parallelized	12	0.00	0.00
recursive calls	38,955	10.70	9.38
recursive cpu usage	192	0.05	0.05
redo blocks written	5,053	1.39	1.22
redo entries	6,000	1.65	1.44
redo ordering marks	99	0.03	0.02
redo size	2,116,020	581.06	509.52
redo subscn max counts	175	0.05	0.04
redo synch time	20	0.01	0.00
redo synch writes	445	0.12	0.11
redo wastage	257,728	70.77	62.06
redo write time	44	0.01	0.01
redo writer latching time	1	0.00	0.00
redo writes	894	0.25	0.22
rollback changes - undo records applied	12	0.00	0.00
rollbacks only - consistent read gets	1	0.00	0.00
rows fetched via callback	5,437	1.49	1.31
session connect time	2,910	0.80	0.70
session cursor cache hits	18,460	5.07	4.44
session logical reads	367,384	100.88	88.46
session pga memory	86,768,872	23,826.97	20,893.06
session pga memory max	78,166,600	21,464.76	18,821.72
session uga memory	8,589,787,064	2,358,779.23	2,068,333.03
session uga memory max	52,814,120	14,502.90	12,717.10
shared hash latch upgrades - no wait	5,137	1.41	1.24
shared hash latch upgrades - wait	2	0.00	0.00
sorts (memory)	12,438	3.42	2.99
sorts (rows)	116,693	32.04	28.10
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
switch current to new buffer	1	0.00	0.00
table fetch by rowid	104,696	28.75	25.21
table fetch continued row	7	0.00	0.00
table scan blocks gotten	151,145	41.50	36.39
table scan rows gotten	3,518,386	966.16	847.19
table scans (long tables)	0	0.00	0.00
table scans (short tables)	12,044	3.31	2.90
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	7	0.00	0.00
undo change vector size	618,556	169.86	148.94
user I/O wait time	1,598	0.44	0.38
user calls	49,299	13.54	11.87
user commits	443	0.12	0.11
user rollbacks	3,710	1.02	0.89
workarea executions - optimal	8,935	2.45	2.15

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,520	2,399
opened cursors current	71	54
logons current	55	47

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,358	1	5.91	1.72	800	1	0.00
SYSAUX	235	0	3.19	1.64	368	0	0.00
FCINDEX	459	0	5.56	1.78	58	1	10.00
UNDOTBS1	0	0	0.00	0.00	200	0	0.00
SYSTEM	17	0	4.71	1.18	20	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	93	5.59	2.19	22	0	0.00
FC	/dev/rora_data003	117	5.90	1.92	16	0	0.00
FC	/dev/rora_data004	121	4.46	1.85	16	0	0.00
FC	/dev/rora_data005	113	6.02	2.22	16	0	0.00
FC	/dev/rora_data006	90	5.44	2.07	14	1	0.00
FC	/dev/rora_data007	129	5.12	2.02	22	0	0.00
FC	/dev/rora_data009	83	4.10	2.23	12	0	0.00
FC	/dev/rora_data010	133	5.41	2.05	20	0	0.00
FC	/dev/rora_data011	143	4.27	1.94	19	0	0.00
FC	/dev/rora_data016	213	5.96	1.62	56	0	0.00
FC	/dev/rora_data017	248	6.41	1.54	87	0	0.00
FC	/dev/rora_data018	177	6.16	1.64	56	0	0.00
FC	/dev/rora_data019	242	5.37	1.59	48	0	0.00
FC	/dev/rora_data020	204	6.72	1.56	70	0	0.00
FC	/dev/rora_data021	180	5.39	1.59	77	0	0.00
FC	/dev/rora_data022	187	5.67	1.47	58	0	0.00
FC	/dev/rora_data023	221	6.20	1.75	58	0	0.00
FC	/dev/rora_data031	230	6.26	1.48	56	0	0.00
FC	/dev/rora_data032	223	8.25	1.55	35	0	0.00
FC	/dev/rora_data033	211	6.07	1.52	42	0	0.00
FCINDEX	/dev/rora_data008	238	5.76	1.71	24	1	10.00
FCINDEX	/dev/rora_data015	221	5.34	1.85	34	0	0.00
SYSAUX	/dev/rlv_sysaux_02	142	3.10	1.58	234	0	0.00
SYSAUX	/dev/rlv_sysaux_2046m	93	3.33	1.74	134	0	0.00
SYSTEM	/dev/rlv_system_2046m	8	6.25	1.00	20	0	0.00
SYSTEM	/dev/rlv_system_2g	9	3.33	1.33	0	0	0.00
UNDOTBS1	/dev/rlv_undo1_4094m	0			195	0	0.00
UNDOTBS1	/dev/rlv_undo1a_2046m	0			5	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	351,177	98	367,389	6,982	1,580	0	0	2

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	331	1054	2798	5651190	2798
E	0	0	216	677	1007	5651190	1007

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	288	0.10	34,542	1.03	164,024
D	576	0.20	69,084	1.00	158,838
D	864	0.30	103,626	1.00	158,838
D	1,152	0.39	138,168	1.00	158,838
D	1,440	0.49	172,710	1.00	158,838
D	1,728	0.59	207,252	1.00	158,838
D	2,016	0.69	241,794	1.00	158,838
D	2,304	0.79	276,336	1.00	158,838
D	2,592	0.89	310,878	1.00	158,838
D	2,880	0.98	345,420	1.00	158,838
D	2,928	1.00	351,177	1.00	158,838
D	3,168	1.08	379,962	1.00	158,838
D	3,456	1.18	414,504	1.00	158,838
D	3,744	1.28	449,046	1.00	158,838
D	4,032	1.38	483,588	1.00	158,838
D	4,320	1.48	518,130	1.00	158,838
D	4,608	1.57	552,672	1.00	158,838
D	4,896	1.67	587,214	1.00	158,838
D	5,184	1.77	621,756	1.00	158,838
D	5,472	1.87	656,298	1.00	158,838
D	5,760	1.97	690,840	1.00	158,838

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,341	158.41	0.00	0.00	0.00	0.00	159,530
E	1,558	1,346	142.91	0.00	0.00	0.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	8,725	8,725
64K	128K	13	13
128K	256K	4	4
512K	1024K	11	11
1M	2M	179	179
2M	4M	3	3

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	1,051.83	100.00
390	0.25	1,051.83	100.00
779	0.50	1,051.83	100.00
1,169	0.75	1,051.83	100.00
1,558	1.00	1,051.83	100.00
1,870	1.20	1,051.83	100.00
2,181	1.40	1,051.83	100.00
2,493	1.60	1,051.83	100.00
2,804	1.80	1,051.83	100.00
3,116	2.00	1,051.83	100.00
4,674	3.00	1,051.83	100.00
6,232	4.00	1,051.83	100.00
9,348	6.00	1,051.83	100.00
12,464	8.00	1,051.83	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
608	0.19	62	6,814	1,915	1.00	8	1.00	54,603
928	0.29	62	6,814	1,915	1.00	8	1.00	54,603
1,248	0.39	62	6,814	1,915	1.00	8	1.00	54,603
1,568	0.49	62	6,814	1,915	1.00	8	1.00	54,603
1,888	0.60	62	6,814	1,915	1.00	8	1.00	54,603
2,208	0.70	62	6,814	1,915	1.00	8	1.00	54,603
2,528	0.80	62	6,814	1,915	1.00	8	1.00	54,603
2,848	0.90	62	6,814	1,915	1.00	8	1.00	54,603
3,168	1.00	62	6,814	1,915	1.00	8	1.00	54,603
3,488	1.10	62	6,814	1,915	1.00	8	1.00	54,603
3,808	1.20	62	6,814	1,915	1.00	8	1.00	54,603
4,128	1.30	62	6,814	1,915	1.00	8	1.00	54,603
4,448	1.40	62	6,814	1,915	1.00	8	1.00	54,603
4,768	1.51	62	6,814	1,915	1.00	8	1.00	54,603
5,088	1.61	62	6,814	1,915	1.00	8	1.00	54,603
5,408	1.71	62	6,814	1,915	1.00	8	1.00	54,603
5,728	1.81	62	6,814	1,915	1.00	8	1.00	54,603
6,048	1.91	62	6,814	1,915	1.00	8	1.00	54,603
6,368	2.01	62	6,814	1,915	1.00	8	1.00	54,603

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	142	158,747
3,072	0.50	142	158,747
4,608	0.75	142	158,747
6,144	1.00	142	158,747
7,680	1.25	142	158,747
9,216	1.50	142	158,747
10,752	1.75	142	158,747
12,288	2.00	142	158,747

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	2	0	5

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	28	28	17	21.76
PS-PX Process Reservation	133	133	91	0.37
TX-Transaction (index contention)	1	1	1	17.00
TA-Instance Undo	12	12	12	0.25
TM-DML	3,905	3,905	4	0.25
MW-MWIN Schedule	2	2	2	0.50
AF-Advisor Framework (task serialization)	7	7	1	1.00
TD-KTF map table enqueue (KTF dump entries)	6	6	6	0.00
DR-Distributed Recovery	2	2	2	0.00
FB-Format Block	1	1	1	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
1	0.11	721	551	3	15/46.7	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:58	1	65	551	1	24	0/0	0/0/0/0/0/0
09-May 15:48	7	57	0	3	15	0/0	0/0/0/0/0/0
09-May 15:38	3	44	0	1	15	0/0	0/0/0/0/0/0
09-May 15:28	22	196	99	3	16	0/0	0/0/0/0/0/0
09-May 15:18	13	243	444	3	21	0/0	0/0/0/0/0/0
09-May 15:08	65	116	238	3	47	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,438	0.00		0
AWR Alerted Metric Element list	15,856	0.00		0
Consistent RBA	893	0.00		0
FOB s.o list latch	870	0.23	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
JS slv state obj latch	6	0.00		0
KCL gc element parent latch	52,618	0.00		118	0.00
KJC message pool free list	3,380	0.03	0.00	1,315	0.00
KJCT flow control latch	23,056	0.00		0
KMG MMAN ready and startup request latch	1,214	0.00		0
KSXR large replies	246	0.00		0
KTF sga latch	6	0.00		1,025	0.00
KWQMN job cache list latch	315	0.00		0
MQL Tracking Latch	0			73	0.00
Memory Management Latch	0			1,214	0.00
OS process	210	0.00		0
OS process allocation	1,346	0.30	0.00	0
OS process: request allocation	116	0.86	0.00	0
PL/SQL warning settings	158	0.00		0
SQL memory manager latch	1	0.00		1,213	0.00
SQL memory manager workarea list latch	126,050	0.00		0
Shared B-Tree	129	0.00		0
active checkpoint queue latch	2,840	0.00		0
active service list	8,176	0.11	0.11	1,862	0.00
begin backup scn array	1	0.00		0
business card	24	0.00		0
cache buffer handles	270	0.00		0
cache buffers chains	758,030	0.03	0.00	55,817	0.00
cache buffers lru chain	25,838	0.00		43,724	0.01
channel handle pool latch	118	0.85	0.00	0
channel operations parent latch	146,108	0.02	0.00	0
checkpoint queue latch	119,309	0.00		1,834	0.00
client/application info	651	0.00		0
commit callback allocation	34	0.00		0
compile environment latch	135	0.00		0
dml lock allocation	7,871	0.00		0
dummy allocation	278	0.72	0.00	0
enqueue hash chains	93,822	0.00		30	0.00
enqueues	79,945	0.01	0.00	0
error message lists	48	0.00		0
event group latch	54	0.00		0
file cache latch	695	0.00		0
gcs opaque info freelist	10,560	0.15	0.00	0
gcs partitioned table hash	104,344	0.00		110	0.00
gcs remastering latch	456	0.00		0
gcs resource freelist	3,470	0.00		3,765	0.00
gcs resource hash	47,009	0.02	0.00	0
gcs shadows freelist	1,591	0.00		7,687	0.00
ges caches resource lists	5,393	0.00		37,487	0.00
ges deadlock list	54	0.00		0
ges domain table	17,968	0.00		0
ges enqueue table freelist	18,844	0.00		0
ges group table	26,353	0.00	0.00	0
ges process hash list	1,829	0.00		0
ges process parent latch	39,045	0.00		0
ges process table freelist	116	2.59	0.00	0
ges resource hash list	28,364	0.05	0.00	1,114	0.00
ges resource scan list	4	0.00		0
ges resource table freelist	870	0.00		0
ges timeout list	588	0.00		837	0.00
global KZLD latch for mem in SGA	50	0.00		0
hash table column usage latch	106	0.00		7,625	0.00
hash table modification latch	62	0.00		0
job workq parent latch	0			4	0.00
job_queue_processes parameter latch	63	0.00		0
kks stats	1,900	0.00		0
kokc descriptor allocation latch	512	0.00		0
ksuosstats global area	245	0.00		0
ktm global data	12	0.00		0
kwqbsn:qsga	129	0.00		0
lgwr LWN SCN	1,520	0.00		0
library cache	60,218	0.02	0.00	101	0.00
library cache load lock	190	0.00		0
library cache lock	31,297	0.16	0.00	0
library cache lock allocation	510	0.39	0.00	0
library cache pin	19,165	0.01	0.00	0
library cache pin allocation	69	1.45	0.00	0
list of block allocation	95	0.00		0
loader state object freelist	6	0.00		0
message pool operations parent latch	1,065	0.00		0
messages	111,907	0.00	0.00	0
mostly latch-free SCN	1,521	0.07	0.00	0
multiblock read objects	8,790	0.01	0.00	0
name-service memory objects	2,298	0.00		0
name-service namespace bucket	37,559	0.00		0
name-service pending queue	1,086	0.00		0
name-service request queue	37,755	0.00		0
ncodef allocation latch	61	0.00		0
object queue header heap	11,474	0.00		22	0.00
object queue header operation	43,518	0.00		0
object stats modification	33	0.00		0
parallel query alloc buffer	1,192	0.00		0
parallel query stats	115	0.00		0
parallel txn reco latch	648	0.00		0
parameter list	455	0.22	0.00	0
parameter table allocation management	281	0.00		0
post/wait queue	702	0.00		472	0.00
process allocation	36,163	0.00		54	0.00
process group creation	116	2.59	0.00	0
process queue	303	0.00		0
process queue reference	5,803	0.00		558	0.00
qmn task queue latch	543	0.00		0
query server freelists	230	0.00		0
queued dump request	18,204	0.00		0
redo allocation	3,935	0.03	0.00	6,014	0.03
redo copy	0			6,015	1.46
redo writing	8,069	0.00		0
resmgr group change latch	193	0.00		0
resmgr:active threads	275	0.00		0
resmgr:actses change group	131	0.00		0
resmgr:free threads list	274	1.46	0.00	0
resmgr:schema config	1	0.00		0
row cache objects	205,504	0.07	0.00	184	0.00
rules engine aggregate statistics	17	0.00		0
rules engine rule set statistics	34	0.00		0
sequence cache	2,795	0.11	0.00	0
session allocation	26,661	0.04	0.09	0
session idle bit	103,262	0.00		0
session state list latch	277	0.72	0.00	0
session switching	61	0.00		0
session timer	1,285	0.00		0
shared pool	50,637	0.13	0.00	0
shared pool sim alloc	75	0.00		0
shared pool simulator	19,968	0.00		0
simulator hash latch	22,883	0.00		0
simulator lru latch	0			21,763	0.05
slave class	2	0.00		0
slave class create	8	12.50	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	363	0.00		0
transaction allocation	87,234	0.00	0.00	0
transaction branch allocation	1,285	0.00		0
undo global data	4,201	0.00		0
user lock	220	6.36	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	26,661	11	1	10
active service list	8,176	9	1	8
slave class create	8	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	8	8
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: 367,384
Captured Segments account for 95.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_OBJAUTH1	INDEX	46,304	12.60
FJFC	FC	T_FC_ZHANGTING	TABLE	40,976	11.15
FJFC	FC	T_FC_OPERATION	TABLE	39,504	10.75
FJFC	FC	T_FC_FIRST_LOGIN_LOGS	TABLE	38,224	10.40
FJFC	FC	T_CMS_NEWS	TABLE	35,808	9.75

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 6,989
Captured Segments account for 98.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
FJFC	FC	T_FC_FIRST_LOGIN_LOGS	TABLE	4,171	59.68
FJFC	FC	INDEX_FIRST_LOGIN_PHONENUMBER	INDEX	589	8.43
FJFC	FC	SYS_C0067038	INDEX	542	7.76
FJFC	FCINDEX	PK_FC_USER	INDEX	531	7.60
FJFC	FCINDEX	IDX_FC_VIEW_NOTES_PHONE_NUMBER	INDEX	271	3.88

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_C0067037		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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 882
Captured Segments account for 95.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
FJFC	FC	INDEX_FIRST_LOGIN_PHONENUMBER	INDEX	259	29.37
FJFC	FC	T_FC_FIRST_LOGIN_LOGS	TABLE	208	23.58
FJFC	FC	T_FC_USER	TABLE	193	21.88
FJFC	FCINDEX	PK_FC_USER	INDEX	68	7.71
FJFC	FC	SYS_C0067038	INDEX	31	3.51

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 4,445
Captured Segments account for 96.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
FJFC	FC	T_FC_FIRST_LOGIN_LOGS	TABLE	2,896	65.15
FJFC	FCINDEX	PK_FC_USER	INDEX	249	5.60
FJFC	FC	SYS_C0067038	INDEX	175	3.94
FJFC	FC	IDX_SYSA_PHONE	INDEX	150	3.37
FJFC	FCINDEX	IDX_FC_VIEW_NOTES_PHONE_NUMBER	INDEX	146	3.28

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	65	0.00	2	1
dc_database_links	102	0.00	0	1
dc_global_oids	338	2.37	0	26
dc_histogram_data	911	9.00	0	1,197
dc_histogram_defs	3,208	3.68	0	3,176
dc_object_ids	7,306	0.73	0	661
dc_objects	1,457	4.32	0	593
dc_profiles	52	0.00	0	1
dc_rollback_segments	1,162	0.00	0	56
dc_segments	3,023	1.12	0	477
dc_sequences	49	51.02	49	10
dc_tablespaces	23,766	0.00	0	11
dc_usernames	358	0.00	0	9
dc_users	26,177	0.00	0	20
outstanding_alerts	157	74.52	17	22

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts
dc_awr_control	4	0
dc_global_oids	8	0
dc_histogram_defs	118	0
dc_object_ids	53	0
dc_objects	63	0
dc_segments	34	1
dc_sequences	98	21
outstanding_alerts	290	109

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	11	27.27	31	9.68	0
CLUSTER	6	0.00	10	0.00	0
INDEX	1	0.00	3	0.00	0
SQL AREA	4,793	38.72	27,261	10.52	0
TABLE/PROCEDURE	366	9.29	6,473	1.42	1

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests	GES Inval Requests
CLUSTER	10	0	0
INDEX	3	0	0
TABLE/PROCEDURE	2,209	45	36

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	133.87		2.31	5.42	22	22	58	58
	Freeable	23.50	0.00	1.12	0.97	5		21	21
	SQL	0.74	0.41	0.02	0.03	0	2	44	38
	PL/SQL	0.31	0.15	0.01	0.01	0	0	56	56
E	Other	127.33		2.55	5.81	22	22	50	50
	Freeable	14.75	0.00	1.23	1.30	5		12	12
	SQL	0.63	0.33	0.02	0.03	0	2	36	25
	PL/SQL	0.20	0.10	0.00	0.01	0	0	48	48

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	3,070,230,528
Fixed Size	2,093,688
Redo Buffers	14,680,064
Variable Size	3,355,446,664

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	2,809.60	2,789.19	-0.73
shared	gcs resources	61.48	61.48	0.00
shared	gcs shadows	36.82	36.82	0.00
shared	sql area		42.03
	buffer_cache	2,928.00	2,928.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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

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	160,995	372,656	397883	397883
gcs_shadows	294,753	375,384	397883	397883

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	1
job_queue_processes	10
local_listener	(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.201)(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	1
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/admin/portal/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	1,026	0.28	0.25
acks for commit broadcast(logical)	1,059	0.29	0.25
broadcast msgs on commit(actual)	893	0.25	0.22
broadcast msgs on commit(logical)	893	0.25	0.22
broadcast msgs on commit(wasted)	2	0.00	0.00
broadcast on commit wait time(ms)	3	0.00	0.00
broadcast on commit waits	6	0.00	0.00
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,748	0.75	0.66
gcs ast xid	1	0.00	0.00
gcs blocked converts	881	0.24	0.21
gcs blocked cr converts	1,124	0.31	0.27
gcs compatible basts	20	0.01	0.00
gcs compatible cr basts (global)	56	0.02	0.01
gcs compatible cr basts (local)	4,408	1.21	1.06
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	230	0.06	0.06
gcs dbwr write request msgs	165	0.05	0.04
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	338	0.09	0.08
gcs immediate (null) converts	843	0.23	0.20
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	6,359	1.75	1.53
gcs indirect ast	1,408	0.39	0.34
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	72	0.02	0.02
gcs msgs process time(ms)	472	0.13	0.11
gcs msgs received	19,856	5.45	4.78
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	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	1,302	0.36	0.31
gcs side channel msgs actual	1,598	0.44	0.38
gcs side channel msgs logical	6,222	1.71	1.50
gcs stale cr	0	0.00	0.00
gcs undo cr	1	0.00	0.00
gcs write notification msgs	15	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	29	0.01	0.01
ges msgs received	2,164	0.59	0.52
global posts dropped	0	0.00	0.00
global posts queue time	932	0.26	0.22
global posts queued	17	0.00	0.00
global posts requested	17	0.00	0.00
global posts sent	17	0.00	0.00
implicit batch messages received	340	0.09	0.08
implicit batch messages sent	278	0.08	0.07
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,425	0.39	0.34
messages queue sent actual	4,976	1.37	1.20
messages queue sent logical	5,306	1.46	1.28
messages received actual	14,218	3.90	3.42
messages received logical	22,020	6.05	5.30
messages sent directly	4,128	1.13	0.99
messages sent indirectly	2,851	0.78	0.69
messages sent not implicit batched	4,698	1.29	1.13
messages sent pbatched	12,691	3.48	3.06
msgs causing lmd to send msgs	850	0.23	0.20
msgs causing lms(s) to send msgs	1,518	0.42	0.37
msgs received queue time (ms)	88	0.02	0.02
msgs received queued	22,021	6.05	5.30
msgs sent queue time (ms)	123	0.03	0.03
msgs sent queue time on ksxp (ms)	2,108	0.58	0.51
msgs sent queued	5,264	1.45	1.27
msgs sent queued on ksxp	13,797	3.79	3.32
process batch messages received	5,346	1.47	1.29
process batch messages sent	5,828	1.60	1.40

Global CR Served Stats

Statistic	Total
CR Block Requests	779
CURRENT Block Requests	34
Data Block Requests	779
Undo Block Requests	1
TX Block Requests	15
Current Results	807
Private results	4
Zero Results	2
Disk Read Results	0
Fail Results	0
Fairness Down Converts	118
Fairness Clears	0
Free GC Elements	0
Flushes	10
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	2
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	5,048	100.00	0.00
Flushes	7	57.14	42.86
Writes	270	95.19	4.81

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
2	data block	853	99.53	0.47	0.00	4,410	99.98	0.02	0.00
2	Others	12	100.00	0.00	0.00	26	100.00	0.00	0.00
2	undo header	16	100.00	0.00	0.00	2	100.00	0.00	0.00

End of Report

% Blocks changed per Read:	2.26	Recursive Call %:	44.14
Rollback per transaction %:	89.33	Rows per Sort:	9.38

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	98.10	In-memory Sort %:	100.00
Library Hit %:	91.23	Soft Parse %:	95.59
Execute to Parse %:	9.86	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	14.01	% Non-Parse CPU:	98.70

Buffer access - local cache %:	96.65
Buffer access - remote cache %:	1.45
Buffer access - disk %:	1.90

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.3
Avg global cache current block receive time (ms):	0.4
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 %:	1.2
Avg global cache cr block flush time (ms):	1.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.1
Avg global cache current block flush time (ms):	0.0

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.2
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:	49.12
% of indirect sent messages:	33.92
% of flow controlled messages:	16.96