Oracle-L: Re: How can I measure my DB performance.

From: <Jared.Still_at_radisys.com>
Date: Thu, 28 Aug 2003 16:34:25 -0800
Message-ID: <F001.005CDD14.20030828163425@fatcity.com>

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:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------