WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

SSCDB 61673719 sscdb1 1 29-Sep-13 02:09 11.2.0.3.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
SSCDB	61673719	sscdb1	1	29-Sep-13 02:09	11.2.0.3.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

sdyzsscdb1 Linux x86 64-bit 64 32 4 189.15

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 2418 18-Dec-13 10:00:29 270 1.8

End Snap: 2419 18-Dec-13 11:00:33 277 2.0

Elapsed: 60.07 (mins)

DB Time: 24.41 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2418	18-Dec-13 10:00:29	270	1.8
End Snap:	2419	18-Dec-13 11:00:33	277	2.0
Elapsed:		60.07 (mins)
DB Time:		24.41 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,440M 1,440M Std Block Size: 8K

Shared Pool Size: 2,496M 2,496M Log Buffer: 44,616K

	Begin	End
Buffer Cache:	1,440M	1,440M	Std Block Size:	8K
Shared Pool Size:	2,496M	2,496M	Log Buffer:	44,616K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.4 0.1 0.00 0.00

DB CPU(s): 0.4 0.0 0.00 0.00

Redo size: 29,954.4 3,432.7

Logical reads: 12,341.4 1,414.3

Block changes: 187.5 21.5

Physical reads: 2.5 0.3

Physical writes: 11.9 1.4

User calls: 232.5 26.6

Parses: 56.6 6.5

Hard parses: 40.8 4.7

W/A MB processed: 4.3 0.5

Logons: 0.1 0.0

Executes: 95.0 10.9

Rollbacks: 0.0 0.0

Transactions: 8.7

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.4	0.1	0.00	0.00
DB CPU(s):	0.4	0.0	0.00	0.00
Redo size:	29,954.4	3,432.7
Logical reads:	12,341.4	1,414.3
Block changes:	187.5	21.5
Physical reads:	2.5	0.3
Physical writes:	11.9	1.4
User calls:	232.5	26.6
Parses:	56.6	6.5
Hard parses:	40.8	4.7
W/A MB processed:	4.3	0.5
Logons:	0.1	0.0
Executes:	95.0	10.9
Rollbacks:	0.0	0.0
Transactions:	8.7

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

Buffer Hit %: 99.98 In-memory Sort %: 100.00

Library Hit %: 65.37 Soft Parse %: 27.99

Execute to Parse %: 40.40 Latch Hit %: 99.83

Parse CPU to Parse Elapsd %: 93.40 % Non-Parse CPU: 37.58

Shared Pool Statistics

Begin End

Memory Usage %: 87.95 87.62

% SQL with executions>1: 82.51 77.87

% Memory for SQL w/exec>1: 83.79 79.21

	Begin	End
Memory Usage %:	87.95	87.62
% SQL with executions>1:	82.51	77.87
% Memory for SQL w/exec>1:	83.79	79.21

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		1,396		95.29
log file sync	31,217	41	1	2.81	Commit
db file sequential read	8,493	35	4	2.38	User I/O
enq: TX - row lock contention	1	10	9519	0.65	Application
gc current block 2-way	5,414	3	1	0.20	Cluster

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

Load Average Begin Load Average End %User %System %WIO %Idle

0.37 0.25 0.8 0.2 0.0 99.0

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.37	0.25	0.8	0.2	0.0	99.0

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

0.7 68.7 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.7	68.7	0.0

Begin End

Host Mem (MB): 193,693.6 193,693.6

SGA use (MB): 4,096.0 4,096.0

PGA use (MB): 929.4 971.2

% Host Mem used for SGA+PGA: 2.59 2.62

	Begin	End
Host Mem (MB):	193,693.6	193,693.6
SGA use (MB):	4,096.0	4,096.0
PGA use (MB):	929.4	971.2
% Host Mem used for SGA+PGA:	2.59	2.62

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 2.52 0.29

Global Cache blocks served: 3.88 0.44

GCS/GES messages received: 21.37 2.45

GCS/GES messages sent: 23.83 2.73

DBWR Fusion writes: 0.62 0.07

Estd Interconnect traffic (KB) 60.03

	Per Second	Per Transaction
Global Cache blocks received:	2.52	0.29
Global Cache blocks served:	3.88	0.44
GCS/GES messages received:	21.37	2.45
GCS/GES messages sent:	23.83	2.73
DBWR Fusion writes:	0.62	0.07
Estd Interconnect traffic (KB)	60.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): 0.4

Avg global cache current block receive time (ms): 0.5

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 %: 2.4

Avg global cache cr block flush time (ms): 0.7

Avg global cache current block pin time (ms): 0.0

Avg global cache current block send time (ms): 0.0

Global cache log flushes for current blocks served %: 0.3

Avg global cache current block flush time (ms): 1.7

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

Avg message sent queue time on ksxp (ms): 0.7

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 70.21

% of indirect sent messages: 29.72

% of flow controlled messages: 0.07

Cluster Interconnect

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

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
eth7:1	169.254.26.241	N

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

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): 1464.7s
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

Statistic Name	Time (s)	% of DB Time
DB CPU	1,395.66	95.29
parse time elapsed	941.47	64.28
hard parse elapsed time	890.24	60.78
sql execute elapsed time	417.67	28.52
connection management call elapsed time	2.38	0.16
sequence load elapsed time	0.95	0.07
PL/SQL compilation elapsed time	0.79	0.05
PL/SQL execution elapsed time	0.70	0.05
hard parse (sharing criteria) elapsed time	0.37	0.03
hard parse (bind mismatch) elapsed time	0.18	0.01
repeated bind elapsed time	0.02	0.00
failed parse elapsed time	0.00	0.00
DB time	1,464.70
background cpu time	173.20
background elapsed time	165.91

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

Statistic	Value	End Value
BUSY_TIME	228,283
IDLE_TIME	22,782,224
IOWAIT_TIME	7,019
NICE_TIME	0
SYS_TIME	49,481
USER_TIME	177,733
LOAD	0	0
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	203,102,425,088
NUM_CPUS	64
NUM_CPU_CORES	32
NUM_CPU_SOCKETS	4
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,586
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
18-Dec 10:00:29	0.37
18-Dec 11:00:33	0.25	0.99	0.77	0.22	99.01	0.03

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 102.0% of Total DB time 1,464.70 (s)
Total FG Wait Time: 97.89 (s) DB CPU time: 1,395.66 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			1,396		95.29
Commit	31,217	0	41	1	2.81
User I/O	8,811	0	35	4	2.39
Application	734	0	10	13	0.65
Cluster	15,874	0	8	0	0.52
Concurrency	7,461	0	2	0	0.16
Network	646,974	0	2	0	0.11
Configuration	15	0	0	28	0.03
Other	2,152	84	0	0	0.01
System I/O	44	0	0	1	0.00

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
log file sync	31,217	0	41	1	0.99	2.81
db file sequential read	8,493	0	35	4	0.27	2.38
enq: TX - row lock contention	1	0	10	9519	0.00	0.65
gc current block 2-way	5,414	0	3	1	0.17	0.20
gc current grant busy	3,108	0	2	1	0.10	0.11
gc cr block 2-way	2,303	0	1	1	0.07	0.08
gc current grant 2-way	2,771	0	1	0	0.09	0.07
row cache lock	3,503	0	1	0	0.11	0.06
SQL*Net more data to client	43,851	0	1	0	1.39	0.05
SQL*Net message to client	597,576	0	1	0	19.00	0.05
gc cr grant 2-way	1,748	0	1	0	0.06	0.04
log file switch completion	14	0	0	30	0.00	0.03
latch: shared pool	2,206	0	0	0	0.07	0.03
cursor: pin S wait on X	3	0	0	115	0.00	0.02
library cache: mutex X	435	0	0	1	0.01	0.02
library cache lock	429	2	0	0	0.01	0.01
library cache pin	544	0	0	0	0.02	0.01
SQL*Net more data from client	5,547	0	0	0	0.18	0.01
gc cr block busy	55	0	0	1	0.00	0.00
gc current block congested	96	0	0	1	0.00	0.00
gc cr disk read	192	0	0	0	0.01	0.00
SQL*Net break/reset to client	730	0	0	0	0.02	0.00
control file sequential read	44	0	0	1	0.00	0.00
latch: ges resource hash list	9	0	0	4	0.00	0.00
db file parallel read	6	0	0	6	0.00	0.00
gc current block busy	15	0	0	2	0.00	0.00
latch: row cache objects	293	0	0	0	0.01	0.00
IPC send completion sync	84	0	0	0	0.00	0.00
enq: JQ - contention	37	100	0	1	0.00	0.00
gc current multi block request	36	0	0	1	0.00	0.00
Disk file operations I/O	273	0	0	0	0.01	0.00
gc cr block congested	40	0	0	1	0.00	0.00
gc current grant congested	50	0	0	0	0.00	0.00
DFS lock handle	34	9	0	1	0.00	0.00
gc cr grant congested	32	0	0	0	0.00	0.00
db file scattered read	4	0	0	3	0.00	0.00
enq: PS - contention	28	14	0	0	0.00	0.00
enq: FB - contention	20	0	0	0	0.00	0.00
rdbms ipc reply	8	0	0	1	0.00	0.00
PX Deq: Slave Session Stats	38	0	0	0	0.00	0.00
enq: TX - index contention	12	0	0	1	0.00	0.00
gc cr multi block request	8	0	0	1	0.00	0.00
latch: cache buffers chains	18	0	0	0	0.00	0.00
direct path read	35	0	0	0	0.00	0.00
reliable message	16	0	0	0	0.00	0.00
asynch descriptor resize	1,466	100	0	0	0.05	0.00
PX Deq: reap credit	302	100	0	0	0.01	0.00
gc buffer busy acquire	6	0	0	0	0.00	0.00
latch: active service list	26	0	0	0	0.00	0.00
enq: TT - contention	3	0	0	1	0.00	0.00
buffer busy waits	18	0	0	0	0.00	0.00
SQL*Net message from client	597,568	0	195,664	327	19.00
Streams AQ: waiting for messages in the queue	721	100	3,605	5001	0.02
jobq slave wait	5,767	100	2,887	501	0.18
PX Deq: Execution Msg	120	0	0	1	0.00
PX Deq: Parse Reply	8	0	0	2	0.00
PX Deq: Execute Reply	8	0	0	1	0.00
PX Deq: Join ACK	8	0	0	1	0.00

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	33,255	0	32	1	1.06	19.04
Streams AQ: qmn coordinator waiting for slave to start	3	100	17	5752	0.00	10.40
db file parallel write	32,071	0	11	0	1.02	6.55
control file sequential read	10,055	0	4	0	0.32	2.65
control file parallel write	1,849	0	3	2	0.06	2.09
os thread startup	119	0	2	20	0.00	1.46
row cache lock	3,811	0	1	0	0.12	0.63
db file sequential read	273	0	1	3	0.01	0.46
ASM file metadata operation	1,445	0	0	0	0.05	0.22
row cache process	45,438	0	0	0	1.44	0.21
CGS wait for IPC msg	34,346	100	0	0	1.09	0.20
CSS operation: data query	180	0	0	2	0.01	0.17
direct path write	61	0	0	5	0.00	0.17
gc cr block 2-way	519	0	0	0	0.02	0.14
gc current block 2-way	527	0	0	0	0.02	0.13
ksxr poll remote instances	19,412	100	0	0	0.62	0.10
reliable message	295	0	0	1	0.01	0.09
gcs log flush sync	202	0	0	1	0.01	0.09
row cache cleanup	29,648	0	0	0	0.94	0.07
log file single write	24	0	0	4	0.00	0.06
library cache lock	291	0	0	0	0.01	0.06
library cache pin	307	0	0	0	0.01	0.05
enq: TM - contention	12	50	0	7	0.00	0.05
gc current grant busy	157	0	0	0	0.00	0.04
log file sequential read	24	0	0	3	0.00	0.04
CSS group membership query	60	0	0	1	0.00	0.03
DFS lock handle	147	88	0	0	0.00	0.03
db file async I/O submit	31,997	0	0	0	1.02	0.02
gc current grant 2-way	106	0	0	0	0.00	0.02
gc current block busy	16	0	0	1	0.00	0.01
libcache interrupt action by LCK	21,398	0	0	0	0.68	0.01
PX Deq: reap credit	1,667	100	0	0	0.05	0.01
enq: PS - contention	20	40	0	1	0.00	0.01
gc cr block busy	5	0	0	2	0.00	0.01
undo segment extension	2	100	0	5	0.00	0.01
gc cr grant 2-way	32	0	0	0	0.00	0.01
latch free	2	0	0	4	0.00	0.00
CSS initialization	2	0	0	4	0.00	0.00
enq: WF - contention	19	0	0	0	0.00	0.00
CSS operation: action	4	0	0	2	0.00	0.00
log file sync	2	0	0	3	0.00	0.00
gc current block congested	13	0	0	0	0.00	0.00
enq: CF - contention	10	100	0	1	0.00	0.00
PX Deq: Slave Session Stats	18	0	0	0	0.00	0.00
latch: shared pool	21	0	0	0	0.00	0.00
gc current multi block request	7	0	0	1	0.00	0.00
Disk file operations I/O	74	0	0	0	0.00	0.00
enq: TA - contention	12	0	0	0	0.00	0.00
LGWR wait for redo copy	82	0	0	0	0.00	0.00
enq: HW - contention	10	20	0	0	0.00	0.00
enq: TT - contention	10	60	0	0	0.00	0.00
gc cr block congested	7	0	0	0	0.00	0.00
latch: call allocation	9	0	0	0	0.00	0.00
asynch descriptor resize	541	100	0	0	0.02	0.00
enq: US - contention	5	0	0	0	0.00	0.00
ADR block file read	15	0	0	0	0.00	0.00
enq: TD - KTF dump entries	8	0	0	0	0.00	0.00
IPC send completion sync	12	0	0	0	0.00	0.00
PX Deq: Signal ACK RSG	18	0	0	0	0.00	0.00
SQL*Net message to client	988	0	0	0	0.03	0.00
enq: DR - contention	2	0	0	1	0.00	0.00
enq: CR - block range reuse ckpt	3	0	0	0	0.00	0.00
rdbms ipc message	160,698	42	93,598	582	5.11
gcs remote message	1,414,160	95	14,391	10	44.96
class slave wait	484	0	8,274	17095	0.02
wait for unread message on broadcast channel	7,202	100	7,209	1001	0.23
DIAG idle wait	78,921	87	7,177	91	2.51
Streams AQ: qmn slave idle wait	253	2	6,961	27513	0.01
Space Manager: slave idle wait	1,018	99	5,062	4973	0.03
dispatcher timer	61	100	3,661	60009	0.00
Streams AQ: qmn coordinator idle wait	259	49	3,608	13932	0.01
GCR sleep	721	100	3,605	5001	0.02
PX Idle Wait	30	0	3,605	120163	0.00
ASM background timer	721	0	3,605	5000	0.02
ges remote message	41,354	83	3,603	87	1.31
pmon timer	1,224	97	3,601	2942	0.04
shared server idle wait	120	100	3,601	30008	0.00
PING	1,384	21	3,600	2601	0.04
smon timer	22	32	3,595	163408	0.00
Streams AQ: waiting for time management or cleanup tasks	222	68	3,094	13935	0.01
SQL*Net message from client	1,250	0	2	1	0.04
KSV master wait	2,340	94	0	0	0.07
PX Deq: Join ACK	18	0	0	1	0.00
PX Deq: Parse Reply	18	0	0	1	0.00
Streams AQ: RAC qmn coordinator idle wait	264	100	0	0	0.01
PX Deq: Execute Reply	18	0	0	0	0.00

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)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	15	100.0
ADR block file write	5	100.0
ADR file lock	6	100.0
ASM file metadata operation	1446	99.7					.3
CGS wait for IPC msg	34.3K	100.0
CSS group membership query	60	93.3	6.7
CSS initialization	2	50.0			50.0
CSS operation: action	4	50.0		50.0
CSS operation: data query	180	3.3	96.1	.6
CSS operation: query	66	100.0
DFS lock handle	181	98.3	1.7
Disk file operations I/O	346	100.0
IPC send completion sync	96	97.9	2.1
KJC: Wait for msg sends to complete	71	100.0
LGWR wait for redo copy	82	100.0
PX Deq: Signal ACK EXT	26	100.0
PX Deq: Signal ACK RSG	26	100.0
PX Deq: Slave Session Stats	56	100.0
PX Deq: reap credit	1969	100.0
SQL*Net break/reset to client	730	100.0
SQL*Net message to client	598.8K	100.0
SQL*Net more data from client	5548	100.0	.0
SQL*Net more data to client	43.8K	100.0	.0
Streams AQ: qmn coordinator waiting for slave to start	3								100.0
asynch descriptor resize	2009	100.0
buffer busy waits	22	100.0
control file parallel write	1850	77.2	2.0	.5	17.6	2.5	.2
control file sequential read	10.1K	97.8	.2	.5	1.1	.2	.1	.0
cursor: pin S wait on X	3					33.3		66.7
db file async I/O submit	32K	100.0
db file parallel read	6				100.0
db file parallel write	32.1K	98.3	.9	.3	.5	.0		.0
db file scattered read	4	25.0	25.0		50.0
db file sequential read	8755	24.1	4.8	18.6	48.6	3.4	.4	.1
direct path read	35	100.0
direct path write	61	34.4		1.6	57.4	6.6
enq: AE - lock	2	100.0
enq: AF - task serialization	1	100.0
enq: CF - contention	10	100.0
enq: CR - block range reuse ckpt	3	100.0
enq: DR - contention	2	100.0
enq: FB - contention	23	100.0
enq: HW - contention	26	100.0
enq: JQ - contention	37	91.9	8.1
enq: JS - job run lock - synchronize	1	100.0
enq: MW - contention	1	100.0
enq: PS - contention	48	97.9	2.1
enq: TA - contention	12	100.0
enq: TD - KTF dump entries	8	100.0
enq: TM - contention	25	96.0						4.0
enq: TQ - TM contention	1	100.0
enq: TT - contention	13	100.0
enq: TX - contention	3	100.0
enq: TX - index contention	13	92.3	7.7
enq: UL - contention	3	100.0
enq: US - contention	7	100.0
enq: WF - contention	19	100.0
gc buffer busy acquire	6	100.0
gc buffer busy release	1				100.0
gc cr block 2-way	2887	99.3	.7	.0
gc cr block busy	65	12.3	86.2		1.5
gc cr block congested	48	100.0
gc cr disk read	192	100.0
gc cr grant 2-way	1781	99.4	.5	.1
gc cr grant congested	33	100.0
gc cr multi block request	9	77.8	22.2
gc current block 2-way	5966	99.2	.8	.0
gc current block busy	42	26.2	57.1	7.1	7.1	2.4
gc current block congested	111	99.1	.9
gc current grant 2-way	2878	99.6	.3		.0
gc current grant busy	3309	99.2	.8	.1
gc current grant congested	51	100.0
gc current multi block request	50	98.0	2.0
gcs log flush sync	210	90.5	5.7	1.9	1.9
ksxr poll remote instances	19.2K	100.0
latch free	2	50.0			50.0
latch: active service list	26	100.0
latch: cache buffers chains	18	83.3	16.7
latch: call allocation	9	100.0
latch: gcs resource hash	1	100.0
latch: ges resource hash list	16	56.3		18.8	25.0
latch: messages	1	100.0
latch: redo allocation	1	100.0
latch: redo writing	2	100.0
latch: row cache objects	295	98.6	1.4
latch: shared pool	2232	98.3	1.3	.4
libcache interrupt action by LCK	21.2K	100.0
library cache lock	718	99.2	.7		.1
library cache pin	849	99.6	.4
library cache: mutex X	435	92.4	.2	.2	.7	6.2	.2
log file parallel write	33.3K	89.1	1.1	.9	8.2	.8	.0	.0
log file sequential read	24	50.0	4.2	20.8	20.8	4.2
log file single write	24	50.0			37.5	12.5
log file switch completion	14		7.1	7.1	28.6	7.1		50.0
log file sync	31.2K	85.2	3.6	1.1	8.8	1.2	.0	.0
os thread startup	119					9.2	90.8
rdbms ipc reply	8	87.5			12.5
reliable message	311	74.0	26.0
row cache cleanup	29.3K	100.0	.0	.0
row cache lock	7154	99.1	.9	.0
row cache process	44.8K	100.0
undo segment extension	2	50.0				50.0
ASM background timer	721								100.0
DIAG idle wait	78.9K	11.2	1.1	.1	.0	6.3	29.1	52.2
GCR sleep	721								100.0
KSV master wait	2338	100.0
PING	1384	79.3							20.7
PX Deq: Execute Reply	26	80.8	11.5	7.7
PX Deq: Execution Msg	120	91.7	8.3
PX Deq: Join ACK	26	57.7	19.2	23.1
PX Deq: Parse Reply	26	65.4	23.1	11.5
PX Idle Wait	30					20.0			80.0
SQL*Net message from client	599.1K	71.2	11.4	3.7	2.7	1.7	1.0	4.5	3.8
Space Manager: slave idle wait	1020							.5	99.5
Streams AQ: RAC qmn coordinator idle wait	264	100.0
Streams AQ: qmn coordinator idle wait	259	49.0			.4	.8			49.8
Streams AQ: qmn slave idle wait	253	.8							99.2
Streams AQ: waiting for messages in the queue	721								100.0
Streams AQ: waiting for time management or cleanup tasks	222	30.6						34.2	35.1
class slave wait	485	36.3		9.5	8.9	10.5	1.0	1.4	32.4
dispatcher timer	61								100.0
gcs remote message	1414.4K	1.0	.6	1.0	1.5	95.9	.0	.0
ges remote message	41.5K	8.7	1.8	1.2	.8	.8	1.9	84.7
jobq slave wait	5767					.0		100.0
pmon timer	1225	.6		.1	.3	.2	.1	.6	98.1
rdbms ipc message	160.4K	34.3	.9	.7	7.6	3.1	2.4	35.2	15.9
shared server idle wait	120								100.0
smon timer	24				4.2			12.5	83.3
wait for unread message on broadcast channel	7202							100.0

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)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s
		% of Total Waits
