SAP Knowledge Base Article - Preview

3366693 - ORA-41010: No more memory to hold connection state information

Symptom

BR0301E SQL error -41010 at location BrSegListGet-3, SQL statement: 'OPEN curs_84 CURSOR FOR'
'SELECT OWNER, SEGMENT_NAME, NVL(PARTITION_NAME, ''), SEGMENT_TYPE, TABLESPACE_NAME, NVL (BYTES, 0), NVL (EXTENTS, 0), NVL (IN ITIAL_EXTENT, 0), NVL (NEXT_EXTENT, 0), NVL (MAX_EXTENTS, 0), NVL(PCT_INCREASE, 0) FROM DBA_SEGMENTS WHERE OWNER LIKE '' AND SEGMENT_NAME LIKE '' AND SEGMENT_NAME NOT LIKE 'BINS' ORDER BY OWNER, SEGMENT_NAME, PARTITION_NAME, SEGMENT_TYPE' 
ORA-41010: No more memory to hold connection state information
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 171


Read more...

Environment

  • Oracle 19c
  • Any OS platform

Keywords

ora-41010 job limit reached brtools brbackup brconnect br*tools failing  , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.