August 5, 2015
There is no denying that Oracle database has evolved over the years. Some redundant features have paved way for ingenious additions to which Oracle Global Temporary Tables (GTT) is one of the latest. GTT came with Oracle 8i, but within a fairly short time, it has become indispensible for database administration and management
This is a DBA tool that is invaluable where complex calculations are involved. The session-specific table is used to store temporary data which cannot be shared with other sessions. In essence, the data in the table is valid only for the session hence the term temporary.
In other words, the data in the table is what is temporary and will disappear when the rows are explicitly deleted. If you commit the current transaction or roll it back, the data is also lost, but the definition of the table stays. Other structures within the table will also not disappear including synonyms and views.
The crux of an Oracle GTT is the fact that the table is private to your session. For instance, 10 applications could be inserting data into the temporary table, but each application can only view its own data.
The features in this database application make its functional value in DBA invaluable. Most of the features are just like what you find in ordinary tables including triggers, information about rows and columns and much more.
Some of the miscellaneous features you will find in this application include:
Creation of Oracle Global Temporary Tables is similar to that of an ordinary table but with the addition of the words GLOBAL TEMPORARY. You should then specify whether the table is transaction bound or session bound in the clause ON COMMIT.
There are myriad situations calling for a temporary table. Moreover, most remote database services cite various benefits of applying GTT in database management. Here are a few of these pros:
There are many other functional benefits of using Oracle Global Temporary Tables, and with this hindsight, you can start applying it on your database.