Text only | Text with Images

OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: Trambak on March 18, 2013, 08:08:53 PM

Title: Delay between creation and writing to a System Log table
Post by: Trambak on March 18, 2013, 08:08:53 PM
All
   We are seeing a difference in timestamps in the arsseg table between the START_DATE and the POST_DATE on System Log table.Our system is getting used heavily and we do see a drop in CMOD performance related to query return and get document during the interval between START DATE and POST DATE. We have seen similar delay in the previous SL creations also apart from SL2 and SL3. The STOP DATE on SL6 is 03/12/13 10:08:44.

System Log table SL7
START DATE - 03/12/13 10:08:44
POST DATE - 03/12/13 10:09:21

There seems to be a difference of around 37 seconds. Is this common?

Any suggestions/pointers on what may be going on?
Title: Re: Delay between creation and writing to a System Log table
Post by: Justin Derrick on March 19, 2013, 10:50:27 AM
Simply sounds like you've got some slowness relating to your database.

You didn't mention which platform / database combo you're running.  What versions are you on?
Title: Re: Delay between creation and writing to a System Log table
Post by: Trambak on March 19, 2013, 01:35:25 PM
OS - AIX (Library Server) 6.1.0.0, RHEL (Object Server) 5.8 (Tikanga)
It's a cache only system.
Database - Oracle 11.2.0.3
CMOD - 8.5.0.6
Text only | Text with Images