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:	2296	24-Jan-13 10:00:02	117	4.2
End Snap:	2297	24-Jan-13 11:00:25	161	4.6
Elapsed:		60.39 (mins)
DB Time:		812.15 (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):	13.5	0.3	0.05	0.01
DB CPU(s):	0.7	0.0	0.00	0.00
Redo size:	16,914.3	322.0
Logical reads:	81,739.3	1,555.8
Block changes:	95.3	1.8
Physical reads:	20,873.1	397.3
Physical writes:	8.0	0.2
User calls:	988.5	18.8
Parses:	21.3	0.4
Hard parses:	1.8	0.0
W/A MB processed:	4.3	0.1
Logons:	0.7	0.0
Executes:	296.4	5.6
Rollbacks:	46.2	0.9
Transactions:	52.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.94	Redo NoWait %:	100.00
Buffer Hit %:	98.59	In-memory Sort %:	100.00
Library Hit %:	97.96	Soft Parse %:	91.39
Execute to Parse %:	92.81	Latch Hit %:	99.71
Parse CPU to Parse Elapsd %:	56.85	% Non-Parse CPU:	98.36

Shared Pool Statistics

	Begin	End
Memory Usage %:	82.64	83.04
% SQL with executions>1:	85.36	83.07
% Memory for SQL w/exec>1:	82.55	81.51

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.88	1.62	3.9	1.4	32.9	94.0

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
4.5	74.0	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):	472.0	602.7
% Host Mem used for SGA+PGA:	34.09	35.19

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	131.43	2.50
Global Cache blocks served:	143.10	2.72
GCS/GES messages received:	529.91	10.09
GCS/GES messages sent:	303.13	5.77
DBWR Fusion writes:	1.51	0.03
Estd Interconnect traffic (KB)	2,358.92

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

