INTRODUCTION TO ORACLE
A relational model, made by Dr. E.F Codd in 1970, sponsored by IBM, accepted as definitive model for RDBMS. This language developed by IBM to manipulate the data stored within Codd’s model was originally called Structured English Query Language(SEQUAL) with the word English later being dropped in favor Structured Query Language(SQL).
In 1979 a company called Relation Software, Inc. released the first commercially available implementation of SQL. Relation Software later came to be known as Oracle Corporation. Oracle corporation is a company that produces the most widely used, Server based, Multi user RDBMS named Oracle.
FEATURES OF ORACLE:
1. Very Large Memory Support:
Oracle allows Very Large Memory (VLM) configuration in Window 2000 and Window XP, which allows Oracle to access more than 4GB RAM.
2. 4GB RAM TUNING(4GT):
Window NT Server Enterprise and Datacenter Editions include a feature called 4GB RAM TUNING(4GT).This feature allows memory-intensive applications running on Oracle
3. VLM INSTANCE TUNING:
VLM configuration improves database performance by caching more database buffers in memory.
4. USER MIGRATION UTILITY:
A new command-line tool, User Migration Utility, simplifies conversion of local or external database users to enterprise users.
5. ORACLE SHARED SERVER PROCESS:
It is a server configuration which allows many user processes to share very few server processes. The user processes connect to a dispatcher background process, which routes client requests to the next available shared server process.
6. ORACLE NET MULTIPLEXING AND CONNECTION POOLING:
Oracle net multiplexing and connection pooling features allow a large configuration to connect more users to a single database instance.
7. ORACLE REAL APPLICATION CLUSTERS:
This clusters raises connection counts dramatically by allowing multiple server computers to access the same database files, increasing the number of user connections by tens of thousands, as well as increasing throughput
FEATURES OF ORACLE:
1. Very Large Memory Support:
Oracle allows Very Large Memory (VLM) configuration in Window 2000 and Window XP, which allows Oracle to access more than 4GB RAM.
2. 4GB RAM TUNING(4GT):
Window NT Server Enterprise and Datacenter Editions include a feature called 4GB RAM TUNING(4GT).This feature allows memory-intensive applications running on Oracle
3. VLM INSTANCE TUNING:
VLM configuration improves database performance by caching more database buffers in memory.
4. USER MIGRATION UTILITY:
A new command-line tool, User Migration Utility, simplifies conversion of local or external database users to enterprise users.
5. ORACLE SHARED SERVER PROCESS:
It is a server configuration which allows many user processes to share very few server processes. The user processes connect to a dispatcher background process, which routes client requests to the next available shared server process.
6. ORACLE NET MULTIPLEXING AND CONNECTION POOLING:
Oracle net multiplexing and connection pooling features allow a large configuration to connect more users to a single database instance.
7. ORACLE REAL APPLICATION CLUSTERS:
This clusters raises connection counts dramatically by allowing multiple server computers to access the same database files, increasing the number of user connections by tens of thousands, as well as increasing throughput
0 comments:
Post a Comment