Re: Weird database hanging

I have opened an SR with Oracle, as it has hung 3 times today and actually crashed once.

When the database hang, Ignite is showing "latch: shared pool" and "latch: library cache" waits. Otherwise I don't see these at all.

Oracle has had me up OPEN_CURSORS and SESSION_CACHED_CURSORS, but I did that last night (with instance restart) and, as I said, it has hung 3 times and crashed once since then. Oracle's also telling me that this is largely due to application coding. My problem with that is that the application code has been in place for a while.

To recap: we migrated to the 64-bit machine on Sep 1. Hanging has occurred since Sep 13, seemingly during bulk load activity. Our SGA is quite a bit larger (16 GB) than on our 32 bit box (1.5 GB).

db_cache_size                        big integer 12G
shared_pool_size                     big integer 2G

I haven't seen the "block change tracking buffer space" wait since yesterday morning, thankfully.

Any tips would be appreciated.

Thanks,
Don.

-- 
Don Seiler
oracle: http://ora.seiler.us
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l