WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
LQSI	2184274693	lqsi1	1	05-Nov-13 19:11	11.2.0.2.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
lqsb01	Linux x86 64-bit	32	32	4	125.91

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	14929	06-Nov-13 15:00:09	96	1.6
End Snap:	14930	06-Nov-13 16:00:14	93	1.5
Elapsed:		60.09 (mins)
DB Time:		4.30 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	10,368M	10,368M	Std Block Size:	8K
Shared Pool Size:	7,296M	7,296M	Log Buffer:	24,132K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.1	0.4	0.01	0.00
DB CPU(s):	0.1	0.4	0.01	0.00
Redo size:	2,025.6	11,252.7
Logical reads:	2,883.2	16,016.7
Block changes:	10.4	57.8
Physical reads:	191.2	1,062.0
Physical writes:	1.1	6.0
User calls:	26.9	149.2
Parses:	9.6	53.3
Hard parses:	0.4	2.4
W/A MB processed:	0.3	1.8
Logons:	0.4	2.4
Executes:	12.5	69.2
Rollbacks:	0.0	0.0
Transactions:	0.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.95	In-memory Sort %:	100.00
Library Hit %:	94.87	Soft Parse %:	95.55
Execute to Parse %:	23.00	Latch Hit %:	99.93
Parse CPU to Parse Elapsd %:	100.14	% Non-Parse CPU:	94.74

Shared Pool Statistics

	Begin	End
Memory Usage %:	27.68	28.74
% SQL with executions>1:	88.54	91.33
% Memory for SQL w/exec>1:	87.59	90.26

Top 5 Timed Foreground Events

Host CPU (CPUs: 32 Cores: 32 Sockets: 4)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.87	0.26	0.4	0.1	0.1	99.5

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.2	51.3	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	128,934.6	128,934.6
SGA use (MB):	18,176.0	18,176.0
PGA use (MB):	345.5	332.5
% Host Mem used for SGA+PGA:	14.37	14.35

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	4.56	25.33
Global Cache blocks served:	7.64	42.46
GCS/GES messages received:	26.97	149.81
GCS/GES messages sent:	16.28	90.43
DBWR Fusion writes:	0.14	0.76
Estd Interconnect traffic (KB)	106.07

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

