Microsoft SQL Server
Courtesy of our friends at Oracle cost containment company Miro Consulting, I am giving a webinar tomorrow at 1pm EST (click this link for the time in other timezones please. The subject I’ve chosen is how to apply the best practices around advanced supply management that are extremely successful and mature in the product supply chain world to the equally extremely immature practices we typically find in enterprise IT supply provisioning. It should be a great presentation; I give an overview of the famous “Toyota Way” and cover some recent findings from the California Management Review as well. Keep reading for a full overview.
Do you need to know why the standby periodically lags during the day, if the standby redo apply rate lag during the day and when, or how fast is the current archived redo log being applied? If you answered yes to any of these look no further. The following SQL script will help you answer these questions.
I’ve been told that using NOT EXISTS in (Oracle) SQL is a bad idea, and that a way to overcome this problem is to collect the non-matching rows with an OUTER JOIN. So I decided to check if it is true.
I do realize that for most of you, there may be nothing new about the dbms_sys_sql package knowledge of it has been floating around for quite a while. I myself discovered this package a couplI do realize that for most of you, there may be nothing new about the dbms_sys_sql package knowledge of it has been floating around for quite a while. I myself discovered this package a couple of years ago while playing around with HTMLDB’s (now APEX’s) internals. I’m posting this as a response to a vox populi demand: I often see people who could benefit from dbms_sys_sql, if they only knew about it.e of years ago while playing around with HTMLDB’s (now APEX’s) internals. I’m posting this as a response to a vox populi demand: I often see people who could benefit from dbms_sys_sql, if they only knew about it.
There’s an interesting dynamic going on right now in the DBA world. MySQL’s growth and installed base, as a function of its size three or five years ago, is perhaps five if not ten times larger than it was. In 2002 when Pythian’s MySQL services launched, we took on the platform at the explicit request of an existing customer that was primarily an Oracle shop, but that was adopting MySQL for some bolt-on systems. Today, MySQL is our fastest-growing practice in terms of new customer acquisition. The point I want you to take away from that is simply this: there are about five to ten times more high-value environments running MySQL in the world today than there were three years ago.
So what is SQL Performance Analyzer (SQLPA)? The DBMS_SQLPA package enables you to register and compare the statistics of several SQL query executions stored in an SQL Tuning Set (STS). With SQL Performance Analyzer, you can compare the executions of queries before and after you make some changes to your database. As you might guess, I’m going to illustrate this new feature in Oracle 11g with a simple example.
So Management chooses to review the documentation generated from your database failover test and see that the time to switchover is slow and that there is still a possibility of losing some data. Enter standby redo logs. Rather than regurgitate the documentation, I have attached the links to the specific parts of the documentation. Since I’m focused on providing ways for you to “get the job done”, I have also included some SQL that uses dynamic SQL to generate a series of ALTER DATABASE ADD STANDBY LOGFILE commands to run on both the primary and standby databases. Have a look.
Wouldn’t “Automatic SQL Plan Management” be the 11g “killer app”? I’m just wondering… be careful it is part of Oracle Tuning Pack 11g! Before you answer this question, lets illustrate with an example how the “non-automatic”, “no tuning Pack” SQL Plan Management works.
“Real Time SQL Monitoring” is a 11g Tuning Pack new feature. You can easily access it when the Tuning Pack is set. Anyway, It’s very impressive even if it doesn’t look to be fully functional (Is it me ?). I guess Enterprise Manager provides a fantastic GUI for this feature. This post is for you if you don’t always use it…
I just read a fascinating article on clustering architectures for databases from Kevin Closson of Polyserve (now HP). All I can say is that he has one of the most informed and incisive views and insights on clustering, SMP, high-availability and high-performance environments in the industry. I thought I would share this with the broader community because I think a lot of MySQL, SQL Server and EnterpriseDB folks who need to read this and think about this subject might otherwise miss it, simply because they may not be regular readers of Kevin’s blog.