I have 10g databases. When I went to tune the database I saw that the temporary tablespace was 38gb, but it was 1gb at the time of creation. Then I drop the temp tablespace and assign the database to a new temporary tablespace. What is the possibility to grow the temporary tablespace?
Since you are using Oracle 10g, you should probably have set the PGA_AGGREGATE_TARGET parameter. To accurately set this parameter, refer to the white paper titled "Tuning PGA in Oracle 9i" on
. It is important that this parameter is set correctly. When performing sort operations, hash joins, and a few other operations, most of the work will be performed in memory. The PGA_AGGREGATE_TARGET parameter controls how much memory is available for these operations. For work that is too big to fit into memory, the temporary tablespace is used to store pieces of the work. If you do not adequately size this parameter, then it is very possible your temporary tablespace will grow again.
Dig Deeper on Oracle database administration
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.