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:

  • Disable TIMED_OS_STATISTICS
  • Disable TIMED_STATISTICS

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

Advertisements

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 10.2.0.4 on AIX 6.1.

      Douglas

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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