My Oracle Support Banner

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

Last updated on JUNE 12, 2023

Applies to:

Oracle WebCenter Sites - Version 7.6.0 and later
Information in this document applies to any platform.


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.


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

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