WORKLOAD REPOSITORY report for

whooshribbitΛογισμικό & κατασκευή λογ/κού

2 Δεκ 2013 (πριν από 3 χρόνια και 9 μήνες)

274 εμφανίσεις

WORKLOAD REPOSITORY report for

DB Name

DB Id

Instance

Inst num

Release

RAC

Host

ORCL

1198388159

orcl1

1

10.2.0.3.0

YES

node1


Snap Id

Snap Time

Sessions

Cursors/Session

Begin Snap:

4796

04
-
Jun
-
09 16:00:16

47

2.9

End Snap:

4798

04
-
Jun
-
09 18:00:55

106

20.4

Elapsed:



120.66 (mins)





DB Time:



141.84 (mins)





Report Summary

Cache Sizes


Begin

End



Buffer Cache:

5,392M

5,392M

Std Block Size:

8K

Shared Pool Size:

720M

720M

Log Buffer:

4,224K

Load Profile


Per Second

Per Transaction

Redo size:

229,323.06

14,623.11

Logical reads:

39,954.43

2,547.75

Block changes:

1,350.15

86.09

Physical reads:

66.54

4.24

Physical writes:

37.49

2.39

User calls:

539.97

34.43

Parses:

297.59

18.98

Hard parses:

0.31

0.02

Sorts:

45.63

2.91

Logons:

0.58

0.04

Executes:

529.19

33.74

Transactions:

15.68



% Blocks changed per Read:

3.38

Recursive Call %:

67.37

Rollback per transaction %:

6.43

Rows per Sort:

131.81

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:

99.99

Redo NoWait %:

100.00

Bu
ffer Hit %:

99.96

In
-
memory Sort %:

100.00

Library Hit %:

99.89

Soft Parse %:

99.89

Execute to Parse %:

43.77

Latch Hit %:

99.94

Parse CPU to Parse Elapsd %:

96.41

% Non
-
Parse CPU:

97.63

Shared Pool Statistics


Begin

End

Memory Usage %:

69.30

75.94

% SQL with executions>1:

60.18

89.41

% Memory for SQL w/exec>1:

61.24

94.59

Top 5 Timed Events

Event

Waits

Time(s)

Avg Wait(ms)

% Total Call Time

Wait Class

CPU time



3,201



37.6



gc buffer busy

31,850

1,184

37

13.9

Cluster

log file sync

173,559

8
77

5

10.3

Commit

flashback buf free by RVWR

24,319

619

25

7.3

Other

db file sequential read

161,855

559

3

6.6

User I/O

RAC Statistics


Begin

End

Number of Instances:

2

2

Global Cache Load Profile


Per Second

Per Transaction

Global Cache blocks recei
ved:

112.55

7.18

Global Cache blocks served:

108.30

6.91

GCS/GES messages received:

388.86

24.80

GCS/GES messages sent:

369.39

23.55

DBWR Fusion writes:

5.52

0.35

Estd Interconnect traffic (KB)

1,914.94



Global Cache Efficiency Percentages (Target l
ocal+remote 100%)

Buffer access
-

local cache %:

99.68

Buffer access
-

remote cache %:

0.28

Buffer access
-

disk %:

0.04

Global Cache and Enqueue Services
-

Workload Characteristics

Avg global enqueue get time (ms):

1.2

Avg global cache cr block rece
ive time (ms):

0.8

Avg global cache current block receive time (ms):

1.7

Avg global cache cr block build time (ms):

0.0

Avg global cache cr block send time (ms):

0.1

Global cache log flushes for cr blocks served %:

12.8

Avg global cache cr block flush

time (ms):

2.5

Avg global cache current block pin time (ms):

0.6

Avg global cache current block send time (ms):

0.1

Global cache log flushes for current blocks served %:

2.4

Avg global cache current block flush time (ms):

37.8

Global Cache and Enqueu
e Services
-

Messaging Statistics

Avg message sent queue time (ms):

0.1

Avg message sent queue time on ksxp (ms):

0.3

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:

61.53

% of indirect sent messages:

17.56

% of flow controlled messages:

20.90


Main Report



Report Summary




Wait Events Statistics




SQL Statistics




Instance Activity Statistics




IO Stats




Buffer Pool Statistics




Advisory Statistics




Wait Statistics




Undo Statistic
s




Latch Statistics




Segment Statistics




Dictionary Cache Statistics




Library Cache Statistics




Memory Statistics




Streams Statistics




Resource Limit Statistics




init.ora Parameters


More RAC Statistics



RAC Report Summary




Global Enqueue Statistics




Global CR Served Stats




Global CURRENT Served Stats




Global Cache Transfer Stats



Back to Top


Wait Events Statistics



Tim
e Model Statistics



Wait Class



Wait Events



Background Wait Events



Operating System Statistics



Service Statistics



Service Wait Class Stats

Back to Top

Time Model Statistics



Total time in database user
-
calls (DB Time): 8510.6s



Statistics including the word "background" measure background process time, and so do not
cont
ribute to the DB time statistic



Ordered by % or DB time desc, Statistic name

Statistic Name

Time (s)

% of DB Time

sql execute elapsed time

8,027.50

94.32

DB CPU

3,200.65

37.61

Java execution elapsed time

1,100.72

12.93

PL/SQL execution elapsed time

1
36.28

1.60

parse time elapsed

83.87

0.99

sequence load elapsed time

59.92

0.70

hard parse elapsed time

20.10

0.24

connection management call elapsed time

1.60

0.02

repeated bind elapsed time

1.35

0.02

PL/SQL compilation elapsed time

1.09

0.01

inboun
d PL/SQL rpc elapsed time

0.90

0.01

hard parse (sharing criteria) elapsed time

0.13

0.00

RMAN cpu time (backup/restore)

0.04

0.00

hard parse (bind mismatch) elapsed time

0.02

0.00

failed parse elapsed time

0.00

0.00

DB time

8,510.60



background elap
sed time

1,546.03



background cpu time

528.56



Back to Wait Events Statistics


Back to Top

Wait Class



s
-

second



cs
-

centisecond
-

100th of a second



ms
-

millisecond
-

1000th of a second



us
-

micro
second
-

1000000th of a second



ordered by wait time desc, waits desc

Wait Class

Waits

%Time
-
outs

Total Wait Time (s)

Avg wait (ms)

Waits /txn

Cluster

1,046,560

0.10

2,175

2

9.22

Other

523,707

51.94

1,136

2

4.61

User I/O

369,238

0.00

976

3

3.25

Commi
t

173,559

0.00

877

5

1.53

Application

9,719

5.17

496

51

0.09

Configuration

8,850

14.01

475

54

0.08

System I/O

374,736

0.00

300

1

3.30

Concurrency

52,209

0.09

74

1

0.46

Network

2,833,834

0.00

11

0

24.96

Back to Wait Events Stat
istics


Back to Top

Wait Events



s
-

second



cs
-

centisecond
-

100th of a second



ms
-

millisecond
-

1000th of a second



us
-

microsecond
-

1000000th of a second



ordered by wait time desc, waits desc (idle events last)

Event

Wa
its

%Time
-
outs

Total Wait Time
(s)

Avg wait
(ms)

Waits
/txn

gc buffer busy

31,850

2.75

1,184

37

0.28

log file sync

173,559

0.00

877

5

1.53

flashback buf free by RVWR

24,319

1.46

619

25

0.21

db file sequential read

161,855

0.00

559

3

1.43

enq: TX
-

ro
w lock contention

6,166

8.14

495

80

0.05

enq: HW
-

contention

8,243

8.13

474

58

0.07

gc current block busy

12,283

0.83

402

33

0.11

gcs log flush sync

123,595

36.12

357

3

1.09

db file scattered read

17,832

0.00

216

12

0.16

gc current block 2
-
way

293,92
9

0.00

143

0

2.59

gc cr block 2
-
way

324,394

0.00

137

0

2.86

log file parallel write

217,294

0.00

135

1

1.91

gc cr block busy

44,105

0.00

124

3

0.39

direct path read

152,559

0.00

120

1

1.34

db file parallel write

81,817

0.00

99

1

0.72

gc current multi

block request

79,622

0.02

79

1

0.70

gc cr multi block request

184,106

0.00

60

0

1.62

db file parallel read

1,722

0.00

56

32

0.02

reliable message

11,866

0.35

54

5

0.10

gc current grant busy

57,047

0.00

39

1

0.50

log file sequential read

1,796

0.00

35

20

0.02

enq: TX
-

index contention

708

3.11

27

39

0.01

cr request retry

39

97.44

27

680

0.00

