Sqltcompare report does not generate any data, it has following error in it - sqlt$a: *** r:ORA-0140
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?