|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle |
RSA Version/Condition: All
|Issue||When database statistics are executing in an RSA Identity Governance & Lifecycle database, SQL queries may be seen that insert data from the AVDB database schema into tables called SYS.ORA_TEMP_1_DS_<number>. What are these tables?|
Below is an example of such a query:
Note this query inserts data into table SYS.ORA_TEMP_1_DS_2666110. What is this table?
|Resolution||SYS.ORA_TEMP_1_DS_% tables are global temporary tables used by Oracle when running database statistics (dbms_stats).|