Re: MTS and Memory

Howard J. Rogers wrote:
> As I said, I could have posted that you are a complete moron for even
> wanting to "bump up my SGA" without any supporting tuning diagnostic
facts
> or figures. I tried to be polite about it, and yes... moronically
enough,
> you dismiss someone who *is* actually helping by giving you the right
> answer. It just happens not to be the answer you wanted to hear.
>

I'm sorry Howard, but you didn't help. You failed to understand the question and responded with scarcasm. I've unfortunately had to work with self-professed oracle experts like you before and I must say, its not an enjoyable experience. I pitty those around you.

Blame your speed reading skills or your lousy interpretation of my question if you want but it doesn't dispute the fact that you jumped to conclusions. (I'll take part of the blame for not making my question more specific..)

(Note: I took a quick glance through the oracle documentation and no where do I see a 50% value tossed around.. they just say to make sure your SGA and user connections fit in main memory..)

<Lotsa stuff deleted..> I almost gave in and provided you details about our environment and why I had orginally asked the question:

"Now my question is, since i'm using MTS how far can I bump up my SGA.. Correct me if i'm wrong but only a portion of the PGA will be allocated outside of the SGA. So are there any formulas which will help me determine how large my SGA can be?"

But it doesn't take a rocket scientist to realize i'm asking a general question. In a perfect world I would have gotten 1 response with a formula on how to size an SGA within an MTS environment. I've done it for dedicated connections before and it worked like a charm but I haven't been able to find relevant information for MTS. But, since this isn't a perfect world I recieved a half ass response from a self-professed wannabe.

It doesn't matter if i'm hitting 4031 errors or experiencing performance problems. Having a 'formula' would allow me to properly size my SGA instead of your method of hit and miss. Sure, I could have made an education guess and allocated to much or little to the SGA. Waited to see if I hit any 4031 errors and (de)allocated where necessary. But thats not how I like to operate, especially since this one environment brings in 500M$ a year in revenue. But hey, if thats how you like to work more power to ya.

The reason I choose the term 'how far can I bump up my SGA' is because the database/application has outgrown the hardware/OS. The replacement is being tested (were actually doing loadtesting today with dedicated connections..) but it isn't expected to be ready for another month. So unfortunately i'm stuck with supporting this environment until we upgrade. If I had a reliable way to calculate my memory requirements then I would know how far I could push this environment without hitting adverse performance problems. But see, you didn't need to know that information to answer my question. You just jumped to conclusions determined I was tossing memory at a problem that may not have existed. Received on Mon Sep 13 2004 - 13:19:13 CDT