WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ZXDB	2879712909	zxdb1	1	11-Jan-13 17:01	11.2.0.3.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
zhixing-db1	Linux x86 64-bit	16	8	2	11.57

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2298	24-Jan-13 12:00:36	152	4.9
End Snap:	2299	24-Jan-13 13:00:06	138	4.9
Elapsed:		59.50 (mins)
DB Time:		10.46 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	2,672M	2,672M	Std Block Size:	8K
Shared Pool Size:	816M	816M	Log Buffer:	14,264K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.2	0.0	0.00	0.00
DB CPU(s):	0.1	0.0	0.00	0.00
Redo size:	3,198.3	397.1
Logical reads:	8,785.0	1,090.8
Block changes:	16.8	2.1
Physical reads:	1,904.9	236.5
Physical writes:	1.7	0.2
User calls:	146.5	18.2
Parses:	2.1	0.3
Hard parses:	0.5	0.1
W/A MB processed:	0.6	0.1
Logons:	0.0	0.0
Executes:	48.3	6.0
Rollbacks:	7.0	0.9
Transactions:	8.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	98.92	In-memory Sort %:	100.00
Library Hit %:	96.27	Soft Parse %:	74.41
Execute to Parse %:	95.66	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	95.98	% Non-Parse CPU:	97.26

Shared Pool Statistics

	Begin	End
Memory Usage %:	83.21	83.70
% SQL with executions>1:	89.80	84.10
% Memory for SQL w/exec>1:	87.90	75.12

Top 5 Timed Foreground Events

Host CPU (CPUs: 16 Cores: 8 Sockets: 2)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.03	0.56	0.8	0.5	0.8	98.4

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.6	37.4	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	11,851.5	11,851.5
SGA use (MB):	3,568.0	3,568.0
PGA use (MB):	574.0	527.6
% Host Mem used for SGA+PGA:	34.95	34.56

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	15.19	1.89
Global Cache blocks served:	9.72	1.21
GCS/GES messages received:	42.30	5.25
GCS/GES messages sent:	33.13	4.11
DBWR Fusion writes:	0.29	0.04
Estd Interconnect traffic (KB)	213.97

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	98.71
Buffer access - remote cache %:	0.22
Buffer access - disk %:	1.08

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.9
Avg global cache current block receive time (ms):	0.9
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	0.3
Avg global cache cr block flush time (ms):	5.0
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.1
Avg global cache current block flush time (ms):	10.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	2.8
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	76.85
% of indirect sent messages:	22.96
% of flow controlled messages:	0.20

Cluster Interconnect

• if IP/Public/Source at End snap is different a '*' is displayed

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
• Shared Server Statistics
• init.ora Parameters

More RAC Statistics

• RAC Report Summary
• Global Messaging Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats
• Interconnect Stats
• Dynamic Remastering Statistics

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

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

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 103.0% of Total DB time 627.89 (s)
• Total FG Wait Time: 411.48 (s) DB CPU time: 235.15 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

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 seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• SQL ordered by Cluster Wait Time
• 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 - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 72.8% of Total DB Time (s): 628
• Captured PL/SQL account for 0.5% of Total DB Time (s): 628

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 - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 53.5% of Total CPU Time (s): 235
• Captured PL/SQL account for 0.8% of Total CPU Time (s): 235

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 85.4% of Total User I/O Wait Time (s): 370
• Captured PL/SQL account for 0.3% of Total User I/O Wait Time (s): 370

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 as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 31,360,327
• Captured SQL account for 72.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 6,800,097
• Captured SQL account for 91.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 167,483
• Captured SQL account for 76.9% of Total
• Total UnOptimized Read Requests: 167,483
• Captured SQL account for 76.9% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 172,561
• Captured SQL account for 48.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 7,487
• Captured SQL account for 38.3% 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

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

