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:	14928	06-Nov-13 14:00:04	87	1.4
End Snap:	14929	06-Nov-13 15:00:09	96	1.6
Elapsed:		60.08 (mins)
DB Time:		10.83 (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.2	0.4	0.01	0.01
DB CPU(s):	0.2	0.4	0.01	0.01
Redo size:	3,773.7	8,539.5
Logical reads:	46,513.6	105,255.4
Block changes:	64.0	144.7
Physical reads:	197.2	446.3
Physical writes:	191.6	433.6
User calls:	30.7	69.5
Parses:	13.1	29.6
Hard parses:	0.8	1.7
W/A MB processed:	1.4	3.1
Logons:	0.3	0.7
Executes:	31.1	70.4
Rollbacks:	0.0	0.0
Transactions:	0.4

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	96.03	Soft Parse %:	94.19
Execute to Parse %:	58.01	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	98.60	% Non-Parse CPU:	96.42

Shared Pool Statistics

	Begin	End
Memory Usage %:	26.23	27.68
% SQL with executions>1:	93.28	88.54
% Memory for SQL w/exec>1:	91.66	87.59

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.78	0.87	0.6	0.1	0.2	99.3

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.5	69.6	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):	316.3	345.5
% Host Mem used for SGA+PGA:	14.34	14.37

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	10.67	24.15
Global Cache blocks served:	47.51	107.51
GCS/GES messages received:	81.29	183.94
GCS/GES messages sent:	34.29	77.59
DBWR Fusion writes:	0.18	0.40
Estd Interconnect traffic (KB)	488.03

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

Buffer access - local cache %:	99.96
Buffer access - remote cache %:	0.02
Buffer access - disk %:	0.02

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	1.7
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 %:	4.3
Avg global cache cr block flush time (ms):	1.1
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):	20.8

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:	53.85
% of indirect sent messages:	45.96
% of flow controlled messages:	0.20

Cluster Interconnect

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

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• Shared Server Statistics
• init.ora Parameters

More RAC Statistics

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

Wait Events Statistics

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

Time Model Statistics

