Tag Archives: Oracle database

REDO……How do you do?????

Its been quite a while since my last post, and I am finally breaking the silence streak. The reason it took me this long would be because I was in a dilemma regarding do I continue the Tuning series from … Continue reading

Posted in Best Practices, Oracle | Tagged , , , , , , | Leave a comment

Manage Your Temporary…….Permanently

Taking a break from the tuning trio-logy, this time I wanted to share my views on addressing something in Oracle database, that I have come across multiple times in my professional career. And every time I came across this question … Continue reading

Posted in Best Practices, Oracle | Tagged , , , , , , | Leave a comment

Tuning 101: Automatic Memory Management (AMM)

In my previous posts we came across few parameters that can affect the performance of Oracle database, such as SHARE POOL, BLOCK BUFFERS, SORT AREA, etc. Adding to these lists there can be other parameters too, which can affect the … Continue reading

Posted in Oracle | Tagged , , , , , , | Leave a comment

Tuning 101: PARAMS_2014-02-24.log

Hello folks Sochi games are over and now its time for me to add to the tuning series. In the last post we talked about SHARED POOL, and continuing with where we left, we shall come across few other parameters … Continue reading

Posted in Oracle | Tagged , , , , , | Leave a comment