performance

HammerOra Quick Start...

Submitted by dave on Sun, 07/27/2008 - 21:20

Its time to test some IO.

I have used OraBM/OraStress in the past to throw a load at an Oracle server.

This time I wanted to see what else was out there. I had seen mention of HammerOra on forums and listserves so I figured I'de give it a shot. Here's what it took to get it running on a Windows server.

1) Download and Install HammerOra

Their home page is here: http://hammerora.sourceforge.net/

Tags: 
oracle
performance

Execution plans and bind peeking...

Submitted by dave on Fri, 03/21/2008 - 13:10

If you haven't seen this optimizermagic.blogspot.com post already, check it out.

It covers the standard Execution Plan stuff, but also covers use of the dbms_xplan package including using dbms_xplan.display to format output and using dbms_xplan.display_cursor to see Bind Variables used to generate a plan!

Click here for Article

-- Dave

Tags: 
oracle
performance

RDA and HCVE...

Submitted by dave on Wed, 01/02/2008 - 22:56

I haven't look at Oracle's Remote Diagnostic Agent (RDA) tool in a couple of years. Back when we ran our systems on Windows I remember using a clunky version of RDA that looked like it was cobbled together with batch files and VB code.

What is RDA? From the Oracle website:

Tags: 
oracle
monitoring
performance

Pages

Subscribe to performance