Expert Oracle Database 11g Administration by Sam R. Alapati

By Sam R. Alapati

Sam Alapati's specialist Oracle Database 11g management is a complete instruction manual for Oracle database directors (DBAs) utilizing the 11g free up of the Oracle Database. All key points of database management are lined, together with backup and restoration, day–to–day management and tracking, functionality tuning, and extra. this can be the single e-book to have in your table as a continuous reference. seek advice from it usually. It'll assist you get the task done.

* complete instruction manual for Oracle Database directors. Covers all significant points of database administration.
* assessments and explains intimately key DBA commands.
* deals primers on Linux/Unix, information modeling, SQL, and PL/SQL.

Show description

Read or Download Expert Oracle Database 11g Administration PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time details entry and knowledge sharing throughout your dispensed framework utilizing the professional details during this Oracle Press consultant. Oracle Streams 11g information Replication explains the best way to manage and administer a unified firm information sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software exhibit four Recipes offers an example-based method of studying program show - the ground-breaking, quick program improvement platform integrated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply desires an exceptional instance or to kick commence their pondering and get pointed within the correct path.

Additional info for Expert Oracle Database 11g Administration

Example text

1075 Using Partitioned Tables . . . . . . . . . . . . . . . . . 1076 Using Compression Techniques . . . . . . . . . . . . . . 1076 Using Materialized Views . . . . . . . . . . . . . . . . . 1077 Using Stored Outlines to Stabilize the CBO . . . . . . . . . 1077 SQL Plan Management . . . . . . . . . . . . . . . . . . . . 1080 SQL Plan Baselines . . . . . . . . . . . . . . . . . . . 1080 Capturing SQL Plan Baselines .

1020 Managing Automated Maintenance Tasks . . . . . . . . . . 1020 Monitoring Automated Maintenance Tasks . . . . . . . . . 1020 Fault Diagnosability . . . . . . . . . . . . . . . . . . . . . 1022 Automatic Diagnostic Repository . . . . . . . . . . . . . 1023 ADRCI . . . . . . . . . . . . . . . . . . . . . . . . . 1024 Incident Packaging Service . . . . . . . . . . . . . . . .

The idea is to enable software to access spare processing power across networks (grids) of inexpensive servers. Traditionally, database systems have been run on large servers capable of running several very large databases at once. However, there are distinct disadvantages inherent in the single-server model. For example, resources tied up in the large servers can’t be redistributed among the various databases and other services to ensure an optimal allocation of resources. If you need a massive amount of resources to handle your database’s peak needs, chances are that you’ll run with identical resources throughout the day, thus guaranteeing that you are going to waste critical resources during low-utilization periods.

Download PDF sample

Rated 4.56 of 5 – based on 24 votes