Alex,Thanks for your critique and suggestions. Someone else suggested using the same events (10046/10053) off list and I am looking into it now. This is the first major performance issue we've had in years so we are rusty in this area.
I appreciate all the other comments, too. Thanks. Joe Alex Gorbachev wrote:
Dear list, It was very interesting to track the development of this thread and I've been waiting whether someone will come up with a suggestion to take a little different investigation approach instead of, well, guesswork. It's a little slow due to the weekend and vacation season and I'm a bit impatient. :) So my apologies to Joe for hijacking this thread.
-- //www.freelists.org/webpage/oracle-l