手工艺品 发表于 2025-3-28 17:13:06
Transactions,understood and many developers do not even know that they are accidentally not using them. This chapter examines how transactions should be used in Oracle and also exposes some bad habits that may have been picked up when developing with other databases. In particular, we look at the implications ofdry-eye 发表于 2025-3-28 21:25:17
http://reply.papertrans.cn/32/3192/319164/319164_42.pngCardioplegia 发表于 2025-3-28 22:58:09
http://reply.papertrans.cn/32/3192/319164/319164_43.pngaspect 发表于 2025-3-29 03:50:28
Indexes, 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 whereAnecdote 发表于 2025-3-29 09:45:32
Datatypes, when to use each one. First up is a brief overview of National Language Support (NLS), a basic knowledge of which is necessary to fully understand the simple string types in Oracle. We then move on to the ubiquitous NUMBER type. Next the LONG and LONG RAW types are covered, mostly from a historicallinguistics 发表于 2025-3-29 13:35:04
Partitioning,p 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. Features introduced in the latest versions of Oracle are also covered in detail..This chapter covers both table and indeagglomerate 发表于 2025-3-29 15:36:57
http://reply.papertrans.cn/32/3192/319164/319164_47.pngOmnipotent 发表于 2025-3-29 23:34:46
http://reply.papertrans.cn/32/3192/319164/319164_48.pngEclampsia 发表于 2025-3-30 02:16:27
Developing Successful Oracle Applications,r database can do, you run the risk of continually reinventing the wheel—developing functionality that the database already provides. If you do not know how your database works, you are likely to develop applications that perform poorly and do not behave in a predictable manner.尽管 发表于 2025-3-30 04:29:07
Partitioning,availability and performance. Features introduced in the latest versions of Oracle are also covered in detail..This chapter covers both table and index partitioning. We look at partitioning using local indexes (common in data warehouses) and global indexes (common in OLTP systems).