Re: Need help: wio rease from 1% to more than 50% after increasing SGA size
From: <jshen.cad_at_gmail.com>
Date: Fri, 27 Jun 2008 07:36:27 -0700 (PDT)
Message-ID: <3f189857-8aff-4752-8849-cab02cec8183@q24g2000prf.googlegroups.com>
> I don't think 8.1.7 is even supported any more. Upgrade to something a
> little more recent.
> To find out why trace what the queries are doing. What is taking so long?
Date: Fri, 27 Jun 2008 07:36:27 -0700 (PDT)
Message-ID: <3f189857-8aff-4752-8849-cab02cec8183@q24g2000prf.googlegroups.com>
>
> I don't think 8.1.7 is even supported any more. Upgrade to something a
> little more recent.
> To find out why trace what the queries are doing. What is taking so long?
maybe that's a solution, but currently it could not help me out of trouble.
To my understanding, enlarge data buffer will do help with oracle performance, but whil wio increase so fast? Received on Fri Jun 27 2008 - 09:36:27 CDT