WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
PROD133474625700PROD13110.2.0.3.0NOextradb.cs.usfs.gov

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:7789028-Sep-08 12:00:221105 22.1
End Snap:7789128-Sep-08 13:00:021424 19.6
Elapsed:  59.66 (mins)  
DB Time:  26,584.63 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 6,048M 6,672MStd Block Size: 16K
Shared Pool Size: 2,128M 1,504MLog Buffer: 14,384K

Load Profile

Per SecondPer Transaction
Redo size: 82,004.89 12,706.86
Logical reads: 115,506.44 17,898.00
Block changes: 288.00 44.63
Physical reads: 806.04 124.90
Physical writes: 138.29 21.43
User calls: 177.23 27.46
Parses: 269.11 41.70
Hard parses: 6.81 1.06
Sorts: 366.29 56.76
Logons: 0.81 0.13
Executes: 644.19 99.82
Transactions: 6.45 

% Blocks changed per Read: 0.25Recursive Call %: 93.87
Rollback per transaction %: 8.04Rows per Sort: 25.17

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.99
Buffer Hit %: 99.34In-memory Sort %: 99.98
Library Hit %: 97.25Soft Parse %: 97.47
Execute to Parse %: 58.22Latch Hit %: 99.83
Parse CPU to Parse Elapsd %: 50.15% Non-Parse CPU: 92.38

Shared Pool Statistics

