Scalability and Performance with Oracle
Oracle Server gives you a number of scalability and performance improvements.
For the most part, you obtain these advantages automatically.
For example, you can access Oracle Database Server's:
- Larger sizes. The database itself, the number of concurrent users, and its
table column limits (now up to 1000 columns) have all increased.
- Table and index partitioning
- Client-side object caching
You can also make direct use of several other Oracle Database Server functions that provide
it with improved performance:
- Prefetch. Forms uses this Oracle feature (along with the existing Array
Size mechanism) to reduce both database round-trips and memory usage. This
is done automatically, without any need for user involvement.
- Returning values clause. Forms uses this new DML feature when doing inserts
and updates. The Returning clause eliminates the need for a second database
query (to obtain any server-side trigger changes to the data), thus speeding
up processing. Users can control it with the DML Returning Value property.
- INSTEAD-OF trigger for updating views. This server-side trigger provides
a mechanism for updating both relational and object views that would not otherwise
be updatable.