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.
Edition
Language
Place of publication
Target group
Professional/practitioner
Illustrations
LII, 1328 p. With CD-ROM. In 2 volumes, not available separately.
Dimensions
Height: 248 mm
Width: 186 mm
Thickness: 59 mm
Weight
ISBN-13
978-1-59059-525-1 (9781590595251)
DOI
10.1007/978-1-4302-0019-2
Schweitzer Classification
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.
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.- interMedia.- C-Based External Procedures.- Java Stored Procedures.- Using Object Relational Features.- Fine Grained Access Control.- n-Tier Authentication.- Invoker and Definer Rights.
