Thank you, Jared.
Cary Millsap
Method R Corporation
Author of *Optimizing Oracle Performance <http://amzn.to/OM0q75>*
and *The Method R Guide to Mastering Oracle Trace Data, 3rd edition
<https://amzn.to/2IhhCG6+-+Millsap+2019.+Mastering+Oracle+Trace+Data+3ed>*
On Wed, Feb 17, 2021 at 9:41 PM Jared Still <jkstill@xxxxxxxxx> wrote:
Hi Cary,
Possibly consider using some solver for the knapsack problem.
That is how we are planning the shuffling of PDBs and databases to reduce
license costs.
Collect metrics, and the knapsack solver assigns directs where to out
databases.
You didn't hear that from me. :)
Not exactly giving away a lot there I suppose, but apparently it works
pretty well.
I will be using on a client soon, so interested to see for myself.
Jared
On Wed, Feb 17, 2021 at 12:45 Cary Millsap <cary.millsap@xxxxxxxxxxxx>
wrote:
Hi everybody, from freezing cold Texas.Jared Still
I have a friend who's embarking on a big project to reduce the number of
servers and licenses his company has to pay for and maintain (presumably
using VMs and PDBs and all that). Do you know of any good sources for
studying up on how to do a good job on a project like this?
Thank you,
Cary Millsap
Method R Corporation
Author of *Optimizing Oracle Performance <http://amzn.to/OM0q75>*
and *The Method R Guide to Mastering Oracle Trace Data, 3rd edition
<https://amzn.to/2IhhCG6+-+Millsap+2019.+Mastering+Oracle+Trace+Data+3ed>*
--
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill
