WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

UPRR 1121506063 UPRR1 1 08-Jan-13 21:01 11.2.0.3.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
UPRR	1121506063	UPRR1	1	08-Jan-13 21:01	11.2.0.3.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

cn000zhj1003 Linux x86 64-bit 8 8 2 62.77

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
cn000zhj1003	Linux x86 64-bit	8	8	2	62.77

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 513 09-Jan-13 11:00:04 61 1.2

End Snap: 516 09-Jan-13 14:00:16 58 1.1

Elapsed: 180.20 (mins)

DB Time: 177.94 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	513	09-Jan-13 11:00:04	61	1.2
End Snap:	516	09-Jan-13 14:00:16	58	1.1
Elapsed:		180.20 (mins)
DB Time:		177.94 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 3,616M 3,344M Std Block Size: 8K

Shared Pool Size: 720M 816M Log Buffer: 9,496K

	Begin	End
Buffer Cache:	3,616M	3,344M	Std Block Size:	8K
Shared Pool Size:	720M	816M	Log Buffer:	9,496K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 1.0 0.1 0.07 0.01

DB CPU(s): 0.9 0.0 0.06 0.01

Redo size: 30,560.0 1,445.4

Logical reads: 212,133.9 10,033.2

Block changes: 82.3 3.9

Physical reads: 145.4 6.9

Physical writes: 8.0 0.4

User calls: 67.7 3.2

Parses: 0.8 0.0

Hard parses: 0.3 0.0

W/A MB processed: -0.2 -0.0

Logons: 0.0 0.0

Executes: 14.7 0.7

Rollbacks: 10.9 0.5

Transactions: 21.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.0	0.1	0.07	0.01
DB CPU(s):	0.9	0.0	0.06	0.01
Redo size:	30,560.0	1,445.4
Logical reads:	212,133.9	10,033.2
Block changes:	82.3	3.9
Physical reads:	145.4	6.9
Physical writes:	8.0	0.4
User calls:	67.7	3.2
Parses:	0.8	0.0
Hard parses:	0.3	0.0
W/A MB processed:	-0.2	-0.0
Logons:	0.0	0.0
Executes:	14.7	0.7
Rollbacks:	10.9	0.5
Transactions:	21.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.72

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

Library Hit %: 94.99 Soft Parse %: 61.71

Execute to Parse %: 94.68 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 89.07 % Non-Parse CPU: 99.64

Shared Pool Statistics

Begin End

Memory Usage %: 85.27 89.83

% SQL with executions>1: 81.01 88.33

% Memory for SQL w/exec>1: 78.63 85.38

	Begin	End
Memory Usage %:	85.27	89.83
% SQL with executions>1:	81.01	88.33
% Memory for SQL w/exec>1:	78.63	85.38

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		9,894		92.67
SQL*Net more data from client	1,346	199	148	1.86	Network
gc cr block 2-way	261,490	177	1	1.66	Cluster
gc current block 2-way	132,586	82	1	0.77	Cluster
log file sync	111,297	81	1	0.76	Commit

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

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

1.41 1.35 12.6 1.2 0.2 86.1

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.41	1.35	12.6	1.2	0.2	86.1

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

11.9 85.6 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 64,280.2 64,280.2

SGA use (MB): 4,416.0 4,240.0

PGA use (MB): 434.1 383.3

% Host Mem used for SGA+PGA: 7.55 7.19

	Begin	End
Host Mem (MB):	64,280.2	64,280.2
SGA use (MB):	4,416.0	4,240.0
PGA use (MB):	434.1	383.3
% Host Mem used for SGA+PGA:	7.55	7.19

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: 38.10 1.80

Global Cache blocks served: 30.39 1.44

GCS/GES messages received: 93.45 4.42

GCS/GES messages sent: 103.22 4.88

DBWR Fusion writes: 0.70 0.03

Estd Interconnect traffic (KB) 586.33

	Per Second	Per Transaction
Global Cache blocks received:	38.10	1.80
Global Cache blocks served:	30.39	1.44
GCS/GES messages received:	93.45	4.42
GCS/GES messages sent:	103.22	4.88
DBWR Fusion writes:	0.70	0.03
Estd Interconnect traffic (KB)	586.33

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

Buffer access - local cache %: 99.98

Buffer access - remote cache %: 0.02

Buffer access - disk %: 0.00

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

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

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

Avg global cache cr block build time (ms): 0.0

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

Global cache log flushes for cr blocks served %: 0.0

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

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

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

Global cache log flushes for current blocks served %: 0.1

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

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

Avg message received queue time (ms): 0.1

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 69.56

% of indirect sent messages: 30.43

% of flow controlled messages: 0.02

Cluster Interconnect

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

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
bond2:1	169.254.89.31	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): 10676.1s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	10,245.03	95.96
DB CPU	9,894.05	92.67
RMAN cpu time (backup/restore)	83.42	0.78
parse time elapsed	48.06	0.45
hard parse elapsed time	40.07	0.38
PL/SQL execution elapsed time	9.70	0.09
connection management call elapsed time	4.97	0.05
hard parse (sharing criteria) elapsed time	2.64	0.02
inbound PL/SQL rpc elapsed time	2.45	0.02
PL/SQL compilation elapsed time	0.26	0.00
hard parse (bind mismatch) elapsed time	0.14	0.00
repeated bind elapsed time	0.02	0.00
sequence load elapsed time	0.01	0.00
failed parse elapsed time	0.00	0.00
DB time	10,676.13
background elapsed time	3,691.65
background cpu time	541.73

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	1,219,099
IDLE_TIME	7,556,462
IOWAIT_TIME	17,890
NICE_TIME	0
SYS_TIME	102,075
USER_TIME	1,105,196
LOAD	1	1
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	67,402,645,504
NUM_CPUS	8
NUM_CPU_CORES	8
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
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
09-Jan 11:00:04	1.41
09-Jan 12:00:07	2.16	17.43	15.97	1.25	82.57	0.18
09-Jan 13:00:12	1.11	16.89	15.55	1.22	83.11	0.31
09-Jan 14:00:16	1.35	7.36	6.27	1.01	92.64	0.12

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 99.6% of Total DB time 10,676.13 (s)
Total FG Wait Time: 740.52 (s) DB CPU time: 9,894.05 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			9,894		92.67
Cluster	505,954	0	329	1	3.08
Network	494,379	0	199	0	1.87
Commit	111,297	0	81	1	0.76
User I/O	8,074	0	67	8	0.62
Configuration	181	0	54	299	0.51
Other	1,743	43	5	3	0.05
Application	58	9	2	41	0.02
Concurrency	3,521	0	2	1	0.02
System I/O	3,290	0	1	0	0.01
Administrative	0		0		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
SQL*Net more data from client	1,346	0	199	148	0.01	1.86
gc cr block 2-way	261,490	0	177	1	1.14	1.66
gc current block 2-way	132,586	0	82	1	0.58	0.77
log file sync	111,297	0	81	1	0.49	0.76
direct path read	5,914	0	61	10	0.03	0.57
gc current grant busy	101,233	0	56	1	0.44	0.53
log file switch (checkpoint incomplete)	95	0	53	559	0.00	0.50
gc current block busy	415	0	5	11	0.00	0.04
db file sequential read	1,583	0	3	2	0.01	0.03
gc cr block congested	4,733	0	3	1	0.02	0.03
name-service call wait	36	0	3	73	0.00	0.02
enq: KO - fast object checkpoint	6	0	2	367	0.00	0.02
gc buffer busy acquire	535	0	2	4	0.00	0.02
gc cr multi block request	1,621	0	2	1	0.01	0.01
gc current block congested	2,201	0	1	1	0.01	0.01
recovery area: computing obsolete files	1	0	1	1149	0.00	0.01
db file scattered read	241	0	1	5	0.00	0.01
control file sequential read	3,152	0	1	0	0.01	0.01
log file switch completion	54	0	1	20	0.00	0.01
cursor: pin S wait on X	33	0	1	31	0.00	0.01
SQL*Net message to client	492,786	0	1	0	2.16	0.01
direct path write temp	201	0	1	4	0.00	0.01
row cache lock	2,813	0	1	0	0.01	0.01
recovery area: computing backed up files	1	0	1	513	0.00	0.00
control file single write	88	0	0	4	0.00	0.00
DFS lock handle	196	4	0	1	0.00	0.00
gc current multi block request	233	0	0	1	0.00	0.00
SQL*Net break/reset to client	38	0	0	3	0.00	0.00
gc cr block busy	69	0	0	2	0.00	0.00
gc cr grant 2-way	494	0	0	0	0.00	0.00
library cache lock	228	0	0	0	0.00	0.00
os thread startup	1	0	0	98	0.00	0.00
recovery area: computing dropped files	1	0	0	90	0.00	0.00
gc current grant 2-way	227	0	0	0	0.00	0.00
library cache pin	259	0	0	0	0.00	0.00
IPC send completion sync	169	0	0	0	0.00	0.00
CSS initialization	20	0	0	3	0.00	0.00
library cache load lock	19	0	0	3	0.00	0.00
CSS operation: action	20	0	0	2	0.00	0.00
enq: PS - contention	67	30	0	1	0.00	0.00
Disk file operations I/O	128	0	0	0	0.00	0.00
enq: TM - contention	11	45	0	2	0.00	0.00
PX Deq: Slave Session Stats	87	0	0	0	0.00	0.00
library cache: mutex X	32	0	0	1	0.00	0.00
control file parallel write	50	0	0	0	0.00	0.00
enq: TS - contention	48	88	0	0	0.00	0.00
reliable message	53	0	0	0	0.00	0.00
gc cr disk read	78	0	0	0	0.00	0.00
enq: CR - block range reuse ckpt	8	0	0	2	0.00	0.00
gc buffer busy release	14	0	0	1	0.00	0.00
enq: FB - contention	30	0	0	0	0.00	0.00
CSS operation: query	60	0	0	0	0.00	0.00
enq: HW - contention	29	0	0	0	0.00	0.00
direct path read temp	4	0	0	2	0.00	0.00
gc current retry	18	0	0	0	0.00	0.00
SQL*Net more data to client	247	0	0	0	0.00	0.00
direct path write	3	0	0	2	0.00	0.00
ges inquiry response	13	0	0	0	0.00	0.00
enq: RO - fast object reuse	3	0	0	2	0.00	0.00
PX Deq: reap credit	609	100	0	0	0.00	0.00
PX Deq: Signal ACK RSG	22	0	0	0	0.00	0.00
KJC: Wait for msg sends to complete	196	0	0	0	0.00	0.00
latch: cache buffers chains	113	0	0	0	0.00	0.00
enq: CF - contention	4	25	0	0	0.00	0.00
enq: DL - contention	2	100	0	1	0.00	0.00
enq: ST - contention	2	0	0	1	0.00	0.00
gc cr grant congested	6	0	0	0	0.00	0.00
SQL*Net message from client	492,790	0	96,169	195	2.16
PX Deq: Execution Msg	260	0	0	1	0.00
PX Deq: Join ACK	22	0	0	3	0.00
PX Deq: Parse Reply	22	0	0	2	0.00
PX Deq: Execute Reply	22	0	0	2	0.00
KSV master wait	18	0	0	0	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
Backup: MML write backup piece	196,592	0	2,220	11	0.86	60.13
Backup: MML create a backup piece	42	0	704	16762	0.00	19.07
Backup: MML commit backup piece	42	0	236	5610	0.00	6.38
Backup: MML query backup piece	42	0	70	1661	0.00	1.89
log file parallel write	113,217	0	48	0	0.50	1.31
control file sequential read	116,158	0	25	0	0.51	0.68
ASM file metadata operation	43,299	0	20	0	0.19	0.55
reliable message	871	1	16	18	0.00	0.43
RMAN backup & recovery I/O	3,834	0	12	3	0.02	0.31
control file parallel write	13,113	0	6	0	0.06	0.16
db file parallel write	9,462	0	4	0	0.04	0.10
os thread startup	68	0	2	37	0.00	0.07
enq: CF - contention	3,812	1	2	1	0.02	0.07
enq: CO - master slave det	3,598	100	2	1	0.02	0.05
DFS lock handle	1,196	84	2	1	0.01	0.05
SGA: allocation forcing component growth	17	94	2	99	0.00	0.05
db file sequential read	417	0	1	3	0.00	0.04
CSS operation: data query	900	0	1	1	0.00	0.03
Disk file operations I/O	8,132	0	1	0	0.04	0.03
log file sequential read	1,386	0	1	1	0.01	0.03
enq: TC - contention	3	0	1	328	0.00	0.03
CGS wait for IPC msg	93,908	100	1	0	0.41	0.03
name-service call wait	18	0	1	53	0.00	0.03
SQL*Net break/reset to client	14	0	1	57	0.00	0.02
control file single write	156	0	1	5	0.00	0.02
row cache lock	3,467	0	1	0	0.02	0.02
gc current block 2-way	1,104	0	1	1	0.00	0.02
gc cr block 2-way	630	0	0	1	0.00	0.01
ges inquiry response	780	0	0	0	0.00	0.01
row cache process	47,695	0	0	0	0.21	0.01
Log archive I/O	80	0	0	3	0.00	0.01
ksxr poll remote instances	25,818	100	0	0	0.11	0.01
enq: RS - prevent file delete	470	100	0	0	0.00	0.01
CSS group membership query	180	0	0	1	0.00	0.01
gcs log flush sync	118	3	0	1	0.00	0.00
ges lms sync during dynamic remastering and reconfig	24	0	0	6	0.00	0.00
gc current grant busy	267	0	0	0	0.00	0.00
gc cr block busy	17	0	0	7	0.00	0.00
log file single write	320	0	0	0	0.00	0.00
kfk: async disk IO	240	0	0	0	0.00	0.00
gc current block busy	31	0	0	3	0.00	0.00
gc current grant 2-way	214	0	0	0	0.00	0.00
row cache cleanup	34,517	0	0	0	0.15	0.00
library cache lock	151	1	0	0	0.00	0.00
direct path write	184	0	0	0	0.00	0.00
library cache pin	151	0	0	0	0.00	0.00
enq: PS - contention	53	32	0	1	0.00	0.00
CSS operation: action	40	0	0	1	0.00	0.00
log file switch completion	4	0	0	8	0.00	0.00
gc cr grant 2-way	91	0	0	0	0.00	0.00
enq: WF - contention	57	0	0	0	0.00	0.00
CSS initialization	8	0	0	3	0.00	0.00
Parameter File I/O	72	0	0	0	0.00	0.00
ADR block file write	58	0	0	0	0.00	0.00
PX Deq: reap credit	3,197	100	0	0	0.01	0.00
libcache interrupt action by LCK	27,958	0	0	0	0.12	0.00
ges generic event	2	100	0	10	0.00	0.00
enq: WL - contention	40	100	0	0	0.00	0.00
PX Deq: Slave Session Stats	54	0	0	0	0.00	0.00
ADR block file read	88	0	0	0	0.00	0.00
enq: TA - contention	34	0	0	0	0.00	0.00
SQL*Net more data from client	7	0	0	2	0.00	0.00
gc current multi block request	18	0	0	1	0.00	0.00
PX Deq: Signal ACK RSG	54	0	0	0	0.00	0.00
Backup: MML initialization	2	0	0	6	0.00	0.00
db file async I/O submit	8,737	0	0	0	0.04	0.00
enq: CR - block range reuse ckpt	19	0	0	1	0.00	0.00
enq: FB - contention	19	0	0	0	0.00	0.00
gc current block congested	16	0	0	1	0.00	0.00
enq: TM - contention	19	84	0	0	0.00	0.00
IPC send completion sync	36	0	0	0	0.00	0.00
ARCH wait for archivelog lock	80	0	0	0	0.00	0.00
log file sync	6	0	0	1	0.00	0.00
gc cr block congested	11	0	0	1	0.00	0.00
LGWR wait for redo copy	208	0	0	0	0.00	0.00
SQL*Net message to client	3,247	0	0	0	0.01	0.00
enq: PI - contention	17	100	0	0	0.00	0.00
db file single write	12	0	0	0	0.00	0.00
enq: HW - contention	7	14	0	1	0.00	0.00
enq: TD - KTF dump entries	20	0	0	0	0.00	0.00
enq: DR - contention	6	0	0	1	0.00	0.00
enq: BR - file shrink	6	100	0	1	0.00	0.00
CSS operation: query	204	0	0	0	0.00	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	6	0	0	1	0.00	0.00
PX Deq: Signal ACK EXT	54	0	0	0	0.00	0.00
enq: KO - fast object checkpoint	8	0	0	0	0.00	0.00
gc cr multi block request	5	0	0	1	0.00	0.00
enq: TT - contention	5	80	0	0	0.00	0.00
KJC: Wait for msg sends to complete	142	0	0	0	0.00	0.00
enq: PE - contention	3	67	0	1	0.00	0.00
ADR file lock	104	0	0	0	0.00	0.00
gc buffer busy release	1	0	0	2	0.00	0.00
enq: MW - contention	6	0	0	0	0.00	0.00
asynch descriptor resize	187	100	0	0	0.00	0.00
enq: AF - task serialization	3	0	0	0	0.00	0.00
enq: PG - contention	2	100	0	1	0.00	0.00
rdbms ipc message	473,143	37	237,578	502	2.07
wait for unread message on broadcast channel	21,771	89	21,624	993	0.10
class slave wait	30,243	0	21,603	714	0.13
DIAG idle wait	221,640	90	21,581	97	0.97
gcs remote message	2,668,899	67	21,509	8	11.67
Space Manager: slave idle wait	3,871	98	19,086	4931	0.02
Streams AQ: qmn coordinator idle wait	752	50	10,823	14392	0.00
Streams AQ: qmn slave idle wait	376	0	10,823	28783	0.00
ASM background timer	19,159	0	10,812	564	0.08
GCR sleep	2,162	100	10,812	5001	0.01
pmon timer	3,765	95	10,809	2871	0.02
PING	4,047	21	10,809	2671	0.02
ges remote message	126,137	77	10,805	86	0.55
smon timer	57	51	10,589	185765	0.00
PX Idle Wait	83	0	6,107	73582	0.00
SQL*Net message from client	3,272	0	1,268	388	0.01
KSV master wait	34,797	19	21	1	0.15
PL/SQL lock timer	1	100	9	9002	0.00
SGA: MMAN sleep for component shrink	131	93	1	10	0.00
PX Deq: Parse Reply	54	0	0	3	0.00
PX Deq: Join ACK	54	0	0	2	0.00
PX Deq: Execute Reply	54	0	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	761	100	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	88	100.0
ADR block file write	58	100.0
ADR file lock	104	100.0
ARCH wait for archivelog lock	80	100.0
ASM file metadata operation	43.3K	90.8	6.4	1.5	1.1	.1	.1	.0	.0
Backup: MML commit backup piece	42								100.0
Backup: MML create a backup piece	42								100.0
Backup: MML extended initialization	2	100.0
Backup: MML initialization	2	50.0				50.0
Backup: MML query backup piece	42								100.0
Backup: MML shutdown	3	100.0
Backup: MML write backup piece	196.6K	.0		.1	24.0	69.8	5.8	.3	.0
CGS wait for IPC msg	93.9K	100.0
CSS group membership query	180	48.9	48.3	2.8
CSS initialization	28	50.0			46.4	3.6
CSS operation: action	60	40.0	36.7	23.3
CSS operation: data query	900	34.3	65.2	.4
CSS operation: query	264	98.5	1.5
DFS lock handle	1392	96.8	1.9	.1			.1	1.1
Disk file operations I/O	8261	99.9	.0	.1		.0		.0
IPC send completion sync	205	98.0	2.0
KJC: Wait for msg sends to complete	343	100.0
LGWR wait for redo copy	208	100.0
Log archive I/O	80	37.5	3.8	10.0	48.8
PX Deq: Signal ACK EXT	76	100.0
PX Deq: Signal ACK RSG	76	100.0
PX Deq: Slave Session Stats	141	98.6	1.4
PX Deq: reap credit	3806	100.0
Parameter File I/O	72	98.6	1.4
RMAN backup & recovery I/O	3834	42.6	10.8	18.7	19.6	7.3	.8	.2
SGA: allocation forcing component growth	17							100.0
SQL*Net break/reset to client	52	86.5	1.9	3.8				7.7
SQL*Net message to client	496K	100.0
SQL*Net more data from client	1353	9.2	.4	.1		.1		90.2
SQL*Net more data to client	254	100.0
asynch descriptor resize	241	100.0
buffer busy waits	26	100.0
control file parallel write	13.2K	99.6	.2	.1	.1	.0		.0
control file sequential read	119.3K	99.2	.7	.1	.0	.0	.0
control file single write	244	6.6	.8	22.5	68.4	1.6
cursor: pin S	1	100.0
cursor: pin S wait on X	33		6.1	3.0	9.1	30.3	30.3	21.2
db file async I/O submit	8737	100.0
db file parallel write	9462	99.1	.7	.1	.0	.1
db file scattered read	241	10.0	2.5	50.2	24.9	11.6	.8
db file sequential read	2004	59.0	1.3	11.4	25.4	2.0	.7	.0
db file single write	12	100.0
direct path read	5917	7.5	8.9	17.0	22.3	23.0	17.9	3.5
direct path read temp	4	25.0	25.0	25.0	25.0
direct path write	187	95.7	1.6	2.1	.5
direct path write temp	201	18.4	14.9	30.3	28.4	6.0	1.5	.5
enq: AF - task serialization	3	100.0
enq: BR - file shrink	6	100.0
enq: CF - contention	3816	97.2	1.6	.4	.5	.1	.1	.0
enq: CO - master slave det	3598	99.1	.8	.0
enq: CR - block range reuse ckpt	27	85.2	3.7		11.1
enq: DL - contention	2	100.0
enq: DR - contention	6	83.3	16.7
enq: FB - contention	49	98.0	2.0
enq: HW - contention	36	100.0
enq: KO - fast object checkpoint	14	85.7						7.1	7.1
enq: MD - contention	1	100.0
enq: MW - contention	6	100.0
enq: PE - contention	3	100.0
enq: PG - contention	2	100.0
enq: PI - contention	18	100.0
enq: PS - contention	120	93.3	6.7
enq: PW - flush prewarm buffers	1	100.0
enq: RO - fast object reuse	4	75.0			25.0
enq: RS - prevent file delete	470	99.1	.9
enq: SK - contention	1	100.0
enq: ST - contention	2	100.0
enq: TA - contention	34	97.1	2.9
enq: TC - contention	3		33.3				33.3	33.3
enq: TD - KTF dump entries	20	100.0
enq: TM - contention	30	93.3				6.7
enq: TO - contention	6	100.0
enq: TS - contention	50	88.0	12.0
enq: TT - contention	6	100.0
enq: TX - allocate ITL entry	1	100.0
enq: TX - index contention	1					100.0
enq: WF - contention	57	98.2	1.8
enq: WL - contention	40	97.5	2.5
gc buffer busy acquire	535	93.5	6.4						.2
gc buffer busy release	16	75.0	6.3	12.5	6.3
gc cr block 2-way	262.1K	99.4	.6	.0	.0
gc cr block busy	86	8.1	76.7	5.8	1.2	3.5	4.7
gc cr block congested	4742	99.3	.6	.0
gc cr disk read	79	100.0
gc cr grant 2-way	585	98.8	1.0	.2
gc cr grant congested	6	100.0
gc cr multi block request	1626	77.7	18.2	1.1	3.0	.1
gc current block 2-way	133.7K	99.6	.4	.0	.0
gc current block busy	444	65.1	32.0	.5	.9	.5	.2	.5	.5
gc current block congested	2217	98.7	.7	.5	.1			.0
gc current grant 2-way	436	99.3	.7
gc current grant busy	101.5K	99.7	.3	.0
gc current grant congested	3	100.0
gc current multi block request	252	97.2	2.8
gc current retry	18	100.0
gc current split	1	100.0
gc object scan	3	100.0
gcs log flush sync	118	78.8	7.6	8.5	1.7	3.4
ges generic event	2					100.0
ges inquiry response	793	99.6	.4
ges lms sync during dynamic remastering and reconfig	24			33.3	58.3	8.3
kfk: async disk IO	240	98.8		.4	.8
kjbdrmcvtq lmon drm quiesce: ping completion	6	100.0
ksxr poll remote instances	25.2K	100.0
latch free	17	100.0
latch: active service list	2	100.0
latch: cache buffers chains	116	100.0
latch: gc element	10	100.0
latch: gcs resource hash	2	100.0
latch: ges resource hash list	10	100.0
latch: object queue header operation	2	100.0
libcache interrupt action by LCK	27.4K	100.0
library cache load lock	19	57.9	10.5	10.5	10.5	10.5
library cache lock	390	97.2	2.3	.5
library cache pin	421	99.0	.5	.5
library cache: mutex X	32	93.8				6.3
lock escalate retry	2	100.0
log file parallel write	113.2K	99.0	.2	.4	.3	.1	.0	.0
log file sequential read	1386	79.2	6.0	12.1	2.2	.1	.4
log file single write	320	100.0
log file switch (checkpoint incomplete)	95				32.6	6.3		42.1	18.9
log file switch completion	58		1.7	5.2	41.4	22.4	10.3	19.0
log file sync	111.3K	98.6	.7	.4	.2	.1	.0	.0
name-service call wait	54				3.7	7.4	11.1	77.8
os thread startup	69						72.5	27.5
recovery area: computing backed up files	1							100.0
recovery area: computing dropped files	1							100.0
recovery area: computing obsolete files	1								100.0
reliable message	924	77.6	20.1	.3				1.9
row cache cleanup	33.7K	100.0
row cache lock	5993	99.1	.9
row cache process	46.3K	100.0
ASM background timer	19.2K	58.8	8.2	3.6	7.0	1.5	5.8	3.3	11.8
DIAG idle wait	221.7K	8.0	.7	.1	.0	5.6	26.4	59.2
GCR sleep	2162								100.0
KSV master wait	34.8K	88.3	8.0	1.9	1.5	.1	.1	.1	.0
PING	4047	78.8	.1						21.1
PL/SQL lock timer	1								100.0
PX Deq: Execute Reply	76	90.8	1.3		7.9
PX Deq: Execution Msg	260	89.6	8.5	.8	.8		.4
PX Deq: Join ACK	76	38.2	18.4	31.6	9.2		2.6
PX Deq: Parse Reply	76	46.1	13.2	21.1	17.1	1.3	1.3
PX Idle Wait	65	26.2	3.1			21.5	6.2	10.8	32.3
SGA: MMAN sleep for component shrink	131	4.6	1.5	.8		93.1
SQL*Net message from client	496.1K	74.5	.3	.3	.3	.2	.3	23.6	.5
Space Manager: slave idle wait	3871		.0	.0	.1	.0	.0	.8	99.1
Streams AQ: RAC qmn coordinator idle wait	761	100.0
Streams AQ: qmn coordinator idle wait	752	50.0							50.0
Streams AQ: qmn slave idle wait	376								100.0
class slave wait	30.2K	29.5	15.3	14.6	13.8	5.6	3.4	4.6	13.2
gcs remote message	2668.8K	6.7	5.8	9.3	8.0	70.1
ges remote message	126.2K	8.1	.8	.6	.9	1.8	2.4	85.3
pmon timer	3765	.8	.2	.2	.3	.6	.7	1.4	95.8
rdbms ipc message	472.6K	35.8	2.5	2.3	.2	.4	.4	48.2	10.3
smon timer	57	8.8				3.5		14.0	73.7
wait for unread message on broadcast channel	21.8K					.7		99.3

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	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ASM file metadata operation	24	99.9	.0	.0				.0
Backup: MML query backup piece	42							100.0
Backup: MML write backup piece	515	99.7	.2	.0					.0
DFS lock handle	16	98.9	.2	.9
Disk file operations I/O	1	100.0	.0
RMAN backup & recovery I/O	9	99.8	.2	.0
SGA: allocation forcing component growth	17			100.0
SQL*Net break/reset to client	4	92.3	1.9	1.9		3.8
SQL*Net more data from client	1220	9.8		9.8	80.2	.1
control file parallel write	1	100.0			.0
cursor: pin S wait on X	7	78.8	3.0	12.1	6.1
db file sequential read	1	100.0		.0
direct path read	205	96.5	3.1	.3
direct path write temp	1	99.5	.5
enq: CF - contention	1	100.0	.0
enq: KO - fast object checkpoint	2	85.7					7.1	7.1
enq: TC - contention	1	66.7					33.3
gc buffer busy acquire	1	99.8						.2
gc current block busy	4	99.1				.2	.2	.5
gc current block congested	1	100.0	.0
log file parallel write	1	100.0		.0
log file switch (checkpoint incomplete)	53	38.9	2.1	1.1	8.4	13.7	16.8	13.7	5.3
log file switch completion	11	81.0	12.1	6.9
log file sync	1	100.0		.0
name-service call wait	42	22.2	35.2	40.7	1.9
os thread startup	19	72.5	2.9	24.6
recovery area: computing backed up files	1					100.0
recovery area: computing dropped files	1			100.0
recovery area: computing obsolete files	1							100.0
reliable message	18	98.1		.1	.1	.1	1.6

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	< 2m
		% of Total Waits
