Fine-Grained Auditing (FGA). Fine grained auditing extends Oracle standard auditing capabilities by allowing the user to audit actions based on user-defined predicates. It is independant of the AUDIT_TRAILparameter setting and all audit records are stored in the FGA_LOG$ table, rather than the AUD$ table. The following example illustrates how fine… Read More
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
Installation of MySQL Sever in Ubuntu using Generic Binaries. To begin the Installation process first download the generic binary from mysql.com or use the below link for downloading MySQL Sever Software Link to Download Binaries: https://dev.mysql.com/downloads/mysql/ Steps to Configure MySQL Server: Create a group with… Read More
