Karen Morton is a consultant and educator specializing in application optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is a Senior Technical Consultant for Enkitec.
For more than 20 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a database administrator, a data architect and now is a researcher, educator and consultant. Having used Oracle since the early 90s, she began teaching others how to use Oracle over a decade ago.
Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network (an informal association of "Oracle scientists" that are well known throughout the Oracle community). She blogs at karenmorton.blogspot.com.
The revelation was that well-performing databases and applications do not happen by accident, but by design. And "by design" means that you must understand how databases work, and how to make efficient use of the SQL language to create scalable applications and databases. Jared's goal for this book is to make it easier for developers and database administrators to understand and use advanced SQL syntax. There are many features that have been introduced since Oracle 8i, and yet they seem to be seldom used. This book should help rectify that.
Riyaj Shamsudeen is an industry-recognized RAC expert and performance tuning specialist with 19+ years of experience in implementing, using, and tuning RAC and Oracle products. He is an Oracle ACE Director and proud member of the OakTable network. Riyaj has co-authored many books about Oracle Database. He is an active blogger (at http://orainternals.wordpress.com) and frequent international speaker in major conferences such as UKOUG, HOTSOS, Open World, and RMOUG.
Kerry Osborne began working with Oracle (version 2) in 1982. He has worked as both a developer and a DBA. For the past several years he has been focused on understanding Oracle internals and solving performance problems. He is an OakTable member and an Oracle Ace Director.. Kerry is a frequent speaker at Oracle conferences. He is also a co-founder of Enkitec, an Oracle-focused consulting company headquartered in Dallas, Texas. He blogs at kerryosborne.oracle-guy.com.
The book typically indicates the first Oracle release version that supports a feature that is being described.
These chapters detailed how SQL works in various parts of the database structures like the shared pool and buffer cache.
There are also performance points made that are very useful and they are applied after the basic query is presented.
Some excellent tips here on Oracle in general, from a number of contributors, all experts in their various fields. Read morePublished 15 months ago by Gerry
I bought this book because I am about to get involved with Oracle 11g. The first thing I liked about it is that each chapter is written by a different person, so you don't get one... Read morePublished 23 months ago by William R. Bullerman
This book is great. If you are DBA or developer , you will find a lot of things in this book you have ever skip for latter understanding. Read morePublished on May 7, 2012 by Sergey Tatarinov
I recently began reading Pro Oracle SQL to get a brush up on writing better SQL. What I got was far better. Read morePublished on May 23, 2011 by Lon White - AZOAUG