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

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Sites - Version 7.6.0 and later
Information in this document applies to any platform.
Checked for currency on 05/08/2014

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms