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!
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?