star_transformation_enabled = true
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: star_transformation_enabled = true

  1. #1

    Smile

    Can someone explain what this does in the pfile?

    star_transformation_enabled = true

    The brain is a wonderful organ; it starts working the moment you get up in the morning and does not stop until you get into the office.

  2. #2
    it tells Oracle you are using a star schema design (data warehouse) and it will allow oracle to rewrite your query (during parsing?) to utilize the star schema architecture.

    I don't know how much it helps, but I couldn't see NOT using it.

    look at the docs for Datawarehousing. It's pretty self explained.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is the doc that could help you to undestand the star schema.

    http://www.oradoc.com/ora816/server....ical.htm#97642

    Good luck,
    Sam

    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    However - this only has benefit when dealing with an actual star schema. Oracle support just had us turn the option off (disclaimer: It was not I that turned it on - we are OLTP) - they suspect that it might be the cause of some problems. I am told there have been issues related to that option.

    - Chris

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