Monday Feb 27, 2012

Demantra T_UPDATE Performance Issues? Supply an Enhanced AWR Report Using Logger

When communicating with Support or Development the performance issue you are experiencing with the T_UPDATE object, follow the instructions below to produce an AWR report with logger turned on. This may expedite your solution.

Please do the following:

1. Turn on the Logger Category 'appserver.update.sql' via server admin page.
    For example: http://<server>:8080/demantra/admin and then press the Logger Manager link.

2. Launch the AWR Report. See note 1279115.1, Producing an AWR Report for Demantra Performance Troubleshooting

3. Re-run the problematic scenario.

4. Turn off the Logger Category from step 1.

5. Supply the AWR report for the time period matching the Logger Category switch.

6. Supply the tables whose name starts with "T_UPDATE_". If they are very big then please list the T_UPDATE_  table names and their row counts.

About

This blog delivers the latest information regarding performance and install/upgrade. Comments welcome

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today