[prev in list] [next in list] [prev in thread] [next in thread]
List: suse-oracle
Subject: RE: Antw: ENC: [suse-oracle] "temp01.dbf" datafile has grown excessivelly
From: Adam.Cioccarelli () ubsw ! com
Date: 2002-11-29 0:43:36
[Download RAW message or body]
Hi,
just alter something about the storage parameters for the temp tablespace, even alter \
something to be the same as it was, and you should find that a lot of the space in \
the tablespace is cleared out. You can then shrink it and turn off autoextend. Also \
you can change your temporary tablespace to be locally managed rather than dictionary \
and you won't have to worry about clearing it out manually.
Adam
> -----Original Message-----
> From: Adolfo Hernández Bravo [mailto:adolfo@depeca.uah.es]
> Sent: Friday, 29 November 2002 00:00
> To: suse-oracle@suse.com
> Subject: Re: Antw: ENC: [suse-oracle] "temp01.dbf" datafile has grown
> excessivelly
>
>
> Yes, i have autoextend YES for temp01.dbf.
>
> I want to reduce the temp file.
>
> I have received some suggestions about it:
>
> 1.- "drop the tablespace / datafile and re - create it new"
> 2.- "Close db, start it and shrink file with em or command"
>
> Is correct?
> Another ideas?
>
>
>
>
> -------------------------------------------------------
> > Hello,
>
> > Is it possible that your file temp01.dbf is set to autoexents ?
> > Please check this with sqlplus
> > connect system/<passwd>
>
> > select autoextensible from dba_data_files
> > where file_name like '%temp01.dbf';
>
>
> > Philipp Nicolussi
> > xactdata software solutions & service gmbh
> > Reichsstraße 126 · 6800 feldkirch · austria
> > tel +43 (0) 5522 / 38 363 - 21 · fax - 53
> > philipp.nicolussi@xactdata.at
> > www.xactdata.net
>
> > > > > "Valter Rehn" <valter@dimed.com.br> 11/28 2:37 >>>
> > sorry for the signed message... it's the standard in the
> corporation i
> > work for.
>
> > -----Mensagem original-----
> > De: Valter Rehn
> > Enviada em: Thursday, November 28, 2002 10:28
> > Para: 'Adolfo Hernández Bravo'; suse-oracle@suse.com
> > Assunto: RES: [suse-oracle] "temp01.dbf" datafile has grown
> > excessivelly
>
>
> > Adolfo,
>
> > what exactly is your problem? excessive temp usage? datafile
> > autoextend
> > beyond 2Gb?
>
> > Valter
>
> > -----Mensagem original-----
> > De: Adolfo Hernández Bravo [mailto:adolfo@depeca.uah.es]
> > Enviada em: Thursday, November 28, 2002 08:37
> > Para: suse-oracle@suse.com
> > Assunto: [suse-oracle] "temp01.dbf" datafile has grown excessivelly
>
>
> > Hello.
>
> > I'm using:
> > - Oracle 8.1.7.2
> > - SUSE 8.0 Pro
>
> > As you can see, the "temp01.dbf" datafile has grown a lot.
> > Why?
> > What can I do?
>
> > My partition is at 91%...
>
> > /u02/oradata/ls -la
> > drwxr-xr-x 2 oracle oinstall 417 abr 17 2002 .
> > drwxr-xr-x 3 oracle oinstall 146 sep 19 16:05 ..
> > -rw-r----- 1 oracle oinstall 130M nov 28 11:42
> > continental.dbf
> > -rw-r----- 1 oracle oinstall 872k nov 28 11:42 control01.ctl
> > -rw-r----- 1 oracle oinstall 872k nov 28 11:42 control02.ctl
> > -rw-r----- 1 oracle oinstall 872k nov 28 11:42 control03.ctl
> > -rw-r--r-- 1 oracle oinstall 20M nov 28 11:31 drsys01.dbf
> > -rw-r--r-- 1 oracle oinstall 20M nov 28 11:31 indx01.dbf
> > -rw-r--r-- 1 oracle oinstall 50M nov 28 11:41 rbs01.dbf
> > -rw-r----- 1 oracle oinstall 500k nov 28 11:34 redo01.log
> > -rw-r----- 1 oracle oinstall 500k nov 28 11:12 redo02.log
> > -rw-r----- 1 oracle oinstall 500k nov 28 11:42 redo03.log
> > -rw-r--r-- 1 oracle oinstall 270M nov 28 11:39 system01.dbf
> > -rw-r--r-- 1 oracle oinstall 2.0G nov 28 11:42 temp01.dbf
> > -rw-r--r-- 1 oracle oinstall 10M nov 28 11:31 tools01.dbf
> > -rw-r--r-- 1 oracle oinstall 49M nov 28 11:36 users01.dbf
>
> > Thanks.
>
> > ____________________________________________________
>
> > Adolfo Hernández Bravo <adolfo@depeca.uah.es>
>
> > Dpto. de Electrónica - Laboratorio Fondo O-33
> > Escuela Politécnica
> > Universidad de Alcalá
> > Spain
> > ____________________________________________________
>
>
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
> > For additional commands, e-mail: suse-oracle-help@suse.com
> > Please see http://www.suse.com/oracle/ before posting
>
>
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
> > For additional commands, e-mail: suse-oracle-help@suse.com
> > Please see http://www.suse.com/oracle/ before posting
>
>
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
> > For additional commands, e-mail: suse-oracle-help@suse.com
> > Please see http://www.suse.com/oracle/ before posting
>
>
> -------------------------------------------------------
>
>
>
> ____________________________________________________
>
> Adolfo Hernández Bravo < adolfo@depeca.uah.es >
>
> Dpto. de Electrónica - Laboratorio Fondo O-33
> Escuela Politécnica
> Universidad de Alcalá
> Spain
> ____________________________________________________
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
> For additional commands, e-mail: suse-oracle-help@suse.com
> Please see http://www.suse.com/oracle/ before posting
>
>
Visit our website at http://www.ubswarburg.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.
---------------------------------------------------------------------
To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
For additional commands, e-mail: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic