-LSubject:
RE: dbms_stats broken
Hmmm
... I haven't tried with stale option, but gather-schema works.
I know
.. I know... this isnot the answer you were looking for
...
Raj
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]Sent: Wednesday, May 28,
2003 10:25 PMTo
Koivu, Lisa wrote:
Hello everyone,
Is anyone using dbms_stats and gather stale or gather auto in 9.2? Im
trying to use dbms_stats gather schema stats with the stale option and
it just isnt working in 8.1.7.4. This is documented on Metalink. Id
love to hear from someone else if this is fixed
Hey Lisa (Monkey?),
Yes, I had a problem with the stale option, too, at least under 8.1.6. It
would bomb out with no more rows or something like that. Under 8.1.7.4 on
Solaris, I no longer had that problem but I did have some poorer explain
plans than with good ol' ANALYZE. See the Burned by
Darrell,
I put dbms_stats into production, on 8.1.7.4, over two months ago have not
had a problem. Here is what I did to compute the stats automatically. (BTW: this
runs under system)
create procedure compute_daily_stats is
begin
for a in (select distinct table_owner from
PMTo: Multiple recipients of list
ORACLE-LSubject: dbms_stats broken
Hello everyone,
Is anyone using dbms_stats and gather stale or gather auto in 9.2? Im trying to use dbms_stats gather schema stats with the stale option and
it just isnt working in 8.1.7.4.
This is documented
Lisa,
I'm still using Analyze so I have no direct experience with this package.
That being said, would the SET_TABLE_STATS work for the partitions that
haven't been loaded yet?
Mike Hand
Polaroid Corp.
-Original Message-
Sent: Thursday, May 29, 2003 10:46 AM
To: Multiple recipients of
Hi Darrell Kirti -
It was late last night when I was looking at this. It seems I should be using GATHER
EMPTY instead of GATHER STALE. However this will put statistics on partitions with no
rows.
When I load new partitions tomorrow (they are empty prior to the daily load), the
number of
: Wednesday, May 28, 2003 9:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: dbms_stats broken
Lisa,
Wow, you might be saving me from peril right now. I have tested this
with a small set of tables with no problems (in and 8.1.7.4
instance).
I'm preparing to go 'schema' wide
Hi Mike,
Yes, I could use it... but the GATHER EMPTY option set stats on the empty partitions
correctly. I'm more concerned about having old stats on a partition that is now
loaded.
Thanks
-Original Message-
Sent: Thursday, May 29, 2003 12:30 PM
To: Multiple recipients of list
-Original Message-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 9:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: dbms_stats broken
Hi Darrell Kirti -
It was late last night when I was looking at this. It seems
I should be using GATHER EMPTY
-
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 9:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: dbms_stats broken
Hi Darrell Kirti -
It was late last night when I was looking at this. It seems
I should be using GATHER EMPTY instead of GATHER
Hello everyone,
Is anyone using dbms_stats and
gather stale or gather auto in 9.2? Im
trying to use dbms_stats gather schema stats with the
stale option and it just isnt working in 8.1.7.4. This is documented on Metalink. Id love to hear from someone else if
this is fixed in 9.2 and if
ORACLE-LSubject: dbms_stats broken
Hello everyone,
Is anyone using dbms_stats and gather stale or gather auto in 9.2? I'm trying to use dbms_stats gather schema stats with the stale option and
it just isn't working in 8.1.7.4.
This is documented on Metalink. I'd love to hear
Lisa,
Wow, you might be saving me from peril right now. I have tested this
with a small set of tables with no problems (in and 8.1.7.4 instance).
I'm preparing to go 'schema' wide in the next week or so for further
testing prior to implementing in production.
I'd be very interested in more
Hello Lisa Monkey,
What platform are you jumping up on?
Do you have tables with lots of branches.. er.. partitions?
I have been using dbms_stats to collect stale stats on HP-UX 11.0 with a 8.1.7.4
database. These
are not partitioned tables. All are being 'monitored', the script to collect
I don't use it but the other DBA in our group does (gather stale)...
and it's working in 9.2.0.1 and 9.2.0.2
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
Hello everyone,
Is anyone using dbms_stats and gather stale or gather auto in 9.2?
I'm
trying to use dbms_stats gather schema stats with
16 matches
Mail list logo