Home » RDBMS Server » Server Administration » temporary tablespace (merged)
icon4.gif  temporary tablespace (merged) [message #276666] Thu, 25 October 2007 22:24 Go to next message
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
Re: temporary Tablespace... [message #276672 is a reply to message #276666] Thu, 25 October 2007 23:08 Go to previous messageGo to next message
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.
Re: temporary Tablespace... [message #276752 is a reply to message #276672] Fri, 26 October 2007 04:40 Go to previous messageGo to next message
lazycat
Messages: 57
Registered: November 2005
Member
we need more information to confirm
Re: temporary Tablespace... [message #276816 is a reply to message #276752] Fri, 26 October 2007 06:38 Go to previous messageGo to next message
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
Re: temporary Tablespace... [message #276826 is a reply to message #276666] Fri, 26 October 2007 07:09 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Sometimes it is really necessary to be sarcastic
Re: temporary Tablespace... [message #276829 is a reply to message #276826] Fri, 26 October 2007 07:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Sorry didn't understand. Embarassed

Regards
Michel
Re: temporary Tablespace... [message #277012 is a reply to message #276666] Sat, 27 October 2007 23:44 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I also could not get it.
icon5.gif  Inserting Data in table thats take more time. [message #281628 is a reply to message #276666] Sun, 18 November 2007 21:25 Go to previous messageGo to next message
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 623 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 Go to previous message
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:
  


Current Time: Sun Dec 08 05:31:08 CST 2024