Oracle 10g/11g data and database management utilities :: master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task /
"Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources. You don't have to reinvent the wheel, just learn how to properly use the Oracle...
Gespeichert in:
1. Verfasser: | |
---|---|
Weitere Verfasser: | , , |
Format: | Elektronisch E-Book |
Sprache: | English |
Veröffentlicht: |
Birmingham, U.K. :
Packt Pub.,
2009.
|
Schriftenreihe: | From technologies to solutions.
|
Schlagworte: | |
Online-Zugang: | Volltext |
Zusammenfassung: | "Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources. You don't have to reinvent the wheel, just learn how to properly use the Oracle Utilities to achieve your goals. This is what this book is about; it covers topics oriented towards data management, session management, batch processing, massive deployment, troubleshooting, and how to make the most out of the frequently used DBA tools to improve your daily work"--Resource description page. |
Beschreibung: | Title from title screen. Includes index. |
Beschreibung: | 1 online resource (ix, 413 pages) : illustrations. |
ISBN: | 9781847196293 1847196292 1282172344 9781282172340 9786612172342 6612172347 |
Internformat
MARC
LEADER | 00000cam a2200000Ma 4500 | ||
---|---|---|---|
001 | ZDB-4-EBA-ocn440647280 | ||
003 | OCoLC | ||
005 | 20241004212047.0 | ||
006 | m o d | ||
007 | cr zn||||||||| | ||
008 | 090828s2009 enka o 001 0 eng d | ||
040 | |a YUS |b eng |e pn |c YUS |d UMI |d IDEBK |d CEF |d N$T |d E7B |d OCLCQ |d B24X7 |d DEBSZ |d UKMGB |d OCLCQ |d DKDLA |d YDXCP |d OCLCQ |d OCLCF |d OCLCQ |d AGLDB |d MOR |d PIFAG |d LIV |d OCLCQ |d JBG |d U3W |d STF |d WRM |d VTS |d COCUF |d NLE |d INT |d AU@ |d COO |d OCLCQ |d OCLCO |d OCLCQ |d M8D |d OCLCO |d UKAHL |d HS0 |d UKCRE |d VLY |d OCLCO |d OCLCQ |d OCLCO |d OCLCL |d EZC | ||
015 | |a GBB6G3809 |2 bnb | ||
016 | 7 | |a 015849791 |2 Uk | |
016 | 7 | |a 018011675 |2 Uk | |
019 | |a 614436659 |a 666944456 |a 698103878 |a 712995795 |a 764547487 |a 765143306 |a 961501151 |a 962569652 |a 988467196 |a 992035948 |a 1034911068 |a 1037727365 |a 1038618262 |a 1058481026 |a 1153545383 |a 1162229813 |a 1241826052 |a 1290094557 |a 1300577316 | ||
020 | |a 9781847196293 |q (electronic bk.) | ||
020 | |a 1847196292 |q (electronic bk.) | ||
020 | |z 9781847196286 | ||
020 | |z 1847196284 | ||
020 | |a 1282172344 | ||
020 | |a 9781282172340 | ||
020 | |a 9786612172342 | ||
020 | |a 6612172347 | ||
035 | |a (OCoLC)440647280 |z (OCoLC)614436659 |z (OCoLC)666944456 |z (OCoLC)698103878 |z (OCoLC)712995795 |z (OCoLC)764547487 |z (OCoLC)765143306 |z (OCoLC)961501151 |z (OCoLC)962569652 |z (OCoLC)988467196 |z (OCoLC)992035948 |z (OCoLC)1034911068 |z (OCoLC)1037727365 |z (OCoLC)1038618262 |z (OCoLC)1058481026 |z (OCoLC)1153545383 |z (OCoLC)1162229813 |z (OCoLC)1241826052 |z (OCoLC)1290094557 |z (OCoLC)1300577316 | ||
037 | |a CL0500000067 |b Safari Books Online | ||
050 | 4 | |a QA76.9.D3 |b M33 2009eb | |
072 | 7 | |a COM |x 021000 |2 bisacsh | |
082 | 7 | |a 005.75/85 |2 22 | |
049 | |a MAIN | ||
100 | 1 | |a Madrid, Hector R. | |
245 | 1 | 0 | |a Oracle 10g/11g data and database management utilities : |b master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / |c Hector R. Madrid ; reviewers, Hans Forbrich, Peter McLarty, Ulises Lazarini. |
260 | |a Birmingham, U.K. : |b Packt Pub., |c 2009. | ||
300 | |a 1 online resource (ix, 413 pages) : |b illustrations. | ||
336 | |a text |b txt |2 rdacontent | ||
337 | |a computer |b c |2 rdamedia | ||
338 | |a online resource |b cr |2 rdacarrier | ||
490 | 1 | |a From technologies to solutions | |
500 | |a Title from title screen. | ||
500 | |a Includes index. | ||
520 | |a "Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources. You don't have to reinvent the wheel, just learn how to properly use the Oracle Utilities to achieve your goals. This is what this book is about; it covers topics oriented towards data management, session management, batch processing, massive deployment, troubleshooting, and how to make the most out of the frequently used DBA tools to improve your daily work"--Resource description page. | ||
505 | 0 | |a Cover; Table of Contents; Preface; Chapter 1: Data Pump; Data Pump features; Data Pump architecture; Setting up the practical scenarios; Data Pump export; Data Pump export modes; A simple Data Pump export session; Data Pump export filtering operations; Use of parameter file; Retrieve original data; Data Pump export space estimation; Dump file multiplexing; Transporting data among different versions; Data Pump export interactive mode; Data Pump restart capability; Getting information about the export job; Data Pump import; Remap function; Data Pump import network mode | |
505 | 8 | |a Improving performance with Data PumpWorking with the Data Pump API; Data Pump 11g new features; Compression; Encrypted dump file sets; Enhancements for Data Pump External Tables; Single partition transportable for Oracle Data Pump; Overwrite dump files; XML Datatypes; Summary; Chapter 2: SQL*Loader; SQL*Loader basics; Preparing the demo environment; Our first simple load; The SQL*Loader log file; Fixed record size format load; Variable record size format load; Stream record format load; Specifying a particular character set; Load on the fly; Direct path versus Conventional path load | |
505 | 8 | |a Direct path load prosDirect path load cons; Loading Large Objects (LOBs); Loading multimedia files; Resumable load; Parallel load; General performance booster tips; Summary; Chapter 3: External Tables; The External Table basics; Let's setup the environment; A basic External Table; Creating External Table metadata, the easy way; Unloading data to External Tables; Inter-version compatibility; Data transformation with External Tables; Extending the alert.log analysis with External Tables; Reading the listener.log from the database; Mapping XML files as External Tables | |
505 | 8 | |a Dynamically changing the external referenceOracle 11g External Table enhancements; Summary; Chapter 4: Recovery Manager Advanced Techniques; Recovery Manager basics; Getting started with a Recovery Manager session; Format masks used by recovery manager; What happens in a user-managed online backup?; Myths related to the online backup method; Configuring a multiplexed backup; Configuring the RMAN recovery catalog; A simple backup session; Backup compression; Fast backup compression; Improving data set compression with the ZLIB algorithm (11g only) | |
505 | 8 | |a Faster backups through intra-file parallel backup and restore operations (11g only)Block media recovery; Backup duration and throttling; Database cloning; Database cloning procedure; Database cloning on the fly (11g only); Inter-platform database migration; Migrate to and from an ASM environment; General backup advices; Summary; Chapter 5: Recovery Manager Restore and Recovery Techniques; Oracle database recovery; Instance failure; Media failure; Complete recovery; Incomplete recovery; Loss of data files; Queries used to diagnose data files; Loss of a non-critical datafile | |
546 | |a English. | ||
630 | 0 | 0 | |a Oracle (Computer file) |0 http://id.loc.gov/authorities/names/n91015760 |
630 | 0 | 7 | |a Oracle (Computer file) |2 blmlsh |
630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
650 | 0 | |a Relational databases. |0 http://id.loc.gov/authorities/subjects/sh86007768 | |
650 | 6 | |a Bases de données |x Gestion. | |
650 | 6 | |a Bases de données relationnelles. | |
650 | 7 | |a COMPUTERS |x Database Management |x General. |2 bisacsh | |
650 | 7 | |a Database management. |2 blmlsh | |
650 | 7 | |a Relational databases. |2 blmlsh | |
650 | 7 | |a Database management |2 fast | |
650 | 7 | |a Relational databases |2 fast | |
655 | 7 | |a dissertations. |2 aat | |
655 | 7 | |a Academic theses |2 fast | |
655 | 7 | |a Academic theses. |2 lcgft |0 http://id.loc.gov/authorities/genreForms/gf2014026039 | |
655 | 7 | |a Thèses et écrits académiques. |2 rvmgf | |
700 | 1 | |a Forbrich, Hans. |4 rev | |
700 | 1 | |a McLarty, Peter. |4 rev | |
700 | 1 | |a Lazarini, Ulises. |4 rev | |
758 | |i has work: |a Oracle 10g/11g data and database management utilities (Text) |1 https://id.oclc.org/worldcat/entity/E39PCFxwYV46WR6bxF38m8Dd6X |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
776 | 0 | 8 | |i Print version: |a Madrid, Hector R. |t Oracle 10g/11g data and database management utilities. |d Birmingham, U.K. : Packt Publishing, 2009 |z 9781847196286 |w (OCoLC)456626602 |
830 | 0 | |a From technologies to solutions. |0 http://id.loc.gov/authorities/names/no2008038412 | |
856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=351730 |3 Volltext |
938 | |a Askews and Holts Library Services |b ASKH |n AH26942835 | ||
938 | |a Books 24x7 |b B247 |n bks00031735 | ||
938 | |a ebrary |b EBRY |n ebr10433560 | ||
938 | |a EBSCOhost |b EBSC |n 351730 | ||
938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n 217234 | ||
938 | |a YBP Library Services |b YANK |n 3601803 | ||
994 | |a 92 |b GEBAY | ||
912 | |a ZDB-4-EBA | ||
049 | |a DE-863 |
Datensatz im Suchindex
DE-BY-FWS_katkey | ZDB-4-EBA-ocn440647280 |
---|---|
_version_ | 1816881699904028672 |
adam_text | |
any_adam_object | |
author | Madrid, Hector R. |
author2 | Forbrich, Hans McLarty, Peter Lazarini, Ulises |
author2_role | rev rev rev |
author2_variant | h f hf p m pm u l ul |
author_facet | Madrid, Hector R. Forbrich, Hans McLarty, Peter Lazarini, Ulises |
author_role | |
author_sort | Madrid, Hector R. |
author_variant | h r m hr hrm |
building | Verbundindex |
bvnumber | localFWS |
callnumber-first | Q - Science |
callnumber-label | QA76 |
callnumber-raw | QA76.9.D3 M33 2009eb |
callnumber-search | QA76.9.D3 M33 2009eb |
callnumber-sort | QA 276.9 D3 M33 42009EB |
callnumber-subject | QA - Mathematics |
collection | ZDB-4-EBA |
contents | Cover; Table of Contents; Preface; Chapter 1: Data Pump; Data Pump features; Data Pump architecture; Setting up the practical scenarios; Data Pump export; Data Pump export modes; A simple Data Pump export session; Data Pump export filtering operations; Use of parameter file; Retrieve original data; Data Pump export space estimation; Dump file multiplexing; Transporting data among different versions; Data Pump export interactive mode; Data Pump restart capability; Getting information about the export job; Data Pump import; Remap function; Data Pump import network mode Improving performance with Data PumpWorking with the Data Pump API; Data Pump 11g new features; Compression; Encrypted dump file sets; Enhancements for Data Pump External Tables; Single partition transportable for Oracle Data Pump; Overwrite dump files; XML Datatypes; Summary; Chapter 2: SQL*Loader; SQL*Loader basics; Preparing the demo environment; Our first simple load; The SQL*Loader log file; Fixed record size format load; Variable record size format load; Stream record format load; Specifying a particular character set; Load on the fly; Direct path versus Conventional path load Direct path load prosDirect path load cons; Loading Large Objects (LOBs); Loading multimedia files; Resumable load; Parallel load; General performance booster tips; Summary; Chapter 3: External Tables; The External Table basics; Let's setup the environment; A basic External Table; Creating External Table metadata, the easy way; Unloading data to External Tables; Inter-version compatibility; Data transformation with External Tables; Extending the alert.log analysis with External Tables; Reading the listener.log from the database; Mapping XML files as External Tables Dynamically changing the external referenceOracle 11g External Table enhancements; Summary; Chapter 4: Recovery Manager Advanced Techniques; Recovery Manager basics; Getting started with a Recovery Manager session; Format masks used by recovery manager; What happens in a user-managed online backup?; Myths related to the online backup method; Configuring a multiplexed backup; Configuring the RMAN recovery catalog; A simple backup session; Backup compression; Fast backup compression; Improving data set compression with the ZLIB algorithm (11g only) Faster backups through intra-file parallel backup and restore operations (11g only)Block media recovery; Backup duration and throttling; Database cloning; Database cloning procedure; Database cloning on the fly (11g only); Inter-platform database migration; Migrate to and from an ASM environment; General backup advices; Summary; Chapter 5: Recovery Manager Restore and Recovery Techniques; Oracle database recovery; Instance failure; Media failure; Complete recovery; Incomplete recovery; Loss of data files; Queries used to diagnose data files; Loss of a non-critical datafile |
ctrlnum | (OCoLC)440647280 |
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 |
format | Electronic eBook |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>07882cam a2200889Ma 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn440647280</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr zn|||||||||</controlfield><controlfield tag="008">090828s2009 enka o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">YUS</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">YUS</subfield><subfield code="d">UMI</subfield><subfield code="d">IDEBK</subfield><subfield code="d">CEF</subfield><subfield code="d">N$T</subfield><subfield code="d">E7B</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">B24X7</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">DKDLA</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AGLDB</subfield><subfield code="d">MOR</subfield><subfield code="d">PIFAG</subfield><subfield code="d">LIV</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">JBG</subfield><subfield code="d">U3W</subfield><subfield code="d">STF</subfield><subfield code="d">WRM</subfield><subfield code="d">VTS</subfield><subfield code="d">COCUF</subfield><subfield code="d">NLE</subfield><subfield code="d">INT</subfield><subfield code="d">AU@</subfield><subfield code="d">COO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">M8D</subfield><subfield code="d">OCLCO</subfield><subfield code="d">UKAHL</subfield><subfield code="d">HS0</subfield><subfield code="d">UKCRE</subfield><subfield code="d">VLY</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield><subfield code="d">EZC</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB6G3809</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">015849791</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018011675</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">614436659</subfield><subfield code="a">666944456</subfield><subfield code="a">698103878</subfield><subfield code="a">712995795</subfield><subfield code="a">764547487</subfield><subfield code="a">765143306</subfield><subfield code="a">961501151</subfield><subfield code="a">962569652</subfield><subfield code="a">988467196</subfield><subfield code="a">992035948</subfield><subfield code="a">1034911068</subfield><subfield code="a">1037727365</subfield><subfield code="a">1038618262</subfield><subfield code="a">1058481026</subfield><subfield code="a">1153545383</subfield><subfield code="a">1162229813</subfield><subfield code="a">1241826052</subfield><subfield code="a">1290094557</subfield><subfield code="a">1300577316</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781847196293</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1847196292</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781847196286</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1847196284</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1282172344</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781282172340</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9786612172342</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">6612172347</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)440647280</subfield><subfield code="z">(OCoLC)614436659</subfield><subfield code="z">(OCoLC)666944456</subfield><subfield code="z">(OCoLC)698103878</subfield><subfield code="z">(OCoLC)712995795</subfield><subfield code="z">(OCoLC)764547487</subfield><subfield code="z">(OCoLC)765143306</subfield><subfield code="z">(OCoLC)961501151</subfield><subfield code="z">(OCoLC)962569652</subfield><subfield code="z">(OCoLC)988467196</subfield><subfield code="z">(OCoLC)992035948</subfield><subfield code="z">(OCoLC)1034911068</subfield><subfield code="z">(OCoLC)1037727365</subfield><subfield code="z">(OCoLC)1038618262</subfield><subfield code="z">(OCoLC)1058481026</subfield><subfield code="z">(OCoLC)1153545383</subfield><subfield code="z">(OCoLC)1162229813</subfield><subfield code="z">(OCoLC)1241826052</subfield><subfield code="z">(OCoLC)1290094557</subfield><subfield code="z">(OCoLC)1300577316</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000067</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">M33 2009eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">021000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.75/85</subfield><subfield code="2">22</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Madrid, Hector R.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle 10g/11g data and database management utilities :</subfield><subfield code="b">master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task /</subfield><subfield code="c">Hector R. Madrid ; reviewers, Hans Forbrich, Peter McLarty, Ulises Lazarini.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham, U.K. :</subfield><subfield code="b">Packt Pub.,</subfield><subfield code="c">2009.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (ix, 413 pages) :</subfield><subfield code="b">illustrations.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">From technologies to solutions</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Title from title screen.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">"Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources. You don't have to reinvent the wheel, just learn how to properly use the Oracle Utilities to achieve your goals. This is what this book is about; it covers topics oriented towards data management, session management, batch processing, massive deployment, troubleshooting, and how to make the most out of the frequently used DBA tools to improve your daily work"--Resource description page.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Table of Contents; Preface; Chapter 1: Data Pump; Data Pump features; Data Pump architecture; Setting up the practical scenarios; Data Pump export; Data Pump export modes; A simple Data Pump export session; Data Pump export filtering operations; Use of parameter file; Retrieve original data; Data Pump export space estimation; Dump file multiplexing; Transporting data among different versions; Data Pump export interactive mode; Data Pump restart capability; Getting information about the export job; Data Pump import; Remap function; Data Pump import network mode</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Improving performance with Data PumpWorking with the Data Pump API; Data Pump 11g new features; Compression; Encrypted dump file sets; Enhancements for Data Pump External Tables; Single partition transportable for Oracle Data Pump; Overwrite dump files; XML Datatypes; Summary; Chapter 2: SQL*Loader; SQL*Loader basics; Preparing the demo environment; Our first simple load; The SQL*Loader log file; Fixed record size format load; Variable record size format load; Stream record format load; Specifying a particular character set; Load on the fly; Direct path versus Conventional path load</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Direct path load prosDirect path load cons; Loading Large Objects (LOBs); Loading multimedia files; Resumable load; Parallel load; General performance booster tips; Summary; Chapter 3: External Tables; The External Table basics; Let's setup the environment; A basic External Table; Creating External Table metadata, the easy way; Unloading data to External Tables; Inter-version compatibility; Data transformation with External Tables; Extending the alert.log analysis with External Tables; Reading the listener.log from the database; Mapping XML files as External Tables</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Dynamically changing the external referenceOracle 11g External Table enhancements; Summary; Chapter 4: Recovery Manager Advanced Techniques; Recovery Manager basics; Getting started with a Recovery Manager session; Format masks used by recovery manager; What happens in a user-managed online backup?; Myths related to the online backup method; Configuring a multiplexed backup; Configuring the RMAN recovery catalog; A simple backup session; Backup compression; Fast backup compression; Improving data set compression with the ZLIB algorithm (11g only)</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Faster backups through intra-file parallel backup and restore operations (11g only)Block media recovery; Backup duration and throttling; Database cloning; Database cloning procedure; Database cloning on the fly (11g only); Inter-platform database migration; Migrate to and from an ASM environment; General backup advices; Summary; Chapter 5: Recovery Manager Restore and Recovery Techniques; Oracle database recovery; Instance failure; Media failure; Complete recovery; Incomplete recovery; Loss of data files; Queries used to diagnose data files; Loss of a non-critical datafile</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">Oracle (Computer file)</subfield><subfield code="0">http://id.loc.gov/authorities/names/n91015760</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Oracle (Computer file)</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Oracle (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Relational databases.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh86007768</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données relationnelles.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Database Management</subfield><subfield code="x">General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management.</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Relational databases.</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Relational databases</subfield><subfield code="2">fast</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">dissertations.</subfield><subfield code="2">aat</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Academic theses</subfield><subfield code="2">fast</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Academic theses.</subfield><subfield code="2">lcgft</subfield><subfield code="0">http://id.loc.gov/authorities/genreForms/gf2014026039</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Thèses et écrits académiques.</subfield><subfield code="2">rvmgf</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Forbrich, Hans.</subfield><subfield code="4">rev</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">McLarty, Peter.</subfield><subfield code="4">rev</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Lazarini, Ulises.</subfield><subfield code="4">rev</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Oracle 10g/11g data and database management utilities (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCFxwYV46WR6bxF38m8Dd6X</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Madrid, Hector R.</subfield><subfield code="t">Oracle 10g/11g data and database management utilities.</subfield><subfield code="d">Birmingham, U.K. : Packt Publishing, 2009</subfield><subfield code="z">9781847196286</subfield><subfield code="w">(OCoLC)456626602</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">From technologies to solutions.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2008038412</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=351730</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26942835</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Books 24x7</subfield><subfield code="b">B247</subfield><subfield code="n">bks00031735</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10433560</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">351730</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">217234</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">3601803</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
genre | dissertations. aat Academic theses fast Academic theses. lcgft http://id.loc.gov/authorities/genreForms/gf2014026039 Thèses et écrits académiques. rvmgf |
genre_facet | dissertations. Academic theses Academic theses. Thèses et écrits académiques. |
id | ZDB-4-EBA-ocn440647280 |
illustrated | Illustrated |
indexdate | 2024-11-27T13:16:52Z |
institution | BVB |
isbn | 9781847196293 1847196292 1282172344 9781282172340 9786612172342 6612172347 |
language | English |
oclc_num | 440647280 |
open_access_boolean | |
owner | MAIN DE-863 DE-BY-FWS |
owner_facet | MAIN DE-863 DE-BY-FWS |
physical | 1 online resource (ix, 413 pages) : illustrations. |
psigel | ZDB-4-EBA |
publishDate | 2009 |
publishDateSearch | 2009 |
publishDateSort | 2009 |
publisher | Packt Pub., |
record_format | marc |
series | From technologies to solutions. |
series2 | From technologies to solutions |
spelling | Madrid, Hector R. Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / Hector R. Madrid ; reviewers, Hans Forbrich, Peter McLarty, Ulises Lazarini. Birmingham, U.K. : Packt Pub., 2009. 1 online resource (ix, 413 pages) : illustrations. text txt rdacontent computer c rdamedia online resource cr rdacarrier From technologies to solutions Title from title screen. Includes index. "Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources. You don't have to reinvent the wheel, just learn how to properly use the Oracle Utilities to achieve your goals. This is what this book is about; it covers topics oriented towards data management, session management, batch processing, massive deployment, troubleshooting, and how to make the most out of the frequently used DBA tools to improve your daily work"--Resource description page. Cover; Table of Contents; Preface; Chapter 1: Data Pump; Data Pump features; Data Pump architecture; Setting up the practical scenarios; Data Pump export; Data Pump export modes; A simple Data Pump export session; Data Pump export filtering operations; Use of parameter file; Retrieve original data; Data Pump export space estimation; Dump file multiplexing; Transporting data among different versions; Data Pump export interactive mode; Data Pump restart capability; Getting information about the export job; Data Pump import; Remap function; Data Pump import network mode Improving performance with Data PumpWorking with the Data Pump API; Data Pump 11g new features; Compression; Encrypted dump file sets; Enhancements for Data Pump External Tables; Single partition transportable for Oracle Data Pump; Overwrite dump files; XML Datatypes; Summary; Chapter 2: SQL*Loader; SQL*Loader basics; Preparing the demo environment; Our first simple load; The SQL*Loader log file; Fixed record size format load; Variable record size format load; Stream record format load; Specifying a particular character set; Load on the fly; Direct path versus Conventional path load Direct path load prosDirect path load cons; Loading Large Objects (LOBs); Loading multimedia files; Resumable load; Parallel load; General performance booster tips; Summary; Chapter 3: External Tables; The External Table basics; Let's setup the environment; A basic External Table; Creating External Table metadata, the easy way; Unloading data to External Tables; Inter-version compatibility; Data transformation with External Tables; Extending the alert.log analysis with External Tables; Reading the listener.log from the database; Mapping XML files as External Tables Dynamically changing the external referenceOracle 11g External Table enhancements; Summary; Chapter 4: Recovery Manager Advanced Techniques; Recovery Manager basics; Getting started with a Recovery Manager session; Format masks used by recovery manager; What happens in a user-managed online backup?; Myths related to the online backup method; Configuring a multiplexed backup; Configuring the RMAN recovery catalog; A simple backup session; Backup compression; Fast backup compression; Improving data set compression with the ZLIB algorithm (11g only) Faster backups through intra-file parallel backup and restore operations (11g only)Block media recovery; Backup duration and throttling; Database cloning; Database cloning procedure; Database cloning on the fly (11g only); Inter-platform database migration; Migrate to and from an ASM environment; General backup advices; Summary; Chapter 5: Recovery Manager Restore and Recovery Techniques; Oracle database recovery; Instance failure; Media failure; Complete recovery; Incomplete recovery; Loss of data files; Queries used to diagnose data files; Loss of a non-critical datafile English. Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) blmlsh Oracle (Computer file) fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données Gestion. Bases de données relationnelles. COMPUTERS Database Management General. bisacsh Database management. blmlsh Relational databases. blmlsh Database management fast Relational databases fast dissertations. aat Academic theses fast Academic theses. lcgft http://id.loc.gov/authorities/genreForms/gf2014026039 Thèses et écrits académiques. rvmgf Forbrich, Hans. rev McLarty, Peter. rev Lazarini, Ulises. rev has work: Oracle 10g/11g data and database management utilities (Text) https://id.oclc.org/worldcat/entity/E39PCFxwYV46WR6bxF38m8Dd6X https://id.oclc.org/worldcat/ontology/hasWork Print version: Madrid, Hector R. Oracle 10g/11g data and database management utilities. Birmingham, U.K. : Packt Publishing, 2009 9781847196286 (OCoLC)456626602 From technologies to solutions. http://id.loc.gov/authorities/names/no2008038412 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=351730 Volltext |
spellingShingle | Madrid, Hector R. Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / From technologies to solutions. Cover; Table of Contents; Preface; Chapter 1: Data Pump; Data Pump features; Data Pump architecture; Setting up the practical scenarios; Data Pump export; Data Pump export modes; A simple Data Pump export session; Data Pump export filtering operations; Use of parameter file; Retrieve original data; Data Pump export space estimation; Dump file multiplexing; Transporting data among different versions; Data Pump export interactive mode; Data Pump restart capability; Getting information about the export job; Data Pump import; Remap function; Data Pump import network mode Improving performance with Data PumpWorking with the Data Pump API; Data Pump 11g new features; Compression; Encrypted dump file sets; Enhancements for Data Pump External Tables; Single partition transportable for Oracle Data Pump; Overwrite dump files; XML Datatypes; Summary; Chapter 2: SQL*Loader; SQL*Loader basics; Preparing the demo environment; Our first simple load; The SQL*Loader log file; Fixed record size format load; Variable record size format load; Stream record format load; Specifying a particular character set; Load on the fly; Direct path versus Conventional path load Direct path load prosDirect path load cons; Loading Large Objects (LOBs); Loading multimedia files; Resumable load; Parallel load; General performance booster tips; Summary; Chapter 3: External Tables; The External Table basics; Let's setup the environment; A basic External Table; Creating External Table metadata, the easy way; Unloading data to External Tables; Inter-version compatibility; Data transformation with External Tables; Extending the alert.log analysis with External Tables; Reading the listener.log from the database; Mapping XML files as External Tables Dynamically changing the external referenceOracle 11g External Table enhancements; Summary; Chapter 4: Recovery Manager Advanced Techniques; Recovery Manager basics; Getting started with a Recovery Manager session; Format masks used by recovery manager; What happens in a user-managed online backup?; Myths related to the online backup method; Configuring a multiplexed backup; Configuring the RMAN recovery catalog; A simple backup session; Backup compression; Fast backup compression; Improving data set compression with the ZLIB algorithm (11g only) Faster backups through intra-file parallel backup and restore operations (11g only)Block media recovery; Backup duration and throttling; Database cloning; Database cloning procedure; Database cloning on the fly (11g only); Inter-platform database migration; Migrate to and from an ASM environment; General backup advices; Summary; Chapter 5: Recovery Manager Restore and Recovery Techniques; Oracle database recovery; Instance failure; Media failure; Complete recovery; Incomplete recovery; Loss of data files; Queries used to diagnose data files; Loss of a non-critical datafile Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) blmlsh Oracle (Computer file) fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données Gestion. Bases de données relationnelles. COMPUTERS Database Management General. bisacsh Database management. blmlsh Relational databases. blmlsh Database management fast Relational databases fast |
subject_GND | http://id.loc.gov/authorities/names/n91015760 http://id.loc.gov/authorities/subjects/sh85035848 http://id.loc.gov/authorities/subjects/sh86007768 http://id.loc.gov/authorities/genreForms/gf2014026039 |
title | Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / |
title_auth | Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / |
title_exact_search | Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / |
title_full | Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / Hector R. Madrid ; reviewers, Hans Forbrich, Peter McLarty, Ulises Lazarini. |
title_fullStr | Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / Hector R. Madrid ; reviewers, Hans Forbrich, Peter McLarty, Ulises Lazarini. |
title_full_unstemmed | Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / Hector R. Madrid ; reviewers, Hans Forbrich, Peter McLarty, Ulises Lazarini. |
title_short | Oracle 10g/11g data and database management utilities : |
title_sort | oracle 10g 11g data and database management utilities master twelve must use utilities to optimize the efficiency management and performance of your daily database task |
title_sub | master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / |
topic | Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) blmlsh Oracle (Computer file) fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données Gestion. Bases de données relationnelles. COMPUTERS Database Management General. bisacsh Database management. blmlsh Relational databases. blmlsh Database management fast Relational databases fast |
topic_facet | Oracle (Computer file) Database management. Relational databases. Bases de données Gestion. Bases de données relationnelles. COMPUTERS Database Management General. Database management Relational databases dissertations. Academic theses Academic theses. Thèses et écrits académiques. |
url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=351730 |
work_keys_str_mv | AT madridhectorr oracle10g11gdataanddatabasemanagementutilitiesmastertwelvemustuseutilitiestooptimizetheefficiencymanagementandperformanceofyourdailydatabasetask AT forbrichhans oracle10g11gdataanddatabasemanagementutilitiesmastertwelvemustuseutilitiestooptimizetheefficiencymanagementandperformanceofyourdailydatabasetask AT mclartypeter oracle10g11gdataanddatabasemanagementutilitiesmastertwelvemustuseutilitiestooptimizetheefficiencymanagementandperformanceofyourdailydatabasetask AT lazariniulises oracle10g11gdataanddatabasemanagementutilitiesmastertwelvemustuseutilitiestooptimizetheefficiencymanagementandperformanceofyourdailydatabasetask |