[dbsec] Fwd: Performance metrics

Dear All,

This may not have made it last time. Please excuse double posting if it did.

./Z

=============================================================================
Hello all,

I don't know whether this is applicable to the list, but being a
database security oriented question I thought I would give it a shot
here first...

I am trying to construct a capacity plan for the company I work for
regarding enabling Oracle Security, namely Audit and Encryption.
My main approach will be:
Audit:
  Get usage statistics from the production environment
  Get performance statistics from the production environment
  Mirror my production environment to test
  Enable audit for SELECTs to a number of tables.
  Rerun the usage scenarios and monitor performance degradation
  Stress test test environment Oracle server to get the maximum limits
  Based on that an upgrade will be proposed so as to level the
performance to previous limits

Encryption:
  Get usage statistics from the production environment
  Get performance statistics from the production environment
  Mirror my production environment to test
  Enable Oracle TDE to a number of tables.
  Rerun the usage scenarios and monitor performance degradation
  Stress test test envinronent Oracle server to get the maximum limits
  Based on that an upgrade will be proposed so as to level the
performance to previous limits

Of great help would be Database Replay in 11i but the problem is that
all my data is mainly at 9i going to 10g.

My main problem is which usage statistics would be more meaningful to get?
Does enabling auditing and encryption have a direct effect of the
whole database or only on the relevant tables? The reason behind this
question is that mainly I want to use the Concurrent SELECTs Num. vs
Average SELECT Time in order to see the effect. This would make sense
only if the effect was on the individual tables rather than the whole
database. If the latter is the case I must gather more generic
statistics such as concurrent sessions

Anyone done this before and willing to share any insights?

Thanks in advance,
./Z

=============================================================================

Other related posts: