Solved: No DP Slot available to create server, tracefile - 19c

Greetings oraGuru's

No additional errors were appearing in the alert log, just this message thousands of times.

I just wanted to let you all know, the resolution to this was to set 'optimizer_adaptive_plans' to false.

BTW this was indeed 19.9.

Thanks
Doug

On Thu, Sep 23, 2021 at 5:19 AM Ghassan Salem <salem.ghassan_at_gmail.com> wrote:

> Douglas,
> Is there any other error signaled in the alert.log just before these
> messages?
>
> On Wed, Sep 22, 2021 at 11:16 PM Douglas Dunyan <dmdunyan_at_gmail.com>
> wrote:
>
>> Greets oraGuru's
>>
>> In a 19c RAC database, the alert log file is filling with the following
>> messages many many many times:
>>
>> "No DP Slot available to create server, tracefile
>> /{$oracle_base}/diag/rdbms/{dbname}/{instance}/trace/{INSTANCE}_pxmn_{pid}.trc
>> "
>>
>> Min parallel servers is set to 2, max parallel servers set to 8. The
>> tracefile for the parallel execution monitor shows:
>>
>> Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
>> Version 19.9.0.0.0
>> Build label: RDBMS_19.9.0.0.0DBRU_LINUX.X64_200930
>>
>> ORACLE_HOME: /u01/ora19c_db
>> System name: Linux
>> Node name: {nodename}
>> Release: 4.18.0-240.el8.x86_64
>> Version: #1 SMP Wed Sep 23 05:13:10 EDT 2020
>> Machine: x86_64
>> Instance name: {INSTANCE_NAME}
>> Redo thread mounted by this instance: 1
>> Oracle process number: 45
>> Unix process pid: 390675, image: oracle_at_{nodename} (PXMN)
>>
>> *** 2021-09-14T07:59:58.564681-07:00 (CDB$ROOT(1))
>> *** SESSION ID:(13148.48277) 2021-09-14T07:59:58.564756-07:00
>> *** CLIENT ID:() 2021-09-14T07:59:58.564768-07:00
>> *** SERVICE NAME:(SYS$BACKGROUND) 2021-09-14T07:59:58.564777-07:00
>> *** MODULE NAME:() 2021-09-14T07:59:58.564786-07:00
>> *** ACTION NAME:() 2021-09-14T07:59:58.564793-07:00
>> *** CLIENT DRIVER:() 2021-09-14T07:59:58.564800-07:00
>> *** CONTAINER ID:(1) 2021-09-14T07:59:58.564808-07:00
>>
>> DP slot 0 flag is 0x18
>> DP slot 1 flag is 0x18
>> DP slot 2 flag is 0x18
>> DP slot 3 flag is 0x18
>> DP slot 4 flag is 0x18
>> DP slot 5 flag is 0x18
>> DP slot 6 flag is 0x18
>> DP slot 7 flag is 0x18
>>
>> I can find no information about what is a DP slot, and why this is
>> polluting my alert logs. I have checked ulimits for user oracle, as well
>> as cluvfy with no hints as to why this one RAC database is exhibiting this
>> behavior.
>>
>> Any hints on this would be greatly appreciated.
>>
>> TIA
>>
>> Doug
>>
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l