Forum Stats

  • 3,854,197 Users
  • 2,264,340 Discussions


What exactly goes in TEMP_UNDO in 12c

user632098 Member Posts: 296
edited Sep 23, 2013 4:08PM in Multitenant

I know in Oracle 12c undo associated with temporary tables can be redirected to temp space, but want to know what exactly are  temporary tables.

I am not uisng any global temporay tables.

1. If I am doing complex join and let us say it requires sorting etc, will undo for sorting  will go in TEMP.

2. Let us say I have very large PGA and SGA so all my sorting etc is done in memory instead of intermediate reuslts written to TEMP tablespace,

will undo for sorting etc still go in TEMP tablespace.



This discussion has been closed.