Buffer access - local cache %:	98.37
Buffer access - remote cache %:	0.21
Buffer access - disk %:	1.41

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.9
Avg global cache cr block receive time (ms):	4.4
Avg global cache current block receive time (ms):	1.1
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 %:	9.0
Avg global cache cr block flush time (ms):	38.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.3
Avg global cache current block flush time (ms):	34.6

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	2.6
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:	70.94
% of indirect sent messages:	28.67
% of flow controlled messages:	0.40

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): 48728.8s
• 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 100.4% of Total DB time 48,728.76 (s)
• Total FG Wait Time: 46,456.55 (s) DB CPU time: 2,470.76 (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)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % 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 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 59.7% of Total DB Time (s): 48,729
• Captured PL/SQL account for 0.0% of Total DB Time (s): 48,729

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 48.9% of Total CPU Time (s): 2,471
• Captured PL/SQL account for 0.0% of Total CPU Time (s): 2,471

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 61.8% of Total User I/O Wait Time (s): 43,312
• Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 43,312

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: 296,155,945
• Captured SQL account for 53.2% 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: 75,626,880
• Captured SQL account for 76.6% 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: 2,932,949
• Captured SQL account for 56.2% of Total
• Total UnOptimized Read Requests: 2,932,949
• Captured SQL account for 56.2% 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: 1,073,730
• Captured SQL account for 57.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 77,184
• Captured SQL account for 55.8% 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): 712
• Captured SQL account for 71.5% 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
0kwc2h8bupnna	SELECT COUNT(*) FROM ( select i.id , i.CASE_CODE, LISTAGG(o.INAME, ', ') WITHIN GROUP (order by o.ID) undertaker , c.INAME courtName, d.INAME departName from tb_case_infor i join tb_case_undertaker u on u.CASE_ID = i.ID join tb_org_undertaker o on o.ID = u.UNDERTAKER_ID join tb_org_court c on c.ID = i.COURT_ID join tb_org_depart d on d.id = i.DEPART_ID where i.id = :1 group by i.id, i.CASE_CODE, c.INAME, d.INAME ) ralasafe_
0tak34u160aw0	select count(*) count from RALASAFE_RALASAFE_USERROLE where USERID=:1 and ROLEID=144
0vj5rchx58cyt	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 <= 19) where rownum_ >= 1
0vkc0s11g2mgr	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 <= 20) where rownum_ >= 1
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')
111ckzj8s13xj	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 <= 10) where rownum_ >= 1
18nu7udgr2mdn	SELECT roleid, privilegeid FROM ralasafe_roleprivilege WHERE roleid=:1
1974f3chw4vnx	select count(*) count from tb_case_infor i where i.id = :1 and exists(select * from tb_org_court c where c.id = i.COURT_ID and (c.BELONG_S = :2 or c.BELONG_M = :3 )) and i.COURT_ID != :4
1mv2p6ahjar5k	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 <= 15) where rownum_ >= 1
1r40sbw1fndc2	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 <= 10) where rownum_ >= 1
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
2bz74jynm5kh4	select count(cu.case_id) isUnderTaker, count(ur.roleid) isAdmin, (select decode(i.CASE_STATE_ID, 608, 1, 0) from tb_case_infor i where i.id = :1 ) isClose, count(ci.CREATER_ID) isCreater from tb_org_undertaker ou left join tb_case_infor ci on ci.CREATER_ID = ou.id and ci.id=:2 left join tb_case_undertaker cu on cu.undertaker_id = ou.id and cu.CASE_ID=:3 left join ralasafe_ralasafe_userrole ur on ur.userid = ou.id and ur.roleid = 38 where ou.id = :4 group by cu.case_id
2hwy91zb1kh2x	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 <= 22) where rownum_ >= 1
2nfzqs4thbg9x	select count(1) num from tb_case_infor i, tb_case_undertaker u where u.CASE_ID = i.ID and u.UNDERTAKER_ID =:1 and is_deleted = 0 and case_state_id != 608 and ceil((sysdate - maturity_date)) > 0
2nszajb0qbyvp	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('SMTP_HOST_ADDRESS'), wwv_flow_platform.get_preference('SMTP_HOST_PORT')); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2p4mw0cbyt0qk	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 <= 8) where rownum_ >= 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
39m4sx9k63ba2	select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
39pfabdq1kjz0	SELECT COUNT(*) FROM ( select cp.id, cp.iname , cp.REG_DATE , cp.THE_MONEY , cp.ENABLE, pc.CODE_NAME from tb_case_party cp left join TB_PARA_CODE pc on cp.SUIT_IDENTITY_ID = pc.id where cp.case_id = :1 ) ralasafe_
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 )
3ybf7paztz8bg	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 <= 13) where rownum_ >= 1
3zvuca8fc7w33	SELECT userid, roleid FROM ralasafe_ralasafe_userrole WHERE userid=:1
4403ffvybwsb3	SELECT COUNT(*) FROM ( select cp.id, cp.iname , cp.REG_DATE , cp.THE_MONEY , cp.ENABLE, pc.CODE_NAME from tb_case_party cp left join TB_PARA_CODE pc on cp.SUIT_IDENTITY_ID = pc.id where cp.case_id = :1 and (pc.id = 570 or pc.id = 571)) ralasafe_
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
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
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
56c44uu0kkbbc	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 <= 6) 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 )
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
60nxjh6zwzdhv	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 <= 9) where rownum_ >= 1
63dry37u9s39k	SELECT COUNT(*) FROM ( select count(cu.case_id) isUnderTaker, count(ur.roleid) isAdmin, (select decode(i.CASE_STATE_ID, 608, 1, 0) from tb_case_infor i where i.id = :1 ) isClose, count(ci.CREATER_ID) isCreater from tb_org_undertaker ou left join tb_case_infor ci on ci.CREATER_ID = ou.id and ci.id=:2 left join tb_case_undertaker cu on cu.undertaker_id = ou.id and cu.CASE_ID=:3 left join ralasafe_ralasafe_userrole ur on ur.userid = ou.id and ur.roleid = 38 where ou.id = :4 group by cu.case_id) ralasafe_
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
6su52m6d3dsgh	select count(*) acceptTotal 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')
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
7d86mb0552wnv	select count(*) count from RALASAFE_RALASAFE_USERROLE where USERID=:1 and ROLEID=143
7qacbdfbpjvdy	select count(*) count from RALASAFE_RALASAFE_USERROLE where USERID=:1 and ROLEID=147
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
8v08scf8cq4np	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 <= 15) where rownum_ >= 1
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
90zx22k17342a	select count(*) atelicNum 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') and t.case_state_id != 608
9gw23f1suy5mc	select count(*) count from RALASAFE_RALASAFE_USERROLE where USERID=:1 and ROLEID=38
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
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
bbg7r12c35rhc	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 <= 33) where rownum_ >= 23
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
c9jru82wgkfmt	SELECT COUNT(*) 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) 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
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cr31dn88a8f3s	select count(*) endCaseNum 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')
cra8c4vjgn0uj	select i.id , i.CASE_CODE, LISTAGG(o.INAME, ', ') WITHIN GROUP (order by o.ID) undertaker , c.INAME courtName, d.INAME departName from tb_case_infor i join tb_case_undertaker u on u.CASE_ID = i.ID join tb_org_undertaker o on o.ID = u.UNDERTAKER_ID join tb_org_court c on c.ID = i.COURT_ID join tb_org_depart d on d.id = i.DEPART_ID where i.id = :1 group by i.id, i.CASE_CODE, c.INAME, d.INAME
csu2xrs18kd2q	select count(*) count from tb_case_undertaker where CASE_ID=:1 and undertaker_id=:2
cv4g2k17m9a0n	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 <= 9) 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
f07g9840xt3ct	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 <= 17) where rownum_ >= 1
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
frv77398yxt4w	select count(*) count from RALASAFE_RALASAFE_USERROLE where USERID=:1 and ROLEID=148
ftjpa6nj7pdym	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 <= 20) 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
fzjdbn1zr78c1	SELECT COUNT(*) 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 ) ) ralasafe_
g1ra6ztgmk9jg	SELECT COUNT(*) FROM ( select count(*) endCaseNum 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')) ralasafe_
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
gd2khy1aqy751	SELECT COUNT(*) 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 ) ralasafe_
grbmkduns4y9b	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 <= 16) where rownum_ >= 1
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
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