From:                                         Pascal FAURE

Sent:                                           lundi 15 octobre 2012 11:49

To:                                               dba@client3

Cc:                                               'sent@db1.fr'

Subject:                                     plus de précision sur les manips sur SRF

 

 

Tailles avant la réorganisation :

 

select sum(bytes)/1024/1024/1024 from dba_segments;

-------------------------

               135,488159

 

Aprés la reorganization des tables SAFLIN et SAPRAG ainsi que leurs index :

 

select sum(bytes)/1024/1024/1024 from dba_segments;

-------------------------

               96,5745239

 

 

Pour info, la taille réelle des fichiers d’une base (hors temp) est obtenue avec la requete : select sum(bytes)/1024/1024/1024 from dba_data_files;

 

Liste des autres commandes passées ce weekend :

 

alter system set log_archive_dest_1=' LOCATION=I:\BACKUP\ARC\SRF’;

 

alter table VBANK.SAFLIN move;

alter table VBANK.SAPRAG move;

alter index VBANK.SAFLIN0 rebuild;

alter index VBANK.SAFLIN1 rebuild;

alter index VBANK.SAFLIN2 rebuild;

alter index VBANK.SAPRAG0 rebuild;

alter index VBANK.SAPRAG1 rebuild;

alter index VBANK.SAPRAG2 rebuild;

alter index VBANK.SAPRAG3 rebuild;

 

ALTER TABLESPACE VBANK_DATA ADD DATAFILE 'F:\SRF\BTSP\VBANK_DATA11.ORA' SIZE 100M AUTOEXTEND ON MAXSIZE 16000M;

ALTER TABLESPACE VBANK_INDX ADD DATAFILE 'F:\SRF\BTSP\VBANK_INDX08.ORA' SIZE 100M AUTOEXTEND ON MAXSIZE 16000M;

ALTER TABLESPACE TEMP ADD TEMPFILE 'F:\SRF\BTSP\TEMP02.DBF' SIZE 100M AUTOEXTEND ON MAXSIZE 16000M;

ALTER TABLESPACE UNDOTBS1 ADD DATAFILE 'F:\SRF\BTSP\UNDOTBS02.DBF' SIZE 100M AUTOEXTEND ON;

ALTER DATABASE DATAFILE 'H:\SRF\BTSP\VBANK_INDX04.ORA'  AUTOEXTEND ON MAXSIZE 4200M;

 

 

 

 

Pascal FAURE
Consultant Oracle 


Description: Description: Description: Description: cid:910CBE1D-DDA4-4962-B24C-8D5D2884BB9E

Tél : 08 20 22 00 80

www.db1.fr