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: Data Dictioanry View Doubt
Next Topic: Error Messages
Goto Forum:

Current Time: Sun Jun 25 17:39:22 CDT 2017

Total time taken to generate the page: 0.28950 seconds