OraFAQ Forum: Server Administration » Which file is currently being used

Home » RDBMS Server » Server Administration » Which file is currently being used

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Which file is currently being used [message #209298]

Thu, 14 December 2006 02:57

vivekmenon_k@yahoo.co.uk
Messages: 6
Registered: October 2006
Location: India

Junior Member

My instance is up and running, it could either be using a PFILE or a SPFILE.I am not sure which one its using,so how do I check it.

Report message to a moderator

Re: Which file is currently being used [message #209300 is a reply to message #209298]

Thu, 14 December 2006 03:11

atulsehgal_1978
Messages: 2
Registered: December 2006

Junior Member

Hi,

Try this :-
1.Login to the database .

2.Issue the following command :-
SQL>sho parameter pfile

3.If the above command shows some value for spfile parameter , then you are using spfile otherwise pfile.

Report message to a moderator

Re: Which file is currently being used [message #209301 is a reply to message #209298]

Thu, 14 December 2006 03:12

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,


sql>show parameter spfile

it will show value mean ur database currently using spfile.
if it will show "null"
then database using "pfile".

hope this helps
Taj

Report message to a moderator

Re: Which file is currently being used [message #209302 is a reply to message #209298]

Thu, 14 December 2006 03:13

seema.taunk
Messages: 96
Registered: October 2006

Member

Hi,

Check this

http://www.orafaq.com/forum/t/21590/2/

Report message to a moderator

Previous Topic:	Temporary tablespace VS Temporary datafile question
Next Topic:	Fragmentations

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 20 01:30:48 CDT 2026