3 Replies Latest reply: Jun 19, 2014 2:37 AM by Chrisjenkins-Oracle RSS

    many IX and S locks found

    2690604

      Hi Chris

       

      There are so many IX and S locks when i run ttxactadmin as below, and there are error 6003 in the tterrors.log. I am not sure how it comes and how i can do to avoid so many locks (IX,S), as the locks seem to lead to the poor performance.

       

      Regards

      Li

       

      [timesten@policies info]$ ttxactadmin tt_1122

      2014-06-10 19:39:59.124

      /opt/TimesTen/tt1122/info/TT_1122

      TimesTen Release 11.2.2.6.0

       

      Outstanding locks

       

      PID     Context            TransID     TransStatus Resource  ResourceID           Mode  SqlCmdID             Name

       

      Program File Name: ttcserver

        Client: zhanglei01 (192.168.3.97) PID: 652 ConnId: 3

       

      13193   0x122141e0            3.6218256 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63070070280          S     63070070280         

                                                         Command   63070088488          S     63070088488         

       

      Program File Name: java

       

      22898   0x2abb70744190       68.192079 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63135962640          S     63135962640         

       

              0x2abb740a8fd0       26.332773 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63135962640          S     63135962640         

       

      Program File Name: java

       

      27257   0x1ee88010           28.61798  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x1efabdc0           14.135708 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x1f234d60           20.212847 Active      Database  0x01312d0001312d00   IX    0                   

       

              0x1f3c4d20           69.61019  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x1f42bb50           61.55575  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x1f520090           18.144761 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x1f75fd50           40.54027  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x1f802700           32.60926  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x1f96ee00           13.133386 Active      Database  0x01312d0001312d00   IX    0                   

       

              0x1fa97510           23.66043  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x1fab74a0           15.263987 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x1fb13ee0           62.58715  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x1fbe70b0           22.54699  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x1fd67b80           70.58108  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x1fe5a1e0          108.19195  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x20569c50           83.48231  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x206c74d0           88.44535  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x20795c60           94.135147 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2aaab80fbfe0       82.51766  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x2aaab8198070       39.66183  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2aaac85cb210        4.4862402 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x2aaac8a79070        5.4231353 Active      Database  0x01312d0001312d00   IX    0                   

       

              0x2aaac8ade2b0        6.2251763 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2aaac8b4f630        7.1958134 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x2aaac8bd1360        8.2970264 Active      Database  0x01312d0001312d00   IX    0                   

       

              0x2aaac8c53090        9.948962 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2aaac8cd4dc0       10.4442556 Active      Database  0x01312d0001312d00   IX    0                   

       

              0x2aaac8d56af0       11.3089531 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2aaac8dd8820       12.3377348 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb7001aca0       16.1092282 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb700983f0       17.216793 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x2abb700fd630       19.546665 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb701dd740       27.62472  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x2abb70287980       54.131520 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb703267b0      100.161812 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb703a0ce0      114.18564  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x2abb780393a0       29.61830  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x2abb7807f6b0       33.69272  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x2abb7811cd40       46.59031  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x2abb78131930       47.57511  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb781e5d40       86.49723  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x2abb782149f0       37.60371  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb782be9e0      106.16739  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb7c0dd800       34.59934  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x2abb7c1717b0       43.58632  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb7c1b69d0       50.48246  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb7c2c7290       99.77142  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb800f7ce0       42.58233  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb8014ca40       49.45579  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x2abb801ef220       55.53388  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb802db740      101.205712 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb84016810       30.59694  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x2abb8403ba10       31.61627  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x2abb840a7710       35.49096  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   63078042632          S     63078042632         

       

              0x2abb84171bd0       41.62948  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb841c9480       45.62825  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb8428d650       48.59628  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb843a5730       76.60185  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb843d2c10       80.47384  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb844890e0       95.158977 Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb844ebcb0      113.17537  Active      Database  0x01312d0001312d00   IX    0                   

       

              0x2abb88069430       36.68769  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb880e7110       38.55534  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb88183df0       44.54232  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb8820d230       53.29378  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb88261e60       51.59713  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb882b6a90       52.60489  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb882fb6b0       56.59902  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb8835e750       64.56058  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb883f4b80       72.56333  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb884b2090       98.70919  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208         

       

              0x2abb885172d0      102.88736  Active      Database  0x01312d0001312d00   IX    0                   

                                                         Command   62926043208          S     62926043208   

       

       

      [timesten@policies logs]$ tail -50 tterrors.log

      18:56:23.96 Warn:    :  3644: 3648/0x41bae200: sbOLUndoByConn: oplog stack for connid 21 (java) pid 23180: <none>

      18:56:23.96 Warn:    :  3644: 3648/0x444a9200: sbOLUndoByConn: oplog stack for connid 130 (java) pid 23180: <none>

      18:56:23.96 Warn:    :  3644: 3648/0x46acf200: sbOLUndoByConn: oplog stack for connid 172 (java) pid 23180: <none>

      18:56:23.96 Warn:    :  3644: 3648/0x44cb1200: sbOLUndoByConn: oplog stack for connid 140 (java) pid 23180: <none>

      18:56:23.96 Warn:    :  3644: 3648/0x44db2200: sbOLUndoByConn: oplog stack for connid 141 (java) pid 23180: <none>

      18:56:23.96 Warn:    :  3644: 3648/0x44eb3200: sbOLUndoByConn: oplog stack for connid 142 (java) pid 23180: <none>

      18:56:23.96 Warn:    :  3644: 3648/0x4359a200: sbOLUndoByConn: oplog stack for connid 111 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x446ab200: sbOLUndoByConn: oplog stack for connid 133 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x452b7200: sbOLUndoByConn: oplog stack for connid 146 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x44fb4200: sbOLUndoByConn: oplog stack for connid 143 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x42287200: sbOLUndoByConn: oplog stack for connid 14 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x453b8200: sbOLUndoByConn: oplog stack for connid 147 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x455ba200: sbOLUndoByConn: oplog stack for connid 149 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x454b9200: sbOLUndoByConn: oplog stack for connid 148 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x456bb200: sbOLUndoByConn: oplog stack for connid 150 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x458bd200: sbOLUndoByConn: oplog stack for connid 152 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x459be200: sbOLUndoByConn: oplog stack for connid 153 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x45bc0200: sbOLUndoByConn: oplog stack for connid 155 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x45abf200: sbOLUndoByConn: oplog stack for connid 154 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x460c5200: sbOLUndoByConn: oplog stack for connid 161 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x463c8200: sbOLUndoByConn: oplog stack for connid 164 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x472d7200: sbOLUndoByConn: oplog stack for connid 181 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x464c9200: sbOLUndoByConn: oplog stack for connid 165 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x462c7200: sbOLUndoByConn: oplog stack for connid 163 (java) pid 23180: <none>

      18:56:23.97 Warn:    :  3644: 3648/0x4288d200: sbOLUndoByConn: oplog stack for connid 96 (java) pid 23180: <none>

      18:56:23.98 Warn:    :  3644: 3648/0x461c6200: sbOLUndoByConn: oplog stack for connid 162 (java) pid 23180: <none>

      18:56:23.98 Warn:    :  3644: 3648/0x45dc2200: sbOLUndoByConn: oplog stack for connid 157 (java) pid 23180: <none>

      18:56:23.98 Warn:    :  3644: 3648/0x45fc4200: sbOLUndoByConn: oplog stack for connid 160 (java) pid 23180: <none>

      18:56:23.98 Warn:    :  3644: 3648/0x467cc200: sbOLUndoByConn: oplog stack for connid 169 (java) pid 23180: <none>

      18:56:23.98 Warn:    :  3644: 3648/0x442a7200: sbOLUndoByConn: oplog stack for connid 128 (java) pid 23180: <none>

      18:56:23.98 Warn:    :  3644: 3648/0x468cd200: sbOLUndoByConn: oplog stack for connid 170 (java) pid 23180: <none>

      18:56:23.98 Warn:    :  3644: 3648/0x44aaf200: sbOLUndoByConn: oplog stack for connid 138 (java) pid 23180: <none>

      18:56:23.98 Warn:    :  3644: 3648/0x44bb0200: sbOLUndoByConn: oplog stack for connid 139 (java) pid 23180: <none>

      18:56:23.98 Warn:    :  3644: 3648/0x447ac200: sbOLUndoByConn: oplog stack for connid 134 (java) pid 23180: <none>

      18:56:23.98 Warn:    :  3644: 3648/0x46cd1200: sbOLUndoByConn: oplog stack for connid 174 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x46ed3200: sbOLUndoByConn: oplog stack for connid 177 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x46fd4200: sbOLUndoByConn: oplog stack for connid 178 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x46dd2200: sbOLUndoByConn: oplog stack for connid 175 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x46bd0200: sbOLUndoByConn: oplog stack for connid 173 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x470d5200: sbOLUndoByConn: oplog stack for connid 179 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x471d6200: sbOLUndoByConn: oplog stack for connid 180 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x40573250: sbOLUndoByConn: oplog stack for connid 186 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x476db200: sbOLUndoByConn: oplog stack for connid 185 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x475da200: sbOLUndoByConn: oplog stack for connid 184 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x473d8200: sbOLUndoByConn: oplog stack for connid 182 (java) pid 23180: <none>

      18:56:23.99 Warn:    :  3644: 3648/0x474d9200: sbOLUndoByConn: oplog stack for connid 183 (java) pid 23180: <none>

      18:56:24.00 Warn:    :  3644: 3648/0x45ec3200: sbOLUndoByConn: oplog stack for connid 158 (java) pid 23180: <none>

      19:06:41.64 Warn:    :  3644: 3718/0x1570ca20: sbLogBufGCLockENQNoErr: The commit is performed without the benefit of group commit optimization (error 6003)

      19:15:41.69 Warn:    :  3644: 3718/0x1570ca20: sbLogBufGCLockENQNoErr: The commit is performed without the benefit of group commit optimization (error 6003)

      19:32:41.67 Warn:    :  3644: 3718/0x1570ca20: sbLogBufGCLockENQNoErr: The commit is performed without the benefit of group commit optimization (error 6003)

        • 1. Re: many IX and S locks found
          Chrisjenkins-Oracle

          The locks are not your problem here:

           

          An IX lock is a very weak lock held at a high level to indicate that the connections is doing something on a lower level object. So here these IX locks simply mean that the connection has an active database operation. They do not block other operations nor cause lock timeouts.

           

          The S locks here are locks on shared commands (prepared statements) meaning that the connection has an open cursor on the associated statement. They do not cause lock timeouts nor do they block other operations.

           

          When you get a 6003 lock timeout error in the application, the associated error text contains a great deal of information; what is the error text for the errors that you are seeing? That should help you determine where the real lock contention lies. If your application does not report/log that text then it needs to do so...

           

          These messages:


          sbOLUndoByConn: oplog stack for connid 21 (java) pid 23180: <none>


          Indicate that a process exited (or aborted, or was killed) while it had an in progress database operation. That is usually indicative of poor application implementation. Applications should not exit while they have in progress operations. Applications should ensure that before exiting they (a) commit or rollback and then (b) execute a proper disconnection call before the process exits. This is especially important in multi-threaded processes or any process that utilised multiple database connections. TimesTen will cleanup in these circumstances but the cleanup process takes some resources and may block other operations while it is in progress.


          These messages:


          sbLogBufGCLockENQNoErr: The commit is performed without the benefit of group commit optimization (error 6003)


          usually only occur if you are using DurableCommits=1 and they typically mean that the workload you are running is very write intensive and the hardware (storage) is really not up to the job. They are warnings rather than errors.


          If you can describe your setup in more detail we may be able to provide additional feedback or guidance.


          Chris


          • 2. Re: many IX and S locks found
            2690604

            Hi Chris

            Thanks for your kind reply! It is very helpful to look into the problems and find some better resolutions.

            I simply kill the PID associated to LOCKS, I cann't but have to kill the PID accossiated to the lock cause they really degrade the performance.

            "When you get a 6003 lock timeout error in the application, the associated error text contains a great deal of information; what is the error text for the errors that you are seeing? That should help you determine where the real lock contention lies. If your application does not report/log that text then it needs to do so..."

            ---you mean the error text in the JAVA application or in TT?

             

            Here is the TT configuration, most of attributes are set by default.

            [timesten@policies info]$ cat sys.odbc.ini

            [ODBC Data Sources]

            TT_1122=TimesTen 11.2.2 Driver

            [TT_1122]

            Driver=/opt/TimesTen/tt1122/lib/libtten.so

            DataStore=/opt/TimesTen/tt1122/info/TT_1122

            DatabaseCharacterSet=ZHS16GBK

            ConnectionCharacterSet=ZHS16GBK

            PermSize=60000

            TempSize=8000

            OracleNetServiceName=vedb

            Connections=300

             

            [ODBC Data Sources]

            tt_1122_c=TimesTen 11.2.2 Client Driver

            [tt_1122_c]

            TTC_SERVER=tt_1122_c_s

            TTC_SERVER_DSN=tt_1122

             

            [timesten@policies info]$ ttisql "dsn=tt_1122;uid=cacheuser;pwd=timesten;oraclepwd=oracle";

             

            Copyright (c) 1996, 2013, Oracle and/or its affiliates. All rights reserved.

            Type ? or "help" for help, type "exit" to quit ttIsql.

             

             

             

            connect "dsn=tt_1122;uid=cacheuser;pwd=timesten;oraclepwd=oracle";

            Connection successful: DSN=TT_1122;UID=cacheuser;DataStore=/opt/TimesTen/tt1122/info/TT_1122;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/opt/TimesTen/tt1122/lib/libtten.so;PermSize=60000;TempSize=8000;Connections=300;TypeMode=0;OracleNetServiceName=vedb;

            (Default setting AutoCommit=1)

            Command> call  ttConfiguration;

            < CacheAwtMethod, 1 >

            < CacheAwtParallelism, 1 >

            < CacheGridEnable, 1 >

            < CacheGridMsgWait, 60 >

            < CkptFrequency, 600 >

            < CkptLogVolume, 0 >

            < CkptRate, 0 >

            < CommitBufferSizeMax, 0 >

            < ConnectionCharacterSet, ZHS16GBK >

            < ConnectionName, tt_1122 >

            < Connections, 300 >

            < DDLCommitBehavior, 0 >

            < DDLReplicationAction, INCLUDE >

            < DDLReplicationLevel, 2 >

            < DataBaseCharacterSet, ZHS16GBK >

            < DataStore, /opt/TimesTen/tt1122/info/TT_1122 >

            < DynamicLoadEnable, 1 >

            < DuplicateBindMode, 0 >

            < DurableCommits, 0 >

            < DynamicLoadErrorMode, 0 >

            < Isolation, 1 >

            < RangeIndexType, 1 >

            < LockLevel, 0 >

            < LockWait, 10 >

            < LogAutoTruncate, 1 >

            < LogBufMB, 64 >

            < LogBufParallelism, 4 >

            < LogDir, /opt/TimesTen/tt1122/info/ >

            < LogFileSize, 64 >

            < LogFlushMethod, 1 >

            < LogPurge, 1 >

            < Logging, 1 >

            < MemoryLock, 0 >

            < NLS_LENGTH_SEMANTICS, BYTE >

            < NLS_NCHAR_CONV_EXCP, 0 >

            < NLS_SORT, BINARY >

            < OracleNetServiceName, vedb >

            < PLSCOPE_SETTINGS, IDENTIFIERS:NONE >

            < PLSQL, 1 >

            < PLSQL_CCFLAGS, <NULL> >

            < PLSQL_CODE_TYPE, INTERPRETED >

            < PLSQL_CONN_MEM_LIMIT, 100 >

            < PLSQL_MEMORY_ADDRESS, 0x0000007fa0000000 >

            < PLSQL_MEMORY_SIZE, 32 >

            < PLSQL_OPTIMIZE_LEVEL, 2 >

            < PLSQL_TIMEOUT, 30 >

            < PassThrough, 0 >

            < PermSize, 60000 >

            < PermWarnThreshold, 90 >

            < Preallocate, 0 >

            < PrivateCommands, 0 >

            < QueryThreshold, 0 >

            < RACCallback, 1 >

            < ReceiverThreads, 1 >

            < RecoveryThreads, 1 >

            < ReplicationApplyOrdering, 0 >

            < ReplicationParallelism, 1 >

            < ReplicationParallelismBufferMB, 64 >

            < ReplicationTrack, -1 >

            < SQLQueryTimeout, 0 >

            < TempSize, 8000 >

            < TempWarnThreshold, 90 >

            < Temporary, 0 >

            < TypeMode, 0 >

            < UID, CACHEUSER >

            65 rows found.

            Command>

             

            Regards

            Li

            • 3. Re: many IX and S locks found
              Chrisjenkins-Oracle

              I meant the full text associated with the lock timeout SQL exception received by the Java application.

               

              As I said, these locks are *not* causing a performance problem for you. If you are seeing degraded performance then it is due to some other cause, possibly not even related to TimesTen. You need to determine what is really causing your performance issue but for sure it is not the locks shown in your original post.

               

              When you kill the process that is the cause of all the messages of the form:

               

              18:56:23.99 Warn:    :  3644: 3648/0x476db200: sbOLUndoByConn: oplog stack for connid 185 (java) pid 23180: <none>

               

              and these could have some (minor) impact - so do not kill processes like this.

               

              Chris