Home » RDBMS Server » Server Administration » SPFILE or PFILE
SPFILE or PFILE [message #217934] Tue, 06 February 2007 02:53 Go to next message
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.

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

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: Sat Dec 10 01:00:34 CST 2016

Total time taken to generate the page: 0.08689 seconds