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