control file sequential read	1	100.0			.0
cursor: pin S wait on X	2	33.3		33.3	33.3
db file parallel write	1	100.0	.0
db file sequential read	6	99.9	.0	.0	.0
enq: TM - contention	1	96.0		4.0
log file parallel write	2	100.0	.0		.0
log file switch completion	7	50.0	35.7	14.3
log file sync	2	100.0	.0		.0

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)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
Streams AQ: qmn coordinator waiting for slave to start	3			100.0

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

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	1,462	1,395	9	44,389
SYS$BACKGROUND	0	0	0	104
sscdb	0	0	0	0
sscdbXDB	0	0	0	0

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	8811	35	7458	2	646830	2
SYS$BACKGROUND	410	1	26080	4	0	0
sscdb	0	0	0	0	0	0

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 5.1% of Total DB Time (s): 1,465
Captured PL/SQL account for 0.6% of Total DB Time (s): 1,465

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Text
14.03	0		0.96	0.03	0.00	74hnkh8j6hzam	update R_MAIN set STATE='9' wh...
7.22	10	0.72	0.49	99.49	0.00	gfgc7ttzq8p7f	select a.account_id id, a.full...
4.32	14	0.31	0.29	69.83	16.57	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
3.80	76,772	0.00	0.26	18.18	0.00	6x218n4acz9mw	select workitem_id from t_work...
3.64	88	0.04	0.25	95.86	0.00	1qwr920c0z4vv	update tfas_process_ins_exp se...
3.33	1	3.33	0.23	92.38	1.29	6ajkhukk78nsr	begin prvt_hdm.auto_execute( :...
3.23	39	0.08	0.22	98.27	0.00	bb16zxqq5vzbt	SELECT COUNT(*) AS RowsCount F...
1.80	17	0.11	0.12	96.85	0.00	89pk0qvj7f0by	select distinct a.WORKITEM_ID,...
1.65	21	0.08	0.11	97.73	0.00	1zp2zmv8gmarq	select b.username from ( selec...
1.58	22	0.07	0.11	97.99	0.00	gnvqzf1b2cchr	select b.username from ( selec...

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 3.6% of Total CPU Time (s): 1,396
Captured PL/SQL account for 0.5% of Total CPU Time (s): 1,396

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
7.18	10	0.72	0.51	7.22	99.49	0.00	gfgc7ttzq8p7f	select a.account_id id, a.full...
3.48	88	0.04	0.25	3.64	95.86	0.00	1qwr920c0z4vv	update tfas_process_ins_exp se...
3.18	39	0.08	0.23	3.23	98.27	0.00	bb16zxqq5vzbt	SELECT COUNT(*) AS RowsCount F...
3.07	1	3.07	0.22	3.33	92.38	1.29	6ajkhukk78nsr	begin prvt_hdm.auto_execute( :...
3.02	14	0.22	0.22	4.32	69.83	16.57	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
1.75	17	0.10	0.13	1.80	96.85	0.00	89pk0qvj7f0by	select distinct a.WORKITEM_ID,...
1.61	21	0.08	0.12	1.65	97.73	0.00	1zp2zmv8gmarq	select b.username from ( selec...
1.55	22	0.07	0.11	1.58	97.99	0.00	gnvqzf1b2cchr	select b.username from ( selec...
1.48	13	0.11	0.11	1.50	98.77	0.00	9sa165as0czsd	select distinct a.WORKITEM_ID,...
1.40	20	0.07	0.10	1.44	97.82	0.00	5njy2hztvpk3s	select b.username from ( selec...

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 0.5% of Total User I/O Wait Time (s): 36
Captured PL/SQL account for 2.6% of Total User I/O Wait Time (s): 36

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
0.72	14	0.05	1.99	4.32	69.83	16.57	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
0.18	16	0.01	0.51	1.26	73.52	14.64	3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_...
0.08	222	0.00	0.23	0.13	34.38	64.44	ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_id...
0.04	276	0.00	0.12	0.13	44.52	33.38	3ktacv9r56b51	select owner#, name, namespace...
0.04	1	0.04	0.12	3.33	92.38	1.29	6ajkhukk78nsr	begin prvt_hdm.auto_execute( :...
0.02	222	0.00	0.06	0.07	55.74	33.21	39m4sx9k63ba2	select /*+ index(idl_ub2$ i_id...
0.01	222	0.00	0.04	0.04	37.94	31.53	c6awqs517jpj0	select /*+ index(idl_char$ i_i...
0.01	4	0.00	0.03	0.95	97.81	1.14	2yxm9v8ukckc4	SELECT DISTINCT decode(m.i_dep...
0.01	3	0.00	0.02	0.66	98.16	0.89	6uh2c845c8dh9	SELECT DISTINCT decode(m.i_dep...
0.00	3	0.00	0.01	0.66	98.65	0.66	b6rx9306f2w6z	SELECT DISTINCT decode(m.i_dep...

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: 44,480,735
Captured SQL account for 7.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	SQL Id	SQL Text
336,360	10	33,636.00	0.76	7.22	99.5	gfgc7ttzq8p7f	select a.account_id id, a.full...
327,484	22	14,885.64	0.74	1.58	98	gnvqzf1b2cchr	select b.username from ( selec...
312,562	21	14,883.90	0.70	1.65	97.7	1zp2zmv8gmarq	select b.username from ( selec...
297,764	20	14,888.20	0.67	1.44	97.8	5njy2hztvpk3s	select b.username from ( selec...
253,098	17	14,888.12	0.57	1.18	97.9	bymd50n9jgthm	select b.username from ( selec...
223,351	15	14,890.07	0.50	1.04	97.9	4qvq4tv1x2395	select b.username from ( selec...
211,781	88	2,406.60	0.48	3.64	95.9	1qwr920c0z4vv	update tfas_process_ins_exp se...
193,573	13	14,890.23	0.44	0.92	98.1	g549wdgtgm842	select b.username from ( selec...
178,500	12	14,875.00	0.40	0.89	98	85874gx2quwr2	select b.username from ( selec...
178,499	12	14,874.92	0.40	0.87	97.7	8bh4wgq9r258j	select b.username from ( selec...

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: 8,908
Captured SQL account for 0.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
738	14	52.71	8.28	4.32	69.83	16.57	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
427	16	26.69	4.79	1.26	73.52	14.64	3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_...
28	1	28.00	0.31	3.33	92.38	1.29	6ajkhukk78nsr	begin prvt_hdm.auto_execute( :...
22	222	0.10	0.25	0.07	55.74	33.21	39m4sx9k63ba2	select /*+ index(idl_ub2$ i_id...
18	222	0.08	0.20	0.13	34.38	64.44	ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_id...
7	276	0.03	0.08	0.13	44.52	33.38	3ktacv9r56b51	select owner#, name, namespace...
5	222	0.02	0.06	0.04	37.94	31.53	c6awqs517jpj0	select /*+ index(idl_char$ i_i...
3	4	0.75	0.03	0.95	97.81	1.14	2yxm9v8ukckc4	SELECT DISTINCT decode(m.i_dep...
2	3	0.67	0.02	0.66	98.16	0.89	6uh2c845c8dh9	SELECT DISTINCT decode(m.i_dep...
1	3	0.33	0.01	1.07	98.52	0.02	922grt54akzsa	SELECT DISTINCT decode(m.i_dep...

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: 8,892
Captured SQL account for 0.1% of Total
Total UnOptimized Read Requests: 8,892
Captured SQL account for 0.1% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Opt	%Total	SQL Id	SQL Text
465	465	16	29.06	0.00	5.23	3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_...
160	160	14	11.43	0.00	1.80	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
28	28	1	28.00	0.00	0.31	6ajkhukk78nsr	begin prvt_hdm.auto_execute( :...
3	3	4	0.75	0.00	0.03	2yxm9v8ukckc4	SELECT DISTINCT decode(m.i_dep...
2	2	3	0.67	0.00	0.02	6uh2c845c8dh9	SELECT DISTINCT decode(m.i_dep...
1	1	3	0.33	0.00	0.01	922grt54akzsa	SELECT DISTINCT decode(m.i_dep...
1	1	3	0.33	0.00	0.01	b6rx9306f2w6z	SELECT DISTINCT decode(m.i_dep...
0	0	1	0.00		0.00	0c5r9pu3utfxx	SELECT DISTINCT decode(m.i_dep...
0	0	68	0.00		0.00	0fr8zhn4ymu3v	select intcol#, type, flags, l...
0	0	279	0.00		0.00	0k8522rmdzg4k	select privilege# from sysauth...

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: 342,313
Captured SQL account for 33.1% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	SQL Id	SQL Text
76,772	0	0.00	3.80	18.2	6x218n4acz9mw	select workitem_id from t_work...
9,908	9,908	1.00	0.58	93	47r1y8yn34jmj	select default$ from col$ wher...
1,868	14,038	7.51	0.36	94.3	cm5vu20fhtnq1	select /*+ connect_by_filterin...
1,632	9,792	6.00	0.27	20.2	6huy6agd4nk2m	SELECT CODE, NAME, ID, URL, NO...
1,470	39,690	27.00	0.39	18.6	9c6tym2fyspch	SELECT CODE, NAME, ID, URL, NO...
1,190	8,330	7.00	0.25	26	19wwbd3swhwr4	SELECT CODE, NAME, ID, URL, NO...
1,068	0	0.00	0.12	15.3	93r1kqu3k6kks	select code, name, to_number(p...
1,066	0	0.00	0.07	46.5	b2gnxm5z6r51n	lock table sys.col_usage$ in e...
1,012	13,156	13.00	0.29	28.5	850n5j6bmq98p	SELECT CODE, NAME, ID, URL, NO...
896	0	0.00	0.08	20	8vj70bbxgx4pv	SELECT CODE, NAME, ID, URL, NO...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 204,031
Captured SQL account for 6.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
1,066	1,066	0.52	b2gnxm5z6r51n	lock table sys.col_usage$ in e...
386	386	0.19	350f5yrnnmshs	lock table sys.mon_mods$ in ex...
381	595	0.19	243s9n1cubsfn	SELECT CODE, NAME, ID, URL, NO...
381	595	0.19	5kv5vcfhkk94u	SELECT CODE, NAME, ID, URL, NO...
381	595	0.19	86nc18zgwdmyt	SELECT CODE, NAME, ID, URL, NO...
378	883	0.19	2q54yf860cut8	SELECT * FROM COM_EXCHANGE_RAT...
369	1,012	0.18	850n5j6bmq98p	SELECT CODE, NAME, ID, URL, NO...
360	1,068	0.18	93r1kqu3k6kks	select code, name, to_number(p...
347	1,632	0.17	6huy6agd4nk2m	SELECT CODE, NAME, ID, URL, NO...
347	545	0.17	86b2j97b5758q	SELECT CODE, NAME, ID, URL, NO...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Text
1,707,255	3	0.07	9g4uhfdrmc7fu	SELECT DISTINCT decode(m.i_dep...
1,140,119	4	0.04	fs7muf6d2sx1f	SELECT DISTINCT decode(m.i_dep...
1,139,999	2	0.04	5xnbjw1534qf2	SELECT DISTINCT decode(m.i_dep...
1,139,999	5	0.04	7rq5bakh87zmn	SELECT DISTINCT decode(m.i_dep...
1,139,207	2	0.04	7gzr0bvhn0vvr	SELECT DISTINCT decode(m.i_dep...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Text
33	5	38t3pnrp90uxy	select exptime, ltime, astatus...
28	13	bd4bznqbq73hk	select bo#, intcol# from icold...
21	68	32bhha21dkv0v	select col#, intcol#, charseti...
21	1,868	cm5vu20fhtnq1	select /*+ connect_by_filterin...

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): 8
Captured SQL account for 3.0% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Text
0.25	14	3.06	4.32	5.86	69.83	16.57	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
0.10	88	1.16	3.64	2.65	95.86	0.00	1qwr920c0z4vv	update tfas_process_ins_exp se...
0.08	16	0.96	1.26	6.32	73.52	14.64	3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_...
0.07	782	0.79	0.34	19.52	41.88	0.05	4m7m0t6fjcs5x	update seq$ set increment$=:2,...
0.06	1	0.72	3.33	1.79	92.38	1.29	6ajkhukk78nsr	begin prvt_hdm.auto_execute( :...
0.01	34	0.14	1.31	0.85	77.39	0.00	6xz3nzu7bx6zw	select distinct a.WORKITEM_ID,...
0.01	5	0.12	1.12	0.86	98.90	0.00	dqx3b5hzrw222	SELECT DISTINCT decode(m.i_dep...
0.01	222	0.10	0.07	11.87	55.74	33.21	39m4sx9k63ba2	select /*+ index(idl_ub2$ i_id...
0.01	21	0.10	1.65	0.48	97.73	0.00	1zp2zmv8gmarq	select b.username from ( selec...
0.01	20	0.08	1.44	0.43	97.82	0.00	5njy2hztvpk3s	select b.username from ( selec...
0.01	222	0.07	0.13	4.82	34.38	64.44	ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_id...
0.01	3	0.07	1.07	0.54	98.52	0.02	922grt54akzsa	SELECT DISTINCT decode(m.i_dep...
0.01	276	0.07	0.13	4.32	44.52	33.38	3ktacv9r56b51	select owner#, name, namespace...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0c5r9pu3utfxx SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A371600_2101_1312_0001') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A371600_2101_1312_0001') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A371600_2101_1312_0001' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A371600_2101_1312_0001' ORDER BY m.ID

0fr8zhn4ymu3v select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

19wwbd3swhwr4 SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code||'-'||name codename FROM COM_DATA_DESC WHERE URL='��.�ʽ�֧��.֧��ʽ' ORDER BY P4, CODE

1qwr920c0z4vv update tfas_process_ins_exp set state = '9' where process_ins_id in (select process_ins_id from t_process_ins where state = '5') and state = '0'

1zp2zmv8gmarq select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '38792' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='38792') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)

243s9n1cubsfn SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code||'-'||name codename FROM COM_DATA_DESC WHERE URL='ADJUSTSTATE.��' ORDER BY P4, CODE

2q54yf860cut8 SELECT * FROM COM_EXCHANGE_RATE WHERE STANDARD_CURRENCY='RMB'

2yxm9v8ukckc4 SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A370800_14_1312_0028') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A370800_14_1312_0028') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A370800_14_1312_0028' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A370800_14_1312_0028' ORDER BY m.ID

32bhha21dkv0v select col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

38t3pnrp90uxy select exptime, ltime, astatus, lcount from user$ where user#=:1

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)

3ktacv9r56b51 select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

47r1y8yn34jmj select default$ from col$ where rowid=:1

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

4qvq4tv1x2395 select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '35885' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='35885') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)

5kv5vcfhkk94u SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code||'-'||name codename FROM COM_DATA_DESC WHERE URL='��ܷ�Χ' ORDER BY P4, CODE

5njy2hztvpk3s select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '36068' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='36068') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)

5xnbjw1534qf2 SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_1_A371600_03_1312_0002') m LEFT JOIN (select * from R_MAIN where r_code = 'R_1_A371600_03_1312_0002') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_1_A371600_03_1312_0002' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_1_A371600_03_1312_0002' ORDER BY m.ID

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); 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;

6huy6agd4nk2m SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code||'-'||name codename FROM COM_DATA_DESC WHERE URL='��.��' ORDER BY P4, CODE

6uh2c845c8dh9 SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A370900_6306_1311_0029') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A370900_6306_1311_0029') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A370900_6306_1311_0029' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A370900_6306_1311_0029' ORDER BY m.ID

6x218n4acz9mw select workitem_id from t_workitemnotif

6xz3nzu7bx6zw select distinct a.WORKITEM_ID, a.PROCESS_DEF_ID, a.PROCESS_DEF_NAME, a.PROCESS_INS_ID, decode(p.process_ins_name, '', a.process_ins_name, p.process_ins_name)PROCESS_INS_NAME, a.ACTIVITY_INS_ID, decode(instr(a.ACTIVITY_INS_NAME, '.'), 0, a.ACTIVITY_INS_NAME, substr(a.ACTIVITY_INS_NAME, instr(a.ACTIVITY_INS_NAME, '.')+1)) ACTIVITY_INS_NAME, b.PROCESS_TYPE, a.CREATED_TIME, a.PARTICIPANT, a.START_TIME, a.TIME_UNIT, a.TIME_LIMIT, a.ATTACHMENT_ID, 'workflow/workItemForward.jsp?actionName=doWorkItemForward&formId='||a.FORM_ID FORM_ID, a.APP_ID, a.ACTIVITY_LIST, a.COMPLETED_TIME, a.DESCRIPTION, a.STATE, a.PRESTATE, d.STARTER, d.NOTE, d.START_DEPT_NAME, d.sender, d.money , d.IS_CONCENTRATE, d.PROCESS_INS_ID_LIST, d.R_CODE, d.CONTRACT_CODE, d.BILL_TYPE, d.BAR_CODE, c.STARTER, c.CREATED_TIME, d.PRI, d.HANG, d.bar_state, d.COMPANY_ID, e.JJCD_GZ, d.GLJY, d.charge_type, d.provider_user, d.ORDER_CODE, d.NOTE PROCESS_INS_DESC, d.start_dept_name FLOW_PARA_INIT_DEPT_NAME, decode(INSTR(b.PROCESS_TYPE, ';'), 0, b.PROCESS_TYPE, substr(b.PROCESS_TYPE, 0, instr(b.PROCESS_TYPE, ';')-1 )) PROCESS_DEF_TYPE, d.process_ins_id parent_process_ins_id from ( select tt.*, minmoney, maxmoney, ifwt from tmsfzwf.t_workitem tt inner join ( select participant, process_id, decode(minmoney, '', -1000000000, minmoney) minmoney, decode(maxmoney, '', 99999999999, maxmoney) maxmoney, ifwt from( select participant, process_id, min(minmoney)minmoney, max(maxmoney)maxmoney, max(ifwt)ifwt from ( select '78333' participant, '*'process_id, null minmoney, null maxmoney, 0 ifwt from dual union all select userid participant, decode(to_char(process_id), '', '*', to_char(process_id))process_id, minmoney, maxmoney, 0 ifwt from tmsfzwf.tfas_user_reassign where (trustid in( select a.id from com_relation_ua b inner join base_user a on b.user_id = a.userid where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '78333')) ) or trustid='78333' ) and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0 group by userid, process_id, minmoney, maxmoney union all select to_char(b.id)participant, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, decode(c.minmoney, '', -1000000000, c.minmoney) minmoney, decode(c.maxmoney, '', 99999999999, c.maxmoney) maxmoney, decode(c.userid, '', 0, 1) ifwt from (select b.user_id from com_relation_ua b where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '78333')) union all select userid user_id from base_user where id='78333' ) a inner join base_user b on a.user_id = b.userid left join (select userid, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '78333' and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0) c on b.id = c.userid group by b.id, process_id, c.minmoney, c.maxmoney, c.userid )group by participant, process_id ) )uu on tt.participant=uu.participant and (process_id='*' or process_id=tt.process_def_id) )a inner join tmsfzwf.T_PROCESS_DEF_MANAGE b on a.PROCESS_DEF_ID = b.PROCESS_ID inner join (select * from tmsfzwf.T_PROCESS_INS where state='2') c on a.PROCESS_INS_ID = c.PROCESS_INS_ID left join ( select * from tmsfzwf.tfas_process_ins_exp where state='0' ) d on (a.process_ins_id=d.process_ins_id or c.parent_process_ins_id=d.process_ins_id) and ((a.ifwt = 0 and d.money >= a.minmoney and d.money <= a.maxmoney) or (a.ifwt = 1 and (d.money < a.minmoney or d.money > a.maxmoney))) left join (select * from tmsfzwf.T_PROCESS_INS where state='2' and parent_process_ins_id is null ) p on c.parent_process_ins_id=p.process_ins_id left join com_budget_subject e on substr(d.company_id, 0, length(d.company_id)-2) = e.company_id and e.budge t_year=substr(c.CREATED_TIME, 0, 4) and d.TASK_TYPE=e.budget_id left join (select userid, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '78333' and ISEND = 0 and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') )f on to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID where d.note is not null and ( (to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID and f.userid is not null and (d.money < f.minmoney or d.money > f.maxmoney)) or (f.userid is null and d.money >= f.minmoney and d.money <= f.maxmoney) or (f.userid is null and f.minmoney is null and f.maxmoney is null)) order by d.BAR_STATE, decode(substr(note, 0, 3), '��ˮ��', substr(note, 5, 6), '') desc , d.STARTER, d.START_DEPT_NAME, b.PROCESS_TYPE, a.CREATED_TIME DESC

74hnkh8j6hzam update R_MAIN set STATE='9' where R_CODE='R_6_A370300_2331_1312_0008'

7gzr0bvhn0vvr SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_3_A371200_01_1311_0001') m LEFT JOIN (select * from R_MAIN where r_code = 'R_3_A371200_01_1311_0001') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_3_A371200_01_1311_0001' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_3_A371200_01_1311_0001' ORDER BY m.ID

7rq5bakh87zmn SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_1_A370400_2201_1312_0001') m LEFT JOIN (select * from R_MAIN where r_code = 'R_1_A370400_2201_1312_0001') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_1_A370400_2201_1312_0001' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_1_A370400_2201_1312_0001' ORDER BY m.ID

850n5j6bmq98p SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code||'-'||name codename FROM COM_DATA_DESC WHERE URL='��.��ñ��.ϸ��' ORDER BY P4, CODE

85874gx2quwr2 select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '8043' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='8043') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)

86b2j97b5758q SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code||'-'||name codename FROM COM_DATA_DESC WHERE URL='YX.�ͻ��' ORDER BY P4, CODE

86nc18zgwdmyt SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code||'-'||name codename FROM COM_DATA_DESC WHERE URL='IFADJUST.�Ƿ��' ORDER BY P4, CODE

89pk0qvj7f0by select distinct a.WORKITEM_ID, a.PROCESS_DEF_ID, a.PROCESS_DEF_NAME, a.PROCESS_INS_ID, decode(p.process_ins_name, '', a.process_ins_name, p.process_ins_name)PROCESS_INS_NAME, a.ACTIVITY_INS_ID, decode(instr(a.ACTIVITY_INS_NAME, '.'), 0, a.ACTIVITY_INS_NAME, substr(a.ACTIVITY_INS_NAME, instr(a.ACTIVITY_INS_NAME, '.')+1)) ACTIVITY_INS_NAME, b.PROCESS_TYPE, a.CREATED_TIME, a.PARTICIPANT, a.START_TIME, a.TIME_UNIT, a.TIME_LIMIT, a.ATTACHMENT_ID, 'workflow/workItemForward.jsp?actionName=doWorkItemForward&formId='||a.FORM_ID FORM_ID, a.APP_ID, a.ACTIVITY_LIST, a.COMPLETED_TIME, a.DESCRIPTION, a.STATE, a.PRESTATE, d.STARTER, d.NOTE, d.START_DEPT_NAME, d.sender, d.money , d.IS_CONCENTRATE, d.PROCESS_INS_ID_LIST, d.R_CODE, d.CONTRACT_CODE, d.BILL_TYPE, d.BAR_CODE, c.STARTER, c.CREATED_TIME, d.PRI, d.HANG, d.bar_state, d.COMPANY_ID, e.JJCD_GZ, d.GLJY, d.charge_type, d.provider_user, d.ORDER_CODE, d.NOTE PROCESS_INS_DESC, d.start_dept_name FLOW_PARA_INIT_DEPT_NAME, decode(INSTR(b.PROCESS_TYPE, ';'), 0, b.PROCESS_TYPE, substr(b.PROCESS_TYPE, 0, instr(b.PROCESS_TYPE, ';')-1 )) PROCESS_DEF_TYPE, d.process_ins_id parent_process_ins_id from ( select tt.*, minmoney, maxmoney, ifwt from tmsfzwf.t_workitem tt inner join ( select participant, process_id, decode(minmoney, '', -1000000000, minmoney) minmoney, decode(maxmoney, '', 99999999999, maxmoney) maxmoney, ifwt from( select participant, process_id, min(minmoney)minmoney, max(maxmoney)maxmoney, max(ifwt)ifwt from ( select '74950' participant, '*'process_id, null minmoney, null maxmoney, 0 ifwt from dual union all select userid participant, decode(to_char(process_id), '', '*', to_char(process_id))process_id, minmoney, maxmoney, 0 ifwt from tmsfzwf.tfas_user_reassign where (trustid in( select a.id from com_relation_ua b inner join base_user a on b.user_id = a.userid where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '74950')) ) or trustid='74950' ) and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0 group by userid, process_id, minmoney, maxmoney union all select to_char(b.id)participant, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, decode(c.minmoney, '', -1000000000, c.minmoney) minmoney, decode(c.maxmoney, '', 99999999999, c.maxmoney) maxmoney, decode(c.userid, '', 0, 1) ifwt from (select b.user_id from com_relation_ua b where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '74950')) union all select userid user_id from base_user where id='74950' ) a inner join base_user b on a.user_id = b.userid left join (select userid, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '74950' and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0) c on b.id = c.userid group by b.id, process_id, c.minmoney, c.maxmoney, c.userid )group by participant, process_id ) )uu on tt.participant=uu.participant and (process_id='*' or process_id=tt.process_def_id) )a inner join tmsfzwf.T_PROCESS_DEF_MANAGE b on a.PROCESS_DEF_ID = b.PROCESS_ID inner join (select * from tmsfzwf.T_PROCESS_INS where state='2') c on a.PROCESS_INS_ID = c.PROCESS_INS_ID left join ( select * from tmsfzwf.tfas_process_ins_exp where state='0' ) d on (a.process_ins_id=d.process_ins_id or c.parent_process_ins_id=d.process_ins_id) and ((a.ifwt = 0 and d.money >= a.minmoney and d.money <= a.maxmoney) or (a.ifwt = 1 and (d.money < a.minmoney or d.money > a.maxmoney))) left join (select * from tmsfzwf.T_PROCESS_INS where state='2' and parent_process_ins_id is null ) p on c.parent_process_ins_id=p.process_ins_id left join com_budget_subject e on substr(d.company_id, 0, length(d.company_id)-2) = e.company_id and e.budge t_year=substr(c.CREATED_TIME, 0, 4) and d.TASK_TYPE=e.budget_id left join (select userid, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '74950' and ISEND = 0 and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') )f on to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID where d.note is not null and ( (to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID and f.userid is not null and (d.money < f.minmoney or d.money > f.maxmoney)) or (f.userid is null and d.money >= f.minmoney and d.money <= f.maxmoney) or (f.userid is null and f.minmoney is null and f.maxmoney is null)) order by d.BAR_STATE, decode(substr(note, 0, 3), '��ˮ��', substr(note, 5, 6), '') desc , d.STARTER, d.START_DEPT_NAME, b.PROCESS_TYPE, a.CREATED_TIME DESC

8bh4wgq9r258j select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '4029' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='4029') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)

8vj70bbxgx4pv SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code||'-'||name codename FROM COM_DATA_DESC WHERE URL='ZH.MX.��ϸ' ORDER BY P4, CODE

922grt54akzsa SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A371500_2001_1311_0054') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A371500_2001_1311_0054') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A371500_2001_1311_0054' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A371500_2001_1311_0054' ORDER BY m.ID

93r1kqu3k6kks select code, name, to_number(p1) * 1 p1, p2, p3, b.account_name from com_data_desc a left join com_accountant_subject b on a.p3 = b.account_id and b.account_year = to_char(sysdate, 'yyyy') and b.bukrs = '3100' where url = 'FM_˰��' order by a.p4, code

9c6tym2fyspch SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code||'-'||name codename FROM COM_DATA_DESC WHERE URL='ZH.��Ʒ��' ORDER BY P4, CODE

9g4uhfdrmc7fu SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_1_A370200_07_1312_0001') m LEFT JOIN (select * from R_MAIN where r_code = 'R_1_A370200_07_1312_0001') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_1_A370200_07_1312_0001' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_1_A370200_07_1312_0001' ORDER BY m.ID

9sa165as0czsd select distinct a.WORKITEM_ID, a.PROCESS_DEF_ID, a.PROCESS_DEF_NAME, a.PROCESS_INS_ID, decode(p.process_ins_name, '', a.process_ins_name, p.process_ins_name)PROCESS_INS_NAME, a.ACTIVITY_INS_ID, decode(instr(a.ACTIVITY_INS_NAME, '.'), 0, a.ACTIVITY_INS_NAME, substr(a.ACTIVITY_INS_NAME, instr(a.ACTIVITY_INS_NAME, '.')+1)) ACTIVITY_INS_NAME, b.PROCESS_TYPE, a.CREATED_TIME, a.PARTICIPANT, a.START_TIME, a.TIME_UNIT, a.TIME_LIMIT, a.ATTACHMENT_ID, 'workflow/workItemForward.jsp?actionName=doWorkItemForward&formId='||a.FORM_ID FORM_ID, a.APP_ID, a.ACTIVITY_LIST, a.COMPLETED_TIME, a.DESCRIPTION, a.STATE, a.PRESTATE, d.STARTER, d.NOTE, d.START_DEPT_NAME, d.sender, d.money , d.IS_CONCENTRATE, d.PROCESS_INS_ID_LIST, d.R_CODE, d.CONTRACT_CODE, d.BILL_TYPE, d.BAR_CODE, c.STARTER, c.CREATED_TIME, d.PRI, d.HANG, d.bar_state, d.COMPANY_ID, e.JJCD_GZ, d.GLJY, d.charge_type, d.provider_user, d.ORDER_CODE, d.NOTE PROCESS_INS_DESC, d.start_dept_name FLOW_PARA_INIT_DEPT_NAME, decode(INSTR(b.PROCESS_TYPE, ';'), 0, b.PROCESS_TYPE, substr(b.PROCESS_TYPE, 0, instr(b.PROCESS_TYPE, ';')-1 )) PROCESS_DEF_TYPE, d.process_ins_id parent_process_ins_id from ( select tt.*, minmoney, maxmoney, ifwt from tmsfzwf.t_workitem tt inner join ( select participant, process_id, decode(minmoney, '', -1000000000, minmoney) minmoney, decode(maxmoney, '', 99999999999, maxmoney) maxmoney, ifwt from( select participant, process_id, min(minmoney)minmoney, max(maxmoney)maxmoney, max(ifwt)ifwt from ( select '96543' participant, '*'process_id, null minmoney, null maxmoney, 0 ifwt from dual union all select userid participant, decode(to_char(process_id), '', '*', to_char(process_id))process_id, minmoney, maxmoney, 0 ifwt from tmsfzwf.tfas_user_reassign where (trustid in( select a.id from com_relation_ua b inner join base_user a on b.user_id = a.userid where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '96543')) ) or trustid='96543' ) and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0 group by userid, process_id, minmoney, maxmoney union all select to_char(b.id)participant, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, decode(c.minmoney, '', -1000000000, c.minmoney) minmoney, decode(c.maxmoney, '', 99999999999, c.maxmoney) maxmoney, decode(c.userid, '', 0, 1) ifwt from (select b.user_id from com_relation_ua b where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '96543')) union all select userid user_id from base_user where id='96543' ) a inner join base_user b on a.user_id = b.userid left join (select userid, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '96543' and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0) c on b.id = c.userid group by b.id, process_id, c.minmoney, c.maxmoney, c.userid )group by participant, process_id ) )uu on tt.participant=uu.participant and (process_id='*' or process_id=tt.process_def_id) )a inner join tmsfzwf.T_PROCESS_DEF_MANAGE b on a.PROCESS_DEF_ID = b.PROCESS_ID inner join (select * from tmsfzwf.T_PROCESS_INS where state='2') c on a.PROCESS_INS_ID = c.PROCESS_INS_ID left join ( select * from tmsfzwf.tfas_process_ins_exp where state='0' ) d on (a.process_ins_id=d.process_ins_id or c.parent_process_ins_id=d.process_ins_id) and ((a.ifwt = 0 and d.money >= a.minmoney and d.money <= a.maxmoney) or (a.ifwt = 1 and (d.money < a.minmoney or d.money > a.maxmoney))) left join (select * from tmsfzwf.T_PROCESS_INS where state='2' and parent_process_ins_id is null ) p on c.parent_process_ins_id=p.process_ins_id left join com_budget_subject e on substr(d.company_id, 0, length(d.company_id)-2) = e.company_id and e.budge t_year=substr(c.CREATED_TIME, 0, 4) and d.TASK_TYPE=e.budget_id left join (select userid, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '96543' and ISEND = 0 and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') )f on to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID where d.note is not null and ( (to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID and f.userid is not null and (d.money < f.minmoney or d.money > f.maxmoney)) or (f.userid is null and d.money >= f.minmoney and d.money <= f.maxmoney) or (f.userid is null and f.minmoney is null and f.maxmoney is null)) order by d.BAR_STATE, decode(substr(note, 0, 3), '��ˮ��', substr(note, 5, 6), '') desc , d.STARTER, d.START_DEPT_NAME, b.PROCESS_TYPE, a.CREATED_TIME DESC

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

b6rx9306f2w6z SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A370900_6406_1311_0003') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A370900_6406_1311_0003') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A370900_6406_1311_0003' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A370900_6406_1311_0003' ORDER BY m.ID

bb16zxqq5vzbt SELECT COUNT(*) AS RowsCount FROM (select d.name, d.code, d.bank_code, d.bank_type from base_lhh d where d.state ='1' and d.name like '%��%' order by d.code) TEMP_EXPPAGEQUERY

bd4bznqbq73hk select bo#, intcol# from icoldep$ where obj#=:1

bymd50n9jgthm select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '35889' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='35889') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)

c6awqs517jpj0 select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

dqx3b5hzrw222 SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A370500_02_1312_0004') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A370500_02_1312_0004') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A370500_02_1312_0004' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A370500_02_1312_0004' ORDER BY m.ID

fs7muf6d2sx1f SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m.*, b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r.*, sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A3700_13_1312_0003') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A3700_13_1312_0003') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A3700_13_1312_0003' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A3700_13_1312_0003' ORDER BY m.ID

g549wdgtgm842 select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '35882' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='35882') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)

ga9j9xk5cy9s0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

gfgc7ttzq8p7f select a.account_id id, a.full_name title, a.parent_id parentid from com_accountant_subject a where exists (select 1 from com_accountant_subject b where b.wl_type='3' and b.account_year = '2013' and instr(b.account_id, a.account_id)=1) and a.account_year = '2013' order by a.account_id

gnvqzf1b2cchr select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '36016' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='36016') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)

SQL Id	SQL Text
0c5r9pu3utfxx	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A371600_2101_1312_0001') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A371600_2101_1312_0001') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A371600_2101_1312_0001' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A371600_2101_1312_0001' ORDER BY m.ID
0fr8zhn4ymu3v	select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
19wwbd3swhwr4	SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code\|\|'-'\|\|name codename FROM COM_DATA_DESC WHERE URL='��.�ʽ�֧��.֧��ʽ' ORDER BY P4, CODE
1qwr920c0z4vv	update tfas_process_ins_exp set state = '9' where process_ins_id in (select process_ins_id from t_process_ins where state = '5') and state = '0'
1zp2zmv8gmarq	select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '38792' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='38792') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)
243s9n1cubsfn	SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code\|\|'-'\|\|name codename FROM COM_DATA_DESC WHERE URL='ADJUSTSTATE.��' ORDER BY P4, CODE
2q54yf860cut8	SELECT * FROM COM_EXCHANGE_RATE WHERE STANDARD_CURRENCY='RMB'
2yxm9v8ukckc4	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A370800_14_1312_0028') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A370800_14_1312_0028') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A370800_14_1312_0028' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A370800_14_1312_0028' ORDER BY m.ID
32bhha21dkv0v	select col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
38t3pnrp90uxy	select exptime, ltime, astatus, lcount from user$ where user#=:1
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
47r1y8yn34jmj	select default$ from col$ where rowid=:1
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
4qvq4tv1x2395	select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '35885' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='35885') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)
5kv5vcfhkk94u	SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code\|\|'-'\|\|name codename FROM COM_DATA_DESC WHERE URL='��ܷ�Χ' ORDER BY P4, CODE
5njy2hztvpk3s	select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '36068' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='36068') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)
5xnbjw1534qf2	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_1_A371600_03_1312_0002') m LEFT JOIN (select * from R_MAIN where r_code = 'R_1_A371600_03_1312_0002') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_1_A371600_03_1312_0002' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_1_A371600_03_1312_0002' ORDER BY m.ID
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); 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;
6huy6agd4nk2m	SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code\|\|'-'\|\|name codename FROM COM_DATA_DESC WHERE URL='��.��' ORDER BY P4, CODE
6uh2c845c8dh9	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A370900_6306_1311_0029') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A370900_6306_1311_0029') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A370900_6306_1311_0029' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A370900_6306_1311_0029' ORDER BY m.ID
6x218n4acz9mw	select workitem_id from t_workitemnotif
6xz3nzu7bx6zw	select distinct a.WORKITEM_ID, a.PROCESS_DEF_ID, a.PROCESS_DEF_NAME, a.PROCESS_INS_ID, decode(p.process_ins_name, '', a.process_ins_name, p.process_ins_name)PROCESS_INS_NAME, a.ACTIVITY_INS_ID, decode(instr(a.ACTIVITY_INS_NAME, '.'), 0, a.ACTIVITY_INS_NAME, substr(a.ACTIVITY_INS_NAME, instr(a.ACTIVITY_INS_NAME, '.')+1)) ACTIVITY_INS_NAME, b.PROCESS_TYPE, a.CREATED_TIME, a.PARTICIPANT, a.START_TIME, a.TIME_UNIT, a.TIME_LIMIT, a.ATTACHMENT_ID, 'workflow/workItemForward.jsp?actionName=doWorkItemForward&formId='\|\|a.FORM_ID FORM_ID, a.APP_ID, a.ACTIVITY_LIST, a.COMPLETED_TIME, a.DESCRIPTION, a.STATE, a.PRESTATE, d.STARTER, d.NOTE, d.START_DEPT_NAME, d.sender, d.money , d.IS_CONCENTRATE, d.PROCESS_INS_ID_LIST, d.R_CODE, d.CONTRACT_CODE, d.BILL_TYPE, d.BAR_CODE, c.STARTER, c.CREATED_TIME, d.PRI, d.HANG, d.bar_state, d.COMPANY_ID, e.JJCD_GZ, d.GLJY, d.charge_type, d.provider_user, d.ORDER_CODE, d.NOTE PROCESS_INS_DESC, d.start_dept_name FLOW_PARA_INIT_DEPT_NAME, decode(INSTR(b.PROCESS_TYPE, ';'), 0, b.PROCESS_TYPE, substr(b.PROCESS_TYPE, 0, instr(b.PROCESS_TYPE, ';')-1 )) PROCESS_DEF_TYPE, d.process_ins_id parent_process_ins_id from ( select tt., minmoney, maxmoney, ifwt from tmsfzwf.t_workitem tt inner join ( select participant, process_id, decode(minmoney, '', -1000000000, minmoney) minmoney, decode(maxmoney, '', 99999999999, maxmoney) maxmoney, ifwt from( select participant, process_id, min(minmoney)minmoney, max(maxmoney)maxmoney, max(ifwt)ifwt from ( select '78333' participant, ''process_id, null minmoney, null maxmoney, 0 ifwt from dual union all select userid participant, decode(to_char(process_id), '', '', to_char(process_id))process_id, minmoney, maxmoney, 0 ifwt from tmsfzwf.tfas_user_reassign where (trustid in( select a.id from com_relation_ua b inner join base_user a on b.user_id = a.userid where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '78333')) ) or trustid='78333' ) and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0 group by userid, process_id, minmoney, maxmoney union all select to_char(b.id)participant, decode(to_char(process_id), '', '', to_char(process_id)) process_id, decode(c.minmoney, '', -1000000000, c.minmoney) minmoney, decode(c.maxmoney, '', 99999999999, c.maxmoney) maxmoney, decode(c.userid, '', 0, 1) ifwt from (select b.user_id from com_relation_ua b where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '78333')) union all select userid user_id from base_user where id='78333' ) a inner join base_user b on a.user_id = b.userid left join (select userid, decode(to_char(process_id), '', '', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '78333' and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0) c on b.id = c.userid group by b.id, process_id, c.minmoney, c.maxmoney, c.userid )group by participant, process_id ) )uu on tt.participant=uu.participant and (process_id='' or process_id=tt.process_def_id) )a inner join tmsfzwf.T_PROCESS_DEF_MANAGE b on a.PROCESS_DEF_ID = b.PROCESS_ID inner join (select * from tmsfzwf.T_PROCESS_INS where state='2') c on a.PROCESS_INS_ID = c.PROCESS_INS_ID left join ( select * from tmsfzwf.tfas_process_ins_exp where state='0' ) d on (a.process_ins_id=d.process_ins_id or c.parent_process_ins_id=d.process_ins_id) and ((a.ifwt = 0 and d.money >= a.minmoney and d.money <= a.maxmoney) or (a.ifwt = 1 and (d.money < a.minmoney or d.money > a.maxmoney))) left join (select * from tmsfzwf.T_PROCESS_INS where state='2' and parent_process_ins_id is null ) p on c.parent_process_ins_id=p.process_ins_id left join com_budget_subject e on substr(d.company_id, 0, length(d.company_id)-2) = e.company_id and e.budge t_year=substr(c.CREATED_TIME, 0, 4) and d.TASK_TYPE=e.budget_id left join (select userid, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '78333' and ISEND = 0 and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') )f on to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID where d.note is not null and ( (to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID and f.userid is not null and (d.money < f.minmoney or d.money > f.maxmoney)) or (f.userid is null and d.money >= f.minmoney and d.money <= f.maxmoney) or (f.userid is null and f.minmoney is null and f.maxmoney is null)) order by d.BAR_STATE, decode(substr(note, 0, 3), '��ˮ��', substr(note, 5, 6), '') desc , d.STARTER, d.START_DEPT_NAME, b.PROCESS_TYPE, a.CREATED_TIME DESC
74hnkh8j6hzam	update R_MAIN set STATE='9' where R_CODE='R_6_A370300_2331_1312_0008'
7gzr0bvhn0vvr	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_3_A371200_01_1311_0001') m LEFT JOIN (select * from R_MAIN where r_code = 'R_3_A371200_01_1311_0001') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_3_A371200_01_1311_0001' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_3_A371200_01_1311_0001' ORDER BY m.ID
7rq5bakh87zmn	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_1_A370400_2201_1312_0001') m LEFT JOIN (select * from R_MAIN where r_code = 'R_1_A370400_2201_1312_0001') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_1_A370400_2201_1312_0001' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_1_A370400_2201_1312_0001' ORDER BY m.ID
850n5j6bmq98p	SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code\|\|'-'\|\|name codename FROM COM_DATA_DESC WHERE URL='��.��ñ��.ϸ��' ORDER BY P4, CODE
85874gx2quwr2	select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '8043' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='8043') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)
86b2j97b5758q	SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code\|\|'-'\|\|name codename FROM COM_DATA_DESC WHERE URL='YX.�ͻ��' ORDER BY P4, CODE
86nc18zgwdmyt	SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code\|\|'-'\|\|name codename FROM COM_DATA_DESC WHERE URL='IFADJUST.�Ƿ��' ORDER BY P4, CODE
89pk0qvj7f0by	select distinct a.WORKITEM_ID, a.PROCESS_DEF_ID, a.PROCESS_DEF_NAME, a.PROCESS_INS_ID, decode(p.process_ins_name, '', a.process_ins_name, p.process_ins_name)PROCESS_INS_NAME, a.ACTIVITY_INS_ID, decode(instr(a.ACTIVITY_INS_NAME, '.'), 0, a.ACTIVITY_INS_NAME, substr(a.ACTIVITY_INS_NAME, instr(a.ACTIVITY_INS_NAME, '.')+1)) ACTIVITY_INS_NAME, b.PROCESS_TYPE, a.CREATED_TIME, a.PARTICIPANT, a.START_TIME, a.TIME_UNIT, a.TIME_LIMIT, a.ATTACHMENT_ID, 'workflow/workItemForward.jsp?actionName=doWorkItemForward&formId='\|\|a.FORM_ID FORM_ID, a.APP_ID, a.ACTIVITY_LIST, a.COMPLETED_TIME, a.DESCRIPTION, a.STATE, a.PRESTATE, d.STARTER, d.NOTE, d.START_DEPT_NAME, d.sender, d.money , d.IS_CONCENTRATE, d.PROCESS_INS_ID_LIST, d.R_CODE, d.CONTRACT_CODE, d.BILL_TYPE, d.BAR_CODE, c.STARTER, c.CREATED_TIME, d.PRI, d.HANG, d.bar_state, d.COMPANY_ID, e.JJCD_GZ, d.GLJY, d.charge_type, d.provider_user, d.ORDER_CODE, d.NOTE PROCESS_INS_DESC, d.start_dept_name FLOW_PARA_INIT_DEPT_NAME, decode(INSTR(b.PROCESS_TYPE, ';'), 0, b.PROCESS_TYPE, substr(b.PROCESS_TYPE, 0, instr(b.PROCESS_TYPE, ';')-1 )) PROCESS_DEF_TYPE, d.process_ins_id parent_process_ins_id from ( select tt., minmoney, maxmoney, ifwt from tmsfzwf.t_workitem tt inner join ( select participant, process_id, decode(minmoney, '', -1000000000, minmoney) minmoney, decode(maxmoney, '', 99999999999, maxmoney) maxmoney, ifwt from( select participant, process_id, min(minmoney)minmoney, max(maxmoney)maxmoney, max(ifwt)ifwt from ( select '74950' participant, ''process_id, null minmoney, null maxmoney, 0 ifwt from dual union all select userid participant, decode(to_char(process_id), '', '', to_char(process_id))process_id, minmoney, maxmoney, 0 ifwt from tmsfzwf.tfas_user_reassign where (trustid in( select a.id from com_relation_ua b inner join base_user a on b.user_id = a.userid where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '74950')) ) or trustid='74950' ) and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0 group by userid, process_id, minmoney, maxmoney union all select to_char(b.id)participant, decode(to_char(process_id), '', '', to_char(process_id)) process_id, decode(c.minmoney, '', -1000000000, c.minmoney) minmoney, decode(c.maxmoney, '', 99999999999, c.maxmoney) maxmoney, decode(c.userid, '', 0, 1) ifwt from (select b.user_id from com_relation_ua b where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '74950')) union all select userid user_id from base_user where id='74950' ) a inner join base_user b on a.user_id = b.userid left join (select userid, decode(to_char(process_id), '', '', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '74950' and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0) c on b.id = c.userid group by b.id, process_id, c.minmoney, c.maxmoney, c.userid )group by participant, process_id ) )uu on tt.participant=uu.participant and (process_id='' or process_id=tt.process_def_id) )a inner join tmsfzwf.T_PROCESS_DEF_MANAGE b on a.PROCESS_DEF_ID = b.PROCESS_ID inner join (select * from tmsfzwf.T_PROCESS_INS where state='2') c on a.PROCESS_INS_ID = c.PROCESS_INS_ID left join ( select * from tmsfzwf.tfas_process_ins_exp where state='0' ) d on (a.process_ins_id=d.process_ins_id or c.parent_process_ins_id=d.process_ins_id) and ((a.ifwt = 0 and d.money >= a.minmoney and d.money <= a.maxmoney) or (a.ifwt = 1 and (d.money < a.minmoney or d.money > a.maxmoney))) left join (select * from tmsfzwf.T_PROCESS_INS where state='2' and parent_process_ins_id is null ) p on c.parent_process_ins_id=p.process_ins_id left join com_budget_subject e on substr(d.company_id, 0, length(d.company_id)-2) = e.company_id and e.budge t_year=substr(c.CREATED_TIME, 0, 4) and d.TASK_TYPE=e.budget_id left join (select userid, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '74950' and ISEND = 0 and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') )f on to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID where d.note is not null and ( (to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID and f.userid is not null and (d.money < f.minmoney or d.money > f.maxmoney)) or (f.userid is null and d.money >= f.minmoney and d.money <= f.maxmoney) or (f.userid is null and f.minmoney is null and f.maxmoney is null)) order by d.BAR_STATE, decode(substr(note, 0, 3), '��ˮ��', substr(note, 5, 6), '') desc , d.STARTER, d.START_DEPT_NAME, b.PROCESS_TYPE, a.CREATED_TIME DESC
8bh4wgq9r258j	select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '4029' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='4029') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)
8vj70bbxgx4pv	SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code\|\|'-'\|\|name codename FROM COM_DATA_DESC WHERE URL='ZH.MX.��ϸ' ORDER BY P4, CODE
922grt54akzsa	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A371500_2001_1311_0054') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A371500_2001_1311_0054') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A371500_2001_1311_0054' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A371500_2001_1311_0054' ORDER BY m.ID
93r1kqu3k6kks	select code, name, to_number(p1) * 1 p1, p2, p3, b.account_name from com_data_desc a left join com_accountant_subject b on a.p3 = b.account_id and b.account_year = to_char(sysdate, 'yyyy') and b.bukrs = '3100' where url = 'FM_˰��' order by a.p4, code
9c6tym2fyspch	SELECT CODE, NAME, ID, URL, NOTE, P1, P2, P3, P4, P5, P6, P7, code\|\|'-'\|\|name codename FROM COM_DATA_DESC WHERE URL='ZH.��Ʒ��' ORDER BY P4, CODE
9g4uhfdrmc7fu	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_1_A370200_07_1312_0001') m LEFT JOIN (select * from R_MAIN where r_code = 'R_1_A370200_07_1312_0001') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_1_A370200_07_1312_0001' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_1_A370200_07_1312_0001' ORDER BY m.ID
9sa165as0czsd	select distinct a.WORKITEM_ID, a.PROCESS_DEF_ID, a.PROCESS_DEF_NAME, a.PROCESS_INS_ID, decode(p.process_ins_name, '', a.process_ins_name, p.process_ins_name)PROCESS_INS_NAME, a.ACTIVITY_INS_ID, decode(instr(a.ACTIVITY_INS_NAME, '.'), 0, a.ACTIVITY_INS_NAME, substr(a.ACTIVITY_INS_NAME, instr(a.ACTIVITY_INS_NAME, '.')+1)) ACTIVITY_INS_NAME, b.PROCESS_TYPE, a.CREATED_TIME, a.PARTICIPANT, a.START_TIME, a.TIME_UNIT, a.TIME_LIMIT, a.ATTACHMENT_ID, 'workflow/workItemForward.jsp?actionName=doWorkItemForward&formId='\|\|a.FORM_ID FORM_ID, a.APP_ID, a.ACTIVITY_LIST, a.COMPLETED_TIME, a.DESCRIPTION, a.STATE, a.PRESTATE, d.STARTER, d.NOTE, d.START_DEPT_NAME, d.sender, d.money , d.IS_CONCENTRATE, d.PROCESS_INS_ID_LIST, d.R_CODE, d.CONTRACT_CODE, d.BILL_TYPE, d.BAR_CODE, c.STARTER, c.CREATED_TIME, d.PRI, d.HANG, d.bar_state, d.COMPANY_ID, e.JJCD_GZ, d.GLJY, d.charge_type, d.provider_user, d.ORDER_CODE, d.NOTE PROCESS_INS_DESC, d.start_dept_name FLOW_PARA_INIT_DEPT_NAME, decode(INSTR(b.PROCESS_TYPE, ';'), 0, b.PROCESS_TYPE, substr(b.PROCESS_TYPE, 0, instr(b.PROCESS_TYPE, ';')-1 )) PROCESS_DEF_TYPE, d.process_ins_id parent_process_ins_id from ( select tt., minmoney, maxmoney, ifwt from tmsfzwf.t_workitem tt inner join ( select participant, process_id, decode(minmoney, '', -1000000000, minmoney) minmoney, decode(maxmoney, '', 99999999999, maxmoney) maxmoney, ifwt from( select participant, process_id, min(minmoney)minmoney, max(maxmoney)maxmoney, max(ifwt)ifwt from ( select '96543' participant, ''process_id, null minmoney, null maxmoney, 0 ifwt from dual union all select userid participant, decode(to_char(process_id), '', '', to_char(process_id))process_id, minmoney, maxmoney, 0 ifwt from tmsfzwf.tfas_user_reassign where (trustid in( select a.id from com_relation_ua b inner join base_user a on b.user_id = a.userid where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '96543')) ) or trustid='96543' ) and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0 group by userid, process_id, minmoney, maxmoney union all select to_char(b.id)participant, decode(to_char(process_id), '', '', to_char(process_id)) process_id, decode(c.minmoney, '', -1000000000, c.minmoney) minmoney, decode(c.maxmoney, '', 99999999999, c.maxmoney) maxmoney, decode(c.userid, '', 0, 1) ifwt from (select b.user_id from com_relation_ua b where b.main_user_id in (select main_user_id from com_relation_ua where user_id = (select userid from base_user where id = '96543')) union all select userid user_id from base_user where id='96543' ) a inner join base_user b on a.user_id = b.userid left join (select userid, decode(to_char(process_id), '', '', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '96543' and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') and ISEND = 0) c on b.id = c.userid group by b.id, process_id, c.minmoney, c.maxmoney, c.userid )group by participant, process_id ) )uu on tt.participant=uu.participant and (process_id='' or process_id=tt.process_def_id) )a inner join tmsfzwf.T_PROCESS_DEF_MANAGE b on a.PROCESS_DEF_ID = b.PROCESS_ID inner join (select * from tmsfzwf.T_PROCESS_INS where state='2') c on a.PROCESS_INS_ID = c.PROCESS_INS_ID left join ( select * from tmsfzwf.tfas_process_ins_exp where state='0' ) d on (a.process_ins_id=d.process_ins_id or c.parent_process_ins_id=d.process_ins_id) and ((a.ifwt = 0 and d.money >= a.minmoney and d.money <= a.maxmoney) or (a.ifwt = 1 and (d.money < a.minmoney or d.money > a.maxmoney))) left join (select * from tmsfzwf.T_PROCESS_INS where state='2' and parent_process_ins_id is null ) p on c.parent_process_ins_id=p.process_ins_id left join com_budget_subject e on substr(d.company_id, 0, length(d.company_id)-2) = e.company_id and e.budge t_year=substr(c.CREATED_TIME, 0, 4) and d.TASK_TYPE=e.budget_id left join (select userid, decode(to_char(process_id), '', '*', to_char(process_id)) process_id, minmoney, maxmoney from tmsfzwf.tfas_user_reassign where userid = '96543' and ISEND = 0 and starttime<=to_char(sysdate, 'yyyy-MM-dd') and endtime>=to_char(sysdate, 'yyyy-MM-dd') )f on to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID where d.note is not null and ( (to_char(a.PROCESS_DEF_ID) = f.PROCESS_ID and f.userid is not null and (d.money < f.minmoney or d.money > f.maxmoney)) or (f.userid is null and d.money >= f.minmoney and d.money <= f.maxmoney) or (f.userid is null and f.minmoney is null and f.maxmoney is null)) order by d.BAR_STATE, decode(substr(note, 0, 3), '��ˮ��', substr(note, 5, 6), '') desc , d.STARTER, d.START_DEPT_NAME, b.PROCESS_TYPE, a.CREATED_TIME DESC
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
b6rx9306f2w6z	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A370900_6406_1311_0003') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A370900_6406_1311_0003') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A370900_6406_1311_0003' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A370900_6406_1311_0003' ORDER BY m.ID
bb16zxqq5vzbt	SELECT COUNT(*) AS RowsCount FROM (select d.name, d.code, d.bank_code, d.bank_type from base_lhh d where d.state ='1' and d.name like '%��%' order by d.code) TEMP_EXPPAGEQUERY
bd4bznqbq73hk	select bo#, intcol# from icoldep$ where obj#=:1
bymd50n9jgthm	select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '35889' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='35889') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)
c6awqs517jpj0	select /+ index(idl_char$ i_idl_char1) +/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
dqx3b5hzrw222	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A370500_02_1312_0004') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A370500_02_1312_0004') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A370500_02_1312_0004' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A370500_02_1312_0004' ORDER BY m.ID
fs7muf6d2sx1f	SELECT DISTINCT decode(m.i_department_id, '', i.i_department_id, m.i_department_id)I_DEPARTMENT_ID, decode(m.i_company_id, '', i.i_company_id, m.i_company_id)I_COMPANY_ID, decode(m.I_COMPANY_COST, '', i.i_company_cost, m.I_COMPANY_COST)I_COMPANY_COST, decode(m.i_department_name, '', i.i_department_name, m.i_department_name)i_department_name, m., b.account_id, b.cash_code, b.credence_code, b.credence_time, c.active_name AS active_id_label, NVL (d.budget_money, 0) AS budget_money, NVL (d.consumed_money, 0) AS consumed_money, NVL (d.useable_money, 0) AS useable_money, NVL (d.precontract_money, 0) AS precontract_money, pc.TOTAL_MONEY, pc.CONSUMED_MONEY CHARGE_CONSUMED_MONEY, (TOTAL_MONEY-pc.CONSUMED_MONEY-TRANSITION_MONEY)PersonCharge, m.ad_thin, m.ad_type, m.money_type, m.exchange_rate, m.foreign_currency, m.charge_name, m.project_team, m.E_ZF, NVL (m.BUDGET_STANDARD_MONEY, 0) AS BUDGET_STANDARD_MONEY, NVL (m.OCCUR_BUDGET_BALANCE, 0) AS OCCUR_BUDGET_BALANCE, NVL (m.OCCURRED_BUDGET_BALANCE, 0) AS OCCURRED_BUDGET_BALANCE, NVL (m.EXCEED_BUDGET_MONEY, 0) AS EXCEED_BUDGET_MONEY, NVL (m.COMPLETE_RATE, 0) AS COMPLETE_RATE, m.ISBEFOREHAND, MM.BUDGET_YEAR, c.check_id, c.check_title, m.ACCOUNT_ID, c.active_type_id, m.SPEC_TYPE FROM ( select r., sap.specialty_name as spec_name, sap.duty_center_name, sap.dept_archives_name, sap.render_product_name, cbo.name as s_department_id_lable from r_sub r left join com_budget_organ cbo on r.s_department_id=cbo.code left join SAP_RENDER_SUB sap on r.sub_guid=sap.sub_guid where r.r_code='R_6_A3700_13_1312_0003') m LEFT JOIN (select * from R_MAIN where r_code = 'R_6_A3700_13_1312_0003') MM ON MM.R_CODE = M.R_CODE LEFT JOIN ( select r_code, charge_id, max(account_id)account_id, max(cash_code)cash_code, max(credence_code)credence_code, max(credence_time)credence_time from r_sub_pay_balance where r_code = 'R_6_A3700_13_1312_0003' group by r_code, charge_id ) b ON m.r_code = b.r_code AND m.ID = b.charge_id LEFT JOIN com_activeproject c ON m.active_id = c.active_code LEFT JOIN budget_p_deduct d ON d.active_id = c.active_code AND m.budget_id = d.budget_id AND m.department_id = d.department_id AND d.BUDGET_YEAR = MM.BUDGET_YEAR LEFT JOIN com_i_department i ON m.department_id = i.department_id AND i.TYPE = '1' left join BUDGET_YEAR_PERSON_CHARGE pc on pc.budget_id=m.budget_id and pc.USER_ID=substr(BURDEN_USER_ID, 0, instr(BURDEN_USER_ID, ';')-1) and pc.department_code = d.department_id and pc.year_time = MM.BUDGET_YEAR WHERE m.r_code = 'R_6_A3700_13_1312_0003' ORDER BY m.ID
g549wdgtgm842	select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '35882' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='35882') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)
ga9j9xk5cy9s0	select /+ index(idl_sb4$ i_idl_sb41) +/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gfgc7ttzq8p7f	select a.account_id id, a.full_name title, a.parent_id parentid from com_accountant_subject a where exists (select 1 from com_accountant_subject b where b.wl_type='3' and b.account_year = '2013' and instr(b.account_id, a.account_id)=1) and a.account_year = '2013' order by a.account_id
gnvqzf1b2cchr	select b.username from ( select participant from T_WORKITEM where PROCESS_INS_ID = '36016' or PROCESS_INS_ID in (select process_ins_id from t_process_ins p where p.parent_process_ins_id='36016') ) a inner join tmsfz.base_user b on a.participant=to_char(b.id)

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

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	1	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	11	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	6	0.00	0.00
Batched IO same unit count	2	0.00	0.00
Batched IO single block count	6	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	2	0.00	0.00
Batched IO vector read count	1	0.00	0.00
Block Cleanout Optim referenced	256	0.07	0.01
CCursor + sql area evicted	48	0.01	0.00
CPU used by this session	136,093	37.76	4.33
CPU used when call started	123,978	34.40	3.94
CR blocks created	1,549	0.43	0.05
Cached Commit SCN referenced	60	0.02	0.00
Clusterwide global transactions	0	0.00	0.00
Commit SCN cached	1,673	0.46	0.05
DB time	791,174	219.52	25.16
DBWR checkpoint buffers written	40,893	11.35	1.30
DBWR checkpoints	6	0.00	0.00
DBWR fusion writes	2,225	0.62	0.07
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	121	0.03	0.00
DBWR undo block writes	5,002	1.39	0.16
DFO trees parallelized	16	0.00	0.00
DX/BB enqueue lock background get time	0	0.00	0.00
DX/BB enqueue lock background gets	0	0.00	0.00
DX/BB enqueue lock foreground requests	0	0.00	0.00
DX/BB enqueue lock foreground wait time	0	0.00	0.00
Effective IO time	5,222	1.45	0.17
HSC Heap Segment Block Changes	141,543	39.27	4.50
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	978	0.27	0.03
Heap Segment Array Updates	3,313	0.92	0.11
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	116	0.03	0.00
PX local messages recv'd	40	0.01	0.00
PX local messages sent	40	0.01	0.00
PX remote messages recv'd	72	0.02	0.00
PX remote messages sent	72	0.02	0.00
Parallel operations not downgraded	16	0.00	0.00
Requests to/from client	597,952	165.90	19.01
RowCR - row contention	31	0.01	0.00
RowCR attempts	1,536	0.43	0.05
RowCR hits	1,501	0.42	0.05
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	11	0.00	0.00
SQL*Net roundtrips to/from client	598,003	165.92	19.01
SQL*Net roundtrips to/from dblink	0	0.00	0.00
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	4,029	1.12	0.13
application wait time	1,066	0.30	0.03
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	7	0.00	0.00
background checkpoints started	6	0.00	0.00
background timeouts	36,033	10.00	1.15
branch node splits	3	0.00	0.00
buffer is not pinned count	2,540,989	705.01	80.79
buffer is pinned count	54,873,844	15,225.01	1,744.74
bytes received via SQL*Net from client	85,462,560	23,712.00	2,717.32
bytes received via SQL*Net from dblink	0	0.00	0.00
bytes sent via SQL*Net to client	245,404,861	68,088.75	7,802.77
bytes sent via SQL*Net to dblink	0	0.00	0.00
calls to get snapshot scn: kcmgss	332,622	92.29	10.58
calls to kcmgas	95,087	26.38	3.02
calls to kcmgcs	413,997	114.87	13.16
cell physical IO interconnect bytes	892,319,744	247,578.37	28,371.74
change write time	541	0.15	0.02
cleanout - number of ktugct calls	3,884	1.08	0.12
cleanouts and rollbacks - consistent read gets	1,520	0.42	0.05
cleanouts only - consistent read gets	114	0.03	0.00
cluster key scan block gets	29,724	8.25	0.95
cluster key scans	9,820	2.72	0.31
cluster wait time	833	0.23	0.03
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	25	0.01	0.00
commit batch/immediate requested	25	0.01	0.00
commit cleanout failures: block lost	69	0.02	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	79	0.02	0.00
commit cleanout failures: cannot pin	3	0.00	0.00
commit cleanouts	109,598	30.41	3.48
commit cleanouts successfully completed	109,447	30.37	3.48
commit immediate performed	25	0.01	0.00
commit immediate requested	25	0.01	0.00
commit txn count during cleanout	9,257	2.57	0.29
concurrency wait time	605	0.17	0.02
consistent changes	16,409	4.55	0.52
consistent gets	43,671,029	12,116.74	1,388.54
consistent gets - examination	3,859,836	1,070.93	122.73
consistent gets direct	181	0.05	0.01
consistent gets from cache	43,670,847	12,116.68	1,388.54
consistent gets from cache (fastpath)	39,372,036	10,923.96	1,251.85
cursor authentications	7,888	2.19	0.25
data blocks consistent reads - undo records applied	16,381	4.54	0.52
db block changes	675,682	187.47	21.48
db block gets	809,667	224.65	25.74
db block gets direct	101	0.03	0.00
db block gets from cache	809,566	224.62	25.74
db block gets from cache (fastpath)	285,498	79.21	9.08
deferred (CURRENT) block cleanout applications	61,872	17.17	1.97
dirty buffers inspected	40	0.01	0.00
enqueue conversions	3,898	1.08	0.12
enqueue releases	393,530	109.19	12.51
enqueue requests	393,593	109.20	12.51
enqueue timeouts	32	0.01	0.00
enqueue waits	244	0.07	0.01
exchange deadlocks	0	0.00	0.00
execute count	342,313	94.98	10.88
failed probes on index block reclamation	6	0.00	0.00
file io wait time	46,369,863	12,865.54	1,474.35
frame signature mismatch	0	0.00	0.00
free buffer inspected	25,717	7.14	0.82
free buffer requested	28,230	7.83	0.90
gc blocks compressed	5,471	1.52	0.17
gc cr block flush time	12	0.00	0.00
gc cr block receive time	126	0.03	0.00
gc cr blocks received	2,977	0.83	0.09
gc cr blocks served	6,827	1.89	0.22
gc current block flush time	4	0.00	0.00
gc current block pin time	6	0.00	0.00
gc current block receive time	294	0.08	0.01
gc current blocks received	6,117	1.70	0.19
gc current blocks served	7,148	1.98	0.23
gc kbytes saved	15,995	4.44	0.51
gc kbytes sent	95,804	26.58	3.05
gc local grants	8,384	2.33	0.27
gc read wait time	0	0.00	0.00
gc read waits	0	0.00	0.00
gc remote grants	8,757	2.43	0.28
gcs messages sent	74,845	20.77	2.38
ges messages sent	11,044	3.06	0.35
global enqueue get time	1,115	0.31	0.04
global enqueue gets async	7,401	2.05	0.24
global enqueue gets sync	600,593	166.64	19.10
global enqueue releases	605,139	167.90	19.24
global undo segment hints helped	0	0.00	0.00
heap block compress	2,980	0.83	0.09
hot buffers moved to head of LRU	42,164	11.70	1.34
immediate (CR) block cleanout applications	1,634	0.45	0.05
immediate (CURRENT) block cleanout applications	11,867	3.29	0.38
in call idle wait time	17,749,565	4,924.70	564.36
index crx upgrade (positioned)	2,742	0.76	0.09
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	21,687	6.02	0.69
index fetch by key	1,486,917	412.55	47.28
index scans kdiixs1	33,156,416	9,199.41	1,054.22
leaf node 90-10 splits	133	0.04	0.00
leaf node splits	476	0.13	0.02
lob reads	38	0.01	0.00
lob writes	250	0.07	0.01
lob writes unaligned	250	0.07	0.01
logical read bytes from cache	364,383,518,720	101,099,946.90	11,585,753.04
logons cumulative	432	0.12	0.01
max cf enq hold time	0	0.00	0.00
messages received	76,030	21.09	2.42
messages sent	76,030	21.09	2.42
min active SCN optimization applied on CR	80	0.02	0.00
no buffer to keep pinned count	8,628	2.39	0.27
no work - consistent read gets	39,030,445	10,829.18	1,240.99
non-idle wait count	1,115,184	309.41	35.46
non-idle wait time	17,432	4.84	0.55
opened cursors cumulative	282,631	78.42	8.99
parse count (describe)	48	0.01	0.00
parse count (failures)	5	0.00	0.00
parse count (hard)	146,932	40.77	4.67
parse count (total)	204,031	56.61	6.49
parse time cpu	87,124	24.17	2.77
parse time elapsed	93,281	25.88	2.97
physical read IO requests	8,892	2.47	0.28
physical read bytes	72,974,336	20,247.08	2,320.25
physical read total IO requests	19,027	5.28	0.60
physical read total bytes	238,579,712	66,195.08	7,585.76
physical read total multi block requests	0	0.00	0.00
physical reads	8,908	2.47	0.28
physical reads cache	8,719	2.42	0.28
physical reads cache prefetch	24	0.01	0.00
physical reads direct	189	0.05	0.01
physical reads direct (lob)	116	0.03	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	33,047	9.17	1.05
physical write bytes	349,929,472	97,089.60	11,126.18
physical write total IO requests	103,651	28.76	3.30
physical write total bytes	653,740,032	181,383.29	20,785.99
physical write total multi block requests	339	0.09	0.01
physical writes	42,716	11.85	1.36
physical writes direct	109	0.03	0.00
physical writes direct (lob)	95	0.03	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	42,607	11.82	1.35
physical writes non checkpoint	11,702	3.25	0.37
pinned buffers inspected	0	0.00	0.00
pinned cursors current	47	0.01	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	39	0.01	0.00
process last non-idle time	3,626	1.01	0.12
queries parallelized	16	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	429,632	119.20	13.66
recursive cpu usage	86,747	24.07	2.76
redo blocks checksummed by FG (exclusive)	28,786	7.99	0.92
redo blocks written	237,478	65.89	7.55
redo buffer allocation retries	16	0.00	0.00
redo entries	385,376	106.92	12.25
redo log space requests	16	0.00	0.00
redo log space wait time	42	0.01	0.00
redo ordering marks	4,899	1.36	0.16
redo size	107,961,272	29,954.37	3,432.68
redo size for direct writes	4,984	1.38	0.16
redo subscn max counts	7,080	1.96	0.23
redo synch long waits	440	0.12	0.01
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	4,161	1.15	0.13
redo synch time (usec)	41,601,913	11,542.65	1,322.75
redo synch writes	31,445	8.72	1.00
redo wastage	9,593,936	2,661.88	305.04
redo write broadcast ack count	24,765	6.87	0.79
redo write broadcast ack time	3,599,308	998.65	114.44
redo write broadcast lgwr post count	0	0.00	0.00
redo write time	3,414	0.95	0.11
redo writes	33,262	9.23	1.06
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	505	0.14	0.02
rollbacks only - consistent read gets	36	0.01	0.00
root node splits	0	0.00	0.00
rows fetched via callback	231,731	64.29	7.37
scheduler wait time	0	0.00	0.00
serializable aborts	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	72,778	20.19	2.31
session logical reads	44,480,735	12,341.39	1,414.29
shared hash latch upgrades - no wait	393,826	109.27	12.52
shared hash latch upgrades - wait	53	0.01	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	93,029	25.81	2.96
sorts (rows)	7,885,032	2,187.74	250.71
sql area evicted	147,603	40.95	4.69
sql area purged	5	0.00	0.00
summed dirty queue length	21	0.01	0.00
switch current to new buffer	5,280	1.46	0.17
table fetch by rowid	26,743,765	7,420.19	850.33
table fetch continued row	9,006	2.50	0.29
table scan blocks gotten	3,491,310	968.68	111.01
table scan rows gotten	220,801,310	61,262.38	7,020.49
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	117,142	32.50	3.72
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	950	0.26	0.03
total number of cf enq holders	172	0.05	0.01
total number of times SMON posted	16	0.00	0.00
transaction lock background gets	4	0.00	0.00
transaction lock foreground requests	4	0.00	0.00
transaction lock foreground wait time	1	0.00	0.00
transaction rollbacks	24	0.01	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	35,302,572	9,794.87	1,122.46
user I/O wait time	3,601	1.00	0.11
user calls	837,959	232.50	26.64
user commits	31,443	8.72	1.00
user rollbacks	8	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	101,832	28.25	3.24
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	322,156,237,920	322,491,809,344
session cursor cache count	6,304,210	6,310,149
session uga memory	302,960,356,780,376	303,037,697,248,320
opened cursors current	488	543
workarea memory allocated	0	102
logons current	270	277
session uga memory max	493,453,409,248	493,980,225,208
session pga memory	241,237,192,608	241,367,114,752

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	6	5.99

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
DBWR	0M	0.00	0M	333M	9.14	.092392	0
LGWR	1M	0.03	.000277	233M	18.58	.064646	33.4K	0.65
Others	156M	2.80	.043282	56M	1.01	.015537	11.9K	0.36
Buffer Cache Reads	68M	2.41	.018866	0M	0.00	0M	8683	3.68
Direct Reads	1M	0.03	.000277	0M	0.00	0M	0
Direct Writes	0M	0.00	0M	0M	0.01	0M	0
Streams AQ	0M	0.00	0M	0M	0.00	0M	4	5.00
TOTAL:	226M	5.28	.062704	622M	28.74	.172576	54K	1.07

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

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read
Data File	70M	2.47	.019421	331M	9.17	.091837	3.61
Log File	0M	0.01	0M	231M	18.54	.064092	2.25
Control File	157M	2.80	.043560	58M	1.03	.016092	0.14
TOTAL:	227M	5.28	.062982	620M	28.74	.172021	1.77

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
DBWR	0M	0.00	0M	333M	9.14	.092392	0
DBWR (Data File)	0M	0.00	0M	333M	9.14	.092392	0
LGWR	1M	0.03	.000277	233M	18.58	.064646	138	1.70
LGWR (Log File)	0M	0.01	0M	231M	18.54	.064092	48	2.98
LGWR (Control File)	1M	0.02	.000277	2M	0.04	.000554	90	1.02
Others	157M	2.80	.043560	56M	1.01	.015537	10.1K	0.15
Others (Control File)	157M	2.78	.043560	56M	0.99	.015537	10K	0.13
Others (Data File)	0M	0.02	0M	0M	0.02	0M	73	2.52
Buffer Cache Reads	68M	2.41	.018866	0M	0.00	0M	8676	3.67
Buffer Cache Reads (Data File)	68M	2.41	.018866	0M	0.00	0M	8676	3.67
Direct Reads	1M	0.03	.000277	0M	0.00	0M	0
Direct Reads (Data File)	1M	0.03	.000277	0M	0.00	0M	0
Streams AQ	0M	0.00	0M	0M	0.00	0M	4	5.00
Streams AQ (Data File)	0M	0.00	0M	0M	0.00	0M	4	5.00
Direct Writes	0M	0.00	0M	0M	0.01	0M	0
Direct Writes (Data File)	0M	0.00	0M	0M	0.01	0M	0
TOTAL:	227M	5.28	.062982	622M	28.74	.172576	18.9K	1.78

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits
TMSFZ	8,261	2	4.13	1.00	31,401	9	13
SYSAUX	255	0	2.90	1.01	969	0	0
UNDOTBS1	2	0	0.00	1.00	525	0	15
SYSTEM	377	0	2.04	1.00	120	0	2
SXPACS	1	0	0.00	1.00	1	0	0
UNDOTBS2	1	0	0.00	1.00	1	0	0
USERS	1	0	0.00	1.00	1	0	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits
SXPACS	+DATA/sscdb/datafile/sxpacs01.dbf	1	0	0.00	1.00	1	0	0
SYSAUX	+DATA/sscdb/datafile/sysaux.257.825609769	255	0	2.90	1.01	969	0	0
SYSTEM	+DATA/sscdb/datafile/system.256.825609769	377	0	2.04	1.00	120	0	2
TMSFZ	+DATA/sscdb/datafile/tmsfz01.dbf	4,014	1	4.15	1.00	15,299	4	7
TMSFZ	+DATA/sscdb/datafile/tmsfz02.dbf	4,247	1	4.12	1.00	16,102	4	6
UNDOTBS1	+DATA/sscdb/datafile/undotbs1.258.825609769	2	0	0.00	1.00	525	0	15
UNDOTBS2	+DATA/sscdb/datafile/undotbs2.267.825609943	1	0	0.00	1.00	1	0	0
USERS	+DATA/sscdb/datafile/users.259.825609769	1	0	0.00	1.00	1	0	0

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	169,920	100	44,480,609	8,722	42,607	0	0	30

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 42,716

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	40,891	0

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

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	3	3877	24484	82944	82944	139788			1
E	0	3	3978	23199	82944	82944	126531			1

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

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	144	0.10	17	3.23	58,111	1	53729.00
D	288	0.20	34	1.53	27,555	1	20985.00
D	432	0.30	51	1.12	20,218	1	13123.00
D	576	0.40	68	1.02	18,388	1	11163.00
D	720	0.49	85	1.00	18,073	1	10825.00
D	864	0.59	102	1.00	18,036	1	10785.00
D	1,008	0.69	119	1.00	18,023	1	10771.00
D	1,152	0.79	136	1.00	18,014	1	10761.00
D	1,296	0.89	153	1.00	18,006	1	10753.00
D	1,440	0.99	170	1.00	17,999	1	10746.00
D	1,456	1.00	172	1.00	17,999	1	10745.00
D	1,584	1.09	187	1.00	17,993	1	10739.00
D	1,728	1.19	204	1.00	17,988	1	10734.00
D	1,872	1.29	221	1.00	17,984	1	10729.00
D	2,016	1.38	238	1.00	17,979	1	10724.00
D	2,160	1.48	255	1.00	17,976	1	10720.00
D	2,304	1.58	272	1.00	17,973	1	10717.00
D	2,448	1.68	289	1.00	17,970	1	10714.00
D	2,592	1.78	306	1.00	17,962	1	10706.00
D	2,736	1.88	323	0.98	17,675	1	10398.00
D	2,880	1.98	340	0.88	15,901	1	8497.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	15,626	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	28,672	25,252	929.42	0.00	0.00	0.00	0.00	1,048,576
E	28,672	25,228	971.15	0.10	0.01	100.00	0.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	85,622	85,622
64K	128K	2,191	2,191
128K	256K	274	274
256K	512K	114	114
512K	1024K	8,151	8,151
1M	2M	3,542	3,542
2M	4M	1,919	1,919
4M	8M	2	2
8M	16M	10	10

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd Time
3,584	0.13	5,118,792.81	10,114.05	100.00	1,015,264,265
7,168	0.25	5,118,792.81	67.06	100.00	1,013,275,469
14,336	0.50	5,118,792.81	67.06	100.00	1,013,275,469
21,504	0.75	5,118,792.81	67.06	100.00	1,013,275,469
28,672	1.00	5,118,792.81	67.06	100.00	1,013,275,469
34,406	1.20	5,118,792.81	0.00	100.00	1,013,262,194
40,141	1.40	5,118,792.81	0.00	100.00	1,013,262,194
45,875	1.60	5,118,792.81	0.00	100.00	1,013,262,194
51,610	1.80	5,118,792.81	0.00	100.00	1,013,262,194
57,344	2.00	5,118,792.81	0.00	100.00	1,013,262,194
86,016	3.00	5,118,792.81	0.00	100.00	1,013,262,194
114,688	4.00	5,118,792.81	0.00	100.00	1,013,262,194
172,032	6.00	5,118,792.81	0.00	100.00	1,013,262,194
229,376	8.00	5,118,792.81	0.00	100.00	1,013,262,194

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
1,472	0.59	92	14,805	1,738,279	0.06	28,346,472	92.68	168,522
1,728	0.69	347	26,283	9,925,013	0.33	20,159,738	65.91	376,976
1,984	0.79	602	39,591	16,916,547	0.57	13,168,204	43.05	519,197
2,240	0.90	857	52,415	23,605,861	0.79	6,478,890	21.18	615,283
2,336	0.94	952	57,042	26,096,088	0.88	3,988,663	13.04	650,913
2,352	0.94	968	57,889	26,511,518	0.89	3,573,233	11.68	656,843
2,368	0.95	984	58,627	26,926,454	0.90	3,158,297	10.33	662,776
2,384	0.96	1,000	59,621	27,342,086	0.92	2,742,665	8.97	668,718
2,400	0.96	1,016	60,296	27,753,698	0.93	2,331,053	7.62	674,601
2,416	0.97	1,032	60,970	28,166,326	0.95	1,918,425	6.27	680,523
2,432	0.97	1,048	61,755	28,551,593	0.96	1,533,158	5.01	686,155
2,448	0.98	1,064	62,563	28,920,552	0.97	1,164,199	3.81	691,716
2,464	0.99	1,079	63,433	29,230,769	0.98	853,982	2.79	699,088
2,480	0.99	1,095	64,177	29,499,291	0.99	585,460	1.91	703,118
2,496	1.00	1,111	65,090	29,778,904	1.00	305,847	1.00	707,530
2,512	1.01	1,127	65,889	29,786,836	1.00	297,915	0.97	708,437
2,528	1.01	1,143	66,612	29,786,978	1.00	297,773	0.97	708,475
2,544	1.02	1,158	67,560	29,787,090	1.00	297,661	0.97	708,515
2,560	1.03	1,174	68,450	29,787,212	1.00	297,539	0.97	708,553
2,576	1.03	1,189	69,446	29,787,345	1.00	297,406	0.97	708,595
2,592	1.04	1,205	70,327	29,787,461	1.00	297,290	0.97	708,632
2,608	1.04	1,221	71,172	29,787,570	1.00	297,181	0.97	708,668
2,624	1.05	1,237	71,737	29,787,689	1.00	297,062	0.97	708,707
2,640	1.06	1,252	72,467	29,787,810	1.00	296,941	0.97	708,745
2,752	1.10	1,364	78,081	29,788,591	1.00	296,160	0.97	708,999
3,008	1.21	1,620	90,497	29,790,355	1.00	294,396	0.96	709,645
3,264	1.31	1,875	103,330	29,792,021	1.00	292,730	0.96	710,320
3,520	1.41	2,131	116,108	29,793,767	1.00	290,984	0.95	711,105
3,776	1.51	2,386	127,837	29,795,516	1.00	289,235	0.95	711,942
4,032	1.62	2,642	140,675	29,797,203	1.00	287,548	0.94	712,771
4,288	1.72	2,897	152,713	29,799,324	1.00	285,427	0.93	713,635
4,544	1.82	3,152	165,751	29,801,039	1.00	283,712	0.93	714,464
4,800	1.92	3,407	177,985	29,802,639	1.00	282,112	0.92	715,202
5,056	2.03	3,663	190,294	29,803,972	1.00	280,779	0.92	715,864

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,048	0.50	20,931,860	57,871,040
2,560	0.63	4,669,586	57,871,040
3,072	0.75	916,634	20,135,083
3,584	0.88	913,087	17,998,644
4,096	1.00	909,630	17,998,644
4,608	1.13	906,082	17,998,644
5,120	1.25	902,262	17,998,644
5,632	1.38	898,987	17,998,644
6,144	1.50	897,532	17,948,248
6,656	1.63	897,532	17,919,450
7,168	1.75	897,532	17,905,051
7,680	1.88	896,622	15,835,207
8,192	2.00	895,258	15,835,207

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	0.50	0	0	0	0
32	1.00	0	0	0	0
48	1.50	0	0	0	0
64	2.00	0	0	0	0
80	2.50	0	0	0	0
96	3.00	0	0	0	0
112	3.50	0	0	0	0
128	4.00	0	0	0	0
144	4.50	0	0	0	0
160	5.00	0	0	0	0
176	5.50	0	0	0	0
192	6.00	0	0	0	0
208	6.50	0	0	0	0
224	7.00	0	0	0	0
240	7.50	0	0	0	0
256	8.00	0	0	0	0
272	8.50	0	0	0	0
288	9.00	0	0	0	0
304	9.50	0	0	0	0
320	10.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)	JP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
16	0.33	7	155	5	1.00	305,848	1.00	145
32	0.67	7	155	5	1.00	305,848	1.00	145
48	1.00	7	155	5	1.00	305,848	1.00	145
64	1.33	7	155	5	1.00	305,848	1.00	145
80	1.67	7	155	5	1.00	305,848	1.00	145
96	2.00	7	155	5	1.00	305,848	1.00	145
112	2.33	7	155	5	1.00	305,848	1.00	145
128	2.67	7	155	5	1.00	305,848	1.00	145
144	3.00	7	155	5	1.00	305,848	1.00	145
160	3.33	7	155	5	1.00	305,848	1.00	145
176	3.67	7	155	5	1.00	305,848	1.00	145
192	4.00	7	155	5	1.00	305,848	1.00	145

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	15	0	0
undo block	10	0	0
undo header	5	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Av Wt Time(ms)
TM-DML	59,019	59,018	0	13	6.15
JQ-Job Queue	49	18	31	37	0.54
TD-KTF map table enqueue (KTF dump entries)	8	8	0	8	2.50
FB-Format Block	63	63	0	23	0.43
WF-AWR Flush	22	22	0	19	0.53
TX-Transaction (index contention)	20	20	0	13	0.77
HW-Segment High Water Mark	218	218	0	12	0.83
PS-PX Process Reservation	108	108	0	48	0.00
TT-Tablespace	1,771	1,771	0	13	0.00
TA-Instance Undo	13	13	0	12	0.00
CF-Controlfile Transaction	8,104	8,104	0	10	0.00
US-Undo Segment	13	13	0	7	0.00
CR-Reuse Block Range (block range reuse ckpt)	114	114	0	3	0.00
TX-Transaction	34,497	34,498	0	3	0.00
UL-User-defined	4	4	0	3	0.00
AE-Edition Lock (lock)	302	302	0	2	0.00
DR-Distributed Recovery	2	2	0	2	0.00
AF-Advisor Framework (task serialization)	13	13	0	1	0.00
JS-Job Scheduler (job run lock - synchronize)	2	2	0	1	0.00
MW-MWIN Schedule	2	2	0	1	0.00
TQ-Queue table enqueue (TM contention)	76	76	0	1	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	4.97	35,256	1,264	11	25.9/36.1	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
18-Dec 10:50	882	6,293	1,252	11	36	0/0	0/0/0/0/0/0
18-Dec 10:40	836	5,950	650	10	26	0/0	0/0/0/0/0/0
18-Dec 10:30	763	5,715	1,258	10	36	0/0	0/0/0/0/0/0
18-Dec 10:20	809	6,350	657	8	26	0/0	0/0/0/0/0/0
18-Dec 10:10	527	3,912	1,264	6	36	0/0	0/0/0/0/0/0
18-Dec 10:00	1,157	7,036	662	10	26	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Mutex Sleep Summary
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
AQ dequeue txn counter latch	3,724	0.00		0
ASM Keyed state latch	755	0.13	0.00	0
ASM allocation	304	0.00		0
ASM db client latch	2,424	0.00		0
ASM map operation freelist	422	0.24	0.00	0
ASM map operation hash table	245,545	0.00		0
ASM network background latch	1,618	0.00		0
ASM network state latch	428	0.00		0
AWR Alerted Metric Element list	39,918	0.00		0
Change Notification Hash table latch	1,201	0.00		0
Consistent RBA	33,267	0.00	0.00	0
DML lock allocation	118,073	0.00		0
Event Group Locks	813	0.00		0
FOB s.o list latch	644	0.47	0.00	0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC other latch	31	0.00		0
IPC stats buffer allocation latch	1,176	0.00		1,240	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	7	0.00		0
JS broadcast add buf latch	3,844	0.00		0
JS broadcast drop buf latch	3,845	0.00		0
JS broadcast load blnc latch	3,741	0.00		0
JS mem alloc latch	7	0.00		0
JS queue access latch	8	0.00		0
JS queue state obj latch	134,710	0.00		0
JS slv state obj latch	193	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KFK SGA Libload latch	120	0.00		0
KFMD SGA	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	3,383	0.15	0.00	237	0.00
KJCT flow control latch	149,927	0.00	0.00	0
KMG MMAN ready and startup request latch	1,201	0.00		0
KSXR large replies	242	0.00		0
KTF sga latch	28	0.00		1,179	0.00
KWQMN job cache list latch	652	0.00		0
KWQP Prop Status	2	0.00		0
KWQS pqsubs latch	3	0.00		0
KWQS pqueue ctx latch	30	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	4,933	0.02	0.00	0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	1	0.00		1,201	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	2,480	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	2,099	0.00		0
OS process allocation	8,405	0.00		0
OS process: request allocation	755	0.00		0
PL/SQL warning settings	610	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	47,340	0.00		0
SGA IO buffer pool latch	2	0.00		2	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	1	0.00		1,199	0.00
SQL memory manager workarea list latch	144,006	0.00	0.00	0
Shared B-Tree	294	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	19	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	43,333	0.21	0.00	0
active service list	12,512,128	0.07	0.00	2,998	0.13
begin backup scn array	95	0.00		0
buffer pool	1	0.00		0
business card	33	0.00		0
cache buffer handles	12,894	0.02	0.00	0
cache buffers chains	86,476,365	0.17	0.00	92,062	0.00
cache buffers lru chain	77,427	0.00		139,087	0.00
cache table scan latch	4	0.00		4	0.00
call allocation	3,406	0.50	0.71	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	798	0.13	0.00	0
channel operations parent latch	1,310,418	0.00	0.00	0
checkpoint queue latch	2,928,572	0.00	0.00	45,159	0.00
client/application info	1,933	0.00		0
compile environment latch	431	0.00		0
corrupted undo seg latch	1,539	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	84	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	84	0.00		0
dml lock allocation	84	0.00		0
done queue latch	1	0.00		0
dummy allocation	856	0.12	0.00	0
enqueue freelist latch	1	0.00		598,274	0.00
enqueue hash chains	914,423	0.00	0.00	18	0.00
enqueues	1	0.00		0
error message lists	68	0.00		0
fifth spare latch	1	0.00		0
file cache latch	294	0.00		0
flashback copy	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	195,745	0.01	0.00	7,414	0.01
gcs commit scn state	1	0.00		0
gcs opaque info freelist	14,248	0.01	0.00	0
gcs partitioned table hash	5,106,781	0.00	0.00	5,565	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	1	0.00		0
gcs resource freelist	9,185	0.00		794	0.00
gcs resource hash	165,309	0.01	0.07	0
gcs resource scan list	1	0.00		0
gcs shadows freelist	3,867	0.00		2,837	0.00
ges caches resource lists	401,145	0.01	0.00	49,001	0.00
ges deadlock list	3,169	0.00		5	0.00
ges domain table	1,200,799	0.00	0.00	0
ges enqueue table freelist	1,202,980	0.00	0.00	0
ges group table	1,199,158	0.00	0.00	0
ges process hash list	3,317	0.00		0
ges process parent latch	2,431,798	0.00		0
ges process table freelist	755	0.00		0
ges resource hash list	2,377,121	0.01	0.07	7,556	0.00
ges resource scan list	39	0.00		0
ges resource table freelist	14,783	0.00		0
ges timeout list	5,756	0.00		54	0.00
ges value block free list	16	0.00		0
global KZLD latch for mem in SGA	262	0.00		0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	1,410	0.00		18,973,092	0.02
hash table modification latch	135	0.00		0
heartbeat check	1	0.00		1,380	0.00
heartbeat structure management	0			721	0.00
internal temp table object number allocation latch	15	0.00		0
interrupt manipulation	256	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	52	0.00		51	0.00
job_queue_processes free list latch	106	0.00		0
job_queue_processes parameter latch	3,817	0.00		0
k2q global data latch	2,402	0.00		0
k2q lock allocation	1	0.00		0
kcbtsemkid latch	6	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kgnfs mount latch	1	0.00		0
kokc descriptor allocation latch	456	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	1,019	0.00		0
ksim membership request latch	0			2,098	0.00
kss move lock	47	0.00		0
ksuosstats global area	364	0.00		0
ksv allocation latch	178	0.00		0
ksv class latch	8,055	0.15	0.00	0
ksv instance latch	16	0.00		0
ksv msg queue latch	1	0.00		0
ksxp shared latch	755	0.00		0
ksxp so latch	755	0.00		0
ksz_so allocation latch	755	0.13	0.00	0
ktm global data	94	0.00		0
kwqbsn:qsga	128	0.00		0
lgwr LWN SCN	33,393	0.00	0.00	0
list of block allocation	919	0.00		0
loader state object freelist	432	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	13	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	2	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	4,890	0.00		0
messages	431,228	0.04	0.00	0
mostly latch-free SCN	33,461	0.08	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	1,278	0.00		0
name-service memory objects	15,500	0.00		0
name-service namespace bucket	27,588	0.00		0
name-service pending queue	12,928	0.00		0
name-service request queue	48,944	0.00		0
ncodef allocation latch	84	0.00		0
object queue header heap	349,216	0.00		3,677	0.00
object queue header operation	1,239,822	0.00	0.00	0
object stats modification	96	0.00		0
parallel query alloc buffer	2,317	0.00		0
parallel query stats	79	0.00		0
parallel txn reco latch	325	0.00		0
parameter list	48	0.00		0
parameter table management	1,637	0.12	0.00	0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	126,655	0.03	0.00	75,568	0.01
process allocation	18,353	0.01	0.50	381	0.00
process group creation	755	0.00		0
process queue	201	0.00		0
process queue reference	3,356	0.03	0.00	306	0.00
qmn state object latch	6	0.00		0
qmn task context latch	3	0.00		0
qmn task queue latch	904	0.55	0.20	0
query server freelists	161	0.00		0
query server process	10	0.00		0
queued dump request	12	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	167,178	0.02	0.03	384,894	0.05
redo copy	1	0.00		384,972	0.03
redo writing	145,828	0.04	0.04	0
resmgr group change latch	338	0.00		0
resmgr:active threads	856	0.00		0
resmgr:actses change group	334	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	855	0.00		0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	81	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	56,635,724	0.29	0.00	1,406	0.36
rules engine rule set statistics	100	0.00		0
second Audit Vault latch	1	0.00		0
second spare latch	1	0.00		0
sequence cache	15,866	0.00		0
session allocation	44,856	0.00		44,053	0.00
session idle bit	1,718,985	0.00	0.00	0
session queue latch	1	0.00		0
session state list latch	906	0.00		0
session switching	459	0.00		0
session timer	1,224	0.00		0
shared pool	8,246,233	0.13	0.21	0
shared pool sim alloc	1	0.00		0
shared pool simulator	583,623	0.00	0.00	0
sim partition latch	1	0.00		0
simulator hash latch	965,141	0.00		0
simulator lru latch	1	0.00		964,374	0.01
sort extent pool	148	0.00		0
space background state object latch	12	0.00		0
space background task latch	4,471	0.18	0.00	2,406	0.00
state object free list	2	0.00		0
statistics aggregation	1,120	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	2	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	142	0.00		0
transaction allocation	5,729	0.00		0
transaction branch allocation	1,224	0.00		0
undo global data	117,505	0.00	0.00	0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	56,635,724	163,357	301	163,076
cache buffers chains	86,476,365	144,183	18	144,164
shared pool	8,246,233	10,869	2,280	8,651
active service list	12,512,128	8,355	26	8,330
ges resource hash list	2,377,121	246	17	230
redo writing	145,828	55	2	53
redo allocation	167,178	29	1	28
call allocation	3,406	17	12	9
gcs resource hash	165,309	15	1	14
qmn task queue latch	904	5	1	4
process allocation	18,353	2	1	1

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
active service list	kswsite: service iterator	27	0
active service list	kswslogon: session logout	5	0
cache buffers chains	kcbgtcr: fast path (cr pin)	10	6
cache buffers chains	kcbrls: fast release	9	3
cache buffers chains	kcbget: fast exchange	1	0
cache buffers chains	kcbgtcr: fast path	1	0
call allocation	ksuxds	10	11
call allocation	ksudlp: top call	2	1
gcs resource hash	kjbopen	1	0
ges resource hash list	kjlrlr: remove lock from resource queue	7	10
ges resource hash list	kjrmas1: lookup master node	6	0
ges resource hash list	kjakcai: search for resp by resname	2	1
ges resource hash list	kjakoca: search for resp by resname	2	0
process allocation	ksucrp:1	1	0
qmn task queue latch	kwqmngettsk: get task	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
redo writing	kcrfwcr	2	2
row cache objects	kqreqd: reget	126	8
row cache objects	kqrso	92	98
row cache objects	kqrpre: find obj	55	149
row cache objects	kqreqd	26	44
row cache objects	kqrigt	1	0
shared pool	kghalo	1,958	1,047
shared pool	kghalp	271	604
shared pool	kghupr1	35	523
shared pool	kgh_heap_sizes	14	90
shared pool	kghasp	1	12
shared pool	kghfre	1	3
shared pool	kghfrunp: clatch: nowait	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Cursor Pin	kkslce [KKSCHLPIN2]	296
Library Cache	kglget1 1	261
Library Cache	kgllkdl1 85	110
Library Cache	kgldtin1 42	32
Library Cache	kglhdgn2 106	21
Library Cache	kglpnal2 91	16
Library Cache	kglhdgh1 64	14
Library Cache	kglpin1 4	12
Library Cache	kglobpn1 71	10
Library Cache	kglhdgn1 62	9
Library Cache	kgllkal1 80	9
Library Cache	kglpnal1 90	7
Library Cache	kgllkc1 57	5
Library Cache	kglrfcl1 79	3
Library Cache	kglget2 2	2

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Segments by Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 44,480,735
Captured Segments account for 95.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TMSFZWF	TMSFZ	IDX_PARENT_PROCESS_INS_ID	INDEX	28,573,200	64.24
TMSFZ	TMSFZ	PK_BUDGET_P_DEDUCT_SPECIALTY	INDEX	5,917,568	13.30
TMSFZWF	TMSFZ	T_WORKITEM	TABLE	1,011,264	2.27
TMSFZ	TMSFZ	BASE_LHH	TABLE	801,136	1.80
TMSFZ	TMSFZ	IND_BUDGET_P_USEDEPT1	INDEX	675,056	1.52

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	65.37	Soft Parse %:	27.99
Execute to Parse %:	40.40	Latch Hit %:	99.83
Parse CPU to Parse Elapsd %:	93.40	% Non-Parse CPU:	37.58

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

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	0.4
Avg global cache current block receive time (ms):	0.5
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 %:	2.4
Avg global cache cr block flush time (ms):	0.7
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.3
Avg global cache current block flush time (ms):	1.7

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.7
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	70.21
% of indirect sent messages:	29.72
% of flow controlled messages:	0.07

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TMSFZ	TMSFZ	IDX_SAP_PZ_PROPERTY_GUID	INDEX	769	8.63
TMSFZ	TMSFZ	BASE_BIZLOG	TABLE	728	8.17
TMSFZ	TMSFZ	PK_BASE_BIZLOG	INDEX	601	6.75
TMSFZ	TMSFZ	SAP_PZ_PROPERTY	TABLE	422	4.74
TMSFZWF	TMSFZ	IDX_ARGS_WORKITEM_ID	INDEX	420	4.71

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	SYS_LOB0000006339C00038$$		LOB	73	66.97
SYS	SYSAUX	SYS_LOB0000006331C00004$$		LOB	22	20.18

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
TMSFZ	TMSFZ	PK_BASE_ROLE_RESOURCES	INDEX	17,283	79.69
TMSFZ	TMSFZ	IND_BASE_USER3	INDEX	1,925	8.88
TMSFZ	TMSFZ	IDX_USER_COM	INDEX	1,917	8.84
TMSFZ	TMSFZ	IDX_COM_RELATION_BSA	INDEX	12	0.06
TMSFZWF	TMSFZ	IDX_PARENT_PROCESS_INS_ID	INDEX	3	0.01

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
TMSFZWF	TMSFZ	T_FORM_APP_ARGS	TABLE	75,568	27.90
TMSFZWF	TMSFZ	IDX_ARGS_WORKITEM_ID	INDEX	38,384	14.17
TMSFZWF	TMSFZ	T_RELEVANT_DATA	TABLE	26,272	9.70
TMSFZWF	TMSFZ	PK_T_RELEVANT_DATA	INDEX	17,936	6.62
TMSFZ	TMSFZ	BASE_BIZLOG	TABLE	16,320	6.02

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
TMSFZ	TMSFZ	IDX_BASELOG_LOGTIME		INDEX	19	95.00
TMSFZ	TMSFZ	R_MAIN		TABLE	1	5.00

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
TMSFZ	TMSFZ	NC_PZ_WL_PAY	TABLE	368	12.36
TMSFZ	TMSFZ	BUDGET_P_DEDUCT_SPECIALTY	TABLE	226	7.59
TMSFZWF	TMSFZ	TFAS_PROCESS_INS_EXP	TABLE	205	6.89
TMSFZ	TMSFZ	BUDGET_P_DEDUCT	TABLE	193	6.48
SYS	SYSTEM	JOB$	TABLE	109	3.66

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	65	0.00	2	1
dc_files	8	100.00	0	0
dc_global_oids	5,130	0.68	0	44
dc_histogram_data	4,371,453	0.04	0	3,778
dc_histogram_defs	3,263,421	0.14	0	4,141
dc_object_grants	7	28.57	0	3
dc_objects	7,837,428	0.01	5	1,784
dc_profiles	283	0.00	0	1
dc_rollback_segments	1,736	0.00	4	28
dc_segments	1,619,683	0.05	11	1,324
dc_sequences	784	19.90	784	5
dc_tablespaces	2,048,040	0.00	0	8
dc_users	2,641,542	0.00	0	86
global database name	3,899	0.00	0	1
outstanding_alerts	30	100.00	0	0
sch_lj_oids	6	83.33	0	2

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	526	0.76	0		0	0
BODY	504	13.89	829	11.94	23	0
CLUSTER	131	9.92	131	9.92	0	0
DBLINK	528	0.00	0		0	0
EDITION	296	0.00	577	0.00	0	0
INDEX	85	28.24	85	28.24	0	0
QUEUE	898	0.33	2,450	0.24	1	0
SCHEMA	1,095	0.00	0		0	0
SQL AREA	207,244	68.56	654,658	66.51	5,063	5
SQL AREA BUILD	146,896	98.86	0		0	0
SQL AREA STATS	146,130	98.53	146,129	98.53	0	0
SUBSCRIPTION	8	62.50	8	62.50	0	0
TABLE/PROCEDURE	235,395	0.26	875,790	0.35	1,702	0
TRANSFORMATION	360	0.00	360	0.00	0	0
TRIGGER	353	0.57	1,264	0.24	1	0

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	1,440.00	1,440.00	1,440.00	1,904.00	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	28,672.00	28,672.00	28,672.00	28,672.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	4,096.00	4,096.00	4,096.00	4,096.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	48.00	48.00	48.00	48.00	STA/
large pool	16.00	16.00	16.00	16.00	STA/
shared pool	2,496.00	2,496.00	2,032.00	2,496.00	GRO/IMM
streams pool	32.00	32.00	32.00	32.00	STA/

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	756.11		2.77	2.69	24	24	273	273
B	Freeable	162.88	0.00	0.90	0.92	10		181	181
B	PL/SQL	5.64	3.94	0.02	0.07	1	1	271	271
B	SQL	4.93	1.09	0.02	0.03	0	27	236	218
E	Other	788.11		2.81	2.64	24	24	280	280
E	Freeable	172.06	0.00	0.89	0.87	10		193	193
E	PL/SQL	5.91	4.15	0.02	0.07	1	1	278	278
E	SQL	5.15	1.23	0.02	0.03	0	27	244	231

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,509,949,440
Fixed Size	2,235,208
Redo Buffers	45,686,784
Variable Size	2,717,910,200

Pool	Name	Begin MB	End MB	% Diff
java	JOXLE	8.49	8.49	0.00
java	free memory	39.16	39.16	0.00
large	ASM map operations hashta	0.38	0.38	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	7.81	7.81	0.00
shared	ASH buffers	101.60	101.60	0.00
shared	KGLH0	384.42	374.28	-2.64
shared	KGLHD	57.84	57.60	-0.42
shared	SQLA	923.44	923.15	-0.03
shared	dbwriter coalesce buffer	32.03	32.03	0.00
shared	dirty object counts array	32.00	32.00	0.00
shared	event statistics per sess	28.76	28.76	0.00
shared	free memory	300.69	309.03	2.78
shared	gcs resources	49.78	49.78	0.00
shared	gcs shadows	29.04	29.04	0.00
shared	ges enqueues	71.66	71.66	0.00
shared	ges resource	55.36	55.04	-0.58
shared	kglsim object batch	34.43	34.43	0.00
shared	ksunfy : SSO free list	26.81	26.81	0.00
streams	free memory	31.99	31.99	0.00
	buffer_cache	1,440.00	1,440.00	0.00
	fixed_sga	2.13	2.13	0.00
	log_buffer	43.57	43.57	0.00

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0929 02:01:48	0.18	0.02	0.00
QMON Coordinator	0929 02:01:38	0.17	0.00	0.00

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(12733)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(68711)	21	21	0.00	0.00	0.04	0.18	0.00	0.00

Subscriber/Queue	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE
SDYZSSCDB1_3938_SSCDB1(41)/SYS.ALERT_QUE	0.00	0.00	0.00
SDYZSSCDB2_3938_SSCDB2(61)/SYS.ALERT_QUE	0.00	0.00	0.00

Name	Total Disp Time (s)	%Busy	%Idle
D000	3,604	0.00	100.00
D000	3,604	0.00	100.00
D000	3,604	0.00	100.00
D000	3,604	0.00	100.00
Sum
Avg		0.00	100.00
Std		0.00	0.00

WORKLOAD REPOSITORY report for

Report Summary

RAC Statistics

Main Report

More RAC 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

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

Instance Activity Statistics

Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

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

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

Segment Statistics

Segments by Logical Reads

Segments by Physical Reads

Segments by Physical Read Requests

Segments by UnOptimized Reads

Segments by Optimized Reads

Segments by Direct Physical Reads

Segments by Physical Writes

Segments by Physical Write Requests

Segments by Direct Physical Writes

Segments by Table Scans

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/app/oracle/admin/sscdb/adump
audit_trail	NONE
cluster_database	TRUE
compatible	11.2.0.0.0
control_files	+DATA/sscdb/controlfile/current.261.825609847, +DATA/sscdb/controlfile/current.260.825609847
db_block_size	8192
db_create_file_dest	+DATA
db_domain
db_name	sscdb
db_recovery_file_dest	+DATA
db_recovery_file_dest_size	21474836480
diagnostic_dest	/oracle/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=sscdbXDB)
instance_number	1
local_listener	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.154.4.223)(PORT=1521))))
open_cursors	300
pga_aggregate_target	30064771072
processes	1500
remote_listener	sdyzsscdb-scan:1521
remote_login_passwordfile	EXCLUSIVE
service_names	sscdb
sga_target	4294967296
spfile	+DATA/sscdb/spfilesscdb.ora
thread	1
undo_tablespace	UNDOTBS1

Parameter Name	Begin value	End value (if different)
control_files	+DATA/sscdb/controlfile/current.260.825609847
control_files	+DATA/sscdb/controlfile/current.261.825609847

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	4,023	1.12	0.13
acks for commit broadcast(logical)	4,055	1.13	0.13
broadcast msgs on commit(actual)	33,222	9.22	1.06
broadcast msgs on commit(logical)	33,262	9.23	1.06
broadcast msgs on commit(wasted)	190	0.05	0.01
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	1	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	3,503	0.97	0.11
gcs ast xid	0	0.00	0.00
gcs blocked converts	6,400	1.78	0.20
gcs blocked cr converts	4,159	1.15	0.13
gcs compatible basts	30	0.01	0.00
gcs compatible cr basts (global)	622	0.17	0.02
gcs compatible cr basts (local)	1,619	0.45	0.05
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	1,648	0.46	0.05
gcs dbwr write request msgs	1,242	0.34	0.04
gcs delta msgs sent	0	0.00	0.00
gcs delta push aborted by cancel	0	0.00	0.00
gcs delta push aborted by remastering	0	0.00	0.00
gcs delta push cancelled	0	0.00	0.00
gcs delta push cancelled at master	0	0.00	0.00
gcs delta push cancelled by close	0	0.00	0.00
gcs delta push cancelled by consign	0	0.00	0.00
gcs delta push cancelled by cvt ping	0	0.00	0.00
gcs delta push cancelled by dwncvt	0	0.00	0.00
gcs delta push create pi	0	0.00	0.00
gcs delta update master msgs sent	0	0.00	0.00
gcs delta wait aborted by remastering	0	0.00	0.00
gcs delta wait cancelled	0	0.00	0.00
gcs error msgs	0	0.00	0.00
gcs force cr block only	4	0.00	0.00
gcs force cr grant	1	0.00	0.00
gcs force cr no current	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	990	0.27	0.03
gcs immediate (null) converts	2,073	0.58	0.07
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	1,804	0.50	0.06
gcs indirect ast	1,248	0.35	0.04
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	1,248	0.35	0.04
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	241	0.07	0.01
gcs msgs process time(ms)	1,690	0.47	0.05
gcs msgs received	68,437	18.99	2.18
gcs new served by master	394	0.11	0.01
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	3	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	0	0.00	0.00
gcs reader bypass grant X on assume	0	0.00	0.00
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	0	0.00	0.00
gcs reader bypass grant immediate	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	10	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	8,218	2.28	0.26
gcs side channel msgs logical	15,773	4.38	0.50
gcs stale cr	202	0.06	0.01
gcs undo cr	3	0.00	0.00
gcs write notification msgs	131	0.04	0.00
gcs writes refused	6	0.00	0.00
ges msgs process time(ms)	195	0.05	0.01
ges msgs received	8,592	2.38	0.27
global posts dropped	0	0.00	0.00
global posts queue time	41	0.01	0.00
global posts queued	21	0.01	0.00
global posts requested	21	0.01	0.00
global posts sent	21	0.01	0.00
implicit batch messages received	323	0.09	0.01
implicit batch messages sent	761	0.21	0.02
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	55	0.02	0.00
messages queue sent actual	21,327	5.92	0.68
messages queue sent logical	1,713	0.48	0.05
messages received actual	74,516	20.67	2.37
messages received logical	77,029	21.37	2.45
messages sent directly	55,392	15.37	1.76
messages sent indirectly	23,450	6.51	0.75
messages sent not implicit batched	0	0.00	0.00
messages sent pbatched	12,999	3.61	0.41
msgs causing lmd to send msgs	2,328	0.65	0.07
msgs causing lms(s) to send msgs	2,787	0.77	0.09
msgs received queue time (ms)	1,593	0.44	0.05
msgs received queued	77,029	21.37	2.45
msgs sent queue time (ms)	679	0.19	0.02
msgs sent queue time on ksxp (ms)	53,679	14.89	1.71
msgs sent queued	22,275	6.18	0.71
msgs sent queued on ksxp	80,766	22.41	2.57
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	39,774	11.04	1.26
process batch messages sent	8,698	2.41	0.28

Statistic	Total
CR Block Requests	6,010
CURRENT Block Requests	775
Data Block Requests	6,010
Undo Block Requests	3
TX Block Requests	73
Current Results	6,624
Private results	9
Zero Results	152
Disk Read Results	0
Fail Results	0
Fairness Down Converts	3,290
Fairness Clears	589
Free GC Elements	0
Flushes	163
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	1
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	5	0.00	20.00	80.00	0.00	0.00
Flushes	24	54.17	45.83	0.00	0.00	0.00
Writes	2,225	56.58	40.04	0.99	0.99	1.39

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	1,960	95.26	2.86	1.89	5,664	97.76	0.46	1.78
2	Others	639	98.90	0.00	1.10	456	95.83	1.97	2.19
2	undo header	410	96.10	2.68	1.22	11	72.73	27.27	0.00

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	0.55	0.53	1.26	0.55	0.54	0.53	1.92	0.56
2	others	0.48	0.48		0.52	0.48	0.45	1.66	0.42
2	undo header	0.48	0.45	1.68	0.39	0.63	0.43	1.16
2	undo block

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	1,867	100.00	0.00	5,537	100.00	0.00
2	others	0	632	100.00	0.00	437	100.00	0.00
2	undo header	0	394	100.00	0.00	8	100.00	0.00
2	undo block	0	0			0

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.03	0.02
Parallel Query	0.00	0.00
DB Locks	0.00	0.00
DB Streams	0.00	0.00
Other	0.00	0.00