How to check hidden parameter in Oracle

Check hidden parameter in Oracle

set lines 200
col name for a50
col value for a40

select ksppinm name , ksppstvl value from x$ksppi a, x$ksppsv b where a.indx=b.indx and substr(ksppinm,1,1) = '_';

How to check hidden parameter in Oracle

Like this:

Leave a Reply Cancel reply

Oracle Help

Follow Us

Share this:

Like this:

Related Articles

RMAN Backup With Archivelog

Delete applied archivelog script

How to Purge Listener Log in Oracle

MAXDATAFILES and other files in Oracle

How to Flush Single SQL Plan out of Shared Pool in Oracle

Progress status of index rebuild in Oracle

Leave a Reply Cancel reply

Tags

Oracle Help

Follow Us