On database environments there should be a strict change management policy with agreed rules between database development teams and DBAs on how to maintain database objects.
Imagine you have a large number of Oracle schemas on one database instance running many different applications. Maintaining database objects on such an environment can be tricky. Below I give some tips how to do just that by using SQL scripts and the SQL*Plus utility. Read more »
According to Gartner the five major growing technical IT trends for the coming years are Cloud Computing, Virtualization, Mobile, Unified Collaboration & Communications and Service Oriented Architecture (SOA). All of them comprise of techniques that have an impact on different industries as well as user behavior in the long term.
What are they, and how the enterprises can adopt them – in my short wrap-up below. Read more »
I always thought Oracle performance tuning was more an art than a science. Being an Oracle performance tuning expert you have to recite not only database manuals but know how the database really works. Besides, you have to understand the core principles of performance management, including a time-tested methodology that is utilized to determine, investigate, and implement efficient solutions to real performance problems. Read more »