| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
|
Index > Oracle Books > DBA Books
| ||
|
Oracle Database 10g DBA Handbook by Kevin Loney, Bob Bryla | If you are looking to learn Oracle, don't try to do it with this book alone. This book is great for reference, but to try and understand all that is Oracle requires a different book. |
|
The Oracle Hacker's Handbook: Hacking and Defending Oracle by David Litchfield Highly recommended! | When I have started with this book I was amazed and afraid both. By this book all those tricks of SQL injections in Oracle has started to be a public knowledge. So this book is like a knife... you can cut the bread or you can kill with it. :) But let's be honest. It is always better to know especially when you are DBA... |
|
Oracle Application Server 10g Administration Handbook (Osborne ORACLE Press Series) by John Garmany, Donald K. Burleson Highly recommended! | I used this book to deploy Oracle Application Server 10g infrastructure on Linux and UNIX. I felt that it was a good book and overall I have little ill to say about it. The examples are well written and do a good job of reinforcing what you read in the handbook. You read a little then do an example, then read some more... |
|
OCA: Oracle 10g Administration I Study Guide (1Z0-042) by Chip Dawes, Bob Bryla, Joseph C. Johnson | ...and I'm a picky guy.
Seriously, this book has a clear concise language, is structured well, and has a wealth of examples, screenshots and very good diagrams. What it luckily doesn't have: The occasional corny episodes other technical book authors include, like: In 1984 I had an incident when a customer stuck his finger in the floppy drive, and... |
|
Expert Oracle Database 10g Administration (Expert's Voice) by Sam R. Alapati Highly recommended! | This is short and sweet. Of all the Oracle books I have read, this is among the best if not the best. I'm not affiliated with the author, reviewer, or publisher so I get nothing for saying it.
If you're a brand new DBA this isn't for you. If you've read and understand the majority of the Oracle concepts, admin, backup/recovery, and performance guides, then this book helps put the technical theory into practice. |
|
Oracle Applications DBA Field Guide by Elke Phelps, Paul Jackson | I am just getting into Oracle Applications. Traditionally, I always read the Oracle Documentation . . . (RTFM). I bought this book for the purpose of getting a high level view before getting into the Oracle Docs. This book is well laid and reads very easily. The author also points to various Metalink articles which is ... |
|
Oracle Database 10g Linux Administration by Edward Whalen | If you read the editorial review: It is stated that the book is about installing and configuring Oracle Database 10g on Linux. Yes, the author did explain clearly the process of installing and configuring the Oracle 10g on Linux. He also covered a few more topics such as HA (High Availability), Tuning SQL, RAC, ...
|
|
Mastering Oracle SQL, 2nd Edition by Sanjay Mishra, Alan Beaulieu | I'm no SDE, but I had a need to learn enough SQL to enable me to hit my company's Data Warehouse tables directly and employ some complex joins. This was the book recommended to me, and it did the trick. I sat down and began reading it and was quickly writing increasingly complex queries. I found the explanations ... |
|
OCP Oracle Database 10g: New Features for Administrators Exam Guide (Oracle Press) by Sam Alapati | This is the only guide you need to pass the exam. It may not have the depth, but it covered the objectives well.
Then again, what kind of depth does one require for ASM? I've not seen it in use yet here. |
|
Pro Oracle Database 10g RAC on Linux: Installation, Administration, and Performance (Expert's Voice in Oracle) by Julian Dyke, Steve Shaw Highly recommended! | Any programmer or designer who wants a step-by-step tutorial to Pro Oracle Database 10gRAC on Linux must have this book: it surveys all details from installation to advanced administration and optimization, with chapters covering installations across multiple servers for all Oracle users. The book delivers RAC on Linux...
Diane C. Donovan California Bookwatch |
|
Oracle9i DBA Handbook by Kevin Loney, Marlene Theriault | First off, I purchased this book as I am taking a course in Relational Database Design using Oracle 9i. I had labs to do that involved setting up user accounts, giving/revoking permissions to tables, etc. THe "Complete Reference" didn't have the necessary information--some but not all. This book--the DBA Handbook--had ... |
|
Oracle Essentials, 3e: Oracle Database 10g by Rick Greenwald, Robert Stackowiak, Jonathan Stern | I've used a number of different database systems before, but never had the pleasure of working with Oracle's software. I installed a development version of 10g and was somewhat taken aback when the installer proudly announced "169 products installed." I glumly thought "Gee, hope the database server is in there ...
I picked up a copy of Oracle Essentials and found it to be an excellent introduction to Oracle. The book is short enough to read end-to-end, but it is packed with information about Oracle's architecture and most of those 169 products. The authors write lucidly, in an easily accessible style. Even though the book is eminently readable, it doesn't "talk down" to the reader, nor skimp on details. There is surprising depth in so short a book with such broad scope! As another reviewer mentioned, there is essentially nothing about SQL and PL/SQL in this book. That's okay with me - there are plenty of excellent texts on those two topics. Oracle Essentials claims it is "What you need to know about Oracle Database architecture and features." I agree completely! |
|
PeopleSoft for the Oracle DBA (Oaktable Press) by David Kurtz Highly recommended! | I have been an Oracle DBA for ten years and needed to ramp up very quickly recently for a large client to support their PeopleSoft environment without time to get training on PeopleSoft. This book fits the void left empty as the other PeopleSoft books are geared toward PeopleSoft application developers and not for an ... |
|
OCA/OCP: Oracle9i DBA Fundamentals I Study Guide by Biju Thomas, Bob Bryla | Don't kid yourself. The 1Z0-031 is not an easy test, but reading this book helped me pass the test. If you are new to the profession, like me, then this book alone will not be enough.
I read this book once, understood MOST of what I read and then tried the test and failed. I then took an Oracle DBA class at a Community College and read two other books titled "Oracle 8i DBA Bible" and "Oracle 9i DBA Handbook". I also read Biju Thomas' book one more time, fully understood it and then I was able ... I highly recommend this book. I feel that if you can read and understand 99-100% of what Biju Thomas writes in "OCA/OCP: Oracle 9i DBA Fundamentals I" then you can pass the Oracle Exam. I also would not attempt the Exam without reading this book at least once. |
|
OCP: Oracle 10g New Features for Administrators Study Guide: Exam 1Z0-040 (Certification Study Guide) by Bob Bryla, Biju Thomas | Today I passed the OCP upgrade exam with a 52/60 score and this book is principally responsible. I used the practice exams to find holes in my knowledge and revisited the text in those areas. By the way, the 10g Upgrade exam is a lot more work than the last two upgrade exams. Prepare to spend more time studying. I have... |
|
Oracle 10g Database Administrator: Implementation and Administration by Gavin Powell, Carol McCullough-Dieter | I'm teaching two sections of a database administration course for which this textbook was selected. It's the worst textbook I think I've ever seen. The earlier edition, used with Oracle 9i, had all the problems Raymond noted, but at least it lined up with the Oracle release it described.
This edition lines up with Oracle release 10g, which is provided on a CD with the book. However, the authors were too careless or lazy to update the screen shots of the Enterprise Manager console from the old 9i ones. And they are completely different -- in 10g Oracle went to a browser-based EM console that ... Needless to say, the students are very confused and frustrated. This book doesn't even merit one star, but that's the least it can be given. |
|
Oracle SQL Plus Pocket Reference (Pocket Reference (O'Reilly)) by Jonathan Gennick | ...a good combination of size, price, and content. I have the 3rd edition, which includes an 8-page index. I use this as part of teaching a class in Oracle Developer and recommend it for my students. As the other reviewers recommend, write your name in it...the Oreilly pocket references are easy to misplace, and ...
Drawbacks? I'd like a larger index, although the current one is useful. A little bit more room throughout the book for notes might be handy, although it would enlarge the book a bit. I think the content is about right, although there will always be things one can't find, and other topics which are never used in this type of book. And, as with all the Oreilly pocket references I've seen, there is no colophon, so one must go to the original large book to discover that the insect on the front cover is a moving leaf, Phyllium giganteum, a Malaysian creature which grows to about four inches in length...roughly the width of the book! |
|
OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 by Doug Stuns, Tim Buterbaugh, Bob Bryla | i have passed my ocp 10g exam last month, thanks to this book and bersinic & watson book (ocp all in one exam guide). i have to say overall this book is better than the admin I book also by sybex. the thing i like about this book is it covers more than the exam needs, e.g. how to create the rman recovery catalog, which... |
|
Oracle 10g Database Administrator II: Backup/Recovery and Network Administration by Claire Rajan Highly recommended! | The book is an excellent resource for understanding how to perform backups and recovery using RMAN and its associated options. It does a good job of presenting theoritical information while including practical hands on exercises with associated screen shots as help aids. The book applies the same method in covering ... |
|
Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration by Mike Ault, Madhu Tumma, Daniel Liu | After wasting my money on the Freeman book I got this one because it has far more comprehensive coverage. I detest Oracle Press books and it is refreshing to see the top authors like Mike Ault coming into their own with books that are made for real people. |
|
Oracle Data Dictionary Pocket Reference by David C Kreines, David C. Kreines | "ORACLE Data Dictionary Pocket Reference" describes (most of) the ORACLE data dictionary views. This book sorts the DD views according to subjects e.g. "Replication". Normally for each view you will find a sentence about the contents of the view and the columns with datatype and not null constraints (if present). For ... |
|
OCP Introduction to Oracle9i: SQL Exam Guide by Jason Couchman | This is the only book I used to prepare for the OCP 1Z0-007 exam. The Oracle published exam objectives were covered and the sample test questions on CD were good. Other than one or two SQL syntax surprises, I had no problems with the exam. This book may not be adequate if you are unfamiliar with databases, SQL, and ... |
|
Oracle DBA Pocket Guide by David C Kreines Highly recommended! | No review available! |
|
Oracle9i: A Beginner's Guide by Michael Abbey, Michael J Corey, Ian Abramson | I read the reviews posted above, and was discouraged, but I needed an Oracle reference right away and this was the only book available at the library. Just as one person said, the first 2 chapters aren't wholly necessary and promote Oracle a lot. On the other hand, the book is printed by the Oracle Press. Chap. 3 ...
It is a lot at once for a true novice. I'm not so bad -- I had a pretty good crash course on relational DB ideas and SQL in 2 lectures of a web programming class once, for use with mySQL. This book is good enough to explain the Oracle side of things. And the writing isn't all that bad, i.e. it's more than just a copy of the manuals, IMO. It suits me well enough as an intro to the Oracle syntax and way of doing things. |
|
OCA: Oracle Application Server 10g Administration I Study Guide (Exam 1Z0-311) by Bob Bryla, April Wells | No review available! |
|
OCP Oracle9i DBA Certification Boxed Set by Jason Couchman, Rama Velpuri, Charles Pack | The 4 book set arrived 1 week earlier in great condition before all other Amazon Marketplace books ordered the same day. |
|
Oracle PL/SQL for DBAs by Arup Nanda, Steven Feuerstein Highly recommended! | Are you a developer or database administrator? If you are, then this book is for you! Authors Arup Nanda and Steven Feuerstein, have done an outstanding job of writing a book that allows you to take advantage of the PL/SQL-based functionality in the Oracle database that is the most critical for DBAs...
Nanda and Steven Feuerstein, begin by providing a whirlwind tour of the PL/SQL language, touching on all of the topics DBAs will need to become familiar with--from the basics of the PL/SQL block structure, identifier construction, and program data declarations, to the use of control and error-handling statements, to the construction of procedures, functions, packages, and triggers in PL/SQL. Then, the authors describe PL/SQL cursors and how you can improve database performance by taking advantage of such features as cursor reuse, cursor soft-parsing and soft-closing, and various characteristics of implicit cursors. Next, they explore the use of functions that can be used as data sources for queries and that are used frequently in Extraction, Transformation, and Loading (ETL) operations. The authors then explain how you can use Oracle's tools to build basic encryption and key management systems to protect sensitive data. They continue to explain how you can define policies on database tables so that you can restrict which rows particular users can see or change in those tables. Then, the authors show you how you can extend traditional Oracle auditing to capture both database changes and queries. Next, they discuss situations in which you may need to generate values. Finally, they describe the use of the DBMS_SCHEDULER package in scheduling jobs to be performed at regular intervals. This most excellent book is here to help you get your job done. More importantly, this book is focused squarely on the language topics of special concern to DBAs. |
|
Oracle RMAN Pocket Reference by Darl Kuhn, Scott Schulze | This book by no means replaces the (online) documentation that oracle provides, or a more complete RMAN book. But it shines when you want the syntax without carrying around a boat anchor of a book. You need a working knowlege of RMAN for this book to be useful. If you purchase this to learn RMAN, you will be ... |
|
OCA Oracle Application Server 10g Administrator Exam Guide (Exam 1Z0-311) (Osborne Oracle Press) by Sam Alapati | The book is inadequate as a means to prepare for the OCA exam. |
|
Oracle9i UNIX Administration Handbook by Donald K. Burleson | First, I would like to strongly disagree with one negative reviewer who claims this book contains many technical errors including the one comparing Unix and DOS commands. I have found the book contains virtually no technical errors.
If you are a ORACLE DBA who isn't too familiar with Unix or Linux, this is a very worthwhile book to read. Although it is not meant to make anyone a Unix\Linux guru, it is intended for the Oracle DBA who may lack fundamental competency in Unix\Linux. This book provides: 1)Unix Architecture and basic Unix syntax 2)monitoring Unix (CPU, Disk, Memory) 3)Network management in Unix (weakest portion of the book) 4)Interaction between Oracle and Unix server(could have been more comprehensive) 5)Unix Admninistration for the Oracle DBA( file, task, and profile management etc). 6)Many useful Korn Shell scripts (and how to create them) for ORACLE DBAs. If you already have medium to strong understanding of Unix\Linux, I recommend a book which is more focused on Unix\Linux to gain better mastery of the operating system. |
|
Oracle DBA Guide to Data Warehousing and Star Schemas by Bert Scalzo | Allow me to bestow some well-deserved praise upon Bert Scalzo's terrific "Oracle DBA Guide to Data Warehousing and Star Schemas". A true gem - I won't go on another Oracle project without it.
What Bert provides here is nothing short of a clear and crisp recipe for success for implementing Oracle-based data warehouses. It fills in a much-needed area of dimensional data warehousing best practices, by describing precisely how to coax the best achieveable Oracle performance from dimensional data models... I can't tell you how many projects I've been on where I've had to compromise physical data models in order to address perceived "shortcomings" in Oracle's ability to efficiently service dimensional queries. Using Bert's book on my most recent project, we followed his "recipe", and were able to consistently achieve the ideal query optimization plans and aggregate navigation behaviors - simply - without any of the usual hassles that I have (unfairly) come to associate with large scale Oracle data warehousing. To data warehousing newbies I humbly suggest: pick up any one of Ralph Kimball's terrific texts on data warehouse design, and then if you are rendering it in Oracle, buy this book and follow its advice. The resultant system will be simple, powerful, and fast. Bravo Bert - a great contribution to the field. Jim Stagnitto Llumino, Inc (www.llumino.com) |
|
Unix for Oracle DBAs Pocket Reference by Donald K Burleson | This is a very helpful book which provides a basic overview of using Unix running Oracle. Perhaps the best feature of this book is that the author has spent lot of time providing only the most useful and salient Unix scripts for the Oracle DBA. You will not find any unnecessary or redundant information in this book. In...
Here are some of the best tips: 1)Script to kill all Oracle processes. 2)Place a SQL * Plus script in a Unix Shell Wrapper 3)Ensure that only the Oracle user can run a Unix shell script 4)Execute a SQL*Plus Script on all the instances in the enterprise. 5)Automatically delete old trace and audit files 6)Copy TNSnames.ora to all the Unix servers in the enterprise 7)Detect when Oracle is not accepting connections and send alert |
|
Oracle9i Database Administrator: Implementation and Administration by Carol McCullough-Dieter | The book is great for my class. The reviews really help and are easy to follow. |
|
Oracle DBA Checklists Pocket Reference by Quest Software Highly recommended! | You can formulate(If you're not that documenting kind of a dba;)) to make religiously your own checklists from this simple but very helpful pocket reference. Tarry |
|
Oracle DBA Interactive Workbook by Melanie Caffrey, Douglas Scherer | I think this is a good book for all of you to have a hands-on experience in oracle database. If you understand some concepts of oracle database, you will find it useful. Everyone doesn't use unix at home, but it provides how to use unix and windows NT in oracle database. I am expecting the author can rewrite... |
|
Oracle SQL Tuning & CBO Internals by Kimberly Floss | I was happy with the price and quality of this book. The book has detailed information about the internal workings of the cost based optimizer and the scriptgs were helpful. I could recommend this book to anyone who wants to learn about Oracle SQL internals of the optimzier. |
|
OCP: Oracle9i DBA Fundamentals II Study Guide by Doug Stuns, Matthew Weishan | You're not going to get certified with this book, but the CD is pretty good at testing your Backup and Recovery knowledge. The CD also quizzes you on Recovery Manager (RMAN), parameter files, Import, Export, SQL Loader and Listener Control utility. Everyone here is accurate; that Oracle DBA II test is very difficult to... |
|
OCP Oracle9i Database: Fundamentals II Exam Guide by Rama Velpuri | I used this book for my exam (1z0-032). It is a good book, well-organized and detailed. It is far better than the sybex book that I used as supplement. The contents of the oraclepressbook are very closed to the Exam questions. The practice exams on the CD were very helpfull especially those questions related to ...
I will finish by thanking Rama Velpuri for the great job he did putting this Exam Guide together. Other than a bug in the software the guide deserves 4 stars from me. Thanks R. Velpuri DeKalb, IL 60115 |
|
Oracle Performance Troubleshooting: With Dictionary Internals, SQL & Tuning Scripts (Oracle In-Focus series) by Robin Schumacher, Donald K. Burleson | This book is another in the series of technical volumes published by "Rampant Techpress," published by Don Burleson. The purpose of this book by Robin Schumacher is to suggest and illustrate a robust, comprehensive performance tuning methodology. With this methodology in hand, the author then provide examples and ... |
|
Expert Oracle9i Database Administration by Sam R. Alapati Highly recommended! | An excellent book covering all essential DBA topics for Oracle 9i Administration. Explained very well covering In-depth details, Illustrations and examples makes this book invaluable. I use it as a true source of reference and I will strongly recommend this book. |
40 books listed. Updated: 24 Feb 2007 | ||
 |
 |