Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Limit SQL execution for specific SQL IDs

    Hello Connor/Chris, Hope you are doing well. Not sure if I am missing something obvious but is there a way to limit execution of specific SQL ID to a certain amount of elapsed time/CPU time? I looked at Resource Manager but it only allows to affect based on user/service/action. A...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    dba_tab_statistics remains stale after rollback

    Hi Tom. When running a DML, the dba_tab_statistics, stale_stats column will be set to "YES" for the related table also when it was before "NO". It will remain to yes, also when the entire transaction was rolled back. So it looks like the update in dba_tab_statistics set stale_sta...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Connecting db to Jupyter notebook (or alternative notebook)

    I would like to link a notebook (preferably Jupyter) to an on-prem Oracle DB. I understand that I can do this by making calls with Python, but this is <u>NOT</u> what I am looking for. I am looking a way to run the native SQL. Can I do this via SQL Developer on VS Code? Is there ...
    #MISC#
    #ACTIONS#
  • #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

    Is it possible to run Oracle Apex without cookies ?

    Hi team, I have an oracle apex 19.2 application. My app is supposed to be integrated on my clients web sites as an iframe. This is something which works very badly since Safari doesn't accept third party cookies (cookies of my app are considered third pary cookies). Chrome will e...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report