Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    test

    test asdfjksa abasdflkj
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Use of dbms_scheuler

    After using dbms_scheduler since its introduction I was surprised to learn that it is not the way application development should go. I was explained that having scheduling outside of the database is better than having it inside the database. And the replacement are crontab, compl...
    #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#
  • #SELECTION#
    Connor McDonald

    Solving a logical problem using analytical functions

    (https://livesql.oracle.com/ords/livesql/s/da34i74lkmxt2mqrtp0k4xsk6 ) (I was able to format better with screenshots on the Oracle forums - https://forums.oracle.com/ords/apexds/post/help-solving-a-logical-problem-using-analytical-query-3778) Hi, I am trying to solve a problem us...
    #MISC#
    #ACTIONS#

Upcoming Live Sessions

Upcoming Ask TOM Live report