After moving to the new data center the overall performance of the database is noticeably slow. The process which used to finish in 3 minutes taking 6-7 minutes. How can I check that it is the database which is slow or the network ?The database is now on a new datacenter but the database is just the same as per server, memory ,cpu ,,sga ,pga etc.
This is Oracle database 11g rel 2 on Sun Solaris
I would definitely look at underlying hardware differences first.
I never thought about virus scanning but fully agree with the above post, that would kill a system if every update to a datafile caused
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…