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: Basic SQL Question, re. logging costly sql

Re: Basic SQL Question, re. logging costly sql

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 20 Oct 2005 08:21:16 -0700
Message-ID: <1129821669.307278@yasure>


BD wrote:

>>Getting statspack up and running only takes 5 minutes.
>>Your decision to put it at the bottom of a list is very questionable.

>
>
> Most things take 5 minutes if you've done them several times. Look at
> how long I've been mucking with RMAN, trying to get it going for the
> first time! And NOW, I have to work out the differences in 10g's RMAN.
> Ahh, the fun never stops. ;)
>
> Besides, it's not a conscious decision to NOT do it; I just have bigger
> fish to fry most of the time.
>
> But, I'm sure statspack is considerably more straightforward than RMAN.
> I'll try to bump it up on the priority list, as I know it's something
> we'd benefit from.

And after getting STATS Pack working try RMAN through OEM rather than the command line. If it takes you more than 1 hour you weren't paying attention.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Oct 20 2005 - 10:21:16 CDT

Original text of this message

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