To avoid unexpected execution plan changes some people say that we must set DBMS_STATS estimate_percent should always be to 100. I would like to know if you agree with this ?

<u></u>table has two rows select id,value from IIO_SYSTEM_PARAMETER; 200 1027/1029/1000 199 1027/1029/1000 when I ran the below query, it is giving 7 records, instead of 3 records query1: SELECT REGEXP_SUBSTR(VALUE, '[^/]+', 1, LEVEL) DEST FROM

Hello, I work as a dba and get requests from developers to create tables which we often review and sometimes change for better design and/or implementation. One of the developers recently sent a request to create a table such as the following ; table_name:t1_relation Column_names...

How to activate the auto-index feature in Oracle 19c Enterprise Edition? To activate on PDB send me the error: BEGIN dbms_auto_index.configure('AUTO_INDEX_MODE','IMPLEMENT'); END; Informe de error - ORA-40216: función no soportada ORA-06512: en "SYS.DBMS_SYS_ERROR", línea 79 ORA-...

Hi Tom, First of all, I want to thank you for all the things which you have done and doing for Oracle community. It inspire me to learn more and more. Now my question is -- Is there any way by which we can hide the procedures and functions code so the user can only execute it but...