<< Back to previous view

[PSUP-149] max session Created: 16/Jun/20  Updated: 16/Jun/20

Status: In Progress
Project: PUBLIC_SUPPORT
Fix Version/s: None

Type: ubTools - itrprof SQL Analyzer Priority: Major
Reporter: Jose Giner Assignee: ubTools Support
Resolution: Unresolved Votes: 0

File Attachments: File progresst_ora_8544.rar    
Product Version: Oracle Database 12c Standard Edition Release 12.1.0.2.0

 Description   
analyze trace file

 Comments   
Comment by ubTools Support [ 16/Jun/20 10:49 AM ]
Hello!

progresst_ora_8544.rar does not include an Event 10046 trace file. If you have Event 10046 trace file, please attach.





[PSUP-148] library cache pin Created: 03/Jan/18  Updated: 12/Jan/18

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: None

Type: ubTools - itrprof SQL Analyzer Priority: Major
Reporter: Lobezno Aja Assignee: ubTools Support
Resolution: Rejected Votes: 0

File Attachments: File MR011_diag_24837.trc    
Product Version: 11.2.0.4

 Description   
library cache pin

 Comments   
Comment by ubTools Support [ 12/Jan/18 08:45 AM ]
We don't provide public support.




[PSUP-144] Performance Issue Created: 10/May/16  Updated: 19/Jul/16

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: None

Type: ubTools - itrprof SQL Analyzer Priority: Major
Reporter: Musfeq Saleheen Assignee: ubTools Support
Resolution: Customer Timeout Votes: 0

File Attachments: File PROD_ora_1770_AHG000599_0509_140552.trc    
Product Version: 11.2 --> 12.1.0.2.0

 Description   
Application performance

 Comments   
Comment by ubTools Support [ 11/May/16 01:14 PM ]
Hello!

There is no WAIT information in the trace file. But, actual elapsed time is greater than the measured in Oracle calls.

The first line:

CLOSE #18446744071435781424:c=3,e=3,dep=1,type=0,tim=15622922398752

The last line:

EXEC #18446744071435417616:c=531,e=531,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=0,tim=15623068360896

The time difference between the first and last line: 15623068360896 - 15622922398752=145962144 (146 sec)

Please upload your trace file with WAIT info. No BIND calls are required.

Comment by ubTools Support [ 11/May/16 01:15 PM ]
Changing the database version to 12.1.0.2.0.
Comment by ubTools Support [ 11/May/16 01:17 PM ]
This issue has been moved to PUBLIC_SUPPORT from TEST.




[PSUP-139] Change Log: itrprof SQL Analyzer 6.2.8 Created: 16/Dec/13  Updated: 16/Dec/13

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: itrprof SQL Analyzer 6.2.8

Type: ubTools - itrprof SQL Analyzer Priority: Major
Reporter: ubTools Support Assignee: ubTools Support
Resolution: Product Update (Bug) Votes: 0

Product Version: 6.2.8

 Description   
Change Log:
       - Bug: Cursor number changed to String type.
       - itp-05 [1] removed.
       - itp-05 [6] removed.
       - Bug: Calculating statement length in PARSE ERROR line fixed.
       - Bug: Wrong number of "UN-KNOWN statements" in "TRACE FILE STATISTICS" output.
       - Bug: Wrong number of "Unique statements" in "TRACE FILE STATISTICS" output.





[PSUP-136] Change Log: itrprof SQL Analyzer 6.2.7 Created: 28/Feb/13  Updated: 28/Feb/13

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: itrprof SQL Analyzer 6.2.7

Type: ubTools - itrprof SQL Analyzer Priority: Major
Reporter: ubTools Support Assignee: ubTools Support
Resolution: Product Update (Minor) Votes: 0

Product Version: 6.2.7

 Description   
Change Log:
1- Cursor number changed to double type.
2- Binds fixed for Oracle 10g and Oracle 11g.
3- Execution plan exclusive statistics fixed for Oracle 11g.
4- All response time in output changed to elapsed time.
5- SQL Hash and SQLID added.
6- Tuning advice calculation fixed when dependent event cost is less than tuning advice limit.





