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

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

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

From: bunyamin karadeniz <bunyamink_at_havelsan.com.tr>
Date: Fri, 22 Sep 2000 15:11:13 +0300
Message-Id: <10717.125104@fatcity.com> 





This is a multi-part message in MIME format.



------=_NextPart_000_0176_01C024A7.58BB1D50
Content-Type: text/plain;


        charset="iso-8859-9"


Content-Transfer-Encoding: quoted-printable



Hi All Oracle Guru's ,=20


You'll love this document so much .=20



         =20




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)=20
  b.. JVM Accelerator to improve performance of Java code=20
  c.. Java Server Pages (JSP) engine=20
  d.. MemStat - A new utility for analyzing Java Memory footprints=20
  e.. OIS - Oracle Intergration Server introduced.=20
  f.. PLSQL Gateway introduced for deploying PL/SQL based solutions on =


the Web=20


  g.. Enterprise Manager Enhancements - including new HTML based =
reporting and Advanced Replication functionality included.=20
  h.. New Database Character Ser Migration utilility included.=20
Oracle 8i (8.1.6)

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


corruptions to be fixed before writing to disk=20

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


Oracle 8i (8.1.5)


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


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


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


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


  e.. Advanced Queueing improvements (security, performance, OO4O =
support=20


  f.. User Security Improvements - more centralisation, single =
enterprise user, users/roles across multiple databases.=20

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


paths across different environments.=20


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

  o.. Enterprise Manager v2 delivered=20
  p.. NLS - Euro Symbol supported=20
  q.. Analyze tables in parallel=20
  r.. Temporary tables supported.=20
  s.. Net8 support for SSL, HTTP, HOP protocols=20
  t.. Transportable tablespaces between databases=20
  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=20


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


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

  a.. Object Relational database=20
  b.. Object Types (not just date, character, number as in v7=20
  c.. SQL3 standard=20
  d.. Call external procedures=20
  e.. LOB >1 per table=20
  f.. Partitioned Tables and Indexes=20
  g.. export/import individual partitions=20
  h.. partitions in multiple tablespaces=20
  i.. online/offline, backup/recover individual partitions=20
  j.. merge/balance partitions=20
  k.. Advanced Queuing for message handling=20
  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)=20


  m.. Parallel DML statements=20


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


  o.. Improved "STAR" Query optimizer=20
  p.. Integrated Distributed Lock Manager in Oracle PS (as opposed to =
Operating system DLM in v7).=20


  q.. Performance improvements in OPS - global V$ views introduced =
across all instances, transparent failover to a new node=20
  r.. Data Cartridges introduced on database (e.g. image, video, =
context, time, spatial)=20


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


  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)=20
  u.. Fast Refresh for complex snapshots, parallel replication, PL/SQL =
replication code moved in to Oracle kernel. Replication manager =
introduced.=20


  v.. Index Organized tables=20


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

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




  aa.. New ROWID format=20


Oracle 7.3

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




Oracle 7.2

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


Oracle 7.1

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




Oracle 7.0


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

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


UPDATES,DELETES, 2PC=20


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


Bunyamin K. Karadeniz


Information Technologies Dept.


Database Group Tel :90-312-2873565/1681


HAVELSAN Ankara / TURKEY





------=_NextPart_000_0176_01C024A7.58BB1D50
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 content=3D"text/html; charset=3Diso-8859-9" =

http-equiv=3DContent-Type>


<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>

<STYLE></STYLE>

</HEAD>

<BODY bgColor=3D#a6caf0>

<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.=20


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




  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 fixed=20


  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,=20
  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





  CPU/Memory. V7 limits extended (e.g. 1000 columns/table, 4000 bytes =
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 =
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, =



  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, =



  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 (no=20


  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





  <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 Sep 22 2000 - 07:11:13 CDT












Original text of this message













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