Re: On SSDs - Unable to update System Stats (Noworkload)!
- From: PD Malik <pdthedba@xxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
- Date: Fri, 8 Feb 2013 17:47:37 +0000
This is strange and I can not believe the documentation for the first link
being right at all because it seems to say that even cpuspeed is gathered
with NOWORKLOAD but cpuspeedNW ( NW = NO WORKLOAD) is specifically designed
for No Workload so cpuspeed can not be updated with noworkload stats. Same
with maxthr - that's again a workload stats!
Anyway, it doesn't answer my question anyway so I guess will go down the
route of raising an Oracle SR ... unless someone else enlightens me from
Oracle-L!
Thanks.
On Fri, Feb 8, 2013 at 3:15 PM, Rich Jesse <rjoralist2@xxxxxxxxxxxxxxxxxxxxx
> wrote:
> Howdy,
>
> > We are unable to gather the NOWORKLOAD System stats on our SSD storage
> > (Violin + IBM V7000) based Oracle systems or more precisely, its
> completing
> > successfully but the stat number remain unchanged at their default
> values.
> >
> > This is what we are doing :-
> >
> > SQL> SELECT pname, pval1
> > 2 FROM sys.aux_stats$
> > 3 WHERE sname = 'SYSSTATS_MAIN';
> >
> > PNAME PVAL1
> > ------------------------------ ----------
> > CPUSPEEDNW 1560
> > IOSEEKTIM 10
> > IOTFRSPEED 4096
>
> The documentation does seem a little fuzzy on this, where the table in the
> link below says cpuspeed and maxthr would be gathered using NOWORKLOAD:
>
> http://docs.oracle.com/cd/E25178_01/server.1111/e16638/stats.htm#i41496
>
> But the text below the table in the "Noworkload Statistics" section doesn't
> seem to support that:
>
> http://docs.oracle.com/cd/E25178_01/server.1111/e16638/stats.htm#CIHGHDFG
>
> I wonder if this is a documentation bug...
>
> Rich
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
