Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> NT4 / 8.0.5 /Transactions Limit Reached

NT4 / 8.0.5 /Transactions Limit Reached

From: George Hofilena <GHofilena_at_cnv.org>
Date: Fri, 01 Jun 2001 14:34:08 -0700
Message-ID: <F001.00318CBB.20010601141109@fatcity.com>

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 IS 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



Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--

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 - 16:34:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US