Memory allocation

[srinivas_42]

All,
Thanks for the replies.

Ariel Cary, CURSOR_SPACE_FOR_TIME is set to FALSE in my case, I think if we want to minimize the memory occupation may be FALSE makes sense. Regarding the swap memory allocation D or L settings, I need the document you pointed in the link, the link seem to be outdated can you provide the latest one.

Leon Allen, My current settings for dbc_max_pct 10, dbc_min_pct 10.

We are using Hyperion application, I am not sure if it is considered high memory based transaction application. But this server has only Database though.

Bottom line is, I am trying to get the comfort feeling that such a high reserve of memory for each oracle database process/connection is normal, if not normal then what to modify exactly.

[Ariel Cary]

Hi,

Sorry I just realized a ')' sticked in the previous URL. Please check out:

http://download-east.oracle.com/docs/html/A97350_05/toc.htm

section : "Large Memory Allocations and Oracle9i Tuning"

Regards,

-Ariel

[Brian Crabtree]

Srini,

What is the sga_max_size and pga_aggregate_target set to currently?

Also, what memory error are you getting? (ORA-04031, etc).

Thanks,

Brian