WORKLOAD REPOSITORY report for

DB Name

DB Id

Instance

Inst num

Release

RAC

Host

SNCLR1

99870073

SNCLR1

1

10.2.0.3.0

NO

sinclair

 

 

Snap Id

Snap Time

Sessions

Cursors/Session

Begin Snap:

6287

12-Jan-0912:00:21

71

14.3

End Snap:

6288

12-Jan-0913:00:27

72

14.0

Elapsed:

 

60.10 (mins)

 

 

DB Time:

 

59.84 (mins)

 

 

Report Summary

Cache Sizes

 

Begin

End

 

 

Buffer Cache:

656M

720M

Std Block Size:

8K

Shared Pool Size:

784M

720M

Log Buffer:

14,356K

Load Profile

 

Per Second

Per Transaction

Redo size:

30,788.38

5,442.16

Logical reads:

30,887.20

5,459.62

Block changes:

198.95

35.17

Physical reads:

409.51

72.39

Physical writes:

6.74

1.19

User calls:

286.82

50.70

Parses:

109.89

19.42

Hard parses:

2.41

0.43

Sorts:

1,114.83

197.06

Logons:

0.12

0.02

Executes:

141.26

24.97

Transactions:

5.66

 

 

% Blocks changed per Read:

0.64

Recursive Call %:

44.74

Rollback per transaction %:

0.44

Rows per Sort:

3.17

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:

99.93

Redo NoWait %:

100.00

Buffer Hit %:

98.68

In-memory Sort %:

100.00

Library Hit %:

96.35

Soft Parse %:

97.81

Execute to Parse %:

22.21

Latch Hit %:

99.49

Parse CPU to Parse Elapsd %:

58.76

% Non-Parse CPU:

95.09

Shared Pool Statistics

 

Begin

End

Memory Usage %:

48.53

42.43

% SQL with executions>1:

62.68

71.35

% Memory for SQL w/exec>1:

74.06

77.92

Top 5 Timed Events

Event

Waits

Time(s)

Avg Wait(ms)

% Total Call Time

Wait Class

db file sequential read

803,108

1,705

2

47.5

User I/O

CPU time

 

1,541

 

42.9

 

db file scattered read

64,152

135

2

3.8

User I/O

read by other session

78,693

92

1

2.6

User I/O

ARCH wait on SENDREQ

159

60

380

1.7

Network

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name

Time (s)

% of DB Time

sql execute elapsed time

3,353.38

93.40

DB CPU

1,541.02

42.92

parse time elapsed

271.34

7.56

hard parse elapsed time

254.99

7.10

PL/SQL compilation elapsed time

9.56

0.27

PL/SQL execution elapsed time

4.45

0.12

connection management call elapsed time

1.11

0.03

inbound PL/SQL rpc elapsed time

0.68

0.02

hard parse (sharing criteria) elapsed time

0.54

0.02

sequence load elapsed time

0.53

0.01

hard parse (bind mismatch) elapsed time

0.28

0.01

repeated bind elapsed time

0.16

0.00

RMAN cpu time (backup/restore)

0.02

0.00

DB time

3,590.41

 

background elapsed time

236.46

 

background cpu time

29.44

 

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class

Waits

%Time -outs

Total Wait Time (s)

Avg wait (ms)

Waits /txn

User I/O

949,088

0.00

1,939

2

46.52

System I/O

46,179

0.00

68

1

2.26

Network

1,053,953

0.00

64

0

51.66

Commit

20,398

0.00

57

3

1.00

Other

426

0.00

32

76

0.02

Concurrency

643

0.62

0

1

0.03

Configuration

6

0.00

0

20

0.00

Administrative

12

0.00

0

4

0.00

Application

2

0.00

0

0

0.00

Back to Wait Events Statistics
Back to Top

Wait Events

Event

Waits

%Time -outs

Total Wait Time (s)

Avg wait (ms)

Waits /txn

db file sequential read

803,108

0.00

1,705

2

39.37

db file scattered read

64,152

0.00

135

2

3.14

read by other session

78,693

0.00

92

1

3.86

ARCH wait on SENDREQ

159

0.00

60

380

0.01

log file sync

20,398

0.00

57

3

1.00

log file parallel write

21,576

0.00

52

2

1.06

reliable message

129

0.00

32

249

0.01

control file sequential read

21,622

0.00

7

0

1.06

direct path read

2,396

0.00

5

2

0.12

control file parallel write

1,719

0.00

4

2

0.08

db file parallel write

857

0.00

2

3

0.04

SQL*Net more data to client

90,047

0.00

2

0

4.41

log file sequential read

168

0.00

2

13

0.01

db file parallel read

138

0.00

2

11

0.01

SQL*Net more data from client

9,153

0.00

1

0

0.45

SQL*Net message to client

954,594

0.00

1

0

46.79

direct path write

499

0.00

0

1

0.02

os thread startup

4

0.00

0

34

0.00

log file switch completion

6

0.00

0

20

0.00

library cache load lock

12

0.00

0

9

0.00

Log archive I/O

207

0.00

0

0

0.01

direct path write temp

51

0.00

0

2

0.00

latch: cache buffers chains

588

0.00

0

0

0.03

enq: TX - index contention

4

0.00

0

14

0.00

latch: shared pool

16

0.00

0

3

0.00

Backup: sbtinit

4

0.00

0

13

0.00

direct path read temp

51

0.00

0

1

0.00

cursor: pin S wait on X

5

80.00

0

8

0.00

control file single write

24

0.00

0

2

0.00

latch free

12

0.00

0

2

0.00

LGWR wait for redo copy

283

0.00

0

0

0.01

log file single write

6

0.00

0

2

0.00

latch: library cache

2

0.00

0

0

0.00

buffer busy waits

9

0.00

0

0

0.00

latch: cache buffers lru chain

2

0.00

0

0

0.00

Backup: sbtcommand

4

0.00

0

0

0.00

SQL*Net break/reset to client

2

0.00

0

0

0.00

latch: library cache lock

2

0.00

0

0

0.00

latch: library cache pin

1

0.00

0

0

0.00

Backup: sbtinit2

4

0.00

0

0

0.00

SQL*Net message from client

954,592

0.00

124,977

131

46.79

virtual circuit status

121

100.00

3,521

29098

0.01

Streams AQ: waiting for messages in the queue

721

100.00

3,517

4878

0.04

Streams AQ: qmn slave idle wait

128

0.00

3,516

27472

0.01

Streams AQ: qmn coordinator idle wait

264

51.52

3,516

13319

0.01

Streams AQ: waiting for time management or cleanup tasks

11

100.00

525

47709

0.00

jobq slave wait

40

100.00

117

2930

0.00

SGA: MMAN sleep for component shrink

292

92.47

3

9

0.01

wait for unread message on broadcast channel

180

0.00

0

1

0.01

class slave wait

2

0.00

0

0

0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event

Waits

%Time -outs

Total Wait Time (s)

Avg wait (ms)

Waits /txn

ARCH wait on SENDREQ

159

0.00

60

380

0.01

log file parallel write

21,574

0.00

52

2

1.06

events in waitclass Other

415

0.00

32

77

0.02

db file sequential read

4,022

0.00

7

2

0.20

control file parallel write

1,683

0.00

4

2

0.08

db file parallel write

857

0.00

2

3

0.04

control file sequential read

5,439

0.00

2

0

0.27

log file sequential read

168

0.00

2

13

0.01

db file scattered read

124

0.00

1

5

0.01

os thread startup

4

0.00

0

34

0.00

Log archive I/O

207

0.00

0

0

0.01

direct path read

72

0.00

0

0

0.00

log file single write

6

0.00

0

2

0.00

latch: shared pool

1

0.00

0

9

0.00

direct path write

72

0.00

0

0

0.00

rdbms ipc message

35,148

36.45

51,045

1452

1.72

pmon timer

1,209

100.00

3,520

2912

0.06

Streams AQ: qmn slave idle wait

128

0.00

3,516

27472

0.01

Streams AQ: qmn coordinator idle wait

264

51.52

3,516

13319

0.01

smon timer

3,237

0.00

3,511

1085

0.16

Streams AQ: waiting for time management or cleanup tasks

11

100.00

525

47709

0.00

SGA: MMAN sleep for component shrink

292

92.47

3

9

0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic

Total

NUM_LCPUS

0

NUM_VCPUS

0

AVG_BUSY_TIME

56,022

AVG_IDLE_TIME

304,320

AVG_IOWAIT_TIME

38,624

AVG_SYS_TIME

11,399

AVG_USER_TIME

44,528

BUSY_TIME

224,475

IDLE_TIME

1,217,637

IOWAIT_TIME

154,868

SYS_TIME

45,974

USER_TIME

178,501

LOAD

0

OS_CPU_WAIT_TIME

244,700

RSRC_MGR_CPU_WAIT_TIME

0

PHYSICAL_MEMORY_BYTES

10,737,418,240

NUM_CPUS

4

NUM_CPU_CORES

2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name

DB Time (s)

DB CPU (s)

Physical Reads

Logical Reads

SYS$USERS

3,583.60

1,540.60

1,475,500

111,320,772

SNCLR1.news.airwise.local

0.00

0.00

0

0

SNCLR1XDB

0.00

0.00

0

0

SYS$BACKGROUND

0.00

0.00

6,821

48,184

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

SYS$USERS

943197

192384

638

31

12

5

1052270

395

SYS$BACKGROUND

5910

1540

5

14

0

0

159

6040

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)

CPU Time (s)

Executions

Elap per Exec (s)

% Total DB Time

SQL Id

SQL Module

SQL Text

440

26

28

15.72

12.26

5zyyvzgfz4xq5

dllhost.exe

SELECT DISTINCT t1."ACCOUNT_ID...

417

261

12

34.71

11.60

1vwsk2xvdhh5c

dllhost.exe

