Pages

Tuesday, December 1, 2015

Background process SMCO

============================
SMCO background process
============================
In an event of "disk space full 100%", there is an error related to SMCO background process in Oracle alert.log.
SMCO stands for: Space Management Coordinator Process

============================
Background process SMCO Reference
============================


Per Oracle Documentation Background Processes
SMCO - Space Management Coordinator Process:
- Coordinates the execution of various space management tasks
- SMON performs many database maintenance tasks, including the following:
- Creates and manages the temporary tablespace metadata
- Reclaims space used by orphaned temporary segment
- Maintains the undo tablespace.
- Cleans up the data dictionary when it is in a transient and inconsistent state
- Maintains the SCN to time mapping table used to support Oracle Flashback features
============================
Following is from Oracle alert.log:
============================
Thu Nov 05 06:30:10 2015
DW01 started with pid=75, OS id=782, wid=1, job SHDAEMON.SYS_EXPORT_FULL_01
Thu Nov 05 06:35:30 2015
Thread 1 advanced to log sequence 170306 (LGWR switch)
  Current log# 2 seq# 170306 mem# 0: /oracle_db/db1/db_igt/ora_redo_02_a.rdo
Thu Nov 05 06:35:32 2015
Archived Log entry 170294 added for thread 1 sequence 170305 ID 0x36162634 dest 1:
Thu Nov 05 06:53:47 2015
Stopping background process SMCO
Stopping background process FBDA
Shutting down instance: further logons disabled
Stopping background process QMNC
Thu Nov 05 06:53:57 2015
Stopping background process MMNL
Stopping background process MMON
Shutting down instance (immediate)
License high water mark = 233
Thu Nov 05 06:58:58 2015
Active call for process 14073 user 'oracle' program 'oracle@mex-tel-1-aps-2'
Active call for process 782 user 'oracle' program 'oracle@mex-tel-1-aps-2 (DW01)'
SHUTDOWN: waiting for active calls to complete.

No comments:

Post a Comment