how to set packages size to certain values on your tnsnames/listerner
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to set packages size to certain values on your tnsnames/listerner

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    how to set packages size to certain values on your tnsnames/listerner

    How can you set the package size to certain value on your tnsnames/listener. we have some problem with the network and one of the suggestion is trying to set the package size to 8192

    any advises???

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    go to network admin guide index, look SDU and TDU

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    In the listener,

    SID_LIST_LISTENERABC =
    (SID_LIST =
    (SID_DESC =
    (SDU = 8192)
    (TDU = 8192)
    (SID_NAME = ABC)
    (ORACLE_HOME = /opt/app/oracle/product/9.2.0)
    )
    )


    In the tnsnames.ora,


    ABC =
    (DESCRIPTION =
    (SDU = 8192)
    (TDU = 8192)
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 90.100.100.100)(PORT = 1522))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ABC)
    )
    )

    Tamil

  4. #4
    Join Date
    Oct 2003
    Posts
    312
    I have a question about this issue and it's still a mysteries, could someone throw out some hint.

    We have a procedure on our client database, it access to our database through DB Link, basically the proc go to our database and grab the data and pull it to their database do some business logic and update some of the records on our database. The two tables on our side is not big (<100 rows). For some reason, every time the procedure was executed, it froze. After some analysis, the DBA requested to do SQL* trace during the execution of the proc.

    Is his approach is appropriate??? Could anyone think of the reason??? BTW, my database and the client database was connected via fiber optics. could it be the firewall set up or configuration????

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