Default Temporary Tablespace [message #194777] |
Mon, 25 September 2006 04:37  |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
i have checked V$temp_space_header and determine the free bytes and free blocks are 0
i also check that the temp tablespace not set to autoextensible
whether it is beneficial to add temp file in that tablespace or set to autoextensible
I also want to confirm that if a default temporary tablespace has been set at db level and each user also have its default temp tablespace then which tablespace each user will use for sorting
should we go for only one default temporary tablespace at db level
and drop all other temporary tablespace whether are used by the users as their temporary tablespace
|
|
|
|