Oracle Communities

Oracle Analytics and AI

Child Item

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

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)

Find more posts tagged with

Accepted answers

All comments

EzequielC-Oracle

Hi,

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

https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-9F8FCB4B-EA17-4302-813A-BEF84F295A6A.htm#GUID-9574337B-2A9C-4A00-AFA6-01CB5F209E96

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

https://community.oracle.com/products/oracleanalytics/discussion/5798/obiee-12c-usage-tracking

Regards,

Ezequiel.

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