This could simplify life, particularly with wait event-based tuning. If Oracle properly instruments these additional layers for timing, it makes it easy to diagnose performance problems, not harder. Interested in Cary's thoughts on this.
Adam "Goulet, Dick" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/19/2003 07:49 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject RE: RE: 10g new features question for beta testers And the more that vendor, namely the database in this case, controls more and more of the stack the more any performance problem must be a database problem. No thank you. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- Sent: Friday, December 19, 2003 10:34 AM To: Multiple recipients of list ORACLE-L As with anything I suppose, if a single vendor can be in control of more of the stack between application and physical server structure then there is a greater opportunity for benefits. For example, ASM offers the ability to add disks to a stripe without needing to redistribute(reload) the entire stripeset. A (bug-free) ASM product looks very very impressive to me. Time will tell how close Oracle are to achieving it. hth connor --- [EMAIL PROTECTED] wrote: > no ASMs are considerably different. Its supposed to > manage everything. You dont give it a file, you give > it entire disks and oracle does everything. Sets up > files, manages, I/O, everything. > > you only look at the tablespace level. you dont even > install any software on it. If your on SAN, you dont > install SAN software on it. > > > > From: "Goulet, Dick" <[EMAIL PROTECTED]> > > Date: 2003/12/19 Fri AM 09:14:27 EST > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Subject: RE: 10g new features question for beta > testers > > > > That is not exactly a new feature. Oracle 9i has > Oracle Managed Files where you give it a directory > and then just build tablespaces. The database picks > the filenames for you. Now mind you it does work, > but I'll be damned if I use it in anything other > than a development environment. For some reason > Oracle has never gotten over that DUMB SAME (Stripe > And Mirror Everything) idea. The concept is great > in theory, but in practice it's absolutely abysmal > at best. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -----Original Message----- > > Sent: Friday, December 19, 2003 8:24 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I saw a presentation from Oracle on 10g new > features last night in Reston,VA. I know atleast one > other person from the list was there. Since Oracle > is releasing details and its going to be released(in > theory) in the next 2 weeks, I was wondering if you > guys could talk about it. > > > > 1. does ASMs work as well as Oracle claims? I > always wonder about first generation features... > takes most software vendors a couple of generations > to get it right(takes any project Im on just as > long). This is a radical departure. > > > > for those of you who dont know. Oracle claims that > they will manage your disks for you. All you do is > give Oracle some Raw Disks and Oracle will set up, > and handle all your datafiles. All you do is look at > logical tablespaces. It will also handle I/O > balancing. > > > > How well does this work? Anyone test it with a > SAN? > > > > > > 2. RAC Load Balancing. Oracle claims that you only > need Oracle software from now on. They also claim > that you can load balance multiple applications. > Lets say you have One application that runs batch > loads over night and a transactional application > during the day.... oracle will automatically steal > resources from the other when its not busy... > > > > anyone test this? > > > > > > 3. Flashback database. Kyte was the presenter and > he said that you can keep massive undo areas, so > that if you have a failure or delete data you > shouldnt have you can have oracle automatically > write the DML necessary to bring it back to any > point in time. Kyte said that regular EIDE hard > drives that you put in home PCs are plenty fast > enough for most systems. He recommends getting 4 300 > GB drives(1.2 TBs) for about $1400 to do this and to > make tape backups off of this since they are really > slow. > > > > Can any beta testers comment? > > > > Im pleased with the rename tablespace feature... > that way I dont have to update TS$ anymore... I > wonder if it was our complaining that got them to > add it :) > > > > -- > > 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: Goulet, Dick > > 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: <[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). ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Goulet, Dick 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).
