• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Mr.Kyte, could you introduce a little about your book?

 
Ranch Hand
Posts: 235
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
such as the contents.
Thanks
 
Ranch Hand
Posts: 106
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
FROM amazon site:

Table of Contents
Introduction
Setting Up
Chapter 1: Developing Successful Oracle Applications
Chapter 2: Architecture
Chapter 3: Locking and Concurrency
Chapter 4: Transactions
Chapter 5: Redo and Rollback
Chapter 6: Database Tables
Chapter 7: Indexes
Chapter 8: Import and Export
Chapter 9: Data Loading
Chapter 10: Tuning Strategies and Tools
Chapter 11: Optimizer Plan Stability
Chapter 12: Analytic Functions
Chapter 13: Materialized Views
Chapter 14: Partitioning
Chapter 15: Autonomous Transactions
Chapter 16: Dynamic SQL
Chapter 17: interMedia
Chapter 18: C-Based External Procedures
Chapter 19: Java Stored Procedures
Chapter 20: Using Object Relational Features
Chapter 21: Fine Grained Access Control
Chapter 22: n-Tier Authentication
Chapter 23: Invoker and Definer Rights
Appendix A: Necessary Supplied Packages
Appendix B: Support, Errata and p2p.wrox.com
Index
 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sure, you can get some information from:

the wrox website
but here is an annotated table of contents:

Chapter 1: Developing Successful Oracle Applications
Here I cover topics such as why it is fairly important to understand how your database works, how transactions work, how things in general in your database of choice works (and every database works differently). This is done by relating observations of what happened when the database and its implementation was ignored..

Chapter 2: Architecture
Here I go over the architecture of the Oracle database from the organization of the SGA, how memory is used by the various Oracle processes to the Oracle processes themselves (what they are, what they do and how they interact)
Chapter 3: Locking and Concurrency
This section covers the ins and outs of locking in Oracle, the various types of locks/latches, how to use them (and not use them) and how concurrency control in Oracle is implemented.
Chapter 4: Transactions
Covers the transaction control statements, what they do and how to use them. Cover also how integrity constraints work with transactions, "bad" transaction habits I've observed, distributed transactions and lastly how redo and rollback work (what the server does to support transactions) in Oracle
Chapter 5: Redo and Rollback
Covers most things you would want to know about redo and rollback in Oracle..
Chapter 6: Database Tables
Many people don't know there is more then one type of table -- we have heap tables, index organized tables, clustered objects, hash clustered objects, nested tables, temporary tables and object tables -- this chapter explores the implementation and uses of each

Chapter 7: Indexes
Like tables -- there is more then one index structure. Here we cover b*trees (and the various types of b*trees out there), bitmaps, function based, and domain indexes. This section also has a "FAQ" on indexes covering what I've seen to be the most frequently asked questions on indexes.
Chapter 8: Import and Export
Chapter 9: Data Loading
These two chapters cover the ins and outs of using the IMP/EXP and SQLLDR tools with examples and suggested uses for the tools, lots of examples.
Chapter 10: Tuning Strategies and Tools
Covers an approach to tuning (it starts from day 1 of design). How to use the supplied tools everyone has access to such as sql_trace, timed_statistics, tkprof, statspack, dbms_profiler, and so on.
Chapter 11: Optimizer Plan Stability
Discusses the implementation of an advanced query hinting facility in Oracle8i..
Chapter 12: Analytic Functions
Starting with 8i, release 2 -- Oracle added dozens of analytic functions. These functions are extremely powerful in day to day usage (you need not be a statistician to make use of these functions every day). This chapter goes into how they work, what they do and how to use them.
(most of the chapters that follow have this format now:
o intro to topic
o how topic works
o why you might want to use topic
o examples of topic
o caveats to be aware of with regards to topic
o summary)
Chapter 13: Materialized Views
A materialized view is a way of answering complex questions ahead of time and can be used to take a query that would take hours to execute and get the answer in milli-seconds. This chapter explores materialized views, how they work... (that list from above)
Chapter 14: Partitioning
Same for partitioning (that list)
Chapter 15: Autonomous Transactions
Autonomous transactions are a new 8i feature that are sometimes misunderstood (or missed all together). This chapter goes into detail as to what they are and why they are (the list again)
Chapter 16: Dynamic SQL
Covers dynamic sql in PLSQL
Chapter 17: interMedia
Using interMedia text to query, summarize, and theme textual data..
Chapter 18: C-Based External Procedures
How to write an external procedure in C ( a stored procedure written in C)
Chapter 19: Java Stored Procedures
What they are, why they are, how to do them, (that list again)
Chapter 20: Using Object Relational Features
covers the object relational features of Oracle8i, what they mean to you and how to use them.
Chapter 21: Fine Grained Access Control
How the virtual private databases (VPD) function is implemented in Oracle, how/when to use it.
Chapter 22: n-Tier Authentication
Covers the ability for a middle tier application to "proxy" log in on behalf of some user.
Chapter 23: Invoker and Definer Rights
What the differences between invokers and definers rights are and how they affect the execution of stored procedures written in Java, C or PLSQL.

Appendices
Appendix A: Necessary Supplied Packages
Covers all of the goodies Oracle supplies out of the box like dbms_job, dbms_application_info and so on...

------------------
Thomas Kyte ([email protected]) http://asktom.oracle.com/
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/
Opinions are mine and do not necessarily reflect those of Oracle Corp
 
Ranch Hand
Posts: 527
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Kyte,
Is there anything regd. replication in your book.
Thanks,
Anil
 
Ranch Hand
Posts: 293
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Mr. Kyte,
Does your book cover anything on EJB QL with Oracle?
If not, could you (or anyone else here) recommend a source other than the Sun EJB 2.0 Sun Specification?
Thanks!
reply
    Bookmark Topic Watch Topic
  • New Topic