Oracle Database Vault – Secured Application Roles tutorial

Learn how to integrate grant and revoke databas roles based on pre-defined security roles, using oracle secure appliation roles and Oracle database vault.

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.

Database Replay Part 1 – Capture Video tutorial

Database replay is a feature that enables us to capture a database load from Oracle 9i, 10g and 11g, and replay the same load on an 11g database.

Let’s see what it is and how it works

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?