How to see all spfile parameters Posted by Unknown on October 06, 2016 Get link Facebook X Pinterest Email Other Apps SET LINESIZE 300 COLUMN name FORMAT A30 COLUMN value FORMAT A60 COLUMN displayvalue FORMAT A60 SELECT sp.sid, sp.name, sp.value, sp.display_value FROM v$spparameter sp ORDER BY sp.name, sp.sid; Comments
Comments