-Original Message-
From: Post, Ethan [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 5:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBMS_STATS.GATHER_DATABASE_STATS
analyzes SYS and SYSTEM
inde
Arr...
So anyway, I am
] Quad/Tech
International, Sussex, WI USA
-Original Message-
From: Post, Ethan [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 5:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBMS_STATS.GATHER_DATABASE_STATS
analyzes SYS and SYSTEM
inde
]]
Sent: Friday, October 04, 2002 5:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM
inde
Arr...
So anyway, I am thinking, hey it's high time I start using DBMS_STATS
instead of my own procedure so I kick
: DBMS_STATS.GATHER_DATABASE_STATS
analyzes SYS and SYSTEM
inde
Arr...
So anyway, I am thinking, hey it's high time I
start using DBMS_STATS
instead of my own procedure so I kick of the
following
(Oracle 8.1.7.4).
After the first run I have SYS and SYSTEM stats on
indexes
: DBMS_STATS.GATHER_DATABASE_STATS
analyzes SYS and SYSTEM
inde
Arr...
So anyway, I am thinking, hey it's high time I
start using DBMS_STATS
instead of my own procedure so I kick of the
following
(Oracle 8.1.7.4).
After the first run I have SYS and SYSTEM stats on
indexes
] Quad/Tech
International, Sussex, WI USA
-Original Message-
From: Post, Ethan [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 5:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBMS_STATS.GATHER_DATABASE_STATS
analyzes SYS and SYSTEM
inde
It is still quirky in 9.2.0.1.
Now it does not like an FBI on a table :(
Check out bug# 2606697 on Metalink...
- Kirti
-Original Message-
Sent: Monday, October 07, 2002 10:29 AM
To: Multiple recipients of list ORACLE-L
inde
Yes, the DBMS_STATS package is very quirky in 8i, IMHO.
-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 12:30 PM
To: oracle list
Cc: Jesse, Rich
Subject: RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM
inde
It is still quirky in 9.2.0.1.
Now it does not like an FBI on a table :(
Check out bug
Man that is ridiculous. You would think Oracle would have it's act together
on DBMS_STATS package by now. Since is it supposedly so superior to analyze
table you would think it might actually work.
Ethan Post
perotdba (AIM), epost1 (Yahoo)
: Jesse, Rich
Subject: RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM
inde
It is still quirky in 9.2.0.1.
Now it does not like an FBI on a table :(
Check out bug# 2606697 on Metalink...
- Kirti
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED
Arr...
So anyway, I am thinking, hey it's high time I start using DBMS_STATS
instead of my own procedure so I kick of the following (Oracle 8.1.7.4).
After the first run I have SYS and SYSTEM stats on indexes and on other
schemas with NO STATS it just ignored those tables even though you can
11 matches
Mail list logo