SQL> select count(*),status from wf_notifications group by status; COUNT(*) STATUS ———- ——– 1530 CANCELED 1627 CLOSED 15266 OPEN SQL> select count(*),status, MAIL_STATUS from wf_notifications group by 2 status, MAIL_STATUS order by status; COUNT(*) STATUS…
Read MoreAlert Log File location: $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log Trace file location: $ORACLE_HOME/admin/SID_Hostname/udump Application Tier Logs Start/Stop script log files location: $COMMON_TOP/admin/log/CONTEXT_NAME/ OPMN log file location $ORACLE_HOME/opmn/logs/ipm.log Apache, Jserv, JVM log files locations: $IAS_ORACLE_HOME/Apache/Apache/logs/ssl_engine_log…
Read MoreIf this error is coming in Oracle database, then take downtime and do the following: Drop the queue table – exec dbms_aqadm.drop_queue_table( queue_table=>’SYS.SYS$SERVICE_METRICS_TAB’, force => TRUE) select object_name, object_type from…
Read MoreRMAN> 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 More