• Total time in database user-calls (DB Time): 649.5s
• 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 104.0% of Total DB time 649.50 (s)
• Total FG Wait Time: 104.79 (s) DB CPU time: 570.82 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• SQL ordered by Cluster Wait Time
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 83.1% of Total DB Time (s): 650
• Captured PL/SQL account for 5.5% of Total DB Time (s): 650

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

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

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

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: 167,671,902
• Captured SQL account for 96.8% 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: 710,964
• Captured SQL account for 99.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 30,348
• Captured SQL account for 91.1% of Total
• Total UnOptimized Read Requests: 30,348
• Captured SQL account for 91.1% 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: 112,125
• Captured SQL account for 19.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 47,085
• Captured SQL account for 49.9% 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): 20
• Captured SQL account for 97.2% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
085vn378jcwv3	select sql_text, disk_reads, buffer_gets, sorts, executions from gv$sqlarea a where (a.hash_value, a.address) in (select DECODE (sql_hash_value, 0, prev_hash_value, sql_hash_value), DECODE (sql_hash_value, 0, prev_sql_addr, sql_address) from gv$session where sid=1811)
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
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))
1984j5xpckzt4	select count(*) from (select aac001, aac002, aac003, amc020, aae002, ggg, alc079 amc051 from net_mc03 m where aab001 = '00031490')
39g8ryp3pnkhx	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 )
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
42dqbg9azja9k	begin LinkConsole.Ora_Trade4205(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006); end;
4b3drb3axu8yx	BEGIN NET_CHECK_PERSONXUBAONEW(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12); END;
4b5gy0bfjtabv	select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$0A66034D0001'
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
63smq9u7bzq5c	select * from (select rownum as numrow, c.* from (select aac001, aac002, aac003, amc020, aae002, ggg, alc079 amc051 from net_mc03 m where aab001 = '00035531') c) where numrow>=1 and numrow<=13
6c636wuqmyq44	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 = '00030833' order by t.aae035 desc )
6cg8w9rp8v8zr	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 ='00030347' 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 ='00030347' 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 ='00030347' 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
6dsgg526fbgph	select * from (select rownum as numrow, c.* from (select aac001, aac002, aac003, amc020, aae002, ggg, alc079 amc051 from net_mc03 m where aab001 = '00031490') c) where numrow>=1 and numrow<=13
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;
6n1fy4ztm3790	select count(*) from (select aac001, aac002, aac003, amc020, aae002, ggg, alc079 amc051 from net_mc03 m where aab001 = '00035531')
6rxn7z9hvwzdr	select output from table(dbms_workload_repository.awr_global_report_html( :dbid, :instl, :bid, :eid, :rpt_options ))
707w5kyfsjyhf	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 ='00002761' 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)>='2012' 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 ='00002761' 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)>='2012' 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 ='00002761' 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) >= '2012' 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
85pv01w70ktq4	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 ='00002761' 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 ='00002761' 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 ='00002761' 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
8k8qkbwh6mryp	select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$0535062F0001'
8qdzfs1z967xj	select * from (select rownum as numrow, c.* from (select n.aac001, n.aac002, n.aac003, n.aac004, n.eae003, n.aae143, n.eac018, n.eac029, n.eac031, n.eac032, n.eac033, n.aae111, n.aac091 from net_ac09 n where n.aab001= '00020732' and n.eae003='201310' and n.aae140='01' ) c) where numrow>=1 and numrow<=10
97rz99hpwxa4q	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 ='00002211' 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 ='00002211' 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 ='00002211' 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
af43g452zvqnj	SELECT COUNT(*) FROM LQ_AC02 A , LQ_AC01 T WHERE (T.AAC157 =:B2 OR T.AAC157=:B1 ) AND F_CEB_ZTZD(T.AAC001)>0 AND T.AAC001 =A.AAC001 AND A.AAE140 ='01'
af90xc7m4r0yu	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 ='00002761' AND AAE140 ='06' AND EAE003 >=200707 AND AAE109 ='0') X , ( SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 ='06' 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 ='00002761' AND AAE140 ='06' AND EAE003 >=200707 AND AAE109 ='0') X , ( SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 ='06' 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 ='00002761' AND AAE140 = '06' AND EAE003 >= 200707 AND AAE109 = '0') X, (SELECT AAB030, EAE003, AAE140, SUM(EAC031) kpsj FROM ABE8 WHERE aae140 = '06' 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
aypbh2768y69j	begin LinkConsole.Ora_Trade4205_Update(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006); end;
bjqcvk0khru4h	SELECT T.AAC001 FROM LQ_AC02 A , LQ_AC01 T WHERE (T.AAC157 =:B2 OR T.AAC157=:B1 ) AND F_CEB_ZTZD(T.AAC001)>0 AND T.AAC001 =A.AAC001 AND ROWNUM=1
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
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
cy7b9kscdnavb	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 ='00002761' 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 ='00002761' 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 ='00002761' 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
d2svfdrr4cnz0	Insert Into Link_TradeData(ID, LinkID, TRADETYPE, ROWSNO, TEXTMsg, DoFLAG) values(SEQ_TRADEDATAID.NEXTVAL, :V00001, :V00002, :V00003, :V00004, '0')
dasxmf3367zkn	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' order by t.aae035 desc ) c) where numrow>=1 and numrow<=13
dunqfkxhagf3r	Update Link_TradeLog Set ProcResult=:V00001, ProcMsg=:V00002 where LinkID=:V00003
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)
f9zzxtqn8j8uh	create table SBDS_USCRLOG_BAK as select * from SBDS_USCRLOG
fhw2qjm168nwy	SELECT SB_PRSENO.NEXTVAL FROM DUAL
fknbhyzkvjzv3	begin LinkConsole.Ora_Trade4211_Update(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006); end;
ftj9uawt4wwzb	select condition from cdef$ where rowid=:1
fz05ft2tgpj1g	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
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
gcgy8vmvgzsuv	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' order by t.aae035 desc )
grwydz59pu6mc	select text from view$ where rowid=:1
gs8vxu5n1b6fq	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 ='00002761' 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)>='2013' 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 ='00002761' 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)>='2013' 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 ='00002761' 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) >= '2013' 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

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: 690,757

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