Now have a table for 100 g, in the test library, the exec dbms_stats. Gather_table_stats (ownname=& gt; 'easdt, tabname=& gt; 't_bg_bgtemrefbgitemcombin'), how a little useless temporary tablespace? 10 g, archiving, statistical information only, the index is the latest information, I am looking at real-time, really useless temporary table space, and statistical time also changed dba_table,
So here's the thing, I in the official repository, error, hint I table space is not enough, which table space forgot, affirmation is to execute the statement users under the table space, is nothing but a table space and temporary table space,

So, now have two questions, NO1: why testing library use temporary table space (60 g), a little useless
NO2: why formal library used a table space (the temporary table space is little, 28 g)

Ps: thank the first

CodePudding user response:

Two machine memory parameters setting is not the same as
Especially when the PGA

CodePudding user response:

reference 1st floor sych888 response:

two machines is not the same as the memory parameter Settings.
Especially when the PGA

Certainly is not the same, but certainly a formal library bigger than testing library, formal total 8 g, test a total of 4 g, I also consider this problem, main is there is no reason to test there is no temporary table space, formal use, the only way is to increase the temporary table space, get the same as testing library, but this two days

CodePudding user response:

refer to the second floor yan_gyan_g response:

Quote: refer to 1st floor sych888 response:

Two machine memory parameters setting is not the same as
Especially when the PGA

Certainly is not the same, but certainly a formal library bigger than testing library, formal total 8 g, test a total of 4 g, I also consider this problem, main is there is no reason to test there is no temporary table space, formal use, the only way is to increase the temporary table space, get the same as testing library, but it may not be able to get two days

The formal library have? What other transactions at the same time operating database? Take up memory space

CodePudding user response:

This depends on your database configuration parameter, may lead to a parameter value is not the same as the background is different, the effect of two a configuration, if not exactly the same db, so there is no more meaning

CodePudding user response:

reference sych888 reply: 3/f

Quote: refer to the second floor yan_gyan_g response:

Quote: refer to 1st floor sych888 response:

Two machine memory parameters setting is not the same as
Especially when the PGA

Certainly is not the same, but certainly a formal library bigger than testing library, formal total 8 g, test a total of 4 g, I also consider this problem, main is there is no reason to test there is no temporary table space, formal use, the only way is to increase the temporary table space, get the same as testing library, but it may not be able to get two days

The formal library have? What other transactions at the same time operating database? Take up memory space

Seems to be some update, but I vaguely remember hint is temporary table space as if not enough, but now I don't understand, why the test library use temporary table space, and check information, collect statistics will use temporary table space, but why, don't know

CodePudding user response:

reference 4 floor ghx287524027 response:

this depends on your database configuration parameter, may lead to a parameter value is not the same as the background is different, the effect of two a configuration, if not exactly the same db, so there is no more meaning

What parameters? Just a collection of statistics, with less than so many relations,