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;