Home » RDBMS Server » Server Administration » Which file is currently being used
Which file is currently being used [message #209298] Thu, 14 December 2006 02:57 Go to next message
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.
Re: Which file is currently being used [message #209300 is a reply to message #209298] Thu, 14 December 2006 03:11 Go to previous messageGo to next message
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.
Re: Which file is currently being used [message #209301 is a reply to message #209298] Thu, 14 December 2006 03:12 Go to previous messageGo to next message
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
Re: Which file is currently being used [message #209302 is a reply to message #209298] Thu, 14 December 2006 03:13 Go to previous message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi,

Check this

http://www.orafaq.com/forum/t/21590/2/
Previous Topic: Temporary tablespace VS Temporary datafile question
Next Topic: Fragmentations
Goto Forum:
  


Current Time: Fri Dec 09 23:01:37 CST 2016

Total time taken to generate the page: 0.10161 seconds