https://mikedietrichde.com/database-upgrade-hands-on-lab-oracle-18c-and-19c/hands-on-labs-for-upgrade-migration-and-patching/ How to Move a Database Using Transportable Tablespaces (Doc ID 1493809.1)

https://weidongzhou.wordpress.com/2016/04/06/direct-path-read-vs-buffer-cache-read/ For direct path read, SGA is bypassed and the blocks are read directly into…

https://dbaclass.com/article/how-to-run-sql-tuning-advisor-for-a-sql_id/

Problem: Often while conducting benchmarking tests, it is required to load a clean database before…

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; https://community.ifs.com/service-touch-apps-mwo-mro-43/how-to-create-a-user-with-unlimited-password-expiry-8585

https://gavinsoorma.com/2009/07/data-guard-adding-and-resizing-a-datafile-on-the-primary-database/ In a Data Guard environment, care should be taken while performing tasks like adding…

RTO and RPO in Disaster Recovery Planning The terms RTO and RPO are often thrown…

set lines 1000 pages 140col OutBytesPerSec for a10col OUTPUT_BYTES_DISPLAY for a20col INPUT_BYTES_DISPLAY for a20col TIME_TAKEN_DISPLAY…

rsync -avzr –progress /backup/finename.dmp oracle@linux1:/d01/oracle/new

http://mdvreddy.blogspot.com/2016/10/rman-11003-failure-during.html — Please note correct set of backup is must for recovery.. no backup means…