Lisa,
>From Steve Adams site:
Despite the potential for improved statistics gathering, many DBAs have not
yet adopted modification monitoring. One of the concerns that people have is
that the monitoring might have a significant performance overhead. In fact,
this is not the case. The modif
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
You may want to read up on table monitoring.
Jared
On Tuesday 28 January 2003 11:10, Koivu, Lisa wrote:
> 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.
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,
Lisa,
On our "home grown" partitioned databases, I am still using the ANALYZE command for
partitions. There were some bugs associated with DBMS_STATS and partitions, although
I don't remember the specifics at the moment (it may have been with 8.1.6). I haven't
had a chance to go back and se
14 matches
Mail list logo