DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.