Re: Oracle10G error!!!!

Praveen wrote:

> Hi All,
>
> I'm using Oracle 10g on Win Xp system SP2. I have the following
> entries in spfile.ora file:
> processes = 100
> sessions = 1105
> __shared_pool_size = 117440512
> shared_pool_size = 33554432
> __large_pool_size = 20971520
> large_pool_size = 4194304
> __java_pool_size = 20971520
> java_pool_size = 20971520
> sga_target = 167772160
> control_files =
> D:\ORACLE\PRODUCT\10.1.0\DB_1\FISDB10G\CONTROL01.CTL,
> D:\ORACLE\PRODUCT\10.1.0\DB_1\FISDB10G\CONTROL02.CTL,
> D:\ORACLE\PRODUCT\10.1.0\DB_1\FISDB10G\CONTROL03.CTL
> db_block_size = 8192
> __db_cache_size = 4194304
> compatible = 10.1.0.2.0
> db_file_multiblock_read_count= 16
> db_recovery_file_dest =
> D:\oracle\product\10.1.0\flash_recovery_area
> db_recovery_file_dest_size= 2147483648
> undo_management = AUTO
> undo_tablespace = UNDOTBS1
> remote_login_passwordfile= EXCLUSIVE
> db_domain =
> global_names = FALSE
> dispatchers = (protocol=TCP)
> utl_file_dir = d:\temp
> job_queue_processes = 10
> background_dump_dest =
> D:\ORACLE\PRODUCT\10.1.0\ADMIN\FISDB10G\BDUMP
> user_dump_dest =
> D:\ORACLE\PRODUCT\10.1.0\ADMIN\FISDB10G\UDUMP
> core_dump_dest =
> D:\ORACLE\PRODUCT\10.1.0\ADMIN\FISDB10G\CDUMP
> sort_area_size = 65536
> db_name = fisdb10g
> open_cursors = 300
> pga_aggregate_target = 25165824
>
> I'm getting the following error frequently. And around 35 programmers
> will connect daily.
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-12414: internal LBAC error: zllcsi:OCIStmtExecute
> Error: ORA-04031: unable to allocate 64088 bytes of shared memory
> ("large pool","unknown object","session heap","kksfal:1:frame
> segment")
>
> Can anybody help me why this error is coming?

Yes, it's what the error message explicitly says. You've run out of space in the large pool, which is apparently just 4MB big. Give it some more memory.

Regards
HJR
> ORA-06512: at "LBACSYS.LBAC_CACHE", line 99
> ORA-06512: at "LBACSYS.LBAC_EVENTS", line 74
> ORA-06512: at line 2
>

>
> Thanks,
> Praveen
Received on Wed Oct 27 2004 - 14:23:36 CDT