Sql Statement error

[pareshg]

Hi,

While executing one sql statement, I am getting foll error.
The sql statement using 8 tables to retrive the data.

ORA-04031 : Unable to allocate 8192 bytes of Shared Memory
("large pool","unknown object","sort subheap,"sort key")

Pls tell me the solution to resolve this problem.

Paresh.

[ovidius]

So, where is the problem?
Give it some (more) large pool, it is crying in a very precise manner... Maybe you did not allocate large pool or sort area size enough?