+25 Oracle Global Temp Table 2023. Web prior to oracle database 12c, global temporary tables (gtts) shared statistics between sessions, so each gtt had one set of statistics visible to all sessions. A temporary table is a table that holds data only for the duration of a session or transaction.

The performance of application engine programs are enhanced on using gtts. Web prior to oracle database 18c, only global temporary tables existed. Available since oracle 8i and.