Re: 10 ASM question

joe bayer wrote:
> Does anybody here used Oracle 10G ASM?

Yes,

> Is it reliable?

Yes.

> Do you guys recommend it?

At least one of us does.

> I have two question here.

Only two? I'm at three so far.

> 1) 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?

SELECT object_name
FROM dba_objects
WHERE owner = 'SYS'
AND object_name like '%ASM%';

But the best way is to use the Grid Control.

> 2) 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?

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/storeman.htm#i1025250

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)