Atjaunināt sīkdatņu piekrišanu

E-grāmata: Oracle Insights: Tales of the Oak Table

3.88/5 (16 ratings by Goodreads)
, , , , , , , , ,
  • Formāts: PDF+DRM
  • Izdošanas datums: 23-Jul-2004
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781430207382
Citas grāmatas par šo tēmu:
  • Formāts - PDF+DRM
  • Cena: 47,58 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
  • Šī e-grāmata paredzēta tikai personīgai lietošanai. E-grāmatas nav iespējams atgriezt un nauda par iegādātajām e-grāmatām netiek atmaksāta.
Oracle Insights: Tales of the Oak TablePalielināt
  • Formāts: PDF+DRM
  • Izdošanas datums: 23-Jul-2004
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781430207382
Citas grāmatas par šo tēmu:

DRM restrictions

  • Kopēšana (kopēt/ievietot):

    nav atļauts

  • Drukāšana:

    nav atļauts

  • Lietošana:

    Digitālo tiesību pārvaldība (Digital Rights Management (DRM))
    Izdevējs ir piegādājis šo grāmatu šifrētā veidā, kas nozīmē, ka jums ir jāinstalē bezmaksas programmatūra, lai to atbloķētu un lasītu. Lai lasītu šo e-grāmatu, jums ir jāizveido Adobe ID. Vairāk informācijas šeit. E-grāmatu var lasīt un lejupielādēt līdz 6 ierīcēm (vienam lietotājam ar vienu un to pašu Adobe ID).

    Nepieciešamā programmatūra
    Lai lasītu šo e-grāmatu mobilajā ierīcē (tālrunī vai planšetdatorā), jums būs jāinstalē šī bezmaksas lietotne: PocketBook Reader (iOS / Android)

    Lai lejupielādētu un lasītu šo e-grāmatu datorā vai Mac datorā, jums ir nepieciešamid Adobe Digital Editions (šī ir bezmaksas lietotne, kas īpaši izstrādāta e-grāmatām. Tā nav tas pats, kas Adobe Reader, kas, iespējams, jau ir jūsu datorā.)

    Jūs nevarat lasīt šo e-grāmatu, izmantojot Amazon Kindle.

Announcing a new book from Apress and the OakTable Network:



Oracle Insights: Tales of the Oak Table presents 11 world-renowned industry specialists proffering their own highly experienced views, input, and insights on Oraclewhere it's been, where it's going, how (and how not) to use it successfully, the software and techniques that theyve introduced to help people achieve their goals, and some frightening tales of what can happen when fundamental design principles are ignored.



The collaborating authors have solved many of the worst Oracle performance problems in the world, and they've each saved at least one doomed flagship project. Over many years, they've been sharing their unique knowledge with each other at conferences, around the OakTable, and in coffee shops, restaurants, and bars on five continents. Now they want to share their key insights with you.



A major focus of this book concerns the ways in which you can avoid common and debilitating mistakes when building Oracle software projects. From these stories, you'll learn the simple steps that will help you avoid real pain on your next (or current) Oracle project.

Papildus informācija

