RE: Performance tuning in complex environment
Avnish, The book goes through this a bit on p61. There are a few tools out there, including three from Oracle. As I mention in the book, I use our own Hotsos Profiler, described at www.hotsos.com/products/profiler.html. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:44 PM To: Multiple recipients of list ORACLE-L I will try to get the output of v$system_event and will send it you guys. In the mean time I have more question.. I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and over looked rest of the chapters but didnt find an easy way to analyze thousands of lines trace file. I am not very good in analyzing big trace files and wondering how you guys analyze do that. Do you do it manually or use any tool to get summarized report. I didnt see anything in that book. I am also planning to take class from HotSos in Feb, 2004 in Seattle to see if that will help. I really appreciate all of your input. Thanks -Original Message- Jared Still Sent: Thursday, December 11, 2003 10:04 PM To: Multiple recipients of list ORACLE-L The wholesale system wide collection of timing data is not generally a good way to go about trouble shooting performance issues. You need to pick a process, collect the timing data for that process, and *only* that process, diagnose where the most time is being spent, and determine what can be done to speed it up. This in a nutshell is the basis of Cary's book, at least per my reading of it. Always try to fix the stuff with the biggest payoff. It could be a SQL statement, it could be a misconfigured or malfunctioning network card. It could be that a developer is filling a temporary table with lots of data during a transaction, then deleting the data and doing it over and over again, all the while doing full table scans. FTS is expensive when you want to retrieve 3 rows from a temp table with 500 meg of extents in it. Just for grins though, how about running this script and posting the output for us? Sometimes you get lucky, and something may appear really out of whack. No guarantees though. Troubleshooting system performance problems takes more than an email. HTH Jared = col event format a35 head 'EVENT NAME' col total_waits format 999,999,999 head TOTAL|WAITS col total_timeouts format 999,999,999 head TOTAL|TIMEOUTS col time_waited format 999,999,999 head TIME|WAITED|SECONDS col average_wait format 9 head AVG|WAIT|100ths set line 150 set trimspool on select event, total_waits, total_timeouts, time_waited/100 time_waited, average_wait from v$system_event order by time_waited / On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote: Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Re: Performance tuning in complex environment
All, This sounds wy too familiar to me. My (blind) guess is that sql*net round trips is killing performance. System-wide could indicate this, but, as Jared states, trace out a specific session, and grab the session-specific info from v$sesstat, before and after. We brute forced the issue of sqlnet round tripsin the past by having the site upgrade the Citrix Servers from fast ethernet to gigabit network cards. Most new servers these days in the intel space ship with 2 integrated gigabit NICs, is just a matter of having GigE switched ports available. If you're moving too much data between client and server, increasing the SDU could help, but your mileage will vary. PdJared Still [EMAIL PROTECTED] wrote: The wholesale system wide collection of timing data is not generallya good way to go about trouble shooting performance issues.You need to pick a process, collect the timing data for that process,and *only* that process, diagnose where the most time is being spent,and determine what can be done to speed it up.This in a nutshell is the basis of Cary's book, at least per my reading of it.Always try to fix the stuff with the biggest payoff.It could be a SQL statement, it could be a misconfigured ormalfunctioning network card. It could be that a developer is filling a temporary table with lots of data during a transaction,then deleting the data and doing it over and over again, all thewhile doing full table scans. FTS is expensive when you want to retrieve 3 rows from a temp table with 500 meg of extents in it.Just for grins though, how about running this script and postingthe output for us? Sometimes you get lucky, and something mayappear really out of whack. No guarantees though. Troubleshootingsystem performance problems takes more than an email.HTHJared=col event format a35 head 'EVENT NAME'col total_waits format 999,999,999 head "TOTAL|WAITS"col total_timeouts format 999,999,999 head "TOTAL|TIMEOUTS"col time_waited format 999,999,999 head "TIME|WAITED|SECONDS"col average_wait format 9 head "AVG|WAIT|100ths"set line 150set trimspool onselectevent,total_waits,total_timeouts,time_waited/100 time_waited,average_waitfrom v$system_eventorder by time_waited/On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote: Hello Everyon! e, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator.DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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 l! ine 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.net-- Author: Jared StillINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? Free Pop-Up Blocker - Get
RE: Performance tuning in complex environment
I will try to get the output of v$system_event and will send it you guys. In the mean time I have more question.. I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and over looked rest of the chapters but didnt find an easy way to analyze thousands of lines trace file. I am not very good in analyzing big trace files and wondering how you guys analyze do that. Do you do it manually or use any tool to get summarized report. I didnt see anything in that book. I am also planning to take class from HotSos in Feb, 2004 in Seattle to see if that will help. I really appreciate all of your input. Thanks -Original Message- Jared Still Sent: Thursday, December 11, 2003 10:04 PM To: Multiple recipients of list ORACLE-L The wholesale system wide collection of timing data is not generally a good way to go about trouble shooting performance issues. You need to pick a process, collect the timing data for that process, and *only* that process, diagnose where the most time is being spent, and determine what can be done to speed it up. This in a nutshell is the basis of Cary's book, at least per my reading of it. Always try to fix the stuff with the biggest payoff. It could be a SQL statement, it could be a misconfigured or malfunctioning network card. It could be that a developer is filling a temporary table with lots of data during a transaction, then deleting the data and doing it over and over again, all the while doing full table scans. FTS is expensive when you want to retrieve 3 rows from a temp table with 500 meg of extents in it. Just for grins though, how about running this script and posting the output for us? Sometimes you get lucky, and something may appear really out of whack. No guarantees though. Troubleshooting system performance problems takes more than an email. HTH Jared = col event format a35 head 'EVENT NAME' col total_waits format 999,999,999 head TOTAL|WAITS col total_timeouts format 999,999,999 head TOTAL|TIMEOUTS col time_waited format 999,999,999 head TIME|WAITED|SECONDS col average_wait format 9 head AVG|WAIT|100ths set line 150 set trimspool on select event, total_waits, total_timeouts, time_waited/100 time_waited, average_wait from v$system_event order by time_waited / On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote: Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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,
RE: Performance tuning in complex environment
On Fri, 12 Dec 2003 [EMAIL PROTECTED] wrote: I will try to get the output of v$system_event and will send it you guys. In the mean time I have more question.. I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and over looked rest of the chapters but didnt find an easy way to analyze thousands of lines trace file. I am not very good in analyzing big trace files and wondering how you guys analyze do that. Do you do it manually or use any tool to get summarized report. I didnt see anything in that book. I am also planning to take class from HotSos in Feb, 2004 in Seattle to see if that will help. I really appreciate all of your input. I brewed up my own (still semi-baked) profiler in Perl. The tricky part is sorting out the recursive dependencies between db calls, but the rest is pretty straightforward, and Perl makes chewing up the trace file a snap. Currently it works 'well enough' for basic traces (w/o a lot of recursive calls) to give me a decent picture of what a session is doing. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Performance tuning in complex environment
Ummm ... what was the problem that prompted you guys to replace citrix servers? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Re: Performance tuning in complex environment
DBAs should never 'guess' about performance. If they are guessing you need new DBAs. They should be running statspacks, sql trace, and looking at timing data. Its too much to explain in an email. Fire your DBAs and find people who dont 'guess'. How much are you paying these guys? From: [EMAIL PROTECTED] Date: 2003/12/11 Thu PM 01:34:52 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Performance tuning in complex environment Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Performance tuning in complex environment
Not really sure what happened and why we decided to that. I was involved in the beginning of project and remembered that PM was mentioning about talking to another Logician client who were facing same issues. -Original Message- Jamadagni, Rajendra Sent: Thursday, December 11, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Ummm ... what was the problem that prompted you guys to replace citrix servers? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
RE: Performance tuning in complex environment
Thanks I asked because we also use Citrix and so far we never had a problem related to Citrix, only problems we had were inefficient coding and oracle bugs, nothing related to HW/disk/WTS etc. The only problem initially with Citrix was configuring client printers, but our guys figured it out as well. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Not really sure what happened and why we decided to that. I was involved in the beginning of project and remembered that PM was mentioning about talking to another Logician client who were facing same issues. ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Performance tuning in complex environment
Oh I've run into THIS beforeyou are in a sticky technical AND political situation I am sure. It is really not that complex. I'll bet they (your DBAs) have already been told you that the app is horribly designed and it was a mistake and that the hardware is under powered canned dataserver install was poorly laid out. The vendor says everything is fine and are basically silent but willing to send in expensive consultants. You don't trust you DBA's. They are pissed at you and the vendor. (imagine that) Now you are stuck with hearing exactly what you didn't want to hear. The DBA's (If they are Oracle DBA's) have done everything they can and now you are on a fishing expedition because you don't trust your DBAs...you probably have been glazing over when ever you hear them talk about issues with this system...because of that they have washed their hands of it. They can't help you if you don't all sit down and listen and respect each other. I'll put got $20 bucks that if I came in and sat down with them for ten minutes I'd find out they were sharp competent people who have been given the crap because of this lousy application. So why don't you send your DBAs in here and let them tell the folks on this board what they have done thus far and maybe there will be some good come out if it. Also expect that apps purchased two years ago are going to royally suck for the most part as the software industry was a giant scam at that time. Frankly if you have multiple users on citrix attaching to oracle expect poor performance. Think about it. A Citrix server with dozens of users using the same resources to display an entire desktop across the networkHave you determined if it is app performance or oracle? What this tells me is this is a client server app licensed to sacrifice cost versus performance. You bought the Citrix version to save money no doubt. Now you are stuck. Either way you have fell for the sell them the sizzle give them the bacon later software bait and switch. Do queries typically run faster on a stand alone install of the client than the Citrix? Do the queries run by the app run the same or faster when executed through say sqlplus... How far flung is this Citrix app do you have remote users? In remote offices? What kind of bandwidth do you have? How much data is pumped between the database and the client in a typical connection? Sorry if a came off a bit frank, but If I were you I would go back and listen to your DBA's again. This time more closely because I am sure you left a lot of other information out. Stop listening to the Citrix and Logician marketing hype and listen to your people. Software vendors could care less how well your app runs as long as they get their stinking money. They are in the business first to SELL SOFTWARE, always remember that. You have to get everybody working together, accept the situation, set some new expectations and hold the vendor partially accountable if you are going to move forward on this problem. If you indeed can say: When I push this button it take ten minutes to get the data and the same query takes just as long from sqlplus then you POSSIBLY have a database issue, a program design issue or both. Good luck. Brad Odland -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Performance tuning in complex environment
OK. Before we go blaming Oracle DB, you need to look at the entire picture. 1. Are other applications within the environment affected by slow performance? 2. What other apps are running on the network? 3. Have any network-related diagnostics been performed to ensure that Network bottlenecks are not causing the issue. 4. What is your disk configuration look like? Mirroring/Striping, etc. 5. How large/small are the transactions? Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Subject:RE: Performance tuning in complex environment Not really sure what happened and why we decided to that. I was involved in the beginning of project and remembered that PM was mentioning about talking to another Logician client who were facing same issues. -Original Message- Jamadagni, Rajendra Sent: Thursday, December 11, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Ummm ... what was the problem that prompted you guys to replace citrix servers? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information
RE: Performance tuning in complex environment
Avnish - Since nobody has mentioned it yet (my posts arrive late, so probably will by the time this appears), get Cary Millsap's book Optimizing Oracle Performance http://search.barnesandnoble.com/textbooks/booksearch/isbnInquiry.asp?userid =6WIANMIL0Hisbn=059600527XTXT=Yitm=1 His methods sound exactly suited to your issues. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Performance tuning in complex environment
Reminds me of the day when a third-party developed app (main batch program) ran *very* slowly - the user department went out and bought this app and server on their own without IT's blessing or support (a different story). Dialogue below: Third-party Developer (TPD): This same batch program which runs 1hr 30 min on your box completes under 30 min at our Office with *your* data. We suggest obtaining an IBM S80 because it is 3 times faster than your current box (IBM On-site person: Yes! Yes!!!) User Department Manager (UDM): Ok - we have a $100,000 budget for this - lets go out and buy this h/w (We need to go through IT for this purchase) My Manager, when approached with this issue (MM): I know your TPD has this view, but can my Sr. DBA look at this problem? UDM: Ok, but I doubt anything can be done since my TPD says so... TPD: Hey, your DBA can't mess with our code! Sr.DBA (Me!): Ok - let's take a look at V$SYSTEM_EVENT, V$SESSION_EVENT and V$SESSION_WAIT when your program runs... Me: Hey - what's this session doing with 'SQL*Net Message from dblink'? This is the top wait (more than 99% of TIME_WAITED in V$SESSION_EVENT) TPD: Yeah - we have a view that makes a call to your employee table sitting on your prod box to fetch the Emp name, once for every row in the loop (1000s of rows, 3300 rows a pop) Me: Haven't you guys heard of Replicated Tables? TPD: What's that? Me: (after creating a local copy and replacing the view with an indexed table) Run your program now... TPD: Hey - it finished in 5 minutes!!! We don't need to buy any other box! UDM: I like that!!! Thanks!! MM: Well done - I knew my DBA could do it! (IBM On-site person: [EMAIL PROTECTED]@#*()+__@) Me: (Hitting myself on the head, and thinking to myself: I should have asked for just 1% of the $$ that would have otherwise been unnecessarily spent on that great big H/w box :( Moral of the story: (a) Never ass*u*me anything - ask for stats to prove any 'assumption' (b) Get the right tools to determine the problem area (and use it correctly) Afterthought (c) - Follow Gary Goodman's principle: Ask for 10% of the $$ allocated for the h/w that would have otherwise been spent on *trying* to solve the problem by throwing h/w at it! (Cary - correct me if I erred here!) John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Performance tuning in complex environment Not really sure what happened and why we decided to that. I was involved in the beginning of project and remembered that PM was mentioning about talking to another Logician client who were facing same issues. -Original Message- Jamadagni, Rajendra Sent: Thursday, December 11, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Ummm ... what was the problem that prompted you guys to replace citrix servers? Raj --- - Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email
Re: Performance tuning in complex environment
The wholesale system wide collection of timing data is not generally a good way to go about trouble shooting performance issues. You need to pick a process, collect the timing data for that process, and *only* that process, diagnose where the most time is being spent, and determine what can be done to speed it up. This in a nutshell is the basis of Cary's book, at least per my reading of it. Always try to fix the stuff with the biggest payoff. It could be a SQL statement, it could be a misconfigured or malfunctioning network card. It could be that a developer is filling a temporary table with lots of data during a transaction, then deleting the data and doing it over and over again, all the while doing full table scans. FTS is expensive when you want to retrieve 3 rows from a temp table with 500 meg of extents in it. Just for grins though, how about running this script and posting the output for us? Sometimes you get lucky, and something may appear really out of whack. No guarantees though. Troubleshooting system performance problems takes more than an email. HTH Jared = col event format a35 head 'EVENT NAME' col total_waits format 999,999,999 head TOTAL|WAITS col total_timeouts format 999,999,999 head TOTAL|TIMEOUTS col time_waited format 999,999,999 head TIME|WAITED|SECONDS col average_wait format 9 head AVG|WAIT|100ths set line 150 set trimspool on select event, total_waits, total_timeouts, time_waited/100 time_waited, average_wait from v$system_event order by time_waited / On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote: Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Performance tuning book
Cary, I detoured from the new Tom Kytebook after chapter 4 to read your test through. chapter 6 of the tom kyte book might have been a better band aid for me at the moment, but - I finally (4 weeks after the issue was raised) got a user to let me know when he was going to run a posting routine. finding someone that would allow me to trace their session, when the client site is1500 miles away, is the tough part. 40 MB trace file later ...lets say that it will be a huge undertaking to close the loop on that one. can you imagine 10E6 sqlnet roundtrips for a single user in a business day? The best thing about 10046 trace is, the trace file don't lie and the developer cannot deny. The worst thing is trying to get any changes actually made in the app code. having an engineering math background with courses in linear algebra, optimizations research - the thing that I picked up the most about your chapter on queueing theory (on the first read, standing between NWK and NYP on NJT) is ... sensitivity analysis. It helps if you can think of (mean) response time as an objective function and can view the topology of that surface in a multidimensional space. If you can avoid the steep peaks, the highly non-linear sections, the response times will stay predictable. an economist or business type that never integrated anyting in the calculus sense would just say "law of diminishing returns" and wouldn't be far off. but the term "marginal" really has no relevance without a derivative. In chemical engineering distillation, one attempts to avoid a "pinch point" (read: more trays or CPUs won't help) and must avoid an azeotrope (read: no amount of hardware can get you across - can't getmore pure than95% C2H5OH / 5% H20 - aka grain alcohol). the part that hit me hardest, was that bymanaging the service level agreement and the business requirement, by getting that mean response time up to3.5 seconds instead of 3, by allowing 95% of the queries to complete instead of 99% in the tolerance interval - that a single cpu system could handle the load, where an 8 cpu system might not have. (numbers fudged, my copy of your book is in the office) maybe grid computing will push the knee out a little further. knowing where the second derivative (of response time asa function of load)is increasing dramatically would indeed be the most useful info - but how to get load vs response data of high enough quality to provide decent enough resolution to afford such info seems completely out of reach to me. (mathcad and polynomial splines bridged the gap for me back in 95). that sharp part of the curve past the knee can be so steep, so highly sensitive to additional load - that having such info nearly real-time to curtail additional (incoming) load would be a very powerful selling point. some stop lights on the on-ramps could really help. I hope that the math doesn't scare people off, if you made it through sophmore year of engineering or comp-sci, it should just require scraping the rust off ... but that is only the queueing theory section. The theory does provide extremely interesting results in terms of constraining an optimality condition. If one can eliminate all that is not possible (e.g. square roots of negative numbers) and can estimate what is theoretically possible, one can determine what a reasonable solution would be much more quickly and confidently. I'm sure that the discussion could have been much more in depth, more theoretical. Heck, you didn't even break out the semi-log or log-log plots! I am planning on following through on some of the recommended texts. atits price point, there is no excuse for picking it up - and thrusting it at others to read as soon as you're done with it. thanks for the book. Paul DrakeCary Millsap [EMAIL PROTECTED] wrote: Ryan,Your two questions have different answers.I studied mathematics as an undergrad. I focused on the abstract stuff:predicate calculus, language theory, functional analysis, topology, In my studies I constructed many, Many, MANY proofs. (A "proof" inmathematics is a piece of technical documentation in which loopholes areimpermissible.) I never heard of queueing theory until I had to figureout how to predict performance at an Oracle project I was leading in1994.It might be a fun indulgence to say that to be a good Oracle performanceanalyst, you have to model yourself after me, but it's just not true.The honest answer is that many of the best performance analysts I'veever met have backgrounds that are all over the map: History, Theology,Economics, Geology, Music, Some of the great ones do have aMathe! matics background (Jonathan Lewis, for example), but accusationsthat you must have a CS, EE, or Math degree to be a performance analyst(or to understand "Optimizing Oracle Performance") are patently absurd.I've written about what I think are the most important traits for theperformance analyst in Chapter 1 of the book. This chapter is the onethat's available for free
RE: Performance tuning book
Sorry to double post. It didn't show up on the board and after about an hour I thought there was a problem. Of course as soon as I posted again, they both showed up! I'll be more patient next time. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Performance tuning book
Michael, I've responded by preceding your questions with MM: and my answers with CVM:. MM: ...can you please tell me if your new book, of which I've heard good things, is different in any way than other Oracle Performance Tuning books out. Does it take a different approach? CVM: Drastically different. Probably the most important difference is that it's the first Oracle book that doesn't espouse a method that consists of just trying things until you find something that helps. It prescribes a step-by-step process, which is the same every time, for diagnosing your performance problem. The method works for finding performance problem causes whatever in the technology stack they may be. I didn't do it this way for the sake of being different. I did it this way because the traditional ways of tuning don't work. I think some other things like the queueing chapter make it different, too, but I feel that there's been too much focus placed upon the apparently deep mathematical nature of this chapter. The point of the chapter is to show people how to use a model (one that's already completely worked out for you) to gain insight into your real Oracle performance problems. At the end of the chapter is a 14-page, fully worked example. No other book does this. There are a lot of formulas in this chapter, but I show them only to help people recreate (or test) my results. For every formula, there is an Excel spreadsheet function that automates the use of that formula (some of the Excel formulas took years to develop, by the way). The chapter is all about showing the reader why performance behaves in the surprising ways that it sometimes does. It's not about showing you how cool math can be. MM: Does it teach different methodologies? CVM: It teaches a single method that is radically different from the ones most Oracle professionals are taught. You can get a drift of what I mean by reading the sample chapter at http://www.oreilly.com/catalog/optoraclep/index.html. (By the way, I distinguish carefully between the words method and methodology. I have a note about this in the book's Glossary, and at http://www.hotsos.com/e-library/oop.html as well.) MM: Is it more readable? I'd be very interested in your own assessment. CVM: There are three parts to the book, and the readability varies by design across those three parts. Parts I and III are meant to be read front-to-back by DBAs and analysts, and also their managers. Part II is reference material that I hope technical people are reading, but Part II is definitely too much to swallow in a few sittings. There's just too much detail. You can see more information about the structure of the book at http://www.hotsos.com/e-library/oop.html. There are some tricky concepts you have to understand before you can optimize an Oracle database, so it can be difficult to write about these concepts in a manner that people can understand. I find virtually nothing more offensive in technical literature than the author who tells you that something is so complicated that you would never understand it, even if he bothered to explain it to you. I think it should be the reader's right to see the facts and decide whether to skip them or dive into them. I think that most authors who try to complicate things are really just afraid to admit publicly that they don't know something. It's fine not to know some things. We all don't know a lot of things! But it's not helpful when an author's ultimate goal is to look authoritative instead of trying to help the reader understand what we know and what needs further study. I know I've scared a lot of people with all the arithmetic in the queueing chapter, but here I've been especially careful to explain how to use what our good mathematical forefathers have worked out for us. You can read the entire chapter without having to know what any of the formulas mean. I've focused on what the models *mean* and how to use them, not on why they work. So, how readable is it? There's a lot of stuff out there that I hope we're much, much better than. But it would be difficult to be more readable than, for example, Ensor, Kyte, Lewis, Morle, Vaidyanatha/Deshpande, or Lawson, who, in my opinion, write beautifully. So far, much of the feedback I've received is that the book is fun to read, which was definitely a principal design goal of the project. MM: What did you try to accomplish with this book? CVM: I covered much of this in the preface. Our whole company was borne of deep frustration with some of the very popular tips techniques work out there that I consider to be absolute garbage. One of the principal motives of the book was to create a better classroom experience for our students (see http://www.hotsos.com/courses/PD101.php, for example). With the book, Jeff and I have tried to lay out a system that enables a reader to determine whether the performance information he's getting at conferences, classes, books, magazines, etc. is valid or not. We have
Re: RE: Performance tuning book
there is a queuing theory article on hotsos. you have to be a member to read it... does it have more detail than what is in your book? unfortunately i havent had a chance to read it yet. Ill get to it. Everyone I know who has read it, really liked it. From: Cary Millsap [EMAIL PROTECTED] Date: 2003/10/21 Tue PM 03:49:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Performance tuning book Michael, I've responded by preceding your questions with MM: and my answers with CVM:. MM: ...can you please tell me if your new book, of which I've heard good things, is different in any way than other Oracle Performance Tuning books out. Does it take a different approach? CVM: Drastically different. Probably the most important difference is that it's the first Oracle book that doesn't espouse a method that consists of just trying things until you find something that helps. It prescribes a step-by-step process, which is the same every time, for diagnosing your performance problem. The method works for finding performance problem causes whatever in the technology stack they may be. I didn't do it this way for the sake of being different. I did it this way because the traditional ways of tuning don't work. I think some other things like the queueing chapter make it different, too, but I feel that there's been too much focus placed upon the apparently deep mathematical nature of this chapter. The point of the chapter is to show people how to use a model (one that's already completely worked out for you) to gain insight into your real Oracle performance problems. At the end of the chapter is a 14-page, fully worked example. No other book does this. There are a lot of formulas in this chapter, but I show them only to help people recreate (or test) my results. For every formula, there is an Excel spreadsheet function that automates the use of that formula (some of the Excel formulas took years to develop, by the way). The chapter is all about showing the reader why performance behaves in the surprising ways that it sometimes does. It's not about showing you how cool math can be. MM: Does it teach different methodologies? CVM: It teaches a single method that is radically different from the ones most Oracle professionals are taught. You can get a drift of what I mean by reading the sample chapter at http://www.oreilly.com/catalog/optoraclep/index.html. (By the way, I distinguish carefully between the words method and methodology. I have a note about this in the book's Glossary, and at http://www.hotsos.com/e-library/oop.html as well.) MM: Is it more readable? I'd be very interested in your own assessment. CVM: There are three parts to the book, and the readability varies by design across those three parts. Parts I and III are meant to be read front-to-back by DBAs and analysts, and also their managers. Part II is reference material that I hope technical people are reading, but Part II is definitely too much to swallow in a few sittings. There's just too much detail. You can see more information about the structure of the book at http://www.hotsos.com/e-library/oop.html. There are some tricky concepts you have to understand before you can optimize an Oracle database, so it can be difficult to write about these concepts in a manner that people can understand. I find virtually nothing more offensive in technical literature than the author who tells you that something is so complicated that you would never understand it, even if he bothered to explain it to you. I think it should be the reader's right to see the facts and decide whether to skip them or dive into them. I think that most authors who try to complicate things are really just afraid to admit publicly that they don't know something. It's fine not to know some things. We all don't know a lot of things! But it's not helpful when an author's ultimate goal is to look authoritative instead of trying to help the reader understand what we know and what needs further study. I know I've scared a lot of people with all the arithmetic in the queueing chapter, but here I've been especially careful to explain how to use what our good mathematical forefathers have worked out for us. You can read the entire chapter without having to know what any of the formulas mean. I've focused on what the models *mean* and how to use them, not on why they work. So, how readable is it? There's a lot of stuff out there that I hope we're much, much better than. But it would be difficult to be more readable than, for example, Ensor, Kyte, Lewis, Morle, Vaidyanatha/Deshpande, or Lawson, who, in my opinion, write beautifully. So far, much of the feedback I've received is that the book is fun to read, which was definitely a principal design goal of the project. MM: What did you try to accomplish with this book? CVM: I covered much of this in the preface. Our
RE: RE: Performance tuning book
No, the most complete and detailed queueing theory thing I've ever done is Chapter 9 of the book. You might be thinking of Batch Queue Management and the Magic of '2', which is a completely different thing. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 3:05 PM To: Multiple recipients of list ORACLE-L there is a queuing theory article on hotsos. you have to be a member to read it... does it have more detail than what is in your book? unfortunately i havent had a chance to read it yet. Ill get to it. Everyone I know who has read it, really liked it. From: Cary Millsap [EMAIL PROTECTED] Date: 2003/10/21 Tue PM 03:49:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Performance tuning book Michael, I've responded by preceding your questions with MM: and my answers with CVM:. MM: ...can you please tell me if your new book, of which I've heard good things, is different in any way than other Oracle Performance Tuning books out. Does it take a different approach? CVM: Drastically different. Probably the most important difference is that it's the first Oracle book that doesn't espouse a method that consists of just trying things until you find something that helps. It prescribes a step-by-step process, which is the same every time, for diagnosing your performance problem. The method works for finding performance problem causes whatever in the technology stack they may be. I didn't do it this way for the sake of being different. I did it this way because the traditional ways of tuning don't work. I think some other things like the queueing chapter make it different, too, but I feel that there's been too much focus placed upon the apparently deep mathematical nature of this chapter. The point of the chapter is to show people how to use a model (one that's already completely worked out for you) to gain insight into your real Oracle performance problems. At the end of the chapter is a 14-page, fully worked example. No other book does this. There are a lot of formulas in this chapter, but I show them only to help people recreate (or test) my results. For every formula, there is an Excel spreadsheet function that automates the use of that formula (some of the Excel formulas took years to develop, by the way). The chapter is all about showing the reader why performance behaves in the surprising ways that it sometimes does. It's not about showing you how cool math can be. MM: Does it teach different methodologies? CVM: It teaches a single method that is radically different from the ones most Oracle professionals are taught. You can get a drift of what I mean by reading the sample chapter at http://www.oreilly.com/catalog/optoraclep/index.html. (By the way, I distinguish carefully between the words method and methodology. I have a note about this in the book's Glossary, and at http://www.hotsos.com/e-library/oop.html as well.) MM: Is it more readable? I'd be very interested in your own assessment. CVM: There are three parts to the book, and the readability varies by design across those three parts. Parts I and III are meant to be read front-to-back by DBAs and analysts, and also their managers. Part II is reference material that I hope technical people are reading, but Part II is definitely too much to swallow in a few sittings. There's just too much detail. You can see more information about the structure of the book at http://www.hotsos.com/e-library/oop.html. There are some tricky concepts you have to understand before you can optimize an Oracle database, so it can be difficult to write about these concepts in a manner that people can understand. I find virtually nothing more offensive in technical literature than the author who tells you that something is so complicated that you would never understand it, even if he bothered to explain it to you. I think it should be the reader's right to see the facts and decide whether to skip them or dive into them. I think that most authors who try to complicate things are really just afraid to admit publicly that they don't know something. It's fine not to know some things. We all don't know a lot of things! But it's not helpful when an author's ultimate goal is to look authoritative instead of trying to help the reader understand what we know and what needs further study. I know I've scared a lot of people with all the arithmetic in the queueing chapter, but here I've been especially careful to explain how to use what our good mathematical forefathers have worked out for us. You can read the entire chapter without having to know what any of the formulas mean
RE: Performance tuning book
Sorry to double post. It didn't show up on the board and after about an hour I thought there was a problem. Of course as soon as I posted again, they both showed up! I'll be more patient next time. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Performance tuning book
Cary, Thank you for your in-depth response. It was very helpful. To me, the hardest books to read and understand are those that tell you WHAT but not WHY. From the excellent reviews I've received (look at MLaden's review just posted), it appears to give plenty of WHY. I appreciate that very much. I'll be buying it tonight. Thanks again, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Re: Performance tuning book
here is a list of tuning books to read. I used to work with the guy who wrote it. He definitely knows what he is doing. There are quite a few people on this list who can attest to that. http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1/re f=cm_lm_dp_l_2/102-3468524-1000163 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 6:24 PM Cary, Thank you for your in-depth response. It was very helpful. To me, the hardest books to read and understand are those that tell you WHAT but not WHY. From the excellent reviews I've received (look at MLaden's review just posted), it appears to give plenty of WHY. I appreciate that very much. I'll be buying it tonight. Thanks again, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Re: Performance tuning book
what is your math background? what level of math would you recommend performance specialists to have? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 3:49 PM Michael, I've responded by preceding your questions with MM: and my answers with CVM:. MM: ...can you please tell me if your new book, of which I've heard good things, is different in any way than other Oracle Performance Tuning books out. Does it take a different approach? CVM: Drastically different. Probably the most important difference is that it's the first Oracle book that doesn't espouse a method that consists of just trying things until you find something that helps. It prescribes a step-by-step process, which is the same every time, for diagnosing your performance problem. The method works for finding performance problem causes whatever in the technology stack they may be. I didn't do it this way for the sake of being different. I did it this way because the traditional ways of tuning don't work. I think some other things like the queueing chapter make it different, too, but I feel that there's been too much focus placed upon the apparently deep mathematical nature of this chapter. The point of the chapter is to show people how to use a model (one that's already completely worked out for you) to gain insight into your real Oracle performance problems. At the end of the chapter is a 14-page, fully worked example. No other book does this. There are a lot of formulas in this chapter, but I show them only to help people recreate (or test) my results. For every formula, there is an Excel spreadsheet function that automates the use of that formula (some of the Excel formulas took years to develop, by the way). The chapter is all about showing the reader why performance behaves in the surprising ways that it sometimes does. It's not about showing you how cool math can be. MM: Does it teach different methodologies? CVM: It teaches a single method that is radically different from the ones most Oracle professionals are taught. You can get a drift of what I mean by reading the sample chapter at http://www.oreilly.com/catalog/optoraclep/index.html. (By the way, I distinguish carefully between the words method and methodology. I have a note about this in the book's Glossary, and at http://www.hotsos.com/e-library/oop.html as well.) MM: Is it more readable? I'd be very interested in your own assessment. CVM: There are three parts to the book, and the readability varies by design across those three parts. Parts I and III are meant to be read front-to-back by DBAs and analysts, and also their managers. Part II is reference material that I hope technical people are reading, but Part II is definitely too much to swallow in a few sittings. There's just too much detail. You can see more information about the structure of the book at http://www.hotsos.com/e-library/oop.html. There are some tricky concepts you have to understand before you can optimize an Oracle database, so it can be difficult to write about these concepts in a manner that people can understand. I find virtually nothing more offensive in technical literature than the author who tells you that something is so complicated that you would never understand it, even if he bothered to explain it to you. I think it should be the reader's right to see the facts and decide whether to skip them or dive into them. I think that most authors who try to complicate things are really just afraid to admit publicly that they don't know something. It's fine not to know some things. We all don't know a lot of things! But it's not helpful when an author's ultimate goal is to look authoritative instead of trying to help the reader understand what we know and what needs further study. I know I've scared a lot of people with all the arithmetic in the queueing chapter, but here I've been especially careful to explain how to use what our good mathematical forefathers have worked out for us. You can read the entire chapter without having to know what any of the formulas mean. I've focused on what the models *mean* and how to use them, not on why they work. So, how readable is it? There's a lot of stuff out there that I hope we're much, much better than. But it would be difficult to be more readable than, for example, Ensor, Kyte, Lewis, Morle, Vaidyanatha/Deshpande, or Lawson, who, in my opinion, write beautifully. So far, much of the feedback I've received is that the book is fun to read, which was definitely a principal design goal of the project. MM: What did you try to accomplish with this book? CVM: I covered much of this in the preface. Our whole company was borne of deep frustration with some of the very popular tips techniques work out there that I consider to be absolute garbage. One of the principal motives of the book was to create a better classroom
RE: Performance tuning book
Ryan, Your two questions have different answers. I studied mathematics as an undergrad. I focused on the abstract stuff: predicate calculus, language theory, functional analysis, topology, In my studies I constructed many, Many, MANY proofs. (A proof in mathematics is a piece of technical documentation in which loopholes are impermissible.) I never heard of queueing theory until I had to figure out how to predict performance at an Oracle project I was leading in 1994. It might be a fun indulgence to say that to be a good Oracle performance analyst, you have to model yourself after me, but it's just not true. The honest answer is that many of the best performance analysts I've ever met have backgrounds that are all over the map: History, Theology, Economics, Geology, Music, Some of the great ones do have a Mathematics background (Jonathan Lewis, for example), but accusations that you must have a CS, EE, or Math degree to be a performance analyst (or to understand Optimizing Oracle Performance) are patently absurd. I've written about what I think are the most important traits for the performance analyst in Chapter 1 of the book. This chapter is the one that's available for free at www.oreilly.com. I think relevance, common sense, self-confidence, and the ability to communicate effectively are much more important (and actually more difficult to learn) than a lot of the more obvious educational factors. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Ryan Sent: Tuesday, October 21, 2003 7:04 PM To: Multiple recipients of list ORACLE-L what is your math background? what level of math would you recommend performance specialists to have? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 3:49 PM Michael, I've responded by preceding your questions with MM: and my answers with CVM:. MM: ...can you please tell me if your new book, of which I've heard good things, is different in any way than other Oracle Performance Tuning books out. Does it take a different approach? CVM: Drastically different. Probably the most important difference is that it's the first Oracle book that doesn't espouse a method that consists of just trying things until you find something that helps. It prescribes a step-by-step process, which is the same every time, for diagnosing your performance problem. The method works for finding performance problem causes whatever in the technology stack they may be. I didn't do it this way for the sake of being different. I did it this way because the traditional ways of tuning don't work. I think some other things like the queueing chapter make it different, too, but I feel that there's been too much focus placed upon the apparently deep mathematical nature of this chapter. The point of the chapter is to show people how to use a model (one that's already completely worked out for you) to gain insight into your real Oracle performance problems. At the end of the chapter is a 14-page, fully worked example. No other book does this. There are a lot of formulas in this chapter, but I show them only to help people recreate (or test) my results. For every formula, there is an Excel spreadsheet function that automates the use of that formula (some of the Excel formulas took years to develop, by the way). The chapter is all about showing the reader why performance behaves in the surprising ways that it sometimes does. It's not about showing you how cool math can be. MM: Does it teach different methodologies? CVM: It teaches a single method that is radically different from the ones most Oracle professionals are taught. You can get a drift of what I mean by reading the sample chapter at http://www.oreilly.com/catalog/optoraclep/index.html. (By the way, I distinguish carefully between the words method and methodology. I have a note about this in the book's Glossary, and at http://www.hotsos.com/e-library/oop.html as well.) MM: Is it more readable? I'd be very interested in your own assessment. CVM: There are three parts to the book, and the readability varies by design across those three parts. Parts I and III are meant to be read front-to-back by DBAs and analysts, and also their managers. Part II is reference material that I hope technical people are reading, but Part II is definitely too much to swallow in a few sittings. There's just too much detail. You can see more information about the structure of the book at http://www.hotsos.com/e-library/oop.html. There are some tricky concepts you have to understand before you can optimize an Oracle database, so it can be difficult to write about these concepts in a manner that people can
Re: Performance tuning
Perhaps you should consider disabling / dropping the index during the first procedure and then recreating it. You can use commands like 'execute immediate' within a procedure to issue DDL. Otherwise perhaps you can change the inserts to some kind of bulk insert - depending on how your application behaves. If it's any compensation I've seen many situations where the application does things like creating temporary indexes, analyzing tables, etc during a procedure to get performance right. A classic example was one procedure which truncated a table, inserted a pile of rows and then did some complex queries - we had to analyze the table after the inserts and before the selects so that the optimiser could use the correct indexes, etc - made a huge difference. Regards, Mark. dilmohan dilmohan@delhi. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tcs.co.in cc: Sent by: Subject: Performance tuning [EMAIL PROTECTED] 07/11/2002 15:38 Please respond to ORACLE-L I have a table in my application . This table gets all inserts during one procedure and select during other . Now if I make an index on this then the first procedure gets slow and if i drop the index then the second procedure gets very slow. Is there some solution to get out of this problem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Performance tuning
This is where the balancing comes into picture. If it is a bulk Insert then definitely the performance would degrade to the extent that it has to create an entry in the Index at a particular place. If there are so many indexes on this table you should visualise them in such a manner that a concatenated index could be formed to take care of all your selects on this table. The other alternative is to go in for partitioning and do the data partioning by range to that the selective data is getting indexed by the local index and not the global index on the table is getting effected. However if the inserts are huge than the Selects than dropping the index is beneficial, but if the Selects are too much that the index is beneficial. It relayy depends on the nature of the application. If the rows you want to retrieve from the table are in the range of 5% - 10% then index is beneficial else it could be better for the CBO to go in for a Full table scan. Moreover if it's a buldk insert you can disable the index at that point of time and then rebuild it online after the insert is over for that data to be used in Selects but if the inserts are happening in an OLTP application then you are the best judge, Vikas Khanna [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 07, 2002 10:08 AM To: Multiple recipients of list ORACLE-L I have a table in my application . This table gets all inserts during one procedure and select during other . Now if I make an index on this then the first procedure gets slow and if i drop the index then the second procedure gets very slow. Is there some solution to get out of this problem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Vikas Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Performance tuning
Trace the slower procedure. Hit the 10046 paper on www.hotsos.com to see how. This sounds like maybe 'buffer busy wait' waits on the index are causing contention among the procedures. But you need to prove whether it is (and which block it is, if my guess is right) before you can take the right corrective action on the first try. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Sent: Wednesday, November 06, 2002 10:38 PM To: Multiple recipients of list ORACLE-L I have a table in my application . This table gets all inserts during one procedure and select during other . Now if I make an index on this then the first procedure gets slow and if i drop the index then the second procedure gets very slow. Is there some solution to get out of this problem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Performance Tuning on RAC with Tru64 Unix - Any Docs , Links
Vivek - Hopefully you will receive some replies from someone with RAC experience. However, since RAC is so new, the information on tuning it may be pretty slim. Since RAC is based on Oracle Parallel Server, you might consider searching for tips on OPS. Some tips might apply to RAC. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:59 AM To: Multiple recipients of list ORACLE-L We are doing a Benchmark on RAC with Digital Unix (Tru64 Unix) with Oracle 9.0.1.3 Any Dos , Don'ts , Advice , Links , Books for MAXimizing Performance ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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).
RE: Performance Tuning and Backup Recovery
Sorry for the late reply, thx a lot all of u for the help Regards Sameer --- Godlewski, Melissa [EMAIL PROTECTED] wrote: Sam, Que1: If you have statistics on the table then the cost based optimizer is used. If you have out of data statistics you could be sending bad information to the optimizer for join conditions. Using the explain plan and plan table (utlplan.sql in $oracle_home/rdbms/admin) will show you cost information and access paths to the data. Que2: The trace file should have a date time stamp that is near the time you ran yours. Additionally if you look at the trace file it will have the osuer information in it. Que3: It's hard to say the cause. You will need to look at v$session and v$session_wait to identify what the session in waiting for. Is it possible there was other jobs executing on the system which slowed down your query the second time? On NT the perfmon on UNIX top will give you some information. You need to know what the waits are. Additionally you can trace or dump the session. Que4: Run an explain plan and tk_prof on the session to find out what objects the application is using. Verify all the indexes are there and not dropped accidentally. You need to find the objects and verify the access paths the optimizer is using for the application are the best ones. Hints or sql rewrite may be in order. Que5: I'm not sure what you mean by logical backup. Maybe below suggestions may work. Are you using RMAN for backups. If so look into tablespace recover. If not restore your backups to a development/test server recover the tablespace and associated data. Export/Import to your other machine. -Original Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Performance Tuning and Backup Recovery Hi, I don't have much onhand experience, I thought list is the appropriate place to get information. These are related to Oracle Performance Tuning and Backup Recovery. I have a system of Oracle 8i under HP-Unix and with ARCHIVELOG on. It has been running and stable since last 2-3 years. This was a brief overview. Que 1: Assuming that I am using Cost based Optimizer (CBO); I have a query which is a join of three tables out of which only one table have been analyzed and in first case rest two were analyzed but long time back and after that I have changed the structure of the table and in second case the other two tables have not been analyzed. Will Oracle use CBO ? I know it will but then what will be the behavior of optimizer ? Will it take the best guess for the other two tables in both the cases and if yes then those best guesses will be depending upon on what ? Que 2: Suppose u have ran EXPLAIN PLAN for a particular query at sqlplus prompt and there are around 50 more users running EXPLAIN PLAN at the same time from the UNIX bos itself. In this case the OSUSER, TERMINAL, PROGRAM will be same (u know it better). Now suppose I want to run TKPROF against the trace file how will I identify which will be my trace file in USER_DUMP_DEST directory ? Que 3: Supposing if I have Oracle Report running on Oracle. I passed 3 parameters first time it took me around 3 seconds to execute and 4 parameters second time its hogging the system taking almost 25 minutes to run. There are no concatenated indexs on the underlying tables. What might be the cause and how would u go about identifying it ? Que 4: A user starts complaining about a particular part of an appln. What will be my first steps to optimize it ? Que 5: Let's say we have a situation where at point A I took a complete db backup. Somewhere after point B I lost an online redo log file. I recovered the db using the bck taken at point A and archived redo log files and started the new incarnation at point B. I took a complete logical backup at point B and taking incremental backup after that. Now again at point C I took the complete bck. If I have dropped a tablespace somewhere in between point B and C which are the possible ways to recover it and which one will be the fastest ? (Of course if possible). A---B---C---D If I am not clear on any of the part please let me know and I'll do the needful. Thanks __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d 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
RE: Performance Tuning and Backup Recovery
Here are replies to a couple Sam, 1) If optimiser mode is chose and any table in a query has stats then CBO will be used. If stats do not exist on any table Oracle has a hard-coded default value which is 100 if I recall a note on here correctly. If stats do exist but they are very old then they will still be used possibly giving a poor path. The best bet is to analyze the tables. 2) 50 user running explain plan at the same time? Some system However the best bet is to select something which you can identify with the trace. Something like 'select this is sams session from dual;' Then do a grep on the udump directory searching for that phrase. 4) Put a trace on that particular session and get the user to run the application and then you can view the trace files afterwards. (see my notes on www.hcresources.co.uk re tracing sessions) Check that performance is bad all the time rather than just at a peak time etc HTH John -Original Message- Sent: 11 June 2002 14:24 To: Multiple recipients of list ORACLE-L Hi, I don't have much onhand experience, I thought list is the appropriate place to get information. These are related to Oracle Performance Tuning and Backup Recovery. I have a system of Oracle 8i under HP-Unix and with ARCHIVELOG on. It has been running and stable since last 2-3 years. This was a brief overview. Que 1: Assuming that I am using Cost based Optimizer (CBO); I have a query which is a join of three tables out of which only one table have been analyzed and in first case rest two were analyzed but long time back and after that I have changed the structure of the table and in second case the other two tables have not been analyzed. Will Oracle use CBO ? I know it will but then what will be the behavior of optimizer ? Will it take the best guess for the other two tables in both the cases and if yes then those best guesses will be depending upon on what ? Que 2: Suppose u have ran EXPLAIN PLAN for a particular query at sqlplus prompt and there are around 50 more users running EXPLAIN PLAN at the same time from the UNIX bos itself. In this case the OSUSER, TERMINAL, PROGRAM will be same (u know it better). Now suppose I want to run TKPROF against the trace file how will I identify which will be my trace file in USER_DUMP_DEST directory ? Que 3: Supposing if I have Oracle Report running on Oracle. I passed 3 parameters first time it took me around 3 seconds to execute and 4 parameters second time its hogging the system taking almost 25 minutes to run. There are no concatenated indexs on the underlying tables. What might be the cause and how would u go about identifying it ? Que 4: A user starts complaining about a particular part of an appln. What will be my first steps to optimize it ? Que 5: Let's say we have a situation where at point A I took a complete db backup. Somewhere after point B I lost an online redo log file. I recovered the db using the bck taken at point A and archived redo log files and started the new incarnation at point B. I took a complete logical backup at point B and taking incremental backup after that. Now again at point C I took the complete bck. If I have dropped a tablespace somewhere in between point B and C which are the possible ways to recover it and which one will be the fastest ? (Of course if possible). A---B---C---D If I am not clear on any of the part please let me know and I'll do the needful. Thanks __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d 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).
RE: Performance Tuning and Backup Recovery
Sam Que 3 - I have no idea how the parameters you are passing affect the execution time. That one probably needs more explanation. Que 5 - You don't say what you are performing backups with. RMAN? System? Hot? I am going to assume that you are doing hot backups (archivelogging) with the O.S. (not RMAN) and logical backups with exports. The correct answer is that once you change the incarnation that you immediately do a full backup because the prior backups won't be of much use. If you have done a partial (hot) backup that includes the tablespace that was dropped and the needed archive logs, and probably the system tablespace and control file, you should be able to recover the tablespace. You would probably be doing a TSPITR. Whether the logical backup (export) would be better probably depends on issues like whether that is your only option (depending on what your partial backup backed up), the size of the tablespace, the level of activity, the importance of data loss, etc. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 11, 2002 8:24 AM To: Multiple recipients of list ORACLE-L Hi, I don't have much onhand experience, I thought list is the appropriate place to get information. These are related to Oracle Performance Tuning and Backup Recovery. I have a system of Oracle 8i under HP-Unix and with ARCHIVELOG on. It has been running and stable since last 2-3 years. This was a brief overview. Que 1: Assuming that I am using Cost based Optimizer (CBO); I have a query which is a join of three tables out of which only one table have been analyzed and in first case rest two were analyzed but long time back and after that I have changed the structure of the table and in second case the other two tables have not been analyzed. Will Oracle use CBO ? I know it will but then what will be the behavior of optimizer ? Will it take the best guess for the other two tables in both the cases and if yes then those best guesses will be depending upon on what ? Que 2: Suppose u have ran EXPLAIN PLAN for a particular query at sqlplus prompt and there are around 50 more users running EXPLAIN PLAN at the same time from the UNIX bos itself. In this case the OSUSER, TERMINAL, PROGRAM will be same (u know it better). Now suppose I want to run TKPROF against the trace file how will I identify which will be my trace file in USER_DUMP_DEST directory ? Que 3: Supposing if I have Oracle Report running on Oracle. I passed 3 parameters first time it took me around 3 seconds to execute and 4 parameters second time its hogging the system taking almost 25 minutes to run. There are no concatenated indexs on the underlying tables. What might be the cause and how would u go about identifying it ? Que 4: A user starts complaining about a particular part of an appln. What will be my first steps to optimize it ? Que 5: Let's say we have a situation where at point A I took a complete db backup. Somewhere after point B I lost an online redo log file. I recovered the db using the bck taken at point A and archived redo log files and started the new incarnation at point B. I took a complete logical backup at point B and taking incremental backup after that. Now again at point C I took the complete bck. If I have dropped a tablespace somewhere in between point B and C which are the possible ways to recover it and which one will be the fastest ? (Of course if possible). A---B---C---D If I am not clear on any of the part please let me know and I'll do the needful. Thanks __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d 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
Re: Performance Tuning
Commit; :-) And then go to OraPerf.com, Hotsos.com, Jonathan Lewis' website with one of these wonderful, long and strange English names, Ixora, etc. and get the good articles there. This is where you'll find a lot of current thinking. Mogens [EMAIL PROTECTED] wrote: Okay, I'll plug my own list of recommendations on Amazon. It should come up from this URL:http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316-6595843If it doesn't, just enter 'Oracle performance tuning' in a search on Amazon.com and look to the right. My list usually pops up.If you just get one book on performance, go with Performance 101. If you're getting two books, get 101 and Tom Kyte's book.Regards,Chris GaitOn 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote:Date sent: Wed, 30 Jan 2002 02:25:19 -0800To: Multiple recipients of list ORACLE-L ORACLE-L@fatc ity.comSend reply to: [EMAIL PROTECTED]Organization: Fat City Network Services, San Diego, California Hi Everyone I am interested in purchasing some exceptionally good book on OraclePerformance Tuning. Can anyone suggest me some very good book on OracleTunning worth purchasingBinay KumarOracle Cerified DBALondon***Binay KumarFocus 3 -Technical SupportP O NedllyodLondon0044 207 441 1648***---The contents of this e-mail are confidential to the ordinary userof the e-mail address to which it was addressed and may also beprivileged. If you are not the addressee of this e-mail you shouldnot copy, forward, disclose or otherwise use it or any part of itin any form whatsoever. If you have received this e-mail in errorplease notify us by telephone or e-mail the sender by replying tothis message, and then delete this e-mail and other copies of itfrom your computer system. Thank you.We reserve the right to monitor all e-mail communications throughour network.-- 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-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from ). You mayalso send the HELP command for other information (like subscribing).
Re: Performance Tuning
A note about Amazon URLs: You can often cut off a lot of the stuff at the end when sharing a link with others. The stuff at the end is just session context. For instance, Chris's list is at: http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1 -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 18 Feb 2002, Mogens [ISO-8859-1] Nørgaard wrote: Commit; :-) And then go to OraPerf.com, Hotsos.com, Jonathan Lewis' website with one of these wonderful, long and strange English names, Ixora, etc. and get the good articles there. This is where you'll find a lot of current thinking. [EMAIL PROTECTED] wrote: Okay, I'll plug my own list of recommendations on Amazon. It should come up from this URL: http://www.amazon.com/exec/obidos/tg/listmania/list-browse/- /VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316- 6595843 If it doesn't, just enter 'Oracle performance tuning' in a search on Amazon.com and look to the right. My list usually pops up. If you just get one book on performance, go with Performance 101. If you're getting two books, get 101 and Tom Kyte's book. On 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote: I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).
Re: Performance Tuning
well, we would certainly expect *you* to know this :) thanks, that helps when I send links to my mom, who still feels she has to retype the url rather than cut and paste --- Jeremiah Wilton [EMAIL PROTECTED] wrote: A note about Amazon URLs: You can often cut off a lot of the stuff at the end when sharing a link with others. The stuff at the end is just session context. For instance, Chris's list is at: http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1 -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 18 Feb 2002, Mogens [ISO-8859-1] Nørgaard wrote: Commit; :-) And then go to OraPerf.com, Hotsos.com, Jonathan Lewis' website with one of these wonderful, long and strange English names, Ixora, etc. and get the good articles there. This is where you'll find a lot of current thinking. [EMAIL PROTECTED] wrote: Okay, I'll plug my own list of recommendations on Amazon. It should come up from this URL: http://www.amazon.com/exec/obidos/tg/listmania/list-browse/- /VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316- 6595843 If it doesn't, just enter 'Oracle performance tuning' in a search on Amazon.com and look to the right. My list usually pops up. If you just get one book on performance, go with Performance 101. If you're getting two books, get 101 and Tom Kyte's book. On 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote: I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
Re: Performance Tuning
Okay, I'll plug my own list of recommendations on Amazon. It should come up from this URL: http://www.amazon.com/exec/obidos/tg/listmania/list-browse/- /VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316- 6595843 If it doesn't, just enter 'Oracle performance tuning' in a search on Amazon.com and look to the right. My list usually pops up. If you just get one book on performance, go with Performance 101. If you're getting two books, get 101 and Tom Kyte's book. Regards, Chris Gait On 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote: Date sent: Wed, 30 Jan 2002 02:25:19 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Send reply to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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: 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).
RE: Performance Tuning
I agree we need to look at both. Depends on the shop you work in if you can though. Where I've been the SAs hold tuning of the OS close, and I can work WITH them but can't effect changes on my own. so I concentrate on the database. Besides, I've always found it much more effective if I go to the SA with a list of all the steps I've taken to ensure that the problem is not with the database. That and I *never* say your stuff is broken but rather I have a problem, this is what I've done to find it, can you help me seems to work much better that way. --- SARKAR, Samir [EMAIL PROTECTED] wrote: Okay Rachelu have me convinced thereI am adding the 101 book to my shelf !! I said *some* of the masters of OracleI do realize that there r lots of other masters of Oracle who do not work for TUSC. Yep...Alomari's book does deal more on OS tuning for Oracle but don't u think that much of our tuning efforts always go towards the database whereas the real focus should b directed on the OS which houses Oracleof course, it depends on case-to-case basis but I have come across so many DBAs who always think that the problem is with the database rather than otherwise. Other than Alomari's book, I haven't come across any other book which explains so well the way Oracle works within the OS kernel, thats the reason I thought anybody working on Oracle on Unix needs that book. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 19:21 To: Multiple recipients of list ORACLE-L I didn't say Rich's book is bad, just that if you could only buy one, I'd buy the 101 book. It's written in a more friendly style than the other one, mostly because that's the goal of the 101 series. Of course, since I did some of the editing on the book, I'm prejudiced (and no, I don't get any money if more copies sell) define masters of Oracle -- there are a heck of lot of incredibly brilliant Oracle users (developers and DBAs) who don't work for TUSC As for Alomari's book -- it deals more with OS tuning for Oracle than for performance tuning within the database. --- SARKAR, Samir [EMAIL PROTECTED] wrote: Maybe u r right, Rachel.since except for me, all the others have suggested the 101 book. Thing is, I bought Rich's book based on the customer reviews on Amazon and I must say that I am not disappointed but then, I haven't read the 101 book. At the same time, TUSC is supposed to have some of the masters of Oracle. One thing I wonder is why nobody has recommended Alomari's book cos it is a gem for DBAs working on Unix. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 15:50 To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- SARKAR, Samir [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to
Re: Performance Tuning
[EMAIL PROTECTED] wrote: I agree we need to look at both. Depends on the shop you work in if you can though. Where I've been the SAs hold tuning of the OS close, and I can work WITH them but can't effect changes on my own. so I concentrate on the database. it also helps if the OS is tunable. some are more so than others. and i also do the database first, then go to the SA and work with them, then do the database again. and the wait_state tuning method does give you things to take to the SA and say, how come i get these numbers? and what do i have to do to change them? -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. You have a tendency to feel you are superior to most computers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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).
RE: Performance Tuning
You should take a look at 'Scaling Oracle8i' by James Morle. It's a mini computer systems architecture course. You go through quite a bit of OS and HW before you ever get to Oracle. Helps you very clearly see the relationship between Oracle, OS and HW. Jared SARKAR, Samir [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/31/02 03:20 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Performance Tuning Okay Rachelu have me convinced thereI am adding the 101 book to my shelf !! I said *some* of the masters of OracleI do realize that there r lots of other masters of Oracle who do not work for TUSC. Yep...Alomari's book does deal more on OS tuning for Oracle but don't u think that much of our tuning efforts always go towards the database whereas the real focus should b directed on the OS which houses Oracleof course, it depends on case-to-case basis but I have come across so many DBAs who always think that the problem is with the database rather than otherwise. Other than Alomari's book, I haven't come across any other book which explains so well the way Oracle works within the OS kernel, thats the reason I thought anybody working on Oracle on Unix needs that book. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 19:21 To: Multiple recipients of list ORACLE-L I didn't say Rich's book is bad, just that if you could only buy one, I'd buy the 101 book. It's written in a more friendly style than the other one, mostly because that's the goal of the 101 series. Of course, since I did some of the editing on the book, I'm prejudiced (and no, I don't get any money if more copies sell) define masters of Oracle -- there are a heck of lot of incredibly brilliant Oracle users (developers and DBAs) who don't work for TUSC As for Alomari's book -- it deals more with OS tuning for Oracle than for performance tuning within the database. --- SARKAR, Samir [EMAIL PROTECTED] wrote: Maybe u r right, Rachel.since except for me, all the others have suggested the 101 book. Thing is, I bought Rich's book based on the customer reviews on Amazon and I must say that I am not disappointed but then, I haven't read the 101 book. At the same time, TUSC is supposed to have some of the masters of Oracle. One thing I wonder is why nobody has recommended Alomari's book cos it is a gem for DBAs working on Unix. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 15:50 To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- SARKAR, Samir [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail
RE: Performance Tuning
Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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).
RE: Performance Tuning
Binay, The Oracle Performance Tuning book from O'Reilly (ISBN 1-56592-237-9) is an excellent book. Covers just about everything, database, code, environment tuning. Regards, Kev. -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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: Thomas, Kevin 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).
RE: Performance Tuning
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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).
RE: Performance Tuning
Hi, are they up to release 5 already? I'm 4 releases behind :-)) Jack K Gopalakrishnan [EMAIL PROTECTED]@fatcity.com on 30-01-2002 13:30:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the
RE: Performance Tuning
Yeah its very good book!!!Especially I like that chapter Method behind madness!!..Every body should read that book. From: K Gopalakrishnan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Performance Tuning Date: Wed, 30 Jan 2002 04:30:24 -0800 Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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). Raghu Kota OCP DBA. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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).
RE: Performance Tuning
I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- SARKAR, Samir [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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
RE: Performance Tuning
Maybe u r right, Rachel.since except for me, all the others have suggested the 101 book. Thing is, I bought Rich's book based on the customer reviews on Amazon and I must say that I am not disappointed but then, I haven't read the 101 book. At the same time, TUSC is supposed to have some of the masters of Oracle. One thing I wonder is why nobody has recommended Alomari's book cos it is a gem for DBAs working on Unix. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 15:50 To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- SARKAR, Samir [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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).
RE: Performance Tuning
Rachel, Thank you so much for you kind words and the very interesting comparison.. :) - Kirti -Original Message- Sent: Wednesday, January 30, 2002 9:50 AM To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- SARKAR, Samir [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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
RE: Performance Tuning
Umm, how do you really feel about it? grin I have to concur though - OPT101 is excellent! Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: K Gopalakrishnan [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 6:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: Performance Tuning Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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).
RE: Performance Tuning
Rachel IS kind but her words are also true and I think this was her main focus in this case. ;-) My Alomari book was for v7 and was good but is now dated... Is it up to date for 8i/9i? -Original Message- Sent: Wednesday, January 30, 2002 10:11 AM To: Multiple recipients of list ORACLE-L Rachel, Thank you so much for you kind words and the very interesting comparison.. :) - Kirti -Original Message- Sent: Wednesday, January 30, 2002 9:50 AM To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- SARKAR, Samir [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network
RE: Performance Tuning
No... we are not.. still at #1. Must be something wrong with K.Gopal's keyboard or mouse (or finger;) I sincerely thank you all for 'discussing' our book. Gaja is still catching up with his office e-mail after returning from a long vacation. But he will join the list soon.. Regards, - Kirti -Original Message- Sent: Wednesday, January 30, 2002 6:55 AM To: Multiple recipients of list ORACLE-L Hi, are they up to release 5 already? I'm 4 releases behind :-)) Jack K Gopalakrishnan [EMAIL PROTECTED]@fatcity.com on 30-01-2002 13:30:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
RE: Performance Tuning
yeah its very straight forward!! No beating around the bush!! The points are striking!! The way kirti explained also extraordinary!! its not so easy to explain technical jargon such easy way!! Iam greateful to him for such excellent book. Frankly I enjoyed book alot!! From: Deshpande, Kirti [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Performance Tuning Date: Wed, 30 Jan 2002 09:10:33 -0800 Rachel, Thank you so much for you kind words and the very interesting comparison.. :) - Kirti -Original Message- Sent: Wednesday, January 30, 2002 9:50 AM To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- SARKAR, Samir [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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). __ Do
RE: Performance Tuning
Very cute ---your submisness This book may be improved further if some aspect/topics are discussed in detail.. Regards Rafiq No... we are not.. still at #1. Must be something wrong with K.Gopal's keyboard or mouse (or finger;) I sincerely thank you all for 'discussing' our book. Gaja is still catching up with his office e-mail after returning from a long vacation. But he will join the list soon.. Regards, - Kirti -Original Message- Sent: Wednesday, January 30, 2002 6:55 AM To: Multiple recipients of list ORACLE-L Hi, are they up to release 5 already? I'm 4 releases behind :-)) Jack K Gopalakrishnan [EMAIL PROTECTED]@fatcity.com on 30-01-2002 13:30:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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).
RE: Performance Tuning
the soul of diplomacy, that's me :) I am prejudiced, I did edit the book after all. But I don't endorse what I don't believe in. Everyone I have talked to within and without Oracle is espousing the tuning by wait events methodology that drives your book. and thank you for proving the rollback/optimal point :) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Rachel, Thank you so much for you kind words and the very interesting comparison.. :) - Kirti -Original Message- Sent: Wednesday, January 30, 2002 9:50 AM To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- SARKAR, Samir [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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). __ Do You Yahoo!? Great
RE: Performance Tuning
I didn't say Rich's book is bad, just that if you could only buy one, I'd buy the 101 book. It's written in a more friendly style than the other one, mostly because that's the goal of the 101 series. Of course, since I did some of the editing on the book, I'm prejudiced (and no, I don't get any money if more copies sell) define masters of Oracle -- there are a heck of lot of incredibly brilliant Oracle users (developers and DBAs) who don't work for TUSC As for Alomari's book -- it deals more with OS tuning for Oracle than for performance tuning within the database. --- SARKAR, Samir [EMAIL PROTECTED] wrote: Maybe u r right, Rachel.since except for me, all the others have suggested the 101 book. Thing is, I bought Rich's book based on the customer reviews on Amazon and I must say that I am not disappointed but then, I haven't read the 101 book. At the same time, TUSC is supposed to have some of the masters of Oracle. One thing I wonder is why nobody has recommended Alomari's book cos it is a gem for DBAs working on Unix. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 15:50 To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- SARKAR, Samir [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
RE: Performance Tuning
Hi Rafiq, You are most welcome to write to us directly in detail your comments/suggestions. Many have done that. We will make every effort to incorporate our readers' suggestions when we work on the 2nd edition. Thanks. Best Regards, - Kirti -Original Message- Sent: Wednesday, January 30, 2002 1:11 PM To: Multiple recipients of list ORACLE-L Very cute ---your submisness This book may be improved further if some aspect/topics are discussed in detail.. Regards Rafiq No... we are not.. still at #1. Must be something wrong with K.Gopal's keyboard or mouse (or finger;) I sincerely thank you all for 'discussing' our book. Gaja is still catching up with his office e-mail after returning from a long vacation. But he will join the list soon.. Regards, - Kirti -Original Message- Sent: Wednesday, January 30, 2002 6:55 AM To: Multiple recipients of list ORACLE-L Hi, are they up to release 5 already? I'm 4 releases behind :-)) Jack K Gopalakrishnan [EMAIL PROTECTED]@fatcity.com on 30-01-2002 13:30:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
RE: Performance Tuning
rather than being coy and saying some aspect/topics are discussed in detail why not say what you'd like to see? First -- Oracle Press strictly limits the number of pages in their books, it is a constant challenge to cram all the information that the authors want into the page limit. Second -- this IS after all, a beginner's book. Sometimes too much detail is overwhelming Third -- every author I know, myself included, more than welcomes constructive criticism of the books. Please note the use of the word constructive. Vague statements don't help. Tell me/Kirti/Gaja/whomever exactly what you'd like to see expanded, and why. If you think you've found an error, tell us. We fix these things. We include requested enhancements whenever possible. All we ask is that the request/error check be worded politely :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Very cute ---your submisness This book may be improved further if some aspect/topics are discussed in detail.. Regards Rafiq No... we are not.. still at #1. Must be something wrong with K.Gopal's keyboard or mouse (or finger;) I sincerely thank you all for 'discussing' our book. Gaja is still catching up with his office e-mail after returning from a long vacation. But he will join the list soon.. Regards, - Kirti -Original Message- Sent: Wednesday, January 30, 2002 6:55 AM To: Multiple recipients of list ORACLE-L Hi, are they up to release 5 already? I'm 4 releases behind :-)) Jack K Gopalakrishnan [EMAIL PROTECTED]@fatcity.com on 30-01-2002 13:30:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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
RE: Performance Tuning
Rachel, It looks that you are not in good mood today. I got a message from Kirti,also,on same subject and I am replying to him directly Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 30 Jan 2002 11:37:25 -0800 rather than being coy and saying some aspect/topics are discussed in detail why not say what you'd like to see? First -- Oracle Press strictly limits the number of pages in their books, it is a constant challenge to cram all the information that the authors want into the page limit. Second -- this IS after all, a beginner's book. Sometimes too much detail is overwhelming Third -- every author I know, myself included, more than welcomes constructive criticism of the books. Please note the use of the word constructive. Vague statements don't help. Tell me/Kirti/Gaja/whomever exactly what you'd like to see expanded, and why. If you think you've found an error, tell us. We fix these things. We include requested enhancements whenever possible. All we ask is that the request/error check be worded politely :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Very cute ---your submisness This book may be improved further if some aspect/topics are discussed in detail.. Regards Rafiq No... we are not.. still at #1. Must be something wrong with K.Gopal's keyboard or mouse (or finger;) I sincerely thank you all for 'discussing' our book. Gaja is still catching up with his office e-mail after returning from a long vacation. But he will join the list soon.. Regards, - Kirti -Original Message- Sent: Wednesday, January 30, 2002 6:55 AM To: Multiple recipients of list ORACLE-L Hi, are they up to release 5 already? I'm 4 releases behind :-)) Jack K Gopalakrishnan [EMAIL PROTECTED]@fatcity.com on 30-01-2002 13:30:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Performance Tuning
Rafiq, actually I was in a good mood... I really DO want specific instances of things that you think need more explanation or something we didn't include that you'd want to see. But some things should be discussed in detail doesn't tell me WHAT things and I can't fix anything. Rachel --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Rachel, It looks that you are not in good mood today. I got a message from Kirti,also,on same subject and I am replying to him directly Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 30 Jan 2002 11:37:25 -0800 rather than being coy and saying some aspect/topics are discussed in detail why not say what you'd like to see? First -- Oracle Press strictly limits the number of pages in their books, it is a constant challenge to cram all the information that the authors want into the page limit. Second -- this IS after all, a beginner's book. Sometimes too much detail is overwhelming Third -- every author I know, myself included, more than welcomes constructive criticism of the books. Please note the use of the word constructive. Vague statements don't help. Tell me/Kirti/Gaja/whomever exactly what you'd like to see expanded, and why. If you think you've found an error, tell us. We fix these things. We include requested enhancements whenever possible. All we ask is that the request/error check be worded politely :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Very cute ---your submisness This book may be improved further if some aspect/topics are discussed in detail.. Regards Rafiq No... we are not.. still at #1. Must be something wrong with K.Gopal's keyboard or mouse (or finger;) I sincerely thank you all for 'discussing' our book. Gaja is still catching up with his office e-mail after returning from a long vacation. But he will join the list soon.. Regards, - Kirti -Original Message- Sent: Wednesday, January 30, 2002 6:55 AM To: Multiple recipients of list ORACLE-L Hi, are they up to release 5 already? I'm 4 releases behind :-)) Jack K Gopalakrishnan [EMAIL PROTECTED]@fatcity.com on 30-01-2002 13:30:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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
Re: performance tuning
Oracle Performance Tuning 101 from Oracle Press. Scripts are in the book. Hang out a while and you will see posts to this list from the authors... Scott Shafer San Antonio, TX k johnson wrote: Does anyone have any good ideas on where to start tuning and any good scripts out there. thanks kym _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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).
RE: performance tuning
www.ixora.com.au www.vampired.net O'Reilly Performance Tuning O'Reilly Oracle Internals Oracle 8i and Unix Performance Tuning Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, July 23, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Does anyone have any good ideas on where to start tuning and any good scripts out there. thanks kym __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k johnson 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: Christopher Spence 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).
RE: performance tuning
www.oracletuning.com has a few interesting scripts, Kym. -Original Message- Sent: Monday, July 23, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Does anyone have any good ideas on where to start tuning and any good scripts out there. thanks kym __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k johnson 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: Norwood Bradly A 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).
RE: Performance tuning
Database parameters were slightly changed for the second run and SGA was made only 140 MB. Loading was done without indexes and SQL loader parameters were changed to Readsize=10m, Bindsize=10m and Rows=5000. It took almost same time for about 21 hours but again it committed 8-10 times ( first 5) very quickly. Real bottleneck is RAM (as pointed out by all) since commit charge in NT task manager was almost double than the physical memory. But since the data is loaded , we are through. Thanks to every one who responded Azhar Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: mpo.gc.ca Subject: RE: Performance tuning Sent by: [EMAIL PROTECTED] 05/31/2001 12:56 AM Please respond to ORACLE-L I don't know what is causing this, but I would keep an eye on physical memory available vs. commit charge in Task Manager, I strongly recommend your commit charge never exceed your physical memory. I found that Oracle sometimes refuses to even start services when it runs out of physical memory, it doesn't like virtual memory very much. Shrinking the size of your SGA is preferable to exceeding the available physical memory, in my opinion. Keep in mind session memory space in your calculations, and the other programs you may be running on your machine. I recommend you stop all the services (in Services applet) that you dare stop, to lighten the load. In the virtual memory settings, allocate the amount you want, but try to avoid a range of values - when initial and max size values are different NT keeps polling the pagefile and memory statistics to figure out if the pagefile should grow or shrink. Better to do that manually up front, allocate at set amount. NT then stops doing extra work regarding memory allocation. Every little bit helps. I haven't used SQL*Loader, so I can't say much about that, except... when you start loading those first few rows, what does Commit Charge look like in Task Manager? Is it growing? If it is, notice how slowly NT does this. It can't be helped. If commit charge approaches physical memory available, you will hit a ceiling I think. Then things may well slow down to a crawl. Is there a buffer size you can set for SQL*Loader? I always set my exp buffer size to 100 to speed it up. Maybe you can do the same for SQL*Loader. That must use more memory though. Can you commit every few records? Could it be every 10 rows? Would it be better not to commit too often? As mentioned before, RAID 5 will prove slower than simple disk or RAID 01 or RAID 10. Do you have many indexes on the tables you are filling up? You may want to drop them and re-create them once the load is finished. This may sound silly but... do you have a virus checking program running
Re: Performance tuning
Azhar, I agree with the other responses (more RAM, don't use OPTIMAL on your RBS's) but would also suggestdropping all indexes except PK until the load is done, therebuild them. Also, does this table have any triggers? If so, if can you disable them during the load, that will help speed up the load. For help in setting the ROWS and BINDSIZE parameters, there is an article of mine that O'Reilly published on their web site (http://oracle.oreilly.com/news/oraclesqlload_0401.html) which details my experience which resulted in some big performance gains. HTH, Stephen [EMAIL PROTECTED] 05/30/01 02:19AM HI ALL,We have to load almost 3 millions records of average row size of 150 bytes.We are importing data using sqloader with ROWS=4000 and bindsize=845 .We have adjusted the rollback segment to almost 10 m with 8 extents enoughfor single transaction size and considering 30% rollback overhead. Weadjusted the OPTIMAL TO 10 M to have avoid rollback extensionRollback segment, databuffer cache have hit ratio of 100%.The loading was fast only for first 10 commits but then it slowed likesnail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM.SGA figures in M :NAME VALUE -Fixed Size .0676384Variable Size 239.02734Database Buffers 39.0625Redo Buffers 7.8203125 -sum 285.97779( we can't use direct path due to functions in sqlldr controlfile). .Couldn't figure out the bottleneck yet.Any ideas.TIAAzhar Siddiq,DBALMK Resources-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Performance tuning
I would not recommend using optimal as it will cause the segment to have to shrink. Your better of doing it manually on lulls of activity and size the segments bigger if need be. Segments should not be frequently shrinking. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 5:19 AM To: Multiple recipients of list ORACLE-L HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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: Christopher Spence 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).
Re: Performance tuning
Peter is right. Look at your SGA it's 285M. If you only have 128M on the machine you are running your at least 75% of your db in swap. I would recommend 512M MINIMUM on this system push for more if you can. RAM is relatively cheap right now for intel machines get some. After that you need to get some other system stats (i/o, cpu, waits, locks) and configuration data (SMP?, RAID??). Rodd Holman Original Message On 5/30/01, 6:21:45 AM, Peter McLarty [EMAIL PROTECTED] wrote regarding Re: Performance tuning : Okay fill us in why would you try and inane thing like that on only 128MB RAM. NT would be barely running on that without getting your instance up. I am not that good yet at calculating what amount of RAM you need for a given SGA but I am thinking that you are running in swap What is the disk configuration. Are you running RAID and if so what configuration. (Not RAID 5 I hope) Can you get this system up to 512MB at least. With this and a whole lot more you will get some better answers Peter Trainee Oracle DBA At 01:19 AM 30/05/2001 -0800, you wrote: HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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: Peter McLarty 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: Rodd Holman 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).
Re: Performance tuning
Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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).
RE: Performance tuning
Why putting DB in noarchivelog will avoid redo generation? There will be no archiving, but redo will continue to be generated. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Hillman, Alex 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).
RE: Performance tuning
John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I believe. RAID 5 will require additional writes by DBWR which is going to be huge overhead during a dataload. - Ethan Post -Original Message- Sent: Wednesday, May 30, 2001 6:51 AM To: Multiple recipients of list ORACLE-L FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Peter McLarty wrote Are you running RAID and if so what configuration. (Not RAID 5 I hope) Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid performance for Oracle RDBMS on NT RAID 5 is useful for Oracle datafiles but not for redo log files or rollback segments which are sequentially accessed. Datafiles belonging to the temporary tablespace are not suitable for a RAID 5 device. More benefits will be seen in situations where reads predominate over writes. I know that in this instance it is a data load that is being discussed but presumably once the data is loaded then it will be read more than once. Certainly the tone of the note suggests that raid 5 is not a definite no-no rather a 'be cautious as to which files are placed where'. It is my belief that often a single raid level is set for all files rather than a mix of raid 1 and raid 5 as appropriate. Peter, I fully agree that the level of memory utilised here is totally insufficient and is very likely to be the constraining factor in this case. John -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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).
RE: Performance tuning
Raid 5 can consume as much as 60% overhead for writes. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 12:51 PM To: Multiple recipients of list ORACLE-L John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I believe. RAID 5 will require additional writes by DBWR which is going to be huge overhead during a dataload. - Ethan Post -Original Message- Sent: Wednesday, May 30, 2001 6:51 AM To: Multiple recipients of list ORACLE-L FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Peter McLarty wrote Are you running RAID and if so what configuration. (Not RAID 5 I hope) Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid performance for Oracle RDBMS on NT RAID 5 is useful for Oracle datafiles but not for redo log files or rollback segments which are sequentially accessed. Datafiles belonging to the temporary tablespace are not suitable for a RAID 5 device. More benefits will be seen in situations where reads predominate over writes. I know that in this instance it is a data load that is being discussed but presumably once the data is loaded then it will be read more than once. Certainly the tone of the note suggests that raid 5 is not a definite no-no rather a 'be cautious as to which files are placed where'. It is my belief that often a single raid level is set for all files rather than a mix of raid 1 and raid 5 as appropriate. Peter, I fully agree that the level of memory utilised here is totally insufficient and is very likely to be the constraining factor in this case. John -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Christopher Spence 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).
RE: Performance tuning
Redo generation will not change. Just the archiving process, which on improperly laid out file system can be very painful process. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 1:22 PM To: Multiple recipients of list ORACLE-L Why putting DB in noarchivelog will avoid redo generation? There will be no archiving, but redo will continue to be generated. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Hillman, Alex 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: Christopher Spence 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).
RE: Performance tuning
Indeses are not critical for the application to run..It just helps them run faster at times. You could build you indexes with the no logging or unrecoverable option and that will save on the archivelog creation. Just be sure to take a backup after the indexes are rebuilt because you will not have archived the index info in archivelogs for recovery. I do it all the time for my files that have a large data load each day and it saves log writing time and log space. ROR mª¿ªm [EMAIL PROTECTED] 05/30/01 01:21PM Why putting DB in noarchivelog will avoid redo generation? There will be no archiving, but redo will continue to be generated. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Hillman, Alex 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: Ron Rogers 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
RE: Performance tuning
Sorry - that's what I meant. No archive log generation. NOT no redo log generation. Thanks for pointing that out. Is it Friday yet? Jim Why putting DB in noarchivelog will avoid redo generation? There will be no archiving, but redo will continue to be generated. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Hillman, Alex 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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
RE: Performance tuning
Since Data is being loaded in development environment. that is why we have 128 meg ram. (Regarding RAM i have no other choice) i have the NT performance monitor and it shows that it is not using swap heavily. NT swaps heavily with 128Mb ram running office, you must have some sort of magical system to run oracle with such a large table on it. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Actually we have to Since Data is being loaded in development environment. that is why we have 128 meg ram. (Regarding RAM i have no other choice) i have the NT performance monitor and it shows that it is not using swap heavily. Currently disk configuration is not RAID . however we have no disk limit problem. i have autoexetended datafiles. Regards Azhar Peter McLarty peter.mclarty@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] incts.com cc: Sent by: Subject: Re: Performance tuning [EMAIL PROTECTED] m 05/30/2001 04:21 PM Please respond to ORACLE-L Okay fill us in why would you try and inane thing like that on only 128MB RAM. NT would be barely running on that without getting your instance up. I am not that good yet at calculating what amount of RAM you need for a given SGA but I am thinking that you are running in swap What is the disk configuration. Are you running RAID and if so what configuration. (Not RAID 5 I hope) Can you get this system up to 512MB at least. With this and a whole lot more you will get some better answers Peter Trainee Oracle DBA At 01:19 AM 30/05/2001 -0800, you wrote: HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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: Peter McLarty 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
Re: Performance tuning
No to be overly pedantic, but RAID5 does not change the number of write() calls made by DBWR. It will change the number of disk operations done by your hardware controller or your software raid drivers, but that's slightly different. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 2:02 PM Raid 5 can consume as much as 60% overhead for writes. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 12:51 PM To: Multiple recipients of list ORACLE-L John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I believe. RAID 5 will require additional writes by DBWR which is going to be huge overhead during a dataload. - Ethan Post -Original Message- Sent: Wednesday, May 30, 2001 6:51 AM To: Multiple recipients of list ORACLE-L FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Peter McLarty wrote Are you running RAID and if so what configuration. (Not RAID 5 I hope) Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid performance for Oracle RDBMS on NT RAID 5 is useful for Oracle datafiles but not for redo log files or rollback segments which are sequentially accessed. Datafiles belonging to the temporary tablespace are not suitable for a RAID 5 device. More benefits will be seen in situations where reads predominate over writes. I know that in this instance it is a data load that is being discussed but presumably once the data is loaded then it will be read more than once. Certainly the tone of the note suggests that raid 5 is not a definite no-no rather a 'be cautious as to which files are placed where'. It is my belief that often a single raid level is set for all files rather than a mix of raid 1 and raid 5 as appropriate. Peter, I fully agree that the level of memory utilised here is totally insufficient and is very likely to be the constraining factor in this case. John -- -- -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Christopher Spence 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: George Schlossnagle 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).
RE: Performance tuning
I don't know what is causing this, but I would keep an eye on physical memory available vs. commit charge in Task Manager, I strongly recommend your commit charge never exceed your physical memory. I found that Oracle sometimes refuses to even start services when it runs out of physical memory, it doesn't like virtual memory very much. Shrinking the size of your SGA is preferable to exceeding the available physical memory, in my opinion. Keep in mind session memory space in your calculations, and the other programs you may be running on your machine. I recommend you stop all the services (in Services applet) that you dare stop, to lighten the load. In the virtual memory settings, allocate the amount you want, but try to avoid a range of values - when initial and max size values are different NT keeps polling the pagefile and memory statistics to figure out if the pagefile should grow or shrink. Better to do that manually up front, allocate at set amount. NT then stops doing extra work regarding memory allocation. Every little bit helps. I haven't used SQL*Loader, so I can't say much about that, except... when you start loading those first few rows, what does Commit Charge look like in Task Manager? Is it growing? If it is, notice how slowly NT does this. It can't be helped. If commit charge approaches physical memory available, you will hit a ceiling I think. Then things may well slow down to a crawl. Is there a buffer size you can set for SQL*Loader? I always set my exp buffer size to 100 to speed it up. Maybe you can do the same for SQL*Loader. That must use more memory though. Can you commit every few records? Could it be every 10 rows? Would it be better not to commit too often? As mentioned before, RAID 5 will prove slower than simple disk or RAID 01 or RAID 10. Do you have many indexes on the tables you are filling up? You may want to drop them and re-create them once the load is finished. This may sound silly but... do you have a virus checking program running on your server? Try to exclude the oradata directories from it. Just some ideas. That's what I would check first. If your RBS segments filled up, you would see an error somewhere, it seems to me. Is TEMP filling up? You never know. Oh another probably silly thing - if you are not using SCSI, download DMACheck from microsoft and test whether your DMA is turned on. That would speed up your disk by 40% or more. Servers use SCSI disks normally though, but sometimes people install Oracle on PCs or workstations with IDE drives. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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 --
RE: Performance tuning
Yes, Agreed. Raid of any level will not change the number of writes in terms of DBWR. But will change how many physical reads and writes needed to implement parity and data to the disks. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 3:02 PM To: Multiple recipients of list ORACLE-L No to be overly pedantic, but RAID5 does not change the number of write() calls made by DBWR. It will change the number of disk operations done by your hardware controller or your software raid drivers, but that's slightly different. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 2:02 PM Raid 5 can consume as much as 60% overhead for writes. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 12:51 PM To: Multiple recipients of list ORACLE-L John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I believe. RAID 5 will require additional writes by DBWR which is going to be huge overhead during a dataload. - Ethan Post -Original Message- Sent: Wednesday, May 30, 2001 6:51 AM To: Multiple recipients of list ORACLE-L FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Peter McLarty wrote Are you running RAID and if so what configuration. (Not RAID 5 I hope) Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid performance for Oracle RDBMS on NT RAID 5 is useful for Oracle datafiles but not for redo log files or rollback segments which are sequentially accessed. Datafiles belonging to the temporary tablespace are not suitable for a RAID 5 device. More benefits will be seen in situations where reads predominate over writes. I know that in this instance it is a data load that is being discussed but presumably once the data is loaded then it will be read more than once. Certainly the tone of the note suggests that raid 5 is not a definite no-no rather a 'be cautious as to which files are placed where'. It is my belief that often a single raid level is set for all files rather than a mix of raid 1 and raid 5 as appropriate. Peter, I fully agree that the level of memory utilised here is totally insufficient and is very likely to be the constraining factor in this case. John -- -- -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Christopher Spence 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: George Schlossnagle 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
RE: Performance tuning
I am impressed. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 5:18 PM To: Multiple recipients of list ORACLE-L You are above average in awareness, so one would have to work harder than normal to slip something by you. In my fractured metaphor, early-ness in the morning maps to degree of awareness, and wool over the eyes maps to unawareness. The original metaphors are the early bird gets the worm and you can't pull the wool over my eyes. http://www.cs.nmsu.edu/atmet/Databank/root.html http://www.wam.umd.edu/~mturn/ (Mark was my ONLY non math/science/engineering instructor in nine years of higher education. A genius. He did ran a class on Classic Style ( viz. LaRouchefoucauld, et al.) http://www.wam.umd.edu/~mturn/WWW/blending.html (His work on cognitive blending deserves an award, or at least a small impervious plaque somewhere. ) http://www.reversespeech.com/index.html I don't buy this, but neither have I read it. It is simply interesting and tangentially connected to metaphor generation and usage. hth, Ross || -Original Message- || From: Hillman, Alex [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 30, 2001 4:21 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Performance tuning || || || Translation please. || || Alex Hillman || || -Original Message- || Sent: Wednesday, May 30, 2001 3:32 PM || To: Multiple recipients of list ORACLE-L || || || You have to get up pretty early in || the morning to pull the wool over || your eyes, Mr. Hillman. || || :) || || || -Original Message- || || From: Hillman, Alex [mailto:[EMAIL PROTECTED]] || || Sent: Wednesday, May 30, 2001 1:22 PM || || To: Multiple recipients of list ORACLE-L || || Subject: RE: Performance tuning || || || || || || Why putting DB in noarchivelog will avoid redo generation? || || There will be no || || archiving, but redo will continue to be generated. || || || || Alex Hillman || || || || -Original Message- || || Sent: Wednesday, May 30, 2001 10:21 AM || || To: Multiple recipients of list ORACLE-L || || || || || || Azhar, || || || || Just two thoughts off the top of my head to improve loading || || of records: || || 1. Put database in noarchivelog mode to avoid redo || generation (if || || possible). || || 2. Drop all indexes on target tables (if possible), then || || load data, then || || recreate all indexes on target tables. || || || || Jim || || || || Jim Hawkins || || Lead SAPR/3 Oracle Database Administrator || || MEMC Electronic Materials, Inc. || || 600 Pearl Drive || || St. Louis, MO 633376 || || 9636) 474-7832 || || [EMAIL PROTECTED] (work) || || [EMAIL PROTECTED] (home) || || || || || || HI ALL, || || We have to load almost 3 millions records of average row || || size of 150 || || bytes. || || We are importing data using sqloader with ROWS=4000 and || || bindsize=845 . || || We have adjusted the rollback segment to almost 10 m with || || 8 extents || || enough || || for single transaction size and considering 30% rollback || || overhead. We || || adjusted the OPTIMAL TO 10 M to have avoid rollback extension || || Rollback segment, databuffer cache have hit ratio of 100%. || || || || The loading was fast only for first 10 commits but then it || || slowed like || || snail. LOADING TOOK 22 hours in the first run on ORACLE8i || || NT4 128 megs RAM || || . || || SGA figures in M : || || NAME VALUE || || - || || Fixed Size.0676384 || || Variable Size239.02734 || || Database Buffers 39.0625 || || Redo Buffers 7.8203125 || || - || || sum 285.97779 || || ( we can't use direct path due to functions in sqlldr || || controlfile). . || || Couldn't figure out the bottleneck yet. || || Any ideas. || || TIA || || Azhar Siddiq, || || DBA || || LMK Resources || || || || -- || || 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). || || || || || || || || || || -- || || Jim Hawkins || || Lead SAPR/3 Oracle Database Administrator || || MEMC Electronic Materials, Inc. || || 600 Pearl Drive || || St. Louis, MO 633376 || || 9636) 474-7832 || || [EMAIL