Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slowing down Oracle 7.3 on SCO OpenServer-5
Well, in short, you need an experienced UNIX System Administrator to monitor the OS for you, using either the built-in UNIX commands (ps, vmstat, iostat, etc.) or whatever third-party tools you have.
Likewise on the Oracle side you need an experienced DBA to monitor and tune the instance. Again either develop/download some SQL scripts or buy a third party tool (or those provided at additional cost by Oracle).
Steve Phelan.
Edward W. Vergragt wrote in article <5qj361$sc1$1_at_news.Kijfhoek.NL.net>...
>We have an Oracle-application (Pro*SQL) running against an Oracle 7.3
>instance. Everything workt really fast directly after startup of the
>instance. After several days the preformance of ALL applications
>deteriorate....
>
>The effect is that the COMMIT after several transactions is very slow.
>Normally you update some records in SQL*Plus. When entering COMMIT,
>the command is executing very fast. In our situation, the time between
>asking for a commit and the actual commit takes a long time (eg.
>several seconds). After shutting down the instance and re-starting it,
>performance is OK. Some time later, the whole thing starts again...
>
>Does anybody has any ideas what to do? We would like to monitor
>something in order to find out what is causing this to happen.....
>
>Thanks in advance
>
>SWM Automatisering
>Bussum, Netherlands
>
>Edward W. Vergragt
>edward_at_swm.nl
>Edward W. Vergragt
>SWM Automatisering - Bussum, the Netherlands
>vergragt_at_inter.NL.net
>
>programmatuur voor handel in bulk-goederen (commodities), gebaseerd op het
Oracle RDBMS
>software for commodity-traders, trafficers, Oracle-based
>
Received on Thu Jul 17 1997 - 00:00:00 CDT