0 Comments

Mysql Logical Backup using mysqlsh – Import 0 (0)

Mysql Logical Backup using mysqlsh – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mysqlsh – Export Click here to read more. In the previous blog, we saw How to perform the export of the Database and Table using mysqlsh. Now in this post, we will see How to perform an import of […]

 27 total views,  1 views today

0 Comments

Step by Step Drop Database using DBCA in Oracle 0 (0)

Step by Step Drop Database using DBCA in Oracle In this article, we are going to demonstrate Step by Step DROP database using DBCA (GUI) in Oracle. Generally, we do drop the database when application testing completed or not require anymore to business. We can drop the database using the below methods: 1. Manual (Command […]

 44 total views,  1 views today

0 Comments

Mysql Logical Backup using mysqlsh – Export 0 (0)

Mysql Logical Backup using mysqlsh – Export In this article, we are going to demonstrate MySQL Logical Backup using mysqlsh – Export. There are several ways to backup MySQL data. Those are: –                   1) Physical Backup                   2) Logical Backup Physical Backup:It […]

 29 total views

0 Comments

Mysql Logical Backup using myloader – Import 0 (0)

Mysql Logical Backup using myloader – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mydumper – Export Click here to read more. In the previous blog, we saw How to perform the export of the Database and Table using mydumper. Now in this post, we will see […]

 37 total views

0 Comments

Mysql Logical Backup using mydumper – Export 0 (0)

Mysql Logical Backup using mydumper – Export In this article, we are going to demonstrate Mysql Logical Backup using mydumper – Export.  There are several ways to take the backup of MySQL data. Those are: –                   1) Physical Backup                   2) […]

 72 total views

0 Comments

Step by Step How to increase SGA size in Oracle 0 (0)

Step by Step How to increase SGA size in Oracle I was facing a memory issue in my environment after validating the AWR  and ADDM reports and came to the conclusion that SGA is undersized. Below are both options to increase SGA_MAX_SIZE and SGA_TARGET size using pfile & spfile. in our environment, it’s running using […]

 236 total views

0 Comments

Mysql Logical Backup using mysqlpump – Import 0 (0)

Mysql Logical Backup using mysqlpump – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mysqlpump – Export, Click here to read more. mysql utility is used to import mysqlpump dump files so import commands are the same like we used in mysqldump. In the previous blog, we […]

 53 total views

0 Comments

Step By Step Apply Combo Patch on Primary & Standby (DATAGUARD) Database in Oracle 5 (3)

Combo Patch Apply on Primary & Standby Database in Oracle In this article, we are going to demonstrate step by step apply combo patches on Oracle Primary & Standby (DATAGUARD) which released in January 2021, combo patch contains PSU (31985579) and  OJVM (32119956) patches. Below is the database, system,  patch id, etc. details.   COMPONENTS […]

 239 total views

0 Comments

How to Check PGA information 0 (0)

How to Check PGA full information.   A Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for each server […]

 44 total views

0 Comments

How to Check Long Running Job in the Oracle Database 0 (0)

How to Check Long Running Job in the Oracle Database Sometimes in the database, few queries are taking a long time to complete the query, to validate which query taking a long time. Below is the query to check the long-running jobs/queries in the database where: SOFAR:-  Total block Processed. TOTAL WORK:- Total work Block […]

 89 total views