Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shutdown immediate hangs.
Rafiq,
Sorry for changing the subject .... but,
Do you know the best way to verify if the mts_ configurations are working properly? I have configured mts parameters to except 3000 connections.
The problem is, during load testing the applications are requesting 2000+ connections, but V$SESSIONS only showns 148 connections.
mts_dispatchers =
"(ADDRESS=(LIS=IQ)(PROTOCOL=TCP)(HOST=mydb.home.com))(DIS=20)(POOL=YES)"
mts_servers=30 mts_max_dispatchers=600 mts_max_servers=1000 mts_service=IQ mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(Host=mydb.home.com)(Port=1521))"
sessions=2000
How can I verify whether or not there are 2000 requests for connection?
Can you help please?
Thanks
larry abdul Latif taylor
-----Original Message-----
From: Mohammad Rafiq [mailto:rafiq9857_at_hotmail.com]
Sent: Friday, October 13, 2000 9:52 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Shutdown immediate hangs.
Please check whether any user running any background job(nohup) on database
as shutdown immediate is unable to shut down database and wait for that
session to complete processing....
Regards
Rafiq
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Fri, 13 Oct 2000 01:10:23 -0800
All,
Last night our backups were not able to kick in as the shutdowns did not work. The trace file shows the following
This goes on for sometime until a shutdown abort is issued. Am i right in assuming that the DB is attempting to rollback active transactions before shutting down or is there something else causing this. I am new at this place and apparently they say this has never happened before.
Anyone seen this ??
Lee
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk
>
>
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: LEROBE_at_acxiom.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: rafiq9857_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Fri Oct 13 2000 - 11:19:35 CDT