RE: Event 10046 and Performance

2002-11-18 Thread Jamadagni, Rajendra
Title: RE: Event 10046 and Performance No, we are 9201 on Test/Prod ... we are getting ready to test 9202 though ... As Cary suggested ... I am going to watch is today ...let's see ... it would be interesting .. Raj __ Rajendra Jamadagni

Re: Event 10046 and Performance

2002-11-18 Thread John Shaw
I am in the middle of this fight myself. We had an Oracle consultant come in to look at our performance problems. He spent a 3 days examing the sql and coming up with various reasons that our code was slow. Then the "BUG" cropped up - one of his reports that had been running great all of a

Re: Event 10046 and Performance

2002-11-17 Thread Binley Lim
It is not uncommon to find the problem disappearing after switching debugging/tracing on, but in this case I'm wondering if its some feature with 9201? Are your test/prod on the same patch release? or you have already applied 9202 to your test environment? [EMAIL PROTECTED] 11/16/02 11:48a.m.

RE: Event 10046 and Performance

2002-11-15 Thread Cary Millsap
Title: Event 10046 and Performance Ah, the secret power of event 10046 reaches the light of day at last! J Just kidding Is there a chance that its coincidence, that some workload variation that causes poor performance just happens not to have occurred since you instrumented the form?