OraFAQ Forum: Security » How many maximum Redo Logfiles one can have in a Database

Home » RDBMS Server » Security » How many maximum Redo Logfiles one can have in a Database (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How many maximum Redo Logfiles one can have in a Database [message #218301]

Wed, 07 February 2007 12:10

sanjay_kant
Messages: 25
Registered: February 2007

Junior Member

How many maximum Redo Logfiles one can have in a Database?

Report message to a moderator

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 13:42:17 CST 2024