Re: Two "create table as select" locking?

Perhaps the partitioned table is a clue - there are bugs in library cache locking for partitioned tables. Maybe there was a sequence of

    pin table definition
    pin partition definition
or similar, that caused the two sessions to collide.

Another place to look when this happens is v$session_wait to find out what it is that each session is waiting for (like 'latch free'. 'enqueue', 'library cache' etc.) and whether a session is WAITING for a very long time, or doing lots of short waits and backing off and trying again.

--
Jonathan Lewis

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




Greg Simpson wrote in message ...


>

>>Were the tables partitioned ?

>>

>

>The tables being selected from are partitioned. The tables being create are

>not.

>

>

>I'll pass along the tip about looking at v$lock and dba_kgllock. Maybe that

>will provide a clue to what's going on.

>