There’s no fighting progress. Decades ago database administrators managed and controlled everything – the OS, network, storage and database. Times have changed and DBAs have had to evolve (i.e. accept...
I’ll be speaking at the annual Hotsos Symposium in Dallas TX February 27th and 28th. To quote their website: Hotsos is the best conference in the Americas devoted to Oracle system performance. The co...
In my last blog titled “Varying Database Benchmark Results” I tried to explain why people can often get varied performance results when running a specific database benchmark multiple times. I attempte...
I’ve been asked on numerous occasions why do peoples’ database benchmark results often vary. In other words why one observed transaction per second (TPS) value today and sometimes 20% or more off tomo...
For some time now Toad’s SQL Editor has offered several very basic SQL code refactoring capabilities. But to be honest those refactoring features did not see extensive use or adoption as they were so ...
An Oracle explain plan is very much like a Google map of directions to drive from point-A to point-B (in the old days, before the web, we used to go to a local AAA to get a “Trip Tik” map). However a ...
A: In version 11, go to Help and search on "customize" or in the Contents, go to: Toolbars, Menus, and Shortcut Keys > Customize Toolbars and Menus. There are six topics on customizing items. Regardi...
Let’s face it – it’s a rough and scary computer world we live in today. We have people routinely losing notebook computers with massive local copies of confidential records, computer hackers aggressiv...
A few years ago I wrote a blog titled “Run Toad off a USB Flash Drive”. It’s been a fairly popular blog, but it’s also quite out dated now – so I thought I’d update it. The original blog had several ...
