Re: Shutdown of one instance takes about 1hr

On Feb 1, 2:28 am, Alexander Skwar <alexan..._at_skwar.name> wrote:
> Digeratus 2006 <digeratus2..._at_nospam.hotmaildotcom>:
>
> > As the others have said, "shutdown immediate" is your first step.
>
> Well, yeah, but I'd like to know why all the other databases,
> which are basically identical to the the RACEREF1 (RACE Reference),
> shutdown fine.
>
> > It looks like something is interrupting the shutdown of "RACEREF1".
> > Without more details, it is difficult to say what is happening.
>
> How can I get more details? Those are plain normal databases. They
> do make use DBLINKS - pointing to themselves, if I understood the
> developers correctly.
>
> > Andy Young
> > "If it isn't broken, then it doesn't have enough features, yet"
>
> ;)
>
> Alexander Skwar

Just use "shutdown immediate". If you want to see who is connected you can query v$session before the shutdown is issued.

HTH -- Mark D Powell -- Received on Fri Feb 02 2007 - 11:06:12 CST