• %Total - Cluster Time as a percentage of Total Cluster Wait Time
• %Clu - Cluster Time as a percentage of Elapsed Time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Only SQL with Cluster Wait Time > .005 seconds is reported
• Total Cluster Wait Time (s): 27
• Captured SQL account for 68.1% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
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)
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
18nu7udgr2mdn	SELECT roleid, privilegeid FROM ralasafe_roleprivilege WHERE roleid=:1
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
212544061agc2	select caseinfor0_.id as id17_37_, caseinfor0_.apply_action as apply2_17_37_, caseinfor0_.apply_money as apply3_17_37_, caseinfor0_.apply_res as apply4_17_37_, caseinfor0_.apply_rights as apply5_17_37_, caseinfor0_.auto_exec_money as auto6_17_37_, caseinfor0_.case_code as case7_17_37_, caseinfor0_.case_kind_id as case34_17_37_, caseinfor0_.kind_cause_id as kind35_17_37_, caseinfor0_.case_src_id as case36_17_37_, caseinfor0_.case_state_id as case37_17_37_, caseinfor0_.cause_id as cause38_17_37_, caseinfor0_.court_id as court39_17_37_, caseinfor0_.create_time as create8_17_37_, caseinfor0_.creater_id as creater40_17_37_, caseinfor0_.defer_begin_date as defer9_17_37_, caseinfor0_.defer_cause_id as defer41_17_37_, caseinfor0_.defer_days as defer10_17_37_, caseinfor0_.defer_end_date as defer11_17_37_, caseinfor0_.depart_id as depart42_17_37_, caseinfor0_.exec_incept_date as exec12_17_37_, caseinfor0_.execed_action as execed13_17_37_, caseinfor0_.execed_money as execed14_17_37_, caseinfor0_.execed_rights as execed15_17_37_, caseinfor0_.execed_res as execed16_17_37_, caseinfor0_.foreign_factor_id as foreign43_17_37_, caseinfor0_.gist_id as gist44_17_37_, caseinfor0_.gist_cid as gist17_17_37_, caseinfor0_.gist_content as gist18_17_37_, caseinfor0_.gist_date as gist19_17_37_, caseinfor0_.gist_term as gist20_17_37_, caseinfor0_.gist_unit as gist21_17_37_, caseinfor0_.is_deleted as is22_17_37_, caseinfor0_.is_report as is23_17_37_, caseinfor0_.last_update_time as last24_17_37_, caseinfor0_.maturity_date as maturity25_17_37_, caseinfor0_.parent_case_code as parent26_17_37_, caseinfor0_.parent_court as parent27_17_37_, caseinfor0_.reg_date as reg28_17_37_, caseinfor0_.remark as remark17_37_, caseinfor0_.root_id as root30_17_37_, caseinfor0_.state_end_date as state31_17_37_, caseinfor0_.state_update_time as state32_17_37_, caseinfor0_.will_expense as will33_17_37_, paracaseki1_.id as id101_0_, paracaseki1_.case_kind as case2_101_0_, paracaseki1_.disable_time as disable3_101_0_, paracaseki1_.enable as enable101_0_, paracaseki1_.gist_term as gist5_101_0_, paracaseki1_.need_old_case as need6_101_0_, paracaseki1_.reg_time as reg7_101_0_, paracaseki2_.id as id102_1_, paracaseki2_.case_kind_id as case3_102_1_, paracaseki2_.kind_cause as kind2_102_1_, paracaseki3_.id as id101_2_, paracaseki3_.case_kind as case2_101_2_, paracaseki3_.disable_time as disable3_101_2_, paracaseki3_.enable as enable101_2_, paracaseki3_.gist_term as gist5_101_2_, paracaseki3_.need_old_case as need6_101_2_, paracaseki3_.reg_time as reg7_101_2_, paracasesr4_.id as id103_3_, paracasesr4_.case_src as case2_103_3_, paracasesr4_.disable_time as disable3_103_3_, paracasesr4_.enable as enable103_3_, paracasesr4_.reg_time as reg5_103_3_, paracode5_.id as id105_4_, paracode5_.attribute as attribute105_4_, paracode5_.attribute1 as attribute3_105_4_, paracode5_.code_name as code4_105_4_, paracode5_.disable_time as disable5_105_4_, paracode5_.enable as enable105_4_, paracode5_.type_id as type8_105_4_, paracode5_.reg_time as reg7_105_4_, paratype6_.id as id109_5_, paratype6_.ori_name as ori2_109_5_, paratype6_.para_name as para3_109_5_, paratype6_.rmks as rmks109_5_, paracaseca7_.id as id100_6_, paracaseca7_.cause_seq as cause2_100_6_, paracaseca7_.disable_time as disable3_100_6_, paracaseca7_.enable as enable100_6_, paracaseca7_.iname as iname100_6_, paracaseca7_.p_id as p8_100_6_, paracaseca7_.reg_time as reg6_100_6_, paracaseca7_.stat_id as stat7_100_6_, paracaseca8_.id as id100_7_, paracaseca8_.cause_seq as cause2_100_7_, paracaseca8_.disable_time as disable3_100_7_, paracaseca8_.enable as enable100_7_, paracaseca8_.iname as iname100_7_, paracaseca8_.p_id as p8_100_7_, paracaseca8_.reg_time as reg6_100_7_, paracaseca8_.stat_id as stat7_100_7_, court9_.id as id0_8_, court9_.belong_m as belong2_0_8_, court9_.belong_s as belong3_0_8_, court9_.del_flag as del4_0_8_, court9_.disable_time a s disable5_0_8_, court9_.dname as dname0_8_, court9_.enable as enable0_8_, court9_.iname as iname0_8_, court9_.jcode as jcode0_8_, court9_.court_level_id as court13_0_8_, court9_.area_id as area14_0_8_, court9_.parent_id as parent15_0_8_, court9_.reg_time as reg10_0_8_, court9_.sname as sname0_8_, court9_.stdcode as stdcode0_8_, paracode10_.id as id105_9_, paracode10_.attribute as attribute105_9_, paracode10_.attribute1 as attribute3_105_9_, paracode10_.code_name as code4_105_9_, paracode10_.disable_time as disable5_105_9_, paracode10_.enable as enable105_9_, paracode10_.type_id as type8_105_9_, paracode10_.reg_time as reg7_105_9_, paracode11_.id as id105_10_, paracode11_.attribute as attribute105_10_, paracode11_.attribute1 as attribute3_105_10_, paracode11_.code_name as code4_105_10_, paracode11_.disable_time as disable5_105_10_, paracode11_.enable as enable105_10_, paracode11_.type_id as type8_105_10_, paracode11_.reg_time as reg7_105_10_, court12_.id as id0_11_, court12_.belong_m as belong2_0_11_, court12_.belong_s as belong3_0_11_, court12_.del_flag as del4_0_11_, court12_.disable_time as disable5_0_11_, court12_.dname as dname0_11_, court12_.enable as enable0_11_, court12_.iname as iname0_11_, court12_.jcode as jcode0_11_, court12_.court_level_id as court13_0_11_, court12_.area_id as area14_0_11_, court12_.parent_id as parent15_0_11_, court12_.reg_time as reg10_0_11_, court12_.sname as sname0_11_, court12_.stdcode as stdcode0_11_, undertaker13_.id as id6_12_, undertaker13_.admin_flag as admin2_6_12_, undertaker13_.bday as bday6_12_, undertaker13_.court_id as court19_6_12_, undertaker13_.degree_id as degree20_6_12_, undertaker13_.del_flag as del4_6_12_, undertaker13_.depart_id as depart21_6_12_, undertaker13_.education_id as education22_6_12_, undertaker13_.email as email6_12_, undertaker13_.enable as enable6_12_, undertaker13_.entry_type_id as entry23_6_12_, undertaker13_.executive_id as executive24_6_12_, undertaker13_.folk_id as folk25_6_12_, undertaker13_.group_list as group7_6_12_, undertaker13_.iname as iname6_12_, undertaker13_.iname_py as iname9_6_12_, undertaker13_.jid as jid6_12_, undertaker13_.judge_job_id as judge26_6_12_, undertaker13_.judge_level_id as judge27_6_12_, undertaker13_.last_login_time as last11_6_12_, undertaker13_.leader_job as leader12_6_12_, undertaker13_.mobile as mobile6_12_, undertaker13_.passwd as passwd6_12_, undertaker13_.phone as phone6_12_, undertaker13_.pid as pid6_12_, undertaker13_.political_id as political28_6_12_, undertaker13_.profession_level_id as profession29_6_12_, undertaker13_.remark as remark6_12_, undertaker13_.sex_id as sex30_6_12_, undertaker13_.ssl_id as ssl18_6_12_, undertaker13_.weave_id as weave31_6_12_, court14_.id as id0_13_, court14_.belong_m as belong2_0_13_, court14_.belong_s as belong3_0_13_, court14_.del_flag as del4_0_13_, court14_.disable_time as disable5_0_13_, court14_.dname as dname0_13_, court14_.enable as enable0_13_, court14_.iname as iname0_13_, court14_.jcode as jcode0_13_, court14_.court_level_id as court13_0_13_, court14_.area_id as area14_0_13_, court14_.parent_id as parent15_0_13_, court14_.reg_time as reg10_0_13_, court14_.sname as sname0_13_, court14_.stdcode as stdcode0_13_, paracode15_.id as id105_14_, paracode15_.attribute as attribute105_14_, paracode15_.attribute1 as attribute3_105_14_, paracode15_.code_name as code4_105_14_, paracode15_.disable_time as disable5_105_14_, paracode15_.enable as enable105_14_, paracode15_.type_id as type8_105_14_, paracode15_.reg_time as reg7_105_14_, depart16_.id as id1_15_, depart16_.court_id as court7_1_15_, depart16_.del_flag as del2_1_15_, depart16_.disable_time as disable3_1_15_, depart16_.enable as enable1_15_, depart16_.iname as iname1_15_, depart16_.reg_time as reg6_1_15_, court17_.id as id0_16_, court17_.belong_m as belong2_0_16_, court17_.belong_s as belong3_0_16_, court17_.del_flag as del4_0_ 16_, court17_.disable_time as disable5_0_16_, court17_.dname as dname0_16_, court17_.enable as enable0_16_, court17_.iname as iname0_16_, court17_.jcode as jcode0_16_, court17_.court_level_id as court13_0_16_, court17_.area_id as area14_0_16_, court17_.parent_id as parent15_0_16_, court17_.reg_time as reg10_0_16_, court17_.sname as sname0_16_, court17_.stdcode as stdcode0_16_, paracode18_.id as id105_17_, paracode18_.attribute as attribute105_17_, paracode18_.attribute1 as attribute3_105_17_, paracode18_.code_name as code4_105_17_, paracode18_.disable_time as disable5_105_17_, paracode18_.enable as enable105_17_, paracode18_.type_id as type8_105_17_, paracode18_.reg_time as reg7_105_17_, paracode19_.id as id105_18_, paracode19_.attribute as attribute105_18_, paracode19_.attribute1 as attribute3_105_18_, paracode19_.code_name as code4_105_18_, paracode19_.disable_time as disable5_105_18_, paracode19_.enable as enable105_18_, paracode19_.type_id as type8_105_18_, paracode19_.reg_time as reg7_105_18_, paracode20_.id as id105_19_, paracode20_.attribute as attribute105_19_, paracode20_.attribute1 as attribute3_105_19_, paracode20_.code_name as code4_105_19_, paracode20_.disable_time as disable5_105_19_, paracode20_.enable as enable105_19_, paracode20_.type_id as type8_105_19_, paracode20_.reg_time as reg7_105_19_, paracode21_.id as id105_20_, paracode21_.attribute as attribute105_20_, paracode21_.attribute1 as attribute3_105_20_, paracode21_.code_name as code4_105_20_, paracode21_.disable_time as disable5_105_20_, paracode21_.enable as enable105_20_, paracode21_.type_id as type8_105_20_, paracode21_.reg_time as reg7_105_20_, paracode22_.id as id105_21_, paracode22_.attribute as attribute105_21_, paracode22_.attribute1 as attribute3_105_21_, paracode22_.code_name as code4_105_21_, paracode22_.disable_time as disable5_105_21_, paracode22_.enable as enable105_21_, paracode22_.type_id as type8_105_21_, paracode22_.reg_time as reg7_105_21_, paracode23_.id as id105_22_, paracode23_.attribute as attribute105_22_, paracode23_.attribute1 as attribute3_105_22_, paracode23_.code_name as code4_105_22_, paracode23_.disable_time as disable5_105_22_, paracode23_.enable as enable105_22_, paracode23_.type_id as type8_105_22_, paracode23_.reg_time as reg7_105_22_, paracode24_.id as id105_23_, paracode24_.attribute as attribute105_23_, paracode24_.attribute1 as attribute3_105_23_, paracode24_.code_name as code4_105_23_, paracode24_.disable_time as disable5_105_23_, paracode24_.enable as enable105_23_, paracode24_.type_id as type8_105_23_, paracode24_.reg_time as reg7_105_23_, paracode25_.id as id105_24_, paracode25_.attribute as attribute105_24_, paracode25_.attribute1 as attribute3_105_24_, paracode25_.code_name as code4_105_24_, paracode25_.disable_time as disable5_105_24_, paracode25_.enable as enable105_24_, paracode25_.type_id as type8_105_24_, paracode25_.reg_time as reg7_105_24_, paracode26_.id as id105_25_, paracode26_.attribute as attribute105_25_, paracode26_.attribute1 as attribute3_105_25_, paracode26_.code_name as code4_105_25_, paracode26_.disable_time as disable5_105_25_, paracode26_.enable as enable105_25_, paracode26_.type_id as type8_105_25_, paracode26_.reg_time as reg7_105_25_, paracode27_.id as id105_26_, paracode27_.attribute as attribute105_26_, paracode27_.attribute1 as attribute3_105_26_, paracode27_.code_name as code4_105_26_, paracode27_.disable_time as disable5_105_26_, paracode27_.enable as enable105_26_, paracode27_.type_id as type8_105_26_, paracode27_.reg_time as reg7_105_26_, paracause28_.id as id104_27_, paracause28_.code_name as code2_104_27_, paracause28_.disable_time as disable3_104_27_, paracause28_.enable as enable104_27_, paracause28_.type_id as type7_104_27_, paracause28_.party_type_id as party5_104_27_, paracause28_.reg_time as reg6_104_27_, paratype29_.id as id109_28_, paratype29_.ori_name as ori2_109_28_, pa ratype29_.para_name as para3_109_28_, paratype29_.rmks as rmks109_28_, depart30_.id as id1_29_, depart30_.court_id as court7_1_29_, depart30_.del_flag as del2_1_29_, depart30_.disable_time as disable3_1_29_, depart30_.enable as enable1_29_, depart30_.iname as iname1_29_, depart30_.reg_time as reg6_1_29_, paracode31_.id as id105_30_, paracode31_.attribute as attribute105_30_, paracode31_.attribute1 as attribute3_105_30_, paracode31_.code_name as code4_105_30_, paracode31_.disable_time as disable5_105_30_, paracode31_.enable as enable105_30_, paracode31_.type_id as type8_105_30_, paracode31_.reg_time as reg7_105_30_, paracode32_.id as id105_31_, paracode32_.attribute as attribute105_31_, paracode32_.attribute1 as attribute3_105_31_, paracode32_.code_name as code4_105_31_, paracode32_.disable_time as disable5_105_31_, paracode32_.enable as enable105_31_, paracode32_.type_id as type8_105_31_, paracode32_.reg_time as reg7_105_31_, endcase33_.id as id20_32_, endcase33_.case_id as case17_20_32_, endcase33_.court_id as court18_20_32_, endcase33_.del_money as del2_20_32_, endcase33_.end_case_date as end3_20_32_, endcase33_.end_case_mode_id as end19_20_32_, endcase33_.end_case_money as end4_20_32_, endcase33_.exempt_money as exempt5_20_32_, endcase33_.money_arraival_rate as money6_20_32_, endcase33_.overawed as overawed20_32_, endcase33_.party_dispute as party8_20_32_, endcase33_.real_exec_action as real9_20_32_, endcase33_.real_exec_money as real10_20_32_, endcase33_.real_exec_res as real11_20_32_, endcase33_.real_exec_rights as real12_20_32_, endcase33_.real_income_money as real13_20_32_, endcase33_.remark as remark20_32_, endcase33_.undertaker_infraction as undertaker15_20_32_, endcase33_.undertaker_id as undertaker20_20_32_, endcase33_.upd_date as upd16_20_32_, court34_.id as id0_33_, court34_.belong_m as belong2_0_33_, court34_.belong_s as belong3_0_33_, court34_.del_flag as del4_0_33_, court34_.disable_time as disable5_0_33_, court34_.dname as dname0_33_, court34_.enable as enable0_33_, court34_.iname as iname0_33_, court34_.jcode as jcode0_33_, court34_.court_level_id as court13_0_33_, court34_.area_id as area14_0_33_, court34_.parent_id as parent15_0_33_, court34_.reg_time as reg10_0_33_, court34_.sname as sname0_33_, court34_.stdcode as stdcode0_33_, paraendcas35_.id as id107_34_, paraendcas35_.disable_time as disable2_107_34_, paraendcas35_.enable as enable107_34_, paraendcas35_.end_case_mode as end4_107_34_, paraendcas35_.old_id as old5_107_34_, paraendcas35_.parent_id as parent7_107_34_, paraendcas35_.reg_time as reg6_107_34_, paraendcas36_.id as id107_35_, paraendcas36_.disable_time as disable2_107_35_, paraendcas36_.enable as enable107_35_, paraendcas36_.end_case_mode as end4_107_35_, paraendcas36_.old_id as old5_107_35_, paraendcas36_.parent_id as parent7_107_35_, paraendcas36_.reg_time as reg6_107_35_, undertaker37_.id as id6_36_, undertaker37_.admin_flag as admin2_6_36_, undertaker37_.bday as bday6_36_, undertaker37_.court_id as court19_6_36_, undertaker37_.degree_id as degree20_6_36_, undertaker37_.del_flag as del4_6_36_, undertaker37_.depart_id as depart21_6_36_, undertaker37_.education_id as education22_6_36_, undertaker37_.email as email6_36_, undertaker37_.enable as enable6_36_, undertaker37_.entry_type_id as entry23_6_36_, undertaker37_.executive_id as executive24_6_36_, undertaker37_.folk_id as folk25_6_36_, undertaker37_.group_list as group7_6_36_, undertaker37_.iname as iname6_36_, undertaker37_.iname_py as iname9_6_36_, undertaker37_.jid as jid6_36_, undertaker37_.judge_job_id as judge26_6_36_, undertaker37_.judge_level_id as judge27_6_36_, undertaker37_.last_login_time as last11_6_36_, undertaker37_.leader_job as leader12_6_36_, undertaker37_.mobile as mobile6_36_, undertaker37_.passwd as passwd6_36_, undertaker37_.phone as phone6_36_, undertaker37_.pid as pid6_36_, undertaker37_.political_id as political28_6_36 _, undertaker37_.profession_level_id as profession29_6_36_, undertaker37_.remark as remark6_36_, undertaker37_.sex_id as sex30_6_36_, undertaker37_.ssl_id as ssl18_6_36_, undertaker37_.weave_id as weave31_6_36_ from tb_case_infor caseinfor0_ left outer join tb_para_case_kind paracaseki1_ on caseinfor0_.case_kind_id=paracaseki1_.id left outer join tb_para_case_kind_cause paracaseki2_ on caseinfor0_.kind_cause_id=paracaseki2_.id left outer join tb_para_case_kind paracaseki3_ on paracaseki2_.case_kind_id=paracaseki3_.id left outer join tb_para_case_src paracasesr4_ on caseinfor0_.case_src_id=paracasesr4_.id left outer join tb_para_code paracode5_ on caseinfor0_.case_state_id=paracode5_.id left outer join tb_para_type paratype6_ on paracode5_.type_id=paratype6_.id left outer join tb_para_case_cause paracaseca7_ on caseinfor0_.cause_id=paracaseca7_.id left outer join tb_para_case_cause paracaseca8_ on paracaseca7_.p_id=paracaseca8_.id left outer join tb_org_court court9_ on caseinfor0_.court_id=court9_.id left outer join tb_para_code paracode10_ on court9_.court_level_id=paracode10_.id left outer join tb_para_code paracode11_ on court9_.area_id=paracode11_.id left outer join tb_org_court court12_ on court9_.parent_id=court12_.id left outer join tb_org_undertaker undertaker13_ on caseinfor0_.creater_id=undertaker13_.id left outer join tb_org_court court14_ on undertaker13_.court_id=court14_.id left outer join tb_para_code paracode15_ on undertaker13_.degree_id=paracode15_.id left outer join tb_org_depart depart16_ on undertaker13_.depart_id=depart16_.id left outer join tb_org_court court17_ on depart16_.court_id=court17_.id left outer join tb_para_code paracode18_ on undertaker13_.education_id=paracode18_.id left outer join tb_para_code paracode19_ on undertaker13_.entry_type_id=paracode19_.id left outer join tb_para_code paracode20_ on undertaker13_.executive_id=paracode20_.id left outer join tb_para_code paracode21_ on undertaker13_.folk_id=paracode21_.id left outer join tb_para_code paracode22_ on undertaker13_.judge_job_id=paracode22_.id left outer join tb_para_code paracode23_ on undertaker13_.judge_level_id=paracode23_.id left outer join tb_para_code paracode24_ on undertaker13_.political_id=paracode24_.id left outer join tb_para_code paracode25_ on undertaker13_.profession_level_id=paracode25_.id left outer join tb_para_code paracode26_ on undertaker13_.sex_id=paracode26_.id left outer join tb_para_code paracode27_ on undertaker13_.weave_id=paracode27_.id left outer join tb_para_cause paracause28_ on caseinfor0_.defer_cause_id=paracause28_.id left outer join tb_para_type paratype29_ on paracause28_.type_id=paratype29_.id left outer join tb_org_depart depart30_ on caseinfor0_.depart_id=depart30_.id left outer join tb_para_code paracode31_ on caseinfor0_.foreign_factor_id=paracode31_.id left outer join tb_para_code paracode32_ on caseinfor0_.gist_id=paracode32_.id left outer join tb_exec_end_case endcase33_ on caseinfor0_.id=endcase33_.case_id left outer join tb_org_court court34_ on endcase33_.court_id=court34_.id left outer join tb_para_end_case_mode paraendcas35_ on endcase33_.end_case_mode_id=paraendcas35_.id left outer join tb_para_end_case_mode paraendcas36_ on paraendcas35_.parent_id=paraendcas36_.id left outer join tb_org_undertaker undertaker37_ on endcase33_.undertaker_id=undertaker37_.id where caseinfor0_.id=:1
2trj39sw606qx	select undertaker0_.id as id6_18_, undertaker0_.admin_flag as admin2_6_18_, undertaker0_.bday as bday6_18_, undertaker0_.court_id as court19_6_18_, undertaker0_.degree_id as degree20_6_18_, undertaker0_.del_flag as del4_6_18_, undertaker0_.depart_id as depart21_6_18_, undertaker0_.education_id as education22_6_18_, undertaker0_.email as email6_18_, undertaker0_.enable as enable6_18_, undertaker0_.entry_type_id as entry23_6_18_, undertaker0_.executive_id as executive24_6_18_, undertaker0_.folk_id as folk25_6_18_, undertaker0_.group_list as group7_6_18_, undertaker0_.iname as iname6_18_, undertaker0_.iname_py as iname9_6_18_, undertaker0_.jid as jid6_18_, undertaker0_.judge_job_id as judge26_6_18_, undertaker0_.judge_level_id as judge27_6_18_, undertaker0_.last_login_time as last11_6_18_, undertaker0_.leader_job as leader12_6_18_, undertaker0_.mobile as mobile6_18_, undertaker0_.passwd as passwd6_18_, undertaker0_.phone as phone6_18_, undertaker0_.pid as pid6_18_, undertaker0_.political_id as political28_6_18_, undertaker0_.profession_level_id as profession29_6_18_, undertaker0_.remark as remark6_18_, undertaker0_.sex_id as sex30_6_18_, undertaker0_.ssl_id as ssl18_6_18_, undertaker0_.weave_id as weave31_6_18_, court1_.id as id0_0_, court1_.belong_m as belong2_0_0_, court1_.belong_s as belong3_0_0_, court1_.del_flag as del4_0_0_, court1_.disable_time as disable5_0_0_, court1_.dname as dname0_0_, court1_.enable as enable0_0_, court1_.iname as iname0_0_, court1_.jcode as jcode0_0_, court1_.court_level_id as court13_0_0_, court1_.area_id as area14_0_0_, court1_.parent_id as parent15_0_0_, court1_.reg_time as reg10_0_0_, court1_.sname as sname0_0_, court1_.stdcode as stdcode0_0_, paracode2_.id as id105_1_, paracode2_.attribute as attribute105_1_, paracode2_.attribute1 as attribute3_105_1_, paracode2_.code_name as code4_105_1_, paracode2_.disable_time as disable5_105_1_, paracode2_.enable as enable105_1_, paracode2_.type_id as type8_105_1_, paracode2_.reg_time as reg7_105_1_, paratype3_.id as id109_2_, paratype3_.ori_name as ori2_109_2_, paratype3_.para_name as para3_109_2_, paratype3_.rmks as rmks109_2_, paracode4_.id as id105_3_, paracode4_.attribute as attribute105_3_, paracode4_.attribute1 as attribute3_105_3_, paracode4_.code_name as code4_105_3_, paracode4_.disable_time as disable5_105_3_, paracode4_.enable as enable105_3_, paracode4_.type_id as type8_105_3_, paracode4_.reg_time as reg7_105_3_, court5_.id as id0_4_, court5_.belong_m as belong2_0_4_, court5_.belong_s as belong3_0_4_, court5_.del_flag as del4_0_4_, court5_.disable_time as disable5_0_4_, court5_.dname as dname0_4_, court5_.enable as enable0_4_, court5_.iname as iname0_4_, court5_.jcode as jcode0_4_, court5_.court_level_id as court13_0_4_, court5_.area_id as area14_0_4_, court5_.parent_id as parent15_0_4_, court5_.reg_time as reg10_0_4_, court5_.sname as sname0_4_, court5_.stdcode as stdcode0_4_, paracode6_.id as id105_5_, paracode6_.attribute as attribute105_5_, paracode6_.attribute1 as attribute3_105_5_, paracode6_.code_name as code4_105_5_, paracode6_.disable_time as disable5_105_5_, paracode6_.enable as enable105_5_, paracode6_.type_id as type8_105_5_, paracode6_.reg_time as reg7_105_5_, depart7_.id as id1_6_, depart7_.court_id as court7_1_6_, depart7_.del_flag as del2_1_6_, depart7_.disable_time as disable3_1_6_, depart7_.enable as enable1_6_, depart7_.iname as iname1_6_, depart7_.reg_time as reg6_1_6_, court8_.id as id0_7_, court8_.belong_m as belong2_0_7_, court8_.belong_s as belong3_0_7_, court8_.del_flag as del4_0_7_, court8_.disable_time as disable5_0_7_, court8_.dname as dname0_7_, court8_.enable as enable0_7_, court8_.iname as iname0_7_, court8_.jcode as jcode0_7_, court8_.court_level_id as court13_0_7_, court8_.area_id as area14_0_7_, court8_.parent_id as parent15_0_7_, court8_.reg_time as reg10_0_7_, court8_.sname as sname0_7_, court8_.stdcode as stdcode0_7_, paracode9_.id as id105_8_, paracode9_.attribute as attribute105_8_, paracode9_.attribute1 as attribute3_105_8_, paracode9_.code_name as code4_105_8_, paracode9_.disable_time as disable5_105_8_, paracode9_.enable as enable105_8_, paracode9_.type_id as type8_105_8_, paracode9_.reg_time as reg7_105_8_, paracode10_.id as id105_9_, paracode10_.attribute as attribute105_9_, paracode10_.attribute1 as attribute3_105_9_, paracode10_.code_name as code4_105_9_, paracode10_.disable_time as disable5_105_9_, paracode10_.enable as enable105_9_, paracode10_.type_id as type8_105_9_, paracode10_.reg_time as reg7_105_9_, paracode11_.id as id105_10_, paracode11_.attribute as attribute105_10_, paracode11_.attribute1 as attribute3_105_10_, paracode11_.code_name as code4_105_10_, paracode11_.disable_time as disable5_105_10_, paracode11_.enable as enable105_10_, paracode11_.type_id as type8_105_10_, paracode11_.reg_time as reg7_105_10_, paracode12_.id as id105_11_, paracode12_.attribute as attribute105_11_, paracode12_.attribute1 as attribute3_105_11_, paracode12_.code_name as code4_105_11_, paracode12_.disable_time as disable5_105_11_, paracode12_.enable as enable105_11_, paracode12_.type_id as type8_105_11_, paracode12_.reg_time as reg7_105_11_, paracode13_.id as id105_12_, paracode13_.attribute as attribute105_12_, paracode13_.attribute1 as attribute3_105_12_, paracode13_.code_name as code4_105_12_, paracode13_.disable_time as disable5_105_12_, paracode13_.enable as enable105_12_, paracode13_.type_id as type8_105_12_, paracode13_.reg_time as reg7_105_12_, paracode14_.id as id105_13_, paracode14_.attribute as attribute105_13_, paracode14_.attribute1 as attribute3_105_13_, paracode14_.code_name as code4_105_13_, paracode14_.disable_time as disable5_105_13_, paracode14_.enable as enable105_13_, paracode14_.type_id as type8_105_13_, paracode14_.reg_time as reg7_105_13_, paracode15_.id as id105_14_, paracode15_.attribute as attribute105_14_, paracode15_.attribute1 as attribute3_105_14_, paracode15_.code_name as code4_105_14_, paracode15_.disable_time as disable5_105_14_, paracode15_.enable as enable105_14_, paracode15_.type_id as type8_105_14_, paracode15_.reg_time as reg7_105_14_, paracode16_.id as id105_15_, paracode16_.attribute as attribute105_15_, paracode16_.attribute1 as attribute3_105_15_, paracode16_.code_name as code4_105_15_, paracode16_.disable_time as disable5_105_15_, paracode16_.enable as enable105_15_, paracode16_.type_id as type8_105_15_, paracode16_.reg_time as reg7_105_15_, paracode17_.id as id105_16_, paracode17_.attribute as attribute105_16_, paracode17_.attribute1 as attribute3_105_16_, paracode17_.code_name as code4_105_16_, paracode17_.disable_time as disable5_105_16_, paracode17_.enable as enable105_16_, paracode17_.type_id as type8_105_16_, paracode17_.reg_time as reg7_105_16_, paracode18_.id as id105_17_, paracode18_.attribute as attribute105_17_, paracode18_.attribute1 as attribute3_105_17_, paracode18_.code_name as code4_105_17_, paracode18_.disable_time as disable5_105_17_, paracode18_.enable as enable105_17_, paracode18_.type_id as type8_105_17_, paracode18_.reg_time as reg7_105_17_ from tb_org_undertaker undertaker0_ left outer join tb_org_court court1_ on undertaker0_.court_id=court1_.id left outer join tb_para_code paracode2_ on court1_.court_level_id=paracode2_.id left outer join tb_para_type paratype3_ on paracode2_.type_id=paratype3_.id left outer join tb_para_code paracode4_ on court1_.area_id=paracode4_.id left outer join tb_org_court court5_ on court1_.parent_id=court5_.id left outer join tb_para_code paracode6_ on undertaker0_.degree_id=paracode6_.id left outer join tb_org_depart depart7_ on undertaker0_.depart_id=depart7_.id left outer join tb_org_court court8_ on depart7_.court_id=court8_.id left outer join tb_para_code paracode9_ on undertaker0_.education_id=paracode9_.id left outer join tb_para_code paracode10_ o n undertaker0_.entry_type_id=paracode10_.id left outer join tb_para_code paracode11_ on undertaker0_.executive_id=paracode11_.id left outer join tb_para_code paracode12_ on undertaker0_.folk_id=paracode12_.id left outer join tb_para_code paracode13_ on undertaker0_.judge_job_id=paracode13_.id left outer join tb_para_code paracode14_ on undertaker0_.judge_level_id=paracode14_.id left outer join tb_para_code paracode15_ on undertaker0_.political_id=paracode15_.id left outer join tb_para_code paracode16_ on undertaker0_.profession_level_id=paracode16_.id left outer join tb_para_code paracode17_ on undertaker0_.sex_id=paracode17_.id left outer join tb_para_code paracode18_ on undertaker0_.weave_id=paracode18_.id where undertaker0_.id=:1
2y41pruxb092p	delete from tb_case_party where id=:1
317v5hnvvd49h	UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3s9hykfwmf41p	insert into tb_case_party (add_cause, address, business_entity, card_number, case_id, parent_id, change_date, disable_cause, disable_date, enable, iname, job, now_address, card_type_id, nationality_id, person_identity_id, person_spc_id, suit_identity_id, type_id, unit_identity_id, unit_kind_id, reg_date, remark, telephone, the_action, the_money, the_res, the_rights, undertaker_id, where_employ, id) 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 )
3zvuca8fc7w33	SELECT userid, roleid FROM ralasafe_ralasafe_userrole WHERE userid=:1
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
459j924bfnwq9	select /*+ all_rows */ count(1) from "ZHIXING"."TB_EXEC_STH_MANAGE" where "PARTY_ID" = :1
4awx3qv79s2m6	select * from ( select row_.*, rownum rownum_ from ( select i.ID , i.REG_DATE , pc.CODE_NAME , pa.iname, i.CASE_CODE, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID left join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.court_id = :1 and ( i.CASE_STATE_ID = 600 or i.CASE_STATE_ID = 601 or i.CASE_STATE_ID = 602) and exists (select u.UNDERTAKER_ID from tb_case_undertaker u where u.CASE_ID = i.id and u.UNDERTAKER_ID = :2 ) and i.IS_DELETED = 0 order by i.ID desc ) row_ where rownum <= 11) where rownum_ >= 1
4m6kp0ycyq2av	select * from ( select row_.*, rownum rownum_ from ( select t.id, t.title as title, l.location_name, t.reg_time as regtime, t.info_flag as infoflag, u.INAME from tb_news_article t join tb_news_location l on l.id = t.main_location join tb_org_undertaker u on u.id =t.ARTICLE_CEATOR_ID join tb_news_article_location a on a.ARTICLE_ID = t.id where t.info_flag=10 and a.LOCATION_ID=:1 and ((t.distribute_area = 1 and distribute_court = :2 ) or (t.distribute_area = 2 and distribute_court in (select d.id from tb_org_court d start with d.id = :3 connect by prior d.parent_id = d.id))) order by t.REG_TIME desc ) row_ where rownum <= 10) where rownum_ >= 1
4sts2w43rb2z8	select * from ( select row_.*, rownum rownum_ from ( select i.ID, i.REG_DATE regDate, pc.CODE_NAME, pa.iname, i.CASE_CODE, (select LISTAGG(p1.INAME, ', ')WITHIN GROUP(order by p1.ID)from tb_case_party p1 where p1.CASE_ID=i.id and p1.SUIT_IDENTITY_ID=570)proposer, (select LISTAGG(p2.INAME, ', ')WITHIN GROUP(order by p2.ID)from tb_case_party p2 where p2.CASE_ID=i.id and p2.SUIT_IDENTITY_ID=571)party from tb_case_infor i join TB_PARA_CODE pc on pc.ID=i.CASE_STATE_ID left join tb_para_case_cause pa on pa.id=i.CAUSE_ID where i.court_id=:1 and i.creater_id=:2 and i.IS_DELETED=0 order by i.CASE_CODE desc ) row_ where rownum <= 15) where rownum_ >= 1
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :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)
4x2xjs7bx3498	select count(*) count from RALASAFE_RALASAFE_USERROLE where USERID=:1 and ROLEID=146
4yhy7w1ak64j8	select * from ( select row_.*, rownum rownum_ from ( select i.ID, i.REG_DATE regDate, pc.CODE_NAME, pa.iname, i.CASE_CODE, (select LISTAGG(p1.INAME, ', ')WITHIN GROUP(order by p1.ID)from tb_case_party p1 where p1.CASE_ID=i.id and p1.SUIT_IDENTITY_ID=570)proposer, (select LISTAGG(p2.INAME, ', ')WITHIN GROUP(order by p2.ID)from tb_case_party p2 where p2.CASE_ID=i.id and p2.SUIT_IDENTITY_ID=571)party from tb_case_infor i join TB_PARA_CODE pc on pc.ID=i.CASE_STATE_ID left join tb_para_case_cause pa on pa.id=i.CAUSE_ID where i.court_id=:1 and i.creater_id=:2 and i.IS_DELETED=0 order by i.CASE_CODE desc ) row_ where rownum <= 12) where rownum_ >= 1
4zstnh94x5fsq	select S_TB_SYSTEM_LOG.nextval from dual
51p3qxf0r2c65	update tb_case_infor set apply_action=:1 , apply_money=:2 , apply_res=:3 , apply_rights=:4 , auto_exec_money=:5 , case_code=:6 , case_kind_id=:7 , kind_cause_id=:8 , case_src_id=:9 , case_state_id=:10 , cause_id=:11 , court_id=:12 , create_time=:13 , creater_id=:14 , defer_begin_date=:15 , defer_cause_id=:16 , defer_days=:17 , defer_end_date=:18 , depart_id=:19 , exec_incept_date=:20 , execed_action=:21 , execed_money=:22 , execed_rights=:23 , execed_res=:24 , foreign_factor_id=:25 , gist_id=:26 , gist_cid=:27 , gist_content=:28 , gist_date=:29 , gist_term=:30 , gist_unit=:31 , is_deleted=:32 , is_report=:33 , last_update_time=:34 , maturity_date=:35 , parent_case_code=:36 , parent_court=:37 , reg_date=:38 , remark=:39 , root_id=:40 , state_end_date=:41 , state_update_time=:42 , will_expense=:43 where id=:44
5633bm2cwvy54	select * from ( select row_.*, rownum rownum_ from ( select i.ID , i.REG_DATE , pc.CODE_NAME , pa.iname, i.CASE_CODE, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID left join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.court_id = :1 and ( i.CASE_STATE_ID = 600 or i.CASE_STATE_ID = 601 or i.CASE_STATE_ID = 602) and exists (select u.UNDERTAKER_ID from tb_case_undertaker u where u.CASE_ID = i.id and u.UNDERTAKER_ID = :2 ) and i.IS_DELETED = 0 order by i.ID desc ) row_ where rownum <= 16) where rownum_ >= 1
5fzf5v9v3a5rs	insert into tb_case_infor (apply_action, apply_money, apply_res, apply_rights, auto_exec_money, case_code, case_kind_id, kind_cause_id, case_src_id, case_state_id, cause_id, court_id, create_time, creater_id, defer_begin_date, defer_cause_id, defer_days, defer_end_date, depart_id, exec_incept_date, execed_action, execed_money, execed_rights, execed_res, foreign_factor_id, gist_id, gist_cid, gist_content, gist_date, gist_term, gist_unit, is_deleted, is_report, last_update_time, maturity_date, parent_case_code, parent_court, reg_date, remark, root_id, state_end_date, state_update_time, will_expense, id) 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 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 )
5p5jkbg1ct45v	select * from ( select row_.*, rownum rownum_ from ( SELECT S.ID AS ID, S.TITLE AS TITLE, S.ADDRESSEE AS ADDR, S.SERVICE_TIME AS S_TIME FROM TB_EXEC_SERVICE S WHERE S.CASE_ID=:1 order by S_TIME desc ) row_ where rownum <= 16) where rownum_ >= 1
5tgxh0qcrxrd5	select * from ( select row_.*, rownum rownum_ from ( select i.ID , i.REG_DATE , pc.CODE_NAME , pa.iname, i.CASE_CODE, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID left join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.court_id = :1 and ( i.CASE_STATE_ID = 600 or i.CASE_STATE_ID = 601 or i.CASE_STATE_ID = 602) and exists (select u.UNDERTAKER_ID from tb_case_undertaker u where u.CASE_ID = i.id and u.UNDERTAKER_ID = :2 ) and i.IS_DELETED = 0 order by i.ID desc ) row_ where rownum <= 10) where rownum_ >= 1
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5y40rg0vq1bk3	select * from ( select row_.*, rownum rownum_ from ( SELECT S.ID AS ID, S.TITLE AS TITLE, S.ADDRESSEE AS ADDR, S.SERVICE_TIME AS S_TIME FROM TB_EXEC_SERVICE S WHERE S.CASE_ID=:1 order by S_TIME desc ) row_ where rownum <= 6) where rownum_ >= 1
60gtyduhr8nx4	select count(1) num from tb_case_assets ca left join (select p.ID, p.INAME from tb_case_party p) cp on cp.id = ca.id left join (select c.id , c.case_code from tb_case_infor c ) ci on ci.id = ca.case_id where status_id = 993 and exists( select cu.CASE_ID from tb_case_undertaker cu where cu.UNDERTAKER_ID = :1 and cu.CASE_ID = ci.id) and ceil((status_end_date - sysdate)) >= 0 and ceil((status_end_date - sysdate)) <= (select attribute from tb_para_code where id = 1263)
67nwttkjzv2pb	select * from ( select row_.*, rownum rownum_ from ( select i.id, i.CASE_CODE, i.REG_DATE regDate, pc.CODE_NAME , pa.iname, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.COURT_ID = :1 and i.IS_DELETED = 0 and exists(select u.UNDERTAKER_ID from tb_case_undertaker u where u.CASE_ID = i.id and u.UNDERTAKER_ID = :2 ) order by i.CASE_CODE desc ) row_ where rownum <= 14) where rownum_ >= 1
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
76rhd5qjq6nu4	SELECT COUNT(*) FROM ( select count(*) endCaseNum from tb_exec_end_case e where e.court_id = :1 and to_char(e.end_case_date, 'yyyyMM') <= :2 and to_char(e.end_case_date, 'yyyyMM') >=:3 ) ralasafe_
779260wyp34bq	select count(*) as col_0_0_ from tb_case_infor_gist_unit casegistun0_ where casegistun0_.court_id=:1 and casegistun0_.gist_unit=:2
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
82fgxn0zn4zg4	select * from ( select row_.*, rownum rownum_ from ( select i.id, i.CASE_CODE, i.REG_DATE regDate, pc.CODE_NAME , pa.iname, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.COURT_ID = :1 and i.IS_DELETED = 0 and exists(select u.UNDERTAKER_ID from tb_case_undertaker u where u.CASE_ID = i.id and u.UNDERTAKER_ID = :2 ) order by i.CASE_CODE desc ) row_ where rownum <= 15) where rownum_ >= 1
8arftf864h9mn	select * from ( select row_.*, rownum rownum_ from ( select i.ID, i.REG_DATE regDate, pc.CODE_NAME, pa.iname, i.CASE_CODE, (select LISTAGG(p1.INAME, ', ')WITHIN GROUP(order by p1.ID)from tb_case_party p1 where p1.CASE_ID=i.id and p1.SUIT_IDENTITY_ID=570)proposer, (select LISTAGG(p2.INAME, ', ')WITHIN GROUP(order by p2.ID)from tb_case_party p2 where p2.CASE_ID=i.id and p2.SUIT_IDENTITY_ID=571)party from tb_case_infor i join TB_PARA_CODE pc on pc.ID=i.CASE_STATE_ID left join tb_para_case_cause pa on pa.id=i.CAUSE_ID where i.court_id=:1 and i.creater_id=:2 and i.IS_DELETED=0 order by i.CASE_CODE desc ) row_ where rownum <= 14) where rownum_ >= 1
8y2g4249ypfsh	select count(*) acceptTotal , to_char(t.reg_date, 'yyyy-MM') emonth from tb_case_infor t where t.creater_id=:1 and t.reg_date >=to_date(:2 , 'yyyy-MM-dd') and t.reg_date <=to_date(:3 , 'yyyy-MM-dd') group by to_char(t.reg_date, 'yyyy-MM')
90jssw9bhmurx	select * from ( select row_.*, rownum rownum_ from ( select i.ID, i.REG_DATE regDate, pc.CODE_NAME, pa.iname, i.CASE_CODE, (select LISTAGG(p1.INAME, ', ')WITHIN GROUP(order by p1.ID)from tb_case_party p1 where p1.CASE_ID=i.id and p1.SUIT_IDENTITY_ID=570)proposer, (select LISTAGG(p2.INAME, ', ')WITHIN GROUP(order by p2.ID)from tb_case_party p2 where p2.CASE_ID=i.id and p2.SUIT_IDENTITY_ID=571)party from tb_case_infor i join TB_PARA_CODE pc on pc.ID=i.CASE_STATE_ID left join tb_para_case_cause pa on pa.id=i.CAUSE_ID where i.court_id=:1 and i.creater_id=:2 and i.IS_DELETED=0 order by i.CASE_CODE desc ) row_ where rownum <= 10) where rownum_ >= 1
962fnqgbrky6j	select * from ( select row_.*, rownum rownum_ from ( select i.ID , i.REG_DATE , pc.CODE_NAME , pa.iname, i.CASE_CODE, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID left join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.court_id = :1 and ( i.CASE_STATE_ID = 600 or i.CASE_STATE_ID = 601 or i.CASE_STATE_ID = 602) and exists (select u.UNDERTAKER_ID from tb_case_undertaker u where u.CASE_ID = i.id and u.UNDERTAKER_ID = :2 ) and i.IS_DELETED = 0 order by i.ID desc ) row_ where rownum <= 30) where rownum_ >= 16
a1kg1b6q99rk4	select count(*) atelicNum from tb_case_infor t where court_id=:1 and to_char(t.reg_date, 'yyyyMM') >= :2 and to_char(t.reg_date, 'yyyyMM') <= :3 and t.case_state_id != 608
ah59uvrxqu5cd	select * from ( select row_.*, rownum rownum_ from ( select i.ID, i.REG_DATE regDate, pc.CODE_NAME, pa.iname, i.CASE_CODE, (select LISTAGG(p1.INAME, ', ')WITHIN GROUP(order by p1.ID)from tb_case_party p1 where p1.CASE_ID=i.id and p1.SUIT_IDENTITY_ID=570)proposer, (select LISTAGG(p2.INAME, ', ')WITHIN GROUP(order by p2.ID)from tb_case_party p2 where p2.CASE_ID=i.id and p2.SUIT_IDENTITY_ID=571)party from tb_case_infor i join TB_PARA_CODE pc on pc.ID=i.CASE_STATE_ID left join tb_para_case_cause pa on pa.id=i.CAUSE_ID where i.court_id=:1 and i.creater_id=:2 and i.IS_DELETED=0 order by i.CASE_CODE desc ) row_ where rownum <= 9) where rownum_ >= 1
b1kqnwa1whfv7	select undertaker0_.case_id as case1_19_, undertaker0_.undertaker_id as undertaker2_19_, undertaker1_.id as id6_0_, undertaker1_.admin_flag as admin2_6_0_, undertaker1_.bday as bday6_0_, undertaker1_.court_id as court19_6_0_, undertaker1_.degree_id as degree20_6_0_, undertaker1_.del_flag as del4_6_0_, undertaker1_.depart_id as depart21_6_0_, undertaker1_.education_id as education22_6_0_, undertaker1_.email as email6_0_, undertaker1_.enable as enable6_0_, undertaker1_.entry_type_id as entry23_6_0_, undertaker1_.executive_id as executive24_6_0_, undertaker1_.folk_id as folk25_6_0_, undertaker1_.group_list as group7_6_0_, undertaker1_.iname as iname6_0_, undertaker1_.iname_py as iname9_6_0_, undertaker1_.jid as jid6_0_, undertaker1_.judge_job_id as judge26_6_0_, undertaker1_.judge_level_id as judge27_6_0_, undertaker1_.last_login_time as last11_6_0_, undertaker1_.leader_job as leader12_6_0_, undertaker1_.mobile as mobile6_0_, undertaker1_.passwd as passwd6_0_, undertaker1_.phone as phone6_0_, undertaker1_.pid as pid6_0_, undertaker1_.political_id as political28_6_0_, undertaker1_.profession_level_id as profession29_6_0_, undertaker1_.remark as remark6_0_, undertaker1_.sex_id as sex30_6_0_, undertaker1_.ssl_id as ssl18_6_0_, undertaker1_.weave_id as weave31_6_0_, court2_.id as id0_1_, court2_.belong_m as belong2_0_1_, court2_.belong_s as belong3_0_1_, court2_.del_flag as del4_0_1_, court2_.disable_time as disable5_0_1_, court2_.dname as dname0_1_, court2_.enable as enable0_1_, court2_.iname as iname0_1_, court2_.jcode as jcode0_1_, court2_.court_level_id as court13_0_1_, court2_.area_id as area14_0_1_, court2_.parent_id as parent15_0_1_, court2_.reg_time as reg10_0_1_, court2_.sname as sname0_1_, court2_.stdcode as stdcode0_1_, paracode3_.id as id105_2_, paracode3_.attribute as attribute105_2_, paracode3_.attribute1 as attribute3_105_2_, paracode3_.code_name as code4_105_2_, paracode3_.disable_time as disable5_105_2_, paracode3_.enable as enable105_2_, paracode3_.type_id as type8_105_2_, paracode3_.reg_time as reg7_105_2_, paratype4_.id as id109_3_, paratype4_.ori_name as ori2_109_3_, paratype4_.para_name as para3_109_3_, paratype4_.rmks as rmks109_3_, paracode5_.id as id105_4_, paracode5_.attribute as attribute105_4_, paracode5_.attribute1 as attribute3_105_4_, paracode5_.code_name as code4_105_4_, paracode5_.disable_time as disable5_105_4_, paracode5_.enable as enable105_4_, paracode5_.type_id as type8_105_4_, paracode5_.reg_time as reg7_105_4_, court6_.id as id0_5_, court6_.belong_m as belong2_0_5_, court6_.belong_s as belong3_0_5_, court6_.del_flag as del4_0_5_, court6_.disable_time as disable5_0_5_, court6_.dname as dname0_5_, court6_.enable as enable0_5_, court6_.iname as iname0_5_, court6_.jcode as jcode0_5_, court6_.court_level_id as court13_0_5_, court6_.area_id as area14_0_5_, court6_.parent_id as parent15_0_5_, court6_.reg_time as reg10_0_5_, court6_.sname as sname0_5_, court6_.stdcode as stdcode0_5_, paracode7_.id as id105_6_, paracode7_.attribute as attribute105_6_, paracode7_.attribute1 as attribute3_105_6_, paracode7_.code_name as code4_105_6_, paracode7_.disable_time as disable5_105_6_, paracode7_.enable as enable105_6_, paracode7_.type_id as type8_105_6_, paracode7_.reg_time as reg7_105_6_, depart8_.id as id1_7_, depart8_.court_id as court7_1_7_, depart8_.del_flag as del2_1_7_, depart8_.disable_time as disable3_1_7_, depart8_.enable as enable1_7_, depart8_.iname as iname1_7_, depart8_.reg_time as reg6_1_7_, court9_.id as id0_8_, court9_.belong_m as belong2_0_8_, court9_.belong_s as belong3_0_8_, court9_.del_flag as del4_0_8_, court9_.disable_time as disable5_0_8_, court9_.dname as dname0_8_, court9_.enable as enable0_8_, court9_.iname as iname0_8_, court9_.jcode as jcode0_8_, court9_.court_level_id as court13_0_8_, court9_.area_id as area14_0_8_, court9_.parent_id as parent15_0_8_, court9_.reg_time as reg1 0_0_8_, court9_.sname as sname0_8_, court9_.stdcode as stdcode0_8_, paracode10_.id as id105_9_, paracode10_.attribute as attribute105_9_, paracode10_.attribute1 as attribute3_105_9_, paracode10_.code_name as code4_105_9_, paracode10_.disable_time as disable5_105_9_, paracode10_.enable as enable105_9_, paracode10_.type_id as type8_105_9_, paracode10_.reg_time as reg7_105_9_, paracode11_.id as id105_10_, paracode11_.attribute as attribute105_10_, paracode11_.attribute1 as attribute3_105_10_, paracode11_.code_name as code4_105_10_, paracode11_.disable_time as disable5_105_10_, paracode11_.enable as enable105_10_, paracode11_.type_id as type8_105_10_, paracode11_.reg_time as reg7_105_10_, paracode12_.id as id105_11_, paracode12_.attribute as attribute105_11_, paracode12_.attribute1 as attribute3_105_11_, paracode12_.code_name as code4_105_11_, paracode12_.disable_time as disable5_105_11_, paracode12_.enable as enable105_11_, paracode12_.type_id as type8_105_11_, paracode12_.reg_time as reg7_105_11_, paracode13_.id as id105_12_, paracode13_.attribute as attribute105_12_, paracode13_.attribute1 as attribute3_105_12_, paracode13_.code_name as code4_105_12_, paracode13_.disable_time as disable5_105_12_, paracode13_.enable as enable105_12_, paracode13_.type_id as type8_105_12_, paracode13_.reg_time as reg7_105_12_, paracode14_.id as id105_13_, paracode14_.attribute as attribute105_13_, paracode14_.attribute1 as attribute3_105_13_, paracode14_.code_name as code4_105_13_, paracode14_.disable_time as disable5_105_13_, paracode14_.enable as enable105_13_, paracode14_.type_id as type8_105_13_, paracode14_.reg_time as reg7_105_13_, paracode15_.id as id105_14_, paracode15_.attribute as attribute105_14_, paracode15_.attribute1 as attribute3_105_14_, paracode15_.code_name as code4_105_14_, paracode15_.disable_time as disable5_105_14_, paracode15_.enable as enable105_14_, paracode15_.type_id as type8_105_14_, paracode15_.reg_time as reg7_105_14_, paracode16_.id as id105_15_, paracode16_.attribute as attribute105_15_, paracode16_.attribute1 as attribute3_105_15_, paracode16_.code_name as code4_105_15_, paracode16_.disable_time as disable5_105_15_, paracode16_.enable as enable105_15_, paracode16_.type_id as type8_105_15_, paracode16_.reg_time as reg7_105_15_, paracode17_.id as id105_16_, paracode17_.attribute as attribute105_16_, paracode17_.attribute1 as attribute3_105_16_, paracode17_.code_name as code4_105_16_, paracode17_.disable_time as disable5_105_16_, paracode17_.enable as enable105_16_, paracode17_.type_id as type8_105_16_, paracode17_.reg_time as reg7_105_16_, paracode18_.id as id105_17_, paracode18_.attribute as attribute105_17_, paracode18_.attribute1 as attribute3_105_17_, paracode18_.code_name as code4_105_17_, paracode18_.disable_time as disable5_105_17_, paracode18_.enable as enable105_17_, paracode18_.type_id as type8_105_17_, paracode18_.reg_time as reg7_105_17_, paracode19_.id as id105_18_, paracode19_.attribute as attribute105_18_, paracode19_.attribute1 as attribute3_105_18_, paracode19_.code_name as code4_105_18_, paracode19_.disable_time as disable5_105_18_, paracode19_.enable as enable105_18_, paracode19_.type_id as type8_105_18_, paracode19_.reg_time as reg7_105_18_ from tb_case_undertaker undertaker0_ left outer join tb_org_undertaker undertaker1_ on undertaker0_.undertaker_id=undertaker1_.id left outer join tb_org_court court2_ on undertaker1_.court_id=court2_.id left outer join tb_para_code paracode3_ on court2_.court_level_id=paracode3_.id left outer join tb_para_type paratype4_ on paracode3_.type_id=paratype4_.id left outer join tb_para_code paracode5_ on court2_.area_id=paracode5_.id left outer join tb_org_court court6_ on court2_.parent_id=court6_.id left outer join tb_para_code paracode7_ on undertaker1_.degree_id=paracode7_.id left outer join tb_org_depart depart8_ on undertaker1_.depart_id=depart8_.id left outer join tb_org_court co urt9_ on depart8_.court_id=court9_.id left outer join tb_para_code paracode10_ on undertaker1_.education_id=paracode10_.id left outer join tb_para_code paracode11_ on undertaker1_.entry_type_id=paracode11_.id left outer join tb_para_code paracode12_ on undertaker1_.executive_id=paracode12_.id left outer join tb_para_code paracode13_ on undertaker1_.folk_id=paracode13_.id left outer join tb_para_code paracode14_ on undertaker1_.judge_job_id=paracode14_.id left outer join tb_para_code paracode15_ on undertaker1_.judge_level_id=paracode15_.id left outer join tb_para_code paracode16_ on undertaker1_.political_id=paracode16_.id left outer join tb_para_code paracode17_ on undertaker1_.profession_level_id=paracode17_.id left outer join tb_para_code paracode18_ on undertaker1_.sex_id=paracode18_.id left outer join tb_para_code paracode19_ on undertaker1_.weave_id=paracode19_.id where undertaker0_.case_id=:1
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
b4r9vvw077nvz	select count(*) count from tb_exec_end_case i where i.COURT_ID = :1 and (i.END_CASE_MODE_ID = 2 or i.END_CASE_MODE_ID = 4 or i.END_CASE_MODE_ID = 18 or i.END_CASE_MODE_ID = 12 or i.END_CASE_MODE_ID = 13) and to_char(i.END_CASE_DATE, 'yyyyMM') <= :2 and to_char(i.END_CASE_DATE, 'yyyyMM') >= :3
bmdkzhg840awx	select paracourtk0_.id as id106_20_, paracourtk0_.court_id as court7_106_20_, paracourtk0_.court_case_kind as court2_106_20_, paracourtk0_.disable_time as disable3_106_20_, paracourtk0_.enable as enable106_20_, paracourtk0_.is_report as is5_106_20_, paracourtk0_.reg_time as reg6_106_20_, paracourtk0_.undertaker_id as undertaker8_106_20_, court1_.id as id0_0_, court1_.belong_m as belong2_0_0_, court1_.belong_s as belong3_0_0_, court1_.del_flag as del4_0_0_, court1_.disable_time as disable5_0_0_, court1_.dname as dname0_0_, court1_.enable as enable0_0_, court1_.iname as iname0_0_, court1_.jcode as jcode0_0_, court1_.court_level_id as court13_0_0_, court1_.area_id as area14_0_0_, court1_.parent_id as parent15_0_0_, court1_.reg_time as reg10_0_0_, court1_.sname as sname0_0_, court1_.stdcode as stdcode0_0_, paracode2_.id as id105_1_, paracode2_.attribute as attribute105_1_, paracode2_.attribute1 as attribute3_105_1_, paracode2_.code_name as code4_105_1_, paracode2_.disable_time as disable5_105_1_, paracode2_.enable as enable105_1_, paracode2_.type_id as type8_105_1_, paracode2_.reg_time as reg7_105_1_, paratype3_.id as id109_2_, paratype3_.ori_name as ori2_109_2_, paratype3_.para_name as para3_109_2_, paratype3_.rmks as rmks109_2_, paracode4_.id as id105_3_, paracode4_.attribute as attribute105_3_, paracode4_.attribute1 as attribute3_105_3_, paracode4_.code_name as code4_105_3_, paracode4_.disable_time as disable5_105_3_, paracode4_.enable as enable105_3_, paracode4_.type_id as type8_105_3_, paracode4_.reg_time as reg7_105_3_, court5_.id as id0_4_, court5_.belong_m as belong2_0_4_, court5_.belong_s as belong3_0_4_, court5_.del_flag as del4_0_4_, court5_.disable_time as disable5_0_4_, court5_.dname as dname0_4_, court5_.enable as enable0_4_, court5_.iname as iname0_4_, court5_.jcode as jcode0_4_, court5_.court_level_id as court13_0_4_, court5_.area_id as area14_0_4_, court5_.parent_id as parent15_0_4_, court5_.reg_time as reg10_0_4_, court5_.sname as sname0_4_, court5_.stdcode as stdcode0_4_, undertaker6_.id as id6_5_, undertaker6_.admin_flag as admin2_6_5_, undertaker6_.bday as bday6_5_, undertaker6_.court_id as court19_6_5_, undertaker6_.degree_id as degree20_6_5_, undertaker6_.del_flag as del4_6_5_, undertaker6_.depart_id as depart21_6_5_, undertaker6_.education_id as education22_6_5_, undertaker6_.email as email6_5_, undertaker6_.enable as enable6_5_, undertaker6_.entry_type_id as entry23_6_5_, undertaker6_.executive_id as executive24_6_5_, undertaker6_.folk_id as folk25_6_5_, undertaker6_.group_list as group7_6_5_, undertaker6_.iname as iname6_5_, undertaker6_.iname_py as iname9_6_5_, undertaker6_.jid as jid6_5_, undertaker6_.judge_job_id as judge26_6_5_, undertaker6_.judge_level_id as judge27_6_5_, undertaker6_.last_login_time as last11_6_5_, undertaker6_.leader_job as leader12_6_5_, undertaker6_.mobile as mobile6_5_, undertaker6_.passwd as passwd6_5_, undertaker6_.phone as phone6_5_, undertaker6_.pid as pid6_5_, undertaker6_.political_id as political28_6_5_, undertaker6_.profession_level_id as profession29_6_5_, undertaker6_.remark as remark6_5_, undertaker6_.sex_id as sex30_6_5_, undertaker6_.ssl_id as ssl18_6_5_, undertaker6_.weave_id as weave31_6_5_, court7_.id as id0_6_, court7_.belong_m as belong2_0_6_, court7_.belong_s as belong3_0_6_, court7_.del_flag as del4_0_6_, court7_.disable_time as disable5_0_6_, court7_.dname as dname0_6_, court7_.enable as enable0_6_, court7_.iname as iname0_6_, court7_.jcode as jcode0_6_, court7_.court_level_id as court13_0_6_, court7_.area_id as area14_0_6_, court7_.parent_id as parent15_0_6_, court7_.reg_time as reg10_0_6_, court7_.sname as sname0_6_, court7_.stdcode as stdcode0_6_, paracode8_.id as id105_7_, paracode8_.attribute as attribute105_7_, paracode8_.attribute1 as attribute3_105_7_, paracode8_.code_name as code4_105_7_, paracode8_.disable_time as disable5_105_7_, paracode8_ .enable as enable105_7_, paracode8_.type_id as type8_105_7_, paracode8_.reg_time as reg7_105_7_, depart9_.id as id1_8_, depart9_.court_id as court7_1_8_, depart9_.del_flag as del2_1_8_, depart9_.disable_time as disable3_1_8_, depart9_.enable as enable1_8_, depart9_.iname as iname1_8_, depart9_.reg_time as reg6_1_8_, court10_.id as id0_9_, court10_.belong_m as belong2_0_9_, court10_.belong_s as belong3_0_9_, court10_.del_flag as del4_0_9_, court10_.disable_time as disable5_0_9_, court10_.dname as dname0_9_, court10_.enable as enable0_9_, court10_.iname as iname0_9_, court10_.jcode as jcode0_9_, court10_.court_level_id as court13_0_9_, court10_.area_id as area14_0_9_, court10_.parent_id as parent15_0_9_, court10_.reg_time as reg10_0_9_, court10_.sname as sname0_9_, court10_.stdcode as stdcode0_9_, paracode11_.id as id105_10_, paracode11_.attribute as attribute105_10_, paracode11_.attribute1 as attribute3_105_10_, paracode11_.code_name as code4_105_10_, paracode11_.disable_time as disable5_105_10_, paracode11_.enable as enable105_10_, paracode11_.type_id as type8_105_10_, paracode11_.reg_time as reg7_105_10_, paracode12_.id as id105_11_, paracode12_.attribute as attribute105_11_, paracode12_.attribute1 as attribute3_105_11_, paracode12_.code_name as code4_105_11_, paracode12_.disable_time as disable5_105_11_, paracode12_.enable as enable105_11_, paracode12_.type_id as type8_105_11_, paracode12_.reg_time as reg7_105_11_, paracode13_.id as id105_12_, paracode13_.attribute as attribute105_12_, paracode13_.attribute1 as attribute3_105_12_, paracode13_.code_name as code4_105_12_, paracode13_.disable_time as disable5_105_12_, paracode13_.enable as enable105_12_, paracode13_.type_id as type8_105_12_, paracode13_.reg_time as reg7_105_12_, paracode14_.id as id105_13_, paracode14_.attribute as attribute105_13_, paracode14_.attribute1 as attribute3_105_13_, paracode14_.code_name as code4_105_13_, paracode14_.disable_time as disable5_105_13_, paracode14_.enable as enable105_13_, paracode14_.type_id as type8_105_13_, paracode14_.reg_time as reg7_105_13_, paracode15_.id as id105_14_, paracode15_.attribute as attribute105_14_, paracode15_.attribute1 as attribute3_105_14_, paracode15_.code_name as code4_105_14_, paracode15_.disable_time as disable5_105_14_, paracode15_.enable as enable105_14_, paracode15_.type_id as type8_105_14_, paracode15_.reg_time as reg7_105_14_, paracode16_.id as id105_15_, paracode16_.attribute as attribute105_15_, paracode16_.attribute1 as attribute3_105_15_, paracode16_.code_name as code4_105_15_, paracode16_.disable_time as disable5_105_15_, paracode16_.enable as enable105_15_, paracode16_.type_id as type8_105_15_, paracode16_.reg_time as reg7_105_15_, paracode17_.id as id105_16_, paracode17_.attribute as attribute105_16_, paracode17_.attribute1 as attribute3_105_16_, paracode17_.code_name as code4_105_16_, paracode17_.disable_time as disable5_105_16_, paracode17_.enable as enable105_16_, paracode17_.type_id as type8_105_16_, paracode17_.reg_time as reg7_105_16_, paracode18_.id as id105_17_, paracode18_.attribute as attribute105_17_, paracode18_.attribute1 as attribute3_105_17_, paracode18_.code_name as code4_105_17_, paracode18_.disable_time as disable5_105_17_, paracode18_.enable as enable105_17_, paracode18_.type_id as type8_105_17_, paracode18_.reg_time as reg7_105_17_, paracode19_.id as id105_18_, paracode19_.attribute as attribute105_18_, paracode19_.attribute1 as attribute3_105_18_, paracode19_.code_name as code4_105_18_, paracode19_.disable_time as disable5_105_18_, paracode19_.enable as enable105_18_, paracode19_.type_id as type8_105_18_, paracode19_.reg_time as reg7_105_18_, paracode20_.id as id105_19_, paracode20_.attribute as attribute105_19_, paracode20_.attribute1 as attribute3_105_19_, paracode20_.code_name as code4_105_19_, paracode20_.disable_time as disable5_105_19_, paracode20_.enable as enable105_19 _, paracode20_.type_id as type8_105_19_, paracode20_.reg_time as reg7_105_19_ from tb_para_court_kind paracourtk0_ left outer join tb_org_court court1_ on paracourtk0_.court_id=court1_.id left outer join tb_para_code paracode2_ on court1_.court_level_id=paracode2_.id left outer join tb_para_type paratype3_ on paracode2_.type_id=paratype3_.id left outer join tb_para_code paracode4_ on court1_.area_id=paracode4_.id left outer join tb_org_court court5_ on court1_.parent_id=court5_.id left outer join tb_org_undertaker undertaker6_ on paracourtk0_.undertaker_id=undertaker6_.id left outer join tb_org_court court7_ on undertaker6_.court_id=court7_.id left outer join tb_para_code paracode8_ on undertaker6_.degree_id=paracode8_.id left outer join tb_org_depart depart9_ on undertaker6_.depart_id=depart9_.id left outer join tb_org_court court10_ on depart9_.court_id=court10_.id left outer join tb_para_code paracode11_ on undertaker6_.education_id=paracode11_.id left outer join tb_para_code paracode12_ on undertaker6_.entry_type_id=paracode12_.id left outer join tb_para_code paracode13_ on undertaker6_.executive_id=paracode13_.id left outer join tb_para_code paracode14_ on undertaker6_.folk_id=paracode14_.id left outer join tb_para_code paracode15_ on undertaker6_.judge_job_id=paracode15_.id left outer join tb_para_code paracode16_ on undertaker6_.judge_level_id=paracode16_.id left outer join tb_para_code paracode17_ on undertaker6_.political_id=paracode17_.id left outer join tb_para_code paracode18_ on undertaker6_.profession_level_id=paracode18_.id left outer join tb_para_code paracode19_ on undertaker6_.sex_id=paracode19_.id left outer join tb_para_code paracode20_ on undertaker6_.weave_id=paracode20_.id where paracourtk0_.id=:1
bmus8kmmq91sj	select * from ( select row_.*, rownum rownum_ from ( select i.id, i.CASE_CODE, i.REG_DATE regDate, pc.CODE_NAME , pa.iname, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.COURT_ID = :1 and i.IS_DELETED = 0 order by i.CASE_CODE desc ) row_ where rownum <= 238) where rownum_ >= 222
c0zfqkhbm2p3w	select * from ( select row_.*, rownum rownum_ from ( select i.id, i.CASE_CODE, i.REG_DATE regDate, pc.CODE_NAME , pa.iname, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.COURT_ID = :1 and i.IS_DELETED = 0 and exists(select u.UNDERTAKER_ID from tb_case_undertaker u where u.CASE_ID = i.id and u.UNDERTAKER_ID = :2 ) order by i.CASE_CODE desc ) row_ where rownum <= 13) where rownum_ >= 1
c3gn3zrpjc4df	SELECT COUNT(*) FROM ( select count(*) atelicNum from tb_case_infor t where court_id=:1 and to_char(t.reg_date, 'yyyyMM') >= :2 and to_char(t.reg_date, 'yyyyMM') <= :3 and t.case_state_id != 608) ralasafe_
cf03bvg8wupry	select casepartie0_.parent_id as parent22_3_, casepartie0_.id as id3_, casepartie0_.id as id18_2_, casepartie0_.add_cause as add2_18_2_, casepartie0_.address as address18_2_, casepartie0_.business_entity as business4_18_2_, casepartie0_.card_number as card5_18_2_, casepartie0_.case_id as case21_18_2_, casepartie0_.parent_id as parent22_18_2_, casepartie0_.change_date as change6_18_2_, casepartie0_.disable_cause as disable7_18_2_, casepartie0_.disable_date as disable8_18_2_, casepartie0_.enable as enable18_2_, casepartie0_.iname as iname18_2_, casepartie0_.job as job18_2_, casepartie0_.now_address as now12_18_2_, casepartie0_.card_type_id as card23_18_2_, casepartie0_.nationality_id as nationa24_18_2_, casepartie0_.person_identity_id as person25_18_2_, casepartie0_.person_spc_id as person26_18_2_, casepartie0_.suit_identity_id as suit27_18_2_, casepartie0_.type_id as type28_18_2_, casepartie0_.unit_identity_id as unit29_18_2_, casepartie0_.unit_kind_id as unit30_18_2_, casepartie0_.reg_date as reg13_18_2_, casepartie0_.remark as remark18_2_, casepartie0_.telephone as telephone18_2_, casepartie0_.the_action as the16_18_2_, casepartie0_.the_money as the17_18_2_, casepartie0_.the_res as the18_18_2_, casepartie0_.the_rights as the19_18_2_, casepartie0_.undertaker_id as undertaker31_18_2_, casepartie0_.where_employ as where20_18_2_, paracode1_.id as id105_0_, paracode1_.attribute as attribute105_0_, paracode1_.attribute1 as attribute3_105_0_, paracode1_.code_name as code4_105_0_, paracode1_.disable_time as disable5_105_0_, paracode1_.enable as enable105_0_, paracode1_.type_id as type8_105_0_, paracode1_.reg_time as reg7_105_0_, paratype2_.id as id109_1_, paratype2_.ori_name as ori2_109_1_, paratype2_.para_name as para3_109_1_, paratype2_.rmks as rmks109_1_ from tb_case_party casepartie0_ left outer join tb_para_code paracode1_ on casepartie0_.suit_identity_id=paracode1_.id left outer join tb_para_type paratype2_ on paracode1_.type_id=paratype2_.id where casepartie0_.parent_id=:1
ch4g694s5rwjx	select * from ( select row_.*, rownum rownum_ from ( select ci.id, ci.case_code as caseCode, ci.reg_date as regDate, ci.creater_id as createrId£¬ci.APPLY_MONEY as applyMoney, ci.GIST_TERM as gistTerm , (select t.CODE_NAME from tb_para_code t where ci.CASE_STATE_ID = t.id) as stateName , (select tt.sname from TB_ORG_COURT tt where ci.COURT_ID = tt.id) as courtSNAME , (select listagg(t.iname, ', ') within group(order by t.id) from tb_case_party t where t.case_id = ci.id and t.suit_identity_id = 570) as PROPOSER , (select listagg(t.iname, ', ') within group(order by t.id) from tb_case_party t where t.case_id = ci.id and t.suit_identity_id = 571) as PARTY from tb_case_infor ci where ci.court_id = :1 and ci.is_deleted !=1 and ci.court_id = 2149 and ci.case_code like '%200%' order by regDate, id desc ) row_ where rownum <= 12) where rownum_ >= 1
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cq55srydr99c2	select * from ( select row_.*, rownum rownum_ from ( select i.id, i.CASE_CODE, i.REG_DATE regDate, pc.CODE_NAME , pa.iname, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.COURT_ID = :1 and i.IS_DELETED = 0 and exists(select u.UNDERTAKER_ID from tb_case_undertaker u where u.CASE_ID = i.id and u.UNDERTAKER_ID = :2 ) order by i.CASE_CODE desc ) row_ where rownum <= 17) where rownum_ >= 1
cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
czwmn5r0yzxmf	select * from ( select row_.*, rownum rownum_ from ( select i.id, i.CASE_CODE, i.REG_DATE regDate, pc.CODE_NAME , pa.iname, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.COURT_ID = :1 and i.IS_DELETED = 0 and exists(select u.UNDERTAKER_ID from tb_case_undertaker u where u.CASE_ID = i.id and u.UNDERTAKER_ID = :2 ) order by i.CASE_CODE desc ) row_ where rownum <= 18) where rownum_ >= 10
d9yy8nsr268wj	select * from ( select row_.*, rownum rownum_ from ( select i.id, i.CASE_CODE, i.REG_DATE regDate, pc.CODE_NAME , pa.iname, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.COURT_ID = :1 and i.IS_DELETED = 0 and to_char(reg_date, 'yyyyMM') = to_char(sysdate, 'yyyyMM') order by regDate desc ) row_ where rownum <= 14) where rownum_ >= 1
dmj9073xrdxst	select count(*) endCaseNum from tb_exec_end_case e where e.court_id = :1 and to_char(e.end_case_date, 'yyyyMM') <= :2 and to_char(e.end_case_date, 'yyyyMM') >=:3
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fbawztrrjk5gk	select * from ( select row_.*, rownum rownum_ from ( SELECT S.ID AS ID, S.TITLE AS TITLE, S.ADDRESSEE AS ADDR, S.SERVICE_TIME AS S_TIME FROM TB_EXEC_SERVICE S WHERE S.CASE_ID=:1 order by S_TIME desc ) row_ where rownum <= 8) where rownum_ >= 1
fgfjdhu3u4gcc	select * from ( select row_.*, rownum rownum_ from ( select ci.id, ci.case_code as caseCode, ci.reg_date as regDate, ci.creater_id as createrId£¬ci.APPLY_MONEY as applyMoney, ci.GIST_TERM as gistTerm , (select t.CODE_NAME from tb_para_code t where ci.CASE_STATE_ID = t.id) as stateName , (select tt.sname from TB_ORG_COURT tt where ci.COURT_ID = tt.id) as courtSNAME , (select listagg(t.iname, ', ') within group(order by t.id) from tb_case_party t where t.case_id = ci.id and t.suit_identity_id = 570) as PROPOSER , (select listagg(t.iname, ', ') within group(order by t.id) from tb_case_party t where t.case_id = ci.id and t.suit_identity_id = 571) as PARTY from tb_case_infor ci where ci.court_id = :1 and ci.is_deleted !=1 and ci.court_id = 2430 order by regDate, id desc ) row_ where rownum <= 16) where rownum_ >= 1
fkw3bttddq2yr	select * from ( select row_.*, rownum rownum_ from ( select i.id, i.CASE_CODE, i.REG_DATE regDate, pc.CODE_NAME , pa.iname, (select LISTAGG(p1.INAME, ', ') WITHIN GROUP (order by p1.ID) from tb_case_party p1 where p1.CASE_ID = i.id and p1.SUIT_IDENTITY_ID = 570) proposer, (select LISTAGG(p2.INAME, ', ') WITHIN GROUP (order by p2.ID) from tb_case_party p2 where p2.CASE_ID = i.id and p2.SUIT_IDENTITY_ID = 571) party from tb_case_infor i join TB_PARA_CODE pc on pc.ID = i.CASE_STATE_ID join tb_para_case_cause pa on pa.id = i.CAUSE_ID where i.COURT_ID = :1 and i.IS_DELETED = 0 order by i.ID desc ) row_ where rownum <= 15) where rownum_ >= 1
fvh0jbzaqjtxy	select * from ( select row_.*, rownum rownum_ from ( select i.ID, i.REG_DATE regDate, pc.CODE_NAME, pa.iname, i.CASE_CODE, (select LISTAGG(p1.INAME, ', ')WITHIN GROUP(order by p1.ID)from tb_case_party p1 where p1.CASE_ID=i.id and p1.SUIT_IDENTITY_ID=570)proposer, (select LISTAGG(p2.INAME, ', ')WITHIN GROUP(order by p2.ID)from tb_case_party p2 where p2.CASE_ID=i.id and p2.SUIT_IDENTITY_ID=571)party from tb_case_infor i join TB_PARA_CODE pc on pc.ID=i.CASE_STATE_ID left join tb_para_case_cause pa on pa.id=i.CAUSE_ID where i.court_id=:1 and i.creater_id=:2 and i.IS_DELETED=0 order by i.CASE_CODE desc ) row_ where rownum <= 11) where rownum_ >= 1
fvk8ycvkurgbf	select * from ( select row_.*, rownum rownum_ from ( SELECT S.ID AS ID, S.TITLE AS TITLE, S.ADDRESSEE AS ADDR, S.SERVICE_TIME AS S_TIME FROM TB_EXEC_SERVICE S WHERE S.CASE_ID=:1 order by S_TIME desc ) row_ where rownum <= 17) where rownum_ >= 1
g4c41c5c4q2wg	insert into tb_exec_end_case (case_id, court_id, del_money, end_case_date, end_case_mode_id, end_case_money, exempt_money, money_arraival_rate, overawed, party_dispute, real_exec_action, real_exec_money, real_exec_res, real_exec_rights, real_income_money, remark, undertaker_infraction, undertaker_id, upd_date, id) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 )
g64cqjhad087c	SELECT COUNT(*) FROM ( SELECT S.ID AS ID, S.TITLE AS TITLE, S.ADDRESSEE AS ADDR, S.SERVICE_TIME AS S_TIME FROM TB_EXEC_SERVICE S WHERE S.CASE_ID=:1 ) ralasafe_
g7c45udhsw746	select * from ( select row_.*, rownum rownum_ from ( select t.id, t.title as title, l.location_name, t.reg_time as regtime, t.info_flag as infoflag, u.INAME from tb_news_article t join tb_news_location l on l.id = t.main_location join tb_org_undertaker u on u.id =t.ARTICLE_CEATOR_ID join tb_news_article_location a on a.ARTICLE_ID = t.id where t.info_flag=10 and a.LOCATION_ID=:1 and ((t.distribute_area = 1 and distribute_court = :2 ) or (t.distribute_area = 2 and distribute_court in (select d.id from tb_org_court d start with d.id = :3 connect by prior d.parent_id = d.id))) order by t.REG_TIME desc ) row_ where rownum <= 4) where rownum_ >= 1
ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gs3dwqdqwtvux	select paratype0_.id as id109_0_, paratype0_.ori_name as ori2_109_0_, paratype0_.para_name as para3_109_0_, paratype0_.rmks as rmks109_0_ from tb_para_type paratype0_ where paratype0_.id=:1
gvndxghru6k09	select count(*) endCaseNum , to_char(e.end_case_date, 'yyyy-MM') emonth from tb_exec_end_case e where e.undertaker_id=:1 and e.end_case_date >=to_date(:2 , 'yyyy-MM-dd') and e.end_case_date <=to_date(:3 , 'yyyy-MM-dd') group by to_char(e.end_case_date, 'yyyy-MM')
gzn84kjtmxawt	select count(*) count from tb_case_infor where court_id = :1 and to_char(reg_date, 'yyyyMM') >= :2 and to_char(reg_date, 'yyyyMM') <= :3

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

• Ordered by statistic name

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

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

Tablespace IO Stats