- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle 8.1.6 not closed with shutdown immediate
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-02-2001 11:35 PM
тАО10-02-2001 11:35 PM
oracle 8.1.6 not closed with shutdown immediate
WAITING FOR SMON TO DISABLE TX RECOVERY
and I have to do a shutdown abort to go on
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2001 02:34 AM
тАО10-03-2001 02:34 AM
Re: oracle 8.1.6 not closed with shutdown immediate
The shutdown immediate means, that ALL processes on the database must ne finished, before the shutdown reacts. If a user's process would still be active, it would also finish first ( long query etc ). With the shutdown abort you shoot the horse, kill all processes,no rollback will work and it will take a bit longer to start the database because of recovery. Recovery will be done prior to opening of the database.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2001 02:50 AM
тАО10-03-2001 02:50 AM
Re: oracle 8.1.6 not closed with shutdown immediate
this problem might occur when a very large number of temporary segments are in use (which have to be cleaned up at shutdown). A solution might be to edit the default storage of your temp tablespace and define larger extents, or even to completely recreate the temp tablespace (as locally managed?).
good luck,
Thierry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2001 04:28 AM
тАО10-03-2001 04:28 AM
Re: oracle 8.1.6 not closed with shutdown immediate
With shutdown immediate, all transactions that aren't commited are rolled back, and this may take a long time if there are large transactions going on in your base.
If you are in a hurry the abort is preferable, even if this may feel a litle risky, it isn't, as the recovery during startup gets everything into place.
To aviod having SMON doing cleanup of the temporary extents after your transactions are cleaned up, the temp tablespace should be set temporary, as the temp extents now are simply dropped during shutdown.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2001 07:36 AM
тАО10-03-2001 07:36 AM
Re: oracle 8.1.6 not closed with shutdown immediate
which are no longer needed and marking them as freed.
Either wait for SMON to clean up the free extents in the database as it
shuts down or perform a SHUTDOWN ABORT to shutdown the instance. A SHUTDOWN
ABORT will not perform a clean shutdown.
Verify that temporary segments are decreasing
---------------------------------------------
To verify that the temporary segments are decreasing have an active session
available in Server Manager during the SHUTDOWN IMMEDIATE. Issue the following
query to ensure the database is not hanging, but is actually perform extent
cleanup:
SVRMGR> select count(block#) from fet$;
COUNT(BLOC
----------
7
SVRMGR> select count(block#) from uet$;
COUNT(BLOC
----------
402
After some time has elapsed, reissue the query and see that the values for fet$
have increased while the values or uet$ have decreased:
SVRMGR> select count(block#) from fet$;
COUNT(BLOC
----------
10
SVRMGR> select count(block#) from uet$;
COUNT(BLOC
----------
399
During shutdown the SMON process is cleaning up extents and updating the data
dictionary tables with the marked free extents. As the extents are marked as
freed, they are removed from the table for used extents, UET$ and placed on the
table for free extents, FET$.
How to Avoid creating many Temporary Extents
--------------------------------------------
Once the database has shutdown cleanly, to avoid creating many temporary
extents change the initial and next extent sizes on temporary tablespaces
to a more appropriate size:
ALTER TABLESPACE
Note: If the temporary tablespace is of type TEMPORARY, then this change
will only affect temporary segments created after issuing the above
command. Any existing temporary segments already in the TEMPORARY tablespace
will not be affected till the instance is restarted. On shutdown, existing
temporary segments are dropped. If the TEMPORARY TABLESPACE is of type
PERMANENT, then cleanup is performed by SMON after completion of the process
using it.
Increasing the initial and next extent size will decrease the number of extents
that are allocated to temporary segments. Since there are fewer extents to
deallocate, the database should shutdown more speedily.
Take the following scenario:
A database was subject to large sorts with the following sort parameter in
the "init.ora" file:
- sort_area_size=1000000
The temporary tablespaces for this database were all created with initial and
next extents sized at 50k and the total database size was about 300mb.
Database sorts will utilize memory as much as possible based on the "init.ora"
parameter "sort_area_size". Once this memory-based sort area is filled, the
database will utilize the temporary table space associated with the database
user to complete the sort operation. During a shutdown normal, the database
will attempt to clean up the temporary tablespaces.
If a small extent size is used, then a large number of extents will be created
for a large sort. The cleanup of the temporary tablespace takes much longer
with a large number of extents.
Note:
=====
You have to do a shutdown abort and then bring the database
back up to run the suggested queries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2001 03:31 PM
тАО10-04-2001 03:31 PM
Re: oracle 8.1.6 not closed with shutdown immediate
if you are in a hurry when shutting down the instance,
why not force a checkpoint and then do an "shutdown
abort"? Even Oracle themselfs recommend it now...
HTH,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2001 11:13 PM
тАО10-04-2001 11:13 PM
Re: oracle 8.1.6 not closed with shutdown immediate
regds
jp
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-18-2004 08:56 PM
тАО04-18-2004 08:56 PM