Thomas Kyte has a simple philosophy: You can treat Oracle as a black box and shove data inside of it, or you can learn how Oracle works and exploit it as a powerful computing environment. If you choose the latter, you will see there are few information management problems you cannot solve quickly and elegantly.
Kyte has selected the most important features and techniques to discuss in Expert One-on-One Oracle, which he teaches in a proof-by-example manner. He discusses available features, implementing software using these features, and avoiding potential pitfalls.
Table of Content
Setting Up.- Developing Successful Oracle Applications.- Architecture.- Locking and Concurrency.- Transactions.- Redo and Rollback.- Database Tables.- Indexes.- Import and Export.- Data Loading.- Tuning Strategies and Tools.- Optimizer Plan Stability.- Analytic Functions.- Materialized Views.- Partitioning.- Autonomous Transactions.- Dynamic SQL.- inter Media.- C-Based External Procedures.- Java Stored Procedures.- Using Object Relational Features.- Fine Grained Access Control.- n-Tier Authentication.- Invoker and Definer Rights.
About the author
Thomas Kyte is vice president of the Core Technologies Group at Oracle Corporation and has been with the company since version 7.0.9 was released in 1993. Kyte, however, has been working with Oracle since version 5.1.5c. At Oracle, Kyte works with the Oracle database, and more specifically, he helps clients who are using the Oracle database and works directly with them specifying and building their systems or rebuilding and tuning them. Prior to working at Oracle, Kyte was a systems integrator who built large-scale, heterogeneous databases and applications for military and government clients.Tom Kyte is the same ‘Ask Tom’ whose column appears in Oracle Magazine, where he answers questions about the Oracle database and tools that developers and database administrators struggle with every day.
More ebooks from the same author(s) / Editor
16,480 Ebooks in this category
