Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.
Since few months, I test the future new version SQL Server 2012 codename Denali and I was very surprised form the news DMVs from this version.
I will just explain some DMVs very interesting for a DBA.
My article is based on msdn web site reference and you find in the end from each chapter a msdn reference for more details of the DMV.
Ayant rencontré récemment des problèmes de blocs corrompus sur des bases Oracle en version Oracle 10g et Oracle 11g, des différences notables sont apparues notamment au niveau de la vue v$database_block_corruption. Je vous livre dans ce post le résultat de mes tests.
A few days ago I downloaded the Cloud Control 12c binaries for Linux x86_64 from the Oracle Technet.
My friend, Hervé Schweitzer, configured an OEL 5.7 VM for test purpose and I was quite eager to install this new software. I checked the O.S settings, the required parameters, aso …, everything was fine. My OMS repository database (220.127.116.11) was ready. Unfortunately, as soon as I started the installer, it directly crashed.
Last week, I attended for the first time the Microsoft TechDays. The 2011 Swiss “edition” took place in Bern. For me it is new challenge, because I newer worked deeply with the Microsoft Database Platform “SQL Server”.
During our test to create a failover clustering with the new function ‘AlwaysOn High Availability’, we had a few difficulties to overcome like the restoring of databases of the secondary cluster node.
In this article, we will just explain you how to avoid it before you encounter the problem.
As we are on Microsoft Connection Days 2011 in Lausanne yesterday, we have a presentation of Windows Server 8 and specifically of Hyper-V 3.0.
I take this opportunity to introduce some news about this.
So we are now arrived at the end of the largest Oracle OpenWorld ever. Around 45’000 people had joined San Francisco to exchange around IT and especially Oracle technologies.
It has been a great conference with much of interesting sessions and as each year several announcements: Enterprise Manager 12c, Exalytics and Oracle Public Cloud.
For my last post about OOW11, I want to talk about the last session I attended. Who said that the late sessions are usually having less interest? I personally was lucky enough to attend a great presentation held by Oak Table member, Alex Gorbachev. Alex used ASM to demonstrate how hardware and software fault tolerance mechanisms, especially mirroring, are affected by different parameters such MTBF.
This has been a long day, started with gathering some news about the Enterprise Manager 12c and finished with a huge concert on Treasure Island. However the highlight of the day was clearly Larry Ellison’s Keynote. Since this afternoon (pacific time), Oracle is officially proposing a Public Cloud, which integrates an Oracle Social Network…
In my second blog about OpenWorld, I gave an overview of the Engineered Solutions portfolio, which just got enhanced with Exalytics. Today I’m going to focus a bit more on the Database Appliance product and how this box works. I had the chance to go a session called “New! Database Appliance: Secrets revealed”, which provided more information on its architecture and functionalities.
After that I want to highly a interesting use case made by DELL and pointing out the usage of the brand new Oracle Enterprise Manager 12c for Cloud computing.
But before that let’s have a look on the Database Appliance secrets…