PLug in sqlserver pour OEM 13c

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

OEM Agent 12c: Common issues and resolutions

https://developer.rackspace.com/blog/oemagent12c/

 

CPU too heavy

Constraint NOT NULL missing

 

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 release with parameter EXCLUDE=CONSTRAINT the NOT NULL constraints from source tables are not in target tables. Sequence of steps leading to the problem:
– Data Pump export of tables with NOT NULL and referential integrity constraints
– Data Pump import with EXCLUDE=CONSTRAINT

 

http://blog.umairmansoob.com/data-dump-import-missing-not-null-constraints/

Problème avant upgrade en 12.2

Pending dst session 

 

datapump (x) 

list des FREE Pps restant dans un VG AIX

 lsvg | egrep -w "backupvg|datavg" | lsvg -i | grep FREE

Taille des fichiers unix

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

 

 

Lister la taille des blobs partitionnés

La requête suivant permet de te lister la taille des partitions qui contiennent des LOBS  :

 

SELECT DS.TABLESPACE_NAME, SEGMENT_NAME,PARTITION_NAME,ROUND(SUM(DS.BYTES)/(1024 * 1024)) AS MB
FROM DBA_SEGMENTS DS
WHERE
DS.TABLESPACE_NAME not in ('SYSAUX','SYSTEM')
AND
SEGMENT_TYPE='LOB PARTITION'
GROUP BY DS.TABLESPACE_NAME,SEGMENT_NAME,PARTITION_NAME
ORDER BY 4;

La requête suivante permet de te lister la taille des partitions pour le segment TOTO : 

SELECT DS.TABLESPACE_NAME, SEGMENT_NAME, ROUND(SUM(DS.BYTES) / (1024 * 1024)) AS MB
FROM DBA_SEGMENTS DS
WHERE SEGMENT_NAME ='TOTO'
GROUP BY DS.TABLESPACE_NAME,
SEGMENT_NAME;

Je ne suis pas un escroc, je suis un opportuniste...

Suppression des objets pour un schéma

begin
for f in (select table_name from user_tables) loop
execute immediate 'drop table "'||f.table_name||'" cascade constraints';
end loop;
for f in (select object_type, object_name from user_objects
where object_type in ('SEQUENCE','VIEW','FUNCTION','PROCEDURE','PACKAGE','SYNONYM','DATABASE LINK')) loop
execute immediate 'drop '||f.object_type||' "'||f.object_name||'"';
end loop;
for f in (select type_name from user_types) loop
execute immediate 'drop type "'||f.type_name||'" force';
end loop;
end;

/

Tuner une requête Oracle

http://www.br8dba.com/tag/manually-run-sql-advisor/#2

Repasser le code

LeCode