| Dynamic SQLs [message #542] |
Tue, 19 February 2002 05:45  |
Rolando Marino
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
|
I have an application that creates 40+ Dynamic sqls on startup. The application will be distributed to 30 users. During testing I have noticed that the number of open cursors equals the number of dynamic SQLs even it the result sets are close. Does this mean that when using Dynamic SQLs the server assigns a cursor per SQL until the handle to the SQL is destroy?
|
|
|
|
| Re: Dynamic SQLs [message #545 is a reply to message #542] |
Tue, 19 February 2002 07:15  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
hi,
perhaps u r looking at v$open_cursor. the entries in this view does not guarantees that cursor is open.sometimes oracle keeps the cursor open due to performance reason
cheers
pratap
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
