OraFAQ Forum: Server Administration » Temporary tablespace Mgmt

Home » RDBMS Server » Server Administration » Temporary tablespace Mgmt

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Temporary tablespace Mgmt [message #222181]

Fri, 02 March 2007 03:34

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

Oracle Version - 9.2
temporary tablesace - EXTENT MANAGEMENT LOCAL & UNIFORM SIZE

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.

Brian

Report message to a moderator

Re: Temporary tablespace Mgmt [message #222189 is a reply to message #222181]

Fri, 02 March 2007 04:05

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Temporary tablespace Mgmt [message #222264 is a reply to message #222189]

Fri, 02 March 2007 10:04

JRowbottom
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

Report message to a moderator

Previous Topic:	COMPATIBLE parameter
Next Topic:	Need Information on V$controlfile_record_section

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:43:51 CST 2024