Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'drop tablespace' produces a file/table lock??
"Tanel Poder" <tanel@@peldik.com> wrote in message news:<3f21b1c6$1_1_at_news.estpak.ee>...
> > > Hi!
> > >
> > > At least using 8.1.7.1 on Solaris 8, Oracle actually closes the file
> when
> > > taken offline or dropped. You can verify it with "fuser" command for
> > > example.
> > >
> > > Tanel.
> >
> > "Fuser command"?? Is that the one that short-circuits your server room??
> >
> > A novel approach to getting the file system to remove files, but I imagine
> > it would be quite effective!
>
> Fuser is a quite standard unix command to check which processes have a file
> open.
> Quote from Solaris man page:
>
>
> NAME
> fuser - identify processes using a file or file structure
>
> SYNOPSIS
> /usr/sbin/fuser [ -
> [ c | f ] ku ] files [ [ -
> [ c | f ] ku ] files ] ...
>
> DESCRIPTION
> fuser displays the process IDs of the processes that are
> using the files specified as arguments.
>
> Cheers,
> Tanel.
(It was a joke!!).
~QM
Received on Mon Jul 28 2003 - 01:10:57 CDT
![]() |
![]() |