Database Implementation

Database responsiveness is critical for the CMS application. CMS is a typical online transaction processing (OLTP) application, which requires good read and write performance. It is recommended for the database administrator to identify workloads and plan the DB online maintenance scripts.

Let us assume a scenario where a DB insert query is slow and you would like to understand the DB bottleneck. First, identify if it is an infrastructure issue (bottlenecks in CPU, memory, I/O, and so on). If not, you might need to look at the following DB performance bottleneck issues:

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)`

tempdb bottlenecks

Transaction log bottlenecks deadlocks

Indexing issues

Always use the Database Guide and the Support Matrix as validators to check if you have the database server set up properly. Before the UCMDB server goes for production, make sure the DB administrator has enabled monitoring and is capturing all required metrics for effective analysis. If you have products such as Micro Focus Operations Manager agent with Oracle SPI, the agent will have some OOTB policies to capture the DB metrics which can then be visualized via Micro Focus Performance Manager.

If you have Oracle installed on UNIX machine which has Micro Focus OpenView Performance Agent, then you can customize the parm (/var/opt/perf/parm) file to get Oracle related process information.

Database Infrastructure Requirements (10.2x)