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: Oracle11 & statistics calculations

Re: Oracle11 & statistics calculations

From: <sybrandb_at_hccnet.nl>
Date: Wed, 29 Aug 2007 11:38:19 +0200
Message-ID: <2ifad3davqo3jiard9revtjf97sc33llks@4ax.com>


On Wed, 29 Aug 2007 05:25:38 -0400, Mladen Gogala <mgogala_at_yahoo.com> wrote:

>Oracle11 has some new additions to the mechanism of statistics
>calculation. The old GATHER_STATS_JOB is gone, it is replaced by
>BSLN_MAINTAIN_STATS_JOB which, unfortunately, doesn't run DBMS_STATS, it
>uses an undocumented package DBSNMP.BSLN_INTERNAL which maintains
>baselines for the AWR. I have to questions:
>1) Is AWR in version 11G still a licensed product that has to be paid
> for? Do we still have to spend money on statspack on steroids?

That info is probably located in 'Oracle 11g, a family of products' so no need to ask here.
Apart from that, who is using 11g?

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Wed Aug 29 2007 - 04:38:19 CDT

Original text of this message

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