Re: Count # of log switches accurately?

From: Joel Garry <joelga_at_pebble.org>
Date: Tue, 04 Aug 1998 18:18:27 GMT
Message-Id: <slrn6sek5k.2jl.joelga@pebble.org>

On Sun, 02 Aug 1998 15:50:17 GMT, johnvue_at_gte.net <johnvue_at_gte.net> wrote:
>What's the easiest way to _accurately_ find out # of log switches?
>
>I can see # of checkpoints from v$sysstat:
> DBWR checkpoints 7521
>
>I could look in v$loghist but that seems to only show the last 100
>rows. That may not be enough to see all the log switches since the
>instance was started.
>
>I could also manually count them in alert_SID.log but there's got to
>be a better way.
>
>Thanks.

If you are on a unix type shell you can (off the top of my head), grep "log sequence" <your alert log> | wc -l

Note that this will multiple count the attaches and closes to the same log file as you bounce the db. If that isn't part of your idea of a log switch, add an additional grep for "advanced".

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Tue Aug 04 1998 - 13:18:27 CDT