yep, I used lsof, but it doesn't show a process using the filesystem where
it was the datafile.
On 7/7/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Maybe fuser or lsof?
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ken Naim
> *Sent:* Friday, July 07, 2006 4:37 PM
> *To:* aleon68_at_gmail.com; 'oracle-l'
> *Subject:* RE: Linux does not show the freed space by a drop tablespace
>
>
>
> . . . When I used to work on solaris 9 we used a command (which currently
> escapes me) that listed all the process id's that had handles on each
> datafile . . .
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
--
Alfonso Leon
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 07 2006 - 18:57:45 CDT
