To check the waits stats
column object_name format a20 column owner format a20 column object_type format a20 column sample_time format a27 column sql_text format a50 set ver off prompt Histogram of Buffer Busy Wait select…
Read MoreTo get the SGA statistics
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 MoreManaging control files in ASM
Copying 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
How 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
Install 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
DBMS_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
OEM 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
Viewing 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
Finding 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
Determining 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 More