Skip to Content
avatar image
Former Member

How to get Query response Time?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Jun 26, 2009 at 01:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 26, 2009 at 01:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 26, 2009 at 02:44 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 26, 2009 at 10:25 PM

    Hi

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 28, 2009 at 04:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 29, 2009 at 08:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded