Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / / Ann L.R. McKinnell [and] Eric Yen
| Oracle 11g Streams implementer's guide : design, implement, and maintain a distributed environment with Oracle Streams / / Ann L.R. McKinnell [and] Eric Yen |
| Autore | McKinnell Ann L. R |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Pub., 2010 |
| Descrizione fisica | 1 online resource (352 p.) |
| Disciplina | 005.7575 |
| Altri autori (Persone) | YenEric |
| Collana | From technologies to solutions |
| Soggetto topico |
Database management
Distributed databases Electronic data processing - Distributed processing |
| ISBN |
1-282-50184-4
9786612501845 1-84719-971-2 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; Table of Contents; Preface; Chapter 1: All the Pieces: The Parts of an Oracle 11g Streams Environment; Streams architecture overview; Topology configurations; Single source; Multiple source; Simultaneous versus Synchronous replication; Oracle's Streams replication process flow; Streams components; About those Queues; Capture process-what are we supposed to stream?; Downstream Capture; Synchronous Capture; Instantiation; What sets the instantiation SCN and when?; Propagate process; The Network: COMLINK
Propagation success/failurePropagation Stream Split and Merge; Apply process; Trigger firing and Apply; Combined Capture and Apply; SCN Coordination-keeps it flowing smoothly; The SCNs of Capture; FIRST_SCN; START_SCN; REQUIRED_CHECKPOINT_SCN; CAPTURED_SCN; APPLIED_SCN; MAXIMUM_SCN; LAST_ENQUEUED_SCN; SOURCE_RESETLOGS_SCN; MAX_CHECKPOINT_SCN; The SCNs of Propagation; The SCNs of Apply; IGNORE_SCN; MAXIMUM_SCN; OLDEST_SCN_NUM; Low-watermark SCN; SCN SYNC-hronization; Capture checkpointing; Archive Log availability; LCRs-what they are and how they work; Extracting data from an LCR Conflict detection and the LCRControlling conflict detection; Types of LCRs and how they get created; Oracle 11g memory and storage architecture (basic) relating to Streams; A word on performance; Streams Change tables; Oracle GoldenGate XSTREAMS; Summary; Chapter 2: Plot Your Course: Design Considerations; Why?; What?; Where?; Who and How?; When and How?; Other factors to consider; Network capabilities; Transaction sizes; Potential queue growth; Additional hardware resource requirements; Administration and maintenance costs; Third party application requirements; Security; Change auditing Platform and version compatibilityKISS; Design aid: Streams site matrix; The Matrix template; Summary; Chapter 3: Prepare the Rafts and Secure Your Gear: The pre-work before configuring Oracle 11g Streams; Network connectivity; Check the waterways; Configure the Oracle Net ""Current""; Configure the database; Initialization parameters; Logging features; Archive logging; Supplemental logging; Forced logging; Separate tablespaces; LogMiner tablespace; Streams Administration tablespace; Streams users and privileges; Trusted Streams Administrator user configuration Untrusted Streams capture, propagation, and apply user configurationStreams Administration user; Capture user; Propagation user; Apply user; Database links; Trusted versus untrusted configurations; Understanding your Instantiation tools; Using Data Pump to Instantiate; Setting Instantiation SCN manually; Oracle Demo Schemas; Summary; Chapter 4: Single-Source Configuration; The stream flows one way: Downhill; The Enterprise Manager; Setup options; Schedule Streams setup job; Verify; The code behind the curtain; Checking the waters; Diving in The proof is in the pudding (or propagation in this case) |
| Record Nr. | UNINA-9910826157603321 |
McKinnell Ann L. R
|
||
| Birmingham, U.K., : Packt Pub., 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Application express 4.0 with Ext JS [[electronic resource] ] : deliver rich, desktop-styled Oracle APEX applications using the powerful Ext JS JavaScript library / / Mark Lancaster
| Oracle Application express 4.0 with Ext JS [[electronic resource] ] : deliver rich, desktop-styled Oracle APEX applications using the powerful Ext JS JavaScript library / / Mark Lancaster |
| Autore | Lancaster Mark |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2011 |
| Descrizione fisica | 1 online resource (599 p.) |
| Disciplina |
005.7575
005.7585 |
| Soggetto topico | Application software - Development |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-283-37683-0
9786613376831 1-84968-107-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Oracle Application Express 4.0 with Ext JS; Oracle Application Express 4.0 with Ext JS; Credits; About the Author; About the Reviewer; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Setting up an Oracle APEX and Ext JS Environment; Setting up for success; Installing Oracle APEX
Downloading Ext JSWhich web server to use?; Storing your web assets; Customizing application builder files; Oracle HTTP Server; Loading Ext JS onto the Oracle HTTP Server; Embedded PL/SQL Gateway; Loading Ext JS onto the Embedded PL/SQL Gateway; Oracle APEX listener; Loading Ext JS for the Oracle APEX listener; Overviewing the production setup; Using Ext JS in a hosted APEX environment; Installing a source code repository; Automating the build process; Configuring and using APEXExport; More ideas for automating the build process; Setting up a local web server; Summary 2. Getting Acquainted with ExtBuilding a sandbox; Cross-browser DOM manipulation with Ext.Element; Heavyweight versus flyweight; Sizing and positioning; CSS classes and styling; DOM traversal; Selecting multiple elements; DOM manipulation; Defining event handlers; Using event delegation to reduce memory consumption; One-off events; Parameter passing using object notation; Old-school parameters; Using object notation; Basic syntax; Use namespacing to avoid collisions; Ext.namespace; Ext.BLANK_IMAGE_URL; Summary; 3. Building a Ext JS Theme into APEX; Theme basics; Separation of concerns Standard themesCreating a theme; Building a Viewport Page template; Starting with a standalone template; Loading the page template into APEX; Issue when input items are outside the form; Ensuring that input items always remain with the form; Summary; 4. Ext Themed Regions, Labels, and Lists; Region templates; Report Region; Form Region; Additional region templates; Label templates; Optional label; QuickTips for error messages; Optional label with help; Mandatory label; Mandatory label with help; Hidden label; List templates; Vertical unordered list without bullets Vertical unordered list with bulletsBuilding an Ext JS tree template using lists; APEX 4.0 tree template; Prior APEX versions tree template; Highlighting the current node; Customizing individual nodes; Summary; 5. Ext Themed Buttons, Popups, Calendars, and Reports; Button templates; Sliding doors meet CSS sprites; APEX sliding door CSS sprite button template; Building a hideous Ext.Button; Converting our buttons; Popup List of Values template; Breadcrumb templates; Benefits of using breadcrumbs; When not to use breadcrumbs; Basic horizontal breadcrumb template; Report templates It's a classic |
| Record Nr. | UNINA-9910459567203321 |
|
Lancaster Mark
|
||
| Birmingham, U.K., : Packt Enterprise, 2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Application express 4.0 with Ext JS [[electronic resource] ] : deliver rich, desktop-styled Oracle APEX applications using the powerful Ext JS JavaScript library / / Mark Lancaster
| Oracle Application express 4.0 with Ext JS [[electronic resource] ] : deliver rich, desktop-styled Oracle APEX applications using the powerful Ext JS JavaScript library / / Mark Lancaster |
| Autore | Lancaster Mark |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2011 |
| Descrizione fisica | 1 online resource (599 p.) |
| Disciplina |
005.7575
005.7585 |
| Soggetto topico | Application software - Development |
| ISBN |
1-283-37683-0
9786613376831 1-84968-107-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Oracle Application Express 4.0 with Ext JS; Oracle Application Express 4.0 with Ext JS; Credits; About the Author; About the Reviewer; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Setting up an Oracle APEX and Ext JS Environment; Setting up for success; Installing Oracle APEX
Downloading Ext JSWhich web server to use?; Storing your web assets; Customizing application builder files; Oracle HTTP Server; Loading Ext JS onto the Oracle HTTP Server; Embedded PL/SQL Gateway; Loading Ext JS onto the Embedded PL/SQL Gateway; Oracle APEX listener; Loading Ext JS for the Oracle APEX listener; Overviewing the production setup; Using Ext JS in a hosted APEX environment; Installing a source code repository; Automating the build process; Configuring and using APEXExport; More ideas for automating the build process; Setting up a local web server; Summary 2. Getting Acquainted with ExtBuilding a sandbox; Cross-browser DOM manipulation with Ext.Element; Heavyweight versus flyweight; Sizing and positioning; CSS classes and styling; DOM traversal; Selecting multiple elements; DOM manipulation; Defining event handlers; Using event delegation to reduce memory consumption; One-off events; Parameter passing using object notation; Old-school parameters; Using object notation; Basic syntax; Use namespacing to avoid collisions; Ext.namespace; Ext.BLANK_IMAGE_URL; Summary; 3. Building a Ext JS Theme into APEX; Theme basics; Separation of concerns Standard themesCreating a theme; Building a Viewport Page template; Starting with a standalone template; Loading the page template into APEX; Issue when input items are outside the form; Ensuring that input items always remain with the form; Summary; 4. Ext Themed Regions, Labels, and Lists; Region templates; Report Region; Form Region; Additional region templates; Label templates; Optional label; QuickTips for error messages; Optional label with help; Mandatory label; Mandatory label with help; Hidden label; List templates; Vertical unordered list without bullets Vertical unordered list with bulletsBuilding an Ext JS tree template using lists; APEX 4.0 tree template; Prior APEX versions tree template; Highlighting the current node; Customizing individual nodes; Summary; 5. Ext Themed Buttons, Popups, Calendars, and Reports; Button templates; Sliding doors meet CSS sprites; APEX sliding door CSS sprite button template; Building a hideous Ext.Button; Converting our buttons; Popup List of Values template; Breadcrumb templates; Benefits of using breadcrumbs; When not to use breadcrumbs; Basic horizontal breadcrumb template; Report templates It's a classic |
| Record Nr. | UNINA-9910790057903321 |
|
Lancaster Mark
|
||
| Birmingham, U.K., : Packt Enterprise, 2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Application express 4.0 with Ext JS : deliver rich, desktop-styled Oracle APEX applications using the powerful Ext JS JavaScript library / / Mark Lancaster
| Oracle Application express 4.0 with Ext JS : deliver rich, desktop-styled Oracle APEX applications using the powerful Ext JS JavaScript library / / Mark Lancaster |
| Autore | Lancaster Mark |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2011 |
| Descrizione fisica | 1 online resource (599 p.) |
| Disciplina |
005.7575
005.7585 |
| Soggetto topico | Application software - Development |
| ISBN |
1-283-37683-0
9786613376831 1-84968-107-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Oracle Application Express 4.0 with Ext JS; Oracle Application Express 4.0 with Ext JS; Credits; About the Author; About the Reviewer; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Setting up an Oracle APEX and Ext JS Environment; Setting up for success; Installing Oracle APEX
Downloading Ext JSWhich web server to use?; Storing your web assets; Customizing application builder files; Oracle HTTP Server; Loading Ext JS onto the Oracle HTTP Server; Embedded PL/SQL Gateway; Loading Ext JS onto the Embedded PL/SQL Gateway; Oracle APEX listener; Loading Ext JS for the Oracle APEX listener; Overviewing the production setup; Using Ext JS in a hosted APEX environment; Installing a source code repository; Automating the build process; Configuring and using APEXExport; More ideas for automating the build process; Setting up a local web server; Summary 2. Getting Acquainted with ExtBuilding a sandbox; Cross-browser DOM manipulation with Ext.Element; Heavyweight versus flyweight; Sizing and positioning; CSS classes and styling; DOM traversal; Selecting multiple elements; DOM manipulation; Defining event handlers; Using event delegation to reduce memory consumption; One-off events; Parameter passing using object notation; Old-school parameters; Using object notation; Basic syntax; Use namespacing to avoid collisions; Ext.namespace; Ext.BLANK_IMAGE_URL; Summary; 3. Building a Ext JS Theme into APEX; Theme basics; Separation of concerns Standard themesCreating a theme; Building a Viewport Page template; Starting with a standalone template; Loading the page template into APEX; Issue when input items are outside the form; Ensuring that input items always remain with the form; Summary; 4. Ext Themed Regions, Labels, and Lists; Region templates; Report Region; Form Region; Additional region templates; Label templates; Optional label; QuickTips for error messages; Optional label with help; Mandatory label; Mandatory label with help; Hidden label; List templates; Vertical unordered list without bullets Vertical unordered list with bulletsBuilding an Ext JS tree template using lists; APEX 4.0 tree template; Prior APEX versions tree template; Highlighting the current node; Customizing individual nodes; Summary; 5. Ext Themed Buttons, Popups, Calendars, and Reports; Button templates; Sliding doors meet CSS sprites; APEX sliding door CSS sprite button template; Building a hideous Ext.Button; Converting our buttons; Popup List of Values template; Breadcrumb templates; Benefits of using breadcrumbs; When not to use breadcrumbs; Basic horizontal breadcrumb template; Report templates It's a classic |
| Record Nr. | UNINA-9910810893003321 |
|
Lancaster Mark
|
||
| Birmingham, U.K., : Packt Enterprise, 2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle database 11g-underground advice for database administrators [[electronic resource] ] : a real-world DBA survival guide for Oracle 11g database implementations / / April C. Sims
| Oracle database 11g-underground advice for database administrators [[electronic resource] ] : a real-world DBA survival guide for Oracle 11g database implementations / / April C. Sims |
| Autore | Sims April C |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Pub., 2010 |
| Descrizione fisica | 1 online resource (348 p.) |
| Disciplina | 005.7575 |
| Collana | From technologies to solutions |
| Soggetto topico |
Database management
SQL*PLUS (Computer program language) Relational databases |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-282-55746-7
9786612557460 1-84968-001-9 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the author; About the reviewers; Table of Contents; Preface; Chapter 1: When to Step Away from the Keyboard; Protecting and defending; Choosing your tools; Graphic-based, command-line Oracle tools and usage; Staying away from dinosaurs; Insisting on help; What does a DBA do all day?; Prioritizing tasks-daily, weekly, monthly, quarterly, or yearly; SLA's: Why isn't the database down anymore?; Avoiding major blunders; Summary; Chapter 2: Maintaining Oracle Standards; Adapting to constant change; Database concepts; Multiple ORACLE_HOME(s)
Keeping the environment clean Oracle's Optimal Flexible Architecture (OFA); 11g differences in the OFA standard; XWINDOWS and GUI displays; Automating day-to-day tasks; DBMS_SCHEDULER; OS cron utility executing a scheduled task on a Unix server; OEM Console plus the Intelligent Agent; 11g Diagnosability Framework; Advisors and checkers; Missing temp file resolution; Environmental variables and scripting; Guidelines for scripting; Separating the configuration file; Separate the variable part of the script into its own configuration file; Don't hardcode values reference a configuration file and password file at runtime Putting variables at the top of the script with curly braces; Moving functions to a centralized file to be reused; Validate the use of the script; Using SQL to generate code; Helpful Unix commands; Reducing operating system differences with common tools; Configuration management, release management, and change control; Configuration management; Using OCM in disconnected mode with masking; Mass deployment utility; Release management; DBA issues with patching; Applying a patch without integrating MOS with OCM Using the new patch plan functionality with OCM installed and uploaded to MOSChange control; Where, when, and who to call for help; My Oracle Support; Documentation library; Summary; Chapter 3: Tracking the Bits and Bytes; Dump block; Demonstration of data travel path; Location of trace files; Running dump block SQL statements; Identifying files and blocks; Tracking the SCN through trace files; Oracle's RDBMS Log Miner utility; Turn on archivelog mode; Add supplemental logging; Identification key logging; Table-level supplemental logging; Flash(back) Recovery Area (FRA) Automatic Undo Management (AUM)Identifying data in undo segments by flashing back to timestamp; When to use Log Miner; Identifying the data needed to restore; SCN, timestamp, or log sequence number; Pseudo column ORA_ROWSCN; Flashback Transaction Query and Backout; Enabling flashback logs; Flashback Table; Flashback Transaction Query with pseudo columns; Flashback Transaction Backout; Using strings to remove binary components; Summary; Chapter 4: Achieving Maximum Uptime; Maximum Availability Architecture (MAA); Downtime-planned or unplanned; MAA with commodity hardware: Case study Optimizing Oracle Database High Availability |
| Record Nr. | UNINA-9910459376303321 |
|
Sims April C
|
||
| Birmingham, U.K., : Packt Pub., 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle database 11g-underground advice for database administrators [[electronic resource] ] : a real-world DBA survival guide for Oracle 11g database implementations / / April C. Sims
| Oracle database 11g-underground advice for database administrators [[electronic resource] ] : a real-world DBA survival guide for Oracle 11g database implementations / / April C. Sims |
| Autore | Sims April C |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Pub., 2010 |
| Descrizione fisica | 1 online resource (348 p.) |
| Disciplina | 005.7575 |
| Collana | From technologies to solutions |
| Soggetto topico |
Database management
SQL*PLUS (Computer program language) Relational databases |
| ISBN |
1-282-55746-7
9786612557460 1-84968-001-9 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the author; About the reviewers; Table of Contents; Preface; Chapter 1: When to Step Away from the Keyboard; Protecting and defending; Choosing your tools; Graphic-based, command-line Oracle tools and usage; Staying away from dinosaurs; Insisting on help; What does a DBA do all day?; Prioritizing tasks-daily, weekly, monthly, quarterly, or yearly; SLA's: Why isn't the database down anymore?; Avoiding major blunders; Summary; Chapter 2: Maintaining Oracle Standards; Adapting to constant change; Database concepts; Multiple ORACLE_HOME(s)
Keeping the environment clean Oracle's Optimal Flexible Architecture (OFA); 11g differences in the OFA standard; XWINDOWS and GUI displays; Automating day-to-day tasks; DBMS_SCHEDULER; OS cron utility executing a scheduled task on a Unix server; OEM Console plus the Intelligent Agent; 11g Diagnosability Framework; Advisors and checkers; Missing temp file resolution; Environmental variables and scripting; Guidelines for scripting; Separating the configuration file; Separate the variable part of the script into its own configuration file; Don't hardcode values reference a configuration file and password file at runtime Putting variables at the top of the script with curly braces; Moving functions to a centralized file to be reused; Validate the use of the script; Using SQL to generate code; Helpful Unix commands; Reducing operating system differences with common tools; Configuration management, release management, and change control; Configuration management; Using OCM in disconnected mode with masking; Mass deployment utility; Release management; DBA issues with patching; Applying a patch without integrating MOS with OCM Using the new patch plan functionality with OCM installed and uploaded to MOSChange control; Where, when, and who to call for help; My Oracle Support; Documentation library; Summary; Chapter 3: Tracking the Bits and Bytes; Dump block; Demonstration of data travel path; Location of trace files; Running dump block SQL statements; Identifying files and blocks; Tracking the SCN through trace files; Oracle's RDBMS Log Miner utility; Turn on archivelog mode; Add supplemental logging; Identification key logging; Table-level supplemental logging; Flash(back) Recovery Area (FRA) Automatic Undo Management (AUM)Identifying data in undo segments by flashing back to timestamp; When to use Log Miner; Identifying the data needed to restore; SCN, timestamp, or log sequence number; Pseudo column ORA_ROWSCN; Flashback Transaction Query and Backout; Enabling flashback logs; Flashback Table; Flashback Transaction Query with pseudo columns; Flashback Transaction Backout; Using strings to remove binary components; Summary; Chapter 4: Achieving Maximum Uptime; Maximum Availability Architecture (MAA); Downtime-planned or unplanned; MAA with commodity hardware: Case study Optimizing Oracle Database High Availability |
| Record Nr. | UNINA-9910784914703321 |
|
Sims April C
|
||
| Birmingham, U.K., : Packt Pub., 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle database 11g-underground advice for database administrators : a real-world DBA survival guide for Oracle 11g database implementations / / April C. Sims
| Oracle database 11g-underground advice for database administrators : a real-world DBA survival guide for Oracle 11g database implementations / / April C. Sims |
| Autore | Sims April C |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Pub., 2010 |
| Descrizione fisica | 1 online resource (348 p.) |
| Disciplina | 005.7575 |
| Collana | From technologies to solutions |
| Soggetto topico |
Database management
SQL*PLUS (Computer program language) Relational databases |
| ISBN |
1-282-55746-7
9786612557460 1-84968-001-9 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the author; About the reviewers; Table of Contents; Preface; Chapter 1: When to Step Away from the Keyboard; Protecting and defending; Choosing your tools; Graphic-based, command-line Oracle tools and usage; Staying away from dinosaurs; Insisting on help; What does a DBA do all day?; Prioritizing tasks-daily, weekly, monthly, quarterly, or yearly; SLA's: Why isn't the database down anymore?; Avoiding major blunders; Summary; Chapter 2: Maintaining Oracle Standards; Adapting to constant change; Database concepts; Multiple ORACLE_HOME(s)
Keeping the environment clean Oracle's Optimal Flexible Architecture (OFA); 11g differences in the OFA standard; XWINDOWS and GUI displays; Automating day-to-day tasks; DBMS_SCHEDULER; OS cron utility executing a scheduled task on a Unix server; OEM Console plus the Intelligent Agent; 11g Diagnosability Framework; Advisors and checkers; Missing temp file resolution; Environmental variables and scripting; Guidelines for scripting; Separating the configuration file; Separate the variable part of the script into its own configuration file; Don't hardcode values reference a configuration file and password file at runtime Putting variables at the top of the script with curly braces; Moving functions to a centralized file to be reused; Validate the use of the script; Using SQL to generate code; Helpful Unix commands; Reducing operating system differences with common tools; Configuration management, release management, and change control; Configuration management; Using OCM in disconnected mode with masking; Mass deployment utility; Release management; DBA issues with patching; Applying a patch without integrating MOS with OCM Using the new patch plan functionality with OCM installed and uploaded to MOSChange control; Where, when, and who to call for help; My Oracle Support; Documentation library; Summary; Chapter 3: Tracking the Bits and Bytes; Dump block; Demonstration of data travel path; Location of trace files; Running dump block SQL statements; Identifying files and blocks; Tracking the SCN through trace files; Oracle's RDBMS Log Miner utility; Turn on archivelog mode; Add supplemental logging; Identification key logging; Table-level supplemental logging; Flash(back) Recovery Area (FRA) Automatic Undo Management (AUM)Identifying data in undo segments by flashing back to timestamp; When to use Log Miner; Identifying the data needed to restore; SCN, timestamp, or log sequence number; Pseudo column ORA_ROWSCN; Flashback Transaction Query and Backout; Enabling flashback logs; Flashback Table; Flashback Transaction Query with pseudo columns; Flashback Transaction Backout; Using strings to remove binary components; Summary; Chapter 4: Achieving Maximum Uptime; Maximum Availability Architecture (MAA); Downtime-planned or unplanned; MAA with commodity hardware: Case study Optimizing Oracle Database High Availability |
| Record Nr. | UNINA-9910821146003321 |
|
Sims April C
|
||
| Birmingham, U.K., : Packt Pub., 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Database 11gR2 performance tuning cookbook [[electronic resource] ] : over 80 recipes to help beginners achieve better performance from Oracle Database applications / / Ciro Fiorillo
| Oracle Database 11gR2 performance tuning cookbook [[electronic resource] ] : over 80 recipes to help beginners achieve better performance from Oracle Database applications / / Ciro Fiorillo |
| Autore | Fiorillo Ciro |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2012 |
| Descrizione fisica | 1 online resource (543 p.) |
| Disciplina |
005.75/85
005.7575 |
| Soggetto topico |
Relational databases
Database management |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-283-45344-4
9786613453440 1-84968-261-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Starting with Performance Tuning; Introduction; Reviewing the performance tuning process; Exploring the example database; Acquiring data using a data dictionary and dynamic performance views; Analyzing data using Statspack reports; Diagnosing performance issues using the alert log; Analyzing data using Automatic Workload Repository (AWR); Analyzing data using Automatic Database Diagnostic Monitor (ADDM); A working example
Chapter 2: Optimizing Application DesignIntroduction; Optimizing connection management; Improving performance sharing reusable code; Reducing the number of requests to the database using stored procedures; Reducing the number of requests to the database using sequences; Reducing the number of requests to the database using materialized views; Optimizing performance with schema denormalization; Avoiding dynamic SQL; Chapter 3: Optimizing Storage Structures; Introduction; Avoiding row chaining; Avoiding row migration; Using LOBs; Using index clusters; Using hash clusters Indexing the correct wayRebuilding index; Compressing indexes; Using reverse key indexes; Using bitmap indexes; Migrating to index organized tables; Using partitioning; Chapter 4: Optimizing SQL Code; Introduction; Using bind variables; Avoiding full table scans; Exploring index lookup; Exploring index skip-scan and index range-scan; Introducing arrays and bulk operations; Optimizing joins; Using subqueries; Tracing SQL activity with SQL Trace and TKPROF; Chapter 5: Optimizing Sort Operations; Introduction; Sorting-in-memory and on-disk; Sorting and indexing; Writing top n queries and ranking Using count, min/max, and group-byAvoiding sorting in set operations: union, minus, and intersect; Troubleshooting temporary tablespaces; Chapter 6: Optimizing PL/SQL Code; Introduction; Using bind variables and parsing; Array processing and bulk-collect; Passing values with NOCOPY (or not); Using short-circuit IF statements; Avoiding recursion; Using native compilation; Taking advantage of function result cache; Inlining PL/SQL code; Using triggers and virtual columns; Chapter 7: Improving the Oracle Optimizer; Introduction; Exploring optimizer hints; Collecting statistics; Using histograms Managing stored outlinesIntroducing Adaptive Cursor Sharing for bind variable peeking; Creating SQL Tuning Sets; Using the SQL Tuning Advisor; Configuring and using SQL Baselines; Chapter 8: Other Optimizations; Introduction; Caching results with the client-side result cache; Enabling parallel SQL; Direct path inserting; Using create table as select; Inspecting indexes and triggers overhead; Loading data with SQL*Loader and Data Pump; Chapter 9: Tuning Memory; Introduction; Tuning memory to avoid Operating System paging; Tuning the Library Cache; Tuning the Shared Pool Tuning the Program Global Area and the User Global Area |
| Record Nr. | UNINA-9910461486803321 |
|
Fiorillo Ciro
|
||
| Birmingham, U.K., : Packt Enterprise, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Database 11gR2 performance tuning cookbook [[electronic resource] ] : over 80 recipes to help beginners achieve better performance from Oracle Database applications / / Ciro Fiorillo
| Oracle Database 11gR2 performance tuning cookbook [[electronic resource] ] : over 80 recipes to help beginners achieve better performance from Oracle Database applications / / Ciro Fiorillo |
| Autore | Fiorillo Ciro |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2012 |
| Descrizione fisica | 1 online resource (543 p.) |
| Disciplina |
005.75/85
005.7575 |
| Soggetto topico |
Relational databases
Database management |
| ISBN |
1-283-45344-4
9786613453440 1-84968-261-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Starting with Performance Tuning; Introduction; Reviewing the performance tuning process; Exploring the example database; Acquiring data using a data dictionary and dynamic performance views; Analyzing data using Statspack reports; Diagnosing performance issues using the alert log; Analyzing data using Automatic Workload Repository (AWR); Analyzing data using Automatic Database Diagnostic Monitor (ADDM); A working example
Chapter 2: Optimizing Application DesignIntroduction; Optimizing connection management; Improving performance sharing reusable code; Reducing the number of requests to the database using stored procedures; Reducing the number of requests to the database using sequences; Reducing the number of requests to the database using materialized views; Optimizing performance with schema denormalization; Avoiding dynamic SQL; Chapter 3: Optimizing Storage Structures; Introduction; Avoiding row chaining; Avoiding row migration; Using LOBs; Using index clusters; Using hash clusters Indexing the correct wayRebuilding index; Compressing indexes; Using reverse key indexes; Using bitmap indexes; Migrating to index organized tables; Using partitioning; Chapter 4: Optimizing SQL Code; Introduction; Using bind variables; Avoiding full table scans; Exploring index lookup; Exploring index skip-scan and index range-scan; Introducing arrays and bulk operations; Optimizing joins; Using subqueries; Tracing SQL activity with SQL Trace and TKPROF; Chapter 5: Optimizing Sort Operations; Introduction; Sorting-in-memory and on-disk; Sorting and indexing; Writing top n queries and ranking Using count, min/max, and group-byAvoiding sorting in set operations: union, minus, and intersect; Troubleshooting temporary tablespaces; Chapter 6: Optimizing PL/SQL Code; Introduction; Using bind variables and parsing; Array processing and bulk-collect; Passing values with NOCOPY (or not); Using short-circuit IF statements; Avoiding recursion; Using native compilation; Taking advantage of function result cache; Inlining PL/SQL code; Using triggers and virtual columns; Chapter 7: Improving the Oracle Optimizer; Introduction; Exploring optimizer hints; Collecting statistics; Using histograms Managing stored outlinesIntroducing Adaptive Cursor Sharing for bind variable peeking; Creating SQL Tuning Sets; Using the SQL Tuning Advisor; Configuring and using SQL Baselines; Chapter 8: Other Optimizations; Introduction; Caching results with the client-side result cache; Enabling parallel SQL; Direct path inserting; Using create table as select; Inspecting indexes and triggers overhead; Loading data with SQL*Loader and Data Pump; Chapter 9: Tuning Memory; Introduction; Tuning memory to avoid Operating System paging; Tuning the Library Cache; Tuning the Shared Pool Tuning the Program Global Area and the User Global Area |
| Record Nr. | UNINA-9910790466903321 |
|
Fiorillo Ciro
|
||
| Birmingham, U.K., : Packt Enterprise, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Database 11gR2 performance tuning cookbook : over 80 recipes to help beginners achieve better performance from Oracle Database applications / / Ciro Fiorillo
| Oracle Database 11gR2 performance tuning cookbook : over 80 recipes to help beginners achieve better performance from Oracle Database applications / / Ciro Fiorillo |
| Autore | Fiorillo Ciro |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2012 |
| Descrizione fisica | 1 online resource (543 p.) |
| Disciplina |
005.75/85
005.7575 |
| Soggetto topico |
Relational databases
Database management |
| ISBN |
1-283-45344-4
9786613453440 1-84968-261-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Starting with Performance Tuning; Introduction; Reviewing the performance tuning process; Exploring the example database; Acquiring data using a data dictionary and dynamic performance views; Analyzing data using Statspack reports; Diagnosing performance issues using the alert log; Analyzing data using Automatic Workload Repository (AWR); Analyzing data using Automatic Database Diagnostic Monitor (ADDM); A working example
Chapter 2: Optimizing Application DesignIntroduction; Optimizing connection management; Improving performance sharing reusable code; Reducing the number of requests to the database using stored procedures; Reducing the number of requests to the database using sequences; Reducing the number of requests to the database using materialized views; Optimizing performance with schema denormalization; Avoiding dynamic SQL; Chapter 3: Optimizing Storage Structures; Introduction; Avoiding row chaining; Avoiding row migration; Using LOBs; Using index clusters; Using hash clusters Indexing the correct wayRebuilding index; Compressing indexes; Using reverse key indexes; Using bitmap indexes; Migrating to index organized tables; Using partitioning; Chapter 4: Optimizing SQL Code; Introduction; Using bind variables; Avoiding full table scans; Exploring index lookup; Exploring index skip-scan and index range-scan; Introducing arrays and bulk operations; Optimizing joins; Using subqueries; Tracing SQL activity with SQL Trace and TKPROF; Chapter 5: Optimizing Sort Operations; Introduction; Sorting-in-memory and on-disk; Sorting and indexing; Writing top n queries and ranking Using count, min/max, and group-byAvoiding sorting in set operations: union, minus, and intersect; Troubleshooting temporary tablespaces; Chapter 6: Optimizing PL/SQL Code; Introduction; Using bind variables and parsing; Array processing and bulk-collect; Passing values with NOCOPY (or not); Using short-circuit IF statements; Avoiding recursion; Using native compilation; Taking advantage of function result cache; Inlining PL/SQL code; Using triggers and virtual columns; Chapter 7: Improving the Oracle Optimizer; Introduction; Exploring optimizer hints; Collecting statistics; Using histograms Managing stored outlinesIntroducing Adaptive Cursor Sharing for bind variable peeking; Creating SQL Tuning Sets; Using the SQL Tuning Advisor; Configuring and using SQL Baselines; Chapter 8: Other Optimizations; Introduction; Caching results with the client-side result cache; Enabling parallel SQL; Direct path inserting; Using create table as select; Inspecting indexes and triggers overhead; Loading data with SQL*Loader and Data Pump; Chapter 9: Tuning Memory; Introduction; Tuning memory to avoid Operating System paging; Tuning the Library Cache; Tuning the Shared Pool Tuning the Program Global Area and the User Global Area |
| Record Nr. | UNINA-9910808544003321 |
|
Fiorillo Ciro
|
||
| Birmingham, U.K., : Packt Enterprise, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
