OraFAQ Forum: Server Administration » Can we know which file we are using after db started?

Home » RDBMS Server » Server Administration » Can we know which file we are using after db started?

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

Can we know which file we are using after db started? [message #136760]

Fri, 09 September 2005 23:26

bhavind
Messages: 8
Registered: September 2005

Junior Member

Hi Frends,

I have one doubt..

let us assume some one have started the DB. now i want to know which file that person used for starting purpose?????

so my question is --- in a running database, can we find which file is used when it was started (pfile or spfile) ????

Bhavin

Report message to a moderator

Re: Can we know which file we are using after db started? [message #136784 is a reply to message #136760]

Sat, 10 September 2005 04:01

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

If DB is started using spfile then search for parameter spfile:

show parameter spfile.

Value will be the name of spfile used.

Regds
Girish

Report message to a moderator

Previous Topic:	9i: Data dictionary views does exists
Next Topic:	Error TNS-12542

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 10 15:27:06 CDT 2025