Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 8.1.7: shared pool fragmented - can I clear it on-the-fly?
We run a customer's application on Oracle 8.1.7. From time to time it's
not possible to log in anymore. The shared seems to be fragmented. A
restart of the instance helps, but then the application has to be
restarted as well.
Is it possible to de-fragment the shared pool or at least clear it while the instance is up and the application stays connected? Received on Sat May 31 2003 - 17:35:13 CDT