Home > Default > Sql trace

Sql trace

October 11Hits:0
Advertisement
Hi All,
I am new to this ABAP field..
I know how to do SQL trace ....But what I am not getting is " <b>HOW CAN WE TELL FROM THE OUTPUT OF SQL TRACE, THAT THIS IS THE CAUSE OF SLOW PERFORMANCE OF A REPORT</b>" Based on what are we determining the performance?
Can Anybody help me here pls?............
Kelly

Answers

Hi Kelly,
if you really have no idea, why a report is slow, then you have to start with SE30 (runtime analysis).
There are three bargraphs: ABAP / database / system.
System should be more or less nothing.
If ABAP is bigger than database: have a look at slow abap-statements (normally operations with internal tables: read, delete, loop where,...); classic reason: to much reads without binary search / sorted table / hashed table use.
If database is bigger than ABAP: have a look at your SQL statements. If you can see already forgotten key fields, fine - otherwise SQL trace will bring help in analyzing.
A SQL trace itself says nothing about overall performance (which is done by runtime analysis), only about database part. But 'normally' programmers have their ABAP-part in control and struggle only with slow selects: that's the reason, why often SQL trace is used immediately.
I hope, this brings a little bit light in your question,
regards,
Christian

Read other 5 answers

Tags:

Related Articles

  • In SQL Trace how to see which statement getting more time .October 11

    Hi Expart, In SQL Trace (T-code ST05) . I am running the standard transaction . how to see which statement running more time and less time . suppose one statement running more time so how resolve the performance . Plz. reply me Regards Razz> The ones

  • Sql traceOctober 11

    Hi All, I am new to this ABAP field.. I know how to do SQL trace ....But what I am not getting is " <b>HOW CAN WE TELL FROM THE OUTPUT OF SQL TRACE, THAT THIS IS THE CAUSE OF SLOW PERFORMANCE OF A REPORT</b>" Based on what are we det

  • Create sql trace files on client machineOctober 11

    Hi oracle creates sql trace files on server side, what are possible and best ways of sharing those files with end users? is it possible to create them on client side instead?Dbb wrote: Hi Hi oracle creates sql trace files on server side, Yes what are

  • How to look at the SQL trace in OracleOctober 11

    Hi, How do we look for the SQL trace in Oracle? With SQL trace I mean all the SQL statements being executed in Oracle database ( including select ). Thanks........Thanks for a quick reply nbellam. I wonder if there is a way to find out the date and t

  • Analysing details of SQL trace and runtime analysis for a report.October 11

    Hi, I am trying to tune the performance of a Z ABAP report for target group export. A brief overview of what is done in the report is the retrieval of BP details present in the Target group including BP general, address, marketing attributes, person

  • Unable to generate SQL trace file on a 10.2.0.1.0 databaseOctober 11

    Hello, I am unable to generate SQL trace files on a 10.2.0.1.0 database (OS is Win2003 server 64 bits). First I tried the way I used to do it on older databases (8i and 9i) : execute dbms_system.set_sql_trace_in_session(sid, serial#, true); I got no

  • What is SQL Trace and How to Use it .October 11

    Dear Experts . 1.) May You Please tell me What is the Purpose of SQL-Trace and How to use it ? 2.) What is purpose of T-codes SE30 and ST22 ? Please it is urgent ... Regards :  RajneeshHi SQL Trace transaction ST05: The trace list has many lines that

  • Can I set up SQL Trace or Audit to connect to serversOctober 11

    I have a server (2003) with SQL (2005) on it.  If i install MS SQL Management Studio 2012 on my PC, can I audit what SQL on that server is doing by connecting to it from the PC ? Or would it be better to set up SQL Trace on the server itself ? Thanks

  • Finding SQL trace and Log trace in SAP MEOctober 11

    Dear Experts, I am new to SAP ME SDK 2.0  development. After depolying the ME with changes.If an error occurs as "An internal error occurred; contact technical support". Where should I check for the traces like SQL trace or og trace. Thanks in a

  • How to set SQL trace in OCI session ?October 11

    Hello, In a SQL*Plus session, I can use the SQL statement "alter session set sql_trace=true;" to set SQL trace in that session only. I assume I could execute the same SQL statement from C code in an OCI client and achieve the same goal. However,

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.667 s.