Category: Oracle 11g

Different ways to get Oracle Software Release Number/Version Number: SQL> SELECT version FROM V$INSTANCE; VERSION—————–12.2.0.1.0 SQL> select BANNER from v$version; SQL> set line 200 col version for a15 col PRODUCT for a50 col STATUS…

Hybrid Columnar Compression (Release 2 Only on Oracle Exadata) : In 11g Release 2 (but only if pre-installed with Oracle Exadata v2), compression technology has been extended in the form of Hybrid Columnar…

Table Compression Enhancements in Oracle Database 11g R1 : Table compression was introduced in Oracle 9i as a space saving feature for data warehousing projects. In 11g it is now considered a…

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 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: 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: 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 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 : Remember setting the password for listener? Up to just prior to Oracle Database 10g, setting this password was a must for any security…