Titlebook: Oracle Core: Essential Internals for DBAs and Developers; Jonathan Lewis Book 2011 Jonathan Lewis 2011

夹子

书目名称Oracle Core: Essential Internals for DBAs and Developers影响因子(影响力)




书目名称Oracle Core: Essential Internals for DBAs and Developers影响因子(影响力)学科排名




书目名称Oracle Core: Essential Internals for DBAs and Developers网络公开度




书目名称Oracle Core: Essential Internals for DBAs and Developers网络公开度学科排名




书目名称Oracle Core: Essential Internals for DBAs and Developers被引频次




书目名称Oracle Core: Essential Internals for DBAs and Developers被引频次学科排名




书目名称Oracle Core: Essential Internals for DBAs and Developers年度引用




书目名称Oracle Core: Essential Internals for DBAs and Developers年度引用学科排名




书目名称Oracle Core: Essential Internals for DBAs and Developers读者反馈




书目名称Oracle Core: Essential Internals for DBAs and Developers读者反馈学科排名

1分开

Redo and Undo,ogy is the most important bit and when did it first appear. The answers I get tend to go through the newer, more exciting features such as ref partitioning, logical standby, or even Exadata, but in my opinion the single most important feature of Oracle is one that first appeared in version 6: the .,

追逐

Transactions and Consistency,edo (again) to describe how to create the undo records—and then (apart from a concurrency optimization introduced in Oracle Database 10.) applies the changes in near real time rather than “saving them up” to the moment you commit.

BOOR

Locks and Latches,o ensure that resources don’t get damaged by conflicting requirements for access and modification. The mechanisms may slow down the rate at which you are allowed to work, to ensure that you can work safely, although, as we shall see in Chapter 7, some of the mechanisms can save you time when you kee

gustation

会议

Writing and Recovery, does so. You’ve seen the mechanisms that combine changes into transactions and ensure that those transactions appear to be atomic, consistent, and isolated, the first three requirements of ACID, but the questions remains, how does Oracle satisfy the . of ACID and make transactions durable?

Coeval

Parsing and Optimizing, looking at the .. Both these caches are part of the . (or SGA heap to give a more appropriate name) so, inevitably, we will have to look at some of the generic mechanisms that affect the shared pool at the same time.

Substance-Abuse

RAC and Ruin,cess to a single database, which means multiple independent data caches, multiple independent log buffers, and multiple independent SGAs—all accessing the same set of physical files, all using the same data dictionary. Without a constant stream of negotiation going on between instances, it would be

碳水化合物

example, products are often difficult or dull to use, make tasks less flexible or more tedious, shift attention away from important or gratifying activities, and simply fail to deliver expected benefits or experiences. By identifying such trouble and frustration in the lab prior to widespread use, u

Glaci冰