Oracle views and modifies its maximum number of cursors

The following article describes how to view and modify the maximum number of cursors in Oracle. This article describes how to use the relevant code to display and modify the maximum number of cursors in Oracle, the following is a description of the specific content of the article. I hope you will gain some benefits after browsing it.

1. view the maximum number of Oracle cursors in Oracle

 
 

  
  
C:\Documents and Settings\Administrator>sqlplus "sys/admin@test151 as sysdba"  
 
 

Sys logs on to the test151 service as a dba)

SQL * Plus: Release 9.2.0.1.0-Production on Thursday November 5 09:08:04 2009

 
 

  
  
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 
 
 

Connect:

 
 

  
  
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production  
  
  
With the Partitioning, OLAP and Oracle Data Mining options  
  
  
JServer Release 9.2.0.1.0 - Production  
  
  
SQL> show parameter open_cursors;  
  
  
NAME TYPE VALUE  
  
  
open_cursors integer 300  
 
 

2. Check the number of currently opened cursors in Oracle.

 
 

  
  
SQL> select count(*) from v$open_cursor;  
  
  
COUNT(*)  
  
  
17494  
 
 

3. Modify the maximum number of Oracle cursors

 
 

  
  
SQL> alter system set open_cursors=1000 scope=both; 
 
 

The system has been changed.

 
 

  
  
SQL> show parameter open_cursors;  
  
  
NAME TYPE VALUE  
  
  
open_cursors integer 1000   
 
 

The above content introduces how to view and modify the maximum number of cursors in Oracle. I hope you will find some gains.