A few times a day we get a dramatic increase in the number of user
connections on our database (sometimes 4 to 5 times as many according
to perfmon). Here is some additional information...
- from the time the number of connections starts to increase to the
time it drops back down to a "normal" level can take anywhere between 1
minute and 60 minutes
- the increase usually occurs rather quickly and drops off slowly
- we've checked for blocking, and none occurs during these sudden
increases
- we've ran profiler, and it seems like the average duration of queries
during these periods are no different then at other times of the day
Any ideas how we can find out what is causing this sudden increase in
user connections? Your help is greatly appreciated.
Re: How can I open an SQL database and be the only one who has access to it? ... you can determine how SS permits access to your server.... SINGLE_USER allows one user at a time to connect to the database.... controlled by the termination clause of the ALTER DATABASE statement.... To allow multiple connections, the database must be changed to ... (microsoft.public.data.ado)
Re: ORA-12518, 04030 errors after 9i-10G upgrade. ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ... out of process memory errors.... (comp.databases.oracle.server)
Re: ORA-12518, 04030 errors after 9i-10G upgrade. ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... out of process memory errors.... that Oracle is having issues with OS resources. ... (comp.databases.oracle.server)
Re: ORA-12518, 04030 errors after 9i-10G upgrade. ... New server has 6GB ram.... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ... (comp.databases.oracle.server)
Re: Proper Database Connection Cleanup ... but I think two of them have a database query in them. ... Public Sub ConnectToDB2(byref XCmd, byref YRS, byRef Conn) ...Set ObjRS = ObjCmd.Execute ... from DB connections in my code or from something else? ... (microsoft.public.scripting.vbscript)
