dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You don't need to worry regarding internal locks as they are held by system catalog objects.
Internal P Locks are used with cached packages/sections.
Any execution of SQL, whether static or dynamic, must be done while holding a 'package lock'.
This ensures that no-one can drop the package that is being executed.
There should be no performance issues because of them. |
|