v$open_cursor and session_cached_cursors

all;

i've read a number of postings, documentation and such on the subject, but something is still ocnfusing me. please forgive if this is a dumb question.

oracle 8.1.7: my understanding is that one is supposed to use session_cached_cursors to control the number of cursors that get cached by the plsql engine. however, it doesn't seem to be working the way i'm expecting it to. if you open/fetch/close a cursor, with session_cached_cursors set to 0, shouldn't the cursor *not* show up in v$open_cursor (resulting in a hard + soft parse for each execution)? i'm trying to differentiate which sql_text's in v$open_cursor represent cached cursors as opposed to cursors that are actually being left open by the (java) application, and i thought that i would be able to essentially turn off the cursor caching. what am i missing? thanks in advance .. Received on Mon Oct 15 2001 - 14:55:07 CDT