David Fitzjarrell wrote:
> 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.
Actually, on Windows, a 16K block size is my preference. Point is, he can
use any block size he likes on Windows, because NTFS does direct I/O out of
the box.
Or are you saying the multiblock read count should be 8Kx8=64K, hence
16Kx4=64K etc etc etc?
Besides which, I just tried this:
SQL> show parameter db_file_multi
NAME TYPE VALUE
------------------------------------ -----------
db_file_multiblock_read_count integer 16
SQL> alter system set db_file_multiblock_read_count=512 scope=spfile;
System altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 101784276 bytes
Fixed Size 453332 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> show parameter db_file_multi
NAME TYPE VALUE
------------------------------------ -----------
db_file_multiblock_read_count integer 128
Which indicates that 128x8k (happens to be an 8k system) is do-able: 1MB
seems perfectly feasible to me.
I'm a bit at a loss therefore to understand the "It should be 8" comment.
Regards
HJR
Received on Wed Oct 27 2004 - 18:25:06 CDT
