Using Oracle DBMS_MONITOR

DBMS_MONITOR is a new package in ORACLE 10G. This package allows us, amongst others, to trace sessions in the database.

SQL Server – Values of Newly Added Columns

What happens if we add a column to a table? What value does this column get?

Oracle Database Hidden Parameters

Always wanted to see all Oracle parameters? Including the hidden ones?

Oracle – Monitoring Long Operations

There are several specific operations that are considered as long operations.
When performing one of these operations, we can follow the progress of the operation

Oracle RMAN backup script

Need an RMAN backup script?

Database Replay Part 3 – Replay Video tutorial

When using database replay, the third and final step is to replay the load captured and processed.

Let’s see the replay

Database Replay Part 2 – Process Video tutorial

In database replay, after capturing the load, we need to process the capture files and create replay files. These files will be used to replay the load on the target database.

Using Oracle DBMS_XPLAN DISPLAY_CURSOR

How can we get the actual execution plan of a query that is in the SQL area?
We have several options to get the execution plan of a query, but it doesn’t give us the real execution plan from the shared pool, but recalculate the execution plan for us.
So, how can we see the real execution plan?

Creating an Oracle Standby Database – Data Guard tutorial

Physical standby database is a common solution for DR. We can maintain it automatically using Data Guard, or manually by copying archived redo logs to the standby server and apply them to the database.

Oracle 11g Linux Installation

This video will show you how to install oracle 11g on linux – step by step. We will start in checking the requirement for Oracle installation. Then we continue with the steps to complete before starting the installation. We will finish with some final tasks after the installation is complete.