[#PSUP-144] Performance Issue

PUBLIC_SUPPORT

Created: 10/May/16 04:07 PM Updated: 19/Jul/16 01:42 PM

Fix Version/s:

None

File Attachments:

PROD_ora_1770_AHG000599_0509_140552.trc (124 kb)

Product Version:

11.2 --> 12.1.0.2.0

Description

« Hide

Application performance

All

Comments

Change History

Sort Order:

[ Permlink | « Hide ]

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.

[ Permlink | « Hide ]

Changing the database version to 12.1.0.2.0.

[ Permlink | « Hide ]

This issue has been moved to PUBLIC_SUPPORT from TEST.