[PSUP-135] Cannot analyze report Created: 29/May/12  Updated: 04/Feb/13

Status: Resolved
Project: PUBLIC_SUPPORT
Fix Version/s: None

Type: ubTools - itrprof SQL Analyzer Priority: Major
Reporter: Jose Luu Assignee: ubTools Support
Resolution: Answered Votes: 0

File Attachments: Zip Archive OP_TP_SI1_ora_27734_EDA25_TESTER_FOLIO_LOAD_ONLY.zip    
Product Version: Oracle 11g

 Description   
itp-5 [11] : File corrupted.
File name : OP_TP_SI1_ora_27734_EDA25_TESTER_FOLIO_LOAD_ONLY.zip
Line : PARSING IN CURSOR #18446744071469248640 len=141 dep=0 uid=62 oct=3 lid=62 tim=4910139113614 hv=503140487 ad='b9fc4c4d8' sqlid='0djpx18fzun47'

possibly the cursor ID is too large under Oracle 11g as it is a 2 digit number on Oracle 10g



 Comments   
Comment by ubTools Support [ 31/Jan/13 08:01 PM ]
Sorry Jose for the late answer. I've not got a notification or I've deleted it without notice.

You're right. Cursor number is too long in Oracle 11g. I've fixed this issue. I'm planning to upload the new version this weekend. I'll also contact you when upload is done.

Sorry again...

Comment by ubTools Support [ 04/Feb/13 09:19 AM ]
Hello!

It has been fixed itrprof SQL Analyzer 6.2.7. You can analyze your trace file online. It will be available for download this week.





[PSUP-127] Invalid IP Created: 15/Jan/10  Updated: 02/Mar/10

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: None

Type: ubTools - itrprof SQL Analyzer Priority: Blocker
Reporter: Stephen Ochieng Assignee: ubTools Support
Resolution: Customer Timeout Votes: 0

Product Version: ubtools-2.0.0.1

 Description   
I get the error below.

itp-3 [1] : Not authorized.
Cause : Not authorized IP : 0:0:0:0:0:0:0:1
Action : Contact support.



 Comments   
Comment by ubTools Support [ 16/Jan/10 05:58 PM ]
A strange IP returned by the system.

can you please add this 0:0:0:0:0:0:0:1 IP to Authorized Clients by ubAdmin ? Then, restart your servlet container.

Comment by ubTools Support [ 29/Jan/10 12:14 PM ]
Looks it's a V6 IP address.

does it work ?





[PSUP-124] . Created: 17/Oct/08  Updated: 13/Nov/08

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: None

Type: ubTools - itrprof SQL Analyzer Priority: Major
Reporter: yuceh Assignee: ubTools Support
Resolution: Customer Timeout Votes: 0

File Attachments: Zip Archive ar_ora.zip    
Product Version: 10

 Description   
.

 Comments   
Comment by ubTools Support [ 20/Oct/08 08:58 AM ]
There is no problem description in this issue. I guess you want us to interpret your trace file.
TOP STATEMENTS ORDERED BY RESPONSE TIME

Statement# 	Statement 	Response time 	Service time 	Wait time 	Logical IO 	in Overall(%)
----------- 	--------------------------------------------------- 	-------------- 	------------- 	---------- 	----------- 	--------------
2  	SELECT apps.xxkrs_cst_get_item_type_ctg (o251371.i  	3,439.97  	3,425.76  	14.21  	495,463,680  	68% 
8  	SELECT NVL(L.ACCOUNTED_DR,0)-NVL(L.ACCOUNTED_CR,0)  	1,516.72  	1,507.32  	9.40  	45,640,708  	30% 
1  	UN-KNOWN CURSOR 3  	61.53  	0.00  	61.53  	0  	1% 
7  	SELECT DECODE (:B4 , 'T', DECODE (:B3 , 'C', MSI.I  	17.24  	8.93  	8.31  	437,446  	0% 
6  	SELECT Z.ITEM_COST FROM (SELECT X.ITEM_COST FROM X  	16.46  	8.73  	7.73  	114,563  	0% 
5  	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTIO  	0.00  	0.00  	0.00  	3  	0% 
4  	SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENA  	0.00  	0.00  	0.00  	3  	0% 
3  	SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_  	0.00  	0.00  	0.00  	5  	0% 
----------- 	--------------------------------------------------- 	-------------- 	------------- 	---------- 	----------- 	--------------
total  	  	5,051.91  	4,950.74  	101.17  	541,656,408  	100% 

The statement# 2 and 8 look having high consumption when compared to others.

Unfortunately, there is no execution plan to go forward. I recommend you getting traces for individually for each statements by i.e sqlplus. Or, check your application if your cursors of these statements are closed after they are completed. When cursors are closed, their respective execution plans are dumped to traces.

Comment by ubTools Support [ 28/Oct/08 09:02 AM ]
will there be new traces for further diagnosis ?
Comment by ubTools Support [ 13/Nov/08 09:56 AM ]
Closing with "Customer Timeout" status.




[PSUP-122] License key Created: 04/Jul/08  Updated: 07/Jul/08

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: None

Type: ubTools - itrprof SQL Analyzer Priority: Critical
Reporter: gabriel mantovani Assignee: ubTools Support
Resolution: Answered Votes: 0

Product Version: itrprof SQL Analyzer 6.2.4

 Description   
I already entered the license key in the parameters file but I still get the message "java.lang.UnsupportedOperationException: ppf-03 [0] : Initialization parameters error. Cause : java.lang.UnsupportedOperationException: Not a proper license key for the host britw00107. Action : Contact support."

The parameter file is configured like this:

  1. Editable...: YES
  1. To configure this file, refer to ubTools Installation Manual.

INPUT_BUFFER_SIZE = 4096

OUTPUT_BUFFER_SIZE = 4096

MAXIMUM_FILE_SIZE = 190485760

LICENSE_KEY = MC8zLzEtZmBjc2hkbSFsYG91bndgb2gtZmBjc2hkbS9sYG91bndgb2hBZmxgaG0vYm5sLWB1bnIhbnNoZmhvLWl1dXE7Li52dnYvYHVucm5zaGZoby9ibmwtY3NodXYxMTAxNi8tMS0wMzA0MDg1ODc2MDk1LTAzMDc1ODE4NzYwOTUtNC0w



 Comments   
Comment by ubTools Support [ 06/Jul/08 09:53 AM ]
The correct license key emailed you.

Let me know if it works.

Comment by ubTools Support [ 07/Jul/08 11:44 AM ]
It's emailed that it worked.




[PSUP-121] Can`t generate a report Created: 03/Jul/08  Updated: 06/Jul/08

Status: Closed
Project: PUBLIC_SUPPORT
Fix Version/s: None

Type: ubTools - itrprof SQL Analyzer Priority: Major
Reporter: gabriel mantovani Assignee: ubTools Support
Resolution: Answered Votes: 0

File Attachments: PNG File Screenshot.png    
Product Version: itrprof SQL Analyzer 6.2.4

 Description   
When a choose the *.trc file to be analyzed and click the button "Analyze" it doesn't show a report just the screen in the attached file and if I click on of the links it show me the trc file as shown in the text editor.

 Comments   
Comment by ubTools Support [ 03/Jul/08 02:00 PM ]
Hello,

What is you Servlet Container(Tomcat,Resin,etc. ? Before using ubTools, we should be sure if your Servlet Container is up and running ?

The steps are defined at http://www.ubtools.com/ubtools/ubtools_web_package_installation.html.

If you still get a problem, let me know.

Comment by ubTools Support [ 06/Jul/08 09:55 AM ]
This issue looks solved since PSUP-122 was created.




Generated at Sun Jun 20 03:16:01 UTC 2021 using JIRA Standard Edition, Version: 3.12.3-#302.