Abdul Hafeez Kalsekar -- Oracle database tuning case studies

   We had requirement  where we  want to assign maxsize  for each   Pdb for capacity  planning  whenw e had multiple Pdb iniside Same Cdb . Luckily Oracle  Doc ID 2166477.1  came to rescue  with below Steps  Default of MAX_PDB_STORAGE is no limit. Run following sql in current PDB to limit the size of all datafiles of that PDB: ALTER PLUGGABLE DATABASE STORAGE (MAXSIZE <MAXSIZE>); To verify the setting, run below in current PDB: select PROPERTY_VALUE FROM database_properties WHERE property_name = 'MAX_PDB_STORAGE'; To check every PDB's setting, run below in CDB: select PROPERTY_NAME,PROPERTY_VALUE,DESCRIPTION,CON_ID FROM cdb_properties WHERE property_name = 'MAX_PDB_STORAGE'; The storage limits for PDBs (like MAX_PDB_STORAGE and MAX_SHARED_TEMP_SIZE) are also  stored in CDB_PROPERTIES.   SELECT name,      total_size,      NVL(property_value, 'UNLIMITED') AS "MAX_SIZE"  FROM...

  In this Document Goal Solution References APPLIES TO: Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Cloud Service - Version N/A and later Information in this document applies to any platform. GOAL Starting with Oracle11g, alert and trace information is generated in a new format and stored in the Automatic Diagnostic Repository (ADR). Refer to <Document 422893.1> to know the ADR in detail. This article explains how to find and send the alert.log and relevant trace files to Oracle Global Software Support when a critical error occurs in database, using the ADRCI tool. SOLUTION Oracle11g provides tools and methods to automatically identify and gather trace files related to a problem (a critical error in the database environ...

Thought of documenting this since on exacc we have pluggable database and it uses tde. Having this article will help as one stop to get insight of Tde   wallets management  For  both TDE and TlS  we create wallet .  In case of TDE wallet contains encryption keys and TLS store contains certificates  Exacc   there is also 1 more external wallet  called as  Secure External Password Store (SEPS) for  storing sys password which is managed by mkstore  .  Will cover SEPS  in another  Blog  This Blog is dedicated to  Tde and Tls  ################################ ################################ Encryption of Data at Rest (TDE) ################################ ################################ -- Encryption of the Data Files on Disk Main Steps For TDE Include  TDE DB Parameter Changes Configure a Software KeyStore Create Master Key Create Auto-login KeyStore Encryption of Tablespaces Backup Ke...

  Since  between  Migrations we were required  to compare sql performance  with different optimizer modes .   Here old  tool  SPA  helped us    .   Documenting handy steps of myself and will help  others Too .  The steps involved in the SQL PERFORMANCE Analyzer are 1) Create the Sql Tuning Set (STS). 2) Create a task to run Sql Performance Analyzer. 3) Execute Before Change TEST EXECUTE (Pre-Change SQL Trial).          Make a change that needs to tested. 4) Execute After Change TEST EXECUTE (Post-Change SQL Trial). 5) Comparing SQL Trials. 6) Generate Compare report. You can use the SQL Performance Analyzer to analyze the SQL performance impact of any type of   system change. Examples of common system changes include: •Database upgrades •Configuration changes to the operating system, hardware, or database •Database initialization parameter changes •Schema changes, such as a...