In spite I’m an Oracle database expert I work also partly with Microsoft SQL Server and Sybase.
This gives me the opportunity to compare different RDBMSs and on the other hand identify weak areas in Oracle compared to others.
This article is about missing functionality or features that probably every Oracle DBA would like to have in the future Oracle database releases (Oracle Server 12c for example). And I’ll start with the database access control that is not so flexible on Oracle as in Microsoft SQL Server or Sybase. Read more »
I’ve recently notices a common issue on Oracle Enterprise Linux 5.x with Oracle database 10gR2 and 11gR2. The Oracle ADDM Performance Analysis showed the following alert as a top event in both OEM console – Virtual Memory Paging and in the ADDM report – Significant virtual memory paging was detected on the host operating system.
From the first look I thought this was a virtual memory issue on the boxes but on the other hand I could not find any evidence at OS level of any problem with virtual memory paging. Additionally I was surprised that the issue occurred at the same time on different servers and Oracle versions. So, below I did some checks to prove there was no memory issue on these Linux boxes. Read more »
Since a fairly long time, two little words are on their way: Cloud Computing. Cloud Computing is a concept from IT-Management and has the aim – described easily – that the IT-domains will not be operated via the user anymore but rather via one or more service providers. The data and applications will not be found on the local computer or data processing service center but rather will be stored in the so-called Cloud.
The concept of Cloud Computing has the aim to present the liberty, to provide services from any place in the world. However, the liberty of these Clouds will be initially limited in Europe. Reason for that is the restrictive Data Protection regulation. Read more »