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) |
|
|
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 |
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 |
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
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
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
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
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
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
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 |
dllhost.exe |
SELECT DISTINCT
t1."ACCOUNT_ID... |
|
417 |
261 |
12 |
34.71 |
11.60 |
dllhost.exe |
INSERT INTO
temp_lookup_pks(se... |
|
315 |
284 |
68 |
4.63 |
8.77 |
dllhost.exe |
SELECT PL.N1 FROM
PAGED_LOOKUP... |
|
118 |
109 |
19 |
6.21 |
3.29 |
dllhost.exe |
BEGIN :1 := ANYDBA.VISIBILITYP... |
|
92 |
23 |
4 |
23.10 |
2.57 |
SQL*Plus |
SELECT a.ACCOUNT_ID,
a.COMP... |
|
87 |
29 |
8 |
10.84 |
2.42 |
SQL Developer |
select count(distinct
b.bookin... |
|
76 |
18 |
3 |
25.39 |
2.12 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
|
76 |
18 |
3 |
25.30 |
2.11 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
|
75 |
17 |
3 |
24.96 |
2.09 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
|
66 |
53 |
3,158 |
0.02 |
1.84 |
dllhost.exe |
SELECT COUNT(*) FROM
SALES_REP... |
|
53 |
46 |
215 |
0.25 |
1.47 |
|
SELECT IUSERID FROM
TBLUSER WH... |
|
37 |
36 |
6 |
6.09 |
1.02 |
dllhost.exe |
BEGIN :1 := ANYDBA.VISIBILITYP... |
Back to SQL Statistics
Back to Top
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 |
dllhost.exe |
SELECT PL.N1 FROM
PAGED_LOOKUP... |
|
261 |
417 |
12 |
21.77 |
11.60 |
dllhost.exe |
INSERT INTO
temp_lookup_pks(se... |
|
109 |
118 |
19 |
5.71 |
3.29 |
dllhost.exe |
BEGIN :1 := ANYDBA.VISIBILITYP... |
|
53 |
66 |
3,158 |
0.02 |
1.84 |
dllhost.exe |
SELECT COUNT(*) FROM
SALES_REP... |
|
46 |
53 |
215 |
0.22 |
1.47 |
|
SELECT IUSERID FROM
TBLUSER WH... |
|
36 |
37 |
6 |
6.00 |
1.02 |
dllhost.exe |
BEGIN :1 := ANYDBA.VISIBILITYP... |
|
30 |
35 |
133 |
0.23 |
0.98 |
|
SELECT TBLUSER.IUSERID
FROM TB... |
|
29 |
87 |
8 |
3.67 |
2.42 |
SQL Developer |
select count(distinct
b.bookin... |
|
28 |
32 |
1,909 |
0.01 |
0.88 |
dllhost.exe |
SELECT COUNT(*) FROM
SALES_REP... |
|
26 |
440 |
28 |
0.93 |
12.26 |
dllhost.exe |
SELECT DISTINCT
t1."ACCOUNT_ID... |
|
23 |
92 |
4 |
5.77 |
2.57 |
SQL*Plus |
SELECT a.ACCOUNT_ID,
a.COMP... |
|
18 |
76 |
3 |
5.86 |
2.12 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
|
18 |
76 |
3 |
5.84 |
2.11 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
|
17 |
75 |
3 |
5.74 |
2.09 |
ZenaAgent.exe |
SELECT ia.insertion_attr_detai... |
Back to SQL Statistics
Back to Top
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 |
dllhost.exe |
INSERT INTO
temp_lookup_pks(se... |
|
10,936,831 |
3,158 |
3,463.21 |
9.82 |
52.72 |
65.92 |
dllhost.exe |
SELECT COUNT(*) FROM
SALES_REP... |
|
6,302,145 |
8 |
787,768.13 |
5.66 |
29.38 |
86.72 |
SQL Developer |
select count(distinct
b.bookin... |
|
5,531,194 |
1,909 |
2,897.43 |
4.97 |
27.66 |
31.66 |
dllhost.exe |
SELECT COUNT(*) FROM
SALES_REP... |
|
4,156,481 |
68 |
61,124.72 |
3.73 |
284.15 |
314.71 |
dllhost.exe |
SELECT PL.N1 FROM
PAGED_LOOKUP... |
|
2,512,704 |
2 |
1,256,352.00 |
2.26 |
12.93 |
14.78 |
dllhost.exe |
BEGIN :1 := ANYDBA.VISIBILITYP... |
|
2,430,484 |
4 |
607,621.00 |
2.18 |
23.09 |
92.41 |
SQL*Plus |
SELECT a.ACCOUNT_ID,
a.COMP... |
|
2,314,367 |
2,206 |
1,049.12 |
2.08 |
18.95 |
25.37 |
dllhost.exe |
SELECT COUNT(*) FROM
SALES_REP... |
|
2,273,660 |
2 |
1,136,830.00 |
2.04 |
12.36 |
13.52 |
dllhost.exe |
BEGIN :1 := ANYDBA.VISIBILITYP... |
|
2,138,522 |
8 |
267,315.25 |
1.92 |
10.96 |
12.85 |
dllhost.exe |
BEGIN :1 := ANYDBA.VISIBILITYP... |
|
2,011,537 |
28 |
71,840.61 |
1.81 |
26.16 |
440.29 |
dllhost.exe |
SELECT DISTINCT
t1."ACCOUNT_ID... |
|
1,924,411 |
3 |
641,470.33 |
1.73 |
17.52 |
75.90 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
|
1,924,352 |
3 |
641,450.67 |
1.73 |
17.23 |
74.87 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
|
1,924,255 |
3 |
641,418.33 |
1.73 |
17.57 |
76.16 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
Back to SQL Statistics
Back to Top
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 |
SQL*Plus |
SELECT a.ACCOUNT_ID,
a.COMP... |
|
199,037 |
28 |
7,108.46 |
13.48 |
26.16 |
440.29 |
dllhost.exe |
SELECT DISTINCT
t1."ACCOUNT_ID... |
|
90,686 |
12 |
7,557.17 |
6.14 |
261.29 |
416.52 |
dllhost.exe |
INSERT INTO
temp_lookup_pks(se... |
|
52,742 |
8 |
6,592.75 |
3.57 |
29.38 |
86.72 |
SQL Developer |
select count(distinct
b.bookin... |
|
43,802 |
5 |
8,760.40 |
2.97 |
4.19 |
19.49 |
dllhost.exe |
INSERT INTO temp_lookup_pks(se... |
|
23,585 |
3 |
7,861.67 |
1.60 |
17.52 |
75.90 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
|
23,568 |
3 |
7,856.00 |
1.60 |
17.57 |
76.16 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
|
16,772 |
3 |
5,590.67 |
1.14 |
17.23 |
74.87 |
ZenaAgent.exe |
SELECT
ia.insertion_attr_detai... |
|
7,185 |
3 |
2,395.00 |
0.49 |
1.91 |
17.01 |
ZenaAgent.exe |
SELECT b.booking FROM
booking... |
|
6,980 |
3 |
2,326.67 |
0.47 |
1.39 |
17.29 |
ZenaAgent.exe |
SELECT b.booking FROM
booking... |
Back to SQL Statistics
Back to Top
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 |
dllhost.exe |
SELECT
"BOTTOM_BLEED", "CASUAL... |
|
15,565 |
78,094 |
5.02 |
0.00 |
0.00 |
dllhost.exe |
SELECT "ANIM_PUBLICATION_I... |
|
15,555 |
15,555 |
1.00 |
0.00 |
0.00 |
dllhost.exe |
SELECT DISTINCT
t1."ANIM_P... |
|
14,790 |
14,790 |
1.00 |
0.00 |
0.00 |
dllhost.exe |
SELECT
"APPORTION_BY_CIRC", "C... |
|
13,195 |
5,391 |
0.41 |
0.00 |
0.00 |
dllhost.exe |
SELECT "D1",
"DESCRIPTION", "H... |
|
12,982 |
12,981 |
1.00 |
0.00 |
0.00 |
dllhost.exe |
SELECT
"ABBREVIATION", "ADDRES... |
|
11,624 |
72,152 |
6.21 |
0.00 |
0.00 |
dllhost.exe |
SELECT "ANIM_CLASSIFICATIO... |
|
11,624 |
11,624 |
1.00 |
0.00 |
0.00 |
dllhost.exe |
SELECT DISTINCT
t1."ANIM_C... |
|
9,754 |
10,674 |
1.09 |
0.00 |
0.00 |
|
select intcol#,
nvl(pos#, 0), ... |
|
7,121 |
7,121 |
1.00 |
0.00 |
0.00 |
dllhost.exe |
SELECT
"CREATE_TIME", "CREATE_... |
|
7,052 |
180,285 |
25.57 |
0.00 |
0.00 |
dllhost.exe |
delete from
temp_lookup_pks |
|
6,653 |
6,653 |
1.00 |
0.00 |
0.00 |
dllhost.exe |
SELECT
"ACCOUNT_ID", "ATTRIBUT... |
|
5,232 |
5,232 |
1.00 |
0.00 |
0.00 |
|
select text from view$
where r... |
Back to SQL Statistics
Back to Top
Parse
Calls |
Executions
|
%
Total Parses |
SQL
Id |
SQL
Module |
SQL
Text |
17,616 |
17,616 |
4.45 |
dllhost.exe |
SELECT
"BOTTOM_BLEED", "CASUAL... |
|
15,565 |
15,565 |
3.93 |
dllhost.exe |
SELECT "ANIM_PUBLICATION_I... |
|
15,555 |
15,555 |
3.93 |
dllhost.exe |
SELECT DISTINCT
t1."ANIM_P... |
|
14,790 |
14,790 |
3.73 |
dllhost.exe |
SELECT
"APPORTION_BY_CIRC", "C... |
|
13,195 |
13,195 |
3.33 |
dllhost.exe |
SELECT "D1",
"DESCRIPTION", "H... |
|
12,982 |
12,982 |
3.28 |
dllhost.exe |
SELECT
"ABBREVIATION", "ADDRES... |
|
11,624 |
11,624 |
2.93 |
dllhost.exe |
SELECT "ANIM_CLASSIFICATIO... |
|
11,624 |
11,624 |
2.93 |
dllhost.exe |
SELECT DISTINCT
t1."ANIM_C... |
|
7,121 |
7,121 |
1.80 |
dllhost.exe |
SELECT
"CREATE_TIME", "CREATE_... |
|
7,052 |
7,052 |
1.78 |
dllhost.exe |
delete from
temp_lookup_pks |
|
6,653 |
6,653 |
1.68 |
dllhost.exe |
SELECT
"ACCOUNT_ID", "ATTRIBUT... |
|
5,232 |
5,232 |
1.32 |
|
select text from view$
where r... |
|
5,083 |
5,083 |
1.28 |
dllhost.exe |
SELECT
"BIN_PASSWORD", "CAN_BE... |
|
4,856 |
4,856 |
1.23 |
dllhost.exe |
SELECT
"ABBREVIATION", "ADDRES... |
Back to SQL Statistics
Back to Top
No data exists for this
section of the report.
Back to SQL Statistics
Back to Top
No data exists for this
section of the report.
Back to SQL Statistics
Back to Top
SQL
Id |
SQL
Text |
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 ) ) |
|
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 |
|
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 |
|
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 |
|
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 ) |
|
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 |
|
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 ) ) ) ) |
|
BEGIN :1 := ANYDBA.VISIBILITYPACKAGE_1.CONTRACTFILTER1(
3064281, 164, 15585, 'ViewCont' ); END; |
|
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 |
|
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 |
|
BEGIN :1 := ANYDBA.VISIBILITYPACKAGE_1.BOOKINGFILTER1(
3064371, 162, 6301, 'ViewBook' ); END; |
|
select intcol#,
nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1 |
|
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 |
|
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 |
|
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 |
|
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 |
|
SELECT IUSERID FROM
TBLUSER WHERE UPPER(SZUSERNAME) = UPPER(:B1 ) |
|
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
|
|
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
|
|
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 |
|
BEGIN :1 := ANYDBA.VISIBILITYPACKAGE_1.CONTRACTFILTER1(
3063956, 164, 717, 'ViewCont' ); END; |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
BEGIN :1 := ANYDBA.VISIBILITYPACKAGE_1.BOOKINGFILTER1(
3064281, 3759, 15585, 'ViewBook' ); END; |
|
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 |
|
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 |
|
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 ) ) |
|
BEGIN :1 := ANYDBA.VISIBILITYPACKAGE_1.BOOKINGFILTER1(
3063961, 162, 4480, 'ViewBook' ); END; |
|
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 ) |
|
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 ) ) |
|
delete from
temp_lookup_pks |
|
select text from view$
where rowid=:1 |
Back to SQL Statistics
Back to Top
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
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
Statistic |
Total |
per
Hour |
log switches (derived) |
3 |
3.00 |
Back to Instance Activity Statistics
Back to Top
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 |
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 |
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 |
|
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
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
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(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
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
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 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 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
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
No data exists for this
section of the report.
Back to Advisory Statistics
Back to Top
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
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
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
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
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
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
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
No data exists for this
section of the report.
Back to Latch Statistics
Back to Top
No data exists for this
section of the report.
Back to Latch Statistics
Back to Top
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
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
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
No data exists for this
section of the report.
Back to Segment Statistics
Back to Top
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
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 |
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 |
|
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
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
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
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
No data exists for this
section of the report.
Back to Streams Statistics
Back to Top
No data exists for this
section of the report.
Back to Streams Statistics
Back to Top
No data exists for this
section of the report.
Back to Streams Statistics
Back to Top
No data exists for this
section of the report.
Back to Streams Statistics
Back to Top
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
No data exists for this
section of the report.
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 |
|
End of Report