Timeline for Investigating an Oracle 12c outage after the fact, while limited to SQL*Plus
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 2, 2020 at 17:02 | vote | accept | TrojanName | ||
| Mar 2, 2020 at 16:59 | comment | added | Gerard H. Pille | Keep it that way. But if you still know how to read, Oracle used to have very good documentation. Check this out: docs.oracle.com/en/database/oracle/oracle-database/18/refrn/…. If smaller shared pool gives you the same performance, go for the smaller pool. | |
| Mar 2, 2020 at 16:57 | comment | added | TrojanName | Yes, it does have a V$SHARED_POOL_ADVICE. I'm not really a DBA so I can't answer if the shared pool is taking all of the SGA. I used know all this stuff back in Oracle 8i but haven't kept up with recent changes. | |
| Mar 2, 2020 at 16:44 | comment | added | Gerard H. Pille | I quit the game some time ago now, but is your shared pool taking all of the SGA? Does the "Standard Edition" have a V$SHARED_POOL_ADVICE ? | |
| Mar 2, 2020 at 16:33 | comment | added | TrojanName | Super! Thanks for this. To answer your other question, shared pool is 4798283776, and sga_target is 4928M | |
| Mar 2, 2020 at 14:11 | history | answered | Gerard H. Pille | CC BY-SA 4.0 |