Streams AQ: qmn coordinator waiting for slave to
start

5

100.00

25

5033

0.00

row cache lock

32,018

0.00

24

1

0.28

buffer busy waits

12,018

0.09

21

2

0.11

co
ntrol file sequential read

65,376

0.00

20

0

0.58

DFS lock handle

33,542

0.00

15

0

0.30

direct path write

34,828

0.00

13

0

0.31

read by other session

442

0.00

11

26

0.00

rdbms ipc reply

1,391

0.22

9

6

0.01

Log archive I/O

4,542

0.00

8

2

0.04

SQL*Net m
ore data to client

402,361

0.00

6

0

3.54

enq: WF
-

contention

48

22.92

6

129

0.00

wait for scn ack

26,703

0.00

5

0

0.24

control file parallel write

3,868

0.00

4

1

0.03

SQL*Net message to client

2,297,123

0.00

3

0

20.23

gc current grant 2
-
way

10,728

0.
00

3

0

0.09

enq: PS
-

contention

7,833

0.00

3

0

0.07

gc cr grant 2
-
way

8,350

0.00

2

0

0.07

enq: FB
-

contention

305

0.00

2

7

0.00

PX Deq: reap credit

108,450

95.63

2

0

0.96

PX Deq: Signal ACK

11,638

33.02

2

0

0.10

global enqueue expand wait

159

84.28

2

12

0.00

SQL*Net more data from client

134,350

0.00

2

0

1.18

enq: US
-

contention

4,144

0.00

2

0

0.04

gc current retry

34

0.00

1

44

0.00

PX Deq Credit: send blkd

6,074

37.85

1

0

0.05

enq: TX
-

contention

35

0.00

1

33

0.00

ksxr poll remote instances

87,408

53.47

1

0

0.77

os thread startup

12

0.00

1

59

0.00

CGS wait for IPC msg

67,124

99.84

1

0

0.59

ges global resource directory to be frozen

25

92.00

0

13

0.00

log file switch completion

20

0.00

0

15

0.00

library cache pin

1,637

0.00

0

0

0.01

lib
rary cache lock

893

0.00

0

0

0.01

SQL*Net break/reset to client

3,452

0.00

0

0

0.03

name
-
service call wait

3

0.00

0

82

0.00

latch: cache buffers chains

4,857

0.00

0

0

0.04

cursor: pin S wait on X

13

92.31

0

14

0.00

control file single write

19

0.00

0

7

0.00

RMAN backup & recovery I/O

9

0.00

0

14

0.00

gc current split

73

0.00

0

2

0.00

change tracking file synchronous read

138

0.00

0

1

0.00

enq: CF
-

contention

271

0.00

0

0

0.00

latch free

93

0.00

0

1

0.00

LGWR wait for redo copy

3,033

0.00

0

0

0.0
3

change tracking file synchronous write

121

0.00

0

1

0.00

KJC: Wait for msg sends to complete

1,596

0.00

0

0

0.01

IPC send completion sync

273

98.90

0

0

0.00

buffer deadlock

2,907

97.32

0

0

0.03

enq: TM
-

contention

99

0.00

0

0

0.00

enq: SQ
-

conten
tion

1

0.00

0

30

0.00

kjbdrmcvtq lmon drm quiesce: ping completion

25

24.00

0

1

0.00

gcs drm freeze in enter server mode

1

0.00

0

28

0.00

recovery area: computing obsolete files

1

0.00

0

18

0.00

log buffer space

5

0.00

0

3

0.00

gc cr failure

33

0.00

0

0

0.00

enq: TT
-

contention

30

0.00

0

0

0.00

enq: TA
-

contention

25

0.00

0

0

0.00

latch: ges resource hash list

85

0.00

0

0

0.00

enq: TX
-

allocate ITL entry

10

0.00

0

1

0.00

enq: FL
-

Flashback database log

18

0.00

0

0

0.00

log file single write

1
4

0.00

0

1

0.00

ges inquiry response

16

0.00

0

0

0.00

latch: KCL gc element parent latch

141

0.00

0

0

0.00

enq: DR
-

contention

7

0.00

0

0

0.00

latch: row cache objects

14

0.00

0

0

0.00

latch: shared pool

15

0.00

0

0

0.00

latch: gcs resource hash

47

0.00

0

0

0.00

enq: CT
-

global space management

5

0.00

0

0

0.00

enq: WL
-

contention

4

0.00

0

0

0.00

enq: MW
-

contention

5

0.00

0

0

0.00

undo segment extension

571

99.82

0

0

0.01

gc cr disk read

4

0.00

0

0

0.00

latch: library cache

18

0.00

0

0

0.00

gc current block unknown

2

0.00

0

1

0.00

library cache load lock

3

0.00

0

0

0.00

enq: TQ
-

TM contention

3

0.00

0

0

0.00

enq: RS
-

prevent file delete

2

0.00

0

0

0.00

ksfd: async disk IO

1

0.00

0

1

0.00

enq: JS
-

job run lock
-

synchronize

2

0.00

0

0

0.00

PX qref latch

23

91.30

0

0

0.00

enq: UL
-

contention

2

0.00

0

0

0.00

cursor: pin S

44

0.00

0

0

0.00

lock deadlock retry

32

100.00

0

0

0.00

latch: enqueue hash chains

8

0.00

0

0

0.00

recovery area: computing backed up files

1

0.00

0

0

0.00

enq:

AF
-

task serialization

1

0.00

0

0

0.00

enq: RS
-

read alert level

1

0.00

0

0

0.00

latch: redo allocation

3

0.00

0

0

0.00

recovery area: computing applied logs

1

0.00

0

0

0.00

recovery area: computing dropped files

1

0.00

0

0

0.00

latch: object queue

header operation

5

0.00

0

0

0.00

latch: undo global data

2

0.00

0

0

0.00

lock escalate retry

21

80.95

0

0

0.00

latch: library cache pin

3

0.00

0

0

0.00

latch: session allocation

2

0.00

0

0

0.00

latch: messages

1

0.00

0

0

0.00

latch: cache buffers lr
u chain

2

0.00

0

0

0.00

latch: checkpoint queue latch

1

0.00

0

0

0.00

ges2 LMON to wake up LMD
-

mrcvr

3

0.00

0

0

0.00

SQL*Net message from client

2,297,064

0.00

317,955

138

20.23

gcs remote message

2,446,169

87.59

27,728

11

21.55

PX Idle Wait

8,723

5
4.43

14,355

1646

0.08

Streams AQ: waiting for messages in the queue

2,262

95.00

14,114

6240

0.02

Streams AQ: qmn slave idle wait

281

2.14

7,324

26062

0.00

DIAG idle wait

34,335

0.00

7,067

206

0.30

jobq slave wait

2,414

98.84

7,065

2927

0.02

ASM backgr
ound timer

1,961

0.00

7,062

3601

0.02

Streams AQ: waiting for time management or
cleanup tasks

269

44.61

7,059

26240

0.00

ges remote message

234,330

84.24

7,055

30

2.06

virtual circuit status

241

100.00

7,024

29146

0.00

Streams AQ: qmn coordinator idle

wait

526

49.62

7,002

13312

0.00

class slave wait

400

7.00

6,903

17258

0.00

PX Deq: Execute Reply

10,114

34.71

36

4

0.09

PX Deq: Execution Msg

17,612

0.49

24

1

0.16

PX Deq: Join ACK

11,111

31.28

6

1

0.10

PX Deq: Parse Reply

9,968

25.83

2

0

0.09

KSV m
aster wait

364

0.00

2

5

0.00

PX Deq: Msg Fragment

1,081

3.24

0

0

0.01

Streams AQ: RAC qmn coordinator idle wait

526

100.00

0

0

0.00

Back to Wait Events Statistics


Back to Top

Background Wait Events



ord
ered by wait time desc, waits desc (idle events last)

Event

Waits

%Time
-
outs

Total Wait Time
(s)

Avg wait
(ms)

Waits
/txn

events in waitclass Other

316,380

50.23

451

1

2.79

log file parallel write

217,295

0.00

135

1

1.91

db file parallel write

81,817

0.00

99

1

0.72

log file sequential read

1,796

0.00

35

20

0.02

control file sequential read

17,427

0.00

8

0

0.15

Log archive I/O

4,542

0.00

8

2

0.04

control file parallel write

3,819

0.00

3

1

0.03

os thread startup

10

0.00

1

56

0.00

db file sequential

read

105

0.00

1

5

0.00

gc cr block 2
-
way

1,176

0.00

1

0

0.01

row cache lock

1,311

0.00

0

0

