In 10g on Windows, unless specifically instructed otherwise, DBCA makes a
block size of 8 and a db_file_multiblock_read_count of 16. He probably used
DBCA.
"David Fitzjarrell" <fitzjarrell_at_cox.net> wrote in message
news:9711ade0.0410271424.792dfc9_at_posting.google.com...
> 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
>
> Your large pool is only 4 meg; increase its size and you should
> eliminate the problem. Also, why are you using an 8k block size and a
> db_file_multiblock_read_count of 16 on Windows? It should be 8.
>
> David Fitzjarrell
Received on Thu Oct 28 2004 - 10:05:21 CDT
