Stephane and other Gurus, Apologies if you think I am a spoilsport..
I executed 3/4 PL/SQL blocks and ran the query after each one. Every time I got the following output. I think 'REPOS' is the OEM repository owner. Two questions: 1. Is this what Stephane wanted us to see? 2. If yes, what does that indicate? That some component of OEM runs the procedure 'SMP_VDP' every time we execute a PL/SQL block? (This is total guesswork, so I may be horribly off target.) Regards, Charu PROC QUERY ----------------------------------- ---------------------------------------- REPOS.SMP_VDP SELECT NUM_NODES FROM SMP_VDP_OMS_NUM_NODES WHERE (OMS = :b1 ) LOCK TABLE SMP_VDG_GATEWAY_MAP IN EXCLUSIVE MODE LOCK TABLE SMP_VDP_NODE_OMS_MAP IN EXCLUSIVE MODE SELECT OMS,NUM_NODES FROM SMP_VDP_OMS_NUM_NODES WHERE (OMS != :b1 )ORDER BY NUM_NODES DESC UPDATE SMP_VDP_NODE_OMS_MAP SET OMS=:b1 WHERE (OMS = :b2 ) AND (ROWNUM <= :b3 ) UPDATE SMP_VDP_OMS_NUM_NODES SET NUM_NODES=NUM_NODES - :b1 WHERE (OMS = :b2 ) UPDATE SMP_VDP_OMS_NUM_NODES SET NUM_NODES=NUM_NODES + :b1 WHERE (OMS = :b2 ) INSERT INTO SMP_VDP_OMS_NUM_NODES VALUES ( :b1,:b2 ) UPDATE SMP_VDG_NODE_LIST SET AGENTSTATE='UNK',PROCESSING= NULL WHERE NODENAME IN (SELECT NODE FROM SMP_VDP_NODE_OMS_MAP WHERE OMS = :b1 ) AND (AGENTSTATE != 'BAD' ) UPDATE SMP_VDP_NODES SET TIMESTAMP=SYSDATE WHERE NODE IN (SELECT NODE FROM SMP_VDP_NODE_INFO WHERE STATUS = 'Y' ) SELECT OMS,NUM_NODES FROM SMP_VDP_OMS_NUM_NODES WHERE (OMS != :b1 )ORDER BY NUM_NODES DELETE FROM SMP_VDP_OMS_NUM_NODES WHERE (OMS = :b1 ) -----Original Message----- Thomas F Sent: Friday, January 10, 2003 4:49 PM To: Multiple recipients of list ORACLE-L Ron, did you run it from the SYS account? worked for me using 8.1.7.2 Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Friday, January 10, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Stephane, My creativity has been stumulated, simulated, and mutated. What version of Oracle are you using? x$kglrd ...table or view does no exist on 8.1.7 rel 3 Ron >>> [EMAIL PROTECTED] 01/10/03 05:03AM >>> break on proc column "QUERY" format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM "QUERY" from x$kglrd where KGLNAOWN != 'SYS' order by 1, kgldepno / If it doesn't stimulate your creativity I can do nothing for you :-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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). ********************************************************* Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. ********************************************************* Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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).