Re: Logging

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 21 Feb 2001 06:22:46 +0100
Message-ID: <84k69tohmeh0avd7h128cob52hbnk4ld6l@4ax.com>

On Tue, 20 Feb 2001 15:47:14 -0900, Calvin Crumrine <Calvin_Crumrine_at_dced.state.ak.us> wrote:

>Some time back I found/generated a file that recorded log file switches.
>Now that I want to check it again I can no longer find it. Any ideas?
>
>What I'm trying to do is determine how often log switches occur. We
>aren't currently archiving our logs but we want to start. (More
>accurately, I've convinced management we should start.) I need to figure
>out how many log files are generated daily. As a side issue this will
>also tell me whether or not our log files are sized properly. I've heard
>that a log switch should occur every 15-30 minutes during the day.

select * from v$log_history

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Feb 20 2001 - 23:22:46 CST