So many times we need to check hidden parameters of Oracle. Sometime we forgot script of data dictionary views for writing sql script.

Here I am providing you SQL script for check hidden parameters of Oracle. For executing this script you should need to login as SYSDBA. Because only X$ tables are providing hidden parameter and value detailing. For performing tasks of database administration, it is very keen idea to keep in mind value of some hidden parameters.

From Oracle 10g, there new hidden parameters with double underscore were introduced. Those parameter are specially for Automatic Shared Memory Management (ASMM) feature. In short you should need to keep in mind for same.

Subscribe

Get Oracle DBA Job Quickly

About US

This is official Blog of Dbametrix Solutions. Dbametrix is group of companies for providing database services and database dba support to global client with exclusive remote support system using strong and transparent SLA and response time matrix with low cost plans.