Re: Database creation parameters

From: Wasim Hamwi <whamwi_at_bright.net>
Date: Sun, 3 Jan 1999 00:31:43 -0800
Message-ID: <76mv95$lks$1@cletus.bright.net>

James

I don't think you can get the values of the MAXLOGFILES, MAXDATAFILES from v$paramters. These are the values which specified at database creation. You would need to backup control file to trace and look into the trace file to find out the values of these paramters. These paramters ca not be changed unless you recreate the control file which can be done since the trace file will provide you with the script to recreate the control file. Check it out.

Thanks;

Wasim
Peter Chan wrote in message <3676C444.C8320DD2_at_nortelnetworks.ca>...
>You can:
>
>1. Query the v$parameter view.
>
>2. Run the following command line:
> sql> show parameter <parameter_name>;
>
>James McKay wrote:
>
>> Hi,
>> Can anyone tell me where exactly Oracle stores database creation
>> parameters, such as MAXLOGFILES, MAXDATAFILES etc? Thanks in advance.
>> James.
>
Received on Sun Jan 03 1999 - 02:31:43 CST