Oracle7 ServerRelease 7.3Oracle7 Server Release 7.3 Key Features:Hardware and Software Requirements:Oracle7 is fully portable to more than 80 distinct hardware and operating system platforms, including 40+ UNIX, VMS, MVS, VM, HP MPE/XL, Siemens, ICL, Novell Netware, OS/2, Windows, Windows NT, and Macintosh. Copyright ã 1971-2002 Thomas P. Sturm Oracle Feature Set Page 2Transaction Processing and DecisionSupport Transaction Processing Multithreaded Server Architecture Scalable SMP performance Shared database buffer cache Shared SQL cache (SQL statements, PL/SQL procedures, functions, packages, and triggers) Shared dictionary cache Fast and Group Commits Deferred Writes Serializable Transactions Oracle7 Parallel Server* Clustered, MPP, and hybrid parallel systems support Multiple nodes share access to a single Oracle7 database Easy incremental expansion of processing resources Linear scalable increases in performance High availability applications Consolidated system administration Parallel Disk Affinity * Requires appropriate optional feature bundle: Parallel Query option, Distributed option, ParallelServer option, or Advanced Replication option Copyright ã 1971-2002 Thomas P. Sturm Oracle Feature Set Page 3SQL Optimizer Cost-based, syntax-independent optimization ANALYZE table statistics generation Nested-loop and sort-merge join selection "Star" query algorithm support Manual UNION ALL predicate push-down Histograms Transactional Data Access B-tree single column and concatenated column indexes Clustered tables, hash-clusters, application-specific hash functions ROWIDs Query results directly from index lookup Integrated bitmapped indexes Concurrency Control and Reliable Results Unrestricted row-level locking No lock escalation Contention-free queries Unique sequence number generation Non-blocking, multiversion read- consistent query results Copyright ã 1971-2002 Thomas P. Sturm Oracle Feature Set Page 4Oracle7 Parallel Query* Parallel execution of table scans, sorts, joins, and aggregates Parallel direct database reads and direct database writes Parallelization of user-written code Parallel CREATE INDEX and CREATE TABLE AS SELECT Parallel, direct-path data loading Oracle7 Parallel Server for SMP and MPP architectures* Fully integrated parallel query architecture Application transparency Supports all standard server features and options Dynamic workload balancing Dynamic data partitioning * Requires appropriate optional feature bundle: Parallel Query option, Distributed option, ParallelServer option, or Advanced Replication option Copyright ã 1971-2002 Thomas P. Sturm Oracle Feature Set Page 5High Availability Online backup by file, table-space, or database Online recovery Parallel recovery Parallel backup/restore utility Read-only tablespaces Mirrored multisegment log files Checksums on database and redo log file blocks Dynamic resizing of database files Oracle7 Parallel Server for highly available applications* Standby database * Requires appropriate optional feature bundle: Parallel Query option, Distributed option, ParallelServer option, or Advanced Replication option Copyright ã 1971-2002 Thomas P. Sturm Oracle Feature Set Page 6Distributed Systems Distributed Queries and Transactions Transparent remote and distributed query Distributed, optimized joins Location transparency, network transparency Integrated distributed query architecture Transparent, multisite distributed transactions Distributed SQL updates and remote procedure calls (RPCs) Commit transparency Automatic failure detection and resolution Open Gateways Data source transparency Transparent SQL gateways Transparent procedural gateways Distributed queries and update transactions Compliant with XA standard for TP-monitor coordinated two-phase commit* * Requires appropriate optional feature bundle: Parallel Query option, Distributed option, ParallelServer option, or Advanced Replication option Copyright ã 1971-2002 Thomas P. Sturm Oracle Feature Set Page 7Data Replication Multiple, read-only snapshots (basic primary site replication) Full transactional consistency and data integrity Full and subset table replication Incremental refresh of snapshot copies Event and demand based refresh Symmetric Replication Updatable snapshots (both master and snapshot tablesupdatable) Multiple master configurations (full table replication between master sites) Hybrid configurations (combine snapshot and multiple master configurations) Fail-over configuration support Automatic conflict detection and resolution Distributed schema management Synchronous and Asynchronous Replication support Copyright ã 1971-2002 Thomas P. Sturm Oracle Feature Set Page 8Application Development SQL Implementation 100-percent ANSI/ISO SQL 92 Entry Level compliant-NIST tested ANSI/ISO standard precompilers applications interface (API) Robust SQL extensions including UNION, INTERSECT, MINUS, outer join, and tree-structured queries (CONNECT BY) SQL3 inline views (query in the FROM clause of another query) Updatable join views Declarative Integrity Constraints 100-percent ANSI/ISO standard declarative entity andreferential integrity constraints CHECK, DEFAULT, not NULL constraints PRIMARY, FOREIGN, UNIQUE keys Optional DELETE CASCADE Copyright ã 1971-2002 Thomas P. Sturm Oracle Feature Set Page 9Stored Procedures PL/SQL procedural extension to ANSI/ISO standard SQL Strongly typed variable declarations (SQL datatypes) Block structure Flow control including FOR and WHILE loops, IF/THEN/ELSE SQL cursor support Static and dynamic SQL support Robust exception handling Subprogram types: procedures, functions, and packages Subprograms stored in shared, compiled form Called from Oracle and third-party tools**, Oracle Pre-compilers,** Oracle Call Interface, SQL*Module,** other stored procedures, database triggers Remote procedure calls (RPCs) protected by transparent two-phase commit User-defined PL/SQL functions in SQL Cursor Variables for easy retrieval of multi-row result sets Wrapper utility hiding PL/SQL application code in binary source format Server side file I/O ** Requires Oracle or 3rd-party tool, Oracle Precompiler, or Oracle SQL*Module Copyright ã 1971-2002 Thomas P. Sturm Oracle Feature Set Page 10Database Triggers Procedural code