1

Topic: Temp Tablespaces

for a silly question in advance.
Whether it is possible to clear temp tablespace and how? Takes a place in storage Too much. I will mark that temp it was never cleaned.
In advance thanks.

2

Re: Temp Tablespaces

Goofy122 wrote:

takes a place in storage

It at all much Too much. But if you  ...

3

Re: Temp Tablespaces

Goofy122;
Swap do not forget to clean.

4

Re: Temp Tablespaces

Goofy122 wrote:

takes a place in storage

Too much
Well it not in storage, and on a disk.
Also it occupies so much, how many ever it was necessary.
Type alter tablespace temp shrink space, convince beforehand that it  has an autoextension.
It most likely also will be compressed, but if what request demands the big sortings - it again extends.

5

Re: Temp Tablespaces

p.s. Yes, did not specify the version , got used to work only with those that on support therefore if something ancient - itself google, whether it works on your version .

6

Re: Temp Tablespaces

Elic wrote:

it is passed...
It at all is a lot of. But if you  ...

You will laugh but a disk  45  smile

7

Re: Temp Tablespaces

Q.Tarantino wrote:

it is passed...
Well it not in storage, and on a disk.
Also it occupies so much, how many ever it was necessary.
Type alter tablespace temp shrink space, convince beforehand that it  has an autoextension.
It most likely also will be compressed, but if what request demands the big sortings - it again extends.

Yes on a disk for this reason it is necessary to clean

8

Re: Temp Tablespaces

Q.Tarantino wrote:

p.s. Yes, did not specify the version , got used to work only with those that on support therefore if something ancient - itself google, whether it works on your version .

Yes I apologize precisely 11g

9

Re: Temp Tablespaces

wrote:

Goofy122;
Swap do not forget to clean.

The silly question but , and problems will not be?

10

Re: Temp Tablespaces

Goofy122;
There is no system - there is no problem.

11

Re: Temp Tablespaces

To fulfill 
And not to pay attention to trolling of others

12

Re: Temp Tablespaces

SAS2014 wrote:

to fulfill

To fulfill " " it is possible, if at a known level of luck units in the end of a file are not occupied.
Frequently easier to create new temp (at first small if problem with place) to assign new temp ,  old together with its files, and to rename new temp into the old.

13

Re: Temp Tablespaces

If rate on 11g Oracle delete it at an idle copy to all devils and  a DB grew. The Oracle creates it, if at you is certainly right correctly . I do not understand, whether you  that here? smile

14

Re: Temp Tablespaces

DKbru wrote:

If rate on 11g Oracle delete it at an idle copy to all devils and  a DB grew. The Oracle creates it, if at you is certainly right correctly . I do not understand, whether you  that here? smile

Thanks big, it is right is, likely )))

15

Re: Temp Tablespaces

DKbru wrote:

If rate on 11g Oracle delete it at an idle copy to all devils and  a DB grew. The Oracle creates it, if at you is certainly right correctly . I do not understand, whether you  that here? smile

Naturally, at first in a tambourine and then to understand smile)). Well you will kill TEMP. Well creates its Oracle again. Further that? Through some e TEMP as the phoenix revives from ashes and will be e  as before. Here a question and why TEMP grew till these sizes? As a result of normal operation of a DB or there was e an one-time operation  the raised size TEMP?
SY.

16

Re: Temp Tablespaces

SY;
Absolutely with you it agree. Itself on a head of all I beat, when stupidly recreate UNDO and Temp thus. But, judging by "the huge" size of the screw, here if there is a question in adjustment of a DBMS or business logic debugging, temporary ts - peak . Therefore on etching question  gave the trivial answer did not become. Mahlo of the data for collection , especially key for itself found a phrase:

Goofy122 wrote:

I Will mark that temp was never cleaned.

My council does not treat possible current or last problems, but it precisely is better than councils  temp ts not clearly what for, giving birth to itself to hypothetical problems from air.

17

Re: Temp Tablespaces

I am sorry for spelling in the previous post - the small monitor, already I see nothing and counted upon chrome autocorrections xD

18

Re: Temp Tablespaces

