DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: from DSS to HYBRID, any advise??

  1. #1
    Join Date
    Aug 2000
    Location
    NY
    Posts
    37

    Red face

    I have my database in a DSS environment. Due to business rules, we have decided to go online making it a hybrid system.
    Can any body give the list of likely things (including initlization parameters,etc) that I should consider changing that would help in this transformation?

    Any other advise on moving from DSS to HYBRID environment would be greatly appreciated.

    Thanks

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    It is not that simple. I should see you init.ora first in order to tell you waht do do.

    Here is something anyway:

    1. Reduce the amount of indexes you might have. OLTP and HYBRIDS should use fewer indexes.

    2. You might want to reduce the size of your RBSs if there meant only for DSS (that is big).

    3. You might want to recreate your tables with higher PCTFREE. Was it close to 0 in the DSS?

    4. Eliminate most of the parallel queries.

    5. You might want to to give up (some of) the histogram statistics.

    I also run a HYBRID, getting the balance right is difficult.

  3. #3
    Join Date
    Aug 2000
    Location
    NY
    Posts
    37
    Thanx

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by charity
    Thanx
    You are welcome. Has anyone from this forum switched from DSS to a HYBRID?


  5. #5
    Join Date
    Aug 2000
    Location
    NY
    Posts
    37
    Why do I have to Eliminate most of the parallel queries in the HYBRID SYSTEM?


  6. #6
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    doc id Note:39599.1 on the metalink may help you know why
    sonofsita
    http://www.ordba.net

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