RE: Free buffer requested

Ramon

        Thanks for the clarification. When you say that performance should be better according to the computer configuration, are you looking at the maximum throughput specification for the disk/disk controller? I continually have this argument with the hardware people. My statistics show that the system is disk bound, and they say that I am way below the rated maximum specs. I reply that the maximum rated throughput only applies to a bulk process like a file copy and for a normal OLTP database, disk latency and disk buffer are more important. I don't know if that is your issue, but I just thought I'd mention it.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, June 20, 2002 9:58 AM
To: Multiple recipients of list ORACLE-L

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: 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).