Home » RDBMS Server » Server Administration » Temp tablespace size (oracle 11 g)
Temp tablespace size [message #625814] Tue, 14 October 2014 07:40 Go to next message
simplesanju
Messages: 36
Registered: July 2008
Member
Hi All,

I need some understang regarding managing temp tablespace size.
Ex: My DB is currently at 42GB, as per my DBA,they allocated TEMP tablespace over 200GB.
so how it will manage if this is the case...

I don't have much idea about tablespace memory management.

Thanks
Sanjana
Re: Temp tablespace size [message #625817 is a reply to message #625814] Tue, 14 October 2014 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Who is "it"?
Temp space usage depends on the SQL statements used not on the size of the database.
What is your question exactly?

Re: Temp tablespace size [message #625831 is a reply to message #625817] Tue, 14 October 2014 08:59 Go to previous messageGo to next message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
Temporary tablespace is used for sorting data. The size will be related to the statements and queries used, not the actual database itself.
Re: Temp tablespace size [message #625835 is a reply to message #625831] Tue, 14 October 2014 09:20 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks to confirm what I have said.

Re: Temp tablespace size [message #625851 is a reply to message #625835] Wed, 15 October 2014 01:11 Go to previous messageGo to next message
simplesanju
Messages: 36
Registered: July 2008
Member
Thanks all for your explanation.
Re: Temp tablespace size [message #625872 is a reply to message #625835] Wed, 15 October 2014 03:38 Go to previous messageGo to next message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
When learning, sometimes it is good to hear the same explanation in different ways. Not everyone has English as their first language. Also, if everything was RTFM, there would be no need for teachers and schools.
Re: Temp tablespace size [message #625876 is a reply to message #625872] Wed, 15 October 2014 05:06 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Who speak about RTFM here?
Different ways? Where are the different ways? You said EXACTLY what I said (just adding "Temporary tablespace is used for sorting data" which is true but not complete so is misleading if someone gets an out of temporary space error with no sort).

Re: Temp tablespace size [message #625877 is a reply to message #625876] Wed, 15 October 2014 05:09 Go to previous messageGo to next message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
It is as complete as your answer, but clearer. As you agreed:

Quote:
Thanks to confirm what I have said.
Re: Temp tablespace size [message #625879 is a reply to message #625877] Wed, 15 October 2014 05:56 Go to previous message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
I think I understand the misunderstanding, Michel. My first post looked like I was replying to you. In fact I was replying to the OP. Apologies for the confusion.
Previous Topic: Database Performance vs SGA size
Next Topic: ORA-00308: cannot open archived log
Goto Forum:
  


Current Time: Sat Feb 24 19:53:22 CST 2018

Total time taken to generate the page: 0.20151 seconds