We have a new high transaction application that is running on 9ias (forms & reports)
on top of a 9i database. I believe the application has alot of bugs,
but most importantly we are experiencing alot of locks thru out the day.

to be proactive:
I have reports that list which user is causing the lock and which users are waiting.
and for how long, cpu %, etc.....
I also list the exact forms that are causing the locks. There are many.....

I believe the developers need to fix this, but it doesn't seem to be happening.
Any suggestions, on what a dba can do to help reduce these locks? from effecting the users?
something im not seeing?
maybe the developer cant fix them either and that is why they aren't being fixed?

why do oracle locks occur? exactly???
how can I be proactive and help the problem, even though
I haven't worked on an oracle form in years and really don't have access to fix it? (the fmb)

any good ideas out there? any suggestions would be great, who knows
it could advance my career it I could come up with something....


Thank you fellow lazy-dba's
Scott


Scott Grant
Oracle DBA
NIKE TN, Inc. a
(901) 542-3072
<mailto:Scott.[Email address protected]




Oracle LazyDBA home page