lt to
> > figure out the number of distinct values for a column from the number of
> > distinct values found in each partition because of the possible overlap
> > in values. Therefore, actually gathering global statistics with the
>
> DBMS_STATS
>
> > package is hig
Hi Gopal,
Thanks for the information.
I was not aware of this.
Regards,
- Kirti
-Original Message-
From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: Thu 1/30/2003 1:03 AM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:RE: Global Stats
Hi Kirti
It's not correct, check metalink -- there is a note about that.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
K Gopalakrishnan wrote:
Kirti:
I think the interval is changed to 5 minutes from
3 hours starting
ssage-
> From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
> Sent: Wed 1/29/2003 10:58 PM
> To: Multiple recipients of list ORACLE-L
> Cc:
> Subject: RE: Global Stats
>
> Kirti:
>
> Sorry for the typo. It is 15 minutes.
>
>
> --- K Gopalakrishna
lto:[EMAIL PROTECTED]]
Sent: Wed 1/29/2003 10:58 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: RE: Global Stats
Kirti:
Sorry for the typo. It is 15 minutes.
--- K Gopalakrishnan <[EMAIL PROTECTED]> wrote:
> Kirti:
>
> I think the interval is chan
PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: RE: Global Stats
Kirti:
I think the interval is changed to 5 minutes from
3 hours starting from 9i (rel2?).
Best Regards,
K Gopalakrishnan
-Original Message-
Kirti
Sent: Wednesday, January 29, 2003 8:19 PM
To: Mul
So, there is nothing automatic in gathering table
> stats.
>
> You can test it yourself. remember there is a last_analyzed
> column ;)
>
> HTH,
>
> - Kirti
>
>
>
>
> -Original Message-
> From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
> Sent: Wed 1/29/2003 9:09 A
athering table stats.
You can test it yourself. remember there is a last_analyzed column ;)
HTH,
- Kirti
-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Wed 1/29/2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:RE: Global Stat
le recipients of list ORACLE-L
Cc:
Subject:RE: Global Stats
Hi Jared,
Actually I think monitoring won't work in my case. Data loads fire
throughout the day and the docs say that in 8i, analyze can fire based upon
table monitoring sometime within 3 hours after data changes. I wo
E-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Global Stats
Hi Jared,
Actually I think monitoring won't work in my case. Data loads fire
throughout the day and the docs say that in 8i, analyze can fire based
upon table monitoring sometime within 3 hours after data changes.
Title: RE: Global Stats
Hi Jared,
Actually I think monitoring won't work in my case. Data loads fire throughout the day and the docs say that in 8i, analyze can fire based upon table monitoring sometime within 3 hours after data changes. I would rather include a manual fire of analy
nd grows by ~2GB
> per week. Even the smallest estimate with calculating global stats will
> take a long long time and I may not be able to spring for all the required
> temp space.
>
> How does the list feel about global stats? Does anyone agree with the
> documentation that they &
If I remember right, global stats are computed/inferred from partition level
stats if its available. If thats the case, then it may make sense to
compute/estimate the stats at the partition level. You also have the advantage
of being able to run analyze each partition in parallel.
Regards
hance to go back and see if we want to switch to DBMS_STATS.
On our 11i database (8.1.7), Oracle provided scripts specifically check to make sure
that global stats to not exist on partitioned tables (search for bde_last_analyzed.sql
on MetaLink). We analyze these tables with FND_STATS and a gran
Title: Global Stats
Hi everyone,
Back to the lovely world of Oracle :) I've been reading up on statistics. Out of the 8.1.7 doco:
/*
Partitioned schema objects may contain multiple sets of statistics. They can have statistics which refer to the entire schema object as a whole (g
15 matches
Mail list logo
