Database Load or Usage calculation

From: <mune19642003_at_yahoo.com>
Date: 11 Aug 2006 16:40:02 -0700
Message-ID: <1155339602.316949.82910_at_i42g2000cwa.googlegroups.com>


[Quoted] [Quoted] I want to get some opinions on what would be a good way to calculate or maybe ballpark estimate the LOAD or CRITICALITY or USAGE etc of an Oracle database.

This is more from the point of view of an SLA. So lets say we signup for supporting a database with x amount of resources and then subsequently the number of USERS increase or maybe that remains the same but their USAGE increases ie they submit more SQL QUERIES to the database. Or maybe the users share connections using a SHARED / WEB / APPLICATION account and just the number of SESSIONS keeps increasing or such or maybe its just the DATA VOLUME or DISK SPACE but that is also not the only factor if the data volume stays same due to archival but many APPS are sharing the database or such ...

[Quoted] What might be a good way to say that - OK last year X was the total usage of the database and this year Y is the total usage and so the support cost increases by Y-X coefficient.....

Thoughts ?? Received on Sat Aug 12 2006 - 01:40:02 CEST

Original text of this message