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

Was this page helpful? Yes No Submitting... Thank you

Comments