pfile spfile in oracle database
pfile and spfile in oracle database
show parameter spfile
create pfile from spfile;
create pfile='/tmp/dbtech.txt' from spfile;
create spfile from pfile;
startup pfile='/tmp/dbtech'
--alert log location
set pages 999 long 999 lines 999
col name for a30
col value for a60
select name,value from v$diag_info where NAME='Diag Trace';