oracle
View Answers
January 8, 2009 at 8:03 AM
Hi friend,
The SDU and TDU parameters in the tnsnames.ora file
The session data unit (SDU) and transport date unit (TDU) parameters are located in the tnsnames.ora and listener.ora files. SDU specifies the size of the packets to send over the network. Ideally, SDU should not surpass the size of the maximum transmission unit (MTU). MTU is a fixed value that depends on the actual network implementation used. Oracle recommends that SDU be set equal to MTU.
The TDU is the default packet size used in the tnsnames.ora file to group data together. The TDU parameter should ideally be a multiple of the SDU parameter. The default value for both SDU and TDU is 2,048, and the maximum value is 32,767 bytes.
The basic syntax for a tnsnames.ora file
net_service_name=
(DESCRIPTION=
(ADDRESS=(protocol_address_information))
(CONNECT_DATA=
(SERVICE_NAME=service_name)))
DESCRIPTION contains the connect descriptor, ADDRESS contains the protocol address, and CONNECT_DATA contains the database service identification information.
--------------------------------------
Thanks.
The SDU and TDU parameters in the tnsnames.ora file
The session data unit (SDU) and transport date unit (TDU) parameters are located in the tnsnames.ora and listener.ora files. SDU specifies the size of the packets to send over the network. Ideally, SDU should not surpass the size of the maximum transmission unit (MTU). MTU is a fixed value that depends on the actual network implementation used. Oracle recommends that SDU be set equal to MTU.
The TDU is the default packet size used in the tnsnames.ora file to group data together. The TDU parameter should ideally be a multiple of the SDU parameter. The default value for both SDU and TDU is 2,048, and the maximum value is 32,767 bytes.
The basic syntax for a tnsnames.ora file
net_service_name=
(DESCRIPTION=
(ADDRESS=(protocol_address_information))
(CONNECT_DATA=
(SERVICE_NAME=service_name)))
DESCRIPTION contains the connect descriptor, ADDRESS contains the protocol address, and CONNECT_DATA contains the database service identification information.
--------------------------------------
Thanks.
Related Tutorials/Questions & Answers:
oracle
oracle sir now am doing one project , my frond end is vb and backend is oracle. so 1> how can i store the image in my field 2> how can i back up the table into .txt file
oracle sir now am doing one project , my frond end is vb and backend is oracle. so 1> how can i store the image in my field 2> how can i back up the table into .txt file
Advertisements
Oracle BLOB
Oracle BLOB Can anyone send me the code for inserting an image or audio into the oracle database using BLOB datatype. Plz...it's useful for my project
Oracle BLOB Can anyone send me the code for inserting an image or audio into the oracle database using BLOB datatype. Plz...it's useful for my project
oracle conditions
oracle conditions can you briefly explain about the "EXISTS" condition in SQL with examples
oracle conditions can you briefly explain about the "EXISTS" condition in SQL with examples
oracle - JDBC
oracle sir iam hari iam doing the project using oracle with jdbc in xp when iam inserting the data it is giving error like ora-01034:oracle not available sir plz.......give me the solution it is urgent sir thanku
oracle sir iam hari iam doing the project using oracle with jdbc in xp when iam inserting the data it is giving error like ora-01034:oracle not available sir plz.......give me the solution it is urgent sir thanku
oracle problem
oracle problem Hi I have installed oracleXE on my system and for reasons i've uninstalled them and am not able to stop oracle xe services and i could'nt reinstall it. I couldnt reinstall my os for this as it is in my office
oracle problem Hi I have installed oracleXE on my system and for reasons i've uninstalled them and am not able to stop oracle xe services and i could'nt reinstall it. I couldnt reinstall my os for this as it is in my office
Oracle - SQL
Oracle I have one .dmp file. I want to import this file into oracle 9i and oracle 10g. wat is procedure and stepts. thanks u Open... D:\oracle\ora90\BIN\imp type this command if your are using oracle 9i
Oracle I have one .dmp file. I want to import this file into oracle 9i and oracle 10g. wat is procedure and stepts. thanks u Open... D:\oracle\ora90\BIN\imp type this command if your are using oracle 9i
oracle - JDBC
to store these two fields into oracle database for that i have given one jsp page... it is giving error like java.sql.SQLException:[MICROSOFT][ODBC Driver for oracle][oracle
to store these two fields into oracle database for that i have given one jsp page... it is giving error like java.sql.SQLException:[MICROSOFT][ODBC Driver for oracle][oracle
oracle connectivity
oracle connectivity con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr"); i have error on above line when i tried...=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr
oracle connectivity con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr"); i have error on above line when i tried...=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr
oracle - JDBC
oracle How to collect the backup of tables in oracle? plz,, i want some tables in oracle of one system to be shifted to the another system...;There are two .exe files in ORACLE, with the FOLLOWING names,generally
oracle How to collect the backup of tables in oracle? plz,, i want some tables in oracle of one system to be shifted to the another system...;There are two .exe files in ORACLE, with the FOLLOWING names,generally
oracle - SQL
oracle can you suggest me a book regarding oracle and java even.. Hi friend, For more information on Oracle and Java Books visit to : http://www.roseindia.net/programming/books/Freejavabooks.shtml http
oracle can you suggest me a book regarding oracle and java even.. Hi friend, For more information on Oracle and Java Books visit to : http://www.roseindia.net/programming/books/Freejavabooks.shtml http
oracle - SQL
oracle what is meant by redo log file? Hi Friend, In Oracle, a redo log file is used with each database. It records all changes made in datafiles.Each transactions has been recorded in it.It makes it possible
oracle what is meant by redo log file? Hi Friend, In Oracle, a redo log file is used with each database. It records all changes made in datafiles.Each transactions has been recorded in it.It makes it possible
java-oracle
java-oracle hi friends, I wanted to upload a image from jsp page to oracle database.i am not getting how to do it... Please help me if you can....... please give me detail code
java-oracle hi friends, I wanted to upload a image from jsp page to oracle database.i am not getting how to do it... Please help me if you can....... please give me detail code
oracle - JDBC
oracle HI i am using ORACLE 10g. How to i find "TNSNAMES.ORA" file in my system after installation of ORACLE 10g succussfully. please send... that depends on the actual network implementation used. Oracle recommends that SDU
oracle HI i am using ORACLE 10g. How to i find "TNSNAMES.ORA" file in my system after installation of ORACLE 10g succussfully. please send... that depends on the actual network implementation used. Oracle recommends that SDU
Oracle - JDBC
Oracle How to Use Blob and Clob Data types in Oracle... Hi friend BLOB : Binary Large Object CLOB : Character Large Object Default storage each time a BLOB or CLOB exceeds 4000 bytes you could cause
Oracle How to Use Blob and Clob Data types in Oracle... Hi friend BLOB : Binary Large Object CLOB : Character Large Object Default storage each time a BLOB or CLOB exceeds 4000 bytes you could cause
jsp connection with oracle.
jsp connection with oracle. I want to connect with jsp to oracle,,,plz send me the codes
jsp connection with oracle. I want to connect with jsp to oracle,,,plz send me the codes
jsp connection with oracle.
jsp connection with oracle. I want to connect with jsp to oracle,,,plz send me the codes
jsp connection with oracle. I want to connect with jsp to oracle,,,plz send me the codes
Oracle 9i free download
Oracle 9i free download where to download oracle 9i for database connectivity in j2ee
Oracle 9i free download where to download oracle 9i for database connectivity in j2ee
storing csv into oracle database
storing csv into oracle database i want jsp code for storing csv file into oracle database
storing csv into oracle database i want jsp code for storing csv file into oracle database
File insertion into oracle database
File insertion into oracle database How to Read and Insert a file (any format) into a Oracle database
File insertion into oracle database How to Read and Insert a file (any format) into a Oracle database
oracle data backup
oracle data backup how to take oracle tables data backup and use in another system
oracle data backup how to take oracle tables data backup and use in another system
jdk6 and oracle 8i
jdk6 and oracle 8i I connecte oracle 8i and jdk6 I notice that why can not connect
jdk6 and oracle 8i I connecte oracle 8i and jdk6 I notice that why can not connect
Uninstall Oracle Virtual Box
Uninstall Oracle Virtual Box Hi, Is there any video of uninstalling Oracle Virtual Box? Thanks
Uninstall Oracle Virtual Box Hi, Is there any video of uninstalling Oracle Virtual Box? Thanks
ModuleNotFoundError: No module named 'oracle'
ModuleNotFoundError: No module named 'oracle' Hi, My Python... 'oracle' How to remove the ModuleNotFoundError: No module named 'oracle'... to install padas library. You can install oracle python with following command
ModuleNotFoundError: No module named 'oracle' Hi, My Python... 'oracle' How to remove the ModuleNotFoundError: No module named 'oracle'... to install padas library. You can install oracle python with following command
Hibernate oracle dialect
Hibernate oracle dialect What is the the Hibernate oracle dialect? Hi, Here is the Hibernate dialect for oracle database: org.hibernate.dialect.OracleDialect Read more at Dialect in Hibernate. Thanks
Hibernate oracle dialect What is the the Hibernate oracle dialect? Hi, Here is the Hibernate dialect for oracle database: org.hibernate.dialect.OracleDialect Read more at Dialect in Hibernate. Thanks
Oracle Tutorial
Oracle Tutorial In this section we will discuss about the Oracle Database. This tutorial will describe you about the Oracle Database. This section will describe you the many aspects of Oracle such as, What is Oracle database, Oracle
Oracle Tutorial In this section we will discuss about the Oracle Database. This tutorial will describe you about the Oracle Database. This section will describe you the many aspects of Oracle such as, What is Oracle database, Oracle
Oracle ANd JDBC - JDBC
Oracle ANd JDBC How to Save and Retrieve an Image or File into a Oracle Table.. Please give me answer as early as possible.. Thanks
Oracle ANd JDBC How to Save and Retrieve an Image or File into a Oracle Table.. Please give me answer as early as possible.. Thanks
Spring and Oracle Database
Spring and Oracle Database I need example for Batch update process using oracle database and spring framework with full explanation
Spring and Oracle Database I need example for Batch update process using oracle database and spring framework with full explanation
Oracle - Java Beginners
Oracle Hi sir, I installed oracle but the error occur on The java Runtime Environment was not found, at bin\jrew.exe. Hence the Oracle Universal Installer can not be run JRE version 1.1.7 Are the Java and Oracle related
Oracle Hi sir, I installed oracle but the error occur on The java Runtime Environment was not found, at bin\jrew.exe. Hence the Oracle Universal Installer can not be run JRE version 1.1.7 Are the Java and Oracle related
jdbc oracle connectivity problem
jdbc oracle connectivity problem Hi All, I am trying to connect my swing application to oracle DB . but class.forname is giving error. Please suggest me if there is some different way to connect swing application to oracle
jdbc oracle connectivity problem Hi All, I am trying to connect my swing application to oracle DB . but class.forname is giving error. Please suggest me if there is some different way to connect swing application to oracle
JAVA BEAN WITH ORACLE FORMS
JAVA BEAN WITH ORACLE FORMS Hi..I am doing my final year Project.. I need the ste-by-step procedure to integrate a bean with oracle forms? Please help me
JAVA BEAN WITH ORACLE FORMS Hi..I am doing my final year Project.. I need the ste-by-step procedure to integrate a bean with oracle forms? Please help me
tables in oracle 10g
tables in oracle 10g sir i have created a table in oracle 10g,i want to know where this table is stored and how can i move this table to another pc and insert values
tables in oracle 10g sir i have created a table in oracle 10g,i want to know where this table is stored and how can i move this table to another pc and insert values
JSP-Oracle connectivity
JSP-Oracle connectivity I have created a "dynamic web project" mainly with jsp files in eclipse and now, want to connect with oracle 10g, so how can I proceed for the database connection
JSP-Oracle connectivity I have created a "dynamic web project" mainly with jsp files in eclipse and now, want to connect with oracle 10g, so how can I proceed for the database connection
java to oracle code - JDBC
java to oracle code please suggest m calculate the database performance between scaled images and unscaled images in the database
java to oracle code please suggest m calculate the database performance between scaled images and unscaled images in the database
oracle connectivity problem with netbeans
oracle connectivity problem with netbeans sir I am using oracle window version +net bean6.8. jam trying to connect net bean to oracle. for this after adding new driver(ojdbc6.jar) in services tab I got connectivity with oracle
oracle connectivity problem with netbeans sir I am using oracle window version +net bean6.8. jam trying to connect net bean to oracle. for this after adding new driver(ojdbc6.jar) in services tab I got connectivity with oracle
java with Oracle Database
java with Oracle Database Hello I have been encountering a problem regarding creating a table with Oracle.When i am creating new table in the Database using Oracle , it is giving error saying an errror occured incursive sql
java with Oracle Database Hello I have been encountering a problem regarding creating a table with Oracle.When i am creating new table in the Database using Oracle , it is giving error saying an errror occured incursive sql
JDBC Oracle program
JDBC Oracle program Here is my code: import java.sql.*; public class Tyagi { public static void main (String args[])throws SQLException... = DriverManager.getConnection("jdbc:oracle:thin:@localhost:8080:oracle", "System", "System
JDBC Oracle program Here is my code: import java.sql.*; public class Tyagi { public static void main (String args[])throws SQLException... = DriverManager.getConnection("jdbc:oracle:thin:@localhost:8080:oracle", "System", "System
Oracle Database connectivity probem
Oracle Database connectivity probem hi Below is the code of oracle... also set the environment variable like that .;E:\oracle\ora81\jdbc\lib\classes12.zip;E:\oracle\ora81\jdbc\lib\ojdbc14.zip;C:\Program Files\Apache Software
Oracle Database connectivity probem hi Below is the code of oracle... also set the environment variable like that .;E:\oracle\ora81\jdbc\lib\classes12.zip;E:\oracle\ora81\jdbc\lib\ojdbc14.zip;C:\Program Files\Apache Software
Oracle Tutorials
Oracle Tutorials Oracle, which is also referred as Oracle database or Oracle...) managed by Oracle Corporation, an American multinational computer technology... of Oracle software was initially developed by Software Development Laboratories
Oracle Tutorials Oracle, which is also referred as Oracle database or Oracle...) managed by Oracle Corporation, an American multinational computer technology... of Oracle software was initially developed by Software Development Laboratories
Java Connection to Oracle database
Java Connection to Oracle database HI I am ubable to connnect jdbc to Oracle database.i had gone to control panel >>Administrative tool>>>Data source,in that forDNS name i typed Oracle and in TNS i culdn't
Java Connection to Oracle database HI I am ubable to connnect jdbc to Oracle database.i had gone to control panel >>Administrative tool>>>Data source,in that forDNS name i typed Oracle and in TNS i culdn't
Sql query from oracle
Sql query from oracle Please help me that I want to get the table names form the existing database who does it having eid coloumn plz provide me query in oracle database
Sql query from oracle Please help me that I want to get the table names form the existing database who does it having eid coloumn plz provide me query in oracle database
java and oracle - JSP-Servlet
java and oracle I am developing a small project where I need to upload the resume of the employee and store it into database and retrieve the same... data types in oracle database. And I need to write the code in servlets
java and oracle I am developing a small project where I need to upload the resume of the employee and store it into database and retrieve the same... data types in oracle database. And I need to write the code in servlets
instruction to install oracle 10g in linux....
instruction to install oracle 10g in linux.... how to install oracle 10g in linux
instruction to install oracle 10g in linux.... how to install oracle 10g in linux
Ads