TEMP allocation between nodes
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