WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

ORCL 1251528357 orcl 1 10.2.0.5.0 NO CYXXPTDATA1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ORCL	1251528357	orcl	1	10.2.0.5.0	NO	CYXXPTDATA1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 22459 02-2月 -13 00:00:27 78 3.3

End Snap: 22466 02-2月 -13 07:00:07 79 3.6

Elapsed: 419.66 (mins)

DB Time: 241.66 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	22459	02-2月 -13 00:00:27	78	3.3
End Snap:	22466	02-2月 -13 07:00:07	79	3.6
Elapsed:		419.66 (mins)
DB Time:		241.66 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 7,888M 7,888M Std Block Size: 8K

Shared Pool Size: 1,232M 1,232M Log Buffer: 14,336K

	Begin	End
Buffer Cache:	7,888M	7,888M	Std Block Size:	8K
Shared Pool Size:	1,232M	1,232M	Log Buffer:	14,336K

Load Profile

Per Second Per Transaction

Redo size: 33,288.35 37,078.12

Logical reads: 31,743.69 35,357.61

Block changes: 135.14 150.53

Physical reads: 346.83 386.31

Physical writes: 3.65 4.06

User calls: 25.09 27.94

Parses: 16.16 18.00

Hard parses: 0.32 0.36

Sorts: 7.59 8.45

Logons: 0.20 0.23

Executes: 30.14 33.57

Transactions: 0.90

	Per Second	Per Transaction
Redo size:	33,288.35	37,078.12
Logical reads:	31,743.69	35,357.61
Block changes:	135.14	150.53
Physical reads:	346.83	386.31
Physical writes:	3.65	4.06
User calls:	25.09	27.94
Parses:	16.16	18.00
Hard parses:	0.32	0.36
Sorts:	7.59	8.45
Logons:	0.20	0.23
Executes:	30.14	33.57
Transactions:	0.90

% Blocks changed per Read: 0.43 Recursive Call %: 86.74

Rollback per transaction %: 0.03 Rows per Sort: 35.14

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.24 Soft Parse %: 98.00

Execute to Parse %: 46.39 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 88.20 % Non-Parse CPU: 99.45

Shared Pool Statistics

Begin End

Memory Usage %: 83.12 76.24

% SQL with executions>1: 95.47 97.88

% Memory for SQL w/exec>1: 95.03 97.12

	Begin	End
Memory Usage %:	83.12	76.24
% SQL with executions>1:	95.47	97.88
% Memory for SQL w/exec>1:	95.03	97.12

Top 5 Timed Events

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

CPU time 11,744 81.0

SQL*Net message from dblink 621,990 1,347 2 9.3 Network

Datapump dump file I/O 182,885 793 4 5.5 User I/O

SQL*Net more data from dblink 10,531,682 554 0 3.8 Network

