Re: Tracking database usage patterns

Three ways to do it:
1 run $ORACLE_HOME/rdbms/admin/utlbstat and utlestat. This takes a snapshot from (amongst others) the V$SYSTAT virtual table and dumps results to report.txt in the current directory.
2 write your own scripts around V$SYSTAT, as this contains the accumulated info since database boot
3 use Oracle Enterprise Manager Performance Pack (I haven't been able to do this yet)

Sybrand Bakker, Oracle DBA

bdg_at_hotmail.com wrote:

> Is there a way to scientifically determine the times of minimum database
> usage. I'm interested in both the lowest transaction volume (to schedule
> on-line backups) and lowest interactive user sessions (to schedule
> maintenance tasks).
>
> My current guess for transaction volume is to use the V$LOG_HISTORY view, but
> I'm having a little trouble putting the available information together
> (redo log size / time between log switches). I think there might be a way to
> use the Oracle auditing to track interactive user sessions, but this is a new
> feature to me. Any words of encouragement that I'm taking the right approach
> would be valuable.
>
> Thanks,
> Brian Gastineau
> bgastine_at_giveblood.org
> DBA/Applications Developer
> Gulf Coast Regional Blood Center
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Aug 13 1998 - 15:10:56 CDT