OBIEE 12c page switch taking time — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c page switch taking time

Received Response
21
Views
4
Comments
sandy45252
sandy45252 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:01PM in Oracle Analytics Cloud and Server

Hi All,

We have installed obiee 12.2.1.2 version on linux version 6. Deployed everything proper but when after login when we switch from page to other or from results to criteria or from one page to another its taking time.

Performace of page refresh is not good, so when we checked the sawserver log found below warnings.

2017-05-22T06:05:29Z] [OBIPS] [WARNING:16] [] [saw.meminfo.threadpool.asynclogon] [ecid: 005K1QcCKdx7EC2_Rpt1id0001N500005^,0] [tid: 4215371520] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] ThreadPool<AsyncLogon:1>: Memory usage log - Allocs: 437649, Net: 77300; Bytes Alloc'd: 360332540, Net: 194011808; System Bytes: 167772160, Net: 167772160; Peak-Bytes: 236008521.[[

File:threadpool.cpp

Line:1021

Location:

  saw.meminfo.threadpool.asynclogon

  saw.threadpool.asynclogon

  saw.threads

]]

[2017-05-22T06:10:58Z] [OBIPS] [WARNING:16] [] [saw.odbc.statement.execute.timings] [ecid: 4ac707eb-c4b7-4a96-b3e3-966330e531d1-00000230,0:1:152] [tid: 2817337088] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] SQLExecDirectW returned in 289807 msec(s).[[

File:odbcstatementimpl.cpp

Line:160

Location:

  saw.odbc.statement.execute.timings

  saw.odbc.statement.execute

  saw.queryCache.odbcExecuter.execute

  saw.querycache.executeQuery

  saw.threadpool.query

  saw.threads

ConnId: 1

StmtId: 29

Please help to know what are this warnings indicate and how can we eliminate it.

Thanks,

Sandeep

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Do you have Direct SQL requests going on?

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Check below document is this something similar to your issue

    Switching Dashboards In OBIEE 11g (11.1.1.9.0) Fails To Display | Hangs | Load Until The Original Dashboard Is Rendered (Doc ID 2075808.1)

    The document states 11.1.1.9.0 but the Bug for this issue is said to be fixed in 12.2.2.0.0, so not sure if fix for this bug has been already included in 12.2.1.2.0

    Check with Oracle Support on same whether Patch is available for this issue on top of 12.2.1.2.0, if this is not similar to your issue then you need capture fiddler trace(a free web debugging proxy which logs all HTTP(s) traffic between your computer and the Internet. Use it to debug traffic from virtually any application that supports a proxy like IE, Chrome, Safari, Firefox, Opera and more) for further diagnosis of issue

  • sandy45252
    sandy45252 Rank 3 - Community Apprentice

    We are not using any Direct Database requests in reports or Dashboards.

  • 3310714
    3310714 Rank 6 - Analytics Lead

    Hi,

    I think OBIEE logs all sorts of warnings/errors even when no one is using the system.  So it might not be the warning for your issue.  You said things are slow, could it because the query takes a long time to run?  Are you able to run the query against the DB to see how long that takes?