RE: 20 Instances 1 Machine
I would recommend a Sun E-15k. The best option would be to domain it into separate virtual boxes so that each instance has it's own space. Or, you could go the other route and buy a bunch of Ultra-2 machines and give each database its own box. Or, maybe a blade for each instance? -Original Message- Sent: Friday, August 02, 2002 5:23 AM To: Multiple recipients of list ORACLE-L You also have to consider the OS overhead. Putting 20 instances means hundreds of processes. Just managing all this at the system level can be resource consuming. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael-EDS 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: Cloning Problems
From my understanding you do not need the on-line redo logs unless you perform a shutdown abort. As a matter of fact the database will create the logs if they do not exist when you issue the alter database open resetlogs command. -Original Message- Sent: Monday, July 29, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Ethan, Your first line of the trace file is the same as mine when I clone from cold backups. I also always do clean shutdown normal before cold backup but I think you should be okay with shutdown immediate too (IMHO). I think if you are renaming the cloned database then the RESETLOGS option is required. You said the database was shut down IMMEDIATE and you had no control over this. Did someone else shutdown and do the backup for you? Don't forget to check the obvious. Are you sure the backup was completely closed (not rolling back) before the backup began? (You're used to hot files) Are you sure the database was not restarted before the backup completed? Are you sure you copied ALL files to your cloned database? (I copy everything, then delete control files, then create controlfiles) Take a quick check on the timestamps on the files you backed up. See if there are any time differences that jump out at you. Good luck, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael-EDS 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: A DBA looks at OAS | IAS vs. Locally-built Apache
Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Jenkins, Michael - EDS 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).
Things to do when writing scripts in the Korn Shell
Just some humor to pass the day. Top things you can do while writing scripts in the Korn Shell: * Listen to a Korn CD * Eat some popKorn * Munch on a roasted ear of Korn * Rub the Korns on your feet * Have a Cream Korn fight with your mate in the next cube. * See how many Korn Chips you can burn in a glass ashtray before it expodes from the heat. Ok, so I had two seconds to think of these things as I was listening the new Korn CD, writing a Korn Shell script. --Michael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael - EDS 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: Good HR vs. Bad HR...
in management (especially the managers of the Phoenix project) was an incompetent fool. Matt Adams - GE Appliances - [EMAIL PROTECTED] Reason is 6/7ths of treason. - The Xtals -Original Message- Sent: Thursday, May 09, 2002 12:14 PM To: Multiple recipients of list ORACLE-L This is getting too good we need to see that letter now. Rodd On Thu, 2002-05-09 at 02:13, Adams, Matthew (GEA, MABG, 088130) wrote: Had to be CSG! Your resignation letter was legendary. -Original Message- Sent: Wednesday, May 08, 2002 5:03 PM To: Multiple recipients of list ORACLE-L I was once fired because HR didn't like the tone of my resignation! Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 08, 2002 12:30 PM True story (my own...) Dear ..., I am tendering my resignation (to which HR returned it with) Resignations must be made using form XYZ - please fill in the correct form and resend -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Don Granaman 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: Don Granaman 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: =?utf-8?B?TWVyY2FkYW50ZSwgVGhvbWFzIEY=?= 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: Jenkins, Michael - EDS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Financials Sys Admin. Needed in South Carolina
You've hit the nail on the head there. They're looking for something for nothing. If they get somebody at this price I suspect that the town is near and dear to them. I wonder what the relo is? 2k? -Original Message- Sent: Monday, April 29, 2002 1:58 PM To: Multiple recipients of list ORACLE-L Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. I'm wondering what frequent means...? Am I the only one that thinks the pay scale is a bit low, with this caveat? To me, the paradigm seems to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Company located in Spartanburg, South Carolina with a small IT shop needs an Oracle Financials System Adminsitrator to join its IT team. Relocation Assistance is provided. PLEASE Do Not send your resume for this position UNLESS you have the qualifications for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of all phases of ORACLE FINANCIALS including system administration, RDBMS tuning, application tuning, DBA/Unix back-up administration, user training, report development utilizing SQL*Plus and Reports 2.5. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Freeman, Robert 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: Jenkins, Michael - EDS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Financials Sys Admin. Needed in South Carolina
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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: Jenkins, Michael - EDS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Financials Sys Admin. Needed in South Carolina
, 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael - EDS 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: Is DATAFILE order important in CREATE CONTROLFILE?
No, the order does not matter. We create control files frequently when we clone from production to test and development. We use this piece of code to generate the listing in Korn Shell: ls /*/oradata/SID/*.dbf | while read FN; do echo '$FN',; done Of course you will have to replace the final comma with a semi-colon. Good luck. --Michael -Original Message- Sent: Thursday, April 11, 2002 4:54 PM To: Multiple recipients of list ORACLE-L Rich, I believe the datafile order in a CREATE CONTROLFILE statement is critical, from lowest FILE# to highest. I'd be reluctant to prove myself wrong by testing our database copy process (I used sed to map the datafiles.), but we are moving 500-600Gb databases around and rerunning it would require another 25hr window ;) -Original Message- Sent: Thursday, April 11, 2002 3:13 PM To: Multiple recipients of list ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the new dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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: Jenkins, Michael - EDS 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: Disk is cheap?
Wouldn't it be cheaper just to replace each drive with a bigger one rather than buying all of the infrastructure related stuff? If you replace 8gb drives with 80gb drives you just saved 9 cabinets. -Original Message- Sent: Tuesday, March 19, 2002 9:08 AM To: Multiple recipients of list ORACLE-L I beg to differ. Each disk cost the disk price + 1/24 of the infrastructure costs. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Stahlke, Mark [SMTP:[EMAIL PROTECTED]] Sent: Mon, March 18, 2002 10:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: Disk is cheap? Robert G. Freeman - Oracle8i OCP wrote: But disk is cheap, right...? Or is that yet another Urban Legend??? Yes, that's another Urban Legend. Disk DRIVES are cheap, disk SPACE is not so cheap. Consider this example: I have a disk cabinet with 24 slots and 23 disks. The 24th disk is cheap, but how much does the 25th disk cost? In addition to the disk drive we need a cabinet, controllers, cache, host adapters, cables, floor space, environmental controls, installation, configuration, management, maintenance contract, and on and on. Mark Stahlke Oracle DuhBA Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stahlke, Mark 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Jenkins, Michael - EDS 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: Disk is cheap?
Doesn't creative striping solve this problem to some extent? -Original Message- Sent: Tuesday, March 19, 2002 12:24 PM To: Multiple recipients of list ORACLE-L This highlights problems with those larger drives... DBA's want more, smaller drives in order to spread I/O and reduce contention but SA's want fewer, larger drives in order to reduce expenses and ease administration. I once fought a major battle demanding smaller 4GB drives because the same amount of storage with the larger 9GB drives took away my ability to spread I/O and segregate contending files. After winning the battle they went ahead and bought the number of spindles I required but with the 9GB drives because the incremental cost was only another $100 per drive. So I got the number spindles I needed and a lot more storage capacity than was necessary but it was OK to waste space in order to gain performance. Large drives dedicated to redo logs can also be tempting for S/A's. They see all that extra space and figure it's a good place to put their monitoring utilities and system log files the look at you quizically when you explain that's why the database just slowed down. Then they walk away complaining how Oracle is so wasteful of disk space. Larger, fewer drives are NOT necessarily cheaper if you try to make up for I/O degredation by throwing CPU's and memory at the system. Storage may be cheaper on a $'s/GB basis but it still takes a lot to engineer optimum I/O throughput. Still wishing I has some 2GB SCSI drives... :-) Steve Orr -Original Message- Sent: Tuesday, March 19, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Wouldn't it be cheaper just to replace each drive with a bigger one rather than buying all of the infrastructure related stuff? If you replace 8gb drives with 80gb drives you just saved 9 cabinets. -Original Message- Sent: Tuesday, March 19, 2002 9:08 AM To: Multiple recipients of list ORACLE-L I beg to differ. Each disk cost the disk price + 1/24 of the infrastructure costs. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Stahlke, Mark [SMTP:[EMAIL PROTECTED]] Sent: Mon, March 18, 2002 10:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: Disk is cheap? Robert G. Freeman - Oracle8i OCP wrote: But disk is cheap, right...? Or is that yet another Urban Legend??? Yes, that's another Urban Legend. Disk DRIVES are cheap, disk SPACE is not so cheap. Consider this example: I have a disk cabinet with 24 slots and 23 disks. The 24th disk is cheap, but how much does the 25th disk cost? In addition to the disk drive we need a cabinet, controllers, cache, host adapters, cables, floor space, environmental controls, installation, configuration, management, maintenance contract, and on and on. Mark Stahlke Oracle DuhBA Denver Newspaper Agency -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael - EDS 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: Anybody against using views?
One of the mains reasons we used views at one place I worked was the table drop factor. We never created a table that we didn't immediately create a select * from ... view on. We then granted the privileges on the views instead of the tables so that if we ever had to drop and recreate the table all of our grants would stay intact on the view. Now that you can rebuild the table without dropping it I don't think this approach has much merit but it is something to consider in older databases. Just one more point of view :) --Michael -Original Message- Sent: Thursday, February 21, 2002 12:29 PM To: Multiple recipients of list ORACLE-L I like views... right now I'm working on the one out my office window... a spectacular view of the Tobacco Root range across the Gallatin Valley. :-) Regarding database views, you can't say they're entirely good or bad. They may simplify things for reporting but they could complicate your ability to tune the SQL... it just depends. Ad hoc end user queries on a separate non-OLTP reporting server is one thing, ad hoc end user reporting or batch reports with views of production source data on an OLTP server is could be quite another. The idea of having business object views of data and turning end users loose with a reporting tool without DBA supervision can be both appealing and frightening. But duhvelopers SHOULD know what they're doing. ;-) Looking out the window in Bozeman, Montana... Steve Orr -Original Message- Sent: Thursday, February 21, 2002 9:18 AM To: Multiple recipients of list ORACLE-L We have several applications that use views extensively. On the other hand there are several apps that use no views at all. We have a new developer who wants to use views when writing reports in Crystal Reports. The application administrator is leery of using views and ask the DBA group what we think. I can see several reasons to use views and a few reasons not to use them. I was just wondering what the rest of the group thought. Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael - EDS 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: FTP Exports
I'm pretty sure you will get a partial file in most cases. Some FTP daemons even have the capability to resume a broken tranfer. Almost all of them return an error code when the transfer is incomplete. I would test this out in my script and make provisions to notify someone in the event of a failure. --Michael -Original Message- Sent: Friday, February 08, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Erik - You probably want a Unix group or networking group to get a definitive answer. FTP won't delete the file on your server. However if you write a Unix command to delete the file as part of your FTP script, you should test for a success/failure indication from the FTP script before you delete the file. My understanding is that FTP has integrity checks built in to sense whether the transfer was successful or not. HTH. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 08, 2002 10:04 AM To: Multiple recipients of list ORACLE-L I am FTPing exports in binary mode as a part of my backup/recovery plan. What happens when the network connection is lost between FTP client and server while a file is being transferred? Will an incomplete file appear on the FTP server or would the FTP server sense the disconnect and remove the partially transferred file? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael - EDS 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).
