[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
From:       "Philipp Nicolussi" <Philipp.Nicolussi () xactdata ! net>
Date:       2002-11-28 13:13:09
[Download RAW message or body]

I would try to ...

  1. set temp tablespace from temporary to permanet
      ->> now database will clean up the tablespace and free all unused
space
  2. try to shrink the temp01.dbf

If this not work try this ...

  1. check the temp tablespace for no database objects like indexes or
tables.
  2. Reboot the database
  3. drop tablespace temp and it's datafiles
  4. rebuild tablespace temp, but without autoextents




>>> Adolfo Hernández Bravo <adolfo@depeca.uah.es> 11/28 1:59  >>>
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


---------------------------------------------------------------------
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]