0 Comments

Important Technical Links Powered by DBsGuru 5 (4)

Important Technical Links Powered by DBsGuru About Us DBsGuru is a group of experienced DBA professionals and serves the database and its related community by providing technical blogs, projects, training. Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on. We are […]

 616 total views,  4 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 […]

 23 total views,  3 views today

0 Comments

Full Database Refresh Using EXPDP-IMPDP Datapump command 0 (0)

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 […]

 35 total views,  2 views today

0 Comments

How to run sql tuning advisor 0 (0)

Steps by steps to run SQL Tuning Advisor 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 for the […]

 86 total views,  4 views today

0 Comments

Oracle Critical Database Patch IDs for January 2021 0 (0)

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 […]

 255 total views,  16 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 […]

 41 total views,  1 views today

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 […]

 51 total views

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 […]

 51 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 […]

 96 total views,  3 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 […]

 99 total views,  2 views today

0 Comments

MySql File-based Master Slave Replication – All Database 0 (0)

MySql File-based Master Slave Replication – All Database Replication enables data from one MySQL database server to be copied to one or more MySQL database servers. Replication is asynchronous by default, replicas do not need to be connected permanently to receive updates from a source. Depending on the configuration, you can replicate all databases, selected […]

 114 total views,  3 views today