Database - RAC/Scalability (MOSC)

MOSC Banner

TEMP allocation between nodes

edited Sep 19, 2019 10:14AM in Database - RAC/Scalability (MOSC) 4 commentsAnswered ✓

hi,

I faced issue today's morning - ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

there is 2-node RAC on 18c version and within PDB we have 1 tempfile:

select * from dba_temp_files;

FILE_NAME                                                                              FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS  RELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS SHARED           INST_ID

+DATA/DBNAME/TEMPFILE/temp.266.1000561217         1 TEMP                            390070272      47616 ONLINE             1 YES 3.4360E+10    4194302           80  389021696       47488 SHARED

Interesting thing is that I tried to find out what consume TEMP during falling query and there was nothing consumed on 1st node.

                 

select inst_id, tablespace_name, total_blocks, used_blocks, free_blocks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center