Untitled
Different Results Between QUERY Parameter Used With EXP/EXPDP and SQL*Plus APPLIES TO: Oracle Database – Enterprise Edition – Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2] SYMPTOMS: You try to…
Read MoreView running processes in Oracle DB
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 RAC
Start/ 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 MoreTablespace Thresholds and Alerts
How 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
Creating 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 in Oracle Fusion Financials
How 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
Creating 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 in Oracle Fusion Applications
How 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 MoreInvoice Payment in Oracle Fusion Applications
Invoice Payment in Oracle Fusion Applications Please find the below setups for Creating the Customer Step1: Login as Application User Step2: you will be in home page as below Step3:…
Read More