Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OBIEE 12c Usage tracking

Received Response
41
Views
6
Comments
Hesh
Hesh Rank 5 - Community Champion
edited Aug 13, 2024 5:29PM in Oracle Analytics Forum

Hi,

OBIEE 12C version - 12.2.1.4.0

There is a column TOTAL_TEMP_KB in usage tracking table(S_NQ_ACCT) showing in negative ! not sure what does that mean? the number is quite high!

Can someone help me to understand this?

TOTAL_TEMP_KB

-739411654

-740259871

Regards

Hesh

Answers

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    It's a column that has been added in 12c. It is the total temp space used by a query during its execution.

  • Hesh
    Hesh Rank 5 - Community Champion

    Thanks Joel,

    What I am not able to understand is how can that value can be a negative(-) value for that column? how can I interpret that ?

    I can understand if something 5000 KB, but not sure what does -5000 KB? is that something like it was using Disk memory instead of RAM memory for processing?

    Regards

    Hesh

  • Hesh
    Hesh Rank 5 - Community Champion

    Hi,

    Can someone please help me with this? how can I understand the negative number of TOTAL_TEMP_KB in usage tracking table(S_NQ_ACCT) ?

    I found following numbers which looks very huge and I believe this is impacting the performance of the system! any docs we have to refer about this more?

    -687312572

    -687313848

    -691213346

    Regards

    Hesh

  • Hesh
    Hesh Rank 5 - Community Champion

    This is what I can interpret for minus( -) , the processing still requires that amount of memory and that is not available!

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    Can you allocate more resources to the server and see if you still get these negative numbers? Have you tried to get to the root cause of what is triggering this? Do you have some very large analyses/exports that are running on your system?

  • Hesh
    Hesh Rank 5 - Community Champion

    Thanks Joel,

    That is one report is part of a Dashboard.. that is an overview page users will leave it open on the desktops without knowing that it is actually running code to try and create the chart.

    The starting hour and ending Hour in usage tracking shows it runs for 30 min .. and Error Message shows following .. time out.

    I strongly believe this is causing slowdown of other reports performance. 

    "[nQSError: 60009] The user request exceeded the maximum query governing execution time.

    [nQSError: 17001] Oracle Error code: 1013, message: ORA-01013: user requested cancel of current operation

    at OCI call OCIStmtFetch."

    Regards

    Hesh