Oracle parallel processing: [oracle parallel execution and oracle parallel server]
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip
O'Reilly
2000
|
| Ausgabe: | 1. ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XVII, 268 S. graph. Darst. : 24 cm |
| ISBN: | 156592701X |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV013388711 | ||
| 003 | DE-604 | ||
| 005 | 20011116 | ||
| 007 | t | ||
| 008 | 001010s2000 gw d||| |||| 00||| eng d | ||
| 016 | 7 | |a 959866736 |2 DE-101 | |
| 020 | |a 156592701X |c kart. : DM 70.00, $ 32.95 |9 1-56592-701-X | ||
| 035 | |a (OCoLC)313667394 | ||
| 035 | |a (DE-599)BVBBV013388711 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 044 | |a gw |c DE | ||
| 049 | |a DE-91G | ||
| 050 | 0 | |a QA76.58.M34 2000 | |
| 082 | 0 | |a 005.75/85 | |
| 084 | |a DAT 652f |2 stub | ||
| 084 | |a DAT 663f |2 stub | ||
| 100 | 1 | |a Mahapatra, Tushar |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Oracle parallel processing |b [oracle parallel execution and oracle parallel server] |c Tushar Mahapatra and Sanjay Mishra |
| 250 | |a 1. ed. | ||
| 264 | 1 | |a Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip |b O'Reilly |c 2000 | |
| 300 | |a XVII, 268 S. |b graph. Darst. : 24 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 630 | 0 | 4 | |a Oracle (Computer file) |
| 650 | 4 | |a Parallel processing Electronic computers | |
| 650 | 0 | 7 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a ORACLE WebServer |0 (DE-588)4420179-5 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Parallelverarbeitung |0 (DE-588)4075860-6 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |D s |
| 689 | 0 | 1 | |a Parallelverarbeitung |0 (DE-588)4075860-6 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a ORACLE WebServer |0 (DE-588)4420179-5 |D s |
| 689 | 1 | 1 | |a Parallelverarbeitung |0 (DE-588)4075860-6 |D s |
| 689 | 1 | |5 DE-604 | |
| 689 | 2 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 2 | 1 | |a Parallelverarbeitung |0 (DE-588)4075860-6 |D s |
| 689 | 2 | |5 DE-604 | |
| 700 | 1 | |a Mishra, Sanjay |e Verfasser |4 aut | |
| 856 | 4 | 2 | |m HEBIS Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009132911&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-009132911 | ||
Datensatz im Suchindex
| _version_ | 1804128169537568768 |
|---|---|
| adam_text | Oracle Parallel Processing
Tushar Mahapatra and Sanjay Mishra
O REILLY*
Beijing • Cambridge • Farnham • Koln • Paris • Sebastopol • Taipei • Tokyo
Table of Contents
Preface - xi
I Overview 1
1 Introduction 3
About Parallel Processing 3
Parallel Processing for Databases 6
Parallel Processing in Oracle 12
Overhead for Oracle Parallel Processing 17
Requirements for Oracle s Parallel Features 19
2 Architectures for Parallel Processing 23
Hardware Architectures 23
High-Speed Interconnect 31
Software Architectures of Parallel Database Systems 32
Oracle s Parallel Processing Architecture 36
II Oracle Parallel Execution 39
3 Parallel Execution Concepts 41
What Is Parallel SQL? 41
How Parallel Execution Works : 46
4 Using Parallel Execution 54
Parallel Query 54
Parallel DML 58
vii
viii Table of Contents
Parallel DDL 64
Parallel Data Loading 65
Parallel Recovery 69
Parallel Replication Propagation 70
5 Monitoring and Tuning Parallel Execution 72
Tuning Overview 72
Dynamic Performance Views 73
Using EXPLAIN PLAN to View Parallel Execution 84
Tuning Tips for Parallel Execution 87
Automatic Tuning of Parallel Execution in Oracle8f 89
III Oracle Parallel Server 93
6 Oracle Parallel Server Architecture 95
OPS and Oracle Instances 95
Synchronization Between Instances 100
OPS Impact on Database Files 102
Integrated Distributed Lock Manager 105
Group Membership Service 108
Rollback Segments in OPS 109
7 Administering an OPS Database 112
Creating an OPS Database 112
Starting and Stopping an OPS Database 120
Managing Instance Groups 123
Backing Up an OPS Database 124
Recovering an OPS Database 130
8 Locking Mechanisms in OPS 134
Cache Coherency 134
Lock Types in OPS 135
Lock Modes 137
Parallel Cache Management 139
PCM Lock Types 148
PCM Lock Allocation Parameters and Verification 152
PCM Lock Allocation Guidelines 158
Non-PCM Locks 763
Table of Contents ix
9 Storage Management in OPS 165
Using Free Lists and Free List Groups 165
The PCTFREE Parameter: Reserving Free Space 174
Using Reverse Key Indexes 175
10 Monitoring and Tuning OPS 176
OPS Performance Views 176
Dynamic Performance Views 177
Monitoring PCM Locking 178
Monitoring Overall Statistics 189
Monitoring and Tuning IDLM 195
Oracle Performance Manager 198
11 Partitioning for OPS 200
When Is Partitioning Needed? 200
Partitioning Techniques 201
Changing Your Partitioning Scheme 211
12 Application Failover 213
Maintaining a Failover Database 214
Planning for Failover with OPS 219
Failover Complexity 222
Failover Methods 224
13 Parallel Execution in OPS 233
How Parallel Execution Works with OPS 233
Disk Affinity 234
Instance Groups for Parallel Execution 236
Appendix: Case Studies 239
Index - 255
|
| any_adam_object | 1 |
| author | Mahapatra, Tushar Mishra, Sanjay |
| author_facet | Mahapatra, Tushar Mishra, Sanjay |
| author_role | aut aut |
| author_sort | Mahapatra, Tushar |
| author_variant | t m tm s m sm |
| building | Verbundindex |
| bvnumber | BV013388711 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.58.M34 2000 |
| callnumber-search | QA76.58.M34 2000 |
| callnumber-sort | QA 276.58 M34 42000 |
| callnumber-subject | QA - Mathematics |
| classification_tum | DAT 652f DAT 663f |
| ctrlnum | (OCoLC)313667394 (DE-599)BVBBV013388711 |
| dewey-full | 005.75/85 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/85 |
| dewey-search | 005.75/85 |
| dewey-sort | 15.75 285 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 1. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02126nam a2200541 c 4500</leader><controlfield tag="001">BV013388711</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20011116 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">001010s2000 gw d||| |||| 00||| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">959866736</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">156592701X</subfield><subfield code="c">kart. : DM 70.00, $ 32.95</subfield><subfield code="9">1-56592-701-X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)313667394</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV013388711</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">gw</subfield><subfield code="c">DE</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91G</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.58.M34 2000</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/85</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 652f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 663f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Mahapatra, Tushar</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle parallel processing</subfield><subfield code="b">[oracle parallel execution and oracle parallel server]</subfield><subfield code="c">Tushar Mahapatra and Sanjay Mishra</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2000</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVII, 268 S.</subfield><subfield code="b">graph. Darst. : 24 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Parallel processing Electronic computers</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE WebServer</subfield><subfield code="0">(DE-588)4420179-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Parallelverarbeitung</subfield><subfield code="0">(DE-588)4075860-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Parallelverarbeitung</subfield><subfield code="0">(DE-588)4075860-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">ORACLE WebServer</subfield><subfield code="0">(DE-588)4420179-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">Parallelverarbeitung</subfield><subfield code="0">(DE-588)4075860-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2="1"><subfield code="a">Parallelverarbeitung</subfield><subfield code="0">(DE-588)4075860-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Mishra, Sanjay</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HEBIS Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009132911&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-009132911</subfield></datafield></record></collection> |
| id | DE-604.BV013388711 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T18:44:58Z |
| institution | BVB |
| isbn | 156592701X |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-009132911 |
| oclc_num | 313667394 |
| open_access_boolean | |
| owner | DE-91G DE-BY-TUM |
| owner_facet | DE-91G DE-BY-TUM |
| physical | XVII, 268 S. graph. Darst. : 24 cm |
| publishDate | 2000 |
| publishDateSearch | 2000 |
| publishDateSort | 2000 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Mahapatra, Tushar Verfasser aut Oracle parallel processing [oracle parallel execution and oracle parallel server] Tushar Mahapatra and Sanjay Mishra 1. ed. Beijing ; Cambridge ; Farnham ; Köln ; Paris ; Sebastopol ; Taip O'Reilly 2000 XVII, 268 S. graph. Darst. : 24 cm txt rdacontent n rdamedia nc rdacarrier Oracle (Computer file) Parallel processing Electronic computers ORACLE Datenbanksystem (DE-588)4206222-6 gnd rswk-swf ORACLE WebServer (DE-588)4420179-5 gnd rswk-swf Parallelverarbeitung (DE-588)4075860-6 gnd rswk-swf SQL (DE-588)4134010-3 gnd rswk-swf ORACLE Datenbanksystem (DE-588)4206222-6 s Parallelverarbeitung (DE-588)4075860-6 s DE-604 ORACLE WebServer (DE-588)4420179-5 s SQL (DE-588)4134010-3 s Mishra, Sanjay Verfasser aut HEBIS Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009132911&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Mahapatra, Tushar Mishra, Sanjay Oracle parallel processing [oracle parallel execution and oracle parallel server] Oracle (Computer file) Parallel processing Electronic computers ORACLE Datenbanksystem (DE-588)4206222-6 gnd ORACLE WebServer (DE-588)4420179-5 gnd Parallelverarbeitung (DE-588)4075860-6 gnd SQL (DE-588)4134010-3 gnd |
| subject_GND | (DE-588)4206222-6 (DE-588)4420179-5 (DE-588)4075860-6 (DE-588)4134010-3 |
| title | Oracle parallel processing [oracle parallel execution and oracle parallel server] |
| title_auth | Oracle parallel processing [oracle parallel execution and oracle parallel server] |
| title_exact_search | Oracle parallel processing [oracle parallel execution and oracle parallel server] |
| title_full | Oracle parallel processing [oracle parallel execution and oracle parallel server] Tushar Mahapatra and Sanjay Mishra |
| title_fullStr | Oracle parallel processing [oracle parallel execution and oracle parallel server] Tushar Mahapatra and Sanjay Mishra |
| title_full_unstemmed | Oracle parallel processing [oracle parallel execution and oracle parallel server] Tushar Mahapatra and Sanjay Mishra |
| title_short | Oracle parallel processing |
| title_sort | oracle parallel processing oracle parallel execution and oracle parallel server |
| title_sub | [oracle parallel execution and oracle parallel server] |
| topic | Oracle (Computer file) Parallel processing Electronic computers ORACLE Datenbanksystem (DE-588)4206222-6 gnd ORACLE WebServer (DE-588)4420179-5 gnd Parallelverarbeitung (DE-588)4075860-6 gnd SQL (DE-588)4134010-3 gnd |
| topic_facet | Oracle (Computer file) Parallel processing Electronic computers ORACLE Datenbanksystem ORACLE WebServer Parallelverarbeitung SQL |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009132911&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT mahapatratushar oracleparallelprocessingoracleparallelexecutionandoracleparallelserver AT mishrasanjay oracleparallelprocessingoracleparallelexecutionandoracleparallelserver |