Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Configuration Management System (CMS)2018.05

Use > Database > Deploying the Oracle Server Database > Oracle Server Configuration and Sizing Guidelines > Oracle Tablespace Settings

Oracle Tablespace Settings

This section describes the storage settings and file sizing guidelines for data tablespaces, temporary tablespaces, redo logs, and undo tablespaces.

Data Tablespace Settings

The following table specifies the recommended sizes for Universal CMDB tablespaces:

Tablespace	Universal CMDB Deployment		Remarks
Tablespace	Small	Large	Remarks
CMDB	5 GB	60 GB	The specified size is a minimum requirement.

Note The data in the table is only relevant when the following parameters are assigned their default values:

the Oracle parameter deferred_segment_creation is set to true (only relevant for Oracle 11g R2)
the tablespace setting INITIAL_EXTENT is set to 65,536

Data Tablespace Default Storage Settings

The storage settings for data tablespaces should be:

Locally managed tablespace
Automatic segment space management
Automatic local extent management

The following command can be used to create a data tablespace:

CREATE TABLESPACE <tablespace name> DATAFILE ’<data file full path>’ REUSE SIZE <file size>
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

For example:

CREATE TABLESPACE APPTBS DATAFILE
’/ORADATA/ORCL/APPTBS1.DBF’ REUSE SIZE 1024M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

System Tablespace Settings

The following table specifies the recommended settings for system tablespaces:

Tablespace	Universal CMDB Deployment
Tablespace	Small	Large
SYSTEM	2 GB	5 GB
SYSAUX	2 GB	5 GB

The System Tablespace storage default settings should be:

Locally managed tablespace
Segment space management:
- SYSAUX: Automatic
- SYSTEM: Manual
Automatic local extent management

Temporary Tablespace Settings

The following table specifies the recommended settings for temporary tablespaces:

Tablespace	Universal CMDB Deployment		Remarks
Tablespace	Small	Large	Remarks
TEMP	1 GB	10 GB	Use multiple files with large tablespaces.
TEMP storage settings	Uniform allocation: 2 MB	Uniform allocation: 2 MB	Should be locally managed (Uniform allocation). Tablespaces should be of a temporary type (use of TEMPFILE). Segment space management in temporary tablespaces is manual.

Redo Log Settings

The following table specifies the recommended settings for redo log files:

Setting	Universal CMDB Deployment
Setting	Small	Large
Redo log file size	100 MB	200 MB - 500 MB
Minimum number of groups	4	4
Minimum number of members per group	2	2

Undo Segment Settings

The following table specifies the recommended Undo settings:

Setting	Universal CMDB Deployment		Remarks
Setting	Small	Large	Remarks
Undo tablespace size	1 GB	10 GB	The number of segments, the minimum number of extents, and the rollback segment size (initial, next) are all set automatically by Oracle.
UNDO_ MANAGEMENT parameter	AUTO		Oracle default value
UNDO_ RETENTION parameter	Oracle default value

Send Help Center feedback