Buffer access - local cache %:	99.78
Buffer access - remote cache %:	0.17
Buffer access - disk %:	0.05

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	1.4
Avg global cache current block receive time (ms):	1.4
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 %:	10.9
Avg global cache cr block flush time (ms):	1.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.0
Avg global cache current block flush time (ms):	4.6

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.2
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:	51.01
% of indirect sent messages:	48.70
% of flow controlled messages:	0.29

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): 258.1s
• 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 111.1% of Total DB time 258.13 (s)
• Total FG Wait Time: 23.82 (s) DB CPU time: 262.89 (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 74.2% of Total DB Time (s): 258
• Captured PL/SQL account for 1.7% of Total DB Time (s): 258

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 65.4% of Total CPU Time (s): 263
• Captured PL/SQL account for 1.3% of Total CPU Time (s): 263

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 50.5% of Total User I/O Wait Time (s): 12
• Captured PL/SQL account for 0.7% of Total User I/O Wait Time (s): 12

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: 10,394,806
• Captured SQL account for 68.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: 689,214
• Captured SQL account for 99.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: 9,449
• Captured SQL account for 79.2% of Total
• Total UnOptimized Read Requests: 9,449
• Captured SQL account for 79.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: 44,911
• Captured SQL account for 33.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 34,583
• Captured SQL account for 46.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

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): 6
• Captured SQL account for 37.6% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0anap28awdxmp	SELECT operation, master_id, state, flags, inst_id, serialnum, NVL(msg_ctrl_queue, '') FROM gv$datapump_job WHERE owner_name = :1 AND job_name = :2
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
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')
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1gvya58v1xpjq	select server_url, repwebappserver_list.ROWID from repwebappserver_list where WEBAPPID='lqrep' and POWER_BEGIN<=1 and POWER_END >=1
2qzrgxmwmzq60	select * from sbds_uscrlog where dwdata like '%331004198308221811%'
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3srvr2r5up1fu	select * from acb6 where aac001='0020222025' and eae003<200006
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
5fn4azfppknf8	select * from (select rownum as numrow, c.* from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '00020718' and t.aac003 like '%Íõΰºì%' order by t.aae035 desc ) c) where numrow>=1 and numrow<=13
5h4xgqpwvr8tg	select count(*) from sbds_uscrlog
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
5v4bnb370hpqr	select * from (select null table_catalog, idx.table_owner table_schema, idx.table_name table_name, null index_catalog, idx.owner index_schema, idx.index_name index_name, null primary_key, decode(idx.uniqueness, 'UNIQUE', 65535, 0) unique_, decode(idx.index_type, 'CLUSTER', 65535, 0) clustered, null type, null fill_factor, idx.initial_extent initial_size, null nulls, null sort_bookmarks, 65535 auto_update, 2 null_collation, col.column_position ordinal_position, col.column_name column_name, null column_guid, null column_propid, 1 collation, null cardinality, null pages, null filter_condition, decode(idx.index_type, 'CLUSTER', 65535, 0) integrated from all_indexes idx, all_ind_columns col where idx.owner = col.index_owner and idx.index_name = col.index_name and idx.table_owner = col.table_owner and idx.table_name = col.table_name) indexes where table_schema = 'LQSI' and table_name = 'ACA6' order by 8, 10, 5, 6, 17
5ybquzu5k02qz	select yzxbz Ò»ÖÂÐÔ±êÖ¾, aac002 Éí·ÝÖ¤B2, ybsfzh Éí·ÝÖ¤B3, aac003 ÐÕÃûB2, YBXM ÐÕÃûB3, ybagcardno ÊÖ²áºÅB3, eac018 »ùÊýB2, ybjfjs »ùÊýB3, eac031 Ó¦Õ÷B2, ybyjje Ó¦Õ÷B3 from lqsi.ceb_yl2b3bdb t where aab001='00035278' and eac019=0 and aac031=1 and yzxbz>0 and aac031<>3
67541kaz81ub8	SELECT ONE FROM REPONE
69fwvhqjzmhzv	select sb_id "µ¥Î»±àÂë", qymc "µ¥Î»Ãû³Æ", ssny "Ó¦½ÉÄêÔÂ", kpsj "Êսɽð¶î", jsbz "½É·Ñ±ê×¼", rs "½É·ÑÈËÊý", kprq "¿ªÆ±ÈÕÆÚ", zsrs "µÇ¼ÇÈËÊý", reflg "ÀàÐÍ" , nvl((zsrs-rs), 0) "²¹½ÉÈËÊý" , bjamount "ÒѲ¹½É½ð¶î", --decode(sign(nvl((zsrs-rs), 0)-zsrs), 1, nvl((zsrs-rs), 0)-zsrs*jsbz, 0) "Ðè²¹½É" decode(sign(nvl((zsrs-rs), 0)), 1, nvl((zsrs-rs), 0)*nvl(jsbz, 0), 0) "Ðè²¹½É" from( select nvl(m.aab001, j.sb_id) sb_id, j.qymc, j.ssny, j.kpsj, nvl(YJJJS1, 0) + nvl(YJJJS3, 0) dwsj, nvl(YJJJS2, 0) + nvl(yjjjs4, 0) grsj, q.bjamount, k.jsbz, round((j.kpsj + nvl(q.bjamount, 0)) / k.jsbz, 1) rs, j.sjrq kprq, h.rs zsrs, decode(h.reflag, '1', 'µ÷Õû', 'Õý³£') reflg, j.swdjzh from ceb_dssj j, ceb_jfbz k, (select a.aab001 , b.aab004 , eae003 , reflag , b.aab030, count(*) rs from ( select aac001, a.aab001 , aae002 eae003, aab033 , decode(aae143, '7', 1, 0 ) reflag from aca6 a where aae140 ='01' and aab033 ='2' and aae143 ='7' and eac031 >eac033 and aae109 =0 AND EAC018<>0 --and aae003<=200707 -- and a.aab001 ='00020279' union select aac001, a.aab001 , eae003, aab033 , decode(aae143, '7', 1, 0 ) reflag from aca6 a where aae140 ='01' and aab033 ='2' and aae143 not in('6', '4', '7') and eac 031 >eac033 and aae109 =0 --and /*aae003<=200707 and a.aab001 ='00020279'*/ ) a , ab01 b where a.aab001=b.aab001 group by a.aab001 , b.aab004 , b.aab030, a.eae003, a.reflag) h, (select s.AAB030, s.EAE003, sum(s.EAC031) bjamount, s.AAB411 from abe9 s where aae140 ='01' /*and aab001 = '00020279'*/ group by s.AAB030, s.EAE003, s.AAB411) q, ab01 m, aba1 w where j.ssny = k.ssny and j.reflg = k.reflg and m.aab001 =w.aab001 and (w.aae013 is null or w.aae013 not like '%½¨Öþ¹¤ÉË%') and j.ssny= h.eae003(+) and j.reflg = h.reflag(+) and j.swdjzh =h.aab030(+) and j.swdjzh = '332603101330042' and m.aab030 = j.swdjzh and j.ssny = q.EAE003(+) And j.reflg = q.AAB411(+) and j.swdjzh=q.aab030(+) -- and m.aab001 =':[aab001]' -- and substr(j.ssny, 0, 4)>=200207 and substr(j.ssny, 0, 4)<=200706 and j.ssny>=200207 and j.ssny<=200706 -- and j.ssny>=200501 and j.ssny<=200612 union select nvl(m.aab001, j.sb_id) sb_id, nvl(j.qymc, m.aab004) qymc , nvl(j.ssny, h.eae003) ssny, j.kpsj, nvl(YJJJS1, 0) + nvl(YJJJS3, 0) dwsj, nvl(YJJJS2, 0) + nvl(yjjjs4, 0) grsj, q.bjamount, k.jsbz, round((nvl(j.kpsj, 0) + nvl(q.bjamount, 0)) / k.jsbz, 1) rs, j.sjrq kprq, h.rs zsrs, decode(h.reflag, '1', 'µ÷Õû', 'Õý³£'), j.swdjzh from ceb_dssj j, ceb_jfbz k, (select a.aab001 , b.aab004 , eae003 , reflag , b.aab030, count(*) rs from ( select aac001, a.aab001 , aae002 eae003, aab033 , decode(aae143, '7', 1, 0 ) reflag from aca6 a where aae140 ='01' and aab033 ='2' and aae143 ='7' and eac031 >eac033 and aae109 =0 AND EAC018<>0 --and aae003<=200707 -- and a.aab001 ='00020279' union select aac001, a.aab001 , eae003, aab033 , decode(aae143, '7', 1, 0 ) reflag from aca6 a where aae140 ='01' and aab033 ='2' and aae143 not in('6', '4', '7') and eac031 >eac033 and aae109 =0 --and /* aae003<=200707 and a.aab001 ='00020279'*/ ) a , ab01 b where a.aab001=b.aab001 group by a.aab001 , b.aab004 , b.aab030, a.eae003, a.reflag) h, ab01 m, aba1 w , (select s.AAB030, s.EAE003, sum(s.EAC031) bjamount, s.AAB411 from abe9 s where aae140 ='01' /*and aab001 = '00020279'*/ group by s.AAB030, s.EAE003, s.AAB411) q where h.eae003 = k.ssny(+) and h.reflag = k.REFLG(+) and h.aab030 =j.swdjzh(+) and h.eae003 = j.ssny(+) and h.reflag =j.reflg(+) -- and j.s wdjzh(+) = '332603101330042' and h.aab030=m.aab030 and h.eae003 = q.EAE003(+) And h.reflag = q.AAB411(+) and h.aab030 = q.AAB030(+) -- and substr(h.eae003, 0, 4)>=200207 and substr(h.eae003, 0, 4)<=200706 and h.eae003>=200207 and h.eae003<=200706 and m.aab001 =w.aab001 and h.aab030 = '332603101330042' --and m.aab001=':[aab001]' and (w.aae013 is null or w.aae013 not like '%½¨Öþ¹¤ÉË%')) order by ssny , reflg
6fucx13c52fu8	begin LinkConsole.Ora_Trade4401_Update(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006); end;
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6mj37rvmghndb	select count(*) from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '00020718' and t.aac003 like '%»Æΰºì%' order by t.aae035 desc )
7d2wgtxsp30r5	select sb_id "µ¥Î»±àÂë", qymc "µ¥Î»Ãû³Æ", ssny "Ó¦½ÉÄêÔÂ", kpsj "Êսɽð¶î", jsbz "½É·Ñ±ê×¼", rs "½É·ÑÈËÊý", kprq "¿ªÆ±ÈÕÆÚ", zsrs "µÇ¼ÇÈËÊý", reflg "ÀàÐÍ" , nvl((zsrs-rs), 0) "²¹½ÉÈËÊý" , bjamount "ÒѲ¹½É½ð¶î", --decode(sign(nvl((zsrs-rs), 0)-zsrs), 1, nvl((zsrs-rs), 0)-zsrs*jsbz, 0) "Ðè²¹½É" decode(sign(nvl((zsrs-rs), 0)), 1, nvl((zsrs-rs), 0)*nvl(jsbz, 0), 0) "Ðè²¹½É" from( select nvl(m.aab001, j.sb_id) sb_id, j.qymc, j.ssny, j.kpsj, nvl(YJJJS1, 0) + nvl(YJJJS3, 0) dwsj, nvl(YJJJS2, 0) + nvl(yjjjs4, 0) grsj, q.bjamount, k.jsbz, round((j.kpsj + nvl(q.bjamount, 0)) / k.jsbz, 1) rs, j.sjrq kprq, h.rs zsrs, decode(h.reflag, '1', 'µ÷Õû', 'Õý³£') reflg, j.swdjzh from ceb_dssj j, ceb_jfbz k, (select a.aab001 , b.aab004 , eae003 , reflag , b.aab030, count(*) rs from ( select aac001, a.aab001 , aae002 eae003, aab033 , decode(aae143, '7', 1, 0 ) reflag from aca6 a where aae140 ='01' and aab033 ='2' and aae143 ='7' and eac031 >eac033 and aae109 =0 AND EAC018<>0 --and aae003<=200707 -- and a.aab001 ='00020279' union select aac001, a.aab001 , eae003, aab033 , decode(aae143, '7', 1, 0 ) reflag from aca6 a where aae140 ='01' and aab033 ='2' and aae143 not in('6', '4', '7') and eac 031 >eac033 and aae109 =0 --and /*aae003<=200707 and a.aab001 ='00020279'*/ ) a , ab01 b where a.aab001=b.aab001 group by a.aab001 , b.aab004 , b.aab030, a.eae003, a.reflag) h, (select s.AAB030, s.EAE003, sum(s.EAC031) bjamount, s.AAB411 from abe9 s where aae140 ='01' /*and aab001 = '00020279'*/ group by s.AAB030, s.EAE003, s.AAB411) q, ab01 m, aba1 w where j.ssny = k.ssny and j.reflg = k.reflg and m.aab001 =w.aab001 and (w.aae013 is null or w.aae013 not like '%½¨Öþ¹¤ÉË%') and j.ssny= h.eae003(+) and j.reflg = h.reflag(+) and j.swdjzh =h.aab030(+) and j.swdjzh = '332603101060021' and m.aab030 = j.swdjzh and j.ssny = q.EAE003(+) And j.reflg = q.AAB411(+) and j.swdjzh=q.aab030(+) -- and m.aab001 =':[aab001]' -- and substr(j.ssny, 0, 4)>=200207 and substr(j.ssny, 0, 4)<=200706 and j.ssny>=200207 and j.ssny<=200706 -- and j.ssny>=200501 and j.ssny<=200612 union select nvl(m.aab001, j.sb_id) sb_id, nvl(j.qymc, m.aab004) qymc , nvl(j.ssny, h.eae003) ssny, j.kpsj, nvl(YJJJS1, 0) + nvl(YJJJS3, 0) dwsj, nvl(YJJJS2, 0) + nvl(yjjjs4, 0) grsj, q.bjamount, k.jsbz, round((nvl(j.kpsj, 0) + nvl(q.bjamount, 0)) / k.jsbz, 1) rs, j.sjrq kprq, h.rs zsrs, decode(h.reflag, '1', 'µ÷Õû', 'Õý³£'), j.swdjzh from ceb_dssj j, ceb_jfbz k, (select a.aab001 , b.aab004 , eae003 , reflag , b.aab030, count(*) rs from ( select aac001, a.aab001 , aae002 eae003, aab033 , decode(aae143, '7', 1, 0 ) reflag from aca6 a where aae140 ='01' and aab033 ='2' and aae143 ='7' and eac031 >eac033 and aae109 =0 AND EAC018<>0 --and aae003<=200707 -- and a.aab001 ='00020279' union select aac001, a.aab001 , eae003, aab033 , decode(aae143, '7', 1, 0 ) reflag from aca6 a where aae140 ='01' and aab033 ='2' and aae143 not in('6', '4', '7') and eac031 >eac033 and aae109 =0 --and /* aae003<=200707 and a.aab001 ='00020279'*/ ) a , ab01 b where a.aab001=b.aab001 group by a.aab001 , b.aab004 , b.aab030, a.eae003, a.reflag) h, ab01 m, aba1 w , (select s.AAB030, s.EAE003, sum(s.EAC031) bjamount, s.AAB411 from abe9 s where aae140 ='01' /*and aab001 = '00020279'*/ group by s.AAB030, s.EAE003, s.AAB411) q where h.eae003 = k.ssny(+) and h.reflag = k.REFLG(+) and h.aab030 =j.swdjzh(+) and h.eae003 = j.ssny(+) and h.reflag =j.reflg(+) -- and j.s wdjzh(+) = '332603101060021' and h.aab030=m.aab030 and h.eae003 = q.EAE003(+) And h.reflag = q.AAB411(+) and h.aab030 = q.AAB030(+) -- and substr(h.eae003, 0, 4)>=200207 and substr(h.eae003, 0, 4)<=200706 and h.eae003>=200207 and h.eae003<=200706 and m.aab001 =w.aab001 and h.aab030 = '332603101060021' --and m.aab001=':[aab001]' and (w.aae013 is null or w.aae013 not like '%½¨Öþ¹¤ÉË%')) order by ssny , reflg
7r8pfpcrs5fq2	select * from (select rownum as numrow, c.* from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '00020718' and t.aac003 like '%»Æΰºì%' order by t.aae035 desc ) c) where numrow>=1 and numrow<=13
8b05kku86qbay	select * from (select rownum as numrow, c.* from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '04000217' order by t.aae035 desc ) c) where numrow>=92 and numrow<=104
8ch7mxx79p4uy	SELECT RNAME, RVALUE, RTYPE, REPREPLACETEXT.ROWID FROM REPREPLACETEXT WHERE ENABLE='1'
95gcncv54hq6r	select x.nd Äê¶È, x.aab001 µ¥Î»±àÂë, decode(x.aae140, '01', 'ÑøÀÏ', '04', '¹¤ÉË', 'ÆäËû') ÏÕÖÖ, eac029 ½É·ÑÈËÊý, eac018 ½É·Ñ»ùÊý, x.eac031 Ó¦½É×ܶî, x.eac032 µ¥Î»Ó¦½É, y.kpsj ʵ½É½ð¶î, z.eac031 ÒѲ¹½É , nvl(x.eac032, 0) - nvl(y.kpsj, 0) - nvl(z.eac031, 0) Ç··Ñ from (SELECT substr(EAE003, 1, 4) nd, a.AAB001, aae140, sum(eac029) eac029, sum(EAC018) eac018, sum(EAC031) eac031, sum(EAC032) eac032, b.aab030, b.aab004 FROM lqsi.ACA6 a , lqsi.ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and a.AAB001 ='00032267' AND AAE140 in ('01', '04') AND EAE003 >=200707 AND AAE109 ='0' group by a.AAB001, aae140, substr(EAE003, 1, 4), b.aab030, b.aab004 order by aae140, nd) x, ( SELECT AAB030, substr(EAE003, 1, 4)nd, AAE140, SUM(EAC031) kpsj FROM lqsi.ABE8 WHERE aae140 in ('01', '04') and aab400 not in ('2940200', '2940201', '2940501', '2940500') and eae003>=200707 and aab001='00032267' GROUP BY AAB030, substr(EAE003, 1, 4), aae140 order by nd, aae140) y, (select substr(eae003, 1, 4)nd, aae140, aab001, sum(eac031) eac031 from lqsi.abe9 where aab001='00032267' and eae003>=200707 group by aae140, aab001, substr(eae003, 1, 4) ) z where x.nd=y.nd and x.aae140=y.aae140 and x.nd<=to_char(sysdate, 'yyyy')-1 and x.nd=z.nd(+) and x.aae140=z.aae140(+) and x.eac032-y. kpsj-nvl(z.eac031, 0)>0 order by ÏÕÖÖ, x.nd
9ypmd09btfzt0	select * from ( select a.eae003||'00' mxh, (select aaa103 from aa10 where aaa100 ='AAE140' and aaa102 =a.aae140) "ÏÕÖÖ", a.eae003 "Ó¦½ÉÄêÔÂ", a.eac029 "ÈËÊý", a.eac018 "½É·Ñ»ùÊý", a.eac031 "Ó¦½É½ð¶î", a.eac032 "µ¥Î»²¿·Ö", kpsj "µ½Õ˽ð¶î", b.eac031 "ÒѲ¹½ð¶î", eac032-nvl(kpsj, 0)-nvl(b.eac031, 0) "²¹½É½ð¶î", 0 "Äê¶È" from ( select x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029, sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from (SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032, b.aab030, b.aab004 FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and a.AAB001 ='00031229' AND AAE140 ='01' AND EAE003 >=200707 AND AAE109 ='0') X , ( SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 ='01' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140 ) Y WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+) group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj ) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b where a.aab001=b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+) and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013' union select a.yearno||'1300' mxh, 'С¼Æ' "ÏÕÖÖ", 0 "Ó¦½ÉÄêÔÂ", sum(a.eac029) "ÈËÊý", sum(a.eac018) "½É·Ñ»ùÊý", sum(a.eac031) "Ó¦½É½ð¶î", sum(a.eac032) "µ¥Î»²¿·Ö", sum(kpsj) "µ½Õ˽ð¶î", sum(b.eac031) "ÒѲ¹½ð¶î", sum(eac032-nvl(kpsj, 0)-nvl(b.eac031, 0)) "²¹½É½ð¶î", 0 "Äê¶È" from ( select substr(x.eae003, 0, 4) yearno, x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029, sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from (SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032, b.aab030, b.aab004 FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and a.AAB001 ='00031229' AND AAE140 ='01' AND EAE003 >=200707 AND AAE109 ='0') X , ( SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 ='01' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140 ) Y WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+) group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj ) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b where a.aab001= b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+) and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013' group by a.aae140 , a.yearno union select mxh, "ÏÕÖÖ", "Ó¦½ÉÄêÔÂ", sum(ÈËÊý) "ÈËÊý", sum("½É·Ñ»ùÊý") "½É·Ñ»ùÊý", sum("Ó¦½É½ð¶î") "Ó¦½É½ð¶î", sum("µ¥Î»²¿·Ö") "µ¥Î»²¿·Ö", sum("µ½Õ˽ð¶î") "µ½Õ˽ð¶î", sum("ÒѲ¹½ð¶î") "ÒѲ¹½ð¶î", sum("²¹½É½ð¶î") "²¹½É½ð¶î", 0 "Äê¶È" from (select '99991900' mxh, 'ºÏ¼Æ' "ÏÕÖÖ", 0 "Ó¦½ÉÄêÔÂ", sum(a.eac029) "ÈËÊý", sum(a.eac018) "½É·Ñ»ùÊý", sum(a.eac031) "Ó¦½É½ð¶î", sum(a.eac032) "µ¥Î»²¿·Ö", sum(kpsj) "µ½Õ˽ð¶î", sum(b.eac031) "ÒѲ¹½ð¶î", sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) "²¹½É½ð¶î", a.yearno "Äê¶È" from (select substr(x.eae003, 0, 4) yearno, x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029, sum(eac018) eac018, sum(eac031) eac031, sum(eac032) eac032, kpsj from (SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032, b.aab030, b.aab004 FROM ACA6 a, ab01 b WHERE a.aab001 = b.aab001 and a.aab033 = '2' and a.AAB001 ='00031229' AND AAE140 = '01' AND EAE003 >= 200707 AND AAE109 = '0') X, (SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 = '01' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140) Y WHERE x.aab030 = y.AAB030(+) and x.eae003 = y.eae003(+) group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b where a.aab001 = b.aab001(+) and a.aae140 = b.aae140 (+) and a.eae003 = b.eae003(+) and substr(a.eae003, 0, 4) >= '2007' and substr(a.eae003, 0, 4) <= '2013' group by a.aae140, a.yearno having sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) > 0) group by mxh, "ÏÕÖÖ", "Ó¦½ÉÄêÔÂ" ) order by mxh
a1xgxtssv5rrp	select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
a8cxcv0yr6gg1	select * from (select rownum as numrow, c.* from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '04000217' order by t.aae035 desc ) c) where numrow>=105 and numrow<=117
am1gwa1mzj50v	select * from ( select a.eae003||'00' mxh, (select aaa103 from aa10 where aaa100 ='AAE140' and aaa102 =a.aae140) "ÏÕÖÖ", a.eae003 "Ó¦½ÉÄêÔÂ", a.eac029 "ÈËÊý", a.eac018 "½É·Ñ»ùÊý", a.eac031 "Ó¦½É½ð¶î", a.eac032 "µ¥Î»²¿·Ö", kpsj "µ½Õ˽ð¶î", b.eac031 "ÒѲ¹½ð¶î", eac032-nvl(kpsj, 0)-nvl(b.eac031, 0) "²¹½É½ð¶î", 0 "Äê¶È" from ( select x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029, sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from (SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032, b.aab030, b.aab004 FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and a.AAB001 ='00020370' AND AAE140 ='04' AND EAE003 >=200707 AND AAE109 ='0') X , ( SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 ='04' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140 ) Y WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+) group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj ) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b where a.aab001=b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+) and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013' union select a.yearno||'1300' mxh, 'С¼Æ' "ÏÕÖÖ", 0 "Ó¦½ÉÄêÔÂ", sum(a.eac029) "ÈËÊý", sum(a.eac018) "½É·Ñ»ùÊý", sum(a.eac031) "Ó¦½É½ð¶î", sum(a.eac032) "µ¥Î»²¿·Ö", sum(kpsj) "µ½Õ˽ð¶î", sum(b.eac031) "ÒѲ¹½ð¶î", sum(eac032-nvl(kpsj, 0)-nvl(b.eac031, 0)) "²¹½É½ð¶î", 0 "Äê¶È" from ( select substr(x.eae003, 0, 4) yearno, x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029, sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from (SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032, b.aab030, b.aab004 FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and a.AAB001 ='00020370' AND AAE140 ='04' AND EAE003 >=200707 AND AAE109 ='0') X , ( SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 ='04' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140 ) Y WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+) group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj ) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b where a.aab001= b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+) and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013' group by a.aae140 , a.yearno union select mxh, "ÏÕÖÖ", "Ó¦½ÉÄêÔÂ", sum(ÈËÊý) "ÈËÊý", sum("½É·Ñ»ùÊý") "½É·Ñ»ùÊý", sum("Ó¦½É½ð¶î") "Ó¦½É½ð¶î", sum("µ¥Î»²¿·Ö") "µ¥Î»²¿·Ö", sum("µ½Õ˽ð¶î") "µ½Õ˽ð¶î", sum("ÒѲ¹½ð¶î") "ÒѲ¹½ð¶î", sum("²¹½É½ð¶î") "²¹½É½ð¶î", 0 "Äê¶È" from (select '99991900' mxh, 'ºÏ¼Æ' "ÏÕÖÖ", 0 "Ó¦½ÉÄêÔÂ", sum(a.eac029) "ÈËÊý", sum(a.eac018) "½É·Ñ»ùÊý", sum(a.eac031) "Ó¦½É½ð¶î", sum(a.eac032) "µ¥Î»²¿·Ö", sum(kpsj) "µ½Õ˽ð¶î", sum(b.eac031) "ÒѲ¹½ð¶î", sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) "²¹½É½ð¶î", a.yearno "Äê¶È" from (select substr(x.eae003, 0, 4) yearno, x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029, sum(eac018) eac018, sum(eac031) eac031, sum(eac032) eac032, kpsj from (SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032, b.aab030, b.aab004 FROM ACA6 a, ab01 b WHERE a.aab001 = b.aab001 and a.aab033 = '2' and a.AAB001 ='00020370' AND AAE140 = '04' AND EAE003 >= 200707 AND AAE109 = '0') X, (SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 = '04' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140) Y WHERE x.aab030 = y.AAB030(+) and x.eae003 = y.eae003(+) group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b where a.aab001 = b.aab001(+) and a.aae140 = b.aae140 (+) and a.eae003 = b.eae003(+) and substr(a.eae003, 0, 4) >= '2007' and substr(a.eae003, 0, 4) <= '2013' group by a.aae140, a.yearno having sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) > 0) group by mxh, "ÏÕÖÖ", "Ó¦½ÉÄêÔÂ" ) order by mxh
amcxmwpqtxgtv	select * from (select null table_catalog, idx.table_owner table_schema, idx.table_name table_name, null index_catalog, idx.owner index_schema, idx.index_name index_name, null primary_key, decode(idx.uniqueness, 'UNIQUE', 65535, 0) unique_, decode(idx.index_type, 'CLUSTER', 65535, 0) clustered, null type, null fill_factor, idx.initial_extent initial_size, null nulls, null sort_bookmarks, 65535 auto_update, 2 null_collation, col.column_position ordinal_position, col.column_name column_name, null column_guid, null column_propid, 1 collation, null cardinality, null pages, null filter_condition, decode(idx.index_type, 'CLUSTER', 65535, 0) integrated from all_indexes idx, all_ind_columns col where idx.owner = col.index_owner and idx.index_name = col.index_name and idx.table_owner = col.table_owner and idx.table_name = col.table_name) indexes where table_name = 'REPSUMMARY' order by 8, 10, 5, 6, 17
anscansccb56k	select * from ( select a.eae003||'00' mxh, (select aaa103 from aa10 where aaa100 ='AAE140' and aaa102 =a.aae140) "ÏÕÖÖ", a.eae003 "Ó¦½ÉÄêÔÂ", a.eac029 "ÈËÊý", a.eac018 "½É·Ñ»ùÊý", a.eac031 "Ó¦½É½ð¶î", a.eac032 "µ¥Î»²¿·Ö", kpsj "µ½Õ˽ð¶î", b.eac031 "ÒѲ¹½ð¶î", eac032-nvl(kpsj, 0)-nvl(b.eac031, 0) "²¹½É½ð¶î", 0 "Äê¶È" from ( select x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029, sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from (SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032, b.aab030, b.aab004 FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and a.AAB001 ='00020370' AND AAE140 ='01' AND EAE003 >=200707 AND AAE109 ='0') X , ( SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 ='01' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140 ) Y WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+) group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj ) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b where a.aab001=b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+) and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013' union select a.yearno||'1300' mxh, 'С¼Æ' "ÏÕÖÖ", 0 "Ó¦½ÉÄêÔÂ", sum(a.eac029) "ÈËÊý", sum(a.eac018) "½É·Ñ»ùÊý", sum(a.eac031) "Ó¦½É½ð¶î", sum(a.eac032) "µ¥Î»²¿·Ö", sum(kpsj) "µ½Õ˽ð¶î", sum(b.eac031) "ÒѲ¹½ð¶î", sum(eac032-nvl(kpsj, 0)-nvl(b.eac031, 0)) "²¹½É½ð¶î", 0 "Äê¶È" from ( select substr(x.eae003, 0, 4) yearno, x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029, sum(eac018) eac018 , sum(eac031) eac031 , sum(eac032) eac032 , kpsj from (SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032, b.aab030, b.aab004 FROM ACA6 a , ab01 b WHERE a.aab001=b.aab001 and a.aab033 ='2' and a.AAB001 ='00020370' AND AAE140 ='01' AND EAE003 >=200707 AND AAE109 ='0') X , ( SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 ='01' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140 ) Y WHERE x.aab030=y.AAB030(+) and x.eae003=y.eae003(+) group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj ) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b where a.aab001= b.aab001(+) and a.aae140=b.aae140(+) and a.eae003=b.eae003(+) and substr(a.eae003, 0, 4)>='2007' and substr(a.eae003, 0, 4)<='2013' group by a.aae140 , a.yearno union select mxh, "ÏÕÖÖ", "Ó¦½ÉÄêÔÂ", sum(ÈËÊý) "ÈËÊý", sum("½É·Ñ»ùÊý") "½É·Ñ»ùÊý", sum("Ó¦½É½ð¶î") "Ó¦½É½ð¶î", sum("µ¥Î»²¿·Ö") "µ¥Î»²¿·Ö", sum("µ½Õ˽ð¶î") "µ½Õ˽ð¶î", sum("ÒѲ¹½ð¶î") "ÒѲ¹½ð¶î", sum("²¹½É½ð¶î") "²¹½É½ð¶î", 0 "Äê¶È" from (select '99991900' mxh, 'ºÏ¼Æ' "ÏÕÖÖ", 0 "Ó¦½ÉÄêÔÂ", sum(a.eac029) "ÈËÊý", sum(a.eac018) "½É·Ñ»ùÊý", sum(a.eac031) "Ó¦½É½ð¶î", sum(a.eac032) "µ¥Î»²¿·Ö", sum(kpsj) "µ½Õ˽ð¶î", sum(b.eac031) "ÒѲ¹½ð¶î", sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) "²¹½É½ð¶î", a.yearno "Äê¶È" from (select substr(x.eae003, 0, 4) yearno, x.aab001, x.aab004, x.aae140, x.eae003, sum(eac029) eac029, sum(eac018) eac018, sum(eac031) eac031, sum(eac032) eac032, kpsj from (SELECT a.AAB001, aae140, eac029, EAE003, EAC018, EAC031, EAC032, b.aab030, b.aab004 FROM ACA6 a, ab01 b WHERE a.aab001 = b.aab001 and a.aab033 = '2' and a.AAB001 ='00020370' AND AAE140 = '01' AND EAE003 >= 200707 AND AAE109 = '0') X, (SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 = '01' and aab400 not in ('2940200', '2940201', '2940501', '2940500') GROUP BY AAB030, EAE003, aae140) Y WHERE x.aab030 = y.AAB030(+) and x.eae003 = y.eae003(+) group by x.aab001, x.aab004, x.aae140, x.eae003, kpsj) a, (select aae140, aab001, eae003, sum(eac031) eac031 from abe9 group by aae140, aab001, eae003) b where a.aab001 = b.aab001(+) and a.aae140 = b.aae140 (+) and a.eae003 = b.eae003(+) and substr(a.eae003, 0, 4) >= '2007' and substr(a.eae003, 0, 4) <= '2013' group by a.aae140, a.yearno having sum(eac032 - nvl(kpsj, 0) - nvl(b.eac031, 0)) > 0) group by mxh, "ÏÕÖÖ", "Ó¦½ÉÄêÔÂ" ) order by mxh
axfcq597829h6	select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag, inst_id from sys.ts$, GV$FILESPACE_USAGE where ts# = tablespace_id and online$ != 3 and (changescn_wrap > PITRSCNWRP or (changescn_wrap = PITRSCNWRP and changescn_base >= PITRSCNBAS)) and inst_id != :inst and (changescn_wrap > :w or (changescn_wrap = :w and changescn_base >= :b))
bfy0v6kq8bz7h	select * from (select null table_catalog, idx.table_owner table_schema, idx.table_name table_name, null index_catalog, idx.owner index_schema, idx.index_name index_name, null primary_key, decode(idx.uniqueness, 'UNIQUE', 65535, 0) unique_, decode(idx.index_type, 'CLUSTER', 65535, 0) clustered, null type, null fill_factor, idx.initial_extent initial_size, null nulls, null sort_bookmarks, 65535 auto_update, 2 null_collation, col.column_position ordinal_position, col.column_name column_name, null column_guid, null column_propid, 1 collation, null cardinality, null pages, null filter_condition, decode(idx.index_type, 'CLUSTER', 65535, 0) integrated from all_indexes idx, all_ind_columns col where idx.owner = col.index_owner and idx.index_name = col.index_name and idx.table_owner = col.table_owner and idx.table_name = col.table_name) indexes where table_name = 'REPREPORT' order by 8, 10, 5, 6, 17
c08wz0g8s79r9	select * from (select rownum as numrow, c.* from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '04002301' and t.aac003 like '%Íõΰºì%' order by t.aae035 desc ) c) where numrow>=1 and numrow<=13
c8b3c8n0w8wn5	select count(*) from (select distinct n.eac001, n.aac157, n.aac003, (select a.aaa103 aac004 from v_AA10 a where a.aaa100 = 'AAC004' and a.aaa102=aac004), (select a.aaa103 aac008 from v_AA10 a where a.aaa100 = 'AAC008' and a.aaa102=aac008) , (select a.aaa103 eac067 from v_AA10 a where a.aaa100 = 'EAC067' and a.aaa102=eac067), n.aac039, to_char(aae030, 'yyyy-mm-dd') from net_ac03 n , net_ac15 m where n.aac001=m.aac001 and n.aab001='04000595')
cdcx3uyujuk42	SELECT /*+rule*/ O.OBJECT_TYPE, O.OWNER, O.OBJECT_NAME FROM SYS.ALL_OBJECTS O WHERE O.OWNER = :B2 AND O.OBJECT_NAME = :B1 AND OBJECT_TYPE IN ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') AND ROWNUM = 1
ckfvdnh6ta080	SELECT ONE FROM REPONE
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cnu8yzf3sy5ku	SELECT OBJECT_TYPE, USER, :B1 FROM SYS.ALL_OBJECTS WHERE OWNER = USER AND OBJECT_NAME = :B1 AND OBJECT_TYPE IN ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') AND ROWNUM = 1
cqftu5hgs02fy	select '00.00.0000 '||banner, user, 99/100 from v$version where banner like 'Oracle%'
cxn009qhp21hs	select smtfunctio0_.FUNCTIONID as FUNCTIONID59_, smtfunctio0_.LOCATION as LOCATION59_, smtfunctio0_.TITLE as TITLE59_, smtfunctio0_.PARENT as PARENT59_, smtfunctio0_.ORDERNO as ORDERNO59_, smtfunctio0_.TYPE as TYPE59_, smtfunctio0_.DESCRIPTION as DESCRIPT7_59_, smtfunctio0_.LOG as LOG59_, smtfunctio0_.DEVELOPER as DEVELOPER59_, smtfunctio0_.ACTIVE as ACTIVE59_, smtfunctio0_.FUNCTIONDESC as FUNCTIO11_59_, smtfunctio0_.AUFLAG as AUFLAG59_, smtfunctio0_.RPFLAG as RPFLAG59_, smtfunctio0_.UPTYPE as UPTYPE59_, smtfunctio0_.PUBLICFLAG as PUBLICFLAG59_, smtfunctio0_.PRSOURCE as PRSOURCE59_, smtfunctio0_.RBFLAG as RBFLAG59_, smtfunctio0_.PARAM1 as PARAM18_59_, smtfunctio0_.PARAM2 as PARAM19_59_, smtfunctio0_.VSCLASS as VSCLASS59_, smtfunctio0_.SYSID as SYSID59_, smtfunctio0_.FIRSTOPEN as FIRSTOPEN59_, smtfunctio0_.FOCANCLOSE as FOCANCLOSE59_, smtfunctio0_.REAUFLAG as REAUFLAG59_, smtfunctio0_.CREATEDATE as CREATEDATE59_, smtfunctio0_.OWNER as OWNER59_, smtfunctio0_.RESOURCEID as RESOURCEID59_, smtfunctio0_.APPID as APPID59_, smtfunctio0_.ISPROXY as ISPROXY59_ from SMT_FUNCTION smtfunctio0_ where smtfunctio0_.LOCATION=:1
d9ngaputykym7	select * from (select rownum as numrow, c.* from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '04002301' and t.aac003 like '%»Æΰºì%' order by t.aae035 desc ) c) where numrow>=1 and numrow<=13
dzggk2aa35h5k	select smtfunctio0_.FUNCTIONID as FUNCTIONID33_, smtfunctio0_.LOCATION as LOCATION33_, smtfunctio0_.TITLE as TITLE33_, smtfunctio0_.PARENT as PARENT33_, smtfunctio0_.ORDERNO as ORDERNO33_, smtfunctio0_.TYPE as TYPE33_, smtfunctio0_.DESCRIPTION as DESCRIPT7_33_, smtfunctio0_.LOG as LOG33_, smtfunctio0_.DEVELOPER as DEVELOPER33_, smtfunctio0_.ACTIVE as ACTIVE33_, smtfunctio0_.FUNCTIONDESC as FUNCTIO11_33_, smtfunctio0_.AUFLAG as AUFLAG33_, smtfunctio0_.RPFLAG as RPFLAG33_, smtfunctio0_.UPTYPE as UPTYPE33_, smtfunctio0_.PUBLICFLAG as PUBLICFLAG33_, smtfunctio0_.PRSOURCE as PRSOURCE33_, smtfunctio0_.RBFLAG as RBFLAG33_, smtfunctio0_.PARAM1 as PARAM18_33_, smtfunctio0_.PARAM2 as PARAM19_33_, smtfunctio0_.VSCLASS as VSCLASS33_, smtfunctio0_.SYSID as SYSID33_, smtfunctio0_.FIRSTOPEN as FIRSTOPEN33_, smtfunctio0_.FOCANCLOSE as FOCANCLOSE33_, smtfunctio0_.REAUFLAG as REAUFLAG33_, smtfunctio0_.CREATEDATE as CREATEDATE33_, smtfunctio0_.OWNER as OWNER33_, smtfunctio0_.RESOURCEID as RESOURCEID33_, smtfunctio0_.APPID as APPID33_, smtfunctio0_.ISPROXY as ISPROXY33_ from SMT_FUNCTION smtfunctio0_ where smtfunctio0_.LOCATION=: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)
f8d91f7gazpd9	select count(*) from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '04000217' order by t.aae035 desc )
fb538b0m6atm1	select count(*) from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '04002301' and t.aac003 like '%Íõΰºì%' order by t.aae035 desc )
fknbhyzkvjzv3	begin LinkConsole.Ora_Trade4211_Update(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006); end;
fqmpmkfr6pqyk	select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
ftj9uawt4wwzb	select condition from cdef$ where rowid=:1
g37zzhdxz360u	Select sysdate from dual
g8parww8h2a2x	SELECT A.SBBM, A.YWLSH, A.YWOPLSH, B.JZRQ, '01' PDCODE , A.SSNF, A.SSYF FROM (SELECT SBBM, SSNF, SSYF, YWLSH, SUM(YZJE) YZJE, YWOPLSH FROM SBDI_TAXEXP A WHERE A.OPFLAG='1' AND A.DZBZ ='0' AND A.ZTLB='1' AND A.EAE024='0' AND A.CSBZ='1' AND A.SBBM=NVL(:B1 , A.SBBM) AND A.YWOPLSH IS NOT NULL AND A.YWOPLSH<>0 AND A.JJXLBM IN ('2940502', '2940503') GROUP BY SBBM, SSNF, SSYF, YWLSH, YWOPLSH) A, (SELECT SBBM, SSNF, SSYF, YWLSH, SUM(KPSJ) SJJE, MAX(SJRQ) JZRQ FROM SBDI_TAXRETDT A WHERE ZTLB =1 AND RZBZ =0 AND YWLSH IS NOT NULL AND A.SBBM=NVL(:B1 , A.SBBM) AND A.JJXLBM IN ('2940502', '2940503') GROUP BY SBBM, SSNF, SSYF, YWLSH) B WHERE A.SBBM=B.SBBM AND A.SSNF=B.SSNF AND A.SSYF=B.SSYF AND A.YWLSH=B.YWLSH AND A.YZJE=B.SJJE
gcxt3km51bb3f	select * from (select rownum as numrow, c.* from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '04000217' order by t.aae035 desc ) c) where numrow>=79 and numrow<=91
gfw5qrrmpb9cw	select count(*) from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '00020718' and t.aac003 like '%Íõΰºì%' order by t.aae035 desc )
grwydz59pu6mc	select text from view$ where rowid=:1
gx1r269dat54x	select count(*) from (select distinct t.aac001, t.aab001, t.eac001, t.aac002, t.aac003, t.aae160, t.aae035 , t.aac039 as aac039 from net_ad01 t where t.aab001 = '04002301' and t.aac003 like '%»Æΰºì%' order by t.aae035 desc )

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

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Buffer Pool Statistics
• Checkpoint Activity

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 3,870

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

• Instance Recovery Stats
• MTTR Advisory
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin Snapshot, E: End Snapshot

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate