Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    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

    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#
    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

    SQL Plus doesn't consider special characters in filenames

    There are files that contain special characters (i.e. $, #) in the name, and SQL Plus cannot find them. $ sqlplus -L user/password@host:port/SID @/path/to/file/create$spec_view.sql SQL*Plus: Release 12.2.0.1.0 Production on Thu Dec 13 17:29:54 2018 Copyright (c) 1982, 2016, Ora
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    v$sql_montor retention

    Hi Team, Recently, while reading articles by Maria Colgan, I found out that I was able to generate reports from the v$sql_monitor info that help me alot when I am trying to find out what is happening to the performance on our systems. I am also using the historic view DBA_HIST_RE...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report