RE: !!Please Read - Oracle-L is moving!!
I subscribed by the send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field method and received confirmation within an hour. David Phillips Support DBA Gasper 937-445-1382 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 3:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Give it a little time, you'll get it. Jared Arnold, Sandra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 11:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: !!Please Read - Oracle-L is moving!! I went through the webpage but never got the confirmation email back containing the code to be entered. -Original Message- Sent: Thursday, January 22, 2004 2:00 PM To: Multiple recipients of list ORACLE-L It's working for me, but slowly. I tried to do it through the webpage and got the first confirmation e-mail back (containing a code to enter on the webpage.) Then I subscribed to the new list, got a second e-mail back to confirm my subscription, and replied to that. I'm sure more things will show up shortly. One caveat though: the first response was caught by my work's spam filter and flagged as spam. -Original Message- Ron Thomas The list members must be really hammering their servers now. I've tried to sign up using both the web and email methods and have yet to receive a conformation/response. I can see the headlines now, oracle-l slashdots freelists.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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: Arnold, Sandra 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).
Software Engineer/DBA needed in Southwest Ohio
I would like to thank Jared for allowing me to post this on the list. We have an opening for a Software Engineer/DBA in southwest Ohio. Our software can use Oracle or SQL Server for the database engine. Front end is MS tools (Visual Basic, VBC++, C, C++ and .NET.) Basic information from HR is provided below. For more detailed information contact me off list at [EMAIL PROTECTED] --- Oracle DBA / Software Engineer Summary: Develops, designs, and documents computer software under general supervision. Uses skills and knowledge of company policies, procedures, services, and applications to solve a variety of problems: Works on problems of diverse scope which may require in depth analysis. Moderate to advanced working knowledge of Oracle and general programming applications. Exercises judgment within established practices and procedures to determine appropriate action: receives moderate guidance from manager. Qualifications: Four year college degree and two years related experience and/or training; or equivalent combination of education and experience. The Software engineer is expected to have a general understanding of programming concepts, system design, and a working knowledge of one or more of the following: Visual Basic, VBC++, C, C++ and .NET. The Software engineer is expected to have prior Oracle experience and Oracle DBA Certification (8i,9i). (Unix experience would be a plus.) -- David Phillips Support DBA Gasper Corporation 937-445-1382 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Phillips 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: Huge optimization costs with 9.2
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Phillips 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).
Redo Logs - Raid 1 or No Raid
Title: Redo Logs - Raid 1 or No Raid Hello all Oracle 8.1.7 Windoze 2000 Archive Mode - OLTP System Which do you think is a better set up for the Redo Logs: 2 Groups on 2 Raid1 or 4 Groups on 4 separate non-raid disks? Granted you gain fault tolerance with the mirriored pair, but is that really needed if you multiplex group members over 4 different disks? As usual we are working with clients that have limited number of disks to work, so 4 Raid1's is not an option ;) Does anyone have multiple log groups on the same physical drive(s). For example, 4 log groups, 2 members each, with group 13 on drive A, and 24 on drive B? Does this really gain you anything? Any ideas and comments are welcome. Thanks for all the help. David Phillips Support DBA
Multiple Datafiles and performance?
Oracle 8.1.7.4 Win2k What is the consensus on datafile sizing and the impact/overhead multiple datafiles have on performance? For example, if I have one 2.5g datafile, and three 1g datafiles, and I need more space, would it be better to increase the size of the 1g to 2g or add another 1g datafile?. Is it better to keep them all uniform in size? I would think having multiple datafiles that could be spread across drive volumes would be beneficial, am I wrong? (Wouldn't be the first time :) TIA David Phillips Support DBA Gasper Corp. BAARF member #30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Phillips 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: Multiple Datafiles and performance?
Thanks for the knowledge dump everyone! Based on your responses, I'll make the recommendation that our client go with 3 2.5G datafiles. They currently are 1 2.5G and 2 1G datafiles for the tablespace in question. Most of our clients have less than 30 datafiles, and I doubt will find any over 50. (slightly less than 1150 ...whew!) Index files are separated from data. The datafiles in question were data, and not index files, but they are on RAID5. We got them add 2 more RAID1's, so they are up to 4 RAID1's and 1 RAID5. We have the Indexes on a RAID1, the OS/Oracle on a RAID1, the remaining were on the RAID5, including RBS and REDO. We are moving the Redo Groups to the other RAID1's (one group on each). We could move the RBS to the OS/Oracle drive should contention is still an issue. I've been walking around with ORACLE 101 - Performance Tuning duct taped to the back of my head for about 4 weeks now trying to absorb as much as I can. It's got me looking at every change we make and it performance consequences. The number/size of datafiles was one thing I couldn't track down much info about in relation to performance. We've changed the app to increase use of bind variables, so we're making progress. (It helps that we have an Oracle DBA on each development team). We're making a lot of progress, an the info from this list and the recommended reading has played a big part in helping me get, not just changes made, but the right changes made. Now, if I could just learn to make more focused and cohesive sentences and yeh,uh what I just said. Once again, thanks for the help David Phillips Support DBA -Original Message- Sent: Thursday, August 07, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Dave, There is little about the size of datafiles to affect the performance of SQL statements, but there is much to affect the performance of backup and restore and administration. Uniform-sized datafiles simplify the administration of space. The speed of a backup or restore is a function of the largest datafile, so although files can now be sized in petabytes, it is not a good idea to do so. Personally, I stick to a max size of 2-8 Gbytes, depending on overall database size. Far faster to backup/restore lots of smaller files than to have one 500Gb monster holding things up. Also, if your storage subsystem isn't already implementing RAID-0 striping, then hand-striping multiple datafiles across volumes could help performance. Again, in that situation, many smaller uniform-sized files make the job easier than a few larger odd-sized files. Hope this helps... -Tim on 8/6/03 1:14 PM, Dave Phillips at [EMAIL PROTECTED] wrote: Oracle 8.1.7.4 Win2k What is the consensus on datafile sizing and the impact/overhead multiple datafiles have on performance? For example, if I have one 2.5g datafile, and three 1g datafiles, and I need more space, would it be better to increase the size of the 1g to 2g or add another 1g datafile?. Is it better to keep them all uniform in size? I would think having multiple datafiles that could be spread across drive volumes would be beneficial, am I wrong? (Wouldn't be the first time :) TIA David Phillips Support DBA Gasper Corp. BAARF member #30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: Dave Phillips 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: Multiple Datafiles and performance?
Gee, that question sounded a whole lot better when I wrote it yesterday than it did this morning when I saw it. :) Maybe I should be a little more vague.:) The problem is there are a couple of things I am trying to accomplish. We have clients that use our application that have specific performance issues which I am working to improve. The other issue is to provide recommendation to development/tech staff on initial setup of database/tablespaces/datafiles etc.., along with hardware recommendations for our application. So, that being said, I'll try and ask better questions. The environment is W2K, Oracle 8.1.7.2 or higher All tablespaces are LMT Most disk config's are 1 (or 2) Raid 1 along with a Raid 5 for basic systems. Most operate application 24/7 Questions: 1) Is there any advantage to uniform datafile sizes? 2) Is there any advantage/disadvantage for say 4 1G datafiles vs 2 2G. (Other than time to recover from datafile loss) It is probably safe to assume that the datafiles exist on a RAID 5. (for now) 3) Why the recommendation to take a Win2k datafile to just over 2G? For future apps I am pushing for optimal recommendations that go for more raid 1 sets or raid 10 over the Raid 5. This should allow for more flexibility for spreading out the i/o. Thanks for your patience and all the help. David Phillips Support DBA BAARF Member #30 -Original Message- Sent: Thursday, August 07, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Win2K. If you decide to increase the filesize, do it to more than 2G (doesn't have to be by much). Of course, you didn't mention autoextend so this may not be an issue. Also, just how many physical disks do you have? Logical disks are not the issue. If you're going to get any increased performance you should be putting the second datafile on a second physical disk. Any how come you're not using some sort of RAID device (or don't you have your logical drives striped across your physical drives)? There is no easy answer to your question without an understanding of the reality of your disk layout. Fermin Bernaus fbernausTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @sammic.com cc: Sent by: Subject: RE: Multiple Datafiles and performance? ml-errors 08/07/2003 08:05 AM Please respond to ORACLE-L In my experience, spreading datafiles across volumes (specially if you are careful not to locate the a table's datafiles and its indexes datafiles in the same drive) greatly increases performance. As for the file size, I can not say because I have not tested it, but I think it should have no real impact compared to splitting it. Reorganizing the database regularly is a better way to optimize performance. .. Fermín Bernaus Berraondo Dpto. de Informática SAMMIC, S.A. [EMAIL PROTECTED] http://www.sammic.com Telf. +34 - 943 157 331 Fax +34 - 943 151 276 .. -Mensaje original- De: Dave Phillips [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 06 de agosto de 2003 22:14 Para: Multiple recipients of list ORACLE-L Asunto: Multiple Datafiles and performance? Oracle 8.1.7.4 Win2k What is the consensus on datafile sizing and the impact/overhead
RE: Union quries: INTERSECT, MINUS, etc
At a previous job, I used MINUS as part of a package to perform automated testing of transaction processing. Compared actual result set with expected result set via minus. IF rows returned then if failed and returned rows were written to error table for review. Worked well for what we needed it to do. David Phillips Support DBA Gasper Corp -Original Message- Sent: Thursday, July 24, 2003 9:04 AM To: Multiple recipients of list ORACLE-L I'm doing research for an article on union queries. I'm interested in finding examples of problems that were solved using UNION, UNION ALL, INTERSECT, or MINUS, with the latter two being of special interest because I don't see them used very often. If you can think of an interesting problem you've solved using one of these keywords, I'd love to hear about it. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Dave Phillips 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).
Oracle 8i - catproc (dbms_pickler) causes end-of-file comm channel
Oracle 8.1.7.0 Windows 2000 Pro While setting a test database on one of our test servers I have encountered an error while running catproc.sql It always occurs while trying to create the dbms_pickler package. It is end-of-file comm error, which identifies TNS read/write errors incl TNS-12640 Authentication adapter initialization failed or TNS-12636 Packet send failed Trace Assist on the trace file returns with TNS-04237, but with no message available with this error code. It's not in TNS errors in doc's either. Anybody have a clue what this is or where I can track this down? Thanks David Phillips Support DBA Gasper Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Phillips 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).
Want to BAARF - Recommendations for 10 36G Drive config
A client runs our app with the following layout. Since their intial 6 drive config they have procured more drives for a total of 10 36Gig Drives. They have also upgraded memory from 1 to 4 gig. I have the opportunity to recommend changes to the current structure to improve performance. So, any recommendations from the BAARF committee are welcome. Current System Ora 8.1.7 Win 2k Size 30Gig Logical Array 1 - Raid 1 - OS and Oracle Logical Array 2 - Raid 1 - App and Index TS Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc) David Phillips Support DBA BAARF member wanna-be -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Phillips 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).
Oracle 9i vs SQL Server
Title: Oracle 9i vs SQL Server I know this topic has come up before on the list, so I hesitate to kick it again.(I hesitatedI didn't say I wouldn't :) I know there are cost issues, as well as skill set questions (do you have Oracle skills/MS skills) in house. My company has an App that runs on Ms2000 OS. (Dbase connections through ADO/OCI). It is capable of using Oracle 8i/9i or SQL Server 2000 on the backend for the database. Clients have the option, though we 'recommend' for the higher volume clients. The app receives status information from objects. There can be anywhere from 50 objects with 3 clients stations active all the way to 20,000 plus objects with 50+ client stations active. It's mainly OLTP in nature, with daily batch reporting. I'm and Oracle DBA who is learning MS SQL Server 2000 (because I'll have to support customer issues with our app.) I have confidence that Oracle will handle the load, but what about Sql Server 2000? I remember reading about read write contention issues with SQL Server, is that still a problem? What are the weakness/problem issues with SQL Server? Any opinions/comments would be welcome. TIA David P. Oracle 8i DBA SQL Server DBA in training (yuck)