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.