Buy New

Sign in to turn on 1-Click ordering.
Buy Used
Used - Very Good See details
Price: £3.95

More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Practical Oracle8i: Building Efficient Databases [Paperback]

Jonathan Lewis
5.0 out of 5 stars  See all reviews (6 customer reviews)
Price: £31.99 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 2 Nov.? Choose Express delivery at checkout. Details

Book Description

18 Dec 2000

In this book, one of the world's leading Oracle database consultants covers the real-world design and development issues most Oracle books ignore! Jonathan Lewis presents powerful techniques -- and errors to avoid -- if you want to build databases that meet their objectives, stay on budget, scale to support growth, and are easy to manage. Jonathan Lewis focuses on helping database designers and developers answer two essential questions: "How should I think when designing an Oracle-based application? And, how can I select the most appropriate Oracle features for my application, taking into account their interrelationships?" Drawing upon fifteen years experience as an Oracle database designer and consultant, he delivers an intimate understanding of the Oracle database engine, and all the guidance you need to use its key features most effectively. Coverage includes: tables and tablespaces, indexing, temporary space, files, views, partitioning, lots, simple and collection objects, LOBs, integrity, PL/SQL, autonomous transactions, RLS, PQO and OPS, replication, fallback, and much more. For every Oracle database designer, developer, and manager; and for any professional called upon to maintain or optimize Oracle-based databases.

Product details

  • Paperback: 672 pages
  • Publisher: Addison Wesley; 1 edition (18 Dec 2000)
  • Language: English
  • ISBN-10: 0201715848
  • ISBN-13: 978-0201715842
  • Product Dimensions: 18.7 x 3 x 23.4 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Bestsellers Rank: 1,366,936 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Back Cover

What is really involved in building effective Oracle database systems, and how do you approach the endeavor in a way that increases your chances for success?

Practical Oracle8i™ offers a real-life approach to constructing Oracle databases--one that is geared toward solving important business problems. This book will help you devise appropriate strategies for database design that takes into account Oracle's technical underpinnings, hardware and user limitations, and tradeoffs between simplicity and efficiency. It discusses selecting the Oracle features needed to perform specific functions and demonstrates how to structure code most effectively for the features being implemented.

Practical Oracle8i™ presents an overview of Oracle that clearly explains the central functions that are key to Oracle's operation. In addition, the book presents the fundamentals of the system, covering the way in which data is stored, packed, and made visible, as well as the dynamic features involved in transactions and calculations. Specific topics covered include:

  • A discussion of why Oracle projects fail
  • Leveraging tablespaces
  • Partitioning
  • LOBs
  • Autonomous transactions
  • Row-level security for virtual private databases
  • Parallel query and parallel server
  • The new analytical functions introduced in Oracle 8.1.6

This book also provides a summary of the most useful new features of Oracle 8.1.5, practical tips for tuning performance and testing features, and information on the major space-management features of an Oracle database.

Written by one of the world's most knowledgeable and experienced Oracle database designers and programmers, Practical Oracle8i™ reveals the strategies, techniques, and insights that will enable you to understand the technology's full potential and put Oracle to work for successful database systems.


About the Author

Jonathan Lewis is a leading independent database consultant with over fifteen years' experience helping clients design and implement Oracle database systems. Much of his career has been spent working around the problems caused by the inappropriate use of the technology. In addition, he is the Director for Products and Services for the UK Oracle Users Group and maintains a Web site of Oracle tips and advice.


Inside This Book (Learn More)
First Sentence
When faced with Oracle for the first time, where is the novice supposed to start? Read the first page
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

4 star
3 star
2 star
1 star
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
6 of 6 people found the following review helpful
By A Customer
At last! A book that tells it like it is!
In the age of The Object, many unenlightened I.T. professionals dismiss the database as a mere "persistent object repository". In other words, a big bucket to put data into. At best this approach results in poor performance - at worse, you're looking at project failure, loss of reputation, dismissal, homelessness, etc.
Jonathan Lewis's book is not a magic bullet to solve all Oracle project ills nor is it an easy read. The first chapter alone covers some difficult ground regarding redo and rollback. What becomes immediately apparent is that databases are extremely complex beasts. However, when you put the effort in, take heed of good advice, and, most importantly, prove it to yourself, there is a much greater chance of going live with a champ rather than a chump!
If you can get through the (essential) first four chapters unscathed, the rest of the book is plain sailing and, to a certain degree, you can dip into them. However, I wouldn't say that the book contains "tips": It contains "pointers to the right direction and away from the wrong turns". Quite often it is tempting to use a feature of Oracle "because it's there". However, Mr. Lewis tells us whether its worth it of not - preventing much potential time-wasting. Also, to his credit, he isn't afraid to speak out: defending RAID 5, debunking Oracle's Objects, and putting RMAN into its proper perspective.
No project involving Oracle should be started without this book being read and understood by all it's key players!
Comment | 
Was this review helpful to you?
7 of 7 people found the following review helpful
5.0 out of 5 stars The best Oracle DBA Book on the Market 6 Jun 2001
By A Customer
Excellent, the best and most coherent oracle book I have read since the original DBA Handbook by Kevin Loney. A practical and succint review of Oracle 8i features.
The regularly updated errata and addendums on Johnathan's website are also particularly useful.
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
5.0 out of 5 stars Outstanding contribution to Oracle usage 20 April 2001
Of the many (perhaps too many) Oracle books on the market, Jonathan Lewis' contribution stands out as the most useful to the everyday Oracle practitioner.
There are usually many ways to achieve the same result in Oracle ... only experience provides the optimal solution; I thoroughly recommend this book to anyone that wants to know how to make optimal Oracle solutions and avoid the common pitfalls.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category