RE: shutdown immediate

From: O'Neill, Sean <Sean.ONeill_at_organon.ie>
Date: Wed, 6 Dec 2000 11:14:42 +0100
Message-Id: <10702.123762@fatcity.com>

Problem Description: Shutdown immediate slow Oracle Version: ?
Operating System: Solaris 7
Related Web sites: ?
Related MetaLink docs: ?

Roy,

Had a look thru me notes and found the following info relating to SHUTDOWN IMMEDIATE hanging. So FWIW,

Someone made a posting where immediate was taking 20 hours. They created a decent sized TEMP tablespace and ALTERED SYS to use TEMP as temporary tablespace. The explanation/rationalization offered was that previously SYS was using SYSTEM as it's "temporary" tablespace and was being resource cramped. Once SYS had some acceptable amount of scrathc space in TEMP, it could and would quickly complete the shutdown within a minute or two. Ov8.1.5, HW not specified.

Sean :)

Rookie Data Base Adminstrator

[0%] OCP Oracle8 DBA 
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
------------------------------    ------------------------ 

E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]

Visit: http://www.egroups.com/group/Oracle-OCP-DBA

The only man who never makes a mistake is the man who never does anything.

• Theodore Roosevelt

> From: Roy Ferguson <rferguso_at_level1.com>
> Date: Tue, 5 Dec 2000 16:35:49 -0800 (PST)
> Subject: shutdown immediate
>
>hello all...I've been asked about an issue with a database not shutting
down
>after executing shutdown immediate. over 6 hours later the database is
still
>not down...what should I look at?
>running solaris 7
Received on Wed Dec 06 2000 - 04:14:42 CST