Progress
DataServer
for ORACLE Guide
Skipping Schema Verification
When r-code runs each time a table, view, or buffer is opened, the DataServer checks the data definitions of the ORACLE database to make sure they match the schema definitions in the schema holder. If they do not match, the DataServer returns an error.
Unmatched definitions can result in the corruption of your ORACLE database. However, verifying the definitions is time consuming in a production scenario. In a production environment, you might consider using the -Dsrv skip-schema-check startup parameter to increase performance, but only when you are certain that the data definitions in the ORACLE database, at least for the tables you are accessing, have not changed.
CAUTION: If you use this parameter, and the DataServer skips the schema check, it will not detect discrepancies between the schema in the schema holder and the data definitions in the ORACLE database. If it continues to process queries, inserts, and deletions, your ORACLE database might become corrupted.Even if you specify the skip-schema-check option, the DataServer does not skip the schema check if one of these cases is true:
- The schema holder does not have enough information on the table being queried to determine the maximum size of a column. For example, there might not be maximum size information if you had a Version 8 schema holder that you dumped and loaded into a Version 9 schema holder. In Version 8, the DataServer did not store information in the schema holder on maximum sizes of CHARACTER and RAW columns. To make sure that the schema holder has the required maximum size information, use the Progress Data Admin Update/Add ORACLE Table Definitions utility to update the schema holder after using the dump and load utilities.
- A view does not have a field selected to serve as a record identifier (PROGRESS_RECID).
The
dataserv.lg
log file notes when the DataServer skips the schema check.Measure carefully the performance benefit against the risk to your database before deciding to use -Dsrv skip-schema-check.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |