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 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