Re: Oracle Licenses vs Processes

Thanks for your replies. I think I have 2 issues here:

1. the licensing agreement - whether it's 40 sessions or 40 'seats' which I will have to find out about at this end

and

2. the relationship between sessions and processes. Is it 1 connection to the database = 1 process? If so, then why in Instance Manager do the two not tally up? For example, there are currently 34 sessions listed - 26 from the application, 7 background and the session I am using. However, when I switch to the Resource limit tab it lists 35 sessions and 61 processes. So what are these extra processes?

What are the implications to the database performance if I increase the maximum number of processes, currently set to 100?

Hope that all makes sense

thanks again

Richard

richardpstanton_at_yahoo.com (Richard Stanton) wrote in message news:<87bc8a5f.0310020138.1178edd0_at_posting.google.com>...
> Hello
>
> I have 'inherited' an oracle 8.05 database running on nt and have a
> question regarding processes and licenses.
>
> The database is accessed mainly through an application, but also
> serves some asp pages. We are licensed for 40 concurrent users.
>
> Occasionally we get a situation where you try and connect to the
> database and you get an error message stating that "maximum number of
> processes (100) exceeded".
>
> What processes is this referring to and how is it related to connected
> sessions? If it's just a default database setting, is it something I
> could change?
>
> thanks in advance for your help
>
> Richard
Received on Fri Oct 03 2003 - 10:43:14 CDT