Looking at Sort Memory Performance on BLU

You may also like...

4 Responses

  1. Manohar says:

    you r right ember, BLU Is mem savvy may be that’s how its designed to be.
    Sort mem estimation came out to be more than we initially estimated in our Datamarts, LPAR is now standing at 140GB and still some intenstive queries feeling shot of sort mem and plans in place to add some more to LPAR.

    So baseline is that keep In mind it BLU might beat ur expectation when it comes to sort mem utilization 🙂 get ready with some spare mem

    • Ember Crooks says:

      Agreed. Bernie Sheifer is currently saying that the minimum memory needed is 16 GB per CPU and 16 cores for every 3 TB of uncompressed data. And that is the MINIMUM. That seems to go up every year – it was less last year.

  2. Murali Chava says:

    This query select sort_shrheap_top from table(mon_get_database(-2)) give sort high water mark but not total sort consumption at the point of time

    sort_shrheap_top – Sort share heap high watermark monitor element

    Database-wide shared sort memory high watermark in 4 KB pages.

  1. December 1, 2015

    […] Looking at Sort Memory Performance on BLU […]

Leave a Reply

Your email address will not be published. Required fields are marked *