| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12839 on 9.2.0.4
pagesflames_at_usa.net (Dusan Bolek) wrote in message news:<1e8276d6.0401150202.26bdce3a_at_posting.google.com>...
> cerebruspipeline_at_yahoo.co.uk (c3r3bro) wrote in message news:<74f64a8f.0401141244.79205455_at_posting.google.com>...
> > Definitely 9204, we upgraded after Oracle support pointed out the bug
> > you mentioned. Didn't help though.
> >
> > Here's a simpler example:
> >
> > alter table emp parallel;
> > alter table dept parallel;
> > alter session enable parallel dml;
> > delete emp;
> > delete dept;
> > ERROR at line 1:
> > ORA-12839: cannot modify an object in parallel after modifying it
> >
> > You can see that dept has not been modified before the last statement,
> > yet it still thinks it has. This is due to the constraint between the
> > two tables.
>
> That's even more strange. I can't reproduce this even on 9.2.0.1.
> There must be some differences between your and my setup. Can you post
> your parameters?
> I do not think so this kind of behaviour could be platform specific,
> so difference should be in some parameter.
>
> P.S. All my 9is are fresh new installs, no migration involved.
Here is the full list. You probably only need to increase parallel_max_servers and parallel_min_servers to replicate the problem.
parallel_threads_per_cpu=2
enqueue_resources=5000
db_block_size=16384
optimizer_mode=choose
optimizer_features_enable=8.1.3
db_files=500 db_file_multiblock_read_count=16 db_block_buffers=8192 db_writer_processes=8
pre_page_sga=true parallel_max_servers=256 parallel_min_servers=32
dml_locks=50000 log_buffer=81920000 log_checkpoints_to_alert=true log_checkpoint_interval=0
 |
 |