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.
Hidden Parameter checking Script:
SQL> SELECT ksppinm name,
FROM x$ksppi x, x$ksppcv y
WHERE (x.indx = y.indx)
AND ksppinm LIKE ‘_%’ ESCAPE ”
ORDER BY name;
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.
About Dbametrix Company:
The global remote services provider company for Oracle database. Dbametrix is expert team of remote dba services,database services,remote dba,remote service, oracle support. Dbametrix offers remote dba plans with SLA matrix and cost effective flexibility.
Thanks and regards,