What is the fastest way to execute a PL/SQL function? If you paid attention to the title, your answer would be “to not execute it at all”. In fact, that is the correct answer and Oracle provides the means to do it. The magic is possible because of an Oracle feature called result cache which […]
Before you read on, please check out my related post on "Function Result Cache". You may find it valuable in this context. Conversation sounds familiar? I am sure you have been privy to a conversation like this between an IT manager and a DBA: Manager: My query is extremely slow. Can you make the query … Continue reading Oracle – Fastest Way To Execute SQL Is? To, Not Execute It! – Query Result Cache – Part II
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!