Aq_tm_processes

Hi All,

Can anybody tell me what will be the effect of increase in the parameter value AQ_TM_PROCESSES in the init.ora file.

Thanks in advance,

Regards,

Paddy

believe it is only relvant if you are using advanced queuing..r u?

That is right stmontgo..and I know that..
What I want to know is the effact of increasing the parameter value..in the init.ora file..

Regards,

Paddy

are you using advanced queueing? if not what's the point setting that even

Yes pando...Consider it that I am using it in my database...Then how will it affect...
Pls tell how will it moniter the queues..what will be its effect in SGA...what is the relative affect in performance.

Warm Regards,

Pradeep

since I have not used advanced queueing myself

RTFM

http://download-west.oracle.com/docs...a76938/toc.htm