Hi friends,
So many times we need to check the hidden parameters of Oracle. Sometimes we forgot the script of data dictionary views for writing SQL script.
Here I am providing you SQL script for checking hidden parameters of Oracle. For executing this script, you should need to login as SYSDBA. Because only X$ tables are providing hidden parameters and value detailing. For performing tasks of database administration, it is a very keen idea to keep in mind the value of some hidden parameters.
Hidden Parameter checking Script:
SQL> SELECT ksppinm name,
ksppstvl value,
ksppdesc description
FROM x$ksppi x, x$ksppcv y
WHERE (x.indx = y.indx)
AND x.inst_id=y.inst_id
AND ksppinm LIKE ‘_%’ ESCAPE ”
ORDER BY name;
From Oracle 10g, their new hidden parameters with double underscore were introduced. Those parameters 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,
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.