Every product has its quirks and statement 0 is one of DBmarlin’s. In this article we will look at what it is and why you should pay attention to it.

When you look at the Database Activity screen in DBmarlin, for all intents and purposes it looks like it is displaying a list of statements. By and large it is but occasionally you will see a statement with a hash value of 0 and no text. What is this?

I will let you in on a little secret. Activity is really a session-based view. The majority of things that a session waits on are statements of course. But a session could also be waiting on other things such as writing to the log file, waiting for checkpoint completion, replication and so on. These may appear belonging to a commit statement but sometimes there is no associated statement.

Once you know the wait-event(s) associated with statement 0, you can click through to the DBmarlin knowledge-base to read more about what they mean and what can be done to reduce them.

It is important that these session waits are addressed. You may need a larger log buffer and faster log devices, for example. This will give you an across-the-board performance improvement, without the need to touch or tune any statements.

So watch out for statement 0!

Ready to try DBmarlin?

If you would like to find out more about DBmarlin and why we think it is special, try one of the links below.

• Get hands-on without an installation at play.dbmarlin.com
• Download DBmarlin from www.dbmarlin.com, with one FREE standard edition license, which is free forever for 1 target database.
• Join our new community at https://community.dbmarlin.com/invitation?code=74020A