Re: Parallel query on when it's not supposed to be (?)

On Sep 14, 2004, at 4:28 PM, Bobak, Mark wrote:

> Janine, yes, for that table, do:
> alter table table_name parallel (degree 1);
> and also set parallel_max_servers to 0, as the other Mark suggested.

Ok, I'll try it. I don't see parallel_max_servers in the init.ora file so I don't know how/where it's getting set.

> Um, the table w/ degree set to default, was that table involved in
> the problem query you described in the original post?

There are several tables set to default, actually, and yes several of them are in the view being selected from. So this could certainly be the problem. I wonder how they got that way? I am only a consultant on this project and not privy to all that has gone before, so we may never know.

FYI, I replied to both Marks and cc'd the list, but my replies were sent to the moderator because there was too much quoted material in them. Oops. So I have snipped out everything but my last reply - hopefully this will go through to the list!

janine

> -----Original Message-----
> From: Janine A Sisk [mailto:janine_at_furfly.net]
> Sent: Tuesday, September 14, 2004 4:20 PM
> To: Bobak, Mark
> Cc: oracle-l_at_freelists.org
> Subject: Re: Parallel query on when it's not supposed to be (?)
>
>
> Here you go:
>
> SQL> select table_name from dba_tables where degree >1;
> select table_name from dba_tables where degree >1
> *
> ERROR at line 1:
> ORA-01722: invalid number
>
>
> SQL> select index_name from dba_indexes where degree >1;
>
> no rows selected
>
> The error turned out to be because degree is a varchar2(10) in
> dba_tables, so I did this instead:
>
> SQL> select distinct degree from dba_tables;
>
> DEGREE
> -------------------------------
> 1
> DEFAULT
>
> Interesting... I think the DEFAULT might be the problem, because the
> tables that have this set are very closely related to this query.
> Should I change them to 1? Actually, neither of those values is
> exactly as it appears:
>
> SQL> select distinct '|' || degree || '|' from dba_tables;
>
> '|'||DEGREE||'|'
> ---------------------------------
> | 1|
> | DEFAULT|
>
> So I guess I would change it to 3 spaces + 1. Sounds like a magic
> incantation or something!
>
> thanks,
>
> janine

--
http://www.freelists.org/webpage/oracle-l