Catégorie : Système

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 […]

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 […]

https://docs.oracle.com/cd/E63000_01/SQLPG/overview.htm#SQLPG108   https://docs.oracle.com/cd/E24628_01/doc.121/e24473/plugin_mngr.htm#EMADM13102

https://developer.rackspace.com/blog/oemagent12c/   CPU too heavy

  Data Pump Import With EXCLUDE=CONSTRAINT Or INCLUDE=CONSTRAINT Is Excluding And Respectively Not Including NOT NULL Constraints (Doc ID 1930631.1) After doing a Data Pump import (impdp) in 12.1.0.2 database […]

Pending dst session    datapump (x)  https://blog.oracle-ninja.com/2013/09/17/stuck-timezone-upgrades-and-smart-scans/    

 lsvg | egrep -w « backupvg|datavg » | lsvg -i | grep FREE

du -ms expdp_$ORACLE_SID_20190* | awk ‘{ total += $1 }; END { print total }’    

define TBS=’SIM_SIM_LOB01′define DFSZ=’10000M’ select ‘Alter database datafile  »’||FILE_NAME|| »’ resize ‘||’&DFSZ’||’;’ from dba_data_files where TABLESPACE_NAME like ‘&TBS’ order by FILE_NAME;

SET serveroutput ON;DECLAREordre_sql VARCHAR2(32000 CHAR);nomTable VARCHAR2(200 CHAR);nomColonne VARCHAR2(200 CHAR);nomSchema VARCHAR2(200 CHAR) := ‘JOJO’; BEGINDBMS_OUTPUT.ENABLE(1000000);FOR lob_cols IN (SELECT table_name nomTable, column_name nomColonne FROM ALL_TAB_COLSWHERE data_type LIKE ‘%LOB%’AND owner = nomSchemaAND table_name […]