Re: Want to BAARF - Recommendations for 10 36G Drive config
Hi Ron, It's done. You're Party member # 42 - with a special obligation to know the Answer to RAID-5, of course. Three members have socalled red numbers that will remain guaranteed constant for as long as we can keep them constant. They are: Carel-Jan Engels (#11) Leif Knudsen (#13) and now Ron (#42). By the way, Peter Gram has now registered BAARF.com and it should be available in a couple of days. In the beginning it will just point to the MiracleAS.dk page for BAARF stuff, but who knows what can happen? Mogens Ron Thomas wrote: Mogens- Can you register me with id 42? It is my age (in a few weeks) and of course the meaning of life, the universe, and everything. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: Re: Want to BAARF - Recommendations for 10 36G Drive config 06/14/2003 12:59 AM Please respond to ORACLE-L David - I just registered you as Party member # 30. You obviously have the right attitudes :-). Mogens Dave Phillips wrote: A client runs our app with the following layout. Since their intial 6 drive config they have procured more drives for a total of 10 36Gig Drives. They have also upgraded memory from 1 to 4 gig. I have the opportunity to recommend changes to the current structure to improve performance. So, any recommendations from the BAARF committee are welcome. Current System Ora 8.1.7 Win 2k Size 30Gig Logical Array 1 - Raid 1 - OS and Oracle Logical Array 2 - Raid 1 - App and Index TS Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc) David Phillips Support DBA BAARF member wanna-be -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: wait event puzzler
For the record, 'db file sequential read' isn't ALWAYS a single-block read. There are cases in which you can see 'db file sequential read' events with p3>1. It happens (well, happened) when the kernel reads from a data file directly into a user's non-shared process space (not the SGA). It used to happen in Oracle7.3 when reading sort segments from disk into a PGS. Nowadays, these reads are done with the event 'direct path read'. It is true that 'db file scattered read' will never have p3=1. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Dallas, Washington, Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Wolfgang Breitling Sent: Wednesday, June 11, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Yes, 'db file sequential read' is always a single block read. It is 'db file scattered read' which is <= DB_FILE_MULTIBLOCK_READ_COUNT At 10:35 AM 6/11/2003 -0800, you wrote: >A SINGLE block? I was convinced that it was <= DB_FILE_MULTIBLOCK_READ_COUNT >blocks. >Are you sure? > >Mladen Gogala >Oracle DBA >Phone:(203) 459-6855 >Email:[EMAIL PROTECTED] > > >-Original Message- >Sent: Wednesday, June 11, 2003 2:19 PM >To: Multiple recipients of list ORACLE-L > > >Dennis: > >THe event 'db file sequential read' is NOT always an INDEX Scan. It is >just a single block read which TYPICALLY happens during an INDEX scan. >The word 'TYPICALLY' is the key here. > > > >Best Regards, >K Gopalakrishnan Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: World premier performance of the BAARF party logo
> Meanwhile I have never understood why storage vendors would prefer > selling RAID5 over RAID10. ...Because if they don't sell RAID5, they don't recover the R&D costs of creating a RAID5 microkernel that has more lines of code than the Oracle7 executable. I'm not kidding. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Dallas, Washington, Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Niall Litchfield Sent: Thursday, June 12, 2003 12:05 PM To: Multiple recipients of list ORACLE-L Jared writes > At the meeting last week I wore my 'No RAID 5' hat. > > Those of you at IOUG 99 in Denver may have seen it, I > wore it every day there. ;) I'm curious now. Pictures required. Meanwhile I have never understood why storage vendors would prefer selling RAID5 over RAID10. More disks=more profit surely? Also 10 > 5 therefore self evidently twice as good for all applications. Meanwhile we have this strange situation where performance consultants are publicising the fact that you have less need for performance consultants with RAID10 than with RAID5. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Inverse 9i Question
My answers A) Available in 9i Release 1 only as part of DBMS_REDEFINITION - available in 9.2 from SQL B) Not available at all in 9i Release 1 so far as I can see - available in 9.2 C) Not available at all D) Available E) Wrong name - should be DBMS_XPLAN.DISPLAY. So I'd say c),e) and maybe b) depending on what 9i is defined as. Is this an OCP question? Niall > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Freeman Robert - IL > Sent: 13 June 2003 21:10 > To: Multiple recipients of list ORACLE-L > Subject: Inverse 9i Question > > > Just in the mood to do one of these > Which of the following is *not* a feature of Oracle 9i? > > a. The ability to Rename a Column > b. The ability to Rename a Constraint > c. The ability to rename a tablespace > d. The ability to drop a column > e. The utl_xplan function to format execution plans from the > SQL prompt. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Freeman Robert - IL > 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: Inverse 9i Question
The correct answer is C. No points for Joe's answer since it's not supported. Oracle9i supports renaming of column names, constraint names, and you can drop columns (note I didn't say new features as drop column was in 8i too as I recall). Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/13/2003 6:49 PM Ramon, I think you are right, Frankly speaking I missed 'c'. What our judge(Robert) says? Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 13 Jun 2003 15:19:39 -0800 I would go with A and C Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- CP Sent: Friday, June 13, 2003 6:15 PM To: Multiple recipients of list ORACLE-L I think, it should c: (The ability to rename a tablespace). Thanks CP [EMAIL PROTECTED] wrote: > Robert > > If I am not wrong..without looking at your book or any 9i doc...The > answer is > > a. The ability to Rename a Column > > Regards > Rafiq > > > > > > > Reply-To: [EMAIL PROTECTED] > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: Fri, 13 Jun 2003 12:09:54 -0800 > > Just in the mood to do one of these > Which of the following is *not* a feature of Oracle 9i? > > a. The ability to Rename a Column > b. The ability to Rename a Constraint > c. The ability to rename a tablespace > d. The ability to drop a column > e. The utl_xplan function to format execution plans from the SQL > prompt. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Freeman Robert - IL > 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). > > _ > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > http://join.msn.com/?page=features/virus > -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [EMAIL PROTECTED] http://shopnow.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CP 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: Ramon E. Estevez 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). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --
Re: Want to BAARF - Recommendations for 10 36G Drive config
Mogens- Can you register me with id 42? It is my age (in a few weeks) and of course the meaning of life, the universe, and everything. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: Re: Want to BAARF - Recommendations for 10 36G Drive config 06/14/2003 12:59 AM Please respond to ORACLE-L David - I just registered you as Party member # 30. You obviously have the right attitudes :-). Mogens Dave Phillips wrote: >A client runs our app with the following layout. Since their intial 6 >drive config they have procured more drives for a total of 10 36Gig >Drives. They have also upgraded memory from 1 to 4 gig. I have the >opportunity to recommend changes to the current structure to improve >performance. >So, any recommendations from the BAARF committee are welcome. > >Current System > >Ora 8.1.7 >Win 2k >Size 30Gig >Logical Array 1 - Raid 1 - OS and Oracle >Logical Array 2 - Raid 1 - App and Index TS >Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc) > > > > >David Phillips >Support DBA >BAARF member wanna-be > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: Ron Thomas 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 World Paris call for papers
Forgive me if this is redundant information (I have suspended list e-mail for a week), but there is an European edition of Oracle World in Paris at the end of October which may interest budget-conscious EMEA denizens and, who knows, people from elsewhere as well who couldn't make it to Frisco. The call for paper is now open (till July 7th) and you will find all information at http://www.oracle.com/oracleworld/paris/conference/index.html?content.html Warning : looks weird with Netscape 4.77. -- Regards, Stephane Faroult Oriole Limited -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
Hi: Thanks to everyone who responded to my message on Cross Platform Migration... I will update the list if we come to any conclusions not consilient with the findings given on the list.. Thanks & Regards, Sashi Sashidhar Kondareddy Project Manager IT Solutions Inc, a SEI CMM Level 5 Company Chennai 66, India efax : +1 (360) 242-8334 -- The nice thing about standards is that you have so many to choose from. Furthermore, if you do not like any of them, you can just wait for next year's model. -- Andrew S. Tanenbaum in Computer Networks, 2nd Edition --- Original Message --- We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks & Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy 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).