Hello guys, in this article we are going to learn how to install, configure and use statspack in oracle. In this activity, I’m going to use the Oracle 12c environment. Introduction to Statspack If the DB server running very slow, then we need to perform DB tuning and it is …
Read moreHow to install, configure, and use Statspack in Oracle
Hi Guys, in this article we are going to learn how to rename database using controlfile. Actually, we have two ways to rename the oracle database listed below. Rename Database using controlfile. Rename Database using NID utility. So, here I’m going to us first one how to rename database using …
Hello friends, in this article I’m going to demonstrate to you Restore RMAN Backup with a Different Database Name on New Server step by step guide. Steps to Clone database to different DB name use RMAN Full or Level 0 Database RMAN backup. Controlfile backup. spfile backup. Password file backup. …
Read moreHow to Restore RMAN Backup with a Different Database Name
Partitioning in existing table Hello, friends in this article we are going to disuse how to partitioning in the existing table using EXCHANGE PARTITION. If you want to learn more about partition click here. In this article, we are going to perform the below actions. Create a sample table and …
Read moreHow to Partitioning in existing table using EXCHANGE PARTITION
Uninstall Oracle 18c? Dear friends if you using the windows platform for Oracle database so I think you know that very well this is not an easy task to uninstall oracle software like other software. In this tutorial, we are going to learn how to uninstall oracle 18c from windows …
Oracle database 18c available for Linux and Microsoft Windows and in this article we are going to discuss how to install oracle 18c on windows. Minimum hardware requirements for Oracle 18c These are the minimum hardware requirements for oracle 18c installation. 2GB RAM 10GB Free space on your machine disk 16GB …