Trace Performance problem for Application. [message #361144] |
Tue, 25 November 2008 03:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
crazypeter2005
Messages: 29 Registered: September 2008 Location: Peking China
|
Junior Member |
|
|
An application based on Oracle 10g
Has following strange scene:
In singleUser API test,
delete a Item will take 700ms, which is normal.
But delete a folder will take 2s! which is unacceptable.
Opatch info:
bash-2.05$ opatch lsinventory
Invoking OPatch 10.2.0.3.0
Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
Oracle Home : /opt/oracle10g
Central Inventory : /opt/oracle/u01/app/oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /opt/oracle10g/oui
Log file location : /opt/oracle10g/cfgtoollogs/opatch/opatch2008-11-25_17-13-53P
M.log
Lsinventory Output file location : /opt/oracle10g/cfgtoollogs/opatch/lsinv/lsinventory2008-11-25_17-13-53PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 2 products installed in this Oracle Home.
Interim patches (5) :
Patch 5892355 : applied on Fri Nov 14 16:21:36 CST 2008
Created on 6 Mar 2007, 22:43:23 hrs PST8PDT
Bugs fixed:
5892355
Patch 5871314 : applied on Fri Nov 14 16:19:21 CST 2008
Created on 15 Feb 2007, 03:54:10 hrs PST8PDT
Bugs fixed:
5871314
Patch 4722328 : applied on Fri Nov 14 16:14:29 CST 2008
Created on 7 Mar 2007, 10:48:04 hrs US/Pacific
Bugs fixed:
4722328
Patch 5556081 : applied on Fri Nov 14 16:04:00 CST 2008
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081
Patch 5557962 : applied on Fri Nov 14 16:03:49 CST 2008
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974
--------------------------------------------------------------------------------
OPatch succeeded.
Following is
1 tkprof file of delete Item operation
2 tkprof file of delete Folder operation
3 Statpack of MultiThread of user delete folder
Please help me, I am mad with these.
Thanks in advance!
-
Attachment: Item.txt
(Size: 74.95KB, Downloaded 3003 times)
|
|
|
|
|
|
|
Re: Trace Performance problem for Application. [message #361492 is a reply to message #361307] |
Wed, 26 November 2008 11:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
the trace shows a total elapsed time of 0.43 sec
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 20 0.01 0.03 0 0 0 0
Execute 20 0.22 0.38 30 172 176 0
Fetch 17 0.01 0.02 8 725 0 229
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 57 0.24 0.43 38 897 176 229
1) make sure there are no triggers that add processing not shown in the trace file (I seem to remember that triggers don't show up in trace??)
2) Read YAPP (signup first)
http://www.oraperf.com/logon.html?rpage=download.php/yapp_anjo_kolk.pdf
|
|
|
|