RE: Oracle SAN Experiences?
David, You might find one of my whitepapers interesting: Sane SAN is the title. You can get it at: www.scaleabilities.com/whitepapers.shtml www.oaktable.net Also, you will find a paper on integrating solid state disks into a SAN, and whether that makes any sense to real sites or not. Best regards James -- James Morle Author of Scaling Oracle8i: Building Highly Scalable OLTP System Architectures
RE: WHICH UNIX FOR ORACLE?
Yes, let's not miss an opportunity to remind Evil Bill of his contribution to the wonderful world of UNIX. Xenix/286... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Boivin, Patrice J Sent: 04 April 2002 21:09 To: Multiple recipients of list ORACLE-L Subject: RE: WHICH UNIX FOR ORACLE? How about XENIX? : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 04, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: WHICH UNIX FOR ORACLE? I'm very suprised no one has said Linux. ?? It is one of the first tier platforms for Oracle now, isn't it? I also thought I read on this list a while back that Solaris was no longer the dev platform? Guess it all depends on what strengths you are looking for. For my employer, who is CHEAP, it was Windows. Who cares that it's not as stable as I would like. You should have seen the VP grin at me with this patronizing smile when he said, I'll approve $35,000 for this project!, like he had done me a huge favor. I wanted to growl. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: James Morle 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: ORA-00600 error
Title: Message Bunyamin, It's bug id 2177050. The bug report talks about temp tables, but that's a red herring really - it happens without temp tables being used. Cheers James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bunyamin K. KaradenizSent: 04 April 2002 09:23To: Multiple recipients of list ORACLE-LSubject: Re: ORA-00600 error Yes I am running 8.1.7.3 .. Is this a bug ? What will I do then? Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 03, 2002 9:33 PM Subject: RE: ORA-00600 error Are you running 8.1.7.3? This is a known bug, with a patch available. Regards James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bunyamin K. KaradenizSent: 03 April 2002 18:21To: Multiple recipients of list ORACLE-LSubject: ORA-00600 error Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
RE: Oracle on Linux articles
I have to strongly disagree with the 'bigger is better' methodology of this article! For example, allowing 100% of the Linux buffer cache to be dirty, then only running a 5 second load pretty much guarantees that very little physical I/O was performed. The author is also misinformed about the workings of the log buffer, and the interaction of Oracle blocksize with the filesystem block size. In some ways, though, I agree with the subtitle: Gladiator-like performance. In this case, the Gladiator runs faster than any man alive, until he reaches the wall of the amphitheater, where he has to stop and be eaten by the lion after all ;-) James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Marin Dimitrov Sent: 12 March 2002 12:33 To: Multiple recipients of list ORACLE-L Subject: Oracle on Linux articles Linux Maximus, Part 1: Gladiator-like Oracle Performance - http://www.linuxjournal.com//article.php?sid= 5840 Linux Maximus, Part 2: the RAW Facts on Filesystems - http://www.linuxjournal.com/article.php?sid=5841 (the discussions after the articles are quite interesting too) hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: James Morle 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: Oracle on Linux articles
Hi Steve, The author is also misinformed about the workings of the log buffer, and the interaction of Oracle blocksize with the filesystem block size. I didn't see any discussion of this in the article. ? This is two separate issues: a) log buffer - this was discussed insofar as 'open it up really big', and b) block sizes - this was implied from his not understanding the reasons for the larger block sizes not making a bigger difference. Could you briefly explain your understanding of the workings of the log buffer and the interaction of Oracle blocksize and filesystem block size? Yes, no problem: Log buffer: The log buffer flushes under certain conditions; an explicit commit, buffer 1/3 full, or every 3 seconds if one of the former conditions has not occurred. In the case of the online transaction, the former case will have always been true for a TPC-C transaction. For the load, either the former or secondary condition will have always been true, depending upon the loading code. At no point in the article did the author suggest a rationale for any of the tuning actions, and this was a classic example. A useful datapoint at this stage would have been how long the sessions were waiting for space in the buffer compared to log file switching time, compared to physical I/O time. I would suggest that a far more significant gain in performance would have been gained from much bigger log files, and a relatively small log buffer. Oracle blocksize vs FS blocksize: The author noted a large improvement going from 2KB to 4KB blocks. He fails to mention that the block size of the filesystem (assuming default ext2) is 4KB. This is far more significant, both from the standpoint of 2KB-4KB and 4KB-8KB Oracle blocksizes. In the 2-4 case, the system was issuing twice as many system calls under 2KB blocks for the same number of physical reads as the $KB case. In the 4-8 case, the system was having to break open each I/O call into two physical reads/writes, because the filesystem block size is the only unit of I/O. So, if the filesystem had a blocksize of 8KB, the gain at 8KB would have been more significant. All this discussion completely ignores the other efficiency gains with larger blocks, especially inside Oracle. Without seeing any Oracle wait events (again), it's all pure speculation as to where the real bottlenecks moved to! Really, the thing that went against the grain was the 'tuning in a vacuum' approach of the author. It's so unnecessary to do when there is so much instrumentation available. Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle 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: Oracle on Linux articles
or secondary condition will have always been true, depending upon the loading code. At no point in the article did the author suggest a rationale for any of the tuning actions, and this was a classic example. A useful datapoint at this stage would have been how long the sessions were waiting for space in the buffer compared to log file switching time, compared to physical I/O time. I would suggest that a far more significant gain in performance would have been gained from much bigger log files, and a relatively small log buffer. Oracle blocksize vs FS blocksize: The author noted a large improvement going from 2KB to 4KB blocks. He fails to mention that the block size of the filesystem (assuming default ext2) is 4KB. This is far more significant, both from the standpoint of 2KB-4KB and 4KB-8KB Oracle blocksizes. In the 2-4 case, the system was issuing twice as many system calls under 2KB blocks for the same number of physical reads as the $KB case. In the 4-8 case, the system was having to break open each I/O call into two physical reads/writes, because the filesystem block size is the only unit of I/O. So, if the filesystem had a blocksize of 8KB, the gain at 8KB would have been more significant. All this discussion completely ignores the other efficiency gains with larger blocks, especially inside Oracle. Without seeing any Oracle wait events (again), it's all pure speculation as to where the real bottlenecks moved to! Really, the thing that went against the grain was the 'tuning in a vacuum' approach of the author. It's so unnecessary to do when there is so much instrumentation available. Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: James Morle 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: Linux for Big(ish) Databases
Bill, In general terms, I would say that it is certainly suitable. That answer is based upon the information you provide below. The real answer could only be ascertained by evaluating other requirements: A) Availability B) Scalability C) 'Cost' of each user - what do the transactions look like Don't fall into the trap of treating the machine as a PC - many implementations of Linux/Oracle apply the cost-reduced approach all the way across the system. You save money on the server and OS, but you should still make sure your I/O requirements are well catered for. From a CPU standpoint, you are probably more than OK. A quad Xeon machine has more power than you need in all likelihood (again, APPLICATION DEPENDENT - a single user can suck down 4 Xeons if they want to...). Memory, no problem - 4GB should be more than enough, and Linux is pretty well proven up to this level. The big downsides are thus: A) PCI bus bandwidth. Unless you go for a system with multiple PCI buses (they are available, but I've not personally run Linux on one of these), you are limited to a maximum theoretical bandwidth of width*clock: 33MHz * 32-bit= ~132MB/s, 66MHz*64-bit= 528MB/s. B) Crash Dumps. If you hit an OS problem, who do you go to, and what do you give them? C) Memory bandwidth. RDRAM or at least DDR memory solutions should be used where possible. This is where the P4 is actually worth considering. Forget all the 'extensions' stuff, though - Oracle is pretty much a pure INTEGER compute load. The thing you get that's worth having with the P4 is 400MHz front side bus - Memory Bandwidth! I would recommend, in the complete absence of any real workload knowledge ( ;-) ) to go for a 2-way P4 system based upon the ServerWorks GC-HE chipset. Something like the Dell PowerEdge 4600. This will give you a) memory bandwidth more balanced against the CPU power, b) lots of PCI bandwidth. Hope that is of use. Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Buchan Sent: 04 March 2002 10:18 To: Multiple recipients of list ORACLE-L Subject: Linux for Big(ish) Databases We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan 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: James Morle 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: Korn Shell Q
eval foo.sh $FOO Should do the trick... -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Post, Ethan Sent: 06 March 2002 19:23 To: Multiple recipients of list ORACLE-L Subject: RE: Korn Shell Q No that did not work, thanks. I remember the command I am more specifically looking for, it is a command that says to do expansion twice on a line, anyone remember what this is? basically if you have a variable that looks as follows echo $FOO -g dba apps the double quotes will get exanded another time so they are picked up correctly when you call foo.sh $FOO - Ethan -Original Message- Sent: Wednesday, March 06, 2002 12:32 PM To: Multiple recipients of list ORACLE-L Ethan, I had a similar problem when using the getopts command when using it in conjuction with nohup and the . I found by throwing ksh in the syntax everthing worked. i.e. nohup ksh setup.ksh -a parameters This may or may not work for you but it's worth a try. Scott -- 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: James Morle 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: Old Chestnut: Tablespace Fragmentation
Your best best is to quantify this mathematically. Take the following example: Case 1: 100GB table, one extent Case 2: 100GB table, 1000 extents Assume: a) track to track seeks are 'free' b) random seeks are 20ms c) Block size is 16KB d) db_file_multiblock_read_count=16 e) multiblock read time=8.6ms (29MB/s conservative for 10k drives) f) total # reads=409600 g) one drive only (a very big one...) Case1: Time for FTS= 409600*8.6ms=3522s (~ 1 hour) Case2: Time for FTS= 3522s (as above) PLUS 1000*20ms= 20s - TOTAL=3542s The difference is minor in this case (0.5% greater elapsed time) and 1000 extents would put each at ~100MB in this case. If you had cue Dr. Evil voice 1 million extents, it would be a different story - about 668% longer... Hope that helps - there's an infinite number of shades of grey, so it's important to do the math! Regards James Bill Buchan wrote: I know this one has been done to death: use uniform extents to avoid fragmentation; multiple extents don't hurt (within limits). But what if: Data Warehouse, one big table on a single disk, full table (batch) scan, no concurrent transactions on the database (so no contention for the disk), no fragmentation at the file system level, initially empty buffer cache (startup), read-only operation so DBWR isn't doing anything on this disk. Basically I want to read one data file from end to end. Surely it would make sense to have the disk read moving smoothly from one end of the disk to the other rather than bouncing about all over the place as it may do with multiple extents randomly allocated. Any thoughts? Thanks - Bill. -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle 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: Linux Cluster
I'm also running it on two Vmware machines running Linux on my laptop. I'm currently working on a 'real' cluster, using a mixture of SMP linux boxes on a shared SCSI array. Two nodes, no problem. Three nodes, big problem. I believe it still to be electrical on the SCSI bus, so watch this space. If you have a choice, use FC, preferably switched! Oracle version: 9.0.1.2 Is it fun? I always say - If you really want to learn about how Oracle instances work, run OPS. I don't say that anymore, because they changed the name to RAC. But that's the only change to the saying. I love it though, it's loads of fun, but very much in a masochistic way. In the particular case of Linux, if anyone worked on any big multi-node OPS configurations about ten years ago, you have a good idea of what it's like now on Linux Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Henrik Ekenberg [EMAIL PROTECTED] Sent: 22 February 2002 15:03 To: Multiple recipients of list ORACLE-L Subject: Linux Cluster Hi from the Swow storm from Sweden, We wants to try to run Oracle on a Linux Cluster. Is someone using Oracle on a Linux Cluster ? Who is your configuration ? 1- (DELL,HP,Compaq,..) 2- Which Linux version ? 3- Which Oracle version ? 4- Is is fun ? Best Regards, HEnrik -- -- - There's fun in being serious. -- Wynton Marsalis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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: James Morle 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: [Fwd: UNIX Performance Issues]
Title: Message Rahul, Did you get a response on this? I'm not sure I fully understand the actual question - are you looking for specific commands you need to run to get the information, or advice on how to interpret it? Don't forget that you will really need to correlate many of these statistics to the Oracle pathology at the same time. This then causes a problem because your sample points will at the very least experience clock drift and become harder to compare over time. There are ways to solve it, though. Anyway, if you could elaborate a little, I can try to assist! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 22:11To: James MorleSubject: [Fwd: UNIX Performance Issues]Hi James,I've got no idea whether this is of interest or not to you, but you probably know a bit about this topic.Mogens Original Message Subject: UNIX Performance Issues Date: Thu, 14 Feb 2002 07:43:26 -0800 From: "Rahul Dandekar" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]DBAs, This might be littlebit (or completely!) UNIX related... But I am told to do the performance analysis of some 10-15 machines and generate some statistical data to find out bottlenecks and identify areas of tuning... Operating System : Solaris 2.6 I have been using sar, iostat, top... I actually plan to script these things and run these scripts at certain intervals and put the data in database (Oracle 8i) and then do the crunching... Inputs are appreciated... 1. I/O What is current I/O status. Is there a lot of I/O going on? 2. Paging Is there lot of swapping / paging happening? Which processes are getting swapped in/out continuously? Are the I/O waits due to swapping / paging or regular stuff like DB waiting to read from DB files? 3. CPU What is the CPU utulization? Which processes are using lot of CPU? 4. Memory What is the current picture of Real and Virtual Memory? What processes are using how much memory? Which processes are i n real memory and which are in virtual memory? Which processes are swapped in and out from/to real/virtual memory and how many times? 5. Network What is the percentage utilization of network pipe? What is the capacity (bandwidth) of the network device? What percentage of that bandwidth is getting used? Is the system waiting for data from outside network I/O? In short, is there any bandwidth problem with network device or network traffic. Thanks, ___ ______ ___ ___ / /\ / /\ / /\ / /\ / /\ / /::\ / /::\/ /:// /:// /:/ / /:/\:\ / /:/:| / /:// /:// /:/ / /::\ \:\ / /:/|:| / /::\ __ / /:/ ___ / /:/ /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/ / /\ /__/:/ \__\/~|::\/:/ \__\/\:\:| \__\/ \:\/:/ \ \:\ / /:/ \ \:\ | |:|::/ \__\::| \__\::/ \ \:\ /:/ \ \:\ | |:|\/ | |:| / /:/ \ \:\/:/ \ \:\ |__|:| |__|:| /__/:/ \ \::/ \ \:\ \__\| \__\| \__\/ \__\/ \__\/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar 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: Where does a DBA go from here?
Mogens is using a new type of aircraft from the other large Seattle company That's why it takes 10 times longer... ;-) -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rachel Carmichael Sent: 19 February 2002 12:38 To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Mogens, Are you sure you have that time scale right for the flight times? I seem to recall it took me a mere (!) 24 hours to return to NYC from Brisbane. and I am jealous and longing to go to this class as well. sigh.. Rachel --- Mogens Nørgaard [EMAIL PROTECTED] wrote: Yeah, we're doing the Forum on 27-28 of May (confirmed) and we'll do a Miracle Master Class with Jonathan about 5-6 weeks later. Apart from the 200-250 hours flight time to get there, it should prove fun. Let's have a Fatcity Oracle-L party while we're there, shall we? Mogens Suhen Pather wrote: Sujatha, Just spoke to Peter Bach, Miracle AS , Australia The forum dates are not confirmed yet but it will be towards the end of May. Once he has the dates confirmed he will post it on the Miracle website. You can call him for more info, the numbers can be obtained from the Miracle AS website. It should be a great training to attend with lots of big names from the industry. He says that Jonathan Lewis will also be doing a training course (seminar) in Australia similar to the one on his website (JLCOMP). Regards $uhen Where can I get more information about this Database Forum in Sydney ?? Cheers, Sujatha -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 February 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: Where does a DBA go from here? Time for some real marketing here :-). Jonathan Lewis, Cary Millsap, Anjo Kolk, Steve Adams, Bjorn Engsig, James Morle and a few others will be the main speakers at the Database Forum we're doing in Sydney in late May. A couple of days with these guys should prove fun and educational. These days we even have an informal organisation called The OakTable Network ( www.OakTable.net http://www.OakTable.net ) which, for instance, will have a booth at Oracle World in Copenhagen in June where you can ask anything you like, sit around my oak table, and drink beer (well, maybe not that :) ), listen to mini presentations by the guys, and so on. EoM (End of Marketing). PS: We'll also try to build the worlds biggest laptop RAC cluster. That's proving a challenge. So far, we've managed to run two nodes on the laptops, but then it becomes harder - much harder. But James, Jonathan and Bjorn are working on it. Wouldn't it be fun if anybody could bring their laptop, plug it in, be part of the RAC thing for some minutes, and then get a certificate stating that the person participated in the worlds biggest, etc...? Mogens Greg Moore wrote: Now where do I go for more Oracle training? Consider looking at the web sites of the Oracle DBA's who are up on the latest techniques. They sometimes teach advanced classes. Craig Shallahamer (www.orapub.com http://www.orapub.com) offers an advanced class, as does Cary Millsap. Steve Adams recently taught a class in San Francisco. Tim Gorman may give advanced classes. The latest and best thinking seems to appear first in papers that are freely available, and then later appears in books and classes. These four DBA's offer papers like that on their sites, and link to other sites with more of the same. After a certain point you have to turn to quality books, papers and conferences. If it's classes you want, a clever move might be to take some UNIX or Windows system administration ones, to broaden your skills into some new area like that. __ 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
RE: [Fwd: UNIX Performance Issues]
Title: Message Rahul, Here's what I would do. 1) I would use "mpstat" for the processor statistics. This breaks the usage up by processor in SMP configurations. This can be useful to see the relative loading of each CPU, in particular the breakdown of kernel and user time. 2) Memory: Concentrate on Page Outs and Free Memory more than anything else. That will give you plenty of clues about memory starvation, and the relevence of your VM tuning. 3) I/O: User "sar -d". It's a bit annoying on a system with a lot of disks, because it returns a row for every device, even if no I/O occurred in the sample period. However, it makes it easier to parse. ;-) Notably, keep an eye on the Service Times (avserv?), Wait times (avwait), and the queue depth. The utilisation is a function of these (queuing theory), but you can store that too as a shortcut. You can give sar any sample period, so your 5 minute averages are no problem. 4) Network: "netstat 5" will report a row for every 5 seconds (for example), showing how many packets went in and out of each interface. Your question below is easily answered - you have two columns in your output; the first is for the named interface (hme0), the 100baseT network card. The second is a total of all cards - looks like you only have one. This total can also include the loopback interface (lo0), so look out for that. Good luck, you're doing the right thing. I've been working on some software to do just this for a couple of years. I'd love to hear how it goes! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul DandekarSent: 19 February 2002 12:59To: Multiple recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance Issues] James, Interleaved, please find my reply +Rahul - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 6:03 AM Subject: RE: [Fwd: UNIX Performance Issues] Rahul, Did you get a response on this? I'm not sure I fully understand the actual question - are you looking for specific commands you need to run to get the information, [Rahul] Yes. I would like to know which flags of the commonly used commands give good information. For general System stats, I use "sar -u" (same as default), for Memory / Virtual Memory I use "vmstat" and look for "r b w swap free pi po us sy id" columns. I am looking for general monitoring. And once we have this general information giving a overall picture, we could know if there is a problem and we could investigate further. I am specifically looking for IO and Network statistics. Is there any command which would give me approx IO of the system, say in last 5 minutes or current? How to get network statistics? I was littlebit confused with netstat. There are two main categories in my output : hme0 and Total. What does that mean? input hme0 output input (Total) outputpackets errs packets errs colls packets errs packets errs colls5757291 0 2447690 0 0 6071152 0 2761551 0 045 0 1 0 0 45 0 1 0 024 0 2 0 0 24 0 2 0 0 What I plan to do is to take snapshot of all these statistics at acertain frequency and put it in database.Later on I could generate reports based on this. Currently, I have a lot of "Camera"s like thistaking snapshots of my system. Others involveOracle stuff like DB Size Growth, Performance Ratios,UNIX File System usage, Replication Statistics, Growth of DB objects, a lot of monitors for application info (e.g. total # of clients, # of invoices generated per day). I generate trends based on this archival data for capacity planning and proactively anticipating chronic problems. or advice on how to interpret it? Don't forget that you will really need to correlate many of these statistics to the Oracle pathology at the same time. You said it! I want co-relation of Application Load, UNIX System Load and Database Statistics. And not just when the problem arises. So, that's what I am trying to develop. This then causes a problem because your sample points will at the very least experience clock drift and become harder to compare over time. There are ways to solve it, though. Anyway, if you could elaborate a little, I can try to assist! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Orig
RE: [Fwd: UNIX Performance Issues]
Title: Message
Hi Rahul.
Interesting, as ever!
See below
James
--James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor
of "Scaling Oracle8i - Building Highly Scalable OLTP System
Architectures"
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Rahul DandekarSent:
19 February 2002 15:49To: Multiple recipients of list
ORACLE-LSubject: Re: [Fwd: UNIX Performance
Issues]
James,
Getting interesting, isn't it? I have added my
response...
- Original Message -
From:
James Morle
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, February 19, 2002 8:58
AM
Subject: RE: [Fwd: UNIX Performance
Issues]
Rahul,
Here's what I would do.
1) I would use "mpstat" for the processor statistics.
This breaks the usage up by processor in SMP configurations. This can be
useful to see the relative loading of each CPU, in particular the breakdown
of kernel and user time.
2) Memory: Concentrate on Page Outs and Free Memory
more than anything else. That will give you plenty of clues about memory
starvation, and the relevence of your VM tuning.
3) I/O: User "sar -d". It's a bit annoying on a system
with a lot of disks, because it returns a row for every device, even if no
I/O occurred in the sample period. However, it makes it easier to parse. ;-)
Notably, keep an eye on the Service Times (avserv?), Wait times (avwait),
and the queue depth. The utilisation is a function of these (queuing
theory), but you can store that too as a shortcut. You can give sar any
sample period, so your 5 minute averages are no
problem.
How can I get the current I/O load on the system? I don't know
exactly what metric I am looking for.
But I want to establish some baseline metric for each machine
and then hunt for spikes from the
gathered data. The metric can be "I/O load on system bus in
Mb/sec" (like the netstat info packets
input and output). I don't want individual disk statistics. I
just want a overall number, which I
can snapshot.
I know what you're after, but it's just not going to work that way! A
network adapter is a single serial resource with a finite limit. An I/O
subsystem is an arbitrarily complex *set* ofresources with a
finitecapacity on each! For example,
if you were to just measure the aggregate I/O rate across your SAN (or
whatever), that may well return a good number. However, one disk in there
could be assuming 50% or more of the load due to hotspots. This disk would
probably be providing multi-SECOND response time, and because it's the hot
disk, will be slowing nearly everything down. Your aggregate stats would not
show this. You need per-disk, per-controller, and if you've got a very busy
system you might want to start worrying about backplane capacity. There's no
easy way to measure that one,
however.
4) Network: "netstat 5" will report a row for every 5
seconds (for example), showing how many packets went in and out of each
interface. Your question below is easily answered - you have two columns in
your output; the first is for the named interface (hme0), the 100baseT
network card. The second is a total of all cards - looks like you only have
one. This total can also include the loopback interface (lo0), so look out
for that.
If I have only one card then why the
total and hme0 data are different (by about 10%)?
I suspect it is reporting the lo0interface in the total, but not showing it individually. Check
out the options for netstat (I don't have Slowlaris in front of me right
now).
Good luck, you're doing the right thing. I've been
working on some software to do just this for a couple of years. I'd love to
hear how it goes!
+Rahul
Regards
James
--James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor
of "Scaling Oracle8i - Building Highly Scalable OLTP System
Architectures"
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul
DandekarSent: 19 February 2002 12:59To: Multiple
recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance
Issues]
James,
Interleaved, please find my
reply
+Rahul
- Original Message -
From:
James Morle
To: Multiple recipients of list
ORACLE-L
Sent: Tuesday, February 19, 2002
6:03 AM
Subject: RE: [Fwd: UNIX Performance
Issues]
Rahul,
Did you get a response on this? I'm not sure I
fully understand the actual question - are you looking for specific
commands you need
RE: Email -- DB (export/parse)
I believe Netscape have a utility to convert Outlook datafiles to 'mbox' format, which is more easily parsed. James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Walter K Sent: 19 February 2002 16:18 To: Multiple recipients of list ORACLE-L Subject: Email -- DB (export/parse) Hi, Does anyone know of a utility that would allow me to export email, from say Outlook or Outlook Express, directly to a database or to a flat file (delimited) for import into a database? It doesn't need to be fancy, basically just date/time, to/from, subject, body. Thanks. -w __ 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: Walter K 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: James Morle 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: Fw: Just got back from SQL*Server 2000 training...
See below... Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. JS: 10+GB over the network is trivial. If you are using anything that approaches enterprise level backups, you will dedicate some fast pipes to your network attached tape system. This means that if you're using for instance Tivoli with a StorageTek Tape Silo,you must copy it first to disk, since you're not going to have direct access. Making backups to disk first tends to break any Oracle specific tape cataloging system ( RMAN for instance ) so that files must be located manually in case of a restore. I think the real key is that the value of 10GB is quoted as an extreme example! Just affirms my opinion that SQL-Server is where Oracle was over 10 years ago James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle 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: Oracle Archiving insanely
Could it be a backlog in the online logs? The arch process(es) would still have to catch up, even if the job had long since finished. If you suspect it to be a current session, check the sesstats for 'redo size' for all the sessions. If one session is guilty of this, it will be immediately obvious. James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of K Gopalakrishnan Sent: 04 November 2001 14:35 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Archiving insanely By any chance HOTBACKUP is turned on? Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Sent: Sunday, November 04, 2001 6:00 AM To: Multiple recipients of list ORACLE-L H All, I am facing a very typical problem. One of my client's database has suddenly started archiving like mad. There is no change ( claimed by users) made to the database. I checked Alert log, but could not find anything. Many times it generates up to 50 Mb of Archives per minute( Earlier max upto 2-3 Mb/Min). I did shutdown immediate, which took around 15 min ( acceptable), but immediately after next startup (with no user logged on), in next 3 minutes, it generated 100 Mb of Archives ( how'z that possible) ??? How can I find out what is the thing that's causing such a massive load on database. There is no hotbackup going on. There is no Oracle scheduled job running. On OS side also there is no scheduled job in cron. Please suggest how to get down to the problem. How can I find out which session/user is generating so much of Redo? What possible preventive measures can I take??? We are on Oracle 8.1.6.0.0 on TRU64 Unix. Appreciate your suggestions and immediate help, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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: James Morle 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: Internal error code problem
Shankar This is not an error caused directly by your package. It is an internal Oracle error, otherwise known as a BUG. The first argument normally gives a clue as to what is going on, and a further investigation of the stack trace in the trace file shows which area of the code this is in. In this case, it looks to be an error encountered in one of the kernel routines that build a consistent read block in the buffer cache. You need to either search metalink or log a TAR with support. Support will be able to advise you on a workaround or the availability of a patch set for this problem. James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ramasubramanian, Shankar (Cognizant) Sent: 30 October 2001 12:46 To: Multiple recipients of list ORACLE-L Subject: Internal error code problem Hi friends, I am running a package in my application and i got the following error message . ORA-00600: internal error code, arguments: [kcbgtcr_4], [], [], [], [], [], [], [] Can anyone throw up some points on this , basically what would have went wrong. Thanks in advance Shankar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle 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).
