RE: RE: 10g new features question for beta testers

Hi,

I sat in a presentation up here in Wisconsin. I got the distinct feeling that most of the new "features" aren't optional. Either you use them or you don't use 10g.

I can't remember if ASM was one of those mandatory features.

--
Joe Frohne
Rawson Oaks Consulting, Remote Oracle Admins
http://www.rawsonoaks.com
joe_at_rawsonoaks.com or joe_at_frohne.org
Oak Creek, WI, USA




> HUMM,  That gives me an even worse feeling.  Not something I'll use

> that's for sure.

>

> Dick Goulet

> Senior Oracle DBA

> Oracle Certified 8i DBA

>

> -----Original Message-----

> Sent: Friday, December 19, 2003 9:45 AM

> To: Multiple recipients of list ORACLE-L

>

>

> 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" <DGoulet_at_vicr.com>

>> Date: 2003/12/19 Fri AM 09:14:27 EST

>> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

>> 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: <ryan_oracle_at_cox.net

>>   INET: ryan_oracle_at_cox.net

>>

>> 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: ListGuru_at_fatcity.com (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: DGoulet_at_vicr.com

>>

>> 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: ListGuru_at_fatcity.com (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: <ryan_oracle_at_cox.net

>   INET: ryan_oracle_at_cox.net

>

> 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: ListGuru_at_fatcity.com (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: DGoulet_at_vicr.com

>

> 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: ListGuru_at_fatcity.com (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: Joe Frohne
  INET: joe_at_rawsonoaks.com

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: ListGuru_at_fatcity.com (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).