By Gowthami | apps-dba.com | Oracle Performance Series Oracle Parallel Query (PQ) allows a single SQL statement to be executed by multiple ...
Read the full lessonShowing posts with label 12c. Show all posts
Showing posts with label 12c. Show all posts
February 14, 2023 · 12c · 19c · dba · oracle · parallelism · performance · tuning
Using Parallelism in Oracle Database 12C
October 18, 2022 · 12c · awr · dba · oracle · performance · tuning
Modify AWR interval and retention periods in 12C
By Gowthami | apps-dba.com | Oracle Database Administration Series AWR (Automatic Workload Repository) is Oracle's built-in performanc...
Read the full lessonSeptember 21, 2022 · 12c · dba · dbms_spm · optimizer · performance · tuning
Create SQL Plan Baselines for High Resource Intensive SQL's from AWR - 12C
=> Identify SNAP ID's for the interval Here I am collecting resource intensive SQL's ran on a week from Monday (12-SEP-22) to F...
Read the full lessonJuly 05, 2022 · 12c · cdb · dba · oracle · pdb
Change CDB and PDB names in 12c
Change CDB name from DEVCDB to TESTCDB ********************************************* Backup database before performing this action *********...
Read the full lesson
Subscribe to:
Posts (Atom)
-
By Gowthami | apps-dba.com | Oracle Administration Series A common issue after Oracle Database 19c patching is a Pluggable Database (PDB) o...
-
By Gowthami | apps-dba.com | Oracle Performance Series Oracle Parallel Query (PQ) allows a single SQL statement to be executed by multiple ...
-
Oracle Data Safe - Practical Guide Oracle Data Safe learner guide Oracle Data Safe Assess risk, discover sensitive data, audit acti...
Oracle DBA Lesson 20B — Define How a New Database Will Be Accepted
OPEN means the instance finished recovery and will take sessions. It is not a handoff. Acceptance is four proofs, each with evidence, ...
