Oracle7 Server Release 7.3Copyright  1971-2002 Thomas P. Sturm Oracle Feature Set Page 2 Oracle7 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 3 Transaction Processing and Decision Support 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, Parallel Server option, or Advanced Replication optionCopyright  1971-2002 Thomas P. Sturm Oracle Feature Set Page 4 SQL 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 resultsCopyright  1971-2002 Thomas P. Sturm Oracle Feature Set Page 5 Oracle7 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, Parallel Server option, or Advanced Replication optionCopyright  1971-2002 Thomas P. Sturm Oracle Feature Set Page 6 High 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, Parallel Server option, or Advanced Replication optionCopyright  1971-2002 Thomas P. Sturm Oracle Feature Set Page 7 Distributed 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, Parallel Server option, or Advanced Replication optionCopyright  1971-2002 Thomas P. Sturm Oracle Feature Set Page 8 Data 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 tables updatable) 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 supportCopyright  1971-2002 Thomas P. Sturm Oracle Feature Set Page 9 Application 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 and referential integrity constraints CHECK, DEFAULT, not NULL constraints PRIMARY, FOREIGN, UNIQUE keys Optional DELETE CASCADECopyright  1971-2002 Thomas P. Sturm Oracle Feature Set Page 10 Stored 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