ASM and ORACLE-MANAGED FILES
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: ASM and ORACLE-MANAGED FILES

  1. #1
    Join Date
    Feb 2007
    Posts
    212

    ASM and ORACLE-MANAGED FILES

    Hi Friends,

    Im migrating our database from 8i to 10g. While doing the intallation of 10g
    I met these options to use ASM and ORACLE-MANAGED files. Would you
    recommend to me to use these features? are they cool or a pain
    in the neck to troubleshoot.

    Thanks a lot

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    ASM is the future. Actually, street talk says Oracle is building a whole new O/S around ASM.

    ASM provides "near" raw device performance and easy administration thru OEM

    We have implemented ASM and we are very happy with it.

    You can check Note:312731.1, which is an Oracle white paper that puts togheter 10g, RAC and ASM.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Oracle managed files won't change your environment very much, it'll just have Oracle do the file creation / naming / deletion. ASM changes more things, so you might not want to go to it yet if you aren't familiar with it.

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Right, getting familiar one feature at a time would be a good idea. Both of these features are here to stay.
    -- Dilip

  5. #5
    Join Date
    Feb 2007
    Posts
    212
    Thanks hunnies so u mean to say it is still ok if I use the old fashion way.
    I just thot i gain better performance when I used ASM.

    Quote Originally Posted by PAVB
    We have implemented ASM and we are very happy with it.
    What happiness did it bring u dear?

  6. #6
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Quote Originally Posted by jennifer2007
    What happiness did it bring u dear?
    Lolz. Only you can ask this question.
    -- Dilip

  7. #7
    Join Date
    Feb 2007
    Posts
    212
    I mean if he is happy with the ease in ASM management or if it made
    his database run fast

  8. #8
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    He is happy in general. That's the future and how do you live without it until now :-)
    About the ASM, yes, the performance shoudl be better it stipes the IO.
    About the management .. there is still what to be expected, but no serious problems. Generally, if you use RAC or you do not have hardware storage array, then definitely go for it , the benefit will be great
    If running single instance with storage array, then the improvement will not be so significant

    Cheers
    Boris

  9. #9
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Jen -- ASM gives us near-raw device performance -which makes us happy in a very easy to manage environment -which makes us even "happier" :-)))
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  10. #10
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Quote Originally Posted by jennifer2007
    Thanks hunnies so u mean to say it is still ok if I use the old fashion way.
    I just thot i gain better performance when I used ASM.



    What happiness did it bring u dear?
    Kris123? yxez?
    Assistance is Futile...

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