RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-08 Thread Connor McDonald
-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

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-08 Thread Connor McDonald
] 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

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-07 Thread Jesse, Rich
]] 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

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-07 Thread Connor McDonald
: 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

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-07 Thread Cherie_Machler
: 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

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-07 Thread MacGregor, Ian A.
] 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

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-07 Thread Deshpande, Kirti
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.

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-07 Thread Jesse, Rich
- 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

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-07 Thread Post, Ethan
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)

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-07 Thread Deshpande, Kirti
: 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

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-04 Thread Post, Ethan
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