we could not connect to our oracle db this morning. when i review the awr report snapshot for this timeperiod, the latch library cache is sticking out. is this a bad indicator?
what should i look for to narrow down the issue?
1st 7 am | | | | | 2nd 9.30 am | | | | |
Event | Waits | Time(s) | Percent Total DB Time | Wait Class | Event | Waits | Time(s) | Percent Total DB Time | Wait Class |
*latch: library cache | 24,981 | 696,465.9 | - 144.95
| Concurrency | *log file switch (checkpoint i | 32 | - 21.0
| -.00 | Configuration |
*cursor: pin S wait on X | 5,852,377 | 58,045.4 | - 12.08
| Concurrency | CPU time | | -5,047,623.0 | - 59.44
| |
*Backup: sbtwrite2 | 284,238 | 18,444.6 | - 3.84
| Administrativ | CPU time | | -5,047,623.0 | - 59.44
| |
CPU time | | 8,445.3 | - 1.76
| | CPU time | | -5,047,623.0 | - 59.44
| |
*db file scattered read | 186,930 | 1,374.4 | .29 | User I/O | CPU time | | -5,047,623.0 | - 59.44
| |