| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Some of you may find this useful
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:
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
>>> sfaroult_at_oriolecorp.com 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: sfaroult_at_oriolecorp.com 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: ListGuru_at_fatcity.com (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: RROGERS_at_galottery.org 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: ListGuru_at_fatcity.com (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: NDATFM_at_labor.state.ny.us 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: ListGuru_at_fatcity.com (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: joshic_at_mahindrabt.com 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: ListGuru_at_fatcity.com (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).Received on Fri Jan 10 2003 - 11:10:44 CST
 |
 |