THE Wiki

User Tools

Site Tools

Trace: • python
oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
oracle [2026/08/17 08:17] – [EMCC] mduerschoracle [2026/09/11 07:22] (current) – [Environement] mduersch
Line 38: Line 38:
   9- EM OMS main log file for the OMS pbs (empbs) application. (emoms_pbs.log)   9- EM OMS main log file for the OMS pbs (empbs) application. (emoms_pbs.log)
   10- EM OMS main trace file for the OMS pbs (empbs) application. (emoms_pbs.tc)   10- EM OMS main trace file for the OMS pbs (empbs) application. (emoms_pbs.tc)
 +
 +Promoted Discovered Error und emcli
 +
 +  SQL> connect / as sysdba
 +  SQL> show parameter job_queue_processes;  --->Verify the current value of job queue process.
 +  SQL> alter system set job_queue_processes = 0; (Note: Please track the existing value before making it to 0)
 +  SQL> connect sysman/
 +  SQL> exec emd_maintenance.remove_em_dbms_jobs;
 +  SQL>exec gc_interval_partition_mgr.partition_maintenance; 
 +  SQL> connect / as sysdba
 +  SQL> alter system set job_queue_processes = 300; (Note: Set the value which was verified before making it to 0)
 +  SQL> connect sysman/
 +  SQL> exec emd_maintenance.submit_em_dbms_jobs;
 +  SQL> commit;
 +
 +
  
 ==== CDB PDB ==== ==== CDB PDB ====
Line 626: Line 642:
    V$SESSION - This gives detailed session information about all connected Oracle users.    V$SESSION - This gives detailed session information about all connected Oracle users.
    V$SESSION_EVENT - This is used to show the number of session waits and session timeouts.    V$SESSION_EVENT - This is used to show the number of session waits and session timeouts.
- 
  
    SELECT username, elapsed_time, plsql_exec_time, sql_text, cpu_time, rm_last_action, rm_last_action_reason, rm_last_action_time, rm_consumer_group FROM v$sql_monitor WHERE username is not null;    SELECT username, elapsed_time, plsql_exec_time, sql_text, cpu_time, rm_last_action, rm_last_action_reason, rm_last_action_time, rm_consumer_group FROM v$sql_monitor WHERE username is not null;
 +
 +==== Long running Statements v$session_longops ====
 +  
 +  col opname for a20
 +  col username for a20
 +  col prozent for clear 
 +  col time_remaining for clear 
 +
 +  SELECT opname, username, 
 +     to_char(start_time,'DD-MON-YYYY HH24:MI:SS'),
 +     (sofar/totalwork)*100 prozent, time_remaining 
 +     FROM v$session_longops
 +     WHERE time_remaining>0;
 +  
 +
 ==== RESSOURCES ==== ==== RESSOURCES ====
  
Line 757: Line 787:
   select PATCH_ID, PATCH_UID, STATUS, ACTION_TIME, DESCRIPTION from DBA_REGISTRY_SQLPATCH;   select PATCH_ID, PATCH_UID, STATUS, ACTION_TIME, DESCRIPTION from DBA_REGISTRY_SQLPATCH;
  
 +  ./datapatch -purge_old_metadata
 +  https://mikedietrichde.com/2025/02/28/final-blog-post-about-datapatch-cleanup-and-purge/ 
 +  
  
 ====== ORACLE 11G ====== ====== ORACLE 11G ======
oracle.1786954632.txt.gz · Last modified: by mduersch