Auditing in Oracle. Auditing is used to track the occurrence of SQL statements in subsequent user sessions. In this article will see how can dba track all types of sql operations (select,insert,update,delete drop,create and alter) of particular user. Auditing is a default feature of the… Read More
UNPLANNED FAILOVER and ReInitializing the OLD Primary as the NEW Standby(Using Flashback). A failover is done when the primary database (all instances of an Oracle RAC primary database) fails or has become unreachable and one of the standby databases is transitioned to take over the primary role.… Read More
We have discussed on How Optimizer works in our previous article. Please find the article here Performance Tuning – Part4 Now we will discuss about the SQL Tuning. SQL TUNING Before going into how to perform SQL Tuning, let us begin with Thumb Rules… Read More
Till now in my previous articles we have discussed about the tools that are used in the performance tuning. Please find the previous article here. Performance Tuning in Oracle – Part3 Before we go in depth of the Performance tuning, it is important to… Read More
Easy way to perform Transportable tablespace across platforms. Transportable Tablespace feature was introduced in Oracle 8i to transfer large amount of data between the oracle databases. In Oracle 10g this useful feature was enhanced with cross-platform support which allowed a tablespace, or set of tablespaces, to be… Read More
Performance Tuning Tools This is the continuation to the previous article about the Tools used in the performance Tuning. Please find the previous article here. Performance Tuning in Oracle – Part2 In this article we will discuss about Oracle SQL Tuning advisor and baseline.… Read More
Dear Readers, In this article, we will see the following Transportable Tablespace between two pluggable database(PDB’s). This article discusses simple example of performing TTS (Transportable Tablespace) across two pluggable databases in a same container. Transportable tablespaces(T-Ts) is used to move the data from one database… Read More
Performance Tuning Tools We have discussed the tools that are being used for Performance Tuning in our previous article. Please find the article here Performance Tuning in Oracle – Part1 In this article we will be discussing the additional tools which are used in… Read More
Introduction of Performance Tuning: Performance tuning plays an important role in the DBA life. Performance tuning refers in the following areas: 1. Instance tuning 2. SQL tuning 3. Memory, Storage (I/O) 4. Network tuning 5. OS tuning For OS Tuning and Network tuning DBAs… Read More
Dear Readers, In this article, we will see the following Datapump in Oracle 12c. Oracle Datapump was introduced in Oracle 10g. This article provides an overview of the main Data Pump enhancements in Oracle Database 12c Release 1. Oracle Datapump have two utilities They are 1.EXPDP… Read More
