| TEMPorary tablespace [message #56199] |
Wed, 12 March 2003 06:43  |
Suraj
Messages: 38
Registered: April 2002
|
Member |
|
|
Hi all,
I ve got some problems with TEMP tablespace.
I have a sudden and sharp rise in the TEMP tablespace by about 200% in a day (never happened in the last 18 months)
The TEMP tablespace was created with the following:
- PCT Increase: 0
- Contents : TEMPORARY
I attempted a coalesce on the tablespace but no change in size.
How do I determine the users' activities that led to the high disk usage?
What can I do to clean up or empty the tablespace?
Would appreciate any help.
Suraj
|
|
|
|
| Re: TEMPorary tablespace [message #56200 is a reply to message #56199] |
Wed, 12 March 2003 07:04  |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
Some user activity has lead to this. To clear up the TEMP tablespace, do the following:
alter tablesapce temp default storage (pctincrease 0);
Cheers.
|
|
|
|
|
|
| Re: TEMPorary tablespace [message #56241 is a reply to message #56200] |
Thu, 13 March 2003 08:09 |
Suraj
Messages: 38
Registered: April 2002
|
Member |
|
|
I wonder what effect ALTER TABLESPACE TEMP DEFAULT STORAGE(PCTINCREASE 0); would do considering the fact that the current pctincrease is set to 0.
Can I do this on the fly at any time during daily activity?
Thanks,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
