Oracle Apps and Oracle Database

 Find Client IP Address logged in to EBS 12 Below query will provide the list of all application users connected to EBS with their client IP...

 Execute/Run Tuning Advisor from backend step1 : login as sysdba or with user with tuning advisor priv Step 2: Identify the sql for which yo...

Huge archive log generation .. what to do? what is causing it Step 1: Know which table / object has more number of changes during the pro...

Below query can be used to find details of PID runing on Server and its associated SID,Serial# at database level col sid format 999999 c...

Processes consuming swap on Server ## Get swap space in Linux using bash for loop ## for file in /proc/*/status ; do awk '/VmSwap|Na...