What’s the ORA_TEMP_%_DS_% table, eg. SYS.ORA_TEMP_1_DS_%

  • 2019/09/22
  • ORACLE 9i-23ai
  • 619 views
  • What’s the ORA_TEMP_%_DS_% table, eg. SYS.ORA_TEMP_1_DS_%已关闭评论

This is expected behavior. ORA_TEMP_%_DS_% is only used when gathering histogram. SYS.ORA_TEMP_1_DS_% are global temporary tables created by dbms_stats to generate histograms for tables.

阅读全文