-
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
-
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
-
db_files is a parameter in the init.ora parameter which cannot exceed the maxdatafiles value at any point
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|