Oracle 10g XE + ASM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle 10g XE + ASM

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    Oracle 10g XE + ASM

    Hi,

    I have installed Oracle 10g XE on my Windows XP with all the tablespaces .dbfs
    (system,users,temp,undo, etc) on ordinary c:\data file system.
    Can I add another tablespace TS_DATA with its .dbf configured on ASM?
    I mean can I have a mixed storage management?


    Thanks a lot
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, no ASM in XE

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks dave

    Supposing I use 10g R2 EE it is ok to have a mixed storage management?
    Behind The Success And Failure Of A Man Is A Woman

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Talking


    Oracle recommends: Don't do it.

    ...To enable ASM to balance I/O and storage appropriately within the disk group, all devices in the disk group should have similar, if not identical, storage capacity and performance.

    Although you can specify a logical volume as a device in an ASM disk group, Oracle does not recommend their use. Because logical volume managers can hide the physical disk architecture, ASM may not operate effectively when logical volumes are specified as disk group devices.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    thanks
    Behind The Success And Failure Of A Man Is A Woman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width