Re: OLTP compression slow update
From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 26 Dec 2012 13:54:12 -0800
Message-ID: <CAORjz=M93dCSJygnRsnZ9KX=Mz1W-U0V4KDdYey8L1VuqZTGxw_at_mail.gmail.com>
On Wed, Dec 26, 2012 at 11:55 AM, Patterson, Joel < Joel.Patterson_at_crowley.com> wrote:
> Its been awhile, so just to make sure -- I believe runstats is best served
> on a database which has no-one else doing business -- like if you could fit
> it on your laptop, or after hours. Not even sure if multiple databases on
> the same server can serve to skew the results depending on what you are
> going for.
>
> The reason being is that every session is contributing to the numbers --
> like enqueues, latches, mutexes, or runtime.
>
Date: Wed, 26 Dec 2012 13:54:12 -0800
Message-ID: <CAORjz=M93dCSJygnRsnZ9KX=Mz1W-U0V4KDdYey8L1VuqZTGxw_at_mail.gmail.com>
On Wed, Dec 26, 2012 at 11:55 AM, Patterson, Joel < Joel.Patterson_at_crowley.com> wrote:
> Its been awhile, so just to make sure -- I believe runstats is best served
> on a database which has no-one else doing business -- like if you could fit
> it on your laptop, or after hours. Not even sure if multiple databases on
> the same server can serve to skew the results depending on what you are
> going for.
>
> The reason being is that every session is contributing to the numbers --
> like enqueues, latches, mutexes, or runtime.
>
No, it may only skews the timing.
The stats are taken from v$mystat
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 26 2012 - 22:54:12 CET