Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: maxlogfiles and maxlogmembers

Re: maxlogfiles and maxlogmembers

From: No Name <no_at_emain.com>
Date: Sun, 7 Nov 1999 19:58:00 -0000
Message-ID: <808bn1$9dr@news.csus.edu> 





    
  
  1.   connect to server manager
  
  2.   backup controlfile to trace;
  
  3.   exit server manager.
  
  4.   View the generated trace file
Aamir Siddiqi wrote in message <3825c316_at_news.cyber.net.pk>...

    
>Hi,

    
>

    
>You can execute the following select statement at Server Manager, SQL DBA

    
or

    
>SQL Plus to find out the number of Log Files; and their statistics

    
>

    
>SELECT * FROM v$logfile;

    
>

    
>Regards,

    
>

    
>

    
>Christ Follower <christ_follower_at_my-deja.com> wrote in message

    
>news:800bmc$rb0$1_at_nnrp1.deja.com...

    
>> How do I find out maxlogfiles and maxlogmembers settings in an existing

    
>> database? Thanks.

    
>>

    
>>

    
>> Sent via Deja.com http://www.deja.com/

    
>> Before you buy.

    
>

    
>

    





Received on Sun Nov 07 1999 - 13:58:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US