Topic
  • 1 reply
  • Latest Post - ‏2017-10-11T19:20:34Z by sgarcia0033
joecook
joecook
13 Posts

Pinned topic Oracle database settings for 10.5.2/3.5.2

‏2017-10-05T13:33:46Z | application; tririga

there are a few settings that I wanted to see if anyone has setup in an Oracle database for Tririga

any help would be great.

1. NLS_LENGTH_SEMANTICS be set to CHAR? In current Prod, It's set to Byte - and the Tririga support documentation says this can lead to data loss so they recommend using CHAR.

2. NLS_CHARACTERSET is set to WE8ISO8859P1 in Current Prod but the Support document says it Must be UTF 8 or 16.

3. Block size. This is set to 8k but the documentation recommends using 16k. At DSG.

thanks

Joe

 

  • sgarcia0033
    sgarcia0033
    27 Posts
    ACCEPTED ANSWER

    Re: Oracle database settings for 10.5.2/3.5.2

    ‏2017-10-11T19:20:34Z  

    For #1 & 2, if you are never wanting to store multibyte characters then what you have is fine, but if you are, you need to use what the support documentation suggests.  Once you have your database created, it is difficult and time consuming to change and needs to be done outside of TRIRIGA.

    As for #3, I would encourage you to use 16k as it will allow you better throughput and paging unless you have a strong reason why you need to stay at 8k.

  • sgarcia0033
    sgarcia0033
    27 Posts

    Re: Oracle database settings for 10.5.2/3.5.2

    ‏2017-10-11T19:20:34Z  

    For #1 & 2, if you are never wanting to store multibyte characters then what you have is fine, but if you are, you need to use what the support documentation suggests.  Once you have your database created, it is difficult and time consuming to change and needs to be done outside of TRIRIGA.

    As for #3, I would encourage you to use 16k as it will allow you better throughput and paging unless you have a strong reason why you need to stay at 8k.