Articles

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   #!/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

Oracle : Important Commands for Dataguard (SecureCRT)

  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

Oracle 19c Software Installation On Linux 7.6

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

More Latest News »