Oracle 12c recommendations

The database is an important part of BMC Client Management , especially in highly distributed environments. For each of the three basic types of database-Web Application (Web), Online Transaction Processing (OLTP), and Data Warehousing (DW)-the hardware component priorities are different. Client Management works like a web application with web services; it behaves like an OLTP application when integrating all information reported by devices; and it performs like a DW application for report generation, aggregating the results and displaying inventory views.

This topic provides recommendations for the appropriate database configuration for Oracle 12c in highly distributed environments:

Disk layout

When you run the Create_TS.oracle.sql script, which is provided for tablespace creation on your database, BMC recommends that you segregate the tablespaces on different disks, as shown in the following tables:

Tablespaces for tables

Small	Large	Static
BCM_DATA	BCM_EL	BCM_VMCKB
BCM_VM	BCM_INV	BCM_ESIDKB
BCM_WQ	BCM_DELTAINV	BCM_PATCH
—	BCM_VMINV	—
—	BCM_ESIDDATA	—
—	BCM_SCAP	—

Tablespaces for indexes

Small	Large	Static
BCM_INDEX	BCM_ELINDEX	BCM_VMCKBINDEX
BCM_VMINDEX	BCM_INVINDEX	BCM_ESIDKBINDEX
BCM_WQINDEX	BCM_DELTAINDEX	BCM_PATCHINDEX
—	BCM_VMINVINDEX	—
—	BCM_ESIDDATAINDEX	—
—	BCM_SCAPINDEX	—

Recommended minimum disk layout

Disk	Rmp/s	File system	Purpose
1	10 K / 15 K	ext3	/ SYSTEM - ORACLE
1	10 K / 15 K	ext3	/ REDO LOG
1	10 K / 15 K	ext3	/ TABLESPACES FOR TABLES
1	10 K / 15 K	ext3	/ TABLESPACES FOR INDEXES
1	10 K / 15 K	ext3	/ TEMPORARY TABLESPACES

Recommended best disk layout

Disk	Rmp/s	File system	Purpose
1	10 K / 15 K	ext3	/ SYSTEM - ORACLE
2	10 K / 15 K	ext3	/ REDO LOG
1	10 K / 15 K	ext3	/ TABLESPACES FOR SMALL TABLES
1	10 K / 15 K	ext3	/ TABLESPACES FOR LARGE TABLES
1	10 K / 15 K	ext3	/ TABLESPACES FOR STATIC TABLES
1	10 K / 15 K	ext3	/ TABLESPACES FOR SMALL INDEXES
1	10 K / 15 K	ext3	/ TABLESPACES FOR LARGE INDEXES
1	10 K / 15 K	ext3	/ TABLESPACES FOR STATIC INDEXES
1	10 K / 15 K	ext3	/ TEMPORARY TABLESPACES

Recommended RAID implementation

Disk	Rmp/s	RAID level	File system	Purpose
2	10 K / 15 K	10	ext3	/ SYSTEM
8	10 K / 15 K	10	ext3	/ ORACLE + TABLESPACES
2	10 K / 15 K	10	ext3	/ REDO LOG
2	10 K / 15 K	10	ext3	/ TEMPORARY TABLESPACES

Storage capacity sizing

When sizing storage capacity for an Oracle system, you need to consider the following Oracle database components:

Database files
Online REDO log files
Backup/flash data

Database element	Space requirement	20,000 nodes	50,000 nodes	100,000 nodes	150,000 nodes	200,000 nodes
Database files	DB size	20 GB	50 GB	100 GB	150 GB	200 GB
Temporary tablespace	DB size * 0.2	4 GB	10 GB	20 GB	30 GB	40 GB
System/undo tablespace	DB size * 0.1	2 GB	5 GB	10 GB	15 GB	20 GB
Online redo logs	DB size * 0.2	4 GB	10 GB	20 GB	30 GB	40 GB
Archive logs	DB size * 1.0	20 GB	50 GB	100 GB	150 GB	200 GB
Backup/flash data	DB size * 2.0	40 GB	100 GB	200 GB	300 GB	400 GB
Total		90 GB	225 GB	450 GB	675 GB	900 GB

Memory management

Memory management is the most critical and complex part of tuning Oracle databases for performance. Our testing environment confirmed that using AMM provided better performance if the correct initial settings for MEMORY_TARGET are specified.

Number of nodes	MEMORY_TARGET
20,000	16 GB
50,000	24 GB
100,000	48 GB
150,000	72 GB
200,000	96 GB

Initialization parameters

For optimal performance with Client Management , the following Oracle database initialization parameters are recommended.

Parameter	Value
filesystemio_options	SETALL
query_rewrite_enabled	FALSE
optimizer_mode	CHOOSE
optimizer_features_enable	9.2.0
cursor_sharing	FORCE
open_cursors	800
session_cached_cursors	2000
compatible	11.2.0
commit_logging	BATCH
commit_wait	NOWAIT
optimizer_index_cost_adj	20