My Oracle Support Banner

High Load On Delivery Servers When Many Invalid Vanity Urls Are Requested (Doc ID 2518328.1)

Last updated on NOVEMBER 13, 2019

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Goal

Our delivery servers are performing too slow when there are many invalid vanity URL requests for e.g. http://{hostname}/global-en/home works fine but any request which is not valid like http://{hostname}/global-en/home1 and so on takes too much time in order to get response. If such requests are hugely incoming then delivery server is not fast responsive and we see very high load on delivery server.

We would like to know how we can optimize WebReferences table if the rows within runs into millions? Do we need to index this table or fragment this particular table?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.