| temp not being used [message #50696] |
Tue, 02 April 2002 06:20  |
Toby
Messages: 2
Registered: April 2002
|
Junior Member |
|
|
Our application used the temp tablespace quite heavily.
One of the sites I am working on is experiencing performance issues.
One thing that I have noticed is that temp is not being utilized. Is there a reason why?
SQL> select ts, sum_free_blocks, check_date
2 from spaces
3 where ts = 'TEMP'
4 order by check_date desc;
TS SUM_FREE_BLOCKS CHECK_DA
------------------------------ --------------- --------
TEMP 127999 02-04-02
TEMP 127999 02-04-01
TEMP 127999 02-03-31
TEMP 127999 02-03-30
TEMP 127999 02-03-29
TEMP 127999 02-03-28
TEMP 127999 02-03-27
TEMP 127999 02-03-26
TEMP 127999 02-03-25
TEMP 127999 02-03-24
TEMP 127999 02-03-23
TS SUM_FREE_BLOCKS CHECK_DA
------------------------------ --------------- --------
TEMP 127999 02-03-22
TEMP 127999 02-03-21
TEMP 127269 02-03-20
TEMP 127999 02-03-19
TEMP 127999 02-03-18
TEMP 127999 02-03-17
TEMP 127999 02-03-16
TEMP 127999 02-03-15
TEMP 127999 02-03-14
TEMP 127999 02-03-13
TEMP 127999 02-03-12
Thank you for any replies.
|
|
|
|
| Re: temp not being used [message #50697 is a reply to message #50696] |
Tue, 02 April 2002 08:49  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Check to make sure the users ts hasn't changed from using TEMP if so change it.
select USERNAME,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE from dba_users;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
