Home » SQL & PL/SQL » SQL & PL/SQL » Package is in use? (Oracle
Package is in use? [message #357084] Mon, 03 November 2008 16:50 Go to next message
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 #357117 is a reply to message #357084] Tue, 04 November 2008 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 65088
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select * from dictionary where table_name like '%DEPENDENC%';
Then goto to Reference Manual.

Re: Package is in use? [message #357514 is a reply to message #357084] Wed, 05 November 2008 12:54 Go to previous message
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

Previous Topic: Optimized query does not uses same plan if used to create a table
Next Topic: select count(1)
Goto Forum:

Current Time: Wed Jul 26 08:06:45 CDT 2017

Total time taken to generate the page: 0.21836 seconds