Category: Oracle 11g

 Automatic Secure Configuration: When you create a new database, you can use Database Configuration Assistant (DBCA) to automatically create a more secure configuration than in previous releases of Oracle Database. You can…

Secure Password Support in Oracle 11g : Oracle 11g secure passwords and implementing good password policies are by far the most important defense for protecting against password based security threats. Oracle recommends…

Database Replay Workflow in Oracle 11g Enterprise Manager: Part-II : Replay using Enterprise Manager As with the PL/SQL API replay example, we must create a directory and directory object on the test…

Database Replay Workflow in Oracle 11g Enterprise Manager: Part-I : Capture using Enterprise Manager : As you might expect, the capture processing using Enterprise Manager is similar to that of using the…

Replay using the DBMS_WORKLOAD_REPLAY Package The DBMS_WORKLOAD_REPLAY package provides a set of procedures and functions to control the replay process. In order to replay the logs captured on the “ORCL” system, we need to…

Capture using the DBMS_WORKLOAD_CAPTURE Package The DBMS_WORKLOAD_CAPTURE package provides a set of procedures and functions to control the capture process. Before we can initiate the capture process we need an empty directory on the…

How to Use Database Replay: The new Database Replay tool works like a DVR inside the database. Using a unique approach, it faithfully captures all database activity beneath the level of SQL…

Database Replay in Oracle Database 11g Release 1: What is your biggest concern when you need to make a change in the database—be it some minor change, such as altering initialization parameters…

Restoring Data Files to Nondefault Locations:– Using SET NEWNAME for Switching Files :–  The SET NEWNAME command can be used only inside a RUN block. It prepares a name mapping for subsequent…