WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

HJFXDB 1975059769 hjfxdb 1 10.2.0.1.0 NO hjfxdb3

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
HJFXDB	1975059769	hjfxdb	1	10.2.0.1.0	NO	hjfxdb3

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 24827 05-May-14 00:00:45 23 2.1

End Snap: 24837 05-May-14 10:00:25 29 1.9

Elapsed: 599.66 (mins)

DB Time: 43.85 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	24827	05-May-14 00:00:45	23	2.1
End Snap:	24837	05-May-14 10:00:25	29	1.9
Elapsed:		599.66 (mins)
DB Time:		43.85 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 4,432M 4,400M Std Block Size: 8K

Shared Pool Size: 384M 416M Log Buffer: 14,400K

	Begin	End
Buffer Cache:	4,432M	4,400M	Std Block Size:	8K
Shared Pool Size:	384M	416M	Log Buffer:	14,400K

Load Profile

Per Second Per Transaction

Redo size: 45,619.36 8,045.35

Logical reads: 2,112.65 372.58

Block changes: 79.34 13.99

Physical reads: 286.63 50.55

Physical writes: 74.54 13.15

User calls: 17.01 3.00

Parses: 3.41 0.60

Hard parses: 0.28 0.05

Sorts: 1.09 0.19

Logons: 0.09 0.02

Executes: 11.17 1.97

Transactions: 5.67

	Per Second	Per Transaction
Redo size:	45,619.36	8,045.35
Logical reads:	2,112.65	372.58
Block changes:	79.34	13.99
Physical reads:	286.63	50.55
Physical writes:	74.54	13.15
User calls:	17.01	3.00
Parses:	3.41	0.60
Hard parses:	0.28	0.05
Sorts:	1.09	0.19
Logons:	0.09	0.02
Executes:	11.17	1.97
Transactions:	5.67

% Blocks changed per Read: 3.76 Recursive Call %: 74.17

Rollback per transaction %: 0.12 Rows per Sort: 11.91

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 100.00

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

Library Hit %: 97.07 Soft Parse %: 91.89

Execute to Parse %: 69.49 Latch Hit %: 99.94

Parse CPU to Parse Elapsd %: 32.32 % Non-Parse CPU: 99.29

Shared Pool Statistics

Begin End

Memory Usage %: 88.15 83.04

% SQL with executions>1: 94.66 78.44

% Memory for SQL w/exec>1: 88.13 85.25

	Begin	End
Memory Usage %:	88.15	83.04
% SQL with executions>1:	94.66	78.44
% Memory for SQL w/exec>1:	88.13	85.25

Top 5 Timed Events

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

CPU time 1,957 74.4

db file scattered read 648,379 473 1 18.0 User I/O

log file parallel write 214,230 123 1 4.7 System I/O

log file sync 202,944 114 1 4.3 Commit

SQL*Net more data from client 588,930 86 0 3.3 Network

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		1,957		74.4
db file scattered read	648,379	473	1	18.0	User I/O
log file parallel write	214,230	123	1	4.7	System I/O
log file sync	202,944	114	1	4.3	Commit
SQL*Net more data from client	588,930	86	0	3.3	Network

Main Report

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

Time Model Statistics