0.01

gc current block 2
-
way

388

0.00

0

0

0.00

direct path read

134

0.00

0

1

0.00

buffer busy waits

420

0.71

0

0

0.00

library cache lock

62

0.00

0

0

0.00

log
file single write

14

0.00

0

1

0.00

direct path write

135

0.00

0

0

0.00

gc current grant 2
-
way

12

0.00

0

0

0.00

latch: cache buffers chains

90

0.00

0

0

0.00

log file sync

4

0.00

0

0

0.00

ksfd: async disk IO

1

0.00

0

1

0.00

enq: HW
-

contention

3

0.00

0

0

0.00

gc cr disk read

1

0.00

0

0

0.00

gc current multi block request

9

0.00

-
0

-
1

0.00

library cache pin

8

0.00

-
0

-
1

0.00

gc current grant busy

71

0.00

-
0

-
1

0.00

rdbms ipc message

553,502

25.45

161,281

291

4.88

gcs remote message

2,446,161

87.59

27,728

11

21.55

smon timer

102

0.00

7,167

70269

0.00

DIAG idle wait

34,334

0.00

7,066

206

0.30

ASM background timer

1,961

0.00

7,062

3601

0.02

pmon timer

2,678

99.85

7,061

2637

0.02

Streams AQ: waiting for time management or
cleanup tasks

269

44.61

7
,059

26240

0.00

ges remote message

234,323

84.24

7,055

30

2.06

Streams AQ: qmn coordinator idle wait

526

49.62

7,002

13312

0.00

class slave wait

390

7.18

6,903

17700

0.00

Streams AQ: qmn slave idle wait

17

0.00

471

27692

0.00

KSV master wait

252

0.00

1

6

0.00

PX Deq: Join ACK

60

40.00

0

1

0.00

PX Deq: Parse Reply

57

36.84

0

0

0.00

PX Deq: Execute Reply

55

34.55

0

0

0.00

Streams AQ: RAC qmn coordinator idle wait

526

100.00

0

0

0.00

Back to Wait Events Statistics


Back to Top

Operating System Statistics

Statistic

Total

AVG_BUSY_TIME

38,317

AVG_IDLE_TIME

685,036

AVG_IOWAIT_TIME

0

AVG_SYS_TIME

13,990

AVG_USER_TIME

24,086

BUSY_TIME

616,603

IDLE_TIME

10,964,262

IOWAIT_TIME

0

SYS_TIME

227,595

US
ER_TIME

389,008

LOAD

0

OS_CPU_WAIT_TIME

5,300

RSRC_MGR_CPU_WAIT_TIME

0

VM_IN_BYTES

323,584

VM_OUT_BYTES

0

PHYSICAL_MEMORY_BYTES

33,813,995,520

NUM_CPUS

16

Back to Wait Events Statistics


Back to Top

Service Statistics



ordered by DB Time

Service Name

DB Time (s)

DB CPU (s)

Physical Reads

Logical Reads

orcl_rac

8,417.80

3,122.70

480,239

287,270,203

orcl

79.90

67.60

12

26,099

SYS$USERS

12.80

10.30

63

1,299,476

SYS$BACKGROUND

0.00

0.00

1,602

653,75
0

orclXDB

0.00

0.00

0

0

Back to Wait Events Statistics


Back to Top

Service Wait Class Stats



Wait Class info for services in the Service Statistics section.



Total Waits and Time Waited displayed for the

following wait classes: User I/O, Concurrency,
Administrative, Network



Time Waited (Wt Time) in centisecond (100th of a second)

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
To
tal Wts

Network
Wt Time

orcl

12

6

1726

41

0

0

15808

2

SYS$USERS

97

41

689

16

0

0

13243

4

SYS$BACKGROUND

1223

258

7000

191

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 Gets



SQL ordered by Reads



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 Li
st of SQL Text

Back to Top

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 in
to the Total Database Time
multiplied by 100

Elapsed
Time (s)

CPU
Time
(s)

Executions

Elap
per
Exec
(s)

%
Total
DB
Time

SQL Id

SQL Module

SQL Text

1,918

92

9,921

0.19

22.53

6y4wha9gqjbkb

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN :1 :=
p_outbox.createOut...

1,717

51

9,921

0.17

20.18

