Clue for Performance Analysts

Today, I had a DBA give some recommendations for tuning a database. One of those took me by surprise as this DBA is supposed to be a performance analyst!

The recommendations included:


My response was that performance analysis cannot proceed without statistics. I am less inclined to trust the DBA’s performance recommendations.

2 thoughts on “Clue for Performance Analysts

  1. Any reasons given? Was it to solve a specific performance problem? What version is the database and on which platform?

    • Cheeky, Fred.

      The reasons given were that these parameters caused overhead.

      Version was on AIX 6.1.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s