Total time in database user-calls (DB Time): 2630.8s
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	2,272.24	86.37
DB CPU	1,956.59	74.37
parse time elapsed	42.58	1.62
hard parse elapsed time	12.20	0.46
PL/SQL execution elapsed time	9.80	0.37
connection management call elapsed time	5.34	0.20
hard parse (sharing criteria) elapsed time	0.69	0.03
PL/SQL compilation elapsed time	0.43	0.02
hard parse (bind mismatch) elapsed time	0.10	0.00
sequence load elapsed time	0.06	0.00
repeated bind elapsed time	0.03	0.00
failed parse elapsed time	0.01	0.00
RMAN cpu time (backup/restore)	0.01	0.00
inbound PL/SQL rpc elapsed time	0.00	0.00
DB time	2,630.80
background elapsed time	261.35
background cpu time	56.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	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	683,896	574	1	3.35
System I/O	286,222	165	1	1.40
Commit	202,944	114	1	0.99
Network	1,211,753	92	0	5.94
Concurrency	845	24	29	0.00
Other	6,209	4	1	0.03
Application	28,950	2	0	0.14
Configuration	2	0	23	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
db file scattered read	648,379	0.00	473	1	3.18
log file parallel write	214,230	0.00	123	1	1.05
log file sync	202,944	0.00	114	1	0.99
SQL*Net more data from client	588,930	0.00	86	0	2.89
db file sequential read	19,763	0.00	58	3	0.10
read by other session	12,787	0.00	42	3	0.06
os thread startup	553	0.00	23	41	0.00
log file sequential read	2,043	0.00	16	8	0.01
control file parallel write	13,971	0.00	11	1	0.07
db file parallel write	16,343	0.00	8	1	0.08
SQL*Net more data to client	33,625	0.00	5	0	0.16
control file sequential read	37,187	0.00	5	0	0.18
rdbms ipc reply	4,875	0.00	4	1	0.02
Log archive I/O	2,446	0.00	2	1	0.01
latch: shared pool	109	0.00	1	12	0.00
enq: RO - fast object reuse	530	0.00	1	2	0.00
local write wait	1,223	0.00	1	1	0.01
SQL*Net break/reset to client	28,420	0.00	0	0	0.14
SQL*Net message to client	586,221	0.00	0	0	2.87
latch free	49	0.00	0	5	0.00
SQL*Net more data from dblink	2,925	0.00	0	0	0.01
log file switch completion	1	0.00	0	46	0.00
LGWR wait for redo copy	976	0.00	0	0	0.00
reliable message	306	0.00	0	0	0.00
latch: cache buffers chains	163	0.00	0	0	0.00
latch: library cache	14	0.00	0	1	0.00
direct path read	1	0.00	0	7	0.00
log file single write	2	0.00	0	2	0.00
buffer busy waits	6	0.00	0	0	0.00
direct path write	1,743	0.00	0	0	0.01
latch: cache buffers lru chain	2	0.00	0	0	0.00
SQL*Net message to dblink	52	0.00	0	0	0.00
latch: object queue header operation	1	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
Streams AQ: qmn slave idle wait	1,287	0.00	35,035	27223	0.01
Streams AQ: qmn coordinator idle wait	2,651	49.04	35,035	13216	0.01
virtual circuit status	1,199	100.00	35,003	29193	0.01
jobq slave wait	11,140	99.61	32,579	2925	0.05
SQL*Net message from client	586,216	0.00	15,141	26	2.87
Streams AQ: waiting for time management or cleanup tasks	8	100.00	11,257	1407122	0.00
class slave wait	16	100.00	78	4883	0.00
SQL*Net message from dblink	52	0.00	0	2	0.00
single-task message	2	0.00	0	59	0.00
SGA: MMAN sleep for component shrink	2	0.00	0	4	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
log file parallel write	214,236	0.00	123	1	1.05
db file scattered read	4,492	0.00	23	5	0.02
os thread startup	553	0.00	23	41	0.00
log file sequential read	2,043	0.00	16	8	0.01
control file parallel write	12,259	0.00	10	1	0.06
db file parallel write	16,343	0.00	8	1	0.08
control file sequential read	10,659	0.00	2	0	0.05
db file sequential read	665	0.00	2	3	0.00
Log archive I/O	2,446	0.00	2	1	0.01
events in waitclass Other	1,002	0.00	0	0	0.00
latch: shared pool	1	0.00	0	4	0.00
log file single write	2	0.00	0	2	0.00
latch: library cache	5	0.00	0	0	0.00
buffer busy waits	3	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
rdbms ipc message	343,523	33.70	377,441	1099	1.68
pmon timer	12,278	100.00	35,124	2861	0.06
Streams AQ: qmn slave idle wait	1,287	0.00	35,035	27223	0.01
Streams AQ: qmn coordinator idle wait	2,651	49.04	35,035	13216	0.01
smon timer	765	13.46	33,981	44420	0.00
Streams AQ: waiting for time management or cleanup tasks	8	100.00	11,257	1407122	0.00
SGA: MMAN sleep for component shrink	2	0.00	0	4	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	396,929
AVG_IDLE_TIME	3,211,293
AVG_IOWAIT_TIME	45,405
AVG_SYS_TIME	199,987
AVG_USER_TIME	196,115
BUSY_TIME	1,591,293
IDLE_TIME	12,848,807
IOWAIT_TIME	185,303
SYS_TIME	803,710
USER_TIME	787,583
LOAD	0
OS_CPU_WAIT_TIME	3,512,500
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	17,179,869,184
NUM_CPUS	4
NUM_CPU_CORES	2

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	2,630.60	1,956.40	10,253,878	74,420,587
SYS$BACKGROUND	0.00	0.00	58,996	1,584,446
hjfxdb	0.00	0.00	0	0
hjfxdbXDB	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
SYS$USERS	678417	54834	275	14	1208700	9189
SYS$BACKGROUND	5479	2598	565	2281	0	0
hjfxdb	0	0	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
271	216	1	270.77	10.29	6x84a4w4afrq0	SQL*Plus	delete from TI_CRM_USER_ITE...
124	47	1	123.87	4.71	ct91xzzquzxrb	SQL*Plus	INSERT INTO TI_CONTRACT_USER N...
62	27	1	62.01	2.36	1g3ybkzrp5uxf	SQL*Plus	select count(*) from TI_BIL_GS...
49	48	166,864	0.00	1.84	0d39nynkjb60r	SQL Loader Conventional Path Load	INSERT INTO TI_CRM_USER_INFOCH...
48	7	1	48.18	1.83	dgwcyapy6hba6	SQL*Plus	select max(t.execute_id) from ...
41	2	20	2.06	1.57	dzffdpu58dqgv	SQL*Plus	SELECT A.TABLESPACE_NAME\|\|'\|'\|...
37	20	2	18.57	1.41	81qnwktdc1g9h	oraclehjfxdb@hjfxdb2 (TNS V1-V3)	SELECT "A1"."TASK_ID", MAX(DEC...
32	1	20	1.58	1.20	6v946t788a28t	SQL*Plus	SELECT A.TABLESPACE_NAME "tabl...
24	5	1	24.19	0.92	chndvcf5uj6vp	SQL*Plus	select count(*) from TI_BIL_PS...
23	13	1	22.90	0.87	728wb6r60qcks	SQL*Plus	update TI_INTERFACE_PERIOD_STA...

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
216	271	1	216.23	10.29	6x84a4w4afrq0	SQL*Plus	delete from TI_CRM_USER_ITE...
48	49	166,864	0.00	1.84	0d39nynkjb60r	SQL Loader Conventional Path Load	INSERT INTO TI_CRM_USER_INFOCH...
47	124	1	46.83	4.71	ct91xzzquzxrb	SQL*Plus	INSERT INTO TI_CONTRACT_USER N...
27	62	1	26.55	2.36	1g3ybkzrp5uxf	SQL*Plus	select count(*) from TI_BIL_GS...
20	37	2	10.11	1.41	81qnwktdc1g9h	oraclehjfxdb@hjfxdb2 (TNS V1-V3)	SELECT "A1"."TASK_ID", MAX(DEC...
15	22	1	15.00	0.82	4p3qpz9kmy8zh	SQL*Plus	update TI_INTERFACE_PERIOD_STA...
14	21	1	14.36	0.81	0r3udzupy52v2	SQL*Plus	update TI_INTERFACE_PERIOD_STA...
14	14	1	14.04	0.55	5rh991nnr5d79	SQL*Plus	update TI_INTERFACE_PERIOD_STA...
14	14	1	13.76	0.53	cb0dwkwdy0mfp	SQL*Plus	update TI_INTERFACE_PERIOD_STA...
14	14	1	13.71	0.53	fhx9dpv7b55wa	SQL*Plus	update TI_INTERFACE_PERIOD_STA...
7	48	1	7.11	1.83	dgwcyapy6hba6	SQL*Plus	select max(t.execute_id) from ...
2	41	20	0.09	1.57	dzffdpu58dqgv	SQL*Plus	SELECT A.TABLESPACE_NAME\|\|'\|'\|...
1	32	20	0.07	1.20	6v946t788a28t	SQL*Plus	SELECT A.TABLESPACE_NAME "tabl...

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: 76,011,688
Captured SQL account for 46.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
4,722,704	1	4,722,704.00	6.21	216.23	270.77	6x84a4w4afrq0	SQL*Plus	delete from TI_CRM_USER_ITE...
2,030,471	166,864	12.17	2.67	48.45	48.53	0d39nynkjb60r	SQL Loader Conventional Path Load	INSERT INTO TI_CRM_USER_INFOCH...
1,331,323	1	1,331,323.00	1.75	26.55	62.01	1g3ybkzrp5uxf	SQL*Plus	select count(*) from TI_BIL_GS...
1,318,361	2	659,180.50	1.73	20.21	37.14	81qnwktdc1g9h	oraclehjfxdb@hjfxdb2 (TNS V1-V3)	SELECT "A1"."TASK_ID", MAX(DEC...
1,230,679	1	1,230,679.00	1.62	46.83	123.87	ct91xzzquzxrb	SQL*Plus	INSERT INTO TI_CONTRACT_USER N...
396,735	1	396,735.00	0.52	7.11	18.57	gd68yfsj25hzj	SQL*Plus	select count(*) from TI_BIL_GS...
350,586	1	350,586.00	0.46	5.46	24.19	chndvcf5uj6vp	SQL*Plus	select count(*) from TI_BIL_PS...
256,424	1	256,424.00	0.34	5.46	14.39	2h53pkhv56rhb	SQL*Plus	select count(*) from TI_SETTLE...
231,675	1	231,675.00	0.30	10.34	16.19	cq78w8j9119dy	SQL*Plus	delete from TI_CRM_RELATION...
216,228	26	8,316.46	0.28	0.13	0.54	g337099aatnuj		update smon_scn_time set orig_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 10,312,875
Captured SQL account for 93.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
4,721,921	1	4,721,921.00	45.79	216.23	270.77	6x84a4w4afrq0	SQL*Plus	delete from TI_CRM_USER_ITE...
1,331,179	1	1,331,179.00	12.91	26.55	62.01	1g3ybkzrp5uxf	SQL*Plus	select count(*) from TI_BIL_GS...
1,230,314	1	1,230,314.00	11.93	46.83	123.87	ct91xzzquzxrb	SQL*Plus	INSERT INTO TI_CONTRACT_USER N...
396,650	1	396,650.00	3.85	7.11	18.57	gd68yfsj25hzj	SQL*Plus	select count(*) from TI_BIL_GS...
350,482	1	350,482.00	3.40	5.46	24.19	chndvcf5uj6vp	SQL*Plus	select count(*) from TI_BIL_PS...
256,329	1	256,329.00	2.49	5.46	14.39	2h53pkhv56rhb	SQL*Plus	select count(*) from TI_SETTLE...
231,624	1	231,624.00	2.25	10.34	16.19	cq78w8j9119dy	SQL*Plus	delete from TI_CRM_RELATION...
107,933	1	107,933.00	1.05	2.69	7.26	7kh1drk2nykyp	SQL*Plus	select max(t.execute_id) from ...
107,910	1	107,910.00	1.05	3.78	14.36	czjf28cur2c9w	SQL*Plus	update hjfx.TI_INTERFACE_PERIO...
107,832	1	107,832.00	1.05	15.00	21.69	4p3qpz9kmy8zh	SQL*Plus	update TI_INTERFACE_PERIOD_STA...
107,781	1	107,781.00	1.05	14.36	21.43	0r3udzupy52v2	SQL*Plus	update TI_INTERFACE_PERIOD_STA...
107,741	1	107,741.00	1.04	3.17	12.88	508kygghqd02m	PL/SQL Developer	select dd.task_id, dec...
107,741	1	107,741.00	1.04	13.41	22.90	728wb6r60qcks	SQL*Plus	update TI_INTERFACE_PERIOD_STA...
107,717	2	53,858.50	1.04	20.21	37.14	81qnwktdc1g9h	oraclehjfxdb@hjfxdb2 (TNS V1-V3)	SELECT "A1"."TASK_ID", MAX(DEC...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 401,887
Captured SQL account for 66.2% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
166,864	10,650,282	63.83	0d39nynkjb60r	SQL Loader Conventional Path Load	INSERT INTO TI_CRM_USER_INFOCH...
15,566	15,317	0.98	2ym6hhaq30r73		select type#, blocks, extents,...
11,459	11,459	1.00	9qgtwh66xg6nz		update seg$ set type#=:4, bloc...
7,982	136,645	17.12	bsa0wjtftg3uw		select file# from file$ where ...
6,168	393,193	63.75	34jhmhh1bzfrw	SQL Loader Conventional Path Load	INSERT INTO ODS_114_CUST_CALLN...
5,954	58,946	9.90	0h6b2sajwb74n		select privilege#, level from ...
2,885	222	0.08	803b7z0t84sq7		select job, nvl2(last_date, ...
2,672	5,954	2.23	0k8522rmdzg4k		select privilege# from sysauth...
2,500	2,500	1.00	1cjy8v3c0agny		select sys_nc_oid$ from xdb.xd...
2,152	2,152	1.00	5ur69atw3vfhj		select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 122,604
Captured SQL account for 70.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
15,584	15,566	12.71	2ym6hhaq30r73		select type#, blocks, extents,...
11,459	11,459	9.35	9qgtwh66xg6nz		update seg$ set type#=:4, bloc...
7,982	7,982	6.51	bsa0wjtftg3uw		select file# from file$ where ...
5,954	5,954	4.86	0h6b2sajwb74n		select privilege#, level from ...
2,672	2,672	2.18	0k8522rmdzg4k		select privilege# from sysauth...
2,500	2,500	2.04	1cjy8v3c0agny		select sys_nc_oid$ from xdb.xd...
2,152	2,152	1.76	5ur69atw3vfhj		select decode(failover_method,...
2,136	2,136	1.74	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2,126	2,126	1.73	ca7fk0wugft6v	sqlplus@hjfxdb3 (TNS V1-V3)	ALTER SESSION SET NLS_LANGUAGE...
2,120	2,120	1.73	459f3z9u4fb3u		select value$ from props$ wher...
1,776	1,776	1.45	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
1,776	1,776	1.45	g00cj285jmgsw		update sys.mon_mods$ set inser...

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

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
78	80	4gb7r5dm6hnzs		SELECT CONF#, NAME, VALUE FR...
56	471	fy9ta5zgkwqmp	SQL*Plus	SELECT count(*) FROM user_poli...
56	471	fy9ta5zgkwqmp	SQL*Plus	SELECT count(*) FROM user_poli...
54	471	bdv0rkkssq2jm	SQL*Plus	SELECT count(*) FROM user_poli...
54	471	bdv0rkkssq2jm	SQL*Plus	SELECT count(*) FROM user_poli...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0d39nynkjb60r INSERT INTO TI_CRM_USER_INFOCHANGE (PARTITION_ID, USER_ID, PRODUCT_ID, BRAND_CODE, SERIAL_NUMBER, IMSI, IMSI2, START_DATE, END_DATE, DATE_FLAG) VALUES (:PARTITION_ID, :USER_ID, :PRODUCT_ID, :BRAND_CODE, :SERIAL_NUMBER, :IMSI, :IMSI2, :START_DATE, :END_DATE, nvl(:"DATE_FLAG", '20140504'))

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

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

0r3udzupy52v2 update TI_INTERFACE_PERIOD_STATUS set check_import_status='1001', check_import_date='20140505 07:41:57' where data_file_name like '%TTGW%20140504%.Z9C' and execute_id='1'

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

1cjy8v3c0agny select sys_nc_oid$ from xdb.xdb$resource where rowid = :1

1g3ybkzrp5uxf select count(*) from TI_BIL_GSM_CALL_20140504

2h53pkhv56rhb select count(*) from TI_SETTLE_GSM_CALL_20140504

2ym6hhaq30r73 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

34jhmhh1bzfrw INSERT INTO ODS_114_CUST_CALLNUM_20140504 (CALLID, CALLNUM, WAITBEGIN, WAITEND, CALLBEGIN, CALLEND, CALLERNO, CALLEENO, SUBCCNO, DEVICETYPE, STAFFNO, SERVICNAME, PREDEVICETYPE) VALUES (:CALLID, :CALLNUM, :WAITBEGIN, :WAITEND, :CALLBEGIN, :CALLEND, :CALLERNO, :CALLEENO, :SUBCCNO, :DEVICETYPE, :STAFFNO, :SERVICNAME, :PREDEVICETYPE)

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

4gb7r5dm6hnzs SELECT CONF#, NAME, VALUE FROM V$RMAN_CONFIGURATION RM WHERE ((:B2 IS NULL OR UPPER(:B2 ) = UPPER(RM.NAME)) AND (:B1 IS NULL OR UPPER(:B1 ) = UPPER(RM.VALUE)))

4p3qpz9kmy8zh update TI_INTERFACE_PERIOD_STATUS set check_import_status='1001', check_import_date='20140505 07:14:04' where data_file_name like '%TTYD%20140504%.Z9C' and execute_id='1'

508kygghqd02m select dd.task_id, decode(dd.a1, 'ftp_down_status', dd.b1, null) ftp_down_status, decode(dd.a2, 'ftp_check_status', dd.b2, null) ftp_check_status, decode(dd.a3, 'create_log_status', dd.b3, null) create_log_status, decode(dd.a4, 'interface_check_status', dd.b4, null) interface_check_status, decode(dd.a5, 'mk_ctl_status', dd.b5, null) mk_ctl_status, decode(dd.a6, 'import_status', dd.b6, null) import_status, decode(dd.a7, 'check_import_status', dd.b7, null) check_import_status, decode(dd.a8, 'interface_gzip_status', dd.b8, null) interface_gzip_status, decode(dd.a9, 'interface_compress_status', dd.b9, null) interface_compress_status, dd.task_date from (select t.task_id, 'ftp_down_status' a1, max(t.ftp_down_status) b1, 'ftp_check_status' a2, max(t.ftp_check_status) b2, 'create_log_status' a3, max(t.create_log_status) b3, 'interface_check_status' a4, max(t.interface_check_status) b4, 'mk_ctl_status' a5, max(t.mk_ctl_status) b5, 'import_status' a6, max(t.import_status) b6, 'check_import_status' a7, max(t.check_import_status) b7, 'interface_gzip_status' a8, max(t.interface_gzip_status) b8, 'interface_compress_ status' a9, max(t.interface_compress_status) b9, t.task_date from ti_interface_period_status t where t.task_date > '20140101' and t.task_id = '1022' group by t.task_date, t.task_id) dd/*, interface_period_description ee where dd.ftp_down_status = ee.error_id or dd.ftp_check_status = ee.error_id or dd.create_log_status = ee.error_id or dd.interface_check_status = ee.error_id or dd.mk_ctl_status = ee.error_id or dd.import_status = ee.error_id or dd.import_check_status = ee.error_id or dd.interface_gzip_status = ee.error_id or dd.interface_compress_status = ee.error_id*/ order by dd.task_date

5rh991nnr5d79 update TI_INTERFACE_PERIOD_STATUS set interface_compress_status='1001', interface_compress_date='20140505 07:26:09' where data_file_name like'%TTYD%20140504%.Z9C' and execute_id='1'

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

6v946t788a28t SELECT A.TABLESPACE_NAME "tablespace", nvl(ROUND(B.BYTES / 1024 / 1024 / 1024, 2), '0') "size" FROM (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) A, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME ) B WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME(+) AND a.TABLESPACE_NAME='TS_CDR' ORDER BY ((A.BYTES - B.BYTES) / A.BYTES) DESC

6x84a4w4afrq0 delete from TI_CRM_USER_ITEM where date_flag=20140504

728wb6r60qcks update TI_INTERFACE_PERIOD_STATUS set check_import_status='1001', check_import_date='20140505 07:52:10' where data_file_name like '%SMYD%20140504%.Z9C' and execute_id='1'

7kh1drk2nykyp select max(t.execute_id) from hjfx.TI_INTERFACE_PERIOD_STATUS t where t.task_id='1033' and t.data_file_name like '%chenggong%20140505%.txt%'

803b7z0t84sq7 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

81qnwktdc1g9h SELECT "A1"."TASK_ID", MAX(DECODE("A1"."FTP_DOWN_STATUS", '1001', NULL, '1000', NULL, "A1"."FTP_DOWN_STATUS")), MAX(DECODE("A1"."FTP_CHECK_STATUS", '1001', NULL, '1000', NULL, "A1"."FTP_CHECK_STATUS")), MAX(DECODE("A1"."CREATE_LOG_STATUS", '1001', NULL, '1000', NULL, "A1"."CREATE_LOG_STATUS")), MAX(DECODE("A1"."INTERFACE_CHECK_STATUS", '1001', NULL, '1000', NULL, "A1"."INTERFACE_CHECK_STATUS")), MAX(DECODE("A1"."MK_CTL_STATUS", '1001', NULL, '1000', NULL, "A1"."MK_CTL_STATUS")), MAX(DECODE("A1"."IMPORT_STATUS", '1001', NULL, '1000', NULL, "A1"."IMPORT_STATUS")), MAX(DECODE("A1"."CHECK_IMPORT_STATUS", '1001', NULL, '1000', NULL, "A1"."CHECK_IMPORT_STATUS")), MAX(DECODE("A1"."INTERFACE_GZIP_STATUS", '1001', NULL, '1000', NULL, "A1"."INTERFACE_GZIP_STATUS")), MAX(DECODE("A1"."INTERFACE_COMPRESS_STATUS", '1001', NULL, '1000', NULL, "A1"."INTERFACE_COMPRESS_STATUS")), "A1"."TASK_DATE", "A1"."EXECUTE_ID", "A1"."INTERFACE_SOURCE" FROM "TI_INTERFACE_PERIOD_STATUS" "A1" WHERE ("A1"."FTP_DOWN_STATUS">'1001' OR "A1"."FTP_CHECK_STATUS">'1001' OR "A1"."CREATE_LOG_STATUS">'1001' OR "A1"."INTERFACE_CHECK_STATUS">'1001' OR "A1"."MK_CTL_STATUS">'1001' OR "A1"."IMPORT_STATUS">'1001' OR "A1"."CHECK_IMPORT_STATUS">'1001' OR "A1"."INTERFACE_GZIP_STATUS">'1001' OR "A1"."INTERFACE_COMPRESS_STATUS">'1001') AND ("A1"."TASK_DATE"=:1 AND "A1"."INTERFACE_SOURCE"<>'hospital_register' AND NOT EXISTS (SELECT 0 FROM "TI_INTERFACE_PERIOD_STATUS" "A4" WHERE "A4"."TASK_DATE"=: 2 AND "A4"."INTERFACE_SOURCE"<>'hospital_register' AND "A4"."TASK_ID"<>'1007' AND "A4"."TASK_ID"<>'1008' AND "A4"."FTP_DOWN_STATUS"<'1002' AND "A4"."FTP_CHECK_STATUS"<'1002' AND "A4"."CREATE_LOG_STATUS"<'1002' AND "A4"."INTERFACE_CHECK_STATUS"<'1002' AND "A4"."MK_CTL_STATUS"<'1002' AND "A4"."IMPORT_STATUS"<'1002' AND "A4"."CHECK_IMPORT_STATUS"<'1002' AND "A4"."INTERFACE_GZIP_STATUS"<'1002' AND "A4"."INTERFACE_COMPRESS_STATUS"<'1002' GROUP BY "A4"."TASK_ID" HAVING LNNVL("A4"."TASK_ID"<>"A1"."TASK_ID")) OR "A1"."TASK_DATE"=:3 AND "A1"."INTERFACE_SOURCE"='hospital_register' AND NOT EXISTS (SELECT 0 FROM "TI_INTERFACE_PERIOD_STATUS" "A3" WHERE "A3"."TASK_DATE"=:4 AND "A3"."INTERFACE_SOURCE"='hospital_register' AND "A3"."FTP_DOWN_STATUS"<'1002' AND "A3"."FTP_CHECK_STATUS"<'1002' AND "A3"."CREATE_LOG_STATUS"<'1002' AND "A3"."INTERFACE_CHECK_STATUS"<'1002' AND "A3"."MK_CTL_STATUS"<'1002' AND "A3"."IMPORT_STATUS"<'1002' AND "A3"."CHECK_IMPORT_STATUS"<'1002' AND "A3"."INTERFACE_GZIP_STATUS"<'1002' AND "A3"."INTERFACE_COMPRESS_STATUS"<'1002' GROUP BY "A3"."TASK_ID" HAVING LNNVL("A3"."TASK_ID"<>"A1"."TASK_ID")) OR "A1"."TASK_DATE"=:5 AND ("A1"."TASK_ID"='1007' OR "A1"."TASK_ID"='1008') AND NOT EXISTS (SELECT 0 FROM "TI_INTERFACE_PERIOD_STATUS" "A2" WHERE "A2"."TASK_DATE"=:6 AND ("A2"."TASK_ID"='1007' OR "A2"."TASK_ID"='1008') AND "A2"."FTP_DOWN_STATUS"<'1002' AND "A2"."FTP_CHECK_STATUS"<'1002' AN D "A2"."CREATE_LOG_STATUS"<'1002' AND "A2"."INTERFACE_CHECK_STATUS"<'1002' AND "A2"."MK_CTL_STATUS"<'1002' AND "A2"."IMPORT_STATUS"<'1002' AND "A2"."CHECK_IMPORT_STATUS"<'1002' AND "A2"."INTERFACE_GZIP_STATUS"<'1002' AND "A2"."INTERFACE_COMPRESS_STATUS"<'1002' GROUP BY "A2"."TASK_ID" HAVING LNNVL("A2"."TASK_ID"<>"A1"."TASK_ID"))) GROUP BY "A1"."TASK_ID", "A1"."TASK_DATE", "A1"."EXECUTE_ID", "A1"."INTERFACE_SOURCE"

9qgtwh66xg6nz update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3

bdv0rkkssq2jm SELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPF'

bsa0wjtftg3uw select file# from file$ where ts#=:1

ca7fk0wugft6v ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '., ' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' TIME_ZONE= '+08:00' NLS_COMP= 'BINARY' NLS_DUAL_CURRENCY= '$' NLS_TIME_FORMAT= 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT= 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM TZR'

cb0dwkwdy0mfp update TI_INTERFACE_PERIOD_STATUS set import_status='1001', import_date='20140505 07:41:34' where data_file_name like '%TTGW%20140504%.Z9C' and execute_id='1'

chndvcf5uj6vp select count(*) from TI_BIL_PSTN_CALL_20140504

cq78w8j9119dy delete from TI_CRM_RELATION_UU_ITEM where date_flag=20140504

ct91xzzquzxrb INSERT INTO TI_CONTRACT_USER NOLOGGING SELECT SERIAL_NUMBER, PRODUCT_NAME, SYSDATE INSERT_DATE FROM (SELECT SERIAL_NUMBER, PRODUCT_NAME, OPEN_DATE, ROW_NUMBER() OVER(PARTITION BY SERIAL_NUMBER ORDER BY OPEN_DATE DESC) RN FROM (SELECT A.SERIAL_NUMBER, C.PRODUCT_NAME, A.OPEN_DATE FROM TI_CRM_USER A, Ti_Crm_User_Product B, GR_DIM.DIM_ACRM_PRODUCT_ID@TO_HJFX81_CAL C WHERE A.USER_ID = B.USER_ID AND A.PRODUCT_ID = C.PRODUCT_ID AND A.NET_TYPE_CODE IN ('10', '16', '17', '33') AND A.REMOVE_TAG IN ('0', '1', '3') AND B.PRODUCT_MODE = '50' AND SUBSTR(A.SERIAL_NUMBER, 1, 3) <> '145' AND SUBSTR(B.START_DATE, 1, 8) = TO_CHAR(SYSDATE-1, 'yyyymmdd'))) WHERE RN = 1

czjf28cur2c9w update hjfx.TI_INTERFACE_PERIOD_STATUS set check_import_status='1001', check_import_date='20140505 06:35:28' where data_file_name like 'A0500120140504%.AVL' and execute_id='1'

dgwcyapy6hba6 select max(t.execute_id) from TI_INTERFACE_PERIOD_STATUS t where t.task_id='1022' and t.data_file_name like '%TTYD%20140504%.Z9C%'

dzffdpu58dqgv SELECT A.TABLESPACE_NAME||'|'|| decode(substr(ROUND(A.BYTES / 1024 / 1024 / 1024, 2), 1, 1), '.', '0'||ROUND(A.BYTES / 1024 / 1024 / 1024, 2), ROUND(A.BYTES / 1024 / 1024 / 1024, 2))||'|'|| decode(substr(ROUND((A.BYTES - B.BYTES) / 1024 / 1024 / 1024, 2), 1, 1), '.', '0'||ROUND((A.BYTES - B.BYTES) / 1024 / 1024 / 1024, 2), ROUND((A.BYTES - B.BYTES) / 1024 / 1024 / 1024, 2))||'|'|| decode(substr(ROUND(B.BYTES / 1024 / 1024 / 1024, 2), 1, 1), '.', '0'||ROUND(B.BYTES / 1024 / 1024 / 1024, 2), ROUND(B.BYTES / 1024 / 1024 / 1024, 2))||'|'|| decode(substr(ROUND(((A.BYTES - B.BYTES) / A.BYTES) * 100, 2), 1, 1), '.', '0'||ROUND(((A.BYTES - B.BYTES) / A.BYTES) * 100, 2), ROUND(((A.BYTES - B.BYTES) / A.BYTES) * 100, 2)) FROM (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) A, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES, MAX(BYTES) LARGEST FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) B WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME ORDER BY ((A.BYTES - B.BYTES) / A.BYTES) DESC

fhx9dpv7b55wa update TI_INTERFACE_PERIOD_STATUS set import_status='1001', import_date='20140505 08:03:58' where data_file_name like '%CMYD%20140504%.zjc' and execute_id='1'

fy9ta5zgkwqmp SELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPROPF'

g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

g337099aatnuj update smon_scn_time set orig_thread=0, time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)

gd68yfsj25hzj select count(*) from TI_BIL_GSM_SMS_20140504

SQL Id	SQL Text
0d39nynkjb60r	INSERT INTO TI_CRM_USER_INFOCHANGE (PARTITION_ID, USER_ID, PRODUCT_ID, BRAND_CODE, SERIAL_NUMBER, IMSI, IMSI2, START_DATE, END_DATE, DATE_FLAG) VALUES (:PARTITION_ID, :USER_ID, :PRODUCT_ID, :BRAND_CODE, :SERIAL_NUMBER, :IMSI, :IMSI2, :START_DATE, :END_DATE, nvl(:"DATE_FLAG", '20140504'))
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0r3udzupy52v2	update TI_INTERFACE_PERIOD_STATUS set check_import_status='1001', check_import_date='20140505 07:41:57' where data_file_name like '%TTGW%20140504%.Z9C' and execute_id='1'
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1cjy8v3c0agny	select sys_nc_oid$ from xdb.xdb$resource where rowid = :1
1g3ybkzrp5uxf	select count(*) from TI_BIL_GSM_CALL_20140504
2h53pkhv56rhb	select count(*) from TI_SETTLE_GSM_CALL_20140504
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
34jhmhh1bzfrw	INSERT INTO ODS_114_CUST_CALLNUM_20140504 (CALLID, CALLNUM, WAITBEGIN, WAITEND, CALLBEGIN, CALLEND, CALLERNO, CALLEENO, SUBCCNO, DEVICETYPE, STAFFNO, SERVICNAME, PREDEVICETYPE) VALUES (:CALLID, :CALLNUM, :WAITBEGIN, :WAITEND, :CALLBEGIN, :CALLEND, :CALLERNO, :CALLEENO, :SUBCCNO, :DEVICETYPE, :STAFFNO, :SERVICNAME, :PREDEVICETYPE)
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4gb7r5dm6hnzs	SELECT CONF#, NAME, VALUE FROM V$RMAN_CONFIGURATION RM WHERE ((:B2 IS NULL OR UPPER(:B2 ) = UPPER(RM.NAME)) AND (:B1 IS NULL OR UPPER(:B1 ) = UPPER(RM.VALUE)))
4p3qpz9kmy8zh	update TI_INTERFACE_PERIOD_STATUS set check_import_status='1001', check_import_date='20140505 07:14:04' where data_file_name like '%TTYD%20140504%.Z9C' and execute_id='1'
508kygghqd02m	select dd.task_id, decode(dd.a1, 'ftp_down_status', dd.b1, null) ftp_down_status, decode(dd.a2, 'ftp_check_status', dd.b2, null) ftp_check_status, decode(dd.a3, 'create_log_status', dd.b3, null) create_log_status, decode(dd.a4, 'interface_check_status', dd.b4, null) interface_check_status, decode(dd.a5, 'mk_ctl_status', dd.b5, null) mk_ctl_status, decode(dd.a6, 'import_status', dd.b6, null) import_status, decode(dd.a7, 'check_import_status', dd.b7, null) check_import_status, decode(dd.a8, 'interface_gzip_status', dd.b8, null) interface_gzip_status, decode(dd.a9, 'interface_compress_status', dd.b9, null) interface_compress_status, dd.task_date from (select t.task_id, 'ftp_down_status' a1, max(t.ftp_down_status) b1, 'ftp_check_status' a2, max(t.ftp_check_status) b2, 'create_log_status' a3, max(t.create_log_status) b3, 'interface_check_status' a4, max(t.interface_check_status) b4, 'mk_ctl_status' a5, max(t.mk_ctl_status) b5, 'import_status' a6, max(t.import_status) b6, 'check_import_status' a7, max(t.check_import_status) b7, 'interface_gzip_status' a8, max(t.interface_gzip_status) b8, 'interface_compress_ status' a9, max(t.interface_compress_status) b9, t.task_date from ti_interface_period_status t where t.task_date > '20140101' and t.task_id = '1022' group by t.task_date, t.task_id) dd/, interface_period_description ee where dd.ftp_down_status = ee.error_id or dd.ftp_check_status = ee.error_id or dd.create_log_status = ee.error_id or dd.interface_check_status = ee.error_id or dd.mk_ctl_status = ee.error_id or dd.import_status = ee.error_id or dd.import_check_status = ee.error_id or dd.interface_gzip_status = ee.error_id or dd.interface_compress_status = ee.error_id/ order by dd.task_date
5rh991nnr5d79	update TI_INTERFACE_PERIOD_STATUS set interface_compress_status='1001', interface_compress_date='20140505 07:26:09' where data_file_name like'%TTYD%20140504%.Z9C' and execute_id='1'
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6v946t788a28t	SELECT A.TABLESPACE_NAME "tablespace", nvl(ROUND(B.BYTES / 1024 / 1024 / 1024, 2), '0') "size" FROM (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) A, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME ) B WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME(+) AND a.TABLESPACE_NAME='TS_CDR' ORDER BY ((A.BYTES - B.BYTES) / A.BYTES) DESC
6x84a4w4afrq0	delete from TI_CRM_USER_ITEM where date_flag=20140504
728wb6r60qcks	update TI_INTERFACE_PERIOD_STATUS set check_import_status='1001', check_import_date='20140505 07:52:10' where data_file_name like '%SMYD%20140504%.Z9C' and execute_id='1'
7kh1drk2nykyp	select max(t.execute_id) from hjfx.TI_INTERFACE_PERIOD_STATUS t where t.task_id='1033' and t.data_file_name like '%chenggong%20140505%.txt%'
803b7z0t84sq7	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
81qnwktdc1g9h	SELECT "A1"."TASK_ID", MAX(DECODE("A1"."FTP_DOWN_STATUS", '1001', NULL, '1000', NULL, "A1"."FTP_DOWN_STATUS")), MAX(DECODE("A1"."FTP_CHECK_STATUS", '1001', NULL, '1000', NULL, "A1"."FTP_CHECK_STATUS")), MAX(DECODE("A1"."CREATE_LOG_STATUS", '1001', NULL, '1000', NULL, "A1"."CREATE_LOG_STATUS")), MAX(DECODE("A1"."INTERFACE_CHECK_STATUS", '1001', NULL, '1000', NULL, "A1"."INTERFACE_CHECK_STATUS")), MAX(DECODE("A1"."MK_CTL_STATUS", '1001', NULL, '1000', NULL, "A1"."MK_CTL_STATUS")), MAX(DECODE("A1"."IMPORT_STATUS", '1001', NULL, '1000', NULL, "A1"."IMPORT_STATUS")), MAX(DECODE("A1"."CHECK_IMPORT_STATUS", '1001', NULL, '1000', NULL, "A1"."CHECK_IMPORT_STATUS")), MAX(DECODE("A1"."INTERFACE_GZIP_STATUS", '1001', NULL, '1000', NULL, "A1"."INTERFACE_GZIP_STATUS")), MAX(DECODE("A1"."INTERFACE_COMPRESS_STATUS", '1001', NULL, '1000', NULL, "A1"."INTERFACE_COMPRESS_STATUS")), "A1"."TASK_DATE", "A1"."EXECUTE_ID", "A1"."INTERFACE_SOURCE" FROM "TI_INTERFACE_PERIOD_STATUS" "A1" WHERE ("A1"."FTP_DOWN_STATUS">'1001' OR "A1"."FTP_CHECK_STATUS">'1001' OR "A1"."CREATE_LOG_STATUS">'1001' OR "A1"."INTERFACE_CHECK_STATUS">'1001' OR "A1"."MK_CTL_STATUS">'1001' OR "A1"."IMPORT_STATUS">'1001' OR "A1"."CHECK_IMPORT_STATUS">'1001' OR "A1"."INTERFACE_GZIP_STATUS">'1001' OR "A1"."INTERFACE_COMPRESS_STATUS">'1001') AND ("A1"."TASK_DATE"=:1 AND "A1"."INTERFACE_SOURCE"<>'hospital_register' AND NOT EXISTS (SELECT 0 FROM "TI_INTERFACE_PERIOD_STATUS" "A4" WHERE "A4"."TASK_DATE"=: 2 AND "A4"."INTERFACE_SOURCE"<>'hospital_register' AND "A4"."TASK_ID"<>'1007' AND "A4"."TASK_ID"<>'1008' AND "A4"."FTP_DOWN_STATUS"<'1002' AND "A4"."FTP_CHECK_STATUS"<'1002' AND "A4"."CREATE_LOG_STATUS"<'1002' AND "A4"."INTERFACE_CHECK_STATUS"<'1002' AND "A4"."MK_CTL_STATUS"<'1002' AND "A4"."IMPORT_STATUS"<'1002' AND "A4"."CHECK_IMPORT_STATUS"<'1002' AND "A4"."INTERFACE_GZIP_STATUS"<'1002' AND "A4"."INTERFACE_COMPRESS_STATUS"<'1002' GROUP BY "A4"."TASK_ID" HAVING LNNVL("A4"."TASK_ID"<>"A1"."TASK_ID")) OR "A1"."TASK_DATE"=:3 AND "A1"."INTERFACE_SOURCE"='hospital_register' AND NOT EXISTS (SELECT 0 FROM "TI_INTERFACE_PERIOD_STATUS" "A3" WHERE "A3"."TASK_DATE"=:4 AND "A3"."INTERFACE_SOURCE"='hospital_register' AND "A3"."FTP_DOWN_STATUS"<'1002' AND "A3"."FTP_CHECK_STATUS"<'1002' AND "A3"."CREATE_LOG_STATUS"<'1002' AND "A3"."INTERFACE_CHECK_STATUS"<'1002' AND "A3"."MK_CTL_STATUS"<'1002' AND "A3"."IMPORT_STATUS"<'1002' AND "A3"."CHECK_IMPORT_STATUS"<'1002' AND "A3"."INTERFACE_GZIP_STATUS"<'1002' AND "A3"."INTERFACE_COMPRESS_STATUS"<'1002' GROUP BY "A3"."TASK_ID" HAVING LNNVL("A3"."TASK_ID"<>"A1"."TASK_ID")) OR "A1"."TASK_DATE"=:5 AND ("A1"."TASK_ID"='1007' OR "A1"."TASK_ID"='1008') AND NOT EXISTS (SELECT 0 FROM "TI_INTERFACE_PERIOD_STATUS" "A2" WHERE "A2"."TASK_DATE"=:6 AND ("A2"."TASK_ID"='1007' OR "A2"."TASK_ID"='1008') AND "A2"."FTP_DOWN_STATUS"<'1002' AND "A2"."FTP_CHECK_STATUS"<'1002' AN D "A2"."CREATE_LOG_STATUS"<'1002' AND "A2"."INTERFACE_CHECK_STATUS"<'1002' AND "A2"."MK_CTL_STATUS"<'1002' AND "A2"."IMPORT_STATUS"<'1002' AND "A2"."CHECK_IMPORT_STATUS"<'1002' AND "A2"."INTERFACE_GZIP_STATUS"<'1002' AND "A2"."INTERFACE_COMPRESS_STATUS"<'1002' GROUP BY "A2"."TASK_ID" HAVING LNNVL("A2"."TASK_ID"<>"A1"."TASK_ID"))) GROUP BY "A1"."TASK_ID", "A1"."TASK_DATE", "A1"."EXECUTE_ID", "A1"."INTERFACE_SOURCE"
9qgtwh66xg6nz	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
bdv0rkkssq2jm	SELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPF'
bsa0wjtftg3uw	select file# from file$ where ts#=:1
ca7fk0wugft6v	ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '., ' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' TIME_ZONE= '+08:00' NLS_COMP= 'BINARY' NLS_DUAL_CURRENCY= '$' NLS_TIME_FORMAT= 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT= 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM TZR'
cb0dwkwdy0mfp	update TI_INTERFACE_PERIOD_STATUS set import_status='1001', import_date='20140505 07:41:34' where data_file_name like '%TTGW%20140504%.Z9C' and execute_id='1'
chndvcf5uj6vp	select count(*) from TI_BIL_PSTN_CALL_20140504
cq78w8j9119dy	delete from TI_CRM_RELATION_UU_ITEM where date_flag=20140504
ct91xzzquzxrb	INSERT INTO TI_CONTRACT_USER NOLOGGING SELECT SERIAL_NUMBER, PRODUCT_NAME, SYSDATE INSERT_DATE FROM (SELECT SERIAL_NUMBER, PRODUCT_NAME, OPEN_DATE, ROW_NUMBER() OVER(PARTITION BY SERIAL_NUMBER ORDER BY OPEN_DATE DESC) RN FROM (SELECT A.SERIAL_NUMBER, C.PRODUCT_NAME, A.OPEN_DATE FROM TI_CRM_USER A, Ti_Crm_User_Product B, GR_DIM.DIM_ACRM_PRODUCT_ID@TO_HJFX81_CAL C WHERE A.USER_ID = B.USER_ID AND A.PRODUCT_ID = C.PRODUCT_ID AND A.NET_TYPE_CODE IN ('10', '16', '17', '33') AND A.REMOVE_TAG IN ('0', '1', '3') AND B.PRODUCT_MODE = '50' AND SUBSTR(A.SERIAL_NUMBER, 1, 3) <> '145' AND SUBSTR(B.START_DATE, 1, 8) = TO_CHAR(SYSDATE-1, 'yyyymmdd'))) WHERE RN = 1
czjf28cur2c9w	update hjfx.TI_INTERFACE_PERIOD_STATUS set check_import_status='1001', check_import_date='20140505 06:35:28' where data_file_name like 'A0500120140504%.AVL' and execute_id='1'
dgwcyapy6hba6	select max(t.execute_id) from TI_INTERFACE_PERIOD_STATUS t where t.task_id='1022' and t.data_file_name like '%TTYD%20140504%.Z9C%'
dzffdpu58dqgv	SELECT A.TABLESPACE_NAME\|\|'\|'\|\| decode(substr(ROUND(A.BYTES / 1024 / 1024 / 1024, 2), 1, 1), '.', '0'\|\|ROUND(A.BYTES / 1024 / 1024 / 1024, 2), ROUND(A.BYTES / 1024 / 1024 / 1024, 2))\|\|'\|'\|\| decode(substr(ROUND((A.BYTES - B.BYTES) / 1024 / 1024 / 1024, 2), 1, 1), '.', '0'\|\|ROUND((A.BYTES - B.BYTES) / 1024 / 1024 / 1024, 2), ROUND((A.BYTES - B.BYTES) / 1024 / 1024 / 1024, 2))\|\|'\|'\|\| decode(substr(ROUND(B.BYTES / 1024 / 1024 / 1024, 2), 1, 1), '.', '0'\|\|ROUND(B.BYTES / 1024 / 1024 / 1024, 2), ROUND(B.BYTES / 1024 / 1024 / 1024, 2))\|\|'\|'\|\| decode(substr(ROUND(((A.BYTES - B.BYTES) / A.BYTES) * 100, 2), 1, 1), '.', '0'\|\|ROUND(((A.BYTES - B.BYTES) / A.BYTES) * 100, 2), ROUND(((A.BYTES - B.BYTES) / A.BYTES) * 100, 2)) FROM (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) A, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES, MAX(BYTES) LARGEST FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) B WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME ORDER BY ((A.BYTES - B.BYTES) / A.BYTES) DESC
fhx9dpv7b55wa	update TI_INTERFACE_PERIOD_STATUS set import_status='1001', import_date='20140505 08:03:58' where data_file_name like '%CMYD%20140504%.zjc' and execute_id='1'
fy9ta5zgkwqmp	SELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPROPF'
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g337099aatnuj	update smon_scn_time set orig_thread=0, time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)
gd68yfsj25hzj	select count(*) from TI_BIL_GSM_SMS_20140504

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	164,886	4.58	0.81
CPU used when call started	162,747	4.52	0.80
CR blocks created	13,021	0.36	0.06
Cached Commit SCN referenced	2,629,884	73.09	12.89
Commit SCN cached	184	0.01	0.00
DB time	3,606,831	100.25	17.68
DBWR checkpoint buffers written	48,165	1.34	0.24
DBWR checkpoints	419	0.01	0.00
DBWR object drop buffers written	2,977	0.08	0.01
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	80	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	931	0.03	0.00
DBWR undo block writes	6,602	0.18	0.03
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	193	0.01	0.00
IMU Flushes	201,154	5.59	0.99
IMU Redo allocation size	2,110,181,964	58,649.74	10,343.37
IMU commits	2,976	0.08	0.01
IMU contention	3	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	819	0.02	0.00
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	210,684,280	5,855.69	1,032.70
IMU- failed to get a private strand	819	0.02	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
SMON posted for dropping temp segment	217	0.01	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	4	0.00	0.00
SQL*Net roundtrips to/from client	583,311	16.21	2.86
SQL*Net roundtrips to/from dblink	52	0.00	0.00
active txn count during cleanout	154,552	4.30	0.76
application wait time	170	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	115,873	3.22	0.57
branch node splits	0	0.00	0.00
buffer is not pinned count	1,442,644	40.10	7.07
buffer is pinned count	888,100	24.68	4.35
bytes received via SQL*Net from client	14,418,079,727	400,731.60	70,672.36
bytes received via SQL*Net from dblink	5,890,542	163.72	28.87
bytes sent via SQL*Net to client	134,559,028	3,739.89	659.56
bytes sent via SQL*Net to dblink	10,217	0.28	0.05
calls to get snapshot scn: kcmgss	684,248	19.02	3.35
calls to kcmgas	269,679	7.50	1.32
calls to kcmgcs	182,611	5.08	0.90
change write time	1,214	0.03	0.01
cleanout - number of ktugct calls	154,824	4.30	0.76
cleanouts and rollbacks - consistent read gets	139	0.00	0.00
cleanouts only - consistent read gets	209	0.01	0.00
cluster key scan block gets	1,118,655	31.09	5.48
cluster key scans	36,208	1.01	0.18
commit batch performed	233	0.01	0.00
commit batch requested	233	0.01	0.00
commit batch/immediate performed	233	0.01	0.00
commit batch/immediate requested	233	0.01	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	124	0.00	0.00
commit cleanout failures: cannot pin	1	0.00	0.00
commit cleanouts	403,727	11.22	1.98
commit cleanouts successfully completed	403,602	11.22	1.98
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	464	0.01	0.00
concurrency wait time	2,295	0.06	0.01
consistent changes	25,231	0.70	0.12
consistent gets	70,368,704	1,955.81	344.92
consistent gets - examination	438,060	12.18	2.15
consistent gets direct	2	0.00	0.00
consistent gets from cache	70,368,703	1,955.81	344.92
current blocks converted for CR	0	0.00	0.00
cursor authentications	677	0.02	0.00
data blocks consistent reads - undo records applied	25,189	0.70	0.12
db block changes	2,854,771	79.34	13.99
db block gets	5,642,992	156.84	27.66
db block gets direct	2,625,797	72.98	12.87
db block gets from cache	3,017,195	83.86	14.79
deferred (CURRENT) block cleanout applications	200,559	5.57	0.98
dirty buffers inspected	829	0.02	0.00
enqueue conversions	10,027	0.28	0.05
enqueue releases	831,175	23.10	4.07
enqueue requests	831,176	23.10	4.07
enqueue timeouts	0	0.00	0.00
enqueue waits	418	0.01	0.00
execute count	401,887	11.17	1.97
free buffer inspected	10,470,539	291.01	51.32
free buffer requested	10,526,679	292.58	51.60
heap block compress	37,770	1.05	0.19
hot buffers moved to head of LRU	538	0.01	0.00
immediate (CR) block cleanout applications	348	0.01	0.00
immediate (CURRENT) block cleanout applications	2,519	0.07	0.01
index fast full scans (full)	35	0.00	0.00
index fetch by key	206,914	5.75	1.01
index scans kdiixs1	167,626	4.66	0.82
leaf node 90-10 splits	98	0.00	0.00
leaf node splits	148	0.00	0.00
lob reads	263	0.01	0.00
lob writes	485	0.01	0.00
lob writes unaligned	485	0.01	0.00
logons cumulative	3,284	0.09	0.02
messages received	241,579	6.71	1.18
messages sent	241,579	6.71	1.18
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	69,446,867	1,930.18	340.40
opened cursors cumulative	121,620	3.38	0.60
parse count (failures)	9	0.00	0.00
parse count (hard)	9,944	0.28	0.05
parse count (total)	122,604	3.41	0.60
parse time cpu	1,384	0.04	0.01
parse time elapsed	4,282	0.12	0.02
physical read IO requests	667,874	18.56	3.27
physical read bytes	84,483,072,000	2,348,096.09	414,106.32
physical read total IO requests	707,386	19.66	3.47
physical read total bytes	88,540,625,408	2,460,870.46	433,995.02
physical read total multi block requests	652,186	18.13	3.20
physical reads	10,312,875	286.63	50.55
physical reads cache	10,312,873	286.63	50.55
physical reads cache prefetch	9,645,001	268.07	47.28
physical reads direct	2	0.00	0.00
physical reads direct (lob)	1	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	101,494	2.82	0.50
physical write bytes	21,969,035,264	610,600.50	107,684.49
physical write total IO requests	359,653	10.00	1.76
physical write total bytes	26,552,513,024	737,992.25	130,151.08
physical write total multi block requests	304,665	8.47	1.49
physical writes	2,681,767	74.54	13.15
physical writes direct	2,625,797	72.98	12.87
physical writes direct (lob)	1	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	55,970	1.56	0.27
physical writes non checkpoint	2,667,505	74.14	13.08
pinned buffers inspected	366	0.01	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	10,865,769	302.00	53.26
queries parallelized	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	1,757,667	48.85	8.62
recursive cpu usage	5,284	0.15	0.03
redo blocks read for recovery	0	0.00	0.00
redo blocks written	3,435,121	95.47	16.84
redo buffer allocation retries	1	0.00	0.00
redo entries	1,941,519	53.96	9.52
redo log space requests	1	0.00	0.00
redo log space wait time	4	0.00	0.00
redo ordering marks	19,610	0.55	0.10
redo size	1,641,356,900	45,619.36	8,045.35
redo synch time	11,790	0.33	0.06
redo synch writes	213,128	5.92	1.04
redo wastage	61,148,112	1,699.53	299.73
redo write time	12,918	0.36	0.06
redo writer latching time	11	0.00	0.00
redo writes	214,298	5.96	1.05
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	12,831	0.36	0.06
rows fetched via callback	69,780	1.94	0.34
session connect time	0	0.00	0.00
session cursor cache hits	47,997	1.33	0.24
session logical reads	76,011,688	2,112.65	372.58
session pga memory	800,495,016	22,248.71	3,923.75
session pga memory max	891,917,736	24,789.68	4,371.87
session uga memory	###############	68,642,032.56	12,105,594.57
session uga memory max	1,912,766,000	53,162.82	9,375.71
shared hash latch upgrades - no wait	169,350	4.71	0.83
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	39,112	1.09	0.19
sorts (rows)	465,888	12.95	2.28
sql area purged	499	0.01	0.00
summed dirty queue length	1,030	0.03	0.01
switch current to new buffer	1,194	0.03	0.01
table fetch by rowid	159,001	4.42	0.78
table fetch continued row	192	0.01	0.00
table scan blocks gotten	68,202,552	1,895.60	334.30
table scan rows gotten	3,300,108,551	91,722.19	16,175.97
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	0	0.00	0.00
table scans (long tables)	568	0.02	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	31,108	0.86	0.15
total number of times SMON posted	662	0.02	0.00
transaction rollbacks	233	0.01	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	90,451,944	2,513.99	443.36
user I/O wait time	57,432	1.60	0.28
user calls	611,998	17.01	3.00
user commits	203,769	5.66	1.00
user rollbacks	244	0.01	0.00
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	19,971	0.56	0.10
write clones created in background	1,223	0.03	0.01
write clones created in foreground	0	0.00	0.00

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	18,100,051	18,141,498
opened cursors current	48	56
logons current	23	29

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)	1	0.10

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	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
TS_CDR	661,880	18	0.76	15.49	94,084	3	12,787	3.35
SYSTEM	5,394	0	4.78	10.97	1,640	0	0	0.00
SYSAUX	94	0	5.74	1.04	3,252	0	0	0.00
UNDOTBS1	0	0	0.00	0.00	2,260	0	6	0.00
TS_YYGH	505	0	3.43	2.22	258	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/oracle/hjfxdata/oradata/hjfxdb/sysaux01.dbf	94	0	5.74	1.04	3,252	0	0.00
SYSTEM	/oracle/hjfxdata/oradata/hjfxdb/system01.dbf	5,394	0	4.78	10.97	1,640	0	0.00
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR003.dbf	13,917	0	1.64	15.11	2,006	443	2.69
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR004.dbf	37,380	1	0.74	15.77	3,363	624	1.89
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR005.dbf	35,149	1	0.81	15.61	4,113	448	2.12
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR006.dbf	34,863	1	0.83	15.46	3,813	769	4.80
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR007.dbf	10,698	0	1.44	15.81	1,999	210	1.76
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR009.dbf	51,550	1	0.69	15.74	4,530	748	2.73
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR010.dbf	50,493	1	0.70	15.87	4,787	899	1.70
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR011.dbf	21,085	1	1.03	15.71	2,911	611	1.93
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR012.dbf	50,081	1	0.74	15.59	5,118	734	3.80
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR014.dbf	35,253	1	0.77	15.68	4,940	767	2.10
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR015.dbf	35,700	1	0.78	15.84	4,994	550	1.95
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_CDR016.dbf	53,786	1	0.67	15.90	4,274	832	1.30
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/TS_cdr008.dbf	60,593	2	0.73	15.64	6,999	832	4.30
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/ts_cdr01.dbf	61,520	2	0.78	14.47	8,502	2,069	5.36
TS_CDR	/oracle/hjfxdata/oradata/hjfxdb/ts_cdr02.dbf	54,093	2	0.79	14.48	6,317	1,884	4.97
TS_CDR	/oracle/hjfxdata02/oradata/hjfxdb/TS_CDR017.dbf	18,124	1	0.44	15.91	8,438	94	0.64
TS_CDR	/oracle/hjfxdata02/oradata/hjfxdb/TS_CDR018.dbf	18,201	1	0.36	15.92	8,247	95	0.32
TS_CDR	/oracle/hjfxdata02/oradata/hjfxdb/TS_CDR019.dbf	19,394	1	0.37	15.39	8,733	178	0.28
TS_YYGH	/oracle/hjfxdata/oradata/hjfxdb/ts_yygh01.dbf	505	0	3.43	2.22	258	0	0.00
UNDOTBS1	/oracle/hjfxdata/oradata/hjfxdb/UNDOTBS2.dbf	0	0			630	0	0.00
UNDOTBS1	/oracle/hjfxdata/oradata/hjfxdb/undotbs01.dbf	0	0			1,630	6	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	545,594	86	73,384,232	10,312,865	55,970	0	0	12,793

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	12	181	255	567	15099480	567
E	0	213	162929	2780327	2813278	15099480	2813278

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	432	0.10	53,568	1.01	10,593,628,853
D	864	0.20	107,136	1.01	10,579,162,462
D	1,296	0.29	160,704	1.01	10,563,909,024
D	1,728	0.39	214,272	1.01	10,547,683,553
D	2,160	0.49	267,840	1.01	10,531,501,521
D	2,592	0.59	321,408	1.00	10,516,374,341
D	3,024	0.69	374,976	1.00	10,502,439,026
D	3,456	0.79	428,544	1.00	10,489,742,929
D	3,888	0.88	482,112	1.00	10,478,187,119
D	4,320	0.98	535,680	1.00	10,467,559,324
D	4,400	1.00	545,600	1.00	10,465,730,208
D	4,752	1.08	589,248	1.00	10,457,682,080
D	5,184	1.18	642,816	1.00	10,448,400,130
D	5,616	1.28	696,384	1.00	10,439,591,227
D	6,048	1.37	749,952	1.00	10,431,086,450
D	6,480	1.47	803,520	1.00	10,422,647,319
D	6,912	1.57	857,088	1.00	10,414,068,726
D	7,344	1.67	910,656	0.99	10,405,175,307
D	7,776	1.77	964,224	0.99	10,395,774,660
D	8,208	1.87	1,017,792	0.99	10,385,626,608
D	8,640	1.96	1,071,360	0.99	10,374,578,549

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	670	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,628	1,395	192.83	0.00	0.00	0.00	0.00	166,700
E	1,628	1,392	202.73	0.00	0.00	0.00	0.00	166,700

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	19,267	19,267
64K	128K	64	64
128K	256K	4	4
512K	1024K	321	321
1M	2M	306	306
2M	4M	9	9

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
204	0.13	2,827,562.07	2,747,196.89	51.00	38
407	0.25	2,827,562.07	1,537,856.63	65.00	0
814	0.50	2,827,562.07	1,502,828.92	65.00	0
1,221	0.75	2,827,562.07	1,502,828.92	65.00	0
1,628	1.00	2,827,562.07	1,367,089.26	67.00	0
1,954	1.20	2,827,562.07	1,150,479.55	71.00	0
2,279	1.40	2,827,562.07	1,150,479.55	71.00	0
2,605	1.60	2,827,562.07	1,150,479.55	71.00	0
2,930	1.80	2,827,562.07	1,150,479.55	71.00	0
3,256	2.00	2,827,562.07	1,150,479.55	71.00	0
4,884	3.00	2,827,562.07	1,150,479.55	71.00	0
6,512	4.00	2,827,562.07	1,150,479.55	71.00	0
9,768	6.00	2,827,562.07	1,150,479.55	71.00	0
13,024	8.00	2,827,562.07	1,150,479.55	71.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
320	0.77	37	2,455	856,723	1.00	27,023	1.04	228,989,536
368	0.88	84	4,996	857,268	1.00	26,478	1.02	229,221,410
416	1.00	131	10,691	857,799	1.00	25,947	1.00	229,446,309
464	1.12	178	13,714	858,312	1.00	25,434	0.98	229,660,631
512	1.23	225	14,828	858,807	1.00	24,939	0.96	229,863,562
560	1.35	272	17,244	859,286	1.00	24,460	0.94	230,055,645
608	1.46	319	18,999	859,753	1.00	23,993	0.92	230,237,402
656	1.58	366	23,585	860,203	1.00	23,543	0.91	230,409,510
704	1.69	413	28,883	860,637	1.00	23,109	0.89	230,572,645
752	1.81	460	31,374	861,055	1.00	22,691	0.87	230,727,664
800	1.92	507	32,941	861,460	1.00	22,286	0.86	230,876,177
848	2.04	554	34,995	861,855	1.00	21,891	0.84	231,019,932

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,224	0.25	4,849,858	10,578,702,477
2,448	0.50	4,809,937	10,531,606,947
3,672	0.75	4,781,898	10,502,303,062
4,896	1.00	4,752,433	10,465,673,206
6,120	1.25	4,729,621	10,439,509,023
7,344	1.50	4,709,186	10,414,391,407
8,568	1.75	4,685,425	10,385,087,522
9,792	2.00	4,674,494	10,374,621,849

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	0.50	0	0	0	0
32	1.00	0	0	0	0
48	1.50	0	0	0	0
64	2.00	0	0	0	0
80	2.50	0	0	0	0
96	3.00	0	0	0	0
112	3.50	0	0	0	0
128	4.00	0	0	0	0
144	4.50	0	0	0	0
160	5.00	0	0	0	0
176	5.50	0	0	0	0
192	6.00	0	0	0	0
208	6.50	0	0	0	0
224	7.00	0	0	0	0
240	7.50	0	0	0	0
256	8.00	0	0	0	0
272	8.50	0	0	0	0
288	9.00	0	0	0	0
304	9.50	0	0	0	0
320	10.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
segment header	3,171	30	10
data block	9,616	12	1
undo header	5	0	0
undo block	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse)	3,762	3,762	0	418	1	3.19

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	7.94	116,792	219	5	15/17.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
05-May 09:58	2,695	70,554	219	2	18	0/0	0/0/0/0/0/0
05-May 09:48	3	69	0	1	15	0/0	0/0/0/0/0/0
05-May 09:38	45	385	0	3	15	0/0	0/0/0/0/0/0
05-May 09:28	6	72	0	3	15	0/0	0/0/0/0/0/0
05-May 09:18	9	102	0	3	15	0/0	0/0/0/0/0/0
05-May 09:08	79	232	0	3	15	0/0	0/0/0/0/0/0
05-May 08:58	11	139	0	3	15	0/0	0/0/0/0/0/0
05-May 08:48	2	41	0	1	15	0/0	0/0/0/0/0/0
05-May 08:38	4	67	0	1	15	0/0	0/0/0/0/0/0
05-May 08:28	10	122	0	3	15	0/0	0/0/0/0/0/0
05-May 08:18	6	205	0	1	15	0/0	0/0/0/0/0/0
05-May 08:08	592	5,439	0	4	15	0/0	0/0/0/0/0/0
05-May 07:58	239	640	0	4	15	0/0	0/0/0/0/0/0
05-May 07:48	126	333	0	3	15	0/0	0/0/0/0/0/0
05-May 07:38	111	197	0	3	15	0/0	0/0/0/0/0/0
05-May 07:28	64	65	0	1	15	0/0	0/0/0/0/0/0
05-May 07:18	104	84	0	2	15	0/0	0/0/0/0/0/0
05-May 07:08	304	491	0	4	15	0/0	0/0/0/0/0/0
05-May 06:58	65	382	0	3	15	0/0	0/0/0/0/0/0
05-May 06:48	5	82	0	2	15	0/0	0/0/0/0/0/0
05-May 06:38	23	292	0	2	15	0/0	0/0/0/0/0/0
05-May 06:28	19	234	0	3	15	0/0	0/0/0/0/0/0
05-May 06:18	38	407	0	3	15	0/0	0/0/0/0/0/0
05-May 06:08	55	103	0	4	15	0/0	0/0/0/0/0/0
05-May 05:58	4	55	0	1	15	0/0	0/0/0/0/0/0
05-May 05:48	6	192	0	1	15	0/0	0/0/0/0/0/0
05-May 05:38	2,671	30,876	0	3	15	0/0	0/0/0/0/0/0
05-May 05:28	6	68	0	1	15	0/0	0/0/0/0/0/0
05-May 05:18	1	53	0	1	15	0/0	0/0/0/0/0/0
05-May 05:08	59	168	0	3	15	0/0	0/0/0/0/0/0
05-May 04:58	2	31	0	1	15	0/0	0/0/0/0/0/0
05-May 04:48	1	65	0	1	15	0/0	0/0/0/0/0/0
05-May 04:38	12	151	0	3	15	0/0	0/0/0/0/0/0
05-May 04:28	2	60	0	1	15	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	136,457	0.00		0	0
Consistent RBA	214,240	0.00		0	0
FAL request queue	722	0.00		0	0
FAL subheap alocation	722	0.00		0	0
FIB s.o chain latch	14	0.00		0	0
FOB s.o list latch	15,413	0.00		0	0
In memory undo latch	1,098,603	0.00		0	213,366	0.00
JS mem alloc latch	159	0.00		0	0
JS queue access latch	159	0.00		0	0
JS queue state obj latch	259,918	0.00		0	0
JS slv state obj latch	1,701	0.00		0	0
KMG MMAN ready and startup request latch	11,995	0.00		0	0
KMG resize request state object freelist	4	0.00		0	0
KTF sga latch	10,505	0.00		0	11,434	0.00
KWQMN job cache list latch	8	0.00		0	0
KWQP Prop Status	20	0.00		0	0
MQL Tracking Latch	0			0	718	0.00
Memory Management Latch	42	0.00		0	11,995	0.00
OS process	11,427	0.00		0	0
OS process allocation	19,617	0.00		0	0
OS process: request allocation	5,412	0.00		0	0
PL/SQL warning settings	8,535	0.00		0	0
Reserved Space Latch	3	0.00		0	0
SGA IO buffer pool latch	643,232	0.00	0.05	0	643,232	0.00
SQL memory manager latch	10	0.00		0	11,989	0.00
SQL memory manager workarea list latch	820,569	0.00		0	0
Shared B-Tree	1,313	0.00		0	0
active checkpoint queue latch	38,015	0.00		0	0
active service list	89,798	0.00		0	12,278	0.00
archive control	865	0.00		0	0
archive process latch	12,711	0.00		0	0
begin backup scn array	84,671	0.00		0	0
buffer pool	4	0.00		0	0
cache buffer handles	237,774	0.00		0	0
cache buffers chains	163,025,363	0.07	0.00	0	20,248,708	0.00
cache buffers lru chain	217,655	0.08	0.01	0	77,949,346	0.04
cache table scan latch	0			0	648,293	0.01
channel handle pool latch	7,116	0.00		0	0
channel operations parent latch	222,590	0.00	0.00	0	0
checkpoint queue latch	673,639	0.00	0.00	0	221,406	0.00
client/application info	37,945	0.00		0	0
commit callback allocation	96	0.00		0	0
compile environment latch	219,235	0.00		0	0
dictionary lookup	532	0.00		0	0
dml lock allocation	454,812	0.00	0.00	0	0
dummy allocation	6,562	0.02	0.00	0	0
enqueue hash chains	1,673,846	0.04	0.00	0	734	0.00
enqueues	981,739	0.12	0.00	0	0
event group latch	2,709	0.00		0	0
file cache latch	16,221	0.00		0	0
global KZLD latch for mem in SGA	2,076	0.00		0	0
global tx hash mapping	805	0.00		0	0
hash table column usage latch	412	0.00		0	26,345	0.00
hash table modification latch	858	0.00		0	0
job workq parent latch	0			0	1,150	0.00
job_queue_processes parameter latch	1,173	0.00		0	0
kks stats	35,819	0.00	0.00	0	0
kmcptab latch	2	0.00		0	0
kmcpvec latch	0			0	2	0.00
krbmrosl	260	0.00		0	0
ksuosstats global area	2,418	0.00		0	0
ktm global data	1,220	0.00		0	0
kwqbsn:qsga	1,303	0.00		0	0
lgwr LWN SCN	229,670	1.60	0.00	0	0
library cache	2,326,425	0.07	0.01	0	32,439	0.00
library cache load lock	2,100	0.00		0	0
library cache lock	620,107	0.00	0.00	0	0
library cache lock allocation	29,982	0.00		0	0
library cache pin	1,376,920	0.06	0.00	0	0
library cache pin allocation	10,788	0.00		0	0
list of block allocation	4,296	0.00		0	0
loader state object freelist	1,136	0.00		0	0
logminer context allocation	10	0.00		0	0
longop free list parent	57	0.00		0	58	0.00
message pool operations parent latch	2,162	0.00		0	0
messages	967,130	0.06	0.00	0	0
mostly latch-free SCN	223,762	0.16	0.00	0	0
multiblock read objects	1,301,936	0.00	0.00	0	0
ncodef allocation latch	585	0.00		0	0
object queue header heap	2,677	0.00		0	2,448	0.00
object queue header operation	21,364,588	0.00	0.02	0	0
object stats modification	861	0.00		0	0
parallel query alloc buffer	4,376	0.00		0	0
parameter table allocation management	3,374	0.03	0.00	0	0
post/wait queue	305,477	0.00		0	202,953	0.00
process allocation	5,412	0.00		0	2,709	0.00
process group creation	5,412	0.00		0	0
qmn task queue latch	7,702	0.01	1.00	0	0
redo allocation	1,087,317	0.03	0.00	0	1,941,303	0.02
redo copy	0			0	1,941,421	0.05
redo writing	702,024	0.00	0.20	0	0
reservation so alloc latch	2	0.00		0	0
resmgr group change latch	8,003	0.00		0	0
resmgr:actses active list	6,530	0.00		0	0
resmgr:actses change group	2,731	0.00		0	0
resmgr:free threads list	6,520	0.02	0.00	0	0
resmgr:schema config	10	0.00		0	0
row cache objects	1,865,094	0.19	0.00	0	367	0.00
rules engine rule set statistics	1,000	0.00		0	0
sequence cache	7,008	0.00		0	0
session allocation	1,069,885	0.00	0.00	0	0
session idle bit	1,468,700	0.00	0.00	0	0
session state list latch	9,626	0.00		0	0
session switching	585	0.00		0	0
session timer	12,278	0.00		0	0
shared pool	2,316,317	0.01	0.43	1	0
simulator hash latch	20,543,701	0.00	0.00	0	0
simulator lru latch	8,824,367	0.11	0.00	0	3,282,984	0.00
slave class	21	0.00		0	0
slave class create	84	10.71	1.00	0	0
sort extent pool	1,542	0.00		0	0
state object free list	20	0.00		0	0
statistics aggregation	1,400	0.00		0	0
temp lob duration state obj allocation	4	0.00		0	0
threshold alerts latch	1,890	0.00		0	0
transaction allocation	9,513	0.00		0	0
transaction branch allocation	1,357	0.00		0	0
undo global data	1,280,957	0.00		0	0
user lock	9,446	0.03	0.00	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	163,025,363	119,728	163	119,590
simulator lru latch	8,824,367	10,135	35	10,102
lgwr LWN SCN	229,670	3,666	3	3,663
library cache	2,326,425	1,576	14	1,563
shared pool	2,316,317	251	109	171
cache buffers lru chain	217,655	183	2	181
object queue header operation	21,364,588	47	1	46
SGA IO buffer pool latch	643,232	22	1	21
slave class create	84	9	9	0
redo writing	702,024	5	1	4
qmn task queue latch	7,702	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
SGA IO buffer pool latch	ksfd_alloc_sgabuffer	1	0
cache buffers chains	kcbgtcr: kslbegin excl	1,042	1,044
cache buffers chains	kcbrls: kslbegin	157	160
cache buffers chains	kcbzwb	10	8
cache buffers chains	kcbzib: finish free bufs	8	6
cache buffers chains	kcbbic2	1	0
cache buffers chains	kcbzib: multi-block read: nowait	1	0
cache buffers lru chain	kcbzar: KSLNBEGIN	1	0
cache buffers lru chain	kcbzgws	1	0
event range base latch	No latch	1	1
library cache	kglhdiv: child	1	0
library cache	kglpin: child: heap processing	1	5
library cache	kglpndl: child: before processing	1	4
library cache lock	kgllkdl: child: no lock handle	6	0
mostly latch-free SCN	kcs024	3	0
object queue header operation	kcbo_switch_cq	1	0
redo writing	kcrfsr: rba scn pair	1	0
shared pool	kghalo	67	59
shared pool	kghfrunp: alloc: cursor dur	25	0
shared pool	kghalp	15	1
shared pool	kghfrunp: clatch: nowait	5	0
shared pool	kghfre	1	45
shared pool	kghupr1	1	4
simulator lru latch	kcbs_simulate: simulate set	34	35
simulator lru latch	kcbs_free_granule_sim_buffers	1	0
slave class create	ksvcreate	9	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 76,011,688
Captured Segments account for 98.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
HJFX	TS_CDR	TI_INTERFACE_PERIOD_STATUS	TABLE	58,742,080	77.28
HJFX	TS_CDR	TI_CRM_USER_ITEM	TABLE	4,765,920	6.27
HJFX	TS_CDR	TI_BIL_GSM_CALL_20140504	TABLE	2,682,640	3.53
HJFX	TS_CDR	TI_CRM_USER_INFOCHANGE	TABLE	1,551,248	2.04
HJFX	TS_CDR	TI_CRM_USER_PRODUCT	TABLE	1,230,656	1.62

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 10,312,875
Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
HJFX	TS_CDR	TI_CRM_USER_ITEM	TABLE	4,721,924	45.79
HJFX	TS_CDR	TI_INTERFACE_PERIOD_STATUS	TABLE	1,342,889	13.02
HJFX	TS_CDR	TI_BIL_GSM_CALL_20140504	TABLE	1,331,179	12.91
HJFX	TS_CDR	TI_CRM_USER_PRODUCT	TABLE	1,230,314	11.93
HJFX	TS_CDR	TI_BIL_GSM_SMS_20140504	TABLE	396,650	3.85

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	632	0.00	20	1
dc_database_links	534	0.00	0	4
dc_files	1,107	0.00	0	27
dc_global_oids	87,697	0.00	0	115
dc_histogram_data	13,610	0.00	0	8,248
dc_histogram_defs	16,005	1.33	0	15,498
dc_object_grants	502	0.00	0	278
dc_object_ids	130,414	0.39	37	2,383
dc_objects	34,812	0.34	603	2,499
dc_profiles	2,672	0.00	0	1
dc_rollback_segments	6,616	0.00	0	22
dc_segments	29,985	0.89	11,992	2,221
dc_sequences	120	0.00	120	8
dc_tablespace_quotas	7,596	0.00	69	2
dc_tablespaces	56,360	0.00	0	11
dc_usernames	7,159	0.00	0	21
dc_users	260,611	0.00	0	75
outstanding_alerts	600	0.00	0	9

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	8,905	0.00	16,293	0.08	13	0
CLUSTER	7	0.00	66	0.00	0	0
INDEX	35	0.00	123	0.00	0	0
SQL AREA	7,779	93.24	496,352	3.56	2,556	879
TABLE/PROCEDURE	9,695	0.53	178,167	1.51	1,113	0
TRIGGER	3,258	0.00	4,814	0.54	26	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	163.87		6.55	15.79	74	80	25	25
	Freeable	28.06	0.00	2.00	2.55	10		14	14
	SQL	0.56	0.30	0.03	0.04	0	8	16	14
	PL/SQL	0.36	0.16	0.02	0.02	0	0	23	23
