RMAN> delete obsolete; the following error occurs: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of delete command at 18/01/2021 22:04:21 RMAN-06091: no channel allocated…
Read Morecolumn sid_serial format A12 heading “Sid-Serial” column tablespace format a15 heading ‘TBS Name’ column spid format 9,999 heading ‘Unix ID’ column segblk# format 999,999,999 heading ‘Block ID’ column size_mb format…
Read Morecol NAME format a15 col TABLESPACE_NAME format a10 col Programme format a20 col machine format a30 SELECT a.usn, e.sid, e.serial#, e.username, e.program, e.machine, e.osuser, a.name, b.status, c.tablespace_name, d.addr FROM v$rollname…
Read MoreSELECT owner_name ,job_name ,operation ,job_mode ,state ,degree ,attached_sessions FROM dba_datapump_jobs; To get the constraints list: #set linesize 1000 #set verify off #set pagesize 40 #break on owner on table_name on…
Read Morecolumn 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 MoreDECLARE 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 More