Tag Archives: performance

Spectre and Meltdown impact on Oracle DB performance

Posted on February 7, 2018 by Paras Shah

The effect of applying the fix for Specter and Meltdown patch on the Database server. The Oracle Database server kernel was patched in order to mitigate the Specter and Meltdown issue. Post the kernel patch was applied the performance of … Continue reading →

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

Latches Enqueues Locks

Posted on March 16, 2016 by Paras Shah

Difference between “Latches, Enqueue, Locks” The latches and Enqueue are both the types of locks which is used to acquire the resource. Semaphores is a programming device one might use to implement latching and enqueuing. Latches:- Latches are lightweight serialization … Continue reading →

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

Kernel parameters for Oracle DB

Posted on February 9, 2016 by Paras Shah

Kernel parameters for Oracle DB Installing Oracle Database software is one of our regular activities as DBA. There might be supporting notes in each and every project we support, to complete it quicker and more efficiently. One of the pre-requisites … Continue reading →

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

The COMMIT_WRITE parameter

Posted on February 4, 2016 by Paras Shah

The COMMIT_WRITE parameter The default commit processing model is that when a session issues a COMMIT, it places a commit record in the log buffer and then hangs while the log writer writes the log buffer to disc. Only then … Continue reading →

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

AWR basics

Posted on January 30, 2016 by Paras Shah

Dividing awr report into sections for ease Continue reading →

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

Improving Concurrency and throughput

Posted on January 28, 2016 by Paras Shah

Improving Concurrency and throughput Introduction A feature of Oracle 11g that can improve the throughput of your application by avoiding unnecessary locking. If we plan to scale large Web sites, we have to take care deeply about response time and … Continue reading →

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

Load Profile :AWR

Posted on January 28, 2016 by Paras Shah

Brief description for load profile in AWR Continue reading →

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

Table Compression in Oracle

Posted on January 16, 2016 by Paras Shah

Comparison between BASIC and ADVANCE table compression over conventional DMLs Continue reading →

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