| RE:Temp datafile [message #61062] |
Wed, 24 March 2004 18:05  |
dhnish
Messages: 26
Registered: March 2002
|
Junior Member |
|
|
Hi
i'am using Oracle8i on Solaris platform (unix) running an ERP application.
This is regarding my 'temp' datafile in Oracle which is used for query purposes - initially was 4Gb (last year Feb), this Jan ,its 5Gb and now its 9Gb.
This growth - is it considered normal ?
Also should I resize it back to 4Gb?
(if so, can i use system/manager id ? )
Is the 'temp' datafile being cleared corectly?
Pls advice
Thank you and have a nice day
Yours in service
dhnish
|
|
|
|
| Re: RE:Temp datafile [message #61063 is a reply to message #61062] |
Wed, 24 March 2004 20:09  |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
At first I don't understand what seem 'temp' datafile - this is temp tablespace, datafile of temp tablespace of something other. If you want permanent size of temp tablespace - simply simply set AUTOEXTEND OFF in datafile: Sessions will free space for their needs until here will be space that not occuped with other online sessions.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
