Ask the Expert

Tuning Oracle server 7.3.4.4. on SCO OpenServer 5

I am running Oracle server 7.3.4.4. on SCO OpenServer 5. Oracle's utility tstshm looks as follows:

"Number of segments gotten by shmget() = 50 Number of segments attached by shmat() = 50 Segments attach at higher addresses Maximum size segments are not attached contiguously!

Segment separation = 4194304 bytes
Default

    Requires Free Membership to View

shared memory address = 0x80000000
Lowest shared memory address = 0x80000000
Highest shared memory address = 0xc0000000
Total shared memory range = 1075838976
Total shared memory attached = 104857600
Largest single segment size = 2097152
Segment boundaries (SHMLBA) = 4194304 (0x400000)"

Is there any way to attach segments contiguously by tuning?


tstshm doesn't tell you anything about how your SGA is allocated in shared memory. The one thing it can tell you is what your largest single segment size is, and yours appears to be 2097152. That's very small. I'm not sure where the kernel tuneables are on SCO, but you'll want to find how to set shmmax to a value equal to (or at least much closer to) your physical RAM size. That will allow Oracle to allocate fewer, larger segments which can increase efficiency somewhat.

Your focus should be on using fewer segments, not on where they are placed in memory.

By the way, upgrade--really, I mean it.


This was first published in September 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: