Hello All,
The 10.2.0.5 database is frequently getting hung as procesesses parameter is reaching its threshold.
i have increased the value of proceses from 150 to 200 and after a day 200 to 250.
Is there any way to know the number of connections per user over time period .so that i can cometo know which user is having more connections and is not logging out.as a last step i will go to the application team.For eg the data of connections/per user at peak time for last one week.