back to article How not to let your Oracle database spin out of control

Growing pains: How not to let your Oracle database spin out of control Oracle databases are a lot like children. They toddle along quite nicely, being polite and well behaved, until suddenly, they hit a massive growth spurt. They become teenagers and can make their administrators' lives a living hell. They double in size …

COMMENTS

This topic is closed for new posts.
  1. Down not across Silver badge

    Another Dell advert ...I mean workshop

    Yes the small print says "series of Oracle DBA workshop articles in association with Dell Software." but if they're allegedly workshops rather than adverts then really it would be prudent to mention other alternatives. If it hurts too much to mention competition (whether free or paid for) then why not at least mention that Oracle's own OEM could be used for all the instances of "..such as Toad" was used.

    As it is the whole series just stinks of desperate attempts by Dell to (re-)sell Toad. Which devalues the series which does contain valid pointers for less experienced Oracle DBAs.

  2. roselan

    yup, if someone find something useful or he didn't know for his daily work in these ads, there is a serious issue in his knowledge.

    Real question, how do you manage 5000 databases? that's 5 millions indexes, or sql plans, 15 millions sessions, and 200 millions constraints. You don't want to manage that manually, or even with a croaking tool. You need to automate. Automate all what you can, and create strict procedures/api for the rest/future (to clone and move databases by example).

    I see many organisations with dbas actively tuning/managing databases. But as pointed out by the article, this is not the way to go.

    The issue is not that databases grow, it's that they multiply.

    And that why you shall not, most importantly, and no matter how much it cries or begs, never, ever feed it with inserts after midnight. /

This topic is closed for new posts.

Biting the hand that feeds IT © 1998–2021