Oracle

Tech  Oracle

Oracle - Oracle is a database management system or DBMS. Oracle Corporation produces and markets the Oracle DBMS, which many database applications use extensively on many popular computing platforms.

The Oracle corporation is managed by Larry Ellison and his friends and former co-workers Bob Miner and Ed Oates - who had started a consultancy called Software Development Laboratories (SDL) - developed the original Oracle DBMS software. They called their finished product Oracle after the code name of a CIA-funded project they had worked on while previously employed by Ampex.

Oracle Corporation is the largest software company whose primary business is database products. Historically, Oracle has targeted high-end workstations and minicomputers as the server platforms to run its database systems. Its relational database was the first to support the SQL language, which has since become the industry standard. Along with Sun Microsystems, Oracle has been one of the leading champions of network computers.

Oracle Database - Storage and Tablespaces Structures
An Oracle database comprises an instance and data storage. The instance comprises a set of operating system processes and memory structures that interact with the storage. Processes can in turn archive the online redo logs into archive logs (offline redo logs), which provide the basis (if necessary) for data recovery and for some forms of data replication.

The Oracle RDBMS stores data logically in the form of tablespaces and physically in the form of data files. Tablespaces can contain various types of segments, for example, Data Segments, Index Segments etc. Segments in turn comprise one or more extents. Extents comprise groups of contiguous data blocks. Data blocks form the basic units of data storage. At the physical level, data files comprise one or more data blocks.

Oracle keeps track of its data storage with the help of information stored in the SYSTEM tablespace. The SYSTEM tablespace contains the data dictionary - and often (by default) indexes and clusters.

The Oracle DBMS can store and execute stored procedures and functions within itself. Such code can operate under PL/SQL (Oracle Corporation's proprietary procedural extension to SQL), or under the object-oriented language Java.

In , Oracle Corporation released Oracle Database 10g. The g stands for "grid"; emphasizing a marketing thrust of presenting 10g as "grid-computing ready".

Oracle Links
Oracle Home
Oracle Database , a view provided by Oracle Corporation
On-line documentation
Oracle Technology Network
Metalink, Oracle's online support site - requires a password
The Oracle FAQ
Ask Tom - Oracle questions addressed by Thomas Kyte -
  • Oracle Forums OTN and OraFAQ (both requires free registration to log in)
  • Oracle-Rdb for OpenVMS
    Oracle / SQL Tutorial Oracle SQL and PL/SQL tutorials from the UC Davis Database and Information Systems Group (DBIS)
    First Course in Database Systems Oracle Guide The Oracle Bulk Loader, Oracle Dates and Times.
    Oracle-Base Scripts, articles, example code, utilities and a user forum. Covers Oracle 8i, 9i and 10G.
    Choosing Between Oracle and SQL Server This article from InfoWorld Magazine compares and contrasts Oracle and SQL Server.
    Creating Virtual Private Databases in Oracle Article that shows how to implement a Virtual Private Database. Oracle contains several security features that allow database administrators to achieve greater control over their information.
    Migrating to Oracle 8i and 9i This article from Caldera offers advice on upgrading an Oracle installation to Oracle 8i or 9i.
    Orac Database Administration Tool This is a freeware program distributed under the GNU Public License. Provides a suite of database administration tools for users of Oracle, Sybase and Informix products.
    Oracle and XML Provides a brief introduction to XML technology and the Oracle DBMS.
    Oracle FAQ Offers a comprehensive set of frequently asked questions about the Oracle family of database products.
    Oracle Internals Magazine Technically-oriented magazine designed and written for experienced Oracle administrators.
    Oracle Replication FAQ Provides an informative listing of frequently asked questions on the replication capabilities of Oracle databases.
    Oracle's official website offers a comprehensive look at the company's product line along with product support, case studies and implementation assistance.
    Running Oracle on FreeBSD Looking for a FreeBSD database solution? This article provides a step-by-step tutorial on installing Oracle 8 for Linux on a FreeBSD system.
    Underground Oracle FAQ An unoffical, but surprisingly complete, set of frequently asked questions about Oracle products and the Oracle corporation.
    Using Oracle Global Database Links Demonstrates how global database links can simplify your multi-server Oracle environment.
    Hot Oracle Site dedicated to Oracle products with PL SQL and SQLPlus Manuals
    Oracle Fan Club Exchange ideas with other oracle users in the world. Find tips & tricks in ORACLE. have a chat on hot topics. find jobs in ORACLE
    Oracle Commands An AZ Index of Oracle SQL Commands (version 9.2) Words in CAPS are Oracle commands, words in lower-case are the options you can modify.
    Tech on the Net - Oracle Basic code examples for SQL and PL/SQL. Select statements, variables, functions, triggers.
    Oracle Job Network Oracle Jobs, Resumes, Links - The premier website for Oracle Jobs and Resumes.
    An Introduction to Oracle Free Oracle Tutorials. A series of Oracle database tutorials featuring an introduction to the Oracle DBMS, Oracle SQL and SQL*Plus--PL/SQL--Oracle data
    Oracle 101 An overview of Oracle illustrated with several examples. Content includes advanced techniques for database administration
    Using Oracle PL/SQL As with Oracle SQL programs, we can invoke a PL/SQL program either by typing it Note that PL/SQL allows BOOLEAN variables, even though Oracle does not
    Oracle: SQL*Plus Tutorial Oracle faq contains several hints on Oracles products, including SQL Plus and Oracle SQL In windows, find the Oracle group and click on SQL Plus.
    Oracle Linux Page - Installing Real Application Cluster Tuning and Optimizing Red Hat Enterprise Linux for Oracle 9i and 10g Databases Installing Oracle 9i Database on Red Hat Enterprise Linux AS 4, 3, 2.1,
    tech oracle1 2016