OraFAQ Forum: Server Administration » Global Temporary Tablespace

Home » RDBMS Server » Server Administration » Global Temporary Tablespace (10g)

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

Global Temporary Tablespace [message #357447]

Wed, 05 November 2008 06:15

TRaj
Messages: 82
Registered: September 2006

Member

Hi all,

Appreciate if anyone can give me the initial optimal maxsize, when creating a global temporary tablespace.

Thanks.

Report message to a moderator

Re: Global Temporary Tablespace [message #357452 is a reply to message #357447]

Wed, 05 November 2008 06:31

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> create global temporary table tmp (col integer) storage (initial 10m);
create global temporary table tmp (col integer) storage (initial 10m)
*
ERROR at line 1:
ORA-14451: unsupported feature with temporary table

Does this answer the question?

Regards
Michel

Report message to a moderator

Re: Global Temporary Tablespace [message #357466 is a reply to message #357447]

Wed, 05 November 2008 08:10

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

There is no such thing as a global temporary tablespace.

Report message to a moderator

Re: Global Temporary Tablespace [message #357492 is a reply to message #357466]

Wed, 05 November 2008 10:55

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Was so obvious for me that I read it as "global temporary TABLE".

Regards
Michel

Report message to a moderator

Re: Global Temporary Tablespace [message #357580 is a reply to message #357447]

Wed, 05 November 2008 22:55

TRaj
Messages: 82
Registered: September 2006

Member

Hi

Sorry for the confusion. Actually, I used the word "GLOBAL" here is to mean a system wide Temporary tablespace.

That is a default temporary tablespace that has been designated a global temporary tablespace for all users that have not been explicitly defined a temporary tablespace at user creation time.

Thanks.

Report message to a moderator

Re: Global Temporary Tablespace [message #357617 is a reply to message #357580]

Thu, 06 November 2008 01:11

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So now precise your question.

Regards
Michel

Report message to a moderator

Default Temporary Tablespace [message #357689 is a reply to message #357447]

Thu, 06 November 2008 04:50

TRaj
Messages: 82
Registered: September 2006

Member

Hi Mike,

At the time of creating a default temporary tablespace, what factors (calculations) to consider in setting a good maxsize? I don't want to give maxsize unlimited.

Thanks.

Report message to a moderator

Re: Default Temporary Tablespace [message #357698 is a reply to message #357689]

Thu, 06 November 2008 05:05

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

None, I don't put my tablespaces in autoextend mode.

Regards
Michel

Report message to a moderator

Re: Default Temporary Tablespace [message #357978 is a reply to message #357689]

Fri, 07 November 2008 08:10

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

If you're using MASSIZE as a trap in case of runaway datafile growth, then a good definition for MAXSIZE is 'How large can I fford for this file to grow before it will start to interfere with the rest of the server'
Otherwise, it's just a case of how big do you want your datafiles to get. This can be affected by your OS, your backup strategy, and the personal preferences of your sysadmin.

Report message to a moderator

Previous Topic:	Difference between V$parameter and V$parameter2
Next Topic:	Recover table with deleted records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 18:50:55 CST 2024