SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
SQL> SHOW PARAMETER CURSOR;
NAME
TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
cursor_sharing
string
SIMILAR
cursor_space_for_time
boolean
FALSE
open_cursors
integer
800
session_cached_cursors
integer
0