OraFAQ Forum: Server Administration » space available in temporary tablespace is 0

Home » RDBMS Server » Server Administration » space available in temporary tablespace is 0

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

space available in temporary tablespace is 0 [message #57593]

Wed, 25 June 2003 01:43

keanu
Messages: 3
Registered: June 2003

Junior Member

Hi all:
Now temporary tablespace's size is 1.5G,the connections to instance is less than 20,but the ratio of used space to total space is 99%.From using oracle the ratio has been rising,so I have to remove temporary tablespace and re-create it every some days. who can tell me the reason? thanks.

Report message to a moderator

Re: space available in temporary tablespace is 0 [message #57600 is a reply to message #57593]

Wed, 25 June 2003 04:00

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

are the temporary temporary tablespace really 'temporary'?
please check that. a common mistake is to create a temp tablesace with permanent options.
else
what kind of managements is used? local or dictionary?

Report message to a moderator

Re: space available in temporary tablespace is 0 [message #57612 is a reply to message #57600]

Wed, 25 June 2003 18:20

keanu
Messages: 3
Registered: June 2003

Junior Member

the syntax of creating temporary tablespace is :
CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE '/oradata/ndlsdb3/temp01.dbf' SIZE 1500M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP".
So,the temporary tablespace is really temporary,and it is default temporary tablespace of the database.

Report message to a moderator

Re: space available in temporary tablespace is 0 [message #57618 is a reply to message #57600]

Thu, 26 June 2003 02:24

keanu
Messages: 3
Registered: June 2003

Junior Member

I checked detail information about temporary tablespace and discovered the following information:
allocated(M):1500
used(M):1
free(M):1499.
why oracle allocated 1500 but used only 1?

Report message to a moderator

Previous Topic:	Upgrade using patch set 2376472 to 8.1.7.4
Next Topic:	poor performance after 9i upgrade

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 13:25:22 CST 2025