دانلود کتاب Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack (Part No A86647-01) (Release 9 0 1) (2001)

عنوان فارسی :

دانلود کتاب تنظیم تنظیم پایگاه داده Oracle Enterprise Manager با بسته تنظیم Oracle (قسمت شماره A86647-01) (انتشار 9 0 1) (2001)

عنوان انگلیسی :

Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack (Part No A86647-01) (Release 9 0 1) (2001)

زبان : English

موضوع : Computers->Information Systems: EC businesses

نویسندگان : Jamen L. M.

ناشر :

ISBN (شابک) :

تعداد صفحات : 282\282

سال نشر :      ویرایش :

حجم : 1 MB       فرمت : djvu

قیمت : 20000 تومان

فهرست :



Table of contents :
Send Us Your Comments......Page 13
Preface......Page 15
Part I Getting Started with the Oracle Tuning Pack......Page 21
1 Introduction to the Oracle Tuning Pack......Page 23
Oracle SQL Analyze......Page 24
Outline Management......Page 25
Starting the Tuning Pack Products......Page 26
Using Help......Page 27
Configuring SQL Analyze......Page 29
Part II Part II Getting Started with Oracle SQL Analyze......Page 31
3 Introduction to Oracle SQL Analyze......Page 33
Benefits of Oracle SQL Analyze......Page 34
SQL Tuning as Part of an Overall Tuning Process......Page 35
SQL Tuning Issues......Page 36
Analyzing Explain Plans......Page 37
Adding Hints......Page 38
The SQL Tuning Process......Page 39
Step Three: Tuning the Statement......Page 40
Step Four: Verifying Your Results......Page 41
4 Starting a Tuning Session......Page 43
Assigning the SQLADMIN Role......Page 44
Oracle SQL Analyze Repository......Page 45
Oracle SQL Analyze Main Window......Page 46
The Navigator Pane......Page 47
SQL Text Pane......Page 48
Details Pane......Page 49
Selecting a Statement for Tuning......Page 50
Selecting Statements with TopSQL......Page 51
Entering a New Statement......Page 55
Saving......Page 56
Understanding Statistical Information......Page 57
Instance Based Parameters......Page 58
Session Based Parameters......Page 63
Analyzing Logical Structure......Page 71
Viewing Object Properties......Page 72
Table Properties......Page 73
Cluster Properties......Page 75
Index Properties......Page 78
Cost-Based and Rule-Based Optimization......Page 81
Understanding Performance Statistics......Page 85
Using SQL History......Page 86
Understanding Explain Plans......Page 87
Viewing Execution Statistics......Page 93
Comparing SQL Statements and Explain Plans......Page 94
Tuning SQL Statements......Page 97
Understanding Index Tuning Recommendations......Page 98
Understanding Hints......Page 100
Understanding Rules-of-Thumb......Page 103
Use TRUNC differently to enable indexes......Page 105
The SQL Tuning Wizard Process......Page 108
Using the Hint Wizard......Page 110
How to Verify SQL Performance Improvement......Page 111
Part III Getting Started with Graphical Explain Plans......Page 113
8 SQL Explain Plan......Page 115
Stepping Through the SQL Explain Plan......Page 117
Part IV Getting Started with Oracle Expert......Page 119
Advantages of Using Oracle Expert......Page 121
Database Tuning Issues......Page 122
What Are the Types of Performance Tuning?......Page 123
Ways to Use Oracle Expert......Page 124
Sample Tuning Session......Page 125
Steps in Oracle Expert Methodology......Page 127
Setting the Scope of the Tuning Session......Page 128
Managing SQL History Data......Page 129
Reviewing Recommendations......Page 130
Inputs and Outputs......Page 131
Tuning Inputs......Page 132
Generated Output......Page 133
Starting Oracle Expert......Page 135
Identifying the Database to Tune......Page 137
Creating a SQL History......Page 138
Creating a Tuning Session......Page 141
Creating a Tuning Session Manually......Page 142
Setting the Scope of a Tuning Session......Page 143
Instance Optimizations......Page 144
SQL Reuse Opportunities......Page 145
Optimal Data Access......Page 146
Selecting Values for Tuning Session Characteristics......Page 147
Modifying a Tuning Session......Page 149
Saving Tuning Session Data to a Log File......Page 150
Collecting the Collection Classes......Page 151
How Oracle Expert Collects Class Data......Page 152
Collecting Data Efficiently......Page 153
Collecting the Database Class......Page 154
Re-Collecting Database Class Data......Page 155
Collecting Instance Class Data from One or More Instances......Page 156
Collecting Instance Class Data from a File......Page 157
Getting Less Conservative Instance Tuning Recommendations......Page 158
Collecting Schema Class Data from One or More Instances......Page 159
Collecting the System Class......Page 161
Collecting System Class Data from a File......Page 162
Collecting the Workload Class......Page 163
Workload Options......Page 164
Collecting Workload Class Data from a File......Page 165
Starting a Collection......Page 166
Collecting Invalid Data......Page 167
Review Page......Page 169
Databases......Page 170
Workload Applications......Page 173
Analyzing Data Efficiently......Page 175
Tunable Rule......Page 176
Invalid Objects Discovered During an Analysis......Page 177
Reviewing Tuning Recommendations......Page 178
Implementing Tuning Recommendations......Page 181
How to Use the Implementation Files......Page 182
Generating an Analysis Report......Page 183
Generating a Cross Reference Report......Page 184
Defining the Appropriate Tuning Scope......Page 187
Using Iterative Tuning for Improved Performance......Page 188
Taking Advantage of Rules......Page 189
Use SQL History to Avoid Extra SQL Collections......Page 191
Advantages of Using Oracle Expert for Initial Configuration......Page 193
Performing Initial Configuration for a Database......Page 194
User-Provided Information......Page 195
20 Autotune......Page 197
Viewing Autotune Recommendations......Page 198
Implementing Autotune Recommendations......Page 199
Database Workloads......Page 201
Collecting Workload Information with Oracle Trace......Page 203
Collecting Workload Information from the SQL History......Page 204
Specifying Importance Values......Page 205
Part V Getting Started with Oracle Index Tuning Wizard......Page 207
When to Use the Index Tuning Wizard......Page 209
Index Tuning Wizard Interface......Page 210
Index Recommendations......Page 211
Finish......Page 212
Part VI Getting Started with the Reorg Wizard......Page 213
23 Introduction to the Reorg Wizard......Page 215
When to use the Reorg Wizard......Page 216
Reorganizing an Entire Tablespace......Page 217
Reorganization Process......Page 218
Part VII Getting Started with the Tablespace Map......Page 223
24 Introduction to the Tablespace Map......Page 225
Viewing the Tablespace Map......Page 226
Analyzing Segments in a Tablespace......Page 228
Viewing Tablespace Analysis Results......Page 229
Launching Reorg Wizard to Correct Space Problems......Page 230
Part VIII Getting Started with Stored Outlines......Page 233
25 Introduction to Outline Management......Page 235
Accessing the Outline Management Tool......Page 236
Using the Outline Management Tool......Page 237
Accessing the Outline Editor......Page 239
Using Categories......Page 241
Editing an Outline......Page 242
Changing the Join Method......Page 243
Changing the Access Method......Page 245
Glossary......Page 249
Index......Page 271





