Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Interactive Grid

    El erro al crear un Interactive Grid en la versión Oracle APEX 24.2.0 en versiones anteriores funcionaba sin problemas ORA-01400: cannot insert NULL into ("APEX_240200"."WWV_FLOW_IG_REPORTS"."ID")
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    ASMFD not working when we do an in-place upgrade or migrate to RHEL 7

    We are currently in the process of upgrading our Oracle database servers from RHEL 7 to RHEL 8. We are considering two possible approaches: Migrating to a new server built with RHEL 8. Performing an in-place upgrade on the existing server. In both approaches, we intend to use ASM...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Weird Cost-Based-Optimizer behavior

    Hello! We encountered strange (and logically inconsistent) CBO behavior. To provide some context: we are working with an EAV (entity-attribute-value) schema, all objects are stored in a single table, let's call it "my_objects", another table, "object_ancestry", stores all ancesto...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How to configure proxy server between Golden Gate source and destination servers?

    Environment Information Database : Oracle Database 19c (Multi-Tenant Architecture) - Version 19.25.0.0.0 GoldenGate : Oracle GoldenGate Microservices 19c Replication Setup : Data replication will be configured between: Source : On-premises database server (Server A) Target : Azur...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Bitmap indexes and BITMAP CONVERSION TO ROWIDS

    Hello Chris. Hello Connor, I’m struggling with a performance issue … We have a single big table (167 million of rows, 118 columns). For ad hoc queries we have created a simple Apex application with 15 most important columns as filters. To avoid long running queries we start a sim...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report