I keep getting this error:
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects")
I have raised the amount of the shared pool many times, but after some days I get the same error again. I have read everything I could on the web, and came to the conclusion that the cause could be fragmentation.
I know that using bind variables may help to save shared memory, but I need to find another way since I have no control over the query that are executed by a tool from a third party.