Monthly Archives: February 2014

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

Kill Thy Session

As a DBA, the most frequent and recurring task on daily basis are to kill sessions that just aren’t doing anything, possibly because of some resource contention or due to network outage. Since, I have overseen both Data-warehouse database system … Continue reading

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

Blog Log 101

Hello to all those scavenging through my blog currently. Before I begin let me brief you all about myself. I am a database programmer/developer/administrator with over 3 years of experience, and I have started this blog to share some of … Continue reading

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