E-Mail Message:

Applies to

Summary

The Content Server has a high Average Request Time. All Request are Very Slow. Usualy the Thread count going up.

Sources of Errors

1. Database Locks of Tables

   1. Oracle Database

      1. Select for Database Lock

         select
            (select username from v$session where sid=a.sid) blocker,
            a.sid,
            ' is blocking ',
            (select username from v$session where sid=b.sid) blockee,
            b.sid
         from
            v$lock a,
            v$lock b
         where
            a.block = 1
         and
            b.request > 0
         and
            a.id1 = b.id1
         and
            a.id2 = b.id2;

      2. Solution: → Contact your DB Admin he can Remove the Lock.

   2. SQL

      1. SQL Server Locks, Blocked Processes, and Two Easy Ways to Find Them | Diagram (wearediagram.com)

2. To many request from the Clients

   1. Waiting Waiting…