Springer Book Archives
Foreword xi
About the Authors xv
About the Technical Reviewer xxi
Introduction xxiii
Chapter 1 A Brief History of Oracle 1(70)
Before the Relational Model
5(3)
Early RDBMS Implementations
8(3)
From Theory to Practice
9(2)
The 12 Rules
11(12)
Rule 1: The Information Rule
12(1)
Rule 2: Guaranteed Access Rule
12(1)
Rule 3: Systematic Treatment of Null Values
13(2)
Rule 4: Dynamic On-Line Catalog
15(1)
Rule 5: Comprehensive Data Sublanguage
16(1)
Rule 6: View Updating Rule
17(1)
Rule 7: High-level Insert, Update, and Delete
18(1)
Rule 8: Physical Data Independence
18(1)
Rule 9: Logical Data Independence
19(1)
Rule 10: Integrity Independence
19(1)
Rule 11: Distribution Independence
20(2)
Rule 12: Nonsubversion Rule
22(1)
What's Missing?
23(5)
Transactional Integrity
23(1)
Isolation Levels
24(2)
Privileges
26(2)
Early Days, Key Decisions
28(7)
The Rule Based Optimizer (RBO)
32(1)
What the World Wanted
33(2)
Evolution of Expectation of Ease
35(4)
Outriders Become Insiders
39(1)
The "Tipping Points"
40(28)
Version 4: Portability Across Platforms
41(4)
Version 5: Subqueries, Tools, and SQL*Net
45(3)
Version 6: First Steps Towards Scalability
48(7)
Version 7: A More Active Database
55(3)
Version 8: Partitioning and Object Support
58(4)
Version 9: Real Application Clusters (RAC)
62(4)
Version 10: Grid Computing and Manageability
66(2)
A Briefer Technical History of Oracle
68(1)
The Last Word
69(2)
Chapter 2 You Probably Don't Tune Right 71(24)
Correct Instrumentation Is Key
76(14)
It's All a Question of Focus
79(1)
The Time Is Coming
80(2)
History Repeats Itself
82(1)
Overhead
83(1)
Batch
84(1)
The Wild West Systems: VMS, UNIX, Windows
85(1)
Is There No Hope?
86(4)
State of the Nation
90(3)
VMS Is Dying
90(1)
Proprietary UNIX Is also Dying
91(1)
Linux and Windows Are on the Rise
91(1)
What About Oracle?
92(1)
Closing Thoughts
93(2)
Chapter 3 Waste Not, Want Not 95(44)
As Bad As It Gets
99(4)
Resolutions
102(1)
"Ultra" Read Consistency
103(8)
Back to the Problem Application
106(1)
A Closer Look at the Trace Files
107(2)
Resolutions
109(2)
The Reference Code Dumping Ground
111(7)
Problem 1: Lookup Function Pervasion
112(2)
Problem 2: The Loss of Domain
114(3)
Problem 2a: The Loss of Domain for Validation
117(1)
Resolution
118(1)
Parsing Proliferation: From XML to Oracle
118(12)
Background
119(1)
The Problem
120(5)
Resolutions
125(5)
Hidden DUAL Access
130(7)
Background
130(2)
Resolutions
132(5)
Conclusion
137(2)
Chapter 4 Why I Invented YAPP 139(16)
Discovering the Wait Interface
141(4)
Documenting the Wait Events
142(1)
Back to Oracle Parallel Server
143(2)
OPS in Tokyo
145(5)
Problems with Queues
146(1)
The Birth of Tuning by Response Time
147(3)
The Birth of YAPP Methodology
150(1)
Using YAPP Methodology
150(1)
The Wait Interface in the Mainstream
151(1)
Looking Forward
152(1)
Summary
153(2)
Chapter 5 Extended SQL Trace Data 155(28)
Before the Microscope
157(1)
The Dark Ages
158(4)
The Enlightenment
162(2)
The History of SQL Trace
164(12)
Version 5
164(2)
Version 6
166(3)
Version 7
169(2)
Version 8
171(1)
Version 9
172(2)
Version 10
174(2)
The Revolution
176(2)
Diagnosis Beyond the Database
178(2)
The New "Step One"
180(2)
References
182(1)
Chapter 6 Direct Memory Access 183(26)
On Site at Brushco
185(9)
Meeting Roger Sanders
186(2)
Roger and "m2"
188(2)
m2 and Direct Memory Access
190(2)
m2 in Action :
192(2)
Developing DMA in Anger
194(12)
How DMA Works
195(11)
DMA in Action: Reading Buffer Cache Handles
206(1)
DMA Pros and Cons
206(1)
Closing Thoughts
207(2)
Chapter 7 Compulsive Tuning Disorder 209(48)
What Is CTD?
212(5)
Why Do People Suffer from CTD?
214(1)
Oracle 10g Automatic SGA Tuning: An Oasis for a CTD Sufferer
215(1)
Are You DBA Survivor Material?
216(1)
It Is Time to Get Logical
217(1)
Logical Performance Optimization
218(2)
The Oracle Wait Interface
220(3)
Types of Wait Events
220(1)
V$SESSION_WAIT: The Goldmine of Symptoms
221(2)
The OWI in Oracle 10g
223(11)
The Concept of a Wait Class
223(3)
V$ACTIVE_SESSION_HISTORY: The New Diagnostic Data Source
226(4)
V$EVENT_HISTOGRAM: Wait Event Data Distribution
230(2)
Oracle 10g DBMS_MONITOR: The New Frontier in Session Tracing
232(2)
The 2-pronged Methodology: The Cure for CTD
234(17)
Set Reasonable Performance Goals
236(1)
Measure and Document Current Performance
236(1)
Identifying the Bottlenecks within Oracle: Prong I
237(4)
Using Prong I: A Simple Yet Powerful Example
241(6)
Identifying the OS Bottlenecks: Prong II
247(4)
CTD Case Notes
251(4)
CTD Sufferer #1
251(2)
CTD Sufferer #2
253(2)
Conclusion
255(1)
References
255(2)
Chapter 8 New Releases and Big Projects 257(40)
The Arrival
260(1)
The Project
260(7)
Rapid Application Development
262(1)
RAD-ical Runway
263(1)
Multi-Threaded Server1
264(3)
System Sizing
267(2)
We Need Bigger Guns
268(1)
Migrating to Sequent
269(6)
Changing Character Sets
269(1)
Problems with RAID
270(3)
Bugs
273(1)
No More MTS
274(1)
Two Nodes: Using OPS in Anger
275(3)
Functional Partitioning
276(2)
Germany!
278(8)
Shared Pool Problems
279(1)
OPS Problems
280(6)
More Trouble at the WANch
286(2)
Latency
286(1)
Centralized Client/Server
287(1)
Satellite Networks
287(1)
A Multi-Prong Attack on OPS
288(6)
Shared SQL
289(1)
Bigfoot: Splitting the Rental Users
290(1)
Tuning the Operations
291(1)
Tuning the Database
292(2)
Modern Day
294(1)
Putting the Project to Bed
295(2)
Chapter 9 Testing and Risk Management 297(40)
A Little Background Muse
301(1)
Avoiding the Avoidable
302(3)
Strategic Problems
302(1)
Operational Problems
303(2)
Rules of Engagement
305(2)
Cycle Faster
307(1)
Design Principles
308(10)
Design Accurately
308(1)
Keep It Simple
309(3)
Identify Bottlenecks
312(1)
Generalize
313(1)
Design for the Rule Rather Than the Exception
314(1)
Parameterize
314(1)
Work with the Product, Not Against It
315(1)
Instrument Your Code
316(1)
Less Is More
316(2)
Instrumentation
318(8)
Changes in Performance and Resource Usage
324(1)
Auditing
325(1)
Tracing on Failure
325(1)
Sizing
326(1)
Testing
326(7)
Functionality Tests
327(2)
Automated Testing
329(1)
Scalability Testing
329(3)
Keep It Real
332(1)
Testing Culture
332(1)
Prepare to Fail
333(1)
Prototyping
334(1)
Conclusion
335(2)
Chapter 10 Design Disasters 337(40)
The Environment
339(1)
Summary of Errors
340(35)
Database Independence
341(24)
Data Extract to Warehouse
365(3)
Data Feeds
368(2)
Testing, Tuning, and Troubleshooting
370(5)
Postscript
375(2)
Chapter 11 Bad CaRMa 377(20)
Obligatory Disclaimers
380(1)
Introducing Vision
380(13)
Seeing and Vision
382(2)
The Data-Driven Application
384(1)
When It's Not Right, You Know It ... or Not?
385(4)
Expanding Vision
389(3)
Death of a Vision
392(1)
Private Vision
393(1)
Looking Back at Vision
394(3)
Appendix Join the BAARF Party (or Not) 397(10)
Origins of BAARF
397(2)
Battle Lines Are Drawn
399(2)
BAARF. The Musical
401(1)
Is the Enemy in Retreat?
401(1)
BAARF. The Interview
402(5)
Index 407
Cary Millsap is the former vice president of Oracle's System Performance Group and the cofounder of Hotsos (http://www.hotsos.com), a company dedicated to Oracle system performance. Hotsos provides performance-improvement tools for Oracle environments and also delivers training in the form of clinics and the very successful Hotsos symposiums.
Biežāk uzdotie jautājumi par e-grāmatām Biežāk uzdotie jautājumi par e-grāmatām
Permanent link: https://www.kriso.lv/db/97814302073822e.html
Keywords: