Accepted Solutions
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.
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.
