May 312013
 
create table baby as 
  select /*+ parallel (9) */months
  from   mothers;

ORA-12827: insufficient parallel query slaves 
(requested 9, available 1, parallel_min_percent 9)
12827. 00000 -  
"insufficient parallel query slaves available"

One for all the project managers to take note of - there's some tasks which 
simply can't be done any faster by throwing more people/resources at them ;)

  2 Responses to “Some things have to be serially”

  1. did you try
    [code]
    create /*+parallel(9) */ table baby as
    select nonuplets
    from mother;
    [/code]
    ?
    :-D

    • haha :)

      I think one baby at a time is enough; considering twins is scary enough, never mind nonuplets!

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>