Each oracle database is to be accessed by one or more Oracle instances. Oracle Instance Oracle instance is a collection of memory structures and processed that are used to manage oracle database.
In fact, starting from Oracle8i, oracle can run programs written either in PL/SQL or Java. This enables oracle to run java programs. Oracle also provides Java Virtual Machine (JVM) as part of database. Oracle is quite scalable, which means it can scale up and down very easily as the requirements change. One of the biggest advantages of Oracle has been its presence on around 100 different platforms. Oracle supports both OLTP (online transaction processing) applications as well data warehouse applications, which contain a very large database (VLDB). Oracle8i provides special features to support various types of data that is to be stored in web sites. Oracle8i onwards oracle is trying to provide extra facilities that are required to be an internet database.įigure 1: Oracle Server as Server in Client/Server computing model. Front-end programs that are written using application development tools such as Visual basic access Oracle and submit SQL commands for execution. Oracle Database Server Oracle database server is one of the databases that are widely used in client/server computing as back-end. It has Oracle Applications that includes Oracle Financials etc. Oracle Corporation is also into Enterprise Resource Planning (ERP). It doesn’t discuss about other products in Oracle9i. This book is about Oracle Database Server.
Oracle 8i for windows nt box 1 of 2 software#
Oracle Corporation has been targeting Internet programming with the caption - software powers the internet. Oracle Corporation is second largest software company next to Microsoft. Oracle is by far the most widely used relational database management system (RDBMS).
Oracle9iDB is the database management system that is used to store and access data. In simple words Oracle9i is a platform and not a simple database management system. Unlike Oracle8i, which is only a database management system, Oracle9i is a collection of following software: Oracle9i is the latest product released by Oracle Corporation. What is Oracle? Oracle is the name of the database management system that comes from Oracle Corporation.