> > Daniel Castro wrote: > > > > > Hi, > > > > > > I am using sapdb 7.4 > > > Is there any way to do a SQL Query Monitoring. > > > I want to see the queries which are doing a tabls scan. > > > I dont have the system source code. > > > It is not a SAP ERP. > > > > > > Best regards, > > > > > > > Hi, > > > > you could enable diagnose monitor feature with the command "diagnose > > monitor read 0" > > executed from SQL Studio or any other tool. > > > > Than all commands will be written into the system table SYSPARSEID > > and their resource consumption will be written into SYSMONITOR. > > > > With the join > > > > select /*+ordered */ substr(sql_statement,1,2000) > > from sysmonitor sm, sysparseid sp > > where sm.parseid = sp.parseid > > > > you will get some information about the execution of the statements. > > Statements which are doing a table scan have the word SCAN > in the column > > STRATEGY. > > But you should keep in mind that not all scans are bad. > > If the table is small enough a scan may be the best access strategy. > > > > The table SYSMONITOR only keeps a certain amount of rows. > > You could adjust the amount with the command "diagnose monitor rowno > > <uint>". > > > > Kind regards > > Holger > > > > Holger, > > Thank you very much. > > I wrote: > select /*+ordered */ substr(sql_statement,1,2000), strategy > from sysmonitor sm, sysparseid sp > where sm.parseid = sp.parseid and > strategy = 'SCAN' > > TO discover who is doing a SCAN. > > For example, I got: > > SELECT COUNT ( *) FROM HON WHERE ( HON_GMR_COD IS NULL ) OR ( > HON_EMP_COD IS > NULL ) OR ( HON_PSV_SOLIC IS NULL ) OR ( HON_CTF_CATEG IS NULL ) OR ( > HON_PSV_SOLIC IS NULL ) OR ( HON_IH_ORIGEM IS NULL ) > > The Explain returns: > DBA HON TABLE SCAN 1 > DBA RESULT IS COPIED , COSTVALUE IS 3 > > What does it mean? (It is a newbie question, I know...) >
Hi, the explain output shows how the statement is executed. In your case a table scan on the table HON is done and because of the aggregation a result set is physically created. The expected page I/O for this execution plan is 3 pages. For more information about the explain command have a look here http://maxdb.sap.com/currentdoc/da/ed9036dfe4b903e10000009b38f889/frameset.htm Kind regards Holger Holger Becker MaxDB&liveCache SAP AG www.sap.com Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
