Trace Performance problem for Application. [message #361144] |
Tue, 25 November 2008 03:07 |
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 2598 times)
|
|
|