Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Sequence will skip some numbers

    Hi, I have a sequence skip number problem. I have this sequence. The cache is 20 and noorder. create sequence seq_serial_no minvalue 1 maxvalue 999 start with 2 increment by 1 cycle The current situation that has arisen is: I have two servers A and B. They connect to the same da
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    "proper" way to join v$session and v$sqlarea

    Hello, a few questions: 1. All of the scripts I have written years ago use both address and hash_value to join v$session and v$sqlarea. What I don't quite understand is why it's not sufficient to just join on hash_value (or sql_id). Why was/is address also needed? Doc ID 43716.1 ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Failed to set wallet path to system:

    Hi, While listening through the video "Developer Coaching - Oracle Database 23ai - Zero Slides, Zero Marketing, 100% Live Demo" there mentioned that we can set the oracle wallet path to system: to access the windows level certificates, but when I tried the same using below PLSQL ...
    #MISC#
    #ACTIONS#
  • #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#

Upcoming Office Hours

Upcoming Office Hours report