Monday, July 22, 2013

CHECK WHETHER DATABASE RUNNING USING SPFILE OR PFILE

SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
       FROM v$parameter WHERE name = 'spfile';

No comments:

Post a Comment

Setup and design database architecture to meet SLA - 99.9 , 99.99 , 99.999

Achieving distinct Service Level Agreements (SLAs) for a database requires scaling redundancy and infrastructure complexity.  The three-nine...