WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

BSRUN 3665712972 bsrun 1 10.2.0.5.0 NO LQYY-ORACLE

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
BSRUN	3665712972	bsrun	1	10.2.0.5.0	NO	LQYY-ORACLE

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 3642 14-5月 -12 09:00:47 1037 2.9

End Snap: 3643 14-5月 -12 10:00:49 1061 3.0

Elapsed: 60.03 (mins)

DB Time: 122.74 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	3642	14-5月 -12 09:00:47	1037	2.9
End Snap:	3643	14-5月 -12 10:00:49	1061	3.0
Elapsed:		60.03 (mins)
DB Time:		122.74 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 4,544M 4,544M Std Block Size: 8K

Shared Pool Size: 2,272M 2,272M Log Buffer: 14,344K

	Begin	End
Buffer Cache:	4,544M	4,544M	Std Block Size:	8K
Shared Pool Size:	2,272M	2,272M	Log Buffer:	14,344K

Load Profile

Per Second Per Transaction

Redo size: 21,739.98 1,833.19

Logical reads: 104,479.02 8,810.04

Block changes: 148.59 12.53

Physical reads: 0.67 0.06

Physical writes: 7.39 0.62

User calls: 866.77 73.09

Parses: 407.81 34.39

Hard parses: 3.08 0.26

Sorts: 35.01 2.95

Logons: 0.58 0.05

Executes: 403.58 34.03

Transactions: 11.86

	Per Second	Per Transaction
Redo size:	21,739.98	1,833.19
Logical reads:	104,479.02	8,810.04
Block changes:	148.59	12.53
Physical reads:	0.67	0.06
Physical writes:	7.39	0.62
User calls:	866.77	73.09
Parses:	407.81	34.39
Hard parses:	3.08	0.26
Sorts:	35.01	2.95
Logons:	0.58	0.05
Executes:	403.58	34.03
Transactions:	11.86

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

Rollback per transaction %: 1.30 Rows per Sort: 251.67

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 98.75 Soft Parse %: 99.24

Execute to Parse %: -1.05 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 98.33 % Non-Parse CPU: 98.74

Shared Pool Statistics

Begin End

Memory Usage %: 86.56 76.88

% SQL with executions>1: 87.37 86.56

% Memory for SQL w/exec>1: 88.16 88.69

	Begin	End
Memory Usage %:	86.56	76.88
% SQL with executions>1:	87.37	86.56
% Memory for SQL w/exec>1:	88.16	88.69

Top 5 Timed Events

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

CPU time 7,163 97.3

SQL*Net more data to client 3,006,588 151 0 2.1 Network

log file sync 42,013 89 2 1.2 Commit

log file parallel write 43,383 75 2 1.0 System I/O

