, May 28, 2002 6:43 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Parallel degrees in DBMS_STATS
I'd be interested to know of the bugs you've found on
DBMS_STATS; most of
the bugs I've seen logged against it were created due to
differences with
ANALYZE, and in the end
Run following query and check whether relevent table/index has degree 1
select index_name,degree from dba_indexes where degree 1
/
select table_name,degree from dba_tables where degree 1
/
If degree 1 then it will use nymber of PQ process equivalent to number od
degree
Regards
Rafiq
-Original Message-
From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Parallel degrees in DBMS_STATS
Run following query and check whether relevent table/index
has degree 1
select index_name,degree
I'd be interested to know of the bugs you've found on DBMS_STATS; most of
the bugs I've seen logged against it were created due to differences with
ANALYZE, and in the end it was determined that ANALYZE produced the wrong
result, not DBMS_STATS...
Anyway, the symptoms you describe match those