As usual, as soon as I apply the newest RU, I do also a quick check for New parameters and defaults in Oracle Database 19.11.0.
Photo by Roma Kaiuk on Unsplash
New Parameters in Oracle 19.11.0
Based on customer feedback, there is one really big improvement since this RU release. Not only new features but also parameter changes get listed. You will find them in the 19c New Features Guide.
In this RU you will find only 1 new parameter:
- drcp_dedicated_opt
The description says “Turn on/off dedicated optimization for DRCP” – and the default is “YES“.
If you’d like to learn more about Database Resident Connection Pooling, then please see the Administrator Guide 19c.
New Underscore Parameters in Oracle 19.11.0
I found 27 new underscore parameters in 19.11.0. Most of them are tied to an actual bug which is reflected in their name starting with _bug_ as well. I won’t list them here but there are queries available to find out more in case you are interested.
New Features in Oracle 19.11.0
As you know, since 19.10.0 there are occasional new features included in RUs as well. You will find a list in the 19c New Features Guide:
- Application Continuity Protection Check
- Immutable Tables
- Be aware that this feature will require COMPATIBLE=19.11.0 or higher – which we don’t recommend to alter unless you really want to use this feature. You may want to check this blog post about 19.10.0 and Blockchain Tables in addition.
- Oracle SODA for C APIs Enhancements
Further Links and Information
- drcp_dedicated_opt in the Oracle Database Server 21c Reference
- New Features Guide Oracle 19c – 19.11.0
- Administrator Guide Oracle 19c – Database Resident Connection Pooling
- Oracle 19.10.0 and Blockchain Tables
–Mike
can we leave compatible value to default
YES YES YES — please leave COMPATIBLE at the default, 19.0.0 – this is why I linked my COMPATIBLE blog post where I explain this in more detail. NEVER change COMPATIBLE for an RU (with the addition now: unless you want this specific feature NOW).
Cheers,
Mike
“please leave COMPATIBLE at the default, 19.1.0” – this is a little bit misleading.
I think you meant “19.0.0” and not “19.1.0” in your comment.
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/COMPATIBLE.html
Thanks, Martin
You are right, Martin – I changed it. Sorry for the confusion 😉
Cheers,
Mike
Hi Mike,
Can you please provide the query to see parameter changes from 19.10 to 19.11? I have a client with a query which has dramatically dropped in performance after applying RU 19.11 and I checking if there is any new parameter which might have an impact.
Thank you,
Cezar
Sure thing …
You’ll have to adjust the scripts a bit – but we will release an app soon for every customer containing much more than that 🙂
----------------------- Regular Parameters
---------------------
set echo off lines 300 pages 9999 feed off
ttitle off
btitle off
set heading off
spool params_1950.csv
prompt PARAMETER;VALUE;DESCRIPTION;RELEASE;PARAMTYPE;;
SELECT
a.ksppinm || ';' ||
c.ksppstdvl || ';"' ||
a.ksppdesc || '";19.5.0;P;'
FROM
x$ksppi a ,
x$ksppsv c
WHERE
a.indx = c.indx AND
a.ksppinm NOT LIKE '/_%' escape '/'
ORDER BY
1
/
spool off
-------------------------------------
-- End Regular Parameters
-------------------------------------
------------------------
-- Underscore Parameters
-- Manual correction:
-- Remove semicolon => _nologging_mode_override
-- Edit:
-- _olap_allocate_errorlog_header
------------------------
set echo off lines 300 pages 9999 feed off
ttitle off
btitle off
set heading off
spool underscoreparms_1950.csv
prompt PARAMETER;VALUE;DESCRIPTION;RELEASE;PARAMTYPE;;
SELECT
'€' || a.ksppinm || '€;€' ||
c.ksppstdvl || '€;€' ||
a.ksppdesc || '€;19.5.0;U;'
FROM
x$ksppi a ,
x$ksppsv c
WHERE
a.indx = c.indx AND
a.ksppinm LIKE '/_%' escape '/' AND
a.ksppinm not like '/_/_%' escape '/'
ORDER BY
1
/
spool off
----------------------------------------
-- End Underscore Parameters
----------------------------------------