Home » RDBMS Server » Server Administration » Default Temporary Tablespace
Default Temporary Tablespace [message #194777] Mon, 25 September 2006 04:37 Go to next message
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
Re: Default Temporary Tablespace [message #194778 is a reply to message #194777] Mon, 25 September 2006 04:49 Go to previous message
Messages: 18
Registered: September 2006
Junior Member
First you can add temp file to temporary tablespace this will resolve your problem, Later you can plan accordingly what you want to do.
Previous Topic: SQLPLUS coredump on HP-UX
Next Topic: Threshold value
Goto Forum:

Current Time: Mon Oct 24 20:58:49 CDT 2016

Total time taken to generate the page: 0.19893 seconds