SPfile o Pfile?
Como se si mi BD esta usando Pfile o SPfile?
This entry was posted on 11. April 2008 at 03:45 and is filed under Consultas. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response or trackback from your own site.
11. April 2008 at 03:47
En SQL*Plus, dale “SHOW PARAMETER spfile.” si el valor es null est usando pfile, si no esta null, significa que esta usando spfile
7. May 2008 at 08:08
Investigando por ahi me pille con esta query que te entrega el dato …
SELECT DECODE( hay , 0, ‘init.ora’,’spfile.ora’) “Arranque”
FROM (
SELECT count(*) hay
FROM V$SPPARAMETER
WHERE ISSPECIFIED = ‘TRUE’
);
La probé y funcionó perfectamente.-