E	Other	168.73		5.44	14.31	74	80	31	31
	Freeable	32.56	0.00	1.71	2.22	10		19	19
	SQL	0.88	0.52	0.04	0.04	0	8	22	20
	PL/SQL	0.58	0.26	0.02	0.03	0	0	29	29

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	4,647,288,832	4,613,734,400
Fixed Size	2,027,968
Redo Buffers	14,745,600
Variable Size	469,765,696	503,320,128

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	ASH buffers	8.00	8.00	0.00
shared	CCursor	20.61	21.14	2.61
shared	CURSOR STATS	3.53		-100.00
shared	KCB Table Scan Buffer	4.00	4.00	0.00
shared	KGLS heap	5.49		-100.00
shared	KQR M PO	9.91	9.98	0.73
shared	KQR M SO	5.28		-100.00
shared	KSFD SGA I/O b	4.00	4.00	0.00
shared	PCursor	15.27	25.79	68.91
shared	XDB Schema Cac	8.59	8.60	0.04
shared	db_block_hash_buckets	33.63	33.63	0.00
shared	free memory	45.52	70.54	54.96
shared	kglsim hash table bkts	4.00	4.00	0.00
shared	kglsim heap	7.03	7.03	0.00
shared	kglsim object batch	20.26	20.26	0.00
shared	krbmror	4.44	4.44	0.00
shared	library cache	42.97	43.22	0.58
shared	row cache	7.13	7.13	0.00
shared	sql area	51.25	54.04	5.45
streams	free memory	32.00	32.00	0.00
	buffer_cache	4,432.00	4,400.00	-0.72
	fixed_sga	1.93	1.93	0.00
	log_buffer	14.06	14.06	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

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

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Coordinator	99,622	0	0
QMON Slaves	72,560	0	0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/hjfxdata/admin/hjfxdb/adump
background_dump_dest	/oracle/hjfxdata/admin/hjfxdb/bdump
compatible	10.2.0.1.0
control_files	/oracle/hjfxdata/oradata/hjfxdb/control01.ctl, /oracle/hjfxdata/oradata/hjfxdb/control02.ctl, /oracle/hjfxdata/oradata/hjfxdb/control03.ctl
core_dump_dest	/oracle/hjfxdata/admin/hjfxdb/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	hjfxdb
db_recovery_file_dest	/oracle/hjfxdata/flash_recovery_area
db_recovery_file_dest_size	214748364800
dispatchers	(PROTOCOL=TCP) (SERVICE=hjfxdbXDB)
job_queue_processes	10
log_archive_start	TRUE
open_cursors	300
pga_aggregate_target	1707081728
processes	150
remote_login_passwordfile	EXCLUSIVE
sga_target	5133828096
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/hjfxdata/admin/hjfxdb/udump

End of Report

% Blocks changed per Read:	3.76	Recursive Call %:	74.17
Rollback per transaction %:	0.12	Rows per Sort:	11.91

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	86.43	In-memory Sort %:	100.00
Library Hit %:	97.07	Soft Parse %:	91.89
Execute to Parse %:	69.49	Latch Hit %:	99.94
Parse CPU to Parse Elapsd %:	32.32	% Non-Parse CPU:	99.29