Questions on OFSA 4.5 With Oracle RDBMS 10g Installation (Doc ID 381564.1)

Last updated on NOVEMBER 30, 2009

Applies to:

Oracle Financial Data Manager - Version: 4.5.39
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version: 4.5
Checked for relevance on 30-Nov-2009.

Goal

Question 1: DBCA (Database Configuration Assistant)

Is it supported to create the OFSA database using DBCA (Database Configuration Assistant)?

Question 2: AUM (Automatic Undo Management)

Does OFSA support the use of AUM (Automatic Undo Management) in 10g, or should rollback segments only be used ?

Question 3: COMPATIBLE db parameter

What should be the value of the parameter "Compatible"?

Question 4: Spfile

Can OFSA use the server parameter file (spfile)?

Question 5: Locally Managed Tablespaces

Should OFSA tablespace(s) be locally managed or dictionary managed tablespaces?

Question 6: PGA_AGGREGATE_TARGET db parameter

Is OFSA certified to use the PGA_AGGREGATE_TARGET database parameter?
Or is it necessary to configure it to use the sort_area_size parameter?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms