Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: here is a summary of from 7 to oracle 8i new features

RE: here is a summary of from 7 to oracle 8i new features

From: Rajeshwari R <raji_at_chennai.insyst.com>
Date: Fri, 22 Dec 2000 17:22:06 +0530
Message-Id: <10718.125214@fatcity.com> 





This is a multi-part message in MIME format.



------=_NextPart_000_000A_01C06C3B.B510C7E0
Content-Type: text/plain;


        charset="iso-8859-9"


Content-Transfer-Encoding: 7bit



Thank you


  -----Original Message-----


  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of bunyamin
karadeniz


  Sent: Thursday, December 21, 2000 6:46 PM
  To: Multiple recipients of list ORACLE-L
  Subject: here is a summary of from 7 to oracle 8i new features




  Hi All Oracle Guru's ,


  You'll love this document so much .






  Bunyamin K. Karadeniz


  Information Technologies Dept.


  Database Group Tel :90-312-2873565/1681
  HAVELSAN Ankara / TURKEY






  New Features Summary


  Oracle 8i (8.1.7)

    a.. Static HTTP server included (Apache)
    b.. JVM Accelerator to improve performance of Java code
    c.. Java Server Pages (JSP) engine
    d.. MemStat - A new utility for analyzing Java Memory footprints
    e.. OIS - Oracle Intergration Server introduced.
    f.. PLSQL Gateway introduced for deploying PL/SQL based solutions on the


Web


    g.. Enterprise Manager Enhancements - including new HTML based reporting
