Re: Free buffer requested

Dennis,

1000% Agree with you, that's my point.

tks

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, June 20, 2002 10:48 AM

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

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