Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    PDB Snapshot Copy/Carousel

    Hello Chris/Connor, Hope you are doing well. We are using ExaC@C with 19c databases at work and are exploring whether we can use PDB Snapshot Carousel and/or PDB Snapshot Copy feature. It might be just me but I am somewhat confused with the "art of possible" while using ASM. PDB ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    connection pooling

    Tom, What is connection pooling ? Please, can you give an example(s) that show thorough understanding of the subject matter as related to either ODBC OR JDBC application connections to the oracle database. Your site is more important and most value to the little understading and ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    PDB AWR Host CPU

    Does the "Host CPU" in the PDB AWR mean the CPU usage for the PDB, CDB or the host?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    PAGE REFRESH CAUSED BY DATABASE TRIGGER.

    Hi, I have created an application that is tracking a set of processes that are being run from a master table. When a process is completed, a flag in a column name PROC_EXEC_STATUS changes from N to Y for each process. I want my oracle apex application to refresh when the flag for...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    SQL macro with different table

    Hi, I have a database with thousands of tables containing the same kind of information. I need to write a program to aggregate these informations and thought about using a sqlmacro. -- This is a very simplified concept create or replace function get_val (p_table_name varchar2)
    #MISC#
    #ACTIONS#

Upcoming Live Sessions

Upcoming Ask TOM Live report