Hello Everyone, In this article , we will learn Excluding tables while performing datapump import from full schema backup. Database : AVPROD Schema : OT Check objects count in OT Schema. SQL> SELECT COUNT(*), OBJECT_TYPE,STATUS FROM DBA_OBJECTS WHERE OWNER=’&USERNAME’ group by object_type,status; COUNT(*) OBJECT_TYPE STATUS… Read More
Dear Readers, In this article, we will see the following Install PostgreSQL12 On SUSE Linux. Steps to Follow : Logging to AWS Account Launch PostgreSQL EC2 Instance Connect to Linux EC2 Instance by Using Putty Add PostgreSQL Repository Install PostgreSQL 12 Enable the PostgreSQL Start… Read More
Dear Readers, In this article, we will see the following Installation of SQL Server On AWS Cloud. This provides a step by step procedure for installing a new instance of SQL server 2014 by using the SQL server setup installation wizard. Now I will show… Read More
Hello Everyone, In this article , we will learn how to Attach and de-attach the expdp/impdp datapump jobs. EXPDP and IMPDP is used to take the logical backup of full database, tablespace ,schema,table and query level. we can attach or deattach the datapump jobs using… Read More
Dear Readers, In this article, we will see the SQL Joins. Joins A join is a query that combines rows from two or more tables Join Conditions Most join queries contain WHERE clause conditions that compare two columns, each from a different table. Such a… Read More
Dear Readers, In this article, we will see the following Introduction to SQL Server. DBMS: Human needs have increased tremendously. Now people are doing much more composite tasks than ever before. Society has become very complex if a person has to work in a huge… Read More
Dear Readers, In this article, we will see the following Important ASM Commands. Tab Name : asm_free set linesize 300 col name for a30 select NAME, ALLOCATION_UNIT_SIZE, STATE, TYPE, TOTAL_MB, FREE_MB,(FREE_MB/TOTAL_MB)*100 PCt_FREE from v$asm_diskgroup order by PCt_FREE ; NAME ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB PCT_FREE… Read More
Dear Readers, In this article, we will see the following Oracle : Redolog Files. Redo log Files are Recovery options whenever Database crashes or Down. LGWR will take care of redo content that needs to be written to redolog files, Based on SCN a record… Read More
Dear Readers, In this article, we will see the following Daily Tips for .NET. Tip-1 : Date: 21-Dec-20 Provided By (Linkedin): Deepthi 👉 Use yield in C# instead of temporary collections. Tip-2 : … Read More
Dear Readers, In this article, we will see the following Installation of MySQL 8.0.21 On RHEL Using Generic Binaries in AWS Cloud . Steps to Follow : Logging to AWS Account Launch MySQL EC2 Instance Connect to Linux EC2 Instance by Using Putty Switch to… Read More
Dear Readers, In this article, we will see the following Installation of Oracle Database 19c On Windows. Step-1: 👉 Download the Oracle Database Software Download the Oracle Database 19c software (Windows Version) by the below link. https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c Oracle software will be downloaded in zip format … Read More
Dear Readers, In this article, we will see the following MySQL Upgrade from 5.6 to 5.7 to 8.0 1. Logging to AWS Account First, we need to AWS Console page by using below link. https://aws.amazon.com/console/ Click on sign in to Console button. Logging to aws… Read More
Dear Readers, In this article, we will see the following MySQL Upgrade from 5.7 to 8.0 1. Logging to AWS Account First, we need to AWS Console page by using below link. https://aws.amazon.com/console/ Click on sign in to Console button. Logging to aws account Login… Read More
Dear Readers, In this article, we will see the following MySQL Upgrade from 5.6 to 5.7. 1. Logging to AWS Account First, we need to AWS Console page by using below link. https://aws.amazon.com/console/ Click on sign in to Console button. Logging to aws account Login… Read More
Dear Readers, In this article, we will see the following Install MySQL 5.7 On RHEL 8 . Steps to Follow : Logging to AWS Account Launch MySQL Server Connect to Linux EC2 Instance by Using Putty Switch to root user Install Server Updates Install wget… Read More
Dear Readers, In this article, we will see the following Install MySQL 5.7 On RHEL 8. Steps to Follow : Logging to AWS Account Launch MySQL Server Connect to Linux EC2 Instance by Using Putty Switch to root user Install Server Updates Install wget package… Read More
Dear Readers, In this article, we will see Auditing using Percona XDB plugin. Database auditing is the monitoring of selected actions of database users. It doesn’t protect the database in case privileges are set incorrectly, but it can help the administrator detect mistakes Audits are… Read More
Dear Readers, In this article, we will see the following Install MySQL 5.6 On RHEL . Steps to Follow : Logging to AWS Account Launch MySQL Server Connect to Linux EC2 Instance by Using Putty Switch to root user Install Server Updates Install wget package… Read More
Dear Readers, In this article, we will see the following Free Buffer Wait . Buffer Cache Management : 👉 Locating free blocks (Data to write) 👉 Finding data blocks (Data to read) 👉 Managing LRU lists (Flushing least recently used blocks) 👉 Cleaning dirty buffers… Read More
Dear Readers, In this article, we will see the following Transfer Files from One Server to Another Server Using SFTP. Login as root and install sshpass package : [oracle@db2 u01]$ su – root [root@db2 ~]# yum install sshpass Create text file and Create .sh file… Read More
