Re: Oracle10G error!!!!

spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0410270503.e1021fa_at_posting.google.com>...
> 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")
> ORA-06512: at "LBACSYS.LBAC_CACHE", line 99
> ORA-06512: at "LBACSYS.LBAC_EVENTS", line 74
> ORA-06512: at line 2
>
> Can anybody help me why this error is coming?
>
> Thanks,
> Praveen

http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=3513427.8 kinda tells me there may be some pool issues in that version.

Also, I'm sure you've seen the boldface type in http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=146599.1 since you have sga_target set. Maybe you just need a bigger shared pool to get around the bugs.

jg

--
@home.com is bogus.
Now the capitalistic parasites will suck your accounts dry in no time:
 http://www.federalreserve.gov/paymentsystems/truncation/