11-19-2010 01:06 AM - edited 03-01-2019 02:22 PM
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
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?
Solved! Go to Solution.
12-01-2010 08:39 AM
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.
12-01-2010 08:39 AM
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.
12-01-2010 10:59 AM
There are no words to describe my appreciation for your complete answer . Thank you and keep up the good work.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide