This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SecurID® Governance & Lifecycle Knowledge Base

Find answers to your questions and identify resolutions for known issues with knowledge base articles written by SecurID Governance & Lifecycle experts.

Explanation of GTT_ tables used in RSA Identity Governance & Lifecycle

Article Number

000039178

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: All
 

Issue

There are tables in the AVUSER schema prefaced with GTT_ and often empty of data. What is the purpose of these tables?
 

Resolution

Any table that starts with GTT is an Oracle Global Temporary Table, that is used by the RSA Identity Governance & Lifecycle application to capture data at specific points of processing. The data captured in these tables is transient in nature. The size of these tables can vary depending on the process that is running at the time (i.e. Collections, Rules, Reviews) and the amount of data being processed. When processing these tables, Oracle uses the Temporary Tablespace (TEMP). Once the processing is complete, Oracle will release the space used by these tables.
 
0 Likes
Was this article helpful? Yes No
No ratings

In this article

Version history
Last update:
‎2021-04-24 04:20 AM
Updated by:
Administrator Administrator

Related Content

© 2023 RSA Security LLC or its affiliates. All rights reserved.