Tag: SERIAL#

Oracle – Parallel To PGA (P2P) & Serial To SGA (S2S) – Caching Differences And When Parallelism Is Not The Panacea For Performance!

If you are running into memory issues such as below, there could be several causes but one of the causes is excessive parallelism and exhaustion of PGA memory. “ORA-01034: ORACLE not available / ORA-27102: out of memory / Linux-x86_64 Error: 12: Cannot allocate” Please read on to find out how to resolve this. There are … Continue reading Oracle – Parallel To PGA (P2P) & Serial To SGA (S2S) – Caching Differences And When Parallelism Is Not The Panacea For Performance!

Advertisement

Oracle – My KILL’ed Session Continues To Stay On In KILLED Status, Why?

  The v$session view If you do not know already, to check who is connected and since when, what their connection status is etc., you would use dynamic view v$session. The view has the following columns: You would kill the required session by issuing Note: The IMMEDIATE option of the above command just returns control … Continue reading Oracle – My KILL’ed Session Continues To Stay On In KILLED Status, Why?