Home » RDBMS Server » Server Administration » Locally Managed Tablespace and the UNIFORM SIZE option.
Locally Managed Tablespace and the UNIFORM SIZE option. [message #60338] Mon, 02 February 2004 11:43 Go to next message
Patrick Tahiri
Messages: 119
Registered: January 2004
Senior Member
Hi,

What are the tipical tips about the value of UNIFORM SIZE that I can get if creating a Temporary Tablespace with a tempfile and locally managed defined temporary tablespace (I can't set it to AUTOALOCATE as I'm using Oracle 8i which does not support the AUTOALLOCATE option!!)??

CREATE TEMPORARY TABLESPACE TBS_name

TEMPFILE 'path....'

EXTENT MANAGEMENT LOCAL UNIFORM SIZE XM;

What are the performance tips or criteria to evaluate X??

Thank you very much!

Regards,

Patrick.

Report message to a moderator

Re: Locally Managed Tablespace and the UNIFORM SIZE option. [message #60341 is a reply to message #60338] Mon, 02 February 2004 15:04 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Hi
set the UNIFORM extent size to be the same as your SORT_AREA_SIZE or multiples of it.
Yes, you cant AUTOALLOCATE extents in a Locally Managed TEMPORARY tablespace ,as the extents are allocated once and reused thereafter until the instance shutsdown.

-Thiru

Report message to a moderator

Previous Topic: How to consolidate space in tablespace?
Next Topic: Temporary Tablespace defined with: Datafile vs Tempfile.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:36:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.