10 ASM question

From: joe bayer <joebayerii(no-spam)_at_hotmail.com>
Date: Fri, 01 Jul 2005 10:24:57 GMT
Message-ID: <ZR8xe.14503$Q27.9634@trndny02>

Does anybody here used Oracle 10G ASM? Is it reliable? Do you guys recommend it?

I have two question here.

If there is a disk failed in one disk group, how could I tell which disk, in which disk group failed? Any dynamic view to tell this?
the create tablespace is like this: SQL> create teablespace test_tbsp2 datafile '+test_group1'; there is not size specified, does it mean the tablespace will take the whole disk groups?

Thanks very much for your help. Received on Fri Jul 01 2005 - 05:24:57 CDT