Versions Compared

Old Version 3

changes.mady.by.user Tony Johnson

Saved on

compared with

New Version 4

changes.mady.by.user Massimiliano Turri

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Oracle crash

Due to "out of shared pool space". Shared pool is used, among other things, to cache recent queries so that they can be reused. Non optimal queries in the DataQualityMonitoring application seem to have been responsible for this. The queries were fixed immediately.

We learned that we have to e-mail db-admin.

  • Learn to use GRIDControl, an insanely complicated tool to monitor Oracle. We can use it to find out what queries are heavier on the system and ways to optimize them.
  • RAC system: Real Application Clusters. For load balancing and fail over.

Web Server Crashes

There were a few (5?) crashes of the web server on which the DataQualityMonitoring application is deployed. All due to the server running out of memory.

Things we need to fix afterwards

...