Home » RDBMS Server » Server Administration » Temporary tablespace Mgmt
Temporary tablespace Mgmt [message #222181] Fri, 02 March 2007 03:34 Go to next message
Messages: 315
Registered: June 2002
Senior Member

Oracle Version - 9.2

I have a single temp_file in a temporary tablespace, and the file is around 20GB and also auto extend.

1. Is there any adavantage in re-creating the temporary tablespace?

2. Is there any disadvantage by having the auto-extend?

I understand that, I need to have multiple files to stripe over multiple disk files and speed-up sorting.


Re: Temporary tablespace Mgmt [message #222189 is a reply to message #222181] Fri, 02 March 2007 04:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Tempfiles will be reused. No need to have AUTOEXTEND on tempfiles.
If you have it, they would continously grow.

Re: Temporary tablespace Mgmt [message #222264 is a reply to message #222189] Fri, 02 March 2007 10:04 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
And, if your File os in a RAID array, then it will be striped over multiple disks anyway
Previous Topic: COMPATIBLE parameter
Next Topic: Need Information on V$controlfile_record_section
Goto Forum:

Current Time: Thu Jul 20 22:05:31 CDT 2017

Total time taken to generate the page: 0.23754 seconds