OVERVIEW: Oracle Autonomous Transaction Processing (ATP) is a cloud-based, fully managed database service by Oracle. It automates administrative tasks, enabling users to focus on application [...]

INTRODUCTION SQL tuning is the process of improving SQL queries to accelerate your servers performance. It’s general purpose is to reduce the amount of time it takes a user to receive a [...]

[...]

ORA-20004: Error in sending an Email – You have exceeded the maximum number of email messages per workspace. Please contact your administrator. REASON: Actually, Number of mails can be sent [...]

BEFORE WE HAVE CHECK THE OPATCH VERISON AND LAST UPDATE CHECK OPATCH VERSION [oracle@kaamesh OPatch]$ pwd /u01/app/oracle/product/19.0.0/dbhome_1/OPatch [oracle@kaamesh OPatch]$ [oracle@kaamesh [...]

Before cloning we have to take full database backup using  RMAN Target  / COMMAND: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Once completed,move the backup file to target server USING SCP BACKUP [...]