hi here are the specs of my db: version 8.1.7 on windows,open_cursors=500 i am facing a certain issue. we have a few sessions running out of cursor(ora-1000) and i used 1000 event to dump trace on these sessions. i found a certain statement select <seq>.nextval from dual; being repeated more than 350 times of the available 500 cursors. the dev say nothing has changed nor has there been a increase in the load.
can you please advise me whther this could be a issue or am i missing something here thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).