[ASM Process] Onnn 프로세스

프로세스: Onnn(ASM Connection Pool Process) : 메타데이터 작업을 위해 ASM 인스턴스와의 연결을 유지합니다.
온앤 슬레이브 프로세스는 온디맨드로 생성됩니다. 이러한 프로세스는 ASM 인스턴스와 통신합니다.

"o000"은 메타데이터 작업을 위해 ASM 인스턴스에 연결하기 위한 선택적인 백그라운드 프로세스이므로(자동으로 생성되고 종료됨)

일반적으로 너무 높지 않고 지속적으로 보고되면 무해합니다.
성능이 너무 높고 성능에 영향을 미친다고 생각하는 경우 오프 피크 시간 동안 이 프로세스를 중지하고 다시 생성할 수 있습니다.
이 프로세스를 삭제해도 데이터베이스 작업에 영향을 미치지 않습니다.

 

원본

The process: Onnn (ASM Connection Pool Process) : Maintains a connection to the ASM instance for metadata operations.
Onnn slave processes are spawned on demand. These processes communicate with the ASM instance.

since "o000" is an optional background process to connect to the ASM instance for metadata operations(it is spawned and terminated automatically)

Generally, if its not too high and continuously reported, its harmless.
If you think its too high and impacting Performance, then you may kill this process during the off peak hours and let it re-spawn.
Killing this process will not affect the database operations.

 

출처 : https://docs.oracle.com/cd/E11882_01/server.112/e40402/bgprocesses.htm#REFRN104

Background Processes

 

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=164350952625707&id=2248393.1&displayIndex=3&_afrWindowMode=0&_adf.ctrl-state=15bwzkytdk_200#aref_section21

https://login-ext.identity.oraclecloud.com/oauth2/v1/authorize?response_mode=form_post&response_type=id_token&scope=openid&IDCS_CG_ENC_VER=v2&state=ddjQH5Yh3G9AtuhZy29TtZUG5yFY1bfK3zZT9po2oJ4&nonce=TiYw32GQpFJTeowbV7eHm2GttpCWV5EeX8cCrC1LsUM&IDCS_IS_CLOUDGATE=true&X-HOST-IDENTIFIER-NAME=support.oracle.com&idcs_app_name=cb3a35b10af7484b9c706e5509a7961c&idcs_app_resource_url=https%3A%2F%2Fsupport.oracle.com%2Fepmos%2Ffaces%2FDocumentDisplay%3F_adf.ctrl-state%3D15bwzkytdk_200%26_afrLoop%3D164350952625707%26_afrWindowMode%3D0%26displayIndex%3D3%26id%3D2248393.1&client_id=b2ea4a3d18dc476aa20c8c0eee2de79d&IDCS_CG_ENC=true&enc=jsuOx6aYjG9yAgAAOAIAABAgOAIAAB4CAAAQAIzo3TGCsbBIh4DP2nHorqA5zjv_xNFBZHQY2Du2UumXhdc-Of4fUQvB7mDDCeuu-dicA-PBylvitvxu8Sfn8UQ2lGMvYh41POyziWcqxPQw-lJKtwjZ2tr7oG-GuklXrB0RSrI8tPMjDlVh3tPvCGyIwqz-gCZVuYSLlOu5EGAK5Wi29sA1j5mxPCuCYYlV7trMlzAXQOquMSo-yWcPaHUAjjBGSB5_KXZxs7CQiW7MqiCWF3fQhixIMV1_NHNCWSwqkpgkWKBzEeRN8WuvuU0YIVcezLEyaDxD9U2VGxu46X3Uo9bEbhiIOBuX7cMpK9GqFnscHpp9Z9PeSasXshVq2wtLmxYowG9sLrM72cjX1Wh6lRQkOxxi6ahyqT2S7WdoyfpjPZUB0JtG0gpsXnujhbn1k64jmlNCfAZyf8_l56rFXJx5wiLZ97IBIzMpT5leKTocnqpaCTQKei7_3sQh27BOuqpowDi5Z9Dml7dHKSACUYl_cU91fBVLbF9W8hq3oBob4EZrBmiyRTftCv5iFuvgY7ylN9V3zr4xh0HPPk0g63uKeK1WK4XOS2c-kObh5bCRKNLfG3fThYW6weSGIomaKA73mLG4pqVEZLX0zUmiMgNoOlat6-hPWxJPWDGYSRugfyUNB0QkA8tcibQ4NyNe3EXCcoBRjYM3JVVsL7IDfKRo1605HHFyTu1OS_2o_FHtFS9NnYghnpuAJgwem6bnLGszKIExO38gLT-Knm1Nw4D9NiKWnJMvKUvFlS5tS2h2Nykhpo66eZLvPa6UOzsV32lemk5mplNLYQ

출처 : Top 5 Database Hang Issues due to ASM (Doc ID 2248393.1)