http://www.amazon.com/Expert-Oracle-Database-Architecture-Programming/dp/1430229462/ref=sr_1_6?ie=UTF8&qid=1311777235&sr=8-6
Expert Oracle Database Architecture:
http://www.yes24.com/24/Goods/3685944?Acode=101 ( 93,610 KRW )
Look like more expensive, maybe due to the shipping cost.
Book : Expert Oracle Database Architecture (written by Tom )
Chapter 1 : Developing Successful Oracle Applications
This chapter sets out my essential approach to database programming. All databases are not created equal, and in order to develop database - driven applications successfully and on time, you need to understand exactly what your particular database can do an how it does it
.......................
Chapter 7 : Concurrency and Multi-versioning
Chapter 8 : Transactions
Chapter 9 : Redo and Undo
Chapter 10 : Database Tables
Oracle now supports numerous table types. This chapter looks at each different type - heap organized (i.e., the default, "normal" table), index organized, index clustered, hash clustered, nested, temporary, and object - and discusses when, how, and why you should use them. Most of time, the heap organized table is sufficient, but this chapter will help you recognize when one of the other types might be more appropriate.
Chapter 11 : Indexes
Indexes are a crucial aspect of your application design. Correct implementation requires an in-depth knowledge of the data, how it is distributed, and how it will be used. Too often, indexes are treated as an afterthought in application development, and performance suffers as a consequence.
This chapter examines in detail the different types of indexes, including B*Tree, bitmap, function-based, and application domain indexes, and discusses where they should and should not be used. I'll also answer some common queries in the "Frequently Asked Questions and Myths About Indexes" section, such as "Do indexes work on views?" and "Why isn't my index getting used?"
Chapter 12 : Datatypes
Chapter 13 : Partitioning
Partitioning is designed to facilitate the management of very large tables and indexes by implementing a divide and conquer logic-basically breaking up a table or index into many smaller and more manageable pieces. It is an area where the DBA and developer must work together to maximize application availability and performance. This chapter covers both table and index partitioning.
We look at partitioning using local indexes (common in data warehouse) and global indexes (common in OLTP systems).
Chapter 14 : Parallel Execution
Chapter 14 : Parallel Execution
......................
We cover two techniques here. The first is parallel pipelined functions, or the ability of Oracle to execute stored functions in parallel dynamically. The second is "do it yourseld" (DIY) parallelism, whereby we design the application to run concurrently.
Chapter 15 : Data Loading and Unloading
This first half of this chapter focuses on SQL*Loader(SQLDDR) and covers the various ways in which we can use this tool to load and modify data in the database.
......................
The second half of the chapter focuses on external tables, an alternative and highly efficient means by which to bulk load and unload data.
Chapter 16 : Data Encryption
This chapter looks at the opportunities for encrypting data in the Oracle database. A discussion of manual "do it yourself" encryption using the built -in database package DBMS_CRYPTO is included, but not emphasized. Rather, a discussion on why you should probably not be using that package is included.
The focus of this chapter is on the implementation details of Transparent Data Encryption (TDE) in the Oracle Database. This chapter focuses on how both column level and tablespace level encryption possibility is described (that is what the Oracle documentation is for), but rather the practical implementation details and how they will affect you are laid out.
All source is available at http://www.apress.com/9781430229469
Another challenge is the book Effective Oracle by Design written by Thomas Kyte (Tom)
, of course after finishing this book first.
Expert Oracle Database Architecture:
Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions [Paperback] List price : $59.99
http://www.yes24.com/24/Goods/3685944?Acode=101 ( 93,610 KRW )
Look like more expensive, maybe due to the shipping cost.
Book : Expert Oracle Database Architecture (written by Tom )
Chapter 1 : Developing Successful Oracle Applications
This chapter sets out my essential approach to database programming. All databases are not created equal, and in order to develop database - driven applications successfully and on time, you need to understand exactly what your particular database can do an how it does it
.......................
Chapter 7 : Concurrency and Multi-versioning
Chapter 8 : Transactions
Chapter 9 : Redo and Undo
Chapter 10 : Database Tables
Oracle now supports numerous table types. This chapter looks at each different type - heap organized (i.e., the default, "normal" table), index organized, index clustered, hash clustered, nested, temporary, and object - and discusses when, how, and why you should use them. Most of time, the heap organized table is sufficient, but this chapter will help you recognize when one of the other types might be more appropriate.
Chapter 11 : Indexes
Indexes are a crucial aspect of your application design. Correct implementation requires an in-depth knowledge of the data, how it is distributed, and how it will be used. Too often, indexes are treated as an afterthought in application development, and performance suffers as a consequence.
This chapter examines in detail the different types of indexes, including B*Tree, bitmap, function-based, and application domain indexes, and discusses where they should and should not be used. I'll also answer some common queries in the "Frequently Asked Questions and Myths About Indexes" section, such as "Do indexes work on views?" and "Why isn't my index getting used?"
Chapter 12 : Datatypes
Chapter 13 : Partitioning
Partitioning is designed to facilitate the management of very large tables and indexes by implementing a divide and conquer logic-basically breaking up a table or index into many smaller and more manageable pieces. It is an area where the DBA and developer must work together to maximize application availability and performance. This chapter covers both table and index partitioning.
We look at partitioning using local indexes (common in data warehouse) and global indexes (common in OLTP systems).
Chapter 14 : Parallel Execution
Chapter 14 : Parallel Execution
......................
We cover two techniques here. The first is parallel pipelined functions, or the ability of Oracle to execute stored functions in parallel dynamically. The second is "do it yourseld" (DIY) parallelism, whereby we design the application to run concurrently.
Chapter 15 : Data Loading and Unloading
This first half of this chapter focuses on SQL*Loader(SQLDDR) and covers the various ways in which we can use this tool to load and modify data in the database.
......................
The second half of the chapter focuses on external tables, an alternative and highly efficient means by which to bulk load and unload data.
Chapter 16 : Data Encryption
This chapter looks at the opportunities for encrypting data in the Oracle database. A discussion of manual "do it yourself" encryption using the built -in database package DBMS_CRYPTO is included, but not emphasized. Rather, a discussion on why you should probably not be using that package is included.
The focus of this chapter is on the implementation details of Transparent Data Encryption (TDE) in the Oracle Database. This chapter focuses on how both column level and tablespace level encryption possibility is described (that is what the Oracle documentation is for), but rather the practical implementation details and how they will affect you are laid out.
All source is available at http://www.apress.com/9781430229469
Another challenge is the book Effective Oracle by Design written by Thomas Kyte (Tom)
, of course after finishing this book first.
'Oracle' 카테고리의 다른 글
| Dump Large Pool in SGA (0) | 2011.07.31 |
|---|---|
| Session trace with SQL Execution (0) | 2011.07.30 |
| SYS.DBMS_JOB.SUBMIT( , , , , ) (0) | 2011.07.27 |
| latch: shared pool (0) | 2011.07.23 |
| PL/SQL Block 에서 DDL 사용하기 (0) | 2011.07.20 |