| << Back to previous view |
|
[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. |