| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> NT4 / 8.0.5 /Transactions Limit Reached
Hi,
One of our prod databases sort of just suddenly went into restricted mode yesterday allowing only dba's to log in and stopping non-privileged user's. We first noticed this when os_authentication suddenly stopped working and users got the ODBC login. The alert log was clean (no errors reported) but further investigation showed that we had reached the transaction limit which was indicated in the Enterprise Manager. Not having more time to investigate, we rebooted NT and the problem was resolved. Now I can see that the transactions parameter is nearing the limit again and I would like to know where to look first to know what's happening. I looked into v$%transactions% views and they were all empty.
BTW, we only had about 30 sessions at that time and the transactions had reached the limit of 247
Any ideas on where to begin looking or advice on what to watch out for?
Thanks for your help,
George Hofilena
DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Hofilena
INET: GHofilena_at_cnv.org
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). Received on Fri Jun 01 2001 - 14:29:47 CDT
 |
 |