[prev in list] [next in list] [prev in thread] [next in thread] 

List:       suse-oracle
Subject:    ENC: [suse-oracle] "temp01.dbf" datafile has grown excessivelly
From:       "Valter Rehn" <valter () dimed ! com ! br>
Date:       2002-11-28 12:37:59
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]