cursor一般用在什么地方？有何弱点？

what is cursor?

In some database programs, the term cursor is an acronym that stands for current set of records. When a group of records is selected, that group is called the current set.

 

简单理解cursor就是一个句柄这个句柄指向的内存空间里面存储这个sql语句执行后返回的当前的记录集合

 

什么是CURSOR，ORACLE的文档作了如下定义：

A cursor is a handle (a name or pointer) for the memory associated with a specific statement. (Oracle Call Interface, OCI, refers to these as statement handles.) Although most Oracle users rely on automatic cursor handling of Oracle utilities, the programmatic interfaces offer application designers more control over cursors.

For example, in precompiler application development, a cursor is a named resource available to a program and can be used specifically to parse SQL statements embedded within the application. Application developers can code an application so it controls the phases of SQL statement execution and thus improves application performance.

 

An Oracle cursor is a handle to an area in memory that holds the result set of a SQL query, enabling you to individually process the rows in the result set. Oracle uses implicit cursors for all DML statements. Explicit cursors are created and used by application coders.

 

缺点就是如果对于显示游标不及时关闭有可能耗费大量的内存，这样有可能造成数据库挂起操作，因为游标是在PGA和sharepool里面都有存在的 会引起性能问题。