PGA_AGGREGATE_TARGET is not a hard limit. Lather, rinse, and repeat I like to think of it as a tuning suggestion to Oracle as to how much it can allocate for things such as sorts and hash tables. Below is a test case that shows this. 1 2 3 4 5 6 7 8 9... »
Archive for February, 2011
bbed password
Tuesday, February 1st, 2011
It never ceases to amaze me how difficult some responders on message boards make it to use certain tools. Requests for information are usually denied with something similar to “If you have to ask that, you shouldn’t be _fill_in_the_blank_”. How pompous, especially as a response to someone trying to learn, often on their own... »