I want to calculation week number concatenated with year as yyyy My week starts from Saturday to Friday Example: week 1 for year 2025 will be from December 28th 2024 to 3rd jan 2025 Week 1 for year 2024 will be 30th December 2023 to 5th jan 2024 Please help me how this can be ach...

Does the "Host CPU" in the PDB AWR mean the CPU usage for the PDB, CDB or the host?

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

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

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