View running processes in Oracle DB This will show you a list of all running processes: SET LINESIZE 200SET PAGESIZE 200SELECT PROCESS pid, sess.process, sess.status, sess.username, sess.schemaname, sql.sql_text FROM v$session…
Read MoreStart/ Stop / Relocate SCAN listener in Oracle 11gR2 RAC1) Check listener status ( login to grid home)a) Check the cluster resource status $ crsctl stat res -tverify the output…
Read MoreHow to set tablespace thresholds?If you have very less no. of targets and you are using dbcontrol for each database, then use DBMS_SERVER_ALERT package to set. If you have OEM…
Read MoreCreating the Customer in Oracle Fusion Applications Please find the below setups for Creating the Customer Step 1: Login as Application User Step 2: you will be in home page…
Read MoreHow to Prepare the OTBI Reports for Invoice Data Please find the below setups for Preparing the OTBI Reports Step 1: Login as Application User Step 2: you will be…
Read MoreCreating With holding Tax Invoice in Oracle Fusion Applications Please find the below setups for Creating the Customer Step 1: Login as Application User Step 2: you will be in…
Read MoreHow to Prepare the BI Reports by using the Simple SQL Query Please find the below setups for Preparing the BI Reports How to find out the Basic table information…
Read More