Hiya everyone,

I am a developer who could do with some help and I'd appreciate any advice
you can give.
I've got an insert statement in a stored proc called by a Windows service.
The problem is we need it to run a lot faster than it does, as it is
currently the major bottleneck in our system. It is currently taking
approx 10ms per round trip but it needs to be called so many times during
our process that there is no real point focusing on any other area
currently!

Does anyone have any suggestions?

If the tnsping time from the machine with the Windows service to the
database is 10ms, does that indicate that there is not a lot wrong with
the statement? (and that the 10ms is mostly the network).

Also, we are using label security; could this be an issue?

Thanks in advance for any help,

Joe


Oracle LazyDBA home page