Oracle WebCenter Content (MOSC)

MOSC Banner

UCM 10g database query tuning

edited Jun 4, 2013 4:22AM in Oracle WebCenter Content (MOSC) 2 commentsAnswered
Hi all,

Back from an extensive leave from this forum, indeed.

And I have a question to ask myself, this time: upon having problems with some slow loading pages in UCM, the DBA team came to the conclusion that it would be a smart move to add compiler hints to the queries that caused the drop in performance.

I have not found a place where I could insert these hints directly; the queries are being built dynamicly with the use of idoc-script and I couldn't yet find the start of the query where I could insert the compiler hint. While I have not given up this quest yet, I wanted to know if anyone has experience adding compiler hints within UCM queries. They can be added in the query resources no doubt, but I have never seen or heard anyone do it.

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

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