Temp tablespace size [message #625814] |
Tue, 14 October 2014 07:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #625831 is a reply to message #625817] |
Tue, 14 October 2014 08:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gazzag
Messages: 1118 Registered: November 2010 Location: Bedwas, 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 #625872 is a reply to message #625835] |
Wed, 15 October 2014 03:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gazzag
Messages: 1118 Registered: November 2010 Location: Bedwas, 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 #625879 is a reply to message #625877] |
Wed, 15 October 2014 05:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
gazzag
Messages: 1118 Registered: November 2010 Location: Bedwas, 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.
|
|
|