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@xxxxxxxxx>
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@xxxxxxxxx>
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@{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