INSERT INTO temp_lookup_pks(se...

315

284

68

4.63

8.77

fy82wkbv7q06n

dllhost.exe

SELECT PL.N1 FROM PAGED_LOOKUP...

118

109

19

6.21

3.29

8cbfcznp40y90

dllhost.exe

BEGIN :1 := ANYDBA.VISIBILITYP...

92

23

4

23.10

2.57

8c12h6vvgsx2c

SQL*Plus

SELECT a.ACCOUNT_ID, a.COMP...

87

29

8

10.84

2.42

9pjzs5d3wwb6s

SQL Developer

select count(distinct b.bookin...

76

18

3

25.39

2.12

fg8tvnqhaf5z9

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

76

18

3

25.30

2.11

2xfh0dt6a6xaa

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

75

17

3

24.96

2.09

11cr930yzjk3d

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

66

53

3,158

0.02

1.84

00xs501h262s0

dllhost.exe

SELECT COUNT(*) FROM SALES_REP...

53

46

215

0.25

1.47

73tpnkbkrtvc4

 

SELECT IUSERID FROM TBLUSER WH...

37

36

6

6.09

1.02

2qpy9rnkn8b9p

dllhost.exe

BEGIN :1 := ANYDBA.VISIBILITYP...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)

Elapsed Time (s)

Executions

CPU per Exec (s)

% Total DB Time

SQL Id

SQL Module

SQL Text

284

315

68

4.18

8.77

fy82wkbv7q06n

dllhost.exe

SELECT PL.N1 FROM PAGED_LOOKUP...

261

417

12

21.77

11.60

1vwsk2xvdhh5c

dllhost.exe

INSERT INTO temp_lookup_pks(se...

109

118

19

5.71

3.29

8cbfcznp40y90

dllhost.exe

BEGIN :1 := ANYDBA.VISIBILITYP...

53

66

3,158

0.02

1.84

00xs501h262s0

dllhost.exe

SELECT COUNT(*) FROM SALES_REP...

46

53

215

0.22

1.47

73tpnkbkrtvc4

 

SELECT IUSERID FROM TBLUSER WH...

36

37

6

6.00

1.02

2qpy9rnkn8b9p

dllhost.exe

BEGIN :1 := ANYDBA.VISIBILITYP...

30

35

133

0.23

0.98

7wycjsq05ptxz

 

SELECT TBLUSER.IUSERID FROM TB...

29

87

8

3.67

2.42

9pjzs5d3wwb6s

SQL Developer

select count(distinct b.bookin...

28

32

1,909

0.01

0.88

2k2ddvprhp294

dllhost.exe

SELECT COUNT(*) FROM SALES_REP...

26

440

28

0.93

12.26

5zyyvzgfz4xq5

dllhost.exe

SELECT DISTINCT t1."ACCOUNT_ID...

23

92

4

5.77

2.57

8c12h6vvgsx2c

SQL*Plus

SELECT a.ACCOUNT_ID, a.COMP...

18

76

3

5.86

2.12

fg8tvnqhaf5z9

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

18

76

3

5.84

2.11

2xfh0dt6a6xaa

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

17

75

3

5.74

2.09

11cr930yzjk3d

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets

Executions

Gets per Exec

%Total

CPU Time (s)

Elapsed Time (s)

SQL Id

SQL Module

SQL Text

54,383,580

12

4,531,965.00

48.83

261.29

416.52

1vwsk2xvdhh5c

dllhost.exe

INSERT INTO temp_lookup_pks(se...

10,936,831

3,158

3,463.21

9.82

52.72

65.92

00xs501h262s0

dllhost.exe

SELECT COUNT(*) FROM SALES_REP...

6,302,145

8

787,768.13

5.66

29.38

86.72

9pjzs5d3wwb6s

SQL Developer

select count(distinct b.bookin...

5,531,194

1,909

2,897.43

4.97

27.66

31.66

2k2ddvprhp294

dllhost.exe

SELECT COUNT(*) FROM SALES_REP...

4,156,481

68

61,124.72

3.73

284.15

314.71

fy82wkbv7q06n

dllhost.exe

SELECT PL.N1 FROM PAGED_LOOKUP...

2,512,704

2

1,256,352.00

2.26

12.93

14.78

daqxs3fbup049

dllhost.exe

BEGIN :1 := ANYDBA.VISIBILITYP...

2,430,484

4

607,621.00

2.18

23.09

92.41

8c12h6vvgsx2c

SQL*Plus

SELECT a.ACCOUNT_ID, a.COMP...

2,314,367

2,206

1,049.12

2.08

18.95

25.37

fjhcd2cbg7bny

dllhost.exe

SELECT COUNT(*) FROM SALES_REP...

2,273,660

2

1,136,830.00

2.04

12.36

13.52

4h7k4z9mr83sx

dllhost.exe

BEGIN :1 := ANYDBA.VISIBILITYP...

2,138,522

8

267,315.25

1.92

10.96

12.85

fjjm50t7tnub4

dllhost.exe

BEGIN :1 := ANYDBA.VISIBILITYP...

2,011,537

28

71,840.61

1.81

26.16

440.29

5zyyvzgfz4xq5

dllhost.exe

SELECT DISTINCT t1."ACCOUNT_ID...

1,924,411

3

641,470.33

1.73

17.52

75.90

2xfh0dt6a6xaa

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

1,924,352

3

641,450.67

1.73

17.23

74.87

11cr930yzjk3d

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

1,924,255

3

641,418.33

1.73

17.57

76.16

fg8tvnqhaf5z9

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads

Executions

Reads per Exec

%Total

CPU Time (s)

Elapsed Time (s)

SQL Id

SQL Module

SQL Text

256,872

4

64,218.00

17.40

23.09

92.41

8c12h6vvgsx2c

SQL*Plus

SELECT a.ACCOUNT_ID, a.COMP...

199,037

28

7,108.46

13.48

26.16

440.29

5zyyvzgfz4xq5

dllhost.exe

SELECT DISTINCT t1."ACCOUNT_ID...

90,686

12

7,557.17

6.14

261.29

416.52

1vwsk2xvdhh5c

dllhost.exe

INSERT INTO temp_lookup_pks(se...

52,742

8

6,592.75

3.57

29.38

86.72

9pjzs5d3wwb6s

SQL Developer

select count(distinct b.bookin...

43,802

5

8,760.40

2.97

4.19

19.49

fn35nnycmjvq1

dllhost.exe

INSERT INTO temp_lookup_pks(se...

23,585

3

7,861.67

1.60

17.52

75.90

2xfh0dt6a6xaa

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

23,568

3

7,856.00

1.60

17.57

76.16

fg8tvnqhaf5z9

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

16,772

3

5,590.67

1.14

17.23

74.87

11cr930yzjk3d

ZenaAgent.exe

SELECT ia.insertion_attr_detai...

7,185

3

2,395.00

0.49

1.91

17.01

bv4yn9fcbs09v

ZenaAgent.exe

SELECT b.booking FROM booking...

6,980

3

2,326.67

0.47

1.39

17.29

7t9ccwh7h8f8y

ZenaAgent.exe

SELECT b.booking FROM booking...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions

Rows Processed

Rows per Exec

CPU per Exec (s)

Elap per Exec (s)

SQL Id

SQL Module

SQL Text

17,616

17,616

1.00

0.00

0.00

as8hp2s7bbp8j

dllhost.exe

SELECT "BOTTOM_BLEED", "CASUAL...

15,565

78,094

5.02

0.00

0.00

3w65rqfay8pm7

dllhost.exe

SELECT "ANIM_PUBLICATION_I...

15,555

15,555

1.00

0.00

0.00

015mzvtvgvdv3

dllhost.exe

SELECT DISTINCT t1."ANIM_P...

14,790

14,790

1.00

0.00

0.00

5b4k2uy97rhm0

dllhost.exe

SELECT "APPORTION_BY_CIRC", "C...

13,195

5,391

0.41

0.00

0.00

25bmgxfdvxhjv

dllhost.exe

SELECT "D1", "DESCRIPTION", "H...

12,982

12,981

1.00

0.00

0.00

apnma2nyuy67r

dllhost.exe

SELECT "ABBREVIATION", "ADDRES...

11,624

72,152

6.21

0.00

0.00

c29807f9rgcjn

dllhost.exe

SELECT "ANIM_CLASSIFICATIO...

11,624

11,624

1.00

0.00

0.00

d0p95jm91490j

dllhost.exe

SELECT DISTINCT t1."ANIM_C...

9,754

10,674

1.09

0.00

0.00

53saa2zkr6wc3

 

select intcol#, nvl(pos#, 0), ...

7,121

7,121

1.00

0.00

0.00

5qhzwr056bukk

dllhost.exe

SELECT "CREATE_TIME", "CREATE_...

7,052

180,285

25.57

0.00

0.00

gbw8su85csq81

dllhost.exe

delete from temp_lookup_pks

6,653

6,653

1.00

0.00

0.00

03hahkwmhfa69

dllhost.exe

SELECT "ACCOUNT_ID", "ATTRIBUT...

5,232

5,232

1.00

0.00

0.00

grwydz59pu6mc

 

select text from view$ where r...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls

Executions

% Total Parses

SQL Id

SQL Module

SQL Text

17,616

17,616

4.45

as8hp2s7bbp8j

dllhost.exe

SELECT "BOTTOM_BLEED", "CASUAL...

15,565

15,565

3.93

3w65rqfay8pm7

dllhost.exe

SELECT "ANIM_PUBLICATION_I...

15,555

15,555

3.93

015mzvtvgvdv3

dllhost.exe

SELECT DISTINCT t1."ANIM_P...

14,790

14,790

3.73

5b4k2uy97rhm0

dllhost.exe

SELECT "APPORTION_BY_CIRC", "C...

13,195

13,195

3.33

25bmgxfdvxhjv

dllhost.exe

SELECT "D1", "DESCRIPTION", "H...

12,982

12,982

3.28

apnma2nyuy67r

dllhost.exe

SELECT "ABBREVIATION", "ADDRES...

11,624

11,624

2.93

c29807f9rgcjn

dllhost.exe

SELECT "ANIM_CLASSIFICATIO...

11,624

11,624

2.93

d0p95jm91490j

dllhost.exe

SELECT DISTINCT t1."ANIM_C...

7,121

7,121

1.80

5qhzwr056bukk

dllhost.exe

SELECT "CREATE_TIME", "CREATE_...

7,052

7,052

1.78

gbw8su85csq81

dllhost.exe

delete from temp_lookup_pks

6,653

6,653

1.68

03hahkwmhfa69

dllhost.exe

SELECT "ACCOUNT_ID", "ATTRIBUT...

5,232

5,232

1.32

grwydz59pu6mc

 

select text from view$ where r...

5,083

5,083

1.28

f6u155dca4404

dllhost.exe

SELECT "BIN_PASSWORD", "CAN_BE...

4,856

4,856

1.23

6ps4gtax0q1vk

dllhost.exe

SELECT "ABBREVIATION", "ADDRES...

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

Complete List of SQL Text

SQL Id

SQL Text

00xs501h262s0

SELECT COUNT(*) FROM SALES_REP SR , ACCESS_POLICY AP , ACCESS_POLICY_RULE APR , PRIVILEGE PRIV WHERE SR.ACCOUNT_ID IS NULL AND NVL(SR.SALES_REP_START_DATE, SYSDATE) <= SYSDATE AND NVL(SR.SALES_REP_END_DATE, SYSDATE) >= SYSDATE AND SR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.PRIVILEGE_ID = PRIV.PRIVILEGE_ID AND UPPER(PRIV.PRIVILEGE_CODE)= :B2 AND APR.BLOCKABLE = 0 AND EXISTS( SELECT 1 FROM INSERTION I1, INSERTION_SET IS1 WHERE I1.BOOKING = :B3 AND I1.BOOKING = IS1.BOOKING AND I1.INSERTION_SET = IS1.INSERTION_SET AND (APR.PUBLICATION_ID IS NULL OR EXISTS(SELECT 1 FROM PUBLICATION_HIER PH1 WHERE APR.PUBLICATION_ID = PH1.ANIM_PUBLICATION_ID AND PH1.SIGNAGE_PUBLICATION_ID = I1.PUBLICATION_ID AND PH1.PUBLICATION_ROOT_ID = :B4 ) ) AND (APR.CLASSIFICATION_ID IS NULL OR EXISTS( SELECT 1 FROM CLASSIFICATION_HIER CH1 WHERE APR.CLASSIFICATION_ID = CH1.ANIM_CLASSIFICATION_ID AND CH1.SIGNAGE_CLASSIFICATION_ID = IS1.CLASSIFICATION_ID AND CH1.CLASSIFICATION_ROOT_ID = :B5 ) ) ) AND (SR.USER_ID = :B1 OR EXISTS(SELECT 1 FROM WORKGROUP W1 , WORKGROUP W2 , WORKGROUP_HIER WH , USER_WORKGROUP UW WHERE SR.WORKGROUP_ID = W1.WORKGROUP_ID AND AP.WORKGROUP_ROOT_ID = WH.WORKGROUP_ROOT_ID AND ( (AP.ANIMS_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W1.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W2.WORKGROUP_ID AND UW.USER_ID = :B1 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID) OR (AP.SIGNAGEREN_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W2.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W1.WORKGROUP_ID AND UW.USER_ID = :B1 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID) ) ) OR EXISTS(SELECT 1 FROM WORKGROUP W3 , USER_WORKGROUP UW2 WHERE SR.WORKGROUP_ID = W3.WORKGROUP_ID AND UW2.USER_ID = :B1 AND UW2.WORKGROUP_ID = W3.WORKGROUP_ID ) )

015mzvtvgvdv3

SELECT DISTINCT t1."ANIM_PUBLICATION_ID", t1."SIGNAGE_PUBLICATION_ID", t1."CREATE_TIME", t1."CREATE_USER", t1."MODIFY_TIME", t1."MODIFY_USER", t1."PUBLICATION_ROOT_ID", t1."PUBLICATION_SEQ", t1."PUBLICATION_SPAN", t1."TIMESTAMP" FROM g_publication_hier_8 t1 INNER JOIN g_publication_root_7 t2 ON t1."PUBLICATION_ROOT_ID" = t2."PUBLICATION_ROOT_ID" WHERE t1."SIGNAGE_PUBLICATION_ID" = :1 AND lower(t2."PUBLICATION_ROOT_CODE") = :2 AND t1."PUBLICATION_SPAN" = :3 ORDER BY t1.SIGNAGE_publication_id

03hahkwmhfa69

SELECT "ACCOUNT_ID", "ATTRIBUTE_ID", "ATTRIBUTE_STATE_ID", "BOOKING", "CONTACT_ID", "CREATE_TIME", "CREATE_USER", "DATE_VALUE", "INSERTION", "INSERTION_ATTR_DETAIL", "INSERTION_ATTR_OVERRIDE", "INSERTION_ATTR_VALUE", "INSERTION_SET", "MODIFY_TIME", "MODIFY_USER", "MOVED_FROM_PC", "RELEASE_REASON_ID", "TIMESTAMP", "USER_ID" FROM g_insertion_attr_11 WHERE "ATTRIBUTE_ID" = :1 AND "BOOKING" = :2 AND "INSERTION" = :3 AND "INSERTION_SET" = :4

11cr930yzjk3d

SELECT ia.insertion_attr_detail, b.booking, i.INSERTION_SET, i.insertion, i.issue_date, p.publication, c.classification, '-' FROM booking b, --- site s, classification c, insertion i, publication_prop pp, publication p, insertion_attr ia, attribute a WHERE b.booking_hold = 0 --- and (b.booking_site_id = s.site_id --- and s.site = 'Hobart') AND b.booking_incomplete = 0 AND (i.booking = b.booking and i.insertion_cancelled = 0 and i.insertion_missed = 0 and i.published = 0) and i.style_id <> (select style_id from style where style = 'ROP Component') AND (i.publication_id = pp.publication_id and pp.property_id = (select property_id from property where property = 'PublishDivision') and pp.publication_prop_detail = 'NWN') and (ia.booking = b.booking AND ia.attribute_id = a.attribute_id AND a.attribute = 'Unique Insertion_ID') AND i.publication_id = p.publication_id AND c.classification_id = i.booked_classification_id AND i.pagination_type_id = (select pagination_type_id from pagination_type where pagination_type = 'Display') AND b.modify_time < SYSDATE - 0.03125 -- AND b.create_time > SYSDATE - 7.0 and not exists (select * from booking_attr ba, attribute a where ba.booking = b.booking and ba.attribute_id = a.attribute_id and a.attribute = 'WF Special Price' and ba.attribute_state_id = 4) AND NOT EXISTS (SELECT * FROM insertion_attr ia, attribute a WHERE ia.booking = b.booking AND ia.attribute_id = a.attribute_id AND a.attribute = 'Publishing Insertion#') ORDER BY i.issue_date, b.booking

1vwsk2xvdhh5c

INSERT INTO temp_lookup_pks(session_id, search_id, object_no, user_id, sequence_no, n1) SELECT :1, :2, :3, :4, rownum, "ACCOUNT_ID" FROM ( SELECT DISTINCT "ACCOUNT_ID" FROM g_account_27 WHERE EXISTS ( SELECT :5 FROM g_account_attr_9 t5, g_attribute_18 t6, g_attribute_state_4 t7 WHERE g_account_27."ACCOUNT_ID" = t5."ACCOUNT_ID" AND t5."ATTRIBUTE_ID" = t6."ATTRIBUTE_ID" AND t5."ATTRIBUTE_STATE_ID" = t7."ATTRIBUTE_STATE_ID" AND lower(t6."ATTRIBUTE_CODE") = :6 AND lower(t7."ATTRIBUTE_STATE_CODE") = :7 AND ( t5."CREATE_TIME" >= :8 OR t5."MODIFY_TIME" >= :9 ) ) OR EXISTS ( SELECT :10 FROM g_booking_32 t1, g_booking_attr_10 t2, g_attribute_18 t3, g_attribute_state_4 t4 WHERE g_account_27."ACCOUNT_ID" = t1."ACCOUNT_ID" AND t1."BOOKING" = t2."BOOKING" AND t2."ATTRIBUTE_ID" = t3."ATTRIBUTE_ID" AND t2."ATTRIBUTE_STATE_ID" = t4."ATTRIBUTE_STATE_ID" AND t1."BOOKING_INCOMPLETE" = :11 AND lower(t3."ATTRIBUTE_CODE") = :12 AND lower(t4."ATTRIBUTE_STATE_CODE") = :13 AND ( t2."CREATE_TIME" >= :14 OR t2."MODIFY_TIME" >= :15 ) ) ORDER BY "ACCOUNT_ID" NULLS FIRST )

25bmgxfdvxhjv

SELECT "D1", "DESCRIPTION", "HOSTNAME", "LOCK_TIME", "N1", "N2", "N3", "SESSION_ID", "TABLE_NAME", "TIMESTAMP", "USER_ID", "USER_NAME", "V1" FROM generic_lock WHERE table_name = :1 AND n1 = :2

2k2ddvprhp294

SELECT COUNT(*) FROM SALES_REP SR , ACCESS_POLICY AP , ACCESS_POLICY_RULE APR , PRIVILEGE PRIV WHERE SR.ACCOUNT_ID IS NULL AND NVL(SR.SALES_REP_START_DATE, SYSDATE) <= SYSDATE AND NVL(SR.SALES_REP_END_DATE, SYSDATE) >= SYSDATE AND SR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.PRIVILEGE_ID = PRIV.PRIVILEGE_ID AND UPPER(PRIV.PRIVILEGE_CODE)= :B2 AND APR.BLOCKABLE = 1 AND EXISTS( SELECT 1 FROM INSERTION I1, INSERTION_SET IS1 WHERE I1.BOOKING = :B3 AND I1.BOOKING = IS1.BOOKING AND I1.INSERTION_SET = IS1.INSERTION_SET AND (APR.PUBLICATION_ID IS NULL OR EXISTS(SELECT 1 FROM PUBLICATION_HIER PH1 WHERE APR.PUBLICATION_ID = PH1.ANIM_PUBLICATION_ID AND PH1.SIGNAGE_PUBLICATION_ID = I1.PUBLICATION_ID AND PH1.PUBLICATION_ROOT_ID = :B4 ) ) AND (APR.CLASSIFICATION_ID IS NULL OR EXISTS( SELECT 1 FROM CLASSIFICATION_HIER CH1 WHERE APR.CLASSIFICATION_ID = CH1.ANIM_CLASSIFICATION_ID AND CH1.SIGNAGE_CLASSIFICATION_ID = IS1.CLASSIFICATION_ID AND CH1.CLASSIFICATION_ROOT_ID = :B5 ) ) ) AND (SR.USER_ID = :B1 OR EXISTS(SELECT 1 FROM WORKGROUP W1 , WORKGROUP W2 , WORKGROUP_HIER WH , USER_WORKGROUP UW WHERE SR.WORKGROUP_ID = W1.WORKGROUP_ID AND AP.WORKGROUP_ROOT_ID = WH.WORKGROUP_ROOT_ID AND ( (AP.ANIMS_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W1.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W2.WORKGROUP_ID AND UW.USER_ID = :B1 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID) OR (AP.SIGNAGEREN_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W2.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W1.WORKGROUP_ID AND UW.USER_ID = :B1 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID) ) ) OR EXISTS(SELECT 1 FROM WORKGROUP W3, USER_WORKGROUP UW2 WHERE SR.WORKGROUP_ID = W3.WORKGROUP_ID AND UW2.USER_ID = :B1 AND UW2.WORKGROUP_ID = W3.WORKGROUP_ID ) ) AND NOT EXISTS(SELECT 1 FROM SALES_REP SR2 , ACCESS_POLICY AP2 , ACCESS_POLICY_RULE APR2 , PRIVILEGE PRIV2 WHERE ( SR2.ACCOUNT_ID = :B6 OR EXISTS(SELECT 1 FROM TMP_VISIBILITYPKG_ACC_HIER_1 AH WHERE AH.SIGNAGE_ACCOUNT_ID = :B6 AND AH.ANIM_ACCOUNT_ID = SR2.ACCOUNT_ID) ) AND NVL(SR2.SALES_REP_START_DATE, SYSDATE) <= SYSDATE AND NVL(SR2.SALES_REP_END_DATE, SYSDATE) >= SYSDATE AND SR2.ACCESS_POLICY_ID = AP2.ACCESS_POLICY_ID AND APR2.ACCESS_POLICY_ID = AP2.ACCESS_POLICY_ID AND APR2.PRIVILEGE_ID = PRIV2.PRIVILEGE_ID AND UPPER(PRIV2.PRIVILEGE_CODE)= :B2 AND APR2.BLOCKING = 1 AND EXISTS( SELECT 1 FROM INSERTION I2, INSERTION_SET IS2 WHERE I2.BOOKING = :B3 AND I2.BOOKING = IS2.BOOKING AND I2.INSERTION_SET = IS2.INSERTION_SET AND (APR2.PUBLICATION_ID IS NULL OR EXISTS(SELECT 1 FROM PUBLICATION_HIER PH2 WHERE APR2.PUBLICATION_ID = PH2.ANIM_PUBLICATION_ID AND PH2.SIGNAGE_PUBLICATION_ID = I2.PUBLICATION_ID AND PH2.PUBLICATION_ROOT_ID = :B4 ) ) AND (APR2.CLASSIFICATION_ID IS NULL OR EXISTS( SELECT 1 FROM CLASSIFICATION_HIER CH2 WHERE APR2.CLASSIFICATION_ID = CH2.ANIM_CLASSIFICATION_ID AND CH2.SIGNAGE_CLASSIFICATION_ID = IS2.CLASSIFICATION_ID AND CH2.CLASSIFICATION_ROOT_ID = :B5 ) ) ) )

2qpy9rnkn8b9p

BEGIN :1 := ANYDBA.VISIBILITYPACKAGE_1.CONTRACTFILTER1( 3064281, 164, 15585, 'ViewCont' ); END;

2xfh0dt6a6xaa

SELECT ia.insertion_attr_detail, b.booking, i.INSERTION_SET, i.insertion, i.issue_date, p.publication, c.classification, '-' FROM booking b, --- site s, classification c, insertion i, publication_prop pp, publication p, insertion_attr ia, attribute a WHERE b.booking_hold = 0 --- and (b.booking_site_id = s.site_id --- and s.site = 'Hobart') AND b.booking_incomplete = 0 AND (i.booking = b.booking and i.insertion_cancelled = 0 and i.insertion_missed = 0 and i.published = 0) and i.style_id <> (select style_id from style where style = 'ROP Component') AND (i.publication_id = pp.publication_id and pp.property_id = (select property_id from property where property = 'PublishDivision') and pp.publication_prop_detail = 'DBL') and (ia.booking = b.booking AND ia.attribute_id = a.attribute_id AND a.attribute = 'Unique Insertion_ID') AND i.publication_id = p.publication_id AND c.classification_id = i.booked_classification_id AND i.pagination_type_id = (select pagination_type_id from pagination_type where pagination_type = 'Display') AND b.modify_time < SYSDATE - 0.03125 -- AND b.create_time > SYSDATE - 7.0 and not exists (select * from booking_attr ba, attribute a where ba.booking = b.booking and ba.attribute_id = a.attribute_id and a.attribute = 'WF Special Price' and ba.attribute_state_id = 4) AND NOT EXISTS (SELECT * FROM insertion_attr ia, attribute a WHERE ia.booking = b.booking AND ia.attribute_id = a.attribute_id AND a.attribute = 'Publishing Insertion#') ORDER BY i.issue_date, b.booking

3w65rqfay8pm7

SELECT "ANIM_PUBLICATION_ID", "SIGNAGE_PUBLICATION_ID", "CREATE_TIME", "CREATE_USER", "MODIFY_TIME", "MODIFY_USER", "PUBLICATION_ROOT_ID", "PUBLICATION_SEQ", "PUBLICATION_SPAN", "TIMESTAMP" FROM g_publication_hier_8 WHERE "SIGNAGE_PUBLICATION_ID" = :1 ORDER BY SIGNAGE_publication_id

4h7k4z9mr83sx

BEGIN :1 := ANYDBA.VISIBILITYPACKAGE_1.BOOKINGFILTER1( 3064371, 162, 6301, 'ViewBook' ); END;

53saa2zkr6wc3

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

5b4k2uy97rhm0

SELECT "APPORTION_BY_CIRC", "CALENDAR_MONTH_CYCLE", "COSTING_SCRIPT_ID", "CREATE_TIME", "CREATE_USER", "EXTERNAL_NAME", "FIRST_INSERT_DAY", "MAX_OPTIONAL_PUBS", "MIN_OPTIONAL_PUBS", "MODIFY_TIME", "MODIFY_USER", "PACKAGE", "PACKAGE_CYCLE_LENGTH", "PACKAGE_CYCLE_TYPE", "PACKAGE_DESCRIPTION", "PACKAGE_ELAPSED_DAYS", "PACKAGE_ID", "PACKAGE_MNEMONIC", "PACKAGE_PUBLICATION_ID", "PACKAGE_RUN_SCHEDULE", "PROMPT_ID", "TIMESTAMP" FROM g_package_11 WHERE "PACKAGE_ID" = :1

5qhzwr056bukk

SELECT "CREATE_TIME", "CREATE_USER", "HOLIDAY_CODE", "HOLIDAY_DESCRIPTION", "HOLIDAY_ID", "HOLIDAY_NAME", "MODIFY_TIME", "MODIFY_USER", "NON_HOLIDAY", "TIMESTAMP" FROM g_holiday_2 WHERE lower("HOLIDAY_CODE") = :1

5zyyvzgfz4xq5

SELECT DISTINCT t1."ACCOUNT_ID", t1."AGENCY_DISCOUNT_VALUE", t1."BILLING_ACCOUNT_ID", t1."BILLING_CONTACT_ID", t1."BILLING_METHOD_ID", t1."BILLING_SEQUENCE_NUMBER", t1."BOOKING", t1."BOOKING_BASE_COST", t1."BOOKING_CALC_BASE_COST", t1."BOOKING_CALC_PRICE", t1."BOOKING_CANCELLED", t1."BOOKING_CONFIRMED", t1."BOOKING_HOLD", t1."BOOKING_INCOMPLETE", t1."BOOKING_METHOD_ID", t1."BOOKING_NAME", t1."BOOKING_NOTIFIED", t1."BOOKING_PAID_AMOUNT", t1."BOOKING_PRICE", t1."BOOKING_PRICE_ADJUSTMENT", t1."BOOKING_PRICE_SPLIT_BY", t1."BOOKING_QUOTE", t1."BOOKING_RECEIVED_DATE", t1."BOOKING_REQUIRES_TEARSHEET", t1."BOOKING_SITE_ID", t1."BOOKING_TEMPORARY", t1."BOOKING_TRAINEE", t1."CALLER", t1."CLIENT_ACCOUNT_ID", t1."CLIENT_NAME", t1."CONTACT_ID", t1."COPIED_FROM_BOOKING", t1."CREATE_TIME", t1."CREATE_USER", t1."CREDIT_RATING_ID", t1."CURRENCY_TYPE_ID", t1."DEADLINE_TIME", t1."DELETED", t1."DEPTH_UNIT_ID", t1."EXPORTED_AMOUNT", t1."EXTERNAL_BOOKING_NUMBER", t1."FOR_ATTENTION_OF", t1."IS_SERIES", t1."LEDGER_CODE", t1."MASTER_BOOKING", t1."MASTER_ORDER_TYPE", t1."MODIFIED_AT", t1."MODIFIED_BY", t1."MODIFY_TIME", t1."MODIFY_USER", t1."ORDER_NUMBER", t1."PAY_ON_SALE", t1."PAY_ON_SALE_PRICE", t1."PRIMARY_PUBLICATION_ID", t1."QUOTED_CONTRACT_LEVEL_ID", t1."QUOTED_PER_INSERTION", t1."RATE_CARD_ID", t1."REMOVED_AGENCY_DISCOUNT_VALUE", t1."REMOVED_PAID_AMOUNT", t1."REMOVED_PRICE", t1."REMOVED_PRICE_AT_QUOTE_LEVEL", t1."REPRICE_TIME", t1."SALES_REP_USER_ID", t1."TAKEN_BY_ID", t1."TAX_AMOUNT", t1."TIME STAMP", t1."VERSION_NUMBER" FROM g_booking_32 t1 INNER JOIN g_booking_event_8 t2 ON t1."BOOKING" = t2."BOOKING" INNER JOIN g_publication_28 t3 ON t1."PRIMARY_PUBLICATION_ID" = t3."PUBLICATION_ID" INNER JOIN g_publication_28 t4 ON t3."COMPANY_PUBLICATION_ID" = t4."PUBLICATION_ID" INNER JOIN g_insertion_set_24 t5 ON t1."BOOKING" = t5."BOOKING" INNER JOIN g_site_9 t6 ON t1."BOOKING_SITE_ID" = t6."SITE_ID" WHERE t2."CREATE_TIME" >= :1 AND nvl(lower(t3."PUBLICATION_MNEMONIC"), ' ') <> :2 AND lower(t4."PUBLICATION") = :3 AND t1."BOOKING_HOLD" = :4 AND t1."BOOKING_INCOMPLETE" = :5 AND t5."INSERTION_SET_EXPIRED" = :6 AND lower(t6."SITE") = :7 ORDER BY t1."BOOKING" NULLS FIRST

6ps4gtax0q1vk

SELECT "ABBREVIATION", "ADDRESS_USE_ID", "ATTR_PROCESS_SEQ", "ATTR_PROCESS_TIME_ESTIMATE", "ATTRIBUTE", "ATTRIBUTE_CODE", "ATTRIBUTE_DESCRIPTION", "ATTRIBUTE_ID", "ATTRIBUTE_TYPE_ID", "CAUSE_HOLD", "CONSTRAINED", "CONSTRAINT_VALUES", "CREATE_RESTRICTED", "CREATE_TIME", "CREATE_USER", "DEPTH_UNIT_ID", "FIELD_TYPE_ID", "FIELD_TYPE_PARAMETERS", "IS_CREDIT_ATTRIBUTE", "MODIFY_RESTRICTED", "MODIFY_TIME", "MODIFY_USER", "MOVE_TO_ACCOUNT", "MOVE_TO_BOOKING", "MOVE_TO_COMPONENT", "MOVE_TO_INSERTION", "MOVE_TO_INSERTION_SET", "ONE_STEP_PROCESS", "REQUIRES_RELEASE_REASON", "TIMESTAMP", "VALID_FOR_ACCOUNT", "VALID_FOR_ACCOUNT_CONTRACT", "VALID_FOR_ADDRESS", "VALID_FOR_BOOKING", "VALID_FOR_COMPONENT", "VALID_FOR_CONTACT", "VALID_FOR_CONTRACT", "VALID_FOR_E_ADDRESS", "VALID_FOR_INSERTION", "VALID_FOR_INSERTION_SET", "VALID_FOR_PUB_CLASS", "VALID_FOR_RATES", "VALID_FOR_TELEPHONE", "VALID_FOR_USER", "VALID_FOR_WORKFLOW", "VALID_FOR_WORKFLOW_USER", "VIEW_RESTRICTED" FROM g_attribute_18 WHERE lower("ATTRIBUTE_CODE") = :1

73tpnkbkrtvc4

SELECT IUSERID FROM TBLUSER WHERE UPPER(SZUSERNAME) = UPPER(:B1 )

7t9ccwh7h8f8y

SELECT b.booking FROM booking b , insertion_set i , publication p , site s WHERE b.booking_hold = 0 AND b.booking_incomplete = 0 AND b.booking_cancelled = 0 AND b.booking = i.booking AND i.insertion_set_expired = 0 AND b.primary_publication_id = p.publication_id AND p.publication = 'The Advertiser' AND b.modify_time < SYSDATE - 0.03125 AND b.create_time > SYSDATE - 7.0 AND b.booking_site_id = s.site_id AND s.site = 'OLAB' AND NOT EXISTS (SELECT * FROM insertion_attr ia, attribute a WHERE ia.booking = b.booking AND ia.attribute_id = a.attribute_id AND a.attribute = 'ADN Genesis Number') ORDER BY b.modify_time

7wycjsq05ptxz

SELECT TBLUSER.IUSERID FROM TBLUSER INNER JOIN TBLUSERAPPLICATION ON TBLUSER.IUSERID=TBLUSERAPPLICATION.IUSERID WHERE UPPER(SZUSERNAME) = UPPER(:B3 ) AND UPPER(SZPASSWORD) = UPPER(:B2 ) AND TBLUSERAPPLICATION.SZAPPLICATIONID=:B1

8c12h6vvgsx2c

SELECT a.ACCOUNT_ID, a.COMPANY_NUMBER, s.site, b.BOOKING, i.INSERTION_SET, i.INSERTION, ( SELECT INSERTION_ATTR_DETAIL FROM INSERTION_ATTR ia2 WHERE (i.BOOKING=ia2.BOOKING) AND (i.INSERTION_SET=ia2.INSERTION_SET) AND (i.INSERTION=ia2.INSERTION) AND (ia2.ATTRIBUTE_ID=365) )AS FACOM_NUMBER, i.ISSUE_DATE, p.PUBLICATION, c.CLASSIFICATION, b.EXTERNAL_BOOKING_NUMBER, b.CREATE_TIME, i.INSERTION_PRICE, a.account, a.external_account_number, a.customer_name, a.customer_name_2, u.user_name, cp.component_type, ct.content_description, i.published, i.insertion_billed, i.insertion_missed, ( SELECT il.INSERTION_LOADING_PRICE FROM INSERTION_LOADING il INNER JOIN LOADING l ON il.LOADING_ID=l.LOADING_ID WHERE l.LOADING='GST' and il.BOOKING=i.BOOKING AND il.INSERTION_SET=i.INSERTION_SET AND il.INSERTION=i.INSERTION ) as GST, ( SELECT il.INSERTION_LOADING_PRICE FROM INSERTION_LOADING il INNER JOIN LOADING l ON il.LOADING_ID=l.LOADING_ID WHERE l.LOADING='Agency Commission' and il.BOOKING=i.BOOKING AND il.INSERTION_SET=i.INSERTION_SET AND il.INSERTION=i.INSERTION ) as COMMISSION, i.INSERTION_HOLD FROM ANYDBA.BOOKING b, ANYDBA.CLASSIFICATION c, ANYDBA.INSERTION i, ANYDBA.PUBLICATION p, ANYDBA.ACCOUNT a, users u, content ct, component_type cp, site s WHERE (i.BOOKING=b.BOOKING) AND (p.PUBLICATION_ID=i.publication_id) AND (c.CLASSIFI CATION_ID=i.booked_classification_id) and (a.account_id = b.account_id) and (i.insertion_cancelled=0) and (i.insertion_billed=0) and b.modified_by = u.user_id(+) and i.content_id = ct.content_id and ct.component_type_id = cp.component_type_id(+) and b.booking_site_id = s.site_id and (s.site = 'Perth' OR s.site='Hobart' OR s.site='NewsNet' or s.site='Sydney') ORDER BY b.BOOKING, i.INSERTION_SET, i.INSERTION

8cbfcznp40y90

BEGIN :1 := ANYDBA.VISIBILITYPACKAGE_1.CONTRACTFILTER1( 3063956, 164, 717, 'ViewCont' ); END;

9pjzs5d3wwb6s

select count(distinct b.booking), i.issue_date from booking b, insertion i, insertion_set s where b.booking = s.booking and s.booking = i.booking and s.insertion_set = i.insertion_set and i.issue_date > sysdate and i.publication_id IN (SELECT publication_id FROM publication_prop WHERE publication_prop_detail = 'NWN' AND property_id = (SELECT property_id FROM property WHERE property = 'PublishDivision' ) ) and exists (select 1 from insertion_set_colour where booking = s.booking and insertion_set = s.insertion_set) and b.modified_at < to_date('23feb09 10:25', 'ddmonyy hh24:mi') group by i.issue_date order by i.issue_date

apnma2nyuy67r

SELECT "ABBREVIATION", "ADDRESS_USE_ID", "ATTR_PROCESS_SEQ", "ATTR_PROCESS_TIME_ESTIMATE", "ATTRIBUTE", "ATTRIBUTE_CODE", "ATTRIBUTE_DESCRIPTION", "ATTRIBUTE_ID", "ATTRIBUTE_TYPE_ID", "CAUSE_HOLD", "CONSTRAINED", "CONSTRAINT_VALUES", "CREATE_RESTRICTED", "CREATE_TIME", "CREATE_USER", "DEPTH_UNIT_ID", "FIELD_TYPE_ID", "FIELD_TYPE_PARAMETERS", "IS_CREDIT_ATTRIBUTE", "MODIFY_RESTRICTED", "MODIFY_TIME", "MODIFY_USER", "MOVE_TO_ACCOUNT", "MOVE_TO_BOOKING", "MOVE_TO_COMPONENT", "MOVE_TO_INSERTION", "MOVE_TO_INSERTION_SET", "ONE_STEP_PROCESS", "REQUIRES_RELEASE_REASON", "TIMESTAMP", "VALID_FOR_ACCOUNT", "VALID_FOR_ACCOUNT_CONTRACT", "VALID_FOR_ADDRESS", "VALID_FOR_BOOKING", "VALID_FOR_COMPONENT", "VALID_FOR_CONTACT", "VALID_FOR_CONTRACT", "VALID_FOR_E_ADDRESS", "VALID_FOR_INSERTION", "VALID_FOR_INSERTION_SET", "VALID_FOR_PUB_CLASS", "VALID_FOR_RATES", "VALID_FOR_TELEPHONE", "VALID_FOR_USER", "VALID_FOR_WORKFLOW", "VALID_FOR_WORKFLOW_USER", "VIEW_RESTRICTED" FROM g_attribute_18 WHERE "ATTRIBUTE_ID" = :1

as8hp2s7bbp8j

SELECT "BOTTOM_BLEED", "CASUAL_OVER_LIMIT_CR_RATING_ID", "CASUAL_PASS_LIMIT_CR_RATING_ID", "CLASS_PAGE_SIZE_ID", "COMPANY_PUBLICATION_ID", "CREATE_ISSUE_AHEAD_DAYS", "CREATE_TIME", "CREATE_USER", "DEBTOR_HOUSE_LIMIT", "DEBTOR_OVER_LIMIT_CR_RATING_ID", "DEBTOR_PASS_LIMIT_CR_RATING_ID", "DEFAULT_MECHANICAL_DETAIL_ID", "DEFAULT_STORY_STYLE_ID", "DEL_INCOMPLETE_ADS_AFTER_MIN", "DEL_OUTPUT_PAGES_AFTER_ISSUES", "DEL_OUTPUT_PAGES_AFTER_MIN", "DEL_UNUSED_PAGES_AFTER_ISSUES", "DEL_UNUSED_PAGES_AFTER_MIN", "DEPTH_UNIT_ID", "EARLIEST_OPEN_ISSUE", "EDIT_CLASSIFICATION_ROOT_ID", "EDIT_SECTION_ROOT_ID", "EDITORIAL_CLASSIFICATION_ID", "EDITORIAL_PAGE_SIZE_ID", "EDITORIAL_SECTION_ID", "EXTERNAL_NAME", "FRI_PRESS_RUN_TIME", "GRAPHIC_IMPORT_DIRECTORY", "HORIZONTAL_BLEED", "LATEST_CLOSED_ISSUE", "LEFT_HAND_PAGE_ODD", "MAJOR_PUBLICATION", "MANAGED_PAGE_RANGE", "MAX_DISCOUNT_ALLOWED", "MAX_INSERTION_STORE_AHEAD_DAYS", "MAX_PERCENTAGE_DISCOUNT", "MAXIMUM_INSERTS", "MINIMUM_INSERTS", "MODIFY_TIME", "MODIFY_USER", "MON_PRESS_RUN_TIME", "MULTI_PUB_PRIORITY", "PREPAYMENT_CUTOFF", "PRICE_ADJUSTMENT_LEVEL", "PRODUCTION_SITE_ID", "PUB_DEFAULT_PHONE_PREFIX", "PUB_RUN_SCHEDULE", "PUBLICATION", "PUBLICATION_DESCRIPTION", "PUBLICATION_ID", "PUBLICATION_MNEMONIC", "PUBLICATION_PACKAGE_ID", "PUBLICATION_TYPE_ID", "QUOTE_PRIORITY", "RECOST_ROUNDING", "REMOVE_ISSUES_AFTER_DAYS", "SAT_PRESS_RUN_TIME", "SCHEDULE_BY_VOLUME_NUMBER", "SUN_PRESS_RUN_TIME", "TAX_CLASS", "THU_PRESS_RUN_TIME", "TIME_ZONE", "TIMESTAMP", " TOP_BLEED", "TRANSIENT_HOUSE_LIMIT", "TUE_PRESS_RUN_TIME", "WED_PRESS_RUN_TIME" FROM g_publication_28 WHERE "PUBLICATION_ID" = :1

bv4yn9fcbs09v

SELECT b.booking FROM booking b , insertion_set i , publication p , site s WHERE b.booking_hold = 0 AND b.booking_incomplete = 0 AND b.booking = i.booking AND i.insertion_set_expired = 0 AND b.booking_cancelled = 0 AND b.primary_publication_id = p.publication_id AND p.publication = 'The Courier-Mail' AND b.modify_time < SYSDATE - 0.03125 AND b.create_time > SYSDATE - 7.0 AND b.booking_site_id = s.site_id AND s.site = 'OLAB' AND NOT EXISTS (SELECT * FROM insertion_attr ia, attribute a WHERE ia.booking = b.booking AND ia.attribute_id = a.attribute_id AND a.attribute = 'QNP Genesis Number') ORDER BY b.modify_time

c29807f9rgcjn

SELECT "ANIM_CLASSIFICATION_ID", "SIGNAGE_CLASSIFICATION_ID", "CLASSIFICATION_ROOT_ID", "CLASSIFICATION_SEQ", "CLASSIFICATION_SPAN", "CREATE_TIME", "CREATE_USER", "MODIFY_TIME", "MODIFY_USER", "TIMESTAMP" FROM g_classification_hier_8 WHERE "SIGNAGE_CLASSIFICATION_ID" = :1 ORDER BY SIGNAGE_classification_id

d0p95jm91490j

SELECT DISTINCT t1."ANIM_CLASSIFICATION_ID", t1."SIGNAGE_CLASSIFICATION_ID", t1."CLASSIFICATION_ROOT_ID", t1."CLASSIFICATION_SEQ", t1."CLASSIFICATION_SPAN", t1."CREATE_TIME", t1."CREATE_USER", t1."MODIFY_TIME", t1."MODIFY_USER", t1."TIMESTAMP" FROM g_classification_hier_8 t1 INNER JOIN g_classification_root_3 t2 ON t1."CLASSIFICATION_ROOT_ID" = t2."CLASSIFICATION_ROOT_ID" WHERE t1."SIGNAGE_CLASSIFICATION_ID" = :1 AND lower(t2."CLASSIFICATION_ROOT_CODE") = :2 AND t1."CLASSIFICATION_SPAN" = :3 ORDER BY t1.SIGNAGE_classification_id

daqxs3fbup049

BEGIN :1 := ANYDBA.VISIBILITYPACKAGE_1.BOOKINGFILTER1( 3064281, 3759, 15585, 'ViewBook' ); END;

f6u155dca4404

SELECT "BIN_PASSWORD", "CAN_BE_COLLECTION_REP", "CAN_BE_SALES_REP", "CREATE_TIME", "CREATE_USER", "DEPARTMENT", "DESTINATION_GROUP_ID", "DISABLED", "EXTERNAL_USER_ID", "EXTERNAL_USER_NUMBER", "FILING_GROUP_ID", "HIDDEN", "HOME_DESK", "JOB_TITLE", "LANGUAGE_ID", "MODIFY_TIME", "MODIFY_USER", "SHORT_NAME", "SITE_ID", "SNAPSHOT_INTERVAL", "SUPERVISOR_ID", "TELEPHONE", "TIMESTAMP", "USER_DOMAIN_NAME", "USER_DOMAIN_USER_NAME", "USER_ID", "USER_LEVEL", "USER_MAIL_ADDRESS", "USER_NAME", "USER_TRAINEE" FROM g_users_22 WHERE "USER_ID" = :1

fg8tvnqhaf5z9

SELECT ia.insertion_attr_detail, b.booking, i.INSERTION_SET, i.insertion, i.issue_date, p.publication, c.classification, '-' FROM booking b, --- site s, classification c, insertion i, publication_prop pp, publication p, insertion_attr ia, attribute a WHERE b.booking_hold = 0 --- and (b.booking_site_id = s.site_id --- and s.site = 'Perth') AND b.booking_incomplete = 0 AND (i.booking = b.booking and i.insertion_cancelled = 0 and i.insertion_missed = 0 and i.published = 0) and i.style_id <> (select style_id from style where style = 'ROP Component') AND (i.publication_id = pp.publication_id and pp.property_id = (select property_id from property where property = 'PublishDivision') and pp.publication_prop_detail = 'PST') and (ia.booking = b.booking AND ia.attribute_id = a.attribute_id AND a.attribute = 'Unique Insertion_ID') AND i.publication_id = p.publication_id AND c.classification_id = i.booked_classification_id AND i.pagination_type_id = (select pagination_type_id from pagination_type where pagination_type = 'Display') AND b.modify_time < SYSDATE - 0.03125 -- AND b.create_time > SYSDATE - 7.0 and not exists (select * from booking_attr ba, attribute a where ba.booking = b.booking and ba.attribute_id = a.attribute_id and a.attribute = 'WF Special Price' and ba.attribute_state_id = 4) AND NOT EXISTS (SELECT * FROM insertion_attr ia, attribute a WHERE ia.booking = b.booking AND ia.attribute_id = a.attribute_id AND a.attribute = 'Publishing Insertion#') ORDER BY i.issue_date, b.booking

fjhcd2cbg7bny

SELECT COUNT(*) FROM SALES_REP SR , ACCESS_POLICY AP , ACCESS_POLICY_RULE APR , PRIVILEGE PRIV WHERE ( SR.ACCOUNT_ID = :B3 OR EXISTS(SELECT 1 FROM TMP_VISIBILITYPKG_ACC_HIER_1 AH WHERE AH.SIGNAGE_ACCOUNT_ID = :B3 AND AH.ANIM_ACCOUNT_ID = SR.ACCOUNT_ID) ) AND NVL(SR.SALES_REP_START_DATE, SYSDATE) <= SYSDATE AND NVL(SR.SALES_REP_END_DATE, SYSDATE) >= SYSDATE AND SR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.PRIVILEGE_ID = PRIV.PRIVILEGE_ID AND UPPER(PRIV.PRIVILEGE_CODE)= :B2 AND EXISTS( SELECT 1 FROM INSERTION I1, INSERTION_SET IS1 WHERE I1.BOOKING = :B4 AND I1.BOOKING = IS1.BOOKING AND I1.INSERTION_SET = IS1.INSERTION_SET AND (APR.PUBLICATION_ID IS NULL OR EXISTS(SELECT 1 FROM PUBLICATION_HIER PH1 WHERE APR.PUBLICATION_ID = PH1.ANIM_PUBLICATION_ID AND PH1.SIGNAGE_PUBLICATION_ID = I1.PUBLICATION_ID AND PH1.PUBLICATION_ROOT_ID = :B5 ) ) AND (APR.CLASSIFICATION_ID IS NULL OR EXISTS( SELECT 1 FROM CLASSIFICATION_HIER CH1 WHERE APR.CLASSIFICATION_ID = CH1.ANIM_CLASSIFICATION_ID AND CH1.SIGNAGE_CLASSIFICATION_ID = IS1.CLASSIFICATION_ID AND CH1.CLASSIFICATION_ROOT_ID = :B6 ) ) ) AND (SR.USER_ID = :B1 OR EXISTS(SELECT 1 FROM WORKGROUP W1 , WORKGROUP W2 , WORKGROUP_HIER WH , USER_WORKGROUP UW WHERE SR.WORKGROUP_ID = W1.WORKGROUP_ID AND AP.WORKGROUP_ROOT_ID = WH.WORKGROUP_ROOT_ID AND ( (AP.ANIMS_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W1.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W2.WORKGROUP_ID AND UW.USER_ID = :B1 AN D UW.WORKGROUP_ID = W2.WORKGROUP_ID) OR (AP.SIGNAGEREN_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W2.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W1.WORKGROUP_ID AND UW.USER_ID = :B1 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID) ) ) OR EXISTS(SELECT 1 FROM WORKGROUP W3 , USER_WORKGROUP UW2 WHERE SR.WORKGROUP_ID = W3.WORKGROUP_ID AND UW2.USER_ID = :B1 AND UW2.WORKGROUP_ID = W3.WORKGROUP_ID ) )

fjjm50t7tnub4

BEGIN :1 := ANYDBA.VISIBILITYPACKAGE_1.BOOKINGFILTER1( 3063961, 162, 4480, 'ViewBook' ); END;

fn35nnycmjvq1

INSERT INTO temp_lookup_pks(session_id, search_id, object_no, user_id, sequence_no, n1) SELECT :1, :2, :3, :4, rownum, "BOOKING" FROM ( SELECT DISTINCT t1."BOOKING", t6."CLASSIFICATION" FROM g_booking_32 t1 INNER JOIN g_insertion_set_24 t2 ON t1."BOOKING" = t2."BOOKING" INNER JOIN g_insertion_26 t3 ON t2."BOOKING" = t3."BOOKING" AND t2."INSERTION_SET" = t3."INSERTION_SET" INNER JOIN g_pagination_type_9 t4 ON t3."PAGINATION_TYPE_ID" = t4."PAGINATION_TYPE_ID" INNER JOIN g_users_22 t5 ON t1."SALES_REP_USER_ID" = t5."USER_ID" INNER JOIN g_classification_8 t6 ON t3."BOOKED_CLASSIFICATION_ID" = t6."CLASSIFICATION_ID" WHERE t3."ISSUE_DATE" >= :5 AND t3."ISSUE_DATE" <= :6 AND t1."BOOKING_CANCELLED" = :7 AND t1."BOOKING_INCOMPLETE" = :8 AND lower(t4."PAGINATION_TYPE") = :9 AND lower(t5."DEPARTMENT") = :10 GROUP BY t1."BOOKING", t6."CLASSIFICATION" ORDER BY min(lower(t6."CLASSIFICATION")) NULLS FIRST )

fy82wkbv7q06n

SELECT PL.N1 FROM PAGED_LOOKUP_PKS PL WHERE PL.SESSION_ID = :B2 AND PL.SEARCH_ID = :B1 AND NOT EXISTS ( SELECT 1 FROM SALES_REP SR , ACCESS_POLICY AP , ACCESS_POLICY_RULE APR , PRIVILEGE PRIV , ACCOUNT_CONTRACT AC WHERE PL.N1 = AC.CONTRACT_ID AND ( SR.ACCOUNT_ID = AC.ACCOUNT_ID OR EXISTS( SELECT 1 FROM TMP_VISIBILITYPKG_ACC_HIER_1 AH WHERE AH.SIGNAGE_ACCOUNT_ID = AC.ACCOUNT_ID AND AH.ANIM_ACCOUNT_ID = SR.ACCOUNT_ID ) ) AND NVL(SR.SALES_REP_START_DATE, SYSDATE) <= SYSDATE AND NVL(SR.SALES_REP_END_DATE, SYSDATE) >= SYSDATE AND SR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.PRIVILEGE_ID = PRIV.PRIVILEGE_ID AND UPPER(PRIV.PRIVILEGE_CODE) = :B4 AND ( APR.PUBLICATION_ID IS NULL OR AC.PUBLICATION_ID IS NULL OR APR.PUBLICATION_ID = AC.PUBLICATION_ID OR EXISTS( SELECT 1 FROM PUBLICATION_HIER PH WHERE APR.PUBLICATION_ID = PH.ANIM_PUBLICATION_ID AND PH.SIGNAGE_PUBLICATION_ID = AC.PUBLICATION_ID AND PH.PUBLICATION_ROOT_ID = :B5 ) ) AND ( APR.CLASSIFICATION_ID IS NULL OR AC.CLASSIFICATION_ID IS NULL OR APR.CLASSIFICATION_ID = AC.CLASSIFICATION_ID OR EXISTS( SELECT 1 FROM CLASSIFICATION_HIER CH WHERE APR.CLASSIFICATION_ID = CH.ANIM_CLASSIFICATION_ID AND CH.SIGNAGE_CLASSIFICATION_ID = AC.CLASSIFICATION_ID AND CH.CLASSIFICATION_ROOT_ID = :B6 ) ) AND ( SR.USER_ID = :B3 OR EXISTS( SELECT 1 FROM WORKGROUP W1 , WORKGROUP W2 , WORKGROUP_HIER WH , USER_WORKGROUP UW WHERE SR.WORKGROUP_ID = W1.WORKGROUP_ID AND AP.WORKGROUP_ROOT_ID = WH.WO RKGROUP_ROOT_ID AND ( ( AP.ANIMS_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W1.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W2.WORKGROUP_ID AND UW.USER_ID = :B3 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID ) OR ( AP.SIGNAGEREN_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W2.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W1.WORKGROUP_ID AND UW.USER_ID = :B3 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID ) ) ) OR EXISTS( SELECT 1 FROM WORKGROUP W3 , USER_WORKGROUP UW2 WHERE SR.WORKGROUP_ID = W3.WORKGROUP_ID AND UW2.USER_ID = :B3 AND UW2.WORKGROUP_ID = W3.WORKGROUP_ID ) ) ) AND NOT EXISTS ( SELECT 1 FROM SALES_REP SR , ACCESS_POLICY AP , ACCESS_POLICY_RULE APR , PRIVILEGE PRIV , ACCOUNT_CONTRACT AC WHERE PL.N1 = AC.CONTRACT_ID AND SR.ACCOUNT_ID IS NULL AND NVL(SR.SALES_REP_START_DATE, SYSDATE) <= SYSDATE AND NVL(SR.SALES_REP_END_DATE, SYSDATE) >= SYSDATE AND SR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.PRIVILEGE_ID = PRIV.PRIVILEGE_ID AND UPPER(PRIV.PRIVILEGE_CODE) = :B4 AND APR.BLOCKABLE = 0 AND ( APR.PUBLICATION_ID IS NULL OR AC.PUBLICATION_ID IS NULL OR APR.PUBLICATION_ID = AC.PUBLICATION_ID OR EXISTS( SELECT 1 FROM PUBLICATION_HIER PH WHERE APR.PUBLICATION_ID = PH.ANIM_PUBLICATION_ID AND PH.SIGNAGE_PUBLICATION_ID = AC.PUBLICATION_ID AND PH.PUBLICATION_ROOT_ID = :B5 ) ) AND ( APR.CLASSIFICATION_ID IS NULL OR AC.CLASSIFICATION_ID IS NULL OR APR.CLASSIFICATION_ID = AC.CLASSIFICATION_ID OR EXISTS( SELECT 1 FROM CLASSIFICATION_HIER CH WHERE APR.C LASSIFICATION_ID = CH.ANIM_CLASSIFICATION_ID AND CH.SIGNAGE_CLASSIFICATION_ID = AC.CLASSIFICATION_ID AND CH.CLASSIFICATION_ROOT_ID = :B6 ) ) AND ( SR.USER_ID = :B3 OR EXISTS( SELECT 1 FROM WORKGROUP W1 , WORKGROUP W2 , WORKGROUP_HIER WH , USER_WORKGROUP UW WHERE SR.WORKGROUP_ID = W1.WORKGROUP_ID AND AP.WORKGROUP_ROOT_ID = WH.WORKGROUP_ROOT_ID AND ( ( AP.ANIMS_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W1.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W2.WORKGROUP_ID AND UW.USER_ID = :B3 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID ) OR ( AP.SIGNAGEREN_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W2.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W1.WORKGROUP_ID AND UW.USER_ID = :B3 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID ) ) ) OR EXISTS( SELECT 1 FROM WORKGROUP W3 , USER_WORKGROUP UW2 WHERE SR.WORKGROUP_ID = W3.WORKGROUP_ID AND UW2.USER_ID = :B3 AND UW2.WORKGROUP_ID = W3.WORKGROUP_ID ) ) ) AND NOT EXISTS ( SELECT 1 FROM SALES_REP SR , ACCESS_POLICY AP , ACCESS_POLICY_RULE APR , PRIVILEGE PRIV , ACCOUNT_CONTRACT AC WHERE PL.N1 = AC.CONTRACT_ID AND SR.ACCOUNT_ID IS NULL AND NVL(SR.SALES_REP_START_DATE, SYSDATE) <= SYSDATE AND NVL(SR.SALES_REP_END_DATE, SYSDATE) >= SYSDATE AND SR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.ACCESS_POLICY_ID = AP.ACCESS_POLICY_ID AND APR.PRIVILEGE_ID = PRIV.PRIVILEGE_ID AND UPPER(PRIV.PRIVILEGE_CODE) = :B4 AND APR.BLOCKABLE = 1 AND ( APR.PUBLICATION_ID IS NULL OR AC.PUBLICATION_ID IS NULL OR APR.PUBLICATION_ID = AC.PUBLICATION_ID OR EXISTS( SELECT 1 FROM PUB LICATION_HIER PH WHERE APR.PUBLICATION_ID = PH.ANIM_PUBLICATION_ID AND PH.SIGNAGE_PUBLICATION_ID = AC.PUBLICATION_ID AND PH.PUBLICATION_ROOT_ID = :B5 ) ) AND ( APR.CLASSIFICATION_ID IS NULL OR AC.CLASSIFICATION_ID IS NULL OR APR.CLASSIFICATION_ID = AC.CLASSIFICATION_ID OR EXISTS( SELECT 1 FROM CLASSIFICATION_HIER CH WHERE APR.CLASSIFICATION_ID = CH.ANIM_CLASSIFICATION_ID AND CH.SIGNAGE_CLASSIFICATION_ID = AC.CLASSIFICATION_ID AND CH.CLASSIFICATION_ROOT_ID = :B6 ) ) AND ( SR.USER_ID = :B3 OR EXISTS( SELECT 1 FROM WORKGROUP W1 , WORKGROUP W2 , WORKGROUP_HIER WH , USER_WORKGROUP UW WHERE SR.WORKGROUP_ID = W1.WORKGROUP_ID AND AP.WORKGROUP_ROOT_ID = WH.WORKGROUP_ROOT_ID AND ( ( AP.ANIMS_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W1.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W2.WORKGROUP_ID AND UW.USER_ID = :B3 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID ) OR ( AP.SIGNAGEREN_INHERIT = 1 AND WH.SIGNAGE_WORKGROUP_ID = W2.WORKGROUP_ID AND WH.ANIM_WORKGROUP_ID = W1.WORKGROUP_ID AND UW.USER_ID = :B3 AND UW.WORKGROUP_ID = W2.WORKGROUP_ID ) ) ) OR EXISTS( SELECT 1 FROM WORKGROUP W3 , USER_WORKGROUP UW2 WHERE SR.WORKGROUP_ID = W3.WORKGROUP_ID AND UW2.USER_ID = :B3 AND UW2.WORKGROUP_ID = W3.WORKGROUP_ID ) ) AND NOT EXISTS ( SELECT 1 FROM SALES_REP SR2 , ACCESS_POLICY AP2 , ACCESS_POLICY_RULE APR2 , PRIVILEGE PRIV2 , ACCOUNT_CONTRACT AC2 WHERE PL.N1 = AC2.CONTRACT_ID AND ( SR2.ACCOUNT_ID = AC2.ACCOUNT_ID OR EXISTS( SELECT 1 FROM TMP_VISIBILITYPKG_ACC_HIER_1 AH2 WHERE AH2.SIGNAGE_ACCOUNT_ID = A C2.ACCOUNT_ID AND AH2.ANIM_ACCOUNT_ID = SR2.ACCOUNT_ID ) ) AND NVL(SR2.SALES_REP_START_DATE, SYSDATE) <= SYSDATE AND NVL(SR2.SALES_REP_END_DATE, SYSDATE) >= SYSDATE AND SR2.ACCESS_POLICY_ID = AP2.ACCESS_POLICY_ID AND APR2.ACCESS_POLICY_ID = AP2.ACCESS_POLICY_ID AND APR2.PRIVILEGE_ID = PRIV2.PRIVILEGE_ID AND UPPER(PRIV2.PRIVILEGE_CODE) = :B4 AND APR2.BLOCKING = 1 AND ( APR2.PUBLICATION_ID IS NULL OR AC2.PUBLICATION_ID IS NULL OR APR2.PUBLICATION_ID = AC2.PUBLICATION_ID OR EXISTS( SELECT 1 FROM PUBLICATION_HIER PH2 WHERE APR2.PUBLICATION_ID = PH2.ANIM_PUBLICATION_ID AND PH2.SIGNAGE_PUBLICATION_ID = AC2.PUBLICATION_ID AND PH2.PUBLICATION_ROOT_ID = :B5 ) ) AND ( APR2.CLASSIFICATION_ID IS NULL OR AC2.CLASSIFICATION_ID IS NULL OR APR2.CLASSIFICATION_ID = AC2.CLASSIFICATION_ID OR EXISTS( SELECT 1 FROM CLASSIFICATION_HIER CH2 WHERE APR2.CLASSIFICATION_ID = CH2.ANIM_CLASSIFICATION_ID AND CH2.SIGNAGE_CLASSIFICATION_ID = AC2.CLASSIFICATION_ID AND CH2.CLASSIFICATION_ROOT_ID = :B6 ) ) AND AC.ACCOUNT_CONTRACT_ID = AC2.ACCOUNT_CONTRACT_ID AND AC.ACCOUNT_ID = AC2.ACCOUNT_ID ) )

gbw8su85csq81

delete from temp_lookup_pks

grwydz59pu6mc

select text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic

Total

per Second

per Trans

CPU used by this session

135,657

37.62

6.65

CPU used when call started

134,722

37.36

6.60

CR blocks created

750

0.21

0.04

Cached Commit SCN referenced

1,296

0.36

0.06

Commit SCN cached

2

0.00

0.00

DB time

741,843

205.73

36.36

DBWR checkpoint buffers written

4,854

1.35

0.24

DBWR checkpoints

3

0.00

0.00

DBWR object drop buffers written

0

0.00

0.00

DBWR revisited being-written buffer

0

0.00

0.00

DBWR tablespace checkpoint buffers written

0

0.00

0.00

DBWR thread checkpoint buffers written

0

0.00

0.00

DBWR transaction table writes

120

0.03

0.01

DBWR undo block writes

8,424

2.34

0.41

IMU CR rollbacks

75

0.02

0.00

IMU Flushes

14,296

3.96

0.70

IMU Redo allocation size

26,973,516

7,480.37

1,322.23

IMU commits

3,231

0.90

0.16

IMU contention

6

0.00

0.00

IMU ktichg flush

2,231

0.62

0.11

IMU pool not allocated

4,000

1.11

0.20

IMU recursive-transaction flush

0

0.00

0.00

IMU undo allocation size

43,216,272

11,984.86

2,118.44

IMU- failed to get a private strand

4,000

1.11

0.20

Misses for writing mapping

0

0.00

0.00

OS Integral shared text size

0

0.00

0.00

OS Integral unshared data size

0

0.00

0.00

OS Involuntary context switches

0

0.00

0.00

OS Maximum resident set size

0

0.00

0.00

OS Page faults

0

0.00

0.00

OS Page reclaims

0

0.00

0.00

OS System time used

0

0.00

0.00

OS User time used

0

0.00

0.00

OS Voluntary context switches

0

0.00

0.00

SMON posted for undo segment recovery

0

0.00

0.00

SMON posted for undo segment shrink

0

0.00

0.00

SQL*Net roundtrips to/from client

953,362

264.39

46.73

SQL*Net roundtrips to/from dblink

0

0.00

0.00

active txn count during cleanout

1,841

0.51

0.09

application wait time

0

0.00

0.00

background checkpoints completed

3

0.00

0.00

background checkpoints started

3

0.00

0.00

background timeouts

12,863

3.57

0.63

branch node splits

14

0.00

0.00

buffer is not pinned count

108,769,397

30,164.24

5,331.83

buffer is pinned count

71,410,869

19,803.86

3,500.53

bytes received via SQL*Net from client

241,298,283

66,917.52

11,828.35

bytes received via SQL*Net from dblink

0

0.00

0.00

bytes sent via SQL*Net to client

521,522,521

144,630.09

25,564.83

bytes sent via SQL*Net to dblink

0

0.00

0.00

calls to get snapshot scn: kcmgss

814,263

225.81

39.91

calls to kcmgas

37,959

10.53

1.86

calls to kcmgcs

2,730

0.76

0.13

change write time

395

0.11

0.02

cleanout - number of ktugct calls

24,214

6.72

1.19

cleanouts and rollbacks - consistent read gets

281

0.08

0.01

cleanouts only - consistent read gets

16,090

4.46

0.79

cluster key scan block gets

30,445

8.44

1.49

cluster key scans

10,009

2.78

0.49

commit batch performed

0

0.00

0.00

commit batch requested

0

0.00

0.00

commit batch/immediate performed

2

0.00

0.00

commit batch/immediate requested

2

0.00

0.00

commit cleanout failures: block lost

31,483

8.73

1.54

commit cleanout failures: buffer being written

1

0.00

0.00

commit cleanout failures: callback failure

22

0.01

0.00

commit cleanout failures: cannot pin

3

0.00

0.00

commit cleanouts

74,809

20.75

3.67

commit cleanouts successfully completed

43,300

12.01

2.12

commit immediate performed

2

0.00

0.00

commit immediate requested

2

0.00

0.00

commit txn count during cleanout

29,309

8.13

1.44

concurrency wait time

45

0.01

0.00

consistent changes

264,198

73.27

12.95

consistent gets

110,833,081

30,736.54

5,432.99

consistent gets - examination

31,666,195

8,781.76

1,552.26

consistent gets direct

2,600

0.72

0.13

consistent gets from cache

110,830,483

30,735.82

5,432.87

current blocks converted for CR

3

0.00

0.00

cursor authentications

3,982

1.10

0.20

data blocks consistent reads - undo records applied

1,642

0.46

0.08

db block changes

717,406

198.95

35.17

db block gets

543,452

150.71

26.64

db block gets direct

717

0.20

0.04

db block gets from cache

542,735

150.51

26.60

deferred (CURRENT) block cleanout applications

23,110

6.41

1.13

dirty buffers inspected

12,018

3.33

0.59

enqueue conversions

4,308

1.19

0.21

enqueue releases

165,414

45.87

8.11

enqueue requests

165,416

45.87

8.11

enqueue timeouts

2

0.00

0.00

enqueue waits

4

0.00

0.00

exchange deadlocks

0

0.00

0.00

execute count

509,367

141.26

24.97

failed probes on index block reclamation

67

0.02

0.00

frame signature mismatch

0

0.00

0.00

free buffer inspected

1,623,933

450.35

79.60

free buffer requested

1,496,066

414.89

73.34

heap block compress

2,223

0.62

0.11

hot buffers moved to head of LRU

803,103

222.72

39.37

immediate (CR) block cleanout applications

16,371

4.54

0.80

immediate (CURRENT) block cleanout applications

13,273

3.68

0.65

index crx upgrade (found)

0

0.00

0.00

index crx upgrade (positioned)

72,793

20.19

3.57

index fast full scans (full)

659

0.18

0.03

index fetch by key

21,137,994

5,862.05

1,036.18

index scans kdiixs1

21,744,472

6,030.24

1,065.91

leaf node 90-10 splits

170

0.05

0.01

leaf node splits

298

0.08

0.01

lob reads

11,973

3.32

0.59

lob writes

2,036

0.56

0.10

lob writes unaligned

2,036

0.56

0.10

logons cumulative

449

0.12

0.02

messages received

23,583

6.54

1.16

messages sent

23,583

6.54

1.16

no buffer to keep pinned count

0

0.00

0.00

no work - consistent read gets

78,791,644

21,850.72

3,862.34

opened cursors cumulative

404,267

112.11

19.82

parse count (failures)

0

0.00

0.00

parse count (hard)

8,695

2.41

0.43

parse count (total)

396,235

109.89

19.42

parse time cpu

7,573

2.10

0.37

parse time elapsed

12,889

3.57

0.63

physical read IO requests

870,148

241.31

42.65

physical read bytes

12,096,839,680

3,354,729.62

592,982.34

physical read total IO requests

893,746

247.86

43.81

physical read total bytes

12,898,439,680

3,577,031.59

632,276.45

physical read total multi block requests

65,034

18.04

3.19

physical reads

1,476,665

409.51

72.39

physical reads cache

1,473,228

408.56

72.22

physical reads cache prefetch

606,777

168.27

29.74

physical reads direct

3,437

0.95

0.17

physical reads direct (lob)

2,343

0.65

0.11

physical reads direct temporary tablespace

765

0.21

0.04

physical reads prefetch warmup

0

0.00

0.00

physical write IO requests

14,713

4.08

0.72

physical write bytes

199,008,256

55,189.53

9,755.31

physical write total IO requests

41,654

11.55

2.04

physical write total bytes

584,046,592

161,969.44

28,629.73

physical write total multi block requests

22,492

6.24

1.10

physical writes

24,293

6.74

1.19

physical writes direct

1,554

0.43

0.08

physical writes direct (lob)

708

0.20

0.03

physical writes direct temporary tablespace

765

0.21

0.04

physical writes from cache

22,739

6.31

1.11

physical writes non checkpoint

21,126

5.86

1.04

pinned buffers inspected

8,679

2.41

0.43

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

491

0.14

0.02

process last non-idle time

3,605

1.00

0.18

recursive aborts on index block reclamation

0

0.00

0.00

recursive calls

837,300

232.20

41.04

recursive cpu usage

62,894

17.44

3.08

redo blocks written

237,031

65.73

11.62

redo buffer allocation retries

6

0.00

0.00

redo entries

331,790

92.01

16.26

redo log space requests

6

0.00

0.00

redo log space wait time

12

0.00

0.00

redo ordering marks

8,239

2.28

0.40

redo size

111,019,996

30,788.38

5,442.16

redo subscn max counts

11,300

3.13

0.55

redo synch time

5,981

1.66

0.29

redo synch writes

21,993

6.10

1.08

redo wastage

6,352,232

1,761.62

311.38

redo write time

5,539

1.54

0.27

redo writer latching time

1

0.00

0.00

redo writes

21,584

5.99

1.06

rollback changes - undo records applied

298

0.08

0.01

rollbacks only - consistent read gets

469

0.13

0.02

rows fetched via callback

16,640,146

4,614.69

815.69

session connect time

0

0.00

0.00

session cursor cache hits

250,577

69.49

12.28

session logical reads

111,376,336

30,887.20

5,459.62

session pga memory

9,304,952

2,580.48

456.13

session pga memory max

24,002,072

6,656.32

1,176.57

session uga memory

8,601,491,712

2,385,389.89

421,641.75

session uga memory max

874,825,328

242,609.02

42,883.59

shared hash latch upgrades - no wait

139,180

38.60

6.82

shared hash latch upgrades - wait

0

0.00

0.00

sorts (disk)

0

0.00

0.00

sorts (memory)

4,019,967

1,114.83

197.06

sorts (rows)

12,759,655

3,538.54

625.47

sql area evicted

8,383

2.32

0.41

sql area purged

0

0.00

0.00

summed dirty queue length

12,545

3.48

0.61

switch current to new buffer

5,293

1.47

0.26

table fetch by rowid

65,945,234

18,288.12

3,232.61

table fetch continued row

314,182

87.13

15.40

table scan blocks gotten

4,121,877

1,143.09

202.05

table scan rows gotten

176,593,807

48,973.49

8,656.56

table scans (cache partitions)

0

0.00

0.00

table scans (long tables)

55

0.02

0.00

table scans (short tables)

106,927

29.65

5.24

total number of times SMON posted

3,239

0.90

0.16

transaction rollbacks

2

0.00

0.00

transaction tables consistent read rollbacks

0

0.00

0.00

transaction tables consistent reads - undo records applied

0

0.00

0.00

undo change vector size

62,754,464

17,403.24

3,076.20

user I/O wait time

193,713

53.72

9.50

user calls

1,034,260

286.82

50.70

user commits

20,310

5.63

1.00

user rollbacks

90

0.02

0.00

workarea executions - multipass

0

0.00

0.00

workarea executions - onepass

4

0.00

0.00

workarea executions - optimal

407,715

113.07

19.99

write clones created in background

0

0.00

0.00

write clones created in foreground

2

0.00

0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic

Begin Value

End Value

session cursor cache count

13,309,824

13,315,875

opened cursors current

1,017

1,007

workarea memory allocated

4,163

2,191

logons current

71

72

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic

Total

per Hour

log switches (derived)

3

3.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

Tablespace

Reads

Av Reads/s

Av Rd(ms)

Av Blks/Rd

Writes

Av Writes/s

Buffer Waits

Av Buf Wt(ms)

GENDATA_T

576,562

160

2.08

1.27

2,333

1

24

3.33

GEN_INSERTION_T

135,313

38

1.30

1.88

394

0

73,067

1.12

GENINDX_I

83,969

23

2.56

1.67

6,300

2

5,319

2.24

GEN_INSERTION_SET_T

25,725

7

3.92

1.26

436

0

199

2.41

GEN_CONTENT_T

15,257

4

3.38

10.87

274

0

0

0.00

SYSTEM

14,285

4

3.60

1.21

247

0

3

3.33

GEN_ACCOUNT_T

10,863

3

2.83

11.83

66

0

0

0.00

GENLOB_T

2,996

1

5.72

1.01

1,100

0

0

0.00

SYSAUX

2,088

1

4.46

1.96

389

0

0

0.00

CMI_T

1,757

0

5.09

3.52

478

0

0

0.00

UNDOTBS1

91

0

3.63

1.00

1,691

0

2

0.00

GEN_BOOKING_T

942

0

3.44

1.01

552

0

0

0.00

TEMP

259

0

2.12

3.79

413

0

0

0.00

DRS_T

261

0

4.98

4.72

3

0

0

0.00

USERS

138

0

9.28

1.12

48

0

0

0.00

CSDTA

90

0

5.89

1.22

3

0

0

0.00

GEN_INSTANCE_T

66

0

6.97

1.00

3

0

0

0.00

CSIDX

20

0

8.50

1.00

3

0

0

0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace

Filename

Reads

Av Reads/s

Av Rd(ms)

Av Blks/Rd

Writes

Av Writes/s

Buffer Waits

Av Buf Wt(ms)

CMI_T

/ora01/oradata/SNCLR1/SNCLR1_cmi_t01.dbf

1,757

0

5.09

3.52

478

0

0

0.00

CSDTA

/ora01/oradata/SNCLR1/SNCLR1_csdta01.dbf

90

0

5.89

1.22

3

0

0

0.00

CSIDX

/ora01/oradata/SNCLR1/SNCLR1_csidx01.dbf

20

0

8.50

1.00

3

0

0

0.00

DRS_T

/ora01/oradata/SNCLR1/SNCLR1_drs_t01.dbf

261

0

4.98

4.72

3

0

0

0.00

GENDATA_T

/ora01/oradata/SNCLR1/SNCLR1_gendata_t01.dbf

296,941

82

2.06

1.26

1,305

0

13

3.08

GENDATA_T

/ora01/oradata/SNCLR1/SNCLR1_gendata_t02.dbf

279,621

78

2.09

1.27

1,028

0

11

3.64

GENINDX_I

/ora01/oradata/SNCLR1/SNCLR1_genindx_i01.dbf

83,969

23

2.56

1.67

6,300

2

5,319

2.24

GENLOB_T

/ora01/oradata/SNCLR1/SNCLR1_genlob_t01.dbf

590

0

4.78

1.00

159

0

0

0.00

GENLOB_T

/ora01/oradata/SNCLR1/SNCLR1_genlob_t02.dbf

629

0

5.34

1.03

622

0

0

0.00

GENLOB_T

/ora01/oradata/SNCLR1/SNCLR1_genlob_t03.dbf

953

0

5.84

1.00

151

0

0

0.00

GENLOB_T

/ora01/oradata/SNCLR1/SNCLR1_genlob_t04.dbf

824

0

6.53

1.00

168

0

0

0.00

GEN_ACCOUNT_T

/ora01/oradata/SNCLR1/SNCLR1_gen_account_t01.dbf

10,863

3

2.83

11.83

66

0

0

0.00

GEN_BOOKING_T

/ora01/oradata/SNCLR1/SNCLR1_gen_booking_t01.dbf

804

0

3.32

1.01

446

0

0

0.00

GEN_BOOKING_T

/ora01/oradata/SNCLR1/SNCLR1_gen_booking_t02.dbf

138

0

4.13

1.00

106

0

0

0.00

GEN_CONTENT_T

/ora01/oradata/SNCLR1/SNCLR1_gen_content_t01.dbf

9,618

3

3.21

11.30

156

0

0

0.00

GEN_CONTENT_T

/ora01/oradata/SNCLR1/SNCLR1_gen_content_t02.dbf

5,639

2

3.68

10.15

118

0

0

0.00

GEN_INSERTION_SET_T

/ora01/oradata/SNCLR1/SNCLR1_gen_insertion_set_t01.d

25,725

7

3.92

1.26

436

0

199

2.41

GEN_INSERTION_T

/ora01/oradata/SNCLR1/SNCLR1_gen_insertion_t01.dbf

135,313

38

1.30

1.88

394

0

73,067

1.12

GEN_INSTANCE_T

/ora01/oradata/SNCLR1/SNCLR1_gen_instance_t01.dbf

66

0

6.97

1.00

3

0

0

0.00

SYSAUX

/ora01/oradata/SNCLR1/sysaux01.dbf

2,088

1

4.46

1.96

389

0

0

0.00

SYSTEM

/ora01/oradata/SNCLR1/system01.dbf

14,285

4

3.60

1.21

247

0

3

3.33

TEMP

/ora01/oradata/SNCLR1/temp01.dbf

259

0

2.12

3.79

413

0

0

 

UNDOTBS1

/ora01/oradata/SNCLR1/undotbs01.dbf

66

0

2.12

1.00

1,198

0

2

0.00

UNDOTBS1

/ora01/oradata/SNCLR1/undotbs02.dbf

25

0

7.60

1.00

493

0

0

0.00

USERS

/ora01/oradata/SNCLR1/users01.dbf

138

0

9.28

1.12

48

0

0

0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

P

Number of Buffers

Pool Hit%

Buffer Gets

Physical Reads

Physical Writes

Free Buff Wait

Writ Comp Wait

Buffer Busy Waits

D

83,708

99

111,281,415

1,474,024

22,834

0

0

78,701


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

 

Targt MTTR (s)

Estd MTTR (s)

Recovery Estd IOs

Actual Redo Blks

Target Redo Blks

Log File Size Redo Blks

Log Ckpt Timeout Redo Blks

Log Ckpt Interval Redo Blks

B

0

18

666

24754

168766

552960

168766

 

E

0

18

1279

16501

106126

552960

106126

 

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

P

Size for Est (M)

Size Factor

Buffers for Estimate

Est Phys Read Factor

Estimated Physical Reads

D

64

0.09

7,916

1.72

2,918,193,733

D

128

0.18

15,832

1.61

2,738,618,971

D

192

0.27

23,748

1.51

2,559,739,580

D

256

0.36

31,664

1.44

2,445,059,343

D

320

0.44

39,580

1.37

2,330,682,754

D

384

0.53

47,496

1.31

2,216,550,067

D

448

0.62

55,412

1.25

2,114,427,438

D

512

0.71

63,328

1.19

2,012,301,167

D

576

0.80

71,244

1.13

1,910,184,444

D

640

0.89

79,160

1.07

1,814,969,419

D

704

0.98

87,076

1.01

1,719,742,665

D

720

1.00

89,055

1.00

1,695,932,475

D

768

1.07

94,992

0.96

1,624,502,287

D

832

1.16

102,908

0.91

1,537,213,474

D

896

1.24

110,824

0.85

1,449,904,367

D

960

1.33

118,740

0.80

1,362,643,817

D

1,024

1.42

126,656

0.75

1,275,400,582

D

1,088

1.51

134,572

0.70

1,188,177,250

D

1,152

1.60

142,488

0.65

1,100,958,289

D

1,216

1.69

150,404

0.60

1,013,719,383

D

1,280

1.78

158,320

0.55

926,490,216

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %

W/A MB Processed

Extra W/A MB Read/Written

99.63

6,060

23

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

 

PGA Aggr Target(M)

Auto PGA Target(M)

PGA Mem Alloc(M)

W/A PGA Used(M)

%PGA W/A Mem

%Auto W/A Mem

%Man W/A Mem

Global Mem Bound(K)

B

682

459

366.62

3.40

0.93

100.00

0.00

102,400

E

682

454

380.44

2.14

0.56

100.00

0.00

102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal

High Optimal

Total Execs

Optimal Execs

1-Pass Execs

M-Pass Execs

2K

4K

402,172

402,172

0

0

64K

128K

490

490

0

0

128K

256K

515

515

0

0

256K

512K

90

90

0

0

512K

1024K

2,689

2,689

0

0

1M

2M

1,355

1,355

0

0

2M

4M

370

368

2

0

4M

8M

23

23

0

0

8M

16M

2

0

2

0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)

Size Factr

W/A MB Processed

Estd Extra W/A MB Read/ Written to Disk

Estd PGA Cache Hit %

Estd PGA Overalloc Count

85

0.13

7,732,577.08

20,444.67

100.00

1,407

171

0.25

7,732,577.08

5,570.30

100.00

263

341

0.50

7,732,577.08

513.25

100.00

0

512

0.75

7,732,577.08

120.31

100.00

0

682

1.00

7,732,577.08

120.31

100.00

0

818

1.20

7,732,577.08

0.00

100.00

0

955

1.40

7,732,577.08

0.00

100.00

0

1,091

1.60

7,732,577.08

0.00

100.00

0

1,228

1.80

7,732,577.08

0.00

100.00

0

1,364

2.00

7,732,577.08

0.00

100.00

0

2,046

3.00

7,732,577.08

0.00

100.00

0

2,728

4.00

7,732,577.08

0.00

100.00

0

4,092

6.00

7,732,577.08

0.00

100.00

0

5,456

8.00

7,732,577.08

0.00

100.00

0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

160

0.22

87

5,331

121,830,901

0.88

16,221,508

45.87

1,131,898,940

240

0.33

165

10,652

124,104,684

0.90

13,947,725

39.44

1,132,682,250

320

0.44

244

14,626

126,377,581

0.92

11,674,828

33.01

1,133,464,930

400

0.56

323

18,900

128,647,468

0.93

9,404,941

26.59

1,134,246,786

480

0.67

402

22,612

130,914,185

0.95

7,138,224

20.18

1,135,027,633

560

0.78

480

26,281

133,178,105

0.97

4,874,304

13.78

1,135,807,603

640

0.89

559

29,941

135,440,156

0.98

2,612,253

7.39

1,136,586,557

720

1.00

638

34,087

137,698,740

1.00

353,669

1.00

1,137,364,680

800

1.11

717

37,861

139,953,708

1.02

1

0.00

1,138,141,956

880

1.22

796

43,875

142,206,195

1.03

1

0.00

1,138,918,368

960

1.33

875

49,333

144,456,520

1.05

1

0.00

1,139,694,063

1,040

1.44

954

52,403

146,704,977

1.07

1

0.00

1,140,469,176

1,120

1.56

1,033

57,543

148,951,841

1.08

1

0.00

1,141,243,795

1,200

1.67

1,112

61,621

151,197,375

1.10

1

0.00

1,142,018,034

1,280

1.78

1,191

66,218

153,441,837

1.11

1

0.00

1,142,791,959

1,360

1.89

1,270

70,260

155,685,493

1.13

1

0.00

1,143,565,666

1,440

2.00

1,349

74,951

157,928,617

1.15

1

0.00

1,144,339,233

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)

SGA Size Factor

Est DB Time (s)

Est Physical Reads

752

0.50

13,996,262

2,877,811,046

1,128

0.75

7,159,686

2,298,483,889

1,504

1.00

4,836,972

1,695,922,592

1,880

1.25

2,787,547

1,257,696,194

2,256

1.50

2,646,791

913,593,500

2,632

1.75

2,646,791

913,593,500

3,008

2.00

2,646,791

913,593,500

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)

Size Factor

Est Spill Count

Est Spill Time (s)

Est Unspill Count

Est Unspill Time (s)

16

1.00

0

0

0

0

32

2.00

0

0

0

0

48

3.00

0

0

0

0

64

4.00

0

0

0

0

80

5.00

0

0

0

0

96

6.00

0

0

0

0

112

7.00

0

0

0

0

128

8.00

0

0

0

0

144

9.00

0

0

0

0

160

10.00

0

0

0

0

176

11.00

0

0

0

0

192

12.00

0

0

0

0

208

13.00

0

0

0

0

224

14.00

0

0

0

0

240

15.00

0

0

0

0

256

16.00

0

0

0

0

272

17.00

0

0

0

0

288

18.00

0

0

0

0

304

19.00

0

0

0

0

320

20.00

0

0

0

0

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

Back to Top

Buffer Wait Statistics

Class

Waits

Total Wait Time (s)

Avg Time (ms)

data block

78,642

95

1

segment header

7

0

4

1st level bmb

1

0

10

undo header

2

0

0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)

Requests

Succ Gets

Failed Gets

Waits

Wt Time (s)

Av Wt Time(ms)

TX-Transaction (index contention)

4

4

0

4

0

14.50

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

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

1

10.37

27,337

1,490

4

1440/1440

0/0

0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

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

23-Feb 13:00

1,067

3,814

0

4

1,440

0/0

0/0/0/0/0/0

23-Feb 12:50

1,345

3,495

0

4

1,440

0/0

0/0/0/0/0/0

23-Feb 12:40

1,295

3,576

1,490

4

1,440

0/0

0/0/0/0/0/0

23-Feb 12:30

1,386

4,321

889

3

1,440

0/0

0/0/0/0/0/0

23-Feb 12:20

1,820

3,550

289

3

1,440

0/0

0/0/0/0/0/0

23-Feb 12:10

1,339

4,216

0

3

1,440

0/0

0/0/0/0/0/0

23-Feb 12:00

2,121

4,365

0

4

1,440

0/0

0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch Name

Get Requests

Pct Get Miss

Avg Slps /Miss

Wait Time (s)

NoWait Requests

Pct NoWait Miss

ASM db client latch

2,403

0.00

 

0

0

 

AWR Alerted Metric Element list

15,842

0.00

 

0

0

 

Consistent RBA

21,573

0.00

 

0

0

 

DMON Work Queues Latch

780

0.00

 

0

0

 

FAL request queue

93

0.00

 

0

0

 

FAL subheap alocation

90

0.00

 

0

0

 

FIB s.o chain latch

1,730

0.00

 

0

0

 

FOB s.o list latch

6,151

0.00

 

0

0

 

Fast-Start Failover State Latch

240

0.00

 

0

0

 

In memory undo latch

86,658

0.00

0.00

0

23,649

0.00

JS mem alloc latch

5

0.00

 

0

0

 

JS queue access latch

5

0.00

 

0

0

 

JS queue state obj latch

26,062

0.00

 

0

0

 

JS slv state obj latch

16

0.00

 

0

0

 

KMG MMAN ready and startup request latch

1,493

0.00

 

0

0

 

KMG resize request state object freelist

63

0.00

 

0

0

 

KTF sga latch

35

0.00

 

0

1,111

0.00

KWQMN job cache list latch

11

0.00

 

0

0

 

KWQP Prop Status

2

0.00

 

0

0

 

MQL Tracking Latch

0

 

 

0

73

0.00

Memory Management Latch

932

0.00

 

0

1,493

0.00

OS process

1,362

0.00

 

0

0

 

OS process allocation

2,110

0.00

 

0

0

 

OS process: request allocation

893

0.00

 

0

0

 

PL/SQL warning settings

7,182

0.00

 

0

0

 

RSM SQL latch

6,240

0.00

 

0

0

 

RSM process latch

240

0.00

 

0

0

 

Request id generation latch

360

0.00

 

0

0

 

Reserved Space Latch

9

0.00

 

0

0

 

SGA IO buffer pool latch

37,222

0.01

0.00

0

37,222

0.01

SQL memory manager latch

1

0.00

 

0

1,200

0.00

SQL memory manager workarea list latch

174,152

0.00

 

0

0

 

Shared B-Tree

137

0.00

 

0

0

 

active checkpoint queue latch

2,103

0.00

 

0

0

 

active service list

13,135

0.00

 

0

1,209

0.00

alert log latch

972

0.00

 

0

0

 

archive control

6,987

0.00

 

0

0

 

archive process latch

1,284

0.00

 

0

0

 

begin backup scn array

710

0.00

 

0

0

 

buffer pool

640

0.00

 

0

0

 

cache buffer handles

1,591,709

0.01

0.00

0

0

 

cache buffers chains

194,104,232

0.58

0.00

0

2,896,419

0.00

cache buffers lru chain

152,999

0.22

0.01

0

2,856,890

0.11

cache table scan latch

0

 

 

0

63,965

0.02

channel handle pool latch

7,787

0.00

 

0

0

 

channel operations parent latch

55,106

0.22

0.00

0

0

 

checkpoint queue latch

83,075

0.02

0.00

0

76,239

0.02

client/application info

5,934

0.00

 

0

0

 

commit callback allocation

5,024

0.00

 

0

0

 

compile environment latch

12,928

0.00

 

0

0

 

dml lock allocation

145,975

0.01

0.00

0

0

 

dummy allocation

897

0.00

 

0

0

 

enqueue hash chains

335,016

0.00

0.00

0

68

0.00

enqueues

148,746

0.00

0.00

0

0

 

event group latch

447

0.00

 

0

0

 

file cache latch

339

0.00

 

0

0

 

global KZLD latch for mem in SGA

431

0.00

 

0

0

 

hash table column usage latch

1,362

0.00

 

0

1,222,333

0.00

hash table modification latch

100

0.00

 

0

0

 

internal temp table object number allocation latc

1

0.00

 

0

0

 

job workq parent latch

0

 

 

0

4

0.00

job_queue_processes parameter latch

62

0.00

 

0

0

 

kks stats

42,074

0.00

 

0

0

 

krbmrosl

38

0.00

 

0

0

 

ksuosstats global area

242

0.00

 

0

0

 

ktm global data

3,237

0.00

 

0

0

 

kwqbsn:qsga

136

0.00

 

0

0

 

lgwr LWN SCN

21,922

0.44

0.00

0

0

 

library cache

1,521,854

0.02

0.01

0

50,791

0.03

library cache load lock

10,102

0.00

 

0

1

0.00

library cache lock

998,713

0.00

0.04

0

0

 

library cache lock allocation

17,460

0.00

 

0

0

 

library cache pin

455,779

0.00

0.13

0

0

 

library cache pin allocation

7,108

0.00

 

0

0

 

list of block allocation

1,420

0.00

 

0

0

 

loader state object freelist

5,208

0.00

 

0

0

 

logminer context allocation

1

0.00

 

0

0

 

longop free list parent

6

0.00

 

0

5

0.00

message pool operations parent latch

9,228

0.02

0.00

0

0

 

messages

96,498

0.04

0.00

0

0

 

mostly latch-free SCN

22,013

0.80

0.00

0

0

 

multiblock read objects

173,089

0.00

0.00

0

0

 

ncodef allocation latch

57

0.00

 

0

0

 

object queue header heap

10,052

0.00

 

0

10,002

0.00

object queue header operation

3,072,228

0.00

0.00

0

53,875

0.03

object stats modification

6,005

0.02

1.00

0

0

 

parallel query alloc buffer

480

0.00

 

0

0

 

parameter list

454

0.00

 

0

0

 

parameter table allocation management

581

0.00

 

0

0

 

post/wait queue

51,087

0.00

 

0

20,400

0.00

process allocation

893

0.00

 

0

447

0.00

process group creation

893

0.00

 

0

0

 

qmn task queue latch

512

0.00

 

0

0

 

redo allocation

109,097

0.00

0.00

0

331,582

0.01

redo copy

0

 

 

0

331,597

0.10

redo writing

69,449

0.00

0.00

0

0

 

reservation so alloc latch

6

0.00

 

0

0

 

resmgr group change latch

1,118

0.00

 

0

0

 

resmgr:actses active list

894

0.00

 

0

0

 

resmgr:actses change group

445

0.00

 

0

0

 

resmgr:free threads list

893

0.00

 

0

0

 

resmgr:schema config

1

0.00

 

0

0

 

row cache objects

5,000,772

0.12

0.00

0

5,363

0.00

rules engine rule set statistics

100

0.00

 

0

0

 

sequence cache

48,615

0.01

0.00

0

0

 

session allocation

350,323

0.00

0.00

0

0

 

session idle bit

2,084,432

0.00

0.01

0

0

 

session state list latch

1,607

0.00

 

0

0

 

session switching

57

0.00

 

0

0

 

session timer

1,209

0.00

 

0

0

 

shared pool

711,381

0.03

0.07

0

0

 

shared pool simulator

632,528

0.00

 

0

0

 

simulator hash latch

8,046,066

0.00

0.00

0

0

 

simulator lru latch

7,879,148

0.35

0.00

0

94,920

0.01

slave class

2

0.00

 

0

0

 

slave class create

8

12.50

1.00

0

0

 

sort extent pool

25,235

0.15

0.00

0

0

 

state object free list

2

0.00

 

0

0

 

statistics aggregation

140

0.00

 

0

0

 

temp lob duration state obj allocation

4

0.00

 

0

0

 

temporary table state object allocation

327

0.00

 

0

0

 

threshold alerts latch

527

0.00

 

0

0

 

transaction allocation

116,913

0.00

 

0

0

 

transaction branch allocation

57

0.00

 

0

0

 

undo global data

134,510

0.00

0.00

0

0

 

user lock

1,744

0.00

 

0

0

 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name

Get Requests

Misses

Sleeps

Spin Gets

Sleep1

Sleep2

Sleep3

cache buffers chains

194,104,232

1,133,513

588

1,132,982

0

0

0

simulator lru latch

7,879,148

27,825

9

27,816

0

0

0

library cache

1,521,854

351

2

349

0

0

0

cache buffers lru chain

152,999

329

2

327

0

0

0

shared pool

711,381

236

16

221

0

0

0

session idle bit

2,084,432

74

1

73

0

0

0

library cache lock

998,713

49

2

47

0

0

0

library cache pin

455,779

8

1

7

0

0

0

object stats modification

6,005

1

1

0

0

0

0

slave class create

8

1

1

0

0

0

0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name

Where

NoWait Misses

Sleeps

Waiter Sleeps

cache buffers chains

kcbgtcr: kslbegin excl

0

867

721

cache buffers chains

kcbrls: kslbegin

0

226

373

cache buffers chains

kcbzwb

0

12

11

cache buffers chains

kcbgtcr: fast path

0

7

7

cache buffers chains

kcbchg: kslbegin: bufs not pinned

0

4

4

cache buffers chains

kcbchg: kslbegin: call CR func

0

1

2

cache buffers chains

kcbzib: multi-block read: nowait

0

1

0

cache buffers lru chain

kcbzgws

0

2

0

library cache

kgldti: 2SIGNAGE

0

1

0

library cache

kglhdgn: SIGNAGE:

0

1

0

library cache lock

kgllkal: SIGNAGE: multiinstance

0

1

1

library cache lock

kgllkdl: SIGNAGE: cleanup

0

1

1

library cache pin

kglpnal: SIGNAGE: alloc space

0

1

1

object stats modification

ksolsnfy

0

1

0

session idle bit

ksupuc: clear busy

0

1

2

session idle bit

ksupuc: set busy

0

1

0

shared pool

kghalo

0

6

3

shared pool

kgh: sim resz update

0

3

0

shared pool

kgh: quiesce extents

0

2

0

shared pool

kgh_next_free

0

2

0

shared pool

kgh: add extent to quiesced list

0

1

0

shared pool

kghfrunp: alloc: wait

0

1

0

shared pool

kghupr1

0

1

9

simulator lru latch

kcbs_simulate: simulate set

0

9

9

slave class create

ksvcreate

0

1

0

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

SIGNAGE Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

Owner

Tablespace Name

Object Name

Subobject Name

Obj. Type

Logical Reads

%Total

ANYDBA

GENINDX_I

ACCOUNT_ATTR_FK2

 

INDEX

11,979,488

10.76

ANYDBA

GENINDX_I

BOOKING_FK3

 

INDEX

7,954,752

7.14

ANYDBA

GENDATA_T

ATTRIBUTE_STATE

 

TABLE

7,945,664

7.13

ANYDBA

GENINDX_I

AK2_ATTRIBUTE_STATE

 

INDEX

7,920,960

7.11

ANYDBA

GENINDX_I

INSERTION_PACKAGE_1

 

INDEX

7,480,672

6.72

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner

Tablespace Name

Object Name

Subobject Name

Obj. Type

Physical Reads

%Total

ANYDBA

GENDATA_T

BOOKING_EVENT

 

TABLE

466,740

31.61

ANYDBA

GEN_INSERTION_T

INSERTION

 

TABLE

254,108

17.21

ANYDBA

GEN_CONTENT_T

CONTENT

 

TABLE

165,878

11.23

ANYDBA

GEN_ACCOUNT_T

ACCOUNT

 

TABLE

128,493

8.70

ANYDBA

GENDATA_T

PAYMENT_PENDING

 

TABLE

70,803

4.79

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner

Tablespace Name

Object Name

Subobject Name

Obj. Type

Row Lock Waits

% of Capture

ANYDBA

GENINDX_I

PK_CONTENT

 

INDEX

148

60.66

ANYDBA

GENINDX_I

BOOKING_ACCOUNT_1

 

INDEX

54

22.13

CMI

CMI_T

PK_TBLUSER

 

INDEX

30

12.30

ANYDBA

GENINDX_I

UK_PAYMENT

 

INDEX

4

1.64

ANYDBA

GENINDX_I

BOOKING_ATTR_DT1

 

INDEX

3

1.23

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner

Tablespace Name

Object Name

Subobject Name

Obj. Type

Buffer Busy Waits

% of Capture

ANYDBA

GENINDX_I

PK_CONTENT_ATTR

 

INDEX

2

28.57

ANYDBA

GENINDX_I

BOOKING_ACCOUNT_1

 

INDEX

1

14.29

ANYDBA

GENDATA_T

GENERIC_LOCK_TABLE_NAME_IDX1

 

INDEX

1

14.29

ANYDBA

GENINDX_I

PK_CONTENT

 

INDEX

1

14.29

ANYDBA

GENINDX_I

PK_INSERTION

 

INDEX

1

14.29

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

Cache

Get Requests

Pct Miss

Scan Reqs

Pct Miss

Mod Reqs

Final Usage

dc_awr_control

65

0.00

0

 

2

1

dc_files

96

0.00

0

 

0

0

dc_global_oids

146

17.81

0

 

0

25

dc_histogram_data

7,333

14.46

0

 

0

982

dc_histogram_defs

81,193

5.67

0

 

0

3,884

dc_object_grants

20,208

0.23

0

 

0

58

dc_object_ids

895,469

0.09

0

 

0

1,353

dc_objects

38,374

3.18

0

 

6

864

dc_profiles

435

0.00

0

 

0

1

dc_rollback_segments

566

0.00

0

 

0

12

dc_segments

131,692

0.91

0

 

10

1,397

dc_sequences

784

3.83

0

 

784

47

dc_tablespace_quotas

5

20.00

0

 

5

1

dc_tablespaces

231,049

0.00

0

 

0

18

dc_usernames

20,406

0.04

0

 

0

13

dc_users

257,183

0.00

0

 

0

59

outstanding_alerts

228

0.00

0

 

0

36


Back to Top

Library Cache Activity

Namespace

Get Requests

Pct Miss

Pin Requests

Pct Miss

Reloads

Invali- dations

BODY

256

0.39

23,533

0.12

27

0

CLUSTER

50

2.00

80

3.75

2

0

INDEX

40

42.50

104

24.04

8

0

SQL AREA

6,421

84.18

562,910

4.42

3,927

730

TABLE/PROCEDURE

32,672

0.89

200,500

2.34

3,373

0

TRIGGER

17,769

0.23

31,307

0.87

227

0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

 

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

312.30

 

4.28

12.84

80

83

73

73

 

Freeable

44.00

0.00

1.02

0.78

4

 

43

43

 

SQL

8.89

6.05

0.15

0.31

2

119

60

59

 

PL/SQL

1.96

1.16

0.03

0.03

0

0

71

71

E

Other

327.50

 

4.43

12.73

80

83

74

74

 

Freeable

44.56

0.00

1.01

0.72

5

 

44

44

 

SQL

6.28

3.63

0.10

0.22

1

119

61

60

 

PL/SQL

2.50

1.24

0.03

0.03

0

0

72

72

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions

Begin Size (Bytes)

End Size (Bytes) (if different)

Database Buffers

687,865,856

754,974,720

Fixed Size

2,073,160

 

Redo Buffers

14,700,544

 

Variable Size

872,418,744

805,309,880

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool

Name

Begin MB

End MB

% Diff

java

free memory

16.00

16.00

0.00

large

free memory

15.94

15.94

0.00

shared

CCursor

36.26

21.97

-39.42

shared

Cursor Stats

12.88

12.88

0.00

shared

KGH: NO ACCESS

326.58

358.48

9.77

shared

KGLS heap

11.93

 

-100.00

shared

PCursor

30.77

17.09

-44.45

shared

free memory

403.49

414.49

2.73

shared

kglsim heap

16.61

16.61

0.00

shared

kglsim object batch

29.14

29.14

0.00

shared

library cache

23.85

17.14

-28.14

shared

private strands

15.24

15.24

0.00

shared

sql area

100.56

67.13

-33.24

streams

free memory

16.00

16.00

0.00

 

buffer_cache

656.00

720.00

9.76

 

fixed_sga

1.98

1.98

0.00

 

log_buffer

14.02

14.02

0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type

CPU Time

User I/O Time

Sys I/O Time

QMON Coordinator

26,818

0

0

QMON Slaves

17,399

0

0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset Name

Evals

Fast Evals

SQL Execs

CPU Time

Elapsed Time

SYS.ALERT_QUE_R

0

0

0

0

0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter Name

Begin value

End value (if different)

archive_lag_target

0

  

audit_file_dest

/ora/product/admin/SNCLR1/adump

  

background_dump_dest

/ora/product/admin/SNCLR1/bdump

  

compatible

10.2.0.3.0

  

control_files

/ora01/oradata/SNCLR1/control01.ctl, /ora01/oradata/SNCLR1/control02.ctl, /ora01/oradata/SNCLR1/control03.ctl

  

core_dump_dest

/ora/product/admin/SNCLR1/cdump

  

db_block_size

8192

  

db_domain

news.airwise.local

  

db_file_multiblock_read_count

16

  

db_name

SNCLR1

  

db_recovery_file_dest

/ora01/fbra

  

db_recovery_file_dest_size

23622320128

  

dg_broker_start

TRUE

  

dispatchers

(PROTOCOL=TCP) (SERVICE=SNCLR1XDB)

  

fal_client

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sinclair.oracle.newsltd.newscorp)(PORT=1525)))(CONNECT_DATA=(SERVICE_NAME=SNCLR1_XPT.news.airwise.local)(INSTANCE_NAME=SNCLR1)(SERVER=dedicated)))

  

