Oracle WebCenter Content (MOSC)

MOSC Banner

UCM Query in Users Table Performance Issue

edited Jun 21, 2013 11:41AM in Oracle WebCenter Content (MOSC) 6 commentsAnswered ✓
Guys,

I am working in the UCM 10.1.3.5.1 Build 7.2.97 version, and our DBA's noticed that the following query is consuming too much CPU.

SELECT * FROM Users WHERE LOWER(dName) = LOWER(:"SYS_B_0") 

Dba's asked me a recomendation for creation of indexes. Anyone knows if there is a documentation about this case?

Best Regards,

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center