Získejte konzultaci v hodnotě 1 500 Kč k vaší databázi Oracle zcela zdarma. Ozvěte se mi ještě dnes.

ERROR at line 1:ORA-04031: unable to allocate 4096 bytes of shared memory („javapool“,“java/security/PolicySYS“,“joxlod exec hp“,“SGAClass“)ORA-06512: at line 14Kontrola08_01.png

SQL> @lab_08_04.sql*** Current parameter settings ***NAME TYPE VALUE———————————— ———– ——————————sga_max_size big integer 300Msga_target big integer 0*** SGA Dynamic Component Size Information***COMPONENT CURRENT_SIZE MIN_SIZE———————- ————— —————shared pool 100M 100Mlarge pool 4M 4Mjava pool 4M 4MDEFAULT buffer cache 100M 100M*** Current parameter settings in V$PARAMETER ***NAME VALUE ISDEFAULT——————– ——————– ———shared_pool_size 104857600 FALSElarge_pool_size 4194304 FALSEjava_pool_size 4194304 FALSEdb_cache_size 104857600 FALSE08_02.png08_03.png

SQL> @lab_08_04.sql*** Current parameter settings ***NAME TYPE VALUE———————————— ———– ——————————sga_max_size big integer 300Msga_target big integer 216M*** SGA Dynamic Component Size Information***COMPONENT CURRENT_SIZE MIN_SIZE———————- ————— —————shared pool 100M 100Mlarge pool 4M 4Mjava pool 4M 4MDEFAULT buffer cache 100M 100M*** Current parameter settings in V$PARAMETER ***NAME VALUE ISDEFAULT——————– ——————– ———shared_pool_size 0 FALSElarge_pool_size 0 FALSEjava_pool_size 0 FALSEdb_cache_size 4194304 FALSEHotovo 14 EXECUTE IMMEDIATE v_sql; 15 END LOOP; 16 END; 17 /PL/SQL procedure successfully completed.

SQL> @lab_08_04.sql*** Current parameter settings ***NAME TYPE VALUE———————————— ———– ——————————sga_max_size big integer 300Msga_target big integer 216M*** SGA Dynamic Component Size Information***COMPONENT CURRENT_SIZE MIN_SIZE———————- ————— —————shared pool 100M 100Mlarge pool 4M 4Mjava pool 16M 4MDEFAULT buffer cache 88M 88M*** Current parameter settings in V$PARAMETER ***NAME VALUE ISDEFAULT——————– ——————– ———shared_pool_size 0 FALSElarge_pool_size 0 FALSEjava_pool_size 0 FALSEdb_cache_size 4194304 FALSE



Komentáře