Oracle : List all the hidden parameter and their values – &&&&&& – Simulate ORA error in Alert log

************************************************************
List all the hidden parameter and their values
************************************************************
SET PAUSE ON
SET PAUSE ‘Press Return to Continue’
SET PAGESIZE 60
SET LINESIZE 300

COLUMN ksppinm FORMAT A50
COLUMN ksppstvl FORMAT A50

SELECT
ksppinm,
ksppstvl
FROM
x$ksppi a,
x$ksppsv b
WHERE
a.indx=b.indx
AND
substr(ksppinm,1,1) = ‘_’
ORDER BY ksppinm;

*********************************
Simulate ORA error in Alert log:
*********************************
=====================================
exec sys.dbms_system.ksdwrt(2, ‘ORA-07445: SIMULATED ERROR, Testing Please ignore !!!’);