control file parallel write 1,717 16 9 .2 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		7,163		97.3
SQL*Net more data to client	3,006,588	151	0	2.1	Network
log file sync	42,013	89	2	1.2	Commit
log file parallel write	43,383	75	2	1.0	System I/O
control file parallel write	1,717	16	9	.2	System 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): 7364.4s
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
DB CPU	7,162.80	97.26
sql execute elapsed time	6,786.43	92.15
parse time elapsed	99.89	1.36
hard parse elapsed time	39.72	0.54
connection management call elapsed time	7.07	0.10
PL/SQL execution elapsed time	7.05	0.10
failed parse elapsed time	2.86	0.04
hard parse (sharing criteria) elapsed time	2.79	0.04
hard parse (bind mismatch) elapsed time	0.56	0.01
PL/SQL compilation elapsed time	0.24	0.00
repeated bind elapsed time	0.11	0.00
sequence load elapsed time	0.00	0.00
DB time	7,364.39
background elapsed time	175.19
background cpu time	17.84

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			7,163		97.26
Network	5,922,802		160	0	2.18
System I/O	49,265		94	2	1.28
Commit	42,013	0	89	2	1.21
User I/O	2,443		11	4	0.15
Application	8,852		3	0	0.04
Concurrency	227		2	10	0.03
Configuration	7		0	20	0.00
Other	147		0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
SQL*Net more data to client	3,006,588		151	0	70.38
log file sync	42,013	0	89	2	0.98
log file parallel write	43,383		75	2	1.02
control file parallel write	1,717		16	9	0.04
db file sequential read	2,405		11	4	0.06
SQL*Net message to client	2,908,638		9	0	68.09
SQL*Net break/reset to client	8,780		2	0	0.21
control file sequential read	3,985		2	1	0.09
latch: shared pool	113		2	15	0.00
log file sequential read	92		1	9	0.00
enq: TX - row lock contention	72		1	9	0.00
Log archive I/O	84		0	3	0.00
os thread startup	23		0	12	0.00
SQL*Net more data from client	7,576		0	0	0.18
latch: library cache	24		0	6	0.00
log file switch completion	7		0	20	0.00
latch: row cache objects	10		0	10	0.00
latch free	74		0	0	0.00
direct path write	24		0	0	0.00
rdbms ipc reply	5		0	1	0.00
LGWR wait for redo copy	64		0	0	0.00
row cache lock	2		0	1	0.00
log file single write	4		0	0	0.00
latch: cache buffers chains	35		0	0	0.00
latch: In memory undo latch	8		0	0	0.00
buffer busy waits	12		0	0	0.00
latch: messages	2		0	0	0.00
direct path read	14		0	0	0.00
latch: object queue header operation	1		0	0	0.00
cursor: pin S	1		0	0	0.00
SQL*Net message from client	2,909,474		652,223	224	68.11
virtual circuit status	1,407,444	0	174,561	124	32.95
jobq slave wait	1,215	96	3,633	2990	0.03
wait for unread message on broadcast channel	3,602	100	3,600	999	0.08
class slave wait	8		0	0	0.00
i/o slave wait	6		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	43,383		75	2	1.02
control file parallel write	1,717		16	9	0.04
control file sequential read	3,924		2	1	0.09
log file sequential read	92		1	9	0.00
Log archive I/O	84		0	3	0.00
os thread startup	23		0	12	0.00
db file sequential read	66		0	2	0.00
events in waitclass Other	72		0	0	0.00
log file single write	4		0	0	0.00
direct path read	14		0	0	0.00
latch: cache buffers chains	1		0	0	0.00
direct path write	14		-0	-0	0.00
rdbms ipc message	57,995	24	44,563	768	1.36
pmon timer	1,518	100	3,594	2368	0.04
smon timer	15	53	3,399	226597	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	32,593
AVG_IDLE_TIME	327,388
AVG_SYS_TIME	2,196
AVG_USER_TIME	30,279
BUSY_TIME	785,065
IDLE_TIME	7,859,956
SYS_TIME	55,458
USER_TIME	729,607
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	5.9E+18
VM_OUT_BYTES	3.8E+15
PHYSICAL_MEMORY_BYTES	17,176,322,048
NUM_CPUS	24
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
bsrun	7,318.20	7,115.60	2,260	374,180,865
SYS$USERS	50.40	51.50	47	2,185,152
SYS$BACKGROUND	0.00	0.00	105	33,354

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
bsrun	2266	10	152	2	5914385	160
SYS$USERS	47	0	1	0	2205	0
SYS$BACKGROUND	130	0	24	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): 7,364
Captured SQL account for 73.7% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
2,404	2,403	823	2.92	32.64	4s1sawzgtvspt	Main.exe	SELECT B.FYCK, B.FPHM, A.BRXM ...
379	374	605	0.63	5.14	aazrv4j48xq9s	mzgl.exe	Select BRXZ , BRID , ZFPB , CK...
287	222	603	0.48	3.89	9k86kjgywamrq	clinic.exe	SELECT GY_JBBM.JBXH, GY_JBBM....
177	175	528	0.33	2.40	105kp2gu0mpk2	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01.B...
172	171	822	0.21	2.33	41kj4j88fbp9y	Main.exe	SELECT B.FYCK, B.FPHM, A.BRXM ...
158	158	2,242	0.07	2.15	755n8d4g0u6g7	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
140	139	822	0.17	1.90	2drauwv4cpx9p	Main.exe	SELECT B.FYCK, B.FPHM, A.BRXM ...
134	133	16,035	0.01	1.82	3yhfanm17kgcq	indoctor.exe	SELECT LCBZ FROM YS_ZY_JZJL WH...
124	123	823	0.15	1.69	2kdz115yahc1c	pb90.exe	select sum ( ms_sfmx.zjje ) fr...
114	115	2,641	0.04	1.55	fga17xtru63gg	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01.B...
107	103	9,636	0.01	1.45	bxv4auh6fkjdy	bqgl.exe	SELECT TJBQ, TJYF, YZLX, FYFS...
101	100	1,223	0.08	1.37	67mfx2u3cwpbq	clinic.exe	SELECT YS_MZ_JZLS.BRBH, MS_BR...
89	88	660	0.14	1.21	702ggkq5a61pg	indoctor.exe	SELECT COUNT ( 1 ) FROM LC_LCY...
79	79	1,251	0.06	1.08	3hu5zwxu8fcpp	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
79	78	598	0.13	1.07	0f2cqymcw7hqm	clinic.exe	select count ( 1 ) from ys_mz_...
77	76	137	0.56	1.04	9gpjxpz3m4551	mzgl.exe	Select ckxx , brid From GY_CKD...

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): 7,163
Captured SQL account for 74.5% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
2,403	2,404	823	2.92	33.55	32.64	4s1sawzgtvspt	Main.exe	SELECT B.FYCK, B.FPHM, A.BRXM ...
374	379	605	0.62	5.21	5.14	aazrv4j48xq9s	mzgl.exe	Select BRXZ , BRID , ZFPB , CK...
222	287	603	0.37	3.09	3.89	9k86kjgywamrq	clinic.exe	SELECT GY_JBBM.JBXH, GY_JBBM....
175	177	528	0.33	2.44	2.40	105kp2gu0mpk2	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01.B...
171	172	822	0.21	2.39	2.33	41kj4j88fbp9y	Main.exe	SELECT B.FYCK, B.FPHM, A.BRXM ...
158	158	2,242	0.07	2.20	2.15	755n8d4g0u6g7	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
139	140	822	0.17	1.95	1.90	2drauwv4cpx9p	Main.exe	SELECT B.FYCK, B.FPHM, A.BRXM ...
133	134	16,035	0.01	1.86	1.82	3yhfanm17kgcq	indoctor.exe	SELECT LCBZ FROM YS_ZY_JZJL WH...
123	124	823	0.15	1.71	1.69	2kdz115yahc1c	pb90.exe	select sum ( ms_sfmx.zjje ) fr...
115	114	2,641	0.04	1.60	1.55	fga17xtru63gg	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01.B...
103	107	9,636	0.01	1.44	1.45	bxv4auh6fkjdy	bqgl.exe	SELECT TJBQ, TJYF, YZLX, FYFS...
100	101	1,223	0.08	1.39	1.37	67mfx2u3cwpbq	clinic.exe	SELECT YS_MZ_JZLS.BRBH, MS_BR...
88	89	660	0.13	1.23	1.21	702ggkq5a61pg	indoctor.exe	SELECT COUNT ( 1 ) FROM LC_LCY...
79	79	1,251	0.06	1.11	1.08	3hu5zwxu8fcpp	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
78	79	598	0.13	1.09	1.07	0f2cqymcw7hqm	clinic.exe	select count ( 1 ) from ys_mz_...
76	77	137	0.56	1.07	1.04	9gpjxpz3m4551	mzgl.exe	Select ckxx , brid From GY_CKD...

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: 376,338,333
Captured SQL account for 69.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
38,962,541	823	47,342.09	10.35	2403.34	2403.84	4s1sawzgtvspt	Main.exe	SELECT B.FYCK, B.FPHM, A.BRXM ...
33,150,100	605	54,793.55	8.81	373.53	378.80	aazrv4j48xq9s	mzgl.exe	Select BRXZ , BRID , ZFPB , CK...
17,071,633	2,242	7,614.47	4.54	157.53	158.49	755n8d4g0u6g7	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
15,589,268	447	34,875.32	4.14	58.81	59.25	0683ux8mvxfuc	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
13,236,669	380	34,833.34	3.52	57.84	58.31	a7nfq189pmb01	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
11,473,818	328	34,981.15	3.05	46.94	47.44	6dn4xzm4ymh2h	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
11,215,058	496	22,611.00	2.98	63.75	64.49	413spfa5rzqah	clinic.exe	SELECT SYS.ALL_CONS_COLUMNS.CO...
10,278,753	528	19,467.34	2.73	174.69	176.53	105kp2gu0mpk2	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01.B...
9,872,461	27,967	353.00	2.62	62.50	61.67	2m4sswt7fa0rp	zyxt.exe	SELECT COUNT ( *) FROM ZY_BRRY...
9,714,869	1,251	7,765.68	2.58	79.41	79.44	3hu5zwxu8fcpp	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
8,704,395	822	10,589.29	2.31	171.22	171.52	41kj4j88fbp9y	Main.exe	SELECT B.FYCK, B.FPHM, A.BRXM ...
8,691,253	822	10,573.30	2.31	139.42	139.96	2drauwv4cpx9p	Main.exe	SELECT B.FYCK, B.FPHM, A.BRXM ...
7,823,474	2,641	2,962.32	2.08	114.81	114.34	fga17xtru63gg	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01.B...
6,773,368	1,093	6,197.04	1.80	38.48	42.80	fbahzpyh5625k	mzgl.exe	SELECT "MS_YYDJ"."MZHM", "MS_...
6,561,332	1,223	5,364.95	1.74	99.80	100.84	67mfx2u3cwpbq	clinic.exe	SELECT YS_MZ_JZLS.BRBH, MS_BR...
6,514,266	137	47,549.39	1.73	76.34	76.91	9gpjxpz3m4551	mzgl.exe	Select ckxx , brid From GY_CKD...
6,249,983	822	7,603.39	1.66	34.84	34.98	fyndfj02gywdr	Main.exe	SELECT B.FYCK, B.FPHM, A.BRXM ...
4,991,889	9,636	518.05	1.33	103.41	106.56	bxv4auh6fkjdy	bqgl.exe	SELECT TJBQ, TJYF, YZLX, FYFS...
4,371,399	598	7,310.03	1.16	78.09	78.55	0f2cqymcw7hqm	clinic.exe	select count ( 1 ) from ys_mz_...
4,318,452	823	5,247.21	1.15	122.58	124.29	2kdz115yahc1c	pb90.exe	select sum ( ms_sfmx.zjje ) fr...
3,991,362	16,035	248.92	1.06	132.95	134.19	3yhfanm17kgcq	indoctor.exe	SELECT LCBZ FROM YS_ZY_JZJL WH...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 2,410
Captured SQL account for 0.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
11	1,081	0.01	0.46	0.45	0.33	1f9sh8kka3u6h	clinic.exe	SELECT ' ' as YPMC, MS_CF02.S...
0	447	0.00	0.00	58.81	59.25	0683ux8mvxfuc	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
0	598	0.00	0.00	78.09	78.55	0f2cqymcw7hqm	clinic.exe	select count ( 1 ) from ys_mz_...
0	8,250	0.00	0.00	1.36	1.63	0h6b2sajwb74n		select privilege#, level from ...
0	37	0.00	0.00	0.00	0.00	0kt39dtph08sf	yjgl.exe	SELECT DQZ FROM GY_IDENTITY_BQ...
0	528	0.00	0.00	174.69	176.53	105kp2gu0mpk2	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01.B...
0	34	0.00	0.00	4.23	4.24	16r0uaxgar79a	pdxt.exe	SELECT SYS.ALL_CONS_COLUMNS.CO...
0	6,547	0.00	0.00	0.64	0.73	1fzjwzh29ssgd	ssgl.exe	SELECT KSMC FROM GY_KSDM WHERE...
0	244	0.00	0.00	60.23	60.79	1jbpzh7pq4g1y	yfxt.exe	SELECT MS_CF01.CFHM, MS_CF01....
0	5,805	0.00	0.00	0.67	0.78	24r9fj75b0yd2	clinic.exe	select count ( *) from MS_BRZH...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,453,706
Captured SQL account for 37.3% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
86,318	86,318	1.00	0.00	0.00	8575dwh28r0xw	indoctor.exe	BEGIN dt_SYSDate(P_SYSDATE=>:P...
84,252	84,252	1.00	0.00	0.00	60bw3x373qbxn	bqgl.exe	select CSZ from GY_XTCS where ...
27,967	27,967	1.00	0.00	0.00	2m4sswt7fa0rp	zyxt.exe	SELECT COUNT ( *) FROM ZY_BRRY...
20,602	20,602	1.00	0.00	0.00	fxv64cnbp1978	zsxt.exe	select PY from GY_HZBM where H...
18,948	5,951	0.31	0.00	0.00	abxfgcadcabtk	yfxt.exe	SELECT YGXM FROM GY_YGDM Where...
18,918	18,918	1.00	0.00	0.00	bqfw81mfzdupf	clinic.exe	SELECT YHZM FROM SS_OPERATE_US...
18,892	18,892	1.00	0.00	0.00	31q0z3xpcpk67	bqgl.exe	SELECT COUNT ( *) FROM SS_GRIG...
16,035	15,736	0.98	0.01	0.01	3yhfanm17kgcq	indoctor.exe	SELECT LCBZ FROM YS_ZY_JZJL WH...
15,119	15,119	1.00	0.00	0.00	4a1awq0absn5s	bqgl.exe	SELECT ZXZQ , MRCS , SJFW , AT...
14,337	14,337	1.00	0.00	0.00	gkzn84z8xhqvh	ykxt.exe	select nvl ( count ( *) , 0 ) ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,468,944
Captured SQL account for 40.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
101,854	84,252	6.93	60bw3x373qbxn	bqgl.exe	select CSZ from GY_XTCS where ...
86,318	86,318	5.88	8575dwh28r0xw	indoctor.exe	BEGIN dt_SYSDate(P_SYSDATE=>:P...
27,967	27,967	1.90	2m4sswt7fa0rp	zyxt.exe	SELECT COUNT ( *) FROM ZY_BRRY...
20,789	16,035	1.42	3yhfanm17kgcq	indoctor.exe	SELECT LCBZ FROM YS_ZY_JZJL WH...
20,602	20,602	1.40	fxv64cnbp1978	zsxt.exe	select PY from GY_HZBM where H...
18,948	18,948	1.29	abxfgcadcabtk	yfxt.exe	SELECT YGXM FROM GY_YGDM Where...
18,923	18,918	1.29	bqfw81mfzdupf	clinic.exe	SELECT YHZM FROM SS_OPERATE_US...
18,892	18,892	1.29	31q0z3xpcpk67	bqgl.exe	SELECT COUNT ( *) FROM SS_GRIG...
18,367	14,107	1.25	au7x36nfwuuw6	indoctor.exe	SELECT NVL ( YJJE , 0 ) FROM Z...
18,367	14,107	1.25	d67ph6ysm4s51	indoctor.exe	SELECT SUM ( JKJE ) FROM ZY_TB...
17,905	14,337	1.22	gkzn84z8xhqvh	ykxt.exe	select nvl ( count ( *) , 0 ) ...
17,025	11,330	1.16	9g8gb8mj0j60h	mzgl.exe	SELECT COUNT ( *) FROM LB_XZDZ...
15,119	15,119	1.03	4a1awq0absn5s	bqgl.exe	SELECT ZXZQ , MRCS , SJFW , AT...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
50	790	dm9r9cx2rgfnv	clinic.exe	Select MS_GHMX.SBXH, MS_GHMX.K...
50	790	dm9r9cx2rgfnv	clinic.exe	Select MS_GHMX.SBXH, MS_GHMX.K...
49	68	6w7uj0jy0fpv6	bqgl.exe	DELETE FROM SS_REGISTER Where ...
40	40	g0t2hwua5v6m4	mzgl.exe	Delete From SS_REGISTER Where ...
33	712	927131k0pbp3r	indoctor.exe	SELECT LC_LCZX.ZXBH, LC_LCZX....
33	712	927131k0pbp3r	indoctor.exe	SELECT LC_LCZX.ZXBH, LC_LCZX....
32	68	bkdp4fpmcncmt	bqgl.exe	INSERT INTO SS_REGISTER ( XTSB...
31	1,223	67mfx2u3cwpbq	clinic.exe	SELECT YS_MZ_JZLS.BRBH, MS_BR...
31	1,223	67mfx2u3cwpbq	clinic.exe	SELECT YS_MZ_JZLS.BRBH, MS_BR...
31	1,093	fbahzpyh5625k	mzgl.exe	SELECT "MS_YYDJ"."MZHM", "MS_...
30	115	3w1mw61sauznw	indoctor.exe	SELECT SS_GRIGHT.XTSB, SS_GRI...
30	69	60xu967xfacb2	clinic.exe	UPDATE "MS_CF01" SET "ZDMC" = ...
30	24	dmw4vv3fswyux	indoctor.exe	SELECT ZY_BRRY.ZYH, ZY_BRRY.Z...
28	4,160	aq1zd8jwwca5c	indoctor.exe	SELECT COUNT(*) FROM GY_IDENTI...
28	119	bu9z4n28mb2nu	indoctor.exe	SELECT GY_YGDM.YGDM , GY_YGDM....
27	393	4195awawjpvth	indoctor.exe	SELECT BRBQ FROM ZY_BRRY WHERE...
27	55	8qnqup4hshpxf	clinic.exe	DELETE FROM "MS_CF02" WHERE "S...
27	4,160	g9zn3qh3yb0y0	indoctor.exe	UPDATE GY_IDENTITY_YZ SET DQZ ...
25	4	899dygcsptrd1	yfxt.exe	UPDATE GY_IDENTITY_YF SET DQZ ...
23	84,252	60bw3x373qbxn	bqgl.exe	select CSZ from GY_XTCS where ...
23	2	9n0dmp9tzvgqc	mzgl.exe	SELECT nvl(a.gzrq, :adt_begin...
23	2	9n0dmp9tzvgqc	mzgl.exe	SELECT nvl(a.gzrq, :adt_begin...
23	686	apv6kxf9uzh59	PB90.EXE	DELETE FROM "WH_MENU" WHERE "X...
23	38	gq0m5q82b8zdy	indoctor.exe	SELECT ZY_ZKJL.JLXH, ZY_ZKJL....
22	1,267	3xjb8gym2f81h	zyxt.exe	SELECT DQZ FROM GY_IDENTITY_ZY...
22	47	gc672gmwxpj07	yfxt.exe	SELECT COUNT(*) FROM GY_IDENTI...
22	269	gdrn48txd0f3u	indoctor.exe	SELECT DISTINCT LC_LCYJ.BRBH F...
22	269	gdrn48txd0f3u	indoctor.exe	SELECT DISTINCT LC_LCYJ.BRBH F...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0683ux8mvxfuc SELECT MS_CF01.CFHM, MS_CF01.CFSB, MS_CF01.BRXM, MS_MZXX.SFRQ, MS_CF01.BRID, MS_CF01.FYBZ, MS_CF01.pybz, 0 AS CYBZ, MS_CF01.DYRQ FROM MS_CF01, MS_MZXX WHERE ( MS_CF01.MZXH = MS_MZXX.MZXH ) AND ( MS_MZXX.SFRQ >= TO_DATE('11-05-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS') ) and ( MS_CF01.FPHM is not null ) and ( MS_CF01.PYBZ = 1 ) and ( MS_CF01.ZFPB = 0 ) and ( MS_CF01.CFLX in (1, 2)) and ( MS_CF01.YFSB = 1) and (MS_CF01.DYBZ = 1 ) and MS_CF01.FYCK = 2 and ( MS_CF01.FYBZ = 0 )

0f2cqymcw7hqm select count ( 1 ) from ys_mz_jbzd where jbbh =0

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

0kt39dtph08sf SELECT DQZ FROM GY_IDENTITY_BQ WHERE BMC = 'BQ_TJ02'

105kp2gu0mpk2 SELECT MS_CF01.CFHM, MS_CF01.BRXM, MS_CF01.CFSB, MS_MZXX.SFRQ, MS_CF01.CFLX FROM MS_CF01, MS_MZXX WHERE ms_cf01.yfsb = :ai_yfsb and ms_cf01.kfrq >= :ai_cfxq and MS_CF01.ZFPB = 0 and MS_CF01.FYBZ = 0 and MS_CF01.FPHM IS NOT NULL AND MS_CF01.FPHM = MS_MZXX.FPHM order by MS_CF01.CFHM

16r0uaxgar79a SELECT SYS.ALL_CONS_COLUMNS.COLUMN_NAME, SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME FROM SYS.ALL_CONSTRAINTS, SYS.ALL_CONS_COLUMNS WHERE SYS.ALL_CONSTRAINTS.CONSTRAINT_TYPE ='P' AND SYS.ALL_CONSTRAINTS.TABLE_NAME = 'PD_DLB613' AND SYS.ALL_CONSTRAINTS.OWNER = 'BSRUN' AND SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME = SYS.ALL_CONS_COLUMNS.CONSTRAINT_NAME AND SYS.ALL_CONSTRAINTS.TABLE_NAME = SYS.ALL_CONS_COLUMNS.TABLE_NAME AND SYS.ALL_CONSTRAINTS.OWNER = SYS.ALL_CONS_COLUMNS.OWNER ORDER BY SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME, SYS.ALL_CONS_COLUMNS.POSITION

1f9sh8kka3u6h SELECT ' ' as YPMC, MS_CF02.SBXH, MS_CF02.CFSB, MS_CF02.YPXH, MS_CF02.YPCD, MS_CF02.XMLX, MS_CF02.CFTS, MS_CF02.YPSL, MS_CF02.YPDJ, MS_CF02.FYGB, MS_CF02.ZFBL, MS_CF02.YFGG, MS_CF02.YFDW, MS_CF02.YFBZ, MS_CF02.YPYF, 0 as JSBZ , 0 as YPPX, MS_CF01.KFRQ, MS_CF02.HJJE, 0 AS CFZH, MS_CF01.JZXH FROM MS_CF02, MS_CF01 WHERE MS_CF01.CFSB = MS_CF02.CFSB and MS_CF01.BRID = :al_id and ( MS_CF01.FPHM is null or MS_CF01.FPHM = '' ) and MS_CF01.ZFPB = 0 and MS_CF01.FYBZ = 0 and ( MS_CF01.CFBZ = 0 or MS_CF01.CFBZ = 1 ) and ( MS_CF01.KFRQ > :adt_date)

1fzjwzh29ssgd SELECT KSMC FROM GY_KSDM WHERE KSDM =:1

1jbpzh7pq4g1y SELECT MS_CF01.CFHM, MS_CF01.CFSB, MS_CF01.BRXM, MS_MZXX.SFRQ, MS_CF01.BRID, MS_CF01.FYBZ, MS_CF01.pybz, 0 AS CYBZ, MS_CF01.DYRQ FROM MS_CF01, MS_MZXX WHERE ( MS_CF01.MZXH = MS_MZXX.MZXH ) AND ( MS_MZXX.SFRQ >= TO_DATE('10-05-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS') ) and ( MS_CF01.FPHM is not null ) and ( MS_CF01.PYBZ = 1 ) and ( MS_CF01.ZFPB = 0 ) and ( MS_CF01.CFLX in (1, 2)) and ( MS_CF01.YFSB = 1) and (MS_CF01.DYBZ = 1 ) and MS_CF01.FYCK = 5 and ( MS_CF01.FYBZ = 0 )

24r9fj75b0yd2 select count ( *) from MS_BRZH where BRID =:1 and ZFPB =0

2drauwv4cpx9p SELECT B.FYCK, B.FPHM, A.BRXM , A.CSNY FROM V_MS_BRDA_SY A, V_MS_CF01_FY B WHERE A.BRID=B.ID and B.FYCK= 3 and 20120515<= to_char(A.CSNY, 'yyyymmdd') ORDER BY A.CSNY desc

2kdz115yahc1c select sum ( ms_sfmx.zjje ) from ms_mzxx , ms_sfmx where ms_mzxx.fphm =:1 and ms_mzxx.fphm =ms_sfmx.fphm group by ms_sfmx.fphm

2m4sswt7fa0rp SELECT COUNT ( *) FROM ZY_BRRY WHERE BAHM =:1 AND CYPB < 8

31q0z3xpcpk67 SELECT COUNT ( *) FROM SS_GRIGHT WHERE XTSB =:1 AND YHZM =:2 AND CDQX =:3

3hu5zwxu8fcpp SELECT MS_CF01.CFHM, MS_CF01.CFSB, MS_CF01.BRXM, MS_MZXX.SFRQ, MS_CF01.BRID, MS_CF01.FYBZ, MS_CF01.pybz, 0 AS CYBZ, MS_CF01.DYRQ FROM MS_CF01, MS_MZXX WHERE ( MS_CF01.MZXH = MS_MZXX.MZXH ) AND ( MS_MZXX.SFRQ >= TO_DATE('14-04-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS') ) and ( MS_CF01.FPHM is not null ) and ( MS_CF01.PYBZ = 1 ) and ( MS_CF01.ZFPB = 0 ) and ( MS_CF01.CFLX in (0, 2, 3)) and ( MS_CF01.YFSB = 2) and (MS_CF01.DYBZ = 1 ) and MS_CF01.FYCK = 1 and ( MS_CF01.FYBZ = 0 )

3w1mw61sauznw SELECT SS_GRIGHT.XTSB, SS_GRIGHT.YHZM , SS_GRIGHT.CDQX FROM SS_GROUP , SS_GRIGHT WHERE (SS_GRIGHT.XTSB = SS_GROUP.XTSB ) and (SS_GRIGHT.YHZM = SS_GROUP.YHZM ) and (( SS_GRIGHT.XTSB = :ai_xtsb ) and ( SS_GRIGHT.YHZM = :as_yhzm ) )

3xjb8gym2f81h SELECT DQZ FROM GY_IDENTITY_ZY WHERE BMC = 'ZY_FYMX'

3yhfanm17kgcq SELECT LCBZ FROM YS_ZY_JZJL WHERE JZHM =:1

413spfa5rzqah SELECT SYS.ALL_CONS_COLUMNS.COLUMN_NAME, SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME FROM SYS.ALL_CONSTRAINTS, SYS.ALL_CONS_COLUMNS WHERE SYS.ALL_CONSTRAINTS.CONSTRAINT_TYPE ='P' AND SYS.ALL_CONSTRAINTS.TABLE_NAME = 'GY_JBBM' AND SYS.ALL_CONSTRAINTS.OWNER = 'BSRUN' AND SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME = SYS.ALL_CONS_COLUMNS.CONSTRAINT_NAME AND SYS.ALL_CONSTRAINTS.TABLE_NAME = SYS.ALL_CONS_COLUMNS.TABLE_NAME AND SYS.ALL_CONSTRAINTS.OWNER = SYS.ALL_CONS_COLUMNS.OWNER ORDER BY SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME, SYS.ALL_CONS_COLUMNS.POSITION

4195awawjpvth SELECT BRBQ FROM ZY_BRRY WHERE ZYH =:1

41kj4j88fbp9y SELECT B.FYCK, B.FPHM, A.BRXM , A.CSNY FROM V_MS_BRDA_SY A, V_MS_CF01_FY B WHERE A.BRID=B.ID and B.FYCK= 2 and 20120515<= to_char(A.CSNY, 'yyyymmdd') ORDER BY A.CSNY desc

4a1awq0absn5s SELECT ZXZQ , MRCS , SJFW , ATFY FROM GY_SYPC WHERE PCBM =:1

4s1sawzgtvspt SELECT B.FYCK, B.FPHM, A.BRXM , A.CSNY FROM V_MS_BRDA_SY A, V_MS_CF01_FY B WHERE A.BRID=B.ID and B.FYCK= 1 and 20120515<= to_char(A.CSNY, 'yyyymmdd') ORDER BY A.CSNY desc

60bw3x373qbxn select CSZ from GY_XTCS where XTSB =:1 and CSMC =:2

60xu967xfacb2 UPDATE "MS_CF01" SET "ZDMC" = :1 WHERE "JZXH" = :2 AND "CFSB" = :3 AND "CFHM" = :4 AND "FPHM" IS NULL AND "CFLX" = :5 AND "BRID" = :6 AND "BRXM" = :7 AND "KFRQ" = :8 AND "CFTS" = :9 AND "KSDM" = :10 AND "YSDM" = :11 AND "FYRQ" IS NULL AND "FYCK" IS NULL AND "HJGH" IS NULL AND "PYGH" IS NULL AND "FYGH" IS NULL AND "PYBZ" = :12 AND "FYBZ" = :13 AND "CFGL" IS NULL AND "ZFPB" = :14 AND "DYBZ" = :15 AND "YFSB" = :16 AND "TSCF" = :17 AND "TSLX" = :18 AND "TYBZ" = :19 AND "CFBZ" = :20 AND "ZFCF" IS NULL AND "TSBZ" IS NULL AND "ETCF" = :21 AND "DJTS" = :22 AND "JZCF" = :23 AND "BRTZ" IS NULL AND "CFYT" = :24 AND "IPXX" = :25 AND "BZXX" IS NULL AND "ICDBM" = :26 AND "ZDMC" = :27

67mfx2u3cwpbq SELECT YS_MZ_JZLS.BRBH, MS_BRDA.BRXM, MS_BRDA.MZHM, YS_MZ_JZLS.GHXH FROM YS_MZ_JZLS, MS_BRDA WHERE ( YS_MZ_JZLS.BRBH = MS_BRDA.BRID ) AND ( YS_MZ_JZLS.KSSJ >= :adt_Begin ) AND ( YS_MZ_JZLS.KSSJ <= :adt_End ) AND ( YS_MZ_JZLS.KSDM = :al_DeptId ) AND ( YS_MZ_JZLS.YSDM = :as_DoctorId ) AND ( YS_MZ_JZLS.JZZT = 2 )

6dn4xzm4ymh2h SELECT MS_CF01.CFHM, MS_CF01.CFSB, MS_CF01.BRXM, MS_MZXX.SFRQ, MS_CF01.BRID, MS_CF01.FYBZ, MS_CF01.pybz, 0 AS CYBZ, MS_CF01.DYRQ FROM MS_CF01, MS_MZXX WHERE ( MS_CF01.MZXH = MS_MZXX.MZXH ) AND ( MS_MZXX.SFRQ >= TO_DATE('11-05-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS') ) and ( MS_CF01.FPHM is not null ) and ( MS_CF01.PYBZ = 1 ) and ( MS_CF01.ZFPB = 0 ) and ( MS_CF01.CFLX in (1, 2)) and ( MS_CF01.YFSB = 1) and (MS_CF01.DYBZ = 1 ) and MS_CF01.FYCK = 3 and ( MS_CF01.FYBZ = 0 )

6w7uj0jy0fpv6 DELETE FROM SS_REGISTER Where XTSB =:1 AND YHDM =:2 AND WKDZ =:3

702ggkq5a61pg SELECT COUNT ( 1 ) FROM LC_LCYJ , ZY_BRRY WHERE ZY_BRRY.ZYH =LC_LCYJ.BRBH AND ( LC_LCYJ.ZGYS =:1 OR LC_LCYJ.YJKS =:2 ) AND LC_LCYJ.CLBZ =0 AND ( ZY_BRRY.CYRQ IS NULL OR ZY_BRRY.CYRQ > sysdate - 7 )

755n8d4g0u6g7 SELECT MS_CF01.CFHM, MS_CF01.BRXM, MS_CF01.CFSB, MS_CF01.CFLX, MS_MZXX.SFRQ, MS_CF01.FYBZ, MS_CF01.JZCF, /*ADD BY panyd 急诊处方 */ MS_CF01.ETCF, /*ADD BY panyd 儿童处方*/ MS_CF01.DJTS, MS_CF01.FPHM FROM MS_CF01, MS_MZXX WHERE MS_MZXX.FPHM is not null and MS_MZXX.MZXH = MS_CF01.MZXH and MS_MZXX.SFRQ >= :ad_begindate and MS_CF01.DYBZ = 1 and MS_CF01.ZFPB = 1 and MS_CF01.FYBZ = 0 and MS_CF01.YFSB = :ai_yfsb and MS_CF01.FYCK = :ai_fyck and MS_CF01.QRBZ = 0

8575dwh28r0xw BEGIN dt_SYSDate(P_SYSDATE=>:P_SYSDATE); END;

899dygcsptrd1 UPDATE GY_IDENTITY_YF SET DQZ = DQZ + 2 WHERE BMC = 'YF_MZFYMX'

8qnqup4hshpxf DELETE FROM "MS_CF02" WHERE "SBXH" = :1 AND "CFSB" = :2 AND "PLXH" = :3 AND "YPZH" = :4 AND "YPXH" = :5 AND "YPCD" = :6 AND "YFGG" = :7 AND "YFDW" = :8 AND "XMLX" = :9 AND "YPSL" = :10 AND "YCSL" = :11 AND "YCJL" = :12 AND "YFBZ" = :13 AND "YPDJ" = :14 AND "MRCS" = :15 AND "YYTS" = :16 AND "CFTS" = :17 AND "YPYF" = :18 AND "GYTJ" = :19 AND "YPZS" = :20 AND "FYGB" = :21 AND "PSPB" = :22 AND "ZFBL" = :23 AND "HJJE" = :24 AND "CFBZ" = :25 AND "PSJG" = :26 AND "SPBZ" = :27 AND "ZHSL" = :28 AND "ZHDW" = :29 AND "BZ" = :30 AND "SRSJ" = :31 AND "ZSCS" = :32 AND "ZFBZ" = :33 AND "KSSBZ" = :34 AND "JBXH" IS NULL AND "YJQM" IS NULL

927131k0pbp3r SELECT LC_LCZX.ZXBH, LC_LCZX.BRBH, LC_LCZX.LCBH, LC_LCZX.XMBH, LC_LCZX.YPJL, LC_LCZX.SYSL, LC_LCZX.ZZKS, LC_LCZX.ZCWC, LC_LCZX.TZSJ, LC_LCZX.SXBZ, LC_LCZX.TJR, LC_LCZX.TJSJ, LC_LCZX.ZXR, LC_LCZX.ZXSJ, LC_LCZX.YCBZ, LC_LCZX.JGBH, LC_LCZX.ZXZT, LC_LCXM.XMMC, LC_LCXM.YJJB, ZY_BRRY.ZYYS, ZY_BRRY.BRKS, LC_LCXM.ZLXH, LC_LCXM.XMLX, LC_LCXM.RQXH, LC_LCXM.XMKZ , LC_LCXM.DYXM , ZY_BRRY.ZSYS FROM LC_LCZX, LC_LCXM, ZY_BRRY, LC_BRLC WHERE ( LC_LCXM.XMBH = LC_LCZX.XMBH ) AND ( LC_LCZX.BRBH = ZY_BRRY.ZYH ) AND ( LC_LCZX.BRBH = LC_BRLC.BRBH) AND ( ZY_BRRY.BRKS = :al_brks ) AND ( ZY_BRRY.CYPB < 1) AND ( LC_BRLC.TZSJ IS NULL ) AND ( LC_LCZX.ZCWC <= :adt_thedate ) AND ( LC_LCZX.ZXZT <> 'ZX') AND ( LC_LCZX.YCBZ = 0)

9g8gb8mj0j60h SELECT COUNT ( *) FROM LB_XZDZ WHERE BRXZ =:1

9gpjxpz3m4551 Select ckxx , brid From GY_CKDA Where ckxx =:1 And rownum =1

9k86kjgywamrq SELECT GY_JBBM.JBXH, GY_JBBM.DMLB, GY_JBBM.JBMC, GY_JBBM.JBLB, GY_JBBM.PYDM, GY_JBBM.ICD9, GY_JBBM.ICD10, GY_JBBM.CRBZ, GY_JBBM.CRBM, GY_JBBM.YBTS, GY_JBBM.TSBTS, GY_JBBM.CRID, GY_JBBM.BMXH, GY_JBBM.KSBM, GY_JBBM.CRLB, GY_JBBM.MXBID, GY_JBBM.ZFPB , GY_JBBM.LBJB, NVL(GY_JBBM.ZYZD, 0) ZYZD, GY_JBBM.TZYB_JB, CASE WHEN B.SYSL IS NULL THEN 0 ELSE B.SYSL END AS SYSL FROM GY_JBBM, (SELECT JBDM, YSDM, SYSL FROM YS_ZD_SYSL WHERE YSDM = :as_ysdm) B WHERE ( GY_JBBM.ZFPB <> 1 OR GY_JBBM.ZFPB is Null ) AND ( GY_JBBM.JBXH = B.JBDM (+) ) ORDER BY GY_JBBM.PYDM ASC

9n0dmp9tzvgqc SELECT nvl(a.gzrq, :adt_begin) as gzrq, MS_KSPB.GHKS, ms_ghks.ksmc, MS_KSPB.ZBLB, a.YSDM, a.ztgh, MS_KSPB.Ghxe, MS_KSPB.Yyxe, ms_ghks.ksdm FROM (SELECT ms_yspb.ksdm, ms_yspb.ysdm, ms_yspb.zblb, ms_yspb.ztgh, MS_YSPB.gzrq FROM MS_YSPB WHERE MS_YSPB.gzrq >= :adt_begin AND MS_YSPB.gzrq <= :adt_end ) a, MS_KSPB, ms_ghks WHERE a.KSDM(+) = MS_KSPB.GHKS AND a.zblb(+) = ms_kspb.zblb AND MS_KSPB.ghks = ms_ghks.ksdm AND MS_KSPB.GHRQ = :ai_week AND NVL(MS_GHKS.ZJMZ, 0) = 0 and MS_KSPB.GZRQ >= :adt_begin AND MS_KSPB.GZRQ <= :adt_end ORDER BY MS_KSPB.Zblb, MS_KSPB.GHKS, a.YSDM

a7nfq189pmb01 SELECT MS_CF01.CFHM, MS_CF01.CFSB, MS_CF01.BRXM, MS_MZXX.SFRQ, MS_CF01.BRID, MS_CF01.FYBZ, MS_CF01.pybz, 0 AS CYBZ, MS_CF01.DYRQ FROM MS_CF01, MS_MZXX WHERE ( MS_CF01.MZXH = MS_MZXX.MZXH ) AND ( MS_MZXX.SFRQ >= TO_DATE('11-05-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS') ) and ( MS_CF01.FPHM is not null ) and ( MS_CF01.PYBZ = 1 ) and ( MS_CF01.ZFPB = 0 ) and ( MS_CF01.CFLX in (1, 2)) and ( MS_CF01.YFSB = 1) and (MS_CF01.DYBZ = 1 ) and MS_CF01.FYCK = 1 and ( MS_CF01.FYBZ = 0 )

aazrv4j48xq9s Select BRXZ , BRID , ZFPB , CKHM From GY_CKDA Where CKXX =:1

abxfgcadcabtk SELECT YGXM FROM GY_YGDM Where YGDM =:1

apv6kxf9uzh59 DELETE FROM "WH_MENU" WHERE "XTSB" = :1 AND "CDMC" = :2

aq1zd8jwwca5c SELECT COUNT(*) FROM GY_IDENTITY_YZ WHERE BMC = 'YZ_YZZH'

au7x36nfwuuw6 SELECT NVL ( YJJE , 0 ) FROM ZY_BRRY WHERE ZY_BRRY.ZYH =:1 AND ZY_BRRY.CYPB =0

bkdp4fpmcncmt INSERT INTO SS_REGISTER ( XTSB , YHDM , WKDZ , DLSJ , IPDZ , JSJM ) Values ( :1 , :2 , :3 , :4 , :5 , :6 )

bqfw81mfzdupf SELECT YHZM FROM SS_OPERATE_USER WHERE XTSB =:1 AND YHDM =:2

bu9z4n28mb2nu SELECT GY_YGDM.YGDM , GY_YGDM.YGXM , GY_YGDM.YGMM , GY_YGDM.YGBH FROM SS_OPERATE_USER , GY_YGDM WHERE SS_OPERATE_USER.YHDM =GY_YGDM.YGDM AND GY_YGDM.ZFPB =0 AND SS_OPERATE_USER.XTSB =:1 AND GY_YGDM.YGBH =:2

bxv4auh6fkjdy SELECT TJBQ, TJYF, YZLX, FYFS, COUNT(*) AS WFTS FROM BQ_TJ01 WHERE FYBZ = 0 AND TJYF=0 group by TJBQ, TJYF, YZLX, FYFS union SELECT TYBQ AS TJBQ, YFSB AS TJYF, 5 AS YZLX, 0 AS FYFS, count(*) as WFTS FROM BQ_TYMX WHERE YFSB = 0 AND TJBZ=1 and TYRQ is null group by TYBQ, YFSB union SELECT KDKS AS TJBQ, YFSB AS TJYF, 4 AS YZLX, 0 AS FYFS, count(*) as WFTS from YJ_YJYY where SYBZ=1 and YFSB=0 group by KDKS, YFSB

d67ph6ysm4s51 SELECT SUM ( JKJE ) FROM ZY_TBKK , ZY_BRRY WHERE ZY_BRRY.ZYH =ZY_TBKK.ZYH AND ZY_BRRY.ZYH =:1 AND ZY_BRRY.CYPB =0 AND ZY_TBKK.JSCS =0

dm9r9cx2rgfnv Select MS_GHMX.SBXH, MS_GHMX.KSDM, MS_GHMX.YSDM, MS_GHMX.GHSJ, MS_GHMX.GHKSDM, MS_GHMX.GHYSDM, MS_GHMX.GHLBXH, MS_GHMX.JZXH, MS_GHMX.ZBLB, MS_GHKS.MZKS From MS_GHMX , MS_GHKS Where MS_GHMX.KSDM = MS_GHKS.KSDM And MS_GHMX.BRID = :al_PatientId And MS_GHMX.THBZ = 0 And MS_GHMX.GHSJ >= :adt_today

dmw4vv3fswyux SELECT ZY_BRRY.ZYH, ZY_BRRY.ZYHM, ZY_BRRY.BRCH, ZY_BRRY.BRXM, ZY_BRRY.BRXB, ZY_BRRY.CSNY, ZY_BRRY.GZDW, ZY_BRRY.ZSYS, ZY_BRRY.ZLXZ, ZY_BRRY.DJRQ FROM ZY_BRRY WHERE ( ZY_BRRY.BRBQ = :al_DeptId OR ZY_BRRY.BRKS = :al_DeptId) AND ( ZY_BRRY.CYPB < 1 ) AND ( BRCH IS NOT NULL OR TRIM(BRCH) <> '' ) AND NVL( YSJS , 0 ) = 0 AND NOT EXISTS (SELECT * FROM ZY_ZKJL WHERE ZY_ZKJL.ZYH = ZY_BRRY.ZYH AND ZY_ZKJL.ZXBZ = 2) ORDER BY ZLXZ, ZSYS, BRCH

fbahzpyh5625k SELECT "MS_YYDJ"."MZHM", "MS_YYDJ"."BRXM", "MS_YYDJ"."SBXH", "GY_YGDM"."YGXM", "MS_YYDJ"."YYRQ", "MS_YYDJ"."KSDM", "MS_YYDJ"."YSDM", "MS_YYDJ"."ZFBZ", "MS_GHKS"."KSMC", "MS_YYDJ"."BRID", "MS_YYDJ"."ZBLB", "MS_YYDJ"."YYFS", "MS_YYDJ"."JZXH", "MS_YYDJ"."LXDH" FROM "MS_YYDJ", "GY_YGDM", "MS_GHKS" WHERE ( "MS_YYDJ"."YSDM" = "GY_YGDM"."YGDM"(+) ) and ( "MS_YYDJ"."KSDM" = "MS_GHKS"."KSDM" ) AND ( MS_YYDJ.YYRQ >= :adt_kssj ) and ( MS_YYDJ.YYRQ < :adt_jssj ) and ( MS_YYDJ.BRID = :al_brid or 0 = :al_brid )

fga17xtru63gg SELECT MS_CF01.CFHM, MS_CF01.BRXM, MS_CF01.CFSB, MS_CF01.CFLX, MS_MZXX.SFRQ, MS_CF01.FYBZ, MS_CF01.JZCF, /*ADD BY panyd 急诊处方 */ MS_CF01.ETCF, /*ADD BY panyd 儿童处方*/ MS_CF01.djts, MS_CF01.JZXH FROM MS_CF01, MS_MZXX WHERE MS_MZXX.FPHM is not null and MS_MZXX.MZXH = MS_CF01.MZXH and MS_MZXX.SFRQ >= :ad_begindate and MS_CF01.DYBZ = 0 and MS_CF01.ZFPB = 0 and MS_CF01.FYBZ = 0 and MS_CF01.YFSB = :ai_yfsb and MS_CF01.FYCK = :ai_fyck and (MS_CF01.FYCK is null or MS_CF01.FYCK in 1) order by MS_MZXX.SFRQ

fxv64cnbp1978 select PY from GY_HZBM where HZ =:1

fyndfj02gywdr SELECT B.FYCK, B.FPHM, A.BRXM , A.CSNY FROM V_MS_BRDA_SY A, V_MS_CF01_FY B WHERE A.BRID=B.ID and B.FYCK= 4 and 20120515<= to_char(A.CSNY, 'yyyymmdd') ORDER BY A.CSNY desc

g0t2hwua5v6m4 Delete From SS_REGISTER Where XTSB =:1 AND YHDM =:2 AND WKDZ =:3

g9zn3qh3yb0y0 UPDATE GY_IDENTITY_YZ SET DQZ = DQZ + 1 WHERE BMC = 'YZ_YZZH'

gc672gmwxpj07 SELECT COUNT(*) FROM GY_IDENTITY_YF WHERE BMC = 'YF_KCMX'

gdrn48txd0f3u SELECT DISTINCT LC_LCYJ.BRBH FROM LC_LCYJ , ZY_BRRY WHERE LC_LCYJ.BRBH = ZY_BRRY.ZYH AND (LC_LCYJ.ZGYS = :as_Doctorid OR LC_LCYJ.YJKS = :ai_yjks) AND (ZY_BRRY.CYRQ IS NULL OR ZY_BRRY.CYRQ>sysdate - 7 ) AND LC_LCYJ.CLBZ = 0

gkzn84z8xhqvh select nvl ( count ( *) , 0 ) from yk_ck01 where xtsb =:1 and yfly ='1' AND CKRQ IS NULL and sqtj =1

gq0m5q82b8zdy SELECT ZY_ZKJL.JLXH, ZY_ZKJL.ZYH, ZY_BRRY.BRXM AS BRXM, '' AS CWHM, ZY_ZKJL.HCLX, ZY_ZKJL.YSSQRQ, ZY_ZKJL.YSSQGH, ZY_ZKJL.BQSQRQ, ZY_ZKJL.BQSQGH, ZY_ZKJL.BQZXRQ, ZY_ZKJL.BQZXGH, ZY_ZKJL.YSZXRQ, ZY_ZKJL.YSZXGH, ZY_ZKJL.ZXBZ, ZY_ZKJL.HQCH, ZY_ZKJL.HHCH, ZY_ZKJL.HQBQ, ZY_ZKJL.HHBQ, ZY_ZKJL.HQKS, ZY_ZKJL.HHKS, ZY_ZKJL.HQYS, ZY_ZKJL.HHYS, decode(YS_ZY_JZJL.JZHM, null, 0, 1) AS YSBRBZ FROM ZY_ZKJL, ZY_BRRY, YS_ZY_JZJL WHERE ZY_ZKJL.HCLX = 3 AND ZY_ZKJL.HQKS = :al_hqks AND ZY_ZKJL.ZXBZ = 0 AND ZY_ZKJL.ZYH = ZY_BRRY.ZYH AND TO_CHAR(ZY_ZKJL.ZYH) = YS_ZY_JZJL.JZHM(+) AND YS_ZY_JZJL.YSDM = :as_ysdm

SQL Id	SQL Text
0683ux8mvxfuc	SELECT MS_CF01.CFHM, MS_CF01.CFSB, MS_CF01.BRXM, MS_MZXX.SFRQ, MS_CF01.BRID, MS_CF01.FYBZ, MS_CF01.pybz, 0 AS CYBZ, MS_CF01.DYRQ FROM MS_CF01, MS_MZXX WHERE ( MS_CF01.MZXH = MS_MZXX.MZXH ) AND ( MS_MZXX.SFRQ >= TO_DATE('11-05-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS') ) and ( MS_CF01.FPHM is not null ) and ( MS_CF01.PYBZ = 1 ) and ( MS_CF01.ZFPB = 0 ) and ( MS_CF01.CFLX in (1, 2)) and ( MS_CF01.YFSB = 1) and (MS_CF01.DYBZ = 1 ) and MS_CF01.FYCK = 2 and ( MS_CF01.FYBZ = 0 )
0f2cqymcw7hqm	select count ( 1 ) from ys_mz_jbzd where jbbh =0
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0kt39dtph08sf	SELECT DQZ FROM GY_IDENTITY_BQ WHERE BMC = 'BQ_TJ02'
105kp2gu0mpk2	SELECT MS_CF01.CFHM, MS_CF01.BRXM, MS_CF01.CFSB, MS_MZXX.SFRQ, MS_CF01.CFLX FROM MS_CF01, MS_MZXX WHERE ms_cf01.yfsb = :ai_yfsb and ms_cf01.kfrq >= :ai_cfxq and MS_CF01.ZFPB = 0 and MS_CF01.FYBZ = 0 and MS_CF01.FPHM IS NOT NULL AND MS_CF01.FPHM = MS_MZXX.FPHM order by MS_CF01.CFHM
16r0uaxgar79a	SELECT SYS.ALL_CONS_COLUMNS.COLUMN_NAME, SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME FROM SYS.ALL_CONSTRAINTS, SYS.ALL_CONS_COLUMNS WHERE SYS.ALL_CONSTRAINTS.CONSTRAINT_TYPE ='P' AND SYS.ALL_CONSTRAINTS.TABLE_NAME = 'PD_DLB613' AND SYS.ALL_CONSTRAINTS.OWNER = 'BSRUN' AND SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME = SYS.ALL_CONS_COLUMNS.CONSTRAINT_NAME AND SYS.ALL_CONSTRAINTS.TABLE_NAME = SYS.ALL_CONS_COLUMNS.TABLE_NAME AND SYS.ALL_CONSTRAINTS.OWNER = SYS.ALL_CONS_COLUMNS.OWNER ORDER BY SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME, SYS.ALL_CONS_COLUMNS.POSITION
1f9sh8kka3u6h	SELECT ' ' as YPMC, MS_CF02.SBXH, MS_CF02.CFSB, MS_CF02.YPXH, MS_CF02.YPCD, MS_CF02.XMLX, MS_CF02.CFTS, MS_CF02.YPSL, MS_CF02.YPDJ, MS_CF02.FYGB, MS_CF02.ZFBL, MS_CF02.YFGG, MS_CF02.YFDW, MS_CF02.YFBZ, MS_CF02.YPYF, 0 as JSBZ , 0 as YPPX, MS_CF01.KFRQ, MS_CF02.HJJE, 0 AS CFZH, MS_CF01.JZXH FROM MS_CF02, MS_CF01 WHERE MS_CF01.CFSB = MS_CF02.CFSB and MS_CF01.BRID = :al_id and ( MS_CF01.FPHM is null or MS_CF01.FPHM = '' ) and MS_CF01.ZFPB = 0 and MS_CF01.FYBZ = 0 and ( MS_CF01.CFBZ = 0 or MS_CF01.CFBZ = 1 ) and ( MS_CF01.KFRQ > :adt_date)
1fzjwzh29ssgd	SELECT KSMC FROM GY_KSDM WHERE KSDM =:1
1jbpzh7pq4g1y	SELECT MS_CF01.CFHM, MS_CF01.CFSB, MS_CF01.BRXM, MS_MZXX.SFRQ, MS_CF01.BRID, MS_CF01.FYBZ, MS_CF01.pybz, 0 AS CYBZ, MS_CF01.DYRQ FROM MS_CF01, MS_MZXX WHERE ( MS_CF01.MZXH = MS_MZXX.MZXH ) AND ( MS_MZXX.SFRQ >= TO_DATE('10-05-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS') ) and ( MS_CF01.FPHM is not null ) and ( MS_CF01.PYBZ = 1 ) and ( MS_CF01.ZFPB = 0 ) and ( MS_CF01.CFLX in (1, 2)) and ( MS_CF01.YFSB = 1) and (MS_CF01.DYBZ = 1 ) and MS_CF01.FYCK = 5 and ( MS_CF01.FYBZ = 0 )
24r9fj75b0yd2	select count ( *) from MS_BRZH where BRID =:1 and ZFPB =0
2drauwv4cpx9p	SELECT B.FYCK, B.FPHM, A.BRXM , A.CSNY FROM V_MS_BRDA_SY A, V_MS_CF01_FY B WHERE A.BRID=B.ID and B.FYCK= 3 and 20120515<= to_char(A.CSNY, 'yyyymmdd') ORDER BY A.CSNY desc
2kdz115yahc1c	select sum ( ms_sfmx.zjje ) from ms_mzxx , ms_sfmx where ms_mzxx.fphm =:1 and ms_mzxx.fphm =ms_sfmx.fphm group by ms_sfmx.fphm
2m4sswt7fa0rp	SELECT COUNT ( *) FROM ZY_BRRY WHERE BAHM =:1 AND CYPB < 8
31q0z3xpcpk67	SELECT COUNT ( *) FROM SS_GRIGHT WHERE XTSB =:1 AND YHZM =:2 AND CDQX =:3
3hu5zwxu8fcpp	SELECT MS_CF01.CFHM, MS_CF01.CFSB, MS_CF01.BRXM, MS_MZXX.SFRQ, MS_CF01.BRID, MS_CF01.FYBZ, MS_CF01.pybz, 0 AS CYBZ, MS_CF01.DYRQ FROM MS_CF01, MS_MZXX WHERE ( MS_CF01.MZXH = MS_MZXX.MZXH ) AND ( MS_MZXX.SFRQ >= TO_DATE('14-04-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS') ) and ( MS_CF01.FPHM is not null ) and ( MS_CF01.PYBZ = 1 ) and ( MS_CF01.ZFPB = 0 ) and ( MS_CF01.CFLX in (0, 2, 3)) and ( MS_CF01.YFSB = 2) and (MS_CF01.DYBZ = 1 ) and MS_CF01.FYCK = 1 and ( MS_CF01.FYBZ = 0 )
3w1mw61sauznw	SELECT SS_GRIGHT.XTSB, SS_GRIGHT.YHZM , SS_GRIGHT.CDQX FROM SS_GROUP , SS_GRIGHT WHERE (SS_GRIGHT.XTSB = SS_GROUP.XTSB ) and (SS_GRIGHT.YHZM = SS_GROUP.YHZM ) and (( SS_GRIGHT.XTSB = :ai_xtsb ) and ( SS_GRIGHT.YHZM = :as_yhzm ) )
3xjb8gym2f81h	SELECT DQZ FROM GY_IDENTITY_ZY WHERE BMC = 'ZY_FYMX'
3yhfanm17kgcq	SELECT LCBZ FROM YS_ZY_JZJL WHERE JZHM =:1
413spfa5rzqah	SELECT SYS.ALL_CONS_COLUMNS.COLUMN_NAME, SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME FROM SYS.ALL_CONSTRAINTS, SYS.ALL_CONS_COLUMNS WHERE SYS.ALL_CONSTRAINTS.CONSTRAINT_TYPE ='P' AND SYS.ALL_CONSTRAINTS.TABLE_NAME = 'GY_JBBM' AND SYS.ALL_CONSTRAINTS.OWNER = 'BSRUN' AND SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME = SYS.ALL_CONS_COLUMNS.CONSTRAINT_NAME AND SYS.ALL_CONSTRAINTS.TABLE_NAME = SYS.ALL_CONS_COLUMNS.TABLE_NAME AND SYS.ALL_CONSTRAINTS.OWNER = SYS.ALL_CONS_COLUMNS.OWNER ORDER BY SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME, SYS.ALL_CONS_COLUMNS.POSITION
4195awawjpvth	SELECT BRBQ FROM ZY_BRRY WHERE ZYH =:1
41kj4j88fbp9y	SELECT B.FYCK, B.FPHM, A.BRXM , A.CSNY FROM V_MS_BRDA_SY A, V_MS_CF01_FY B WHERE A.BRID=B.ID and B.FYCK= 2 and 20120515<= to_char(A.CSNY, 'yyyymmdd') ORDER BY A.CSNY desc
4a1awq0absn5s	SELECT ZXZQ , MRCS , SJFW , ATFY FROM GY_SYPC WHERE PCBM =:1
4s1sawzgtvspt	SELECT B.FYCK, B.FPHM, A.BRXM , A.CSNY FROM V_MS_BRDA_SY A, V_MS_CF01_FY B WHERE A.BRID=B.ID and B.FYCK= 1 and 20120515<= to_char(A.CSNY, 'yyyymmdd') ORDER BY A.CSNY desc
60bw3x373qbxn	select CSZ from GY_XTCS where XTSB =:1 and CSMC =:2
60xu967xfacb2	UPDATE "MS_CF01" SET "ZDMC" = :1 WHERE "JZXH" = :2 AND "CFSB" = :3 AND "CFHM" = :4 AND "FPHM" IS NULL AND "CFLX" = :5 AND "BRID" = :6 AND "BRXM" = :7 AND "KFRQ" = :8 AND "CFTS" = :9 AND "KSDM" = :10 AND "YSDM" = :11 AND "FYRQ" IS NULL AND "FYCK" IS NULL AND "HJGH" IS NULL AND "PYGH" IS NULL AND "FYGH" IS NULL AND "PYBZ" = :12 AND "FYBZ" = :13 AND "CFGL" IS NULL AND "ZFPB" = :14 AND "DYBZ" = :15 AND "YFSB" = :16 AND "TSCF" = :17 AND "TSLX" = :18 AND "TYBZ" = :19 AND "CFBZ" = :20 AND "ZFCF" IS NULL AND "TSBZ" IS NULL AND "ETCF" = :21 AND "DJTS" = :22 AND "JZCF" = :23 AND "BRTZ" IS NULL AND "CFYT" = :24 AND "IPXX" = :25 AND "BZXX" IS NULL AND "ICDBM" = :26 AND "ZDMC" = :27
67mfx2u3cwpbq	SELECT YS_MZ_JZLS.BRBH, MS_BRDA.BRXM, MS_BRDA.MZHM, YS_MZ_JZLS.GHXH FROM YS_MZ_JZLS, MS_BRDA WHERE ( YS_MZ_JZLS.BRBH = MS_BRDA.BRID ) AND ( YS_MZ_JZLS.KSSJ >= :adt_Begin ) AND ( YS_MZ_JZLS.KSSJ <= :adt_End ) AND ( YS_MZ_JZLS.KSDM = :al_DeptId ) AND ( YS_MZ_JZLS.YSDM = :as_DoctorId ) AND ( YS_MZ_JZLS.JZZT = 2 )
6dn4xzm4ymh2h	SELECT MS_CF01.CFHM, MS_CF01.CFSB, MS_CF01.BRXM, MS_MZXX.SFRQ, MS_CF01.BRID, MS_CF01.FYBZ, MS_CF01.pybz, 0 AS CYBZ, MS_CF01.DYRQ FROM MS_CF01, MS_MZXX WHERE ( MS_CF01.MZXH = MS_MZXX.MZXH ) AND ( MS_MZXX.SFRQ >= TO_DATE('11-05-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS') ) and ( MS_CF01.FPHM is not null ) and ( MS_CF01.PYBZ = 1 ) and ( MS_CF01.ZFPB = 0 ) and ( MS_CF01.CFLX in (1, 2)) and ( MS_CF01.YFSB = 1) and (MS_CF01.DYBZ = 1 ) and MS_CF01.FYCK = 3 and ( MS_CF01.FYBZ = 0 )
6w7uj0jy0fpv6	DELETE FROM SS_REGISTER Where XTSB =:1 AND YHDM =:2 AND WKDZ =:3
702ggkq5a61pg	SELECT COUNT ( 1 ) FROM LC_LCYJ , ZY_BRRY WHERE ZY_BRRY.ZYH =LC_LCYJ.BRBH AND ( LC_LCYJ.ZGYS =:1 OR LC_LCYJ.YJKS =:2 ) AND LC_LCYJ.CLBZ =0 AND ( ZY_BRRY.CYRQ IS NULL OR ZY_BRRY.CYRQ > sysdate - 7 )
755n8d4g0u6g7	SELECT MS_CF01.CFHM, MS_CF01.BRXM, MS_CF01.CFSB, MS_CF01.CFLX, MS_MZXX.SFRQ, MS_CF01.FYBZ, MS_CF01.JZCF, /ADD BY panyd 急诊处方 / MS_CF01.ETCF, /ADD BY panyd 儿童处方/ MS_CF01.DJTS, MS_CF01.FPHM FROM MS_CF01, MS_MZXX WHERE MS_MZXX.FPHM is not null and MS_MZXX.MZXH = MS_CF01.MZXH and MS_MZXX.SFRQ >= :ad_begindate and MS_CF01.DYBZ = 1 and MS_CF01.ZFPB = 1 and MS_CF01.FYBZ = 0 and MS_CF01.YFSB = :ai_yfsb and MS_CF01.FYCK = :ai_fyck and MS_CF01.QRBZ = 0
8575dwh28r0xw	BEGIN dt_SYSDate(P_SYSDATE=>:P_SYSDATE); END;
899dygcsptrd1	UPDATE GY_IDENTITY_YF SET DQZ = DQZ + 2 WHERE BMC = 'YF_MZFYMX'
8qnqup4hshpxf	DELETE FROM "MS_CF02" WHERE "SBXH" = :1 AND "CFSB" = :2 AND "PLXH" = :3 AND "YPZH" = :4 AND "YPXH" = :5 AND "YPCD" = :6 AND "YFGG" = :7 AND "YFDW" = :8 AND "XMLX" = :9 AND "YPSL" = :10 AND "YCSL" = :11 AND "YCJL" = :12 AND "YFBZ" = :13 AND "YPDJ" = :14 AND "MRCS" = :15 AND "YYTS" = :16 AND "CFTS" = :17 AND "YPYF" = :18 AND "GYTJ" = :19 AND "YPZS" = :20 AND "FYGB" = :21 AND "PSPB" = :22 AND "ZFBL" = :23 AND "HJJE" = :24 AND "CFBZ" = :25 AND "PSJG" = :26 AND "SPBZ" = :27 AND "ZHSL" = :28 AND "ZHDW" = :29 AND "BZ" = :30 AND "SRSJ" = :31 AND "ZSCS" = :32 AND "ZFBZ" = :33 AND "KSSBZ" = :34 AND "JBXH" IS NULL AND "YJQM" IS NULL
927131k0pbp3r	SELECT LC_LCZX.ZXBH, LC_LCZX.BRBH, LC_LCZX.LCBH, LC_LCZX.XMBH, LC_LCZX.YPJL, LC_LCZX.SYSL, LC_LCZX.ZZKS, LC_LCZX.ZCWC, LC_LCZX.TZSJ, LC_LCZX.SXBZ, LC_LCZX.TJR, LC_LCZX.TJSJ, LC_LCZX.ZXR, LC_LCZX.ZXSJ, LC_LCZX.YCBZ, LC_LCZX.JGBH, LC_LCZX.ZXZT, LC_LCXM.XMMC, LC_LCXM.YJJB, ZY_BRRY.ZYYS, ZY_BRRY.BRKS, LC_LCXM.ZLXH, LC_LCXM.XMLX, LC_LCXM.RQXH, LC_LCXM.XMKZ , LC_LCXM.DYXM , ZY_BRRY.ZSYS FROM LC_LCZX, LC_LCXM, ZY_BRRY, LC_BRLC WHERE ( LC_LCXM.XMBH = LC_LCZX.XMBH ) AND ( LC_LCZX.BRBH = ZY_BRRY.ZYH ) AND ( LC_LCZX.BRBH = LC_BRLC.BRBH) AND ( ZY_BRRY.BRKS = :al_brks ) AND ( ZY_BRRY.CYPB < 1) AND ( LC_BRLC.TZSJ IS NULL ) AND ( LC_LCZX.ZCWC <= :adt_thedate ) AND ( LC_LCZX.ZXZT <> 'ZX') AND ( LC_LCZX.YCBZ = 0)
9g8gb8mj0j60h	SELECT COUNT ( *) FROM LB_XZDZ WHERE BRXZ =:1
9gpjxpz3m4551	Select ckxx , brid From GY_CKDA Where ckxx =:1 And rownum =1
9k86kjgywamrq	SELECT GY_JBBM.JBXH, GY_JBBM.DMLB, GY_JBBM.JBMC, GY_JBBM.JBLB, GY_JBBM.PYDM, GY_JBBM.ICD9, GY_JBBM.ICD10, GY_JBBM.CRBZ, GY_JBBM.CRBM, GY_JBBM.YBTS, GY_JBBM.TSBTS, GY_JBBM.CRID, GY_JBBM.BMXH, GY_JBBM.KSBM, GY_JBBM.CRLB, GY_JBBM.MXBID, GY_JBBM.ZFPB , GY_JBBM.LBJB, NVL(GY_JBBM.ZYZD, 0) ZYZD, GY_JBBM.TZYB_JB, CASE WHEN B.SYSL IS NULL THEN 0 ELSE B.SYSL END AS SYSL FROM GY_JBBM, (SELECT JBDM, YSDM, SYSL FROM YS_ZD_SYSL WHERE YSDM = :as_ysdm) B WHERE ( GY_JBBM.ZFPB <> 1 OR GY_JBBM.ZFPB is Null ) AND ( GY_JBBM.JBXH = B.JBDM (+) ) ORDER BY GY_JBBM.PYDM ASC
9n0dmp9tzvgqc	SELECT nvl(a.gzrq, :adt_begin) as gzrq, MS_KSPB.GHKS, ms_ghks.ksmc, MS_KSPB.ZBLB, a.YSDM, a.ztgh, MS_KSPB.Ghxe, MS_KSPB.Yyxe, ms_ghks.ksdm FROM (SELECT ms_yspb.ksdm, ms_yspb.ysdm, ms_yspb.zblb, ms_yspb.ztgh, MS_YSPB.gzrq FROM MS_YSPB WHERE MS_YSPB.gzrq >= :adt_begin AND MS_YSPB.gzrq <= :adt_end ) a, MS_KSPB, ms_ghks WHERE a.KSDM(+) = MS_KSPB.GHKS AND a.zblb(+) = ms_kspb.zblb AND MS_KSPB.ghks = ms_ghks.ksdm AND MS_KSPB.GHRQ = :ai_week AND NVL(MS_GHKS.ZJMZ, 0) = 0 and MS_KSPB.GZRQ >= :adt_begin AND MS_KSPB.GZRQ <= :adt_end ORDER BY MS_KSPB.Zblb, MS_KSPB.GHKS, a.YSDM
a7nfq189pmb01	SELECT MS_CF01.CFHM, MS_CF01.CFSB, MS_CF01.BRXM, MS_MZXX.SFRQ, MS_CF01.BRID, MS_CF01.FYBZ, MS_CF01.pybz, 0 AS CYBZ, MS_CF01.DYRQ FROM MS_CF01, MS_MZXX WHERE ( MS_CF01.MZXH = MS_MZXX.MZXH ) AND ( MS_MZXX.SFRQ >= TO_DATE('11-05-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS') ) and ( MS_CF01.FPHM is not null ) and ( MS_CF01.PYBZ = 1 ) and ( MS_CF01.ZFPB = 0 ) and ( MS_CF01.CFLX in (1, 2)) and ( MS_CF01.YFSB = 1) and (MS_CF01.DYBZ = 1 ) and MS_CF01.FYCK = 1 and ( MS_CF01.FYBZ = 0 )
aazrv4j48xq9s	Select BRXZ , BRID , ZFPB , CKHM From GY_CKDA Where CKXX =:1
abxfgcadcabtk	SELECT YGXM FROM GY_YGDM Where YGDM =:1
apv6kxf9uzh59	DELETE FROM "WH_MENU" WHERE "XTSB" = :1 AND "CDMC" = :2
aq1zd8jwwca5c	SELECT COUNT(*) FROM GY_IDENTITY_YZ WHERE BMC = 'YZ_YZZH'
au7x36nfwuuw6	SELECT NVL ( YJJE , 0 ) FROM ZY_BRRY WHERE ZY_BRRY.ZYH =:1 AND ZY_BRRY.CYPB =0
bkdp4fpmcncmt	INSERT INTO SS_REGISTER ( XTSB , YHDM , WKDZ , DLSJ , IPDZ , JSJM ) Values ( :1 , :2 , :3 , :4 , :5 , :6 )
bqfw81mfzdupf	SELECT YHZM FROM SS_OPERATE_USER WHERE XTSB =:1 AND YHDM =:2
bu9z4n28mb2nu	SELECT GY_YGDM.YGDM , GY_YGDM.YGXM , GY_YGDM.YGMM , GY_YGDM.YGBH FROM SS_OPERATE_USER , GY_YGDM WHERE SS_OPERATE_USER.YHDM =GY_YGDM.YGDM AND GY_YGDM.ZFPB =0 AND SS_OPERATE_USER.XTSB =:1 AND GY_YGDM.YGBH =:2
bxv4auh6fkjdy	SELECT TJBQ, TJYF, YZLX, FYFS, COUNT() AS WFTS FROM BQ_TJ01 WHERE FYBZ = 0 AND TJYF=0 group by TJBQ, TJYF, YZLX, FYFS union SELECT TYBQ AS TJBQ, YFSB AS TJYF, 5 AS YZLX, 0 AS FYFS, count() as WFTS FROM BQ_TYMX WHERE YFSB = 0 AND TJBZ=1 and TYRQ is null group by TYBQ, YFSB union SELECT KDKS AS TJBQ, YFSB AS TJYF, 4 AS YZLX, 0 AS FYFS, count(*) as WFTS from YJ_YJYY where SYBZ=1 and YFSB=0 group by KDKS, YFSB
d67ph6ysm4s51	SELECT SUM ( JKJE ) FROM ZY_TBKK , ZY_BRRY WHERE ZY_BRRY.ZYH =ZY_TBKK.ZYH AND ZY_BRRY.ZYH =:1 AND ZY_BRRY.CYPB =0 AND ZY_TBKK.JSCS =0
dm9r9cx2rgfnv	Select MS_GHMX.SBXH, MS_GHMX.KSDM, MS_GHMX.YSDM, MS_GHMX.GHSJ, MS_GHMX.GHKSDM, MS_GHMX.GHYSDM, MS_GHMX.GHLBXH, MS_GHMX.JZXH, MS_GHMX.ZBLB, MS_GHKS.MZKS From MS_GHMX , MS_GHKS Where MS_GHMX.KSDM = MS_GHKS.KSDM And MS_GHMX.BRID = :al_PatientId And MS_GHMX.THBZ = 0 And MS_GHMX.GHSJ >= :adt_today
dmw4vv3fswyux	SELECT ZY_BRRY.ZYH, ZY_BRRY.ZYHM, ZY_BRRY.BRCH, ZY_BRRY.BRXM, ZY_BRRY.BRXB, ZY_BRRY.CSNY, ZY_BRRY.GZDW, ZY_BRRY.ZSYS, ZY_BRRY.ZLXZ, ZY_BRRY.DJRQ FROM ZY_BRRY WHERE ( ZY_BRRY.BRBQ = :al_DeptId OR ZY_BRRY.BRKS = :al_DeptId) AND ( ZY_BRRY.CYPB < 1 ) AND ( BRCH IS NOT NULL OR TRIM(BRCH) <> '' ) AND NVL( YSJS , 0 ) = 0 AND NOT EXISTS (SELECT * FROM ZY_ZKJL WHERE ZY_ZKJL.ZYH = ZY_BRRY.ZYH AND ZY_ZKJL.ZXBZ = 2) ORDER BY ZLXZ, ZSYS, BRCH
fbahzpyh5625k	SELECT "MS_YYDJ"."MZHM", "MS_YYDJ"."BRXM", "MS_YYDJ"."SBXH", "GY_YGDM"."YGXM", "MS_YYDJ"."YYRQ", "MS_YYDJ"."KSDM", "MS_YYDJ"."YSDM", "MS_YYDJ"."ZFBZ", "MS_GHKS"."KSMC", "MS_YYDJ"."BRID", "MS_YYDJ"."ZBLB", "MS_YYDJ"."YYFS", "MS_YYDJ"."JZXH", "MS_YYDJ"."LXDH" FROM "MS_YYDJ", "GY_YGDM", "MS_GHKS" WHERE ( "MS_YYDJ"."YSDM" = "GY_YGDM"."YGDM"(+) ) and ( "MS_YYDJ"."KSDM" = "MS_GHKS"."KSDM" ) AND ( MS_YYDJ.YYRQ >= :adt_kssj ) and ( MS_YYDJ.YYRQ < :adt_jssj ) and ( MS_YYDJ.BRID = :al_brid or 0 = :al_brid )
fga17xtru63gg	SELECT MS_CF01.CFHM, MS_CF01.BRXM, MS_CF01.CFSB, MS_CF01.CFLX, MS_MZXX.SFRQ, MS_CF01.FYBZ, MS_CF01.JZCF, /ADD BY panyd 急诊处方 / MS_CF01.ETCF, /ADD BY panyd 儿童处方/ MS_CF01.djts, MS_CF01.JZXH FROM MS_CF01, MS_MZXX WHERE MS_MZXX.FPHM is not null and MS_MZXX.MZXH = MS_CF01.MZXH and MS_MZXX.SFRQ >= :ad_begindate and MS_CF01.DYBZ = 0 and MS_CF01.ZFPB = 0 and MS_CF01.FYBZ = 0 and MS_CF01.YFSB = :ai_yfsb and MS_CF01.FYCK = :ai_fyck and (MS_CF01.FYCK is null or MS_CF01.FYCK in 1) order by MS_MZXX.SFRQ
fxv64cnbp1978	select PY from GY_HZBM where HZ =:1
fyndfj02gywdr	SELECT B.FYCK, B.FPHM, A.BRXM , A.CSNY FROM V_MS_BRDA_SY A, V_MS_CF01_FY B WHERE A.BRID=B.ID and B.FYCK= 4 and 20120515<= to_char(A.CSNY, 'yyyymmdd') ORDER BY A.CSNY desc
g0t2hwua5v6m4	Delete From SS_REGISTER Where XTSB =:1 AND YHDM =:2 AND WKDZ =:3
g9zn3qh3yb0y0	UPDATE GY_IDENTITY_YZ SET DQZ = DQZ + 1 WHERE BMC = 'YZ_YZZH'
gc672gmwxpj07	SELECT COUNT(*) FROM GY_IDENTITY_YF WHERE BMC = 'YF_KCMX'
gdrn48txd0f3u	SELECT DISTINCT LC_LCYJ.BRBH FROM LC_LCYJ , ZY_BRRY WHERE LC_LCYJ.BRBH = ZY_BRRY.ZYH AND (LC_LCYJ.ZGYS = :as_Doctorid OR LC_LCYJ.YJKS = :ai_yjks) AND (ZY_BRRY.CYRQ IS NULL OR ZY_BRRY.CYRQ>sysdate - 7 ) AND LC_LCYJ.CLBZ = 0
gkzn84z8xhqvh	select nvl ( count ( *) , 0 ) from yk_ck01 where xtsb =:1 and yfly ='1' AND CKRQ IS NULL and sqtj =1
gq0m5q82b8zdy	SELECT ZY_ZKJL.JLXH, ZY_ZKJL.ZYH, ZY_BRRY.BRXM AS BRXM, '' AS CWHM, ZY_ZKJL.HCLX, ZY_ZKJL.YSSQRQ, ZY_ZKJL.YSSQGH, ZY_ZKJL.BQSQRQ, ZY_ZKJL.BQSQGH, ZY_ZKJL.BQZXRQ, ZY_ZKJL.BQZXGH, ZY_ZKJL.YSZXRQ, ZY_ZKJL.YSZXGH, ZY_ZKJL.ZXBZ, ZY_ZKJL.HQCH, ZY_ZKJL.HHCH, ZY_ZKJL.HQBQ, ZY_ZKJL.HHBQ, ZY_ZKJL.HQKS, ZY_ZKJL.HHKS, ZY_ZKJL.HQYS, ZY_ZKJL.HHYS, decode(YS_ZY_JZJL.JZHM, null, 0, 1) AS YSBRBZ FROM ZY_ZKJL, ZY_BRRY, YS_ZY_JZJL WHERE ZY_ZKJL.HCLX = 3 AND ZY_ZKJL.HQKS = :al_hqks AND ZY_ZKJL.ZXBZ = 0 AND ZY_ZKJL.ZYH = ZY_BRRY.ZYH AND TO_CHAR(ZY_ZKJL.ZYH) = YS_ZY_JZJL.JZHM(+) AND YS_ZY_JZJL.YSDM = :as_ysdm

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	694,572	192.83	16.26
CPU used when call started	693,917	192.65	16.24
CR blocks created	5,607	1.56	0.13
Cached Commit SCN referenced	460	0.13	0.01
Commit SCN cached	1	0.00	0.00
DB time	1,446,881	401.68	33.87
DBWR checkpoint buffers written	26,564	7.37	0.62
DBWR checkpoints	2	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	104	0.03	0.00
DBWR undo block writes	3,561	0.99	0.08
IMU CR rollbacks	1,376	0.38	0.03
IMU Flushes	1,770	0.49	0.04
IMU Redo allocation size	16,863,572	4,681.66	394.77
IMU commits	35,112	9.75	0.82
IMU contention	238	0.07	0.01
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	6,169	1.71	0.14
IMU recursive-transaction flush	28	0.01	0.00
IMU undo allocation size	136,752,376	37,965.18	3,201.36
IMU- failed to get a private strand	6,169	1.71	0.14
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
RowCR - row contention	96	0.03	0.00
RowCR attempts	32,965	9.15	0.77
RowCR hits	33,095	9.19	0.77
SMON posted for undo segment shrink	7	0.00	0.00
SQL*Net roundtrips to/from client	4,060,779	1,127.35	95.06
active txn count during cleanout	7,190	2.00	0.17
application wait time	296	0.08	0.01
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	13,982	3.88	0.33
branch node splits	1	0.00	0.00
buffer is not pinned count	171,556,767	47,627.58	4,016.12
buffer is pinned count	418,455,626	116,171.62	9,796.00
bytes received via SQL*Net from client	549,469,940	152,543.80	12,863.03
bytes sent via SQL*Net to client	7.8E+11	217,334,499.79	18,326,405.95
calls to get snapshot scn: kcmgss	2,090,449	580.35	48.94
calls to kcmgas	55,864	15.51	1.31
calls to kcmgcs	719	0.20	0.02
change write time	466	0.13	0.01
cleanout - number of ktugct calls	4,662	1.29	0.11
cleanouts and rollbacks - consistent read gets	2,818	0.78	0.07
cleanouts only - consistent read gets	207	0.06	0.00
cluster key scan block gets	10,818,692	3,003.48	253.26
cluster key scans	4,945,777	1,373.05	115.78
commit batch/immediate performed	14	0.00	0.00
commit batch/immediate requested	14	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	110	0.03	0.00
commit cleanout failures: cannot pin	163	0.05	0.00
commit cleanouts	124,299	34.51	2.91
commit cleanouts successfully completed	124,026	34.43	2.90
commit immediate performed	14	0.00	0.00
commit immediate requested	14	0.00	0.00
commit txn count during cleanout	5,328	1.48	0.12
concurrency wait time	189	0.05	0.00
consistent changes	7,530	2.09	0.18
consistent gets	375,706,496	104,303.61	8,795.25
consistent gets - examination	62,225,576	17,275.06	1,456.69
consistent gets direct	1	0.00	0.00
consistent gets from cache	375,706,471	104,303.60	8,795.24
current blocks converted for CR	0	0.00	0.00
cursor authentications	2,433	0.68	0.06
data blocks consistent reads - undo records applied	6,519	1.81	0.15
db block changes	535,224	148.59	12.53
db block gets	631,081	175.20	14.77
db block gets direct	34	0.01	0.00
db block gets from cache	631,047	175.19	14.77
deferred (CURRENT) block cleanout applications	59,286	16.46	1.39
dirty buffers inspected	0	0.00	0.00
enqueue conversions	2,968	0.82	0.07
enqueue deadlocks	0	0.00	0.00
enqueue releases	150,417	41.76	3.52
enqueue requests	150,417	41.76	3.52
enqueue timeouts	0	0.00	0.00
enqueue waits	70	0.02	0.00
exchange deadlocks	0	0.00	0.00
execute count	1,453,706	403.58	34.03
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	5,919	1.64	0.14
free buffer requested	13,795	3.83	0.32
heap block compress	6,169	1.71	0.14
hot buffers moved to head of LRU	73,118	20.30	1.71
immediate (CR) block cleanout applications	3,025	0.84	0.07
immediate (CURRENT) block cleanout applications	6,572	1.82	0.15
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	40,720	11.30	0.95
index fast full scans (full)	3,583	0.99	0.08
index fetch by key	23,265,068	6,458.85	544.63
index scans kdiixs1	21,103,883	5,858.86	494.04
leaf node 90-10 splits	91	0.03	0.00
leaf node splits	418	0.12	0.01
lob reads	41	0.01	0.00
lob writes	95	0.03	0.00
lob writes unaligned	95	0.03	0.00
logons cumulative	2,100	0.58	0.05
messages received	61,767	17.15	1.45
messages sent	61,767	17.15	1.45
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	312,342,996	86,712.64	7,311.91
opened cursors cumulative	250,793	69.63	5.87
parse count (failures)	4,121	1.14	0.10
parse count (hard)	11,097	3.08	0.26
parse count (total)	1,468,944	407.81	34.39
parse time cpu	9,011	2.50	0.21
parse time elapsed	9,164	2.54	0.21
physical read IO requests	2,410	0.67	0.06
physical read bytes	19,742,720	5,480.97	462.17
physical read total IO requests	6,493	1.80	0.15
physical read total bytes	171,993,600	47,748.85	4,026.35
physical read total multi block requests	84	0.02	0.00
physical reads	2,410	0.67	0.06
physical reads cache	2,395	0.66	0.06
physical reads cache prefetch	0	0.00	0.00
physical reads direct	15	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	20,221	5.61	0.47
physical write bytes	218,005,504	60,522.67	5,103.48
physical write total IO requests	68,929	19.14	1.61
physical write total bytes	484,269,568	134,442.88	11,336.69
physical write total multi block requests	39,521	10.97	0.93
physical writes	26,612	7.39	0.62
physical writes direct	48	0.01	0.00
physical writes direct (lob)	14	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	26,564	7.37	0.62
physical writes non checkpoint	3,157	0.88	0.07
pinned buffers inspected	0	0.00	0.00
pinned cursors current	4	0.00	0.00
prefetch clients - default	242	0.07	0.01
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,600	1.00	0.08
recovery blocks read	0	0.00	0.00
recursive calls	582,546	161.73	13.64
recursive cpu usage	6,408	1.78	0.15
redo blocks read for recovery	0	0.00	0.00
redo blocks written	185,550	51.51	4.34
redo buffer allocation retries	7	0.00	0.00
redo entries	179,020	49.70	4.19
redo log space requests	7	0.00	0.00
redo log space wait time	12	0.00	0.00
redo ordering marks	2,139	0.59	0.05
redo size	78,308,444	21,739.98	1,833.19
redo subscn max counts	5,085	1.41	0.12
redo synch time	9,001	2.50	0.21
redo synch writes	41,927	11.64	0.98
redo wastage	13,851,268	3,845.39	324.26
redo write time	8,012	2.22	0.19
redo writer latching time	0	0.00	0.00
redo writes	43,384	12.04	1.02
rollback changes - undo records applied	500	0.14	0.01
rollbacks only - consistent read gets	2,229	0.62	0.05
root node splits	0	0.00	0.00
rows fetched via callback	20,551,181	5,705.42	481.10
session connect time	0	0.00	0.00
session cursor cache hits	1,025,228	284.62	24.00
session logical reads	376,338,333	104,479.02	8,810.04
shared hash latch upgrades - no wait	426,345	118.36	9.98
shared hash latch upgrades - wait	8	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	126,116	35.01	2.95
sorts (rows)	31,738,986	8,811.37	743.01
sql area evicted	4,050	1.12	0.09
sql area purged	4,121	1.14	0.10
summed dirty queue length	0	0.00	0.00
switch current to new buffer	4,127	1.15	0.10
table fetch by rowid	267,340,469	74,219.04	6,258.41
table fetch continued row	971,567	269.73	22.74
table scan blocks gotten	150,808,840	41,867.54	3,530.42
table scan rows gotten	11,036,925,779	3,064,070.45	258,373.15
table scans (long tables)	0	0.00	0.00
table scans (short tables)	208,410	57.86	4.88
total number of times SMON posted	7	0.00	0.00
transaction rollbacks	14	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	25,547,832	7,092.59	598.07
user I/O wait time	1,077	0.30	0.03
user calls	3,122,151	866.77	73.09
user commits	42,160	11.70	0.99
user rollbacks	557	0.15	0.01
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	101,729	28.24	2.38
write clones created in background	0	0.00	0.00
write clones created in foreground	1	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	2.1E+11	2.1E+11
session cursor cache count	8,493,308	8,506,144
session uga memory	3.8E+14	3.8E+14
opened cursors current	3,053	3,150
workarea memory allocated	145,920	145,920
logons current	1,037	1,061
session uga memory max	5.6E+11	5.6E+11
session pga memory	1.4E+11	1.4E+11

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	2	2.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits
BSRUN	2,232	1	4.62	1.00	19,308	5	10
SYSAUX	27	0	1.48	1.00	387	0	0
UNDOTBS1	2	0	0.00	1.00	380	0	2
SYSTEM	149	0	3.42	1.00	156	0	0
USERS	2	0	0.00	1.00	2	0	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits
BSRUN	Z:\ORADATA\BSRUN\BSRUN1.ORA	879	4.76	1.00	7,256	2	9
BSRUN	Z:\ORADATA\BSRUN\BSRUN2.ORA	962	4.55	1.00	6,276	2	1
BSRUN	Z:\ORADATA\BSRUN\BSRUN3.ORA	391	4.48	1.00	5,776	2	0
SYSAUX	Z:\ORADATA\BSRUN\SYSAUX01.DBF	27	1.48	1.00	387	0	0
SYSTEM	Z:\ORADATA\BSRUN\SYSTEM01.DBF	149	3.42	1.00	156	0	0
UNDOTBS1	Z:\ORADATA\BSRUN\UNDOTBS01.DBF	2	0.00	1.00	380	0	2
USERS	Z:\ORADATA\BSRUN\USERS01.DBF	2	0.00	1.00	2	0	0

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	562,036	100	376,329,832	2,395	26,585	0	0	12

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	17	2588	18868	76043	184320	76043
E	0	17	2857	21208	96756	184320	96756

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	448	0.10	55,412	932.18	21,502,546,008
D	896	0.20	110,824	340.24	7,848,371,478
D	1,344	0.30	166,236	102.38	2,361,633,270
D	1,792	0.39	221,648	29.83	687,989,879
D	2,240	0.49	277,060	9.44	217,721,240
D	2,688	0.59	332,472	3.51	81,028,638
D	3,136	0.69	387,884	1.98	45,626,047
D	3,584	0.79	443,296	1.45	33,373,292
D	4,032	0.89	498,708	1.18	27,250,605
D	4,480	0.99	554,120	1.02	23,447,584
D	4,544	1.00	562,036	1.00	23,066,902
D	4,928	1.08	609,532	0.91	20,898,818
D	5,376	1.18	664,944	0.84	19,379,863
D	5,824	1.28	720,356	0.80	18,538,317
D	6,272	1.38	775,768	0.79	18,142,038
D	6,720	1.48	831,180	0.78	17,973,055
D	7,168	1.58	886,592	0.78	17,898,741
D	7,616	1.68	942,004	0.77	17,824,212
D	8,064	1.77	997,416	0.76	17,532,129
D	8,512	1.87	1,052,828	0.72	16,671,427
D	8,960	1.97	1,108,240	0.65	15,043,506

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	19,866	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,000	2,353	991.07	142.50	14.38	100.00	0.00	307,200
E	3,000	2,343	999.10	142.50	14.26	100.00	0.00	307,200

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	83,682	83,682
64K	128K	155	155
128K	256K	304	304
256K	512K	632	632
512K	1024K	12,843	12,843
1M	2M	2,812	2,812
2M	4M	1,292	1,292

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
375	0.13	9,972,604.28	171,454.72	98.00	8,243
750	0.25	9,972,604.28	10,900.84	100.00	0
1,500	0.50	9,972,604.28	10,488.96	100.00	0
2,250	0.75	9,972,604.28	10,488.96	100.00	0
3,000	1.00	9,972,604.28	10,488.96	100.00	0
3,600	1.20	9,972,604.28	7,225.98	100.00	0
4,200	1.40	9,972,604.28	7,225.98	100.00	0
4,800	1.60	9,972,604.28	7,225.98	100.00	0
5,400	1.80	9,972,604.28	7,225.98	100.00	0
6,000	2.00	9,972,604.28	7,225.98	100.00	0
9,000	3.00	9,972,604.28	7,225.98	100.00	0
12,000	4.00	9,972,604.28	7,225.98	100.00	0
18,000	6.00	9,972,604.28	7,225.98	100.00	0
24,000	8.00	9,972,604.28	7,225.98	100.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
848	0.37	269	25,260	6,260,556	0.99	71,688	2.08	1,046,499
1,088	0.48	487	37,139	6,283,276	1.00	48,968	1.42	1,049,656
1,328	0.58	726	50,856	6,291,248	1.00	40,996	1.19	1,050,749
1,568	0.69	965	63,245	6,293,287	1.00	38,957	1.13	1,051,042
1,808	0.79	1,204	75,868	6,295,958	1.00	36,286	1.05	1,051,205
2,048	0.90	1,443	88,244	6,297,023	1.00	35,221	1.02	1,051,372
2,288	1.00	1,682	99,550	6,297,745	1.00	34,499	1.00	1,051,503
2,528	1.10	1,921	110,164	6,298,171	1.00	34,073	0.99	1,051,580
2,768	1.21	2,160	121,204	6,298,437	1.00	33,807	0.98	1,051,626
3,008	1.31	2,399	133,343	6,298,711	1.00	33,533	0.97	1,051,676
3,248	1.42	2,638	147,138	6,298,943	1.00	33,301	0.97	1,051,718
3,488	1.52	2,877	161,029	6,299,107	1.00	33,137	0.96	1,051,747
3,728	1.63	3,116	173,528	6,299,259	1.00	32,985	0.96	1,051,773
3,968	1.73	3,355	186,209	6,299,410	1.00	32,834	0.95	1,051,801
4,208	1.84	3,594	198,841	6,299,535	1.00	32,709	0.95	1,051,823
4,448	1.94	3,833	211,246	6,299,637	1.00	32,607	0.95	1,051,842
4,688	2.05	4,072	223,690	6,299,745	1.00	32,499	0.94	1,051,862

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,752	0.25	38,652,186	23,733,207,387
3,504	0.50	2,518,902	240,308,626
5,256	0.75	2,195,626	30,076,927
7,008	1.00	2,171,093	23,066,897
8,760	1.25	2,165,231	20,024,373
10,512	1.50	2,163,928	19,837,531
12,264	1.75	2,159,152	16,603,552
14,016	2.00	2,158,502	16,603,552

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	10	0	0
undo block	1	0	0
undo header	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	70	70	0	70	1	7.84

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	3.42	43,339	93	6	15/15	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
14-5月 10:00	674	7,479	40	5	15	0/0	0/0/0/0/0/0
14-5月 09:50	645	8,152	26	5	15	0/0	0/0/0/0/0/0
14-5月 09:40	521	7,204	13	5	15	0/0	0/0/0/0/0/0
14-5月 09:30	645	7,509	93	5	15	0/0	0/0/0/0/0/0
14-5月 09:20	430	5,983	63	5	15	0/0	0/0/0/0/0/0
14-5月 09:10	504	7,012	0	6	15	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,401	0.00		0	0
AWR Alerted Metric Element list	73,860	0.00		0	0
Consistent RBA	43,386	0.00	0.00	0	0
FAL request queue	77	0.00		0	0
FAL subheap alocation	77	0.00		0	0
FIB s.o chain latch	12	0.00		0	0
FOB s.o list latch	388	0.00		0	0
In memory undo latch	236,543	0.01	0.57	0	47,512	0.00
JS mem alloc latch	5	0.00		0	0
JS queue access latch	5	0.00		0	0
JS queue state obj latch	21,688	0.00		0	0
KMG MMAN ready and startup request latch	1,201	0.00		0	0
KTF sga latch	9	0.00		0	1,207	0.00
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	0			0	1,201	0.00
OS process	2,715	0.00		0	0
OS process allocation	3,017	0.00		0	0
OS process: request allocation	1,724	0.00		0	0
PL/SQL warning settings	88,730	0.00		0	0
SQL memory manager latch	1	0.00		0	1,197	0.00
SQL memory manager workarea list latch	225,122	0.00		0	0
active checkpoint queue latch	21,186	2.58	0.00	0	0
active service list	13,658	0.03	0.50	0	3,055	0.00
address list	1,174	0.00		0	0
alert log latch	4	0.00		0	0
archive control	75	0.00		0	0
archive process latch	1,355	0.00		0	0
begin backup scn array	18	0.00		0	0
cache buffer handles	40,083	0.00		0	0
cache buffers chains	692,215,822	0.01	0.00	0	12,769	0.00
cache buffers lru chain	61,507	0.08	0.00	0	18,049	0.01
channel handle pool latch	1,724	0.00		0	0
channel operations parent latch	23,810	0.00		0	0
checkpoint queue latch	551,044	0.01	0.00	0	26,335	0.00
client/application info	13,601	0.00		0	0
compile environment latch	2,101	0.00		0	0
dml lock allocation	133,502	0.01	0.00	0	0
dummy allocation	4,178	0.00		0	0
enqueue hash chains	303,840	0.00	0.00	0	0
enqueues	199,542	0.01	0.00	0	0
event group latch	865	0.00		0	0
file cache latch	141	0.00		0	0
global KZLD latch for mem in SGA	2,016	0.00		0	0
hash table column usage latch	743	0.00		0	582,389	0.00
hash table modification latch	116	0.00		0	0
interrupt manipulation	1,590	0.00		0	0
job workq parent latch	0			0	124	0.00
job_queue_processes parameter latch	122	0.00		0	0
kks stats	53,023	0.00		0	0
kmcptab latch	2,312	0.00		0	0
kmcpvec latch	0			0	2,310	0.09
kokc descriptor allocation latch	86	0.00		0	0
ksuosstats global area	242	0.00		0	0
ktm global data	29	0.00		0	0
lgwr LWN SCN	44,567	0.53	0.00	0	0
library cache	2,813,711	0.02	0.05	0	69,367	0.03
library cache load lock	1,430	0.00		0	0
library cache lock	6,479,770	0.00	0.00	0	0
library cache lock allocation	6,580	0.03	0.00	0	0
library cache pin	526,040	0.00	0.00	0	0
library cache pin allocation	808	0.00		0	0
list of block allocation	2,075	0.00		0	0
loader state object freelist	40	0.00		0	0
messages	197,864	0.32	0.00	0	0
mostly latch-free SCN	45,688	1.84	0.00	0	0
ncodef allocation latch	72	0.00		0	0
object queue header heap	84,793	0.00		0	5	0.00
object queue header operation	185,826	0.02	0.03	0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	480	0.00		0	0
parameter list	4,250	0.00		0	0
parameter table management	4,180	0.00		0	0
post/wait queue	62,965	0.00		0	42,020	0.00
process allocation	1,724	0.00		0	865	0.00
process group creation	1,724	0.00		0	0
redo allocation	221,673	0.01	0.00	0	178,930	0.10
redo copy	0			0	178,988	0.05
redo writing	153,946	0.35	0.00	0	0
resmgr group change latch	2,390	0.00		0	0
resmgr:active threads	4,163	0.00		0	0
resmgr:actses change group	2,078	0.00		0	0
resmgr:free threads list	4,162	0.00		0	0
resmgr:resource group CPU method	2,053	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	2,213,769	0.01	0.07	0	997	0.40
sequence cache	6,472	0.00		0	0
session allocation	250,942	0.02	0.00	0	0
session idle bit	6,367,042	0.00	0.01	0	0
session state list latch	4,186	0.00		0	0
session switching	4,367	0.00		0	0
session timer	1,518	0.00		0	0
shared pool	2,166,026	0.04	0.13	2	0
shared pool sim alloc	2	0.00		0	0
shared pool simulator	92,224	0.00		0	0
simulator hash latch	20,740,395	0.00	0.00	0	0
simulator lru latch	26,586	0.19	0.00	0	20,713,721	0.13
slave class	8	0.00		0	0
slave class create	32	3.13	1.00	0	0
sort extent pool	111	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	252	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	143	0.00		0	0
trace latch	7	0.00		0	0
transaction allocation	1,415	0.00		0	0
transaction branch allocation	1,518	0.00		0	0
undo global data	222,391	0.00		0	0
user lock	8,138	0.04	0.00	0	0
virtual circuit buffers	15,466,788	0.41	0.00	0	0
virtual circuit queues	7,183,083	0.02	0.00	0	0
virtual circuits	2,326,974	0.07	0.00	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
virtual circuit buffers	15,466,788	62,777	66	62,711
cache buffers chains	692,215,822	40,967	35	40,933
virtual circuits	2,326,974	1,588	3	1,585
shared pool	2,166,026	902	113	798
messages	197,864	631	2	629
library cache	2,813,711	495	24	473
session idle bit	6,367,042	209	2	207
row cache objects	2,213,769	137	10	127
object queue header operation	185,826	32	1	31
In memory undo latch	236,543	14	8	6
active service list	13,658	4	2	2
slave class create	32	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	6	3
In memory undo latch	kticmt: child	3	2
active service list	kswslogon: session login	1	1
active service list	kswslogon: session logout	1	1
active service list	kswssyis: find service entry 1	1	1
cache buffers chains	kcbgtcr: kslbegin excl	69	58
cache buffers chains	kcbgtcr: fast path	23	0
cache buffers chains	kcbrls: kslbegin	15	46
cache buffers chains	kcbbxsv	2	2
cache buffers chains	kcbget: pin buffer	2	1
cache buffers chains	kcbchg: kslbegin: bufs not pinned	1	0
cache buffers chains	kcbgcur: kslbegin	1	1
cache buffers chains	kcbzwb	1	0
library cache	kglhdgn: child:	2	10
library cache	kglpndl: child: after processing	2	0
library cache	kglLockCursor	1	2
library cache	kglScanDependency	1	0
library cache	kgldti: 2child	1	0
library cache	kglobpn: child:	1	2
library cache lock	kgllkdl: child: no lock handle	2	6
messages	ksaamb: after wakeup	2	2
object queue header operation	kcbo_switch_mq_bg	1	0
row cache objects	kqreqd: reget	5	2
session idle bit	ksupuc: set busy	3	0
session idle bit	ksupuc: clear busy	1	4
shared pool	kghalo	68	47
shared pool	kghfrunp: alloc: session dur	18	0
shared pool	kghupr1	16	38
shared pool	kghfrunp: clatch: nowait	14	0
shared pool	kghfre	6	28
shared pool	kghfrunp: clatch: wait	5	5
shared pool	kghfrunp: alloc: cursor dur	4	0
shared pool	kghfrunp	1	0
slave class create	ksvcreate	1	0
virtual circuits	kmcgms: if shared server	39	41
virtual circuits	kmcgms: if not shared server	16	3
virtual circuits	kmcfms	6	0
virtual circuits	kmcgms	2	1
virtual circuits	kmcgms: if called with non-zero ckt	2	0
virtual circuits	kmcgbf	1	10
virtual circuits	kmcmbf	1	12
virtual circuits	kmcmbuf: move ckt	1	2
virtual circuits	kmcrst	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 376,338,333
Captured Segments account for 95.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
BSRUN	BSRUN	MS_CF01	TABLE	80,168,736	21.30
BSRUN	BSRUN	GY_CKDA	TABLE	59,324,720	15.76
BSRUN	BSRUN	IDX_CF01_MZXH	INDEX	34,359,376	9.13
BSRUN	BSRUN	MS_BRDA	TABLE	30,545,760	8.12
BSRUN	BSRUN	MS_MZXX	TABLE	20,287,312	5.39

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 2,410
Captured Segments account for 22.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
BSRUN	BSRUN	PK_FYMX	INDEX	116	4.81
BSRUN	BSRUN	YF_ZYFYMX	TABLE	94	3.90
BSRUN	BSRUN	PK_MS_BRDA	INDEX	48	1.99
BSRUN	BSRUN	PK_MS_CF02	INDEX	43	1.78
BSRUN	BSRUN	IDX_BQ_TJ02_ZYH	INDEX	38	1.58

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
BSRUN	BSRUN	PK_YS_MZ_JZLS	INDEX	157	38.39
BSRUN	BSRUN	GY_IDENTITY_ZY	TABLE	50	12.22
BSRUN	BSRUN	GY_IDENTITY_YZ	TABLE	46	11.25
BSRUN	BSRUN	GY_IDENTITY_MS	TABLE	28	6.85
BSRUN	BSRUN	PK_ZY_BRRY	INDEX	18	4.40

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
BSRUN	BSRUN	IDX_ZYFYMX_YFSB		INDEX	1	100.00

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
BSRUN	BSRUN	GY_IDENTITY_MS		TABLE	5	71.43
BSRUN	BSRUN	GY_IDENTITY_ZY		TABLE	2	28.57

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	65	0.00	2	1
dc_database_links	4,034	0.00	0	1
dc_global_oids	2,834	0.00	0	76
dc_histogram_data	345,012	0.03	0	14,604
dc_histogram_defs	88,672	0.10	0	8,032
dc_object_ids	131,215	0.04	0	1,950
dc_objects	20,050	0.27	5	1,487
dc_profiles	2,080	0.00	0	1
dc_rollback_segments	1,171	0.00	0	52
dc_segments	47,885	0.06	7	1,932
dc_sequences	8	12.50	8	0
dc_tablespace_quotas	2	0.00	2	1
dc_tablespaces	124,767	0.00	0	7
dc_usernames	27,147	0.00	0	52
dc_users	180,159	1.06	0	56
outstanding_alerts	36	0.00	0	6

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	773	0.00	4,882	0.10	5	0
CLUSTER	190	0.00	263	0.00	0	0
INDEX	3	33.33	13	7.69	0	0
SQL AREA	449,132	2.57	1,973,631	1.44	5,449	270
TABLE/PROCEDURE	5,063	0.08	353,007	0.20	445	0
TRIGGER	95	0.00	238	0.42	1	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	432.47		0.65	0.40	5	9	662	662
	Freeable	401.75	0.00	0.97	0.17	3		416	416
	SQL	147.19	146.00	0.24	3.32	48	98	613	485
	PL/SQL	9.97	6.97	0.02	0.01	0	0	622	622
	OLAP	0.02	0.02	0.02	0.00	0	0	1	1
E	Other	437.53		0.65	0.40	5	9	668	668
	Freeable	404.44	0.00	0.96	0.16	3		420	420
	SQL	147.38	146.13	0.24	3.31	48	98	619	495
	PL/SQL	10.01	7.05	0.02	0.01	0	0	628	628
	OLAP	0.02	0.02	0.02	0.00	0	0	1	1

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	4,764,729,344
Fixed Size	2,088,920
Redo Buffers	14,688,256
Variable Size	2,566,914,088

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	free memory	25.95	16.50	-36.40
large	session heap	133.03	142.47	7.10
shared	ASH buffers	40.50	40.50	0.00
shared	CCursor	249.19	212.68	-14.65
shared	NETWORK BUFFER	43.75	45.30	3.55
shared	PCursor	112.40	94.44	-15.97
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	305.39	525.40	72.04
shared	kglsim object batch	31.77	31.78	0.02
shared	library cache	108.28	95.42	-11.88
shared	sql area	994.63	848.97	-14.64
	buffer_cache	4,544.00	4,544.00	0.00
	fixed_sga	1.99	1.99	0.00
	log_buffer	14.01	14.01	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

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

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
max_shared_servers	50	50	50	50

init.ora Parameters

Parameter Name	Begin value	End value (if different)
aq_tm_processes	0
audit_file_dest	D:\ORACLE\PRODUCT\10.2.0\ADMIN\BSRUN\ADUMP
background_dump_dest	D:\ORACLE\PRODUCT\10.2.0\ADMIN\BSRUN\BDUMP
compatible	10.2.0.1.0
control_files	Z:\ORADATA\BSRUN\CONTROL01.CTL, Z:\ORADATA\BSRUN\CONTROL02.CTL, Z:\ORADATA\BSRUN\CONTROL03.CTL
core_dump_dest	D:\ORACLE\PRODUCT\10.2.0\ADMIN\BSRUN\CDUMP
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	bsrun
db_recovery_file_dest	d:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size	2147483648
ddl_wait_for_locks	TRUE
dispatchers	(PROTOCOL=TCP) (SERVICE=bsrun)(DISP=40)
dml_locks	100000
job_queue_processes	10
log_archive_dest_1	location=e:\archivelog
max_dispatchers	50
max_shared_servers	50
open_cursors	300
pga_aggregate_target	3145728000
processes	2000
remote_login_passwordfile	EXCLUSIVE
resource_manager_plan
sessions	2205
sga_max_size	7348420608
sga_target	7348420608
shared_servers	50
undo_management	AUTO
undo_retention	900
undo_tablespace	UNDOTBS1
user_dump_dest	D:\ORACLE\PRODUCT\10.2.0\ADMIN\BSRUN\UDUMP

End of Report

% Blocks changed per Read:	0.14	Recursive Call %:	15.72
Rollback per transaction %:	1.30	Rows per Sort:	251.67

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	98.75	Soft Parse %:	99.24
Execute to Parse %:	-1.05	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	98.33	% Non-Parse CPU:	98.74