WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
HIS	3296958993	his	1	10.2.0.4.0	NO	FCJ

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2614	21-6月 -12 16:00:32	42	12.4
End Snap:	2615	21-6月 -12 17:00:11	41	11.0
Elapsed:		59.65 (mins)
DB Time:		3.51 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	396M	396M	Std Block Size:	8K
Shared Pool Size:	608M	608M	Log Buffer:	6,920K

Load Profile

	Per Second	Per Transaction
Redo size:	3,910.03	19,276.51
Logical reads:	962.15	4,743.41
Block changes:	22.75	112.18
Physical reads:	85.04	419.25
Physical writes:	83.23	410.35
User calls:	18.74	92.41
Parses:	5.96	29.40
Hard parses:	1.10	5.40
Sorts:	3.52	17.37
Logons:	0.02	0.10
Executes:	9.71	47.87
Transactions:	0.20

% Blocks changed per Read:	2.36	Recursive Call %:	66.52
Rollback per transaction %:	0.28	Rows per Sort:	171.15

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	99.99
Buffer Hit %:	100.24	In-memory Sort %:	100.00
Library Hit %:	86.14	Soft Parse %:	81.64
Execute to Parse %:	38.58	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	99.20	% Non-Parse CPU:	64.67

Shared Pool Statistics

	Begin	End
Memory Usage %:	84.29	90.49
% SQL with executions>1:	77.48	75.09
% Memory for SQL w/exec>1:	74.04	72.13

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		94		44.9
direct path write temp	12,733	75	6	35.5	User I/O
direct path read temp	12,735	33	3	15.5	User I/O
control file parallel write	1,246	16	13	7.4	System I/O
log file parallel write	1,056	9	8	4.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

Wait Events Statistics

