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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
