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

Home -> Community -> Usenet -> c.d.o.server -> Re: Statspack comparison

Re: Statspack comparison

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: 25 Jan 2006 11:31:23 -0800
Message-ID: <1138217483.952840.19370@g47g2000cwa.googlegroups.com>


Statspack has it's place. It is good for gathering systemic information, identifying those types of issues. It is also good as a historical reference, especially when you write your own queries to extract relevant data.

Will it identify a specific user complaint? Probably not, that is where extended sql_trace comes in to play.

The key to using a tool is to use it appropriately and to understand what it can't do for you.

Regards,
Daniel Fink Received on Wed Jan 25 2006 - 13:31:23 CST

Original text of this message

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