Ora-04031: unable to allocate nnnnn bytes of shared memory

[pando]

sort_area_size is too big, in an OLTP 1MB is more than enough (and you have 200MB!)
even in a dwh 32 to 64 MB should be enough