Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

SQL Server 19 Siebel Upgrade Woes

in Siebel System Admin, Install and Upgrade (MOSC) 1 commentAnswered

Hi All,

Posting this here since figuring this out was a bit difficult.

We were seeing what we thought was "random slowness" after upgrading to IP 22 and Sql Server 19. For me a query that returned a single row from s_rr_streams ran well under 1 second but when Siebel executed the same it took nearly a minute!

After digging deep into SQL server I found a set of tables that provide much the same information as Oracle's AWR.

Turns out the plan Siebel was using was completely different than mine using SQL from the log file. The Siebel version was using a parametrized query where mine was just a select in SSMS.

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