Package is in use? [message #357084] |
Mon, 03 November 2008 16:50  |
coleing
Messages: 213 Registered: February 2008
|
Senior Member |
|
|
Hi All.
Quick question I hope, but ive been unable to find an answer (v$lock doesnt seem to ahve the information I need).
We have a test database, on which everybody developes and tests their code before running once a week end to end.
THere is some shared code that many users call. However, during the week that shared code needs to be updated/fixed also.
The importance of package consistency during the week is not an issue, as everyone is just testing stuff.
Our code release tool(in-house) just seems to hang whenver a package to compile is in use (or is a dependent object in another package in use). I could make the release tool smarter if I could anticipate this, and skip/log the compilation for a later time.
Does anyone know of a query I can find this information out within Oracle?
Or is there a way to force a compilation?
Im not just talking about procedures which are currently executing, but ones that are explictly named in someone elses code, which itself is executing (dependencies).
Hope I am making sense...
[Updated on: Mon, 03 November 2008 16:52] Report message to a moderator
|
|
|
|
Re: Package is in use? [message #357514 is a reply to message #357084] |
Wed, 05 November 2008 12:54  |
coleing
Messages: 213 Registered: February 2008
|
Senior Member |
|
|
You didnt understand my question I dont think.
I wanted to find out, if I want to compile a package, will Oracle Hang and timeout, or will it allow it.
I think I have the answer (it seems to work for my first few initial tests anyway), and it has nothing to do with dependencies and v$lock.
Select owner, name, locks, pins, a.*
From v$db_object_cache a
where type = 'PACKAGE'
and owner = '#OWNER#'
and pins > 0
;
[Updated on: Wed, 05 November 2008 12:55] Report message to a moderator
|
|
|