shared pool size question

Hi all,

    We are running 9.2 database with 300M shared_pool defined. One user created a view on several table. If he query with that view, he will get "ORA-04031 unable to allocate string bytes of shared memory" error. So he created a new table to replace the view. Now if he query this new table, he won't get the error and query time is much short. What makes the difference? Thanks for advice.

Jay Received on Wed Apr 09 2003 - 12:41:05 CDT