Setting up glogin.sql : cd $ORACLE_HOME/sqlplus/admincp glogin.sql glogin.sql.bkp vi glogin.sqlSET termout offDEFINE myv = ‘Not connected’COLUMN myc new_value myvselect user || ‘@QA@’ || global_name myc from global_name;SET sqlprompt ‘&myv:SQL> ‘ Execution : $ sqlplus scott/PW SQL*Plus: Release 22.214.171.124.0 Production on Mon Mar 27 21:56:19 2017… Read More
Use this script to setup oramenu: #!/bin/bash # set -x # # THIS SCRIPT WILL draw the menu of all available Oracle Instances from /etc/oratab. # It will simplify the way you set environment varaibles. # # Get the list of SID’s from /etc/oratab file… Read More
Performance issue with particular form in EBS: Its common issue which reports by end user that they have a performance problem with particular form or form is slow responding Have the user show DBA exactly which form runs slow by select Help->Diagnostics->Trace and click in the… Read More
Steps for Update Statement Process in SGA: update processes >update emp set sal=5000 where empno=7903; step 1 when user fires update statement first it will start user processes step 2 user processes to server processes with the help of user processe interface step 3… Read More
Hi All, Please check below link for AWS Demo video session https://vimeo.com/209007042 Regards, Vinod.
Steps for Select Statement Process in SGA : >SELECT * FROM EMP; step 1 when user fires update statement first it will start user processes step 2 user processes to server processes with the help of user processe interface step 3 server processes to… Read More