Description of the illustration image012.gif

The figure shows the following ORACA variables:

• ORACAID Character string "ORACA"

• ORACABC Length of ORACA data structure in bytes

• ORACCHF Cursor cache consistency flag

• ORADBGF Master debug flag

• ORAHCHF Heap consistency flag

• ORASTXTF Save SQL statement flag

• ORASTXT Subrecord for storing SQL statement

• ORASTXTL Length of the current SQL statement

• ORASTXTC Text of the current SQL statement

• ORASFNM Subrecord for storing filename

• ORASFNML Length of the filename

• ORASFNMC Name of the file containing the current SQL statement

• ORASLNR Line in file at or near the current SQL statement

• ORAHOC Highest MAXOPENCURSORS requested

• ORAMOC Maximum open cursors required

• ORACOC Current number of cursors used

• ORANOR Number of cursor cache reassignments

• ORANPR Number of SQL statement parses

• ORANEX Number of SQL statement executors