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: Thu Oct 27 14:27:43 CDT 2016

Total time taken to generate the page: 0.11566 seconds