ora-4031 export-error! [message #73786] |
Mon, 12 July 2004 23:42 |
Alex
Messages: 190 Registered: August 1999
|
Senior Member |
|
|
Hi,
I have a 8.1.6 db on a windows 2000-system.
When I make the last days my export I get a ora-04031:
EXP-00008: ORACLE-Fehler 4031 gefunden
ORA-04031: 8716 Bytes des gemeinsamen Speichers konnten nicht zugewiesen werden ("large pool","unknown object","cursor work he","kllcqas:kllsltba")
EXP-00000: Der Export-Vorgang endete mit Fehlern
Ichecked the shared pool and its size is 50 MB. Following v$sgastats there are 42 MB free. Now I don't know to react!
I read something about the "alter system flush shared_pool"-command, but I wouldn't understand to clear my shared pool, when there is so much free space!
Is the size of the large pool important, too in this case?
|
|
|
|
Re: ora-4031 export-error! [message #73792 is a reply to message #73791] |
Tue, 13 July 2004 04:14 |
Alex
Messages: 190 Registered: August 1999
|
Senior Member |
|
|
The initial-parameters in the init.ora are:
shared_pool_size = 52428800 # INITIAL
# shared_pool_size = 3500000 # SMALL
# shared_pool_size = 5000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
large_pool_size = 614400
java_pool_size = 20971520
I think 20 MB must be enough, but the large pool seems to me too small!
Additional in the error-message talks from the large pool!
Is it not possible, that the large pool is the problem?
Or to question other:
Will I have trouble, when I increase the size of the large pool?
|
|
|
|