Home » RDBMS Server » Server Administration » SPFILE or pfile
SPFILE or pfile [message #165685] Fri, 31 March 2006 07:29 Go to next message
abcindiaxyz
Messages: 13
Registered: March 2005
Location: Indonesia
Junior Member
Hello guru's,
I wanted to know as to how to find out, whether my database started using a spfile or a pfile.
I know that the first preference would be given to a spfile and then to the pfile.
I wanted to check out using the SQL*PLUS interface rather than the Enterprise Manager..........

Report message to a moderator

Re: SPFILE or pfile [message #165704 is a reply to message #165685] Fri, 31 March 2006 14:00 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
 
MYDBA > show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      C:\ORACLE\PRODUCT\10.2.0\DB_1\
                                                 DATABASE\SPFILEORCL.ORA
MYDBA >

Report message to a moderator

Previous Topic: current value of maxlogmembers
Next Topic: Does Oracle 10gr2 client work on mandrake (10.2) Linuxs?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 14:31:28 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.