After an event last week on our Windows 2003 Oracle 10g server (10.2.0.1) we are experiencing very slow retrieval of certain data. Searches appear to be fine, but going into cases in our application can take 20- 30 secs instead of near instantaneous. The errors were as follows:
Checking the ORA-errors it appears to be a memory or OS problem, but we haven't experience them since that time. Restarts of the server and addition of memory / disk checks have not helped things at all. I am an Oracle noob, so my analysis of the problem centered around trying to find errors in the database (which I'm told is very unlikely in Oracle).
Is there a sure fire way of error checking in this situation and do my errors look to be something fixable? This system is soon to be decomissioned and I am loathed to start up any more Oracle support as the system will be defuncy by the beginning of the new year. Many thanks in advance.
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.
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
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.