Even Oracle Certified DBAs cringe at the thought of performing a real-world database recovery. As disk and hardware has become super-stable, many Oracle DBAs have never experienced the adrenaline rush of a full-blown Oracle recovery.
Many Oracle shops are plagued with slow I/O intensive databases, and this tip is for anyone whose STATSPACK top-5 timed events shows disk I/O as a major event.
With Oracle Database 10g, there are some new arguments available for the dbms_stats package subprograms. Those parameters are as follows:
In this article (chapter) we will look at new features surrounding the DML commands INSERT, UPDATE, and DELETE.
Two improvements have been made in the backup and recovery areas in Oracle 10g. When user errors and logical corruptions occur in the database, flashback functionalities provide fast and flexible data recovery. When physical or media corruption occurs in the database, RMAN delivers an improved and simplified recovery method.
If you've been developing applications on Oracle for a while, you've no doubt come across the concept of 'Bind Variables'. Bind variables are one of those Oracle concepts that experts frequently cite as being key to application performance, but it's often not all that easy to pin down exactly what they are and how you need to alter your programming style to use them. With this in mind, I've tried to pull together the key information about bind variables and why they are a 'good thing' when building Oracle applications.
Being an emergency support DBA is a job with huge stress-levels and it always provides a giant adrenaline rush for even the most experienced DBA. Senior management is in a panic, and high-level executives are continuously asking for a status update. Most of these databases are brand-new to me, and I have only a few minutes to access the situation and devise a plan to quickly relieve their bottleneck.
Oracle Database 10g has expanded the ability to globalize Oracle databases dramatically. As you can see by looking over the following list of globalization improvements, Oracle has attempted to make Database 10g the database of choice for all globally supported and utilized databases.
Oracle databases have many types of auditing features. In mandatory auditing, certain actions are always audited, regardless of the other audit options or parameters. Database activities, such as system startup and shutdown, are always recorded.
SQL tuning is one of the challenging tasks faced by DBAs and developers. It is an interesting and creative, but at the same time, daunting task. Manual tuning of SQL statements requires a high level of expertise and experience to understand and design suitable access paths to yield better response times. It is also a time consuming process. Other challenges include periodic collection of statistics and an ever-changing workload. And in a typical application, there are just too many SQL statements to tune.