RE: database resource usage

  • From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 29 Sep 2006 11:22:39 -0400

Stephen,
 
    Have you ever heard of a product called Bez Prophet for Oracle?
It's marketed by a company called BEZ Systems (
http://www.bez.com/bez-oracle.htm).  Having used the product before for
just what your doing I can highly recommend it.  You'll probably have to
live with your current setup for about a month during which time the
Prophet accumulates data on what your databases are doing.  Thereafter
it can predict, with 80 to 90% accuracy, what will happen is a number of
different scenario's you feed it.  Including separating out the OLAP
instance.  It's written by a serious bunch of "propeller heads" who are
DEEP into system queues, io stats, etc.
 

  
Dick Goulet, Senior Oracle DBA

45 Bartlett St  Marlborough, Ma 01752, USA
Tel.: 508.573.1978 |Fax:  508.229.2019 | Cell:508.742.5795 

RGoulet@xxxxxxxxxx
: POWERING TRANSFORMATION 

 

________________________________

From: Stephens, Chris [mailto:chris_stephens@xxxxxxxxxxxx] 
Sent: Friday, September 29, 2006 10:25 AM
To: oracledba.williams@xxxxxxxxx; Richard J. Goulet
Cc: ORACLE-L
Subject: RE: database resource usage


full blown olap application.  ...yes, i agree.  we need another server.
 
I am trying to graph out database resource usage and correlate that with
server resource usage in order to justify this.  ...i'm hoping there is
something like the Miracle yapp stuff that will do that for me. :)

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams
Sent: Friday, September 29, 2006 9:15 AM
To: rgoulet@xxxxxxxxxx
Cc: ORACLE-L
Subject: Re: database resource usage


Chris,
 
One question. When you say you have some OLAP developers, what is the
plan? Are they just developing some reports, or is your organization
developing a proper data warehouse? If so, they will want to get a
separate server in the future. 
 
Dennis Williams

CONFIDENTIALITY NOTICE: 
This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If the
reader of this message is not the intended recipient or the employee or
agent responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution or copying
of this communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by email reply. 

GIF image

Other related posts: