<< 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: | 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: | 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: | 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: | 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. |
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: | 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:
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: | 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 |