Undocumented ( Hidden ) Parameters in Oracle 11g: Some times ago , one of my junior queried about hidden parameters in Oracle 11g to me and which is the cause because ,…
Category: Database
BIND_AWARE and NO_BIND_AWARE Hints
BIND_AWARE and NO_BIND_AWARE Hints: From 11.1.0.7 onward it is possible to skip the monitoring that is required to detect bind-sensitive queries by using the BIND_AWARE hint. In the following example, the presence of the…
Adaptive Cursor Sharing in Oracle Database 11g R1
Adaptive Cursor Sharing in Oracle Database 11g Release 1: Adaptive Cursor Sharing (ACS) has been introduced in Oracle 11g Release1 to address the potential threat of cursor sharing and bind variables: The…
Listener Password Deprecated in Oracle 11g Release 2
Listener Password Deprecated in Oracle 11g Release 2 : Remember setting the password for listener? Up to just prior to Oracle Database 10g, setting this password was a must for any security…
Automatic Secure Configuration in 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
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 Enterprise Manager-II
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 Enterprise Manager-I
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…
Database Replay PL/SQL Procedures – II
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…
Database Replay PL/SQL Procedures -I
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…