Oracle Database Administration

  Exadata interview Getting ready for a Exadata interview? Make sure to refresh your knowledge by reviewing this list of Exadata Interview Questions. What environment is a good fit for Exadata? Exadata was originally designed for the warehouse environment. Later it was enhanced for use in the OLTP databases as well. What are the advantages of Exadata? The Exadata cluster allows for consistent performance while allowing for increased throughput. As load increases on the cluster the performance remains consistent by utilizing inter-instance and intra-instance parallelism. It should not be expected that just moving to Exadata will improve performance. In most cases it will especially if the current database host is overloaded. What is the secret behind Exadata’s higher throughput? Exadata ships less data through the pipes between the storage and the database nodes and other nodes in the RAC cluster. Also it’s ability to do massive parallelism by running parallel processes across all t...

  Out Of Place (OOP) Patching: Oracle 19c RAC (19.7.0) to Oracle 19c RAC (19.9.0) using 2-Step Method with Rollback Option https://yvrk1973.blogspot.com/2020/10/out-of-place-oop-patching-oracle-19c.html?m=1 Thank you  Y V Ravi Kumar

  Oracle Data Guard Fast-Start Failover using Observer in Failover Scenario https://yvrk1973.blogspot.com/2020/11/oracle-data-guard-fast-start-failover.html?m=1

  How To Patch An Exadata https://blog.pythian.com/patch-exadata-part-1-introduction-prerequisites/ https://blog.pythian.com/patch-exadata-part-2-cells-ib-db-servers/ https://blog.pythian.com/patch-exadata-part-3-grid-database-oh-patching/ https://blog.pythian.com/patch-exadata-part-4-rollback-procedure/ https://blog.pythian.com/patch-exadata-part-5-troubleshooting/ https://blog.pythian.com/patch-exadata-part-6-timing/ Upgrading and Patching Exadata to 18c and 19c https://hiteshgondalia.wordpress.com/2020/09/08/upgrading-and-patching-exadata-to-18c-and-19c/ Shutdown and Startup Exadata https://hiteshgondalia.wordpress.com/2020/09/09/shutdown-and-startup-exadata/ Below are the some of the good article related to this topics. https://oracleracdba1.wordpress.com/2013/08/14/steps-to-shut-down-or-reboot-an-exadata-storage-cell-without-affecting-asm/ http://www.oracle-ckpt.com/shut-down-or-reboot-an-exadata-storage-cell-without-affecting-asm-for-maintenance/ https://dba010.com/...

  Configure the Resource Manager Ref: Thanks  https://hiteshgondalia.wordpress.com/configure-the-resource-manager/#b1 Configure the Resource Manager Go back to  OCM 12c Preparation Project  Hands On Lab – Index [1] Setup the Resource Manager for 12c Non CDB. [2] Test RM for elapsed time limit exceededM [3] Test RM for parallel server limit [4] Test RM for IO Limits (SWITCH_IO_MEGABYTES) [5] Test RM for Active Sessions Limit(active_sess_pool_p1) [6] Test RM for Undo Limit (undo_pool) [7] Automate active respective plan on their schedule window. So Resource Manager for 12c is also pretty the same as Resource Manager for 11g for a database plus the CDB Resource Plans, where you can control how many "shares" and the limitations for each PDB will have in a multi-container environment. In 12c now you can also set the resource plan directive PARALLEL_STMT_CRITICAL to BYPASS_QUEUE for a high-priority consumer group so that parallel statements from the consume...