OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SPFILE or PFILE

Tue, 06 February 2007 02:53

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

Is there a way to find from DB, is the Database running on SPFLE or PFILE?

Brayan.

Tue, 06 February 2007 02:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

show parameter spfile
if value = null database start with PFILE
if value = non-null database start with SPFILE

regards
Taj

Previous Topic:	Data Dictioanry View Doubt
Next Topic:	Error Messages

Goto Forum:

]

Current Time: Fri Jun 19 03:08:09 CDT 2026