Sponsored Content
Operating Systems AIX Oracle performance optimum vs. SGA memory allocation Post 302560106 by zxmaus on Thursday 29th of September 2011 01:12:45 AM
Old 09-29-2011
You should not size the SGA according to what you have in the box but according to what your DB needs. If your SGA is too big this can dramatically slow down performance. If it is not big enough, the same is true. And apart from an SGA you do have a PGA too - sometimes it makes more sense to give more memory to the PGA instead of extending the SGA and so on.

Oracle is a thread based DB, so how much resources you need obviously depends on how many connections you have in parallel - a box with 20 connections per day needs a lot less than a box with 3000 connections in parallel - each of those connections is forking a process, each of those processes can use up to (size of one pp in the corresponding VG) memory - and if your box is doing anything else apart from the DB - and what kind of load your DB has - Data warehouses have a very different utilization pattern than Traders for example. And are you doing EOD batches, what kind of backups are you running, how big are your tables and so on.

Regards
zxmaus
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

memory allocation

I would like to know how I could allocate some more memory to a process. Please note that I am not the root user. (1 Reply)
Discussion started by: sagar
1 Replies

2. UNIX for Dummies Questions & Answers

HP-UX memory usage allocation

Hi all, I have a HP-UX Server with 4 gigabytes of physical RAM. When I use the 'Glance' utility to see what my memory utilization is, my memory usage shows up maxed out at 99%. I shut off all the known processes that I'm running on that box and the memory utilization is still at 78% (with Swap... (1 Reply)
Discussion started by: dehuang83
1 Replies

3. HP-UX

HP-UX memory usage allocation

Hi all, I have a HP-UX Server with 4 gigabytes of physical RAM. When I use the 'Glance' utility to see what my memory utilization is, my memory usage shows up maxed out at 99%. I shut off all the known processes that I'm running on that box and the memory utilization is still at 78% (with Swap... (3 Replies)
Discussion started by: dehuang83
3 Replies

4. Programming

memory allocation in subroutine

Hi everyone, I'm not new to C programming, but I'm having question regarding the memory allocation of a pointer variable which, for instance, will be declared in main(), but its memory will be allocated in subroutine. To clearify my question, I provide a small working example: #include... (1 Reply)
Discussion started by: MIB_Maik
1 Replies

5. Programming

Memory allocation in C

Hi Experts I need some help in static memory allocation in C. I have a program in which I declared 2 variables, one char array and one integer. I was little surprised to see the addresses of the variables. First: int x; char a; printf("%u %u\n', &x, a); I got the addresses displayed... (2 Replies)
Discussion started by: unx_freak
2 Replies

6. Programming

Memory Allocation Query

When we dynamically allocate the memory say 100 integers say int *x = new int(1000); then does entire chunk of memory gets allocated at once after the completion of the statement? I mean will the the concept of page fault come into picture over here? (3 Replies)
Discussion started by: rupeshkp728
3 Replies

7. Shell Programming and Scripting

memory allocation to a variable

hello all.. i'm a beginner in shell scripting. I need to know what is really happening when we are creating a variable in shell scripting? how memory is allocated for that variable? (3 Replies)
Discussion started by: aarathy
3 Replies

8. Programming

memory allocation for string in C

hi in the following code, how the memory is allocated for a1 which holds the values of a2 after cpy function call. #include <stdio.h> #include <string.h> void cpy(char* d, const char* s){ while(*d++=*s++); } main(){ char* a1; char* a2="done"; cpy(a1,a2); ... (3 Replies)
Discussion started by: mprakasheee
3 Replies

9. UNIX for Dummies Questions & Answers

Memory allocation problem

I am using ubuntu. I have written a program to calculate prime factors. it works perfectly fine till entered number is less than 9989 (or so ) but when one enters a number higher than that, for example 15000, it does not work. Can anyone guide me whats the problem ? although new codes are welcome,... (2 Replies)
Discussion started by: Abhishek_kumar
2 Replies

10. UNIX for Advanced & Expert Users

Mapping Oracle SGA memory into physical files in Solaris.

Is there a way by which we could map Oracle SGA memory into physical files in solaris. We could find these physical files in /dev/shm/ folder in linux environment but they are missing in solaris. (1 Reply)
Discussion started by: arjun_chauhan
1 Replies
GENBOX(1)						      General Commands Manual							 GENBOX(1)

NAME
genrbox - generate a RADIANCE description of a box SYNOPSIS
genrbox mat name xsiz ysiz zsiz [ -i ][ -r rad | -b bev ] DESCRIPTION
Genbox produces a RADIANCE scene description of a parallelepiped with one corner at the origin and the opposite corner at (xsiz, ysiz, zsiz). The sides of the box will be parallel to the three coordinate planes. The surfaces that make up the box will be modified by mat and their identifiers will begin with name. The -i option can be used to produce a box with inward directed surface normals. The -r option can be used to specify the radius for rounded edges. The -b option can be used to specify the indentation for beveled edges. EXAMPLE
To produce a rectangular box made of wood with beveled edges: genrbox wood box1 5 8 3 -b .5 > box1 AUTHOR
Greg Ward BUGS
Because spheres and cylinders are used to construct boxes with rounded edges, a transparent box of this type appears quite messy. SEE ALSO
genrev(1), gensurf(1), genworm(1), rpict(1), rvu(1), xform(1) RADIANCE
11/15/93 GENBOX(1)
All times are GMT -4. The time now is 04:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy