Home » Infrastructure » Unix » Trace Performance problem for Application. (Solaris 9 Spark/Oracle 10.2.0.3)
Trace Performance problem for Application. [message #361144] Tue, 25 November 2008 03:07 Go to next message
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 2545 times)
Re: Trace Performance problem for Application. [message #361145 is a reply to message #361144] Tue, 25 November 2008 03:08 Go to previous messageGo to next message
crazypeter2005
Messages: 29
Registered: September 2008
Location: Peking China
Junior Member
No Message Body
  • Attachment: Folder.txt
    (Size: 134.37KB, Downloaded 1995 times)
Re: Trace Performance problem for Application. [message #361147 is a reply to message #361144] Tue, 25 November 2008 03:10 Go to previous messageGo to next message
crazypeter2005
Messages: 29
Registered: September 2008
Location: Peking China
Junior Member
Some one say it is an oracle bug, but I am not sure.
Some say it is sql version too much and hard parse ......
Please help me check it.
Re: Trace Performance problem for Application. [message #361149 is a reply to message #361144] Tue, 25 November 2008 03:16 Go to previous messageGo to next message
crazypeter2005
Messages: 29
Registered: September 2008
Location: Peking China
Junior Member
Here is the statpack file
  • Attachment: test11-12.txt
    (Size: 111.60KB, Downloaded 2746 times)
Re: Trace Performance problem for Application. [message #361307 is a reply to message #361144] Tue, 25 November 2008 19:01 Go to previous messageGo to next message
crazypeter2005
Messages: 29
Registered: September 2008
Location: Peking China
Junior Member
Any one, any ideas?
Re: Trace Performance problem for Application. [message #361492 is a reply to message #361307] Wed, 26 November 2008 11:29 Go to previous messageGo to next message
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
icon12.gif  Re: Trace Performance problem for Application. [message #361636 is a reply to message #361144] Thu, 27 November 2008 04:00 Go to previous message
crazypeter2005
Messages: 29
Registered: September 2008
Location: Peking China
Junior Member
Thanks! I will check this pdf first.
I will update when I get something update.
Have a nice Thanksgiving Day! Razz
Previous Topic: Ftp from Unix box to Windows
Next Topic: /usr/bin/uuencode cannot execute binary file
Goto Forum:
  


Current Time: Thu Mar 28 10:52:48 CDT 2024