Hi Dears, In this article, we will see How to Switch/Recreate Undo Tablespace at PDB Level(12cR2) In Oracle Database 12c Release 1 all containers in an instance shared the same undo tablespace. In Oracle 12c Release 2 each container in an instance can use its… Read More
Hi Dears, In this article, we will see Manage SQL Profile in Oracle Database A SQL profile is a collection of auxiliary statistics on a query, including all tables and columns referenced in the query. The profile is stored in the data dictionary. The optimizer… Read More
Hi Dears, In this article, we will see Resource Manager in Oracle Resource Manager is an enterprise edition feature which will restrict sessions consuming high resources. We can assign shares to sessions depends on priority of session. We can restrict degree of parallelism for group… Read More
Hi Dears, In this article, we will see Oracle Sample Unix script to monitor select query during Load Test #!/bin/bash ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1 ORACLE_SID=ORCL while : do sqlplus -s / as sysdba <<EOF set pagesize 0 set linesize 300 select B.USERNAME ||’ (‘||B.SID||’,’||B.SERIAL#||’,@’||B.INST_ID||’) is Currently ‘||B.STATUS||’… Read More
Hi Dears, In this article, we will see Configure Active DataGuard and DG BROKER. Oracle Active Data Guard allows DBAs and users to run real-time queries on a physical standby system for reporting. Queries and reports can be offloaded from the production system to… Read More
Hi Dears, In this article, we will see Difference between ROWID and ROWID BATCHED in Oracle. TABLE ACCESS BY INDEX ROWID BATCHED is new execution plan operation introduced in oracle 12c to improve performace by make efficient and minimal read writes to the disk. It… Read More
Hi Dears, In this article, we will see Silent Installation of Oracle 19c Database on AWS. Hardware Requirements: Yum Packages to install in server: yum install -y oracle-epel-release-el7 yum install -y oracle-database-preinstall-19c yum install -y bc yum install -y binutils yum install -y compat-libcap1 yum… Read More
Dear Readers, In this article, we will see the following Backup Details of SQL. SQL Server offers many options for creating backups. As we discussed what types of backups can be performed based on the recovery model of the database. Here different types of backups… Read More
Hi Dears, In this article, we will see Install Ubuntu 20.04.1 LTS On Windows.. Steps to Follow Download and Install Oracle VM VirtualBox Download Ubuntu 20.04.1 LTS Create New Virtual Machine Install Ubuntu 20.04.1 LTS in Virtual Machine Install Guest Additions 1. Download and Install… Read More
Hello Readers, In this article ,we will see how to a container database to the existing RMAN recovery catalog. Please check below article before adding container database to RMAN Catalog. How to Create an RMAN Recovery Catalog Target Database : … Read More
Dear Readers, In this article, we will see the following How to Get Instance Details By Using Boto3. Steps to Follow : Logging to AWS Account Launch Linux Server Connect to Linux EC2 Instance by Using Putty Install Python Package Install Boto3 Package Connect to… Read More
Hello Readers, In this article, we will see Recovery models in SQL Server. 1. Take backup of the primary database run { allocate channel ch1 device type disk maxpiecesize 2G; allocate channel ch2 device type disk maxpiecesize 2G; backup incremental level 0 cumulative database… Read More
Hello Readers, In this article, we will see Recovery models in SQL Server. SQL Server backup and restore operations occur within the context of the recovery model of the database. Recovery models are designed to control transaction log maintenance. A recovery model is a database… Read More
Hello Readers, In this article, we will see Creation of RMAN Recovery Catalog. Target Database : Catalog Database: Name : AVPROD … Read More
Dear Readers, In this article, we will see the Oracle : Important Commands for Dataguard (SecureCRT) Menubar Name : Dataguard Tab Name : Instance_info set linesize 300 col machine for a60 select name||’ – ‘||instance_name||’@’||host_name||’ – ‘||DB_UNIQUE_NAME||’ – ‘||version||’ – ‘||open_mode||’ – ‘||to_char(startup_time,’DD-MON-YYYY HH24:MI:SS’)… Read More
Dear Readers, In this article, we will see the Autonomous Health Framework. AHF includes number of diagnostic tools in a single bundle and helps us to gather various types og information like upgrading info. , oracheck….. AHF combines Trace file analyzer(TFA), orachk etc.., which oracle… Read More
Dear Readers, In this article, we will see the Oracle : Important Queries for Parallel Feature (SecureCRT). Menubar Name : Parallel Tab Name : Create table show parameter parallel_max_servers create table owner.tablename_bkp as select /*+ parallel(tablename,64) */ * from owner.tablename ; create table vinod.tablename_bkp as… Read More
Dear Readers, In this article, we will see the Oracle: Important commands for Lock/Unlock Stats and Backup/Restore Old Stats (SecureCRT). MenuBar Name : Lock/Unlock Stats and Backup/Restore Old Stats Tab Name : Check Stats for Table –example : ‘DEPT’,’EMP’,’SALGRADE’ set linesize 300 set pagesize 100… Read More
In this article, we will see Oracle 19c (19.3) Software Installation On Linux 7.6 Click here to Download Oracle 19c Software from Oracle Support. Create a directory for ORACLE_HOME [oracle@oracle19c ~]$ mkdir -p /oracle/app/product/19.3.0/dbhome_1 Unzip the oracle 19c software [oracle@oracle19c ~]$ unzip -d /oracle/app/product/19.3.0/dbhome_1/LINUX.X64_193000_db_home.zip Goto Oracle… Read More
Dear Readers, In this article, we will see the Transport Plan from One Database to Another Database in Oracle . Transport Good Execution Plan(Hash Plan) from one database to another database Requirement: ETL was taking longer period of time in Prod database where as in… Read More
