RE: [***SPAM***] - measuring TPM - Found word(s) to be removed remove list e-mail in the Text body.
Logminer has been of use in looking at past activity as far as INSERT/UPDATE/DELETE and then COMMIT;. Looking at a day of lofs we have been able to measure activity to all of our tables, indexes and queues and as been very helpful in giving us infor we need for future capacity planning. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 8:29 AM To: Multiple recipients of list ORACLE-L remove list e-mail in the Text body. I've been asked to provide value for the Transactions Per Minute going through our primary OLTP production database. I believe I can use deltas in SCN values to measure transactions which do INSERT/UPDATE/DELETE and then COMMIT; Is there any way to measure/count the number of SELECTs which occur? If so, how? How would you derive a value for TPM for your DB? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Tony Johnson 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: [***SPAM***] - Re: Upgrading to Oracle 9.2.0.4 - Any pitfalls? - Found word(s) to be removed remove list error e-mail in the Text body.
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao 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: Tony Johnson 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: [***SPAM***] - Cobol redefine in SQL - Found word(s) to be removed remove list error e-mail in the Text body.
I went thru a conversion like this many moons ago but was to DB2 and not Oracle but in the end was the same. We looked at each and decided what needed to be defined as a seperate table ( ie the key and redefined portion became a table) and others where we had the key and a large binary field that contained the redefined data. The basic rule was if the data in the redefined could be joined to other data to make the application more functional and give us long term benefit for being able to access the columns via SQL then we broke it out. If the redefined portion was mainly used for internal processing and would not be joined to and would only be accessed via the COBOL programs we left them as is. Now, that was the easy part. Getting and defining and setting up each table and getting agreement on what went where wasnt as simple. In the end it worked out and worked out pretty well. -Original Message- Stephane Paquette Sent: Wednesday, November 26, 2003 2:34 PM To: Multiple recipients of list ORACLE-L removed remove list error e-mail in the Text body. Hi all, We'll do a conversion from IMS to Oracle (817). The conversion team wants to move data on Oracle then processed it. Off course, in the file format, the cobol redefine command is used on a filler field (20 times). There is also a redefine command in a redefine command. For the younger ones, it means a zone (50 caracters) that can be defined in many ways depending on a key : 2 fields of 25 char or 5 fields of 10 char or The programmers can always use substring to death to work this out but I was wandering if there was a more elegant and a less error prone solution, maybe using a record type or a function ... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Tony Johnson 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: [***SPAM***] - Experiences with Oracle and MS .Net data providers - Found word(s) to be removed remove based list e-mail in the Text body.
We are using the latest ODP.net provider and up until we upgraded to 92040 had few and minor problems with it. Mostly it was differences between all of the different drivers that our programmers were using based on either the cycles of the moon or which team won the World Series. Since we went to ODP.NET things are much smoother and I dont hear any complaining about things WAY out of my control. When we upgraded to 92040 something changed where one column in one database is now appearing to have a different numeric format than prior to the upgrade. I think that there is this issue with this one column(which is set up in a way that I cant recreate ) and we will fix it soon but overall it is working very well. -Original Message- Sent: Monday, November 24, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Hi all, Would really like to hear any feedback regarding anyone comparing these two .Net data providers (or even some of the others out there - Datadirect, etc.). We're at decision making time, and things like the differences in calling stored procs, returning Ref Cursors, are starting to mean we need to pick one. My gut says go with the Oracle one (keep the technology stack based on the one vendor), but they kludge too many things. (just like in ADO, where they ignored the standard for stored proc calling). Anyway, any comments about your use, likes and dislikes of either would be much appreciated. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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: Tony Johnson 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: Valid Packages/Procedures/Triggers that are NOT
We have been seeing this ever since we went to 9i and in multiple calls to Oracle support they have not been of much help. Most of the time we get an error dump in udumo and things go on there merry way. A couple of times the packages go invalid and wont work but when looking at them thru OEM or other ways they all appear to be vaild. We do a complete recompile of everything and we are back up and running. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Tuesday, November 25, 2003 12:34 PMTo: Multiple recipients of list ORACLE-LSubject: Valid Packages/Procedures/Triggers that are NOTWe had a weird situation yesterday on a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being in production for a day and a half, 93 previously VALID packages, package bodies, triggers and procedures went INVALID. We have not been able to figure out what made them go invalid (they were all in the same application schema). Anyway, we recompiled all objects and all were then marked as VALID. However, some of the code still failed to work; (as an aside, we narrowed it down to those packages that contained ref cursors). Since the packages were apparently VALID, we did not recompile them again until after we bounced the database and generally chased our tails for a couple of hours. In a last-ditch effort, we recompiled all the objects again and the code started working. Do any of you know of a bug in 9i that would cause an INVALID package to be marked VALID? Or, when is a VALID package really INVALID? Thanks for your input. Vicki PierceDatabase Administrationx2401
RE: [***SPAM***] - Re: Valid Packages/Procedures/Triggers that are NOT - Found word(s) to be removed remove home list error e-mail in the Text body.
The original problem is that packages go invalid in the middle of the day with no upgrading going on, no physical changes happening in the database, nothing happening except the normal day-to-day operation of the system. We have seen this happening since 8i. We recently upgraded to 92040 and I have seen it once in the last week where it produced a dump - I dont know how many times it happened where no dump was produced. In 92021 we could see it multiple times in a day. There is a problem out there that Oracle can't seem to recreate. -Original Message- Mladen Gogala Sent: Tuesday, November 25, 2003 1:44 PM To: Multiple recipients of list ORACLE-L NOT - Found word(s) to be removed remove home list error e-mail in the Text body. Victoria, there is a whole slew of bugs with upgrade and patch application. Here are two of them: Patch 3099699 Description REPCA: CATPATCH LEAVES RDBMS UNUSABLE (INVALID OBJECTS IN, LBACSYS [OLS]) Patch 2949941 Description RULES ENGINE OBJECTS BECOME INVALID AFTER UPGRADE There are quie a few others, not listed here. There was probably a SYS-owned object left invalid during upgrade, which caused dependency problems. Solution is to upgrade to 9.2.0.4 now that you've already upgraded to 9.2.0.1 and run $ORALCE_HOME/rdbms/utlirp to recompile all invalid objects in the database. It's always advised to so after any upgrade or patching of the database. On 11/25/2003 02:34:29 PM, [EMAIL PROTECTED] wrote: We had a weird situation yesterday on a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being in production for a day and a half, 93 previously VALID packages, package bodies, triggers and procedures went INVALID. We have not been able to figure out what made them go invalid (they were all in the same application schema). Anyway, we recompiled all objects and all were then marked as VALID. However, some of the code still failed to work; (as an aside, we narrowed it down to those packages that contained ref cursors). Since the packages were apparently VALID, we did not recompile them again until after we bounced the database and generally chased our tails for a couple of hours. In a last-ditch effort, we recompiled all the objects again and the code started working. Do any of you know of a bug in 9i that would cause an INVALID package to be marked VALID? Or, when is a VALID package really INVALID? Thanks for your input. Vicki Pierce Database Administration x2401 Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Tony Johnson 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: what is oracle rdb?
RDB was bought from Digital Corporation many years ago. Supposedly a lot of the CBO was lifted from it. -Original Message- [EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:49 PM To: Multiple recipients of list ORACLE-L I see it referred to on metalink alot. I know its seperate from the rdbms. -- 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: Tony Johnson 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: [***SPAM***] - 9i on Win2k Cluster - Found word(s) to be removed remove list e-mail in the Text body.
Download the Oracle Failsafe for MSCS from OTN. It's all in there ... -Original Message- Sent: Monday, November 10, 2003 3:34 AM To: Multiple recipients of list ORACLE-L removed remove list e-mail in the Text body. Hi, does anybody out there have a paper that describes how to set up 9i on a Win2k cluster? We need to test the cluster capabilites fo the database. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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: Tony Johnson 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: [***SPAM***] - Re: Two New Books On Larry - Found word(s) to be removed remove money free list error e-mail in the Text body.
Journal, 11/7/2003, Review/Books page W8 I opened my WSJ this morning and found a review of these two books on Larry. Everyone Else Must Fail by Karen Southwick Sofwar by Mathew Symonds The reviews were very interesting. This is the print version of the WSJ. The reviews may be available on the on-line WSJ but you have to subscribe to it (not free). My $0.02 worth, Ken Janusz, CPIM Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Tony Johnson 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: dba interview questions - Found word(s) to be removed remove free list error email e-mail in the Text body.
Actually, the only important question is How much do you want ? Oh, for the good old days ... Seriously, Mike Ault had a list of questions once which may be a little dated now but would be a good staert. Perhaps on www.tusc.com where he used to work at. Mike ? -Original Message- Sent: Thursday, October 23, 2003 2:14 PM To: Multiple recipients of list ORACLE-L be removed remove free list error email e-mail in the Text body. 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Tony Johnson 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: Oracle Performance Software from Veritas
This is the renamed Precise Software tools they bought earlier this year . -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: FW: Oracle Performance Software from Veritas Just got this email from Veritas...apparently they are getting into the database performance business for Oracle (and SQL Server too I think). Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions "the most trusted source for STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system.Thank you. -Original Message-From: VERITAS Software [mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 2003 3:40 PMTo: David WagonerSubject: Trial Software for Oracle environment Do something about it. Download a free trial of VERITAS Indepth(tm) for Oracle. Easier said than done. Usually it's difficult, if not impossible, to pinpoint the root cause of performance slowdowns. Countless hours are spent troubleshooting and analyzing applications with few results to show for it. That's about to change. With VERITAS Indepth for Oracle, you can identify specific application bottlenecks, resolve them faster, and maintain promised service levels to users. Download VERITAS Indepth for Oracle to see how you can: Monitor the Oracle environment continuously and capture performance data for current, short term, and long-term performance analysis. Drill down and identify a performance problem caused by a resource bottleneck or a poorly written SQL statement. Resolve performance problems faster with detailed steps and displays statistics relevant to each step in the Oracle access path. Download Now Why we contacted you and how to opt-out: We know your time is valuable and that we (and others) are placing increasing demands on it. We contacted you about this news because we believe that the content of this message would be interesting and valuable to you. If you do not wish to receive future VERITAS notifications, please click on the link below, and send us the e-mail: mailto:[EMAIL PROTECTED] Please review our online Privacy Policy and Terms of Use. © Copyright 2003 VERITAS Software. All rights reserved. VERITAS Software, 350 Ellis Street, Mountain View, CA 94043, United States.We welcome your comments. Send email to [EMAIL PROTECTED]
RE: EMC striping question
Why worry about how it gets written. The cache will make any implementation sing like a bird. And if you think you are having problems just add more cache and that will take care of it. - As told to us by a past EMC Sales Weenie -Original Message- Sent: Friday, October 03, 2003 6:50 AM To: Multiple recipients of list ORACLE-L Hi All, Today I saw an archived thread on orafaq about striped volumes in an EMC Symmetrix. Gaja mentioned that writing to a striped volume is performed in a sequential fashion i.e. spindle B will not start writing block 2 before spindle A has completed writing block 1. Is this still true for a Symmetrix with 5568 firmware? Perhaps it's a better idea to let the OS handle the striping? Regards, Hans de Git _ Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hans de Git 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: Tony Johnson 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: Steps to convert a RAC to a single instance.
I guess this means it is breakable -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Hello All: We had purchased RAC to provide high availability of datawarehouse to our customers. We later discovered that the way our application is designed, and because database links are not failed over in the RAC environment, we have decided to abondon RAC - atleast temporarily. Could you please list all the steps required to convert RAC to a single instance. My understanding is that all we need to do is modify the initSID.ora to comment out RAC specific parameters like cluseter_database_instance cluster_database SID.instance_name SID.instance_number SID.thread SID.remote_listener What about the Oracle software? any changes required there? Appreciate you help and suggestions in this matter. Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[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: Tony Johnson 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 10g Pricing
... or lack thereof. I saw this AM that now pricing will now not be out on 10g til late October. Gee, Larry .. I thought we were supposed to get this 2 weeks ago. ORACLE SILENT ON 10G COSTS | VNunet It looks as if Oracle Corp. will not announce its pricing strategy for its 10g database and application server products until they ship in late October. At the same time, users are being prepared for a new list of licensing options that, depending on their clarity, could confuse the software market even more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Johnson 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: RAC for download -- re RAC Pricing
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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: Tony Johnson 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: Urgent INFO needed.
All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message-From: Ora DBA [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 5:30 AMTo: Multiple recipients of list ORACLE-LSubject: Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: Oracle on Win2000
Depending on the size of your databases OEM and its Tuning Pack may work very well for you. -Original Message-From: Bala Regupathy [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle on Win2000 First time I have got to maintainOracle databases on Win 2000 server.Whattools do you guys use to get to theserverto admin oracle databases ? Thanks, Bala.
RE: RAC or Oracle Fail Safe
FailSafe comes with EE and works very well. It might even come with SE but I am not sure. Our production environment fails over in less than 2 minutes. It is much simpler to set up ( ie no SAN, raw devices or OCFS) and a heck of a lotr cheaper ( 20K$ / CPU for RAC ). One other note is that we have not had to failover due to a Win2K of Oracle problem in 18 months of running failsafe. We have found it to be extremely stable just not scalable froma CPU standpoint. -Original Message- Sent: Wednesday, July 16, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Hello all, We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, and now are in the process of deploying Oracle 9i on it. For the purpose of high availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA with oracle Fail Safe, i.e. if one node is down due to any problem, then the other takes over, then can we do without RAC? Which of these two is more transparent to the user, i.e. which will take less time to shift the load from one node (server) to the other node? Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa. Regards, Hussain DBA SKMCHRC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri 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: Tony Johnson 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: Windohs - monthly at job
Title: Message following is an example from my system at 01:00 /every:SU f:\oracle\admin\scripts\analyze\analyze_wkly.bat being up a cmd prompt and enter 'at /help' and you will see how to set up for specific days of the month -- Tony Johnson Email : [EMAIL PROTECTED] Manager Database Administration Voice : ( 480 ) 682 - 0849 Trimble Navigation Cell : ( 602 ) 363 - 7328 7408 W. Detroit Street #100 Fax : ( 480 ) 961 - 8801 Chandler, AZ 85226 -- Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003 9:39 AMTo: Multiple recipients of list ORACLE-LSubject: Windohs - monthly at job Hi all, Does anybody know the syntax to schedule a monthly "at" job on Windows (2000)? I need to schedule a job for the 1st and 15th every month, and would like to avoid the Task Scheduler GUI. A virtual pint o' Guiness (mm...) for anybody who can help! Thanks! - Jerry
Experience With H/P EVA Storage Products
I was wondering if anyone has experience with the H/P EVA3000 or 5000 storage products from H/P and their storage 'virtualization' products ? Specifically, will it handle very large database volumes ( ie 30m record inserts a day, 7.5 m queue/dequeue operations and all the associated index maintenance ) or is it just another name fro SAME ? Thanks for any input. -- Tony JohnsonEmail : [EMAIL PROTECTED] Manager Database Administration Voice : ( 480 ) 682 - 0849 Trimble Navigation Cell : ( 602 ) 363 - 7328 7408 W. Detroit Street #100 Fax: ( 480 ) 961 - 8801 Chandler, AZ 85226 -- Murphy's Data Constant:Data will be damaged in direct proportion to its value -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Johnson 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: Oracle ambushes Peoplesoft with $5.1bn bid
RDB was developed by DEC and was purchased by Oracle. When I 1ast saw it in depth 10 years ago it wqas quite nice. From what I also understand that the Cost Based Optimizer from 8i and on was part of RDB replacing the 7i Oracle developed version. -Original Message- Sent: Friday, June 06, 2003 12:40 PM To: Multiple recipients of list ORACLE-L And what exactly is RDB to Oracle RDBMS? Predecessor? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 06, 2003 1:04 PM To: Multiple recipients of list ORACLE-L What's really interesting is the quote from Larry indicating that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS. Take all the goodies, no development on the purchased technology. Not sure if it appears in this arcticle, I saw it on Zdnet. Jared Mark Leith [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/06/2003 06:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle ambushes Peoplesoft with $5.1bn bid http://www.theregister.co.uk/content/53/31079.html OoooOO === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: 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: Gogala, Mladen 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: Tony Johnson 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: Unbreakable, my buns. Upgrade to 9.2/w2k
Title: Unbreakable, my buns. Upgrade to 9.2/w2k I have upgraded 16 databases ( manually using the scripts and procedures in metablink as a guide ) with very few problems and only then on the 1st ones I did. We were going from 8174 ro 92021 on Win2k SP3. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]Sent: Wednesday, May 28, 2003 9:25 AMTo: Multiple recipients of list ORACLE-LSubject: Unbreakable, my buns. Upgrade to 9.2/w2k For those of you who have upgraded to 9.2 on w2k: How many of you have ended up with such a hosed server that you had to completely wipe Oracle off of it and start with a fresh install (9.2)? It was spectacular! I ended up in this situation and I sure hope it's something I did or didn't do. I sure don't have time for this when I upgrade my production databases. How I long for those days wading through problems in unix... it was so much easier and more enjoyable... I will say this was definately a learning experience. And Tom Mercadante, your document worked like a charm, and saved my a$$... Muchas Gracias! Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa 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: Database naming conventions
I had the same arguments with a consultant we had in at one time I compromised with him. The database files are in a directory called 'oradata' and we use a designator of D development, T for Testing, B for Beta, P for Production and S for Stress Test. -Original Message-From: Godlewski, Melissa [mailto:[EMAIL PROTECTED]]Sent: Friday, February 14, 2003 9:24 AMTo: Multiple recipients of list ORACLE-LSubject: Database naming conventions List, I'm use to using a standard D=development T=test P=production. So for a database newly created on development it would be called something like D24X7. Then when it was created on Production it would be called P24X7. Or along similar lines. I'm working with an other DBA who wants everything to start with ora. Therefore it would be called orad24x7 and orap24x7. I've argued the ora is rather redundant since everyone will know it's an Oracle database they are connecting to. He is adamant it should have the ora identification so it is easily identified. I feel it will cause more confusion having ora at the beging of every dbname. Any thoughts for against either position? TIA M.Godlewski
RE: Teradata baned from IOUG???
I'm sorry but I thought that IOUG was independant from Oracle? If Larry is afraid of a little competition then perhaps he should get out of the market. If not then he should battle it out in every venue possible and show why Oracle is better. If Rich and the guys do this they will be setting a dangerous precedant. -Original Message- Sent: Wednesday, February 12, 2003 2:59 PM To: Multiple recipients of list ORACLE-L DBA's Check the article's comment on Oracle trying to ban Teradata from IOUG Teradata Steals Oracle's Data Mart Users ... Teradata pushes consolidation and woos away Oracle customers. But Oracle strikes back. Sort of. Will bean counters surf the Web with Excel? Will Steve Ballmer and Larry Ellison become immortal? http://computerworld.com/newsletter/0%2C4902%2C78375%2C0.html?nlid=DM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton 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: Tony Johnson 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: Windows 2000 Cluster on oracle
We have had an excellent experience with our Windows2000 clusters. Since moving to a clustered environment on our Test, Beta and Production systems over 18 months ago we have had 0 ( Zero ) outages due to Windows. in fact I have yet to see a BSOD on over 20 database servers since going to Windows2000. Saying Windows is unstable shows a lack of understanding of what Windows2000 is today. Carrying the baggage of WindowsNT forward is a disservice. I say go for it. In fact we will be moving to 9i RAC by the end of this year and we are planning on using Windows as our Oracle platform. -Original Message- Sent: Wednesday, February 05, 2003 1:49 AM To: Multiple recipients of list ORACLE-L SUN to Windows ?. Why do you want to used Windows. I think SUN more more better than Windows. I suggest please don't used Windows. As you you known the Windows system is not stable. SUN more more stable than Windows. I think you have to think more than twice for using Windows. -Original Message- Sent: Wednesday, February 05, 2003 6:29 AM To: Multiple recipients of list ORACLE-L Sun to Windoz ..h ... are u sure ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 04, 2003 2:34 PM Hi, We are looking from migration from Sun box to Windows box. Is anyone used Windows clustering with oracle8i? Is this clustering stable or more frequent creating problem? Please advice Thx -Seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: BigP 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: Bernardus Deddy Hoeydiono 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: Tony Johnson 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: Configuring disks on a Windows 2000 server?
I think I would be looking for a new vendor. We run applications that run quite well in a Raid5 environment under W2K Server and/or Advanced Server and have run with other configurations also. Oracle doesnt know or care what is underneath as long as the O/S recognizes it and it can read and write to it. -Original Message- Sent: Thursday, November 14, 2002 3:03 AM To: Multiple recipients of list ORACLE-L Hi all, A 3rd-party software vendor is coming in to install their application on a new Windows 2000 server. This application uses Oracle, so they'll also be installing Oracle 8.1.7 as part of their setup session. However, they've sent our server/hardware guys the following, specifying how they want the disks configuring on the server: - - - - - As to the RAID recommendations the issue is that Oracle do not support installations where the redo logs are on any sort of a stripped partition. My recommendation would be to create a mirror pair out of two of the disks. This can be partitioned for the system and the redo logs. The remainder of the disks can be RAID 5. Note that the RAID 5 array is where the actual database and archive logs are stored. In theory If you lose both disks on the mirror you would still have enough information on the RAID 5 partition to save the database. - - - - - Now, disk configuration's one of my weakest spots, but I have the following two questions about their instructions: 1. Is their point about Oracle not supporting redo logs on striped partitions true, or are they talking rubbish? All our UNIX servers with Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it different for Windows servers? I must say I'd never heard of this restriction before, but I'm willing to be enlightened! Anybody? 2. They're recommending RAID 5 for a transaction-heavy application server, here. Surely that's wrong? I thought I understood that RAID 5 was great for file servers but lousy for servers running transactio-heavy business applications. What's the view of you guys on this? Please give me your views, I know we have some very experienced people on this list! Best regards, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent 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: Tony Johnson 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: Datafile size on NT or 2000
There used to be a bug that caused problems with files on NT 4g or more in size. I've standardsized on 3999 meg as a result of this. -- Tony JohnsonEmail : [EMAIL PROTECTED] Manager Database Administration Voice : ( 480 ) 682 - 0849 Trimble Navigation Cell : ( 602 ) 363 - 7328 7408 W. Detroit Street #100 Fax: ( 480 ) 961 - 8801 Chandler, AZ 85226 -- Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message- Sent: Thursday, September 05, 2002 2:29 PM To: Multiple recipients of list ORACLE-L What is an ideal datafile size for a large database 10G or greater Oracle 8.1.6 We have been using slightly under 2G and looking for an ideal size and possible reasons to use such a size Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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: Tony 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).
RE: No DBAs needed on AS400
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tony 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).
RE: opinions on naming primary keys in new database (seriously)
Depends on the primary key type. If a surrogate key type like ( like a sequence number ) we name them (table name)_id. If comprised of multiple columns we cant do this so just give them names following our naming standards. The index which makes up the primary key is always named pk_(table name). Hope this helps. -- Tony JohnsonEmail : [EMAIL PROTECTED] Senior Database Administrator Voice : ( 480 ) 682 - 0849 GRID DATA, INC. Cell : ( 602 ) 363 - 7328 7408 W. Detroit #100Fax: ( 480 ) 961 - 8801 Chandler, AZ 85226 -- Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message- Sent: Thursday, March 08, 2001 9:11 AM To: Multiple recipients of list ORACLE-L Hugh, You are right that Richard Barker says not to use an entity name as part of an attribute name. (CASE*METHOD Entity Relationship Moddelling, by Richard Barker, page 3-9) And I believe Oracle still gives out this book in their Data Modeling class. I have seen databases that completely follow this method and others that include the table name in every column. As far as naming your primary key as a column called 'key', I don't like it either. I am also curious to see what is the preference of other list members. Regards, Jeff Cox IPS-Sendero Scottsdale, AZ -Original Message- Sent: Wednesday, March 07, 2001 4:58 PM To: [EMAIL PROTECTED] Hello, I wanted to get the lists opinion on the preference of naming primary keys. Please see my example below with the CUSTOMER table, and the customer TYPE table. The column 'type_id' is a foreign key referencing the TYPE table. This is just an example to get opinions. CUST TYPE +-+ +--+ | id | |id| | name| |desc | | type_id |--| | +-+ +--+ I like having my primary keys called id, and not including the table names in the columns of the original table. For example, in the CUST table, we would not have 'cust_id' as the primary key, we would just call it 'id'. But having 'type_id' as a column of the CUST table is okay because that is a foreign key, and not an attribute of the original CUST entity. Including the table name in a column that is not a foreign key, I believe, is redundant and not necessary. (I also remember reading this in a Richard Barker book.) All foreign keys would then have the standard of table_column, with the exception of tables with multiple foreign keys from the same table, and recursive relationships - which would then just include a more descriptive table_column name. This way, when you do a describe on a table, you will immediately be able to tell what are the foreign keys, and the primary keys. (I also believe in surrogate keys for most tables, so the problem of having a composite key is not an issue here.) I think that this will later make the database easier to understand to new DBAs and duhvelopers, which would have been nice when I worked on my first database. My questions: 1) What is your preference with primary and foreign keys - if you could design a database from scratch? 2) Am I off my rocker thinking that this is a good way to design a database? 3) We have a developer who wants to name all of our primary keys, 'key', and I am trying to convince her that we should use 'id' or 'nbr' instead. Has anyone ever used 'key' as the primary key of a table? This seems like it would be confusing when All constructive criticism is welcomed. Thank you, Hugh Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Cox 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: Tony Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Recommended # of CPUs and MHz
Im doing this on a dual 500Mhx Dell box with a Raid5 array now and 1g of memory. No issues. -- Tony JohnsonEmail : [EMAIL PROTECTED] Senior Database Administrator Voice : ( 480 ) 682 - 0849 GRID DATA, INC. Cell : ( 602 ) 363 - 7328 7408 W. Detroit #100Fax: ( 480 ) 961 - 8801 Chandler, AZ 85226 -- Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message- Don Sent: Wednesday, March 07, 2001 1:36 PM To: Multiple recipients of list ORACLE-L I've been looking around for ways to determine how much processor speed I need for a new installation. From what I found so far there are basically two ways to do this. 1. Spend the time and money on resources and tools to analyze the needs. 2. Make a best guess and go from there. Given the limited time and budget I would like simply to make a best guess. I'm hoping a query to the mass might produce some suggestions for me. I'm estimating about 100 to 150 users on a machine that will be dedicated strictly to the database, no app servers or any other programs outside of normal OS and database processes will run on it. I will have 3 Oracle instances running on it, all together about 10 gig of data manipulated in a OLTP environment. I'll probably go with a SUN 420 with 2 450MHz processors to start. I'd like to have more but then that would raise the ante on the Oracle licensing. I'll attempt to compensate with loads of memory. What do you think, am I being unrealistic with only 900MHz or can I skate by? Thanks, Don. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simpson, Don 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: Tony 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).
RE: proper database sizing ?
try compress option. i have seen good results with multi column concateneated indexes. -- Tony JohnsonEmail : [EMAIL PROTECTED] Senior Database Administrator Voice : ( 480 ) 682 - 0849 GRID DATA, INC. Cell : ( 602 ) 363 - 7328 7408 W. Detroit #100Fax: ( 480 ) 961 - 8801 Chandler, AZ 85226 -- Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message- Alex Sent: Friday, February 23, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, do you have any idea about how to reduce the space occupied by indexes on a large partitioned table. I have 8 indexes which occupy twice the space of data. -Original Message- From: Bunyamin K.Karadeniz [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 2:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: proper database sizing ? Herman , Hope this helps some. first decide sizes of tables and indexes. avg_numberofrows*numberofrows*1.5(tables and clusters) avg_key_len*num_keys*1.5(indexes) then sum them to decide on tablespaces size. * always size for 1 year as a minimum.. Bunyamin K. Karadeniz / TURKEY - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 23, 2001 12:15 PM Hello all, I've been pointed by the boss, to design our database application. I've a bit oracle background, it's just that I wanted to know what are the things that we need to notice when we do database sizing, and how to do the right calculation. Is there a documentation in the web site how to do that ? or someone can share his/her experience when sizing the database ? thanks a lot regards Herman Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman 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: Bunyamin K.Karadeniz 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: Berindei 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: Tony 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).
RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE
Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE The whole idea behind 9i is CacheFusion which uses a high-speed interconnect to solve the pinging issues. At least that is the marketing line that will only be proved in time. Any database of any size should be using partititioning if you want it to perform and be able to manage it. --Tony Johnson Email : [EMAIL PROTECTED]Senior Database Administrator Voice : ( 480 ) 682 - 0849GridData Cell : ( 602 ) 363 - 7328 7408 W. Detroit #100 Fax : ( 480 ) 961 - 8801Chandler, AZ 85226--Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Tuesday, February 06, 2001 6:53 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE I understand the argument, Rodd and it raises three points/questions: 1) I can always back up a "state" ( part of a federation?) just like EMC/SRDF/BFD SAN does for the Oracle solution, and at less cost, and 2) Do you believe you can simply "add nodes" to an OPS farm to improve performance? I have personally never gone over a humble two nodes in OPS, and even then, locking issues must be addressed. One way out of this is the geographically segregate and partition the data. But this would be "federated." In a pure play OPS scenario, I would imagine the system would choke to death after the fourth or sixth node, without special tweaks like partitioning, either by data or application. 3) Loss of a SS "state", just like loss of an oracle partition, does not "kill the operation of the system". here, they are the same. .. just a thought.. -Original Message-From: Holman, Rodney [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 5:21 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE Ross, I was at the Open World conference session where Jeremy Burton made the comments about clustering, OPS, data segmentation, etc. The data segmentation part was about MS SQLServer, and about how it creates significant work to add cluster nodes.C|net has their terms and comments a little scrambled. The Oracle 9i solution used OPS for the instances and an EMC/SRDF SAN for the data storage. Each OPS cluster node had full access to every piece of data. By doing this no node is a single point of failure (as Larry demonstrated and was chastised for by MS). Also it creates greater capability for scalability. Just configure and add a node and it improves performance (also part of Larry's demo). As described with the MS federated database configuration you would need to resegment the data to add a node. This would then destabilize the system even further by adding another single point of failure. Failure of an OPS cluster node with the data on a SAN with redundancy, such as the EMC/SRDF option, only decreases performance, it doesn't kill the operation of the system. Rodd Holman -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 5:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE Very Interesting! It appears Oracle 9i, is, in fact, a Hybrid Federated Database! http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni A snippet:
RE: Primary Keys
How are you going to retrieve the data in these tables for your application. A surrogate key as you are describing is valid in many instances if for no other reason that to make the model much cleaner. There are many occasions where the 'live-and-die' relational rules have to be bent to meet real world problems. -- Tony JohnsonEmail : [EMAIL PROTECTED] Senior Database Administrator Voice : ( 480 ) 682 - 0849 GRID DATA, INC. Cell : ( 602 ) 363 - 7328 7408 W. Detroit #100Fax: ( 480 ) 961 - 8801 Chandler, AZ 85226 -- Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message- Wisniewski Sent: Thursday, February 01, 2001 12:08 PM To: Multiple recipients of list ORACLE-L I know this violates the most basic data modeling techniques but tell me what you think. I'm working on creating a new database which will be fairly small in number of tables ~8 but large in storage size ~4 terabytes with millions of records eventually. The 3 large tables will hold small images along with supporting data and the only reason I can see to have a primary key is to have a primary key. There is not a natural key for the tables so it would be a sequence which would never be selected against. Given the number of records all I can see it doing is taking up space, increase the time of the imports, generate more redo logs, etc and I can't see the benefits. There won't be any tables hanging off of these, I won't be using snapshots, replication or anything else I can think of that would require a PK but the voice 'YOU MUST HAVE A PRIMARY KEY' is resounding loudly in my head so I must ask why? Tell me what you think. Thanks - Brian __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski 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: Tony 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).
