Timeline for Investigating an Oracle 12c outage after the fact, while limited to SQL*Plus
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 5, 2020 at 7:55 | answer | added | Daniel Overby Hansen | timeline score: 0 | |
| Mar 2, 2020 at 20:01 | history | became hot network question | |||
| Mar 2, 2020 at 17:09 | answer | added | pifor | timeline score: 1 | |
| Mar 2, 2020 at 17:02 | vote | accept | TrojanName | ||
| Mar 2, 2020 at 14:17 | answer | added | Gandolf989 | timeline score: 1 | |
| Mar 2, 2020 at 14:12 | comment | added | Gerard H. Pille | see answer. BTW, what is the size of the shared pool? Has it been tuned? | |
| Mar 2, 2020 at 14:11 | answer | added | Gerard H. Pille | timeline score: 1 | |
| Mar 2, 2020 at 13:15 | comment | added | TrojanName | Yes, this is the kind of info I'm looking for. Can you give some example of these queries that you would run? | |
| Mar 2, 2020 at 12:35 | comment | added | Gerard H. Pille | In that case, I'm not aware of any tools. I'd run queries to see if any traces are left in shared memory. Look for statements that only differ for the value of what should have been variables. Why did this happen during the weekend? Find what jobs ran at that specific time. | |
| Mar 2, 2020 at 12:20 | comment | added | TrojanName | @GerardH.Pille thanks for the response. My apologies, I omitted an important fact, that this is Standard Edition. I have updated the question with this fact. | |
| Mar 2, 2020 at 12:18 | history | edited | TrojanName | CC BY-SA 4.0 |
added 17 characters in body
|
| Mar 2, 2020 at 12:11 | comment | added | Gerard H. Pille | I believe sql*plus allows you to run AWR reports, and save them on your system. What happened was that the shared memory was filled by too many different statements, eg. a batch using statements without bind variables. | |
| Mar 2, 2020 at 12:00 | review | First posts | |||
| Mar 2, 2020 at 12:08 | |||||
| Mar 2, 2020 at 11:55 | history | asked | TrojanName | CC BY-SA 4.0 |