Home » RDBMS Server » Server Administration » Maximum data segment size
Maximum data segment size [message #156233] Mon, 23 January 2006 20:34 Go to next message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member
Hi all,

Our users encountered ORA-04030: out of process memory when trying to allocate 63350 bytes(callheap,temporary memory). This occur when they retriving data from a purchase order. What I found out from metalink was the maximum data segment size currently is insufficient.

Where to find the data segment size? I can't find any of this parameter inside init.ora.

Thanks!

Report message to a moderator

Re: Maximum data segment size [message #157629 is a reply to message #156233] Fri, 03 February 2006 10:33 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
One of the important parameters is
db_block_buffers=160000
(you must set them propely to you). Size of your buffer cache will be db_block_buffers*db_block_size.

Report message to a moderator

Re: Maximum data segment size [message #157767 is a reply to message #156233] Sun, 05 February 2006 20:56 Go to previous messageGo to next message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member
In this case my db_block_buffers=80000, db_block_size=8192.
Is this setting resonable?

Thanks again!

Report message to a moderator

Re: Maximum data segment size [message #157869 is a reply to message #157767] Mon, 06 February 2006 16:20 Go to previous messageGo to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
It appears to me that you have 625MB allocated for your db buffer cache. (80000*8192)/1024/1024

You may need to allocate more memory to your instance if your server can handle it.

Check out this link:

http://www.oracle.com/technology/products/oracle9i/daily/dec31.html

Report message to a moderator

Re: Maximum data segment size [message #157884 is a reply to message #156233] Mon, 06 February 2006 20:26 Go to previous message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member
To allocate more memory, does this means to increase my db_block_buffers?

The memory of my server is 28G.

Thanks a lot!

Report message to a moderator

Previous Topic: lobindex
Next Topic: Creating 9.2 DB from the command line
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 14:02:16 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.