How to get Query response Time?

[Former Member]

II am on BI 7.0. I ran some queries using RSRT command. I want to find how much time the queries took.

I went to

st03 -> expert mode -

---

> BI system load-> select today / week/month according to the query runtime day

I do not see any Info Providers. Query was on a cube so why no Info Providers.

Does something have to turned on InfoPorvider to show.

When I look in RSDDSTAT_OLAP table, I do see many rows but cannot make any sense. Is there some documentation on how to get total query time from this table?

Is there any other way to get query response time?

Thanks a lot.

[markus_doehr2 · Accepted solution]

A (very technical) view can be done by using ST05 (SQL Trace). There you would also see what SQL statements are executed and how much time they need.

Markus

[Former Member]

HI,

why not use RSRT ? You can add database statistics option in "Execut & Debug" and you get all the runtime metrics of your query

In transaction RSRT, enter the query name and press u2018Execute +Debugu2019.

Selecting u2018Display Statistics Datau2019 .

After executing the query will return a list of the measured metrics.

The event id / text describes the steps (duration in seconds):

"OLAP: Read data" gives the SQL statements repsonse time (ok - because the SAP

application server acts as an Oracle client a little network traffic from the db server is included,

but as far as you not transferring zillions of rows it can be ignored)

But it gives you much more (i.e. if the OLAP cache gets used or not )...

In the "Aggreagate statistcs" you get all the infoproviders involved in that query.

bye

yk

[Former Member]

Hi,

Check the Tcode - ora_perf in Database Admin mode.

drill down the menu Performance - > Wait analysis scrren.Execute the report and find out process hanged on which table.

Regards

S.Senthil Kumar

[anindya_bose]

Hi

You can check document attached in Note 935815 - Query analysis tool

[Former Member]

Hi,

STAD is good as written by stefan.One more other way that you can get Query Execution time

by database level.

select ELAPSED_TIME from v$sql where sql_id='SQL_ID'>

SurendraJain

[stefan_koehler]

Hello,

Markus suggestion is for the database itself and would work if you don't use a BIA.

You can also use the transaction STAD for performance analysis. The advantage of this transaction is that you also see the time that is lost by BIA RFC calls. You can also extend the detailed statistics (rows returned by tables, etc.) and take a closer look at it with STAD.

Regards

Stefan