Re: Oracle Performance

Answers intermixed.

victornavin_at_my-dejanews.com wrote in article <7eeh3c$3tf$1_at_nnrp1.dejanews.com>...
> Hi, My name is Victor and I am a research student at Uni of Melbourne and
> I would like to know as to how Oracle performs with respect to the
following
> parameters.If some 1 can let me know as to how it works or where I could
find
> it please do mail me..
>

The manuals referenced below are based on version 8 and I believe that you can find them on-line at the Oracle web site: www.oracle.com

> 1.Language it supports for querying.
 SQL. Also see nls (natural language support) parameters in Concepts Manual
 for foreign language, time zone, and numeric and monetary formating.

> 2.Embedded language features such as C and java
  PL/SQL PL/SQL manual; plus version 8i has an optional built-in Java virtual machine so Java can be used to write stored procedures and triggers.

> 3.Types Isolation it provides.

  I think you are talking about the read consistency model and locking. Oracle supports multiple methods. The default is statement level point in time read consistency with row level locking but ANSI serializable is available at a negative performance cost. See the Concepts manual and/or Application Developers Guide

> 4.Database tuning facilities it supports.
  Several third party tools, Oracle Enterprise Manager tool, and several dynamic performance tables that can be queried, Explain Plan, and tkprof utility. See the Oracle 8 Tuning manual.

> 5.Type of recovery model it uses.

  I do not know the name, but recovey is explained in the Concepts manual. Both last full backup and forward recovery are supported depending on user selected parameters. Related data structures are redo logs and rollback segments.

> 6.Parallel processing

  Both parallel query and parallel server are explained in the Concepts manual

> 7.Cost of the system.

  Talk to Oracle sales department. It varies.
>
> Thanks
> Victor
    Received on Wed Apr 07 1999 - 08:39:36 CDT