Re: OLTP compression slow update
- From: Jared Still <jkstill@xxxxxxxxx>
- To: "Patterson, Joel" <Joel.Patterson@xxxxxxxxxxx>
- Date: Wed, 26 Dec 2012 13:54:12 -0800
On Wed, Dec 26, 2012 at 11:55 AM, Patterson, Joel <
Joel.Patterson@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
