Parameter Values
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Parameter Values

  1. #1
    Join Date
    Sep 2001
    Location
    Pondicherry-India
    Posts
    33

    Question

    Hi guys,

    How to view the value of the parameters:

    MAXLOGFILES
    MAXLOGMEMBERS
    MAXLOGHISTORY
    MAXDATAFILES
    MAXINSTANCES

    How to change the value of these parameters.

    What is the difference between MAXDATAFILES and db_files.




    Regards

    Ramji

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi

    These paramters are created when the Database is created.So if you want to cahnge these parameters you need to recretae the control file.

    Alter database backup controlfule to trace.

    go to OracleHome/admin/sid/udump there you will find a text file which contains the Trace of the control file.

    Regards
    Hrishy

  3. #3
    Join Date
    Jul 2002
    Posts
    132
    db_files is a parameter in the init.ora parameter which cannot exceed the maxdatafiles value at any point

  4. #4
    Join Date
    Jul 2002
    Posts
    2
    Hi-

    You can also use a select like this to show all but maxlogmembers:

    SELECT decode(type, 'REDO LOG', 'MAXLOGFILES',
    'DATAFILE', 'MAXDATAFILES',
    'LOG HISTORY','MAXLOGHISTORY',
    'REDO THREAD','MAXINSTANCES'),
    records_total "VALUES"
    FROM v$controlfile_record_section
    WHERE type in ('REDO LOG','DATAFILE','LOG HISTORY','REDO THREAD');

    DECODE(TYPE,' VALUES
    ------------- ----------
    MAXINSTANCES 1
    MAXLOGFILES 16
    MAXDATAFILES 50
    MAXLOGHISTORY 226

    This is from a controlfile dump (to verify):
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 50
    MAXINSTANCES 1
    MAXLOGHISTORY 226

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width