Home » RDBMS Server » Server Administration » Can we use the swap area /tmp ?
Can we use the swap area /tmp ? [message #61520] Fri, 30 April 2004 14:53 Go to next message
sheela
Messages: 66
Registered: March 2002
Member
Hi,

  I was wondering if there are any potential problems in using the /tmp area for the oracle temporary tablespace?   In our case all our data/logs will be on a NFS mount.  But I'm planning to put the /tmp locally.  What do you guys think?

Thanks

Tony

 

Report message to a moderator

Re: Can we use the swap area /tmp ? [message #61536 is a reply to message #61520] Tue, 04 May 2004 07:39 Go to previous messageGo to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
I would not really go for it.

My reasoning is that /tmp is not that big of a space to start with. Your sysadmin can come and clean up the /tmp occasionally as needed. Dangerous.

It is better to make another dedicated folder like /u02/tmp and put your file there.

Just my thought.
--
Sanjay

Report message to a moderator

Re: Can we use the swap area /tmp ? [message #61546 is a reply to message #61520] Tue, 04 May 2004 22:26 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Not good. The OS needs /tmp to write its temp files and if you put Oracle datafiles, then I/O contention might occur.

Also keep in mind that some Linux distros and wipping out the /tmp on OS reboot. Nobody wants to lose Oracle datafiles, even temporary.

Hope that helps,

Trifon Anguelov

DBAclick.com | DBA Forums

Report message to a moderator

Re: Can we use the swap area /tmp ? [message #61560 is a reply to message #61536] Wed, 05 May 2004 08:22 Go to previous message
Tony
Messages: 190
Registered: June 2001
Senior Member
Thank You. Makes sense.

Report message to a moderator

Previous Topic: Strange problem connecting on Windows 2000
Next Topic: OEM
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:20:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.