Re: Setting bind variables or defines from applications?

sybrandb_at_yahoo.com schrieb:
> In the apps I'm faced with, dynamic sql means
> 'always parse' (whether soft or hard, doesn't matter: always parse)
[...]
> And because every statement is being parsed all the time (which can be
> easily demonstrated from statspack), we know have a server which
> heavily suffers from library latch contention, and is usually pegged at
> 100 percent for most of the day.

What does your developers' boss say to this?

Volker Received on Mon Apr 24 2006 - 06:12:49 CDT