|
|
 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
|
Author: |
MikeA |
Created: |
Wednesday, October 18, 2006 4:54 PM |
|
|
Providing tips, techniques and insight into management and tuning issues affecting your database systems. |
|
Watching Your ASMM in Oracle10g |
|
MikeA
|
Monday, November 27, 2006 8:44 AM
|
|
|
|
Oracle’s Oracle10g requires more memory than was ever required before. If you utilize any of the new features such as automatic storage management (ASM) and automatic shared memory management (ASMM) then you really need to pay attention to what memory is doing in 10g.
|
 |
|
|
Read More...
|
|
|
The Brave New World of Oracle Management |
|
MikeA
|
Wednesday, November 15, 2006 3:50 PM
|
|
|
|
I remember reading “Brave New World” when I was in high school, we needn’t mention the year. I was fascinated by the system described in the book that seemed so logical on the surface but needed so many props underneath to keep it going. It reminds me at times of some of the Oracle management that goes on these days. ...
|
|
|
|
|
Read More...
|
|
|
Why Can’t Johnny Tune? |
|
MikeA
|
Wednesday, November 08, 2006 1:46 PM
|
|
|
|
I often see DBAs and developers who don’t know the first thing about tuning SQL. They ask “Why do I need to know that, can’t Oracle tune itself?” The truth of the matter is that Oracle is, for the most part, able to do a pretty decent job of tuning itself if it is given enough information and the queries or tuning tas ...
|
|
|
|
|
Read More...
|
|
|
Are DBA’s Obsolete? |
|
MikeA
|
Wednesday, November 01, 2006 3:30 PM
|
|
|
|
With each new release of a database, be it Oracle or one of their competitors, we hear the cry that this release will make DBAs as we know them obsolete. We hear again and again how this automated feature set or that new GUI interface will automate the DBA job. So far, all of these claims of DBA obsolescence have been for naught, to mis-quote Samual Clements “The reports of the DBAs death are greatly ex ...
|
|
|
|
|
Read More...
|
|
|
Changes in SQL Tuning |
|
MikeA
|
Wednesday, October 18, 2006 4:54 PM
|
|
|
|
When I started working with Oracle in 1990 there weren’t many SQL tuning tools available. At most you had the Oracle supplied tools which allowed you to capture an explain plan and minimal tracing. Most SQL tuning consisted of either encouragin ...
|
|
|
|
|
Read More...
|
|
|
|
|
|
|
|
|
|
|