PLSQL beginners question

From: Paul van den Bogaard <paul_at_vdbogaard.com>
Date: Fri, 09 Dec 2005 10:58:12 +0100
Message-ID: <43995534.40404@vdbogaard.com>

I have a logon trigger that enables event 10046 for certain users. However there are too many users with this same name. If I want to reduce the amount of sessions that have 10046 enabled, how to extend this in the trigger.

Current idea is:

....

if user = "USER_OF_INTEREST"
then

if counter < SOME_VALUE

	enable event
	counter = counter + 1;

end if

end if

Of course this counter needs to be shared between multiple sessions. Would be real convenient of SOME_VALUE could be set independend from the the trigger.

Thanks
Paul

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 09 2005 - 03:58:27 CST