Oracle Database Performance and Scalability: A Quantitative by Henry H. Liu

By Henry H. Liu

With database innovations and theories in actual fact defined in Oracle's context, readers quick find out how to absolutely leverage Oracle's functionality and scalability functions at each degree of designing and constructing an Oracle-based firm software. The booklet is predicated at the author's greater than ten years of expertise operating with Oracle, and is stuffed with accountable, demonstrated, and confirmed functionality optimization thoughts.

Show description

Read or Download Oracle Database Performance and Scalability: A Quantitative Approach PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

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

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication let real-time details entry and knowledge sharing throughout your dispensed framework utilizing the professional details during this Oracle Press consultant. Oracle Streams 11g facts Replication explains how one can organize and administer a unified company facts sharing infrastructure.

Oracle Application Express 4 Recipes

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

Additional info for Oracle Database Performance and Scalability: A Quantitative Approach

Sample text

A larger amount of memory and a faster disk are as equally important as fast CPUs. & & & & & . For enterprise software professionals, an Oracle setting could range from a laptop or a desktop comparable to the PCs as described above at a minimum or readily to an enterprise-class server system with much larger computing capacities. After you have decided on a computer on which you are going to experiment with Oracle, next, I am going to suggest how you can use this book most effectively and efficiently to achieve the maximum benefits along the way.

DDL (Data Definition Language) SQLs. This subset of SQLs includes the SQL statements of CREATE, ALTER, DROP, TRUNCATE, and so on. Such SQLs are used to create and modify tables, views, and indexes, and so on. DCL (Data Control Language) SQLs. This subset of SQLs includes GRANT, REVOKE, and so on. Such SQLs are used for controlling user access to data in a database, for example, granting/revoking certain privileges to/from certain users. TCL (Transaction Control Language). This subset of SQLs includes COMMIT, ROLLBACK, SET TRANSACTION, and so on.

11 for the entries of this dialog box. 7. Recovery Options. 12. Deselect both in a test environment or select both in a production environment. 8. Sample Schemas. 13 for working on the exercises in the later sections of this text. Otherwise uncheck it if you know that you do not need these sample schemas. We’ll discuss more about those sample schemas in a chapter later. 9. Initialization Parameters. Now we have come to the fun part of creating an Oracle database. 14 parts (a) to (d). We will refer back to these screenshots later.

Download PDF sample

Rated 4.89 of 5 – based on 5 votes