OraFAQ Forum: Server Administration » temporary tablespace (merged)

Home » RDBMS Server » Server Administration » temporary tablespace (merged)

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

temporary tablespace (merged) [message #276666]

Thu, 25 October 2007 22:24

ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh

Member

In our Production database temporary tablespace is always given 100% full, After shutdown and startup database it also still.
what is the solution for reducing temporary tablespace.
My Oracle virson Oracle8.1.7

Report message to a moderator

Re: temporary Tablespace... [message #276672 is a reply to message #276666]

Thu, 25 October 2007 23:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>In our Production database temporary tablespace is always given 100% full,
Normal & expected behavior

>After shutdown and startup database it also still.
Normal & expected behavior

>what is the solution for reducing temporary tablespace.
If you don't know how to "reduce temporary tablespace",
why do you think it is a worthwhile or productive accomplishment?

>My Oracle virson Oracle8.1.7
You should upgrade to a version supported sometime this century.

It you need some activity to keep you occupied & out of trouble,
please run circles while dancing & singing.

Report message to a moderator

Re: temporary Tablespace... [message #276752 is a reply to message #276672]

Fri, 26 October 2007 04:40

lazycat
Messages: 57
Registered: November 2005

Member

we need more information to confirm

Report message to a moderator

Re: temporary Tablespace... [message #276816 is a reply to message #276752]

Fri, 26 October 2007 06:38

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

Senior Member
Account Moderator

To confirm what? Ana's answer is complete.

Regards
Michel

Report message to a moderator

Re: temporary Tablespace... [message #276826 is a reply to message #276666]

Fri, 26 October 2007 07:09

varu123
Messages: 754
Registered: October 2007

Senior Member

Sometimes it is really necessary to be sarcastic

Report message to a moderator

Re: temporary Tablespace... [message #276829 is a reply to message #276826]

Fri, 26 October 2007 07:17

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

Senior Member
Account Moderator

Sorry didn't understand. Embarassed

Regards
Michel

Report message to a moderator

Re: temporary Tablespace... [message #277012 is a reply to message #276666]

Sat, 27 October 2007 23:44

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I also could not get it.

Report message to a moderator

Inserting Data in table thats take more time. [message #281628 is a reply to message #276666]

Sun, 18 November 2007 21:25

ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh

Member

Dear,
>>When inserting data in employee daily attendance table it will take more time.
>>My temporary tablespace is 100% full..
-after shutdown and restart the temporary table space is still 100% full.
-------------------ORACLE Version-8.1.7)
please give me Advice to solve the problems.

Attachment: untitled.JPG
(Size: 44.40KB, Downloaded 622 times)

[Updated on: Sun, 18 November 2007 22:10]

Report message to a moderator

Re: Inserting Data in table thats take more time. [message #281634 is a reply to message #281628]

Sun, 18 November 2007 21:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

REDUNDANCY is the best way to teach slow learners.
REDUNDANCY is the best way to teach slow learners.
REDUNDANCY is the best way to teach slow learners.
REDUNDANCY is the best way to teach slow learners.
REDUNDANCY is the best way to teach slow learners.

http://www.orafaq.com/forum/m/276666/74940/?srch=My+temporary+tablespace+is+100%25+full..#msg_276666

You also need to learn how to use this forum's SEARCH function

http://www.orafaq.com/forum/t/84315/74940/
For clue that you can ignore/forget as with previous answers

[Updated on: Sun, 18 November 2007 21:51] by Moderator

Report message to a moderator

Previous Topic:	Problem..Install Oracle 8.1.7 in Windows XP SP2
Next Topic:	Patch set information

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:59:56 CST 2024