Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How can I measure my DB performance.

Re: How can I measure my DB performance.

From: <bulbultyagi_at_now-india.net.in>
Date: Thu, 04 Sep 2003 12:04:33 -0800
Message-ID: <F001.005CECE6.20030904120433@fatcity.com>


I too have mine setup to take a snapshot every 15 minutes. Can you teach me how to automate purges using sppurge.sql ? Thanks
.........

> Start by installing and configuring statspack.
>
> I have mine setup to take a snapshot every 15 minutes.
>
> It collects a lot of data, I am now in the midst of automating a purge
> process. :)
>
> Then implement YAPPPACK from http://www.miracleas.dk/en/tech.html
> and use the data to create response time charts.
>
> At least, that's one way to do it.
>
> Jared
>
>
>
>
>
>
> Jake Johnson <jake_at_plutoid.com>
> Sent by: ml-errors_at_fatcity.com
> 08/28/2003 04:59 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> cc:
> Subject: How can I measure my DB performance.
>
>
> Is there a standard query I can run to compare the performance of a db.
> (Kind of like bogomips for unix)
>
> Thanks,
> Jake Johnson
> jake_at_plutoid.com
>
> ______________________________________________________________________
> Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
> Rims, Tires, and Wheel Packages.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jake Johnson
> INET: jake_at_plutoid.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Sep 04 2003 - 15:04:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US