Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#

    Containment queries

    Greetings, I have created a map in Oracle APEX where the user can click and get the lat and long and drop a pin there. Now, I want to find which congressional district the pin was dropped in. I have a table with all congressional districts, but that is geojson data that gives pol...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Pooled timeout with 19c

    I am facing issue of "Pooled connection request timed out" when I upgraded database to 19c and moved the application to cloud(TAS) from VM. There is no fixed scenario when this happens. No code changes has been done except replacing DataAccess.dll to ManagedDataAccess.dll. SGA is...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    ORA-06565: SET ROLE in LOGON TRIGGER

    We have a trigger CREATE OR REPLACE TRIGGER TRG_AFTER_LOGON AFTER LOGON ON DATABASE BEGIN LogonCheck; END; / with CREATE OR REPLACE PROCEDURE LogonCheck AUTHID current_user AS BEGIN EXECUTE IMMEDIATE 'SET ROLE NONE'; END; / This always results in error ORA-06565, if LogonChe
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Comparison between ALTER TABLE MOVE ONLINE and DBMS_REDEFINITION

    I need to move online a huge table with BLOBs (around 25 TB) to a new tablespace with bigger block size. Wich method is recommended? Is DBMS_REDEFINITION still the method recommended by oracle? Or is now ALTER TABLE MOVE ONLINE?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Creation of Dynamic Region OR Dynamic Interactive Report

    Before understand question mind I have one table with 3 columns one is id second is description and third is sql query, i created one Apex page with two region one is static region and one is Interactive Report Region. In Static region i have one select list for user and in Inter...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more