Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • normal maintenance for exp-imp and renaming table Oracle
  • get_vmstat.ksh for Solaris Oracle
  • Find All internal Parameters Oracle
  • temp_use.sql diplays usage of temp ts Oracle
  • Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT Oracle
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • CPU speed on Linux Linux/Unix
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • cold backup scripts to copy locally Linux/Unix
  • Goldengate Tutorial Oracle
  • Drop tempfiles from database Oracle
  • DBMS_UTILITY.ANALYZE_SCHEMA Oracle
  • myfile Oracle
  • sbind.sql Find Bind variable from sql_id sqlid Oracle
  • Gathering statistics with DBMS_STATS Oracle

New Latest Param.sql for finding all hidden parameters also

Posted on 18-Jan-2006 By Admin No Comments on New Latest Param.sql for finding all hidden parameters also

set pages 3000

set lines 151

accept param_name prompt ‘Enter Parameter Name : ‘

select a.ksppinm “Parameter”, b.ksppstvl “Session Value”, c.ksppstvl “Instance Value”

from x$ksppi a, x$ksppcv b, x$ksppsv c

where a.indx = b.indx and a.indx = c.indx

and ( upper(ksppinm) like ‘%&param_name%’ or lower(ksppinm) like ‘%&param_name%’ )

order by a.ksppinm;

Oracle, SQL scripts

Post navigation

Previous Post: In Addition to previous note, following grants needed on PERFSTAT user.
Next Post: Good link for LIO in Oracle ( Logical IOs)

Related Posts

  • Find Time Consuming SQL Statements in Oracle 10g Oracle
  • DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
  • Important Script Method for tuning Oracle
  • Privilege to describe the table. Oracle
  • eplan9i.sql Oracle
  • To check whether standby is recovering properly or not?? Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Rownum with Order by Oracle
  • backspace in SQL Plus not working then..? Linux/Unix
  • sid_wise_sql.sql Further explaination Oracle
  • Oracle Support Metalink ID 161818.1 Oracle
  • Jai Shree Ram PHP/MYSQL/Wordpress
  • Temporary Tablespace Information and restriction. Oracle
  • Oracle GoldenGate lag monitoring shell script Linux/Unix
  • Rollback force for distributed transactions Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme