DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
PROD13 | 3474625700 | PROD13 | 1 | 10.2.0.3.0 | NO | extradb.cs.usfs.gov |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 77890 | 28-Sep-08 12:00:22 | 1105 | 22.1 |
End Snap: | 77891 | 28-Sep-08 13:00:02 | 1424 | 19.6 |
Elapsed: | 59.66 (mins) | |||
DB Time: | 26,584.63 (mins) |
Cache Sizes
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 6,048M | 6,672M | Std Block Size: | 16K |
Shared Pool Size: | 2,128M | 1,504M | Log Buffer: | 14,384K |
Load Profile
Per Second | Per 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.25 | Recursive Call %: | 93.87 |
Rollback per transaction %: | 8.04 | Rows per Sort: | 25.17 |
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %: | 100.00 | Redo NoWait %: | 99.99 |
Buffer Hit %: | 99.34 | In-memory Sort %: | 99.98 |
Library Hit %: | 97.25 | Soft Parse %: | 97.47 |
Execute to Parse %: | 58.22 | Latch Hit %: | 99.83 |
Parse CPU to Parse Elapsd %: | 50.15 | % Non-Parse CPU: | 92.38 |
Shared Pool Statistics
Begin | End | |
---|---|---|
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
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
---|---|---|---|---|---|
direct path write temp | 121,004 | 1,448,544 | 11,971 | 90.8 | User I/O |
CPU time | 15,466 | 1.0 | |||
db file sequential read | 897,674 | 8,722 | 10 | .5 | User I/O |
enq: TX - row lock contention | 1,630 | 4,769 | 2,926 | .3 | Application |
db file parallel write | 19,818 | 3,956 | 200 | .2 | System I/O |
Statistic Name | Time (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 | Waits | %Time -outs | Total 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
Event | Waits | %Time -outs | Total 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
Event | Waits | %Time -outs | Total 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
Statistic | Total |
---|---|
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 Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical 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 Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
---|---|---|---|---|---|---|---|---|
SYS$USERS | 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
Elapsed Time (s) | CPU Time (s) | Executions | Elap per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL 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
CPU Time (s) | Elapsed Time (s) | Executions | CPU per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL 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
Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL 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
Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL 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
Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL 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
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL 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
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL 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
Version Count | Executions | SQL Id | SQL Module | SQL 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
Back to SQL Statistics
Back to Top
Statistic | Total | per Second | per 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
Statistic | Begin Value | End 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
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 2 | 2.01 |
Back to Instance Activity Statistics
Back to Top
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
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 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av 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 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer 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 |
Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual Redo Blks | Target Redo Blks | Log File Size Redo Blks | Log Ckpt Timeout Redo Blks | Log Ckpt Interval Redo Blks | |
---|---|---|---|---|---|---|---|---|
B | 0 | 44 | 4331 | 86683 | 272371 | 1382400 | 272371 | |
E | 0 | 39 | 2789 | 46867 | 299864 | 1382400 | 299864 |
Back to Advisory Statistics
Back to Top
P | Size for Est (M) | Size Factor | Buffers for Estimate | Est Phys Read Factor | Estimated Physical Reads |
---|---|---|---|---|---|
D | 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 Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
88.00 | 30,693 | 4,184 |
Back to Advisory Statistics
Back to Top
PGA Aggr Target(M) | Auto PGA Target(M) | PGA Mem Alloc(M) | W/A PGA Used(M) | %PGA W/A Mem | %Auto W/A Mem | %Man W/A Mem | Global Mem Bound(K) | |
---|---|---|---|---|---|---|---|---|
B | 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
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-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 Target Est (MB) | Size Factr | W/A MB Processed | Estd Extra W/A MB Read/ Written to Disk | Estd PGA Cache Hit % | Estd PGA Overalloc Count |
---|---|---|---|---|---|
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 Size(M) | SP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits |
---|---|---|---|---|---|---|---|---|
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 Size (M) | SGA Size Factor | Est 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
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
16 | 1.00 | 0 | 0 | 0 | 0 |
32 | 2.00 | 0 | 0 | 0 | 0 |
48 | 3.00 | 0 | 0 | 0 | 0 |
64 | 4.00 | 0 | 0 | 0 | 0 |
80 | 5.00 | 0 | 0 | 0 | 0 |
96 | 6.00 | 0 | 0 | 0 | 0 |
112 | 7.00 | 0 | 0 | 0 | 0 |
128 | 8.00 | 0 | 0 | 0 | 0 |
144 | 9.00 | 0 | 0 | 0 | 0 |
160 | 10.00 | 0 | 0 | 0 | 0 |
176 | 11.00 | 0 | 0 | 0 | 0 |
192 | 12.00 | 0 | 0 | 0 | 0 |
208 | 13.00 | 0 | 0 | 0 | 0 |
224 | 14.00 | 0 | 0 | 0 | 0 |
240 | 15.00 | 0 | 0 | 0 | 0 |
256 | 16.00 | 0 | 0 | 0 | 0 |
272 | 17.00 | 0 | 0 | 0 | 0 |
288 | 18.00 | 0 | 0 | 0 | 0 |
304 | 19.00 | 0 | 0 | 0 | 0 |
320 | 20.00 | 0 | 0 | 0 | 0 |
Back to Advisory Statistics
Back to Top
Java Pool Size(M) | JP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits |
---|---|---|---|---|---|---|---|---|
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
Class | Waits | Total 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 Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt 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 TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
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
End Time | Num Undo Blocks | Number of Transactions | Max Qry Len (s) | Max Tx Concy | Tun Ret (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
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 Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct 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 Name | Get Requests | Misses | Sleeps | Spin Gets | Sleep1 | Sleep2 | Sleep3 |
---|---|---|---|---|---|---|---|
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 Name | Where | NoWait Misses | Sleeps | Waiter 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
Latch Name | Get Requests | Misses | Sleeps | Spin & 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
Latch Name | Child Num | Get Requests | Misses | Sleeps | Spin & 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
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical 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
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical 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
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row 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
No data exists for this section of the report.
Back to Segment Statistics
Back to Top
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
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
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final 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 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- 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 |
Category | Alloc (MB) | Used (MB) | Avg Alloc (MB) | Std Dev Alloc (MB) | Max Alloc (MB) | Hist Max Alloc (MB) | Num Proc | Num Alloc | |
---|---|---|---|---|---|---|---|---|---|
B | Other | 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 regions | Begin 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
Pool | Name | Begin MB | End 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
Session Type | CPU Time | User I/O Time | Sys I/O Time |
---|---|---|---|
QMON Slaves | 432,442 | 2,903,063 | 0 |
QMON Coordinator | 162,789 | 0 | 0 |
Back to Streams Statistics
Back to Top
No data exists for this section of the report.
Back to Streams Statistics
Back to Top
No data exists for this section of the report.
Back to Streams Statistics
Back to Top
No data exists for this section of the report.
Back to Streams Statistics
Back to Top
No data exists for this section of the report.
Back to Streams Statistics
Back to Top
Ruleset Name | Evals | Fast Evals | SQL Execs | CPU Time | Elapsed Time |
---|---|---|---|---|---|
SYS.ALERT_QUE_R | 4 | 0 | 0 | 88 | 280 |
Back to Streams Statistics
Back to Top
Resource Name | Current Utilization | Maximum Utilization | Initial Allocation | Limit |
---|---|---|---|---|
processes | 1,428 | 1,507 | 1800 | 1800 |
sessions | 1,910 | 1,985 | 1985 | 1985 |
Parameter Name | Begin value | End 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 |
End of Report