Oracle 9i Large_Pool
Hi,
with select * from v$sgastat I'm getting
POOL NAME BYTES
----------- -------------------------- -----------------------------
fixed_sga 434560
db_block_buffers 67108864
log_buffer 524288
shared pool 1M buffer 1048608
shared pool Checkpoint queue 256640
shared pool FileIdentificatonBlock 349824
shared pool FileOpenBlock 1191104
shared pool KGK heap 7000
shared pool KGLS heap 193392
shared pool KGSK scheduler 69632
shared pool KGSKI schedule 21296
shared pool KSXR receive buffers 1064000
shared pool PL/SQL DIANA 734280
shared pool PL/SQL MPCODE 47360
shared pool PLS non-lib hp 2088
shared pool VIRTUAL CIRCUITS 348640
shared pool character set object 330424
shared pool dictionary cache 358736
shared pool enqueue 309528
shared pool event statistics per sess 1366800
shared pool fixed allocation callback 216
shared pool free memory 79418952
shared pool joxlod: in ehe 435472
shared pool joxs heap init 4240
shared pool library cache 4484016
shared pool message pool freequeue 858224
shared pool miscellaneous 4668464
shared pool parameters 1064
shared pool sessions 444720
shared pool sql area 2341408
shared pool transaction 307168
large pool free memory 18446744073708959624
large pool session heap 591992
java pool free memory 77512704
java pool memory in use 6373376
Does anybody know where the large_pool free mem number comes from?
Of course I do not have 1,8E+10 GByte of System Memory! Is there any
know problem with Oracle 9?
Additionally I get the error
ORA-04031: 32512 Bytes des gemeinsamen Speichers konnten nicht zugewiesen werden ("large pool","unknown object","cursor work he","x$ktfbfe-bit")
with question to the data dictionary (TOAD->DBA->Tablespaces)
I think this is related but I have no further idea and would appreciate any hint!
Thanks,
Christoph