oracle

On Real-Time SQL Monitoring and the /*+MONITOR*/ Hint

Oracle 11gR1 Enterprise Edition with the Diagnostic and Tuning packs has a very compelling new feature, Real-Time SQL Monitoring. Oracle thinks enough of the feature that it was highlighted prominently in whitepaper by ACE Directory Arup Nanda titled “Oracle Database 11g: The Top Features for DBAs and Developers” (read it here) Long story short: Too [...]

Database Driver’s License

Do you just hand your keys to whoever wants access to your car or your house? Why do so with your database? Just because someone wants to look at ‘your’ data, doesn’t mean you have to let them in without asking a few questions, right? While the person won’t be driving your car, they’ll be [...]

BEFORE SELECT TRIGGERS

After a year of blogging and living out loud on Twitter, I have started to build a nice network and community. One of the people in my new network is Martin Berger (blog | Twitter). Earlier this week, Martin responded to my Toad Challenge with a question about ‘Before Select Triggers’ (conversation) So let’s get [...]