direct path read 476,894 148 0 1.0 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		11,744		81.0
SQL*Net message from dblink	621,990	1,347	2	9.3	Network
Datapump dump file I/O	182,885	793	4	5.5	User I/O
SQL*Net more data from dblink	10,531,682	554	0	3.8	Network
direct path read	476,894	148	0	1.0	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): 14499.5s
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	14,378.53	99.17
DB CPU	11,744.47	81.00
PL/SQL execution elapsed time	1,429.06	9.86
parse time elapsed	93.93	0.65
hard parse elapsed time	58.38	0.40
connection management call elapsed time	16.84	0.12
PL/SQL compilation elapsed time	7.21	0.05
hard parse (sharing criteria) elapsed time	6.61	0.05
repeated bind elapsed time	0.72	0.00
hard parse (bind mismatch) elapsed time	0.08	0.00
sequence load elapsed time	0.07	0.00
failed parse elapsed time	0.01	0.00
DB time	14,499.45
background elapsed time	150.73
background cpu time	24.52

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			11,744		81.00
Network	12,408,587		1,910	0	13.17
User I/O	803,998		1,081	1	7.45
System I/O	62,916		74	1	0.51
Commit	15,662	0	28	2	0.19
Other	2,116	0	11	5	0.07
Concurrency	391		1	3	0.01
Configuration	24	4	1	28	0.00
Application	586		0	1	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
SQL*Net message from dblink	621,990		1,347	2	27.51
Datapump dump file I/O	182,885		793	4	8.09
SQL*Net more data from dblink	10,531,682		554	0	465.88
direct path read	476,894		148	0	21.10
db file scattered read	128,046		121	1	5.66
log file parallel write	29,304		40	1	1.30
log file sync	15,662	0	28	2	0.69
control file parallel write	8,895		14	2	0.39
control file sequential read	23,055		10	0	1.02
Streams AQ: qmn coordinator waiting for slave to start	2	100	10	4996	0.00
db file sequential read	5,598		10	2	0.25
Log archive I/O	804		7	9	0.04
direct path write	7,907		6	1	0.35
SQL*Net message to dblink	621,977		3	0	27.51
SQL*Net message to client	539,776		3	0	23.88
log file sequential read	840		2	3	0.04
SQL*Net more data to client	36,560		2	0	1.62
local write wait	855		1	1	0.04
os thread startup	158		1	7	0.01
SQL*Net more data from client	47,260		1	0	2.09
utl_file I/O	1,797		1	0	0.08
log file switch completion	23		1	24	0.00
SQL*Net more data to dblink	9,342		0	0	0.41
enq: TQ - DDL contention	3		0	82	0.00
kupp process wait	2	100	0	103	0.00
enq: UL - contention	4		0	42	0.00
enq: RO - fast object reuse	49		0	3	0.00
enq: KO - fast object checkpoint	509		0	0	0.02
undo segment extension	1	100	0	105	0.00
rdbms ipc reply	197		0	0	0.01
enq: TQ - TM contention	1		0	82	0.00
reliable message	559		0	0	0.02
latch free	254		0	0	0.01
LGWR wait for redo copy	697		0	0	0.03
latch: shared pool	22		0	1	0.00
latch: session allocation	397		0	0	0.02
direct path write temp	12		0	1	0.00
log file single write	18		0	0	0.00
latch: cache buffers chains	146		0	0	0.01
SQL*Net break/reset to client	24		0	0	0.00
row cache lock	1		0	1	0.00
buffer busy waits	39		0	0	0.00
library cache lock	2		0	0	0.00
latch: In memory undo latch	15		0	0	0.00
latch: row cache objects	3		0	0	0.00
latch: library cache	5		0	0	0.00
latch: checkpoint queue latch	1		0	0	0.00
latch: cache buffers lru chain	1		0	0	0.00
latch: messages	1		0	0	0.00
direct path sync	4		0	0	0.00
latch: object queue header operation	1		0	0	0.00
SQL*Net message from client	544,294		274,407	504	24.08
Streams AQ: qmn slave idle wait	3,358	0	51,957	15473	0.15
jobq slave wait	8,403	96	25,148	2993	0.37
Streams AQ: qmn coordinator idle wait	2,855	38	25,111	8795	0.13
virtual circuit status	839	100	25,067	29877	0.04
Streams AQ: waiting for time management or cleanup tasks	109	79	13,970	128167	0.00
wait for unread message on broadcast channel	5,216	46	2,653	509	0.23
i/o slave wait	77,921		187	2	3.45
PL/SQL lock timer	9	100	1	104	0.00
single-task message	14		0	14	0.00
class slave wait	60		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	29,304		40	1	1.30
control file parallel write	8,895		14	2	0.39
events in waitclass Other	893	0	10	11	0.04
control file sequential read	21,980		10	0	0.97
Log archive I/O	804		7	9	0.04
log file sequential read	840		2	3	0.04
os thread startup	154		1	7	0.01
direct path read	315		0	0	0.01
direct path write	314		0	0	0.01
db file sequential read	2		0	12	0.00
log file single write	18		0	0	0.00
row cache lock	1		0	1	0.00
library cache lock	2		0	0	0.00
buffer busy waits	1		0	0	0.00
latch: library cache	1		0	0	0.00
latch: cache buffers chains	1		0	0	0.00
rdbms ipc message	122,331	73	295,458	2415	5.41
Streams AQ: qmn slave idle wait	3,028		50,242	16592	0.13
pmon timer	8,517	100	25,169	2955	0.38
Streams AQ: qmn coordinator idle wait	2,855	38	25,111	8795	0.13
smon timer	91	87	24,414	268281	0.00
Streams AQ: waiting for time management or cleanup tasks	109	79	13,970	128167	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	78,393
AVG_IDLE_TIME	2,438,031
AVG_SYS_TIME	6,412
AVG_USER_TIME	71,173
BUSY_TIME	1,266,603
IDLE_TIME	39,020,996
SYS_TIME	115,286
USER_TIME	1,151,317
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	-8.5E+18
VM_OUT_BYTES	1.2E+16
PHYSICAL_MEMORY_BYTES	17,178,505,216
NUM_CPUS	16
NUM_CPU_CORES	4

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	14,491.70	11,742.40	8,732,624	799,011,403
SYS$BACKGROUND	0.00	0.00	384	238,839
orcl	0.00	0.00	0	0
orclXDB	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
SYS$USERS	803058	1079	231	0	12390528	1910
SYS$BACKGROUND	940	1	160	1	0	0
orcl	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
Total DB Time (s): 14,499
Captured SQL account for 94.1% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
1,430	57	4	357.49	9.86	bmk38162y2fvk	SQL*Plus	BEGIN new_add_update_r_x(34, 3...
1,402	1,402	4	350.60	9.67	f8xpnsz1qpd5q	SQL*Plus	UPDATE t_sgzh_jcj_cjjl T SET T...
1,315	1,314	362	3.63	9.07	g1n9ytf9d4mfy		select count(vsjldrybdc0_.ID) ...
1,205	1,113	4	301.17	8.31	c861h35upu6f1	SQL*Plus	BEGIN new_add_update_r_x(3, 3,...
1,147	368	2	573.35	7.91	fvsdmwpp3xn5u		BEGIN SYS.KUPW$WORKER.MAIN('S...
731	725	90,348	0.01	5.04	3mhby23vr098c	SQL*Plus	SELECT PALTFORM_CODE, DIC_OLDL...
588	519	5	117.69	4.06	2kz2ud4r7unwx	SQL*Plus	insert into T_SGXZ_INFO_CRMNLC...
517	499	5	103.32	3.56	4d4gpv5u4vmua	SQL*Plus	insert into T_SGXZ_INFO_CRIMIN...
371	310	5	74.12	2.56	525904warubfj	SQL*Plus	insert into T_SGXZ_SJ_INFO_PEA...
364	364	362	1.01	2.51	c6j7upst6cwyv		select count(vsjldrybdc0_.ID) ...
329	328	362	0.91	2.27	1q7tghmygsmp1		select count(tsjldrybdc0_.ID) ...
213	0	1	212.63	1.47	0t3z36t1ya676	SQL*Plus	select count(*) FROM hc_transl...
209	209	362	0.58	1.44	73ksnutrnmpwy		select count(vsjldrycky0_.ID) ...
207	173	4	51.86	1.43	ff249x8n2x62q	SQL*Plus	insert into t_sgxz_sj_info_pe...
204	97	4	50.96	1.41	dy75jqh67dtkq	SQL*Plus	insert into t_pzxt_gzdx select...
201	0	1	200.70	1.38	4tmxjwjj14k0k	SQL*Plus	select count(*) FROM hc_transl...
198	0	1	198.39	1.37	1hr1659b8u2r4	SQL*Plus	select count(*) FROM hc_transl...
191	0	1	190.66	1.31	2p3rksj1w6a0f	SQL*Plus	select count(*) FROM hc_transl...
186	0	1	185.59	1.28	fyaqfgmuzws2w	SQL*Plus	select count(*) FROM hc_transl...
180	0	1	180.48	1.24	4w11qqj0za02q	SQL*Plus	select count(*) FROM hc_transl...
159	133	5	31.74	1.09	2bg7r3yvjqm9q	SQL*Plus	insert into T_SGXZ_SJ_INFO_CAS...

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): 11,744
Captured SQL account for 80.6% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
1,402	1,402	4	350.60	11.94	9.67	f8xpnsz1qpd5q	SQL*Plus	UPDATE t_sgzh_jcj_cjjl T SET T...
1,314	1,315	362	3.63	11.19	9.07	g1n9ytf9d4mfy		select count(vsjldrybdc0_.ID) ...
1,113	1,205	4	278.18	9.47	8.31	c861h35upu6f1	SQL*Plus	BEGIN new_add_update_r_x(3, 3,...
725	731	90,348	0.01	6.17	5.04	3mhby23vr098c	SQL*Plus	SELECT PALTFORM_CODE, DIC_OLDL...
519	588	5	103.81	4.42	4.06	2kz2ud4r7unwx	SQL*Plus	insert into T_SGXZ_INFO_CRMNLC...
499	517	5	99.85	4.25	3.56	4d4gpv5u4vmua	SQL*Plus	insert into T_SGXZ_INFO_CRIMIN...
368	1,147	2	184.17	3.14	7.91	fvsdmwpp3xn5u		BEGIN SYS.KUPW$WORKER.MAIN('S...
364	364	362	1.00	3.10	2.51	c6j7upst6cwyv		select count(vsjldrybdc0_.ID) ...
328	329	362	0.91	2.79	2.27	1q7tghmygsmp1		select count(tsjldrybdc0_.ID) ...
310	371	5	61.98	2.64	2.56	525904warubfj	SQL*Plus	insert into T_SGXZ_SJ_INFO_PEA...
209	209	362	0.58	1.78	1.44	73ksnutrnmpwy		select count(vsjldrycky0_.ID) ...
173	207	4	43.35	1.48	1.43	ff249x8n2x62q	SQL*Plus	insert into t_sgxz_sj_info_pe...
143	143	362	0.39	1.22	0.99	4p61ffqhxhqyn		select count(tsjldrybdc0_.ID) ...
135	135	362	0.37	1.15	0.93	1k2gqkwjh52n8		select count(tsjldrybdc0_.ID) ...
133	159	5	26.58	1.13	1.09	2bg7r3yvjqm9q	SQL*Plus	insert into T_SGXZ_SJ_INFO_CAS...
133	133	362	0.37	1.13	0.92	0rzj6ttxwnafw		select count(tsjldrybdc0_.ID) ...
126	137	5	25.13	1.07	0.94	7z97ksh3y733j	SQL*Plus	insert into T_SGXZ_INFO_CRMNLC...
119	119	22	5.43	1.02	0.82	918hpcrs0hmry		select infoid, zdryxl, jb, yjj...

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: 799,294,129
Captured SQL account for 74.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
137,109,510	4	34,277,377.50	17.15	1402.39	1402.42	f8xpnsz1qpd5q	SQL*Plus	UPDATE t_sgzh_jcj_cjjl T SET T...
70,141,110	362	193,759.97	8.78	1314.19	1315.29	g1n9ytf9d4mfy		select count(vsjldrybdc0_.ID) ...
59,715,571	4	14,928,892.75	7.47	1112.72	1204.67	c861h35upu6f1	SQL*Plus	BEGIN new_add_update_r_x(3, 3,...
58,816,548	90,348	651.00	7.36	724.77	730.93	3mhby23vr098c	SQL*Plus	SELECT PALTFORM_CODE, DIC_OLDL...
37,266,623	5	7,453,324.60	4.66	132.92	158.72	2bg7r3yvjqm9q	SQL*Plus	insert into T_SGXZ_SJ_INFO_CAS...
31,682,227	5	6,336,445.40	3.96	309.89	370.59	525904warubfj	SQL*Plus	insert into T_SGXZ_SJ_INFO_PEA...
23,824,013	5	4,764,802.60	2.98	499.23	516.59	4d4gpv5u4vmua	SQL*Plus	insert into T_SGXZ_INFO_CRIMIN...
23,817,749	5	4,763,549.80	2.98	519.03	588.45	2kz2ud4r7unwx	SQL*Plus	insert into T_SGXZ_INFO_CRMNLC...
22,731,387	4	5,682,846.75	2.84	173.39	207.46	ff249x8n2x62q	SQL*Plus	insert into t_sgxz_sj_info_pe...
21,020,609	4	5,255,152.25	2.63	117.38	123.58	39n0rggnwwk4k	SQL*Plus	insert into t_sgxz_wp_info_go...
18,597,646	362	51,374.71	2.33	363.70	364.07	c6j7upst6cwyv		select count(vsjldrybdc0_.ID) ...
18,403,050	362	50,837.15	2.30	327.83	328.58	1q7tghmygsmp1		select count(tsjldrybdc0_.ID) ...
16,239,275	5	3,247,855.00	2.03	83.66	115.79	b6q9ta11u4zbh	SQL*Plus	insert into t_sgxz_info_arrest...
11,762,828	362	32,494.00	1.47	208.52	208.81	73ksnutrnmpwy		select count(vsjldrycky0_.ID) ...
11,240,678	5	2,248,135.60	1.41	125.66	136.91	7z97ksh3y733j	SQL*Plus	insert into T_SGXZ_INFO_CRMNLC...
11,031,902	2	5,515,951.00	1.38	368.34	1146.71	fvsdmwpp3xn5u		BEGIN SYS.KUPW$WORKER.MAIN('S...
8,469,354	362	23,396.01	1.06	132.88	132.92	0rzj6ttxwnafw		select count(tsjldrybdc0_.ID) ...
8,469,353	362	23,396.00	1.06	135.11	135.15	1k2gqkwjh52n8		select count(tsjldrybdc0_.ID) ...
8,469,352	362	23,396.00	1.06	142.94	143.02	4p61ffqhxhqyn		select count(tsjldrybdc0_.ID) ...
8,453,931	5	1,690,786.20	1.06	52.03	89.02	9s28vquy2ufa3	SQL*Plus	insert into t_sgzh_jcj_fkqk se...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 8,733,008
Captured SQL account for 22.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
6,739,679	2	3,369,839.50	77.17	368.34	1146.71	fvsdmwpp3xn5u		BEGIN SYS.KUPW$WORKER.MAIN('S...
1,590,169	4	397,542.25	18.21	55.66	132.48	5s897cwqdrz0y	SQL*Plus	SELECT TO_CHAR(MAX(LASTMODIFY...
1,590,169	4	397,542.25	18.21	56.77	1429.94	bmk38162y2fvk	SQL*Plus	BEGIN new_add_update_r_x(34, 3...
398,996	1	398,996.00	4.57	23.63	42.14	1suf4trbgu1pt	SQL*Plus	insert into t_sghc_translatech...
398,996	1	398,996.00	4.57	23.66	42.18	7rb45kkqy6t5k	SQL*Plus	BEGIN hc_exclude2('t_sghc_tran...
978	1	978.00	0.01	22.00	22.05	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
680	4	170.00	0.01	97.25	203.86	dy75jqh67dtkq	SQL*Plus	insert into t_pzxt_gzdx select...
43	1	43.00	0.00	1.56	1.92	07mfwbm9huwmg	Data Pump Worker	SELECT /+all_rows/ SYS_XMLGE...
37	6	6.17	0.00	0.17	0.17	0dwr2vd6vbqzs		SELECT count(*) over () as tot...
37	5	7.40	0.00	52.03	89.02	9s28vquy2ufa3	SQL*Plus	insert into t_sgzh_jcj_fkqk se...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 758,853
Captured SQL account for 36.4% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
90,348	43,141,170	477.50	0.01	0.01	3mhby23vr098c	SQL*Plus	SELECT PALTFORM_CODE, DIC_OLDL...
32,562	142,184	4.37	0.00	0.00	0h6b2sajwb74n		select privilege#, level from ...
15,058	15,058	1.00	0.00	0.00	2nv0hshgud0q2	SQL*Plus	select XH , JJXH , FDWID , CJ...
15,058	241	0.02	0.00	0.00	67uassbtaxvqx	SQL*Plus	insert into T_SGZH_JCJ_DWXX (...
14,849	14,817	1.00	0.00	0.00	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
12,656	12,656	1.00	0.00	0.00	ajrqdg90xn891		update CYGA_DW.T_SJLD_BDZDRLKB...
7,618	7,618	1.00	0.00	0.00	5aq8fb91ujwxg		select tsysbmxxb0_.BMID as BMI...
5,300	0	0.00	0.01	0.01	1gxda38vjnfxr		select vsjldlkbkz0_.ID as ID97...
4,976	32,562	6.54	0.00	0.00	0k8522rmdzg4k		select privilege# from sysauth...
4,517	4,517	1.00	0.00	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 406,855
Captured SQL account for 63.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
90,348	90,348	22.21	3mhby23vr098c	SQL*Plus	SELECT PALTFORM_CODE, DIC_OLDL...
32,562	32,562	8.00	0h6b2sajwb74n		select privilege#, level from ...
15,058	15,058	3.70	2nv0hshgud0q2	SQL*Plus	select XH , JJXH , FDWID , CJ...
15,058	15,058	3.70	67uassbtaxvqx	SQL*Plus	insert into T_SGZH_JCJ_DWXX (...
14,849	14,849	3.65	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
12,656	12,656	3.11	ajrqdg90xn891		update CYGA_DW.T_SJLD_BDZDRLKB...
4,976	4,976	1.22	0k8522rmdzg4k		select privilege# from sysauth...
4,517	4,517	1.11	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
4,517	4,517	1.11	459f3z9u4fb3u		select value$ from props$ wher...
4,517	4,517	1.11	5ur69atw3vfhj		select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

07mfwbm9huwmg SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , 'TABLE' , to_char(KU$.BYTES_ALLOC) , to_char(KU$.ET_PARALLEL) , KU$.FGAC , KU$.NONSCOPED_REF , KU$.XMLSCHEMACOLS , KU$.NAME , KU$.NAME , 'TABLE_DATA' , KU$.PART_NAME , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.TRIGFLAG , decode(KU$.SCHEMA_OBJ.TYPE_NUM, 2, decode(bitand(KU$.PROPERTY, 8192), 8192, 'NESTED TABLE', 'TABLE'), 19, 'PARTITION', 20, 'PARTITION', 'SUBPARTITION') , to_char(KU$.UNLOAD_METHOD) FROM SYS.KU$_TABLE_DATA_VIEW KU$ WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT (BITAND (KU$.BASE_OBJ.FLAGS, 16)=16) AND KU$.BASE_OBJ.OWNER_NAME IN ('CYGA_DW') AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='TABLE' AND A.NAME=KU$.BASE_OBJ.NAME AND A.SCHEMA=KU$.BASE_OBJ.OWNER_NAME) AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='SCHEMA' AND A.NAME=KU$.BASE_OBJ.OWNER_NAME)

0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id

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

0rzj6ttxwnafw select count(tsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.T_SJLD_RY_BDCKYJQBCZFKXX_JF tsjldrybdc0_ where tsjldrybdc0_.XXZT=6 and tsjldrybdc0_.JYBSHFKBZ='T' and (tsjldrybdc0_.SFJL<>'1' or tsjldrybdc0_.SFJL is null)

0t3z36t1ya676 select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 02:35:04', 1, 19))

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')

1gxda38vjnfxr select vsjldlkbkz0_.ID as ID97_, vsjldlkbkz0_.LKZLBH as LKZLBH97_, vsjldlkbkz0_.FWZH as FWZH97_, vsjldlkbkz0_.LKZLLX as LKZLLX97_, vsjldlkbkz0_.LKZLJB as LKZLJB97_, vsjldlkbkz0_.ZLJSDWF as ZLJSDWF97_, vsjldlkbkz0_.SQR as SQR97_, vsjldlkbkz0_.SQRSFZH as SQRSFZH97_, vsjldlkbkz0_.SQRXM as SQRXM97_, vsjldlkbkz0_.SQRLXDH as SQRLXDH97_, vsjldlkbkz0_.SQDW as SQDW97_, vsjldlkbkz0_.SQDWJGDM as SQDWJGDM97_, vsjldlkbkz0_.ZLFBSJ as ZLFBSJ97_, vsjldlkbkz0_.FBRXM as FBRXM97_, vsjldlkbkz0_.FBZRDW as FBZRDW97_, vsjldlkbkz0_.FBZRDWJGDM as FBZRDWJGDM97_, vsjldlkbkz0_.YLKZLBH as YLKZLBH97_, vsjldlkbkz0_.BXCKSY as BXCKSY97_, vsjldlkbkz0_.BKDYFW as BKDYFW97_, vsjldlkbkz0_.BKTS as BKTS97_, vsjldlkbkz0_.BKQSSJ as BKQSSJ97_, vsjldlkbkz0_.BKJZSJ as BKJZSJ97_, vsjldlkbkz0_.BBKR as BBKR97_, vsjldlkbkz0_.BBKRSJLX as BBKRSJLX97_, vsjldlkbkz0_.BBKRSJHM as BBKRSJHM97_, vsjldlkbkz0_.BBKRXM as BBKRXM97_, vsjldlkbkz0_.BBKRXB as BBKRXB97_, vsjldlkbkz0_.BBKRCSRQ as BBKRCSRQ97_, vsjldlkbkz0_.BBKRQTTZXX as BBKRQTTZXX97_, vsjldlkbkz0_.QSSX as QSSX97_, vsjldlkbkz0_.SCCZFKSX as SCCZFKSX97_, vsjldlkbkz0_.CZYQ as CZYQ97_, vsjldlkbkz0_.CZCSYQ as CZCSYQ97_, vsjldlkbkz0_.ZFYJ as ZFYJ97_, vsjldlkbkz0_.BZ as BZ97_, vsjldlkbkz0_.BSYJ as BSYJ97_, vsjldlkbkz0_.INFOID as INFOID97_, vsjldlkbkz0_.DTXXLB as DTXXLB97_, vsjldlkbkz0_.HDFSSJ as HDFSSJ97_, vsjldlkbkz0_.HDFSDD as HDFSDD97_, vsjldlkbkz0_.HDFSDDQH as HDFSDDQH97_, vsjldlkbkz0_.HDFSDDXZ as HDFSDDXZ97_, vsjldlkbkz0_.HDFSDDSSSHCS as HDFSDDS43_97_, vsjldlkbkz0_.HDFSDDSSSHCSDM as HDFSDDS44_97_, vsjldlkbkz0_.HDFSDDSSGAJG as HDFSDDS45_97_, vsjldlkbkz0_.HDFSDDSSGAJGJGDM as HDFSDDS46_97_, vsjldlkbkz0_.DJZJLX as DJZJLX97_, vsjldlkbkz0_.DJZJHM as DJZJHM97_, vsjldlkbkz0_.DJXM as DJXM97_, vsjldlkbkz0_.DJXB as DJXB97_, vsjldlkbkz0_.DJCSRQ as DJCSRQ97_, vsjldlkbkz0_.HDXGXX as HDXGXX97_, vsjldlkbkz0_.DTXXTGDW as DTXXTGDW97_, vsjldlkbkz0_.DTXXTGDWJGDM as DTXXTGD54_97_, vsjldlkbkz0_.XXBDSJ as XXBDSJ97_, vsjldlkbkz0_.XXBDDW as XXBDDW97_, vsjldlkbkz0_.XXBDDWJGDM as XXBDDWJGDM97_, vsjldlkbkz0_.DTGJXXBH as DTGJXXBH97_, vsjldlkbkz0_.BSYXBS as BSYXBS97_, vsjldlkbkz0_.SFJL as SFJL97_, vsjldlkbkz0_.RLSJ as RLSJ97_, vsjldlkbkz0_.SJBZ as SJBZ97_, vsjldlkbkz0_.QBZXBSYJ as QBZXBSYJ97_, vsjldlkbkz0_.DWMC as DWMC97_, vsjldlkbkz0_.DWBM as DWBM97_, vsjldlkbkz0_.XL as XL97_, vsjldlkbkz0_.BS as BS97_, vsjldlkbkz0_.XLBZ as XLBZ97_, vsjldlkbkz0_.CREATETIME as CREATETIME97_, vsjldlkbkz0_.SIGNTIME as SIGNTIME97_, vsjldlkbkz0_.RETURNFIRSTTIME as RETURNF71_97_, vsjldlkbkz0_.UPDATETIME as UPDATETIME97_, vsjldlkbkz0_.LIUZHUANID as LIUZHUANID97_, vsjldlkbkz0_.LIUZHUAN2ID as LIUZHUAN74_97_, vsjldlkbkz0_.XLZT as XLZT97_, vsjldlkbkz0_.ZKZT as ZKZT97_, vsjldlkbkz0_.SJLXBS as SJLXBS97_, vsjldlkbkz0_.FKBS as FKBS97_, vsjldlkbkz0_.LDXXBH as LDXXBH97_ from CYGA_DW.V_SJLD_LKBKZL_FJYJ vsjldlkbkz0_ where vsjldlkbkz0_.XLZT='1' and vsjldlkbkz0_.SJLXBS='2' and (vsjldlkbkz0_.ZKZT<>'1' or vsjldlkbkz0_.ZKZT is null) and (vsjldlkbkz0_.DWBM like '11010561%') order by vsjldlkbkz0_.LKZLJB, vsjldlkbkz0_.CREATETIME

1hr1659b8u2r4 select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 05:35:00', 1, 19))

1k2gqkwjh52n8 select count(tsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.T_SJLD_RY_BDCKYJQBCZFKXX_JF tsjldrybdc0_ where tsjldrybdc0_.XXZT=6 and tsjldrybdc0_.JYBSHFKBZ='P' and tsjldrybdc0_.YJJB='1' and (tsjldrybdc0_.SFJL<>'1' or tsjldrybdc0_.SFJL is null)

1q7tghmygsmp1 select count(tsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.T_SJLD_RY_BDCKYJQBXX_JF tsjldrybdc0_ where tsjldrybdc0_.SJLX='SJ' and tsjldrybdc0_.RGYPBS='2'

1suf4trbgu1pt insert into t_sghc_translatecheckinfo_TEMP select t.CHECKINFOID , t.POLICEMANID , t.POLICESTATION , t.SUBSTATION , t.POLICEMANNAME , t.CHECKTIME , t.CHECKADDRESS , t.CHECKSHIYOU , t.CHECKPERSONNAME , t.CHECKPERSONCUOHAO , t.CHECKPERSONSEX , t.DICTGUOJI , t.DICTCARDTYPE , t.CHECKPERSONCARDNUMBER , t.CHECKPERSONAGE , t.CHECKPERSONHUJI , t.DICTCHUZHISTATE , t.DICTZUAHUOSTATE , t.YIJIAOPERSONNAME , t.YIJIAOTIME , t.COMMENTS , t.DENGJISTATE , t.PERSONID , t.CUNYICAUSE , t.ISCHECKCAR , t.CARINFOID , t.DICTCARTYPE , t.CHECKCARNUMBER , t.BRANDID , t.DICTCARCOLOR , t.CHECKCARZHU , t.CHECKCARZHUCARD , t.CHECKCARCONTACT , t.LASTMODIFYDATE , t.WORKSUGGEST , t.WORKSUGGESTOTHER , t.YIJIAOJU , t.YIJIAOSUO , t.CHECKQU , t.CHECKJIEDAO , t.ISCHECKPERSON , t.SUOSHUSHEQU , t.COMMUNITY , t.OPERATIONTIME , t.QUERYTIME , t.CALLCENTERINPUTTIME , t.CALLCENTERUSERID , t.PHONENUM , t.COMPLETETIME , t.GONGZUORENWU , t.CHECKQUNAME , t.CHECKJIEDAONAME , t.PERSON_GUANLIAN , t.PERSON_GUANLIANNAME , t.CAR_GUANLIAN , t.CAR_GUANLIANNAME , t.POLICESTATIONNAME , t.SUBSTATIONNAME , t.CHECKSHIYOUNAME , t.CHECKPERSONSEXNAME , t.DICTCHUZHISTATENAME , t.DICTZUAHUOSTATENAME , t.DENGJISTATENAME , t.CUNYICAUSENAME , t.WORKSUGGESTNAME , t.YIJIAOJUNAME , t.YIJIAOSUONAME , t.GONGZUORENWUNAME , t.CHECKPERSONSHENGFEN , t.CHECKPERSONSHENGFENNAME , t.XINGZHENGCUOSHI , t.XINGZHENGCUOSHINAME , t.CHECKYEAR , t.CHECKMONTH , t.CHECKDAY , t.CHECKTIMEPIONT , t.CHECKPERSONSHIJI , t.CHECKNUMBER , t.XIEDAIWUPINNAME , t.XIEDAIWUPIN , t.BODYSPECMARKNAME , t.BODYSPECMARK , t.XIEXING , t.XIEXINGNAME , t.JIAOTONGGONGJUNAME , t.JIAOTONGGONGJU , t.LIUZHINUM , t.CUNYINUM , t.CHECKPERSONZHANZHU , t.CHECKCARZUXXDZ , t.REMOTEDATA , t.IP , t.REMOTEDATANAME , t.POLICESFZH , t.ISSHEQU , t.CHECKCOMPLETETIME , t.YIJIAOOTHERORG , t.ISSHEQUNAME , t.ISMOBILE , t.CHECKPERSONMZ , t.CHECKSOURCETYPE , t.CHECKSOURCENAME , t.ISCOMPLETECHECK , t.COMPLETETIME_48 , t.SENDMESSAGE , t.CHECKSOURCETYPENAME , t.DICTZHANZHUSTATE , t.CHECKDUIXIANG , t.SMSZSXXDZ , t.FOREIGN , t.CHECKPER SONBIRTH , t.CNNAME , NULL, NULL from t_sghc_translatecheckinfo t where t.POLICESTATION='110105' and to_char(t.checktime, 'yyyy-mm-dd') >= substr('2013-02-01 04:00:00', 1, 10) and to_char(t.checktime, 'yyyy-mm-dd') < substr('2013-02-02 04:00:00', 1, 10)

2bg7r3yvjqm9q insert into T_SGXZ_SJ_INFO_CASETOPEOPLE select * from T_INFO_CASETOPEOPLE@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select t2.id from T_SGXZ_SJ_INFO_CASETOPEOPLE t2 where t2.id=t.id)

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#

2kz2ud4r7unwx insert into T_SGXZ_INFO_CRMNLCS select * from T_INFO_CRMNLCS@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select id from T_SGXZ_INFO_CRMNLCS t2 where t2.id=t.id)

2nv0hshgud0q2 select XH , JJXH , FDWID , CJDWID , UPID , JQJB , CJR , DWBM , DWMC , JSR , JSRBM , CJSJ , CJDWMC , CJDWBM , SJC , DEL , SJJHDWBM FROM ZHZX_JCJ_DWXX@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM WHERE XH=:ID21

2p3rksj1w6a0f select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 02:35:04', 1, 19))

39n0rggnwwk4k insert into t_sgxz_wp_info_goodsbaseinfo t (select * from t_info_goodsbaseinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t2 where not exists (select t3.ID from t_sgxz_wp_info_goodsbaseinfo t3 where t3.ID =t2.ID))

3mhby23vr098c SELECT PALTFORM_CODE, DIC_OLDLARGE_CLASSCODE, DIC_OLD_CODE, DIC_OLD_ID, TARGETPLATFORM_CODE, DIC_NEWLARGE_CLASSCODE, DIC_NEW_CODE, DIC_ADD_DELETE FROM dictionary_ref WHERE dic_add_delete= :dic_adddelete AND Paltform_code = :platformcode AND dic_oldlarge_classcode IN ( SELECT distinct COLUMN_DICTIONARY_CODE FROM column_name WHERE table_num =:tablenum AND old_new =:oldnew AND column_if_add_delete !=:add_delete AND column_dictionary_code IS NOT NULL AND column_sequence = :columnsequence )

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

4d4gpv5u4vmua insert into T_SGXZ_INFO_CRIMINALBASEINFOR1 select * from T_INFO_CRIMINALBASEINFOR@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select t2.id from T_SGXZ_INFO_CRIMINALBASEINFOR1 t2 where t2.id=t.id)

4p61ffqhxhqyn select count(tsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.T_SJLD_RY_BDCKYJQBCZFKXX_JF tsjldrybdc0_ where tsjldrybdc0_.XXZT=6 and tsjldrybdc0_.JYBSHFKBZ='P' and (tsjldrybdc0_.SFJL<>'1' or tsjldrybdc0_.SFJL is null)

4tmxjwjj14k0k select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 04:04:58', 1, 19))

4w11qqj0za02q select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 04:04:58', 1, 19))

525904warubfj insert into T_SGXZ_SJ_INFO_PEACECASEINFO select * from T_INFO_PEACECASEINFO@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select t2.id from T_SGXZ_SJ_INFO_PEACECASEINFO t2 where t2.id=t.id)

5aq8fb91ujwxg select tsysbmxxb0_.BMID as BMID6_, tsysbmxxb0_.BMBM as BMBM6_, tsysbmxxb0_.BMMC as BMMC6_, tsysbmxxb0_.ZNMS as ZNMS6_, tsysbmxxb0_.SJBMID as SJBMID6_, tsysbmxxb0_.BMFZR as BMFZR6_, tsysbmxxb0_.LXFS as LXFS6_, tsysbmxxb0_.JBID as JBID6_, tsysbmxxb0_.ROLEID as ROLEID6_, tsysbmxxb0_.CJRID as CJRID6_, tsysbmxxb0_.CJSJ as CJSJ6_, tsysbmxxb0_.GXSJ as GXSJ6_, tsysbmxxb0_.YXBS as YXBS6_, tsysbmxxb0_.DSBS as DSBS6_ from T_SYS_BMXXB tsysbmxxb0_ where tsysbmxxb0_.BMBM='11010511'

5s897cwqdrz0y SELECT TO_CHAR(MAX(LASTMODIFYDATE), 'YYYY-MM-DD HH24:MI:SS') FROM T_SGHC_TRANSLATECHECKINFO

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

67uassbtaxvqx insert into T_SGZH_JCJ_DWXX (XH , JJXH , FDWID , CJDWID , UPID , JQJB , CJR , DWBM , DWMC , JSR , JSRBM , CJSJ , CJDWMC , CJDWBM , SJC , DEL , SJJHDWBM) values (:ID21 , :ID22 , :ID23 , :ID24 , :ID25 , :ID26 , :ID27 , :ID28 , :ID29 , :ID210 , :ID211 , :ID212 , :ID213 , :ID214 , :ID215 , :ID216 , :ID217)

73ksnutrnmpwy select count(vsjldrycky0_.ID) as col_0_0_ from CYGA_DW.V_SJLD_RY_CKYJ vsjldrycky0_ where vsjldrycky0_.XXZT=2 and (vsjldrycky0_.SFJL<>'1' or vsjldrycky0_.SFJL is null) and vsjldrycky0_.YJJB<>'5' and vsjldrycky0_.SJLX<>'FQ'

7rb45kkqy6t5k BEGIN hc_exclude2('t_sghc_translatecheckinfo', 't_sghc_translatecheckinfo', to_char(sysdate-1, 'yyyy-mm-dd hh24:mi:ss'), to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss')) ; END;

7z97ksh3y733j insert into T_SGXZ_INFO_CRMNLCSSLV select * from T_INFO_CRMNLCSSLV@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select t2.id from T_SGXZ_INFO_CRMNLCSSLV t2 where t2.id=t.id )

918hpcrs0hmry select infoid, zdryxl, jb, yjjb, zdryxm, yjxxbh, xxzt, qbzxcssjzf, bsjcdwmc, pcszt, pcscssjzf FROM v_sjld_ry_ckyj_notice

9s28vquy2ufa3 insert into t_sgzh_jcj_fkqk select * from zhzx_jcj_fkqk@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select t2.xh from t_sgzh_jcj_fkqk t2 where t2.xh=t.xh)

ajrqdg90xn891 update CYGA_DW.T_SJLD_BDZDRLKBK_JBXX set LDXXBH=:1, LKZLBH=:2, FWZH=:3, LKZLLX=:4, LKZLJB=:5, ZLJSDW=:6, SQRSFZH=:7, SQRXM=:8, SQRLXDH=:9, SQDW=:10, SQDWJGDM=:11, ZLFBSJ=:12, FBRXM=:13, FBZRDW=:14, FBZRDWJGDM=:15, YLKZLBH=:16, BBKRSJLX=:17, BBKRSJHM=:18, BBKRXM=:19, BBKRXB=:20, BBKRCSRQ=:21, BBKRQTTZXX=:22, DTXXLB=:23, HDFSSJ=:24, HDFSDDQH=:25, HDFSDDXZ=:26, HDFSDDSSSHCS=:27, HDFSDDSSSHCSDM=:28, HDFSDDSSGAJG=:29, HDFSDDSSGAJGJGDM=:30, DJZJLX=:31, DJZJHM=:32, DJXM=:33, DJXB=:34, DJCSRQ=:35, HDXGXX=:36, DTXXTGDW=:37, DTXXTGDWJGDM=:38, XXBDSJ=:39, XXBDDW=:40, XXBDDWJGDM=:41, DTGJXXBH=:42, QSSX=:43, XFSX=:44, SCCZFKSX=:45, CZCSYQ=:46, ZFYJ=:47, BSYJ=:48, BSRXM=:49, BSSJ=:50, SJXFSJ=:51, XXZT=:52, SFJL=:53, INFOID=:54, SFCK=:55 where ID=:56

b6q9ta11u4zbh insert into t_sgxz_info_arrestinfor select * from T_INFO_ARRESTINFOR@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists( select t2.id from t_sgxz_info_arrestinfor t2 where t2.id =t.id)

b6usrg82hwsa3 call dbms_stats.gather_database_stats_job_proc ( )

bmk38162y2fvk BEGIN new_add_update_r_x(34, 34, 30000, to_char(sysdate-3, 'yyyy-mm-dd'), to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss'), true); END;

c6j7upst6cwyv select count(vsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.V_SJLD_RY_BDCKYJ_JF vsjldrybdc0_ where vsjldrybdc0_.XXZT=1 and (vsjldrybdc0_.SFJL<>'1' or vsjldrybdc0_.SFJL is null) and vsjldrybdc0_.SJLX<>'FQ'

c861h35upu6f1 BEGIN new_add_update_r_x(3, 3, 30000, to_char(sysdate-2, 'yyyy-mm-dd hh24:mi:ss'), to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss'), true); END;

dy75jqh67dtkq insert into t_pzxt_gzdx select * from gzdx@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM

f8xpnsz1qpd5q UPDATE t_sgzh_jcj_cjjl T SET T.JQLBBM3 =( select T2.JQLBBM3 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQLBBM4 =( select T2.JQLBBM4 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQLBBM1 =( select T2.JQLBBM1 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQLBBM2 =( select T2.JQLBBM2 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.SFZDDQ =( select T2.SFZDDQ from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.SFJTAJ =( select T2.SFJTAJ from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQFSQY =( select T2.JQFSQY from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.RYSHQK =( select T2.RYSHQK from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.XWFSBM =( select T2.XWFSBM from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.GZQK =( select T2.GZQK from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.CSCF =( select T2.CSCF from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JTLBBM =( select T2.JTLBBM from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQJB =( select T2.JQJB from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.ZDDQBM1 =( select T2.ZDDQBM1 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.ZDDQBM2 =( select T2.ZDDQBM2 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.ZDDQBM3 =( select T2.ZDDQBM3 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.ZDDQBM4 =( select T2.ZDDQBM4 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQFSCS =( select T2.JQFSCS from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.SJJHDWBM =( select T2.SJJHDWBM from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.Fjjqgsdw =( select T2.Fjjqgsdw from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.PCSJQGSDW =( select T2.PCSJQGSDW from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.DWID =( select T2.DWID from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JD =( select T2.JD from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.WD =( select T2.WD from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) where exists (select t3.jjxh from t_sgzh_jcj_cjjl_backup t3 where t3.jjxh=t.jjxh)

ff249x8n2x62q insert into t_sgxz_sj_info_peacecasewindup t (select * from t_info_peacecasewindupinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t2 where not exists (select t3.id from t_sgxz_sj_info_peacecasewindup t3 where t3.id =t2.id))

fvsdmwpp3xn5u BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_23', 'CYGA_DW'); END;

fyaqfgmuzws2w select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 05:35:00', 1, 19))

g1n9ytf9d4mfy select count(vsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.V_SJLD_RY_BDCKYJ_JF vsjldrybdc0_ where vsjldrybdc0_.XXZT=2 and (vsjldrybdc0_.SFJL<>'1' or vsjldrybdc0_.SFJL is null) and vsjldrybdc0_.YJJB<>'5' and vsjldrybdc0_.SJLX<>'FQ'

SQL Id	SQL Text
07mfwbm9huwmg	SELECT /+all_rows/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , 'TABLE' , to_char(KU$.BYTES_ALLOC) , to_char(KU$.ET_PARALLEL) , KU$.FGAC , KU$.NONSCOPED_REF , KU$.XMLSCHEMACOLS , KU$.NAME , KU$.NAME , 'TABLE_DATA' , KU$.PART_NAME , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.TRIGFLAG , decode(KU$.SCHEMA_OBJ.TYPE_NUM, 2, decode(bitand(KU$.PROPERTY, 8192), 8192, 'NESTED TABLE', 'TABLE'), 19, 'PARTITION', 20, 'PARTITION', 'SUBPARTITION') , to_char(KU$.UNLOAD_METHOD) FROM SYS.KU$_TABLE_DATA_VIEW KU$ WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT (BITAND (KU$.BASE_OBJ.FLAGS, 16)=16) AND KU$.BASE_OBJ.OWNER_NAME IN ('CYGA_DW') AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='TABLE' AND A.NAME=KU$.BASE_OBJ.NAME AND A.SCHEMA=KU$.BASE_OBJ.OWNER_NAME) AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='SCHEMA' AND A.NAME=KU$.BASE_OBJ.OWNER_NAME)
0dwr2vd6vbqzs	SELECT count() over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash., evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe., nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap. FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count() as cnt FROM (SELECT t1. FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
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
0rzj6ttxwnafw	select count(tsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.T_SJLD_RY_BDCKYJQBCZFKXX_JF tsjldrybdc0_ where tsjldrybdc0_.XXZT=6 and tsjldrybdc0_.JYBSHFKBZ='T' and (tsjldrybdc0_.SFJL<>'1' or tsjldrybdc0_.SFJL is null)
0t3z36t1ya676	select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 02:35:04', 1, 19))
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')
1gxda38vjnfxr	select vsjldlkbkz0_.ID as ID97_, vsjldlkbkz0_.LKZLBH as LKZLBH97_, vsjldlkbkz0_.FWZH as FWZH97_, vsjldlkbkz0_.LKZLLX as LKZLLX97_, vsjldlkbkz0_.LKZLJB as LKZLJB97_, vsjldlkbkz0_.ZLJSDWF as ZLJSDWF97_, vsjldlkbkz0_.SQR as SQR97_, vsjldlkbkz0_.SQRSFZH as SQRSFZH97_, vsjldlkbkz0_.SQRXM as SQRXM97_, vsjldlkbkz0_.SQRLXDH as SQRLXDH97_, vsjldlkbkz0_.SQDW as SQDW97_, vsjldlkbkz0_.SQDWJGDM as SQDWJGDM97_, vsjldlkbkz0_.ZLFBSJ as ZLFBSJ97_, vsjldlkbkz0_.FBRXM as FBRXM97_, vsjldlkbkz0_.FBZRDW as FBZRDW97_, vsjldlkbkz0_.FBZRDWJGDM as FBZRDWJGDM97_, vsjldlkbkz0_.YLKZLBH as YLKZLBH97_, vsjldlkbkz0_.BXCKSY as BXCKSY97_, vsjldlkbkz0_.BKDYFW as BKDYFW97_, vsjldlkbkz0_.BKTS as BKTS97_, vsjldlkbkz0_.BKQSSJ as BKQSSJ97_, vsjldlkbkz0_.BKJZSJ as BKJZSJ97_, vsjldlkbkz0_.BBKR as BBKR97_, vsjldlkbkz0_.BBKRSJLX as BBKRSJLX97_, vsjldlkbkz0_.BBKRSJHM as BBKRSJHM97_, vsjldlkbkz0_.BBKRXM as BBKRXM97_, vsjldlkbkz0_.BBKRXB as BBKRXB97_, vsjldlkbkz0_.BBKRCSRQ as BBKRCSRQ97_, vsjldlkbkz0_.BBKRQTTZXX as BBKRQTTZXX97_, vsjldlkbkz0_.QSSX as QSSX97_, vsjldlkbkz0_.SCCZFKSX as SCCZFKSX97_, vsjldlkbkz0_.CZYQ as CZYQ97_, vsjldlkbkz0_.CZCSYQ as CZCSYQ97_, vsjldlkbkz0_.ZFYJ as ZFYJ97_, vsjldlkbkz0_.BZ as BZ97_, vsjldlkbkz0_.BSYJ as BSYJ97_, vsjldlkbkz0_.INFOID as INFOID97_, vsjldlkbkz0_.DTXXLB as DTXXLB97_, vsjldlkbkz0_.HDFSSJ as HDFSSJ97_, vsjldlkbkz0_.HDFSDD as HDFSDD97_, vsjldlkbkz0_.HDFSDDQH as HDFSDDQH97_, vsjldlkbkz0_.HDFSDDXZ as HDFSDDXZ97_, vsjldlkbkz0_.HDFSDDSSSHCS as HDFSDDS43_97_, vsjldlkbkz0_.HDFSDDSSSHCSDM as HDFSDDS44_97_, vsjldlkbkz0_.HDFSDDSSGAJG as HDFSDDS45_97_, vsjldlkbkz0_.HDFSDDSSGAJGJGDM as HDFSDDS46_97_, vsjldlkbkz0_.DJZJLX as DJZJLX97_, vsjldlkbkz0_.DJZJHM as DJZJHM97_, vsjldlkbkz0_.DJXM as DJXM97_, vsjldlkbkz0_.DJXB as DJXB97_, vsjldlkbkz0_.DJCSRQ as DJCSRQ97_, vsjldlkbkz0_.HDXGXX as HDXGXX97_, vsjldlkbkz0_.DTXXTGDW as DTXXTGDW97_, vsjldlkbkz0_.DTXXTGDWJGDM as DTXXTGD54_97_, vsjldlkbkz0_.XXBDSJ as XXBDSJ97_, vsjldlkbkz0_.XXBDDW as XXBDDW97_, vsjldlkbkz0_.XXBDDWJGDM as XXBDDWJGDM97_, vsjldlkbkz0_.DTGJXXBH as DTGJXXBH97_, vsjldlkbkz0_.BSYXBS as BSYXBS97_, vsjldlkbkz0_.SFJL as SFJL97_, vsjldlkbkz0_.RLSJ as RLSJ97_, vsjldlkbkz0_.SJBZ as SJBZ97_, vsjldlkbkz0_.QBZXBSYJ as QBZXBSYJ97_, vsjldlkbkz0_.DWMC as DWMC97_, vsjldlkbkz0_.DWBM as DWBM97_, vsjldlkbkz0_.XL as XL97_, vsjldlkbkz0_.BS as BS97_, vsjldlkbkz0_.XLBZ as XLBZ97_, vsjldlkbkz0_.CREATETIME as CREATETIME97_, vsjldlkbkz0_.SIGNTIME as SIGNTIME97_, vsjldlkbkz0_.RETURNFIRSTTIME as RETURNF71_97_, vsjldlkbkz0_.UPDATETIME as UPDATETIME97_, vsjldlkbkz0_.LIUZHUANID as LIUZHUANID97_, vsjldlkbkz0_.LIUZHUAN2ID as LIUZHUAN74_97_, vsjldlkbkz0_.XLZT as XLZT97_, vsjldlkbkz0_.ZKZT as ZKZT97_, vsjldlkbkz0_.SJLXBS as SJLXBS97_, vsjldlkbkz0_.FKBS as FKBS97_, vsjldlkbkz0_.LDXXBH as LDXXBH97_ from CYGA_DW.V_SJLD_LKBKZL_FJYJ vsjldlkbkz0_ where vsjldlkbkz0_.XLZT='1' and vsjldlkbkz0_.SJLXBS='2' and (vsjldlkbkz0_.ZKZT<>'1' or vsjldlkbkz0_.ZKZT is null) and (vsjldlkbkz0_.DWBM like '11010561%') order by vsjldlkbkz0_.LKZLJB, vsjldlkbkz0_.CREATETIME
1hr1659b8u2r4	select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 05:35:00', 1, 19))
1k2gqkwjh52n8	select count(tsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.T_SJLD_RY_BDCKYJQBCZFKXX_JF tsjldrybdc0_ where tsjldrybdc0_.XXZT=6 and tsjldrybdc0_.JYBSHFKBZ='P' and tsjldrybdc0_.YJJB='1' and (tsjldrybdc0_.SFJL<>'1' or tsjldrybdc0_.SFJL is null)
1q7tghmygsmp1	select count(tsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.T_SJLD_RY_BDCKYJQBXX_JF tsjldrybdc0_ where tsjldrybdc0_.SJLX='SJ' and tsjldrybdc0_.RGYPBS='2'
1suf4trbgu1pt	insert into t_sghc_translatecheckinfo_TEMP select t.CHECKINFOID , t.POLICEMANID , t.POLICESTATION , t.SUBSTATION , t.POLICEMANNAME , t.CHECKTIME , t.CHECKADDRESS , t.CHECKSHIYOU , t.CHECKPERSONNAME , t.CHECKPERSONCUOHAO , t.CHECKPERSONSEX , t.DICTGUOJI , t.DICTCARDTYPE , t.CHECKPERSONCARDNUMBER , t.CHECKPERSONAGE , t.CHECKPERSONHUJI , t.DICTCHUZHISTATE , t.DICTZUAHUOSTATE , t.YIJIAOPERSONNAME , t.YIJIAOTIME , t.COMMENTS , t.DENGJISTATE , t.PERSONID , t.CUNYICAUSE , t.ISCHECKCAR , t.CARINFOID , t.DICTCARTYPE , t.CHECKCARNUMBER , t.BRANDID , t.DICTCARCOLOR , t.CHECKCARZHU , t.CHECKCARZHUCARD , t.CHECKCARCONTACT , t.LASTMODIFYDATE , t.WORKSUGGEST , t.WORKSUGGESTOTHER , t.YIJIAOJU , t.YIJIAOSUO , t.CHECKQU , t.CHECKJIEDAO , t.ISCHECKPERSON , t.SUOSHUSHEQU , t.COMMUNITY , t.OPERATIONTIME , t.QUERYTIME , t.CALLCENTERINPUTTIME , t.CALLCENTERUSERID , t.PHONENUM , t.COMPLETETIME , t.GONGZUORENWU , t.CHECKQUNAME , t.CHECKJIEDAONAME , t.PERSON_GUANLIAN , t.PERSON_GUANLIANNAME , t.CAR_GUANLIAN , t.CAR_GUANLIANNAME , t.POLICESTATIONNAME , t.SUBSTATIONNAME , t.CHECKSHIYOUNAME , t.CHECKPERSONSEXNAME , t.DICTCHUZHISTATENAME , t.DICTZUAHUOSTATENAME , t.DENGJISTATENAME , t.CUNYICAUSENAME , t.WORKSUGGESTNAME , t.YIJIAOJUNAME , t.YIJIAOSUONAME , t.GONGZUORENWUNAME , t.CHECKPERSONSHENGFEN , t.CHECKPERSONSHENGFENNAME , t.XINGZHENGCUOSHI , t.XINGZHENGCUOSHINAME , t.CHECKYEAR , t.CHECKMONTH , t.CHECKDAY , t.CHECKTIMEPIONT , t.CHECKPERSONSHIJI , t.CHECKNUMBER , t.XIEDAIWUPINNAME , t.XIEDAIWUPIN , t.BODYSPECMARKNAME , t.BODYSPECMARK , t.XIEXING , t.XIEXINGNAME , t.JIAOTONGGONGJUNAME , t.JIAOTONGGONGJU , t.LIUZHINUM , t.CUNYINUM , t.CHECKPERSONZHANZHU , t.CHECKCARZUXXDZ , t.REMOTEDATA , t.IP , t.REMOTEDATANAME , t.POLICESFZH , t.ISSHEQU , t.CHECKCOMPLETETIME , t.YIJIAOOTHERORG , t.ISSHEQUNAME , t.ISMOBILE , t.CHECKPERSONMZ , t.CHECKSOURCETYPE , t.CHECKSOURCENAME , t.ISCOMPLETECHECK , t.COMPLETETIME_48 , t.SENDMESSAGE , t.CHECKSOURCETYPENAME , t.DICTZHANZHUSTATE , t.CHECKDUIXIANG , t.SMSZSXXDZ , t.FOREIGN , t.CHECKPER SONBIRTH , t.CNNAME , NULL, NULL from t_sghc_translatecheckinfo t where t.POLICESTATION='110105' and to_char(t.checktime, 'yyyy-mm-dd') >= substr('2013-02-01 04:00:00', 1, 10) and to_char(t.checktime, 'yyyy-mm-dd') < substr('2013-02-02 04:00:00', 1, 10)
2bg7r3yvjqm9q	insert into T_SGXZ_SJ_INFO_CASETOPEOPLE select * from T_INFO_CASETOPEOPLE@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select t2.id from T_SGXZ_SJ_INFO_CASETOPEOPLE t2 where t2.id=t.id)
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#
2kz2ud4r7unwx	insert into T_SGXZ_INFO_CRMNLCS select * from T_INFO_CRMNLCS@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select id from T_SGXZ_INFO_CRMNLCS t2 where t2.id=t.id)
2nv0hshgud0q2	select XH , JJXH , FDWID , CJDWID , UPID , JQJB , CJR , DWBM , DWMC , JSR , JSRBM , CJSJ , CJDWMC , CJDWBM , SJC , DEL , SJJHDWBM FROM ZHZX_JCJ_DWXX@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM WHERE XH=:ID21
2p3rksj1w6a0f	select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 02:35:04', 1, 19))
39n0rggnwwk4k	insert into t_sgxz_wp_info_goodsbaseinfo t (select * from t_info_goodsbaseinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t2 where not exists (select t3.ID from t_sgxz_wp_info_goodsbaseinfo t3 where t3.ID =t2.ID))
3mhby23vr098c	SELECT PALTFORM_CODE, DIC_OLDLARGE_CLASSCODE, DIC_OLD_CODE, DIC_OLD_ID, TARGETPLATFORM_CODE, DIC_NEWLARGE_CLASSCODE, DIC_NEW_CODE, DIC_ADD_DELETE FROM dictionary_ref WHERE dic_add_delete= :dic_adddelete AND Paltform_code = :platformcode AND dic_oldlarge_classcode IN ( SELECT distinct COLUMN_DICTIONARY_CODE FROM column_name WHERE table_num =:tablenum AND old_new =:oldnew AND column_if_add_delete !=:add_delete AND column_dictionary_code IS NOT NULL AND column_sequence = :columnsequence )
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4d4gpv5u4vmua	insert into T_SGXZ_INFO_CRIMINALBASEINFOR1 select * from T_INFO_CRIMINALBASEINFOR@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select t2.id from T_SGXZ_INFO_CRIMINALBASEINFOR1 t2 where t2.id=t.id)
4p61ffqhxhqyn	select count(tsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.T_SJLD_RY_BDCKYJQBCZFKXX_JF tsjldrybdc0_ where tsjldrybdc0_.XXZT=6 and tsjldrybdc0_.JYBSHFKBZ='P' and (tsjldrybdc0_.SFJL<>'1' or tsjldrybdc0_.SFJL is null)
4tmxjwjj14k0k	select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(CHECKTIME, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 04:04:58', 1, 19))
4w11qqj0za02q	select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 04:04:58', 1, 19))
525904warubfj	insert into T_SGXZ_SJ_INFO_PEACECASEINFO select * from T_INFO_PEACECASEINFO@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select t2.id from T_SGXZ_SJ_INFO_PEACECASEINFO t2 where t2.id=t.id)
5aq8fb91ujwxg	select tsysbmxxb0_.BMID as BMID6_, tsysbmxxb0_.BMBM as BMBM6_, tsysbmxxb0_.BMMC as BMMC6_, tsysbmxxb0_.ZNMS as ZNMS6_, tsysbmxxb0_.SJBMID as SJBMID6_, tsysbmxxb0_.BMFZR as BMFZR6_, tsysbmxxb0_.LXFS as LXFS6_, tsysbmxxb0_.JBID as JBID6_, tsysbmxxb0_.ROLEID as ROLEID6_, tsysbmxxb0_.CJRID as CJRID6_, tsysbmxxb0_.CJSJ as CJSJ6_, tsysbmxxb0_.GXSJ as GXSJ6_, tsysbmxxb0_.YXBS as YXBS6_, tsysbmxxb0_.DSBS as DSBS6_ from T_SYS_BMXXB tsysbmxxb0_ where tsysbmxxb0_.BMBM='11010511'
5s897cwqdrz0y	SELECT TO_CHAR(MAX(LASTMODIFYDATE), 'YYYY-MM-DD HH24:MI:SS') FROM T_SGHC_TRANSLATECHECKINFO
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
67uassbtaxvqx	insert into T_SGZH_JCJ_DWXX (XH , JJXH , FDWID , CJDWID , UPID , JQJB , CJR , DWBM , DWMC , JSR , JSRBM , CJSJ , CJDWMC , CJDWBM , SJC , DEL , SJJHDWBM) values (:ID21 , :ID22 , :ID23 , :ID24 , :ID25 , :ID26 , :ID27 , :ID28 , :ID29 , :ID210 , :ID211 , :ID212 , :ID213 , :ID214 , :ID215 , :ID216 , :ID217)
73ksnutrnmpwy	select count(vsjldrycky0_.ID) as col_0_0_ from CYGA_DW.V_SJLD_RY_CKYJ vsjldrycky0_ where vsjldrycky0_.XXZT=2 and (vsjldrycky0_.SFJL<>'1' or vsjldrycky0_.SFJL is null) and vsjldrycky0_.YJJB<>'5' and vsjldrycky0_.SJLX<>'FQ'
7rb45kkqy6t5k	BEGIN hc_exclude2('t_sghc_translatecheckinfo', 't_sghc_translatecheckinfo', to_char(sysdate-1, 'yyyy-mm-dd hh24:mi:ss'), to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss')) ; END;
7z97ksh3y733j	insert into T_SGXZ_INFO_CRMNLCSSLV select * from T_INFO_CRMNLCSSLV@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select t2.id from T_SGXZ_INFO_CRMNLCSSLV t2 where t2.id=t.id )
918hpcrs0hmry	select infoid, zdryxl, jb, yjjb, zdryxm, yjxxbh, xxzt, qbzxcssjzf, bsjcdwmc, pcszt, pcscssjzf FROM v_sjld_ry_ckyj_notice
9s28vquy2ufa3	insert into t_sgzh_jcj_fkqk select * from zhzx_jcj_fkqk@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists (select t2.xh from t_sgzh_jcj_fkqk t2 where t2.xh=t.xh)
ajrqdg90xn891	update CYGA_DW.T_SJLD_BDZDRLKBK_JBXX set LDXXBH=:1, LKZLBH=:2, FWZH=:3, LKZLLX=:4, LKZLJB=:5, ZLJSDW=:6, SQRSFZH=:7, SQRXM=:8, SQRLXDH=:9, SQDW=:10, SQDWJGDM=:11, ZLFBSJ=:12, FBRXM=:13, FBZRDW=:14, FBZRDWJGDM=:15, YLKZLBH=:16, BBKRSJLX=:17, BBKRSJHM=:18, BBKRXM=:19, BBKRXB=:20, BBKRCSRQ=:21, BBKRQTTZXX=:22, DTXXLB=:23, HDFSSJ=:24, HDFSDDQH=:25, HDFSDDXZ=:26, HDFSDDSSSHCS=:27, HDFSDDSSSHCSDM=:28, HDFSDDSSGAJG=:29, HDFSDDSSGAJGJGDM=:30, DJZJLX=:31, DJZJHM=:32, DJXM=:33, DJXB=:34, DJCSRQ=:35, HDXGXX=:36, DTXXTGDW=:37, DTXXTGDWJGDM=:38, XXBDSJ=:39, XXBDDW=:40, XXBDDWJGDM=:41, DTGJXXBH=:42, QSSX=:43, XFSX=:44, SCCZFKSX=:45, CZCSYQ=:46, ZFYJ=:47, BSYJ=:48, BSRXM=:49, BSSJ=:50, SJXFSJ=:51, XXZT=:52, SFJL=:53, INFOID=:54, SFCK=:55 where ID=:56
b6q9ta11u4zbh	insert into t_sgxz_info_arrestinfor select * from T_INFO_ARRESTINFOR@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t where not exists( select t2.id from t_sgxz_info_arrestinfor t2 where t2.id =t.id)
b6usrg82hwsa3	call dbms_stats.gather_database_stats_job_proc ( )
bmk38162y2fvk	BEGIN new_add_update_r_x(34, 34, 30000, to_char(sysdate-3, 'yyyy-mm-dd'), to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss'), true); END;
c6j7upst6cwyv	select count(vsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.V_SJLD_RY_BDCKYJ_JF vsjldrybdc0_ where vsjldrybdc0_.XXZT=1 and (vsjldrybdc0_.SFJL<>'1' or vsjldrybdc0_.SFJL is null) and vsjldrybdc0_.SJLX<>'FQ'
c861h35upu6f1	BEGIN new_add_update_r_x(3, 3, 30000, to_char(sysdate-2, 'yyyy-mm-dd hh24:mi:ss'), to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss'), true); END;
dy75jqh67dtkq	insert into t_pzxt_gzdx select * from gzdx@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM
f8xpnsz1qpd5q	UPDATE t_sgzh_jcj_cjjl T SET T.JQLBBM3 =( select T2.JQLBBM3 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQLBBM4 =( select T2.JQLBBM4 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQLBBM1 =( select T2.JQLBBM1 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQLBBM2 =( select T2.JQLBBM2 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.SFZDDQ =( select T2.SFZDDQ from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.SFJTAJ =( select T2.SFJTAJ from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQFSQY =( select T2.JQFSQY from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.RYSHQK =( select T2.RYSHQK from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.XWFSBM =( select T2.XWFSBM from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.GZQK =( select T2.GZQK from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.CSCF =( select T2.CSCF from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JTLBBM =( select T2.JTLBBM from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQJB =( select T2.JQJB from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.ZDDQBM1 =( select T2.ZDDQBM1 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.ZDDQBM2 =( select T2.ZDDQBM2 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.ZDDQBM3 =( select T2.ZDDQBM3 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.ZDDQBM4 =( select T2.ZDDQBM4 from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JQFSCS =( select T2.JQFSCS from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.SJJHDWBM =( select T2.SJJHDWBM from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.Fjjqgsdw =( select T2.Fjjqgsdw from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.PCSJQGSDW =( select T2.PCSJQGSDW from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.DWID =( select T2.DWID from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.JD =( select T2.JD from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) , T.WD =( select T2.WD from t_sgzh_jcj_cjjl_backup t2 where t2.jjxh=t.jjxh ) where exists (select t3.jjxh from t_sgzh_jcj_cjjl_backup t3 where t3.jjxh=t.jjxh)
ff249x8n2x62q	insert into t_sgxz_sj_info_peacecasewindup t (select * from t_info_peacecasewindupinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM t2 where not exists (select t3.id from t_sgxz_sj_info_peacecasewindup t3 where t3.id =t2.id))
fvsdmwpp3xn5u	BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_23', 'CYGA_DW'); END;
fyaqfgmuzws2w	select count(*) FROM hc_translatecheckinfo@ORCL_71.REGRESS.RDBMS.DEV.US.ORACLE.COM where (SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) >= SUBSTR('2013-01-30', 1, 19) AND SUBSTR(TO_CHAR(LASTMODIFYDATE, 'YYYY-MM-DD HH24:MI:SS'), 1, 19) <= SUBSTR('2013-02-02 05:35:00', 1, 19))
g1n9ytf9d4mfy	select count(vsjldrybdc0_.ID) as col_0_0_ from CYGA_DW.V_SJLD_RY_BDCKYJ_JF vsjldrybdc0_ where vsjldrybdc0_.XXZT=2 and (vsjldrybdc0_.SFJL<>'1' or vsjldrybdc0_.SFJL is null) and vsjldrybdc0_.YJJB<>'5' and vsjldrybdc0_.SJLX<>'FQ'

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	1,164,486	46.25	51.51
CPU used when call started	1,124,057	44.64	49.72
CR blocks created	3,454	0.14	0.15
Cached Commit SCN referenced	4,202	0.17	0.19
Commit SCN cached	10	0.00	0.00
DB time	3,982,047	158.15	176.15
DBWR checkpoint buffers written	80,952	3.21	3.58
DBWR checkpoints	567	0.02	0.03
DBWR object drop buffers written	948	0.04	0.04
DBWR tablespace checkpoint buffers written	244	0.01	0.01
DBWR transaction table writes	610	0.02	0.03
DBWR undo block writes	25,532	1.01	1.13
IMU CR rollbacks	554	0.02	0.02
IMU Flushes	1,214	0.05	0.05
IMU Redo allocation size	3,631,600	144.23	160.65
IMU commits	21,796	0.87	0.96
IMU contention	14	0.00	0.00
IMU ktichg flush	714	0.03	0.03
IMU pool not allocated	17	0.00	0.00
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	123,091,608	4,888.54	5,445.09
IMU- failed to get a private strand	17	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	592	0.02	0.03
RowCR hits	1,084	0.04	0.05
SMON posted for undo segment shrink	12	0.00	0.00
SQL*Net roundtrips to/from client	521,723	20.72	23.08
SQL*Net roundtrips to/from dblink	621,978	24.70	27.51
active txn count during cleanout	46,986	1.87	2.08
application wait time	49	0.00	0.00
background checkpoints completed	9	0.00	0.00
background checkpoints started	9	0.00	0.00
background timeouts	89,500	3.55	3.96
branch node splits	0	0.00	0.00
buffer is not pinned count	78,471,279	3,116.46	3,471.26
buffer is pinned count	2,192,103	87.06	96.97
bytes received via SQL*Net from client	162,195,174	6,441.52	7,174.87
bytes received via SQL*Net from dblink	21,327,205,684	847,002.51	943,431.20
bytes sent via SQL*Net to client	146,234,882	5,807.67	6,468.85
bytes sent via SQL*Net to dblink	157,913,927	6,271.50	6,985.49
calls to get snapshot scn: kcmgss	6,241,582	247.88	276.10
calls to kcmgas	62,804	2.49	2.78
calls to kcmgcs	41,849	1.66	1.85
change write time	1,289	0.05	0.06
cleanout - number of ktugct calls	1,278,597	50.78	56.56
cleanouts and rollbacks - consistent read gets	197	0.01	0.01
cleanouts only - consistent read gets	1,231,473	48.91	54.48
cluster key scan block gets	289,677	11.50	12.81
cluster key scans	149,407	5.93	6.61
commit batch performed	69	0.00	0.00
commit batch requested	69	0.00	0.00
commit batch/immediate performed	94	0.00	0.00
commit batch/immediate requested	94	0.00	0.00
commit cleanout failures: block lost	2	0.00	0.00
commit cleanout failures: callback failure	101	0.00	0.00
commit cleanout failures: cannot pin	5	0.00	0.00
commit cleanouts	89,800	3.57	3.97
commit cleanouts successfully completed	89,692	3.56	3.97
commit immediate performed	25	0.00	0.00
commit immediate requested	25	0.00	0.00
commit txn count during cleanout	1,235,700	49.08	54.66
concurrency wait time	112	0.00	0.00
consistent changes	274,615	10.91	12.15
consistent gets	794,202,169	31,541.46	35,132.36
consistent gets - examination	141,028,015	5,600.88	6,238.52
consistent gets direct	6,919,093	274.79	306.07
consistent gets from cache	787,283,076	31,266.67	34,826.29
cursor authentications	3,098	0.12	0.14
data blocks consistent reads - undo records applied	6,821	0.27	0.30
db block changes	3,402,769	135.14	150.53
db block gets	5,091,960	202.23	225.25
db block gets direct	8,710	0.35	0.39
db block gets from cache	5,083,250	201.88	224.86
deferred (CURRENT) block cleanout applications	25,987	1.03	1.15
enqueue conversions	1,010,425	40.13	44.70
enqueue releases	443,810	17.63	19.63
enqueue requests	443,831	17.63	19.63
enqueue timeouts	17	0.00	0.00
enqueue waits	566	0.02	0.03
execute count	758,853	30.14	33.57
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	1,989,519	79.01	88.01
free buffer requested	2,096,695	83.27	92.75
heap block compress	19,970	0.79	0.88
hot buffers moved to head of LRU	557	0.02	0.02
immediate (CR) block cleanout applications	1,231,670	48.92	54.48
immediate (CURRENT) block cleanout applications	15,747	0.63	0.70
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	16,731	0.66	0.74
index fast full scans (full)	67	0.00	0.00
index fetch by key	70,568,989	2,802.62	3,121.69
index scans kdiixs1	375,533	14.91	16.61
leaf node 90-10 splits	128	0.01	0.01
leaf node splits	3,472	0.14	0.15
lob reads	4,162,116	165.30	184.12
lob writes	552,832	21.96	24.46
lob writes unaligned	552,395	21.94	24.44
logons cumulative	5,113	0.20	0.23
messages received	45,610	1.81	2.02
messages sent	45,610	1.81	2.02
no buffer to keep pinned count	6	0.00	0.00
no work - consistent read gets	647,514,516	25,715.81	28,643.48
opened cursors cumulative	433,904	17.23	19.19
parse count (failures)	19	0.00	0.00
parse count (hard)	8,129	0.32	0.36
parse count (total)	406,855	16.16	18.00
parse time cpu	6,497	0.26	0.29
parse time elapsed	7,366	0.29	0.33
physical read IO requests	610,293	24.24	27.00
physical read bytes	71,540,801,536	2,841,217.91	3,164,682.01
physical read total IO requests	634,433	25.20	28.06
physical read total bytes	72,762,804,224	2,889,749.32	3,218,738.57
physical read total multi block requests	552,134	21.93	24.42
physical reads	8,733,008	346.83	386.31
physical reads cache	1,992,740	79.14	88.15
physical reads cache prefetch	1,860,620	73.89	82.31
physical reads direct	6,740,268	267.69	298.16
physical reads direct (lob)	55,403	2.20	2.45
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	146	0.01	0.01
physical write IO requests	23,705	0.94	1.05
physical write bytes	751,951,872	29,863.51	33,263.38
physical write total IO requests	262,616	10.43	11.62
physical write total bytes	50,034,616,832	1,987,107.31	2,213,333.49
physical write total multi block requests	214,822	8.53	9.50
physical writes	91,791	3.65	4.06
physical writes direct	9,025	0.36	0.40
physical writes direct (lob)	7,685	0.31	0.34
physical writes direct temporary tablespace	974	0.04	0.04
physical writes from cache	82,766	3.29	3.66
physical writes non checkpoint	75,121	2.98	3.32
pinned buffers inspected	0	0.00	0.00
prefetch clients - default	17	0.00	0.00
prefetch warmup blocks flushed out before use	3	0.00	0.00
process last non-idle time	25,181	1.00	1.11
recovery blocks read	0	0.00	0.00
recursive calls	4,133,006	164.14	182.83
recursive cpu usage	132,640	5.27	5.87
redo blocks read for recovery	0	0.00	0.00
redo blocks written	1,707,995	67.83	75.55
redo buffer allocation retries	20	0.00	0.00
redo entries	1,630,409	64.75	72.12
redo log space requests	23	0.00	0.00
redo log space wait time	58	0.00	0.00
redo ordering marks	25,861	1.03	1.14
redo size	838,188,068	33,288.35	37,078.12
redo subscn max counts	71,138	2.83	3.15
redo synch time	2,980	0.12	0.13
redo synch writes	15,657	0.62	0.69
redo wastage	8,132,252	322.97	359.74
redo write time	4,108	0.16	0.18
redo writer latching time	5	0.00	0.00
redo writes	29,306	1.16	1.30
rollback changes - undo records applied	14,899	0.59	0.66
rollbacks only - consistent read gets	2,938	0.12	0.13
rows fetched via callback	410,809	16.32	18.17
session connect time	0	0.00	0.00
session cursor cache hits	247,452	9.83	10.95
session logical reads	799,294,129	31,743.69	35,357.61
shared hash latch upgrades - no wait	20,008	0.79	0.89
shared hash latch upgrades - wait	1	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	190,998	7.59	8.45
sorts (rows)	6,711,286	266.54	296.88
sql area evicted	9,887	0.39	0.44
sql area purged	44	0.00	0.00
switch current to new buffer	1,531	0.06	0.07
table fetch by rowid	1,115,713	44.31	49.35
table fetch continued row	8,090	0.32	0.36
table scan blocks gotten	577,622,918	22,940.09	25,551.75
table scan rows gotten	21,150,721,019	839,993.49	935,624.22
table scans (direct read)	689	0.03	0.03
table scans (long tables)	730	0.03	0.03
table scans (rowid ranges)	689	0.03	0.03
table scans (short tables)	1,148,149	45.60	50.79
total number of times SMON posted	12	0.00	0.00
transaction rollbacks	94	0.00	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	170,884,340	6,786.61	7,559.25
user I/O wait time	108,053	4.29	4.78
user calls	631,687	25.09	27.94
user commits	22,600	0.90	1.00
user rollbacks	6	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	91,569	3.64	4.05
write clones created in background	855	0.03	0.04
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 pga memory max	19,480,576,992	20,484,647,888
session cursor cache count	1,680,440	1,753,743
session uga memory	4.1E+13	4.3E+13
opened cursors current	256	282
workarea memory allocated	644	644
logons current	78	79
session uga memory max	2.8E+11	2.9E+11
session pga memory	13,953,401,824	14,627,826,640

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)	9	1.29

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
CYGA_YY_DATA	608,281	24	4.54	14.34	15,207	1	34
SYSAUX	115	0	7.39	1.22	3,678	0	0
UNDOTBS1	18	0	8.89	1.00	2,987	0	5
SYSTEM	338	0	1.80	1.00	1,233	0	0
SDE	843	0	5.71	3.74	14	0	0
CYGA_YY_INDEX	272	0	2.54	1.01	244	0	0
USERS	197	0	5.23	13.44	177	0	0
MAPUSER_RA	54	0	10.74	1.00	54	0	0
TEMP	66	0	0.30	14.76	40	0	0
DMETL	55	0	7.27	1.00	9	0	0
EXAMPLE	9	0	10.00	1.00	9	0	0
GADOOR	9	0	10.00	1.00	9	0	0
GASYS	9	0	12.22	1.00	9	0	0
MAPUSER	9	0	10.00	1.00	9	0	0
PORTAL	9	0	10.00	1.00	9	0	0
TEST	9	0	10.00	1.00	9	0	0

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)
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA.ORA	55,516	2	4.86	14.69	1,699	8	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA02.ORA	53,497	2	4.64	14.48	1,036	24	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA03.ORA	51,208	2	4.87	14.54	1,444	2	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA04.ORA	51,653	2	4.80	14.36	1,053	0	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA05.ORA	52,102	2	4.46	14.34	1,020	0	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA06.ORA	52,979	2	4.42	14.56	1,383	0	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA07.ORA	53,282	2	4.45	14.55	1,955	0	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA08.ORA	54,179	2	4.37	13.64	1,379	0	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA09.ORA	49,867	2	4.37	13.89	1,290	0	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA10.ORA	45,558	2	4.43	14.13	1,041	0	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA11.ORA	44,987	2	4.43	14.29	1,017	0	0.00
CYGA_YY_DATA	G:\ORACLE\ORCL\CYGA_YY_DATA12.ORA	43,453	2	4.35	14.65	890	0	0.00
CYGA_YY_INDEX	G:\ORACLE\ORCL\CYGA_YY_INDEX.ORA	138	0	2.32	1.02	124	0	0.00
CYGA_YY_INDEX	G:\ORACLE\ORCL\CYGA_YY_INDEX2.ORA	134	0	2.76	1.00	120	0	0.00
DMETL	G:\ORACLE\ORCL\DMETL02.ORA	55	0	7.27	1.00	9	0	0.00
EXAMPLE	G:\ORACLE\ORCL\EXAMPLE.ORA	9	0	10.00	1.00	9	0	0.00
GADOOR	G:\ORACLE\ORCL\GADOOR.ORA	9	0	10.00	1.00	9	0	0.00
GASYS	G:\ORACLE\ORCL\GASYS.ORA	9	0	12.22	1.00	9	0	0.00
MAPUSER	G:\ORACLE\ORCL\MAPUSER.ORA	9	0	10.00	1.00	9	0	0.00
MAPUSER_RA	G:\ORACLE\ORCL\MAPUSER_RA01.ORA	9	0	10.00	1.00	9	0	0.00
MAPUSER_RA	G:\ORACLE\ORCL\MAPUSER_RA02.ORA	9	0	10.00	1.00	9	0	0.00
MAPUSER_RA	G:\ORACLE\ORCL\MAPUSER_RA03.ORA	9	0	12.22	1.00	9	0	0.00
MAPUSER_RA	G:\ORACLE\ORCL\MAPUSER_RA04.ORA	9	0	10.00	1.00	9	0	0.00
MAPUSER_RA	G:\ORACLE\ORCL\MAPUSER_RA05.ORA	9	0	12.22	1.00	9	0	0.00
MAPUSER_RA	G:\ORACLE\ORCL\MAPUSER_RA06.ORA	9	0	10.00	1.00	9	0	0.00
PORTAL	G:\ORACLE\ORCL\PORTAL.ORA	9	0	10.00	1.00	9	0	0.00
SDE	G:\ORACLE\ORCL\SDE.ORA	843	0	5.71	3.74	14	0	0.00
SYSAUX	G:\ORACLE\ORCL\SYSAUX01.DBF	58	0	7.59	1.00	1,228	0	0.00
SYSAUX	G:\ORACLE\ORCL\SYSAUX02.DBF	57	0	7.19	1.44	2,450	0	0.00
SYSTEM	G:\ORACLE\ORCL\SYSTEM01.DBF	329	0	1.58	1.00	844	0	0.00
SYSTEM	G:\ORACLE\ORCL\SYSTEM02.DBF	9	0	10.00	1.00	389	0	0.00
TEMP	G:\ORACLE\ORCL\TEMP02.DBF	66	0	0.30	14.76	40	0
TEST	G:\ORACLE\ORCL\TEST.ORA	9	0	10.00	1.00	9	0	0.00
UNDOTBS1	G:\ORACLE\ORCL\UNDOTBS01.DBF	9	0	10.00	1.00	2,024	5	0.00
UNDOTBS1	G:\ORACLE\ORCL\UNDOTBS02.DBF	9	0	7.78	1.00	963	0	0.00
USERS	G:\ORACLE\ORCL\USERS01.DBF	197	0	5.23	13.44	177	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	975,647	100	792,146,359	1,992,740	82,766	0	0	39

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	25	302	1199	368287	921600	368287
E	0	25	395	1221	1573	921600	1573

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	784	0.10	96,971	37.76	1,199,842,477
D	1,568	0.20	193,942	2.78	88,487,719
D	2,352	0.30	290,913	1.35	42,752,079
D	3,136	0.40	387,884	1.14	36,082,785
D	3,920	0.50	484,855	1.03	32,792,715
D	4,704	0.60	581,826	1.01	32,193,703
D	5,488	0.70	678,797	1.01	31,986,312
D	6,272	0.80	775,768	1.00	31,873,944
D	7,056	0.89	872,739	1.00	31,806,232
D	7,840	0.99	969,710	1.00	31,776,715
D	7,888	1.00	975,647	1.00	31,775,503
D	8,624	1.09	1,066,681	1.00	31,756,608
D	9,408	1.19	1,163,652	1.00	31,743,359
D	10,192	1.29	1,260,623	1.00	31,736,170
D	10,976	1.39	1,357,594	1.00	31,730,833
D	11,760	1.49	1,454,565	1.00	31,730,517
D	12,544	1.59	1,551,536	1.00	31,729,930
D	13,328	1.69	1,648,507	1.00	31,729,869
D	14,112	1.79	1,745,478	1.00	31,729,862
D	14,896	1.89	1,842,449	1.00	31,729,847
D	15,680	1.99	1,939,420	0.99	31,517,577

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	41,848	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	3,240	2,845	166.62	0.63	0.38	100.00	0.00	331,770
E	3,240	2,830	183.32	0.63	0.34	100.00	0.00	331,770

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	71,904	71,904
64K	128K	234	234
128K	256K	30	30
256K	512K	56	56
512K	1024K	5,868	5,868
1M	2M	8,735	8,735
2M	4M	1,504	1,504
4M	8M	3,196	3,196
8M	16M	30	30
32M	64M	1	1
64M	128M	10	10

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd PGA Cache Hit %
405	0.13	2,184,117.42	100.00
810	0.25	2,184,117.42	100.00
1,620	0.50	2,184,117.42	100.00
2,430	0.75	2,184,117.42	100.00
3,240	1.00	2,184,117.42	100.00
3,888	1.20	2,184,117.42	100.00
4,536	1.40	2,184,117.42	100.00
5,184	1.60	2,184,117.42	100.00
5,832	1.80	2,184,117.42	100.00
6,480	2.00	2,184,117.42	100.00
9,720	3.00	2,184,117.42	100.00
12,960	4.00	2,184,117.42	100.00
19,440	6.00	2,184,117.42	100.00
25,920	8.00	2,184,117.42	100.00

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
464	0.38	147	13,640	422,431	0.99	5,108	1.85	42,600
592	0.48	269	17,768	423,885	1.00	3,654	1.33	42,839
720	0.58	405	21,956	424,433	1.00	3,106	1.13	42,940
848	0.69	531	27,970	424,604	1.00	2,935	1.06	42,988
976	0.79	654	34,350	424,688	1.00	2,851	1.03	43,017
1,104	0.90	781	39,884	424,744	1.00	2,795	1.01	43,037
1,232	1.00	908	46,128	424,783	1.00	2,756	1.00	43,050
1,360	1.10	1,035	52,240	424,806	1.00	2,733	0.99	43,056
1,488	1.21	1,162	57,800	424,828	1.00	2,711	0.98	43,062
1,616	1.31	1,289	63,697	424,851	1.00	2,688	0.98	43,067
1,744	1.42	1,416	69,792	424,885	1.00	2,654	0.96	43,072
1,872	1.52	1,543	76,453	424,925	1.00	2,614	0.95	43,078
2,000	1.62	1,671	81,796	424,957	1.00	2,582	0.94	43,083
2,128	1.73	1,798	89,237	424,971	1.00	2,568	0.93	43,087
2,256	1.83	1,925	97,556	424,979	1.00	2,560	0.93	43,089
2,384	1.94	2,052	106,868	424,991	1.00	2,548	0.92	43,092
2,512	2.04	2,179	115,875	425,003	1.00	2,536	0.92	43,095

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,300	0.25	647,993	88,377,206
4,600	0.50	504,535	32,760,544
6,900	0.75	501,978	31,842,232
9,200	1.00	501,426	31,775,503
11,500	1.25	501,276	31,711,952
13,800	1.50	501,225	31,699,242
16,100	1.75	501,175	31,486,346
18,400	2.00	500,874	31,486,346

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)
data block	34	0	0
undo header	5	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	Av Wt Time(ms)
TQ-Queue table enqueue (DDL contention)	34	34	0	3	83.67
RO-Multiple Object Reuse (fast object reuse)	441	441	0	49	3.88
UL-User-defined	130	123	7	4	42.75
KO-Multiple Object Checkpoint (fast object checkpoint)	4,581	4,581	0	509	0.21
TQ-Queue table enqueue (TM contention)	23	23	0	1	78.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	24.91	30,283	1,343	5	15/35.4	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
02-2月 06:57	8	67	84	2	15	0/0	0/0/0/0/0/0
02-2月 06:47	8	134	0	2	15	0/0	0/0/0/0/0/0
02-2月 06:37	4	62	0	3	15	0/0	0/0/0/0/0/0
02-2月 06:27	3	81	0	1	15	0/0	0/0/0/0/0/0
02-2月 06:17	8	82	0	2	15	0/0	0/0/0/0/0/0
02-2月 06:07	521	847	0	3	15	0/0	0/0/0/0/0/0
02-2月 05:57	570	68	357	2	19	0/0	0/0/0/0/0/0
02-2月 05:47	12	122	1,343	4	35	0/0	0/0/0/0/0/0
02-2月 05:37	4,534	977	734	4	25	0/0	0/0/0/0/0/0
02-2月 05:27	12	209	125	2	15	0/0	0/0/0/0/0/0
02-2月 05:17	5	56	0	1	15	0/0	0/0/0/0/0/0
02-2月 05:07	74	220	0	3	15	0/0	0/0/0/0/0/0
02-2月 04:57	5	55	0	1	15	0/0	0/0/0/0/0/0
02-2月 04:47	3	82	0	1	15	0/0	0/0/0/0/0/0
02-2月 04:37	7	177	0	1	15	0/0	0/0/0/0/0/0
02-2月 04:27	575	125	274	2	19	0/0	0/0/0/0/0/0
02-2月 04:17	7	95	0	2	15	0/0	0/0/0/0/0/0
02-2月 04:07	4,596	1,192	61	5	16	0/0	0/0/0/0/0/0
02-2月 03:57	8	83	0	2	15	0/0	0/0/0/0/0/0
02-2月 03:47	9	162	0	1	15	0/0	0/0/0/0/0/0
02-2月 03:37	183	227	138	2	17	0/0	0/0/0/0/0/0
02-2月 03:27	9	119	0	1	15	0/0	0/0/0/0/0/0
02-2月 03:17	5	103	0	1	15	0/0	0/0/0/0/0/0
02-2月 03:07	95	317	0	3	15	0/0	0/0/0/0/0/0
02-2月 02:57	573	110	0	2	15	0/0	0/0/0/0/0/0
02-2月 02:47	14	192	0	3	15	0/0	0/0/0/0/0/0
02-2月 02:37	4,553	1,096	126	4	15	0/0	0/0/0/0/0/0
02-2月 02:27	15	217	117	2	15	0/0	0/0/0/0/0/0
02-2月 02:17	208	4,530	0	3	15	0/0	0/0/0/0/0/0
02-2月 02:07	76	451	0	3	15	0/0	0/0/0/0/0/0
02-2月 01:57	1,787	6,368	0	3	15	0/0	0/0/0/0/0/0
02-2月 01:47	7	85	0	1	15	0/0	0/0/0/0/0/0
02-2月 01:37	1,052	8,635	0	2	15	0/0	0/0/0/0/0/0
02-2月 01:27	576	145	0	2	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	NoWait Requests	Pct NoWait Miss
ASM db client latch	18,115	0.00		0
AWR Alerted Metric Element list	120,286	0.00		0
Consistent RBA	29,315	0.01	0.00	0
FAL request queue	521	0.00		0
FAL subheap alocation	521	0.00		0
FIB s.o chain latch	70	0.00		0
FOB s.o list latch	4,167	0.00		0
In memory undo latch	193,316	0.01	0.65	30,168	0.00
JS Sh mem access	2	0.00		0
JS mem alloc latch	187	0.00		0
JS queue access latch	187	0.00		0
JS queue state obj latch	182,140	0.00		0
KMG MMAN ready and startup request latch	8,394	0.00		0
KTF sga latch	45	0.00		7,772	0.00
KWQMN job cache list latch	187	0.00		0
KWQP Prop Status	184	0.00		0
MQL Tracking Latch	0			495	0.00
Memory Management Latch	0			8,394	0.00
Memory Queue Message Subscriber #1	4,216	0.05	0.00	0
Memory Queue Subscriber	6,751	0.03	0.00	0
OS process	14,982	0.00		0
OS process allocation	18,383	0.03	0.00	0
OS process: request allocation	9,358	0.00		0
PL/SQL warning settings	10,969	0.00		0
SGA IO buffer pool latch	128,046	0.00		128,046	0.00
SQL memory manager latch	7	0.00		8,391	0.00
SQL memory manager workarea list latch	909,261	0.00	0.00	0
STREAMS Pool Advisor	0			87	0.00
Shared B-Tree	2,381	0.00		0
active checkpoint queue latch	35,774	1.84	0.00	0
active service list	75,584	0.37	0.79	13,262	0.00
alert log latch	18	0.00		0
archive control	512	0.00		0
archive process latch	9,451	0.00		0
begin backup scn array	7,605	0.00		0
bq:time manger info latch	96	0.00		0
bufq statistics	2,861	0.03	0.00	0
cache buffer handles	123,188	0.00		0
cache buffers chains	1,452,789,949	0.01	0.00	4,019,714	0.00
cache buffers lru chain	222,594	0.13	0.00	4,887,570	0.00
cache table scan latch	0			127,998	0.00
channel handle pool latch	9,408	0.00		0
channel operations parent latch	163,533	0.52	0.00	0
checkpoint queue latch	1,717,354	0.01	0.01	82,547	0.00
client/application info	33,336	0.00		0
commit callback allocation	122	0.00		0
compile environment latch	5,113	0.00		0
datapump attach fixed tables latch	266	1.13	0.00	0
datapump job fixed tables latch	266	0.38	0.00	0
dictionary lookup	98	0.00		0
dml lock allocation	95,799	0.00		0
dummy allocation	10,225	0.22	0.00	0
enqueue hash chains	1,899,165	0.00	0.00	0
enqueue sob latch	7	0.00		0
enqueues	921,697	0.01	0.00	0
event group latch	4,680	0.00		0
file cache latch	2,641	0.00		0
global KZLD latch for mem in SGA	4,518	0.00		0
global tx hash mapping	122,991	0.00		0
hash table column usage latch	1,647	0.00		195,970	0.00
hash table modification latch	646	0.00		0
image handles of buffered messages latch	4,216	0.05	0.00	0
internal temp table object number allocation latc	3	0.00		0
interrupt manipulation	4	0.00		0
job workq parent latch	0			874	0.00
job_queue_processes parameter latch	855	0.00		0
kks stats	52,083	0.00		0
kmcptab latch	2	0.00		0
kmcpvec latch	0			2	0.00
kokc descriptor allocation latch	648,546	0.02	0.00	0
ksuosstats global area	1,693	0.00		0
ktm global data	115	0.00		0
kupp process latch	50	0.00		4	0.00
kwqbsgn:msghdr	6,324	0.00		0
kwqbsn:qsga	2,098	0.00		87	0.00
kwqbsn:qxl	44	0.00		0
kwqi:kchunk latch	4	0.00		0
lgwr LWN SCN	36,150	0.30	0.00	0
library cache	6,800,717	0.01	0.01	54,347	0.01
library cache load lock	11,404	0.00		0
library cache lock	11,492,750	0.01	0.00	0
library cache lock allocation	66,750	0.01	0.00	0
library cache pin	1,035,765	0.01	0.00	0
library cache pin allocation	14,965	0.00		0
list of block allocation	6,117	0.03	0.00	0
loader state object freelist	56,116	0.00		0
logminer context allocation	7	0.00		0
longop free list parent	402	0.00		80	0.00
message pool operations parent latch	5,446	0.00		0
messages	312,787	0.24	0.00	0
mostly latch-free SCN	36,228	0.51	0.00	0
multiblock read objects	259,462	0.00		0
ncodef allocation latch	416	0.00		0
object queue header heap	145,049	0.00		12,776	0.02
object queue header operation	4,598,641	0.01	0.00	0
object stats modification	64	0.00		0
parallel query alloc buffer	3,072	0.00		0
parameter list	226	0.00		0
parameter table management	10,248	0.00		0
pass worker exception to master	38	0.00		0
post/wait queue	23,662	0.00		15,685	0.00
process allocation	9,358	0.01	0.00	4,679	0.02
process group creation	9,358	0.05	0.00	0
qmn state object latch	4	0.00		0
qmn task queue latch	8,660	3.76	0.04	0
queue sender's info. latch	8,253	0.56	0.00	0
redo allocation	165,548	0.03	0.00	1,630,289	0.01
redo copy	0			1,630,325	0.04
redo writing	138,676	0.39	0.00	0
resmgr group change latch	7,191	0.00		0
resmgr:active threads	10,113	0.00		0
resmgr:actses change group	4,957	0.00		0
resmgr:actses change state	2	0.00		0
resmgr:free threads list	10,105	0.54	0.00	0
resmgr:resource group CPU method	4,954	0.50	0.00	0
resmgr:schema config	7	0.00		0
resumable state object	337	0.00		0
row cache objects	10,882,584	0.02	0.00	1,608	0.00
rules engine aggregate statistics	4,580	0.00		0
rules engine evaluation context statistics	8	0.00		0
rules engine rule set statistics	12,000	0.01	0.00	0
rules engine rule statistics	2,116	0.00		0
sequence cache	48,889	0.00		0
session allocation	425,685	0.15	0.63	0
session idle bit	1,458,816	0.00	0.00	0
session state list latch	10,383	0.00		0
session switching	23,806	0.00		0
session timer	8,516	0.00		0
shared pool	1,967,640	0.08	0.01	0
shared pool simulator	108,465	0.00		0
simulator hash latch	60,783,739	0.00	0.01	0
simulator lru latch	82,878	0.16	0.02	60,364,377	0.06
slave class	60	0.00		0
slave class create	240	2.50	1.00	0
sort extent pool	841	0.00		0
spilled messages latch	12	0.00		0
state object free list	14	0.00		0
statistics aggregation	3,920	0.00		0
temp lob duration state obj allocation	31	0.00		0
temporary table state object allocation	6	0.00		0
threshold alerts latch	3,230	0.00		0
transaction allocation	3,100	0.00		0
transaction branch allocation	9,380	0.00		0
undo global data	2,580,979	0.00	0.00	0
user lock	18,950	3.07	0.01	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	1,452,789,949	128,241	146	128,096
row cache objects	10,882,584	2,635	3	2,632
shared pool	1,967,640	1,576	22	1,561
messages	312,787	744	1	743
library cache	6,800,717	690	5	685
session allocation	425,685	628	397	315
user lock	18,950	582	6	576
qmn task queue latch	8,660	326	14	312
simulator hash latch	60,783,739	323	2	321
cache buffers lru chain	222,594	292	1	291
active service list	75,584	282	223	85
object queue header operation	4,598,641	244	1	243
simulator lru latch	82,878	132	3	129
checkpoint queue latch	1,717,354	88	1	87
In memory undo latch	193,316	23	15	8
slave class create	240	6	6	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	13	3
In memory undo latch	ktiFlush: child	2	0
In memory undo latch	kturbk	2	13
active service list	kswslogon: session logout	283	283
cache buffers chains	kcbgtcr: kslbegin excl	885	764
cache buffers chains	kcbrls: kslbegin	53	164
cache buffers chains	kcbbxsv	15	13
cache buffers chains	kcbgcur: kslbegin	7	0
cache buffers chains	kcbzib: multi-block read: nowait	4	0
cache buffers chains	kcbbic1	1	0
cache buffers chains	kcbbic2	1	1
cache buffers chains	kcbchg: kslbegin: bufs not pinned	1	6
cache buffers lru chain	kcbbic2	1	0
checkpoint queue latch	kcbkubc	1	0
cost function	kzulrl	6	6
event range base latch	No latch	14	14
library cache	kglLockCursor	2	1
library cache	kglScanDependency	2	0
messages	ksarcv	1	0
object queue header operation	kcbo_swap_buf_bg	1	0
object queue header operation	kcbo_switch_mq_bg	1	1
row cache objects	kqrpre: find obj	2	2
row cache objects	kqreqd: reget	1	0
session allocation	ksuxds: KSUSFCLC not set	396	372
session allocation	ksudlp	1	24
shared pool	kghalo	10	14
shared pool	kghfrunp: alloc: cursor dur	6	0
shared pool	kghupr1	5	1
shared pool	kghfre	1	5
shared pool	kghfrunp: clatch: nowait	1	0
simulator hash latch	kcbs_lookup_setid: lookup dba	1	0
simulator hash latch	kcbsacc: lookup dba	1	2
simulator lru latch	kcbs_simbufseq	2	3
simulator lru latch	kcbs_simulate: simulate set	1	0
slave class create	ksvcreate	6	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: 799,294,129
Captured Segments account for 98.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
CYGA_DW	CYGA_YY_DATA	T_SJLD_RY_BDCKYJQBXX_JF	TABLE	95,672,976	11.97
CYGA_DW	CYGA_YY_DATA	T_SJLD_RY_BDCKYJQBCZFKXX_JF	TABLE	83,641,712	10.46
CYGA_DW	CYGA_YY_DATA	T_SCXX_SCRYXXB	TABLE	72,140,752	9.03
CYGA_DW	CYGA_YY_DATA	DICTIONARY_REF	TABLE	52,607,392	6.58
CYGA_DW	CYGA_YY_DATA	PK_T_INFO_CASETOPEOPLE38	INDEX	37,266,624	4.66

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 8,733,008
Captured Segments account for 64.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
CYGA_DW	CYGA_YY_DATA	T_SGHC_TRANSLATECHECKINFO	TABLE	2,549,955	29.20
CYGA_DW	CYGA_YY_DATA	T_JCLG_CHINESE_NEW	TABLE	743,101	8.51
CYGA_DW	CYGA_YY_DATA	CHINESE_BACKUP	TABLE	723,917	8.29
CYGA_DW	CYGA_YY_DATA	T_SGZH_JCJ_JJJL	TABLE	442,588	5.07
CYGA_DW	CYGA_YY_DATA	T_SGRK_RY_ZANZHURENYUAN	TABLE	397,582	4.55

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
CYGA_DW	CYGA_YY_DATA	IDX_CJJL_SJC		INDEX	2	66.67
CYGA_DW	CYGA_YY_DATA	PK_T_XTBG_XX_XXXXB		INDEX	1	33.33

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	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
CYGA_DW	CYGA_YY_DATA	T_SJLD_BDZDRLKBK_JBXX		TABLE	34	100.00

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	440	0.00	14	1
dc_constraints	66	36.36	66	3
dc_database_links	1,239,048	0.00	0	3
dc_files	36	100.00	0	36
dc_global_oids	334,708	0.07	8	319
dc_histogram_data	214,610	1.90	619	6,769
dc_histogram_defs	224,536	8.69	741	13,413
dc_object_grants	8,643	2.50	0	372
dc_object_ids	426,456	0.67	46	3,613
dc_objects	77,039	2.34	249	1,947
dc_profiles	4,972	0.00	0	1
dc_rollback_segments	5,768	0.00	0	36
dc_segments	24,713	9.23	417	3,400
dc_sequences	158	5.06	158	24
dc_table_scns	6	100.00	0	0
dc_tablespace_quotas	319	0.00	319	1
dc_tablespaces	229,333	0.00	0	17
dc_usernames	263,061	0.00	0	51
dc_users	743,466	0.00	0	84
global database name	4	25.00	0	1
outstanding_alerts	1,361	0.59	16	32

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	5,212	1.84	29,767	0.36	8	0
CLUSTER	417	0.24	653	0.31	1	0
INDEX	207	36.71	733	18.01	10	0
PIPE	6	16.67	6	16.67	0	0
SQL AREA	199,169	5.40	3,014,482	0.70	2,719	446
TABLE/PROCEDURE	49,341	3.65	455,134	1.20	974	0
TRIGGER	551	0.36	2,134	0.56	9	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	104.92		1.31	0.93	5	21	80	80
	Freeable	58.31	0.00	1.06	0.48	3		55	55
	SQL	2.26	1.71	0.03	0.07	0	51	70	54
	PL/SQL	1.14	0.84	0.01	0.01	0	0	78	78
E	Other	112.66		1.37	1.07	6	21	82	82
	Freeable	58.06	0.00	1.10	0.49	3		53	53
	SQL	9.94	9.30	0.14	0.91	8	128	71	54
	PL/SQL	2.67	2.37	0.03	0.17	2	2	79	79

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	8,271,167,488
Fixed Size	2,093,288
Redo Buffers	14,680,064
Variable Size	1,358,958,360

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	29.00	29.00	0.00
shared	CCursor	94.35	76.20	-19.24
shared	KGLS heap		14.34
shared	PCursor	70.23	55.98	-20.28
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	208.00	292.74	40.74
shared	kglsim heap	15.35	15.35	0.00
shared	kglsim object batch	28.53	28.53	0.00
shared	library cache	76.87	57.53	-25.15
shared	sql area	519.85	458.17	-11.86
streams	free memory	31.94	31.93	-0.01
	buffer_cache	7,888.00	7,888.00	0.00
	fixed_sga	2.00	2.00	0.00
	log_buffer	14.00	14.00	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

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

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	46,875	14,428	0
QMON Coordinator	15,625	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	16	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	E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest	E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
compatible	10.2.0.1.0
control_files	G:\ORACLE\ORCL\CONTROL01.CTL, G:\ORACLE\ORCL\CONTROL02.CTL, G:\ORACLE\ORCL\CONTROL03.CTL
core_dump_dest	E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	orcl
db_recovery_file_dest	e:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes	10
log_archive_dest_1	LOCATION=h:\archive
log_archive_format	ARC%S_%R.%T
nls_language	SIMPLIFIED CHINESE
nls_territory	CHINA
open_cursors	300
pga_aggregate_target	3397386240
processes	800
remote_login_passwordfile	EXCLUSIVE
sga_target	9646899200
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP

End of Report

% Blocks changed per Read:	0.43	Recursive Call %:	86.74
Rollback per transaction %:	0.03	Rows per Sort:	35.14

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.76	In-memory Sort %:	100.00
Library Hit %:	99.24	Soft Parse %:	98.00
Execute to Parse %:	46.39	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	88.20	% Non-Parse CPU:	99.45