03hcmjsrzk2uj

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO
MESSAGECONTENTS (I...

807

123

76,013

0.01

9.48

4vngfzppsah
ts

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA.xa_prepare...

683

439

11,881

0.06

8.02

apgdwp5n2wdug

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT T1.RN,
T1.SUBMESSAGEID...

670

426

11,881

0.06

7.87

6ubadds0qp649

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT * FROM ( ...

485

43

9,393

0.05

5.70

cz0d2rv3hsxa2

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO
JMS_MESSAGES (MESS...

434

297

9,982

0.04

5.09

gvt7aq1y5uvp4

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ALL_RESULTS.ID,
ALL_RE...

396

81

11,130

0.04

4.66

1dtdmbwrskwxk

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_outbox.sendOutboxMessa
...

374

23

15,367

0.02

4.39

fqsda57xpqq15

java@jbosscluster2
-
s (TNS V1
-
V3)

DELETE FROM
JMS_MESSAGES WHERE...

321

138

15,983

0.02

3.77

0bgsvc3fy531p

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT COUNT(*) FROM
MAILBOXIT...

265

28

15,368

0.02

3.11

6yu9g4s41wmpp

java@jbosscluster2
-
s (TNS V1
-
V3)

DELETE FROM
JMS_TRANSACTIONS W...

260

61

9,921

0.03

3.05

dgc3kfn6agh0z

java
@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_mailboxitem.manageMail...

247

53

4,102

0.06

2.90

6h0sav4txmn3a

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ID, NAME,
OWNERID, O...

221

170

11,881

0.02

2.60

gmc1a22nkcump

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ID, NAME,
OWNERID, O...

200

71

11,130

0.02

2.34

492ahypg2kn82

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_recipient.updateRecipi...

192

190

217,243

0.00

2.2
6

b6qv8f7zwqz0d

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA.xa_commit_...

189

164

9,921

0.02

2.22

9ztc2usu3fmj5

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT P.ID ID,
P.SYSTEMID
SY...

169

169

229,877

0.00

1.99

779s4601t4v6f

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA.xa_end_new...

144

22

9,921

0.01

1.69

7kqrapr7256ud

java@jbosscluster2
-
s (TNS V1
-
V3
)

INSERT INTO MAILBOXITEM
(MAILB...

127

30

22,658

0.01

1.49

9pwyz2pm98vxx

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_retention.updateMessag...

123

27

22,658

0.01

1.45

0fvy4tf0x9tm0

j
ava@jbosscluster2
-
s (TNS V1
-
V3)

UPDATE
SUBMESSAGERETENTION
SET...

123

122

229,876

0.00

1.44

bnk1g42zxuk5u

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA.xa_start_n...

113

98

11,881

0.01

1.33

4fmn6aaz2ds06

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT COUNT(*) FROM
MAILBOXIT...

93

16

9,921

0.01

1.09

d0mzzx77304yz

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO SUBMESSAGE
(ID, S...

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 DB Time is the Elapsed Time of the SQL statemen
t divided into the Total Database Time
multiplied by 100

CPU
Time
(s)

Elapsed
Time (s)

Executions

CPU
per
Exec
(s)

%
Total
DB
Time

SQL Id

SQL Module

SQL Text

439

683

11,881

0.04

8.02

apgdwp5n2wdug

java@jbosscluster2
-
s

(TNS V1
-
V3)

SELECT T1.RN,
T1.SUBMESSAGEID...

426

670

11,881

0.04

7.87

6ubadds0qp649

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT * FROM ( ...

297

434

9,982

0.03

5.09

gvt7aq1y5uvp4

java
@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ALL_RESULTS.ID,
ALL_RE...

190

192

217,243

0.00

2.26

b6qv8f7zwqz0d

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA.xa_commit_...

170

221

11,881

0.01

2.60

gmc1a22nkcump

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ID, NAME,
OWNERID, O...

169

169

229,877

0.00

1.99

779s4601t4v6f

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA.xa_end_new...

164

189

9,921

0.0
2

2.22

9ztc2usu3fmj5

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT P.ID ID,
P.SYSTEMID SY...

138

321

15,983

0.01

3.77

0bgsvc3fy531p

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT COUNT(*) FROM
M
AILBOXIT...

123

807

76,013

0.00

9.48

4vngfzppsahts

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA.xa_prepare...

122

123

229,876

0.00

1.44

bnk1g42zxuk5u

java@jbosscluster2
-
s (T
NS V1
-
V3)

begin :1 :=
JAVA_XA.xa_start_n...

98

113

11,881

0.01

1.33

4fmn6aaz2ds06

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT COUNT(*) FROM
MAILBOXIT...

92

1,918

9,921

0.01

22.53

6y4wha
9gqjbkb

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN :1 :=
p_outbox.createOut...

81

396

11,130

0.01

4.66

1dtdmbwrskwxk

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_outbox.sendOutboxMessa...

71

200

11,130

0.01

2.34

492ahypg2kn82

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_recipient.updateRecipi...

61

260

9,921

0.01

3.05

dgc3kfn6agh0z

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_mailboxitem.manageMail...

53

247

4,102

0.01

2.90

6h0sav4txmn3a

java@jbosscluster2
-
SELECT ID, NAME,
s (TNS V1
-
V3)

OWNERID, O...

51

1,717

9,921

0.01

20.18

03hcmjsrzk2uj

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO
M
ESSAGECONTENTS (I...

43

485

9,393

0.00

5.70

cz0d2rv3hsxa2

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO
JMS_MESSAGES (MESS...

30

127

22,658

0.00

1.49

9pwyz2pm98vxx

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_retention.updateMessag...

28

265

15,368

0.00

3.11

6yu9g4s41wmpp

java@jbosscluster2
-
s (TNS V1
-
V3)

DELETE FROM
JMS_TRANSACTIONS W...

27

123

22,658

0.00

1.45

0fv
y4tf0x9tm0

java@jbosscluster2
-
s (TNS V1
-
V3)

UPDATE
SUBMESSAGERETENTION
SET...

23

374

15,367

0.00

4.39

fqsda57xpqq15

java@jbosscluster2
-
s (TNS V1
-
V3)

DELETE FROM
JMS_MESSAGES WHERE...

22

144

9,921

0.00

1.69

7kqrapr7256ud

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO MAILBOXITEM
(MAILB...

16

93

9,921

0.00

1.09

d0mzzx77304yz

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO SUBMESSAGE
(ID, S...

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: 289,248,606



Captured SQL acco
unt for 130.1% of Total

Buffer
Gets

Executions

Gets per
Exec

%Total

CPU
Time
(s)

Elapsed
Time (s)

SQL Id

SQL Module

SQL Text

111,457,188

11,881

9,381.13

38.53

438.97

682.59

apgdwp5n2wdug

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT T1.RN,
T1.SUBMESSAGEID...

111,445,901

11,881

9,380.18

38.53

425.60

669.59

6ubadds0qp649

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT * FROM ( ...

48,596,646

9,982

4,868.43

16.80

297.18

433.60

gvt7aq1y5uvp4

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT
ALL_RESULTS.ID,
ALL_RE...

37,053,604

11,881

3,118.73

12.81

170.43

221.14

gmc1a22nkcump

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ID, NAME,
OWNERID
, O...

24,821,725

15,983

1,553.01

8.58

138.35

320.72

0bgsvc3fy531p

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT COUNT(*)
FROM MAILBOXIT...

18,473,665

11,881

1,554.89

6.39

97.63

113.43

4fm
n6aaz2ds06

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT COUNT(*)
FROM MAILBOXIT...

16,696,227

3

5,565,409.00

5.77

56.16

56.16

9ddz2mw10nt8r

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN :1 :=
p_group.insertExte...

6,676,811

4,1
02

1,627.70

2.31

52.66

247.03

6h0sav4txmn3a

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ID, NAME,
OWNERID, O...

5,265,270

9,393

560.55

1.82

43.46

484.69

cz0d2rv3hsxa2

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO
JMS_MESSAGES
(MESS...

3,011,890

752,997

4.00

1.04

56.73

56.73

4z6jfdhm5uxr7

java@jbosscluster2
-
s (TNS V1
-
V3)

select longname from
javasnm$ ...

Back to SQL Statistics


Back to Top

SQL ordered by Reads



Total Disk Reads: 481,696



Captured SQL account for 76.2% of Total

Physical
Reads

Executions

Reads
per
Exec

%Total

CPU
Time
(s)

Elapsed
Time (s)

SQL Id

SQL Module

SQL Text

93,510

9,921

9.43

19
.41

91.52

1917.69

6y4wha9gqjbkb

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN :1 := p_outbox.createOut...

91,708

9,921

9.24

19.04

51.48

1717.37

03hcmjsrzk2uj

java@jbosscluster2
-
s (TNS V1
-
V3
)

INSERT INTO
MESSAGECONTENTS (I...

45,552

11,881

3.83

9.46

425.60

669.59

6ubadds0qp649

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT * FROM ( ...

45,552

11,881

3.83

9.46

438.97

682.59

ap
gdwp5n2wdug

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT T1.RN,
T1.SUBMESSAGEID...

37,310

4,102

9.10

7.75

52.66

247.03

6h0sav4txmn3a

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ID, NAME, OWNERID,
O...

36,041

15,983

2.25

7.48

138.35

320.72

0bgsvc3fy531p

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT COUNT(*) FROM
MAILBOXIT...

20,976

9,393

2.23

4.35

43.46

484.69

cz0d2rv3hsxa2

java@jbosscluster2
-
s (TNS V1
-
V3)

IN
SERT INTO JMS_MESSAGES
(MESS...

16,067

11,130

1.44

3.34

70.75

199.52

492ahypg2kn82

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN p_recipient.updateRecipi...

13,467

40,254

0.33

2.80

62.15

73.49

d6xwurybd1sc1

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN :1 := p_audit.addAuditEn...

13,331

304

43.85

2.77

14.47

44.19

1cbrtxcgj2pty

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_compliance_details.cre...

13,309

230,243

0.06

2.76

15.03

40.91

fmw713zqmuzzz

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO
COMPLIANCE_DETAILS...

12,450

11,130

1.12

2.58

81.08

396.41

1dtdmbwrskwxk

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_outbox.sendOutboxMessa...

9,854

9,982

0.99

2.05

297.18

433.60

gvt7aq1y5uvp4

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ALL_RESULTS.ID,
ALL_RE...

9,283

9,921

0.94

1.93

60.67

259.97

dgc3kfn6agh0z

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_mailboxitem.manageMail...

9,071

11,130

0.82

1.88

21.40

78.82

9bab7znufyxyv

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO MAILBOXITEM (
MAIL...

8,928

22,
658

0.39

1.85

26.57

123.37

0fvy4tf0x9tm0

java@jbosscluster2
-
s (TNS V1
-
V3)

UPDATE
SUBMESSAGERETENTION
SET...

8,928

22,658

0.39

1.85

30.27

127.09

9pwyz2pm98vxx

java@jbosscluster2
-
s (TN
S V1
-
V3)

BEGIN
p_retention.updateMessag...

8,185

22,083

0.37

1.70

20.31

25.78

4m7m0t6fjcs5x




update seq$ set increment$=:2,...

7,946

21,051

0.38

1.65

42.87

58.53

fnpgu5z2728vu

jav
a@jbosscluster2
-
s (TNS V1
-
V3)

SELECT
TO_CHAR(SEQ_MAILBOXITEM...

5,572

9,921

0.56

1.16

21.76

143.64

7kqrapr7256ud

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO MAILBOXITEM
(MAILB...

5,388

10,771

0.50

1.12

12.16

15.75

dsuu77m1r3jbb

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO AUDITENTRY ( ID,
...

5,214

11,130

0.47

1.08

34.29

54.70

253h456mgf3zr

java@jbosscluster2
-
s (TNS V1
-
V3)

UPDATE MAILBOXITEM S
ET
MAILTYP...

Back to SQL Statistics


Back to Top

SQL ordered by Executions



Total Executions: 3,831,071



Captured SQL account for 75.0% of Total

Executions

Rows
Processed

Rows
per
Exec

CPU
per
Exec
(s)

Elap
per
Exec
(s)

SQL Id

SQL Module

SQL Text

752,997

752,977

1.00

0.00

0.00

4z6jfdhm5uxr7

java@jbosscluster2
-
s (TNS V1
-
V3)

select longname from
javasnm$ ...

230,243

230,237

1.00

0.00

0.00

fmw713zqmuzzz

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO
COMPLIANCE_DETAILS...

229,930

229,925

1.00

0.00

0.00

avc1jqzz04wpr

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT 'x' FROM DUAL

229,877

229,875

1.00

0.00

0.
00

779s4601t4v6f

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA.xa_end_new...

229,876

229,875

1.00

0.00

0.00

bnk1g42zxuk5u

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA
.xa_start_n...

217,243

217,242

1.00

0.00

0.00

b6qv8f7zwqz0d

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA.xa_commit_...

76,013

76,013

1.00

0.00

0.01

4vngfzppsahts

java@jbossc
luster2
-
s (TNS V1
-
V3)

begin :1 :=
JAVA_XA.xa_prepare...

66,767

66,766

1.00

0.00

0.00

0hsyjkg4q7z0g

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_session.getActiveSessi...

40,254

40,253

1.00

0.00

0.00

d6xwurybd1sc1

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN :1 :=
p_audit.addAuditEn...

31,538

31,538

1.00

0.00

0.00

8v5v5xxgd200m

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN :1 :=
p_retention.findMe...

Back to SQL Statistics


Back to Top

SQL ordered by Parse Calls



Total Parse Calls: 2,154,390



Captured SQL account for 81.3% of Total

Parse
Calls

Executions

% Total
Parses

SQL Id

SQL Module

SQL Text

229,930

229,93
0

10.67

avc1jqzz04wpr

java@jbosscluster2
-
s
(TNS V1
-
V3)

SELECT 'x' FROM DUAL

229,878

229,877

10.67

779s4601t4v6f

java@jbosscluster2
-
s
(TNS V1
-
V3)

begin :1 := JAVA_XA.xa_end_new...

2
29,877

229,876

10.67

bnk1g42zxuk5u

java@jbosscluster2
-
s
(TNS V1
-
V3)

begin :1 := JAVA_XA.xa_start_n...

217,244

217,243

10.08

b6qv8f7zwqz0d

java@jbosscluster2
-
s
(TNS V1
-
V3)

begin :1 :
= JAVA_XA.xa_commit_...

76,013

76,013

3.53

4vngfzppsahts

java@jbosscluster2
-
s
(TNS V1
-
V3)

begin :1 := JAVA_XA.xa_prepare...

66,768

66,767

3.10

0hsyjkg4q7z0g

java@jbosscluster2
-
s
BEGIN p_session.getActiveSessi...

(TN
S V1
-
V3)

40,254

40,254

1.87

d6xwurybd1sc1

java@jbosscluster2
-
s
(TNS V1
-
V3)

BEGIN :1 := p_audit.addAuditEn...

31,538

31,538

1.46

8v5v5xxgd200m

java
@jbosscluster2
-
s
(TNS V1
-
V3)

BEGIN :1 := p_retention.findMe...

31,538

31,538

1.46

9utsq4swwsmzd

java@jbosscluster2
-
s
(TNS V1
-
V3)

SELECT SMRP.SUBMESSAGEID,
SMR...

28,950

28,950

1.34

5kc5gfurhz6pk

java@jbosscluster1
-
s
(TNS V1
-
V3)

BEGIN :1 := p_attachment.findA...

28,950

28,950

1.34

8k7w26ugdmpzy

java@jbosscluster1
-
s
(TNS V1
-
V3)

SELECT T1.ID, T1.SYSTEMID, T...

27,534

27,534

1.28

5rma8x1a77afm

java@jbosscluster1
-
s
(TNS V1
-
V3)

BEGIN :1 := p_submessage.findB...

27,534

27,534

1.28

62y1vw61ysj1k

java@jbosscluster1
-
s
(TNS V1
-
V3)

BEGIN :1 := p_submessage.findB...

27,534

27,534

1.
28

butrzvwc2ckcc

java@jbosscluster1
-
s
(TNS V1
-
V3)

SELECT SUBMESSAGE.CS AS
CHECKS...

27,533

27,532

1.28

1zbussrsbs640

java@jbosscluster1
-
s
(TNS V1
-
V3)

SELECT RECIPIENT.ID, RECIPIEN..
.

27,533

27,533

1.28

6cjxa2k19akg5

java@jbosscluster1
-
s
(TNS V1
-
V3)

SELECT SUBMESSAGE.ID,
SUBMESS...

27,533

27,533

1.28

d8ghvzjd9r6v2

java@jbosscluster1
-
s
(TNS V1
-
V3)

BEGIN :1 := p
_submessage.findH...

27,533

27,532

1.28

fb9bdkw7ku1ws

java@jbosscluster1
-
s
(TNS V1
-
V3)

SELECT
SUBMESSAGEHISTORY.SUBME...

27,533

27,533

1.28

gb7fysp9b0pxh

java@jbosscluster1
-
s
(TNS V
1
-
V3)

BEGIN :1 := p_submessage.findS...

22,658

22,658

1.05

9pwyz2pm98vxx

java@jbosscluster2
-
s
(TNS V1
-
V3)

BEGIN p_retention.updateMessag...

22,083

22,083

1.03

4m7m0t6fjcs5x




upda
te seq$ set increment$=:2,...

Back to SQL Statistics


Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

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

Cluster
Wait
Time
(s)

CWT
% of
Elapsd
Time

Elapsed
Time(s)

CPU
Time(s)

Executions

SQL Id

SQL Module

SQL Text

575.59

30.01

1,917.69

91.52

9,921

6y4wha9gqjbkb

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN :1 := p_outbox.createOut...

428.75

24.97

1,717.37

51
.48

9,921

03hcmjsrzk2uj

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO
MESSAGECONTENTS (I...

294.75

74.35

396.41

81.08

11,130

1dtdmbwrskwxk

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_ou
tbox.sendOutboxMessa...

252.24

95.16

265.08

28.16

15,368

6yu9g4s41wmpp

java@jbosscluster2
-
s (TNS V1
-
V3)

DELETE FROM
JMS_TRANSACTIONS W...

182.77

37.71

484.69

43.46

9,393

cz0d2rv3hsxa
2

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO JMS_MESSAGES
(MESS...

180.13

69.29

259.97

60.67

9,921

dgc3kfn6agh0z

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_mailboxitem.manageMail...

119.89

32.07

373.82

23.13

15,367

fqsda57xpqq15

java@jbosscluster2
-
s (TNS V1
-
V3)

DELETE FROM JMS_MESSAGES
WHERE...

113.84

79.25

143.64

21.76

9,921

7kqrapr7256ud

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO MAILBOXIT
EM
(MAILB...

96.23

48.23

199.52

70.75

11,130

492ahypg2kn82

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN p_recipient.updateRecipi...

70.96

76.68

92.54

15.83

9,921

d0mzzx77304yz

java@jbossc
luster2
-
s (TNS V1
-
V3)

INSERT INTO SUBMESSAGE (ID,
S...

56.64

89.25

63.46

18.38

7,737

dsj2pmxg64rcu

java@jbosscluster2
-
s (TNS V1
-
V3)

DELETE FROM
SUBMESSAGEHISTORY ...

56.27

12.98

433.60

297.18

9,982

gvt7aq1y5uvp4

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ALL_RESULTS.ID,
ALL_RE...

55.40

68.42

80.97

23.01

9,454

dmvgk7gcc8m1t

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO RECIPIENT SELECT
:...

52.22

8
5.06

61.40

14.67

9,454

46pstmjc93fxq

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO
ATTACHMENTTIMESTAM...

50.20

15.65

320.72

138.35

15,983

0bgsvc3fy531p

java@jbosscluster2
-
s (TNS V1
-
V3
)

SELECT COUNT(*) FROM
MAILBOXIT...

45.17

83.63

54.01

20.80

9,454

gwca9akskcaq9

java@jbosscluster2
-
s (TNS V1
-
V3)

DELETE FROM
DRAFTRECIPIENTS WH...

44.77

56.80

78.82

21.40

11,130

9ba
b7znufyxyv

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO MAILBOXITEM (
MAIL...

44.72

18.10

247.03

52.66

4,102

6h0sav4txmn3a

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ID, NAME, OWNERID,
O...

40.11

32.51

123.37

26.57

22,
658

0fvy4tf0x9tm0

java@jbosscluster2
-
s (TNS V1
-
V3)

UPDATE
SUBMESSAGERETENTION SET...

40.11

31.56

127.09

30.27

22,658

9pwyz2pm98vxx

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN p_retention
.updateMessag...

38.99

17.63

221.14

170.43

11,881

gmc1a22nkcump

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT ID, NAME, OWNERID,
O...

32.78

4.80

682.59

438.97

11,881

apgdwp5n2wdug

java@jb
osscluster2
-
s (TNS V1
-
V3)

SELECT T1.RN,
T1.SUBMESSAGEID...

32.77

4.89

669.59

425.60

11,881

6ubadds0qp649

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT * FROM ( ...

30.65

56.03

54.70

34.29

11,130

253h456mgf3zr

java@jbosscluster2
-
s (TNS V1
-
V3)

UPDATE MAILBOXITEM SET
MAILTYP...

27.01

64.47

41.90

20.49

19,661

68mpuua893h37

java@jbosscluster1
-
s (TNS V1
-
V3)

BEGIN :1 := p_rts.markAsRead(:...

22.05

65.67

33
.57

20.91

9,494

0absnp4fwmc71

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN
p_outbox.getOutboxMessag...

22.05

82.04

26.87

14.40

9,494

8cfhrd3xgfqsn

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT
SUBMESSAGEHISTORY.SUBME...

21.75

19.17

113.43

97.63

11,881

4fmn6aaz2ds06

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT COUNT(*) FROM
MAILBOXIT...

14.65

46.97

31.20

20.73

27,533

6cjxa2k19ak
g5

java@jbosscluster1
-
s (TNS V1
-
V3)

SELECT SUBMESSAGE.ID,
SUBMESS...

12.55

60.73

20.67

16.62

27,534

butrzvwc2ckcc

java@jbosscluster1
-
s (TNS V1
-
V3)

SELECT SUBMESSAGE.CS AS
CHECKS...

12.38

69.71

17.75

13.32

27,532

fb9bdkw7ku1ws

java@jbosscluster1
-
s (TNS V1
-
V3)

SELECT
SUBMESSAGEHISTORY.SUBME...

12.25

27.73

44.19

14.47

304

1cbrtxcgj2pty

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN p_compliance_details.c
re...

12.25

29.95

40.91

15.03

230,243

fmw713zqmuzzz

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO
COMPLIANCE_DETAILS...

9.71

32.77

29.64

22.11

66,767

0hsyjkg4q7z0g

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN p_session.getActiveSessi...

9.40

64.77

14.51

6.06

28,950

8k7w26ugdmpzy

java@jbosscluster1
-
s (TNS V1
-
V3)

SELECT T1.ID, T1.SYSTEMID, T...

7.31

12.49

58.53

42.87

21,051

fnpgu5z2728vu

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT
TO_CHAR(SEQ_MAILBOXITEM...

6.47

42.02

15.40

15.13

31,538

9utsq4swwsmzd

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT SMRP.SUBMESSAGEID,
SMR...

5.77

3.05

189.24

1
64.31

9,921

9ztc2usu3fmj5

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT P.ID ID, P.SYSTEMID
SY...

3.78

14.65

25.78

20.31

22,083

4m7m0t6fjcs5x




update seq$ set increment$=:2,...

3.17

48.
88

6.48

6.31

7,103

ch6ygprzxubjr

java@jbosscluster1
-
s (TNS V1
-
V3)

UPDATE MAILBOXITEM SET
LASTMOD...

2.88

30.75

9.36

7.66

27,532

1zbussrsbs640

java@jbosscluster1
-
s (TNS V1
-
V3)

SELECT

RECIPIENT.ID,
RECIPIEN...

0.65

66.53

0.98

0.98

1,620

axmdf8vq7k1rh




select increment$, minvalue, m...

0.61

0.83

73.49

62.15

40,254

d6xwurybd1sc1

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN :1 := p_audit.addAuditEn...

0.22

0.18

122.71

122.14

229,876

bnk1g42zxuk5u

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 := JAVA_XA.xa_start_n...

0.15

0.08

191.99

189.83

217,243

b6q
v8f7zwqz0d

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 := JAVA_XA.xa_commit_...

0.09

0.59

15.75

12.16

10,771

dsuu77m1r3jbb

java@jbosscluster2
-
s (TNS V1
-
V3)

INSERT INTO AUDITENTRY ( ID,
...

0.06

0.01

806.71

123.48

76,0
13

4vngfzppsahts

java@jbosscluster2
-
s (TNS V1
-
V3)

begin :1 := JAVA_XA.xa_prepare...

0.04

26.40

0.15

0.15

83

1dubbbfqnqvh9




SELECT
ORA_TQ_BASE$.NEXTVAL FR...

0.02

5.68

0.43

0.43

54
9

8zkxzv3y7h8jt

java@jbosscluster2
-
s (TNS V1
-
V3)

SELECT POPUL.ID,
POPUL.SYSTEM...

0.02

9.59

0.23

0.16

1,379

db78fxqxwxt7r




select /*+ rule */ bucket, en...

0.02

2.41

0.92

0.90

0

1gc7umngbqyc1




SELECT /*+ ORDERED */
A.READY ...

0.02

8.17

0.22

0.13

860

cqgv56fmuj63x




select owner#, name, namespace...

0.01

10.31

0.12

0.08

124

39m4sx9k63ba2




select /*+ index(idl_ub2$ i_id...

0.01

0.71

1.56

1.54

4,208

bjzvd7sragcaj

java@jbosscluster2
-
s (TNS V1
-
V3)

BEGIN :1 := p_mailbox_contents...

0.01

10.16

0.07

0.07

124

ga9j9xk5cy9s0




select /*+ index(idl_sb4$ i_id...

0.01

0.10

6.67

6.66

28,950

5kc5gfurhz6pk

java@jbosscluster1
-
s (TNS V1
-
V3)

BEGIN :1 := p_attachment.findA...

0.01

6.69

0.08

0.08

657

8swypbbr0m372




select order#, columns, types ...

Back to SQL Statistics


Back to Top

Complete List of SQL Text

SQL Id

SQL Text

03hcmjsrzk2uj

INSERT INTO MESSAGECONTENTS (ID, SYSTEMID, CREATIONT
IMESTAMP, BODY, PLAINBODY,
FORMATTYPE, TEMPLATEID, CUSTOMDATA) VALUES (:B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

0absnp4fwmc71

BEGIN p_outbox.getOutboxMessageHeader(:1, :2, :3, :4, :5, :6); END;

0bgsvc3fy531p

SELECT COUNT(*) FROM MAILBOXITEM WHERE
OWNERID = :B3 AND OWNERSYSTEMID = :B2
AND MAILBOXID = :B1 AND MAILTYPE='RECVD' AND TRASHEDTIMESTAMP IS NULL AND
READDATE IS NULL

0fvy4tf0x9tm0

UPDATE SUBMESSAGERETENTION SET LASTACCESSTIMESTAMP = :B5 ,
REPLYFORWARDTIMESTAMP = :B4 , EXPIRATIONTIMESTAMP = :
B3 WHERE SUBMESSAGEID =
:B2 AND SUBMESSAGESYSTEMID = :B1

0hsyjkg4q7z0g

BEGIN p_session.getActiveSessionId(:1, :2, :3, :4, :5); END;

1cbrtxcgj2pty

BEGIN p_compliance_details.createAddressBook_array(:1, :2, :3, :4); END;

1dtdmbwrskwxk

BEGIN p_outbox.send
OutboxMessage(:1, :2, :3, :4, :5, :6, :7); END;

1dubbbfqnqvh9

SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL

1gc7umngbqyc1

SELECT /*+ ORDERED */ A.READY FROM USER_QUEUES B, GV$AQ A WHERE B.NAME =
'MGMT_NOTIFY_Q' AND A.QID = B.QID

1zbussrsbs640

SELECT RECIPIENT.I
D, RECIPIENT.SYSTEMID, RECIPIENT.SEQUENCENR, RECIPIENT.TYPE,
RECIPIENT.LISTTYPE, POPULATION.DISPLAYNAME1, POPULATION.SMTPADDRESS FROM
RECIPIENT , POPULATION WHERE RECIPIENT.SUBMESSAGEID = :B2 AND
RECIPIENT.SUBMESSAGESYSTEMID = :B1 AND RECIPIENT.ID = POPULA
TION.ID AND
RECIPIENT.SYSTEMID = POPULATION.SYSTEMID

253h456mgf3zr

UPDATE MAILBOXITEM SET MAILTYPE = 'SENT', MAILBOXID = :B5 , LASTMODIFIEDTIMESTAMP =
:B4 , READDATE = :B4 , LASTREADDATE = :B4 WHERE MAILBOXID = :B3 AND
SUBMESSAGEID=:B2 AND SUBMESSAGESYSTE
MID=:B1

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#

46pstmjc93fxq

INSERT INTO ATTACHMENTTIMESTAMPS (ATTACHMENTID, ATTACHMENTSYSTEMID, ID,
SYSTEMID,
DELIVERYDATE) SELECT DISTINCT CONTAINEE, CONTAINEESYSTEMID, :B5 , :B4 ,
:B3 FROM ATTACHMENTCONTAINMENT, SUBMESSAGE WHERE SUBMESSAGE.ID = :B2 AND
SUBMESSAGE.SYSTEMID = :B1 AND SUBMESSAGE.MESSAGEID =
ATTACHMENTCONTAINMENT.CONTAINER AND SUBMESSAGE.MESSAGESYST
EMID =
ATTACHMENTCONTAINMENT.CONTAINERSYSTEMID AND NOT EXISTS (SELECT 1 FROM
ATTACHMENTTIMESTAMPS WHERE ATTACHMENTTIMESTAMPS.ATTACHMENTID =
ATTACHMENTCONTAINMENT.CONTAINEE AND
ATTACHMENTTIMESTAMPS.ATTACHMENTSYSTEMID =
ATTACHMENTCONTAINMENT.CONTAINEESYSTEMI
D AND ATTACHMENTTIMESTAMPS.ID = :B5
AND ATTACHMENTTIMESTAMPS.SYSTEMID = :B4 )

492ahypg2kn82

BEGIN p_recipient.updateRecipientsInboxes(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); END;

4fmn6aaz2ds06

SELECT COUNT(*) FROM MAILBOXITEM MBI WHERE MBI.OWNERID
=:B3 AND
MBI.OWNERSYSTEMID=:B2 AND MBI.MAILBOXID=:B1 AND MBI.MAILTYPE IN ('SENT', 'RECVD')
AND MBI.TRASHEDTIMESTAMP IS NULL

4m7m0t6fjcs5x

update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7,
highwater=:8, audit$=:9, fla
gs=:10 where obj#=:1

4vngfzppsahts

begin :1 := JAVA_XA.xa_prepare_new (:2, :3, :4); end;

4z6jfdhm5uxr7

select longname from javasnm$ where short = :1

5kc5gfurhz6pk

BEGIN :1 := p_attachment.findAttachmentsBySubMessage(:2, :3) ; END;

5rma8x1a77afm

BEGIN
:1 := p_submessage.findByPrimaryKeyAndOwner(:2, :3, :4, :5) ; END;

62y1vw61ysj1k

BEGIN :1 := p_submessage.findByPrimaryKeyMailboxItem(:2, :3, :4) ; END;

68mpuua893h37

BEGIN :1 := p_rts.markAsRead(:2, :3, :4, :5, :6); END;

6cjxa2k19akg5

SELECT SUBMESSAGE
.ID, SUBMESSAGE.SYSTEMID, SUBMESSAGE.TYPE,
SUBMESSAGE.CREATIONTIMESTAMP, SUBMESSAGE.CREATIONTYPE, SUBMESSAGE.CS AS
CHECKSUM, SUBMESSAGE.CST AS CHECKSUMTYPE, SUBMESSAGE.PV AS
PERMISSIONVECTOR, SUBMESSAGE.PRIORITY, SUBMESSAGE.SENSITIVITY,
SUBMESSAGE.LASTACCE
SSTIMESTAMP, SUBMESSAGE.SIGNATUREID,
SUBMESSAGE.STATUS, SUBMESSAGE.SENDERID, SUBMESSAGE.SENDERSYSTEMID,
POPULATION.DISPLAYNAME1, POPULATION.SMTPADDRESS, POPULATION.TYPE AS
SENDERTYPE, SUBMESSAGE.SUBJECT, MESSAGECONTENTS.BODY,
MESSAGECONTENTS.PLAINBODY, MES
SAGECONTENTS.FORMATTYPE AS FORMATTYPE,
MESSAGECONTENTS.TEMPLATEID, MESSAGECONTENTS.CUSTOMDATA FROM SUBMESSAGE ,
MESSAGECONTENTS, POPULATION, MAILBOXITEM WHERE SUBMESSAGE.ID = :B4 AND
SUBMESSAGE.SYSTEMID = :B3 AND SUBMESSAGE.MESSAGEID=MESSAGECONTENTS.ID AND

SUBMESSAGE.MESSAGESYSTEMID=MESSAGECONTENTS.SYSTEMID AND POPULATION.ID =
SUBMESSAGE.SENDERID AND POPULATION.SYSTEMID = SUBMESSAGE.SENDERSYSTEMID
AND SUBMESSAGE.ID = MAILBOXITEM.SUBMESSAGEID AND SUBMESSAGE.SYSTEMID =
MAILBOXITEM.SUBMESSAGESYSTEMID AND MAILB
OXITEM.OWNERID = :B2 AND
MAILBOXITEM.OWNERSYSTEMID = :B1

6h0sav4txmn3a

SELECT ID, NAME, OWNERID, OWNERSYSTEMID, MBTYPE, ITEMSTYPE, MBPARENT,
-
1,
P_MAILBOX.GETUNREADITEMSCOUNT(ID, :B2 , :B1 ), DESCRIPTION FROM MAILBOX WHERE
MAILBOX.OWNERID = :B2 AND MAILB
OX.OWNERSYSTEMID = :B1

6ubadds0qp649

SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY mailboxitem.deliverydate DESC,
deliverydate DESC, mailboxitem.submessageid DESC) AS rn, mailboxitem.submessageid,
mailboxitem.submessagesystemid, submessage.type, mai
lboxitem.readdate, mailboxitem.forwarddate,
mailboxitem.replydate, mailboxitem.flag, submessage.priority, submessage.sensitivity,
mailboxitem.containsattachments, population.displayname1, population.smtpaddress,
submessage.subject, mailboxitem.deliverydate
, submessage.pv, submessage.hasCustomData as
hasCustomData FROM mailboxitem , submessage, population WHERE mailboxitem.ownerid =
:v_population_id AND mailboxitem.ownersystemid = :v_population_system_id AND
mailboxitem.mailboxid = :v_mailbox_id AND mailboxi
tem.mailtype='RECVD' AND
mailboxitem.trashedtimestamp is null AND mailboxitem.deletedtimestamp is null AND submessage.id =
mailboxitem.submessageid AND submessage.systemid = mailbox item.submessagesystemid AND
submessage.senderid = population.id AND submes
sage.sendersystemid = population.systemid )
WHERE rn > :v_from AND rn <= :v_to

6y4wha9gqjbkb

BEGIN :1 := p_outbox.createOutboxMail(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17,
:18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :2
8); END;

6yu9g4s41wmpp

DELETE FROM JMS_TRANSACTIONS WHERE TXID = :1

779s4601t4v6f

begin :1 := JAVA_XA.xa_end_new(:2, :3, :4, :5); end;

7kqrapr7256ud

INSERT INTO MAILBOXITEM (MAILBOXITEMID, MAILBOXID, SUBMESSAGEID,
SUBMESSAGESYSTEMID, OWNERID, OWNERSYSTE
MID, MAILTYPE, TRASHEDTIMESTAMP,
HISTORYID, LASTMODIFIEDTIMESTAMP) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 ,
:B1 )

8cfhrd3xgfqsn

SELECT SUBMESSAGEHISTORY.SUBMESSAGEID,
SUBMESSAGEHISTORY.SUBMESSAGESYSTEMID FROM SUBMESSAGEHISTORY, MAILB
OXITEM
WHERE MAILBOXITEM.MAILBOXID = :B5 AND MAILBOXITEM.SUBMESSAGEID = :B4 AND
MAILBOXITEM.SUBMESSAGESYSTEMID = :B3 AND MAILBOXITEM.OWNERID = :B2 AND
MAILBOXITEM.OWNERSYSTEMID = :B1 AND MAILBOXITEM.HISTORYID =
SUBMESSAGEHISTORY.HISTORYID AND SUBMESSAGEHIS
TORY.CHECKED = 1

8k7w26ugdmpzy

SELECT T1.ID, T1.SYSTEMID, T1.ENCRYPTED, T1.FILESIZE, T1.INDEXSTATUS, T1.HASHDEPTH,
T1.CS, T1.CST, T1.ORIGINALFILENAME, T1.FILEEXTENSION FROM ATTACHMENT T1,
ATTACHMENTCONTAINMENT T2, SUBMESSAGE T3 WHERE T1.ID = T2.CONTAINEE

AND
T1.SYSTEMID = T2.CONTAINEESYSTEMID AND T2.CONTAINER = T3.MESSAGEID AND
T2.CONTAINERSYSTEMID = T3.MESSAGESYSTEMID AND T3.ID = :B2 AND T3.SYSTEMID = :B1

8swypbbr0m372

select order#, columns, types from access$ where d_obj#=:1

8v5v5xxgd200m

BEGIN :1 :
= p_retention.findMessageRetention(:2, :3) ; END;

8zkxzv3y7h8jt

SELECT POPUL.ID, POPUL.SYSTEMID, POPUL.TYPE, POPUL.STATUS, POPUL.DISPLAYNAME1,
POPUL.DISPLAYNAME2, POPUL.DOMAINID, POPUL.DOMAINSYSTEMID, '0' AS ADMINISTRABLE,
POPUL.COMPLIANCESTATUS, POPUL.ST
ARTDATE, POPUL.STARTTIME, POPUL.ENDDATE,
POPUL.ENDTIME, PERS.LOGONNAME, PERS.FIRSTNAME, PERS.LASTNAME, PERS.PASSWORD,
PERS.ROLEID, PERS.ROLESYSTEMID, PERS.ROLEBITS, ROLE.PERMISSIONBITS,
ROLE.PERMISSIONSIZE, 0 AS DUMMYLOGGEDON, PERS.FAILEDLOGONS, PERS.TOKEN
,
PERS.TOKENEXPIREDATE, PERS.AUTOLOGONALLOWED, POPUL.SMTPADDRESS,
PERS.EMAILADDRESS, PERS.SMSADDRESS, PERS.ADMINISTEREDDOMAINID,
PERS.ADMINISTEREDDOMAINSYSTEMID, PERS.EUSID, EUS.TYPE, PERS.SYNCHRONIZE, CASE
WHEN (PERS.ADMINISTEREDDOMAINID, PERS.ADMINISTERE
DDOMAINSYSTEMID)= (SELECT
ID, SYSTEMID FROM V_POPULATION R WHERE R.DOMAINID IS NULL AND R.DOMAINSYSTEMID
IS NULL) THEN 1 ELSE 0 END AS ISROOTADMINISTERED FROM V_POPULATION POPUL,
V_PERSON PERS, ROLE ROLE, EUS EUS WHERE POPUL.ID = :B2 AND POPUL.SYSTEMID = :
B1
AND (POPUL.TYPE = 'P' OR POPUL.TYPE = 'A') AND PERS.ID = POPUL.ID AND PERS.SYSTEMID =
POPUL.SYSTEMID AND PERS.ROLEID = ROLE.ID(+) AND PERS.ROLESYSTEMID =
ROLE.SYSTEMID(+) AND PERS.EUSID = EUS.ID(+)

9bab7znufyxyv

INSERT INTO MAILBOXITEM ( MAILBOXITEMID,

MAILBOXID, SUBMESSAGEID,
SUBMESSAGESYSTEMID, OWNERID, OWNERSYSTEMID, MAILTYPE,
LASTMODIFIEDTIMESTAMP, LISTTYPE, DELIVERYDATE, CONTAINSATTACHMENTS) VALUES (
:B10 , :B9 , :B8 , :B7 , :B1 , :B2 , :B6 , :B5 , :B3 , :B5 , :B4 )

9ddz2mw10nt8r

BEGIN :1 := p_gro
up.insertExternalGroup(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17,
:18, :19, :20, :21); END;

9pwyz2pm98vxx

BEGIN p_retention.updateMessageRetention(:1, :2, :3, :4, :5); END;

9utsq4swwsmzd

SELECT SMRP.SUBMESSAGEID, SMRP.SUBMESS
AGESYSTEMID, SMRP.RETENTIONPOLICYID,
SMRP.RETENTIONPOLICYSYSTEMID, RP.CODE, RP.DESCRIPTION, SMRP.POLICYTYPE,
SMRP.DAYS, SMRP.MONTHS, SMRP.YEARS, SMRP.SENTTIMESTAMP,
SMRP.LASTACCESSTIMESTAMP, SMRP.REPLYFORWARDTIMESTAMP,
SMRP.EXPIRATIONTIMESTAMP, SMRP.HOLD R
ETENTIONHOLD FROM
SUBMESSAGERETENTION SMRP, RETENTIONPOLICY RP WHERE SMRP.SUBMESSAGEID = :B2
AND SMRP.SUBMESSAGESYSTEMID = :B1 AND SMRP.RETENTIONPOLICYID = RP.ID AND
SMRP.RETENTIONPOLICYSYSTEMID = RP.SYSTEMID

9ztc2usu3fmj5

SELECT P.ID ID, P.SYSTEMID SYSTE
MID, A.TYPED_NAME TYPEDNAME, P.TYPE
POPULATIONTYPE, P.DISPLAYNAME1 DISPLAYNAME, P.SMTPADDRESS SMTPADDRESS FROM
POPULATION P, COMPLIANCE_DETAILS C, TABLE(CAST(:B1 AS RECIPIENT_INFO_LIST)) A
WHERE C.OWNERID = :B3 AND C.OWNERSYSTEMID = :B2 AND P.STATUS <> 'R'

AND
C.TARGETID = P.ID AND C.TARGETSYSTEMID = P.SYSTEMID AND UPPER(P.DISPLAYNAME1)
LIKE UPPER(NVL(A.DISPLAY_NAME, P.DISPLAYNAME1) || '%') AND UPPER(P.SMTPADDRESS) =
NVL(UPPER(A.SMTPADDRESS), UPPER(P.SMTPADDRESS))

apgdwp5n2wdug

SELECT T1.RN, T1.SUBMESSAGEI
D AS SUBMESSAGEID, T1.SUBMESSAGESYSTEMID AS
SUBMESSAGESYSTEMID, T1.TYPE, T1.REPLYDATE AS REPLYDATE, T1.FORWARDDATE AS
FORWARDDATE, T1.READDATE AS READDATE, NVL(T1.FLAG, 0) AS FLAG, T1.PRIORITY AS
PRIORITY, T1.SENSITIVITY AS SENSITIVITY, T1.CONTAINSATTACHME
NTS AS
CONTAINSATTACHMENTS, T1.DISPLAYNAME1 AS ADDRESSDISPLAYNAME1, T1.SMTPADDRESS
AS SMTPADDRESS, T1.SUBJECT AS SUBJECT, T1.DELIVERYDATE AS DELIVERYDATE, T1.PV AS
PV, T1.HASCUSTOMDATA AS HASCUSTOMDATA FROM
TABLE(P_MAILBOX_CONTENTS.GETRECEIVEDITEMSSET( :B1

, :B2 , :B3 , :B4 , :B5 , :B6 , :B7 )) T1
ORDER BY RN

avc1jqzz04wpr

SELECT 'x' FROM DUAL

axmdf8vq7k1rh

select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where
obj#=:1

b6qv8f7zwqz0d

begin :1 := JAVA_XA.xa_c
ommit_new (:2, :3, :4, :5); end;

bjzvd7sragcaj

BEGIN :1 := p_mailbox_contents.getReceivedMailboxItems(:2, :3, :4, :5, :6, :7, :8) ; END;

bnk1g42zxuk5u

begin :1 := JAVA_XA.xa_start_new(:2, :3, :4, :5, :6); end;

butrzvwc2ckcc

SELECT SUBMESSAGE.CS AS CHECK
SUM, MAILBOXITEM.MAILTYPE,
MAILBOXITEM.TRASHEDTIMESTAMP, MAILBOXITEM.DELETEDTIMESTAMP,
MAILBOXITEM.FLAG, MAILBOXITEM.CONTAINSATTACHMENTS AS CONTAINSATTACHMENTS,
MAILBOXITEM.HISTORYID, MAILBOX.NAME AS MAILBOXNAME FROM MAILBOXITEM, MAILBOX,
SUBMESSAGE WHERE
MAILBOXITEM.MAILBOXID = :B1 AND MAILBOXITEM.SUBMESSAGEID =
:B3 AND MAILBOXITEM.SUBMESSAGESYSTEMID = :B2 AND SUBMESSAGE.ID =
MAILBOXITEM.SUBMESSAGEID AND SUBMESSAGE.SYSTEMID =
MAILBOXITEM.SUBMESSAGESYSTEMID AND MAILBOX.ID = :B1

ch6ygprzxubjr

UPDATE MAILBO
XITEM SET LASTMODIFIEDTIMESTAMP = :B5 , READDATE = NVL(READDATE,
:B5 ), LASTREADDATE = :B5 WHERE SUBMESSAGEID = :B4 AND SUBMESSAGESYSTEMID = :B3
AND OWNERID = :B2 AND OWNERSYSTEMID = :B1

cqgv56fmuj63x

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

cz0d2rv3hsxa2

INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP)
VALUES(:1, :2, :3, :4, :5)

d0
mzzx77304yz

INSERT INTO SUBMESSAGE (ID, SYSTEMID, CREATIONTIMESTAMP, CREATIONTYPE,
SENDERID, SENDERSYSTEMID, CS, CSWWS, CST, MESSAGEID, MESSAGESYSTEMID, PV,