### BEGIN LOG - DATE: 140121, TIME: 200852 ### AWR Report for DB: GSDXGPS, Inst: gsdxgps, Snaps: 1593-1594

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

GSDXGPS 769381763 gsdxgps 1 10.2.0.5.0 NO gps1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
GSDXGPS	769381763	gsdxgps	1	10.2.0.5.0	NO	gps1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1593 21-Jan-14 15:00:42 94 3.8

End Snap: 1594 21-Jan-14 16:00:44 94 3.9

Elapsed: 60.04 (mins)

DB Time: 88.38 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1593	21-Jan-14 15:00:42	94	3.8
End Snap:	1594	21-Jan-14 16:00:44	94	3.9
Elapsed:		60.04 (mins)
DB Time:		88.38 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 7,120M 7,168M Std Block Size: 8K

Shared Pool Size: 1,024M 976M Log Buffer: 14,320K

	Begin	End
Buffer Cache:	7,120M	7,168M	Std Block Size:	8K
Shared Pool Size:	1,024M	976M	Log Buffer:	14,320K

Load Profile

Per Second Per Transaction

Redo size: 201,468.28 2,703.06

Logical reads: 4,962.77 66.58

Block changes: 1,045.06 14.02

Physical reads: 265.71 3.56

Physical writes: 64.09 0.86

User calls: 1,123.83 15.08

Parses: 176.24 2.36

Hard parses: 113.97 1.53

Sorts: 36.03 0.48

Logons: 0.01 0.00

Executes: 555.08 7.45

Transactions: 74.53

	Per Second	Per Transaction
Redo size:	201,468.28	2,703.06
Logical reads:	4,962.77	66.58
Block changes:	1,045.06	14.02
Physical reads:	265.71	3.56
Physical writes:	64.09	0.86
User calls:	1,123.83	15.08
Parses:	176.24	2.36
Hard parses:	113.97	1.53
Sorts:	36.03	0.48
Logons:	0.01	0.00
Executes:	555.08	7.45
Transactions:	74.53

% Blocks changed per Read: 21.06 Recursive Call %: 55.10

Rollback per transaction %: 0.00 Rows per Sort: 88.13

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 80.43 Soft Parse %: 35.33

Execute to Parse %: 68.25 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 101.60 % Non-Parse CPU: 88.74

Shared Pool Statistics

Begin End

Memory Usage %: 53.22 46.16

% SQL with executions>1: 49.57 46.81

% Memory for SQL w/exec>1: 46.48 43.01

	Begin	End
Memory Usage %:	53.22	46.16
% SQL with executions>1:	49.57	46.81
% Memory for SQL w/exec>1:	46.48	43.01

Top 5 Timed Events

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

CPU time 1,793 33.8

log file sync 423,585 1,288 3 24.3 Commit

log file parallel write 423,496 1,247 3 23.5 System I/O

direct path sync 10,480 606 58 11.4 User I/O

