Patch 9.2.07 for Linux

>>>I hear what you saying and partly agree. Everyone knows I for one
>>>have been quite vocal of late on the issue of stability. Where I
>>>disagree here is that I think many of the 10g features are quite
>>>important and relevant.

I wont argue that Oracle RDBMS features are important and relevant. Oracle has always been an RDBMS company. An RDBMS resides **inside** files.

Where Oracle is going wrong is in saying they have a volume manager, when in fact it is just a more robust way to handle the CONTENTS of their files.

Ironic that ASM with NAS goes like this: You get inside the NAS, create volumes, create the filesystem (e.g., WAFL on NetApp, PolyServe on HP EFS Clustered NAS Gateway
http://h18000.www1.hp.com/products/storageworks/efs/), preallocate large files and then hand them over to ASM as "disks" for the "diskgroup". ASM is a volume manager? No, it is a file content manager...which I think is just nifty.

Don't call a pickle and porsche. Managing and presenting volumes and files is an entirely different thing than managing the contents therein. The former should be general purpose to cover all IT needs, the latter is up to the application (oracle rdbms in this case).

Let's see. I'll try to get one of our Oil and Gas companies with >150TB (ter-a-bytes) flat file data (manipulated with mmap()) interested in ASM. Yep.

>>>
>>>However (there is always one!), given the paltry state of
>>>implementation of many of the 9ir2 features, 4 (four!) years AFTER
>>>the blessed thing has been out, would I risk going to 10? No bloody
>>>way! I'll let someone else do the "bleeding edge tango" this time
>>>around.
>>>
>>>And I'm not even touching on the stability of patches like 9.2.0.6.
>>>All I want is for the darn features supposed to be in 9i to work as
>>>advertised.
>>>
>>>Like for example: why is it that I get ora-600s when I create a large

>>>compressed index on a very large concatenated key? Why is it that I
>>>can't validate a UK on a 20Gb 100Mrow table large concat key again,
>>>without the temp tablespace going bananas on me? Why is it that if I
>>>enable a resource manager plan on a very busy database it crashes
>>>with a 600 error on an assertion? Yes,yes: I know it's all "fixed in

>>>10gr2"...
>>>Isn't it about time this sort of errors got eradicated from 9i?
>>>Because last time I looked Oracle wasn't a free product and we darn
>>>well paid for 9i!!
>>>
>>>> PPS. anyone remember Oracle's predictions of MPP killing
>>>the SMP ? :-)
>>>
>>>ah yes: the nCube. Another delusion...
>>>
>>>--
>>>Cheers
>>>Nuno Souto
>>>in sunny Sydney, Australia
>>>dbvision_at_iinet.net.au
>>>--
>>>http://www.freelists.org/webpage/oracle-l
>>>

--
http://www.freelists.org/webpage/oracle-l