Re: Which parameter file has been used?

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Sat, 21 Aug 2004 00:46:54 +0200
Message-Id: <1093042014.10428.3.camel@dbalert199.dbalert.nl>

Diego,
On unix 'ls -lutr' shows a directory listing with access times, sorted from old to new. The latest accessed parameterfile is probably the the one used to start the database, unless the files were accessed for backup purposes, by vi, grep or whatever. No idea whether this is possible in Window$ though.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===
On Sat, 2004-08-21 at 01:56, Diego Cutrone wrote:

> Hi list,
> Just wondering.
> Imagine you have more than one valid parameter file in the system (not spfile), and someone else has started the database.
>
> How can you know which parameter file he/she used to start instance up ?
>
> Is there any other option besides comparing values between v$parameter and the init.ora files?
>
> Thanks in advance
> Best Regards,
> Diego

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Aug 20 2004 - 15:42:32 CDT