Table CSFW_MSESSION_URL Keeps Growing (Doc ID 1331394.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Field Service - Version 12.1.2 to 12.1.2 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 17-Nov-2013***

Symptoms

When accessing the wireless application in Field Service, it stores session related information in the following tables.

CSFW_MSESSION
CSFW_MSESSION_URL
CSFW_MSESSION_COOKIE

As the number of sessions grow, the size of the above mentioned tables is growing fast and hence can lead to performance issues.

There is a need to be able to purge this data when it is not longer required

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms