Tag Archives: Oracle

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

Tuning 101: The Beginning

Hello everyone With a view to keep up my momentum for frequent posts and to make my blog lively I have decided to start an ongoing topic that will containĀ  latest updates regarding a very interesting yet challenging feat for … Continue reading

Posted in Oracle | Tagged , , | Leave a comment

Blocking Sessions

In my last post, I had written about queries that might show up as the most resource consuming queries as per total elapsed time, but it may turn out that the query itself is not performing any action. The query … Continue reading

Posted in Oracle | Tagged , , , , , , | 1 Comment

Top Resource Consuming Queries

After a breezy weekend, coming to office on an early Monday morning taking a sip of hot coffee and going through regular checklist tasks…………..Seems like an almost perfect way to start the week. But then suddenly a flood of request … Continue reading

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