Catégorie : Système

Cursor environment mismatch V$SQL_SHARED_CURSOR

SELECTSS1.SQL_TEXT,SS1.SQL_ID,SS1.CHILD_NUMBER,SS2.CHILD_NUMBER,SS1.SQLTYPE,SS2.SQLTYPE,SS1.PARSING_SCHEMA_NAME,SS2.PARSING_SCHEMA_NAMEFROMV$SQL SS1,V$SQL SS2WHERESS1.SQL_ID=SS2.SQL_IDAND SS1.SQLTYPE < SS2.SQLTYPEORDER BYSS1.SQL_TEXT,SS1.CHILD_NUMBER,SS2.CHILD_NUMBER; SELECTSSC.*FROMV$SQL S,V$SQL_SHARED_CURSOR SSCWHERES.SQL_ID=’xxxxxxxxxxxxx’AND S.SQL_ID=SSC.SQL_IDAND S.CHILD_ADDRESS=SSC.CHILD_ADDRESSORDER BYSSC.CHILD_NUMBER; SELECT   S.CHILD_NUMBER,   SBM.POSITION,   SBM.DATATYPE,   SBM.MAX_LENGTH,   SBM.BIND_NAME FROM   V$SQL S,   V$SQL_BIND_METADATA. read more…

Paramètre obsolète

https://mikedietrichde.com/2016/11/22/optimizer_adaptive_features-obsolete-in-oracle-12-2/   The Oracle Database 12.1 parameter OPTIMIZER_ADAPTIVE_FEATURES has been made OBSOLETE (i.e. must be removed from the SPFILE when upgrading) in Oracle Database 12.2. It gets replaced with two parameters of whom one is enabled, the. read more…

Translate »