Database Blog

• Bridge the Gap Between Database Security and Application Security

  Mar 17, 2011 / Posted By:Robert Buda

  Strong Database Security Today’s database systems have sophisticated security mechanisms designed to enable the protection of data and the tracking of the viewing and modification of the data. For example, Oracle has database roles that govern what database objects a user can see and edit.  Oracle also has auditing features that enable us to track … Continue reading Bridge the Gap Between Database Security and Application Security

  Read more Add new comment

• Database Security Issues in the Cloud: Part 1

  Mar 17, 2011 / Posted By:Robert Buda

  The benefits of cloud computing, including reduced IT ownership and operating costs and improved resource utilization, are just too good for many organizations to pass up. More and more businesses of all sizes are moving a wide range of applications to cloud environments. But database security concerns remain a significant barrier to cloud adoption. When … Continue reading Database Security Issues in the Cloud: Part 1

  Read more Add new comment

• Five Leading Causes of Oracle Database Performance Problems

  Feb 3, 2011 / Posted By:Robert Buda

  As we evaluate our clients’ Oracle databases and help them solve problems relating to performance and stability, we see many causes for these issues. However, there are a small number of basic issues that tend to cause problems on the majority of systems. Our Tech Tips document describes these issues and discusses methods of identifying them and resolving … Continue reading Five Leading Causes of Oracle Database Performance Problems

  Read more Add new comment

• Remove that Clutter: The Annual Database Security Audit and Cleanup

  Jan 3, 2011 / Posted By:Robert Buda

  As the New Year begins, many of us take the beginning of a new calendar year as a cue to to clean out and shred our old files and reorganize our storage spaces so that we have room for all the new supplies and equipment we will need in the new year. We do this … Continue reading Remove that Clutter: The Annual Database Security Audit and Cleanup

  Read more Add new comment

• Oracle RAC is Now Supported on VMware

  Nov 24, 2010 / Posted By:Robert Buda

  In a recent change to its long-standing policy, Oracle Corp. will now support its customers running Oracle Real Application Cluster (RAC) software on VMware platforms in certain circumstances. This positive move for customers was announced in a document titled “Support Position for Oracle Products Running on VMware Virtualized Environments,” which Oracle posted on its support … Continue reading Oracle RAC is Now Supported on VMware

  Read more Add new comment

• Oracle Performance Tuning — Trust but Verify

  Nov 18, 2010 / Posted By:Robert Buda

  During an Oracle Performance Tuning engagement in the past, I learned a valuable lesson about validating the information that you are given during a database evaluation. About ten years ago, a client called me with a serious problem. They had just completed development on a new Oracle application at a large pharmaceutical company and the … Continue reading Oracle Performance Tuning — Trust but Verify

  Read more Add new comment

• Oracle Performance Tuning: Periodically reorganize database objects

  Oct 21, 2010 / Posted By:Robert Buda

  One of our Oracle Consultants shared a story with me today that illustrates the importance of periodically reorganizing objects in an oracle database. He was examining a performance problem with a very small oracle table. The table had only 154 rows!. Hardly a large table, and yet it was taking over a minute to do … Continue reading Oracle Performance Tuning: Periodically reorganize database objects

  Read more Add new comment

• Oracle Security — Data Masking using Enterprise Manager

  Sep 27, 2010 / Posted By:Robert Buda

  Database administrators often have to provide test data sets to developers, QA teams, or UAT teams. This can be done manually creating test data sets, which can take a very long time especially when the goal is to stress test a new system and a large amount of data is required. An alternative approach often taken by … Continue reading Oracle Security — Data Masking using Enterprise Manager

  Read more Add new comment

• The importance of documentation, organization, and cross-training

  Sep 16, 2010 / Posted By:Robert Buda

  A recent experience on a large database development project illustrates three very important principals to follow when developing a large computer system;  keeping code well organized, keeping code well documented, and ensuring that more than one person is familiar with all portions of the code base. After about four months of development the lead developer … Continue reading The importance of documentation, organization, and cross-training

  Read more Add new comment

• Oracle Performance Tuning — Log Sync Waits

  Aug 5, 2010 / Posted By:Robert Buda

  I recently worked with a client to resolve a significant performance issue related to painfully slow queries in an Oracle database. One of the queries that they wished to execute was taking over five hours to run. This is an Oracle 10g database running on a Solaris platform. The server has 8 processors so there … Continue reading Oracle Performance Tuning — Log Sync Waits

  Read more Add new comment