and Advanced Replication functionality included.


    h.. New Database Character Ser Migration utilility included.
  Oracle 8i (8.1.6)

    a.. PL/SQL Server Pages (PSP's)
    b.. DBA Studio Introduced
    c.. Statspack
    d.. New SQL Functions (rank, moving average)
    e.. ALTER FREELISTS command (previously done by DROP/CREATE TABLE)
    f.. Checksums always on for SYSTEM tablespace allowing many possible


corruptions to be fixed before writing to disk

    g.. XML Parser for Java
    h.. New PLSQL encrypt/decrypt package introduced
    i.. User and Schemas sepapated
    j.. Numerous Performance Enhancements


  Oracle 8i (8.1.5)


    a.. Fast Start recovery - Checkpoint rate auto-adjusted to meet roll
forward criteria


    b.. Reorganize indexes/index only tables which users accessing data -
Online index rebuilds


    c.. Log Miner introduced - Allows on-line or archived redo logs to be
viewed via SQL


    d.. OPS Cache Fusion introduced avoiding disk I/O during cross-node
communication


    e.. Advanced Queueing improvements (security, performance, OO4O support
    f.. User Security Improvements - more centralisation, single enterprise
user, users/roles across multiple databases.

    g.. Virtual private database
    h.. JAVA stored procedures (Oracle Java VM)
    i.. Oracle iFS
    j.. Resource Management using proirities - resource classes
    k.. Hash and Composite partitioned table types
    l.. SQL*Loader direct load API
    m.. Copy optimizer statistics across databases to ensure same access


paths across different environments.


    n.. Stanby Database - Auto shipping and application of redo logs. Read
Only queries on standby database allowed.

    o.. Enterprise Manager v2 delivered
    p.. NLS - Euro Symbol supported
    q.. Analyze tables in parallel
    r.. Temporary tables supported.
    s.. Net8 support for SSL, HTTP, HOP protocols
    t.. Transportable tablespaces between databases
    u.. Locally managed tablespaces - automatic sizing of extents,


elimination of tablespace fragmentation, tablespace information managed in
tablespace (i.e noved from data dictionary) improving tablespace reliability


    v.. Drop Column on table (Finally !!!!!)
    w.. DBMS_DEBUG PL/SQL package, DBMS_SQL replaced by new EXECUTE
IMMEDIATE statement


    x.. Progress Monitor to track long running DML,DDL
    y.. Functional Indexes - NLS, case insensitive, descending
  Oracle 8.0

    a.. Object Relational database
    b.. Object Types (not just date, character, number as in v7
    c.. SQL3 standard
    d.. Call external procedures
    e.. LOB >1 per table
    f.. Partitioned Tables and Indexes
    g.. export/import individual partitions
    h.. partitions in multiple tablespaces
    i.. online/offline, backup/recover individual partitions
    j.. merge/balance partitions
    k.. Advanced Queuing for message handling
    l.. Many performance improvements to SQL/PLSQL/OCI making more efficient


use of CPU/Memory. V7 limits extended (e.g. 1000 columns/table, 4000 bytes
VARCHAR2)



    m.. Parallel DML statements


    n.. Connection Pooling ( uses the physical connection for idle users and
transparently re-establishes the connection when needed ) to support more
concurrent users.


    o.. Improved "STAR" Query optimizer


    p.. Integrated Distributed Lock Manager in Oracle PS (as opposed to
Operating system DLM in v7).


    q.. Performance improvements in OPS - global V$ views introduced across
all instances, transparent failover to a new node


    r.. Data Cartridges introduced on database (e.g. image, video, context,
time, spatial)


    s.. Backup/Recovery improvements - Tablespace point in time recovery,
incremental backups, parallel backup/recovery. Recovery manager introduced


    t.. Security Server introduced for central user administration. User
password expiry, password profiles, allow custom password scheme. Privileged
database links (no need for password to be stored)


    u.. Fast Refresh for complex snapshots, parallel replication, PL/SQL
replication code moved in to Oracle kernel. Replication manager introduced.


    v.. Index Organized tables


    w.. Deferred integrity constraint checking (deferred until end of
transaction instead of end of statement).

    x.. SQL*Net replaced by Net8
    y.. Reverse Key indexes
    z.. Any VIEW updateable




    aa.. New ROWID format


  Oracle 7.3

    a.. Partitioned Views
    b.. Bitmapped Indexes
    c.. Asynchronous read ahead for table scans
    d.. Standby Database
    e.. Deferred transaction recovery on instance startup
    f.. Updatable Join Views (with restrictions)
    g.. SQLDBA no longer shipped.
    h.. Index rebuilds
    i.. db_verify introduced
    j.. Context Option
    k.. Spatial Data Option
    l.. Tablespaces changes - Coalesce, Temporary Permanent,
    m.. Trigger compilation, debug
    n.. Unlimited extents on STORAGE clause.
    o.. Some init.ora parameters modifiable - TIMED_STATISTICS
    p.. HASH Joins, Antijoins
    q.. Histograms
    r.. Dependencies
    s.. Oracle Trace
    t.. Advanced Replication Object Groups
    u.. PL/SQL - UTL_FILE




  Oracle 7.2

    a.. Resizable, autoextend data files
    b.. Shrink Rollback Segments manually
    c.. Create table, index UNRECOVERABLE
    d.. Subquery in FROM clause
    e.. PL/SQL wrapper
    f.. PL/SQL Cursor variables
    g.. Checksums - DB_BLOCK_CHECKSUM, LOG_BLOCK_CHECKSUM
    h.. Parallel create table
    i.. Job Queues - DBMS_JOB
    j.. DBMS_SPACE
    k.. DBMS Application Info
    l.. Sorting Improvements - SORT_DIRECT_WRITES


  Oracle 7.1

    a.. ANSI/ISO SQL92 Entry Level
    b.. Advanced Replication - Symmetric Data replication
    c.. Snapshot Refresh Groups
    d.. Parallel Recovery
    e.. Dynamic SQL - DBMS_SQL
    f.. Parallel Query Options - query, index creation, data loading
    g.. Server Manager introduced
    h.. Read Only tablespaces




  Oracle 7.0


    a.. Database Integrity Constraints (primary, foreign keys, check
constraints, default values)

    b.. Stored procedures and functions, procedure packages
    c.. Database Triggers
    d.. View compilation
    e.. User defined SQL functions
    f.. Role based security
    g.. Multiple Redo members - mirrored online redo log files
    h.. Resource Limits - Profiles
    i.. Much enhanced Auditing
    j.. Enhanced Distributed database functionality - INSERTS,


UPDATES,DELETES, 2PC


    k.. Incomplete database recovery (e.g SCN)
    l.. Cost based optimiser
    m.. TRUNCATE tables
    n.. Datatype changes (i.e VARCHAR2 CHAR, VARCHAR)
    o.. SQL*Net v2, MTS
    p.. Checkpoint process
    q.. Data replication - Snapshots
  **********************************************


  Bunyamin K. Karadeniz


  Information Technologies Dept.


  Database Group Tel :90-312-2873565/1681
  HAVELSAN Ankara / TURKEY




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.211 / Virus Database: 100 - Release Date: 11/14/00

------=_NextPart_000_000A_01C06C3B.B510C7E0
Content-Type: text/html;
	charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-9">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#a6caf0>
<DIV><SPAN class=3D007565111-22122000><FONT face=3DArial color=3D#0000ff =
size=3D2>Thank=20
you</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">


  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =

face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20
  [mailto:root_at_fatcity.com]<B>On Behalf Of </B>bunyamin=20
  karadeniz<BR><B>Sent:</B> Thursday, December 21, 2000 6:46 =
PM<BR><B>To:</B>=20
  Multiple recipients of list ORACLE-L<BR><B>Subject:</B> here is a =
summary of=20
  from 7 to oracle 8i new features <BR><BR></FONT></DIV>


  <DIV><FONT face=3DArial size=3D2>

  <H3><FONT color=3D#ff0000>Hi All Oracle Guru's , </FONT></H3>

  <H3><FONT color=3D#0000ff>You'll love this document so much . =

</FONT></H3>


  <H3>&nbsp;</H3>

  <H3>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20

  <DIV><FONT face=3DArial=20

  size=3D2>**********************************************<BR>Bunyamin K. =

  Karadeniz<BR>Information Technologies Dept.<BR>Database Group Tel=20
  :90-312-2873565/1681<BR>HAVELSAN Ankara /=20
  =
TURKEY<BR>**********************************************</FONT></DIV></H3=
>


  <H3>&nbsp;</H3>

  <H3>&nbsp;</H3>

  <H3>New Features Summary</H3>

  <H4>Oracle 8i (8.1.7)</H4>

  <UL type=3Ddisc>

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l4 level1 lfo3; tab-stops: list 36.0pt">Static=20
    HTTP server included (Apache)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l4 level1 lfo3; tab-stops: list 36.0pt">JVM=20
    Accelerator to improve performance of Java code=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l4 level1 lfo3; tab-stops: list 36.0pt">Java=20
    Server Pages (JSP) engine=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l4 level1 lfo3; tab-stops: list 36.0pt">MemStat=20
    - A new utility for analyzing Java Memory footprints=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l4 level1 lfo3; tab-stops: list 36.0pt">OIS=20
    - Oracle Intergration Server introduced.=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l4 level1 lfo3; tab-stops: list 36.0pt">PLSQL=20
    Gateway introduced for deploying PL/SQL based solutions on the Web=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l4 level1 lfo3; tab-stops: list 36.0pt">Enterprise=20
    Manager Enhancements - including new HTML based reporting and =
Advanced=20
    Replication functionality included.=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l4 level1 lfo3; tab-stops: list 36.0pt">New=20
    Database Character Ser Migration utilility included. </LI></UL>


  <H4>Oracle 8i (8.1.6)</H4>

  <UL type=3Ddisc>

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l0 level1 lfo6; tab-stops: list 36.0pt">PL/SQL=20
    Server Pages (PSP's)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l0 level1 lfo6; tab-stops: list 36.0pt">DBA=20
    Studio Introduced=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l0 level1 lfo6; tab-stops: list 36.0pt">Statspack=20

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l0 level1 lfo6; tab-stops: list 36.0pt">New=20
    SQL Functions (rank, moving average)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l0 level1 lfo6; tab-stops: list 36.0pt">ALTER=20
    FREELISTS command (previously done by DROP/CREATE TABLE)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l0 level1 lfo6; tab-stops: list 36.0pt">Checksums=20
    always on for SYSTEM tablespace allowing many possible corruptions =
to be=20
    fixed before writing to disk=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l0 level1 lfo6; tab-stops: list 36.0pt">XML=20
    Parser for Java=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l0 level1 lfo6; tab-stops: list 36.0pt">New=20
    PLSQL encrypt/decrypt package introduced=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l0 level1 lfo6; tab-stops: list 36.0pt">User=20
    and Schemas sepapated=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l0 level1 lfo6; tab-stops: list 36.0pt">Numerous=20
    Performance Enhancements </LI></UL>


  <H4>Oracle 8i (8.1.5)</H4>

  <UL type=3Ddisc>

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Fast=20
    Start recovery - Checkpoint rate auto-adjusted to meet roll forward =
criteria=20

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Reorganize=20
    indexes/index only tables which users accessing data - Online index =
rebuilds=20

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Log=20
    Miner introduced - Allows on-line or archived redo logs to be viewed =
via SQL=20

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">OPS=20
    Cache Fusion introduced avoiding disk I/O during cross-node =
communication=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Advanced=20
    Queueing improvements (security, performance, OO4O support=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">User=20
    Security Improvements - more centralisation, single enterprise user, =

    users/roles across multiple databases.=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Virtual=20
    private database=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">JAVA=20
    stored procedures (Oracle Java VM)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Oracle=20
    iFS=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Resource=20
    Management using proirities - resource classes=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Hash=20
    and Composite partitioned table types=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">SQL*Loader=20
    direct load API=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Copy=20
    optimizer statistics across databases to ensure same access paths =
across=20
    different environments.=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Stanby=20
    Database - Auto shipping and application of redo logs. Read Only =
queries on=20
    standby database allowed.=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Enterprise=20
    Manager v2 delivered=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">NLS=20
    - Euro Symbol supported=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Analyze=20
    tables in parallel=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Temporary=20
    tables supported.=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Net8=20
    support for SSL, HTTP, HOP protocols=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Transportable=20
    tablespaces between databases=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Locally=20
    managed tablespaces - automatic sizing of extents, elimination of =
tablespace=20
    fragmentation, tablespace information managed in tablespace (i.e =
noved from=20
    data dictionary) improving tablespace reliability=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Drop=20
    Column on table (Finally !!!!!)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">DBMS_DEBUG=20
    PL/SQL package, DBMS_SQL replaced by new EXECUTE IMMEDIATE statement =

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Progress=20
    Monitor to track long running DML,DDL=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l6 level1 lfo9; tab-stops: list 36.0pt">Functional=20
    Indexes - NLS, case insensitive, descending </LI></UL>


  <H4>Oracle 8.0</H4>

  <UL type=3Ddisc>

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Object=20
    Relational database=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Object=20
    Types (not just date, character, number as in v7=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">SQL3=20
    standard=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Call=20
    external procedures=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">LOB=20
    &gt;1 per table=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Partitioned=20
    Tables and Indexes=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">export/import=20
    individual partitions=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">partitions=20
    in multiple tablespaces=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">online/offline,=20
    backup/recover individual partitions=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">merge/balance=20
    partitions=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Advanced=20
    Queuing for message handling=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Many=20
    performance improvements to SQL/PLSQL/OCI making more efficient use =
of=20
    CPU/Memory. V7 limits extended (e.g. 1000 columns/table, 4000 bytes=20
    VARCHAR2)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Parallel=20
    DML statements=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Connection=20
    Pooling ( uses the physical connection for idle users and =
transparently=20
    re-establishes the connection when needed ) to support more =
concurrent=20
    users.=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Improved=20
    &#8220;STAR&#8221; Query optimizer=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Integrated=20
    Distributed Lock Manager in Oracle PS (as opposed to Operating =
system DLM in=20
    v7).=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Performance=20
    improvements in OPS - global V$ views introduced across all =
instances,=20
    transparent failover to a new node=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Data=20
    Cartridges introduced on database (e.g. image, video, context, time, =

    spatial)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Backup/Recovery=20
    improvements - Tablespace point in time recovery, incremental =
backups,=20
    parallel backup/recovery. Recovery manager introduced=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Security=20
    Server introduced for central user administration. User password =
expiry,=20
    password profiles, allow custom password scheme. Privileged database =
links=20
    (no need for password to be stored)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Fast=20
    Refresh for complex snapshots, parallel replication, PL/SQL =
replication code=20
    moved in to Oracle kernel. Replication manager introduced.=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Index=20
    Organized tables=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Deferred=20
    integrity constraint checking (deferred until end of transaction =
instead of=20
    end of statement).=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">SQL*Net=20
    replaced by Net8=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Reverse=20
    Key indexes=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">Any=20
    VIEW updateable=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l3 level1 lfo12; tab-stops: list 36.0pt">New=20
    ROWID format </LI></UL>


  <H4>Oracle 7.3</H4>

  <UL type=3Ddisc>

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Partitioned=20
    Views=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Bitmapped=20
    Indexes=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Asynchronous=20
    read ahead for table scans=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Standby=20
    Database=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Deferred=20
    transaction recovery on instance startup=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Updatable=20
    Join Views (with restrictions)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">SQLDBA=20
    no longer shipped.=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Index=20
    rebuilds=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">db_verify=20
    introduced=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Context=20
    Option=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Spatial=20
    Data Option=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Tablespaces=20
    changes - Coalesce, Temporary Permanent,=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Trigger=20
    compilation, debug=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Unlimited=20
    extents on STORAGE clause.=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Some=20
    init.ora parameters modifiable - TIMED_STATISTICS=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">HASH=20
    Joins, Antijoins=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Histograms=20

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Dependencies=20

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Oracle=20
    Trace=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">Advanced=20
    Replication Object Groups=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l5 level1 lfo15; tab-stops: list 36.0pt">PL/SQL=20
    - UTL_FILE </LI></UL>


  <H4>Oracle 7.2</H4>

  <UL type=3Ddisc>

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">Resizable,=20
    autoextend data files=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">Shrink=20
    Rollback Segments manually=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">Create=20
    table, index UNRECOVERABLE=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">Subquery=20
    in FROM clause=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">PL/SQL=20
    wrapper=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">PL/SQL=20
    Cursor variables=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">Checksums=20
    - DB_BLOCK_CHECKSUM, LOG_BLOCK_CHECKSUM=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">Parallel=20
    create table=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">Job=20
    Queues - DBMS_JOB=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">DBMS_SPACE=20

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">DBMS=20
    Application Info=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l7 level1 lfo18; tab-stops: list 36.0pt">Sorting=20
    Improvements - SORT_DIRECT_WRITES </LI></UL>


  <H4>Oracle 7.1</H4>

  <UL type=3Ddisc>

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l1 level1 lfo21; tab-stops: list 36.0pt">ANSI/ISO=20
    SQL92 Entry Level=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l1 level1 lfo21; tab-stops: list 36.0pt">Advanced=20
    Replication - Symmetric Data replication=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l1 level1 lfo21; tab-stops: list 36.0pt">Snapshot=20
    Refresh Groups=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l1 level1 lfo21; tab-stops: list 36.0pt">Parallel=20
    Recovery=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l1 level1 lfo21; tab-stops: list 36.0pt">Dynamic=20
    SQL - DBMS_SQL=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l1 level1 lfo21; tab-stops: list 36.0pt">Parallel=20
    Query Options - query, index creation, data loading=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l1 level1 lfo21; tab-stops: list 36.0pt">Server=20
    Manager introduced=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l1 level1 lfo21; tab-stops: list 36.0pt">Read=20
    Only tablespaces </LI></UL>


  <H4>Oracle 7.0</H4>

  <UL type=3Ddisc>

    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Database=20
    Integrity Constraints (primary, foreign keys, check constraints, =
default=20
    values)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Stored=20
    procedures and functions, procedure packages=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Database=20
    Triggers=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">View=20
    compilation=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">User=20
    defined SQL functions=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Role=20
    based security=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Multiple=20
    Redo members - mirrored online redo log files=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Resource=20
    Limits - Profiles=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Much=20
    enhanced Auditing=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Enhanced=20
    Distributed database functionality - INSERTS, UPDATES,DELETES, 2PC=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Incomplete=20
    database recovery (e.g SCN)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Cost=20
    based optimiser=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">TRUNCATE=20
    tables=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">Datatype=20
    changes (i.e VARCHAR2 CHAR, VARCHAR)=20
    <LI class=3DMsoNormal=20
    style=3D"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; =
mso-list: l2 level1 lfo24; tab-stops: list 36.0pt">SQL*Net=20


Received on Fri Dec 22 2000 - 05:52:06 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US