Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Gather Schema Stats

    Hope you're doing well. I'm reaching out to get your inputs on statistics gathering in our Oracle Autonomous Database (version 19c), which we use to support our integration workloads. We have a few very large tables (approximately 70 million records each) that serve as history ta...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Upload XLSX file to table in oracle apex

    I want to upload multiple XLSX files, each containing multiple sheets. The data from each sheet should be inserted into a table with the same name as the sheet (the tables already exist) using Oracle APEX. Is this possible?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Ways to find why a SQL Plan Baseline is not being used

    Hi Chris/Connor. We have a production 12c Database (12.2.0.1) and have enabled a particular SQL Plan Baseline for a high-load query, but, for some reason, it's not being used. Baseline is ENABLED and FIXED, and REPRODUCED column reads YES, but I can't see a date on LAST_EXECUTED ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    After Insert Trigger, Synchronous or Async

    Hi Tom, What I need to do is, to monitor a table for changes. For this a trigger needs to be setup. But my doubt is, if we create a trigger after insert or update of my table column on my table for each row, and the trigger does some time consuming task like DBMS_LOCK.SLEEP (60*1...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    SQL ASSERTIONS vs triggers, materialized views with constraints, etc

    I attended a Hotsos session by Toon Koppelaars yesterday morning on Semantic Query Optimization. Among other interesting topics, Toon lamented the lack of any DBMS implementing SQL "assertions". By which he meant a database-enforced constraint than encompassed more than a single ...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report