In the peak business hours our application is accessed by more 600 users, some times users reported with sessions hanging issue. I really confused whether the issue in the middle tier Or Database. In middle when I see the resource consumption of the server is very less, CPU 80 Idle, Memory 75% free. We are running form based application.
How to justify at which layer issue is persist. Is either database / Application server.
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.