000030667 - L&G: What is the sys.ora_temp_1_ds_####### table

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000030667
Applies ToRSA Product Set: RSA Via Life Cycle and Governance (L&G)
RSA Product/Service Type: Appliance
RSA Version/Condition: 6.0.2+
IssueThe following query or something very similar is found running in the database:
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 WHER E 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 created by dbms_stats to generate histograms for tables.