DKbru, and it needs to be cleaned?
Always was the opponent autoextend and since got on a glitch autoextend and two weeks repaired basis (in other city, access to the server only phone of the administrator and net80)... Became the ardent opponent)))
To create tabular spaces of the necessary size, to forbid autoextend and anything will clean it is not necessary. IMHO

19

Re: Temp Tablespaces

Leonid Kudryavtsev;
Here it is possible to discuss. I for autoextend with calculated both predicted MAXSIZE and understanding logic business. Whether the fact that the author apologizes for a silly question and asks "It is possible to clear temp tablespace and how?" Pushes me on thought that it the administrator of any small accounting utility of type of the Sail or generally a test DB, time example is also it does not know about intrigues and on its direct question the direct answer is necessary. Removal temp ts the normal method described by me solves its problem is momentary. Such size can be for a variety of causes, it is possible http://www.dba-oracle.com/t_monitoring_ … _usage.htm , there are problems with statistics collection more likely, and can single scenarios were fulfilled, and can still that was. The HARDWARE not about it asked.

20

Re: Temp Tablespaces

DKbru wrote:

Here it is possible to discuss.

For discussion to begin with it is necessary to converge in determinations. To clean and reduce in size it not one and too. Well and about autoextend for TEMP - sense I do not see.
SY.

21

Re: Temp Tablespaces

SY;
And I with you did not want , for it owing to your knowledge and experience in the field  for me.
Note, I said nothing about that temp it is necessary to clean or delete, as well as did not express about autoextend temp, and speaks about usefulness \harm of parameter in spherical vacuum.
After physical removal ORACLE  TEMP, except a small exhaust after start and free blocks there it will be primary nothing.
About terminology to "clean" - a dangerous word. At us so cleaned a computer formatting of the system screw with  a folder of docks for 3 years at one manager. The author explicitly asks "cleanings" for reduction of the size. And definitely it does not need to be solved .

22

Re: Temp Tablespaces

IMHO

DKbru wrote:

... The Author explicitly asks "cleanings" for reduction of the size. And definitely it does not need to be solved .

I can I do not understand, but unless shrink not for "reduction of the size" is intended?
I in bewilderment, and what then generally assignment at shrink (never it used) if "definitely it does not need to be solved "

DKbru wrote:

About terminology to "clean" - a dangerous word. At us so cleaned a computer formatting of the system screw with  a folder of docks for 3 years at one manager

So about that and speech.
At first rate removal cleaned, then the screw formatting....
Today he plays a jazz, and tomorrow the native land sells ()

DKbru wrote:

I for autoextend with calculated and predicted MAXSIZE

It as?
Or we know max size and we expose in it tabular spaces - and any autoextend to us is not necessary for nothing
Or we consider that "the Oracle clever, to it is more visible" (C) - then there is nothing to complain. "It at all is a lot of. But if you  ..." (C)
IMHO
1. On the selected server - autoextend it is not necessary, time the server selected, and give initially Oracle resources
2. On not selected server - especially. Since if suddenly, green little men arrive, launch something spiteful and basis is abnormal captivates all disk is can affect all server and on others (not Oracle) systems. .. To scatter for itself and colleagues a rake certainly it is possible... Only, as, in revenge not to receive during the most unexpected moment and in the most unexpected place an iron hoop from a butt)))
/ people with experience assured that it is much more pleasant, than to walk on a rake /

23

Re: Temp Tablespaces

Leonid Kudryavtsev wrote:

Always was the opponent autoextend and since got on a glitch autoextend and two weeks repaired basis

Also what it was for a glitch after which 2 weeks on basis repairing left?

24

Re: Temp Tablespaces

Leonid Kudryavtsev;

Q.Tarantino wrote:

it is passed...
Also what it was for a glitch after which 2 weeks on basis repairing left?

And to whom after that this basis was necessary?
On Oracle extremely rarely hold bases which two weeks - bluntly expensively presume to stay to themselves.
Moreover and without the administrator. Unless also in noarchivelog smile))

25

Re: Temp Tablespaces

Leonid Kudryavtsev wrote:

IMHO
I can I do not understand, but unless shrink not for "reduction of the size" is intended?
I in bewilderment, and what then generally assignment at shrink (never it used) if "definitely it does not need to be solved "

SHRINK! = RESIZE. SHRINK works with e (tables, LOB, IOT...) and RESIZE with files.
SY.