My Oracle Support Banner

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

Last updated on AUGUST 18, 2020

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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