Introduced a quarter-century ago, the Oracle database remains theleading enterprise relational database management system (RDBMS) inthe world. Oracle is a complex system, offering a myriad ofproducts, languages, and tools. Frequent updates, releases, andeditions complicate the ability of Oracle users to keep up with thehuge amounts of frequently changing information about the databaseand its capabilities. The goal of Oracle in a Nutshell is topull together the most essential information on Oraclearchitecture, syntax, and user interfaces. The content and formatof this book, an admirable addition to O'Reilly's respectedIn-a-Nutshell line, combine to boil down vital Oracle commands,language constructs, parameters, and file formats in a succinct andhighly accessible desktop reference. Oracle in a Nutshellcovers the information that database administrators PL/SQL and Javadevelopers, and system, network, and security administrators needas they manage Oracle databases and write code for these databases.It includes:
Oracle Foundations--Overview of the Oracle architecture (memorystructures and fundamental concepts), Oracle's various editions andpackaging options, summary of the initialization file parametersand data dictionary views, and fundamentals of Oracle's concurrencyscheme, security mechanisms (privileges, profiles, roles), andnetworking files (TNSNAMES.ORA, SQLNET.ORA, LISTENER.ORA, DAP.ORA,NAMES.ORA, CMAN.ORA) and options.
Oracle Languages--Syntax summary for SQL language statements,SQL function calls PL/SQL language statements and characteristics,PL/SQL built-in package headers, and Java (JDBC and SQLJ)interfaces to the Oracle database.
Oracle Tools--Commands provided with SQLPlus, SQLLoader,Import and Export, Oracle Recovery Manager (RMAN) and otherbackup/recovery methods, Oracle Enterprise Manager, and variousperformance tuning tools (Explain Plan, TKPROF, AUTOTRACE,UTLBSTAT, UTLESTAT, Statspack).
Appendixes--Summary of Oracle datatypes, operators,expressions, conditions, numeric and date formats, and resourcesfor additional reading.