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影響因子(影響力)學(xué)科排名




書目名稱Oracle Core: Essential Internals for DBAs and Developers網(wǎng)絡(luò)公開度




書目名稱Oracle Core: Essential Internals for DBAs and Developers網(wǎng)絡(luò)公開度學(xué)科排名




書目名稱Oracle Core: Essential Internals for DBAs and Developers被引頻次




書目名稱Oracle Core: Essential Internals for DBAs and Developers被引頻次學(xué)科排名




書目名稱Oracle Core: Essential Internals for DBAs and Developers年度引用




書目名稱Oracle Core: Essential Internals for DBAs and Developers年度引用學(xué)科排名




書目名稱Oracle Core: Essential Internals for DBAs and Developers讀者反饋




書目名稱Oracle Core: Essential Internals for DBAs and Developers讀者反饋學(xué)科排名

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

會(huì)議

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冰