First of all let me give a warm hello to all of you guys.
Coming to my subject, it is relevant to Oracle databases management in general for very large companies (e.g. TLC operators).
They usually face the following kind of problems:
- licences number proliferation, usually it gets out of control
- several different Oracle databases that ask for consolidation
- opportunity of "storage tiering", meaning moving less valuable database data on less expensive storage means
- data classification, meaning how can I assess (automatically? manually?) which data are valuable and which are less ?
- other opportunities you only might be aware of
Do you guys have experience in facing that kind of problems? Any suggestion regarding hw/sw solutions for that purpose?
In an ideal world you're right, but in practice you're not.
We're facing an years-old situation of non-consolidation. We have to tackle it somehow, so theory is of little help here.
Think at tons of Terabytes of data and you'll understand that the issue is not to gather business requirements (we do have them already!) but to find an automatic and smart solution to classify informations and store them accordingly.
Unfortunately the "less accessed" criterion is usually not enough, due to law enforcements.