Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

Siebel on Oracle 12c - recommended parameters and statistics collection?

edited Oct 5, 2015 8:55AM in Siebel System Admin, Install and Upgrade (MOSC) 13 commentsAnswered ✓

Hi All,

we've recently upgraded to 12.1.0.2 in our development and test environments (Siebel 8.1.1.11).

I know Siebel 8.1.1.11 comes with support for 12c. However, all the documents on MOS regarding statistics collection and recommended optimizer parameters do only talk about 10g and 11g.

Now we found that collecting statistics using the recommended coe_siebel_stats.sql script provided on MOS results in horrible Siebel performance on 12c. The query performance gets better when using the default settings for dbms_stats package instead of the recommended script.

My question: When will there be an official recommendation for 12c settings with 8.1.1.11 and onwards? I couldn't find any recommendations for 12c parameters.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

SBL Sys Admin Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center