Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 'drop tablespace' produces a file/table lock??

Re: 'drop tablespace' produces a file/table lock??

From: Quarkman <quarkman_at_myrealbox.com>
Date: 27 Jul 2003 23:10:57 -0700
Message-ID: <6f2ab2f8.0307272210.652bde72@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US