DECLARE libcac number(10,2); rowcac number(10,2); bufcac number(10,2); redlog number(10,2); spsize number; blkbuf number; logbuf number; BEGIN select value into redlog from v$sysstat where name = ‘redo log space requests’; select…
Read MoreCopying Control File to Other locations Just a couple of notes on how to create multiple ASM control files and moving control files to a different diskgroup. Assuming we already…
Read MoreHow to access HTTPS/SSL URL via utl_http using the orapki wallet command Goal: Our goal is to call/access the HTTPS/SSL url from within PL/SQL The instruction provided here should also work for accessing…
Read MoreInstall and Configure Oracle APEX with ORDS and Apache Tomcat Introduction: In this post, we will discuss about the step by step procedure to install Oracle Application express 19.2 with…
Read MoreDBMS_SCHEDULER in Oracle Database Scheduler in the Oracle Database is done by DBMS_SCHEDULER package. This package can be used to create different types of jobs :- 1. Jobs having Program…
Read MoreOEM CONTROL COMMANDS: ===================== Stop/start and status oms in cloud control =============================== cd $ORACLE_HOME/bin emctl stop oms emctl start oms emctl status oms stop/start agent in oem cloud control =====================================…
Read MoreViewing an Alert Log from ADRCI ================================ You want to view an alert log by using ADRCI commands. To view an alert log with ADRCI, follow these steps: Invoke ADRCI.…
Read MoreFinding What’s Consuming the Most Undo ======================================= Use the following query to find out which SQL statement has run for the longest time in your database. SQL> select s.sql_text from…
Read MoreDetermining the Optimal Undo Retention Period ============================================== You need to determine the optimal length of time for undo retention in your database. Solution You can specify the length of time…
Read MoreTo obtain the current patchset levels for each specific E-Business Suite functional product test the following steps: 1. Log into OAM. (Responsibility System Administrator,”Oracle Applications Manager”, menu “OAM Support Cart”)…
Read More