Huge Number of Sessions Hit ORA-4022 (Doc ID 2760872.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• 19.8.0.0.0 version, RDBMS lots of server process suffering from ORA-4022:
  
  Mon Feb 22 10:27:14 2021
  opidcl aborting process unknown ospid (5635) as a result of ORA-4022
  Mon Feb 22 10:27:15 2021
  opidcl aborting process unknown ospid (24422) as a result of ORA-4022
  Mon Feb 22 10:27:15 2021
  opidcl aborting process unknown ospid (7692) as a result of ORA-4022
  ...<>...
   
• There are no remarkable performance degradation factors or waiting events
• hanganalyze dump shows its wait chain mostly like this:
  Oracle session identified by:
  {
  ......
  }
  is waiting for 'library cache: mutex X' with wait info:
  {
  p1: 'idn'=0x4050d3fd
  p2: 'value'=0x457d00000000
  p3: 'where'=0x7f006f
  time in wait: 0.436336 sec
  timeout after: never
  wait id: 12
  blocking: 0 sessions
  current sql_id: 0
  current sql: <none>
  short stack: ksedsts()+976<-ksdxfstk()+44<-ksdxcb()+2112<-sspuser()+400<-__sighndlr()+12<-call_user_handler()+852<-sigacthandler()+84<-_portfs()+8<-port_get()+28<-sskgpwwait()+188<-skgpwwait()+192<-ksliwat()+1900<-kslwaitctx()+156<-kgxWait()+1260<-kgxExclusive()+424<-kglGetMutex()+148<-kgllkdl()+416<-kglUnLock()+240<-kziarlslt()+252<-kpolnb()+4524<-kpoauth()+912<-opiodr()+1096<-ttcpip()+1072<-opitsk()+2096<-opiino()+924<-opiodr()+1096<-opidrv()+904<-sou2o()+136<-opimai_real()+300<-ssthrdmain()+488<-main()+316<-_start()+272
  wait history:
  * time between current wait and wait #1: 0.000000 sec
  1. event: 'library cache load lock'
  time waited: 0.000026 sec (last interval)
  time waited: 1 min 52 sec (total)
  wait id: 10 p1: 'object address'=0xa3e5e8d30
  p2: 'lock address'=0x642e76790
  p3: '100*mask+namespace'=0x7f0003
  * time between wait #1 and #2: 0.000000 sec
  2. event: 'library cache: mutex X'
  time waited: 1 min 17 sec
  wait id: 11 p1: 'idn'=0x4050d3fd
  p2: 'value'=0x5ebb00000000
  p3: 'where'=0x7f006f
  * time between wait #2 and #3: 0.000000 sec
  3. event: 'library cache load lock'
  time waited: 35.101373 sec
  wait id: 10 p1: 'object address'=0xa3e5e8d30
  p2: 'lock address'=0x642e76790
   

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.