OK, so where is the de-compiler so we can proof read it?? Of is that what they provided 10046 for?? Dick Goulet Senior Oracle DBA PAREXEL International ________________________________ From: Jared Still [mailto:jkstill@xxxxxxxxx] Sent: Thursday, May 07, 2009 1:31 PM To: Goulet, Richard Cc: oracle-l-freelists Subject: Re: How to determine sessions with invalid package states On Wed, May 6, 2009 at 10:52 AM, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx> wrote: I found the attached on Metalink some time ago. Works good at telling you who is using what. The script is from ML 1054939.6 From the note: "PROOFREAD THIS SCRIPT BEFORE USING IT!" :) Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist