By R. Greenwald, et. al.,
Read or Download Oracle Essentials - Oracle Database 11g PDF
Similar oracle books
This publication lias been written for the subsequent audiences:■ Management-You could have bought Oracle9i for purposes except Java improvement in the database. notwithstanding, that will be aware of extra approximately Oracle9i Java beneficial properties, see "Overview of Oracle9i Java Documentation" on web page 1-23 for a administration standpoint.
There are few books out that care for Oracle textual content and XSQL. making use of the methodologies, practices, and so on. i discovered no use to look for an additional reference.
Oracle functionality Survival advisor a scientific method of Database Optimization the short, entire, start-to-finish advisor to optimizing Oracle functionality Oracle functionality Survival advisor deals a dependent, systematic, start-to-finish method for optimizing Oracle functionality as successfully as attainable.
This self-study examination training advisor for the Oracle Database 10g Database Administrator OCP certification examination comprises every thing you must try your self and cross the examination. All examination issues are coated and insider secrets and techniques, entire causes of all Oracle Database 10g Database Administrator OCP matters, attempt methods and tips, a variety of hugely life like pattern questions, and routines designed to reinforce realizing of Oracle Database 10g Database Administrator OCP suggestions and get ready you for examination good fortune at the first try are supplied.
- Processing XML documents with Oracle JDeveloper 11g
- Cost-Based Oracle Fundamentals
- SQL Plus. Quick Reference
- Object-oriented Oracle
- Oracle PLSQL Programming
- Oracle BPM Suite 11g Developer's cookbook
Extra info for Oracle Essentials - Oracle Database 11g
BI Publisher A publishing and report layout tool used in generating high-fidelity reports from XML data. Service Registry The Oracle Service Registry enables publishing and advertising of services and provides a System of Record for SOA services. SOA Suite for Oracle Middleware The Suite bundles Oracle Fusion Middleware SOA offerings, including BPEL, BAM, business rules engine, Enterprise Service Bus (for messaging, routing, and transformations), Web Services Management (including a policy manager and monitoring dashboard), Web Services Registry, and applications and technology adapters.
Oracle8 added the capability to store multiple LOB columns in each table. Oracle Database 10g essentially removed the space limitation on large objects. Oracle Database 11g greatly improved the performance of query and insert operations used with LOBs through the introduction of SecureFiles. Transparent data encryption is supported for SecureFiles LOB data. Object-oriented programming Support of object structures has existed since Oracle8i to provide support for an object-oriented approach to programming.
By breaking up a single task into smaller tasks and assigning each subtask to an independent process, you can dramatically improve the performance of certain types of database operations. Examples of query features implemented in parallel include: Table scans Nested loops Sort merge joins GROUP BYs NOT IN subqueries (anti-joins) User-defined functions Index scans Select distinct UNION and UNION ALL Hash joins ORDER BY and aggregation Bitmap star joins Partition-wise joins Stored procedures (PL/SQL, Java, external routines) In addition to parallel query, many other Oracle features and capabilities are parallelized.