Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    SPM and GTTs

    Howdy, I'm wondering about how SPM and things like https://blogs.oracle.com/optimizer/post/what-is-add-verified-spm would be impacted by the presence of global temporary tables within the query(s). I've been looking for documentation that would outline how SQL plan management wou...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Update Partition table from another Partition table Performance issue

    Hi I am migrating from Sybase IQ to Oracle 19C. there are many updates happening from one or multiple tables. My Target_TBL Table has 18 Million records per partition and there are 1000's of Partitions. (Partitioned by VersionID). APP_ID is one of the another key column in this t...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    High Watermark on a table

    What is the main purpose of white watermark and in a case secnario where all the records have been deleted and we try to lookup that table why does the data is looked untill it reaches to an end of whte watermark
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    ORA-00001 on merge, concurent transactions

    When having two simultaneous merges into a table with a unique constraint in different sessions, the second one throws ORA-00001. Steps to reproduce: create table tab1 (col1 number); create unique index ind1 on tab1(col1); --1st session: merge into tab1 d using ( select 1 c
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Day Light Savings

    Hi Tom Here is the problem description- A reporting tables holds data with the date columns in EST. The report when viewed the same columns are reported in CST. I can add a straight offset and make the report available with the columns in CST. But what happens during the DST chan...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report