|
This month we take a close look at Oracle Database 11g: The Complete Reference written by Oracle guru Kevin Loney. Take advantage of the huge Oracle Press Community Member discount of 40% today and you'll find that this book provides an overview of database architecture and Oracle Grid Computing technology, and covers SQL, SQL*Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java programming in the Oracle environment. You will also find valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics. All for 40% off the list price!
For a sneak peek at Oracle Database 11g: The Complete Reference before you buy, click on the link below to read an exclusive excerpt of chapter 33 - Online Application Upgrade. And don't miss our exclusive interview with author Kevin Loney below. | | |
|
|
|
| About the Author
Kevin Loney was named Consultant of the Year by ORACLE Magazine in 2002. He is an internationally recognized Oracle expert who frequently presents at Oracle user conferences in North America and Europe where he is regularly among the highest-rated presenters. | | | » TOP |
| Author Interview
Read on for our exclusive interview with author Kevin Loney. | | | - How long have you been using Oracle?
I started as a developer in 1987. Since then I've worked with all aspects of database and application design, development, implementation, tuning, and planning. I've started writing for Oracle Magazine in 1990, and I've been with Oracle Press since its inception in 1994.
- What's the biggest problem that gets the least visibility?
In a surprising number of cases, databases are upgraded to the latest release for compliance reasons but the new features aren't used. Not only that, but the internal parameters are explicitly set to bypass the upgrades; for example, telling an Oracle 10 database to act as an Oracle 9 database or and Oracle 8 database. As a result, you get none of the benefits of the current version and you have increased costs during maintenance, problem debugging, and performance tuning.
- Why would people do that?
It's an effort to guarantee stability during an upgrade, but it's ultimately misguided as it only defers the problem rather than solving it. You end up with a patchwork database that introduces new problems. In general, you would be better off with a fresh install and migration.
- What database characteristics should DBAs focus on?
Recoverability, performance, and availability. Everything about the database - from the application design to the data model to the way backups are executed - should be seen through the lens of those three characteristics. The features introduced in Oracle 11g that address these areas are significant: change replay, enhanced testing support, enhanced backups, online upgrades, and database vaults all are critical components that can enhance recoverability, performance, and availability.
- What should we be talking to the business users about?
Whenever possible, try to understand exactly how the application is serving the business process. The better you understand what the business is actually trying to do, the more likely you are to find processing steps that can be eliminated or can be targeted for tuning. When you look at new features like the client-side query cache in Oracle 11g, you can then target their use for specific business processes, and you can provide a measurable performance improvement.
| | | | » TOP | | | | | |
Tell your friends about Oracle Press Community
The Oracle Press Community is a growing resource for Oracle and Database professionals world-wide. Please feel free to forward this newsletter to colleagues who may wish to join the Community and enjoy its benefits.
Manage Your Subscriptions
You have received this message because you opted-in to receive information and special offers from McGraw-Hill Professional. We hope you enjoyed receiving this message. However, if you would like to unsubscribe from receiving e-mails in this interest area from McGraw-Hill Professional, please follow this link. http://www.mhprofessional.com/account/?mode=interest&action=unsub&e=ignoble.experiment@arconati.us By clicking the link below, you can view the many interest areas available from the McGraw-HIll Professional Bookstore and manage your subscriptions and communication preferences. Once you login, choose Interest Areas from the right hand navigation. http://books.mcgraw-hill.com/myaccount.php You can also write to us at: Privacy Officer, McGraw-Hill Professional, 2 Penn Plaza, 12th Floor,
New York, NY 10121-2298. Copyright © 2007 The McGraw-Hill Companies. All rights reserved.
Terms of Use and Privacy Notice.
| |
No comments:
Post a Comment
Keep a civil tongue.