Backup: MML commit backup piece	42			100.0
Backup: MML create a backup piece	42				92.9	4.8	2.4
Backup: MML write backup piece	1	100.0					.0
log file switch (checkpoint incomplete)	5	94.7	5.3

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)
UPRR	10,668	9,888	1,571	2,293,263
SYS$USERS	7	5	0	1
SYS$BACKGROUND	1	0	1	338

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	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
UPRR	7984	66	3406	2	0	0	491185	199
SYS$USERS	7050	1	115	0	196725	3229	6361	0
SYS$BACKGROUND	1858	2	31880	3	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 88.8% of Total DB Time (s): 10,676
Captured PL/SQL account for 0.2% of Total DB Time (s): 10,676

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
4,983.60	2	2,491.80	46.68	98.87	0.04	17b0jc7728gg2	SQL*Plus	select b.account, b.en_code, b...
4,077.48	55,238	0.07	38.19	91.64	0.00	3rwmw7xzcguck	JDBC Thin Client	update t_base_changes set dat...
42.26	1	42.26	0.40	23.50	73.69	fk6bnxu02b893	osh@HKP02LP1501 (TNS V1-V3)	alter index ODS.SSALSFP_DATA_D...
38.39	1	38.39	0.36	17.68	80.29	fm3n7vt38gnzd	osh@HKP02LP1501 (TNS V1-V3)	alter index ODS.DDACMSP_DATA_D...
28.53	63	0.45	0.27	97.00	0.00	bx7csmkm83ucu	JDBC Thin Client	SELECT :1 as cell_type, :2 as...
22.34	266	0.08	0.21	95.67	0.00	gz7125av46f4d	JDBC Thin Client	select 't_base_account' as ta...
21.06	252	0.08	0.20	95.77	0.00	cy5ptkf9dv38b	JDBC Thin Client	select count(*) from t_base_a...
19.65	235	0.08	0.18	95.67	0.00	b1r6crsaf4mz1	JDBC Thin Client	select count(*) from t_base_a...
18.35	36,977	0.00	0.17	20.80	0.06	gm8v62jfaksy9	JDBC Thin Client	insert into T_RPT_SEND_COMMIT...
14.03	4	3.51	0.13	74.38	11.02	7xv4jyck7y12u	PL/SQL Developer	begin dbms_stats.GATHER_TABLE_...

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 90.7% of Total CPU Time (s): 9,894
Captured PL/SQL account for 0.1% of Total CPU Time (s): 9,894

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
4,927.21	2	2,463.60	49.80	4,983.60	98.87	0.04	17b0jc7728gg2	SQL*Plus	select b.account, b.en_code, b...
3,736.49	55,238	0.07	37.77	4,077.48	91.64	0.00	3rwmw7xzcguck	JDBC Thin Client	update t_base_changes set dat...
27.68	63	0.44	0.28	28.53	97.00	0.00	bx7csmkm83ucu	JDBC Thin Client	SELECT :1 as cell_type, :2 as...
21.38	266	0.08	0.22	22.34	95.67	0.00	gz7125av46f4d	JDBC Thin Client	select 't_base_account' as ta...
20.17	252	0.08	0.20	21.06	95.77	0.00	cy5ptkf9dv38b	JDBC Thin Client	select count(*) from t_base_a...
18.80	235	0.08	0.19	19.65	95.67	0.00	b1r6crsaf4mz1	JDBC Thin Client	select count(*) from t_base_a...
12.23	257	0.05	0.12	13.28	92.08	0.00	a8xzbs4kh4vsa	JDBC Thin Client	select count(*) from t_base_c...
11.83	240	0.05	0.12	12.79	92.47	0.00	4tjnuw00zdvas	JDBC Thin Client	select 't_base_changes' as ta...
11.64	58	0.20	0.12	12.08	96.39	0.00	byfv3tmrrvnpk	JDBC Thin Client	SELECT SUM(B.CT) FROM ( SELEC...
11.50	1	11.50	0.12	12.59	91.36	3.45	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
31.14	1	31.14	44.99	42.26	23.50	73.69	fk6bnxu02b893	osh@HKP02LP1501 (TNS V1-V3)	alter index ODS.SSALSFP_DATA_D...
30.83	1	30.83	44.53	38.39	17.68	80.29	fm3n7vt38gnzd	osh@HKP02LP1501 (TNS V1-V3)	alter index ODS.DDACMSP_DATA_D...
1.92	2	0.96	2.78	4,983.60	98.87	0.04	17b0jc7728gg2	SQL*Plus	select b.account, b.en_code, b...
1.55	4	0.39	2.23	14.03	74.38	11.02	7xv4jyck7y12u	PL/SQL Developer	begin dbms_stats.GATHER_TABLE_...
0.52	1	0.52	0.75	2.02	69.43	25.73	2xtwcv43am491	PL/SQL Developer	/* SQL Analyze(0) / select /...
0.43	1	0.43	0.63	12.59	91.36	3.45	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
0.34	112	0.00	0.49	0.53	36.37	63.46	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
0.11	6	0.02	0.16	5.19	76.55	2.16	frvvmgb78k7md	JDBC Thin Client	select t.logtype as logtype, ...
0.11	415	0.00	0.15	0.17	19.12	63.00	db78fxqxwxt7r		select /+ rule / bucket, end...
0.07	82	0.00	0.11	0.10	15.29	74.96	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...

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: 2,293,602,773
Captured SQL account for 90.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,638,094,502	2	819,047,251.00	71.42	4,983.60	98.9	0	17b0jc7728gg2	SQL*Plus	select b.account, b.en_code, b...
390,367,366	55,238	7,067.01	17.02	4,077.48	91.6	0	3rwmw7xzcguck	JDBC Thin Client	update t_base_changes set dat...
2,979,466	266	11,201.00	0.13	22.34	95.7	0	gz7125av46f4d	JDBC Thin Client	select 't_base_account' as ta...
2,822,652	252	11,201.00	0.12	21.06	95.8	0	cy5ptkf9dv38b	JDBC Thin Client	select count(*) from t_base_a...
2,632,235	235	11,201.00	0.11	19.65	95.7	0	b1r6crsaf4mz1	JDBC Thin Client	select count(*) from t_base_a...
2,332,329	63	37,021.10	0.10	28.53	97	0	bx7csmkm83ucu	JDBC Thin Client	SELECT :1 as cell_type, :2 as...
1,815,462	257	7,064.05	0.08	13.28	92.1	0	a8xzbs4kh4vsa	JDBC Thin Client	select count(*) from t_base_c...
1,695,367	240	7,064.03	0.07	12.79	92.5	0	4tjnuw00zdvas	JDBC Thin Client	select 't_base_changes' as ta...
1,497,574	212	7,064.03	0.07	11.04	92.2	0	4218x0dzf4pmt	JDBC Thin Client	select count(*) from t_base_c...
1,346,588	1	1,346,588.00	0.06	12.59	91.4	3.4	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...

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: 1,571,874
Captured SQL account for 99.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
777,973	1	777,973.00	49.49	42.26	23.50	73.69	fk6bnxu02b893	osh@HKP02LP1501 (TNS V1-V3)	alter index ODS.SSALSFP_DATA_D...
769,641	1	769,641.00	48.96	38.39	17.68	80.29	fm3n7vt38gnzd	osh@HKP02LP1501 (TNS V1-V3)	alter index ODS.DDACMSP_DATA_D...
21,770	4	5,442.50	1.38	14.03	74.38	11.02	7xv4jyck7y12u	PL/SQL Developer	begin dbms_stats.GATHER_TABLE_...
10,773	1	10,773.00	0.69	2.02	69.43	25.73	2xtwcv43am491	PL/SQL Developer	/* SQL Analyze(0) / select /...
677	112	6.04	0.04	0.53	36.37	63.46	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
453	2	226.50	0.03	4,983.60	98.87	0.04	17b0jc7728gg2	SQL*Plus	select b.account, b.en_code, b...
439	1	439.00	0.03	12.59	91.36	3.45	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
38	82	0.46	0.00	0.10	15.29	74.96	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
27	6	4.50	0.00	5.19	76.55	2.16	frvvmgb78k7md	JDBC Thin Client	select t.logtype as logtype, ...
26	1	26.00	0.00	0.97	78.80	3.19	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...

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: 15,325
Captured SQL account for 88.7% of Total
Total UnOptimized Read Requests: 15,325
Captured SQL account for 88.7% 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	%Total	SQL Id	SQL Module	SQL Text
6,150	6,150	1	6,150.00	40.13	fk6bnxu02b893	osh@HKP02LP1501 (TNS V1-V3)	alter index ODS.SSALSFP_DATA_D...
6,064	6,064	1	6,064.00	39.57	fm3n7vt38gnzd	osh@HKP02LP1501 (TNS V1-V3)	alter index ODS.DDACMSP_DATA_D...
662	662	4	165.50	4.32	7xv4jyck7y12u	PL/SQL Developer	begin dbms_stats.GATHER_TABLE_...
435	435	1	435.00	2.84	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
419	419	2	209.50	2.73	17b0jc7728gg2	SQL*Plus	select b.account, b.en_code, b...
399	399	1	399.00	2.60	0az7czjdw8z7j		declare lbRec dbms_rcvman.lbR...
387	387	9	43.00	2.53	5mw55dp9p6nyt	rman@cn000zhj1003 (TNS V1-V3)	select nvl(max(al.recid), '0')...
101	101	1	101.00	0.66	2xtwcv43am491	PL/SQL Developer	/* SQL Analyze(0) / select /...
27	27	6	4.50	0.18	frvvmgb78k7md	JDBC Thin Client	select t.logtype as logtype, ...
26	26	1	26.00	0.17	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...

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: 158,886
Captured SQL account for 70.8% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
55,238	55,238	1.00	4,077.48	91.6	0	3rwmw7xzcguck	JDBC Thin Client	update t_base_changes set dat...
36,977	36,977	1.00	18.35	20.8	.1	gm8v62jfaksy9	JDBC Thin Client	insert into T_RPT_SEND_COMMIT...
3,672	2,612	0.71	0.22	17.3	14	96g93hntrzjtr		select /+ rule / bucket_cnt,...
3,658	3,658	1.00	0.19	88.9	4	grwydz59pu6mc		select text from view$ where r...
1,344	1,695	1.26	0.06	82.7	11.7	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
806	799	0.99	0.08	41.2	0	9tgj4g8y4rwy8		select type#, blocks, extents,...
797	737	0.92	0.07	24.5	0	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
489	6,773	13.85	0.09	88.3	0	83taa7kaw59c1		select name, intcol#, segcol#,...
463	1,044	2.25	0.04	118.9	0	5n1fs4m2n2y0r		select pos#, intcol#, col#, sp...
419	9	0.02	0.02	112.4	0	3w4qs0tbpmxr6		select con#, obj#, rcon#, enab...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 8,445
Captured SQL account for 28.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
406	406	4.81	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
362	362	4.29	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
54	18	0.64	a1xgxtssv5rrp	MMON_SLAVE	select sum(used_blocks), ts.ts...
51	489	0.60	83taa7kaw59c1		select name, intcol#, segcol#,...
50	348	0.59	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
45	806	0.53	9tgj4g8y4rwy8		select type#, blocks, extents,...
42	797	0.50	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
42	332	0.50	6aq34nj2zb2n7		select col#, grantee#, privile...
41	220	0.49	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
41	334	0.49	2q93zsrvbdw48		select grantee#, privilege#, n...

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 Module	SQL Text
1,631,865	63	0.19	bx7csmkm83ucu	JDBC Thin Client	SELECT :1 as cell_type, :2 as...
1,273,216	58	0.15	6krz8vwhjg5n2	JDBC Thin Client	SELECT SUM(B.CT) FROM ( SELEC...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

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

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
306.30	55,238	92.72	4,077.48	7.51	91.64	0.00	3rwmw7xzcguck	JDBC Thin Client	update t_base_changes set dat...
4.54	20	1.38	4.59	98.93	1.00	0.06	4vs91dcv7u1p6	JDBC Thin Client	insert into sys.aud$( sessioni...
1.88	4	0.57	14.03	13.37	74.38	11.02	7xv4jyck7y12u	PL/SQL Developer	begin dbms_stats.GATHER_TABLE_...
1.53	102	0.46	6.56	23.36	79.03	0.00	9vntpsuc5423h	JDBC Thin Client	select count(*) from T_RPT_SE...
1.17	6	0.35	5.19	22.50	76.55	2.16	frvvmgb78k7md	JDBC Thin Client	select t.logtype as logtype, ...
0.84	257	0.25	13.28	6.34	92.08	0.00	a8xzbs4kh4vsa	JDBC Thin Client	select count(*) from t_base_c...
0.77	240	0.23	12.79	6.03	92.47	0.00	4tjnuw00zdvas	JDBC Thin Client	select 't_base_changes' as ta...
0.70	212	0.21	11.04	6.34	92.23	0.00	4218x0dzf4pmt	JDBC Thin Client	select count(*) from t_base_c...
0.58	266	0.18	22.34	2.61	95.67	0.00	gz7125av46f4d	JDBC Thin Client	select 't_base_account' as ta...
0.56	252	0.17	21.06	2.66	95.77	0.00	cy5ptkf9dv38b	JDBC Thin Client	select count(*) from t_base_a...
0.55	75	0.17	7.66	7.19	91.89	0.00	1mctmndqx2h54	JDBC Thin Client	update t_base_account set dat...
0.53	76	0.16	7.58	7.00	91.91	0.00	13w9fdh2s5wzu	JDBC Thin Client	select t.businessid, t.instco...
0.50	235	0.15	19.65	2.57	95.67	0.00	b1r6crsaf4mz1	JDBC Thin Client	select count(*) from t_base_a...
0.43	63	0.13	10.06	4.32	94.22	0.00	42g8rh79bn457	JDBC Thin Client	SELECT SUM(B.CT) FROM ( SELEC...
0.40	63	0.12	28.53	1.41	97.00	0.00	bx7csmkm83ucu	JDBC Thin Client	SELECT :1 as cell_type, :2 as...
0.33	36,977	0.10	18.35	1.79	20.80	0.06	gm8v62jfaksy9	JDBC Thin Client	insert into T_RPT_SEND_COMMIT...
0.30	58	0.09	10.50	2.90	95.82	0.00	6krz8vwhjg5n2	JDBC Thin Client	SELECT SUM(B.CT) FROM ( SELEC...
0.25	72	0.08	4.72	5.35	93.14	0.00	9nu20wty9ma9d	JDBC Thin Client	select 't_base_changes' as ta...
0.25	58	0.08	12.08	2.06	96.39	0.00	byfv3tmrrvnpk	JDBC Thin Client	SELECT SUM(B.CT) FROM ( SELEC...
0.20	35	0.06	7.34	2.67	95.71	0.00	b338ammcu5s9b	JDBC Thin Client	select ta.businessid from t_b...
0.16	1	0.05	12.59	1.28	91.36	3.45	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
0.16	2	0.05	4,983.60	0.00	98.87	0.04	17b0jc7728gg2	SQL*Plus	select b.account, b.en_code, b...
0.14	107	0.04	9.55	1.51	96.75	0.00	60wkbmhrc0z0q	JDBC Thin Client	select t.businessid, t.instco...
0.14	1	0.04	2.02	6.78	69.43	25.73	2xtwcv43am491	PL/SQL Developer	/* SQL Analyze(0) / select /...
0.11	1	0.03	0.97	11.80	78.80	3.19	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.11	64	0.03	5.98	1.81	96.82	0.00	3hjq8q6kpg4nd	JDBC Thin Client	select 't_base_account' as ta...
0.10	6	0.03	0.81	12.63	84.94	0.00	0chsz91vjw9tj	JDBC Thin Client	select t.businessid, t.instco...
0.09	74	0.03	7.62	1.17	97.06	0.00	7g2nxzxuz01kn	JDBC Thin Client	select t.businessid, t.instco...
0.08	112	0.02	0.53	14.85	36.37	63.46	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
0.07	33	0.02	3.15	2.31	96.18	0.00	14xwkzy8qbf8r	JDBC Thin Client	select t.businessid, t.instco...
0.07	21	0.02	2.16	3.14	94.21	0.00	52vzgkun32d2q	JDBC Thin Client	update t_base_account set dat...
0.07	15	0.02	1.58	4.25	93.27	0.00	bvjub8fx0v5bj	JDBC Thin Client	update t_base_account set isC...
0.06	25	0.02	1.89	3.39	95.16	0.00	39ks9z3mu62df	JDBC Thin Client	select sum(t.balance) from t_...
0.04	1	0.01	0.37	11.89	77.37	9.15	fqmpmkfr6pqyk	PLSQLDev.exe	select s.synonym_name object_n...
0.04	14	0.01	1.80	2.25	95.76	0.00	dbqfhp56241yb	JDBC Thin Client	select t.businessid, t.instco...
0.03	14	0.01	1.65	2.02	96.51	0.00	6vawqchns3v85	JDBC Thin Client	select t.businessid, t.instco...
0.03	8	0.01	0.63	4.25	94.55	0.00	9t1s5z3v9qc52	JDBC Thin Client	select count(*) from t_base_c...
0.02	806	0.01	0.08	27.42	41.18	0.00	9tgj4g8y4rwy8		select type#, blocks, extents,...
0.02	8	0.01	0.69	3.37	95.60	0.00	62qp9vu11116k	JDBC Thin Client	select t.businessid, t.instco...
0.02	14	0.01	1.29	1.53	97.76	0.00	399usqduff0b4	JDBC Thin Client	select t.businessid, t.instco...
0.02	415	0.01	0.17	11.66	19.12	63.00	db78fxqxwxt7r		select /+ rule / bucket, end...
0.02	3	0.00	0.41	4.04	94.22	0.00	5v8a42nt3vbtw	JDBC Thin Client	select count(*) from t_base_c...
0.02	1	0.00	42.26	0.04	23.50	73.69	fk6bnxu02b893	osh@HKP02LP1501 (TNS V1-V3)	alter index ODS.SSALSFP_DATA_D...
0.01	3,672	0.00	0.22	6.49	17.32	14.02	96g93hntrzjtr		select /+ rule / bucket_cnt,...
0.01	15	0.00	1.32	0.78	97.87	0.00	adcj40cs4b8wv	JDBC Thin Client	select count(*) from t_base_a...
0.01	82	0.00	0.10	10.15	15.29	74.96	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
0.01	280	0.00	0.11	8.71	46.89	31.72	3ktacv9r56b51		select owner#, name, namespace...
0.01	15	0.00	0.16	5.82	89.10	0.00	7xu4vfxzryfs4	JDBC Thin Client	select a.id as id, a.name as ...
0.01	7	0.00	0.96	0.95	98.04	0.00	fbssnpxms88kx	JDBC Thin Client	select t.businessid, t.instco...
0.01	348	0.00	0.16	5.53	75.84	0.00	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.01	112	0.00	0.10	8.85	25.37	65.62	ga9j9xk5cy9s0		select /*+ index(idl_sb4$ i_id...
0.01	7	0.00	0.96	0.89	97.59	0.00	3waqrvtb15f1h	JDBC Thin Client	select t.businessid, t.instco...
0.01	107	0.00	8.65	0.10	98.10	0.00	6fpc3uazcdb56	JDBC Thin Client	select count(*) from t_base_a...
0.01	6	0.00	0.80	1.00	97.73	0.00	3u8bs3bqvvwmn	JDBC Thin Client	select t.businessid, t.instco...
0.01	4	0.00	0.42	1.88	95.31	0.00	2xqcx45m245qf	JDBC Thin Client	select t.businessid, t.instco...
0.01	1	0.00	38.39	0.02	17.68	80.29	fm3n7vt38gnzd	osh@HKP02LP1501 (TNS V1-V3)	alter index ODS.DDACMSP_DATA_D...
0.01	17	0.00	0.03	28.42	64.86	3.41	0kkhhb2w93cx0		update seg$ set type#=:4, bloc...
0.01	6	0.00	1.66	0.42	98.43	0.00	a7vz6b87kqk2x	JDBC Thin Client	select count(*) from t_rpt_lo...
0.01	14	0.00	1.54	0.45	98.12	0.00	4csz4fc78rxd4	JDBC Thin Client	select count(*) from t_base_a...
0.01	14	0.00	0.02	28.84	55.73	0.00	1f2kbwu05q275	JDBC Thin Client	select u.id as id, u.username...
0.01	13	0.00	0.87	0.69	97.67	0.00	7tu3bxtjv7trv	JDBC Thin Client	select count(account) from t_...
0.01	3	0.00	2.69	0.21	96.32	0.00	0585y1n8asf82	JDBC Thin Client	select t.businessid, t.instco...
0.01	8	0.00	0.68	0.80	98.46	0.00	3su2k441d3xv6	JDBC Thin Client	select t.businessid, t.instco...
0.01	14	0.00	1.19	0.45	98.24	0.00	7s626urpwpqt1	JDBC Thin Client	select count(*) from t_base_a...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0585y1n8asf82 select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.datastatus in(7) and t.instCode in (select fk_orgId from t_user_org where fk_userId = 'admin1') order by t.businessid asc

0az7czjdw8z7j declare lbRec dbms_rcvman.lbRec_t; lbCursor dbms_rcvman.lbCursor_t; first boolean := FALSE; ret boolean; begin if (:first > 0) then first := TRUE; end if; <<next_row>> ret := dbms_rcvman.listBackup( lbRecOut => lbRec, firstCall => first, only_obsolete => TRUE, redundancy => :redundancy, piped_call => FALSE, lbCursor => lbCursor, lbState => dbms_rcvman.lbStatePck, extRlKeepSCN => NULL); if (not ret) then raise no_data_found; elsif (lbRec.pkey is not null and lbRec.is_rdf = 'YES') then :backup_type := lbRec.backup_type; :file_type := lbRec.file_type; :key := lbRec.pkey; else first := FALSE; goto next_row; end if; end;

0chsz91vjw9tj select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43554297') order by t.businessid asc

0kkhhb2w93cx0 update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3

13w9fdh2s5wzu select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.instcode = :1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) order by t.businessid asc

14xwkzy8qbf8r select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.instcode = :1 and t.businessid = :2 order by t.businessid asc

17b0jc7728gg2 select b.account, b.en_code, b.chinese_name, b.account_type, b.currence_code, case when s.account_status = '11' then b.open_date else b.importdate end, b.file_number, b.instcode, '1', -- b.auditdate, b.importdate, b.businessid, -- b.auditname, -- b.modifyuser, b.iscommit, 'A', '', b.branch_code, b.branch_name, s.account_status, b.amtype, b.account_cata, b.limit_type, b.remark, b.is_handiwork, b.account_limit from tmp_t_base_account b , tmp_account_status s where b.account || b.instcode || b.currence_code = s.account_num and s.account_status in ('11', '12')

1f2kbwu05q275 select u.id as id, u.username as username, u.name as name, u.password as password, u.description as description, u.fk_orgId as orgId, o.shortName as orgName, u.changePassword as changePassword, u.phone as phone, o.customid as customId from t_user u inner join t_org o on u.fk_orgid = o.id where u.id = :1

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

1mctmndqx2h54 update t_base_account set datastatus = 7 where 1=1 and businessid = :1

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

2xqcx45m245qf select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.ACCOUNT as c3, t.DEAL_DATE as c4, t.CURRENCE_CODE as c5, t.CREDIT as c6, t.DEBT as c7, t.BALANCE as c8, t.REMARK as c9, '' as c10, '' as c11, '' as c12, '' as c13, '' as c14, '' as c15, '' as c16, '' as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_changes t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43473200') order by t.businessid asc

2xtwcv43am491 /* SQL Analyze(0) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("ACCOUNT")), to_char(substrb(dump(min("ACCOUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNT"), 16, 0, 32), 1, 120)), to_char(count("EN_CODE")), to_char(substrb(dump(min("EN_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EN_CODE"), 16, 0, 32), 1, 120)), to_char(count("CHINESE_NAME")), to_char(substrb(dump(min("CHINESE_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CHINESE_NAME"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNT_TYPE")), to_char(substrb(dump(min("ACCOUNT_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNT_TYPE"), 16, 0, 32), 1, 120)), to_char(count("CURRENCE_CODE")), to_char(substrb(dump(min("CURRENCE_CODE "), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CURRENCE_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPEN_DATE")), to_char(substrb(dump(min("OPEN_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPEN_DATE"), 16, 0, 32), 1, 120)), to_char(count("FILE_NUMBER")), to_char(substrb(dump(min("FILE_NUMBER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FILE_NUMBER"), 16, 0, 32), 1, 120)), to_char(count("INSTCODE")), to_char(substrb(dump(min("INSTCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INSTCODE"), 16, 0, 32), 1, 120)), to_char(count("DATASTATUS")), to_char(substrb(dump(min("DATASTATUS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DATASTATUS"), 16, 0, 32), 1, 120)), to_char(count("AUDITDATE")), to_char(substrb(dump(min("AUDITDATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AUDITDATE"), 16, 0 , 32), 1, 120)), to_char(count("IMPORTDATE")), to_char(substrb(dump(min("IMPORTDATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("IMPORTDATE"), 16, 0, 32), 1, 120)), to_char(count("BUSINESSID")), to_char(substrb(dump(min("BUSINESSID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BUSINESSID"), 16, 0, 32), 1, 120)), to_char(count("AUDITNAME")), to_char(substrb(dump(min("AUDITNAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AUDITNAME"), 16, 0, 32), 1, 120)), to_char(count("MODIFYUSER")), to_char(substrb(dump(min("MODIFYUSER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MODIFYUSER"), 16, 0, 32), 1, 120)), to_char(count("ISCOMMIT")), to_char(substrb(dump(min("ISCOMMIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ISCOMMIT"), 16, 0, 32), 1, 120)), to_char(count("ACTIONTYPE")), to_char(substrb(dump(min("A CTIONTYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACTIONTYPE"), 16, 0, 32), 1, 120)), to_char(count("ACTIONDESC")), to_char(substrb(dump(min("ACTIONDESC"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACTIONDESC"), 16, 0, 32), 1, 120)), to_char(count("BRANCH_CODE")), to_char(substrb(dump(min("BRANCH_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BRANCH_CODE"), 16, 0, 32), 1, 120)), to_char(count("BRANCH_NAME")), to_char(substrb(dump(min("BRANCH_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BRANCH_NAME"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNTSTAT")), to_char(substrb(dump(min("ACCOUNTSTAT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNTSTAT"), 16, 0, 32), 1, 120)), to_char(count("AMTYPE")), to_char(substrb(dump(min("AMTYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AMTYPE "), 16, 0, 32), 1, 120)), to_char(count("ACCOUNT_CATA")), to_char(substrb(dump(min("ACCOUNT_CATA"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNT_CATA"), 16, 0, 32), 1, 120)), to_char(count("LIMIT_TYPE")), to_char(substrb(dump(min("LIMIT_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LIMIT_TYPE"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNT_LIMIT")), to_char(substrb(dump(min("ACCOUNT_LIMIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNT_LIMIT"), 16, 0, 32), 1, 120)), to_char(count("REMARK")), to_char(substrb(dump(min("REMARK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REMARK"), 16, 0, 32), 1, 120)), to_char(count("IS_HANDIWORK")), to_char(substrb(dump(min("IS_HANDIWORK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("IS_HANDIWORK"), 16, 0, 32), 1, 120)), to_char(count("LIMIT_CCY")), t o_char(substrb(dump(min("LIMIT_CCY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LIMIT_CCY"), 16, 0, 32), 1, 120)) from "DATACORE"."TMP_T_BASE_ACCOUNT" t /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/

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

399usqduff0b4 select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.instcode = :1 and t.iscommit = 0 and t.datastatus in(1) order by t.businessid asc

39ks9z3mu62df select sum(t.balance) from t_base_changes t where t.ACCOUNT=:1 and t.DEAL_DATE=(select max(deal_date) from t_base_changes where ACCOUNT=:2 and INSTCODE=:3 and CURRENCE_CODE=:4 and deal_date<:5 and actiontype <> 'D' ) and t.INSTCODE=:6 and t.CURRENCE_CODE=:7 and t.datastatus >= 5 and actiontype <> 'D'

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#

3hjq8q6kpg4nd select 't_base_account' as tableid, t.businessid, '' as rptno, t.branch_code as branchcode, t.account, t.currence_code as currencecode, t.datastatus, t.iscommit , '' as dealdate from t_base_account t where 1 = 1 and t.businessid = :1

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#

3nkd3g3ju5ph1 select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

3rwmw7xzcguck update t_base_changes set datastatus = 7 where 1=1 and businessid = :1

3su2k441d3xv6 select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.instcode = :1 and ((t.datastatus = 3 and t.iscommit = 1) or t.datastatus < 0) order by t.businessid asc

3u8bs3bqvvwmn select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43215074') order by t.businessid asc

3w4qs0tbpmxr6 select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1

3waqrvtb15f1h select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43202901') order by t.businessid asc

4218x0dzf4pmt select count(*) from t_base_changes t where 1=1 and t.instcode = :1 and t.datastatus = 4

42g8rh79bn457 SELECT SUM(B.CT) FROM ( SELECT COUNT(1) CT FROM t_base_account A WHERE A.DATASTATUS = 3 and A.ISCOMMIT = 1 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :1) UNION ALL SELECT COUNT(1) CT FROM t_base_changes A WHERE A.DATASTATUS = 3 and A.ISCOMMIT = 1 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :2) ) B

4csz4fc78rxd4 select count(*) from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43304268')

4tjnuw00zdvas select 't_base_changes' as tableid, t.businessid, '' as rptno, t.branch_code as branchcode, t.account, t.currence_code as currencecode, t.datastatus, t.iscommit , to_char(DEAL_DATE, 'yyyymmdd') as dealdate from t_base_changes t where 1 = 1 and t.instCode = :1 and t.datastatus = 5 order by businessid asc

4vs91dcv7u1p6 insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)

52vzgkun32d2q update t_base_account set datastatus = 3 where 1=1 and businessid = :1

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

572fbaj0fdw2b select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))

5mw55dp9p6nyt select nvl(max(al.recid), '0'), nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where al.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'

5n1fs4m2n2y0r select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1

5v8a42nt3vbtw select count(*) from t_base_changes t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and to_char(t.DEAL_DATE, 'yyyymmdd') = '20121231' and t.instCode in (select fk_orgId from t_user_org where fk_userId = 'admin')

60wkbmhrc0z0q select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.instcode = :1 and t.datastatus in(1, 2, 3, 4, 5, 6, 7, 8) order by t.businessid asc

62qp9vu11116k select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.ACCOUNT as c3, t.DEAL_DATE as c4, t.CURRENCE_CODE as c5, t.CREDIT as c6, t.DEBT as c7, t.BALANCE as c8, t.REMARK as c9, '' as c10, '' as c11, '' as c12, '' as c13, '' as c14, '' as c15, '' as c16, '' as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_changes t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43289981') order by t.businessid asc

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

6fpc3uazcdb56 select count(*) from t_base_account t where 1=1 and t.instcode = :1 and t.datastatus in(1, 2, 3, 4, 5, 6, 7, 8)

6krz8vwhjg5n2 SELECT SUM(B.CT) FROM ( SELECT COUNT(1) CT FROM t_base_account A WHERE A.DATASTATUS = 5 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :1) UNION ALL SELECT COUNT(1) CT FROM t_base_changes A WHERE A.DATASTATUS = 5 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :2) ) B

6vawqchns3v85 select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(2) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43395631') order by t.businessid asc

7g2nxzxuz01kn select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.businessid = :1 order by t.businessid asc

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

7s626urpwpqt1 select count(*) from t_base_account t where 1=1 and t.instcode = :1 and t.iscommit = 0 and t.datastatus in(1)

7tu3bxtjv7trv select count(account) from t_base_account t where t.ACCOUNT=:1 and t.instCode = :2 and BUSINESSID != :3 and CURRENCE_CODE=:4 and ACCOUNTSTAT = :5

7xu4vfxzryfs4 select a.id as id, a.name as name, a.shortname as shortName, a.customid as customId, a.layer as layer, a.parentid as parentId, a.path as path, c.rpttitle as rpttitle from t_org a inner join t_user_org t on a.id = t.fk_orgid inner join t_user u on u.id = t.fk_userid left join t_org_config c on c.org_id = a.customid where u.id=:1 order by path

7xv4jyck7y12u begin dbms_stats.GATHER_TABLE_STATS('DATACORE', 'TMP_T_BASE_ACCOUNT', cascade=>true); end;

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

9nu20wty9ma9d select 't_base_changes' as tableid, t.businessid, '' as rptno, t.branch_code as branchcode, t.account, t.currence_code as currencecode, t.datastatus, t.iscommit , to_char(DEAL_DATE, 'yyyymmdd') as dealdate from t_base_changes t where 1 = 1 and t.businessid = :1

9t1s5z3v9qc52 select count(*) from t_base_changes t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43289981')

9tgj4g8y4rwy8 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

9vntpsuc5423h select count(*) from T_RPT_SEND_COMMIT t where 1=1 and is_receive = '1' and tableid = :1 and businessid = :2

a1xgxtssv5rrp select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#

a7vz6b87kqk2x select count(*) from t_rpt_log_info t where 1 = 1 and t.tableid = :1 and t.businessid in (select businessid from t_base_changes where instCode in (select fk_orgId from t_user_org where fk_userId = '43289981'))

a8xzbs4kh4vsa select count(*) from t_base_changes t where 1=1 and t.instcode = :1 and t.datastatus < 4

adcj40cs4b8wv select count(*) from t_base_account t where 1=1 and t.instcode = :1 and t.businessid = :2

b1r6crsaf4mz1 select count(*) from t_base_account t where 1=1 and t.instcode = :1 and t.datastatus < 4

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

b338ammcu5s9b select ta.businessid from t_base_account ta where exists (select 1 from t_base_changes tc where tc.businessid=:1 and ta.account = tc.account and ta.instcode = tc.instcode and ta.currence_code = tc.currence_code) and ta.datastatus >= 5 order by ta.open_date desc, ta.auditdate desc

bvjub8fx0v5bj update t_base_account set isCommit = 1, modifyUser = '43702235' where 1=1 and businessid = :1 and dataStatus = :2

bx7csmkm83ucu SELECT :1 as cell_type, :2 as cell_title, 'true' as cell_target, B.BUSINESSID as cell_keyid, B.URL as cell_url, B.IMPORTDATE as cell_date, B.TITLE as cell_desc, :3 as cell_userid, SYSDATE as data_time FROM ( SELECT A.BUSINESSID, A.IMPORTDATE, 'editData.action?tableId=t_base_account&infoTypeCode=1&instCode=' || A.INSTCODE || '&businessId=' AS URL, '????????, ????????:' || A.INSTCODE || ', ??:' || A.ACCOUNT AS TITLE FROM t_base_account A WHERE A.DATASTATUS IN (1, 2, 3, 4) and A.ISCOMMIT = 0 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :4) UNION SELECT A.BUSINESSID, A.IMPORTDATE, 'editDataReadOnly.action?tableId=t_base_account&infoTypeCode=1&instCode=' || A.INSTCODE || '&businessId=' AS URL, '????????, ????????:' || A.INSTCODE || ', ??:' || A.ACCOUNT AS TITLE FROM t_base_account A WHERE A.DATASTATUS IN (3, 5) and A.ISCOMMIT = 1 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :5) UNION SELECT A.BUSINESS ID, A.IMPORTDATE, 'editData.action?tableId=t_base_changes&infoTypeCode=1&instCode=' || A.INSTCODE || '&businessId=' AS URL, '???????, ????????:' || A.INSTCODE || ', ??:' || A.ACCOUNT AS TITLE FROM t_base_changes A WHERE A.DATASTATUS IN (1, 2, 3, 4) and A.ISCOMMIT = 0 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :6) UNION SELECT A.BUSINESSID, A.IMPORTDATE, 'editDataReadOnly.action?tableId=t_base_changes&infoTypeCode=1&instCode=' || A.INSTCODE || '&businessId=' AS URL, '???????, ????????:' || A.INSTCODE || ', ??:' || A.ACCOUNT AS TITLE FROM t_base_changes A WHERE A.DATASTATUS IN (3, 5) and A.ISCOMMIT = 1 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :7) ) B WHERE ROWNUM<= :8 ORDER BY B.IMPORTDATE DESC

byfv3tmrrvnpk SELECT SUM(B.CT) FROM ( SELECT COUNT(1) CT FROM t_base_account A WHERE A.DATASTATUS IN (1, 2, 4) AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :1) UNION ALL SELECT COUNT(1) CT FROM t_base_changes A WHERE A.DATASTATUS IN (1, 2, 4) AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :2) ) B

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

cy5ptkf9dv38b select count(*) from t_base_account t where 1=1 and t.instcode = :1 and t.datastatus = 4

db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

dbqfhp56241yb select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43304268') order by t.businessid asc

fbssnpxms88kx select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43395631') order by t.businessid asc

fk6bnxu02b893 alter index ODS.SSALSFP_DATA_DATE rebuild parallel 1 nologging compute statistics

fm3n7vt38gnzd alter index ODS.DDACMSP_DATA_DATE rebuild parallel 1 nologging compute statistics

fqmpmkfr6pqyk select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

frvvmgb78k7md select t.logtype as logtype, t.tableid as tableid, t.userid as userid, t.updatetime as updatetime, t.businessid as businessid, t.subid as subid, t.datastatus as datastatus, t.column01 as column01, t.column02 as column02, t.column03 as column03, t.column04 as column04, t.column05 as column05, t.column06 as column06, t.column07 as column07, t.column08 as column08, t.column09 as column09, t.column10 as column10, t.column11 as column11, t.column12 as column12, t.column13 as column13, t.column14 as column14, t.column15 as column15, t.column16 as column16, t.column17 as column17, t.column18 as column18, t.column19 as column19, t.column20 as column20, t.column21 as column21, t.column22 as column22, t.column23 as column23, t.column24 as column24, t.column25 as column25, t.column26 as column26, t.column27 as column27, t.column28 as column28, t.column29 as column29, t.column30 as column30, t.column31 as column31, t.column32 as column32, t.column33 as colum n33, t.column34 as column34, t.column35 as column35, t.column36 as column36, t.column37 as column37 from t_rpt_log_info t where 1 = 1 and t.tableid = :1 and t.businessid in (select businessid from t_base_changes where instCode in (select fk_orgId from t_user_org where fk_userId = '43289981')) order by t.businessid asc, t.updatetime desc

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#

gm8v62jfaksy9 insert into T_RPT_SEND_COMMIT (tableid, businessid, packname, filename, is_receive) values(:1, :2, :3, :4, :5)

grwydz59pu6mc select text from view$ where rowid=:1

gz7125av46f4d select 't_base_account' as tableid, t.businessid, '' as rptno, t.branch_code as branchcode, t.account, t.currence_code as currencecode, t.datastatus, t.iscommit , '' as dealdate from t_base_account t where 1 = 1 and t.instCode = :1 and t.datastatus = 5 order by businessid asc

SQL Id	SQL Text
0585y1n8asf82	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.datastatus in(7) and t.instCode in (select fk_orgId from t_user_org where fk_userId = 'admin1') order by t.businessid asc
0az7czjdw8z7j	declare lbRec dbms_rcvman.lbRec_t; lbCursor dbms_rcvman.lbCursor_t; first boolean := FALSE; ret boolean; begin if (:first > 0) then first := TRUE; end if; <<next_row>> ret := dbms_rcvman.listBackup( lbRecOut => lbRec, firstCall => first, only_obsolete => TRUE, redundancy => :redundancy, piped_call => FALSE, lbCursor => lbCursor, lbState => dbms_rcvman.lbStatePck, extRlKeepSCN => NULL); if (not ret) then raise no_data_found; elsif (lbRec.pkey is not null and lbRec.is_rdf = 'YES') then :backup_type := lbRec.backup_type; :file_type := lbRec.file_type; :key := lbRec.pkey; else first := FALSE; goto next_row; end if; end;
0chsz91vjw9tj	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43554297') order by t.businessid asc
0kkhhb2w93cx0	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
13w9fdh2s5wzu	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.instcode = :1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) order by t.businessid asc
14xwkzy8qbf8r	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.instcode = :1 and t.businessid = :2 order by t.businessid asc
17b0jc7728gg2	select b.account, b.en_code, b.chinese_name, b.account_type, b.currence_code, case when s.account_status = '11' then b.open_date else b.importdate end, b.file_number, b.instcode, '1', -- b.auditdate, b.importdate, b.businessid, -- b.auditname, -- b.modifyuser, b.iscommit, 'A', '', b.branch_code, b.branch_name, s.account_status, b.amtype, b.account_cata, b.limit_type, b.remark, b.is_handiwork, b.account_limit from tmp_t_base_account b , tmp_account_status s where b.account \|\| b.instcode \|\| b.currence_code = s.account_num and s.account_status in ('11', '12')
1f2kbwu05q275	select u.id as id, u.username as username, u.name as name, u.password as password, u.description as description, u.fk_orgId as orgId, o.shortName as orgName, u.changePassword as changePassword, u.phone as phone, o.customid as customId from t_user u inner join t_org o on u.fk_orgid = o.id where u.id = :1
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1mctmndqx2h54	update t_base_account set datastatus = 7 where 1=1 and businessid = :1
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2xqcx45m245qf	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.ACCOUNT as c3, t.DEAL_DATE as c4, t.CURRENCE_CODE as c5, t.CREDIT as c6, t.DEBT as c7, t.BALANCE as c8, t.REMARK as c9, '' as c10, '' as c11, '' as c12, '' as c13, '' as c14, '' as c15, '' as c16, '' as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_changes t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43473200') order by t.businessid asc
2xtwcv43am491	/* SQL Analyze(0) / select /+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /to_char(count("ACCOUNT")), to_char(substrb(dump(min("ACCOUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNT"), 16, 0, 32), 1, 120)), to_char(count("EN_CODE")), to_char(substrb(dump(min("EN_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EN_CODE"), 16, 0, 32), 1, 120)), to_char(count("CHINESE_NAME")), to_char(substrb(dump(min("CHINESE_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CHINESE_NAME"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNT_TYPE")), to_char(substrb(dump(min("ACCOUNT_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNT_TYPE"), 16, 0, 32), 1, 120)), to_char(count("CURRENCE_CODE")), to_char(substrb(dump(min("CURRENCE_CODE "), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CURRENCE_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPEN_DATE")), to_char(substrb(dump(min("OPEN_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPEN_DATE"), 16, 0, 32), 1, 120)), to_char(count("FILE_NUMBER")), to_char(substrb(dump(min("FILE_NUMBER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FILE_NUMBER"), 16, 0, 32), 1, 120)), to_char(count("INSTCODE")), to_char(substrb(dump(min("INSTCODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INSTCODE"), 16, 0, 32), 1, 120)), to_char(count("DATASTATUS")), to_char(substrb(dump(min("DATASTATUS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DATASTATUS"), 16, 0, 32), 1, 120)), to_char(count("AUDITDATE")), to_char(substrb(dump(min("AUDITDATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AUDITDATE"), 16, 0 , 32), 1, 120)), to_char(count("IMPORTDATE")), to_char(substrb(dump(min("IMPORTDATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("IMPORTDATE"), 16, 0, 32), 1, 120)), to_char(count("BUSINESSID")), to_char(substrb(dump(min("BUSINESSID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BUSINESSID"), 16, 0, 32), 1, 120)), to_char(count("AUDITNAME")), to_char(substrb(dump(min("AUDITNAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AUDITNAME"), 16, 0, 32), 1, 120)), to_char(count("MODIFYUSER")), to_char(substrb(dump(min("MODIFYUSER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MODIFYUSER"), 16, 0, 32), 1, 120)), to_char(count("ISCOMMIT")), to_char(substrb(dump(min("ISCOMMIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ISCOMMIT"), 16, 0, 32), 1, 120)), to_char(count("ACTIONTYPE")), to_char(substrb(dump(min("A CTIONTYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACTIONTYPE"), 16, 0, 32), 1, 120)), to_char(count("ACTIONDESC")), to_char(substrb(dump(min("ACTIONDESC"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACTIONDESC"), 16, 0, 32), 1, 120)), to_char(count("BRANCH_CODE")), to_char(substrb(dump(min("BRANCH_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BRANCH_CODE"), 16, 0, 32), 1, 120)), to_char(count("BRANCH_NAME")), to_char(substrb(dump(min("BRANCH_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("BRANCH_NAME"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNTSTAT")), to_char(substrb(dump(min("ACCOUNTSTAT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNTSTAT"), 16, 0, 32), 1, 120)), to_char(count("AMTYPE")), to_char(substrb(dump(min("AMTYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AMTYPE "), 16, 0, 32), 1, 120)), to_char(count("ACCOUNT_CATA")), to_char(substrb(dump(min("ACCOUNT_CATA"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNT_CATA"), 16, 0, 32), 1, 120)), to_char(count("LIMIT_TYPE")), to_char(substrb(dump(min("LIMIT_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LIMIT_TYPE"), 16, 0, 32), 1, 120)), to_char(count("ACCOUNT_LIMIT")), to_char(substrb(dump(min("ACCOUNT_LIMIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ACCOUNT_LIMIT"), 16, 0, 32), 1, 120)), to_char(count("REMARK")), to_char(substrb(dump(min("REMARK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REMARK"), 16, 0, 32), 1, 120)), to_char(count("IS_HANDIWORK")), to_char(substrb(dump(min("IS_HANDIWORK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("IS_HANDIWORK"), 16, 0, 32), 1, 120)), to_char(count("LIMIT_CCY")), t o_char(substrb(dump(min("LIMIT_CCY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LIMIT_CCY"), 16, 0, 32), 1, 120)) from "DATACORE"."TMP_T_BASE_ACCOUNT" t / NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
399usqduff0b4	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.instcode = :1 and t.iscommit = 0 and t.datastatus in(1) order by t.businessid asc
39ks9z3mu62df	select sum(t.balance) from t_base_changes t where t.ACCOUNT=:1 and t.DEAL_DATE=(select max(deal_date) from t_base_changes where ACCOUNT=:2 and INSTCODE=:3 and CURRENCE_CODE=:4 and deal_date<:5 and actiontype <> 'D' ) and t.INSTCODE=:6 and t.CURRENCE_CODE=:7 and t.datastatus >= 5 and actiontype <> 'D'
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#
3hjq8q6kpg4nd	select 't_base_account' as tableid, t.businessid, '' as rptno, t.branch_code as branchcode, t.account, t.currence_code as currencecode, t.datastatus, t.iscommit , '' as dealdate from t_base_account t where 1 = 1 and t.businessid = :1
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#
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
3rwmw7xzcguck	update t_base_changes set datastatus = 7 where 1=1 and businessid = :1
3su2k441d3xv6	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.instcode = :1 and ((t.datastatus = 3 and t.iscommit = 1) or t.datastatus < 0) order by t.businessid asc
3u8bs3bqvvwmn	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43215074') order by t.businessid asc
3w4qs0tbpmxr6	select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
3waqrvtb15f1h	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43202901') order by t.businessid asc
4218x0dzf4pmt	select count(*) from t_base_changes t where 1=1 and t.instcode = :1 and t.datastatus = 4
42g8rh79bn457	SELECT SUM(B.CT) FROM ( SELECT COUNT(1) CT FROM t_base_account A WHERE A.DATASTATUS = 3 and A.ISCOMMIT = 1 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :1) UNION ALL SELECT COUNT(1) CT FROM t_base_changes A WHERE A.DATASTATUS = 3 and A.ISCOMMIT = 1 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :2) ) B
4csz4fc78rxd4	select count(*) from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43304268')
4tjnuw00zdvas	select 't_base_changes' as tableid, t.businessid, '' as rptno, t.branch_code as branchcode, t.account, t.currence_code as currencecode, t.datastatus, t.iscommit , to_char(DEAL_DATE, 'yyyymmdd') as dealdate from t_base_changes t where 1 = 1 and t.instCode = :1 and t.datastatus = 5 order by businessid asc
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
52vzgkun32d2q	update t_base_account set datastatus = 3 where 1=1 and businessid = :1
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
572fbaj0fdw2b	select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
5mw55dp9p6nyt	select nvl(max(al.recid), '0'), nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where al.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5v8a42nt3vbtw	select count(*) from t_base_changes t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and to_char(t.DEAL_DATE, 'yyyymmdd') = '20121231' and t.instCode in (select fk_orgId from t_user_org where fk_userId = 'admin')
60wkbmhrc0z0q	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.instcode = :1 and t.datastatus in(1, 2, 3, 4, 5, 6, 7, 8) order by t.businessid asc
62qp9vu11116k	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.ACCOUNT as c3, t.DEAL_DATE as c4, t.CURRENCE_CODE as c5, t.CREDIT as c6, t.DEBT as c7, t.BALANCE as c8, t.REMARK as c9, '' as c10, '' as c11, '' as c12, '' as c13, '' as c14, '' as c15, '' as c16, '' as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_changes t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43289981') order by t.businessid asc
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6fpc3uazcdb56	select count(*) from t_base_account t where 1=1 and t.instcode = :1 and t.datastatus in(1, 2, 3, 4, 5, 6, 7, 8)
6krz8vwhjg5n2	SELECT SUM(B.CT) FROM ( SELECT COUNT(1) CT FROM t_base_account A WHERE A.DATASTATUS = 5 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :1) UNION ALL SELECT COUNT(1) CT FROM t_base_changes A WHERE A.DATASTATUS = 5 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :2) ) B
6vawqchns3v85	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(2) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43395631') order by t.businessid asc
7g2nxzxuz01kn	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.businessid = :1 order by t.businessid asc
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7s626urpwpqt1	select count(*) from t_base_account t where 1=1 and t.instcode = :1 and t.iscommit = 0 and t.datastatus in(1)
7tu3bxtjv7trv	select count(account) from t_base_account t where t.ACCOUNT=:1 and t.instCode = :2 and BUSINESSID != :3 and CURRENCE_CODE=:4 and ACCOUNTSTAT = :5
7xu4vfxzryfs4	select a.id as id, a.name as name, a.shortname as shortName, a.customid as customId, a.layer as layer, a.parentid as parentId, a.path as path, c.rpttitle as rpttitle from t_org a inner join t_user_org t on a.id = t.fk_orgid inner join t_user u on u.id = t.fk_userid left join t_org_config c on c.org_id = a.customid where u.id=:1 order by path
7xv4jyck7y12u	begin dbms_stats.GATHER_TABLE_STATS('DATACORE', 'TMP_T_BASE_ACCOUNT', cascade=>true); end;
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9nu20wty9ma9d	select 't_base_changes' as tableid, t.businessid, '' as rptno, t.branch_code as branchcode, t.account, t.currence_code as currencecode, t.datastatus, t.iscommit , to_char(DEAL_DATE, 'yyyymmdd') as dealdate from t_base_changes t where 1 = 1 and t.businessid = :1
9t1s5z3v9qc52	select count(*) from t_base_changes t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43289981')
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
9vntpsuc5423h	select count(*) from T_RPT_SEND_COMMIT t where 1=1 and is_receive = '1' and tableid = :1 and businessid = :2
a1xgxtssv5rrp	select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
a7vz6b87kqk2x	select count(*) from t_rpt_log_info t where 1 = 1 and t.tableid = :1 and t.businessid in (select businessid from t_base_changes where instCode in (select fk_orgId from t_user_org where fk_userId = '43289981'))
a8xzbs4kh4vsa	select count(*) from t_base_changes t where 1=1 and t.instcode = :1 and t.datastatus < 4
adcj40cs4b8wv	select count(*) from t_base_account t where 1=1 and t.instcode = :1 and t.businessid = :2
b1r6crsaf4mz1	select count(*) from t_base_account t where 1=1 and t.instcode = :1 and t.datastatus < 4
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
b338ammcu5s9b	select ta.businessid from t_base_account ta where exists (select 1 from t_base_changes tc where tc.businessid=:1 and ta.account = tc.account and ta.instcode = tc.instcode and ta.currence_code = tc.currence_code) and ta.datastatus >= 5 order by ta.open_date desc, ta.auditdate desc
bvjub8fx0v5bj	update t_base_account set isCommit = 1, modifyUser = '43702235' where 1=1 and businessid = :1 and dataStatus = :2
bx7csmkm83ucu	SELECT :1 as cell_type, :2 as cell_title, 'true' as cell_target, B.BUSINESSID as cell_keyid, B.URL as cell_url, B.IMPORTDATE as cell_date, B.TITLE as cell_desc, :3 as cell_userid, SYSDATE as data_time FROM ( SELECT A.BUSINESSID, A.IMPORTDATE, 'editData.action?tableId=t_base_account&infoTypeCode=1&instCode=' \|\| A.INSTCODE \|\| '&businessId=' AS URL, '????????, ????????:' \|\| A.INSTCODE \|\| ', ??:' \|\| A.ACCOUNT AS TITLE FROM t_base_account A WHERE A.DATASTATUS IN (1, 2, 3, 4) and A.ISCOMMIT = 0 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :4) UNION SELECT A.BUSINESSID, A.IMPORTDATE, 'editDataReadOnly.action?tableId=t_base_account&infoTypeCode=1&instCode=' \|\| A.INSTCODE \|\| '&businessId=' AS URL, '????????, ????????:' \|\| A.INSTCODE \|\| ', ??:' \|\| A.ACCOUNT AS TITLE FROM t_base_account A WHERE A.DATASTATUS IN (3, 5) and A.ISCOMMIT = 1 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :5) UNION SELECT A.BUSINESS ID, A.IMPORTDATE, 'editData.action?tableId=t_base_changes&infoTypeCode=1&instCode=' \|\| A.INSTCODE \|\| '&businessId=' AS URL, '???????, ????????:' \|\| A.INSTCODE \|\| ', ??:' \|\| A.ACCOUNT AS TITLE FROM t_base_changes A WHERE A.DATASTATUS IN (1, 2, 3, 4) and A.ISCOMMIT = 0 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :6) UNION SELECT A.BUSINESSID, A.IMPORTDATE, 'editDataReadOnly.action?tableId=t_base_changes&infoTypeCode=1&instCode=' \|\| A.INSTCODE \|\| '&businessId=' AS URL, '???????, ????????:' \|\| A.INSTCODE \|\| ', ??:' \|\| A.ACCOUNT AS TITLE FROM t_base_changes A WHERE A.DATASTATUS IN (3, 5) and A.ISCOMMIT = 1 AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :7) ) B WHERE ROWNUM<= :8 ORDER BY B.IMPORTDATE DESC
byfv3tmrrvnpk	SELECT SUM(B.CT) FROM ( SELECT COUNT(1) CT FROM t_base_account A WHERE A.DATASTATUS IN (1, 2, 4) AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :1) UNION ALL SELECT COUNT(1) CT FROM t_base_changes A WHERE A.DATASTATUS IN (1, 2, 4) AND A.INSTCODE IN (SELECT FK_ORGID FROM T_USER_ORG WHERE FK_USERID = :2) ) B
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
cy5ptkf9dv38b	select count(*) from t_base_account t where 1=1 and t.instcode = :1 and t.datastatus = 4
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dbqfhp56241yb	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43304268') order by t.businessid asc
fbssnpxms88kx	select t.businessid, t.instcode, '' as sbhxstatus, t.datastatus, t.auditname, t.auditdate, t.importdate, t.is_Handiwork as isHandiwork , t.ACTIONTYPE as c1, t.ACTIONDESC as c2, t.BRANCH_CODE as c3, t.BRANCH_NAME as c4, t.ACCOUNT as c5, t.ACCOUNTSTAT as c6, t.AMTYPE as c7, t.EN_CODE as c8, t.CHINESE_NAME as c9, t.ACCOUNT_TYPE as c10, t.ACCOUNT_CATA as c11, t.CURRENCE_CODE as c12, t.OPEN_DATE as c13, t.FILE_NUMBER as c14, t.LIMIT_TYPE as c15, t.ACCOUNT_LIMIT as c16, t.REMARK as c17, '' as c18, '' as c19, '' as c20, '' as c21, '' as c22, '' as c23, '' as c24, '' as c25, '' as c26, '' as c27, '' as c28, '' as c29, '' as c30, '' as c31, '' as c32, '' as c33, '' as c34, '' as c35 from t_base_account t where 1=1 and t.iscommit = 0 and t.datastatus in(1, 2, 3, 4) and t.instCode in (select fk_orgId from t_user_org where fk_userId = '43395631') order by t.businessid asc
fk6bnxu02b893	alter index ODS.SSALSFP_DATA_DATE rebuild parallel 1 nologging compute statistics
fm3n7vt38gnzd	alter index ODS.DDACMSP_DATA_DATE rebuild parallel 1 nologging compute statistics
fqmpmkfr6pqyk	select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
frvvmgb78k7md	select t.logtype as logtype, t.tableid as tableid, t.userid as userid, t.updatetime as updatetime, t.businessid as businessid, t.subid as subid, t.datastatus as datastatus, t.column01 as column01, t.column02 as column02, t.column03 as column03, t.column04 as column04, t.column05 as column05, t.column06 as column06, t.column07 as column07, t.column08 as column08, t.column09 as column09, t.column10 as column10, t.column11 as column11, t.column12 as column12, t.column13 as column13, t.column14 as column14, t.column15 as column15, t.column16 as column16, t.column17 as column17, t.column18 as column18, t.column19 as column19, t.column20 as column20, t.column21 as column21, t.column22 as column22, t.column23 as column23, t.column24 as column24, t.column25 as column25, t.column26 as column26, t.column27 as column27, t.column28 as column28, t.column29 as column29, t.column30 as column30, t.column31 as column31, t.column32 as column32, t.column33 as colum n33, t.column34 as column34, t.column35 as column35, t.column36 as column36, t.column37 as column37 from t_rpt_log_info t where 1 = 1 and t.tableid = :1 and t.businessid in (select businessid from t_base_changes where instCode in (select fk_orgId from t_user_org where fk_userId = '43289981')) order by t.businessid asc, t.updatetime desc
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#
gm8v62jfaksy9	insert into T_RPT_SEND_COMMIT (tableid, businessid, packname, filename, is_receive) values(:1, :2, :3, :4, :5)
grwydz59pu6mc	select text from view$ where rowid=:1
gz7125av46f4d	select 't_base_account' as tableid, t.businessid, '' as rptno, t.branch_code as branchcode, t.account, t.currence_code as currencecode, t.datastatus, t.iscommit , '' as dealdate from t_base_account t where 1 = 1 and t.instCode = :1 and t.datastatus = 5 order by businessid asc

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	3	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	29	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	16	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	13	0.00	0.00
Batched IO vector read count	3	0.00	0.00
Block Cleanout Optim referenced	87	0.01	0.00
CCursor + sql area evicted	27	0.00	0.00
CPU used by this session	1,011,609	93.56	4.43
CPU used when call started	980,278	90.67	4.29
CR blocks created	895	0.08	0.00
Cached Commit SCN referenced	1,639,440	151.63	7.17
Commit SCN cached	73	0.01	0.00
DB time	1,043,999	96.56	4.57
DBWR checkpoint buffers written	12,152	1.12	0.05
DBWR checkpoints	87	0.01	0.00
DBWR fusion writes	7,609	0.70	0.03
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	646	0.06	0.00
DBWR thread checkpoint buffers written	3,888	0.36	0.02
DBWR transaction table writes	1,992	0.18	0.01
DBWR undo block writes	5,096	0.47	0.02
DFO trees parallelized	47	0.00	0.00
Effective IO time	61,175,825	5,658.12	267.61
HSC Heap Segment Block Changes	125,613	11.62	0.55
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	430	0.04	0.00
Heap Segment Array Updates	53,774	4.97	0.24
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	12,193	1.13	0.05
PX local messages recv'd	116	0.01	0.00
PX local messages sent	116	0.01	0.00
PX remote messages recv'd	166	0.02	0.00
PX remote messages sent	166	0.02	0.00
Parallel operations not downgraded	47	0.00	0.00
Requests to/from client	492,794	45.58	2.16
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for dropping temp segment	2	0.00	0.00
SMON posted for undo segment shrink	1	0.00	0.00
SQL*Net roundtrips to/from client	495,943	45.87	2.17
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	524	0.05	0.00
application wait time	316	0.03	0.00
background checkpoints completed	80	0.01	0.00
background checkpoints started	80	0.01	0.00
background timeouts	71,951	6.65	0.31
buffer is not pinned count	629,290	58.20	2.75
buffer is pinned count	459,120	42.46	2.01
bytes received via SQL*Net from client	249,339,005	23,061.21	1,090.72
bytes sent via SQL*Net to client	26,115,728	2,415.43	114.24
calls to get snapshot scn: kcmgss	649,227	60.05	2.84
calls to kcmgas	574,430	53.13	2.51
calls to kcmgcs	36,231,407	3,351.02	158.49
cell physical IO interconnect bytes	73,839,887,872	6,829,406.81	323,007.72
change write time	835	0.08	0.00
cleanout - number of ktugct calls	54,471	5.04	0.24
cleanouts and rollbacks - consistent read gets	59	0.01	0.00
cleanouts only - consistent read gets	53,965	4.99	0.24
cluster key scan block gets	12,661	1.17	0.06
cluster key scans	8,353	0.77	0.04
cluster wait time	33,034	3.06	0.14
commit batch/immediate performed	256	0.02	0.00
commit batch/immediate requested	256	0.02	0.00
commit cleanout failures: block lost	30	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	29	0.00	0.00
commit cleanout failures: cannot pin	5	0.00	0.00
commit cleanouts	117,340	10.85	0.51
commit cleanouts successfully completed	117,276	10.85	0.51
commit immediate performed	256	0.02	0.00
commit immediate requested	256	0.02	0.00
commit txn count during cleanout	54,187	5.01	0.24
concurrency wait time	519	0.05	0.00
consistent changes	370,006	34.22	1.62
consistent gets	2,290,985,707	211,891.89	10,021.77
consistent gets - examination	1,337,447	123.70	5.85
consistent gets direct	1,547,346	143.11	6.77
consistent gets from cache	2,289,438,361	211,748.78	10,015.00
consistent gets from cache (fastpath)	2,287,232,928	211,544.80	10,005.35
cursor authentications	992	0.09	0.00
data blocks consistent reads - undo records applied	643	0.06	0.00
db block changes	890,221	82.34	3.89
db block gets	2,617,066	242.05	11.45
db block gets direct	30,038	2.78	0.13
db block gets from cache	2,587,028	239.27	11.32
db block gets from cache (fastpath)	131,869	12.20	0.58
deferred (CURRENT) block cleanout applications	84,700	7.83	0.37
dirty buffers inspected	14	0.00	0.00
enqueue conversions	656	0.06	0.00
enqueue releases	285,363	26.39	1.25
enqueue requests	288,993	26.73	1.26
enqueue timeouts	3,659	0.34	0.02
enqueue waits	8,431	0.78	0.04
exchange deadlocks	0	0.00	0.00
execute count	158,886	14.70	0.70
file io wait time	5,307,924,244	490,926.72	23,219.16
free buffer inspected	121,829	11.27	0.53
free buffer requested	582,033	53.83	2.55
gc blocks compressed	7,966	0.74	0.03
gc cr block flush time	8	0.00	0.00
gc cr block receive time	18,674	1.73	0.08
gc cr blocks received	270,428	25.01	1.18
gc cr blocks served	219,515	20.30	0.96
gc current block flush time	6	0.00	0.00
gc current block pin time	1	0.00	0.00
gc current block receive time	9,757	0.90	0.04
gc current blocks received	141,478	13.09	0.62
gc current blocks served	109,096	10.09	0.48
gc kbytes saved	45,364	4.20	0.20
gc kbytes sent	2,583,524	238.95	11.30
gc local grants	14,236	1.32	0.06
gc read wait time	0	0.00	0.00
gc read wait timeouts	0	0.00	0.00
gc read waits	0	0.00	0.00
gc remote grants	114,364	10.58	0.50
gcs messages sent	1,085,948	100.44	4.75
ges messages sent	30,085	2.78	0.13
global enqueue get time	1,776	0.16	0.01
global enqueue gets async	6,784	0.63	0.03
global enqueue gets sync	186,157	17.22	0.81
global enqueue releases	182,480	16.88	0.80
heap block compress	102	0.01	0.00
hot buffers moved to head of LRU	17,239	1.59	0.08
immediate (CR) block cleanout applications	54,024	5.00	0.24
immediate (CURRENT) block cleanout applications	718	0.07	0.00
in call idle wait time	42,929,040	3,970.48	187.79
index crx upgrade (positioned)	3	0.00	0.00
index fast full scans (full)	19	0.00	0.00
index fetch by key	267,964	24.78	1.17
index scans kdiixs1	40,983	3.79	0.18
leaf node 90-10 splits	66	0.01	0.00
leaf node splits	162	0.01	0.00
lob reads	130,849	12.10	0.57
lob writes	105,450	9.75	0.46
lob writes unaligned	105,450	9.75	0.46
logical read bytes from cache	18,776,271,986,688	1,736,606,100.29	82,135,563.65
logons cumulative	143	0.01	0.00
max cf enq hold time	30	0.00	0.00
messages received	140,988	13.04	0.62
messages sent	140,988	13.04	0.62
min active SCN optimization applied on CR	238	0.02	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	2,255,046,010	208,567.85	9,864.55
non-idle wait count	2,747,131	254.08	12.02
non-idle wait time	412,418	38.14	1.80
opened cursors cumulative	264,780	24.49	1.16
parse count (describe)	99	0.01	0.00
parse count (failures)	10	0.00	0.00
parse count (hard)	3,234	0.30	0.01
parse count (total)	8,445	0.78	0.04
parse time cpu	3,554	0.33	0.02
parse time elapsed	3,990	0.37	0.02
physical read IO requests	15,325	1.42	0.07
physical read bytes	12,876,791,808	1,190,966.73	56,328.68
physical read total IO requests	195,483	18.08	0.86
physical read total bytes	71,320,538,112	6,596,393.66	311,986.99
physical read total multi block requests	71,537	6.62	0.31
physical reads	1,571,874	145.38	6.88
physical reads cache	23,298	2.15	0.10
physical reads cache prefetch	21,167	1.96	0.09
physical reads direct	1,548,576	143.23	6.77
physical reads direct (lob)	1	0.00	0.00
physical reads direct temporary tablespace	270	0.02	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	17,535	1.62	0.08
physical write bytes	708,468,736	65,525.85	3,099.15
physical write total IO requests	271,673	25.13	1.19
physical write total bytes	2,519,349,760	233,013.14	11,020.73
physical write total multi block requests	3,957	0.37	0.02
physical writes	86,483	8.00	0.38
physical writes direct	68,086	6.30	0.30
physical writes direct (lob)	134	0.01	0.00
physical writes direct temporary tablespace	37,296	3.45	0.16
physical writes from cache	18,397	1.70	0.08
physical writes non checkpoint	79,223	7.33	0.35
pinned buffers inspected	20	0.00	0.00
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	10,104	0.93	0.04
process last non-idle time	10,812	1.00	0.05
queries parallelized	47	0.00	0.00
recursive calls	451,994	41.80	1.98
recursive cpu usage	6,601	0.61	0.03
redo KB read	371,589	34.37	1.63
redo blocks checksummed by FG (exclusive)	470,948	43.56	2.06
redo blocks written	744,390	68.85	3.26
redo buffer allocation retries	236	0.02	0.00
redo entries	313,308	28.98	1.37
redo log space requests	879	0.08	0.00
redo log space wait time	5,411	0.50	0.02
redo ordering marks	2,134	0.20	0.01
redo size	330,416,248	30,560.00	1,445.38
redo size for direct writes	243,918,616	22,559.89	1,067.01
redo subscn max counts	10,167	0.94	0.04
redo synch long waits	176	0.02	0.00
redo synch time	8,228	0.76	0.04
redo synch time (usec)	82,305,297	7,612.37	360.04
redo synch writes	111,415	10.30	0.49
redo wastage	38,995,152	3,606.64	170.58
redo write broadcast ack count	24,505	2.27	0.11
redo write broadcast ack time	3,057,045	282.74	13.37
redo write broadcast lgwr post count	9	0.00	0.00
redo write time	6,909	0.64	0.03
redo writes	113,216	10.47	0.50
rollback changes - undo records applied	22	0.00	0.00
rollbacks only - consistent read gets	577	0.05	0.00
rows fetched via callback	221,684	20.50	0.97
session connect time	0	0.00	0.00
session logical reads	2,293,602,773	212,133.94	10,033.21
shared hash latch upgrades - no wait	4,803	0.44	0.02
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	1	0.00	0.00
sorts (memory)	15,161	1.40	0.07
sorts (rows)	18,812,126	1,739.92	82.29
sql area evicted	1,141	0.11	0.00
sql area purged	26	0.00	0.00
summed dirty queue length	61	0.01	0.00
switch current to new buffer	34,321	3.17	0.15
table fetch by rowid	445,076	41.16	1.95
table fetch continued row	1,551	0.14	0.01
table scan blocks gotten	2,254,878,056	208,552.31	9,863.82
table scan rows gotten	448,400,930,095	41,472,332.27	1,961,500.30
table scans (direct read)	2	0.00	0.00
table scans (long tables)	4	0.00	0.00
table scans (short tables)	994,078	91.94	4.35
total cf enq hold time	14,170	1.31	0.06
total number of cf enq holders	6,265	0.58	0.03
total number of times SMON posted	28	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction lock foreground wait time	0	0.00	0.00
transaction rollbacks	27	0.00	0.00
transaction tables consistent read rollbacks	1	0.00	0.00
transaction tables consistent reads - undo records applied	11	0.00	0.00
undo change vector size	22,652,400	2,095.11	99.09
user I/O wait time	6,924	0.64	0.03
user calls	731,413	67.65	3.20
user commits	111,224	10.29	0.49
user rollbacks	117,377	10.86	0.51
workarea executions - onepass	1	0.00	0.00
workarea executions - optimal	12,066	1.12	0.05
write clones created in background	5	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	1,067,525,744	1,074,895,336
session cursor cache count	12,760	13,815
session uga memory	38,736,936,064	38,734,626,952
opened cursors current	73	62
logons current	61	58
session uga memory max	5,822,722,608	6,824,883,288
session pga memory	493,889,136	446,125,896

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)	80	26.64

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)
RMAN	52.2G	9.46	4.94688	380M	1.38	.035145	51.8K	0.07
Direct Reads	11.8G	1.22	1.11819	3M	0.02	.000277	0
Others	1.8G	4.73	.170920	606M	0.99	.056048	55.8K	0.03
LGWR	417M	2.49	.038568	753M	21.16	.069644	141.3K	0.04
Direct Writes	8M	0.00	.000739	527M	0.29	.048741	0
Buffer Cache Reads	182M	0.20	.016833	0M	0.00	0M	2135	2.44
DBWR	0M	0.00	0M	143M	1.29	.013225	0
TOTAL:	66.4G	18.09	6.29214	2.4G	25.13	.223084	251.1K	0.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	Large Read
Data File	58.3G	5.81	5.52494	385M	1.49	.035608	1.84	92.65
Archive Log	5G	1.11	.476782	371M	0.04	.034313	4.07	92.22
Control File	2.7G	11.04	.255733	638M	2.46	.059008	0.01	0.96
Log File	372M	0.12	.034406	727M	21.01	.067239	0.01	3.75
Temp File	4M	0.00	.000369	292M	0.14	.027006	4.90	1.00
Other	0M	0.00	0M	0M	0.00	0M	0.00
TOTAL:	66.4G	18.09	6.29223	2.4G	25.13	.223176	0.11	90.86

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)
RMAN	52.2G	9.46	4.94688	380M	1.38	.035145	44.5K	0.09
RMAN (Data File)	46.3G	4.39	4.38926	0M	0.00	0M	48	0.00
RMAN (Archive Log)	5G	1.11	.476782	0M	0.00	0M	1512	1.85
RMAN (Control File)	874M	3.96	.080835	380M	1.37	.035145	42.9K	0.02
Direct Reads	11.8G	1.22	1.11819	3M	0.02	.000277	0
Direct Reads (Data File)	11.8G	1.22	1.11819	3M	0.02	.000277	0
Others	1.8G	4.72	.170920	606M	0.99	.056048	50.7K	0.03
Others (Control File)	1.4G	4.63	.136514	232M	0.94	.021457	50.1K	0.03
Others (Archive Log)	0M	0.00	0M	371M	0.04	.034313	0
Others (Log File)	371M	0.09	.034313	0M	0.00	0M	567	0.00
Others (Data File)	1M	0.01	.000092	3M	0.01	.000277	73	0.05
LGWR	417M	2.49	.038568	753M	21.16	.069644	27.2K	0.01
LGWR (Log File)	1M	0.03	.000092	727M	21.01	.067239	648	0.00
LGWR (Control File)	416M	2.46	.038475	26M	0.15	.002404	26.6K	0.01
Direct Writes	8M	0.00	.000739	527M	0.29	.048741	0
Direct Writes (Data File)	8M	0.00	.000739	527M	0.29	.048741	0
Buffer Cache Reads	182M	0.20	.016833	0M	0.00	0M	2140	2.44
Buffer Cache Reads (Data File)	182M	0.20	.016833	0M	0.00	0M	2140	2.44
DBWR	0M	0.00	0M	143M	1.29	.013225	0
DBWR (Data File)	0M	0.00	0M	143M	1.29	.013225	0
TOTAL:	66.4G	18.09	6.29214	2.4G	25.13	.223084	124.6K	0.09

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	Av Buf Wt(ms)
ODS	43,161	4	73.63	126.96	1,817	0	0	0.00
ACC	2,173	0	105.28	120.69	7,508	1	622	0.50
UNDOTBS1	3,088	0	117.19	124.38	4,164	0	0	0.00
DATACORE	5,967	1	127.45	113.48	85	0	0	0.00
UNDOTBS2	3,181	0	103.49	124.77	80	0	0	0.00
SYSAUX	1,350	0	114.28	85.67	1,714	0	0	0.00
SYSTEM	1,504	0	39.83	43.23	300	0	8	195.00
TEMP01	44	0	0.00	10.68	1,465	0	0	0.00
UPRR	1,115	0	99.76	117.63	242	0	0	0.00
CFA	1,105	0	99.52	118.69	80	0	0	0.00
USERS	101	0	18.61	26.14	80	0	0	0.00

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	Av Buf Wt(ms)
ACC	+DATA01/uprr/datafile/acc_0001.ora	2,173	0	105.28	120.69	7,508	1	622	0.50
CFA	+DATA01/uprr/datafile/cfa_0001.ora	1,105	0	99.52	118.69	80	0	0	0.00
DATACORE	+DATA01/uprr/datafile/datacore_0001.ora	5,967	1	127.45	113.48	85	0	0	0.00
ODS	+DATA01/uprr/datafile/ods_0001.ora	14,350	1	90.81	126.94	670	0	0	0.00
ODS	+DATA01/uprr/datafile/ods_0002.ora	14,198	1	69.89	126.95	584	0	0	0.00
ODS	+DATA01/uprr/datafile/ods_0003.ora	14,613	1	60.38	126.99	563	0	0	0.00
SYSAUX	+DATA01/uprr/datafile/sysaux_01.dbf	1,350	0	114.28	85.67	1,714	0	0	0.00
SYSTEM	+DATA01/uprr/datafile/system_01.dbf	1,504	0	39.83	43.23	300	0	8	195.00
TEMP01	+DATA01/uprr/datafile/temp_0001.ora	44	0	0.00	10.68	1,465	0	0
UNDOTBS1	+DATA01/uprr/datafile/undotbs1_01.dbf	3,088	0	117.19	124.38	4,164	0	0	0.00
UNDOTBS2	+DATA01/uprr/datafile/undotbs2_01.dbf	3,181	0	103.49	124.77	80	0	0	0.00
UPRR	+DATA01/uprr/datafile/uprr_0001.ora	1,115	0	99.76	117.63	242	0	0	0.00
USERS	+DATA01/uprr/datafile/users_01.dbf	101	0	18.61	26.14	80	0	0	0.00

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	394,592	100	2,290,794,353	23,300	18,397	0	0	630

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 86,483

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	1,711	0	0	7,618	2,177

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	5	1	843	8911	33129	33129			1570	0
E	3	1	754	7672	33129	33129			2546	0

Back to Advisory Statistics
Back to Top

MTTR Advisory

Only rows at end snap are displayed
Estimated Writes and I/Os are in thousands

Size for Est (s)	Dirty Limit	Est Cache Writes	Est Cache Write Fctr	Est Total Writes	Est Total Write Fctr	Est Total IOs	Est Total IO Fctr
2	1,718	489	1.11	844	1.06	49,753	1.00
3	3,038	439	1.00	794	1.00	49,703	1.00

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	320	0.10	38	1.05	12,413	1	2574.00
D	640	0.19	76	1.02	12,073	1	2155.00
D	960	0.29	113	1.01	11,966	1	2023.00
D	1,280	0.38	151	1.01	11,923	1	1970.00
D	1,600	0.48	189	1.01	11,901	1	1943.00
D	1,920	0.57	227	1.01	11,890	1	1929.00
D	2,240	0.67	264	1.01	11,878	1	1915.00
D	2,560	0.77	302	1.00	11,861	1	1894.00
D	2,880	0.86	340	1.00	11,839	1	1866.00
D	3,200	0.96	378	1.00	11,813	1	1834.00
D	3,344	1.00	395	1.00	11,804	1	1823.00
D	3,520	1.05	415	1.00	11,793	1	1809.00
D	3,840	1.15	453	1.00	11,781	1	1795.00
D	4,160	1.24	491	1.00	11,774	1	1786.00
D	4,480	1.34	529	1.00	11,771	1	1782.00
D	4,800	1.44	566	1.00	11,768	1	1778.00
D	5,120	1.53	604	1.00	11,765	1	1775.00
D	5,440	1.63	642	1.00	11,765	1	1774.00
D	5,760	1.72	680	1.00	11,765	1	1774.00
D	6,080	1.82	717	1.00	11,765	1	1774.00
D	6,400	1.91	755	1.00	11,765	1	1774.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
90.25	3,031	327

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

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	1-Pass Execs
2K	4K	11,078	11,078	0
64K	128K	94	94	0
128K	256K	28	28	0
256K	512K	62	62	0
512K	1024K	498	498	0
1M	2M	263	263	0
2M	4M	7	7	0
4M	8M	10	10	0
8M	16M	6	6	0
16M	32M	9	9	0
32M	64M	3	3	0
64M	128M	14	14	0
256M	512M	2	1	1

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 PGA Cache Hit %	Estd Time
494	0.13	912.27	100.00	72,015
988	0.25	912.27	100.00	72,015
1,976	0.50	912.27	100.00	72,015
2,964	0.75	912.27	100.00	72,015
3,952	1.00	912.27	100.00	72,015
4,742	1.20	912.27	100.00	72,015
5,533	1.40	912.27	100.00	72,015
6,323	1.60	912.27	100.00	72,015
7,114	1.80	912.27	100.00	72,015
7,904	2.00	912.27	100.00	72,015
11,856	3.00	912.27	100.00	72,015
15,808	4.00	912.27	100.00	72,015
23,712	6.00	912.27	100.00	72,015
31,616	8.00	912.27	100.00	72,015

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)
624	0.76	14	1,309	26,731	0.73	11,109	7.67	4,236
656	0.80	45	2,281	30,991	0.85	6,849	4.73	4,385
672	0.82	58	2,990	33,342	0.92	4,498	3.11	4,470
688	0.84	74	3,441	35,816	0.98	2,024	1.40	4,555
704	0.86	90	3,654	36,019	0.99	1,821	1.26	4,564
720	0.88	106	3,925	36,228	1.00	1,612	1.11	4,573
736	0.90	122	4,184	36,302	1.00	1,538	1.06	4,576
752	0.92	138	4,453	36,376	1.00	1,464	1.01	4,579
768	0.94	154	4,764	36,381	1.00	1,459	1.01	4,579
784	0.96	169	5,171	36,385	1.00	1,455	1.00	4,579
800	0.98	185	5,529	36,388	1.00	1,452	1.00	4,580
816	1.00	201	5,949	36,392	1.00	1,448	1.00	4,580
832	1.02	217	6,611	36,392	1.00	1,448	1.00	4,580
848	1.04	233	6,891	36,392	1.00	1,448	1.00	4,581
864	1.06	248	7,453	36,392	1.00	1,448	1.00	4,581
880	1.08	264	7,977	36,392	1.00	1,448	1.00	4,581
896	1.10	280	8,345	36,392	1.00	1,448	1.00	4,581
912	1.12	296	8,715	36,392	1.00	1,448	1.00	4,581
928	1.14	312	9,277	36,392	1.00	1,448	1.00	4,581
944	1.16	328	9,696	36,393	1.00	1,447	1.00	4,581
960	1.18	344	10,525	36,393	1.00	1,447	1.00	4,581
1,008	1.24	392	11,488	36,393	1.00	1,447	1.00	4,582
1,104	1.35	488	12,811	36,393	1.00	1,447	1.00	4,582
1,200	1.47	584	14,134	36,393	1.00	1,447	1.00	4,582
1,296	1.59	680	16,487	36,393	1.00	1,447	1.00	4,582
1,392	1.71	776	21,178	36,393	1.00	1,447	1.00	4,582
1,488	1.82	872	25,869	36,393	1.00	1,447	1.00	4,582
1,584	1.94	968	30,560	36,393	1.00	1,447	1.00	4,582
1,680	2.06	1,064	35,251	36,393	1.00	1,447	1.00	4,582

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,060	0.25	62,472	12,423,876
1,590	0.38	59,005	12,083,917
2,120	0.50	58,817	11,934,004
2,650	0.63	58,794	11,912,756
3,180	0.75	58,765	11,889,148
3,710	0.88	58,718	11,850,194
4,240	1.00	58,659	11,804,158
4,770	1.13	58,641	11,792,354
5,300	1.25	58,630	11,782,911
5,830	1.38	58,624	11,775,828
6,360	1.50	58,624	11,775,828
6,890	1.63	58,624	11,775,828
7,420	1.75	58,624	11,775,828
7,950	1.88	58,624	11,775,828
8,480	2.00	58,624	11,775,828

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

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	480	2	4
segment header	149	0	0
1st level bmb	1	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	Wt Time (s)	Av Wt Time(ms)
CO-KTUCLO Master Slave enq (master slave det)	3,598	0	3,598	3,598	3	0.81
KO-Multiple Object Checkpoint (fast object checkpoint)	36	36	0	14	2	156.43
CF-Controlfile Transaction	36,016	36,015	1	3,816	2	0.52
TC-Tablespace Checkpoint	9	9	0	3	1	330.00
RS-Reclaimable Space (prevent file delete)	1,512	1,512	0	470	0	0.79
PS-PX Process Reservation	311	311	0	120	0	0.58
TA-Instance Undo	36	36	0	34	0	1.76
WL-Being Written Redo Log	80	80	0	40	0	1.25
TM-DML	113,576	113,576	0	30	0	1.67
CR-Reuse Block Range (block range reuse ckpt)	302	302	0	27	0	1.48
WF-AWR Flush	69	69	0	57	0	0.35
FB-Format Block	82	82	0	49	0	0.41
PI-Remote PX Process Spawn Status	36	36	0	18	0	0.56
ST-Space Transaction	6	6	0	2	0	5.00
TS-Temporary Segment	131	71	60	50	0	0.00
HW-Segment High Water Mark	992	992	0	36	0	0.00
TD-KTF map table enqueue (KTF dump entries)	21	21	0	20	0	0.00
BR-Backup/Restore (file shrink)	12	12	0	6	0	0.00
DR-Distributed Recovery	6	6	0	6	0	0.00
MW-MWIN Schedule	6	6	0	6	0	0.00
TO-Temp Object	33	33	0	6	0	0.00
TT-Tablespace	894	894	0	6	0	0.00
RO-Multiple Object Reuse (fast object reuse)	14	14	0	4	0	0.00
AF-Advisor Framework (task serialization)	39	39	0	3	0	0.00
PE-Parameter	26	26	0	3	0	0.00
DL-Direct Loader Index Creation	7	7	0	2	0	0.00
PG-Global Parameter	9	9	0	2	0	0.00
MD-Materialized View Log DDL	4	4	0	1	0	0.00
PW-Buffer Cache PreWarm (flush prewarm buffers)	6	6	0	1	0	0.00
SK-Shrink Segment	1	1	0	1	0	0.00
TX-Transaction (allocate ITL entry)	1	1	0	1	0	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	3.12	113,720	3,910	7	16.1/78.2	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
09-Jan 13:55	132	6,108	649	1	24	0/0	0/0/0/0/0/0
09-Jan 13:45	127	6,131	1,261	1	34	0/0	0/0/0/0/0/0
09-Jan 13:35	137	6,165	659	3	24	0/0	0/0/0/0/0/0
09-Jan 13:25	139	6,371	59	1	34	0/0	0/0/0/0/0/0
09-Jan 13:15	133	6,231	3,910	1	78	0/0	0/0/0/0/0/0
09-Jan 13:05	305	6,470	3,309	4	68	0/0	0/0/0/0/0/0
09-Jan 12:55	131	6,260	2,708	1	58	0/0	0/0/0/0/0/0
09-Jan 12:45	144	6,927	2,108	1	48	0/0	0/0/0/0/0/0
09-Jan 12:35	140	6,405	1,506	1	38	0/0	0/0/0/0/0/0
09-Jan 12:25	166	6,547	906	4	35	0/0	0/0/0/0/0/0
09-Jan 12:15	180	6,416	678	5	25	0/0	0/0/0/0/0/0
09-Jan 12:05	286	4,425	2,587	7	56	0/0	0/0/0/0/0/0
09-Jan 11:55	140	6,452	1,986	1	46	0/0	0/0/0/0/0/0
09-Jan 11:45	132	6,317	1,386	1	36	0/0	0/0/0/0/0/0
09-Jan 11:35	137	6,397	785	1	26	0/0	0/0/0/0/0/0
09-Jan 11:25	177	6,591	184	2	16	0/0	0/0/0/0/0/0
09-Jan 11:15	133	6,439	699	1	25	0/0	0/0/0/0/0/0
09-Jan 11:05	385	7,068	99	3	25	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	3	0.00		0
ASM Keyed state latch	192	0.00		0
ASM allocation	35,619	0.00		0
ASM db client latch	7,467	0.00		0
ASM map headers	21,076	0.00		0
ASM map load waiting list	3,471	0.00		0
ASM map operation freelist	322	0.00		0
ASM map operation hash table	8,411,838	0.00	0.00	0
ASM network background latch	44,594	0.00		0
ASM network state latch	19,810	0.00		0
AWR Alerted Metric Element list	83,175	0.00		0
Change Notification Hash table latch	3,608	0.00		0
Consistent RBA	113,299	0.00		0
DML lock allocation	227,185	0.00		0
Event Group Locks	258	0.00		0
FAL Queue	449	0.00		0
FIB s.o chain latch	6,948	0.00		0
FOB s.o list latch	7,881	0.00		0
File State Object Pool Parent Latch	3	0.00		0
I/O Staticstics latch	3	0.00		0
IPC other latch	91	0.00		0
IPC stats buffer allocation latch	522	0.00		505	0.00
In memory undo latch	3	0.00		0
JS Sh mem access	3	0.00		0
JS queue access latch	3	0.00		0
JS slv state obj latch	3	0.00		0
KFC FX Hash Latch	3	0.00		0
KFC Hash Latch	3	0.00		0
KFCL LE Freelist	3	0.00		0
KFK SGA Libload latch	644	0.00		0
KFMD SGA	14	0.00		0
KGNFS-NFS:SHM structure	3	0.00		0
KGNFS-NFS:SVR LIST	3	0.00		0
KJC message pool free list	17,159	0.01	0.00	2,053	0.00
KJCT flow control latch	1,611,884	0.00	0.00	0
KMG MMAN ready and startup request latch	3,734	0.00		0
KMG resize request state object freelist	8	0.00		0
KSXR large replies	726	0.00		0
KTF sga latch	78	0.00		3,622	0.00
KWQMN job cache list latch	762	0.00		0
Locator state objects pool parent latch	3	0.00		0
Lsod array latch	1,307	0.00		0
MQL Tracking Latch	0			216	0.00
Memory Management Latch	237	0.00		3,734	0.00
Memory Queue	3	0.00		0
Memory Queue Message Subscriber #1	3	0.00		0
Memory Queue Message Subscriber #2	3	0.00		0
Memory Queue Message Subscriber #3	3	0.00		0
Memory Queue Message Subscriber #4	3	0.00		0
Memory Queue Subscriber	3	0.00		0
MinActiveScn Latch	3,834	0.00		0
Mutex	3	0.00		0
Mutex Stats	3	0.00		0
OS process	736	0.00		0
OS process allocation	21,982	0.00		0
OS process: request allocation	192	0.00		0
PL/SQL warning settings	2,290	0.00		0
PX hash array latch	3	0.00		0
QMT	3	0.00		0
Real-time plan statistics latch	20,539	0.00		0
Reserved Space Latch	320	0.00		0
SGA IO buffer pool latch	48	0.00		48	0.00
SGA blob parent	3	0.00		0
SGA bucket locks	3	0.00		0
SGA heap locks	3	0.00		0
SGA pool locks	3	0.00		0
SQL memory manager latch	363	0.00		3,600	0.00
SQL memory manager workarea list latch	281,545	0.00		0
Shared B-Tree	379	0.00		0
Streams Generic	3	0.00		0
Testing	3	0.00		0
Token Manager	3	0.00		0
WCR: sync	3	0.00		0
Write State Object Pool Parent Latch	3	0.00		0
X$KSFQP	125,297	0.00		0
XDB NFS Security Latch	3	0.00		0
XDB unused session pool	3	0.00		0
XDB used session pool	3	0.00		0
active checkpoint queue latch	19,077	0.00		0
active service list	2,026,808	0.00	0.25	5,558	0.00
alert log latch	160	0.00		0
archive control	5,256	0.00		0
archive process latch	1,428	0.14	1.00	0
begin backup scn array	1,140	0.00		0
buffer pool	24	0.00		0
business card	97	0.00		0
cache buffer handles	1,473	0.00		0
cache buffers chains	4,585,755,224	0.01	0.00	33,970,605	0.00
cache buffers lru chain	351,199	0.01	0.00	34,294,939	0.00
cache table scan latch	241	0.00		241	0.00
call allocation	3,796	0.03	0.00	0
cas latch	3	0.00		0
change notification client cache latch	3	0.00		0
channel handle pool latch	257	0.00		0
channel operations parent latch	1,765,915	0.00	0.00	0
checkpoint queue latch	1,258,753	0.00	0.00	98,321	0.00
client/application info	5,086	0.00		0
compile environment latch	165	0.00		0
corrupted undo seg latch	93	0.00		0
cp cmon/server latch	3	0.00		0
cp pool latch	3	0.00		0
cp server hash latch	3	0.00		0
cp sga latch	362	0.00		0
cvmap freelist lock	3	0.00		0
deferred cleanup latch	362	0.00		0
device information	24	0.00		0
dml lock allocation	372	0.00		0
done queue latch	3	0.00		0
dummy allocation	332	0.00		0
enqueue freelist latch	3	0.00		123,835	0.00
enqueue hash chains	827,763	0.00	0.00	16	0.00
enqueues	80	0.00		0
error message lists	199	0.50	0.00	0
fifth spare latch	3	0.00		0
file cache latch	1,432	0.07	0.00	0
flashback copy	3	0.00		0
fourth Audit Vault latch	3	0.00		0
gc element	2,132,353	0.02	0.02	271,667	0.15
gc persistent rm	2	0.00		0
gcs commit scn state	3	0.00		0
gcs opaque info freelist	249,784	0.00	0.00	0
gcs partitioned table hash	18,057,652	0.00	0.00	2,355	0.00
gcs pcm hashed value bucket hash	3	0.00		0
gcs remaster request queue	133	0.00		0
gcs remastering latch	123,289	2.28	0.00	2	0.00
gcs resource freelist	101,676	0.00		13,377	0.00
gcs resource hash	2,794,339	0.02	0.00	0
gcs resource scan list	3	0.00		0
gcs shadows freelist	79,381	0.00		10,977	0.00
ges caches resource lists	103,521	0.01	0.00	130,175	0.00
ges deadlock list	1,582	0.00		0
ges domain table	369,178	0.00		0
ges enqueue table freelist	374,365	0.00	0.00	0
ges group table	365,540	0.00	0.00	0
ges process hash list	107,020	0.00		0
ges process parent latch	782,982	0.00		0
ges process table freelist	192	0.00		0
ges resource hash list	681,972	0.02	0.08	4,360	0.92
ges resource scan list	339	0.00		0
ges resource table freelist	9,614	0.00		0
ges timeout list	11,504	0.00		292	0.00
ges value block free list	94	0.00		0
global KZLD latch for mem in SGA	20	0.00		0
global tx hash mapping	3	0.00		0
granule operation	3	0.00		0
hash table column usage latch	1,735	0.00		1,851,847	0.00
hash table modification latch	339	0.00		0
heartbeat check	3	0.00		3,068	0.00
heartbeat structure management	0			2,162	0.00
internal temp table object number allocation latch	93	0.00		0
interrupt manipulation	603	0.00		0
intra txn parallel recovery	3	0.00		0
io pool granule metadata list	3	0.00		0
job workq parent latch	3	0.00		0
k2q global data latch	7,204	0.00		0
k2q lock allocation	3	0.00		0
kcbtsemkid latch	80	0.00		0
kdlx hb parent latch	3	0.00		0
kgb parent	3	0.00		0
kgnfs mount latch	3	0.00		0
kokc descriptor allocation latch	342	0.00		0
krbmrosl	1,906	0.00		0
ksfv messages	3	0.00		0
ksim group membership cache	1,367	0.00		0
ksim membership request latch	0			4,823	0.00
kss move lock	105	0.00		0
ksuosstats global area	1,089	0.00		0
ksv allocation latch	565	0.00		0
ksv class latch	154,484	0.12	0.02	0
ksv instance latch	16	0.00		0
ksv msg queue latch	10,594	0.00		10,591	0.00
ksxp shared latch	192	0.00		0
ksxp so latch	192	0.00		0
ksz_so allocation latch	192	0.00		0
ktm global data	212	0.00		0
kwqbsn:qsga	376	0.00		0
lgwr LWN SCN	117,384	0.00		0
list of block allocation	177	0.00		0
loader state object freelist	1,166	0.00		0
lob segment dispenser latch	3	0.00		0
lob segment hash table latch	39	0.00		0
lob segment query latch	3	0.00		0
lock DBA buffer during media recovery	3	0.00		0
logical standby cache	3	0.00		0
logminer context allocation	3	0.00		0
logminer work area	3	0.00		0
longop free list parent	6,430	0.00		96	0.00
managed standby latch	369	0.00		0
mapped buffers lru chain	3	0.00		0
message pool operations parent latch	14,272	0.00		0
messages	1,103,438	0.01	0.00	0
mostly latch-free SCN	117,701	0.13	0.00	0
msg queue latch	3	0.00		0
multiblock read objects	519,326	0.00	0.00	0
name-service memory objects	110,988	0.00		0
name-service namespace bucket	110,065	0.00		0
name-service namespace objects	36	0.00		0
name-service pending queue	54,910	0.00		0
name-service request	108	0.00		0
name-service request queue	179,188	0.00		0
ncodef allocation latch	362	0.00		0
object queue header heap	147,162	0.00		2,627	0.00
object queue header operation	1,434,593	0.00	0.06	28,825	0.00
object stats modification	154	0.00		0
parallel query alloc buffer	2,455	0.00		0
parallel query stats	209	0.00		0
parallel txn reco latch	2,304	0.00		0
parameter list	280	0.00		0
parameter table management	501	0.20	0.00	0
peshm	3	0.00		0
pesom_free_list	3	0.00		0
pesom_hash_node	3	0.00		0
post/wait queue	335,987	0.08	0.03	243,662	0.00
process allocation	52,630	0.00		94	0.00
process group creation	192	0.00		0
process queue	556	0.00		0
process queue reference	8,548	0.00		781	0.00
qmn task queue latch	1,531	0.00		0
query server freelists	462	0.00		0
query server process	47	0.00		18	0.00
queued dump request	36	0.00		0
queuing load statistics	3	0.00		0
recovery domain hash list	3	0.00		0
redo allocation	349,089	0.02	0.00	313,415	0.06
redo copy	3	0.00		313,487	0.09
redo writing	366,608	0.01	0.00	0
reservation so alloc latch	160	0.00		0
resmgr group change latch	110	0.00		0
resmgr:active threads	328	0.00		0
resmgr:actses change group	146	0.00		0
resmgr:actses change state	3	0.00		0
resmgr:free threads list	325	0.00		0
resmgr:plan CPU method	3	0.00		0
resmgr:resource group CPU method	3	0.00		0
resmgr:schema config	33	0.00		0
resmgr:session queuing	3	0.00		0
rm cas latch	3	0.00		0
row cache objects	4,657,159	0.00	0.00	462	0.00
rules engine aggregate statistics	1	0.00		0
rules engine rule set statistics	2	0.00		0
second Audit Vault latch	3	0.00		0
second spare latch	3	0.00		0
segmented array pool	6,914	0.00		0
sequence cache	1,019	0.00		0
session allocation	236,451	0.00		236,074	0.00
session idle bit	1,703,262	0.00	0.00	7	0.00
session queue latch	3	0.00		0
session state list latch	347	0.00		0
session switching	475	0.00		0
session timer	3,765	0.00		0
shared pool	353,281	0.01	0.00	0
shared pool sim alloc	151	0.00		0
shared pool simulator	8,281	0.00		0
shrink stat allocation latch	2	0.00		0
sim partition latch	6	0.00		427	0.00
simulator hash latch	143,292,645	0.00	0.00	0
simulator lru latch	1,400	0.07	0.00	143,279,892	0.06
sort extent pool	978	0.00		0
space background state object latch	33	0.00		0
space background task latch	15,083	0.19	0.00	7,226	0.00
state object free list	18	0.00		0
statistics aggregation	1,008	0.00		0
tablespace key chain	26	0.00		0
temp lob duration state obj allocation	16	0.00		0
temporary table state object allocation	9	0.00		0
test excl. parent l0	3	0.00		0
test excl. parent2 l0	3	0.00		0
third spare latch	3	0.00		0
threshold alerts latch	578	0.00		0
transaction allocation	232	0.00		0
undo global data	403,213	0.00	0.00	0
virtual circuit buffers	3	0.00		0
virtual circuit holder	3	0.00		0
virtual circuit queues	3	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
cache buffers chains	4,585,755,224	292,969	118	292,854
simulator hash latch	143,292,645	967	4	963
gcs resource hash	2,794,339	592	2	590
gc element	2,132,353	521	11	511
post/wait queue	335,987	279	8	272
ksv class latch	154,484	182	4	178
ges resource hash list	681,972	125	10	115
object queue header operation	1,434,593	69	4	67
active service list	2,026,808	8	2	6
archive process latch	1,428	2	2	0

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	3	0
archive process latch	kcrrsarc	2	0
cache buffers chains	kcbgtcr: fast path (cr pin)	114	72
cache buffers chains	kcbgtcr: kslbegin excl	36	66
cache buffers chains	kcbzibmlt: multi-block read: nowait	9	0
cache buffers chains	kcbrls: fast release	6	5
cache buffers chains	kcbgcur_2	4	2
cache buffers chains	kcllkopesc	4	0
cache buffers chains	kcbzwb	2	3
cache buffers chains	kcbbxsv	1	0
cache buffers chains	kcl_fairness	1	0
cache buffers chains	kclbla	1	0
gc element	kclnfndnewm	5	0
gc element	kclplz	5	0
gc element	kclevict	1	0
gcs resource hash	kjbconvert	1	0
gcs resource hash	kjbmpcreatepi	1	2
ges resource hash list	kjrmas1: lookup master node	5	0
ges resource hash list	kjakcai: search for resp by resname	4	0
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	1	0
ksv class latch	ksvclsl: rdp - recycle	3	0
ksv class latch	ksvclsl: create	1	0
object queue header operation	kcbo_check_flist	2	8
object queue header operation	kclobj_5	2	0
post/wait queue	kslpstevent:get	8	8
simulator hash latch	kcbsacc: lookup dba	4	4

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Cursor Pin	kkslce [KKSCHLPIN2]	761
Library Cache	kglhdgn2 106	10
Library Cache	kglhdgn1 62	6
Library Cache	kglpnal2 91	6
Library Cache	kglpin1 4	5
Library Cache	kgllkal1 80	2
Library Cache	kgllkdl1 85	2
Library Cache	kglget2 2	1
Library Cache	kglini1 32	1
Library Cache	kgllkc1 57	1
Library Cache	kglllal3 111	1
Library Cache	kgllldl2 112	1
Library Cache	kglobld1 75	1
Library Cache	kglpndl1 95	1

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: 2,293,602,773
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
DATACORE	DATACORE	TMP_ACCOUNT_STATUS		TABLE	1,860,788,096	81.13
ACC	ACC	T_BASE_CHANGES		TABLE	401,683,296	17.51
ACC	ACC	T_BASE_ACCOUNT		TABLE	25,933,280	1.13
MISSING	TEMP01	** TRANSIENT: 6285824	MISSING	UNDEFINED	1,239,424	0.05
ACC	ACC	T_RPT_SEND_COMMIT		TABLE	983,072	0.04

Buffer Nowait %:	100.00	Redo NoWait %:	99.72
Buffer Hit %:	100.00	In-memory Sort %:	99.99
Library Hit %:	94.99	Soft Parse %:	61.71
Execute to Parse %:	94.68	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	89.07	% Non-Parse CPU:	99.64

Buffer access - local cache %:	99.98
Buffer access - remote cache %:	0.02
Buffer access - disk %:	0.00

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.7
Avg global cache current block receive time (ms):	0.7
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	0.0
Avg global cache cr block flush time (ms):	2.4
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.1
Avg global cache current block flush time (ms):	1.1

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.6
Avg message received queue time (ms):	0.1
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	69.56
% of indirect sent messages:	30.43
% of flow controlled messages:	0.02

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
ODS	ODS	SSALSFP	TABLE	777,703	49.48
ODS	ODS	DDACMSP	TABLE	769,647	48.96
DATACORE	DATACORE	TMP_T_BASE_ACCOUNT	TABLE	11,213	0.71
DATACORE	DATACORE	TMP_T_BASE_ACCOUNT	TABLE	10,480	0.67
SYS	SYSTEM	IDL_UB1$	TABLE	674	0.04

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
ODS	ODS	SSALSFP	TABLE	6,128	39.99
ODS	ODS	DDACMSP	TABLE	6,070	39.61
SYS	SYSTEM	IDL_UB1$	TABLE	674	4.40
DATACORE	DATACORE	TMP_T_BASE_ACCOUNT	TABLE	507	3.31
DATACORE	DATACORE	TMP_T_BASE_ACCOUNT	TABLE	240	1.57

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
ODS	ODS	DDACMSP	TABLE	30,320	35.06
ACC	ACC	T_BASE_CHANGES	TABLE	6,164	7.13
ACC	ACC	T_RPT_SEND_COMMIT	TABLE	1,514	1.75
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	151	0.17
SYS	SYSAUX	SYS_LOB0000006324C00038$$	LOB	135	0.16

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
ODS	ODS	DDACMSP		TABLE	29,412	43.20
SYS	SYSAUX	SYS_LOB0000006324C00038$$		LOB	132	0.19
ODS	ODS	DDACMSP_DATA_DATE		INDEX	113	0.17
ODS	ODS	SSALSFP_DATA_DATE		INDEX	113	0.17
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1121506063_498	TABLE PARTITION	58	0.09

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_OBJ2	INDEX	4	17.39
ODS	ODS	DDACMSP	TABLE	1	4.35
ODS	ODS	SSALSFP	TABLE	1	4.35
DATACORE	DATACORE	TMP_T_BASE_ACCOUNT	TABLE	1	4.35
DATACORE	DATACORE	TMP_T_BASE_ACCOUNT	TABLE	1	4.35

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
ACC	ACC	T_BASE_CHANGES	TABLE	19	73.08
SYS	SYSTEM	SEG$	TABLE	5	19.23
ACC	ACC	T_RPT_SEND_COMMIT	TABLE	2	7.69

Owner	Tablespace Name	Object Name	Obj. Type	GC Buffer Busy	% of Capture
ACC	ACC	T_BASE_CHANGES	TABLE	595	98.51
ACC	ACC	T_BASE_ACCOUNT	TABLE	6	0.99
SYS	SYSTEM	AUD$	TABLE	3	0.50

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
ACC	ACC	T_BASE_CHANGES		TABLE	258,989	95.77
ACC	ACC	T_RPT_SEND_COMMIT		TABLE	4,394	1.62
ACC	ACC	T_BASE_ACCOUNT		TABLE	3,521	1.30
MISSING	DATACORE	** MISSING: 17082/18473	MISSING	UNDEFINED	2,220	0.82
UPRR	UPRR	U_BASE_USER		TABLE	130	0.05

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
ACC	ACC	T_BASE_CHANGES	TABLE	127,546	90.15
ACC	ACC	T_BASE_ACCOUNT	TABLE	3,352	2.37
ACC	ACC	T_RPT_LOG_INFO	TABLE	3,124	2.21
ACC	ACC	T_RPT_SEND_COMMIT	TABLE	2,848	2.01
DATACORE	DATACORE	TMP_ACCOUNT_STATUS	TABLE	2,213	1.56

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	196	0.00	6	1
dc_global_oids	500	4.80	0	38
dc_histogram_data	639,967	0.28	149	2,527
dc_histogram_defs	374,815	1.10	110	4,138
dc_object_grants	81	53.09	0	50
dc_objects	150,608	0.55	32	1,296
dc_profiles	20	0.00	0	1
dc_rollback_segments	57,832	0.00	0	67
dc_segments	70,469	1.17	57	541
dc_sequences	30	20.00	30	1
dc_table_scns	4	100.00	0	0
dc_tablespace_quotas	550	2.18	0	3
dc_tablespaces	313,443	0.00	0	12
dc_users	344,336	0.01	0	50
global database name	9,743	0.00	0	1
outstanding_alerts	150	96.00	1	0

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	40	7.50	0		0	0
BODY	187	13.37	6,946	0.49	3	0
CLUSTER	639	0.63	641	0.62	0	0
DBLINK	60	0.00	0		0	0
EDITION	61	0.00	81	1.23	1	0
INDEX	432	9.49	434	10.14	0	0
OBJECT ID	5	100.00	0		0	0
QUEUE	2	0.00	2	100.00	1	0
RULESET	1	0.00	1	100.00	1	0
SCHEMA	622	0.48	0		0	0
SQL AREA	8,020	20.85	177,853	3.98	683	79
SQL AREA BUILD	2,706	79.08	0		0	0
SQL AREA STATS	2,524	90.97	2,524	90.97	0	0
TABLE/PROCEDURE	14,844	2.37	47,762	4.95	1,018	0
TRIGGER	58	17.24	58	17.24	0	0

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases
ACCOUNT_STATUS	40	0	0
BODY	0	6,939	6,939
CLUSTER	641	641	641
DBLINK	60	0	0
EDITION	61	60	60
INDEX	431	434	434
QUEUE	0	2	2
RULESET	0	1	1
SCHEMA	25	0	0
TABLE/PROCEDURE	19,111	26,669	26,669
TRIGGER	0	58	58

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	3,616.00	3,344.00	3,344.00	4,224.00	4	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	3,776.00	3,952.00	3,280.00	3,952.00	1	GRO/MAN
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	4,416.00	4,240.00	4,240.00	4,912.00	1	SHR/DEF
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	16.00	16.00	16.00	16.00	0	STA/
large pool	16.00	16.00	16.00	16.00	0	STA/
shared pool	720.00	816.00	608.00	816.00	3	GRO/DEF
streams pool	0.00	0.00	0.00	0.00	0	STA/

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	3,344.00	3,584.00	3,500.00	4	0	4
PGA Target	3,952.00	3,952.00	3,952.00	1	1	0
SGA Target	4,240.00	4,240.00	4,240.00	1	0	1
shared pool	752.00	816.00	784.00	3	3	0

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
01/09 12:20:58	0	bufcache	SHR/DEF	3,520	-176	3,344	COM
01/09 12:20:56	0	pga	GRO/MAN	3,776	176	3,952	COM
01/09 12:20:56	2	sga	SHR/DEF	4,416	-176	4,240	COM
01/09 12:17:54	1	bufcache	SHR/DEF	3,552	-32	3,520	COM
01/09 12:17:54	1	shared	GRO/DEF	784	32	816	COM
01/09 12:00:24	0	bufcache	SHR/DEF	3,584	-32	3,552	COM
01/09 12:00:24	0	shared	GRO/DEF	752	32	784	COM
01/09 11:00:20	0	bufcache	SHR/DEF	3,616	-32	3,584	COM
01/09 11:00:20	0	shared	GRO/DEF	720	32	752	COM

	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	397.45		6.41	9.92	44	44	62	62
B	Freeable	25.38	0.00	0.91	0.67	3		28	28
B	SQL	9.98	6.82	0.32	1.62	9	185	31	26
B	PL/SQL	1.36	0.32	0.02	0.07	0	1	62	61
E	Other	358.31		6.18	9.91	44	44	58	58
E	Freeable	22.94	0.00	1.00	0.73	3		23	23
E	PL/SQL	1.39	1.14	0.02	0.14	1	2	58	57
E	SQL	0.73	0.12	0.03	0.04	0	187	26	21

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

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	3,791,650,816	3,506,438,144
Fixed Size	2,245,480
Redo Buffers	9,723,904
Variable Size	4,747,955,352	5,033,168,024

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	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	16.00	16.00	0.00
shared	Checkpoint queue	15.63	15.63	0.00
shared	FileOpenBlock	15.20	15.20	0.00
shared	KGLH0	33.01	52.62	59.40
shared	KGLS		8.46
shared	SQLA	84.23	164.30	95.06
shared	db_block_hash_buckets	22.25	22.25	0.00
shared	dbktb: trace buffer	7.81		-100.00
shared	event statistics per sess	9.69	9.69	0.00
shared	file state object	8.17	8.17	0.00
shared	free memory	106.08	83.02	-21.74
shared	gc name table	12.00	12.00	0.00
shared	gcs resources	110.43	110.43	0.00
shared	gcs shadows	64.42	64.42	0.00
shared	ges big msg buffers	13.92	13.92	0.00
shared	ges enqueues	15.76	15.76	0.00
shared	ges reserved msg buffers	8.05		-100.00
shared	ges resource	13.11	13.11	0.00
shared	ksunfy : SSO free list	9.03	9.03	0.00
shared	row cache	7.24		-100.00
shared	write state object	14.64	14.64	0.00
	buffer_cache	3,616.00	3,344.00	-7.52
	fixed_sga	2.14	2.14	0.00
	log_buffer	9.27	9.27	0.00

Parameter Name	Begin value	End value (if different)
archive_lag_target	1800
audit_file_dest	/u01/sq/admin/UPRR/adump
audit_sys_operations	TRUE
audit_trail	DB, EXTENDED
cluster_database	TRUE
cluster_database_instances	2
compatible	11.2.0.3
control_file_record_keep_time	14
control_files	+DATA01/uprr/controlfile/control01.ctl, +DATA01/uprr/controlfile/control02.ctl
core_dump_dest	/u01/sq/admin/UPRR/cdump
cursor_sharing	EXACT
db_block_size	8192
db_domain
db_files	2000
db_name	UPRR
db_recovery_file_dest	+FRA01
db_recovery_file_dest_size	107374182400
diagnostic_dest	/u01/sq
fast_start_mttr_target	900
global_names	TRUE
instance_name	UPRR1
instance_number	1
job_queue_processes	5
local_listener	listener_UPRR1
log_archive_dest_1	location=use_db_recovery_file_dest
log_archive_dest_state_1	enable
log_archive_dest_state_10	defer
log_archive_dest_state_2	defer
log_archive_dest_state_3	defer
log_archive_dest_state_4	defer
log_archive_dest_state_5	defer
log_archive_dest_state_6	defer
log_archive_dest_state_7	defer
log_archive_dest_state_8	defer
log_archive_dest_state_9	defer
log_archive_format	UPRR_%t_%s_%r.arc
log_buffer	4194304
log_checkpoint_timeout	0
max_dump_file_size	5M
memory_max_target	8589934592
memory_target	8589934592
open_cursors	2000
optimizer_mode	FIRST_ROWS_100
processes	500
recyclebin	ON
remote_listener	odsdbprod.cn.hsbc:1521
remote_login_passwordfile	EXCLUSIVE
resource_limit	TRUE
service_names	UPRR
sga_max_size	8589934592
spfile	+DATA01/uprr/spfileuprr.ora
thread	1
undo_management	AUTO
undo_tablespace	UNDOTBS1

Parameter Name	Begin value	End value (if different)
audit_trail	DB
audit_trail	EXTENDED
control_files	+DATA01/uprr/controlfile/control01.ctl
control_files	+DATA01/uprr/controlfile/control02.ctl

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	170,474	15.77	0.75
acks for commit broadcast(logical)	170,846	15.80	0.75
broadcast msgs on commit(actual)	113,003	10.45	0.49
broadcast msgs on commit(logical)	113,211	10.47	0.50
broadcast msgs on commit(wasted)	244	0.02	0.00
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	5	0.00	0.00
flow control messages sent	2	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	32,396	3.00	0.14
gcs ast xid	0	0.00	0.00
gcs blocked converts	74,686	6.91	0.33
gcs blocked cr converts	157,342	14.55	0.69
gcs compatible basts	74	0.01	0.00
gcs compatible cr basts (global)	69,580	6.44	0.30
gcs compatible cr basts (local)	9,967	0.92	0.04
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	6,718	0.62	0.03
gcs dbwr write request msgs	5,007	0.46	0.02
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	115	0.01	0.00
gcs force cr grant	2	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	1,929	0.18	0.01
gcs immediate (null) converts	2,830	0.26	0.01
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	11,255	1.04	0.05
gcs indirect ast	46,228	4.28	0.20
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	46,228	4.28	0.20
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	4,075	0.38	0.02
gcs msgs process time(ms)	37,080	3.43	0.16
gcs msgs received	981,077	90.74	4.29
gcs new served by master	1,424	0.13	0.01
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	388	0.04	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	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	55,794	5.16	0.24
gcs side channel msgs logical	485,103	44.87	2.12
gcs stale cr	508	0.05	0.00
gcs undo cr	267	0.02	0.00
gcs write notification msgs	8	0.00	0.00
gcs writes refused	5	0.00	0.00
ges msgs process time(ms)	638	0.06	0.00
ges msgs received	29,322	2.71	0.13
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	0	0.00	0.00
global posts requested	0	0.00	0.00
global posts sent	0	0.00	0.00
implicit batch messages received	8,914	0.82	0.04
implicit batch messages sent	7,540	0.70	0.03
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	163	0.02	0.00
messages queue sent actual	254,828	23.57	1.11
messages queue sent logical	46,459	4.30	0.20
messages received actual	926,823	85.72	4.05
messages received logical	1,010,399	93.45	4.42
messages sent directly	632,179	58.47	2.77
messages sent indirectly	276,532	25.58	1.21
messages sent not implicit batched	2	0.00	0.00
messages sent pbatched	317,008	29.32	1.39
msgs causing lmd to send msgs	14,799	1.37	0.06
msgs causing lms(s) to send msgs	163,239	15.10	0.71
msgs received queue time (ms)	63,090	5.84	0.28
msgs received queued	1,010,403	93.45	4.42
msgs sent queue time (ms)	12,280	1.14	0.05
msgs sent queue time on ksxp (ms)	609,137	56.34	2.66
msgs sent queued	293,619	27.16	1.28
msgs sent queued on ksxp	1,057,069	97.77	4.62
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	194,950	18.03	0.85
process batch messages sent	296,946	27.46	1.30

Statistic	Total
CR Block Requests	117,676
CURRENT Block Requests	102,277
Data Block Requests	117,676
Undo Block Requests	96
TX Block Requests	2,204
Current Results	219,150
Private results	4
Zero Results	357
Disk Read Results	442
Fail Results	0
Fairness Down Converts	104,357
Fairness Clears	670
Free GC Elements	0
Flushes	34
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	38,711
Light Works	28
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms
Pins	3	33.33	66.67	0.00
Flushes	55	65.45	34.55	0.00
Writes	7,609	61.57	35.97	2.46

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	178,160	97.57	0.04	2.38	94,813	96.24	0.44	3.31
2	Others	92,148	98.23	0.00	1.77	46,640	98.53	0.05	1.42
2	undo header	62	82.26	16.13	1.61	13	92.31	0.00	7.69
2	undo block	51	96.08	1.96	1.96	0

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
2	data block	0.74	0.73	2.39	1.13	0.79	0.71	8.22	1.97
2	others	0.60	0.60	1.36	0.63	0.49	0.47	61.38	0.47
2	undo header	1.30	0.54	5.25	0.38	0.47	0.46		0.67
2	undo block	0.51	0.49	1.41	0.38

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
2	data block	0	173,838	100.00	0.00	91,251	100.00	0.00
2	others	0	90,520	100.00	0.00	45,955	100.00	0.00
2	undo header	0	51	100.00	0.00	12	100.00	0.00
2	undo block	0	49	100.00	0.00	0