Strange Query When Starting App Server In a Cluster Environment (Doc ID 1533168.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

Adding a new cluster member to an existing clustered application, The below query is executed several times:
CPU CPU per Elapsd Old
 Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
  2628.43 2,636,002 0.00 30.8 3180.93 549,721,920 2553106702
Module: JDBC Thin Client
SELECT NULL AS table_cat, t.owner AS table_schem,
t.table_name AS table_name, t.column_name AS column_name,
  DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER'
, 3, 'LONG', -1, 'DATE', 91, 'RAW', -3, 'LONG RAW
', -4, 'BLOB', 2004, 'CLOB', 2005, 'BFILE', -13

Once the third node is online, cluster environment becomes unstable. Sometimes response times are fine but mostly very bad.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.