lsvg | egrep -w « backupvg|datavg » | lsvg -i | grep FREE
Josselin Joly
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 MBFROM DBA_SEGMENTS DSWHERE DS.TABLESPACE_NAME not in (‘SYSAUX’,’SYSTEM’)AND. read more…
Suppression des objets pour un schéma
beginfor f in (select table_name from user_tables) loopexecute 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’)) loopexecute immediate ‘drop. read more…
Tuner une requête Oracle
http://www.br8dba.com/tag/manually-run-sql-advisor/#2
Agrandir datafile avant import
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;
Déplacer des objets de type LOB dans le bon tabespace (LOB)
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. read more…
Change permission using UT_FILE
Using utl_file, how file permissions are determined, working sample
Supprimer les segments vides
exec dbms_space_admin.drop_empty_segments(schema_name=>’HR’);
Translate »