cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

1177
Views
0
Helpful
2
Replies
Highlighted

Collection Manager Oracle Database support

Hello,

I want to know if there is any official reply to these questions on CM with Oracle Database:

1) Versions of Oracle Supported(We have Oracle 11gR2 on a RAC environment)

2) Recommendations for

  • SGA(System Global Area MB) :
  • PGA(Program Global Area MB):

3) Recommendations for Database Block Size MB:

4) Recommendations for Database Character Set:

5) Recommendations for National Character Set:

6) Recommendations for tablespaces needed

7) Database users that must be created an the privileges they must have on the database objects

I think in the first issue, it must be OK if it works with JDBC right?

      TIA, Nicos Nicolaides
      1 ACCEPTED SOLUTION

      Accepted Solutions
      Participant

      Re: Collection Manager Oracle Database support


      1) Versions of Oracle Supported(We have Oracle 11gR2 on a RAC environment).

      The following is a list of supported external databases:

      Sybase—Version 12.5.1 and higher

      Oracle—Versions 9.2, 10g, and 11g

      MySQL—Version 4.1 and higher

      http://www.cisco.com/en/US/docs/cable/serv_exch/serv_control/broadband_app/rel36x/cm_qsg/cm_qsg.html

      2) Recommendations for

          * SGA(System Global Area MB) : no such recommendations found, use default or per need.
          * PGA(Program Global Area MB): no such recommendations found, use default or per need.

      3) Recommendations for Database Block Size MB:
      DB_BLOCK_SIZE : Specifies (in bytes) the size of Oracle database blocks. Typical values are 4096 and 8192. 8192 is recommended for better performance. The value of this parameter must be a multiple of the physical block size at the device level.

      4) Recommendations for Database Character Set: no such recommendations found, use default or per need.

      5) Recommendations for National Character Set: no such recommendations found, use default or per need.

      6) Recommendations for tablespaces needed :
      Cisco provides a sizing sheet that helps to configure the customized sizes by a given RDR rate and data storage period.
      For example, if the global insert rate is 5000 and the data storage period is 90 days, the sizing sheet provides the total needed space of 7 terabytes, and space parameters for each tablespace, data file, table, and index.

      The file is Attached to the thread.
      This may also help.
      http://www.cisco.com/en/US/docs/cable/serv_exch/serv_control/broadband_app/rel36x/cmug/Configuring_Databases.html#wp1055997

      You can also use rolling window feature to help improve performance as this is supported by the CM.
      Storage Unit with Oracle version 11 they can make use of inbuilt rolling window feature. For your reference:
      http://www.oracle.com/technology/obe/11gr1_db/bidw/etl/etl.htm#t4.

      7) Database users that must be created an the privileges they must have on the database objects
      This is dependent on your DB admin, usually the CM only needs 1 user/pass to access the DB for data access. All other users and privileges are in your control and can be done to suit your needs.

      I think in the first issue, it must be OK if it works with JDBC right? Yes.

      View solution in original post

      2 REPLIES 2
      Participant

      Re: Collection Manager Oracle Database support


      1) Versions of Oracle Supported(We have Oracle 11gR2 on a RAC environment).

      The following is a list of supported external databases:

      Sybase—Version 12.5.1 and higher

      Oracle—Versions 9.2, 10g, and 11g

      MySQL—Version 4.1 and higher

      http://www.cisco.com/en/US/docs/cable/serv_exch/serv_control/broadband_app/rel36x/cm_qsg/cm_qsg.html

      2) Recommendations for

          * SGA(System Global Area MB) : no such recommendations found, use default or per need.
          * PGA(Program Global Area MB): no such recommendations found, use default or per need.

      3) Recommendations for Database Block Size MB:
      DB_BLOCK_SIZE : Specifies (in bytes) the size of Oracle database blocks. Typical values are 4096 and 8192. 8192 is recommended for better performance. The value of this parameter must be a multiple of the physical block size at the device level.

      4) Recommendations for Database Character Set: no such recommendations found, use default or per need.

      5) Recommendations for National Character Set: no such recommendations found, use default or per need.

      6) Recommendations for tablespaces needed :
      Cisco provides a sizing sheet that helps to configure the customized sizes by a given RDR rate and data storage period.
      For example, if the global insert rate is 5000 and the data storage period is 90 days, the sizing sheet provides the total needed space of 7 terabytes, and space parameters for each tablespace, data file, table, and index.

      The file is Attached to the thread.
      This may also help.
      http://www.cisco.com/en/US/docs/cable/serv_exch/serv_control/broadband_app/rel36x/cmug/Configuring_Databases.html#wp1055997

      You can also use rolling window feature to help improve performance as this is supported by the CM.
      Storage Unit with Oracle version 11 they can make use of inbuilt rolling window feature. For your reference:
      http://www.oracle.com/technology/obe/11gr1_db/bidw/etl/etl.htm#t4.

      7) Database users that must be created an the privileges they must have on the database objects
      This is dependent on your DB admin, usually the CM only needs 1 user/pass to access the DB for data access. All other users and privileges are in your control and can be done to suit your needs.

      I think in the first issue, it must be OK if it works with JDBC right? Yes.

      View solution in original post

      Re: Collection Manager Oracle Database support

      There are no words to describe my appreciation for your complete answer . Thank you and keep up the good work.

      TIA, Nicos Nicolaides
      CreatePlease to create content
      Content for Community-Ad
      FusionCharts will render here