Oracle 11g New Features : 1: Oracle Grid Infrastructure2: Installation and Upgrade Enhancements3: Oracle Restart4: ASM Enhancements5: Storage Enhancements6: Data Warehouse and Partitioning Enhancements7: Oracle SecureFiles8: Security and Networking Enhancements9: SQL Performance Analyzer10: SQL…
Month: June 2016
Oracle Restart Feature in Oracle 11g
What is Oracle Restart feature in Oracle 11g: With Oracle Real Application Clusters the Oracle database can be configured to restart as each node in the cluster is restarted. For single instance…
Querying Recovery Catalog:
Recovery Catalog Performance Views :– There are many views that provide backup-related information. The most commonly used ones are the following dynamic performance views in the target database to obtain information about…
BASE RECOVERY CATALOG DATABASE CREATION
1: Create new service named “catdb” using netca for “catdb” database. 2: Now Create a new database named “catdb” using dbca , check in /etc/oratab 3: Register “catdb” database with listener. [oracle@airyhost…
RMAN Recovery Catalog
The recovery catalog contains information about both RMAN backups and the target database. More specifically, the recovery catalog contains the following: You can create the recovery catalog in a target database that…
Finding Undocumented ( Hidden ) Parameter with their details
Finding Undocumented ( Hidden ) Parameter with their details : Below given script will provide you, the list of all the Undocumented ( Hidden ) initialization parameters present in your database along with…
Finding Undocumented ( Hidden ) Parameter
Finding Undocumented ( Hidden ) Parameter in your database: These parameters can be easily obtained by giving the following command on the sql prompt as shown below: [oracle@airydba ~]$ sqlplus / as…
Undocumented ( Hidden ) Parameters in Oracle 11g
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 ,…
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…