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

Thread: star_transformation_enabled = true

Hybrid View

  1. #1


    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
    Saskatoon, SK, Canada
    Here is the doc that could help you to undestand the star schema.

    Good luck,


    Life is a journey, not a destination!

  4. #4
    Join Date
    Nov 2000
    Baltimore, MD USA
    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