Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    CONNECT_TIME with reset on action

    We have an Oracle Forms / Database application and were asked to limit User's maximum online time to 15 minutes. Following this, we set the profiles' CONNECT_TIME to 15 - this works well. How is it possible to reset this if user does any action on frontend? Maybee v$session.secon...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    PL/SQL package

    Which PL/SQL package is primarily used for interacting with Generative AI services in Oracle Database 23ai? DBMS_AI or DBMS_ML or DBMS_VECTOR_CHAIN or DBMS_GENAI?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Agent OEM 24ai

    Hi there! I've some trouble trying to upload data from agent to OMS server, everything seems correct but: emctl upload agent Oracle Enterprise Manager 24ai Release 1 Copyright (c) 1996, 2024 Oracle Corporation. All rights reserved. ------------------------------------------------...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    General Question for your thought or Experience with the Outbox Pattern and viable alternatives

    Question We're evaluating different approaches to implement the Outbox Pattern in Oracle 19c for reliable event publishing in our microservices architecture, but we're concerned about the significant I/O overhead and performance implications. Could you provide guidance on the bes...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Pl/sql procedure freezes while fetching data from dblink

    I encountered inexplicable freezing of pl/sql procedure while trying to fetch and insert data into table, however same operation runs successfully when called with sql query in any IDE. I am trying to realise ETL process in data warehouse database. I need to load data from a remo...
    #MISC#
    #ACTIONS#

Upcoming Live Sessions

Upcoming Ask TOM Live report