db file sequential read 8,778 248 28 4.7 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		1,793		33.8
log file sync	423,585	1,288	3	24.3	Commit
log file parallel write	423,496	1,247	3	23.5	System I/O
direct path sync	10,480	606	58	11.4	User I/O
db file sequential read	8,778	248	28	4.7	User I/O

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): 5302.6s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	2,032.29	38.33
DB CPU	1,792.71	33.81
parse time elapsed	466.88	8.80
hard parse elapsed time	400.87	7.56
PL/SQL execution elapsed time	199.13	3.76
repeated bind elapsed time	1.69	0.03
hard parse (sharing criteria) elapsed time	1.15	0.02
connection management call elapsed time	1.07	0.02
hard parse (bind mismatch) elapsed time	1.04	0.02
PL/SQL compilation elapsed time	0.53	0.01
sequence load elapsed time	0.32	0.01
failed parse elapsed time	0.03	0.00
DB time	5,302.63
background elapsed time	3,200.98
background cpu time	119.18

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
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%Total Call Time
CPU time			1,793		33.81
Commit	423,585	0	1,288	3	24.29
System I/O	427,587		1,251	3	23.60
User I/O	957,143		862	1	16.26
Network	6,761,282		59	0	1.10
Concurrency	874	1	2	2	0.03
Configuration	4		0	35	0.00
Other	267		0	0	0.00
Application	160		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)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file sync	423,585	0	1,288	3	1.58
log file parallel write	423,496		1,247	3	1.58
direct path sync	10,480		606	58	0.04
db file sequential read	8,778		248	28	0.03
SQL*Net more data to client	2,699,483		53	0	10.05
direct path read	926,184		5	0	3.45
SQL*Net message to client	4,022,880		5	0	14.98
control file parallel write	1,711		4	3	0.01
db file scattered read	1,188		3	2	0.00
latch: shared pool	696		1	1	0.00
SQL*Net more data from client	38,919		1	0	0.14
db file single write	32		0	12	0.00
os thread startup	10		0	35	0.00
enq: TX - index contention	6		0	32	0.00
log file switch completion	4		0	35	0.00
control file sequential read	2,364		0	0	0.01
read by other session	1		0	118	0.00
latch: library cache	59		0	1	0.00
latch free	10		0	8	0.00
log file single write	8		0	8	0.00
cursor: pin S wait on X	6	100	0	11	0.00
direct path write	10,480		0	0	0.04
SQL*Net break/reset to client	160		0	0	0.00
LGWR wait for redo copy	246		0	0	0.00
latch: undo global data	1		0	9	0.00
buffer busy waits	43		0	0	0.00
latch: In memory undo latch	27		0	0	0.00
row cache lock	1		0	2	0.00
latch: cache buffers chains	26		0	0	0.00
latch: checkpoint queue latch	1		0	0	0.00
latch: redo allocation	2		0	0	0.00
latch: enqueue hash chains	3		0	0	0.00
latch: cache buffers lru chain	2		0	0	0.00
log file sequential read	8		0	0	0.00
cursor: pin S	2		0	0	0.00
SQL*Net message from client	4,022,909		192,242	48	14.98
Streams AQ: qmn slave idle wait	129		3,514	27243	0.00
Streams AQ: qmn coordinator idle wait	258	50	3,514	13622	0.00
virtual circuit status	120	100	3,500	29166	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100	877	877294	0.00
jobq slave wait	57	100	167	2931	0.00
class slave wait	8		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)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	423,497		1,247	3	1.58
control file parallel write	1,711		4	3	0.01
db file single write	32		0	12	0.00
os thread startup	10		0	35	0.00
db file sequential read	34		0	3	0.00
control file sequential read	2,227		0	0	0.01
log file single write	8		0	8	0.00
latch: shared pool	6		0	2	0.00
events in waitclass Other	254		0	0	0.00
log file sequential read	8		0	0	0.00
rdbms ipc message	429,351	2	27,859	65	1.60
pmon timer	1,259	100	3,516	2793	0.00
Streams AQ: qmn slave idle wait	129		3,514	27243	0.00
Streams AQ: qmn coordinator idle wait	258	50	3,514	13622	0.00
smon timer	12	100	3,246	270523	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100	877	877294	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	216,609
IDLE_TIME	2,637,481
IOWAIT_TIME	407,497
NICE_TIME	167
SYS_TIME	33,087
USER_TIME	150,225
LOAD	2
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	9,289,871,360
VM_OUT_BYTES	6,884,368,384
PHYSICAL_MEMORY_BYTES	16,831,197,184
NUM_CPUS	8
NUM_CPU_SOCKETS	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
gsdxgps	5,303.00	1,791.50	956,670	17,805,778
SYS$USERS	0.60	0.60	0	5,047
SYS$BACKGROUND	0.00	0.00	26	63,919
gsdxgpsXDB	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 seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
gsdxgps	956852	861	856	1	6760202	58
SYS$USERS	0	0	0	0	0	0
SYS$BACKGROUND	109	1	18	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
Total DB Time (s): 5,303
Captured SQL account for 28.1% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
1,198	974	411,700	0.00	22.59	bqfk75b3knc9u	WriteLog.exe	BEGIN SP_INSERT_TRCK_LOG(:1, :...
110	111	3,552	0.03	2.08	b98p5y022pun6	OperationServer.exe	select distinct D.Middle_No \|\|...
49	48	393,203	0.00	0.93	0dygnuq0gp9vw	WriteLog.exe	UPDATE GK_T_CARINFO SET LAST_L...
40	37	411,708	0.00	0.75	bu26wuua3354u	WriteLog.exe	SELECT B.CAR_ID , B.SIM_PHONE_...
17	18	155,292	0.00	0.31	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
10	7	7,265	0.00	0.19	gx95dv43tmzhm	OperationServerTest.exe	begin SP_EXEC_OPERATION(:V0000...
9	8	48,226	0.00	0.16	db78fxqxwxt7r		select /+ rule / bucket, end...
8	8	10	0.80	0.15	70h58q9d0z5u8	OperationServer1.exe	select ROWNUM, d.dept_type, d....
5	1	2,590	0.00	0.09	4uurfxq566psq	WriteLog.exe	INSERT INTO GJ_T_ONLINE_STATUS...
5	4	1	4.55	0.09	2xwt70smzrmhw	exp.exe	SELECT /*+NESTED_TABLE_GET_REF...

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 is the CPU Time divided into the Total CPU Time times 100
Total CPU Time (s): 1,793
Captured SQL account for 69.4% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
974	1,198	411,700	0.00	54.33	22.59	bqfk75b3knc9u	WriteLog.exe	BEGIN SP_INSERT_TRCK_LOG(:1, :...
111	110	3,552	0.03	6.19	2.08	b98p5y022pun6	OperationServer.exe	select distinct D.Middle_No \|\|...
48	49	393,203	0.00	2.67	0.93	0dygnuq0gp9vw	WriteLog.exe	UPDATE GK_T_CARINFO SET LAST_L...
37	40	411,708	0.00	2.08	0.75	bu26wuua3354u	WriteLog.exe	SELECT B.CAR_ID , B.SIM_PHONE_...
18	17	155,292	0.00	1.01	0.31	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
8	8	10	0.81	0.45	0.15	70h58q9d0z5u8	OperationServer1.exe	select ROWNUM, d.dept_type, d....
8	9	48,226	0.00	0.45	0.16	db78fxqxwxt7r		select /+ rule / bucket, end...
7	10	7,265	0.00	0.38	0.19	gx95dv43tmzhm	OperationServerTest.exe	begin SP_EXEC_OPERATION(:V0000...
4	5	1	4.13	0.23	0.09	2xwt70smzrmhw	exp.exe	SELECT /*+NESTED_TABLE_GET_REF...
4	4	38,075	0.00	0.21	0.07	8yxsjn42s9ua5	OperationServer1.exe	SELECT STATUS_ID AS STATUSID F...

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: 17,878,518
Captured SQL account for 57.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
12,213,522	411,700	29.67	68.31	973.92	1197.98	bqfk75b3knc9u	WriteLog.exe	BEGIN SP_INSERT_TRCK_LOG(:1, :...
3,285,752	411,708	7.98	18.38	37.27	39.97	bu26wuua3354u	WriteLog.exe	SELECT B.CAR_ID , B.SIM_PHONE_...
1,903,312	393,203	4.84	10.65	47.89	49.17	0dygnuq0gp9vw	WriteLog.exe	UPDATE GK_T_CARINFO SET LAST_L...
1,769,499	3,552	498.17	9.90	111.05	110.49	b98p5y022pun6	OperationServer.exe	select distinct D.Middle_No \|\|...
1,242,336	155,292	8.00	6.95	18.04	16.68	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
609,200	38,075	16.00	3.41	3.73	3.70	8yxsjn42s9ua5	OperationServer1.exe	SELECT STATUS_ID AS STATUSID F...
470,176	10	47,017.60	2.63	8.10	8.03	70h58q9d0z5u8	OperationServer1.exe	select ROWNUM, d.dept_type, d....
146,082	48,226	3.03	0.82	7.98	8.57	db78fxqxwxt7r		select /+ rule / bucket, end...
132,224	7,265	18.20	0.74	6.83	9.86	gx95dv43tmzhm	OperationServerTest.exe	begin SP_EXEC_OPERATION(:V0000...
129,741	1	129,741.00	0.73	4.13	4.55	2xwt70smzrmhw	exp.exe	SELECT /*+NESTED_TABLE_GET_REF...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 957,222
Captured SQL account for 0.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
5,276	1	5,276.00	0.55	4.13	4.55	2xwt70smzrmhw	exp.exe	SELECT /*+NESTED_TABLE_GET_REF...
3,722	411,700	0.01	0.39	973.92	1197.98	bqfk75b3knc9u	WriteLog.exe	BEGIN SP_INSERT_TRCK_LOG(:1, :...
103	2,590	0.04	0.01	0.62	4.58	4uurfxq566psq	WriteLog.exe	INSERT INTO GJ_T_ONLINE_STATUS...
63	7,279	0.01	0.01	1.25	3.80	35wjzadkfuqvm	WriteLog.exe	INSERT INTO CW_T_GPSERROR ( ER...
61	1	61.00	0.01	0.17	3.25	3xzgv2bh0cxbx	java.exe	/* OracleOEM */ SELECT d.statu...
44	7,265	0.01	0.00	6.83	9.86	gx95dv43tmzhm	OperationServerTest.exe	begin SP_EXEC_OPERATION(:V0000...
40	1,214	0.03	0.00	0.16	1.73	2c5shu0nbp9zh	WriteLog.exe	INSERT INTO GJ_T_ALARM(CAR_ID,...
39	7,239	0.01	0.00	2.20	4.46	9z14zjbkzywfy	OperationServerTest.exe	INSERT INTO CL_T_USER_OPERATIO...
20	247	0.08	0.00	0.07	0.20	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
11	981	0.01	0.00	0.10	0.91	5apg832cgnd59	WriteLog.exe	INSERT INTO GJ_T_STATUS_CHANGE...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,999,691
Captured SQL account for 78.4% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
411,708	409,256	0.99	bu26wuua3354u	WriteLog.exe	SELECT B.CAR_ID , B.SIM_PHONE_...
411,700	411,700	1.00	bqfk75b3knc9u	WriteLog.exe	BEGIN SP_INSERT_TRCK_LOG(:1, :...
393,203	238,660	0.61	0dygnuq0gp9vw	WriteLog.exe	UPDATE GK_T_CARINFO SET LAST_L...
155,292	155,292	1.00	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
48,226	884,758	18.35	db78fxqxwxt7r		select /+ rule / bucket, end...
38,075	38,075	1.00	8yxsjn42s9ua5	OperationServer1.exe	SELECT STATUS_ID AS STATUSID F...
23,135	22,251	0.96	96g93hntrzjtr		select /+ rule / bucket_cnt,...
8,763	6,214	0.71	8bk9w5wcukytd	WriteLog.exe	UPDATE GK_T_CARINFO SET LAST_L...
7,289	6,910	0.95	6m5hvtwhjcwun	WriteLog.exe	UPDATE GK_T_CARINFO SET RECEIV...
7,279	7,279	1.00	35wjzadkfuqvm	WriteLog.exe	INSERT INTO CW_T_GPSERROR ( ER...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 634,905
Captured SQL account for 30.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
155,292	155,292	24.46	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
14,530	7,265	2.29	gx95dv43tmzhm	OperationServerTest.exe	begin SP_EXEC_OPERATION(:V0000...
3,553	3,553	0.56	d2t1z75cp894w	OperationServer.exe	select A.EMPLOYEE_DEPARTMENT, ...
3,552	3,552	0.56	b98p5y022pun6	OperationServer.exe	select distinct D.Middle_No \|\|...
3,032	3,032	0.48	520mkxqpf15q8		select 1 from dual
1,744	23,135	0.27	96g93hntrzjtr		select /+ rule / bucket_cnt,...
1,526	48,226	0.24	db78fxqxwxt7r		select /+ rule / bucket, end...
1,243	1,243	0.20	2ym6hhaq30r73		select type#, blocks, extents,...
788	1,457	0.12	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
757	1,185	0.12	2q93zsrvbdw48		select grantee#, privilege#, n...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
2,488,494	3	0.24	8mrg623amm8rx		select OBJOID, CLSOID, RUNTIME...

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
362	9	axmdf8vq7k1rh		select increment$, minvalue, m...
224	485	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
94	1,016	5ngzsfstg8tmy		select o.owner#, o.name, o.nam...
84	1,197	f8pavn1bvsj7t		select con#, obj#, rcon#, enab...
78	1,197	a73wbv1yu8x5c		select con#, type#, condlength...
67	1,109	83taa7kaw59c1		select name, intcol#, segcol#,...
64	5	32bhha21dkv0v		select col#, intcol#, charseti...
63	1	1mjd9xp80vuqa		select node, owner, name from ...
56	1,243	2ym6hhaq30r73		select type#, blocks, extents,...
56	7,092	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
48	7,265	gx95dv43tmzhm	OperationServerTest.exe	begin SP_EXEC_OPERATION(:V0000...
46	16	49s332uhbnsma		declare vsn varchar2(20); beg...
37	1,457	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
34	72	3g7sxtj9d6zd3		select privilege#, nvl(col#, 0...
33	6	0h6b2sajwb74n		select privilege#, level from ...
31	215	451q2032pshqm		select owner#, name, namespace...
27	5	5wc2915k44m38		select user#, type# from user$...
26	1,185	2q93zsrvbdw48		select grantee#, privilege#, n...
25	859	6aq34nj2zb2n7		select col#, grantee#, privile...
25	37	g3wrkmxkxzhf2		select cols, audit$, textlengt...
23	62	0fr8zhn4ymu3v		select intcol#, type, flags, l...
22	2,017	6769wyy3yf66f		select pos#, intcol#, col#, sp...
21	23,135	96g93hntrzjtr		select /+ rule / bucket_cnt,...
21	48,226	db78fxqxwxt7r		select /+ rule / bucket, end...
21	5	f3g84j69n0tjh		select col#, intcol#, ntab# fr...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0dygnuq0gp9vw UPDATE GK_T_CARINFO SET LAST_LONGITUDE=:B11 , LAST_LATITUDE = :B10 , LAST_REPORT_TIME = :B1 , LAST_SPEED = :B9 , HEIGH = :B8 , LAST_DIRCTION = :B7 , LAST_STATUS_ID = :B6 , LAST_ALARM_ID = :B5 , RECEIVE_TIME = :B4 , MILEAGE = :B3 , ACC_OPEN_TIME = :B1 WHERE CAR_ID=:B2 AND ( (LAST_REPORT_TIME IS NULL) OR (LAST_REPORT_TIME < :B1 ))

0fr8zhn4ymu3v select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc

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

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

1mjd9xp80vuqa select node, owner, name from syn$ where obj#=:1

2c5shu0nbp9zh INSERT INTO GJ_T_ALARM(CAR_ID, MOBIL_NO, EQUIPMENT_NO, TRACK_TIME, LONGITUDE, LATITUDE, SPEED, DIRECTION, ALARM, COMPUTER_TIME, HEIGH) VALUES ( :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , SYSDATE, :B1 )

2jfqzrxhrm93b select /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

2xwt70smzrmhw SELECT /*+NESTED_TABLE_GET_REFS+*/ "FJDXGPS"."GJ_T_VIDICONTRACK_2".* FROM "FJDXGPS"."GJ_T_VIDICONTRACK_2"

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

32bhha21dkv0v select col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc

35wjzadkfuqvm INSERT INTO CW_T_GPSERROR ( ERROR_ID , MDT_ID , GPS_TIME , IS_VALID , LONGITUDE , LATITUDE , HEIGHT , DIRECTION , SPEED , RECEIVE_TIME , ERROR_REMARK , INPUT_TIME ) VALUES( CW_S_GPSERROR.NEXTVAL, :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE )

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

3g7sxtj9d6zd3 select privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#, nvl(col#, 0)

3xzgv2bh0cxbx /* OracleOEM */ SELECT d.status "Status", d.tablespace_name "Name", d.contents "Type", d.extent_management "Extent Management", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99, 999, 990.900') "Size (M)", TO_CHAR(NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024, '99999999.999') ||'/'||TO_CHAR(NVL(a.bytes/1024/1024, 0), '99999999.999') "Used (M)", TO_CHAR(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0), '990.00') "Used %" FROM sys.dba_tablespaces d, (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) f WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND NOT (d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY') UNION ALL SELECT d.status "Status", d.tablespace_name "Name", d.contents "Type", d.extent_management "Extent Management", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99, 999, 990.900') "Size (M)", TO_CHAR(NVL(t.bytes, 0)/1024/1024, '99999999.999') ||'/'||TO_CHAR(NVL(a.bytes/1024/1024, 0), '99999999.999') "Used (M)", TO_CHAR(NVL(t.bytes / a.bytes * 100, 0), '990.00') "Used %" FROM sys.dba_tablespaces d, (select tablespace_name, sum(bytes) bytes from dba_temp_files group by tablespace_name) a, (select tablespace_name, sum(bytes_cache d) bytes from v$temp_extent_pool group by tablespace_name) t WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY'

451q2032pshqm select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

49s332uhbnsma declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;

4uurfxq566psq INSERT INTO GJ_T_ONLINE_STATUS(STATUS_TYPE, CAR_ID, MOBIL_NO, EQUIPMENT_NO, TRACK_TIME, LONGITUDE, LATITUDE, SPEED, DIRECTION, STATUS, COMPUTER_TIME, RECEIVE_TIME, ACC, MILE_SUM, STATUS_PARAM) VALUES ('0', :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, :B4 , :B3 , :B2 , :B1 )

520mkxqpf15q8 select 1 from dual

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

5apg832cgnd59 INSERT INTO GJ_T_STATUS_CHANGE(TRACK_TIME, STATUS_TYPE, PRE_VALUE, CUR_VALUE, CAR_ID, LNG, LAT, STATUS, MILEAGE, SPEED) VALUES(:B8 , '005', TO_CHAR(:B7 ), TO_CHAR(:B3 ), :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

5ngzsfstg8tmy select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1

5wc2915k44m38 select user#, type# from user$ where name=:1

6769wyy3yf66f select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

6m5hvtwhjcwun UPDATE GK_T_CARINFO SET RECEIVE_TIME = :B1 WHERE CAR_ID=:B2 AND ( (RECEIVE_TIME IS NULL) OR (RECEIVE_TIME < :B1 ))

70h58q9d0z5u8 select ROWNUM, d.dept_type, d.FATHER_DEPARTMENT prior_node, G.middle_no||'-'||G.middle_ip||':'||G.middle_port as AccessInfo, A.CAR_ANOTHER_NO as carAnotherNo, A.Car_ID as CarID, B.MDT_NO as MDTNO, A.Car_No, case when a.video_type is null then G.middle_no else a.video_type end as videoType, case when A.CAR_ANOTHER_NO is not null then a.CAR_ANOTHER_NO||'-'||A.Car_No else A.Car_No end as CarNo, A.Sim_Phone_NO as SIM, to_char(A.RECEIVE_TIME, 'YYYY-MM-DD hh24:mi:ss') as ReportTime, A.MDT_ID as MDTID, to_char(A.Last_Report_Time, 'YYYY-MM-DD hh24:mi:ss') As GPSTIME, sf_GetHeight(Trunc(A.Heigh)) as Height, To_Char(Trunc(A.Last_longitude, 6)) as Longitude, To_Char(Trunc(A.Last_latitude, 6)) as Latitude, case when A.Last_Speed is null then 0.0 else Trunc(A.Last_Speed, 1) end as Speed, sf_GetDirection(Trunc(A.Last_DirCtion)) as Direction, A.Color as Color, ' ' as Remark, A.Company_ID as CompanyID, to_Char(sf_FilterStatusID(A.Last_Status_id)) as StatusID, 0 Status2, A.Vidicon_No as VidiconNo, a.camera, a.video, G.Middle_No as MiddleNo, D.Department_name as DepartMentName, D.Connect_Phone_NO as AttnPhone, D.Cnnnect_man as Attn, A.CarType_id, E.Car_Type as CarType, sf_FilterStatusName(F.Status_name) as StatusName, A.Last_DirCtion as Direction1, trunc(a.mileage, 1) mileage, a.driver_no driver_nbr, a.last_alarm_id from GK_T_CarInfo A left join GK_T_MDTInfo B on a.mdt_id=b.mdt_id left join CL_T_User_Privilege c on a.car_id=c.car_id left join RS_T_Department D on a.company_id=d.departm ent_id left join GK_T_CarType E on a.cartype_id=e.type_id left join GJ_T_status_info F on f.status_id=a.last_status_id left join GK_T_Middle_Part G on B.Middle_ID=G.Middle_ID where(C.User_ID=84304)AND(C.SEE_REMARK='0')and(A.Delete_Flag='0') order by dept_type, prior_node, car_type, CarNo

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

8bk9w5wcukytd UPDATE GK_T_CARINFO SET LAST_LONGITUDE=:B11 , LAST_LATITUDE = :B10 , LAST_REPORT_TIME = :B1 , LAST_SPEED = :B9 , HEIGH = :B8 , LAST_DIRCTION = :B7 , LAST_STATUS_ID = :B6 , LAST_ALARM_ID = :B5 , RECEIVE_TIME = :B4 , MILEAGE = :B3 WHERE CAR_ID=:B2 AND ( (LAST_REPORT_TIME IS NULL) OR (LAST_REPORT_TIME < :B1 ))

8mrg623amm8rx select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID

8yxsjn42s9ua5 SELECT STATUS_ID AS STATUSID FROM GJ_T_STATUS_INFO WHERE STATUS_NAME=:B1

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

9z14zjbkzywfy INSERT INTO CL_T_USER_OPERATIONLOG(OPERATION_ID, USER_ID, OPERATION_DESC, OPERATION_TYPEID) VALUES(CL_S_USER_OPERATIONLOG.NEXTVAL, TO_NUMBER(:B3 ), :B2 , :B1 )

a73wbv1yu8x5c select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1

axmdf8vq7k1rh select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1

b98p5y022pun6 select distinct D.Middle_No || C.MDT_NO MDTNO from CL_T_User_Privilege A, GK_T_CarInfo B, gk_t_mdtinfo C, gk_t_middle_part D where A.USER_ID = 83333 and A.CAR_ID = B.CAR_ID and B.last_report_time >=sysdate-60 AND B.MDT_ID = C.MDT_ID AND c.middle_id = d.middle_id AND B.DELETE_FLAG = '0' and a.see_remark = '0' order by MDTNO

bqfk75b3knc9u BEGIN SP_INSERT_TRCK_LOG(:1, :2, :3); END;

bu26wuua3354u SELECT B.CAR_ID , B.SIM_PHONE_NO, A.MDT_ID, B.LAST_REPORT_TIME, B.LAST_LONGITUDE, B.LAST_LATITUDE, B.RECEIVE_TIME, B.FIRST_BACK, B.SERVICE_DATE, B.MILEAGE, B.LAST_ALARM_ID FROM GK_T_MDTINFO A, GK_T_CARINFO B , GK_T_MIDDLE_PART C WHERE C.MIDDLE_NO = :B2 AND A.MDT_NO = :B1 AND C.MIDDLE_ID = A.MIDDLE_ID AND A.MDT_ID = B.MDT_ID AND B.DELETE_FLAG = '0' AND ROWNUM = 1

d2t1z75cp894w select A.EMPLOYEE_DEPARTMENT, A.User_ID, A.Is_Valid, B.DEPARTMENT_NAME, c.log_remark, B.CONNECT_PHONE_NO, A.BIND_MACHINE from rs_t_employee A, RS_T_Department B, (select * from SF_T_department_stop_log where SF_T_department_stop_log.Log_Remark = 1) C where A.EMPLOYEE_NO = 'gstsdx' and A.USER_PASSWORD= 'cldwyyzx' AND A.EMPLOYEE_DEPARTMENT=B.DEPARTMENT_ID and a.employee_department = c.log_department(+)

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

f3g84j69n0tjh select col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc

f8pavn1bvsj7t select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1

g3wrkmxkxzhf2 select cols, audit$, textlength, intcols, property, flags, rowid from view$ where obj#=:1

gx95dv43tmzhm begin SP_EXEC_OPERATION(:V00001, :V00002, :V00003); end;

SQL Id	SQL Text
0dygnuq0gp9vw	UPDATE GK_T_CARINFO SET LAST_LONGITUDE=:B11 , LAST_LATITUDE = :B10 , LAST_REPORT_TIME = :B1 , LAST_SPEED = :B9 , HEIGH = :B8 , LAST_DIRCTION = :B7 , LAST_STATUS_ID = :B6 , LAST_ALARM_ID = :B5 , RECEIVE_TIME = :B4 , MILEAGE = :B3 , ACC_OPEN_TIME = :B1 WHERE CAR_ID=:B2 AND ( (LAST_REPORT_TIME IS NULL) OR (LAST_REPORT_TIME < :B1 ))
0fr8zhn4ymu3v	select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1mjd9xp80vuqa	select node, owner, name from syn$ where obj#=:1
2c5shu0nbp9zh	INSERT INTO GJ_T_ALARM(CAR_ID, MOBIL_NO, EQUIPMENT_NO, TRACK_TIME, LONGITUDE, LATITUDE, SPEED, DIRECTION, ALARM, COMPUTER_TIME, HEIGH) VALUES ( :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , SYSDATE, :B1 )
2jfqzrxhrm93b	select /+ rule / c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2xwt70smzrmhw	SELECT /+NESTED_TABLE_GET_REFS+/ "FJDXGPS"."GJ_T_VIDICONTRACK_2".* FROM "FJDXGPS"."GJ_T_VIDICONTRACK_2"
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
32bhha21dkv0v	select col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc
35wjzadkfuqvm	INSERT INTO CW_T_GPSERROR ( ERROR_ID , MDT_ID , GPS_TIME , IS_VALID , LONGITUDE , LATITUDE , HEIGHT , DIRECTION , SPEED , RECEIVE_TIME , ERROR_REMARK , INPUT_TIME ) VALUES( CW_S_GPSERROR.NEXTVAL, :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE )
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3g7sxtj9d6zd3	select privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#, nvl(col#, 0)
3xzgv2bh0cxbx	/* OracleOEM / SELECT d.status "Status", d.tablespace_name "Name", d.contents "Type", d.extent_management "Extent Management", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99, 999, 990.900') "Size (M)", TO_CHAR(NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024, '99999999.999') \|\|'/'\|\|TO_CHAR(NVL(a.bytes/1024/1024, 0), '99999999.999') "Used (M)", TO_CHAR(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes 100, 0), '990.00') "Used %" FROM sys.dba_tablespaces d, (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) f WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND NOT (d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY') UNION ALL SELECT d.status "Status", d.tablespace_name "Name", d.contents "Type", d.extent_management "Extent Management", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99, 999, 990.900') "Size (M)", TO_CHAR(NVL(t.bytes, 0)/1024/1024, '99999999.999') \|\|'/'\|\|TO_CHAR(NVL(a.bytes/1024/1024, 0), '99999999.999') "Used (M)", TO_CHAR(NVL(t.bytes / a.bytes * 100, 0), '990.00') "Used %" FROM sys.dba_tablespaces d, (select tablespace_name, sum(bytes) bytes from dba_temp_files group by tablespace_name) a, (select tablespace_name, sum(bytes_cache d) bytes from v$temp_extent_pool group by tablespace_name) t WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY'
451q2032pshqm	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
49s332uhbnsma	declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) \|\| substr(vsn, 4, 2) \|\| substr(vsn, 7, 2) \|\| nvl(substr(vsn, 10, 2), '00')); end if; end;
4uurfxq566psq	INSERT INTO GJ_T_ONLINE_STATUS(STATUS_TYPE, CAR_ID, MOBIL_NO, EQUIPMENT_NO, TRACK_TIME, LONGITUDE, LATITUDE, SPEED, DIRECTION, STATUS, COMPUTER_TIME, RECEIVE_TIME, ACC, MILE_SUM, STATUS_PARAM) VALUES ('0', :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, :B4 , :B3 , :B2 , :B1 )
520mkxqpf15q8	select 1 from dual
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5apg832cgnd59	INSERT INTO GJ_T_STATUS_CHANGE(TRACK_TIME, STATUS_TYPE, PRE_VALUE, CUR_VALUE, CAR_ID, LNG, LAT, STATUS, MILEAGE, SPEED) VALUES(:B8 , '005', TO_CHAR(:B7 ), TO_CHAR(:B3 ), :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5ngzsfstg8tmy	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
5wc2915k44m38	select user#, type# from user$ where name=:1
6769wyy3yf66f	select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6m5hvtwhjcwun	UPDATE GK_T_CARINFO SET RECEIVE_TIME = :B1 WHERE CAR_ID=:B2 AND ( (RECEIVE_TIME IS NULL) OR (RECEIVE_TIME < :B1 ))
70h58q9d0z5u8	select ROWNUM, d.dept_type, d.FATHER_DEPARTMENT prior_node, G.middle_no\|\|'-'\|\|G.middle_ip\|\|':'\|\|G.middle_port as AccessInfo, A.CAR_ANOTHER_NO as carAnotherNo, A.Car_ID as CarID, B.MDT_NO as MDTNO, A.Car_No, case when a.video_type is null then G.middle_no else a.video_type end as videoType, case when A.CAR_ANOTHER_NO is not null then a.CAR_ANOTHER_NO\|\|'-'\|\|A.Car_No else A.Car_No end as CarNo, A.Sim_Phone_NO as SIM, to_char(A.RECEIVE_TIME, 'YYYY-MM-DD hh24:mi:ss') as ReportTime, A.MDT_ID as MDTID, to_char(A.Last_Report_Time, 'YYYY-MM-DD hh24:mi:ss') As GPSTIME, sf_GetHeight(Trunc(A.Heigh)) as Height, To_Char(Trunc(A.Last_longitude, 6)) as Longitude, To_Char(Trunc(A.Last_latitude, 6)) as Latitude, case when A.Last_Speed is null then 0.0 else Trunc(A.Last_Speed, 1) end as Speed, sf_GetDirection(Trunc(A.Last_DirCtion)) as Direction, A.Color as Color, ' ' as Remark, A.Company_ID as CompanyID, to_Char(sf_FilterStatusID(A.Last_Status_id)) as StatusID, 0 Status2, A.Vidicon_No as VidiconNo, a.camera, a.video, G.Middle_No as MiddleNo, D.Department_name as DepartMentName, D.Connect_Phone_NO as AttnPhone, D.Cnnnect_man as Attn, A.CarType_id, E.Car_Type as CarType, sf_FilterStatusName(F.Status_name) as StatusName, A.Last_DirCtion as Direction1, trunc(a.mileage, 1) mileage, a.driver_no driver_nbr, a.last_alarm_id from GK_T_CarInfo A left join GK_T_MDTInfo B on a.mdt_id=b.mdt_id left join CL_T_User_Privilege c on a.car_id=c.car_id left join RS_T_Department D on a.company_id=d.departm ent_id left join GK_T_CarType E on a.cartype_id=e.type_id left join GJ_T_status_info F on f.status_id=a.last_status_id left join GK_T_Middle_Part G on B.Middle_ID=G.Middle_ID where(C.User_ID=84304)AND(C.SEE_REMARK='0')and(A.Delete_Flag='0') order by dept_type, prior_node, car_type, CarNo
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8bk9w5wcukytd	UPDATE GK_T_CARINFO SET LAST_LONGITUDE=:B11 , LAST_LATITUDE = :B10 , LAST_REPORT_TIME = :B1 , LAST_SPEED = :B9 , HEIGH = :B8 , LAST_DIRCTION = :B7 , LAST_STATUS_ID = :B6 , LAST_ALARM_ID = :B5 , RECEIVE_TIME = :B4 , MILEAGE = :B3 WHERE CAR_ID=:B2 AND ( (LAST_REPORT_TIME IS NULL) OR (LAST_REPORT_TIME < :B1 ))
8mrg623amm8rx	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
8yxsjn42s9ua5	SELECT STATUS_ID AS STATUSID FROM GJ_T_STATUS_INFO WHERE STATUS_NAME=:B1
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9z14zjbkzywfy	INSERT INTO CL_T_USER_OPERATIONLOG(OPERATION_ID, USER_ID, OPERATION_DESC, OPERATION_TYPEID) VALUES(CL_S_USER_OPERATIONLOG.NEXTVAL, TO_NUMBER(:B3 ), :B2 , :B1 )
a73wbv1yu8x5c	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b98p5y022pun6	select distinct D.Middle_No \|\| C.MDT_NO MDTNO from CL_T_User_Privilege A, GK_T_CarInfo B, gk_t_mdtinfo C, gk_t_middle_part D where A.USER_ID = 83333 and A.CAR_ID = B.CAR_ID and B.last_report_time >=sysdate-60 AND B.MDT_ID = C.MDT_ID AND c.middle_id = d.middle_id AND B.DELETE_FLAG = '0' and a.see_remark = '0' order by MDTNO
bqfk75b3knc9u	BEGIN SP_INSERT_TRCK_LOG(:1, :2, :3); END;
bu26wuua3354u	SELECT B.CAR_ID , B.SIM_PHONE_NO, A.MDT_ID, B.LAST_REPORT_TIME, B.LAST_LONGITUDE, B.LAST_LATITUDE, B.RECEIVE_TIME, B.FIRST_BACK, B.SERVICE_DATE, B.MILEAGE, B.LAST_ALARM_ID FROM GK_T_MDTINFO A, GK_T_CARINFO B , GK_T_MIDDLE_PART C WHERE C.MIDDLE_NO = :B2 AND A.MDT_NO = :B1 AND C.MIDDLE_ID = A.MIDDLE_ID AND A.MDT_ID = B.MDT_ID AND B.DELETE_FLAG = '0' AND ROWNUM = 1
d2t1z75cp894w	select A.EMPLOYEE_DEPARTMENT, A.User_ID, A.Is_Valid, B.DEPARTMENT_NAME, c.log_remark, B.CONNECT_PHONE_NO, A.BIND_MACHINE from rs_t_employee A, RS_T_Department B, (select * from SF_T_department_stop_log where SF_T_department_stop_log.Log_Remark = 1) C where A.EMPLOYEE_NO = 'gstsdx' and A.USER_PASSWORD= 'cldwyyzx' AND A.EMPLOYEE_DEPARTMENT=B.DEPARTMENT_ID and a.employee_department = c.log_department(+)
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
f3g84j69n0tjh	select col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc
f8pavn1bvsj7t	select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
g3wrkmxkxzhf2	select cols, audit$, textlength, intcols, property, flags, rowid from view$ where obj#=:1
gx95dv43tmzhm	begin SP_EXEC_OPERATION(:V00001, :V00002, :V00003); end;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	154,421	42.86	0.58
CPU used when call started	153,979	42.74	0.57
CR blocks created	5,105	1.42	0.02
Cached Commit SCN referenced	533	0.15	0.00
Commit SCN cached	1	0.00	0.00
DB time	560,732	155.65	2.09
DBWR checkpoint buffers written	220,385	61.18	0.82
DBWR checkpoints	2	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	119	0.03	0.00
DBWR undo block writes	170,197	47.24	0.63
IMU CR rollbacks	542	0.15	0.00
IMU Flushes	171,571	47.63	0.64
IMU Redo allocation size	197,085,000	54,707.42	734.00
IMU commits	247,602	68.73	0.92
IMU contention	50	0.01	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	4,470	1.24	0.02
IMU recursive-transaction flush	11	0.00	0.00
IMU undo allocation size	1,239,798,120	344,146.70	4,617.34
IMU- failed to get a private strand	4,470	1.24	0.02
Misses for writing mapping	0	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	3,543	0.98	0.01
RowCR hits	3,676	1.02	0.01
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	4,023,743	1,116.92	14.99
active txn count during cleanout	468	0.13	0.00
application wait time	4	0.00	0.00
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	11,486	3.19	0.04
branch node splits	16	0.00	0.00
buffer is not pinned count	5,289,216	1,468.20	19.70
buffer is pinned count	1,161,419	322.39	4.33
bytes received via SQL*Net from client	628,690,517	174,513.71	2,341.41
bytes sent via SQL*Net to client	7,040,882,118	1,954,428.15	26,222.15
calls to get snapshot scn: kcmgss	6,846,338	1,900.43	25.50
calls to kcmgas	513,294	142.48	1.91
calls to kcmgcs	1,432	0.40	0.01
change write time	2,919	0.81	0.01
cleanout - number of ktugct calls	10,221	2.84	0.04
cleanouts and rollbacks - consistent read gets	390	0.11	0.00
cleanouts only - consistent read gets	21	0.01	0.00
cluster key scan block gets	232,400	64.51	0.87
cluster key scans	212,941	59.11	0.79
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	155,135	43.06	0.58
commit batch/immediate requested	155,135	43.06	0.58
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	17	0.00	0.00
commit cleanout failures: cannot pin	16	0.00	0.00
commit cleanouts	1,072,536	297.72	3.99
commit cleanouts successfully completed	1,072,503	297.71	3.99
commit immediate performed	155,135	43.06	0.58
commit immediate requested	155,135	43.06	0.58
commit txn count during cleanout	218,543	60.66	0.81
concurrency wait time	163	0.05	0.00
consistent changes	6,346	1.76	0.02
consistent gets	12,092,291	3,356.61	45.03
consistent gets - examination	5,295,894	1,470.05	19.72
consistent gets direct	937,665	260.28	3.49
consistent gets from cache	11,154,626	3,096.33	41.54
current blocks converted for CR	0	0.00	0.00
cursor authentications	9,659	2.68	0.04
data blocks consistent reads - undo records applied	6,043	1.68	0.02
db block changes	3,764,866	1,045.06	14.02
db block gets	5,786,229	1,606.16	21.55
db block gets direct	10,518	2.92	0.04
db block gets from cache	5,775,711	1,603.24	21.51
deferred (CURRENT) block cleanout applications	662,505	183.90	2.47
dirty buffers inspected	0	0.00	0.00
enqueue conversions	732	0.20	0.00
enqueue releases	1,713,046	475.51	6.38
enqueue requests	1,713,048	475.51	6.38
enqueue timeouts	0	0.00	0.00
enqueue waits	6	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	1,999,691	555.08	7.45
failed probes on index block reclamation	1	0.00	0.00
free buffer inspected	15,215	4.22	0.06
free buffer requested	198,627	55.14	0.74
global undo segment hints helped	0	0.00	0.00
heap block compress	51,848	14.39	0.19
hot buffers moved to head of LRU	202	0.06	0.00
immediate (CR) block cleanout applications	411	0.11	0.00
immediate (CURRENT) block cleanout applications	11,422	3.17	0.04
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	6,034	1.67	0.02
index fast full scans (full)	7,347	2.04	0.03
index fetch by key	2,057,265	571.06	7.66
index scans kdiixs1	620,493	172.24	2.31
leaf node 90-10 splits	241	0.07	0.00
leaf node splits	3,778	1.05	0.01
lob reads	749,734	208.11	2.79
lob writes	4,623	1.28	0.02
lob writes unaligned	75	0.02	0.00
logons cumulative	43	0.01	0.00
messages received	472,097	131.05	1.76
messages sent	472,097	131.05	1.76
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	5,153,716	1,430.58	19.19
opened cursors cumulative	300,564	83.43	1.12
parse count (failures)	78	0.02	0.00
parse count (hard)	410,578	113.97	1.53
parse count (total)	634,905	176.24	2.36
parse time cpu	20,179	5.60	0.08
parse time elapsed	19,862	5.51	0.07
physical read IO requests	936,410	259.93	3.49
physical read bytes	7,841,562,624	2,176,683.32	29,204.10
physical read total IO requests	938,836	260.60	3.50
physical read total bytes	7,880,690,688	2,187,544.60	29,349.82
physical read total multi block requests	4,664	1.29	0.02
physical reads	957,222	265.71	3.56
physical reads cache	22,701	6.30	0.08
physical reads cache prefetch	17,334	4.81	0.06
physical reads direct	934,521	259.41	3.48
physical reads direct (lob)	929,975	258.15	3.46
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	58,885	16.35	0.22
physical write bytes	1,891,557,376	525,063.89	7,044.67
physical write total IO requests	909,833	252.55	3.39
physical write total bytes	3,689,022,464	1,024,009.38	13,738.92
physical write total multi block requests	859,798	238.67	3.20
physical writes	230,903	64.09	0.86
physical writes direct	10,518	2.92	0.04
physical writes direct (lob)	10,498	2.91	0.04
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	220,385	61.18	0.82
physical writes non checkpoint	191,706	53.21	0.71
pinned buffers inspected	0	0.00	0.00
pinned cursors current	5	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	4,404	1.22	0.02
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	4,969,217	1,379.37	18.51
recursive cpu usage	83,253	23.11	0.31
redo blocks written	1,700,343	471.99	6.33
redo buffer allocation retries	5	0.00	0.00
redo entries	963,073	267.33	3.59
redo log space requests	5	0.00	0.00
redo log space wait time	15	0.00	0.00
redo ordering marks	73,861	20.50	0.28
redo size	725,795,136	201,468.28	2,703.06
redo subscn max counts	86,782	24.09	0.32
redo synch time	132,942	36.90	0.50
redo synch writes	423,631	117.59	1.58
redo wastage	117,499,872	32,615.95	437.60
redo write time	128,384	35.64	0.48
redo writer latching time	3	0.00	0.00
redo writes	423,572	117.58	1.58
rollback changes - undo records applied	157,936	43.84	0.59
rollbacks only - consistent read gets	4,676	1.30	0.02
root node splits	0	0.00	0.00
rows fetched via callback	1,471,270	408.40	5.48
session connect time	0	0.00	0.00
session cursor cache hits	271,716	75.42	1.01
session logical reads	17,878,518	4,962.77	66.58
shared hash latch upgrades - no wait	12,070	3.35	0.04
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	129,795	36.03	0.48
sorts (rows)	11,439,242	3,175.34	42.60
sql area evicted	412,898	114.61	1.54
sql area purged	78	0.02	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	72	0.02	0.00
table fetch by rowid	2,332,562	647.48	8.69
table fetch continued row	5,953	1.65	0.02
table scan blocks gotten	3,567,366	990.24	13.29
table scan rows gotten	274,128,492	76,093.37	1,020.93
table scans (long tables)	1	0.00	0.00
table scans (short tables)	64,731	17.97	0.24
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	155,135	43.06	0.58
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	195,144,676	54,168.82	726.77
user I/O wait time	86,133	23.91	0.32
user calls	4,048,627	1,123.83	15.08
user commits	268,500	74.53	1.00
user rollbacks	9	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	91,301	25.34	0.34
write clones created in background	0	0.00	0.00
write clones created in foreground	110	0.03	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 pga memory max	13,644,704,704	13,651,941,536
session cursor cache count	1,759,353	1,761,615
session uga memory	1.5E+13	1.5E+13
opened cursors current	357	367
workarea memory allocated	102	102
logons current	94	94
session uga memory max	1.0E+11	1.0E+11
session pga memory	6,645,454,528	6,652,098,848

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	2	2.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	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
FJSATCOMNOR	934,260	259	2.01	1.02	23,003	6	32	4.06
FJSATCOM_TRCK_IDX	1,410	0	65.55	1.00	23,799	7	5	0.00
UNDOTBS1	1	0	20.00	1.00	11,317	3	7	0.00
FJSATCOM_OTHER_IDX	75	0	25.73	1.00	448	0	0	0.00
SYSAUX	29	0	22.07	1.00	203	0	0	0.00
SYSTEM	78	0	19.49	1.00	92	0	0	0.00
USERS	2	0	10.00	1.00	0	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	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
FJSATCOMNOR	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOMNOR.dbf	106,317	30	1.60	1.06	1,474	0	31	0.00
FJSATCOMNOR	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOMNOR1.dbf	147,674	41	1.63	1.02	414	0	0	0.00
FJSATCOMNOR	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOMNOR2.dbf	164,647	46	2.49	1.05	7,530	2	1	130.00
FJSATCOMNOR	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOMNOR3.dbf	180,744	50	2.22	1.01	7,043	2	0	0.00
FJSATCOMNOR	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOMNOR4.dbf	168,235	47	1.93	1.00	2,372	1	0	0.00
FJSATCOMNOR	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOMNOR5.dbf	166,643	46	2.00	1.00	4,170	1	0	0.00
FJSATCOM_OTHER_IDX	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOM_OTHER_IDX.dbf	52	0	12.31	1.00	359	0	0	0.00
FJSATCOM_OTHER_IDX	/u01/app/oracle/oradata/GSDXGPS/datafile/fjsatcom_other_idx1.dbf	23	0	56.09	1.00	89	0	0	0.00
FJSATCOM_TRCK_IDX	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOM_TRCK_IDX.dbf	314	0	65.19	1.00	6,159	2	2	0.00
FJSATCOM_TRCK_IDX	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOM_TRCK_IDX1.dbf	429	0	65.17	1.00	5,625	2	0	0.00
FJSATCOM_TRCK_IDX	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOM_TRCK_IDX2.dbf	317	0	66.97	1.00	6,147	2	2	0.00
FJSATCOM_TRCK_IDX	/u01/app/oracle/oradata/GSDXGPS/datafile/FJSATCOM_TRCK_IDX3.dbf	350	0	65.03	1.00	5,868	2	1	0.00
SYSAUX	/u01/app/oracle/oradata/GSDXGPS/datafile/o1_mf_sysaux_9874kr1x_.dbf	29	0	22.07	1.00	203	0	0	0.00
SYSTEM	/u01/app/oracle/oradata/GSDXGPS/datafile/o1_mf_system_9874jrtx_.dbf	78	0	19.49	1.00	92	0	0	0.00
UNDOTBS1	/u01/app/oracle/oradata/GSDXGPS/datafile/o1_mf_undotbs1_9874kpw7_.dbf	1	0	20.00	1.00	11,317	3	7	0.00
USERS	/u01/app/oracle/oradata/GSDXGPS/datafile/o1_mf_users_9874kwwc_.dbf	2	0	10.00	1.00	0	0	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	883,445	100	16,929,093	22,698	220,355	0	0	44

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	28	17627	145550	812714	1887390	812714
E	0	23	13388	127075	819010	1887390	819010

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	704	0.10	87,076	1.27	182,676,943
D	1,408	0.20	174,152	1.23	176,832,172
D	2,112	0.29	261,228	1.19	171,829,485
D	2,816	0.39	348,304	1.16	167,325,172
D	3,520	0.49	435,380	1.13	163,170,834
D	4,224	0.59	522,456	1.10	159,226,829
D	4,928	0.69	609,532	1.08	155,459,529
D	5,632	0.79	696,608	1.05	151,789,514
D	6,336	0.88	783,684	1.03	148,206,183
D	7,040	0.98	870,760	1.00	144,718,387
D	7,168	1.00	886,592	1.00	144,108,266
D	7,744	1.08	957,836	0.98	141,362,613
D	8,448	1.18	1,044,912	0.96	138,264,152
D	9,152	1.28	1,131,988	0.94	135,148,112
D	9,856	1.38	1,219,064	0.92	132,223,620
D	10,560	1.47	1,306,140	0.90	129,434,789
D	11,264	1.57	1,393,216	0.88	126,744,667
D	11,968	1.67	1,480,292	0.86	124,143,596
D	12,672	1.77	1,567,368	0.84	121,706,806
D	13,376	1.87	1,654,444	0.83	119,320,910
D	14,080	1.96	1,741,520	0.81	116,935,575

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	12,306	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	2,048	1,748	232.17	0.10	0.04	100.00	0.00	209,710
E	2,048	1,746	233.52	0.10	0.04	100.00	0.00	209,710

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	75,852	75,852
64K	128K	94	94
128K	256K	7,279	7,279
256K	512K	8	8
512K	1024K	399	399
1M	2M	7,669	7,669

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
256	0.13	1,843,511.01	153,948.63	92.00	8
512	0.25	1,843,511.01	60,083.50	97.00	2
1,024	0.50	1,843,511.01	48,387.64	97.00	2
1,536	0.75	1,843,511.01	48,387.64	97.00	0
2,048	1.00	1,843,511.01	48,179.74	97.00	0
2,458	1.20	1,843,511.01	4,836.88	100.00	0
2,867	1.40	1,843,511.01	4,836.88	100.00	0
3,277	1.60	1,843,511.01	4,836.88	100.00	0
3,686	1.80	1,843,511.01	4,836.88	100.00	0
4,096	2.00	1,843,511.01	4,836.88	100.00	0
6,144	3.00	1,843,511.01	4,836.88	100.00	0
8,192	4.00	1,843,511.01	4,836.88	100.00	0
12,288	6.00	1,843,511.01	4,836.88	100.00	0
16,384	8.00	1,843,511.01	4,836.88	100.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
416	0.43	128	11,966	20,020,966	1.00	329,801	1.14	1,824,194
528	0.54	239	19,701	20,030,221	1.00	320,546	1.11	1,827,180
640	0.66	350	26,930	20,038,909	1.00	311,858	1.08	1,830,009
752	0.77	461	33,678	20,046,990	1.00	303,777	1.05	1,832,659
864	0.89	572	40,801	20,054,452	1.00	296,315	1.02	1,835,113
976	1.00	683	48,515	20,061,233	1.00	289,534	1.00	1,837,350
1,088	1.11	794	56,305	20,067,357	1.00	283,410	0.98	1,839,375
1,200	1.23	905	64,085	20,072,941	1.00	277,826	0.96	1,841,225
1,312	1.34	1,016	71,879	20,078,078	1.00	272,689	0.94	1,842,928
1,424	1.46	1,127	79,638	20,082,812	1.00	267,955	0.93	1,844,498
1,536	1.57	1,238	87,436	20,087,171	1.00	263,596	0.91	1,845,944
1,648	1.69	1,349	95,226	20,091,181	1.00	259,586	0.90	1,847,272
1,760	1.80	1,460	103,045	20,094,892	1.00	255,875	0.88	1,848,502
1,872	1.92	1,571	110,633	20,098,394	1.00	252,373	0.87	1,849,661
1,984	2.03	1,682	118,276	20,101,770	1.00	248,997	0.86	1,850,779

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,048	0.25	2,572,580	181,907,636
4,096	0.50	2,482,100	166,617,768
6,144	0.75	2,410,373	158,562,126
8,192	1.00	2,344,036	144,108,085
10,240	1.25	2,286,842	137,680,864
12,288	1.50	2,234,805	128,890,271
14,336	1.75	2,229,414	121,194,899
16,384	2.00	2,229,414	116,439,333

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	Avg Time (ms)
data block	37	4
undo header	5	0
undo block	2	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)
TX-Transaction (index contention)	6	6	0	6	0	31.67

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	185.57	487,888	19,512	5	70.1/340.2	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
21-Jan 16:08	25,173	66,299	19,512	5	340	0/0	0/0/0/0/0/0
21-Jan 15:58	14,687	45,590	18,911	4	330	0/0	0/0/0/0/0/0
21-Jan 15:48	34,917	87,866	5,708	5	110	0/0	0/0/0/0/0/0
21-Jan 15:38	24,469	64,791	5,107	4	100	0/0	0/0/0/0/0/0
21-Jan 15:28	34,664	85,963	4,506	4	90	0/0	0/0/0/0/0/0
21-Jan 15:18	25,255	67,253	3,905	5	80	0/0	0/0/0/0/0/0
21-Jan 15:08	26,406	70,126	3,304	4	70	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
ASM db client latch	2,400	0.00		0	0
AWR Alerted Metric Element list	17,458	0.00		0	0
Consistent RBA	423,507	0.00		0	0
FIB s.o chain latch	4	0.00		0	0
FOB s.o list latch	478	0.00		0	0
In memory undo latch	3,064,518	0.00	0.59	0	424,359	0.00
JS mem alloc latch	6	0.00		0	0
JS queue access latch	6	0.00		0	0
JS queue state obj latch	26,026	0.00		0	0
KMG MMAN ready and startup request latch	1,201	0.00		0	0
KMG resize request state object freelist	2	0.00		0	0
KTF sga latch	7	0.00		0	1,208	0.00
KWQMN job cache list latch	1	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	20	0.00		0	1,201	0.00
OS process	183	0.00		0	0
OS process allocation	1,322	0.00		0	0
OS process: request allocation	82	0.00		0	0
PL/SQL warning settings	14,723	0.00		0	0
SQL memory manager latch	1	0.00		0	1,199	0.00
SQL memory manager workarea list latch	125,420	0.00		0	0
Shared B-Tree	129	0.00		0	0
active checkpoint queue latch	49,256	0.00		0	0
active service list	7,585	0.00		0	3,704	0.00
archive control	8	0.00		0	0
begin backup scn array	10,473	0.00		0	0
buffer pool	208	0.00		0	0
cache buffer handles	9,538	0.00		0	0
cache buffers chains	41,855,372	0.00	0.07	0	222,870	0.00
cache buffers lru chain	446,888	0.01	0.06	0	204,869	0.01
cache table scan latch	0			0	1,189	0.00
channel handle pool latch	82	0.00		0	0
channel operations parent latch	16,982	0.00		0	0
checkpoint queue latch	855,054	0.00	0.11	0	212,812	0.00
client/application info	200	0.00		0	0
compile environment latch	43	0.00		0	0
dml lock allocation	1,679,639	0.01	0.03	0	0
dummy allocation	86	0.00		0	0
enqueue hash chains	3,426,342	0.00	0.09	0	0
enqueues	1,069,817	0.01	0.00	0	0
event group latch	41	0.00		0	0
file cache latch	322	0.00		0	0
global KZLD latch for mem in SGA	32	0.00		0	0
hash table column usage latch	959	0.00		0	598,012	0.00
hash table modification latch	79	0.00		0	0
internal temp table object number allocation latc	18	0.00		0	0
job workq parent latch	0			0	4	0.00
job_queue_processes parameter latch	62	0.00		0	0
kks stats	2,920,611	0.00	0.00	0	0
kokc descriptor allocation latch	42	0.00		0	0
ksuosstats global area	242	0.00		0	0
ktm global data	12	0.00		0	0
kwqbsn:qsga	129	0.00		0	0
lgwr LWN SCN	423,588	0.00		0	0
library cache	15,321,136	0.01	0.03	0	2,022,486	0.06
library cache load lock	9,996	0.00		0	0
library cache lock	7,665,437	0.00	0.00	0	0
library cache lock allocation	3,408	0.00		0	0
library cache pin	5,058,927	0.00	0.00	0	0
library cache pin allocation	456	0.00		0	0
list of block allocation	479	0.00		0	0
loader state object freelist	1,534,105	0.00	0.09	0	0
longop free list parent	1,152	0.00		0	1	0.00
messages	1,405,298	0.01	0.00	0	0
mostly latch-free SCN	423,837	0.00	0.00	0	0
multiblock read objects	2,418	0.00		0	0
ncodef allocation latch	60	0.00		0	0
object queue header heap	110	0.00		0	0
object queue header operation	873,015	0.00	0.00	0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	480	0.00		0	0
parameter list	510	0.00		0	0
parameter table management	90	0.00		0	0
post/wait queue	641,327	0.00	0.00	0	423,585	0.00
process allocation	82	0.00		0	41	0.00
process group creation	82	0.00		0	0
qmn task queue latch	516	0.00		0	0
redo allocation	2,116,318	0.00	0.03	0	963,056	0.01
redo copy	0			0	963,092	0.03
redo writing	1,322,465	0.00	0.00	0	0
resmgr group change latch	36	0.00		0	0
resmgr:active threads	71	0.00		0	0
resmgr:actses change group	32	0.00		0	0
resmgr:free threads list	70	0.00		0	0
resmgr:resource group CPU method	31	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	13,126,181	0.01	0.00	0	13,625	0.03
sequence cache	45,761	0.00	0.00	0	0
session allocation	374,670	0.00	0.00	0	0
session idle bit	8,280,355	0.00	0.00	0	0
session state list latch	53	0.00		0	0
session switching	265	0.00		0	0
session timer	1,259	0.00		0	0
shared pool	17,415,319	0.03	0.16	1	0
shared pool simulator	2,831,107	0.00	0.17	0	0
simulator hash latch	1,283,120	0.00	0.00	0	0
simulator lru latch	220,362	0.02	0.09	0	1,042,343	0.02
slave class	8	0.00		0	0
slave class create	32	3.13	1.00	0	0
sort extent pool	92	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
threshold alerts latch	167	0.00		0	0
transaction allocation	491	0.00		0	0
transaction branch allocation	1,259	0.00		0	0
undo global data	2,512,634	0.00	0.50	0	0
user lock	122	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
shared pool	17,415,319	4,397	698	3,725
library cache	15,321,136	1,753	59	1,697
cache buffers chains	41,855,372	353	26	327
dml lock allocation	1,679,639	92	3	89
redo allocation	2,116,318	73	2	71
In memory undo latch	3,064,518	46	27	19
enqueue hash chains	3,426,342	35	3	32
simulator lru latch	220,362	34	3	31
cache buffers lru chain	446,888	31	2	29
shared pool simulator	2,831,107	12	2	10
loader state object freelist	1,534,105	11	1	10
checkpoint queue latch	855,054	9	1	8
undo global data	2,512,634	2	1	1
slave class create	32	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
In memory undo latch	kticmt: child	24	2
In memory undo latch	ktiFlush: child	4	3
In memory undo latch	ktichg: child	1	1
cache buffers chains	kcbgtcr: kslbegin excl	21	0
cache buffers chains	kcbgcur: kslbegin	13	1
cache buffers chains	kcbgtcr: fast path	5	1
cache buffers chains	kcbchg: kslbegin: bufs not pinned	2	9
cache buffers chains	kcbnew: new latch again	1	0
cache buffers lru chain	kcbzgws	2	0
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	1	0
dml lock allocation	ktaiam	2	0
dml lock allocation	ktaidm	1	3
enqueue hash chains	ksqrcl	3	3
library cache	kglpndl: child: after processing	3	1
library cache	kglukp: child	3	0
library cache	kgldti: 2child	1	1
library cache	kglhdgn: child:	1	1
library cache	kglobld	1	0
library cache	kglobpn: child:	1	5
library cache	kglpndl: child: before processing	1	23
library cache lock	kgllkdl: child: no lock handle	8	6
loader state object freelist	kcblfs	1	0
object queue header operation	kcbo_switch_cq	2	0
object queue header operation	kcbw_unlink_q	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	2	0
shared pool	kghalo	532	311
shared pool	kghupr1	91	229
shared pool	kghfrunp: alloc: wait	50	0
shared pool	kghfrunp: clatch: nowait	38	0
shared pool	kghalp	8	118
shared pool	kgh_next_free	6	0
shared pool	kghasp	4	17
shared pool	kgh: quiesce extents	3	0
shared pool	kgh: sim resz update	2	0
shared pool	kghfrunp: clatch: wait	2	8
shared pool	kgh: add extent to quiesced list	1	0
shared pool	kghfre	1	22
shared pool simulator	kglsim_unpin_simhp	2	1
simulator lru latch	kcbs_simulate: simulate set	3	0
slave class create	ksvcreate	1	0
undo global data	ktusm_begin_fu	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 Logical Reads

Total Logical Reads: 17,878,518
Captured Segments account for 67.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
FJDXGPS	FJSATCOMNOR	GK_T_CARINFO	TABLE	1,805,184	10.10
FJDXGPS	FJSATCOMNOR	CL_T_USER_PRIVILEGE	TABLE	922,064	5.16
FJDXGPS	FJSATCOM_OTHER_IDX	GK_I_MDTINFO	INDEX	841,584	4.71
FJDXGPS	FJSATCOM_OTHER_IDX	CAR_INFO_MDT_ID	INDEX	834,368	4.67
FJDXGPS	FJSATCOM_OTHER_IDX	SYS_C0011609	INDEX	816,480	4.57

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 957,222
Captured Segments account for 99.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
FJDXGPS	FJSATCOMNOR	SYS_LOB0000053815C00015$$	LOB	762,143	79.62
FJDXGPS	FJSATCOMNOR	SYS_LOB0000053819C00015$$	LOB	163,815	17.11
FJDXGPS	FJSATCOMNOR	GJ_T_VIDICONTRACK_1	TABLE	13,216	1.38
FJDXGPS	FJSATCOMNOR	GJ_T_VIDICONTRACK_2	TABLE	5,285	0.55
FJDXGPS	FJSATCOMNOR	SYS_LOB0000053811C00015$$	LOB	620	0.06

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
FJDXGPS	FJSATCOM_TRCK_IDX	IND_TRACK_TIME_29	INDEX	2	25.00
FJDXGPS	FJSATCOM_TRCK_IDX	IND_TRACK_TIME_57	INDEX	2	25.00
FJDXGPS	FJSATCOM_TRCK_IDX	IND_TRACK_TIME_84	INDEX	2	25.00
FJDXGPS	FJSATCOM_OTHER_IDX	SYS_C0011981	INDEX	1	12.50
FJDXGPS	FJSATCOM_OTHER_IDX	SYS_C0011996	INDEX	1	12.50

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

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
FJDXGPS	FJSATCOMNOR	GK_T_CARINFO	TABLE	31	86.11
FJDXGPS	FJSATCOM_TRCK_IDX	IND_TRACK_TIME_62	INDEX	2	5.56
FJDXGPS	FJSATCOM_TRCK_IDX	IND_TRACK_TIME_29	INDEX	1	2.78
FJDXGPS	FJSATCOM_TRCK_IDX	IND_TRACK_TIME_57	INDEX	1	2.78
FJDXGPS	FJSATCOM_TRCK_IDX	IND_TRACK_TIME_84	INDEX	1	2.78

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	65	26.15	2	1
dc_database_links	64	10.94	0	1
dc_files	16	100.00	0	0
dc_global_oids	84	29.76	0	0
dc_histogram_data	423,286	11.39	0	4,616
dc_histogram_defs	206,556	11.20	0	2,490
dc_object_grants	576	15.63	0	72
dc_object_ids	1,458,958	0.08	0	630
dc_objects	830,003	0.12	5	411
dc_profiles	34	20.59	0	1
dc_rollback_segments	215	0.00	0	12
dc_segments	1,295,112	0.11	15	676
dc_sequences	748	2.01	748	2
dc_tablespace_quotas	9	100.00	9	0
dc_tablespaces	272,744	0.01	0	8
dc_usernames	1,123	7.12	0	7
dc_users	142,674	0.11	0	39
outstanding_alerts	48	100.00	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	18	55.56	410,418	0.00	9	0
CLUSTER	172	3.49	438	1.60	1	0
INDEX	41	46.34	123	15.45	0	0
SQL AREA	838,029	94.69	3,072,378	40.91	15,252	1,757
TABLE/PROCEDURE	325,402	0.21	2,963,449	0.16	2,849	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	122.88		1.28	1.39	11	11	96	96
	Freeable	83.13	0.00	1.11	2.43	21		75	75
	SQL	24.58	14.82	0.28	0.20	1	11	88	87
	PL/SQL	1.64	1.24	0.02	0.02	0	2	94	94
E	Other	123.95		1.29	1.38	11	11	96	96
	Freeable	83.19	0.00	1.09	2.41	21		76	76
	SQL	24.81	15.00	0.28	0.20	1	11	88	88
	PL/SQL	1.63	1.24	0.02	0.02	0	2	94	94

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	7,465,861,120	7,516,192,768
Fixed Size	2,109,992
Redo Buffers	14,663,680
Variable Size	1,107,299,800	1,056,968,152

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	15.50	15.50	0.00
shared	CCursor	63.63	41.92	-34.12
shared	Cursor Stats	17.28	17.28	0.00
shared	FileOpenBlock	15.20	15.20	0.00
shared	KGH: NO ACCESS	87.71	87.71	0.00
shared	PCursor	38.01	23.61	-37.89
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	479.06	525.48	9.69
shared	kglsim heap	24.27	24.27	0.00
shared	kglsim object batch	41.65	41.65	0.00
shared	library cache	39.55	26.79	-32.27
shared	private strands	15.24	15.24	0.00
shared	sql area	128.90	85.04	-34.03
	buffer_cache	7,120.00	7,168.00	0.67
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.98	13.98	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

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/gsdxgps/adump
background_dump_dest	/u01/app/oracle/admin/gsdxgps/bdump
compatible	10.2.0.5.0
control_files	/u01/app/oracle/oradata/GSDXGPS/controlfile/o1_mf_9874g3mb_.ctl, /u01/app/oracle/oradata/flash_recovery_area/GSDXGPS/controlfile/o1_mf_9874g3ow_.ctl
core_dump_dest	/u01/app/oracle/admin/gsdxgps/cdump
db_block_size	8192
db_create_file_dest	/u01/app/oracle/oradata
db_domain
db_file_multiblock_read_count	16
db_files	1000
db_name	gsdxgps
db_recovery_file_dest	/u01/app/oracle/oradata/flash_recovery_area
db_recovery_file_dest_size	529321164800
dispatchers	(PROTOCOL=TCP) (SERVICE=gsdxgpsXDB)
job_queue_processes	10
open_cursors	800
pga_aggregate_target	2147483648
processes	1000
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	100
sessions	1105
sga_target	8589934592
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/u01/app/oracle/admin/gsdxgps/udump

End of Report [oracle@gps1 zyf]$ ### END LOG - DATE: 140121, TIME: 200907 ###

% Blocks changed per Read:	21.06	Recursive Call %:	55.10
Rollback per transaction %:	0.00	Rows per Sort:	88.13

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	105.07	In-memory Sort %:	100.00
Library Hit %:	80.43	Soft Parse %:	35.33
Execute to Parse %:	68.25	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	101.60	% Non-Parse CPU:	88.74