RMAN is one of the key important utility that every Oracle DBA is dependent on for regular day to day backup and restoration activities. It is proven to be the best utility for hot backups, in-consistent backups while database is running and processing user sessions. With all that known, as an Oracle DBA it will […]
Oracle Database BUFFER CACHE is one of the core important architectural memory component which holds the copies of data blocks read from datafiles. In my journey of Oracle DBA this memory component played major role in handling Performance Tuning issues. In this Blog, I will demonstrate a case study and analyze the behavior of BUFFER […]
In Oracle database, data BLOCK is defined as the smallest storage unit in the data files. But, there are many more concepts run around the BLOCK architecture. One of them is to understand if a BLOCK can accommodate rows from distinct tables. In this article, we are going to arrive at the justifiable answer with […]
One of the major player in the SGA is SHARED_POOL, without which we can say that there are no query executions. During some performance tuning trials, you would have used ALTER SYSTEM command to flush out the contents in SHARED_POOL. Do you really know what exactly this command cleans out? As we know that internally […]
Every user session on Oracle database will be able to access default table PLAN_TABLE to collect execution plan of a query from EXPLAIN PLAN command. But, how is this table available to all the users in the database and gets empty once you disconnect? Is this table available and created for every user logging into […]
On Oracle RAC environment Load Balancing is something which is critical for distribution of connections between the servers we have. Load Balancing Advisory (LBA) is one of the key components for SCAN listener to decide the best instance for the new incoming connection request. I was just wondering if we can check if Load Balancing […]
We must have known already that block sizes of non-system tablespaces can be controlled and altered, but did you ever think of block sizes of Control files and Redo log files in the database? How to check their block sizes if they have so, can we alter them when required? Well, it is really very […]
Choosing the best suitable storage disk for your Oracle database is very important when you architect the environment for better performance. Not just considering database files (Data files, Control files, Redo logs, Archive logs etc…) it is also vital to look at the type of application and the data flow in and out of the […]
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 we implement is to set up appropriate Kernel parameters at the operating system level on UNIX platforms. But, it would […]
Flashback feature in Oracle database is well known to roll back the table to a specific timestamp (depends on undo retention) or to restore dropped table and many more. We must have used this flashback feature so far on application schema objects and found working without any issues. As an Oracle DBA did you configure […]
