UNIX for Advanced & Expert Users

hi ,

i could see 50-60 oracle inactive session running under my application name, does this cause any issue.. or can this inactive session be excluded , if so how can we reduce them or exclude them , your inputs are much required.


my application runs on C++ with oracle , pro*c involved.


oracle is 10G

thanks,
senthil

When you create a Pro*C application when it runs, it forks a new process that is the communication and SQL execution module. So having the parent process inactive is not unusual.

However, if all of those processes are owned by a single user and they are old, then something else is very wrong. Possibly with your code not exiting or not waiting for children correctly.