BeginEnd
Memory Usage %: 66.00 43.07
% SQL with executions>1: 68.21 74.57
% Memory for SQL w/exec>1: 72.52 77.56

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
direct path write temp 121,004 1,448,544 11,971 90.8User I/O
CPU time  15,466  1.0 
db file sequential read 897,674 8,722 10 .5User I/O
enq: TX - row lock contention 1,630 4,769 2,926 .3Application
db file parallel write 19,818 3,956 200 .2System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 1,589,877.30 99.67
inbound PL/SQL rpc elapsed time 57,779.54 3.62
DB CPU 15,465.90 0.97
parse time elapsed 4,102.25 0.26
hard parse elapsed time 3,236.71 0.20
PL/SQL execution elapsed time 982.35 0.06
connection management call elapsed time 829.43 0.05
hard parse (sharing criteria) elapsed time 315.84 0.02
PL/SQL compilation elapsed time 170.15 0.01
hard parse (bind mismatch) elapsed time 133.26 0.01
sequence load elapsed time 10.93 0.00
failed parse elapsed time 4.47 0.00
repeated bind elapsed time 2.63 0.00
Java execution elapsed time 2.26 0.00
DB time 1,595,077.97  
background elapsed time 11,040.24  
background cpu time 422.17  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 1,254,761 0.00 1,460,357 1164 54.32
System I/O 126,333 0.00 5,900 47 5.47
Application 2,921 56.69 5,068 1735 0.13
Commit 25,075 0.97 3,482 139 1.09
Network 1,153,388 0.00 2,284 2 49.93
Concurrency 83,286 43.83 1,064 13 3.61
Other 19,664 76.25 635 32 0.85
Configuration 191 37.17 89 467 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
direct path write temp 121,004 0.00 1,448,544 11971 5.24
db file sequential read 897,674 0.00 8,722 10 38.86
enq: TX - row lock contention 1,630 99.33 4,769 2926 0.07
db file parallel write 19,818 0.00 3,956 200 0.86
log file sync 25,075 0.97 3,482 139 1.09
db file scattered read 188,977 0.00 1,564 8 8.18
log file parallel write 26,019 0.00 1,537 59 1.13
direct path read temp 40,541 0.00 1,230 30 1.75
SQL*Net more data from client 50,391 0.00 958 19 2.18
SQL*Net more data to client 468,766 0.00 897 2 20.29
cursor: pin S wait on X 36,496 99.99 627 17 1.58
control file parallel write 1,718 0.00 378 220 0.07
ARCH wait on SENDREQ 278 0.00 319 1147 0.01
SGA: allocation forcing component growth 15,140 97.13 254 17 0.66
direct path write 406 0.00 244 602 0.02
buffer exterminate 237 97.47 231 975 0.01
latch: shared pool 4,215 0.00 211 50 0.18
SQL*Net break/reset to client 1,232 0.00 179 145 0.05
enq: RO - fast object reuse 59 62.71 121 2044 0.00
SQL*Net more data from dblink 112,602 0.00 109 1 4.87
latch: row cache objects 284 0.00 79 277 0.01
latch: library cache 811 0.00 75 93 0.04
library cache load lock 163 7.36 64 393 0.01
write complete waits 60 100.00 59 983 0.00
read by other session 5,554 0.00 47 8 0.24
flashback buf free by RVWR 218 9.63 46 212 0.01
enq: JI - contention 17 70.59 36 2140 0.00
DBMS_LDAP: LDAP operation 3,199 0.00 26 8 0.14
control file sequential read 77,418 0.00 23 0 3.35
log file switch completion 31 19.35 19 607 0.00
rdbms ipc reply 28 3.57 15 548 0.00
latch free 187 0.00 11 61 0.01
enq: HW - contention 66 0.00 10 157 0.00
enq: CF - contention 8 0.00 7 895 0.00
log file sequential read 292 0.00 5 18 0.01
os thread startup 29 0.00 5 163 0.00
enq: JS - queue lock 12 0.00 4 359 0.00
direct path read 591 0.00 2 3 0.03
db file parallel read 14 0.00 2 141 0.00
reliable message 23 4.35 2 83 0.00
SQL*Net message to client 497,743 0.00 1 0 21.55
kksfbc child completion 22 100.00 1 55 0.00
enq: TX - index contention 9 0.00 1 120 0.00
log buffer space 34 14.71 1 28 0.00
buffer busy waits 73 0.00 1 12 0.00
row cache lock 39 0.00 1 20 0.00
Log archive I/O 1,060 0.00 1 1 0.05
log file single write 8 0.00 0 45 0.00
cursor: mutex X 40,473 0.00 0 0 1.75
latch: cache buffers chains 692 0.00 0 0 0.03
latch: session allocation 86 0.00 0 1 0.00
LGWR wait for redo copy 469 0.21 0 0 0.02
SQL*Net message to dblink 23,608 0.00 0 0 1.02
latch: cache buffers lru chain 15 0.00 0 3 0.00
latch: library cache lock 1 0.00 0 0 0.00
latch: undo global data 1 0.00 0 0 0.00
cursor: pin S 2 0.00 0 0 0.00
latch: library cache pin 1 0.00 0 0 0.00
SQL*Net message from client 497,152 0.00 1,071,108 2154 21.52
Streams AQ: waiting for time management or cleanup tasks 14 57.14 5,502 393034 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,500 27341 0.01
Streams AQ: qmn coordinator idle wait 257 50.19 3,500 13617 0.01
pipe get 714 100.00 3,490 4888 0.03
Streams AQ: waiting for messages in the queue 726 99.17 3,487 4803 0.03
virtual circuit status 119 100.00 3,474 29197 0.01
SQL*Net message from dblink 23,608 0.00 2,803 119 1.02
jobq slave wait 308 98.38 898 2916 0.01
SGA: MMAN sleep for component shrink 9,412 98.81 166 18 0.41
single-task message 10 0.00 2 165 0.00
class slave wait 14 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file parallel write 19,811 0.00 3,956 200 0.86
log file parallel write 26,022 0.00 1,537 59 1.13
control file parallel write 1,717 0.00 377 220 0.07
ARCH wait on SENDREQ 278 0.00 319 1147 0.01
direct path write temp 6 0.00 122 20260 0.00
direct path write 186 0.00 36 192 0.01
db file sequential read 2,466 0.00 27 11 0.11
db file scattered read 1,247 0.00 14 11 0.05
control file sequential read 58,826 0.00 9 0 2.55
events in waitclass Other 507 0.20 7 15 0.02
log file sequential read 292 0.00 5 18 0.01
os thread startup 29 0.00 5 163 0.00
latch: shared pool 289 0.00 3 10 0.01
latch: library cache 4 0.00 1 285 0.00
log buffer space 34 14.71 1 28 0.00
Log archive I/O 1,060 0.00 1 1 0.05
log file sync 5 0.00 0 96 0.00
log file single write 8 0.00 0 45 0.00
latch: row cache objects 6 0.00 0 58 0.00
buffer busy waits 1 0.00 0 128 0.00
direct path read temp 5 0.00 0 14 0.00
direct path read 428 0.00 -0 -0 0.02
rdbms ipc message 36,970 35.48 51,556 1395 1.60
Streams AQ: waiting for time management or cleanup tasks 14 57.14 5,502 393034 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,500 27341 0.01
Streams AQ: qmn coordinator idle wait 257 50.19 3,500 13617 0.01
pmon timer 1,690 99.94 3,459 2047 0.07
smon timer 1,765 0.00 3,453 1956 0.08
SGA: MMAN sleep for component shrink 9,412 98.81 166 18 0.41
class slave wait 1 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 79,612
AVG_IDLE_TIME 298,179
AVG_IOWAIT_TIME 53,380
AVG_SYS_TIME 11,051
AVG_USER_TIME 68,461
BUSY_TIME 1,913,617
IDLE_TIME 7,159,367
IOWAIT_TIME 1,284,180
SYS_TIME 267,937
USER_TIME 1,645,680
LOAD 5
OS_CPU_WAIT_TIME 2,000
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 44,597,248
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 50,340,601,856
NUM_CPUS 24

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 744,135.90 6,410.10 2,018,500 65,596,259
PROD13.fs.usda.gov 707,912.50 8,256.10 736,306 336,008,277
SYS$BACKGROUND 0.00 0.00 30,919 248,602
PROD13 0.00 0.00 0 0
PROD13XDB 0.00 0.00 0 0
PROD13_XPT 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 865003 73179718 51781 55640 0 0 647238 184740
PROD13.fs.usda.gov 377590 72533952 30616 48511 0 0 494804 11729
SYS$BACKGROUND 12255 301470 871 1818 0 0 278 31885

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 IdSQL ModuleSQL Text
268,561 96 36 7460.04 16.84 112stvbc3xgkv Class:gov.fs.grants.model.service.GrantsServiceI SELECT IiAiGaAppV.CN, ...
244,414 634 142 1721.23 15.32 3hthgkmx3983a per0060 SELECT customer_cn, last_name...
219,987 116 64 3437.29 13.79 d5rn0xnatnt9b Class:gov.fs.grants.model.service.GrantsServiceI SELECT * FROM (select /* +choo...
62,144 36 33 1883.14 3.90 fs2x3ncj6xw6w subl0020 SELECT ROWID, CN, BILL_CN, DAT...
57,352 137 40 1433.79 3.60 3kd8xkm3uv72f heritage_events SELECT SECURITY_ID, SECURITY_...
48,864 9 2 24431.86 3.06 f17uf9j090uhg Class:gov.fs.contact.model.service.ContactServic SELECT IiGaContactsUv.CN, ...
48,198 425 39 1235.84 3.02 1cj1fmtmkn7kt   BEGIN prepare_request(:1, :2, ...
35,640 44 24 1484.98 2.23 61wt2b2519tf8 Class:gov.fs.documentation.service.AppModuleImpl SELECT Documentations.CN, ...
31,242 38 38 822.15 1.96 3uc4b9n3vcqmk FACTS SELECT METHOD_CODE , EQUIPMEN...
25,070 61 10 2507.03 1.57 7wxbau87mjt2t per0010 SELECT customer_cn, last_name...
24,303 32 8 3037.93 1.52 bv5y3amd8x0a3 building SELECT II_FEAT_BLD.ID, II_FEAT...
21,421 26 16 1338.84 1.34 cfgdf5ur1cypu suau0010 select security_id id, securit...
20,860 3 2 10429.95 1.31 9q6caawbd4kx0 Class:gov.fs.contact.model.service.ContactServic SELECT /*+ choose */ Contacts....
20,455 144 48 426.14 1.28 bzmc5fqw0n1bg nav102 SELECT REGION_CODE, FOREST_COD...
19,505 12 11 1773.19 1.22 9ks9vhwwsscb7 /m0/fsapps/infraweb/infra7/forms/subl0010 select distinct managing_org_c...
17,506 8 16 1094.10 1.10 f4gcv5gjncm8u all_external_contacts SELECT UPA.PROGRAM_AREA, PAR....

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 IdSQL ModuleSQL Text
3,284 3,686 0   0.23 9p0gghzn23h5q   Select Dummy from ( SELECT '%'...
2,773 3,293 388,662 0.01 0.21 0cxqg25axtxdx   SELECT P.CN, P.NAME, P.ID FR...
1,043 1,053 6,127 0.17 0.07 69zm8k65d56yt FACTS SELECT SECURITY_ID FROM FACTS_...
634 244,414 142 4.47 15.32 3hthgkmx3983a per0060 SELECT customer_cn, last_name...
425 48,198 39 10.89 3.02 1cj1fmtmkn7kt   BEGIN prepare_request(:1, :2, ...
413 416 632 0.65 0.03 axm5005kdufpd frmweb@infraweb1.fs.usda.gov (TNS V1-V3) select ROLE GRPNAME , FLAG GRP...
311 314 859 0.36 0.02 b5k5v68umz9t8 FACTS SELECT COUNT (*) FROM FACT_KVB...
252 345 405,733 0.00 0.02 9j3zu8s6ucdvt   begin :con := II_ROW_LEVEL_SEC...
177 181 18 9.85 0.01 0sk13cbnsxk1p FACTS SELECT KV_REQUIRED, KV_PRIORIT...
149 282 435,382 0.00 0.02 19m9pwz0gv1t1 ipull.pl land_units@pcwcsob4 (TNS V1-V3) SELECT SUM(1) FROM DBA_SYS_PRI...
144 20,455 48 3.01 1.28 bzmc5fqw0n1bg nav102 SELECT REGION_CODE, FOREST_COD...
137 57,352 40 3.43 3.60 3kd8xkm3uv72f heritage_events SELECT SECURITY_ID, SECURITY_...
116 219,987 64 1.81 13.79 d5rn0xnatnt9b Class:gov.fs.grants.model.service.GrantsServiceI SELECT * FROM (select /* +choo...
96 268,561 36 2.66 16.84 112stvbc3xgkv Class:gov.fs.grants.model.service.GrantsServiceI SELECT IiAiGaAppV.CN, ...
61 25,070 10 6.08 1.57 7wxbau87mjt2t per0010 SELECT customer_cn, last_name...
44 35,640 24 1.81 2.23 61wt2b2519tf8 Class:gov.fs.documentation.service.AppModuleImpl SELECT Documentations.CN, ...
38 31,242 38 0.99 1.96 3uc4b9n3vcqmk FACTS SELECT METHOD_CODE , EQUIPMEN...
36 62,144 33 1.10 3.90 fs2x3ncj6xw6w subl0020 SELECT ROWID, CN, BILL_CN, DAT...
32 24,303 8 4.03 1.52 bv5y3amd8x0a3 building SELECT II_FEAT_BLD.ID, II_FEAT...
26 21,421 16 1.64 1.34 cfgdf5ur1cypu suau0010 select security_id id, securit...
12 19,505 11 1.10 1.22 9ks9vhwwsscb7 /m0/fsapps/infraweb/infra7/forms/subl0010 select distinct managing_org_c...
9 48,864 2 4.63 3.06 f17uf9j090uhg Class:gov.fs.contact.model.service.ContactServic SELECT IiGaContactsUv.CN, ...
8 17,506 16 0.50 1.10 f4gcv5gjncm8u all_external_contacts SELECT UPA.PROGRAM_AREA, PAR....
3 20,860 2 1.57 1.31 9q6caawbd4kx0 Class:gov.fs.contact.model.service.ContactServic SELECT /*+ choose */ Contacts....

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
65,985,118 6,127 10,769.56 15.96 1042.90 1052.67 69zm8k65d56yt FACTS SELECT SECURITY_ID FROM FACTS_...
51,707,764 142 364,139.18 12.51 634.23 244414.22 3hthgkmx3983a per0060 SELECT customer_cn, last_name...
21,909,303 859 25,505.59 5.30 311.16 313.62 b5k5v68umz9t8 FACTS SELECT COUNT (*) FROM FACT_KVB...
14,425,725 18 801,429.17 3.49 177.31 181.25 0sk13cbnsxk1p FACTS SELECT KV_REQUIRED, KV_PRIORIT...
10,882,111 48 226,710.65 2.63 144.38 20454.79 bzmc5fqw0n1bg nav102 SELECT REGION_CODE, FOREST_COD...
9,097,819 8 1,137,227.38 2.20 95.92 98.46 cnz9y4qmuc75p FACTS SELECT KV_REQUIRED, KV_PRIORIT...
4,991,091 39 127,976.69 1.21 424.67 48197.84 1cj1fmtmkn7kt   BEGIN prepare_request(:1, :2, ...
4,912,880 10 491,288.00 1.19 48.49 56.07 dc9bdxa7xpv8s PL/SQL Developer declare t_owner varchar2(30...
4,855,052 388,662 12.49 1.17 2773.27 3293.48 0cxqg25axtxdx   SELECT P.CN, P.NAME, P.ID FR...
4,852,088 0   1.17 3284.18 3686.30 9p0gghzn23h5q   Select Dummy from ( SELECT '%'...
4,430,257 10 443,025.70 1.07 60.77 25070.28 7wxbau87mjt2t per0010 SELECT customer_cn, last_name...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
407,802 39 10,456.46 14.13 424.67 48197.84 1cj1fmtmkn7kt   BEGIN prepare_request(:1, :2, ...
109,467 1 109,467.00 3.79 41.99 1570.54 01ntqpuxg4631 /fsapps/fssys/web/httpd/bin/httpd@sv10 (TNS V1-V select count(*) from ...
102,968 1 102,968.00 3.57 37.47 735.66 5jg714zg4dqzp /fsapps/fssys/web/httpd/bin/httpd@sv10 (TNS V1-V Select AU.AU_REGION_CODE ...
93,170 2 46,585.00 3.23 32.58 91.98 0kg3q2c9k1gc7   Select '%' dummy from dual uni...
85,796 1 85,796.00 2.97 29.26 921.16 grs6vhx0pms00 MSACCESS.EXE SELECT "FSDBA"."FACT_ACTIVITIE...
66,796 0   2.32 41.62 3658.19 9v9w468tgukxs   DECLARE job BINARY_INTEGER := ...
66,796 0   2.32 41.62 3658.19 cpqnfscpg532x   INSERT /*+ BYPASS_RECURSIVE_CH...
61,920 3 20,640.00 2.15 34.76 5838.88 87h9678km9k1n Class:gov.fs.grants.model.service.GrantsServiceI SELECT * FROM (select GA_CN, A...
47,970 0   1.66 44.34 3679.80 88cgb570s838q   create table ADHOC_TEMP_TABLE_...
47,612 2 23,806.00 1.65 28.44 7676.46 87ha7c5b4u2g4 java@infraweb1.fs.usda.gov (TNS V1-V3) SELECT ap.fed_id_f...
47,223 0   1.64 37.99 3689.87 9bcntcn2xh444   create table ADHOC_TEMP_TABLE_...
30,960 64 483.75 1.07 115.96 219986.59 d5rn0xnatnt9b Class:gov.fs.grants.model.service.GrantsServiceI SELECT * FROM (select /* +choo...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
435,382 435,382 1.00 0.00 0.00 19m9pwz0gv1t1 ipull.pl land_units@pcwcsob4 (TNS V1-V3) SELECT SUM(1) FROM DBA_SYS_PRI...
405,733 405,733 1.00 0.00 0.00 9j3zu8s6ucdvt   begin :con := II_ROW_LEVEL_SEC...
388,662 181,981 0.47 0.01 0.01 0cxqg25axtxdx   SELECT P.CN, P.NAME, P.ID FR...
70,925 1,258,921 17.75 0.00 0.00 db78fxqxwxt7r   select /*+ rule */ bucket, en...
29,144 29,144 1.00 0.00 0.00 ftj9uawt4wwzb   select condition from cdef$ wh...
25,122 23,891 0.95 0.00 0.00 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
18,516 27,719 1.50 0.00 0.00 6769wyy3yf66f   select pos#, intcol#, col#, sp...
18,491 18,491 1.00 0.00 0.00 grwydz59pu6mc   select text from view$ where r...
14,849 16,949 1.14 0.00 0.00 53saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
11,856 41,374 3.49 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
405,732 405,733 42.12 9j3zu8s6ucdvt   begin :con := II_ROW_LEVEL_SEC...
29,144 29,144 3.03 ftj9uawt4wwzb   select condition from cdef$ wh...
18,490 18,491 1.92 grwydz59pu6mc   select text from view$ where r...
11,857 11,856 1.23 0h6b2sajwb74n   select privilege#, level from ...
8,119 8,119 0.84 2ym6hhaq30r73   select type#, blocks, extents,...
6,733 6,733 0.70 2syvqzbxp4k9z   select u.name, o.name, a.int...
6,577 6,577 0.68 avc1jqzz04wpr Class:gov.usda.fs.iweb.iweblets.model.service.IW SELECT 'x' FROM DUAL
4,938 4,938 0.51 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
4,445 4,445 0.46 8swypbbr0m372   select order#, columns, types ...
3,650 3,650 0.38 39m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
6,345,418 2 0.40 f3g6x0b5wjhbz advr114.fmx select distinct '1' from tim_...
6,309,066 3 0.40 ccgj6bjujgwhq advr110.fmx select distinct '1' from tim_...
6,309,042 2 0.40 58pbz30ub4jb8 advr116.fmx select distinct '1' from tim_...
6,308,970 1 0.40 62hfw96buvh5j advr110.fmx select distinct '1' from tim_...
5,107,990 115 0.32 1dwbvjhjm49jk Class:gov.usda.fs.iweb.timpa.common.model.servic SELECT * FROM (select acp_cn, ...
4,576,965 121 0.29 5tmsn5ysk5k6z Class:gov.usda.fs.iweb.timpa.common.model.servic SELECT * FROM (select sale_cn,...
3,580,987 0 0.23 88cgb570s838q   create table ADHOC_TEMP_TABLE_...
3,528,392 0 0.22 891h9hsuhrd8j   create table ADHOC_TEMP_TABLE_...
3,101,203 73 0.20 9trxrfkzmmpmu Class:gov.usda.fs.iweb.timpa.common.model.servic SELECT * FROM (select region_c...
2,652,874 0 0.17 21yzbj852qm4q   create table ADHOC_TEMP_TABLE_...
2,652,842 0 0.17 bg92k145cypsh   create table ADHOC_TEMP_TABLE_...
2,493,158 0 0.16 3gg6tvjf42mjt   create table ADHOC_TEMP_TABLE_...
2,379,138 0 0.15 d1u74q7hnhca3   create table ADHOC_TEMP_TABLE_...
2,326,170 0 0.15 avzwy56byqrda   create table ADHOC_TEMP_TABLE_...
1,824,067 327 0.12 4n0uzp9k6j4fz FACTS SELECT DISTINCT ABBR FROM FACT...
1,810,650 0 0.11 g7c9davyg4vy5   create table ADHOC_TEMP_TABLE_...
1,747,651 0 0.11 9bcntcn2xh444   create table ADHOC_TEMP_TABLE_...
1,495,853 0 0.09 d2nw2yujhky87   create table ADHOC_TEMP_TABLE_...
1,412,359 18 0.09 256gvsszth4ua   SELECT f.* , t.cn ii_ta...
1,292,653 3 0.08 ccn7fbb7knxcm java@infraweb1.fs.usda.gov (TNS V1-V3) SELECT COUNT (*) FROM TIM_CONT...
1,283,340 0 0.08 ak935m31u6x2r   create table ADHOC_TEMP_TABLE_...
1,283,148 0 0.08 0ffk1md8172j5   create table ADHOC_TEMP_TABLE_...
1,279,151 0 0.08 1aqrr254rtkau   create table ADHOC_TEMP_TABLE_...
1,239,425 1 0.08 8b5ymrbrpa68t java@infraweb1.fs.usda.gov (TNS V1-V3) SELECT NVL(COUNT (*) , 0 ) F...
1,233,818 0 0.08 c97jkw6p9ftbr   create table ADHOC_TEMP_TABLE_...
1,161,721 2 0.07 87ha7c5b4u2g4 java@infraweb1.fs.usda.gov (TNS V1-V3) SELECT ap.fed_id_f...
1,104,493 0 0.07 frqdzkrubz42a   create table ADHOC_TEMP_TABLE_...
1,096,208 0 0.07 9wx4mg6zmtvm1   create table ADHOC_TEMP_TABLE_...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
84 327 4n0uzp9k6j4fz FACTS SELECT DISTINCT ABBR FROM FACT...
41 84 6nu282mktru90 FACTS SELECT SALE.ADMIN_DISTRICT_COD...
41 12 cmv2xbsptu0hx FACTS /* MV_REFRESH (INS) */ INSERT ...
41 12 cmv2xbsptu0hx FACTS /* MV_REFRESH (INS) */ INSERT ...
27 316 777dkhm13g9mt frmweb@infraweb2.fs.usda.gov (TNS V1-V3) SELECT SYS_CONTEXT(:1 , :1 ) ...
25 9 63z0jfv7x97pn FACTS /* MV_REFRESH (DEL) */ DELETE ...
25 9 63z0jfv7x97pn FACTS /* MV_REFRESH (DEL) */ DELETE ...
25 19 693k875ja4btv per0060 SELECT SUM (AC_RATE) FROM TIM_...
25 43 d1qfdskyv9k4z FACTS SELECT COUNT (*) FROM FACT_SAL...
21 18 03f31jjc1xv34 FACTS SELECT AU_REGION_CODE , AU_FO...
21 18 03f31jjc1xv34 FACTS SELECT AU_REGION_CODE , AU_FO...
21 18 03f31jjc1xv34 FACTS SELECT AU_REGION_CODE , AU_FO...
21 18 03f31jjc1xv34 FACTS SELECT AU_REGION_CODE , AU_FO...
21 42 fxk7mb93hbj42 FACTS SELECT SALE.SALE_CN , SALE.AD...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
01ntqpuxg4631select count(*) from fact_act_units AU , fact_act_subunits SU , fact_activities AC , fact_act_funding FU , fact_sales SA where AU.AU_REGION_CODE = '08' and AC.ACTIVITY_CODE is not null and AU.activity_unit_cn = SU.activity_unit_cn (+) and SU.activity_unit_cn = AC.activity_unit_cn (+) and SU.subunit = AC.subunit (+) and AC.activity_cn = FU.activity_cn (+) and AC.SALE_CN = SA.SALE_CN (+) and SU.ADMIN_FOREST_CODE = '01' and AC.FISCAL_YEAR_PLANNED < '2006' and AC.FISCAL_YEAR_PLANNED is not null and AC.FISCAL_YEAR_ACCOMPLISHED is null order by AC.FISCAL_YEAR_PLANNED, AC.ACTIVITY_CODE, FACTS_ID , SU.SUBUNIT
03f31jjc1xv34SELECT AU_REGION_CODE , AU_FOREST_CODE , AU_DISTRICT_CODE FROM FACT_ACT_UNITS WHERE CREATED_DATE = (SELECT MAX (CREATED_DATE) FROM FACT_ACT_UNITS WHERE CREATED_BY = USER ) AND CREATED_BY = USER AND ROWNUM = 1
0cxqg25axtxdxSELECT P.CN, P.NAME, P.ID FROM LAND_UNITS P, LAND_UNITS L WHERE L.CN = :B1 AND L.PARENT_CN = P.CN
0ffk1md8172j5create table ADHOC_TEMP_TABLE_154562 TABLESPACE adhoc_query NOLOGGING as select RRFFDD, CONTACTNAME, USE1, TO_STD, FEES_SEL, BILL_SEL, FEES_ACMP, BILL_ACMP, INS_SEL, INS_ACMP, INSP_SEL, INSP_ACMP, PERF_SEL, PERF_ACMP, TO_CHAR(TODAYSDATE, 'MM/DD/RRRR') TODAYSDATE from ii_su_auths_to_std_v WHERE RRFFDD LIKE '0209%' AND USE1 < '200'
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0kg3q2c9k1gc7Select '%' dummy from dual union all select security_id dummy from ii_bmc_security_id_v order by 1
0sk13cbnsxk1pSELECT KV_REQUIRED, KV_PRIORITY, AU_AU_REGION_CODE, AU_AU_FOREST_CODE, AU_AU_DISTRICT_CODE, AU_FACTS_ID, ACT_SUBUNIT, PROC_REGION_CODE, PROC_FOREST_CODE, ACT_ACTIVITY_CODE, ACD_ACTIVITY, ACT_LOCAL_QUALIFIER, ALLOC_COST_PER_UOM, INFLATED_UNIT_COST, INFLATED_FOREST_COST, INFLATED_DIRECT_COST, ACTIVITY_CN, FUND_CODE, ALLOC_NBR_UNITS_FOR_FUNDING, NBR_UNITS_FUNDED, ASU_ASU_UOM, ACT_ACTIVITY_UNIT_CN, NBR_UNITS_FOR_FUNDING, ACT_FISCAL_YEAR_PLANNED, PCT_UNITS_FUNDED, BASE_YEAR, PCT_COST_FUNDED, TOTAL_COST_PER_FUND, ACTUAL_COST_PER_UOM, COST_PER_UOM, SALE_CN, DATE_ACCOMPLISHED, INFLATED_FND_TOT_COST FROM FACT_KVBD_FORM_VW WHERE sale_cn in (select participating_sale_cn FROM fact_trust_fund_sales WHERE nominal_sale_cn='17402010602' AND fund_code=:1) and (FUND_CODE=:2) order by KV_REQUIRED DESC, KV_PRIORITY ASC, AU_AU_REGION_CODE||AU_AU_FOREST_CODE||AU_AU_DISTRICT_CODE, AU_FACTS_ID, ACT_SUBUNIT, ACT_ACTIVITY_CODE, ALLOC_COST_PER_UOM
112stvbc3xgkv SELECT IiAiGaAppV.CN, IiAiGaAppV.ID, IiAiGaAppV.OBJ_TECH, IiAiGaAppV.OBJ_NAME, IiAiGaAppV.OBJ_CLASS, IiAiGaAppV.DESCRIPTION, IiAiGaAppV.GA_CN, IiAiGaAppV.FED_ID_FY, IiAiGaAppV.FED_ID_TYPE, IiAiGaAppV.FED_ID_AGENCY, IiAiGaAppV.FED_ID_REGION, IiAiGaAppV.FED_ID_UNIT, IiAiGaAppV.FED_ID_SUBUNIT, IiAiGaAppV.FED_ID_SEQ, IiAiGaAppV.PROJ_TITLE, IiAiGaAppV.PROJ_STATUS, IiAiGaAppV.APPLICATION_ID, IiAiGaAppV.APPLICATION_TYPE, IiAiGaAppV.APP_SUBMISSION_TYPE, IiAiGaAppV.APP_SUBMIT_DATE, IiAiGaAppV.APP_RECEIVED_DATE, IiAiGaAppV.HHS_PAYMENT_IND, IiAiGaAppV.PROPOSED_START_DATE, IiAiGaAppV.PROPOSED_END_DATE, IiAiGaAppV.PROJ_DESC, IiAiGaAppV.PROJ_RECEIVED_DT, IiAiGaAppV.PROJ_EXECUTION_DT, IiAiGaAppV.PROJ_START_DT, IiAiGaAppV.PROJ_OBLIGATION_DT, IiAiGaAppV.PROJ_EXPIRATION_DT, IiAiGaAppV.PROJ_RWU, IiAiGaAppV.PROJ_CLOSE_DT, IiAiGaAppV.PROJ_CANCELLATION_DT, IiAiGaAppV.DATE_MAILED, IiAiGaAppV.DATE_SIGNED, IiAiGaAppV.EXTRAMURAL_IND, IiAiGaAppV.FAADS_REP_IND, IiAiGaAppV.PROJ_CFDA_NO, IiAiGaAppV.PROJ_SCIENCE_CD, IiAiGaAppV.RESEARCH_TYPE, IiAiGaAppV.JOURNAL_IND, IiAiGaAppV.MOD_NUMBER, IiAiGaAppV.ORIG_FED_ID, IiAiGaAppV.MASTER_FED_ID, IiAiGaAppV.AOP_IND, IiAiGaAppV.GEO_TYPE, IiAiGaAppV.MANAGING_STATE_COUNTY, IiAiGaAppV.AREAS_EFFECTED, IiAiGaAppV.FFIN, IiAiGaAppV.STATE_EO_CODE, IiAiGaAppV.STATE_EO_DATE, IiAiGaAppV.FED_EST_FUND, IiAiGaAppV.APPLICANT_EST_FUND, IiAiGaAppV.STATE_EST_FUND, IiAiGaAppV.LOCAL_EST_FUND, IiAiGaAppV.PI_EST_FUND, IiAiGaAppV.OTH_EST_FUND, IiAiGaAppV.PROJECT_CONGRESSIONAL_DISTRICT, IiAiGaAppV.FFIS_DOC_ID, IiAiGaAppV.LOCKED_IND, IiAiGaAppV.Status AS STATUS, IiAiGaAppV.STATUS_DATE AS STATUS_DATE, (IiAiGaAppV.FED_EST_FUND + IiAiGaAppV.APPLICANT_EST_FUND+ IiAiGaAppV.STATE_EST_FUND+ IiAiGaAppV.LOCAL_EST_FUND+ IiAiGaAppV.PI_EST_FUND+ IiAiGaAppV.OTH_EST_FUND) AS TotalFunds, IiAiGaAppV.MANAGING_CONT_CN, Contacts.Id AS MANAGING_ORG, Contacts.Id AS old_managing_org, replace (IiAiGaAppV.Status, 'APP-', 'PROP-') AS ContextStatus, IiAiGaAppV.APPLICANT_NAME, substr(fed_id_fy, 3, 4) || '-' ||fed_id_type || '-' || fed_id_agency || fed_id_region || fed_id_unit || fed_id_subunit|| '-' || trim(to_char (fed_id_seq, '099')) AS AgreementNo, IiAiGaAppV.PROJ_CANCELLATION_DT AS PROJ_CANCELLATION_DT1, IiAiGaAppV.COMMENTS, IiAiGaAppV.INTERNATIONAL_ACT_IND, IiAiGaAppV.PROJ_TYPE, IiAiGaAppV.ADVANCE_ALLOWED_IND, IiAiGaAppV.COUNTY, IiAiGaAppV.STATE_CODE, IiAiGaAppV.CITY_NAME, IiAiGaAppV.LINE_2, IiAiGaAppV.LINE_1, IiAiGaAppV.POSTAL_CODE, IiAiGaAppV.ZIP4, IiAiGaAppV.CN AS CN99, IiAiGaAppV.COUNTRY_NAME, IiAiGaAppV.ADVANCE_ALLOWED_IND AS ADVANCE_ALLOWED_IND99 FROM II_AI_GA_APP_V IiAiGaAppV, II_CONTACTS Contacts WHERE (IiAiGaAppV.MANAGING_CONT_CN = Contacts.CN(+))
19m9pwz0gv1t1SELECT SUM(1) FROM DBA_SYS_PRIVS WHERE PRIVILEGE LIKE 'EXEMPT ACCESS POLICY' AND GRANTEE=:B1
1aqrr254rtkaucreate table ADHOC_TEMP_TABLE_154554 TABLESPACE adhoc_query NOLOGGING as select RRFFDD, CONTACTNAME, USE1, TO_STD, FEES_SEL, BILL_SEL, FEES_ACMP, BILL_ACMP, INS_SEL, INS_ACMP, INSP_SEL, INSP_ACMP, PERF_SEL, PERF_ACMP, TO_CHAR(TODAYSDATE, 'MM/DD/RRRR') TODAYSDATE from ii_su_auths_to_std_v WHERE RRFFDD LIKE '0209%'
1cj1fmtmkn7ktBEGIN prepare_request(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); END;
1dwbvjhjm49jkSELECT * FROM (select acp_cn, last_updated, card2, last_updated_by, card80 from tim_isc_approved_cards_vw) QRSLT WHERE ACP_CN = :Bind_AcpCn
21yzbj852qm4qcreate table ADHOC_TEMP_TABLE_154571 TABLESPACE adhoc_query NOLOGGING as select AGREEMENT_NO, TO_CHAR(CLOSE_DT, 'MM/DD/RRRR') CLOSE_DT, REMAINING_BALANCE, UNIT, REGION, AGREEMENT_FY, AGREEMENT_STATUS, TO_CHAR(AGREEMENT_STATUS_DATE, 'MM/DD/RRRR') AGREEMENT_STATUS_DATE from II_GARP041L_RPT_V WHERE ( UNIT LIKE '%' )
256gvsszth4ua SELECT f.* , t.cn ii_task_cn , l.task_id , t.needed_dollars , t.actual_dollars , t.description , t.percent_complete , t.reason_code , t.priority , decode(t.work_item_type, 'DEFERRED MAINTENANCE', 'DM', 'ANNUAL MAINTENANCE', 'AM', 'CAPITAL IMPROVEMENTS', 'CI', null) work_item_type , t.work_classification work_class , t.created_date task_creation_date , t.planned_start , t.finish_date , decode(trim(t.remarks), null, null, '', null, 'REMARKS: ' || trim(t.remarks)) remarks , t.quantity , t.forest_priority , t.rollover_indicator , decode(c.task_cn, null, null, 'Task ID') label_task_id , decode(c.task_cn, null, null, 'Needed $') label_needed_dollar , decode(c.task_cn, null, null, 'Qty') label_qty , decode(c.task_cn, null, null, 'Unit') label_unit , decode(c.task_cn, null, null, 'Material Cost') label_material_cost , decode(c.task_cn, null, null, 'Labor Cost') label_labor_cost , decode(c.task_cn, null, null, 'Equip. Cost') label_equipment_cost , decode(c.task_cn, null, null, 'Description') label_description , c.*, s.sum_needed_dollars, s.sum_actual_dollars FROM ii_wk_bldg_costs_v c, ii_wk_bldg_fea_v f, ii_tasks t, ii_task_lists l, (select fea_cn, nvl(sum(needed_dollars), 0) sum_needed_dollars, nvl(sum(actual_dollars), 0) sum_actu al_dollars from ii_tasks t2, ii_features f where t2.fea_cn = f.cn and f.obj_name = 'BUILDING' and nvl(t2.PRIORITY, '%') like nvl(:1, '%') and nvl(t2.WORK_ITEM_TYPE, '%') like nvl(:2, '%') and nvl(t2.FOREST_PRIORITY, '%') like nvl(:3, '%') and( (:4 = 'Current' and t2.ROLLOVER_INDICATOR = 'N' and ((t2.percent_complete is null or t2.percent_complete <> 100 ) and t2.finish_date is null)) or (:5 = 'Accomplished' and t2.percent_complete = '100' and t2.finish_date between to_date('01/01/'||nvl(:6, TO_CHAR(SYSDATE, 'YYYY')-2), 'MM/DD/YYYY') and to_date('12/31/'||nvl(:7, TO_CHAR(SYSDATE, 'YYYY')+1), 'MM/DD/YYYY')) ) group by fea_cn) s where f.fea_cn = t.fea_cn and t.tasks_cn = l.cn and t.fea_cn = c.fea_cn(+) and s.fea_cn = f.fea_cn and t.cn = c.task_cn(+) and nvl("SECURITY_ID", '%') like nvl(:8, '%') and nvl("ADMIN_ORG", '%') like nvl(:9, '%') and nvl("FEA_PROPERTY_TYPE", '%') like nvl(:10, '%') and nvl("LU_TYPE", '%') like nvl(:11, 'ADMINISTRATIVE_SITE') and nvl("LU_NAME", '%') like nvl(:12, '%') and nvl("FEA_ID", '%') like nvl(:13, '%') and nvl("FEA_NAME", '%') like nvl(:14, '%') and nvl("FEA_CATEGORY", '%') like nvl(:15, '%') and nvl("SUBCATEGORY", '%') like nvl(:16, '%') and nvl("DEVELOPMENT_STATUS", '%') like nvl(:17, 'EXISTING%') and nvl("HISTORICAL_STATUS", '%') like nvl(:18, '%') and nvl(t."PRIORITY", '%') like nvl(:19, '%') and nvl(t."FOREST_PRIORITY", '%') like nvl(:20, '%') an d nvl(t."WORK_ITEM_TYPE", '%') like nvl(:21, '%') and to_char(f."YEAR_CONSTRUCTED", 'yyyy') > decode(:22, null, '1800', :23) and to_char(f."YEAR_CONSTRUCTED", 'yyyy') < decode(:24, null, to_char(sysdate, 'yyyy'), :25) and( (:26 = 'Current' and t.ROLLOVER_INDICATOR = 'N' and ((t.percent_complete is null or t.percent_complete <> 100 ) and t.finish_date is null)) OR (:27 = 'Accomplished' and t.percent_complete = '100' and t.finish_date between to_date('01/01/'||nvl(:28, TO_CHAR(SYSDATE, 'YYYY')-2), 'MM/DD/YYYY') and to_date('12/31/'||nvl(:29, TO_CHAR(SYSDATE, 'YYYY')+1), 'MM/DD/YYYY')) ) order by "ADMIN_ORG", "LU_NAME", "FEA_NAME", t."PRIORITY", t."DESCRIPTION"
2syvqzbxp4k9zselect u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner#
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
39m4sx9k63ba2select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3gg6tvjf42mjtcreate table ADHOC_TEMP_TABLE_154546 TABLESPACE adhoc_query NOLOGGING as select ADMIN_ORG, WASTE_WATER_SYSTEM_ID, NAME, TO_CHAR(LAST_DM_SURVEY_DATE, 'MM/DD/RRRR') LAST_DM_SURVEY_DATE from II_WWS_V
3hthgkmx3983aSELECT customer_cn, last_name, first_name, full_name, identification_number, identification_description, identification, address_type, address FROM tim_customers_in_forest_vw WHERE user_name = user AND last_name like :1 || '%' AND (first_name is null OR (first_name is not null and first_name like :2 || '%')) AND identification_number like :3 || '%' ORDER BY 4
3kd8xkm3uv72fSELECT SECURITY_ID, SECURITY_ORG_NAME, SECURITY_ORG_CN FROM II_SECURITY_ID_LOV_V WHERE TABLE_NAME = 'LAND_UNITS' AND LENGTH(SECURITY_ID) < 5
3uc4b9n3vcqmkSELECT METHOD_CODE , EQUIPMENT_CODE , LOCAL_QUALIFIER FROM FACT_ACTIVITIES WHERE ACTIVITY_CODE = :1 AND CREATED_DATE = (SELECT MAX (CREATED_DATE) FROM FACT_ACTIVITIES WHERE ACTIVITY_CODE = :1 AND CREATED_BY = USER AND ADMIN_REGION_CODE = :1 AND ADMIN_FOREST_CODE = :1 ) AND CREATED_BY = USER AND ROWNUM = 1 AND ADMIN_REGION_CODE = :1 AND ADMIN_FOREST_CODE = :1
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4n0uzp9k6j4fzSELECT DISTINCT ABBR FROM FACT_STATES_CELL WHERE ORG LIKE SUBSTR(:1 , 1 , 4 ) AND STATE_CODE = :1
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
58pbz30ub4jb8 select distinct '1' from tim_contract_sales , tim_engineering_grand_sum_vw gsvw where ((tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and gsvw.grand_total_contributed_funds > 0 and (tim_contract_sales.road_turnback_option = 'N' or tim_contract_sales.road_turnback_option is null) and exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn and gsvw.grand_total_contributed_funds - bsum.total_bid_premium > 0 )) -- or (tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and gsvw.grand_total_supplemental_funds > 0 and (tim_contract_sales.road_turnback_option = 'N' or tim_contract_sales.road_turnback_option is null) and exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn )) -- or (tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and (gsvw.grand_total_contributed_funds > 0 or gsvw.grand_total_supplemental_funds > 0) and tim_contract_sales.road_turnback_option is null and not exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn))) and tim_contract_sales.contract_sale_cn = '5515010602'
5jg714zg4dqzp Select AU.AU_REGION_CODE , AU.AU_FOREST_CODE , AU.AU_DISTRICT_CODE , AU.FACTS_ID , SU.SUBUNIT , AC.ADMIN_FOREST_CODE , AC.ADMIN_DISTRICT_CODE , AC.ACTIVITY_CODE , ACC.ACTIVITY , AC.NBR_UNITS_ACCOMPLISHED , AC.FISCAL_YEAR_ACCOMPLISHED , FU.FUND_CODE , FC.FUND_NAME , trim(FO.NAME) from FACT_ACT_UNITS AU , FACT_ACT_SUBUNITS SU , FACT_ACTIVITIES AC , FACT_ACT_CODES_CLS ACC , FACT_ACT_FUNDING FU , FACT_FUNDS_CLS FC , TIM_FORESTS FO where AU.ACTIVITY_UNIT_CN = SU.ACTIVITY_UNIT_CN and SU.ACTIVITY_UNIT_CN = AC.ACTIVITY_UNIT_CN and SU.SUBUNIT = AC.SUBUNIT and AC.ACTIVITY_CODE = ACC.ACTIVITY_CODE and AC.ACTIVITY_CN = FU.ACTIVITY_CN and FU.FUND_CODE = FC.FUND_ID and AC.ACTIVITY_CODE in (4431, 4432, 4433, 4434, 4441, 4442, 4443, 4444, /* Planting */ 4411, 4412, 4421, 4422, /* Seeding */ 4511, 4512, /* Release */ 4490, 4491 , 4492, 4493, 4494, 4495, /* Site Prep for Natural Regen */ 4382, /* Natural Regen w/o Site Prep */ 4521, 4522, /* Thinning */ 4530, /* Pruning */ 4550, 4551, 4552 /* Fertilization */ ) and AC.FISCAL_YEAR_ACCOMPLISHED = '2006' and SU.OWNERSHIP_CODE = 'FS' and SU.ADMIN_REGION_CODE = FO.REGION_CODE (+) and SU.ADMIN_FOREST_CODE = FO.FOREST_CODE (+) order by AC.ADMIN_FOREST_CODE, AC.ADMIN_DISTRICT_CODE, AU.FACTS_ID, SU.SUBUNIT, AC.ACTIVITY_CODE, FU.FUND_CODE
5tmsn5ysk5k6zSELECT * FROM (select sale_cn, cn, card, action, approval_status, card80 from tim_tsac_pending_cards_vw) QRSLT WHERE SALE_CN = :Bind_ContractSaleCn
61wt2b2519tf8SELECT Documentations.CN, Documentations.CREATED_BY, Documentations.CREATED_DATE, Documentations.CREATED_IN_INSTANCE, Documentations.ID, Documentations.TITLE, Documentations.REMARKS, Documentations.SUBTYPE, Documentations.MODIFIED_BY, Documentations.MODIFIED_DATE, Documentations.MODIFIED_IN_INSTANCE, Documentations.MASTER_SITE, Documentations.TRANS_ID, Documentations.OBJ_TECH, Documentations.OBJ_NAME, Documentations.OBJ_CLASS, Documentations.DIGITIZED_IMAGE_FILENAME, Documentations.SUBTYPE_CATEGORY, Documentations.SECURITY_ID, Documentations.SERVER_FILENAME, Documentations.CHECKED_OUT_BY, Documentations.CHECKED_OUT_DATE, Documentations.RECORD_DISCRIMINATOR, Documentations.CHECKED_OUT_LOCATION, Documentations.WEB_UPDATEABLE_FLAG, Documentations.WEB_UPDATEABLE_FILE, Documentations.FILE_SIZE, NVL(MODIFIED_BY, CREATED_BY) AS LAST_MODIFIED_BY, NVL(MODIFIED_DATE, CREATED_DATE) AS LAST_MODIFIED_DATE FROM II_DOCUMENTATIONS Documentations ORDER BY Documentations.CREATED_BY DESC
62hfw96buvh5j select distinct '1' from tim_contract_sales , tim_engineering_grand_sum_vw gsvw where ((tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and gsvw.grand_total_contributed_funds > 0 and (tim_contract_sales.road_turnback_option = 'N' or tim_contract_sales.road_turnback_option is null) and exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn and gsvw.grand_total_contributed_funds - bsum.total_bid_premium > 0 )) -- or (tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and gsvw.grand_total_supplemental_funds > 0 and (tim_contract_sales.road_turnback_option = 'N' or tim_contract_sales.road_turnback_option is null) and exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn )) -- or (tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and (gsvw.grand_total_contributed_funds > 0 or gsvw.grand_total_supplemental_funds > 0) and tim_contract_sales.road_turnback_option is null and not exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn))) and tim_contract_sales.contract_sale_cn = '3469010602'
63z0jfv7x97pn/* MV_REFRESH (DEL) */ DELETE FROM "FSDBA"."FACTS_AU_ASU_MV" SNA$ WHERE "AU_ROWID" IN (SELECT /*+ NO_MERGE HASH_SJ */ * FROM (SELECT CHARTOROWID("MAS$"."M_ROW$$") RID$ FROM "FSDBA"."MLOG$_FACT_ACT_UNITS" "MAS$" WHERE "MAS$".SNAPTIME$$ > :1 ) AS OF SNAPSHOT (:2) MAS$)
6769wyy3yf66fselect pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
693k875ja4btvSELECT SUM (AC_RATE) FROM TIM_PLAN_SPU_ASSOC_CHARGES ASS_CHARGES WHERE ASS_CHARGES.PLAN_CN = :1 AND ASS_CHARGES.RGN_SPECIES_CODE = :1 AND ASS_CHARGES.PRODUCT_CODE = :1 AND ASS_CHARGES.UOM_CN = :1
69zm8k65d56ytSELECT SECURITY_ID FROM FACTS_SECURITY_V
6nu282mktru90SELECT SALE.ADMIN_DISTRICT_CODE , SALE.ADMIN_FOREST_CODE , SALE.ADMIN_REGION_CODE , SALE.SALE_NBR , SALE.SALE_CATEGORY , SALE.SALE_NAME , SALE.AWARD_DATE , SALE.SALE_CLOSURE_DATE FROM FACT_SALES SALE WHERE SALE.SALE_CN = :1
777dkhm13g9mtSELECT SYS_CONTEXT(:1 , :1 ) FROM SYS.DUAL
7wxbau87mjt2tSELECT customer_cn, last_name, first_name, full_name, identification_number, identification_description, identification, address_type, address FROM tim_customers_all_vw WHERE last_name like :1 || '%' AND (first_name is null OR (first_name is not null and first_name like :2 || '%')) AND identification_number like :3 || '%' ORDER BY 4
87h9678km9k1nSELECT * FROM (select GA_CN, AI_ID, GA_NO, COMMITMENT_TO_DATE, OBLIGATION_TO_DATE, FS_OTHER_CONTRIBUTION, TOTAL_FS_CONTRIBUTION, NON_FS_CASH, NON_FS_OTHER, TOTAL_NON_FS_CONTRIBUTION, TOTAL_PROJECT_CONTRIBUTION, REQUESTED_TO_DATE, PAID_TO_DATE, REMAINING_BALANCE, OTHER_FEDERAL_CONTRIBUTION, OF_PERCENTAGE, NON_FEDERAL_CONTRIBUTION, NF_PERCENTAGE, STATE_CONTRIBUTION, ST_PERCENTAGE, FS_PERCENTAGE from II_AI_GA_SUMMARY_TAB_V) QRSLT WHERE GA_CN = :1
87ha7c5b4u2g4 SELECT ap.fed_id_fy, ap.fed_id_type, --ap.fed_id_agency, ap.fed_id_region, ap.fed_id_unit, ap.fed_id_subunit, ap.fed_id_seq, a.agreement_no, ad.state_code, ad.address_type, co.cooperator_name recipient_name, --ap.proj_received_dt, --'get award date' award_date, --ap.date_signed ap.proj_expiration_dt, ap.proj_close_dt, rp.remaining_balance, Decode(rp.remaining_balance, '0', 'N', 'Y') undelivered_obligations_ind, ap.status, trunc(ap.proj_expiration_dt-sysdate) days_left, ap.ga_cn, o.id org --, decode(pa.Contact_Type, 'Payment Approver', initcap(pa.Contact_Name), null) Payment_Approver_name, -- decode(pa.Contact_Type, 'Payment Approver', pa.electronic_address, null) Payment_Approver_email FROM ii_ai_ga_app_v ap, --(accplishment_instruments a, ii_grants g) ii_ai_ga_cooperators_v co, --(ii_accinst_cont_links acl, ii_contacts c) ii_ai_ga_summary_tab_v rp, ii_addresses ad, ii_ga_agreement_no_v a, (Select c.cn, c.id, c.name from ii_contacts c where c.admin_org_ind(+) = 'Y') o /*, (Select Distinct con.GRANT_CN Contact_cn, con.Contact_Type Contact_type_cd, Decode(con.Contact_Type, 'FLS', 'FS Lead Scientist' , 'PI', 'Principal Investigator' , 'AC', 'Admin Contact' , 'PGC', 'Program Contact' , 'PRC', 'Project Contact' , 'RW', 'Reviewer' , 'COC', 'Cooperator Contact' , 'PC', 'Program Coordinator' , 'PA', 'Payment Approver' , 'SO', 'Signatory Official', con.Contact_Type ) Contact_Type, initcap(con.Contact_Name) Contact_Name , initcap(con.remarks) Contact_Comments, lower(a.electronic_address) electronic_address from II_AI_GA_CONTACTS_V con, ii_addresses a Where con.cont_cn = a.cont_cn(+) and con.Contact_Type in ('PA', 'Payment Approver') -- and con.GRANT_CN = '12508278010602' ) PA */ WHERE ap.managing_cont_cn = o.cn (+) AND ap.ga_cn = co.grant_cn (+) AND ap.ga_cn = rp.ga_cn (+) AND ap.status = 'GA-EXECUTED' AND co.cont_cn = ad.cont_cn (+) AND ap.ga_cn = a.cn AND ad.address_type in ( 'BUSINESS' , 'BILLING' ) AND ( ( : p_days_left != 'Grants and Agreements Expired - Not Closed' and trunc ( nvl ( ap.proj_expiration_dt , sysdate ) - sysdate ) >= 0 ) or ( : p_days_left = 'Grants and Agreements Expire d - Not Closed' and nvl ( ap.proj_expiration_dt , sysdate ) <= sysdate and trunc ( nvl ( ap.proj_expiration_dt , sysdate ) - sysdate ) <= 0 ) ) and trunc ( nvl ( ap.proj_expiration_dt , sysdate ) - sysdate ) <= decode ( : p_days_left , 'Grants and Agreements Expired - Not Closed' , '0' , : p_days_left ) and rpt_util_pkg.IS_LIKE ( ap.fed_id_region , : P_Region ) = 'TRUE' and rpt_util_pkg.IS_LIKE ( o.id , : P_ORG ) = 'TRUE' and rpt_util_pkg.IS_LIKE ( ap.fed_id_unit , : P_Unit ) = 'TRUE' and rpt_util_pkg.IS_LIKE ( ap.fed_id_subunit , : P_sub_unit ) = 'TRUE' and rpt_util_pkg.IS_LIKE ( ap.fed_id_type , : P_instrument_type ) = 'TRUE' AND rpt_util_pkg.date_is_between ( ap.proj_expiration_dt , : p_expiration_dt_from , : p_expiration_dt_to ) = 'TRUE' and ap.ga_cn in ( Select rp.ga_cn from ii_ai_ga_summary_tab_v Where rpt_util_pkg.IS_LIKE ( Decode ( rp.remaining_balance , '0' , 'N' , 'Y' ) , : P_undelivered_mo_ind ) = 'TRUE' ) ORDER BY 1 ASC, 2 ASC, 3 ASC, 4 ASC, 5 ASC, 6 ASC, 7 ASC, 11 ASC, 12 ASC, 13 ASC, 14 ASC, 16 ASC, 15 ASC, 17 ASC, 18 ASC , 1 desc , 2 , 3 , 4 , 5 , 6 , 7 , 8
88cgb570s838qcreate table ADHOC_TEMP_TABLE_154483 TABLESPACE adhoc_query NOLOGGING as select ADMIN_ORG, SITE_NAME, TOTAL_FCI from II_DRS_FCI_V WHERE ( ADMIN_ORG = '030607' )
891h9hsuhrd8j create table ADHOC_TEMP_TABLE_154550 TABLESPACE adhoc_query NOLOGGING as select REGION_CODE, REGION_NAME, FOREST_CODE, FOREST_NAME, DISTRICT_CODE, DISTRICT_NAME, PRODUCT_PLAN_NUMBER, PRODUCT_PLAN_NAME, PERMIT_USE_CODE, GROUP_FOR_TSA_SUBMISSION, PERMIT_USE_DESCRIPTION, PERMIT_USE_ABBREVIATION, CONVERTIBLE_NONCONVERTIBLE, ISSUE_NUMBER, MP_REQUESTER_FIRST_NAME, MP_REQUESTER_MIDDLE_NAME, MP_REQUESTER_LAST_NAME, MP_REQUESTER_FULL_NAME, MP_ORIGINAL_ISSUER_FIRST_NAME, MP_ORIGINAL_ISSUER_MIDDLE_NAME, MP_ORIGINAL_ISSUER_LAST_NAME, MP_ORIGINAL_ISSUER_FULL_NAME, ISSUER_FIRST_NAME, ISSUER_MIDDLE_NAME, ISSUER_LAST_NAME, ISSUER_FULL_NAME, CUSTOMER_LAST_NAME, CUSTOMER_FIRST_NAME, CUSTOMER_MIDDLE_NAME, CUSTOMER_FULL_NAME, IDENTIFICATION_DESCRIPTION, PERMANENT_ADDRESS_LINE1, PERMANENT_ADDRESS_LINE2, PERMANENT_ADDRESS_LINE3, CITY, STATE_ABBREVIATION, POSTAL_CODE, CUSTOMER_FULL_ADDRESS, COR_CREATOR_LAST_NAME, COR_CREATOR_FIRST_NAME, COR_CREATOR_MIDDLE_NAME, COR_CREATOR_FULL_NAME, COR_NUMBER, MANUAL_PERMIT_FLAG, TO_CHAR(ISSUE_DATE, 'MM/DD/RRRR') ISSUE_DATE, ISSUED_FISCAL_YEAR, ISSUED_CALENDAR_YEAR, TO_CHAR(EFFECTIVE_DATE, 'MM/DD/RRRR') EFFECTIVE_DATE, EFFECTIVE_FY, TO_CHAR(TERMINATION_DATE, 'MM/DD/RRRR') TERMINATION_DATE, TERMINATION_FY, PAYMENT_METHOD_DESCRIPTION, STATUS_DESCRIPTION, REMARK, NUMBER_OF_PERMITS_FOR_TSA, TO_CHAR(TSA_TERMINATION_DATE, 'MM/DD/RRRR') TSA_TERMINATION_DAT E, TSA_TERMINATION_FY, PERMIT_VALUE, PERMIT_VALUE_PLUS_AC, PERMIT_VALUE_PLUS_AC_AND_MISC, AC_VALUE, VOIDER_LAST_NAME, VOIDER_FIRST_NAME, VOIDER_MIDDLE_NAME, VOIDER_FULL_NAME, VOID_TYPE, TO_CHAR(VOID_DATE, 'MM/DD/RRRR') VOID_DATE, VOID_FY, MISC_VALUE, TSA_PERMIT_NUMBER, BILL_FOR_COLLECTION_NUMBER, FILE_NAME from TIM_RQ_PERMITS_VW
8b5ymrbrpa68tSELECT NVL(COUNT (*) , 0 ) FROM TIM_CONTRACT_SPUS_INCLUDED_VW WHERE CONTRACT_SALE_CN = :1 AND LOG_PRODUCT = 'Y'
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9bcntcn2xh444create table ADHOC_TEMP_TABLE_154510 TABLESPACE adhoc_query NOLOGGING as select SITE_NAME, ROAD_ID, ROAD_NAME, ROAD_DM_TASK_ID, ROAD_DM_TASK_BMP, ROAD_DM_TASK_DESCRIPTION, ROAD_DM_TASK_NEEDED_$, ROAD_DM_TASK_REMARKS from II_DRS_ROAD_DM_V
9j3zu8s6ucdvtbegin :con := II_ROW_LEVEL_SECURITY.LAND_UNITS_FUNC(:sn, :on); end;
9ks9vhwwsscb7select distinct managing_org_cn, managing_org from ii_su_payment_bill_v where bill_cn is null order by managing_org
9p0gghzn23h5qSelect Dummy from ( SELECT '%' DUMMY FROM DUAL UNION SELECT decode(ii_return_wma_parent_data(LU.cn, 'NAME', 2), null, decode(ii_return_wma_parent_data(LU.cn, 'NAME', 1), null, LU.NAME, ii_return_wma_parent_data(LU.cn, 'NAME', 1)), ii_return_wma_parent_data(LU.cn, 'NAME', 2)) ALLOT_NAME FROM LAND_UNITS LU , II_ACTUAL_GRAZING_USE ACT WHERE LU.CN = ACT.LU_CN ORDER BY 1) where Dummy like '%'
9q6caawbd4kx0SELECT /*+ choose */ Contacts.CN, Contacts.OBJ_NAME, Contacts.ID, Contacts.NAME, Contacts.REMARKS, Contacts.ALC_CODE, Contacts.DUNS, (select FIRST_NAME from II_PERSONS where CONT_CN = Contacts.CN) AS FIRST_NAME, (select SOCIAL_SECURITY_NUMBER from II_PERSONS_V where CONT_CN = Contacts.CN) AS SOCIAL_SECURITY_NUMBER, (select TAX_ID_NUMBER from II_ORGANIZATIONS_V where CONT_CN = Contacts.CN) AS TAX_ID_NUMBER, Addresses.CONT_CN, Addresses.ADDRESS_TYPE, Addresses.LINE_1, Addresses.LINE_2, Addresses.CITY_NAME, Addresses.STATE_CODE, Addresses.POSTAL_CODE, Addresses.ELECTRONIC_ADDRESS, Addresses.PROGRAM_AREA, Addresses.SECURITY_ID, Addresses.ROWID FROM II_CONTACTS Contacts, II_ADDRESSES Addresses WHERE Contacts.ID <> 'XXXX' and Contacts.CN = Addresses.CONT_CN(+)
9trxrfkzmmpmuSELECT * FROM (select region_code, forest_code, subsystem, subsystem_description, acp_cn, district_code, district_name2, sale_name, tracking_number, card_count from timpa.tim_isc_approved_Acp_vw) QRSLT WHERE REGION_CODE = :Bind_RegionCode AND FOREST_CODE = :Bind_ForestCode
9v9w468tgukxsDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"FSDBA"."II_GA_FUNDS_ALL_LINE_SUMM_V"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
9wx4mg6zmtvm1create table ADHOC_TEMP_TABLE_154588 TABLESPACE adhoc_query NOLOGGING as select MANAGING_ORG, RMU_ID, RMU_NAME, RMU_STATUS, NFS_AREA from II_RGE_RMU_V
ak935m31u6x2rcreate table ADHOC_TEMP_TABLE_154573 TABLESPACE adhoc_query NOLOGGING as select RRFFDD, CONTACTNAME, USE1, TO_STD, FEES_SEL, BILL_SEL, FEES_ACMP, BILL_ACMP, INS_SEL, INS_ACMP, INSP_SEL, INSP_ACMP, PERF_SEL, PERF_ACMP, TO_CHAR(TODAYSDATE, 'MM/DD/RRRR') TODAYSDATE from ii_su_auths_to_std_v WHERE RRFFDD LIKE '0209%' AND USE1 < '200'
avc1jqzz04wprSELECT 'x' FROM DUAL
avzwy56byqrdacreate table ADHOC_TEMP_TABLE_154522 TABLESPACE adhoc_query NOLOGGING as select AUTHID, RRFFDD, USE1, USENAME1, RENTMETH1, RENT1 from ii_su_fyrent_v WHERE RRFFDD >= '0114' AND RRFFDD <= '011407'
axm5005kdufpdselect ROLE GRPNAME , FLAG GRPFLG from FRM50_ENABLED_ROLES order by ROLE desc
b5k5v68umz9t8SELECT COUNT (*) FROM FACT_KVBD_FORM_VW A WHERE A.FUND_CODE IN ( 'BDBD' , 'PPPP' ) AND A.SALE_CN IN (SELECT B.PARTICIPATING_SALE_CN FROM FACT_TRUST_FUND_SALES B WHERE B.NOMINAL_SALE_CN = :1 AND B.FUND_CODE IN ( 'BDBD' , 'PPPP' ) )
bg92k145cypshcreate table ADHOC_TEMP_TABLE_154534 TABLESPACE adhoc_query NOLOGGING as select AGREEMENT_NO, TO_CHAR(CLOSE_DT, 'MM/DD/RRRR') CLOSE_DT, REMAINING_BALANCE, UNIT, REGION, AGREEMENT_FY, AGREEMENT_STATUS, TO_CHAR(AGREEMENT_STATUS_DATE, 'MM/DD/RRRR') AGREEMENT_STATUS_DATE from II_GARP041L_RPT_V WHERE ( UNIT LIKE '%' )
bv5y3amd8x0a3 SELECT II_FEAT_BLD.ID, II_FEAT_BLD.NAME, II_FEAT_BLD.FEA_PROPERTY_TYPE, II_FEAT_BLD.SUB_TYPE, II_FEAT_BLD.SUBCATEGORY, II_FEAT_BLD.CN, II_FEAT_BLD.SECURITY_ID, II_FEAT_BLD.ESTIMATED_TRAVEL_TIME, II_FEAT_BLD.FEA_GROSS_SQFT, II_FEAT_BLD.OWNERSHIP, II_FEAT_BLD.DEVELOPMENT_STATUS, II_FEAT_BLD.REMARKS, II_FEAT_BLD.YEAR_CONSTRUCTED, II_FEAT_BLD.MAINTENANCE_RESPONSIBILITY, II_FEAT_BLD.MAINTENANCE_LEVEL, II_FEAT_BLD.HISTORICAL_STATUS, II_FEAT_BLD.MULTI_USE_ASSET, II_FEAT_BLD.HERITAGE_ASSET, II_FEAT_BLD.PRIORITY_ASSET, II_FEAT_BLD.HERITAGE_SIGNIFICANCE, II_FEAT_BLD.ADMIN_CONT_CN, II_FEAT_BLD.MANAGING_CONT_CN, II_FEAT_BLD.IPE_LINE_1, II_FEAT_BLD.IPE_LINE_2, II_FEAT_BLD.IPE_STATE_CODE, II_FEAT_BLD.IPE_COUNTY_COUNTRY_NAME, II_FEAT_BLD.IPE_STATE_NAME, II_FEAT_BLD.IPE_CITY_NAME, II_FEAT_BLD.IPE_POSTAL_CODE, II_FEAT_BLD.IPE_GEO_LOCATOR_CODE, II_FEAT_BLD.IPE_FEA_CN, II_FEAT_BLD.IPE_CN, II_FEAT_BLD.IPE_STATE_LU_CN, II_FEAT_BLD.IPE_LU_CN, II_FEAT_BLD.IPE_TYPE_OF_ADR, II_FEAT_BLD.IPE1_LINE_1, II_FEAT_BLD.IPE1_LINE_2, II_FEAT_BLD.IPE1_STATE_CODE, II_FEAT_BLD.IPE1_COUNTY_COUNTRY_NAME, II_FEAT_BLD.IPE1_CITY_NAME, II_FEAT_BLD.IPE1_POSTAL_CODE, II_FEAT_BLD.IPE1_CN, II_FEAT_BLD.IPE1_TYPE_OF_ADR, II_FEAT_BLD.IPE1_FEA_CN, II_FEAT_BLD.IPE1_LU_CN, II_FEAT_BLD.IPE1_STATE_LU_CN, II_FEAT_BLD.DAYS_OF_USE_PER_YEAR, II_FEAT_BLD.CURRENT_O_M_PLAN_DATE, II_FEAT_BLD.BLD_UTIL_METHOD_PAYMENT, II_FEAT_BLD.HRS_WEEK_OPERATION, II_FEAT_BLD.ENERGY_AUDITS, II_FEAT_BLD.BLD_ENERGY_AUDIT_DATE, II_FEAT_BLD.BLD_SAVINGS_IDENTIF IED, II_FEAT_BLD.BLD_NEEDED_FOR_IMPLEMENT, II_FEAT_BLD.BLD_SPENT_ON_IMPEMENT, II_FEAT_BLD.INFILTRATION_BLOCKED, II_FEAT_BLD.BLD_DESIGNATED_SHOWCASE, II_FEAT_BLD.BLD_RECYCLING_PROGRAM, II_FEAT_BLD.BLD_DESIGN_PRINCIPLES, II_FEAT_BLD.BLD_ENERGY_STAR, II_FEAT_BLD.BLD_WATER_BEST_PRACTICE, II_FEAT_BLD.BLD_COVERED_BY_UESPC, II_FEAT_BLD.BLD_ENERGY_PLAN, II_FEAT_BLD.BLD_WATER_CONSUMPTION_PLAN, II_FEAT_BLD.LEED_REQUIRED, II_FEAT_BLD.LEED_LEVEL, II_FEAT_BLD.LEED_CERTIFIED_DATE, II_FEAT_BLD.FEA_ACQUIRED_FROM_CN, II_FEAT_BLD.FEA_ACQUISITION_AUTHORITY, II_FEAT_BLD.FEA_ACQUISITION_DATE, II_FEAT_BLD.ACQUISITION_METHOD, II_FEAT_BLD.FEA_INITIAL_ACQUISITION_COST, II_FEAT_BLD.FEA_CURRENT_VALUE_METHOD, II_FEAT_BLD.FEA_CURRENT_VALUE, II_FEAT_BLD.FEA_APPRAISAL_DATE, II_FEAT_BLD.FEA_APPRAISAL_FAIR_MARKET_VALU, II_FEAT_BLD.ACCESSIBILITY_STATUS, II_FEAT_BLD.FEA_ACCESSIBILITY_COMPLIANCE, II_FEAT_BLD.ACCESSIBILITY_REMARKS, II_FEAT_BLD.OBJ_TECH, II_FEAT_BLD.OBJ_NAME, II_FEAT_BLD.OBJ_CLASS, II_FEAT_BLD.FEA_GSA_INSTALLATION_SITE_CN FROM II_FEAT_BLD II_FEAT_BLD WHERE (II_FEAT_BLD.ID=:1) order by ID
bzmc5fqw0n1bgSELECT REGION_CODE, FOREST_CODE, DISTRICT_CODE, SALE_NUMBER, SALE_NAME, SALE_STATUS, CONTRACT_TYPE, TSA_CONTRACT_NUMBER, LATEST_LOCKED_GATE, CONTACT_CN, SALE_CATEGORY, CONTRACT_SALE_CN FROM TIM_NAVIG_LIST_OF_SALES_VW WHERE sale_category = :1 order by region_code, forest_code, district_code, sale_number
c97jkw6p9ftbrcreate table ADHOC_TEMP_TABLE_154525 TABLESPACE adhoc_query NOLOGGING as select AUTHCN, FY, AUTHID, RRFFDD, CONTACTNAME, STATUS_NAME, USE1, USENAME1, TO_STD, CURRENT_SEL, CURRENT_ACMP, FEES_SEL, FEES_ACMP, BILL_SEL, BILL_ACMP, INS_SEL, INS_ACMP, INSP_SEL, INSP_ACMP, PERF_SEL, PERF_ACMP, TO_CHAR(TODAYSDATE, 'MM/DD/RRRR') TODAYSDATE from ii_su_auths_to_std_v WHERE ( FY = '2008' )
ccgj6bjujgwhq select distinct '1' from tim_contract_sales , tim_engineering_grand_sum_vw gsvw where ((tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and gsvw.grand_total_contributed_funds > 0 and (tim_contract_sales.road_turnback_option = 'N' or tim_contract_sales.road_turnback_option is null) and exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn and gsvw.grand_total_contributed_funds - bsum.total_bid_premium > 0 )) -- or (tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and gsvw.grand_total_supplemental_funds > 0 and (tim_contract_sales.road_turnback_option = 'N' or tim_contract_sales.road_turnback_option is null) and exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn )) -- or (tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and (gsvw.grand_total_contributed_funds > 0 or gsvw.grand_total_supplemental_funds > 0) and tim_contract_sales.road_turnback_option is null and not exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn))) and tim_contract_sales.contract_sale_cn = '1956010602'
ccn7fbb7knxcmSELECT COUNT (*) FROM TIM_CONTRACT_SPUS_INCLUDED_VW WHERE CONTRACT_SALE_CN = :1 AND ESCALATION_TYPE = 'FLAT'
cfgdf5ur1cypuselect security_id id, security_org_name name from ii_security_id_lov_v where table_name = 'ACCPLISHMENT_INSTRUMENTS'
cmv2xbsptu0hx/* MV_REFRESH (INS) */ INSERT INTO "FSDBA"."FACTS_AU_ASU_MV" SELECT /*+ NO_MERGE("JV$") */ /*+ */ "MAS$1"."ACTIVITY_UNIT_CN", "JV$"."SUID_CN", "MAS$1"."AU_REGION_CODE"||"MAS$1"."AU_FOREST_CODE"||"MAS$1"."AU_DISTRICT_CODE"||"MAS$1"."FACTS_ID"||"JV$"."SUBUNIT", "MAS$1"."ORG", "JV$"."RID$", "MAS$1".ROWID FROM ( SELECT "MAS$"."ROWID" "RID$" , "MAS$".* FROM "FSDBA"."FACT_ACT_SUBUNITS" "MAS$" WHERE ROWID IN (SELECT /*+ HASH_SJ */ CHARTOROWID("MAS$"."M_ROW$$") RID$ FROM "FSDBA"."MLOG$_FACT_ACT_SUBUNITS" "MAS$" WHERE "MAS$".SNAPTIME$$ > :1 )) AS OF SNAPSHOT (:2) "JV$", "FACT_ACT_UNITS" AS OF SNAPSHOT (:2) "MAS$1" WHERE "MAS$1"."ACTIVITY_UNIT_CN"="JV$"."ACTIVITY_UNIT_CN"
cnz9y4qmuc75pSELECT KV_REQUIRED, KV_PRIORITY, AU_AU_REGION_CODE, AU_AU_FOREST_CODE, AU_AU_DISTRICT_CODE, AU_FACTS_ID, ACT_SUBUNIT, PROC_REGION_CODE, PROC_FOREST_CODE, ACT_ACTIVITY_CODE, ACD_ACTIVITY, ACT_LOCAL_QUALIFIER, ALLOC_COST_PER_UOM, INFLATED_UNIT_COST, INFLATED_FOREST_COST, INFLATED_DIRECT_COST, ACTIVITY_CN, FUND_CODE, ALLOC_NBR_UNITS_FOR_FUNDING, NBR_UNITS_FUNDED, ASU_ASU_UOM, ACT_ACTIVITY_UNIT_CN, NBR_UNITS_FOR_FUNDING, ACT_FISCAL_YEAR_PLANNED, PCT_UNITS_FUNDED, BASE_YEAR, PCT_COST_FUNDED, TOTAL_COST_PER_FUND, ACTUAL_COST_PER_UOM, COST_PER_UOM, SALE_CN, DATE_ACCOMPLISHED, INFLATED_FND_TOT_COST FROM FACT_KVBD_FORM_VW WHERE sale_cn in (select participating_sale_cn FROM fact_trust_fund_sales WHERE nominal_sale_cn='2186010602' AND fund_code=:1) and (FUND_CODE=:2) order by KV_REQUIRED DESC, KV_PRIORITY ASC, AU_AU_REGION_CODE||AU_AU_FOREST_CODE||AU_AU_DISTRICT_CODE, AU_FACTS_ID, ACT_SUBUNIT, ACT_ACTIVITY_CODE, ALLOC_COST_PER_UOM
cpqnfscpg532x INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "FSDBA"."II_GA_FUNDS_ALL_LINE_SUMM_V" (SELECT nfs.non_fs_fund_cn fund_trans_cn, nfs.ga_cn, '' budget_org_code, '' job_code, nfs.funding_fy budget_fy, null line_no, nfs.fund_source, nfs.contributor_id, nfs.contributor_name, SUM (NVL (nfs.amount, 0)) total_other_value, 0 total_accrual, 0 total_obligation, 0 total_payment, 0 undelivered_obligation, 0 total_collections, 0 pending_payment, 0 advance_total, 0 advance_liquidation_total, 0 advance_remaining FROM ii_ai_ga_non_fs_funds_v nfs -- where nfs.ga_cn = '17732783010602' GROUP BY nfs.non_fs_fund_cn, nfs.ga_cn, nfs.funding_fy, nfs.fund_source, nfs.contributor_id, nfs.contributor_name -- UNION ALL -- SELECT f.cn, f.grant_cn, '' budget_org_code, '' job_code, f.fy budget_fy, null line_no, f.SOURCE fund_source, DECODE (c.id, f.SOURCE, 'FS', 'FOREST SERVICE') contributor_id, DECODE (c.NAME, f.SOURCE, 'FS', 'FOREST SERVICE') contributor_name, SUM (NVL (f.VALUE, 0)) total_other_value, 0 total_accrual, 0 total_obligation, 0 total_payment, 0 undelivered_obligation, 0 total_collections, 0 pending_payment, 0 advance_total, 0 advance_liquidation_total, 0 advance _remaining FROM ii_ga_other_fund_trans f, ii_contacts c WHERE recipient_cn = c.cn(+) AND f.SOURCE = 'FS' AND f.fund_type != 'CA' -- and f.grant_cn = '17732783010602' group by f.cn, f.grant_cn, f.fy, f.SOURCE, c.id, c.NAME -- UNION ALL -- SELECT v.mo_fund_trans_cn fund_trans_cn, v.grant_cn ga_cn, jc.budget_org_code, jc.job_code, fst.fy budget_fy, v.mo_line_no, 'FS' fund_source, 'FOREST SERVICE' contributor_id, 'FOREST SERVICE' contributor_name, 0 total_other_value, 0 total_accrual, v.total_obligation, v.paid_amt total_payment, v.open_obligation_amount undelivered_obligation, v.collection_amount total_collections, v.pending_payment, v.advance_tot advance_total, v.Advance_liquid_tot advance_liquidation_total, v.advance_remain advance_remaining FROM II_GA_OPEN_LINE_AMOUNT_V v, ii_ga_fs_fund_trans fst, ii_ffis_job_codes jc WHERE v.mo_fund_trans_cn = fst.cn and v.mo_line_no = fst.line_no(+) and fst.job_code_cn = jc.cn(+) --and fst.status = 'FFIS-PROCESSED' -- and v.grant_cn = '17732783010602' )
d1qfdskyv9k4zSELECT COUNT (*) FROM FACT_SALES WHERE SALE_CN = :1 AND SALE_CLOSURE_DATE IS NOT NULL
d1u74q7hnhca3create table ADHOC_TEMP_TABLE_154549 TABLESPACE adhoc_query NOLOGGING as select LATITUDE, LONGITUDE, ASSET_ID, ID, NAME, CN, DEFERRED_MAINTENANCE, ASSET_VALUE, CONDITION_INDEX from II_FRPP_DRS_VW
d2nw2yujhky87create table ADHOC_TEMP_TABLE_154539 TABLESPACE adhoc_query NOLOGGING as select SECURITY_ID, WORK_ITEM_TYPE, DESCRIPTION, NEEDED_DOLLARS, RTE_NO, RTE_NAME, BMP, EMP, FREQUENCY, QUANTITY, TASK_ID from II_ROAD_WORK_ITEMS_V
d5rn0xnatnt9b SELECT * FROM (select /* +choose */ grants.CN , grants.APPLICATION_ID , grants.PROJ_CFDA_NO , grants.NAME -- , grants.MANAGING_ORG , (select id from ii_contacts where cn = grants.managing_cont_cn) MANAGING_ORG , grants.APP_RECEIVED_DATE , grants.REROUTE_FROM , grants.REROUTE_DATE , replace (grants.STATUS, 'APP-', 'PROP-') as STATUS , grants.STATUS_DATE , decode (grants.fed_id_fy, null, null, (substr(grants.fed_id_fy, 3, 4) || '-' ||grants.fed_id_type || '-' || grants.fed_id_agency || grants.fed_id_region || grants.fed_id_unit || grants.fed_id_subunit|| '-' || trim(to_char (grants.fed_id_seq, '099')))) as ID , grants.applicant_name -- budget management comments -- FFIS DOC ID -- FFIS PROCESSED DATE , trunc(sysdate) - trunc(grants.STATUS_DATE) AS RecordAge , grants.Cn as grant_cn , grants.FED_ID_FY , grants.FED_ID_TYPE , grants.FED_ID_AGENCY , grants.FED_ID_REGION , grants.FED_ID_UNIT , grants.FED_ID_SUBUNIT , grants.FED_ID_SEQ , grants.PROJ_TITLE , grants.Managing_cont_cn , grants.MASTER_FED_ID , grants.proj_expiration_dt as ExpDate , grants.OBJ_NAME , grants.ID As RACA_AGMT_ID , r.STATUS As RACA_AGMT_STATUS from II_AI_GA_APP_V grants, II_RACA_AGREEMENTS r where grants.cn = r.cn(+) union select racaAgmts.cn , ' ' APPLICATION_ID , ' ' PROJ_CFDA_NO , ' ' NAME , (select id from ii_contacts where cn = racaAgmts.managing_cont_cn) MANAGING_ORG , null as APP_RECEIVED_DATE , ' ' REROUTE_FROM , null as REROUTE_DATE , ' ' STATUS , null as STATUS_DATE --, racaAgmts.ID , ' ' ID , ' ' applicant_name , null as RecordAge , ' ' grant_cn , ' ' FED_ID_FY , ' ' FED_ID_TYPE , ' ' FED_ID_AGENCY , ' ' FED_ID_REGION , ' ' FED_ID_UNIT , ' ' FED_ID_SUBUNIT , 0 as FED_ID_SEQ , racaAgmts.PROJECT_TITLE as PROJ_TITLE , racaAgmts.Managing_cont_cn , ' ' MASTER_FED_ID , racaAgmts.EXPIRATION_DATE as ExpDate , decode(racaAgmts.OBJ_NAME, 'SPECIAL_USE_AUTHORIZATION', 'RACA AGREEMENT', 'RACA', 'RACA AGREEMENT', racaAgmts.OBJ_NAME) as OBJ_NAME , racaAgmts.ID As RACA_AGMT_ID , racaAgmts.STATUS As RACA_AGMT_STATUS from II_AI_RACA_AGMT_APP_V racaAgmts where racaAgmts.CN in ( select r.cn from ii_raca_agreements r ) and racaAgmts.OBJ_NAME in ('RACA', 'SPECIAL_USE_AUTHORIZATION')) QRSLT ORDER BY RecordAge DESC
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dc9bdxa7xpv8s declare t_owner varchar2(30); t_name varchar2(30); procedure check_mview is dummy integer; begin if :object_type = 'TABLE' then select /*+rule*/ 1 into dummy from sys.all_objects where owner = :object_owner and object_name = :object_name and object_type = 'MATERIALIZED VIEW' and rownum = 1; :object_type := 'MATERIALIZED VIEW'; end if; exception when others then null; end; begin :sub_object := null; if :deep != 0 then begin if :part2 is null then select /*+rule*/ constraint_type, owner, constraint_name into :object_type, :object_owner, :object_name from sys.all_constraints c where c.constraint_name = :part1 and c.owner = :cur_schema and rownum = 1; else select /*+rule*/ constraint_type, owner, constraint_name, :part3 into :object_type, :object_owner, :object_name, :sub_object from sys.all_constraints c where c.constraint_name = :part2 and c.owner = :part1 and rownum = 1; end if; if :object_type = 'P' then :object_type := 'PRIMARY KEY'; end if; if :object_type = 'U' then :object_type := 'UNIQUE KEY'; end if; if :object_type = 'R' then :object_type := 'FOREIGN KEY'; end if; if :object_type = 'C' then :object_type := 'CHECK CONSTRAINT'; end if; return; exception when no_data_found then null; end; end if; :sub_object := :pa rt2; if (:part2 is null) or (:part1 != :cur_schema) then begin select /*+rule*/ object_type, :cur_schema, :part1 into :object_type, :object_owner, :object_name from sys.all_objects where owner = :cur_schema and object_name = :part1 and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; if :object_type = 'SYNONYM' then select /*+rule*/ s.table_owner, s.table_name into t_owner, t_name from all_synonyms s where s.synonym_name = :part1 and s.owner = :cur_schema and rownum = 1; select /*+rule*/ o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = t_owner and o.object_name = t_name and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; end if; :sub_object := :part2; if :part3 is not null then :sub_object := :sub_object || '.' || :part3; end if; check_mview; return; exception when no_data_found then null; end; end if; begin select /*+rule*/ s.table_owner, s.table_name into t_owner, t_name from all_synonyms s where s.synonym_name = :part1 and s.owner = 'PUBLIC' and rownum = 1; select /*+rule*/ o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = t_owner and o.object_name = t_name and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; check_mview; return; exception when no_data_found then null; end; :sub_object := :part3; begin select /*+rule*/ o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = :part1 and o.object_name = :part2 and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; check_mview; return; exception when no_data_found then null; end; begin if :part2 is null and :part3 is null then select /*+rule*/ 'USER', null, :part1 into :object_type, :object_owner, :object_name from sys.all_users u where u.username = :part1 and rownum = 1; return; end if; exception when no_data_found then null; end; begin if :part2 is null and :part3 is null and :deep != 0 then select /*+rule*/ 'ROLE', null, :part1 into :object_type, :object_owner , :object_name from sys.session_roles r where r.role = :part1 and rownum = 1; return; end if; exception when no_data_found then null; end; :object_owner := null; :object_type := null; :object_name := null; :sub_object := null; end;
f17uf9j090uhgSELECT IiGaContactsUv.CN, IiGaContactsUv.ID, IiGaContactsUv.LAST_OR_ORG_NAME, IiGaContactsUv.SSN_TIN, IiGaContactsUv.CONTACT_TYPE, IiGaContactsUv.PREFIX, IiGaContactsUv.FIRST_NAME, IiGaContactsUv.MIDDLE_NAME, IiGaContactsUv.SUFFIX, IiGaContactsUv.REMARKS, IiGaContactsUv.DUNS, IiGaContactsUv.ALC_CODE, IiGaContactsUv.INTERNATIONAL, IiGaContactsUv.PARENT_DUNS, IiGaContactsUv.DUNS_CONFIDENCE_CD FROM II_ALL_CONTACTS_UV IiGaContactsUv WHERE IiGaContactsUv.ID <> 'XXXX'
f3g6x0b5wjhbz select distinct '1' from tim_contract_sales , tim_engineering_grand_sum_vw gsvw where ((tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and gsvw.grand_total_contributed_funds > 0 and (tim_contract_sales.road_turnback_option = 'N' or tim_contract_sales.road_turnback_option is null) and exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn and gsvw.grand_total_contributed_funds - bsum.total_bid_premium > 0 )) -- or (tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and gsvw.grand_total_supplemental_funds > 0 and (tim_contract_sales.road_turnback_option = 'N' or tim_contract_sales.road_turnback_option is null) and exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn )) -- or (tim_contract_sales.contract_sale_cn = gsvw.contract_sale_cn and (gsvw.grand_total_contributed_funds > 0 or gsvw.grand_total_supplemental_funds > 0) and tim_contract_sales.road_turnback_option is null and not exists (select 'X' from tim_bidder_summary_vw bsum where bsum.contract_sale_cn = tim_contract_sales.contract_sale_cn))) and tim_contract_sales.contract_sale_cn = '4243010602'
f4gcv5gjncm8uSELECT UPA.PROGRAM_AREA, PAR.ROLE_NAME FROM II_USER_PROGRAM_AREAS_V UPA, II_PROGRAM_AREA_ROLES PAR WHERE UPA.PROGRAM_AREA = PAR.PROGRAM_AREA
frqdzkrubz42acreate table ADHOC_TEMP_TABLE_154582 TABLESPACE adhoc_query NOLOGGING as select MANAGING_ORG, RMU_ID, RMU_NAME, RMU_STATUS, NFS_AREA from II_RGE_RMU_V WHERE RMU_STATUS = 'ACTIVE'
fs2x3ncj6xw6wSELECT ROWID, CN, BILL_CN, DATE_PAID, PRINCIPAL, PRINCIPAL_JOB_CODE, INTEREST, INTEREST_JOB_CODE, ADMIN_COSTS, ADMIN_COSTS_JOB_CODE, PENALTY, PENALTY_JOB_CODE FROM II_SU_BILL_RECEIPTS order by DATE_PAID
ftj9uawt4wwzbselect condition from cdef$ where rowid=:1
fxk7mb93hbj42SELECT SALE.SALE_CN , SALE.ADMIN_DISTRICT_CODE , SALE.ADMIN_FOREST_CODE , SALE.ADMIN_REGION_CODE , SALE.AWARD_DATE , SALE.SALE_CLOSURE_DATE FROM FACT_SALES SALE WHERE SALE.SALE_NBR = :1 AND SALE.SALE_CN = :1
g7c9davyg4vy5create table ADHOC_TEMP_TABLE_154547 TABLESPACE adhoc_query NOLOGGING as select ADMIN_ORG, BUILD_NAME, BUILD_ID from II_BLD_ALL_SURV_V WHERE ADMIN_ORG = '030607'
grs6vhx0pms00SELECT "FSDBA"."FACT_ACTIVITIES"."ACTIVITY_CN", "FSDBA"."FACT_ACT_SUBUNITS"."ACTIVITY_UNIT_CN", "FSDBA"."FACT_ACT_SUBUNITS"."SUBUNIT", "FSDBA"."FACT_ACT_UNITS"."FACTS_ID", "FSDBA"."FACT_ACT_UNITS"."AU_REGION_CODE", "FSDBA"."FACT_ACT_UNITS"."AU_FOREST_CODE", "FSDBA"."FACT_ACT_UNITS"."AU_DISTRICT_CODE", "FSDBA"."FACT_ACT_UNITS"."UNIT_UNQ_ID" FROM "FSDBA"."FACT_ACTIVITIES", "FSDBA"."FACT_ACT_SUBUNITS", "FSDBA"."FACT_ACT_UNITS" WHERE (((((("FSDBA"."FACT_ACTIVITIES"."FISCAL_YEAR_PLANNED" <= 2005 ) AND ("FSDBA"."FACT_ACTIVITIES"."FISCAL_YEAR_ACCOMPLISHED" IS NULL ) ) AND (("FSDBA"."FACT_ACTIVITIES"."ACTIVITY_UNIT_CN" = "FSDBA"."FACT_ACT_SUBUNITS"."ACTIVITY_UNIT_CN" ) AND ("FSDBA"."FACT_ACTIVITIES"."SUBUNIT" = "FSDBA"."FACT_ACT_SUBUNITS"."SUBUNIT" ) ) ) AND ("FSDBA"."FACT_ACT_SUBUNITS"."ADMIN_FOREST_CODE" = '01' ) ) AND ("FSDBA"."FACT_ACT_SUBUNITS"."ACTIVITY_UNIT_CN" = "FSDBA"."FACT_ACT_UNITS"."ACTIVITY_UNIT_CN" ) ) AND ("FSDBA"."FACT_ACT_UNITS"."AU_REGION_CODE" = '08' ) )
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 1,553,858 434.09 67.26
CPU used when call started 1,201,839 335.75 52.03
CR blocks created 131,056 36.61 5.67
Cached Commit SCN referenced 60,096 16.79 2.60
Commit SCN cached 188 0.05 0.01
DB time 99,140,219 27,696.23 4,291.60
DBWR checkpoint buffers written 17,255 4.82 0.75
DBWR checkpoints 54 0.02 0.00
DBWR object drop buffers written 7 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 221 0.06 0.01
DBWR undo block writes 5,175 1.45 0.22
DFO trees parallelized 0 0.00 0.00
OS All other sleep time 677,477,793 189,263.08 29,326.77
OS Chars read and written 55,198,651,171 15,420,530.14 2,389,448.56
OS Data page fault sleep time 31 0.01 0.00
OS Input blocks 1,030,940 288.01 44.63
OS Involuntary context switches 526,253 147.02 22.78
OS Kernel page fault sleep time 0 0.00 0.00
OS Major page faults 693,105 193.63 30.00
OS Messages sent 0 0.00 0.00
OS Other system trap CPU time 382 0.11 0.02
OS Output blocks 1,202,797 336.02 52.07
OS Process heap size 6,621,609,984 1,849,841.15 286,637.37
OS Process stack size 407,478,272 113,834.86 17,638.99
OS Signals received 4,265 1.19 0.18
OS System call CPU time 122,534 34.23 5.30
OS System calls 57,397,738 16,034.88 2,484.64
OS Text page fault sleep time 262 0.07 0.01
OS User level CPU time 2,084,950 582.46 90.25
OS User lock wait sleep time 1,185,395,928 331,157.25 51,313.62
OS Voluntary context switches 3,485,499 973.72 150.88
OS Wait-cpu (latency) time 4,406 1.23 0.19
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
Parallel operations downgraded 25 to 50 pct 0 0.00 0.00
Parallel operations downgraded 75 to 99 pct 0 0.00 0.00
Parallel operations not downgraded 0 0.00 0.00
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for undo segment recovery 3 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 505,490 141.22 21.88
SQL*Net roundtrips to/from dblink 21,223 5.93 0.92
active txn count during cleanout 135,631 37.89 5.87
application wait time 476,184 133.03 20.61
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 14,760 4.12 0.64
branch node splits 1 0.00 0.00
buffer is not pinned count 261,690,218 73,106.89 11,328.09
buffer is pinned count 559,887,708 156,412.61 24,236.51
bytes received via SQL*Net from client 112,415,268 31,404.81 4,866.25
bytes received via SQL*Net from dblink 110,901,235 30,981.84 4,800.71
bytes sent via SQL*Net to client 572,753,543 160,006.87 24,793.45
bytes sent via SQL*Net to dblink 2,119,515 592.12 91.75
calls to get snapshot scn: kcmgss 2,484,678 694.13 107.56
calls to kcmgas 205,077 57.29 8.88
calls to kcmgcs 1,931 0.54 0.08
change write time 2,583 0.72 0.11
cleanout - number of ktugct calls 129,726 36.24 5.62
cleanouts and rollbacks - consistent read gets 123,967 34.63 5.37
cleanouts only - consistent read gets 3,025 0.85 0.13
cluster key scan block gets 870,741 243.25 37.69
cluster key scans 355,210 99.23 15.38
commit batch performed 3 0.00 0.00
commit batch requested 3 0.00 0.00
commit batch/immediate performed 107 0.03 0.00
commit batch/immediate requested 107 0.03 0.00
commit cleanout failures: block lost 438 0.12 0.02
commit cleanout failures: buffer being written 4 0.00 0.00
commit cleanout failures: callback failure 775 0.22 0.03
commit cleanout failures: cannot pin 19 0.01 0.00
commit cleanouts 108,942 30.43 4.72
commit cleanouts successfully completed 107,698 30.09 4.66
commit immediate performed 104 0.03 0.00
commit immediate requested 104 0.03 0.00
commit txn count during cleanout 7,333 2.05 0.32
concurrency wait time 107,484 30.03 4.65
consistent changes 13,989,466 3,908.16 605.58
consistent gets 412,499,239 115,237.54 17,856.34
consistent gets - examination 181,967,935 50,835.34 7,877.06
consistent gets direct 98 0.03 0.00
consistent gets from cache 412,499,116 115,237.51 17,856.33
current blocks converted for CR 345 0.10 0.01
cursor authentications 11,342 3.17 0.49
data blocks consistent reads - undo records applied 13,962,099 3,900.51 604.39
db block changes 1,030,908 288.00 44.63
db block gets 961,898 268.72 41.64
db block gets direct 4,723 1.32 0.20
db block gets from cache 957,175 267.40 41.43
deferred (CURRENT) block cleanout applications 59,269 16.56 2.57
dirty buffers inspected 30,565 8.54 1.32
enqueue conversions 22,555 6.30 0.98
enqueue releases 348,342 97.31 15.08
enqueue requests 348,487 97.35 15.09
enqueue timeouts 390 0.11 0.02
enqueue waits 163 0.05 0.01
exchange deadlocks 0 0.00 0.00
execute count 2,305,897 644.19 99.82
failed probes on index block reclamation 4 0.00 0.00
flashback log writes 2,464 0.69 0.11
frame signature mismatch 4 0.00 0.00
free buffer inspected 2,924,736 817.07 126.61
free buffer requested 2,889,268 807.16 125.07
heap block compress 123,920 34.62 5.36
hot buffers moved to head of LRU 1,939,016 541.69 83.94
immediate (CR) block cleanout applications 126,992 35.48 5.50
immediate (CURRENT) block cleanout applications 10,516 2.94 0.46
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 71,151 19.88 3.08
index fast full scans (full) 4,812 1.34 0.21
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 102,034,771 28,504.87 4,416.90
index scans kdiixs1 19,559,913 5,464.34 846.71
leaf node 90-10 splits 445 0.12 0.02
leaf node splits 796 0.22 0.03
lob reads 662 0.18 0.03
lob writes 3,838 1.07 0.17
lob writes unaligned 3,834 1.07 0.17
logons cumulative 2,917 0.81 0.13
messages received 63,675 17.79 2.76
messages sent 63,675 17.79 2.76
no buffer to keep pinned count 44 0.01 0.00
no work - consistent read gets 226,509,931 63,278.78 9,805.20
opened cursors cumulative 1,158,031 323.51 50.13
parse count (failures) 324 0.09 0.01
parse count (hard) 24,380 6.81 1.06
parse count (total) 963,300 269.11 41.70
parse time cpu 117,813 32.91 5.10
parse time elapsed 234,900 65.62 10.17
physical read IO requests 1,160,653 324.24 50.24
physical read bytes 47,271,903,232 13,206,080.09 2,046,314.15
physical read total IO requests 1,246,136 348.13 53.94
physical read total bytes 51,151,698,432 14,289,956.19 2,214,263.38
physical read total multi block requests 243,397 68.00 10.54
physical reads 2,885,255 806.04 124.90
physical reads cache 2,738,382 765.01 118.54
physical reads cache prefetch 1,629,564 455.24 70.54
physical reads direct 146,873 41.03 6.36
physical reads direct (lob) 100 0.03 0.00
physical reads direct temporary tablespace 141,626 39.57 6.13
physical reads for flashback new 6,145 1.72 0.27
physical reads prefetch warmup 7 0.00 0.00
physical write IO requests 182,528 50.99 7.90
physical write bytes 8,109,481,984 2,265,499.40 351,044.63
physical write total IO requests 245,057 68.46 10.61
physical write total bytes 10,107,510,272 2,823,677.09 437,535.62
physical write total multi block requests 197,650 55.22 8.56
physical writes 495,019 138.29 21.43
physical writes direct 429,111 119.88 18.58
physical writes direct (lob) 98 0.03 0.00
physical writes direct temporary tablespace 424,202 118.51 18.36
physical writes from cache 65,908 18.41 2.85
physical writes non checkpoint 477,459 133.38 20.67
pinned buffers inspected 1,177 0.33 0.05
prefetch clients - default 18 0.01 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 443 0.12 0.02
process last non-idle time 3,783 1.06 0.16
queries parallelized 0 0.00 0.00
recursive calls 9,719,299 2,715.22 420.73
recursive cpu usage 812,452 226.97 35.17
redo blocks written 605,040 169.03 26.19
redo buffer allocation retries 32 0.01 0.00
redo entries 606,226 169.36 26.24
redo log space requests 40 0.01 0.00
redo log space wait time 1,932 0.54 0.08
redo ordering marks 7,232 2.02 0.31
redo size 293,541,104 82,004.89 12,706.86
redo subscn max counts 43,413 12.13 1.88
redo synch time 388,506 108.53 16.82
redo synch writes 49,829 13.92 2.16
redo wastage 6,275,356 1,753.11 271.65
redo write time 174,872 48.85 7.57
redo writer latching time 5 0.00 0.00
redo writes 26,473 7.40 1.15
rollback changes - undo records applied 8,442 2.36 0.37
rollbacks only - consistent read gets 7,325 2.05 0.32
rows fetched via callback 17,752,905 4,959.53 768.49
session connect time 0 0.00 0.00
session cursor cache hits 996,299 278.33 43.13
session logical reads 413,461,765 115,506.44 17,898.00
session pga memory 829,249,984 231,662.81 35,896.71
session uga memory 90,933,580,728 25,403,592.16 3,936,348.24
session uga memory max 5,348,494,896 1,494,178.30 231,526.55
shared hash latch upgrades - no wait 3,941,149 1,101.02 170.61
shared hash latch upgrades - wait 29 0.01 0.00
sorts (disk) 220 0.06 0.01
sorts (memory) 1,310,918 366.22 56.75
sorts (rows) 32,998,096 9,218.49 1,428.43
sql area evicted 24,932 6.97 1.08
sql area purged 411 0.11 0.02
summed dirty queue length 392,563 109.67 16.99
switch current to new buffer 17,635 4.93 0.76
table fetch by rowid 296,743,783 82,899.61 12,845.50
table fetch continued row 6,767,111 1,890.49 292.94
table scan blocks gotten 13,968,426 3,902.28 604.67
table scan rows gotten 1,737,475,910 485,388.67 75,212.15
table scans (long tables) 35 0.01 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 104,916 29.31 4.54
total number of times SMON posted 1,908 0.53 0.08
transaction rollbacks 107 0.03 0.00
transaction tables consistent read rollbacks 33 0.01 0.00
transaction tables consistent reads - undo records applied 24,702 6.90 1.07
undo change vector size 63,183,552 17,651.23 2,735.10
user I/O wait time 160,280,239 44,776.57 6,938.24
user calls 634,401 177.23 27.46
user commits 21,244 5.93 0.92
user rollbacks 1,857 0.52 0.08
workarea executions - multipass 71 0.02 0.00
workarea executions - onepass 817 0.23 0.04
workarea executions - optimal 1,094,311 305.71 47.37
write clones created in background 0 0.00 0.00
write clones created in foreground 535 0.15 0.02

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 364,793 439,236
opened cursors current 24,394 27,887
workarea memory allocated 1,210,219 1,572,347
logons current 1,105 1,424

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 2 2.01

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
DATA 252,278 70 8.13 4.07 18,494 5 2,719 7.02
DATA_MED 241,298 67 5.33 2.70 724 0 1,546 11.69
TEMP 47,872 13 491.07 2.88 129,111 36 0 0.00
INDEXES 163,144 46 14.68 1.48 3,295 1 1,304 8.48
DATA_BIG 130,442 36 10.15 1.13 354 0 0 0.00
USERS 92,886 26 9.60 2.89 7,888 2 14 0.71
IPART2_NRIS_FSVEG 53,792 15 8.69 1.00 1,372 0 4 57.50
SYSTEM 35,137 10 16.99 2.05 992 0 18 20.00
TPART1_NRIS_FSVEG 31,205 9 7.04 1.00 359 0 0 0.00
TPART2_NRIS_FSVEG 30,961 9 9.13 1.00 351 0 0 0.00
IPART3_NRIS_FSVEG 13,445 4 15.89 1.00 729 0 0 0.00
UNDO_TBS1 9,681 3 6.69 1.00 2,408 1 17 22.94
SYSAUX 6,183 2 15.53 1.42 2,374 1 0 0.00
TPART3_NRIS_FSVEG 5,334 1 8.95 1.00 302 0 0 0.00
AUDIT_TS 4,337 1 8.28 13.79 536 0 4 0.00
INDEXES_NRIS_TERRA 3,286 1 12.02 1.01 88 0 0 0.00
IPART1_NRIS_FSVEG 1,530 0 34.95 1.00 1,410 0 1 0.00
INDEXES_NRIS_FSVEG 1,668 0 24.63 1.01 550 0 0 0.00
TPART4_NRIS_FSVEG 1,149 0 32.36 1.00 899 0 0 0.00
IPART4_NRIS_FSVEG 1,400 0 26.61 1.00 450 0 0 0.00
USERS_NRIS 1,653 0 9.87 2.00 35 0 0 0.00
INDEXES_NRIS 1,420 0 8.34 2.08 15 0 0 0.00
INDEXES_NRIS_FAUNA 736 0 15.63 1.00 377 0 0 0.00
SDE 867 0 15.48 2.78 115 0 0 0.00
R01GISDATA 783 0 10.79 1.01 25 0 0 0.00
ADHOC_QUERY 549 0 13.55 6.50 248 0 0 0.00
USERS_NRIS_TERRA 759 0 17.00 1.11 16 0 0 0.00
USERS_NRIS_FSVEG 383 0 29.37 1.16 314 0 0 0.00
TIMPA_IDX 295 0 36.51 1.00 101 0 0 0.00
USERS_NRIS_FAUNA 291 0 13.33 1.00 55 0 0 0.00
USERS_NRIS_TESP 186 0 7.15 13.13 10 0 0 0.00
TIMPA_DATA 138 0 33.62 1.28 10 0 0 0.00
OWBINDEXES 93 0 9.68 1.00 39 0 0 0.00
OWBDATA 55 0 20.73 1.27 16 0 0 0.00
SDE_NRIS_WILDLIFE_I 3 0 0.00 1.00 59 0 0 0.00
R05GISDATA 57 0 39.30 1.53 2 0 0 0.00
USERS_NRIS_INFORMS 47 0 28.09 1.72 2 0 0 0.00
INDEXES_NRIS_TESP 38 0 6.58 1.26 8 0 0 0.00
R06GISDATA 31 0 18.39 1.00 5 0 0 0.00
R00NATGISDATA 28 0 2.14 1.00 6 0 0 0.00
SRVC_IDX 17 0 27.65 1.00 11 0 0 0.00
SRVC_DATA 17 0 7.65 1.00 9 0 0 0.00
SDE_NRIS_WILDLIFE_B 4 0 117.50 2.75 19 0 0 0.00
INDEXES_NRIS_INFORMS 20 0 58.50 1.00 2 0 0 0.00
R02GISDATA 17 0 12.35 1.00 2 0 0 0.00
CPAIS_TMP 10 0 1.00 1.00 2 0 0 0.00
DATA_LOB 10 0 3.00 1.00 2 0 0 0.00
SDE_NRIS_WATER_AQ_B 10 0 5.00 1.00 2 0 0 0.00
SDE_NRIS_WATER_AQ_F 10 0 2.00 1.00 2 0 0 0.00
SDE_NRIS_WATER_AQ_I 10 0 5.00 1.00 2 0 0 0.00
SDE_NRIS_WATER_AQ_S 10 0 7.00 1.00 2 0 0 0.00
WEBMDATA 10 0 4.00 1.00 2 0 0 0.00
WEBMINDX 10 0 3.00 1.00 2 0 0 0.00
TEMP_GIS 6 0 3.33 1.00 5 0 0 0.00
R03GISDATA 8 0 3.75 1.00 2 0 0 0.00
R08GISDATA 8 0 1.25 1.00 2 0 0 0.00
R09GISDATA 8 0 5.00 1.00 2 0 0 0.00
R10GISDATA 8 0 1.25 1.00 2 0 0 0.00
SDE_BLK 8 0 1.25 1.00 2 0 0 0.00
SDE_BUSINESS 8 0 2.50 1.00 2 0 0 0.00
SDE_GEN_IDX 8 0 2.50 1.00 2 0 0 0.00
SDE_IDX 8 0 3.75 1.00 2 0 0 0.00
SDE_LOGFILES 8 0 1.25 1.00 2 0 0 0.00
SDE_RASTER 8 0 0.00 1.00 2 0 0 0.00
SDE_VECTOR_F 8 0 1.25 1.00 2 0 0 0.00
SDE_VECTOR_S 8 0 2.50 1.00 2 0 0 0.00
INDEXES_NRIS_WATER 6 0 0.00 1.00 2 0 0 0.00
USERS_NRIS_WATER 6 0 3.33 1.00 2 0 0 0.00
R04GISDATA 4 0 5.00 1.00 2 0 0 0.00
UCMDATA 4 0 5.00 1.00 2 0 0 0.00
UCMINDEX 4 0 2.50 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
ADHOC_QUERY /f4/oradata/PROD13/ADHOC_QUERY.dbf 549 0 13.55 6.50 248 0 0 0.00
AUDIT_TS /f1/oradata/PROD13/aud01.dbf 4,337 1 8.28 13.79 536 0 4 0.00
CPAIS_TMP /f2/oradata/PROD13/CPAIS_TMP_01.dbf 10 0 1.00 1.00 2 0 0 0.00
DATA /f4/oradata/PROD13/DATA_01.dbf 238,428 67 7.86 4.15 11,584 3 2,668 6.79
DATA /f4/oradata/PROD13/DATA_02.dbf 13,850 4 12.81 2.75 6,910 2 51 19.22
DATA_BIG /f5/oradata/PROD13/DATA_BIG01.dbf 51,353 14 8.39 1.09 157 0 0 0.00
DATA_BIG /f6/oradata/PROD13/DATA_BIG02.dbf 41,070 11 11.36 1.18 109 0 0 0.00
DATA_BIG /f7/oradata/PROD13/DATA_BIG03.dbf 38,019 11 11.22 1.14 88 0 0 0.00
DATA_LOB /f6/oradata/PROD13/DATA_LOB01.dbf 10 0 3.00 1.00 2 0 0 0.00
DATA_MED /f3/oradata/PROD13/DATA_MED02.dbf 341 0 18.86 3.10 24 0 0 0.00
DATA_MED /f4/oradata/PROD13/DATA_MED01.dbf 240,957 67 5.31 2.70 700 0 1,546 11.69
INDEXES /f2/oradata/PROD13/indexes02.dbf 37,907 11 11.70 1.46 691 0 310 5.03
INDEXES /f2/oradata/PROD13/indexes04.dbf 34,741 10 12.82 1.37 765 0 267 9.78
INDEXES /f3/oradata/PROD13/indexes05.dbf 5,693 2 16.29 1.13 215 0 53 18.68
INDEXES /f5/oradata/PROD13/indexes01.dbf 37,794 11 17.37 1.54 719 0 373 10.40
INDEXES /f8/oradata/PROD13/indexes03.dbf 39,953 11 16.32 1.55 729 0 300 6.70
INDEXES /f8/oradata/PROD13/indexes06.dbf 7,056 2 14.91 1.65 176 0 1 10.00
INDEXES_NRIS /f2/oradata/PROD13/indexes_nris01.dbf 1,420 0 8.34 2.08 15 0 0 0.00
INDEXES_NRIS_FAUNA /f2/oradata/PROD13/indexes_nris_fauna01.dbf 736 0 15.63 1.00 377 0 0 0.00
INDEXES_NRIS_FSVEG /f2/oradata/PROD13/indexes_nris_fsveg01.dbf 1,668 0 24.63 1.01 550 0 0 0.00
INDEXES_NRIS_INFORMS /f4/oradata/PROD13/indexes_nris_informs01.dbf 20 0 58.50 1.00 2 0 0 0.00
INDEXES_NRIS_TERRA /f6/oradata/PROD13/indexes_nris_terra01.dbf 3,286 1 12.02 1.01 88 0 0 0.00
INDEXES_NRIS_TESP /f2/oradata/PROD13/indexes_nris_tesp01.dbf 38 0 6.58 1.26 8 0 0 0.00
INDEXES_NRIS_WATER /f8/oradata/PROD13/indexes_nris_water01.dbf 6 0 0.00 1.00 2 0 0 0.00
IPART1_NRIS_FSVEG /f1/oradata/PROD13/ipart1_nris_fsveg01.dbf 1,530 0 34.95 1.00 1,410 0 1 0.00
IPART2_NRIS_FSVEG /f2/oradata/PROD13/ipart2_nris_fsveg01.dbf 53,792 15 8.69 1.00 1,372 0 4 57.50
IPART3_NRIS_FSVEG /f3/oradata/PROD13/ipart3_nris_fsveg01.dbf 13,445 4 15.89 1.00 729 0 0 0.00
IPART4_NRIS_FSVEG /f4/oradata/PROD13/ipart4_nris_fsveg01.dbf 1,400 0 26.61 1.00 450 0 0 0.00
OWBDATA /f6/oradata/PROD13/owbdata01.dbf 55 0 20.73 1.27 16 0 0 0.00
OWBINDEXES /f8/oradata/PROD13/owbindexes01.dbf 93 0 9.68 1.00 39 0 0 0.00
R00NATGISDATA /f6/oradata/PROD13/r00natgisdata01.dbf 10 0 2.00 1.00 2 0 0 0.00
R00NATGISDATA /f7/oradata/PROD13/r00natgisdata02.dbf 8 0 2.50 1.00 2 0 0 0.00
R00NATGISDATA /f8/oradata/PROD13/r00natgisdata03.dbf 10 0 2.00 1.00 2 0 0 0.00
R01GISDATA /f8/oradata/PROD13/r01gisdata01.dbf 783 0 10.79 1.01 25 0 0 0.00
R02GISDATA /f8/oradata/PROD13/r02gisdata01.dbf 17 0 12.35 1.00 2 0 0 0.00
R03GISDATA /f8/oradata/PROD13/r03gisdata01.dbf 8 0 3.75 1.00 2 0 0 0.00
R04GISDATA /f8/oradata/PROD13/r04gisdata01.dbf 4 0 5.00 1.00 2 0 0 0.00
R05GISDATA /f8/oradata/PROD13/r05gisdata01.dbf 57 0 39.30 1.53 2 0 0 0.00
R06GISDATA /f8/oradata/PROD13/r06gisdata01.dbf 31 0 18.39 1.00 5 0 0 0.00
R08GISDATA /f8/oradata/PROD13/r08gisdata01.dbf 8 0 1.25 1.00 2 0 0 0.00
R09GISDATA /f8/oradata/PROD13/r09gisdata01.dbf 8 0 5.00 1.00 2 0 0 0.00
R10GISDATA /f8/oradata/PROD13/r10gisdata01.dbf 8 0 1.25 1.00 2 0 0 0.00
SDE /f1/oradata/PROD13/sde01.dbf 702 0 14.52 2.86 81 0 0 0.00
SDE /f7/oradata/PROD13/sde02.dbf 165 0 19.58 2.45 34 0 0 0.00
SDE_BLK /f1/oradata/PROD13/sde_blk01.dbf 8 0 1.25 1.00 2 0 0 0.00
SDE_BUSINESS /f1/oradata/PROD13/sde_business01.dbf 8 0 2.50 1.00 2 0 0 0.00
SDE_GEN_IDX /f2/oradata/PROD13/sde_gen_idx01.dbf 8 0 2.50 1.00 2 0 0 0.00
SDE_IDX /f2/oradata/PROD13/sde_idx01.dbf 8 0 3.75 1.00 2 0 0 0.00
SDE_LOGFILES /f1/oradata/PROD13/sde_logfiles01.dbf 8 0 1.25 1.00 2 0 0 0.00
SDE_NRIS_WATER_AQ_B /f1/oradata/PROD13/sde_nris_water_aq_b01.dbf 10 0 5.00 1.00 2 0 0 0.00
SDE_NRIS_WATER_AQ_F /f3/oradata/PROD13/sde_nris_water_aq_f01.dbf 10 0 2.00 1.00 2 0 0 0.00
SDE_NRIS_WATER_AQ_I /f2/oradata/PROD13/sde_nris_water_aq_i01.dbf 10 0 5.00 1.00 2 0 0 0.00
SDE_NRIS_WATER_AQ_S /f4/oradata/PROD13/sde_nris_water_aq_s01.dbf 10 0 7.00 1.00 2 0 0 0.00
SDE_NRIS_WILDLIFE_B /f3/oradata/PROD13/sde_nris_wildlife_b01.dbf 4 0 117.50 2.75 19 0 0 0.00
SDE_NRIS_WILDLIFE_I /f2/oradata/PROD13/sde_nris_wildlife_idx01.dbf 3 0 0.00 1.00 59 0 0 0.00
SDE_RASTER /f1/oradata/PROD13/sde_raster01.dbf 8 0 0.00 1.00 2 0 0 0.00
SDE_VECTOR_F /f1/oradata/PROD13/sde_vector_f01.dbf 8 0 1.25 1.00 2 0 0 0.00
SDE_VECTOR_S /f1/oradata/PROD13/sde_vector_s01.dbf 8 0 2.50 1.00 2 0 0 0.00
SRVC_DATA /f7/oradata/PROD13/srvc_data01.dbf 17 0 7.65 1.00 9 0 0 0.00
SRVC_IDX /f7/oradata/PROD13/srvc_indexes01.dbf 17 0 27.65 1.00 11 0 0 0.00
SYSAUX /f1/oradata/PROD13/sysaux01.dbf 1,535 0 20.85 1.14 472 0 0 0.00
SYSAUX /f1/oradata/PROD13/sysaux02.dbf 1,085 0 17.42 1.15 464 0 0 0.00
SYSAUX /f1/oradata/PROD13/sysaux03.dbf 375 0 26.72 1.01 173 0 0 0.00
SYSAUX /f1/oradata/PROD13/sysaux06.dbf 206 0 5.19 3.31 191 0 0 0.00
SYSAUX /f2/oradata/PROD13/sysaux07.dbf 57 0 12.81 12.25 78 0 0 0.00
SYSAUX /f3/oradata/PROD13/sysaux04.dbf 2,049 1 9.33 1.28 459 0 0 0.00
SYSAUX /f3/oradata/PROD13/sysaux05.dbf 876 0 16.22 1.61 537 0 0 0.00
SYSTEM /f3/oradata/PROD13/system01.dbf 35,137 10 16.99 2.05 992 0 18 20.00
TEMP /f3/oradata/PROD13/temp_01.dbf 47,872 13 491.07 2.88 129,111 36 0  
TEMP_GIS /f7/oradata/PROD13/temp_gis01.dbf 6 0 3.33 1.00 5 0 0  
TIMPA_DATA /f3/oradata/PROD13/timpa_data_01.dbf 138 0 33.62 1.28 10 0 0 0.00
TIMPA_IDX /f4/oradata/PROD13/timpa_idx_01.dbf 295 0 36.51 1.00 101 0 0 0.00
TPART1_NRIS_FSVEG /f5/oradata/PROD13/tpart1_nris_fsveg01.dbf 31,205 9 7.04 1.00 359 0 0 0.00
TPART2_NRIS_FSVEG /f6/oradata/PROD13/tpart2_nris_fsveg01.dbf 30,961 9 9.13 1.00 351 0 0 0.00
TPART3_NRIS_FSVEG /f7/oradata/PROD13/tpart3_nris_fsveg01.dbf 5,334 1 8.95 1.00 302 0 0 0.00
TPART4_NRIS_FSVEG /f8/oradata/PROD13/tpart4_nris_fsveg01.dbf 1,035 0 31.39 1.00 815 0 0 0.00
TPART4_NRIS_FSVEG /f8/oradata/PROD13/tpart4_nris_fsveg02.dbf 114 0 41.14 1.00 84 0 0 0.00
UCMDATA /f7/oradata/PROD13/ucmdata.dbf 4 0 5.00 1.00 2 0 0 0.00
UCMINDEX /f5/oradata/PROD13/ucmindex.dbf 4 0 2.50 1.00 2 0 0 0.00
UNDO_TBS1 /f7/oradata/PROD13/undo_tbs1.dbf 9,681 3 6.69 1.00 2,408 1 17 22.94
USERS /f3/oradata/PROD13/users01.dbf 13,708 4 6.83 4.55 386 0 0 0.00
USERS /f3/oradata/PROD13/users05.dbf 11,986 3 18.92 1.06 3,439 1 0 0.00
USERS /f5/oradata/PROD13/users02.dbf 16,194 5 8.13 4.60 204 0 3 0.00
USERS /f6/oradata/PROD13/users03.dbf 16,008 4 8.24 4.81 422 0 5 2.00
USERS /f6/oradata/PROD13/users04.dbf 19,207 5 9.24 1.25 1,743 0 0 0.00
USERS /f6/oradata/PROD13/users06.dbf 15,783 4 8.26 1.12 1,694 0 6 0.00
USERS_NRIS /f4/oradata/PROD13/users_nris01.dbf 1,653 0 9.87 2.00 35 0 0 0.00
USERS_NRIS_FAUNA /f3/oradata/PROD13/users_nris_fauna01.dbf 291 0 13.33 1.00 55 0 0 0.00
USERS_NRIS_FSVEG /f1/oradata/PROD13/users_nris_fsveg01.dbf 383 0 29.37 1.16 314 0 0 0.00
USERS_NRIS_INFORMS /f3/oradata/PROD13/users_nris_informs01.dbf 47 0 28.09 1.72 2 0 0 0.00
USERS_NRIS_TERRA /f5/oradata/PROD13/users_nris_terra01.dbf 759 0 17.00 1.11 16 0 0 0.00
USERS_NRIS_TESP /f5/oradata/PROD13/users_nris_tesp01.dbf 186 0 7.15 13.13 10 0 0 0.00
USERS_NRIS_WATER /f7/oradata/PROD13/users_nris_water01.dbf 6 0 3.33 1.00 2 0 0 0.00
WEBMDATA /f6/oradata/PROD13/webmdata01.dbf 10 0 4.00 1.00 2 0 0 0.00
WEBMINDX /f4/oradata/PROD13/webmindx01.dbf 10 0 3.00 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 407,986 99 413,166,771 2,738,100 65,825 0 59 5,676
8k 11,874 100 58,276 10 107 0 0 0
K 12,060   0 0 0 0 0 0


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 44 4331 86683 272371 1382400 272371  
E 0 39 2789 46867 299864 1382400 299864  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 656 0.10 41,205 2.68 139,185,829
D 1,312 0.20 82,410 2.22 115,335,102
D 1,968 0.29 123,615 1.87 97,320,774
D 2,624 0.39 164,820 1.62 84,209,963
D 3,280 0.49 206,025 1.43 74,441,268
D 3,936 0.59 247,230 1.29 67,206,942
D 4,592 0.69 288,435 1.19 61,849,008
D 5,248 0.78 329,640 1.11 57,846,813
D 5,904 0.88 370,845 1.05 54,837,455
D 6,560 0.98 412,050 1.01 52,492,112
D 6,704 1.00 421,095 1.00 52,013,332
D 7,216 1.08 453,255 0.97 50,647,493
D 7,872 1.17 494,460 0.94 49,142,271
D 8,528 1.27 535,665 0.92 47,885,558
D 9,184 1.37 576,870 0.90 46,781,606
D 9,840 1.47 618,075 0.88 45,774,977
D 10,496 1.57 659,280 0.86 44,845,157
D 11,152 1.66 700,485 0.85 43,970,143
D 11,808 1.76 741,690 0.83 43,116,689
D 12,464 1.86 782,895 0.81 42,247,498
D 13,120 1.96 824,100 0.79 41,345,074
8k 16 0.17 1,979 1.00 1,795
8k 32 0.33 3,958 1.00 1,795
8k 48 0.50 5,937 1.00 1,795
8k 64 0.67 7,916 1.00 1,795
8k 80 0.83 9,895 1.00 1,795
8k 96 1.00 11,874 1.00 1,795
8k 112 1.17 13,853 1.00 1,795
8k 128 1.33 15,832 1.00 1,795
8k 144 1.50 17,811 1.00 1,795
8k 160 1.67 19,790 1.00 1,795
8k 176 1.83 21,769 1.00 1,795
8k 192 2.00 23,748 1.00 1,795

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
88.00 30,693 4,184

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 MemGlobal Mem Bound(K)
B 2,800 832 4,061.45 1,191.86 29.35 100.00 0.00 1,024
E 2,800 533 4,923.88 1,534.95 31.17 99.93 0.07 1,024

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 1,065,188 1,065,188 0 0
64K 128K 283 283 0 0
128K 256K 246 246 0 0
256K 512K 310 310 0 0
512K 1024K 24,225 24,164 61 0
1M 2M 4,330 4,036 255 39
2M 4M 392 2 382 8
4M 8M 61 2 52 7
8M 16M 88 12 62 14
16M 32M 45 37 5 3
128M 256M 1 0 1 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
350 0.13 377,482.75 59,474.16 86.00 388
700 0.25 377,482.75 10,252.20 97.00 0
1,400 0.50 377,482.75 8,813.02 98.00 0
2,100 0.75 377,482.75 8,813.02 98.00 0
2,800 1.00 377,482.75 8,293.23 98.00 0
3,360 1.20 377,482.75 5,100.80 99.00 0
3,920 1.40 377,482.75 5,100.80 99.00 0
4,480 1.60 377,482.75 5,100.80 99.00 0
5,040 1.80 377,482.75 5,100.80 99.00 0
5,600 2.00 377,482.75 5,100.80 99.00 0
8,400 3.00 377,482.75 5,100.80 99.00 0
11,200 4.00 377,482.75 5,100.80 99.00 0
16,800 6.00 377,482.75 5,100.80 99.00 0
22,400 8.00 377,482.75 5,100.80 99.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
560 0.37 186 12,554 5,598,986 0.99 89,651 3.47 83,757,357
720 0.47 328 17,595 5,610,403 0.99 78,234 3.03 83,791,429
880 0.58 486 23,453 5,621,570 0.99 67,067 2.60 83,822,050
1,040 0.68 642 29,974 5,632,455 0.99 56,182 2.17 83,849,084
1,200 0.79 798 36,555 5,642,960 1.00 45,677 1.77 83,872,157
1,360 0.89 961 42,112 5,653,094 1.00 35,543 1.38 83,891,206
1,520 1.00 1,106 46,405 5,662,803 1.00 25,834 1.00 83,907,046
1,680 1.11 1,262 50,035 5,672,071 1.00 16,566 0.64 83,920,187
1,840 1.21 1,416 54,548 5,680,884 1.00 7,753 0.30 83,931,140
2,000 1.32 1,575 59,310 5,689,209 1.00 1 0.00 83,940,459
2,160 1.42 1,730 63,226 5,697,060 1.01 1 0.00 83,948,533
2,320 1.53 1,887 69,218 5,704,470 1.01 1 0.00 83,955,597
2,480 1.63 2,042 73,605 5,711,493 1.01 1 0.00 83,961,810
2,640 1.74 2,171 76,770 5,718,201 1.01 1 0.00 83,967,335
2,800 1.84 2,329 81,405 5,724,682 1.01 1 0.00 83,972,189
2,960 1.95 2,479 85,279 5,731,064 1.01 1 0.00 83,976,558
3,120 2.05 2,597 87,352 5,737,451 1.01 1 0.00 83,980,542

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,152 0.25 3,665,248 114,270,479
4,304 0.50 3,299,208 73,754,934
6,456 0.75 3,128,005 61,277,811
8,608 1.00 3,030,094 52,009,685
10,760 1.25 2,990,622 47,448,436
12,912 1.50 2,964,264 44,431,874
15,064 1.75 2,950,663 40,968,029
17,216 2.00 2,951,811 40,968,029

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst 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

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
32 0.33 4 150 38 1.00 25,840 1.00 202
48 0.50 4 150 38 1.00 25,840 1.00 202
64 0.67 4 150 38 1.00 25,840 1.00 202
80 0.83 4 150 38 1.00 25,840 1.00 202
96 1.00 4 150 38 1.00 25,840 1.00 202
112 1.17 4 150 38 1.00 25,840 1.00 202
128 1.33 4 150 38 1.00 25,840 1.00 202
144 1.50 4 150 38 1.00 25,840 1.00 202
160 1.67 4 150 38 1.00 25,840 1.00 202
176 1.83 4 150 38 1.00 25,840 1.00 202
192 2.00 4 150 38 1.00 25,840 1.00 202
208 2.17 4 150 38 1.00 25,840 1.00 202

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 5,607 49 9
undo header 17 0 23
1st level bmb 1 0 0
2nd level bmb 1 0 0
segment header 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 60 12 50 7 6,576 939,460.29
RO-Multiple Object Reuse (fast object reuse) 216 216 0 24 124 5,157.42
JI-Materialized View 76 70 6 11 37 3,386.82
HW-Segment High Water Mark 2,792 2,708 84 66 11 160.42
CF-Controlfile Transaction 4,765 4,757 8 8 7 916.25
JS-Job Scheduler (queue lock) 17,760 17,760 0 12 4 367.92
TX-Transaction (index contention) 174 174 0 9 1 123.22

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
24 5.41 47,116 22,070 55 318.966666666666666666666666666666666667/378.85 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
28-Sep 13:07 431 6,260 22,070 51 379 0/0 0/0/0/0/0/0
28-Sep 12:57 694 6,858 21,461 55 369 0/0 0/0/0/0/0/0
28-Sep 12:47 422 4,752 20,852 54 359 0/0 0/0/0/0/0/0
28-Sep 12:37 975 8,512 20,243 52 349 0/0 0/0/0/0/0/0
28-Sep 12:27 709 6,098 19,633 51 339 0/0 0/0/0/0/0/0
28-Sep 12:17 888 7,158 19,025 44 329 0/0 0/0/0/0/0/0
28-Sep 12:07 1,295 7,478 18,416 52 319 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 2,288 0.00   0 0  
AWR Alerted Metric Element list 120,041 0.00   0 0  
Consistent RBA 26,030 0.00   0 0  
FAL request queue 121 0.00   0 0  
FAL subheap alocation 119 0.00   0 0  
FIB s.o chain latch 1,195 0.00   0 0  
FOB s.o list latch 21,329 0.00 0.00 0 0  
JOX SGA heap latch 876 0.00   0 0  
JS Sh mem access 24 0.00   0 0  
JS mem alloc latch 28 0.00   0 0  
JS queue access latch 28 0.00   0 0  
JS queue state obj latch 35,520 0.00   0 0  
JS slv state obj latch 105 0.00   0 0  
KMG MMAN ready and startup request latch 11,515 0.00   0 0  
KMG resize request state object freelist 178 0.00   0 0  
KTF sga latch 209 0.00   0 1,200 0.00
KWQMN job cache list latch 27 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 71 0.00
Memory Management Latch 10,986 0.01 0.00 0 11,444 0.00
OS process 7,677 0.00   0 0  
OS process allocation 6,686 0.00   0 0  
OS process: request allocation 5,382 0.00   0 0  
PL/SQL warning settings 449,448 0.00   0 0  
Reserved Space Latch 21 0.00   0 0  
SQL memory manager latch 1 0.00   0 1,045 0.00
SQL memory manager workarea list latch 2,988,637 0.01 0.00 0 0  
Shared B-Tree 154 0.00   0 0  
active checkpoint queue latch 22,897 0.06 0.00 0 0  
active service list 21,624 0.00 0.00 0 1,690 0.00
alert log latch 108 0.00   0 0  
archive control 414 0.00   0 0  
archive process latch 1,160 0.00   0 0  
begin backup scn array 610 0.00   0 0  
buffer pool 1,429 0.00   0 0  
cache buffer handles 1,646,088 0.03 0.00 0 0  
cache buffers chains 653,999,118 0.18 0.00 0 7,240,854 0.01
cache buffers lru chain 326,820 0.09 0.05 0 7,047,857 0.09
cache table scan latch 0     0 189,007 0.09
channel handle pool latch 8,098 0.00   0 0  
channel operations parent latch 41,735 0.12 0.00 0 0  
checkpoint queue latch 1,405,120 0.00 0.00 0 106,513 0.00
client/application info 35,080 0.00   0 0  
commit callback allocation 380 0.00   0 0  
compile environment latch 70,957 0.00   0 0  
constraint object allocation 140 0.00   0 0  
dictionary lookup 86 0.00   0 0  
dml lock allocation 233,754 0.03 0.00 0 0  
dummy allocation 5,360 0.00   0 0  
enqueue hash chains 717,850 0.00 0.00 0 7,622 0.00
enqueues 438,528 0.05 0.00 0 0  
event group latch 2,881 0.00   0 0  
event range base latch 1 0.00   0 0  
file cache latch 1,513 0.00   0 0  
flashback FBA barrier 2 0.00   0 0  
flashback SCN barrier 4 0.00   0 0  
flashback allocation 42,240 0.00 0.00 0 0  
flashback copy 0     0 38,268 0.01
flashback hint SCN barrier 2 0.00   0 0  
flashback mapping 2,279 0.00   0 0  
flashback sync request 2,644 0.00   0 0  
global KZLD latch for mem in SGA 2,821 0.00   0 0  
global ctx hash table latch 10,638 0.00   0 0  
global tx hash mapping 72,104 0.00   0 1 0.00
hash table column usage latch 4,128 0.19 0.00 0 12,082,254 0.00
hash table modification latch 313 0.00   0 0  
hint flashback FBA barrier 2 0.00   0 0  
job workq parent latch 0     0 34 0.00
job_queue_processes parameter latch 76 0.00   0 0  
kks stats 106,595 0.05 0.67 7 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
ksuosstats global area 245 0.00   0 0  
ktm global data 1,770 0.00   0 0  
kwqbsn:qsga 153 0.00   0 0  
lgwr LWN SCN 26,050 0.00   0 0  
library cache 11,381,593 0.05 0.15 75 173,105 272.60
library cache load lock 60,909 0.01 0.00 0 543 0.00
library cache lock 1,811,718 0.00 0.01 0 0  
library cache lock allocation 78,953 0.00   0 0  
library cache pin 6,124,981 0.01 0.00 0 0  
library cache pin allocation 35,379 0.00   0 0  
list of block allocation 7,492 0.00   0 0  
loader state object freelist 1,871 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 40,440 0.00   0 714 0.00
message pool operations parent latch 3,656 0.00   0 0  
messages 171,718 0.06 0.00 0 0  
mostly latch-free SCN 26,101 0.08 0.00 0 0  
multiblock read objects 573,967 0.02 0.00 0 0  
ncodef allocation latch 81 0.00   0 0  
object queue header heap 300,439 0.00 0.00 0 34,343 0.00
object queue header operation 5,950,322 0.00 0.00 0 40,140 0.00
object stats modification 337 0.00   0 0  
parallel query alloc buffer 444 0.00   0 0  
parameter list 2,824 0.00   0 0  
parameter table allocation management 4,165 0.26 0.27 0 0  
post/wait queue 104,427 1.05 0.00 0 25,140 0.00
process allocation 5,382 0.04 1.00 0 2,881 0.00
process group creation 5,382 0.00   0 0  
qmn task queue latch 508 0.00   0 0  
redo allocation 79,760 0.04 0.00 0 666,825 0.05
redo copy 96 0.00   0 666,933 0.12
redo writing 103,286 0.03 0.00 0 0  
reservation so alloc latch 10 0.00   0 0  
resmgr group change latch 11,607 0.00   0 0  
resmgr:actses active list 11,059 0.43 0.35 0 0  
resmgr:actses change group 14,267 0.00   0 0  
resmgr:free threads list 5,334 0.00   0 0  
resmgr:schema config 3 0.00   0 0  
row cache objects 40,440,372 0.25 0.00 79 26,003 0.85
rules engine aggregate statistics 3 0.00   0 0  
rules engine rule set statistics 106 0.00   0 0  
sequence cache 40,926 0.00   0 0  
session allocation 3,277,395 0.91 0.00 0 0  
session idle bit 1,294,124 0.00 0.00 0 0  
session state list latch 7,705 0.01 0.00 0 0  
session switching 81 0.00   0 0  
session timer 1,689 0.00   0 0  
shared pool 2,331,205 0.36 0.50 211 0  
shared pool simulator 2,182,851 0.00 0.06 0 0  
simulator hash latch 17,213,048 0.00 0.00 0 0  
simulator lru latch 16,448,550 0.15 0.00 0 568,957 0.15
slave class 13 0.00   0 0  
slave class create 53 0.00   0 0  
sort extent pool 19,727 0.04 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 196 0.00   0 0  
temp lob duration state obj allocation 14 0.00   0 0  
temporary table state object allocation 22 0.00   0 0  
threshold alerts latch 1,838 0.00   0 0  
trace latch 425 0.00   0 0  
transaction allocation 182,351 0.00   0 0  
transaction branch allocation 23,397 0.00   0 0  
undo global data 16,221,156 0.07 0.00 0 4,816 0.00
user lock 21,408 0.17 0.61 4 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 653,999,118 1,158,705 692 1,158,025 0 0 0
row cache objects 40,440,372 102,019 284 101,777 0 0 0
session allocation 3,277,395 29,867 86 29,782 0 0 0
simulator lru latch 16,448,550 24,430 101 24,329 0 0 0
undo global data 16,221,156 10,880 1 10,879 0 0 0
shared pool 2,331,205 8,355 4,216 5,585 0 0 0
library cache 11,381,593 5,437 811 4,875 0 0 0
post/wait queue 104,427 1,095 3 1,092 0 0 0
library cache pin 6,124,981 426 1 425 0 0 0
cache buffers lru chain 326,820 279 15 264 0 0 0
SQL memory manager workarea list latch 2,988,637 273 1 272 0 0 0
library cache lock 1,811,718 90 1 89 0 0 0
kks stats 106,595 54 36 23 0 0 0
resmgr:actses active list 11,059 48 17 31 0 0 0
user lock 21,408 36 22 14 0 0 0
shared pool simulator 2,182,851 34 2 32 0 0 0
parameter table allocation management 4,165 11 3 8 0 0 0
process allocation 5,382 2 2 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 929 814
cache buffers chains kcbrls: kslbegin 0 430 607
cache buffers chains kcbgtcr: fast path 0 73 39
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 20 24
cache buffers chains kcbzgb: scan from tail. nowait 0 18 0
cache buffers chains kcbzib: multi-block read: nowait 0 10 0
cache buffers chains kcbget: pin buffer 0 8 1
cache buffers chains kcbgcur: kslbegin 0 2 0
cache buffers chains kcbgtcr: kslbegin shared 0 2 0
cache buffers chains kcbzwb 0 2 1
cache buffers chains kcbgtcr 0 1 0
cache buffers chains kcbw_next_free 0 1 0
cache buffers lru chain kcbzgws 0 15 0
cost function kzulgt: find user res 0 18 16
cost function kzulrl 0 5 7
kks stats kks stats alloc/free 0 36 36
library cache kglpndl: child: after processing 0 76 5
library cache kgldti: 2child 0 61 22
library cache kglobpn: child: 0 37 64
library cache kglhdgn: child: 0 24 59
library cache kglpnp: child 0 24 89
library cache kglLockCursor 0 18 33
library cache kglpin 0 15 14
library cache kglScanDependency 0 10 0
library cache kglic 0 6 0
library cache kglpndl: child: before processing 0 6 54
library cache kglukp: child 0 6 1
library cache kglati 0 3 1
library cache kglhdgc: child: 0 3 0
library cache kglnti 0 3 0
library cache kgldtld: 2child 0 2 4
library cache kglhdbrnl: child 0 2 1
library cache kglivr: child 0 2 0
library cache kglobld 0 2 12
library cache kgldte: child 0 0 1 4
library cache kglhdiv: child 0 1 1
library cache lock kgllkdl: child: no lock handle 0 51 18
library cache lock kglhdbrnl: child 0 1 0
library cache pin kglpndl 0 1 1
parameter table allocation management ksp_param_table_free 0 4 3
post/wait queue ksliwat:remove 0 2 2
post/wait queue kslpstevent:get 0 1 2
process allocation ksucrp 0 2 0
resmgr:actses active list kgskchclass 0 23 21
row cache objects kqreqd: reget 0 196 2
row cache objects kqreqd 0 47 30
row cache objects kqrpre: find obj 0 39 256
row cache objects kqrso 0 16 3
session allocation ksufap: active sessions 0 21 0
session allocation ksuprc 0 20 39
session allocation ksuxds: KSUSFCLC not set 0 18 0
session allocation kspallmod 0 15 0
session allocation ksudlc 0 8 33
session allocation ksucri 0 3 8
session allocation ksuxds: not user session 0 2 7
session allocation ksuxds: KSUSFCLC set 0 1 0
shared pool kgh_next_free 0 3,462 151
shared pool kghfrunp: clatch: wait 0 528 520
shared pool kghalo 0 396 2,213
shared pool kghfrunp: alloc: wait 0 382 283
shared pool kghupr1 0 157 764
shared pool kghalp 0 126 772
shared pool kghfre 0 117 445
shared pool kgh: add extent to quiesced list 0 52 66
shared pool kghfrunp: clatch: nowait 0 35 0
shared pool kgh: quiesce extents 0 30 3
shared pool kghfrunp: alloc: session dur 0 23 3
shared pool kgh: sim resz update 0 16 1
shared pool kghfrunp 0 15 0
shared pool kghasp 0 9 80
shared pool kgh: add extent to reserved list 0 1 2
shared pool kghfrh 0 1 0
shared pool kghquiesce: clatch: nowait 0 1 0
shared pool simulator kglsim_unpin_simhp 0 2 0
simulator lru latch kcbs_shrink_pool 0 49 0
simulator lru latch kcbs_free_granule_sim_buffers 0 28 0
simulator lru latch kcbs_simulate: simulate set 0 15 101
simulator lru latch kcbs_grow_pool 0 14 0
simulator lru latch kcbs_resize_pool : interpolation 0 2 0
undo global data kturimugur: child 0 1 1

Back to Latch Statistics
Back to Top

Parent Latch Statistics

Latch NameGet RequestsMissesSleepsSpin & Sleeps 1->3+
parameter table allocation management 4,380 14 4 10/0/0/0
process allocation 5,508 2 2 0/0/0/0
resmgr:actses active list 11,244 56 23 33/0/0/0
session allocation 3,921,578 34,349 88 34262/0/0/0
user lock 23,418 39 23 16/0/0/0

Back to Latch Statistics
Back to Top

Child Latch Statistics

Latch NameChild NumGet RequestsMissesSleepsSpin & Sleeps 1->3+
SQL memory manager workarea list latch 12 47,877 6 1 5/0/0/0
cache buffers chains 17698 1,434,609 3,665 16 3649/0/0/0
cache buffers chains 11016 1,174,984 1,408 22 1386/0/0/0
cache buffers chains 27467 124,405 24 2 23/0/0/0
cache buffers chains 1514 92,860 5 1 4/0/0/0
cache buffers chains 17166 90,145 10 1 9/0/0/0
cache buffers chains 6647 87,238 14 1 13/0/0/0
cache buffers chains 19163 87,226 15 1 14/0/0/0
cache buffers chains 27601 86,539 18 1 17/0/0/0
cache buffers chains 20991 84,575 23 1 22/0/0/0
cache buffers chains 7349 82,014 17 1 16/0/0/0
cache buffers chains 19446 81,496 3 1 2/0/0/0
cache buffers chains 22819 81,008 23 1 22/0/0/0
cache buffers chains 5521 79,089 18 2 16/0/0/0
cache buffers chains 8736 75,188 5 1 4/0/0/0
cache buffers chains 30944 64,654 2 1 1/0/0/0
cache buffers chains 2136 62,996 1 1 0/0/0/0
cache buffers chains 11428 59,012 3 1 2/0/0/0
cache buffers chains 13098 58,538 4 1 3/0/0/0
cache buffers chains 26180 57,125 2 1 1/0/0/0
cache buffers chains 22373 56,760 2 1 1/0/0/0
cache buffers chains 18350 55,104 3 1 2/0/0/0
cache buffers chains 14057 54,520 5 1 4/0/0/0
cache buffers chains 9236 54,478 1 1 0/0/0/0
cache buffers chains 1332 54,252 3 1 2/0/0/0
cache buffers chains 13418 54,200 2 1 1/0/0/0
cache buffers chains 22534 52,830 2 1 1/0/0/0
cache buffers chains 28193 52,493 3 1 2/0/0/0
cache buffers chains 18170 50,897 2 1 1/0/0/0
cache buffers chains 19748 49,727 7 1 6/0/0/0
cache buffers chains 5404 49,445 2 1 1/0/0/0
cache buffers chains 11138 46,778 4 1 3/0/0/0
cache buffers chains 22279 44,491 5 1 4/0/0/0
cache buffers chains 19950 44,349 8 1 7/0/0/0
cache buffers chains 10909 42,284 30 1 29/0/0/0
cache buffers chains 21494 40,724 23 1 22/0/0/0
cache buffers chains 22300 40,132 22 1 21/0/0/0
cache buffers chains 28375 39,728 5 1 4/0/0/0
cache buffers chains 5667 39,503 21 1 20/0/0/0
cache buffers chains 29982 37,597 10 2 8/0/0/0
cache buffers chains 18540 36,198 14 1 13/0/0/0
cache buffers chains 17838 36,082 23 1 22/0/0/0
cache buffers chains 26326 35,829 18 2 16/0/0/0
cache buffers chains 28526 35,737 17 1 16/0/0/0
cache buffers chains 7918 35,266 21 2 19/0/0/0
cache buffers chains 16712 35,261 25 2 23/0/0/0
cache buffers chains 31123 35,205 17 1 16/0/0/0
cache buffers chains 19666 35,109 19 2 17/0/0/0
cache buffers chains 24921 34,971 15 1 14/0/0/0
cache buffers chains 15507 34,872 21 1 20/0/0/0
cache buffers chains 11851 34,678 19 1 18/0/0/0
cache buffers chains 28577 34,324 37 1 36/0/0/0
cache buffers chains 7852 34,223 9 2 7/0/0/0
cache buffers chains 13810 34,014 15 1 14/0/0/0
cache buffers chains 18963 33,899 25 1 24/0/0/0
cache buffers chains 18606 33,772 16 1 15/0/0/0
cache buffers chains 27044 33,736 20 1 19/0/0/0
cache buffers chains 7215 33,626 13 1 12/0/0/0
cache buffers chains 25573 33,433 38 1 37/0/0/0
cache buffers chains 8977 33,362 16 1 15/0/0/0
cache buffers chains 28872 33,325 25 2 23/0/0/0
cache buffers chains 21137 33,152 14 2 13/0/0/0
cache buffers chains 30354 33,150 19 1 18/0/0/0
cache buffers chains 31825 33,086 11 2 9/0/0/0
cache buffers chains 29238 32,727 3 1 2/0/0/0
cache buffers chains 28169 32,561 15 1 14/0/0/0
cache buffers chains 21545 32,487 18 1 17/0/0/0
cache buffers chains 27401 32,472 25 1 24/0/0/0
cache buffers chains 17516 32,220 16 6 10/0/0/0
cache buffers chains 23796 32,172 16 1 15/0/0/0
cache buffers chains 22247 32,140 16 1 15/0/0/0
cache buffers chains 5321 32,044 19 2 17/0/0/0
cache buffers chains 17481 31,927 20 2 18/0/0/0
cache buffers chains 8275 31,887 21 2 19/0/0/0
cache buffers chains 29997 31,640 21 3 19/0/0/0
cache buffers chains 16778 31,569 20 1 19/0/0/0
cache buffers chains 18261 31,555 43 2 41/0/0/0
cache buffers chains 27452 31,508 17 1 16/0/0/0
cache buffers chains 10526 31,323 24 2 22/0/0/0
cache buffers chains 14884 30,902 15 1 14/0/0/0
cache buffers chains 11931 30,821 28 1 27/0/0/0
cache buffers chains 4964 30,495 22 1 21/0/0/0
cache buffers chains 4619 30,398 13 1 12/0/0/0
cache buffers chains 6075 30,293 15 1 14/0/0/0
cache buffers chains 9043 30,233 17 1 16/0/0/0
cache buffers chains 7903 29,450 17 1 16/0/0/0
cache buffers chains 6447 29,278 11 1 10/0/0/0
cache buffers chains 15661 28,295 3 2 1/0/0/0
cache buffers chains 22117 27,830 17 1 16/0/0/0
cache buffers chains 9828 27,490 1 1 0/0/0/0
cache buffers chains 29336 25,842 2 1 1/0/0/0
cache buffers chains 12208 24,243 105 1 104/0/0/0
cache buffers chains 32604 22,433 5 3 2/0/0/0
cache buffers chains 31442 21,841 1 1 0/0/0/0
cache buffers chains 18058 20,904 170 2 168/0/0/0
cache buffers chains 11026 20,069 154 1 153/0/0/0
cache buffers chains 1066 18,601 4 1 3/0/0/0
cache buffers chains 3147 18,263 1 1 0/0/0/0
cache buffers chains 18546 17,222 10 1 9/0/0/0
cache buffers chains 15777 15,143 1 1 0/0/0/0
cache buffers chains 4699 14,690 1 1 0/0/0/0
cache buffers chains 14857 14,655 169 1 168/0/0/0
cache buffers chains 21058 14,278 3 1 2/0/0/0
cache buffers chains 473 14,245 1 1 0/0/0/0
cache buffers chains 21714 14,076 222 3 219/0/0/0
cache buffers chains 31700 13,819 136 3 133/0/0/0
cache buffers chains 21466 13,780 167 2 165/0/0/0
cache buffers chains 30327 13,518 219 1 218/0/0/0
cache buffers chains 14682 13,380 116 1 115/0/0/0
cache buffers chains 6286 13,232 2 1 1/0/0/0
cache buffers chains 21601 13,034 1 1 0/0/0/0
cache buffers chains 3249 12,577 5 1 4/0/0/0
cache buffers chains 28460 11,892 162 1 161/0/0/0
cache buffers chains 31980 11,586 130 1 129/0/0/0
cache buffers chains 27468 11,191 2 1 1/0/0/0
cache buffers chains 14624 11,027 1 1 0/0/0/0
cache buffers chains 14474 10,174 1 1 0/0/0/0
cache buffers chains 18321 10,027 1 1 0/0/0/0
cache buffers chains 25784 9,801 4 1 3/0/0/0
cache buffers chains 23176 9,299 1 1 0/0/0/0
cache buffers chains 31452 9,068 123 1 122/0/0/0
cache buffers chains 3984 8,904 1 1 0/0/0/0
cache buffers chains 20549 8,580 1 1 0/0/0/0
cache buffers chains 21850 6,912 2 1 1/0/0/0
cache buffers chains 1110 6,905 1 1 0/0/0/0
cache buffers chains 4866 6,815 1 1 0/0/0/0
cache buffers chains 222 6,694 1 1 0/0/0/0
cache buffers chains 9653 6,467 2 1 1/0/0/0
cache buffers chains 10208 6,434 1 1 0/0/0/0
cache buffers chains 13251 6,323 1 1 0/0/0/0
cache buffers chains 11423 6,020 1 1 0/0/0/0
cache buffers chains 27083 6,014 1 1 0/0/0/0
cache buffers chains 28936 5,682 2 1 1/0/0/0
cache buffers chains 11998 5,658 2 1 1/0/0/0
cache buffers chains 7963 5,260 1 1 0/0/0/0
cache buffers chains 8373 5,135 1 1 0/0/0/0
cache buffers chains 16706 5,127 1 1 0/0/0/0
cache buffers chains 27045 5,118 1 1 0/0/0/0
cache buffers chains 1432 4,897 1 1 0/0/0/0
cache buffers chains 14246 4,815 1 1 0/0/0/0
cache buffers chains 4390 4,789 2 1 1/0/0/0
cache buffers chains 11135 4,752 2 1 1/0/0/0
cache buffers chains 27701 4,667 2 1 1/0/0/0
cache buffers chains 11528 4,568 2 1 1/0/0/0
cache buffers chains 29488 4,305 1 1 0/0/0/0
cache buffers chains 20600 4,252 1 1 0/0/0/0
cache buffers chains 977 4,222 1 1 0/0/0/0
cache buffers chains 31476 4,155 1 1 0/0/0/0
cache buffers chains 28504 4,038 1 1 0/0/0/0
cache buffers chains 28306 3,886 1 1 0/0/0/0
cache buffers chains 23508 3,829 1 1 0/0/0/0
cache buffers chains 14059 3,765 1 1 0/0/0/0
cache buffers chains 1204 3,744 1 1 0/0/0/0
cache buffers chains 20000 3,480 1 1 0/0/0/0
cache buffers chains 20666 3,395 1 1 0/0/0/0
cache buffers chains 27448 3,217 1 1 0/0/0/0
cache buffers chains 27896 3,191 1 1 0/0/0/0
cache buffers chains 27517 3,080 1 1 0/0/0/0
cache buffers chains 17124 3,056 1 1 0/0/0/0
cache buffers chains 12510 2,831 2 1 1/0/0/0
cache buffers chains 28040 2,815 3 1 2/0/0/0
cache buffers chains 5999 2,651 1 1 0/0/0/0
cache buffers chains 22605 2,410 1 1 0/0/0/0
cache buffers chains 30360 2,290 1 1 0/0/0/0
cache buffers chains 9936 2,249 1 1 0/0/0/0
cache buffers chains 25030 2,104 1 1 0/0/0/0
cache buffers chains 1251 1,833 1 1 0/0/0/0
cache buffers chains 3722 1,712 1 1 0/0/0/0
cache buffers chains 16732 1,530 1 1 0/0/0/0
cache buffers chains 12336 1,481 1 1 0/0/0/0
cache buffers chains 32390 1,445 1 1 0/0/0/0
cache buffers lru chain 26 27,898 22 1 21/0/0/0
cache buffers lru chain 29 27,517 22 2 20/0/0/0
cache buffers lru chain 31 27,372 28 2 26/0/0/0
cache buffers lru chain 33 26,942 28 2 26/0/0/0
cache buffers lru chain 30 26,604 26 3 23/0/0/0
cache buffers lru chain 27 26,442 25 2 23/0/0/0
cache buffers lru chain 28 26,220 23 1 22/0/0/0
cache buffers lru chain 36 25,754 28 2 26/0/0/0
kks stats 4 28,391 19 7 12/0/0/0
kks stats 3 28,258 14 17 2/0/0/0
kks stats 1 27,960 17 11 6/0/0/0
kks stats 2 27,537 4 1 3/0/0/0
library cache 23 1,612,779 489 24 465/0/0/0
library cache 2 1,449,196 642 31 613/0/0/0
library cache 29 1,446,685 547 15 533/0/0/0
library cache 16 1,435,901 516 25 493/0/0/0
library cache 19 522,924 183 9 174/0/0/0
library cache 14 481,224 166 21 146/0/0/0
library cache 21 318,132 121 27 96/0/0/0
library cache 24 318,119 152 15 138/0/0/0
library cache 28 309,184 155 24 132/0/0/0
library cache 3 300,069 166 19 147/0/0/0
library cache 1 284,125 89 4 85/0/0/0
library cache 9 283,446 200 19 181/0/0/0
library cache 8 278,062 959 473 722/0/0/0
library cache 7 271,348 165 11 154/0/0/0
library cache 4 235,516 111 25 86/0/0/0
library cache 13 222,134 85 3 82/0/0/0
library cache 25 153,153 50 4 46/0/0/0
library cache 18 149,561 65 2 63/0/0/0
library cache 12 141,631 59 10 49/0/0/0
library cache 22 141,458 88 22 68/0/0/0
library cache 11 133,139 46 3 43/0/0/0
library cache 10 121,606 62 4 59/0/0/0
library cache 27 121,559 51 12 39/0/0/0
library cache 26 116,943 38 9 29/0/0/0
library cache 6 104,833 32 7 25/0/0/0
library cache 5 101,232 45 8 37/0/0/0
library cache 17 98,849 30 3 27/0/0/0
library cache 20 97,550 72 17 55/0/0/0
library cache lock 8 74,924 8 1 7/0/0/0
post/wait queue 4 30,722 129 3 126/0/0/0
row cache objects 12 7,818,390 14,592 133 14487/0/0/0
row cache objects 14 1,859,172 1,314 59 1261/0/0/0
row cache objects 9 1,199,462 1,282 71 1211/0/0/0
row cache objects 10 122,243 106 37 95/0/0/0
shared pool 6 570,784 1,770 439 1386/0/0/0
shared pool 3 457,631 1,732 1,250 1003/0/0/0
shared pool 4 455,416 1,564 779 1039/0/0/0
shared pool 5 375,925 612 167 473/0/0/0
shared pool 2 374,851 2,811 1,890 1718/0/0/0
shared pool 1 326,482 656 255 473/0/0/0
simulator lru latch 86 87 2 2 0/0/0/0
simulator lru latch 42 86 1 1 0/0/0/0
simulator lru latch 24 86 1 1 0/0/0/0
simulator lru latch 85 86 1 1 0/0/0/0

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
UMA USERS UMA_USER_ROLE_ORGS_PK   INDEX 71,522,896 17.30
FSDBA DATA_MED TIM_CUSTOMERS   TABLE 50,517,936 12.22
FSDBA INDEXES FACT_TRSSAL_PK   INDEX 42,269,632 10.22
FSDBA INDEXES LU_PK   INDEX 30,295,616 7.33
FSDBA DATA_MED LAND_UNITS   TABLE 23,914,832 5.78

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
FSDBA DATA FACT_ACTIVITIES   TABLE 826,767 28.65
FSDBA DATA_MED II_FEATURES   TABLE 332,649 11.53
FSDBA DATA_MED II_EVENTS   TABLE 167,757 5.81
FSDBA DATA_BIG II_TASKS   TABLE 65,875 2.28
SYS AUDIT_TS AUD$   TABLE 59,750 2.07

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
FS_NRIS_FSVEG INDEXES_NRIS_FSVEG NRV_SETTING_MEASUREMENTS_PK   INDEX 223 28.37
FSDBA DATA FACT_ACT_FUNDING   TABLE 96 12.21
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY_PK 5700_64694 INDEX PARTITION 48 6.11
FS_NRIS_FSVEG INDEXES_NRIS_FSVEG NRV_SAMPLE_DESIGNS_PK   INDEX 42 5.34
FS_NRIS_FSVEG IPART2_NRIS_FSVEG NRV_TREE_MEASUREMENTS_PK   INDEX 23 2.93

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

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
FSDBA DATA II_GA_FUNDS_ALL_LINE_SUMM_V   TABLE 27 48.21
IWEB_APP_USER USERS PS_TXN_PK   INDEX 6 10.71
SYS SYSTEM SEQ$   TABLE 5 8.93
SYS AUDIT_TS I_AUD1   INDEX 4 7.14
FS_NRIS_FSVEG IPART2_NRIS_FSVEG NRV_TREE_MEASUREMENTS_PK   INDEX 3 5.36

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 97 1.03 0   2 1
dc_constraints 255 52.94 0   255 33
dc_database_links 867 0.46 0   0 4
dc_global_oids 42,484 1.25 0   0 20
dc_histogram_data 1,705,472 4.25 0   0 4,889
dc_histogram_defs 478,042 9.02 0   0 1,873
dc_object_grants 303,816 1.38 0   0 4,350
dc_object_ids 2,620,028 0.23 0   53 2,357
dc_objects 320,223 4.90 0   340 3,737
dc_profiles 4,725 0.15 0   0 3
dc_rollback_segments 36,831 0.00 0   0 625
dc_segments 456,360 1.62 0   542 2,784
dc_sequences 4,979 2.03 0   4,978 32
dc_table_scns 2,751 0.91 0   78 13
dc_tablespace_quotas 241 1.66 0   119 3
dc_tablespaces 3,219,462 0.01 0   0 38
dc_usernames 641,670 0.19 0   0 342
dc_users 6,365,248 0.03 0   1 1,034
global database name 22 0.00 0   0 1
kqlsubheap_object 4,485 0.07 0   0 10
outstanding_alerts 886 48.76 0   4 145


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 6,189 0.65 800,096 0.05 366 0
CLUSTER 1,140 0.53 1,660 1.14 13 0
INDEX 3,288 4.14 4,384 9.95 254 0
JAVA DATA 1 0.00 0   0 0
PIPE 21 14.29 21 14.29 0 0
SQL AREA 15,903 62.57 3,253,293 4.33 19,418 8,699
TABLE/PROCEDURE 164,653 5.40 2,310,652 1.49 20,947 0
TRIGGER 5,539 3.23 97,081 1.51 1,215 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 2,037.79   1.84 3.29 44 44 1,108 1,108
  SQL 1,456.36 1,377.91 1.33 3.29 54 406 1,092 1,092
  Freeable 493.63 0.00 0.96 4.22 96   512 512
  PL/SQL 75.94 31.86 0.07 0.05 0 0 1,106 1,106
E Other 2,338.02   1.64 2.65 44 44 1,426 1,426
  SQL 1,905.88 1,798.95 1.35 3.02 54 160 1,411 1,408
  Freeable 598.31 0.00 1.00 3.94 95   600 600
  PL/SQL 84.87 40.32 0.06 0.04 1 1 1,424 1,424

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 6,643,777,536 7,298,088,960
Fixed Size 2,046,488  
Redo Buffers 14,729,216  
Variable Size 3,305,113,064 2,650,801,640

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 89.22 89.22 0.01
java joxlod exec hp 6.53 6.52 -0.12
large free memory 15.94 15.94 0.00
shared ASH buffers 40.50 40.50 0.00
shared CCursor 135.96 61.94 -54.44
shared KGH: NO ACCESS 844.65 1,538.68 82.17
shared KGLS heap 37.84   -100.00
shared PCursor 68.43   -100.00
shared free memory 723.43 856.21 18.35
shared library cache 103.38 79.11 -23.48
shared sql area 668.43 228.33 -65.84
streams free memory 16.00 16.00 0.00
  buffer_cache 6,336.00 6,960.00 9.85
  fixed_sga 1.95 1.95 0.00
  log_buffer 14.05 14.05 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 432,442 2,903,063 0
QMON Coordinator 162,789 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 NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 4 0 0 88 280

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
processes 1,428 1,507 1800 1800
sessions 1,910 1,985 1985 1985


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_db_block_numa 1   
_enable_NUMA_optimization FALSE   
archive_lag_target 0   
audit_file_dest /f10/oradata/audit/PROD13   
audit_sys_operations TRUE   
audit_trail DB, EXTENDED   
background_dump_dest /oracle/product/admin/PROD13/bdump   
compatible 10.2.0   
control_file_record_keep_time 56   
control_files /f1/oradata/PROD13/control01.ctl, /f2/oradata/PROD13/control02.ctl, /f3/oradata/PROD13/control03.ctl   
core_dump_dest /oracle/product/admin/PROD13/cdump   
cursor_sharing EXACT   
db_8k_cache_size 100663296   
db_block_size 16384   
db_domain fs.usda.gov   
db_file_multiblock_read_count 16   
db_file_name_convert /iwebcoop/, /PROD13/   
db_flashback_retention_target 1440   
db_keep_cache_size 201326592   
db_name PROD13   
db_recovery_file_dest /f0/PROD13/flash_recovery_area   
db_recovery_file_dest_size 150323855360   
db_unique_name PROD13   
dg_broker_start FALSE   
dispatchers (PROTOCOL=TCP) (SERVICE=PROD13XDB)   
fal_client PROD13   
fal_server iwebcoop   
job_queue_processes 10   
log_archive_config DG_CONFIG=(PROD13, iwebcoop)   
log_archive_dest_1 service="iwebcoop", ARCH SYNC NOAFFIRM delay=0 OPTIONAL db_unique_name="iwebcoop" register valid_for=(online_logfile, primary_role)   
log_archive_dest_10 LOCATION=USE_DB_RECOVERY_FILE_DEST ARCH MANDATORY REOPEN=5 VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE)   
log_archive_dest_9 LOCATION=USE_DB_RECOVERY_FILE_DEST ARCH MANDATORY REOPEN=5 VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE)   
log_archive_dest_state_1 ENABLE   
log_archive_dest_state_10 enable   
log_archive_dest_state_9 enable   
log_archive_format %t_%s_%r.dbf   
log_archive_max_processes 5   
log_archive_min_succeed_dest 1   
log_archive_trace 0   
log_file_name_convert /iwebcoop/, /PROD13/   
open_cursors 5000   
optimizer_index_caching 0   
optimizer_index_cost_adj 100   
optimizer_mode ALL_ROWS   
os_authent_prefix      
parallel_max_servers 4   
pga_aggregate_target 2936012800   
processes 1800   
remote_login_passwordfile EXCLUSIVE   
service_names PROD13, PROD13_XPT, PROD13.fs.usda.gov   
session_cached_cursors 100   
session_max_open_files 20   
sessions 1985   
sga_max_size 9965666304   
sga_target 9026142208   
standby_archive_dest      
standby_file_management AUTO   
statistics_level ALL   
timed_statistics TRUE   
undo_management AUTO   
undo_retention 4320   
undo_tablespace UNDO_TBS1   
user_dump_dest /oracle/product/admin/PROD13/udump   
utl_file_dir /f5/oradata/utlfile/PROD13   


Back to Top

End of Report