Dennis,
1000% Agree with you, that's my point. tks ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 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. > [EMAIL PROTECTED] > > > -----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" <[EMAIL PROTECTED]> > 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. > > [EMAIL PROTECTED] > > > > > > -----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: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> on behalf of "Igor > > Neyman" <[EMAIL PROTECTED]> > > Sent: Wednesday, June 19, 2002 5:30 PM > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > 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 > > [EMAIL PROTECTED] > > > > > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > 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" <[EMAIL PROTECTED]> > > > 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. > > > > > > > > > > > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
