SQL Performance (MOSC)

MOSC Banner

Sqltcompare report does not generate any data, it has following error in it - sqlt$a: *** r:ORA-0140

edited Feb 5, 2018 4:05AM in SQL Performance (MOSC) 6 commentsAnswered

same SQL query has more 2 different elapsed time on 2 different databases, I wanted to check as to what are the differences between these 2 database environment using sqltcompare..

I used, SQLT Usage Instructions (Doc ID 1614107.1) and 215187.1 SQLTXPLAIN (SQLT) 12.1.06 January 30, 2014

Tool that helps to diagnose SQL statements performing poorly

to produce sqlt_s63435_s63440_compare.html file. But in this file all I see is the below error message -

08:06:06    0 sqlt$a: *** r:

08:06:06    0 sqlt$a: *** r:ORA-01403: no data found

I checked MOS and SQLT discussion forum and, could not find any information on this error, Would you please share any suggestions for this error message?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center