Web ADI for Integrating PO using Code Combination Separator
By using batch mode and COA setups with separator defined in system custom Web ADI been developed in EBS application and integrated with custom template using PO interface. Pre-…
Read MoreData Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c
Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high…
Read MoreDBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c
DBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c The DBMS_JOB package has been deprecated since 12cR2. Oracle 19c takes the demise of the DBMS_JOB package a step further by converting any DBMS_JOB jobs to DBMS_SCHEDULER jobs.…
Read MoreMaximum Security Zone in Oracle Cloud
Maximum Security Zones provides both preventative and detective security controls for cloud environment. Maximum Security Zones is the preventative control, designed to stop from making bad implementation choices that would…
Read MoreMobile First strategy with Oracle CX Mobile App
Enterprise are emphasizing on building a culture of proactive sales with responsibility of identifying leads,new account openings and agility in closing deals. To achieve this, organizations are looking towards recent…
Read MoreTOP Elapsed time SQL in certain hours with below script
Query will find out TOP Elapsed time SQL in certain hours with below script SELECT st.sql_text, sub.sql_id, sub.ELAPSED_TIME PER_EXEC_ELAPSED_TIME_MINUTES FROM DBA_HIST_SQLTEXT st, ( SELECT t.sql_id, ROUND ( SUM (t.elapsed_time_delta /…
Read MoreFind undo blocks and connect by SQL_ID
Provided script will find out the UNDO tablespace blocks usage to the corresponding SQL ID which you will provide. select dhs.sql_id, round(sum((vu.activeblks*8)/1024)) ActiveUNDOMB, round(max((vu.unexpiredblks*8)/1024)) UnexpiredUNDOMB ,max(vu.tuned_undoretention)TunedUndo, max(vu.begin_time)newest_time from v$undostat vu…
Read MoreTo find Multiple Hash Plans for SQLID
This Query will provide much information about the multiple hash plans… select SQL_ID , PLAN_HASH_VALUE , sum(EXECUTIONS_DELTA) EXECUTIONS , sum(ROWS_PROCESSED_DELTA) CROWS , trunc(sum(CPU_TIME_DELTA)/1000000/60) CPU_MINS , trunc(sum(ELAPSED_TIME_DELTA)/1000000/60) ELA_MINS from DBA_HIST_SQLSTAT S,…
Read Moreclrg comand for Oracle Apps DBA in Oracle SuperCluster Environment
Hi All, In Oracle SuperCluster Environment we use important command ‘clrg’ for stopping and Starting of Oracle Web tier and Concurrent Manager Services. clrg stands for clresourcegroup, which assist us…
Read MoreOracle E-Business Suite R12 Applications Certification
Brief about exam: There were 75 Questions and 90 minutes(1 hour 30 minutes) was alloted to complete this exam. We can complete this exam within 1 hour 15 mins after…
Read More