Soft parse & shared pool fragmentation

From: srivenu <srivenu_at_hotmail.com>
Date: 11 Jul 2003 06:09:14 -0700
Message-ID: <1a68177.0307110509.5ca37825@posting.google.com>

I was reading a Note in metalink (<Note:146599.1> - Diagnosing and Resolving Error ORA-04031 ) and had a question. This is part of Note:146599.1
................

If the SHARED_POOL_SIZE is large enough, most ORA-04031 errors are a result of dynamic sql fragmenting the shared pool. This can be caused by:

        o Not sharing SQL 
        o Making unnecessary parse calls (soft) 
        o Not using bind variables 


........................

I can understand shared pool getting fragmented by not sharing SQL. But can sort parses can lead to shared pool fragmentation ? Thanks in advance for any replies.
regards
Srivenu Received on Fri Jul 11 2003 - 08:09:14 CDT