Home » RDBMS Server » Security » How many maximum Redo Logfiles one can have in a Database  () 1 Vote
How many maximum Redo Logfiles one can have in a Database [message #218301] Wed, 07 February 2007 12:10 Go to next message
sanjay_kant
Messages: 25
Registered: February 2007
Junior Member

How many maximum Redo Logfiles one can have in a Database?
Re: How many maximum Redo Logfiles one can have in a Database [message #218303 is a reply to message #218301] Wed, 07 February 2007 12:15 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Depends on what you specified for MAXLOGFILES during database creation (manually) or what you specified for "Maximum no. of redo log files" with DBCA. You can check the current max with:

SQL> select decode(type, 'REDO LOG', 'MAXLOGFILES'), records_total
  2  from v$controlfile_record_section
  3  where type = 'REDO LOG';

DECODE(TYPE RECORDS_TOTAL
----------- -------------
MAXLOGFILES             5

[Updated on: Wed, 07 February 2007 12:19]

Report message to a moderator

Previous Topic: Need info on availabilty of kerberos plugins for Oracle 10g
Next Topic: Accessing list of the objects
Goto Forum:
  


Current Time: Thu Mar 28 05:50:39 CDT 2024