Parallel query on when it 's not supposed to be (?) 2004-09-14 - By Janine A Sisk
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@(protected)]
> Sent: Tuesday, September 14, 2004 4:20 PM
> To: Bobak, Mark
> Cc: oracle-l@(protected)
> 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 (See ORA-01722.ora-code.com): 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
|
|
