Sunday, October 25, 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.

    - Advertisement -

    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

    - Advertisement -
    - Advertisment -

    Most Popular

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Differences Raw Device, ASM Device and CFS

    The article explains basic differences of ASM device, raw device and Oracle cluster file system cfs with fundamentals

    Recent Comments