Wednesday, August 5, 2020
    Home Oracle Internals Hidden parameter checking script for Oracle

    Hidden parameter checking script for Oracle

    Hi friends,

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

    - Advertisement -

    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,
    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, 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,

    Dbametrix Solutions

    - Advertisment -

    Most Popular

    What was new in Oracle 12c

    Blog post explains in detail Oracle 12c new features for Developers including in-memory and Advanced Index Compression.

    The Life of DBAs is Changing

    Article explains how The Life of DBAs is Changing in Self-Managing Oracle Database. An detail introduction of Oracle Autonomous Database Cloud

    MySQL as PHP database

    The article illustrates the relationship between data and semantics of data stored in a database with reference to the semantic WEB

    Supply Chain Management in ERP

    The article provides detail of what is supply chain management system and what is the importance.

    Recent Comments