Regardirng some metrics (in logs and usage tracking) in OBIEE 12.2.1.4

DENISKA80 · March 2024

Hi there. I'm trying to understand 2 metrics

? bytes XXX retrieved from database query (obis1-query.log)

? TOTAL_TEMP_KB from table S_NQ_ACCT

Two examples

1

query from v$sesstat st,v$session ss ,v$statname n with n.name ='bytes sent via SQL*Net to client' IS 75MB

dowloaded csv file from bi with this data IS 62MB

bytes retrieved from database query IS 55GB

TOTAL_TEMP_KB IS 12000

2

query from v$sesstat st,v$session ss ,v$statname n with n.name ='bytes sent via SQL*Net to client' IS 6MB

dowloaded csv file from bi with this data IS 5.2MB

bytes retrieved from database query IS 3.5GB

TOTAL_TEMP_KB IS 0

So i really dont understand what means bytes XXX retrieved from database query and TOTAL_TEMP_KB from table S_NQ_ACCT

Please explain me

I request data in plain tables (no aggregates, pivot or smth like that)

EzequielC-Oracle · March 2024

Hi,

Here is the documentation with the description of the Usage Tracking Data. However, that column is not listed:

Maybe this old post where that column is discussed can be of help:

Regards,

Ezequiel.

DENISKA80 · March 2024

I have found no helpful info

There are some descriptions

-Total temp space used by a query during execution of report.

Total temp size used on DB side? Total temp size used in BI side? What for used?

-Specifies the total KB received for a query. Data type is Number(10).

received by whom? what was sent?

Because I see real

data transferred from DB to BI via SQL NET (75MB and 6MB)

size of plain text file (62mb and 5.2mb)

And i get(12 and 0) TOTAL_TEMP_KB

Oracle Analytics Cloud and Server