Re: Measuring memory used by temp_table_size
Posted by:
Rick James
Date: April 25, 2013 09:28PM
Monitor the actual memory usage. The formula you are working with is pessimistic and can mostly be ignored.
Yes, increasing the buffer_pool is likely to help performance, but not after it is bigger than all the data and indexes. Also, you may be into "diminishing returns". That is, doubling the buffer_pool will _probably_ not double the speed.
Subject
Views
Written By
Posted
2380
April 23, 2013 12:24PM
1004
April 24, 2013 09:48PM
962
April 24, 2013 10:36PM
Re: Measuring memory used by temp_table_size
820
April 25, 2013 09:28PM
814
April 26, 2013 10:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.