search cancel

Oracle DB Parameter setup for Clarity

book

Article ID: 187510

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

What are the recommended Oracle parameters for Clarity running on 12.1.0.2 or 12.2.0.2?

Environment

Release : 15.7.1

Component : CA PPM APPLICATION

Resolution

Character Set
AL32UTF8
National Character Set
UTF8/AL16UTF16
nls_date_format
YYYY-MM-DD HH24:MI:SS
nls_sort
BINARY
nls_comp
BINARY
query_rewrite_enabled
true
optimizer_inmemory_aware
false
optimizer_adaptive_reporting_only
true
optimizer_adaptive_plans
false
Cursor_sharing
FORCE


To improve performance on Oracle 12C 12.2.0.2 below parameters need to set additional to the above.

optimizer_features_enable='12.1.0.2'
"_fix_control" = '17800514:0'

Additional Information

More information on the Documentation can be found at Install Clarity PPM.