Re: parameter missing in v$parameter

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Tue, 22 May 2001 01:17:25 -0700
Message-ID: <F001.0030A4AC.20010522012011@fatcity.com>

Jothish,

Maxdatafiles is not an init.ora parameter so you won't find it in v$parameter. Backup the controlfile to trace and you should see your new setting for maxdatafiles.

Were you perhaps thinking of the init.ora parameter DB_FILES? This parameter does not change when maxdatafiles is changed, it must be changed manually.

You might want to review Note:119507.1 "V6/V7/V8: MAXDATAFILES and DB_FILES Parameters"

HTH,

• Anita
  • "K. JOTHISH" <jothish.k_at_tatainfotech.com> wrote:
    > Hi DBAs,
    > I recreated the controlfile to change the value
    > of the parameter
    > max_data_files.After that when i query for the
    > parameter 'max_data_files'
    > in the v$parameter i dont see this parameter
    > mentioned there!!!
    > I have taken a trace of the controlfile to
    > check the changed
    > value....but then i want to know why this is not
    > listed in the table
    > v$parameter now.
    > thanks in advance
    > jothish
    >
    > --
    > Please see the official ORACLE-L FAQ:
    > http://www.orafaq.com
    > --
    > Author: K. JOTHISH
    > INET: jothish.k_at_tatainfotech.com
    >
    > Fat City Network Services -- (858) 538-5051 FAX:
    > (858) 538-5051
    > San Diego, California -- Public Internet
    > access / Mailing Lists
    >
    

    ---

    
    > To REMOVE yourself from this mailing list, send an
    > E-Mail message
    > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > 'ListGuru') and in
    > the message BODY, include a line containing: UNSUB
    > ORACLE-L
    > (or the name of mailing list you want to be removed
    > from). You may
    > also send the HELP command for other information
    > (like subscribing).
    

    ---

Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue May 22 2001 - 03:17:25 CDT