DBA 2.0 - SQL Tuning

When CRM is running slow, Harry panics, but Sally pulls out their secret weapon--Oracle Database SQL Tuning

Category:

Science & Technology

Tags:

• Oracle
• Database
• 11g
• Release
• R2
• 11gR2
• SQL
• Tuning
• diagnostics
• query
• performance
• DBA
• 2.0

[hillrudy]

I want a fellow DBA like her.

[spain8f]

Absolutely retarded. Welcome to the world of the 'point-and-click' DBA. Applying a SQL Profile (the usual get-out-of-jail-free card) doesn't fix the underlying problem. It only disguises it. Not enough space here to rant more about how stupid this video is. Been an Oracle DBA for 20+ years and BS like this really gets on my wick. Oracle should (and does) know better. Tch! Tch!

[Relinquicide]

HAHA, Brilliant.

[AstorSkywalker]

Lol!!! just great!

[aerotux]

if there were "long running queries" you cannot fix them online like "magic". Even if you add an index, or rewrite it, or whetever "impossible" recommendation the tuning advisor gives you, the query still has to stop and restart so the optimizer uses the new plan. So solving it online is a lie. They could, instead, have use the Resource Manager feature to decrease those session's resources. Those queries will run slower but the rest of the sessions will not suffer from it.

Jose.

[rekounas]

LOL!  How do I know this isn't going to happen again. Ah, when your data and your company stop growing! Or the politically correct answer, when you stop making money.