I am posting here because i really dont know where can be the problem in this situation. So i dont know where it would be correct to open this thread.
I try to explain.
1. The situation.
Users log in an application server where the main application is. Every login creates a new windows session so they can use the application.
Main database ( oracle ) is on another server.
The program has a main window and here you can run all program features using menues, user interfaces, buttons etc etc.
2. Description of the problem.
Sometimes, seems randomly and it has not been found a situation that is equal to the other, it happens that:
you click on a button that must open a program reading data from db;
then the program seems to be reading data and it s all frozen, blocked and you cant do anything;
the widgets of the program and the main window are not loaded but you cannot do anything because ( it is correct that happens, in a normal situation ) everything is disabled to let the new feature run and appear;
users go crazy because they cannot go on working.
3. More info.
I can say that:
- if i enter the application using the same program user but creating my own new server (windows) session: i do the same thing and this program opens correctly!
- you can wait as long as you want but the "blocked" one does not ever recover ( ever waiting an hour )
- looking at the db, i can see no table locks ( in fact i can open the same data using another user ), and the program access table only to read data
- sometimes i kill some random db sessions that seem to be remained open incorrectly and then the programs comes back to life, as summoned by a wizard ( the user of magic of fantasy stories )
- it does not happen everytime, i have not been able to determine a defined condition that causes the problem to raise
- the table that is used from the program has a lot of records and even using tools like Toad it takes a lot of time to be displayed
4. What do you think about that?
I accept every clue you would give.
Do you think that may be a problem related to the application?
May be that it is a problem related to db instead? A session blocked, problems in accessing data, conflicts of other kind?
Network issues? I dont think so but i cant exclude anything.
5. Does anyone know a way to try to discover the problem cause?
If there is a tool that can monitorize the db sessions, ie, to let me know if that session has problems, it s blocked, there is a connection problem and so on, let me know.
May be it is a problem on the application server? How can i discover it?
Other ideas?
Many thanks in advance. I know i ask you a lot.
I try to explain.
1. The situation.
Users log in an application server where the main application is. Every login creates a new windows session so they can use the application.
Main database ( oracle ) is on another server.
The program has a main window and here you can run all program features using menues, user interfaces, buttons etc etc.
2. Description of the problem.
Sometimes, seems randomly and it has not been found a situation that is equal to the other, it happens that:
you click on a button that must open a program reading data from db;
then the program seems to be reading data and it s all frozen, blocked and you cant do anything;
the widgets of the program and the main window are not loaded but you cannot do anything because ( it is correct that happens, in a normal situation ) everything is disabled to let the new feature run and appear;
users go crazy because they cannot go on working.
3. More info.
I can say that:
- if i enter the application using the same program user but creating my own new server (windows) session: i do the same thing and this program opens correctly!
- you can wait as long as you want but the "blocked" one does not ever recover ( ever waiting an hour )
- looking at the db, i can see no table locks ( in fact i can open the same data using another user ), and the program access table only to read data
- sometimes i kill some random db sessions that seem to be remained open incorrectly and then the programs comes back to life, as summoned by a wizard ( the user of magic of fantasy stories )
- it does not happen everytime, i have not been able to determine a defined condition that causes the problem to raise
- the table that is used from the program has a lot of records and even using tools like Toad it takes a lot of time to be displayed
4. What do you think about that?
I accept every clue you would give.
Do you think that may be a problem related to the application?
May be that it is a problem related to db instead? A session blocked, problems in accessing data, conflicts of other kind?
Network issues? I dont think so but i cant exclude anything.
5. Does anyone know a way to try to discover the problem cause?
If there is a tool that can monitorize the db sessions, ie, to let me know if that session has problems, it s blocked, there is a connection problem and so on, let me know.
May be it is a problem on the application server? How can i discover it?
Other ideas?
Many thanks in advance. I know i ask you a lot.