کتاب های پزشکی

دانلود کتاب Encyclopedia of Medical Devices and Instrumentation

دانلود کتاب Why I Left Orthodox Medicine: Healing for the 21st Century

دانلود کتاب Colloidal nanoparticles in biotechnology

دانلود کتاب Environmental Forensics: Principles & Applications

دانلود کتاب Medicinal mushrooms: an exploration of tradition, healing & culture

کتاب های کامپیوتر

دانلود کتاب ICEfaces 1.8 Next Generation Enterprise Web Development

دانلود کتاب Highly Dependable Software

دانلود کتاب Accounting Information Systems, 7th Edition

دانلود کتاب Unity Game Development Essentials

دانلود کتاب Oracle Web Services Manager: Securing your Web Services

کتاب های ریاضی

دانلود کتاب Summer school on mathematical control theory

دانلود کتاب The geometry of fractal sets

دانلود کتاب Digital Signal Processing Techniques and Applications in Radar Image Processing

دانلود کتاب Moduli Spaces and Vector Bundles

دانلود کتاب Statistical Models

کتاب های تکنولوژی

دانلود کتاب Dendrimer-Based Nanomedicine

دانلود کتاب Controlled Growth of Nanomaterials

دانلود کتاب Defect-Oriented Testing for Nano-Metric CMOS VLSI Circuits

