Tracking database usage patterns

From: <bdg_at_hotmail.com>
Date: Thu, 13 Aug 1998 16:29:57 GMT
Message-ID: <6qv4a4$6fi$1@nnrp1.dejanews.com>

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 - 11:29:57 CDT