| ORA-04030 and ORA-12500 [message #58543] |
Tue, 16 September 2003 05:02  |
Ian Ruffle
Messages: 2
Registered: September 2003
|
Junior Member |
|
|
Hi.
We are getting ORA-04030 error messages for logged on users, who are getting thrown out. trying to log back in, they get Ora-12500 messages.
We are running Oracle 9.2 and the instance was only created at the weekend.
My init.ora contains the following
db_file_multiblock_read_count = 8
db_block_buffers = 38400
shared_pool_size = 800000000 # 600M
large_pool_size = 1048576
java_pool_size = 33554432
processes = 400
parallel_max_servers = 5
log_buffer = 1310720
db_block_size = 16384
open_cursors = 100
max_enabled_roles = 100
sort_area_size = 1572864
sort_area_retained_size = 1572864
optimizer_mode = choose
resource_limit = TRUE
buffer_pool_keep = (buffers:4000,"lru_latches:1")
buffer_pool_recycle = (buffers:1000,"lru_latches:3")
We are well within our process limits, and the box is a Windows 2000 machine with 4Gig of memory, and we are using the /3G switch in the boot.ini
Does anyone have any ideas please? We have looged an iTar, but we are making really slow progress. this is a production system, and I am an inexperienced dba.
|
|
|
|
| Re: ORA-04030 and ORA-12500 [message #58559 is a reply to message #58543] |
Tue, 16 September 2003 19:34  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
It maybe that even though you have 4GB of memory,Oracle is not able to use all of it becos of certain Win2K platform limitations, inspite of the boot.ini switch.
The immediate soln would be to reduce your buffer cache(db_cache_size or db_block_buffers) and shared_pool_size to much lower values such as 200M and 100M respectively and bounce the instance. (Frankly 600M for shared pool may be too much).
Although I havent personally done this, I have heard of few things that needs to be done ,to be able to address 3GB or more on Windows platforms.
USE_INDIRECT_DATA_BUFFERS=TRUE needs to be set in the init.ora(or spfile if you use it) and
AWE_WINDOW_MEMORY Windows 2000 registry entry needs to be set appropriately to access larger memory space for Oracle SGA,PGA allocation.
I believe VeryLargeMemory support is present in version 9.2.
All the best.
Thiru
|
|
|
|
| Re: ORA-04030 and ORA-12500 [message #58575 is a reply to message #58543] |
Thu, 18 September 2003 08:06 |
Ian Ruffle
Messages: 2
Registered: September 2003
|
Junior Member |
|
|
Thanks very much for your reply.
We have moved the database back to our old NT server, which only has 2Gig of memory on it, and that has made things much better. We are hitting a limit to the number of users that can log on, but we are putting in another 2Gig of memory in tonight.
I have changed the sort area size to 128, let Oracle handle the large pool (no choice with NT).
I guess I will still need the
USE_INDIRECT_DATA_BUFFERS=TRUE
in my init.ora?
Thanks again.
Ian.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