• Time Model Statistics
• Wait Class
• Wait Events
• Background Wait Events
• Operating System Statistics
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 210.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

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

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)

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in centisecond (100th of a second)

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

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

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: 3,443,713
• Captured SQL account for 58.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 304,378
• Captured SQL account for 97.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 34,756
• Captured SQL account for 20.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 21,348
• Captured SQL account for 27.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

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
07gqk7bw5zcqu	select * from (select a.work_id, a.ywh, a.ywxh, a.SQRQ, a.ywbm, a.ywmc, a.xlmc, b.act_id, b.act_name, b.workorder, b.staff_id, b.YJWCRQ, e.xh, f.ADDFW, f.CANTJ, a.ISBACK, decode(a.BACKTIMES, 0, '', a.BACKTIMES) BACKTIMES, b.FLAGOFACTION, a.GRQZBJ, b.PREFLAGOFACTION, a.PLID, b.ACCEPT_TIME , d.fwzl, b.actionidea, tt.sqrxm sqr, d.syqzh, tt.slr, to_char(tt.dtslrq, 'YYYY-MM-DD') dtslrq, GetLastHJTJR(a.ywh) SHJTJR, GetLastHJTJSJ(a.ywh) SHJTJSJ from gzlr_ywsq a join gzlr_to_do b on a.ywh=b.ywh and a.ywxh=b.ywxh join gzl_work e on a.work_id=e.work_id join gzl_ywxl f on a.ywbm=f.ywbm and a.xlbm=f.xlbm join yw_ywfwsx d on d.ywh=a.ywh and d.ywxh=a.ywxh join yw_ywsq tt on tt.ywh=a.ywh where (b.staff_id=385 or (b.duty_id in (select duty_id from view_duty_staff where staff_id=385) and b.staff_id is null)) and a.wcbs='N' union select a.work_id, a.ywh, a.ywxh, a.SQRQ, a.ywbm, a.ywmc, a.xlmc, b.act_id, b.act_name, b.workorder, b.staff_id, b.YJWCRQ, e.xh, f.ADDFW, f.CANTJ, a.ISBACK, decode(a.BACKTIMES, 0, '', a.BACKTIMES) BACKTIMES, b.FLAGOFACTION, a.GRQZBJ, b.PREFLAGOFACTION, a.PLID, b.ACCEPT_TIME , d.fwzl, b.actionidea, tt.sqrxm sqr, d.syqzh, tt.slr, to_char(tt.dtslrq, 'YYYY-MM-DD') dtslrq, GetLastHJTJR(a.ywh) SHJTJR, GetLastHJTJSJ(a.ywh) SHJTJSJ from gzlr_ywsq a join gzlr_to_do b on a.ywh=b.ywh and a.ywxh=b.ywxh join gzl_work e on a.work_id=e.work_id join gzl_ywxl f on a.ywbm=f.ywbm and a.xlbm=f.xlbm join yw_ywfwsx d on d.ywh=a.ywh and d.ywxh=a.ywxh join yw_ywsq tt on tt .ywh=a.ywh where (exists (select FROMSTAFF_ID from GZL_YW_AUTHORIZATION where TOSTAFF_ID=385 and CALLBACKTIME is null and fromstaff_id=b.staff_id and ywbm=a.ywbm and xlbm=a.xlbm) or (exists (select duty_id from view_duty_staff vstaff where exists (select FROMSTAFF_ID from GZL_YW_AUTHORIZATION where TOSTAFF_ID=385 and CALLBACKTIME is null and vstaff.staff_id=FROMSTAFF_ID and ywbm=a.ywbm and xlbm=a.xlbm) and b.duty_id=vstaff.duty_id )) and b.staff_id is null ) and a.wcbs='N' ) t1 order by t1.yjwcrq asc, t1.GRQZBJ desc, t1.YWH desc
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0n1xb03wsw5f1	select * from (select a.work_id, a.ywh, a.ywxh, a.SQRQ, a.ywbm, a.ywmc, a.xlmc, b.act_id, b.act_name, b.workorder, b.staff_id, b.YJWCRQ, e.xh, f.ADDFW, f.CANTJ, a.ISBACK, decode(a.BACKTIMES, 0, '', a.BACKTIMES) BACKTIMES, b.FLAGOFACTION, a.GRQZBJ, b.PREFLAGOFACTION, a.PLID, b.ACCEPT_TIME , d.fwzl, b.actionidea, tt.sqrxm sqr, d.syqzh, tt.slr, to_char(tt.dtslrq, 'YYYY-MM-DD') dtslrq, GetLastHJTJR(a.ywh) SHJTJR, GetLastHJTJSJ(a.ywh) SHJTJSJ from gzlr_ywsq a join gzlr_to_do b on a.ywh=b.ywh and a.ywxh=b.ywxh join gzl_work e on a.work_id=e.work_id join gzl_ywxl f on a.ywbm=f.ywbm and a.xlbm=f.xlbm join yw_ywfwsx d on d.ywh=a.ywh and d.ywxh=a.ywxh join yw_ywsq tt on tt.ywh=a.ywh where (b.staff_id=411 or (b.duty_id in (select duty_id from view_duty_staff where staff_id=411) and b.staff_id is null)) and a.wcbs='N' union select a.work_id, a.ywh, a.ywxh, a.SQRQ, a.ywbm, a.ywmc, a.xlmc, b.act_id, b.act_name, b.workorder, b.staff_id, b.YJWCRQ, e.xh, f.ADDFW, f.CANTJ, a.ISBACK, decode(a.BACKTIMES, 0, '', a.BACKTIMES) BACKTIMES, b.FLAGOFACTION, a.GRQZBJ, b.PREFLAGOFACTION, a.PLID, b.ACCEPT_TIME , d.fwzl, b.actionidea, tt.sqrxm sqr, d.syqzh, tt.slr, to_char(tt.dtslrq, 'YYYY-MM-DD') dtslrq, GetLastHJTJR(a.ywh) SHJTJR, GetLastHJTJSJ(a.ywh) SHJTJSJ from gzlr_ywsq a join gzlr_to_do b on a.ywh=b.ywh and a.ywxh=b.ywxh join gzl_work e on a.work_id=e.work_id join gzl_ywxl f on a.ywbm=f.ywbm and a.xlbm=f.xlbm join yw_ywfwsx d on d.ywh=a.ywh and d.ywxh=a.ywxh join yw_ywsq tt on tt .ywh=a.ywh where (exists (select FROMSTAFF_ID from GZL_YW_AUTHORIZATION where TOSTAFF_ID=411 and CALLBACKTIME is null and fromstaff_id=b.staff_id and ywbm=a.ywbm and xlbm=a.xlbm) or (exists (select duty_id from view_duty_staff vstaff where exists (select FROMSTAFF_ID from GZL_YW_AUTHORIZATION where TOSTAFF_ID=411 and CALLBACKTIME is null and vstaff.staff_id=FROMSTAFF_ID and ywbm=a.ywbm and xlbm=a.xlbm) and b.duty_id=vstaff.duty_id )) and b.staff_id is null ) and a.wcbs='N' ) t1 order by t1.yjwcrq asc, t1.GRQZBJ desc, t1.YWH desc
0tzhmcac6cd24	Select fwid, zhtai from view_gzlr_FWZT2 where FWID in ('C13154702941010', 'C13154702941011', 'C13154702941012', 'C13154702941013', 'C13154702941014', 'C13154702941015', 'C13154702941016', 'C13154702941017', 'C13154702941018', 'C13154702941019', 'C13154702941020', 'C13154702941021', 'C13154702941022', 'C13154702941023', 'C13154702941024', 'C13154702941025', 'C13154702941026', 'C13154702941027', 'C13154702941028', 'C13154702941029', 'C13154702941030', 'C13154702941031', 'C13154702941032', 'C13154702941033', 'C13154702941034', 'C13154702941035', 'C13154702941036', 'C13154702941037', 'C13154702941038', 'C13154702941039', 'C13154702941040', 'C13154702941041', 'C13154702941042', 'C13154702941043', 'C13154702941044', 'C13154702941045', 'C13154702941046', 'C13154702941047', 'C13154702941048', 'C13154702941049', 'C13154702941050', 'C13154702941051', 'C13154702941052', 'C13154702941053', 'C13154702941054', 'C13154702941055', 'C13154702941056', 'C13154702941057', 'C13154702941058', 'C13154702941001', 'C13154702941002', 'C13154702941003', 'C13154702941004', 'C13154702941005', 'C13154702941006', 'C13154702941007', 'C13154702941008', 'C13154702941009', 'C13154702941059', 'C13154702941060', 'C13154702941061', 'C13154702941062', 'C13154702941063', 'C13154702941064', 'C13154702941065', 'C13154702941066', 'C13154702941067', 'C13154702941068', 'C13154702941069', 'C13154702941070', 'C13154702941071', 'C13154702941072', 'C13154702941073', 'C13154702941074', 'C13154702941075', 'C13154702941076', ' C13154702941077', 'C13154702941078', 'C13154702941079', 'C13154702941080', 'C13154702941081', 'C13154702941082', 'C13154702941083', 'C13154702941084', 'C13154702941085', 'C13154702941086', 'C13154702941087', 'C13154702941088', 'C13154702941089', 'C13154702941090', 'C13154702941091', 'C13154702941092', 'C13154702941093', 'C13154702941094', 'C13154702941095', 'C13154702941096', 'C13154702941097', 'C13154702941098', 'C13154702941099', 'C13154702941100', 'C13154702941101', 'C13154702941102', 'C13154702941103', 'C13154702941104', 'C13154702941105', 'C13154702941106', 'C13154702941107', 'C13154702941108', 'C13154702941109', 'C13154702941110', 'C13154702941111', 'C13154702941112', 'C13154702941113', 'C13154702941114', 'C13154702941115', 'C13154702941116', 'C13154702941117', 'C13154702941118', 'C13154702941119', 'C13154702941120', 'C13154702941121', 'C13154702941122', 'C13154702941123', 'C13154702941124', 'C13154702941125', 'C13154702941126', 'C13154702941127', 'C13154702941128', 'C13154702941129', 'C13154702941130', 'C13154702941131', 'C13154702941132', 'C13154702941133', 'C13154702941134', 'C13154702941135', 'C13154702941136', 'C13154702941137', 'C13154702941138', 'C13154702941139', 'C13154702941140', 'C13154702941141', 'C13154702941142', 'C13154702941143', 'C13154702941144', 'C13154702941145', 'C13154702941146', 'C13154702941147')
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
1gvyjzg4bbpq1	select * from (select a.work_id, a.ywh, a.ywxh, a.SQRQ, a.ywbm, a.ywmc, a.xlmc, b.act_id, b.act_name, b.workorder, b.staff_id, b.YJWCRQ, e.xh, f.ADDFW, f.CANTJ, a.ISBACK, decode(a.BACKTIMES, 0, '', a.BACKTIMES) BACKTIMES, b.FLAGOFACTION, a.GRQZBJ, b.PREFLAGOFACTION, a.PLID, b.ACCEPT_TIME , d.fwzl, b.actionidea, tt.sqrxm sqr, d.syqzh, tt.slr, to_char(tt.dtslrq, 'YYYY-MM-DD') dtslrq, GetLastHJTJR(a.ywh) SHJTJR, GetLastHJTJSJ(a.ywh) SHJTJSJ from gzlr_ywsq a join gzlr_to_do b on a.ywh=b.ywh and a.ywxh=b.ywxh join gzl_work e on a.work_id=e.work_id join gzl_ywxl f on a.ywbm=f.ywbm and a.xlbm=f.xlbm join yw_ywfwsx d on d.ywh=a.ywh and d.ywxh=a.ywxh join yw_ywsq tt on tt.ywh=a.ywh where (b.staff_id=381 or (b.duty_id in (select duty_id from view_duty_staff where staff_id=381) and b.staff_id is null)) and a.wcbs='N' union select a.work_id, a.ywh, a.ywxh, a.SQRQ, a.ywbm, a.ywmc, a.xlmc, b.act_id, b.act_name, b.workorder, b.staff_id, b.YJWCRQ, e.xh, f.ADDFW, f.CANTJ, a.ISBACK, decode(a.BACKTIMES, 0, '', a.BACKTIMES) BACKTIMES, b.FLAGOFACTION, a.GRQZBJ, b.PREFLAGOFACTION, a.PLID, b.ACCEPT_TIME , d.fwzl, b.actionidea, tt.sqrxm sqr, d.syqzh, tt.slr, to_char(tt.dtslrq, 'YYYY-MM-DD') dtslrq, GetLastHJTJR(a.ywh) SHJTJR, GetLastHJTJSJ(a.ywh) SHJTJSJ from gzlr_ywsq a join gzlr_to_do b on a.ywh=b.ywh and a.ywxh=b.ywxh join gzl_work e on a.work_id=e.work_id join gzl_ywxl f on a.ywbm=f.ywbm and a.xlbm=f.xlbm join yw_ywfwsx d on d.ywh=a.ywh and d.ywxh=a.ywxh join yw_ywsq tt on tt .ywh=a.ywh where (exists (select FROMSTAFF_ID from GZL_YW_AUTHORIZATION where TOSTAFF_ID=381 and CALLBACKTIME is null and fromstaff_id=b.staff_id and ywbm=a.ywbm and xlbm=a.xlbm) or (exists (select duty_id from view_duty_staff vstaff where exists (select FROMSTAFF_ID from GZL_YW_AUTHORIZATION where TOSTAFF_ID=381 and CALLBACKTIME is null and vstaff.staff_id=FROMSTAFF_ID and ywbm=a.ywbm and xlbm=a.xlbm) and b.duty_id=vstaff.duty_id )) and b.staff_id is null ) and a.wcbs='N' ) t1 order by t1.yjwcrq asc, t1.GRQZBJ desc, t1.YWH desc
1u4umara1khss	Select fwid, zhtai from view_gzlr_FWZT2 where FWID in ('C13154696911047', 'C13154696911048', 'C13154696911049', 'C13154696911050', 'C13154696911051', 'C13154696911052', 'C13154696911053', 'C13154696911054', 'C13154696911055', 'C13154696911056', 'C13154696911057', 'C13154696911058', 'C13154696911059', 'C13154696911060', 'C13154696911061', 'C13154696911062', 'C13154696911063', 'C13154696911064', 'C13154696911065', 'C13154696911066', 'C13154696911067', 'C13154696911068', 'C13154696911069', 'C13154696911070', 'C13154696911071', 'C13154696911072', 'C13154696911073', 'C13154696911074', 'C13154696911075', 'C13154696911076', 'C13154696911077', 'C13154696911078', 'C13154696911079', 'C13154696911080', 'C13154696911081', 'C13154696911082', 'C13154696911083', 'C13154696911084', 'C13154696911085', 'C13154696911086', 'C13154696911087', 'C13154696911088', 'C13154696911089', 'C13154696911090', 'C13154696911091', 'C13154696911092', 'C13154696911093', 'C13154696911094', 'C13154696911095', 'C13154696911096', 'C13154696911097', 'C13154696911098', 'C13154696911099', 'C13154696911100', 'C13154696911101', 'C13154696911102', 'C13154696911103', 'C13154696911104', 'C13154696911105', 'C13154696911106', 'C13154696911001', 'C13154696911002', 'C13154696911003', 'C13154696911004', 'C13154696911005', 'C13154696911006', 'C13154696911007', 'C13154696911008', 'C13154696911009', 'C13154696911010', 'C13154696911011', 'C13154696911012', 'C13154696911013', 'C13154696911014', 'C13154696911015', 'C13154696911016', ' C13154696911017', 'C13154696911018', 'C13154696911019', 'C13154696911020', 'C13154696911021', 'C13154696911022', 'C13154696911023', 'C13154696911024', 'C13154696911025', 'C13154696911026', 'C13154696911027', 'C13154696911028', 'C13154696911029', 'C13154696911030', 'C13154696911031', 'C13154696911032', 'C13154696911033', 'C13154696911034', 'C13154696911035', 'C13154696911036', 'C13154696911037', 'C13154696911038', 'C13154696911039', 'C13154696911040', 'C13154696911041', 'C13154696911042', 'C13154696911043', 'C13154696911044', 'C13154696911045', 'C13154696911046')
2athhqt2pc752	Select /*+ first_rows no_expand */ fwid, zhtai from view_gzlr_FWZT2 where fwid in('C13171954081129', 'C13171954081130', 'C13171954081131', 'C13171954081132', 'C13171954081133', 'C13171954081134', 'C13171954081135', 'C13171954081136', 'C13171954081137', 'C13171954081138', 'C13171954081139', 'C13171954081140', 'C13171954081141', 'C13171954081142', 'C13171954081143', 'C13171954081144', 'C13171954081145', 'C13171954081146', 'C13171954081147', 'C13171954081148', 'C13171954081149', 'C13171954081150', 'C13171954081151', 'C13171954081152', 'C13171954081153', 'C13171954081154', 'C13171954081155', 'C13171954081156', 'C13171954081157', 'C13171954081158', 'C13171954081159', 'C13171954081160', 'C13171954081161', 'C13171954081162', 'C13171954081163', 'C13171954081164', 'C13171954081165', 'C13171954081166', 'C13171954081167', 'C13171954081168', 'C13171954081169', 'C13171954081170', 'C13171954081171', 'C13171954081172', 'C13171954081173', 'C13171954081084', 'C13171954081085', 'C13171954081086', 'C13171954081087', 'C13171954081088', 'C13171954081089', 'C13171954081090', 'C13171954081091', 'C13171954081092', 'C13171954081093', 'C13171954081094', 'C13171954081095', 'C13171954081096', 'C13171954081097', 'C13171954081098', 'C13171954081099', 'C13171954081100', 'C13171954081101', 'C13171954081102', 'C13171954081103', 'C13171954081104', 'C13171954081105', 'C13171954081106', 'C13171954081107', 'C13171954081108', 'C13171954081109', 'C13171954081110', 'C13171954081111', 'C13171954081112', 'C1317195408 1113', 'C13171954081114', 'C13171954081115', 'C13171954081116', 'C13171954081117', 'C13171954081118', 'C13171954081119', 'C13171954081120', 'C13171954081121', 'C13171954081122', 'C13171954081123', 'C13171954081124', 'C13171954081125', 'C13171954081126', 'C13171954081127', 'C13171954081128', 'C13171954081219', 'C13171954081220', 'C13171954081221', 'C13171954081222', 'C13171954081223', 'C13171954081224', 'C13171954081225', 'C13171954081226', 'C13171954081227', 'C13171954081228', 'C13171954081229', 'C13171954081230', 'C13171954081231', 'C13171954081232', 'C13171954081233', 'C13171954081234', 'C13171954081235', 'C13171954081236', 'C13171954081237', 'C13171954081238', 'C13171954081239', 'C13171954081240', 'C13171954081241', 'C13171954081242', 'C13171954081243', 'C13171954081244', 'C13171954081245', 'C13171954081246', 'C13171954081247', 'C13171954081248', 'C13171954081249', 'C13171954081250', 'C13171954081251', 'C13171954081252', 'C13171954081253', 'C13171954081254', 'C13171954081255', 'C13171954081256', 'C13171954081257', 'C13171954081258', 'C13171954081259', 'C13171954081260', 'C13171954081261', 'C13171954081262', 'C13171954081263', 'C13171954081174', 'C13171954081175', 'C13171954081176', 'C13171954081177', 'C13171954081178', 'C13171954081179', 'C13171954081180', 'C13171954081181', 'C13171954081182', 'C13171954081183', 'C13171954081184', 'C13171954081185', 'C13171954081186', 'C13171954081187', 'C13171954081188', 'C13171954081189', 'C13171954081190', 'C13171954081191', 'C131719540 81192', 'C13171954081193', 'C13171954081194', 'C13171954081195', 'C13171954081196', 'C13171954081197', 'C13171954081198', 'C13171954081199', 'C13171954081200', 'C13171954081201', 'C13171954081202', 'C13171954081203', 'C13171954081204', 'C13171954081205', 'C13171954081206', 'C13171954081207', 'C13171954081208', 'C13171954081209', 'C13171954081264', 'C13171954081210', 'C13171954081211', 'C13171954081212', 'C13171954081213', 'C13171954081214', 'C13171954081215', 'C13171954081216', 'C13171954081217', 'C13171954081218', 'C13171954081265', 'C13171954081266', 'C13171954081267', 'C13171954081268', 'C13171954081269', 'C13171954081270', 'C13171954081271', 'C13171954081272', 'C13171954081273', 'C13171954081274', 'C13171954081275', 'C13171954081276', 'C13171954081040', 'C13171954081041', 'C13171954081042', 'C13171954081043', 'C13171954081044', 'C13171954081045', 'C13171954081046', 'C13171954081047', 'C13171954081048', 'C13171954081049', 'C13171954081050', 'C13171954081051', 'C13171954081052', 'C13171954081053', 'C13171954081054', 'C13171954081055', 'C13171954081056', 'C13171954081057', 'C13171954081058', 'C13171954081059', 'C13171954081060', 'C13171954081061', 'C13171954081062', 'C13171954081063', 'C13171954081064', 'C13171954081065', 'C13171954081066', 'C13171954081067', 'C13171954081068', 'C13171954081069', 'C13171954081070', 'C13171954081071', 'C13171954081072', 'C13171954081073', 'C13171954081074', 'C13171954081075', 'C13171954081076', 'C13171954081077', 'C13171954081078', 'C13171954 081079', 'C13171954081080', 'C13171954081081', 'C13171954081082', 'C13171954081083', 'C13171954081039', 'C13171954081001', 'C13171954081002', 'C13171954081003', 'C13171954081004', 'C13171954081005', 'C13171954081006', 'C13171954081007', 'C13171954081008', 'C13171954081009', 'C13171954081010', 'C13171954081011', 'C13171954081012', 'C13171954081013', 'C13171954081014', 'C13171954081015', 'C13171954081016', 'C13171954081017', 'C13171954081018', 'C13171954081019', 'C13171954081020', 'C13171954081021', 'C13171954081022', 'C13171954081023', 'C13171954081024', 'C13171954081025', 'C13171954081026', 'C13171954081027', 'C13171954081028', 'C13171954081029', 'C13171954081030', 'C13171954081031', 'C13171954081032', 'C13171954081033', 'C13171954081034', 'C13171954081035', 'C13171954081036', 'C13171954081037', 'C13171954081038')
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3shzn6f86jbkw	explain plan set statement_id = 'CZHIS' for Select /*+ no_expand */ fwid, zhtai from view_gzlr_FWZT2 where fwid in('C13171954081129', 'C13171954081130', 'C13171954081131', 'C13171954081132', 'C13171954081133', 'C13171954081134', 'C13171954081135', 'C13171954081136', 'C13171954081137', 'C13171954081138', 'C13171954081139', 'C13171954081140', 'C13171954081141', 'C13171954081142', 'C13171954081143', 'C13171954081144', 'C13171954081145', 'C13171954081146', 'C13171954081147', 'C13171954081148', 'C13171954081149', 'C13171954081150', 'C13171954081151', 'C13171954081152', 'C13171954081153', 'C13171954081154', 'C13171954081155', 'C13171954081156', 'C13171954081157', 'C13171954081158', 'C13171954081159', 'C13171954081160', 'C13171954081161', 'C13171954081162', 'C13171954081163', 'C13171954081164', 'C13171954081165', 'C13171954081166', 'C13171954081167', 'C13171954081168', 'C13171954081169', 'C13171954081170', 'C13171954081171', 'C13171954081172', 'C13171954081173', 'C13171954081084', 'C13171954081085', 'C13171954081086', 'C13171954081087', 'C13171954081088', 'C13171954081089', 'C13171954081090', 'C13171954081091', 'C13171954081092', 'C13171954081093', 'C13171954081094', 'C13171954081095', 'C13171954081096', 'C13171954081097', 'C13171954081098', 'C13171954081099', 'C13171954081100', 'C13171954081101', 'C13171954081102', 'C13171954081103', 'C13171954081104', 'C13171954081105', 'C13171954081106', 'C13171954081107', 'C13171954081108', 'C13171954081109', 'C13171954081110', 'C13171954081111 ', 'C13171954081112', 'C13171954081113', 'C13171954081114', 'C13171954081115', 'C13171954081116', 'C13171954081117', 'C13171954081118', 'C13171954081119', 'C13171954081120', 'C13171954081121', 'C13171954081122', 'C13171954081123', 'C13171954081124', 'C13171954081125', 'C13171954081126', 'C13171954081127', 'C13171954081128', 'C13171954081219', 'C13171954081220', 'C13171954081221', 'C13171954081222', 'C13171954081223', 'C13171954081224', 'C13171954081225', 'C13171954081226', 'C13171954081227', 'C13171954081228', 'C13171954081229', 'C13171954081230', 'C13171954081231', 'C13171954081232', 'C13171954081233', 'C13171954081234', 'C13171954081235', 'C13171954081236', 'C13171954081237', 'C13171954081238', 'C13171954081239', 'C13171954081240', 'C13171954081241', 'C13171954081242', 'C13171954081243', 'C13171954081244', 'C13171954081245', 'C13171954081246', 'C13171954081247', 'C13171954081248', 'C13171954081249', 'C13171954081250', 'C13171954081251', 'C13171954081252', 'C13171954081253', 'C13171954081254', 'C13171954081255', 'C13171954081256', 'C13171954081257', 'C13171954081258', 'C13171954081259', 'C13171954081260', 'C13171954081261', 'C13171954081262', 'C13171954081263', 'C13171954081174', 'C13171954081175', 'C13171954081176', 'C13171954081177', 'C13171954081178', 'C13171954081179', 'C13171954081180', 'C13171954081181', 'C13171954081182', 'C13171954081183', 'C13171954081184', 'C13171954081185', 'C13171954081186', 'C13171954081187', 'C13171954081188', 'C13171954081189', 'C1317195408119 0', 'C13171954081191', 'C13171954081192', 'C13171954081193', 'C13171954081194', 'C13171954081195', 'C13171954081196', 'C13171954081197', 'C13171954081198', 'C13171954081199', 'C13171954081200', 'C13171954081201', 'C13171954081202', 'C13171954081203', 'C13171954081204', 'C13171954081205', 'C13171954081206', 'C13171954081207', 'C13171954081208', 'C13171954081209', 'C13171954081264', 'C13171954081210', 'C13171954081211', 'C13171954081212', 'C13171954081213', 'C13171954081214', 'C13171954081215', 'C13171954081216', 'C13171954081217', 'C13171954081218', 'C13171954081265', 'C13171954081266', 'C13171954081267', 'C13171954081268', 'C13171954081269', 'C13171954081270', 'C13171954081271', 'C13171954081272', 'C13171954081273', 'C13171954081274', 'C13171954081275', 'C13171954081276', 'C13171954081040', 'C13171954081041', 'C13171954081042', 'C13171954081043', 'C13171954081044', 'C13171954081045', 'C13171954081046', 'C13171954081047', 'C13171954081048', 'C13171954081049', 'C13171954081050', 'C13171954081051', 'C13171954081052', 'C13171954081053', 'C13171954081054', 'C13171954081055', 'C13171954081056', 'C13171954081057', 'C13171954081058', 'C13171954081059', 'C13171954081060', 'C13171954081061', 'C13171954081062', 'C13171954081063', 'C13171954081064', 'C13171954081065', 'C13171954081066', 'C13171954081067', 'C13171954081068', 'C13171954081069', 'C13171954081070', 'C13171954081071', 'C13171954081072', 'C13171954081073', 'C13171954081074', 'C13171954081075', 'C13171954081076', 'C131719540810 77', 'C13171954081078', 'C13171954081079', 'C13171954081080', 'C13171954081081', 'C13171954081082', 'C13171954081083', 'C13171954081039', 'C13171954081001', 'C13171954081002', 'C13171954081003', 'C13171954081004', 'C13171954081005', 'C13171954081006', 'C13171954081007', 'C13171954081008', 'C13171954081009', 'C13171954081010', 'C13171954081011', 'C13171954081012', 'C13171954081013', 'C13171954081014', 'C13171954081015', 'C13171954081016', 'C13171954081017', 'C13171954081018', 'C13171954081019', 'C13171954081020', 'C13171954081021', 'C13171954081022', 'C13171954081023', 'C13171954081024', 'C13171954081025', 'C13171954081026', 'C13171954081027', 'C13171954081028', 'C13171954081029', 'C13171954081030', 'C13171954081031', 'C13171954081032', 'C13171954081033', 'C13171954081034', 'C13171954081035', 'C13171954081036', 'C13171954081037', 'C13171954081038')
44mwxbkuxcrsa	SELECT /*+rule*/ S.TABLE_OWNER, S.TABLE_NAME FROM ALL_SYNONYMS S WHERE S.SYNONYM_NAME = :B1 AND S.OWNER = 'PUBLIC' AND ROWNUM = 1
49m5w68g9dcbu	select * from (select a.work_id, a.ywh, a.ywxh, a.SQRQ, a.ywbm, a.ywmc, a.xlmc, b.act_id, b.act_name, b.workorder, b.staff_id, b.YJWCRQ, e.xh, f.ADDFW, f.CANTJ, a.ISBACK, decode(a.BACKTIMES, 0, '', a.BACKTIMES) BACKTIMES, b.FLAGOFACTION, a.GRQZBJ, b.PREFLAGOFACTION, a.PLID, b.ACCEPT_TIME , d.fwzl, b.actionidea, tt.sqrxm sqr, d.syqzh, tt.slr, to_char(tt.dtslrq, 'YYYY-MM-DD') dtslrq, GetLastHJTJR(a.ywh) SHJTJR, GetLastHJTJSJ(a.ywh) SHJTJSJ from gzlr_ywsq a join gzlr_to_do b on a.ywh=b.ywh and a.ywxh=b.ywxh join gzl_work e on a.work_id=e.work_id join gzl_ywxl f on a.ywbm=f.ywbm and a.xlbm=f.xlbm join yw_ywfwsx d on d.ywh=a.ywh and d.ywxh=a.ywxh join yw_ywsq tt on tt.ywh=a.ywh where (b.staff_id=380 or (b.duty_id in (select duty_id from view_duty_staff where staff_id=380) and b.staff_id is null)) and a.wcbs='N' union select a.work_id, a.ywh, a.ywxh, a.SQRQ, a.ywbm, a.ywmc, a.xlmc, b.act_id, b.act_name, b.workorder, b.staff_id, b.YJWCRQ, e.xh, f.ADDFW, f.CANTJ, a.ISBACK, decode(a.BACKTIMES, 0, '', a.BACKTIMES) BACKTIMES, b.FLAGOFACTION, a.GRQZBJ, b.PREFLAGOFACTION, a.PLID, b.ACCEPT_TIME , d.fwzl, b.actionidea, tt.sqrxm sqr, d.syqzh, tt.slr, to_char(tt.dtslrq, 'YYYY-MM-DD') dtslrq, GetLastHJTJR(a.ywh) SHJTJR, GetLastHJTJSJ(a.ywh) SHJTJSJ from gzlr_ywsq a join gzlr_to_do b on a.ywh=b.ywh and a.ywxh=b.ywxh join gzl_work e on a.work_id=e.work_id join gzl_ywxl f on a.ywbm=f.ywbm and a.xlbm=f.xlbm join yw_ywfwsx d on d.ywh=a.ywh and d.ywxh=a.ywxh join yw_ywsq tt on tt .ywh=a.ywh where (exists (select FROMSTAFF_ID from GZL_YW_AUTHORIZATION where TOSTAFF_ID=380 and CALLBACKTIME is null and fromstaff_id=b.staff_id and ywbm=a.ywbm and xlbm=a.xlbm) or (exists (select duty_id from view_duty_staff vstaff where exists (select FROMSTAFF_ID from GZL_YW_AUTHORIZATION where TOSTAFF_ID=380 and CALLBACKTIME is null and vstaff.staff_id=FROMSTAFF_ID and ywbm=a.ywbm and xlbm=a.xlbm) and b.duty_id=vstaff.duty_id )) and b.staff_id is null ) and a.wcbs='N' ) t1 order by t1.yjwcrq asc, t1.GRQZBJ desc, t1.YWH desc
572fbaj0fdw2b	select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
8kksyark4pdwg	Select fwid, zhtai from view_gzlr_FWZT2 where FWID in ('C12637778471001', 'C12637778471002', 'C12637778471003', 'C12637778471004', 'C12637778471005', 'C12637778471006', 'C12637778471007', 'C12637778471008', 'C12637778471009', 'C12637778471010', 'C12637778471011', 'C12637778471012', 'C12637778471013', 'C12637778471014', 'C12637778471015', 'C12637778471016', 'C12637778471017', 'C12637778471018', 'C12637778471019', 'C12637778471020', 'C12637778471021', 'C12637778471022', 'C12637778471540', 'C12637778471541', 'C12637778471542', 'C12637778471543', 'C12637778471544', 'C12637778471545', 'C12637778471546', 'C12637778471547', 'C12637778471548', 'C12637778471549', 'C12637778471550', 'C12637778471551', 'C12637778471552', 'C12637778471553', 'C12637778471554', 'C12637778471555', 'C12637778471556', 'C12637778471557', 'C12637778471558', 'C12637778471559', 'C12637778471560', 'C12637778471561', 'C12637778471562', 'C12637778471563', 'C12637778471564', 'C12637778471565', 'C12637778471566', 'C12637778471567', 'C12637778471568', 'C12637778471569', 'C12637778471570', 'C12637778471571', 'C12637778471572', 'C12637778471573', 'C12637778471574', 'C12637778471575', 'C12637778471576', 'C12637778471577', 'C12637778471578', 'C12637778471579', 'C12637778471023', 'C12637778471024', 'C12637778471025', 'C12637778471026', 'C12637778471027', 'C12637778471028', 'C12637778471029', 'C12637778471030', 'C12637778471031', 'C12637778471032', 'C12637778471033', 'C12637778471034', 'C12637778471035', 'C12637778471036', ' C12637778471037', 'C12637778471038', 'C12637778471039', 'C12637778471040', 'C12637778471041', 'C12637778471042', 'C12637778471043', 'C12637778471044', 'C12637778471045', 'C12637778471046', 'C12637778471047', 'C12637778471245', 'C12637778471246', 'C12637778471247', 'C12637778471248', 'C12637778471249', 'C12637778471250', 'C12637778471251', 'C12637778471252', 'C12637778471253', 'C12637778471254', 'C12637778471255', 'C12637778471256', 'C12637778471257', 'C12637778471258', 'C12637778471259', 'C12637778471260', 'C12637778471261', 'C12637778471262', 'C12637778471263', 'C12637778471264', 'C12637778471265', 'C12637778471266', 'C12637778471267', 'C12637778471268', 'C12637778471269', 'C12637778471270', 'C12637778471580', 'C12637778471581', 'C12637778471582', 'C12637778471596', 'C12637778471597', 'C12637778471598', 'C12637778471599', 'C12637778471600', 'C12637778471601', 'C12637778471603', 'C12637778471604', 'C12637778471605', 'C12637778471606', 'C12637778471607', 'C12637778471608', 'C12637778471609', 'C12637778471613', 'C12637778471614', 'C12637778471615', 'C12637778471616', 'C12637778471624', 'C12637778471625', 'C12637778471626', 'C12637778471627', 'C12637778471628', 'C12637778471629', 'C12637778471630', 'C12637778471631', 'C12637778471632', 'C12637778471633', 'C12637778471634', 'C12637778471635', 'C12637778471636', 'C12637778471651', 'C12637778471652', 'C12637778471653', 'C12637778471654', 'C12637778471655', 'C12637778471656', 'C12637778471657', 'C12637778471658', 'C12637778471659', 'C12637778471676', 'C12637778471677', 'C12637778471678', 'C12637778471679', 'C12637778471680', 'C12637778471688', 'C12637778471689', 'C12637778471690', 'C12637778471691', 'C12637778471695', 'C12637778471696', 'C12637778471271', 'C12637778471272', 'C12637778471273', 'C12637778471274', 'C12637778471275', 'C12637778471276', 'C12637778471277', 'C12637778471278', 'C12637778471279', 'C12637778471280', 'C12637778471281', 'C12637778471282', 'C12637778471283', 'C12637778471284', 'C12637778471285', 'C12637778471286', 'C12637778471287', 'C12637778471288', 'C12637778471289', 'C12637778471290', 'C12637778471291', 'C12637778471292', 'C12637778471293', 'C12637778471294', 'C12637778471295', 'C12637778471296', 'C12637778471297', 'C12637778471298', 'C12637778471299', 'C12637778471300', 'C12637778471301', 'C12637778471302', 'C12637778471303', 'C12637778471304', 'C12637778471305', 'C12637778471306', 'C12637778471307', 'C12637778471308', 'C12637778471309', 'C12637778471310', 'C12637778471311', 'C12637778471312', 'C12637778471313', 'C12637778471314', 'C12637778471315', 'C12637778471316', 'C12637778471317', 'C12637778471318', 'C12637778471319', 'C12637778471320', 'C12637778471697', 'C12637778471698', 'C12637778471699', 'C12637778471700', 'C12637778471701', 'C12637778471702', 'C12637778471703', 'C12637778471704', 'C12637778471705', 'C12637778471706', 'C12637778471924', 'C12637778471925', 'C12637778471926', 'C12637778471927', 'C12637778471928', 'C12637778471929', 'C12637778471930', 'C12637778471931', 'C12637778471321', 'C12637778471322', 'C12637778471323', 'C12637778471324', 'C12637778471325', 'C12637778471326', 'C12637778471327', 'C12637778471328', 'C12637778471329', 'C12637778471330', 'C12637778471331', 'C12637778471332', 'C12637778471333', 'C12637778471334', 'C12637778471335', 'C12637778471336', 'C12637778471337', 'C12637778471338', 'C12637778471339', 'C12637778471340', 'C12637778471341', 'C12637778471342', 'C12637778471441', 'C12637778471442', 'C12637778471443', 'C12637778471444', 'C12637778471445', 'C12637778471446', 'C12637778471447', 'C12637778471448', 'C12637778471449', 'C12637778471450', 'C12637778471451', 'C12637778471452', 'C12637778471453', 'C12637778471454', 'C12637778471455', 'C12637778471456', 'C12637778471457', 'C12637778471458', 'C12637778471459', 'C12637778471460', 'C12637778471461', 'C12637778471462', 'C12637778471463', 'C12637778471464', 'C12637778471465', 'C12637778471466', 'C12637778471467', 'C12637778471468', 'C12637778471048', 'C12637778471049', 'C12637778471050', 'C12637778471051', 'C12637778471052', 'C12637778471053', 'C12637778471054', 'C12637778471055', 'C12637778471056', 'C12637778471057', 'C12637778471058', 'C12637778471059', 'C12637778471060', 'C12637778471061', 'C12637778471469', 'C12637778471470', 'C12637778471471', 'C12637778471472', 'C12637778471473', 'C12637778471474', 'C12637778471475', 'C12637778471476', 'C12637778471477', 'C12637778471478', 'C12637778471479', 'C12637778471480', 'C12637778471481', 'C12637778471482', 'C12637778471483' , 'C12637778471484', 'C12637778471485', 'C12637778471486', 'C12637778471487', 'C12637778471488', 'C12637778471489', 'C12637778471490', 'C12637778471491', 'C12637778471492', 'C12637778471493', 'C12637778471494', 'C12637778471495', 'C12637778471496', 'C12637778471497', 'C12637778471498', 'C12637778471499', 'C12637778471500', 'C12637778471501', 'C12637778471502', 'C12637778471503', 'C12637778471504', 'C12637778471505', 'C12637778471506', 'C12637778471507', 'C12637778471508', 'C12637778471509', 'C12637778471510', 'C12637778471511', 'C12637778471512', 'C12637778471513', 'C12637778471514', 'C12637778471515', 'C12637778471516', 'C12637778471517', 'C12637778471518', 'C12637778471519', 'C12637778471062', 'C12637778471063', 'C12637778471064', 'C12637778471065', 'C12637778471066', 'C12637778471067', 'C12637778471068', 'C12637778471069', 'C12637778471070', 'C12637778471071', 'C12637778471072', 'C12637778471073', 'C12637778471074', 'C12637778471075', 'C12637778471076', 'C12637778471077', 'C12637778471078', 'C12637778471079', 'C12637778471080', 'C12637778471081', 'C12637778471082', 'C12637778471083', 'C12637778471084', 'C12637778471085', 'C12637778471086', 'C12637778471087', 'C12637778471088', 'C12637778471089', 'C12637778471090', 'C12637778471091', 'C12637778471092', 'C12637778471093', 'C12637778471094', 'C12637778471095', 'C12637778471096', 'C12637778471097', 'C12637778471098', 'C12637778471099', 'C12637778471100', 'C12637778471101', 'C12637778471102', 'C12637778471103', 'C12637778471104 ', 'C12637778471105', 'C12637778471106', 'C12637778471107', 'C12637778471108', 'C12637778471109', 'C12637778471110', 'C12637778471111', 'C12637778471112', 'C12637778471520', 'C12637778471521', 'C12637778471522', 'C12637778471523', 'C12637778471524', 'C12637778471525', 'C12637778471526', 'C12637778471527', 'C12637778471528', 'C12637778471529', 'C12637778471530', 'C12637778471531', 'C12637778471532', 'C12637778471533', 'C12637778471534', 'C12637778471535', 'C12637778471536', 'C12637778471537', 'C12637778471538', 'C12637778471539', 'C12637778471343', 'C12637778471344', 'C12637778471345', 'C12637778471346', 'C12637778471347', 'C12637778471348', 'C12637778471349', 'C12637778471350', 'C12637778471351', 'C12637778471352', 'C12637778471353', 'C12637778471354', 'C12637778471355', 'C12637778471356', 'C12637778471357', 'C12637778471358', 'C12637778471359', 'C12637778471360', 'C12637778471361', 'C12637778471362', 'C12637778471363', 'C12637778471364', 'C12637778471365', 'C12637778471366', 'C12637778471367', 'C12637778471368', 'C12637778471369', 'C12637778471370', 'C12637778471371', 'C12637778471372', 'C12637778471373', 'C12637778471113', 'C12637778471114', 'C12637778471115', 'C12637778471116', 'C12637778471117', 'C12637778471118', 'C12637778471119', 'C12637778471120', 'C12637778471121', 'C12637778471122', 'C12637778471123', 'C12637778471124', 'C12637778471125', 'C12637778471126', 'C12637778471127', 'C12637778471128', 'C12637778471129', 'C12637778471130', 'C12637778471131', 'C1263777847113 2', 'C12637778471133', 'C12637778471134', 'C12637778471135', 'C12637778471136', 'C12637778471137', 'C12637778471138', 'C12637778471139', 'C12637778471140', 'C12637778471141', 'C12637778471142', 'C12637778471143', 'C12637778471144', 'C12637778471145', 'C12637778471146', 'C12637778471147', 'C12637778471148', 'C12637778471149', 'C12637778471150', 'C12637778471151', 'C12637778471152', 'C12637778471153', 'C12637778471154', 'C12637778471155', 'C12637778471156', 'C12637778471157', 'C12637778471158', 'C12637778471159', 'C12637778471160', 'C12637778471161', 'C12637778471162', 'C12637778471163', 'C12637778471374', 'C12637778471375', 'C12637778471376', 'C12637778471377', 'C12637778471378', 'C12637778471379', 'C12637778471380', 'C12637778471381', 'C12637778471382', 'C12637778471383', 'C12637778471384', 'C12637778471385', 'C12637778471386', 'C12637778471387', 'C12637778471388', 'C12637778471389', 'C12637778471390', 'C12637778471391', 'C12637778471392', 'C12637778471393', 'C12637778471394', 'C12637778471395', 'C12637778471396', 'C12637778471397', 'C12637778471398', 'C12637778471399', 'C12637778471400', 'C12637778471401', 'C12637778471402', 'C12637778471403', 'C12637778471404', 'C12637778471405', 'C12637778471406', 'C12637778471407', 'C12637778471408', 'C12637778471409', 'C12637778471410', 'C12637778471411', 'C12637778471412', 'C12637778471413', 'C12637778471414', 'C12637778471415', 'C12637778471416', 'C12637778471417', 'C12637778471418', 'C12637778471419', 'C12637778471420', 'C126377784714 21', 'C12637778471422', 'C12637778471423', 'C12637778471164', 'C12637778471165', 'C12637778471166', 'C12637778471167', 'C12637778471168', 'C12637778471169', 'C12637778471170', 'C12637778471171', 'C12637778471172', 'C12637778471173', 'C12637778471174', 'C12637778471175', 'C12637778471176', 'C12637778471177', 'C12637778471178', 'C12637778471179', 'C12637778471180', 'C12637778471181', 'C12637778471182', 'C12637778471183', 'C12637778471184', 'C12637778471185', 'C12637778471186', 'C12637778471187', 'C12637778471188', 'C12637778471189', 'C12637778471190', 'C12637778471191', 'C12637778471192', 'C12637778471193', 'C12637778471194', 'C12637778471195', 'C12637778471424', 'C12637778471425', 'C12637778471426', 'C12637778471427', 'C12637778471428', 'C12637778471429', 'C12637778471430', 'C12637778471431', 'C12637778471432', 'C12637778471433', 'C12637778471434', 'C12637778471435', 'C12637778471436', 'C12637778471437', 'C12637778471438', 'C12637778471439', 'C12637778471440', 'C12637778471196', 'C12637778471197', 'C12637778471198', 'C12637778471199', 'C12637778471200', 'C12637778471201', 'C12637778471202', 'C12637778471203', 'C12637778471204', 'C12637778471205', 'C12637778471206', 'C12637778471207', 'C12637778471208', 'C12637778471209', 'C12637778471210', 'C12637778471211', 'C12637778471212', 'C12637778471213', 'C12637778471214', 'C12637778471215', 'C12637778471216', 'C12637778471217', 'C12637778471218', 'C12637778471219', 'C12637778471220', 'C12637778471221', 'C12637778471222', 'C12637778471 223', 'C12637778471224', 'C12637778471225', 'C12637778471226', 'C12637778471227', 'C12637778471228', 'C12637778471229', 'C12637778471230', 'C12637778471231', 'C12637778471232', 'C12637778471233', 'C12637778471234', 'C12637778471235', 'C12637778471236', 'C12637778471237', 'C12637778471238', 'C12637778471239', 'C12637778471240', 'C12637778471241', 'C12637778471242', 'C12637778471243', 'C12637778471244', 'C13008448531643', 'C13008448531644', 'C13008448531645', 'C13008448531654', 'C13008448531655', 'C13008448531656', 'C13008448531657', 'C13008448531658', 'C13008448531659', 'C13008448531660', 'C13008448531661', 'C13008448531662', 'C13008448531663', 'C13008448531664', 'C13008448531665', 'C13008448531666', 'C13008448531667', 'C13008448531668', 'C13008448531669', 'C13008448531670', 'C13008448531671', 'C13008448531672', 'C13008448531673', 'C13008448531674', 'C13008448531675', 'C13008448531676', 'C13008448531677', 'C13008448531678')
999mpzqx6swwq	/*Select fwid, zhtai from view_gzlr_FWZT2 where fwid in(select fwid from table_room where buildid='ZYH000351_5')*/ Select fwid, zhtai from view_gzlr_FWZT2 where fwid in('C13171954081129', 'C13171954081130', 'C13171954081131', 'C13171954081132', 'C13171954081133', 'C13171954081134', 'C13171954081135', 'C13171954081136', 'C13171954081137', 'C13171954081138', 'C13171954081139', 'C13171954081140', 'C13171954081141', 'C13171954081142', 'C13171954081143', 'C13171954081144', 'C13171954081145', 'C13171954081146', 'C13171954081147', 'C13171954081148', 'C13171954081149', 'C13171954081150', 'C13171954081151', 'C13171954081152', 'C13171954081153', 'C13171954081154', 'C13171954081155', 'C13171954081156', 'C13171954081157', 'C13171954081158', 'C13171954081159', 'C13171954081160', 'C13171954081161', 'C13171954081162', 'C13171954081163', 'C13171954081164', 'C13171954081165', 'C13171954081166', 'C13171954081167', 'C13171954081168', 'C13171954081169', 'C13171954081170', 'C13171954081171', 'C13171954081172', 'C13171954081173', 'C13171954081084', 'C13171954081085', 'C13171954081086', 'C13171954081087', 'C13171954081088', 'C13171954081089', 'C13171954081090', 'C13171954081091', 'C13171954081092', 'C13171954081093', 'C13171954081094', 'C13171954081095', 'C13171954081096', 'C13171954081097', 'C13171954081098', 'C13171954081099', 'C13171954081100', 'C13171954081101', 'C13171954081102', 'C13171954081103', 'C13171954081104', 'C13171954081105', 'C13171954081106', 'C13171954081107', 'C13171954081108', ' C13171954081109', 'C13171954081110', 'C13171954081111', 'C13171954081112', 'C13171954081113', 'C13171954081114', 'C13171954081115', 'C13171954081116', 'C13171954081117', 'C13171954081118', 'C13171954081119', 'C13171954081120', 'C13171954081121', 'C13171954081122', 'C13171954081123', 'C13171954081124', 'C13171954081125', 'C13171954081126', 'C13171954081127', 'C13171954081128', 'C13171954081219', 'C13171954081220', 'C13171954081221', 'C13171954081222', 'C13171954081223', 'C13171954081224', 'C13171954081225', 'C13171954081226', 'C13171954081227', 'C13171954081228', 'C13171954081229', 'C13171954081230', 'C13171954081231', 'C13171954081232', 'C13171954081233', 'C13171954081234', 'C13171954081235', 'C13171954081236', 'C13171954081237', 'C13171954081238', 'C13171954081239', 'C13171954081240', 'C13171954081241', 'C13171954081242', 'C13171954081243', 'C13171954081244', 'C13171954081245', 'C13171954081246', 'C13171954081247', 'C13171954081248', 'C13171954081249', 'C13171954081250', 'C13171954081251', 'C13171954081252', 'C13171954081253', 'C13171954081254', 'C13171954081255', 'C13171954081256', 'C13171954081257', 'C13171954081258', 'C13171954081259', 'C13171954081260', 'C13171954081261', 'C13171954081262', 'C13171954081263', 'C13171954081174', 'C13171954081175', 'C13171954081176', 'C13171954081177', 'C13171954081178', 'C13171954081179', 'C13171954081180', 'C13171954081181', 'C13171954081182', 'C13171954081183', 'C13171954081184', 'C13171954081185', 'C13171954081186', 'C13171954081187', 'C13171954081188', 'C13171954081189', 'C13171954081190', 'C13171954081191', 'C13171954081192', 'C13171954081193', 'C13171954081194', 'C13171954081195', 'C13171954081196', 'C13171954081197', 'C13171954081198', 'C13171954081199', 'C13171954081200', 'C13171954081201', 'C13171954081202', 'C13171954081203', 'C13171954081204', 'C13171954081205', 'C13171954081206', 'C13171954081207', 'C13171954081208', 'C13171954081209', 'C13171954081264', 'C13171954081210', 'C13171954081211', 'C13171954081212', 'C13171954081213', 'C13171954081214', 'C13171954081215', 'C13171954081216', 'C13171954081217', 'C13171954081218', 'C13171954081265', 'C13171954081266', 'C13171954081267', 'C13171954081268', 'C13171954081269', 'C13171954081270', 'C13171954081271', 'C13171954081272', 'C13171954081273', 'C13171954081274', 'C13171954081275', 'C13171954081276', 'C13171954081040', 'C13171954081041', 'C13171954081042', 'C13171954081043', 'C13171954081044', 'C13171954081045', 'C13171954081046', 'C13171954081047', 'C13171954081048', 'C13171954081049', 'C13171954081050', 'C13171954081051', 'C13171954081052', 'C13171954081053', 'C13171954081054', 'C13171954081055', 'C13171954081056', 'C13171954081057', 'C13171954081058', 'C13171954081059', 'C13171954081060', 'C13171954081061', 'C13171954081062', 'C13171954081063', 'C13171954081064', 'C13171954081065', 'C13171954081066', 'C13171954081067', 'C13171954081068', 'C13171954081069', 'C13171954081070', 'C13171954081071', 'C13171954081072', 'C13171954081073', 'C13171954081074', 'C13171954081075', 'C13171954081076', 'C13171954081077', 'C13171954081078', 'C13171954081079', 'C13171954081080', 'C13171954081081', 'C13171954081082', 'C13171954081083', 'C13171954081039', 'C13171954081001', 'C13171954081002', 'C13171954081003', 'C13171954081004', 'C13171954081005', 'C13171954081006', 'C13171954081007', 'C13171954081008', 'C13171954081009', 'C13171954081010', 'C13171954081011', 'C13171954081012', 'C13171954081013', 'C13171954081014', 'C13171954081015', 'C13171954081016', 'C13171954081017', 'C13171954081018', 'C13171954081019', 'C13171954081020', 'C13171954081021', 'C13171954081022', 'C13171954081023', 'C13171954081024', 'C13171954081025', 'C13171954081026', 'C13171954081027', 'C13171954081028', 'C13171954081029', 'C13171954081030', 'C13171954081031', 'C13171954081032', 'C13171954081033', 'C13171954081034', 'C13171954081035', 'C13171954081036', 'C13171954081037', 'C13171954081038')
99qa3zyarxvms	insert into plan_table (statement_id, timestamp, operation, options, object_node, object_owner, object_name, object_instance, object_type, search_columns, id, parent_id, position, other, optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates, projection, time, qblock_name, object_alias, plan_id, depth, remarks, other_xml ) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
9j1511n2xqn47	select distinct ywh 受理编号, ywmc 业务名称, xlmc 小类名称, ywh ||'$'||ywxh as qryValue, syqr 产权人, zjhm 身份证号, fwzl 房屋坐落, zh 幢号, dyh 单元号, ch 层号, fah 房号, ywbz 业务标志, state 状态, ajh 案卷号, syqzh 所有权证号, xzqk 限制状态 from view_cx_xscqcx WHERE SYQR like '%韦少映%' order by ywmc, xlmc
apxprcudsg3vn	select '个人住房（商业用房）借款合同编号：'||t.dyhtbh||'；建筑面积：'||(select sum(jzmj)||'用途：'||max(yt) from yw_jb_fwxx a, gzlr_ywfw b where a.fwid=b.fwid and a.fwxh=b.fwxh and b.ywh=t.ywh)||'；房屋价值：'||t.fcjz||'元。权利价值：'||t.zqse||'元。 预告登记证明号：'||(select YGDJZMH from yw_yg_ygxx where ywh in(select distinct c.ywh from gzlr_ywfw c, gzlr_ywfw d where c.fwid=d.fwid and d.ywh=t.ywh) and rownum=1) fj from yw_tx_txdj t where ywh='201206210061'
ayx9s7kpw1zxh	select distinct '房屋坐落相似' 雷同部分, ywh 业务号, ywmc 业务类型, xlmc 业务小类, fwzl 房屋坐落, syqr 所有权人, act_name 步骤, zx 状态 from view_casecheckForFWZLProc union all select distinct '产权人相似' 雷同部分, ywh 业务号, ywmc 业务类型, xlmc 业务小类, fwzl 房屋坐落, syqr 所有权人, act_name 步骤, zx 状态 from VIEW_CASECHECKForSYQRProc where not(ywh=:YWH ) and SYQR like :SYQR
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
bj38pw9xzvncz	Select /*+ no_expand */ fwid, zhtai from view_gzlr_FWZT2 where fwid in('C13171954081129', 'C13171954081130', 'C13171954081131', 'C13171954081132', 'C13171954081133', 'C13171954081134', 'C13171954081135', 'C13171954081136', 'C13171954081137', 'C13171954081138', 'C13171954081139', 'C13171954081140', 'C13171954081141', 'C13171954081142', 'C13171954081143', 'C13171954081144', 'C13171954081145', 'C13171954081146', 'C13171954081147', 'C13171954081148', 'C13171954081149', 'C13171954081150', 'C13171954081151', 'C13171954081152', 'C13171954081153', 'C13171954081154', 'C13171954081155', 'C13171954081156', 'C13171954081157', 'C13171954081158', 'C13171954081159', 'C13171954081160', 'C13171954081161', 'C13171954081162', 'C13171954081163', 'C13171954081164', 'C13171954081165', 'C13171954081166', 'C13171954081167', 'C13171954081168', 'C13171954081169', 'C13171954081170', 'C13171954081171', 'C13171954081172', 'C13171954081173', 'C13171954081084', 'C13171954081085', 'C13171954081086', 'C13171954081087', 'C13171954081088', 'C13171954081089', 'C13171954081090', 'C13171954081091', 'C13171954081092', 'C13171954081093', 'C13171954081094', 'C13171954081095', 'C13171954081096', 'C13171954081097', 'C13171954081098', 'C13171954081099', 'C13171954081100', 'C13171954081101', 'C13171954081102', 'C13171954081103', 'C13171954081104', 'C13171954081105', 'C13171954081106', 'C13171954081107', 'C13171954081108', 'C13171954081109', 'C13171954081110', 'C13171954081111', 'C13171954081112', 'C13171954081113', 'C13 171954081114', 'C13171954081115', 'C13171954081116', 'C13171954081117', 'C13171954081118', 'C13171954081119', 'C13171954081120', 'C13171954081121', 'C13171954081122', 'C13171954081123', 'C13171954081124', 'C13171954081125', 'C13171954081126', 'C13171954081127', 'C13171954081128', 'C13171954081219', 'C13171954081220', 'C13171954081221', 'C13171954081222', 'C13171954081223', 'C13171954081224', 'C13171954081225', 'C13171954081226', 'C13171954081227', 'C13171954081228', 'C13171954081229', 'C13171954081230', 'C13171954081231', 'C13171954081232', 'C13171954081233', 'C13171954081234', 'C13171954081235', 'C13171954081236', 'C13171954081237', 'C13171954081238', 'C13171954081239', 'C13171954081240', 'C13171954081241', 'C13171954081242', 'C13171954081243', 'C13171954081244', 'C13171954081245', 'C13171954081246', 'C13171954081247', 'C13171954081248', 'C13171954081249', 'C13171954081250', 'C13171954081251', 'C13171954081252', 'C13171954081253', 'C13171954081254', 'C13171954081255', 'C13171954081256', 'C13171954081257', 'C13171954081258', 'C13171954081259', 'C13171954081260', 'C13171954081261', 'C13171954081262', 'C13171954081263', 'C13171954081174', 'C13171954081175', 'C13171954081176', 'C13171954081177', 'C13171954081178', 'C13171954081179', 'C13171954081180', 'C13171954081181', 'C13171954081182', 'C13171954081183', 'C13171954081184', 'C13171954081185', 'C13171954081186', 'C13171954081187', 'C13171954081188', 'C13171954081189', 'C13171954081190', 'C13171954081191', 'C13171954081192', 'C1 3171954081193', 'C13171954081194', 'C13171954081195', 'C13171954081196', 'C13171954081197', 'C13171954081198', 'C13171954081199', 'C13171954081200', 'C13171954081201', 'C13171954081202', 'C13171954081203', 'C13171954081204', 'C13171954081205', 'C13171954081206', 'C13171954081207', 'C13171954081208', 'C13171954081209', 'C13171954081264', 'C13171954081210', 'C13171954081211', 'C13171954081212', 'C13171954081213', 'C13171954081214', 'C13171954081215', 'C13171954081216', 'C13171954081217', 'C13171954081218', 'C13171954081265', 'C13171954081266', 'C13171954081267', 'C13171954081268', 'C13171954081269', 'C13171954081270', 'C13171954081271', 'C13171954081272', 'C13171954081273', 'C13171954081274', 'C13171954081275', 'C13171954081276', 'C13171954081040', 'C13171954081041', 'C13171954081042', 'C13171954081043', 'C13171954081044', 'C13171954081045', 'C13171954081046', 'C13171954081047', 'C13171954081048', 'C13171954081049', 'C13171954081050', 'C13171954081051', 'C13171954081052', 'C13171954081053', 'C13171954081054', 'C13171954081055', 'C13171954081056', 'C13171954081057', 'C13171954081058', 'C13171954081059', 'C13171954081060', 'C13171954081061', 'C13171954081062', 'C13171954081063', 'C13171954081064', 'C13171954081065', 'C13171954081066', 'C13171954081067', 'C13171954081068', 'C13171954081069', 'C13171954081070', 'C13171954081071', 'C13171954081072', 'C13171954081073', 'C13171954081074', 'C13171954081075', 'C13171954081076', 'C13171954081077', 'C13171954081078', 'C13171954081079', 'C 13171954081080', 'C13171954081081', 'C13171954081082', 'C13171954081083', 'C13171954081039', 'C13171954081001', 'C13171954081002', 'C13171954081003', 'C13171954081004', 'C13171954081005', 'C13171954081006', 'C13171954081007', 'C13171954081008', 'C13171954081009', 'C13171954081010', 'C13171954081011', 'C13171954081012', 'C13171954081013', 'C13171954081014', 'C13171954081015', 'C13171954081016', 'C13171954081017', 'C13171954081018', 'C13171954081019', 'C13171954081020', 'C13171954081021', 'C13171954081022', 'C13171954081023', 'C13171954081024', 'C13171954081025', 'C13171954081026', 'C13171954081027', 'C13171954081028', 'C13171954081029', 'C13171954081030', 'C13171954081031', 'C13171954081032', 'C13171954081033', 'C13171954081034', 'C13171954081035', 'C13171954081036', 'C13171954081037', 'C13171954081038')
cf621qmts91wf	SELECT /*+ ordered use_nl(stat text) */ text.sql_text, text.command_type, stat.* FROM (SELECT * FROM (SELECT s.sql_id, max(s.plan_hash_value) as planhash, sum(s.cpu_time_delta) as cpu_time, sum(s.elapsed_time_delta) as elapsed_time, sum(s.elapsed_time_delta - s.plsexec_time_delta - s.javexec_time_delta) as sqlx_time, sum(s.plsexec_time_delta) as plsqlx_time, sum(s.javexec_time_delta) as javax_time, sum(s.disk_reads_delta + s.direct_writes_delta) as io_blocks, sum(s.iowait_delta) as io_wait, sum(s.clwait_delta) as cl_wait, sum(s.rows_processed_delta) as rows_processed, sum(s.fetches_delta) as fetches, sum(s.end_of_fetch_count_delta) as eofs, sum(s.executions_delta) as execs, sum(s.px_servers_execs_delta) as px FROM (SELECT t1.* FROM WRH$_SQLSTAT 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$_SQLSTAT_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) s WHERE s.snap_id > :startsn and s.snap_id <= :endsn and s.dbid = :dbid and s.instance_number = :inst_id and s.sql_id in ( SELECT ash.sql_id FROM ( SELECT a.sql_id as sql_id , coun t(*) as occur_count 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.snap_id > :startsn and a.snap_id <= :endsn and a.dbid = :db_id and a.instance_number = :instance_number and a.sql_id is not null and a.wait_time = 0 and a.session_type = 1 and a.event_id in ( select en.event_id from WRH$_EVENT_NAME en where a.dbid = en.dbid and en.wait_class = 'User I/O') GROUP BY a.sql_id HAVING count(*) >= :cutoff ORDER BY occur_count DESC ) ash WHERE rownum <= :topsql_from_ash ) GROUP BY s.sql_id HAVING sum(s.iowait_delta) >= :cutoff ORDER BY sum(s.iowait_delta) DESC ) WHERE ROWNUM <= :topsql) stat , WRH$_SQLTEXT text WHERE text.dbid = :db_id AND text.sql_id = stat.sql_id ORDER BY stat.io_wait DESC
cfzsp5vd19wmb	explain plan set statement_id = 'CZHIS' for Select fwid, zhtai from view_gzlr_FWZT2 where fwid in('C13171954081129', 'C13171954081130', 'C13171954081131', 'C13171954081132', 'C13171954081133', 'C13171954081134', 'C13171954081135', 'C13171954081136', 'C13171954081137', 'C13171954081138', 'C13171954081139', 'C13171954081140', 'C13171954081141', 'C13171954081142', 'C13171954081143', 'C13171954081144', 'C13171954081145', 'C13171954081146', 'C13171954081147', 'C13171954081148', 'C13171954081149', 'C13171954081150', 'C13171954081151', 'C13171954081152', 'C13171954081153', 'C13171954081154', 'C13171954081155', 'C13171954081156', 'C13171954081157', 'C13171954081158', 'C13171954081159', 'C13171954081160', 'C13171954081161', 'C13171954081162', 'C13171954081163', 'C13171954081164', 'C13171954081165', 'C13171954081166', 'C13171954081167', 'C13171954081168', 'C13171954081169', 'C13171954081170', 'C13171954081171', 'C13171954081172', 'C13171954081173', 'C13171954081084', 'C13171954081085', 'C13171954081086', 'C13171954081087', 'C13171954081088', 'C13171954081089', 'C13171954081090', 'C13171954081091', 'C13171954081092', 'C13171954081093', 'C13171954081094', 'C13171954081095', 'C13171954081096', 'C13171954081097', 'C13171954081098', 'C13171954081099', 'C13171954081100', 'C13171954081101', 'C13171954081102', 'C13171954081103', 'C13171954081104', 'C13171954081105', 'C13171954081106', 'C13171954081107', 'C13171954081108', 'C13171954081109', 'C13171954081110', 'C13171954081111', 'C13171954081 112', 'C13171954081113', 'C13171954081114', 'C13171954081115', 'C13171954081116', 'C13171954081117', 'C13171954081118', 'C13171954081119', 'C13171954081120', 'C13171954081121', 'C13171954081122', 'C13171954081123', 'C13171954081124', 'C13171954081125', 'C13171954081126', 'C13171954081127', 'C13171954081128', 'C13171954081219', 'C13171954081220', 'C13171954081221', 'C13171954081222', 'C13171954081223', 'C13171954081224', 'C13171954081225', 'C13171954081226', 'C13171954081227', 'C13171954081228', 'C13171954081229', 'C13171954081230', 'C13171954081231', 'C13171954081232', 'C13171954081233', 'C13171954081234', 'C13171954081235', 'C13171954081236', 'C13171954081237', 'C13171954081238', 'C13171954081239', 'C13171954081240', 'C13171954081241', 'C13171954081242', 'C13171954081243', 'C13171954081244', 'C13171954081245', 'C13171954081246', 'C13171954081247', 'C13171954081248', 'C13171954081249', 'C13171954081250', 'C13171954081251', 'C13171954081252', 'C13171954081253', 'C13171954081254', 'C13171954081255', 'C13171954081256', 'C13171954081257', 'C13171954081258', 'C13171954081259', 'C13171954081260', 'C13171954081261', 'C13171954081262', 'C13171954081263', 'C13171954081174', 'C13171954081175', 'C13171954081176', 'C13171954081177', 'C13171954081178', 'C13171954081179', 'C13171954081180', 'C13171954081181', 'C13171954081182', 'C13171954081183', 'C13171954081184', 'C13171954081185', 'C13171954081186', 'C13171954081187', 'C13171954081188', 'C13171954081189', 'C13171954081190', 'C1317195408 1191', 'C13171954081192', 'C13171954081193', 'C13171954081194', 'C13171954081195', 'C13171954081196', 'C13171954081197', 'C13171954081198', 'C13171954081199', 'C13171954081200', 'C13171954081201', 'C13171954081202', 'C13171954081203', 'C13171954081204', 'C13171954081205', 'C13171954081206', 'C13171954081207', 'C13171954081208', 'C13171954081209', 'C13171954081264', 'C13171954081210', 'C13171954081211', 'C13171954081212', 'C13171954081213', 'C13171954081214', 'C13171954081215', 'C13171954081216', 'C13171954081217', 'C13171954081218', 'C13171954081265', 'C13171954081266', 'C13171954081267', 'C13171954081268', 'C13171954081269', 'C13171954081270', 'C13171954081271', 'C13171954081272', 'C13171954081273', 'C13171954081274', 'C13171954081275', 'C13171954081276', 'C13171954081040', 'C13171954081041', 'C13171954081042', 'C13171954081043', 'C13171954081044', 'C13171954081045', 'C13171954081046', 'C13171954081047', 'C13171954081048', 'C13171954081049', 'C13171954081050', 'C13171954081051', 'C13171954081052', 'C13171954081053', 'C13171954081054', 'C13171954081055', 'C13171954081056', 'C13171954081057', 'C13171954081058', 'C13171954081059', 'C13171954081060', 'C13171954081061', 'C13171954081062', 'C13171954081063', 'C13171954081064', 'C13171954081065', 'C13171954081066', 'C13171954081067', 'C13171954081068', 'C13171954081069', 'C13171954081070', 'C13171954081071', 'C13171954081072', 'C13171954081073', 'C13171954081074', 'C13171954081075', 'C13171954081076', 'C13171954081077', 'C131719540 81078', 'C13171954081079', 'C13171954081080', 'C13171954081081', 'C13171954081082', 'C13171954081083', 'C13171954081039', 'C13171954081001', 'C13171954081002', 'C13171954081003', 'C13171954081004', 'C13171954081005', 'C13171954081006', 'C13171954081007', 'C13171954081008', 'C13171954081009', 'C13171954081010', 'C13171954081011', 'C13171954081012', 'C13171954081013', 'C13171954081014', 'C13171954081015', 'C13171954081016', 'C13171954081017', 'C13171954081018', 'C13171954081019', 'C13171954081020', 'C13171954081021', 'C13171954081022', 'C13171954081023', 'C13171954081024', 'C13171954081025', 'C13171954081026', 'C13171954081027', 'C13171954081028', 'C13171954081029', 'C13171954081030', 'C13171954081031', 'C13171954081032', 'C13171954081033', 'C13171954081034', 'C13171954081035', 'C13171954081036', 'C13171954081037', 'C13171954081038')
czgd24bbyt6vr	select * from BMB_ZJLB order by bm
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dc9bdxa7xpv8s	declare t_owner varchar2(30); t_name varchar2(30); procedure check_mview is dummy integer; begin if :object_type = 'TABLE' then select /*+rule*/ 1 into dummy from sys.all_objects where owner = :object_owner and object_name = :object_name and object_type = 'MATERIALIZED VIEW' and rownum = 1; :object_type := 'MATERIALIZED VIEW'; end if; exception when others then null; end; begin :sub_object := null; if :deep != 0 then begin if :part2 is null then select /*+rule*/ constraint_type, owner, constraint_name into :object_type, :object_owner, :object_name from sys.all_constraints c where c.constraint_name = :part1 and c.owner = :cur_schema and rownum = 1; else select /*+rule*/ constraint_type, owner, constraint_name, :part3 into :object_type, :object_owner, :object_name, :sub_object from sys.all_constraints c where c.constraint_name = :part2 and c.owner = :part1 and rownum = 1; end if; if :object_type = 'P' then :object_type := 'PRIMARY KEY'; end if; if :object_type = 'U' then :object_type := 'UNIQUE KEY'; end if; if :object_type = 'R' then :object_type := 'FOREIGN KEY'; end if; if :object_type = 'C' then :object_type := 'CHECK CONSTRAINT'; end if; return; exception when no_data_found then null; end; end if; :sub_object := :pa rt2; if (:part2 is null) or (:part1 != :cur_schema) then begin select /*+rule*/ object_type, :cur_schema, :part1 into :object_type, :object_owner, :object_name from sys.all_objects where owner = :cur_schema and object_name = :part1 and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; if :object_type = 'SYNONYM' then select /*+rule*/ s.table_owner, s.table_name into t_owner, t_name from all_synonyms s where s.synonym_name = :part1 and s.owner = :cur_schema and rownum = 1; select /*+rule*/ o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = t_owner and o.object_name = t_name and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; end if; :sub_object := :part2; if :part3 is not null then :sub_object := :sub_object || '.' || :part3; end if; check_mview; return; exception when no_data_found then null; end; end if; begin select /*+rule*/ s.table_owner, s.table_name into t_owner, t_name from all_synonyms s where s.synonym_name = :part1 and s.owner = 'PUBLIC' and rownum = 1; select /*+rule*/ o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = t_owner and o.object_name = t_name and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; check_mview; return; exception when no_data_found then null; end; :sub_object := :part3; begin select /*+rule*/ o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = :part1 and o.object_name = :part2 and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; check_mview; return; exception when no_data_found then null; end; begin if :part2 is null and :part3 is null then select /*+rule*/ 'USER', null, :part1 into :object_type, :object_owner, :object_name from sys.all_users u where u.username = :part1 and rownum = 1; return; end if; exception when no_data_found then null; end; begin if :part2 is null and :part3 is null and :deep != 0 then select /*+rule*/ 'ROLE', null, :part1 into :object_type, :object_owner , :object_name from sys.session_roles r where r.role = :part1 and rownum = 1; return; end if; exception when no_data_found then null; end; :object_owner := null; :object_type := null; :object_name := null; :sub_object := null; end;
dwyz7mw5t8439	Select fwid, zhtai from view_gzlr_FWZT2 where FWID in ('C12609526601061', 'C12609526601062', 'C12609526601063', 'C12609526601064', 'C12609526601065', 'C12609526601066', 'C12609526601067', 'C12609526601068', 'C12609526601069', 'C12609526601070', 'C12609526601071', 'C12609526601072', 'C12609526601073', 'C12609526601074', 'C12609526601075', 'C12609526601076', 'C12609526601077', 'C12609526601078', 'C12609526601079', 'C12609526601080', 'C12609526601081', 'C12609526601082', 'C12609526601083', 'C12609526601084', 'C12609526601085', 'C12609526601086', 'C12609526601087', 'C12609526601088', 'C12609526601089', 'C12609526601090', 'C12609526601001', 'C12609526601002', 'C12609526601003', 'C12609526601004', 'C12609526601005', 'C12609526601006', 'C12609526601007', 'C12609526601008', 'C12609526601009', 'C12609526601010', 'C12609526601011', 'C12609526601012', 'C12609526601013', 'C12609526601014', 'C12609526601015', 'C12609526601016', 'C12609526601017', 'C12609526601018', 'C12609526601019', 'C12609526601020', 'C12609526601021', 'C12609526601022', 'C12609526601023', 'C12609526601024', 'C12609526601025', 'C12609526601026', 'C12609526601027', 'C12609526601028', 'C12609526601029', 'C12609526601030', 'C12609526601031', 'C12609526601032', 'C12609526601033', 'C12609526601034', 'C12609526601035', 'C12609526601036', 'C12609526601037', 'C12609526601038', 'C12609526601039', 'C12609526601040', 'C12609526601041', 'C12609526601042', 'C12609526601043', 'C12609526601044', 'C12609526601045', 'C12609526601046', ' C12609526601047', 'C12609526601048', 'C12609526601049', 'C12609526601050', 'C12609526601051', 'C12609526601052', 'C12609526601053', 'C12609526601054', 'C12609526601055', 'C12609526601056', 'C12609526601057', 'C12609526601058', 'C12609526601059', 'C12609526601060')
fykcnnqqfvswq	select * from (select a.work_id, a.ywh, a.ywxh, a.SQRQ, a.ywbm, a.ywmc, a.xlmc, b.act_id, b.act_name, b.workorder, b.staff_id, b.YJWCRQ, e.xh, f.ADDFW, f.CANTJ, a.ISBACK, decode(a.BACKTIMES, 0, '', a.BACKTIMES) BACKTIMES, b.FLAGOFACTION, a.GRQZBJ, b.PREFLAGOFACTION, a.PLID, b.ACCEPT_TIME , d.fwzl, b.actionidea, tt.sqrxm sqr, d.syqzh, tt.slr, to_char(tt.dtslrq, 'YYYY-MM-DD') dtslrq, GetLastHJTJR(a.ywh) SHJTJR, GetLastHJTJSJ(a.ywh) SHJTJSJ from gzlr_ywsq a join gzlr_to_do b on a.ywh=b.ywh and a.ywxh=b.ywxh join gzl_work e on a.work_id=e.work_id join gzl_ywxl f on a.ywbm=f.ywbm and a.xlbm=f.xlbm join yw_ywfwsx d on d.ywh=a.ywh and d.ywxh=a.ywxh join yw_ywsq tt on tt.ywh=a.ywh where (b.staff_id=413 or (b.duty_id in (select duty_id from view_duty_staff where staff_id=413) and b.staff_id is null)) and a.wcbs='N' union select a.work_id, a.ywh, a.ywxh, a.SQRQ, a.ywbm, a.ywmc, a.xlmc, b.act_id, b.act_name, b.workorder, b.staff_id, b.YJWCRQ, e.xh, f.ADDFW, f.CANTJ, a.ISBACK, decode(a.BACKTIMES, 0, '', a.BACKTIMES) BACKTIMES, b.FLAGOFACTION, a.GRQZBJ, b.PREFLAGOFACTION, a.PLID, b.ACCEPT_TIME , d.fwzl, b.actionidea, tt.sqrxm sqr, d.syqzh, tt.slr, to_char(tt.dtslrq, 'YYYY-MM-DD') dtslrq, GetLastHJTJR(a.ywh) SHJTJR, GetLastHJTJSJ(a.ywh) SHJTJSJ from gzlr_ywsq a join gzlr_to_do b on a.ywh=b.ywh and a.ywxh=b.ywxh join gzl_work e on a.work_id=e.work_id join gzl_ywxl f on a.ywbm=f.ywbm and a.xlbm=f.xlbm join yw_ywfwsx d on d.ywh=a.ywh and d.ywxh=a.ywxh join yw_ywsq tt on tt .ywh=a.ywh where (exists (select FROMSTAFF_ID from GZL_YW_AUTHORIZATION where TOSTAFF_ID=413 and CALLBACKTIME is null and fromstaff_id=b.staff_id and ywbm=a.ywbm and xlbm=a.xlbm) or (exists (select duty_id from view_duty_staff vstaff where exists (select FROMSTAFF_ID from GZL_YW_AUTHORIZATION where TOSTAFF_ID=413 and CALLBACKTIME is null and vstaff.staff_id=FROMSTAFF_ID and ywbm=a.ywbm and xlbm=a.xlbm) and b.duty_id=vstaff.duty_id )) and b.staff_id is null ) and a.wcbs='N' ) t1 order by t1.yjwcrq asc, t1.GRQZBJ desc, t1.YWH desc
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g3vp8a8cqk0uw	select FORM from BDDZ_FORM where FORMID='YW_YWSQR_INFO.XML'
g642aqs2qjq1n	begin P_CaseCheck.CheckSimilarCase(YWH1=>:YWH1, YWXH1=>:YWXH1, Has=>:Has, SimilarCases=>:SimilarCases); end;
gg77sptjn6v2n	INSERT INTO T_SIMILARFWZLCASES(YWH, FWZL, SYQZH, SYQZBH) SELECT YWH, FWZL, SYQZH, SYQZBH FROM YW_YWFWSX B WHERE NOT(YWH=:B2 ) AND FWZL LIKE REPLACE(:B1 , '椒江区', '')
gh51t7rcwbzju	/*Select fwid, zhtai from view_gzlr_FWZT2 where fwid in(select fwid from table_room where buildid='ZYH000351_5')*/ Select /*+ rules */ fwid, zhtai from view_gzlr_FWZT2 where fwid in('C13171954081129', 'C13171954081130', 'C13171954081131', 'C13171954081132', 'C13171954081133', 'C13171954081134', 'C13171954081135', 'C13171954081136', 'C13171954081137', 'C13171954081138', 'C13171954081139', 'C13171954081140', 'C13171954081141', 'C13171954081142', 'C13171954081143', 'C13171954081144', 'C13171954081145', 'C13171954081146', 'C13171954081147', 'C13171954081148', 'C13171954081149', 'C13171954081150', 'C13171954081151', 'C13171954081152', 'C13171954081153', 'C13171954081154', 'C13171954081155', 'C13171954081156', 'C13171954081157', 'C13171954081158', 'C13171954081159', 'C13171954081160', 'C13171954081161', 'C13171954081162', 'C13171954081163', 'C13171954081164', 'C13171954081165', 'C13171954081166', 'C13171954081167', 'C13171954081168', 'C13171954081169', 'C13171954081170', 'C13171954081171', 'C13171954081172', 'C13171954081173', 'C13171954081084', 'C13171954081085', 'C13171954081086', 'C13171954081087', 'C13171954081088', 'C13171954081089', 'C13171954081090', 'C13171954081091', 'C13171954081092', 'C13171954081093', 'C13171954081094', 'C13171954081095', 'C13171954081096', 'C13171954081097', 'C13171954081098', 'C13171954081099', 'C13171954081100', 'C13171954081101', 'C13171954081102', 'C13171954081103', 'C13171954081104', 'C13171954081105', 'C13171954081106', 'C13171954081107', 'C13171 954081108', 'C13171954081109', 'C13171954081110', 'C13171954081111', 'C13171954081112', 'C13171954081113', 'C13171954081114', 'C13171954081115', 'C13171954081116', 'C13171954081117', 'C13171954081118', 'C13171954081119', 'C13171954081120', 'C13171954081121', 'C13171954081122', 'C13171954081123', 'C13171954081124', 'C13171954081125', 'C13171954081126', 'C13171954081127', 'C13171954081128', 'C13171954081219', 'C13171954081220', 'C13171954081221', 'C13171954081222', 'C13171954081223', 'C13171954081224', 'C13171954081225', 'C13171954081226', 'C13171954081227', 'C13171954081228', 'C13171954081229', 'C13171954081230', 'C13171954081231', 'C13171954081232', 'C13171954081233', 'C13171954081234', 'C13171954081235', 'C13171954081236', 'C13171954081237', 'C13171954081238', 'C13171954081239', 'C13171954081240', 'C13171954081241', 'C13171954081242', 'C13171954081243', 'C13171954081244', 'C13171954081245', 'C13171954081246', 'C13171954081247', 'C13171954081248', 'C13171954081249', 'C13171954081250', 'C13171954081251', 'C13171954081252', 'C13171954081253', 'C13171954081254', 'C13171954081255', 'C13171954081256', 'C13171954081257', 'C13171954081258', 'C13171954081259', 'C13171954081260', 'C13171954081261', 'C13171954081262', 'C13171954081263', 'C13171954081174', 'C13171954081175', 'C13171954081176', 'C13171954081177', 'C13171954081178', 'C13171954081179', 'C13171954081180', 'C13171954081181', 'C13171954081182', 'C13171954081183', 'C13171954081184', 'C13171954081185', 'C13171954081186', 'C1317 1954081187', 'C13171954081188', 'C13171954081189', 'C13171954081190', 'C13171954081191', 'C13171954081192', 'C13171954081193', 'C13171954081194', 'C13171954081195', 'C13171954081196', 'C13171954081197', 'C13171954081198', 'C13171954081199', 'C13171954081200', 'C13171954081201', 'C13171954081202', 'C13171954081203', 'C13171954081204', 'C13171954081205', 'C13171954081206', 'C13171954081207', 'C13171954081208', 'C13171954081209', 'C13171954081264', 'C13171954081210', 'C13171954081211', 'C13171954081212', 'C13171954081213', 'C13171954081214', 'C13171954081215', 'C13171954081216', 'C13171954081217', 'C13171954081218', 'C13171954081265', 'C13171954081266', 'C13171954081267', 'C13171954081268', 'C13171954081269', 'C13171954081270', 'C13171954081271', 'C13171954081272', 'C13171954081273', 'C13171954081274', 'C13171954081275', 'C13171954081276', 'C13171954081040', 'C13171954081041', 'C13171954081042', 'C13171954081043', 'C13171954081044', 'C13171954081045', 'C13171954081046', 'C13171954081047', 'C13171954081048', 'C13171954081049', 'C13171954081050', 'C13171954081051', 'C13171954081052', 'C13171954081053', 'C13171954081054', 'C13171954081055', 'C13171954081056', 'C13171954081057', 'C13171954081058', 'C13171954081059', 'C13171954081060', 'C13171954081061', 'C13171954081062', 'C13171954081063', 'C13171954081064', 'C13171954081065', 'C13171954081066', 'C13171954081067', 'C13171954081068', 'C13171954081069', 'C13171954081070', 'C13171954081071', 'C13171954081072', 'C13171954081073', 'C131 71954081074', 'C13171954081075', 'C13171954081076', 'C13171954081077', 'C13171954081078', 'C13171954081079', 'C13171954081080', 'C13171954081081', 'C13171954081082', 'C13171954081083', 'C13171954081039', 'C13171954081001', 'C13171954081002', 'C13171954081003', 'C13171954081004', 'C13171954081005', 'C13171954081006', 'C13171954081007', 'C13171954081008', 'C13171954081009', 'C13171954081010', 'C13171954081011', 'C13171954081012', 'C13171954081013', 'C13171954081014', 'C13171954081015', 'C13171954081016', 'C13171954081017', 'C13171954081018', 'C13171954081019', 'C13171954081020', 'C13171954081021', 'C13171954081022', 'C13171954081023', 'C13171954081024', 'C13171954081025', 'C13171954081026', 'C13171954081027', 'C13171954081028', 'C13171954081029', 'C13171954081030', 'C13171954081031', 'C13171954081032', 'C13171954081033', 'C13171954081034', 'C13171954081035', 'C13171954081036', 'C13171954081037', 'C13171954081038')
grwydz59pu6mc	select text from view$ where rowid=:1

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

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

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

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

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

Back to Top

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

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

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

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

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.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

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

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

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

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

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

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

• ordered by misses desc

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

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: 3,443,713
• Captured Segments account for 89.5% of Total

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 304,378
• Captured Segments account for 0.0% of Total

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Back to Top

Library Cache Activity

• "Pct Misses" should be very low

Back to Top

Memory Statistics

• Process Memory Summary
• SGA Memory Summary
• SGA breakdown difference

Process Memory Summary

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

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Back to Top

init.ora Parameters

Back to Top

End of Report