Re: Limiting Connections

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 28 Jun 2005 13:19:21 -0700
Message-ID: <1119989961.726533.297880@f14g2000cwb.googlegroups.com>

Ed, pull the DBA Administration manual (and later SQL manual) and look at the sessions_per_user parameter of create profile command.

Alternately you could trace a couple of the student sessions and make sure the SQL is tuned. One or two statements being 'fixed' could be all it takes to allow handling the rush without too much trouble.

Another idea might be to use the Database Resource Manager (EE edition) DBMS_RESOURCE_MANAGER, to place this user in a resouce profile that lowers the student priority so that more important work gets first shot at available resouces.

HTH -- Mark D Powell -- Received on Tue Jun 28 2005 - 15:19:21 CDT