| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Free buffer requested
Ramon,
I would recommend to use UTLBSTAT.SQL and UTLESTAT.SQL output may show you bottlenecks. May be the application needs to be tuned.
Log switches are too often. Should be at least 10 min or more.
"redo log space requests" is probably also high.
Looks like LGWR often waits for DBWR to write all dirty buffers on disk when
log switches happen.
Make Redo Log files about 500M - 1000M and see if there is improvements.
-- HTH Alexandre ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, June 20, 2002 4:58 PMReceived on Thu Jun 20 2002 - 11:38:46 CDT
> Thanks a lot to all of you that are helping me, Igor, Anjo, Dennis,
> Alexander, Charlie, Chaos, Ferenc
>
> As a matter of fact the performance is good, I used to ran a process in
> another computer that last 5 hours and in this computer last just 2.5
hours.
> But I see the disk controllers very, very, very busy and checking the
> statistics when the process was running I got these values
>
> redo log space wait time ---> 58,554 ****
> redo buffer allocation retries ---> 18
>
> The process is runing alone in the computer just one connection.
>
> The disk controller has 256MB cache.
>
> I think that the performance could be better according to the computer
> configuration, Sun Sparc 4 processors at 800MHZ, 8GB of RAM. They blame
the
> database configuration for the slow performance of the disks.
>
> As I said yesterday I think that the disks can't manage the data flow of
the
> computer.
>
> The 1GB of shared pool I don't consider it unappropiate because the
computer
> has 8GB of ram.
>
> Tks again,
>
> Ramon
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, June 19, 2002 8:53 PM
>
>
> > Ramon - Just to follow that thought, and I apologize if you've responded
> to
> > this already, how is the disk I/O? Are the controllers very busy? What
is
> > the I/O distribution across devices? Is it RAID5? If so, how much RAM
does
> > the RAID controller have?
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> >
> > -----Original Message-----
> > Sent: Wednesday, June 19, 2002 8:28 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Igor,
> >
> > Online redologs are 100MB size and in a different disk.
> >
> > Database is NOT in archive.
> >
> > Log switches are ocurring each 2 minutes.
> >
> > I am getting to the conclusion that the processing power of the computer
> is
> > by far more than the disks can manage.
> >
> > Tks,
> >
> > Ramon
> >
> > -----Original Message-----
> > From: "root_at_fatcity.com" <root_at_fatcity.com> on behalf of "Igor
> > Neyman" <ineyman_at_perceptron.com>
> > Sent: Wednesday, June 19, 2002 5:30 PM
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Subject: Re: Free buffer requested
> >
> > Ramon,
> >
> > Describing your file allocation, you don't tell, where your online
> RedoLogs.
> > Also, are you running in archived mode? How often log switches occur?
> >
> > Igor Neyman, OCP DBA
> > ineyman_at_perceptron.com
> >
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, June 19, 2002 4:33 PM
> >
> >
> > > Anjo, Igor
> > >
> > > Apologies, didn't make myself clear.
> > >
> > > Redo log space wait time has a value of 58,554
> > > Redo buffer allocation retries 18
> > >
> > > The another wait statistics where either 0 or pretty close to 0.
> > >
> > > With this value, I check the Performance manual, PDF version and in
> > chapter
> > > 19 page 7 makes reference to this statistic. I incremented the value
> and
> > > nothing happened, initially was 50 MB, for that reason I stopped and
ask
> > for
> > > help.
> > >
> > > HTH
> > >
> > > Ramon
> > >
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Wednesday, June 19, 2002 1:53 PM
> > >
> > >
> > > > Hi,
> > > >
> > > > I get easily confused, but you mention that 3 statistics are
> extremely
> > > "high". Oracle
> > > > has 200+ statistics, so the others are ok ?
> > > > Why do you focus on these 3 ? You even fail to mention what you are
> > doing
> > > in these
> > > > tests, so how can we tell you what to do ?
> > > >
> > > > Identify the symptoms (these processes need to run 3 times faster,
for
> > > example)
> > > > Investigate the symptoms
> > > > Formulate the root cause
> > > > fix the the root cause
> > > >
> > > > I think that you are skipping a couple of stages in the problem
> solving
> > > process,
> > > >
> > > > Anjo.
> > > >
> > > >
> > > > com.banilejas_at_codetel.net.do wrote:
> > > >
> > > > > Hi list,
> > > > >
> > > > > Scenario Sun 880 Solaris 8, Oracle 8.1.7.3, 8GB Ram, 4 processors
> > > > >
> > > > > Redo logs 200MB size 4 groups in 1 disk
> > > > > DBWriter = 2
> > > > > log buffer 200 BM
> > > > > Shared Pool 1 GB
> > > > > db block buffers 100,000
> > > > > db block size 8K
> > > > >
> > > > > I started a process and checked the V$sysstat and get those values
> are
> > > extremely high
> > > > >
> > > > > free buffer requested 28938, enqueue requests 25035, redo writer
> > > latching time 0
> > > > >
> > > > > Data 1 volume stripe of 2 disk
> > > > > Index 1 volume stripe of 2 disk -- differents
> > > > > RBS 1 disk apart
> > > > > Temp 1 disk apart
> > > > >
> > > > > What parameter should I check ?
> > > > >
> > > > > TIA
> > > > >
> > > > > Ramon E. Estevez
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > > --
> > > > > Author:
> > > > > INET: com.banilejas_at_codetel.net.do
> > > > >
> > > > > Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> > > > > San Diego, California -- Public Internet access / Mailing
> Lists
> > > >
> --------------------------------------------------------------------
> > > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
in
> > > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > > (or the name of mailing list you want to be removed from). You
may
> > > > > also send the HELP command for other information (like
subscribing).
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Anjo Kolk
> > > > INET: anjo_at_oraperf.com
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > > San Diego, California -- Public Internet access / Mailing
Lists
> > > > --------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from). You may
> > > > also send the HELP command for other information (like subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Ramon E. Estevez
> > > INET: com.banilejas_at_codetel.net.do
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Igor Neyman
> > INET: ineyman_at_perceptron.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: com.banilejas_at_codetel.net.do
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.COM
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ramon E. Estevez
> INET: com.banilejas_at_codetel.net.do
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: alexandre.gorbatchev_at_avermann.de Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |