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 #136759]

Fri, 09 September 2005 23:25

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????

Bhavin

Report message to a moderator

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

Sat, 10 September 2005 05:23

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

There are only two options.
with spfile (in 9i) and pfile (all versions).
in 9i spfile is the default.
There is NO direct method. You can guess.

sql > startup
ORACLE instance started.

Total System Global Area  202868968 bytes
Fixed Size                   731368 bytes
Variable Size             167772160 bytes
Database Buffers           33554432 bytes
Redo Buffers                 811008 bytes
Database mounted.
Database opened.
sql > show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      ?/dbs/spfile@.ora
sql > shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
sql > startup open pfile='$ORACLE_HOME/dbs/initmutation.ora';
ORACLE instance started.

Total System Global Area  202868968 bytes
Fixed Size                   731368 bytes
Variable Size             167772160 bytes
Database Buffers           33554432 bytes
Redo Buffers                 811008 bytes
Database mounted.
Database opened.
sql >  show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
sql >

Report message to a moderator

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

Sat, 10 September 2005 06:41

bhavind
Messages: 8
Registered: September 2005

Junior Member

Thanks mahesh

Report message to a moderator

Previous Topic:	Error TNS-12542
Next Topic:	Solaris 9 Oracle 10.1.0.2 install 10.1.0.4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 08:03:59 CST 2025