Important Oracle v$parameters (SecureCRT)

Hi Dears, In this article, we will see Important Oracle v$parameters (SecureCRT) Tab Name : v$parameter Button Name : SGA

Output :

Button Name : SGA_TARGET

Output :

Button Name : PGA_Aggregate_target

Output :

Button Name :… Read More

Oracle Sample Unix script to monitor select query during Load Test

Hi Dears, In this article, we will see Oracle Sample Unix script to monitor select query during Load Test  

Output :

  Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates KTEXPERTS is always… Read More

Silent Installation of Oracle 19c Database on AWS

Hi Dears, In this article, we will see Silent Installation of Oracle 19c Database on AWS. Hardware Requirements: Yum Packages to install in server:

User/group Creation:

Setup Filesystem:

Download Software from Oracle Site: Software installation by using attached response file: a) Unzip… Read More

Rebuild Stand By database when PDB restored from restore point/Issue with the PDB

Hello Readers, In this article, we will see Recovery models in SQL Server.   1. Take backup of the primary database

2. Create standby control file from primary database.

3. Transfer backup pieces along with control file from primary server to standby server.… Read More