DDL Wait Option in Oracle. A DBA is trying to alter the table called SALES to add a column, TAX_CODE. he issues the following SQL statement: SQL> alter table sales add (tax_code varchar2 (10)); But instead of getting something like “Table altered”, he gets: SQL>>Alter… Read More
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
INTRODUCTION TO AWS CLOUDFORMATION What is CloudFormation? AWS CloudFormation provides a common language for describing and provisioning all the infrastructure resources in environment. Use a simple text file to model and provision, in an automated and secure manner, all the resources needed for your applications… 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
Invoking MySQL Client Programs The MySQL Client programs are used for connecting the MySQL Server for accessing and managing the activities of MySQL Databases there are different client programs mysql mysqladmin mysqlimport mysqldump mysql mysql is a client program which is used to connect… 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
