what is signature in the view dba_outlines

  • From: 刘 Qinliu <Ivyliu_99@xxxxxxxxxxx>
  • To: 'ORACLE-L' <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 4 Mar 2017 08:59:53 +0000

there is signature in the view dba_outlines,which says "Signature uniquely 
identifying the outline SQL text"


It is self-explained, however, which column of v$sql does it correspond to.

there is a column EXACT_MATCHING_SIGNATURE,which is type of number.Obviously, 
you can't join the view v$sql and dba_outlines tpgether by signature=

EXACT_MATCHING_SIGNATURE
.


Other related posts:

  • » what is signature in the view dba_outlines - 刘 Qinliu