DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Aq_tm_processes

  1. #1
    Join Date
    Nov 2002
    Location
    INDIA
    Posts
    38

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    believe it is only relvant if you are using advanced queuing..r u?
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Nov 2002
    Location
    INDIA
    Posts
    38
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    are you using advanced queueing? if not what's the point setting that even

  5. #5
    Join Date
    Nov 2002
    Location
    INDIA
    Posts
    38
    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

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    since I have not used advanced queueing myself

    RTFM

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width