Re: Need help: wio rease from 1% to more than 50% after increasing SGA size
- From: "gym dot scuba dot kennedy at gmail" <kennedyii@xxxxxxxxxxx>
- Date: Sat, 28 Jun 2008 04:24:24 GMT
<jshen.cad@xxxxxxxxx> wrote in message
news:3f189857-8aff-4752-8849-cab02cec8183@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?
No, it will not necessarily help your performance. You are ignoring
analyzing what is going on, what is actually the bottleneck. Regardless of
the version you need to identify what step int he query process is taking so
long. Then work to eliminate the largest one. That may mean a larger cache
size, but not necessarily.
Jim
.
- References:
- Need help: wio rease from 1% to more than 50% after increasing SGA size
- From: jshen.cad@xxxxxxxxx
- Re: Need help: wio rease from 1% to more than 50% after increasing SGA size
- From: gym dot scuba dot kennedy at gmail
- Re: Need help: wio rease from 1% to more than 50% after increasing SGA size
- From: jshen.cad@xxxxxxxxx
- Need help: wio rease from 1% to more than 50% after increasing SGA size
- Prev by Date: Re: RMAN, Best Practice?
- Next by Date: Re: RMAN, Best Practice?
- Previous by thread: Re: Need help: wio rease from 1% to more than 50% after increasing SGA size
- Next by thread: Re: Need help: wio rease from 1% to more than 50% after increasing SGA size
- Index(es):
Relevant Pages
|
