000030667 - What is the SYS.ORA_TEMP_1_DS_% table sometimes seen in a running query in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Feb 19, 2020
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000030667
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: All
Platform:  Oracle
 
IssueWhen 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:
 

insert /*+ append */ into sys.ora_temp_1_ds_2666110 SELECT /*+ parallel(t,5) parallel_index(t,5)
dbms_stats cursor_sharing_exac t use_weak_name_resl dynamic_sampling no_monitoring no_substr b_pad
*/"GROUP_NAME","MEMBER_NAME","MEMBER_TYPE","DC_ID","RUN_I D" from "AVUSER"."T_DC_SOURCEDATA_GROUP_MEM" sample
( .083989 t UNION ALL SELECT * FROM sys.ora_temp_1_ds_2666110 WHERE 1 = 0


Note this query inserts data into table SYS.ORA_TEMP_1_DS_2666110. What is this table?
 
ResolutionSYS.ORA_TEMP_1_DS_% tables are global temporary tables used by Oracle when running database statistics (dbms_stats).
 

Attachments

    Outcomes