0 Comments

Step by Step Apply Patch on Oracle DB Home (January 2021) 5 (1)

Step-by-Step Approach For Applying PSU Patch in Oracle 12c For Single-Instance In this article, we are going to see Oracle12c Step-by-Step Applying PSU Patch For Single-Instance database. List of the steps to follow during the activity : Check the current version of Opatch Tool Upgrade the Opatch utility if needed Take the backup of ORACLE_HOME Shutdown […]

 581 Total Views,  3 Views Today

0 Comments

Table Refresh Using EXPDP-IMPDP Datapump Command 0 (0)

Step by Step guide for Table Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Requirement of Table refresh: Table refresh is a common task that is quite often […]

 281 Total Views

2 Comments

Full Database Refresh Using EXPDP-IMPDP Datapump command 5 (4)

Step by Step guide for Full Database Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Here we are performing a full database refresh activity using Datapump: PARAMETERS SOURCE […]

 616 Total Views,  1 Views Today

2 Comments

How to run sql tuning advisor in Oracle 5 (4)

Steps by steps to run SQL Tuning Advisor in Oracle As we all know running a slow query is a major performance issue in the database also has the biggest challenge for DBA to resolve this issue. Resolving the slowness issue we are using an Oracle tool called SQL Advisor. When you run SQL advisor […]

 801 Total Views

0 Comments

Oracle Critical Database Patch IDs for January 2021 5 (1)

Oracle Critical Database Patch IDs for January 2021 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch […]

 1,325 Total Views,  3 Views Today

0 Comments

Mysql Logical Backup using mysqldump – Import 0 (0)

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

 406 Total Views

0 Comments

Step by Step Apply Patch ODA X7-2M from 18.3 to 18.8 0 (0)

Step by Step Apply Patch ODA X7-2M from 18.3 to 18.8 In this article, we are going to demonstrate step by step to apply the server patch on ODA (Oracle Database Appliance) X7-2M from 18.3 to 18.8. To apply the server patch on Oracle Database Appliance (ODA). We must have to download the latest patches […]

 575 Total Views,  3 Views Today

0 Comments

Mysql Logical Backup using mysqldump – Export 0 (0)

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

 315 Total Views

0 Comments

How to Download and Create Sample database in MySql 0 (0)

How to Download and Create Sample Database in MySql In this article, we are going to demonstrate How to Download & Create Sample Database in MySql. You can download a sample database for MySql directly inside mysql server or download it first from GitHub and then transfer it to mysql server. Click here to download […]

 353 Total Views,  1 Views Today

0 Comments

Improve MySQL Installation Security using mysql_secure_installation 0 (0)

Improve MySQL Installation Security using mysql_secure_installation In this article, we are going to demonstrate Security in MySql. mysql_secure_installation program enables you to improve the security of your MySQL installation in the following ways: You can set a password for root accounts. You can remove root accounts that are accessible from outside the localhost. You can […]

 399 Total Views,  1 Views Today