دانلود کتاب Safety, Reliability and Risk Analysis: Theory, Methods and Applications, 3rd Edition (4 Volumes)

دانلود کتاب Nanostructured materials : processing, properties and potential applications

کتاب های مذهبی

دانلود کتاب Ezekiel: A Commentary based on Iezeki?l in Codex Vaticanus

دانلود کتاب Yahweh is a Warrior: The Theology of Warfare in Ancient Israel

دانلود کتاب Heart of Islam, The: Enduring Values for Humanity

دانلود کتاب Embracing The Dark: The Magic Order Of Dragon Rouge: Its Practice In Dark Magic And Meaning Making

دانلود کتاب The White Man's Bible

کتاب های فیزیولوژی

دانلود کتاب Creative Teaching Strategies for the Nurse Educator

دانلود کتاب Alcohol (Junior Drug Awareness)

دانلود کتاب Introducing Psychology of Success: A Practical Guide

دانلود کتاب Hello Hi-Lo: Readers Theatre Math

دانلود کتاب Reproducing Empire: Race, Sex, Science, and U.S. Imperialism in Puerto Rico

کتاب های تاریخی

دانلود کتاب Sturmartillerie from Assault Guns to Hunting Panther

دانلود کتاب The New American navy

دانلود کتاب The end of the Imperial Japanese Navy

دانلود کتاب Sopwith Camel

دانلود کتاب Spanish Army of the Napoleonic Wars (2): 1808-12

کتاب های زیست شناسی

دانلود کتاب Mechanobiology Handbook

دانلود کتاب Salmonella in Domestic Animals

دانلود کتاب Innovation in Cultural Systems: Contributions from Evolutionary Anthropology (Vienna Series in Theoretical Biology)

دانلود کتاب Calcium Signaling Protocols

دانلود کتاب HPLC of Peptides and Proteins: Methods and Protocols (Methods in Molecular Biology)

کتاب های اقتصاد

دانلود کتاب Enterprise Risk Management Best Practices: From Assessment to Ongoing Compliance (Wiley Corporate F&A)

دانلود کتاب Supply Chain Risk Management: Vulnerability and Resilience in Logistics

دانلود کتاب CFA Level 1 Schweser Study Notes

دانلود کتاب Physical and logical security convergence: powered by enterprise security management

دانلود کتاب Perfect phrases for presenting business strategies: hundreds of ready-to-use phrases for writing effective, informative, and powerful strategy presentations

کتاب های آموزشی

دانلود کتاب FSTTCS 2004: Foundations of Software Technology and Theoretical Computer Science: 24th International Conference, Chennai, India, December 16-18, 2004. Proceedings

دانلود کتاب Learn to Read Science. ???? ??????????? ????? ??? ??????????

دانلود کتاب Pond & River (DK Eyewitness Books)

دانلود کتاب Electrokinetic And Colloid Transport Phenomena

دانلود کتاب Boobytraps: Fm 5-31

کتاب های حقوق

دانلود کتاب Enforcing International Law: From Self-help To Self-contained Regimes

دانلود کتاب Patent fundamentals for scientists and engineers

دانلود کتاب Real Choices: Feminism, Freedom, and the Limits of Law

دانلود کتاب Privacy Matters: Leading CTOs and Lawyers on What Every Business Professional Should Know About Privacy, Technology & the Internet (Inside the Minds)

دانلود کتاب Handbook of Justice Research in Law

کتاب های علوم انسانی

دانلود کتاب Hume on morality (GuideBook)

دانلود کتاب Postmodernism, or, The cultural logic of late capitalism

دانلود کتاب Phenomenology of Perception

دانلود کتاب No Gods No Masters: An Anthology of Anarchism

دانلود کتاب Our Politics, Our Selves? Liberalism, Identity, and Harm