fal_server

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=qld-p590-prd-3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SNCLR1_QLD_XPT.news.airwise.local)(SERVER=dedicated)))

  

job_queue_processes

10

  

local_listener

SNCLR1

  

log_archive_config

dg_config=(SNCLR1_QLD)

  

log_archive_dest_1

service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=qld-p590-prd-3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SNCLR1_QLD_XPT.news.airwise.local)(INSTANCE_NAME=SNCLR1)(SERVER=dedicated)))", ARCH SYNC NOAFFIRM delay=20 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="SNCLR1_QLD" register net_timeout=180 valid_for=(online_logfile, primary_role)

  

log_archive_dest_state_1

ENABLE

  

log_archive_format

%t_%s_%r.dbf

  

log_archive_max_processes

2

  

log_archive_min_succeed_dest

1

  

log_archive_trace

0

  

open_cursors

1000

  

optimizer_mode

ALL_ROWS

  

parallel_max_servers

0

  

pga_aggregate_target

715128832

  

plsql_compiler_flags

INTERPRETED, NON_DEBUG

  

processes

1000

  

remote_login_passwordfile

EXCLUSIVE

  

sessions

1105

  

sga_max_size

1577058304

  

sga_target

1577058304

  

standby_archive_dest

  

  

standby_file_management

AUTO

  

undo_management

AUTO

  

undo_retention

86400

  

undo_tablespace

UNDOTBS1

  

user_dump_dest

/ora/product/admin/SNCLR1/udump

  


Back to Top

End of Report