On 5/9/07, Thotangare, Ajay (GTI) <Ajay_Thotangare@xxxxxx> wrote:
I don't want constant re-connection. I want to use this logic and fire some queries every secs during certain period for proactive monitoring. making so many connections is not acceptable.
Most knowledgeable folks are willing to help. They usually are not willing however to guess about your intent, platform, Oracle versions, etc.. http://www.catb.org/~esr/faqs/smart-questions.html -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist