Skip to Main Content

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

WebCenter Content 12.2.1.2 - Performance Issues and infinite requestaudit log

Daniel MerchánJan 4 2017 — edited Jan 9 2017

Hello community and happy new year.

I came back to 2017 with one of my favourites tasks... performance!.

We have a WebCenter Content 12.2.1.2 which is having an average response of IDC Services from 1 to 2 seconds (DOC_INFO, VCR_GET_DOCUMENT_BY_NAME...).

I made all typical checks in a WCC Performance Check.

E.g of times:

VCR_GET_CONTENT_TYPES (12secs)

VCR_GET_DOC... (1,2 to 2 sec)

DOC_INFO (1,2 to 2 sec)

I cannot understand and I am failing in more mechanisms to understan why UCM is serving too slow.

  • Database is not stressed and the report does not shows slow performance queries. (systemdatabase trace)
  • Indexes are not fragmented.
  • WebLogic Managed Servers are working properly with enough resources (no machine limitation).
  • NFS looks to have acceptable Read / Write Speed.
  • VCR_GET_CONTENT_TYPES taught 12 seconds! <-
  • DOC_INFO takes 2 seconds!

Obviously this is affecting our performnace as WebCenter Portal is taking ages to render simple pages as the IDC Service response average is around 1,5 seconds right now.

About the stack trace (requestaudit), it shows: finished request (no data binder) each second ending in a Service (null) called 19028390218391820 times with 0,4 sec of average.

I do not understand from where finished request (no data binder) comes and why it polls UCM too much.

Questions:

  • Any clue int he finished request (no data binder) stack trace shown by requestaudit?. To me this is the most important question because there are like 80 calls each report to a Service (null)
  • The environment is running WCP 12.2.1.2 / WCC 12.2.1.2 with Framework Folders (obviously) and the EBSAdapter is enabled because they are trying to use it.... I never worked before with EBSAdapter. Is it compatible with Framework Folders on behind?
  • Any tip about how can I detect why a simpel DOC_INFO takes 2 seconds to serve when the database serves in milliseconds?.

Thanks.

Kind regards.

This post has been answered by Daniel Merchán on Jan 9 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2017
Added on Jan 4 2017
9 comments
1,088 views