Check the hidden setting in Oracle.

• Explanation:
  • ksppinm: This is the name of the hidden parameter you’re querying.
  • ksppstvl: This shows the hidden parameter value you want to check.

SET PAGESIZE 50;
SET LINESIZE 150;
COL ParameterName FORMAT A40 
COL ParameterValue  FORMAT A40 
SELECT 
  ksppinm as ParameterName, 
  ksppstvl as ParameterValue 
FROM 
  x$ksppi a, 
  x$ksppsv b 
WHERE 
  a.indx = b.indx 
  AND ksppinm = '_optimizer_gather_stats_on_load';

Example:

 SELECT
   ksppinm,
   ksppstvl
  FROM
  x$ksppi a,
  x$ksppsv b
  WHERE
  a.indx = b.indx
   AND ksppinm = '_optimizer_gather_stats_on_load';

             Parameter Name                Parameter Value
--------------------------------    ------------------------------------------
_optimizer_gather_stats_on_load          TRUE

Hidden parameters control advanced features of the database and are usually not shown to users, as changing them can affect system performance or stability. However, you may need to look at these parameters when debugging performance problems, troubleshooting, or adjusting database features.