structured environment

#1

As a new manager of a DBA group. I was wondering what activities the DBA's
should be involved in to make sure the application the developers are
writing are performing well, not wasting CPU cycles.

Recently it was discovered a query that was not using indexes and machine
performance was terrible.

I am looking for how other shops avoid performance issues.

#2

"Bob" <bfritz01 (AT) comcast (DOT) net> wrote

Quote:

As a new manager of a DBA group. I was wondering what activities the DBA's
should be involved in to make sure the application the developers are
writing are performing well, not wasting CPU cycles.

Recently it was discovered a query that was not using indexes and machine
performance was terrible.

I am looking for how other shops avoid performance issues.

Get Tom Kyte's Books (asktom.oracle.com) and one of the best ways is to make

sure the developer's use bind variables.
Jim

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

structured environment

comp.database.oracle comp.database.oracle

structured environment - 03-13-2005 , 02:17 AM

Re: structured environment - 03-13-2005 , 03:10 PM