Home » RDBMS Server » Server Administration » SPFILE or PFILE
SPFILE or PFILE [message #217934] Tue, 06 February 2007 02:53 Go to next message
Messages: 315
Registered: June 2002
Senior Member

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


Re: SPFILE or PFILE [message #217938 is a reply to message #217934] Tue, 06 February 2007 02:56 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member


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

Previous Topic: resmgr:waiting in end wait
Next Topic: ORA-01109 and ORA-32004
Goto Forum:

Current Time: Thu Aug 24 02:01:30 CDT 2017

Total time taken to generate the page: 0.11709 seconds