| pls help- How to get various network information from server side [message #119630] |
Fri, 13 May 2005 10:13  |
Nasser22
Messages: 15
Registered: April 2005
|
Junior Member |
|
|
Hi
Im doing a final year thesis regarding application - application communication in Oracle. What i want to know is how to view or collect information from the server such as:
- the source IP address, or a reference to it (a registered application user or application server)
- destination IP address or a reference to it (ie - a registered application user or an application server)
- the Transport Layer protocol ( eg transmission Control Protocl, TCP, or User Datagram Protocol, UDP)
- type of application traffic being sent on that flow (eg- signalling or data)
- traffic characteristics
- minimum bandtwidth requirements
I would greatly appreciate if someone can post some links where i can find info regarding this. I hope some experts out there can direct me plz
Thankyou
|
|
|
|
|
|
| Re: pls help- How to get various network information from server side [message #119751 is a reply to message #119630] |
Sat, 14 May 2005 19:58  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Hi,
This may or may not help:
Most installations use TCP as preferred protocol (UDP wouldn't work as it is connectionless). However, the TNS (Transparent Network Substrate) layer can support multiple protocols simultaneously (like TCP, Named Pipes, IPC, etc.).
Oracle uses server side listeners to accept client connections. The Protocol, IP and Port to listen on is specified in the server's LISTENER.ORA file.
Clients normally read the TNSNAMES.ORA file (or Oracle Names Server, LDAP server, or whatever) to obtain the Protocol, IP and Port to connect to on the server to establish a connection.
You can look at the SQL*Net statistics of a running instance by examining the V$SYSSTAT and V$SESSTAT views. Here is an example:
SQL> SELECT * FROM v$SYSSTAT WHERE name LIKE '%SQL*Net%';
STATISTIC# NAME CLASS VALUE
---------- --------------------------------------------- ---------- ----------
304 bytes sent via SQL*Net to client 1 27410
305 bytes received via SQL*Net from client 1 3991
306 SQL*Net roundtrips to/from client 1 46
307 bytes sent via SQL*Net to dblink 1 0
308 bytes received via SQL*Net from dblink 1 0
309 SQL*Net roundtrips to/from dblink 1 0
6 rows selected.
It may also help if you scan through the Net Services Administrator's and Reference Guides.
Best regards.
Frank
|
|
|
|
| Re: pls help- How to get various network information from server side [message #119753 is a reply to message #119630] |
Sat, 14 May 2005 22:45 |
Nasser22
Messages: 15
Registered: April 2005
|
Junior Member |
|
|
You see the my main analysis is to classify various packets into order of priority. So hence if i can get info from the server, i can base my decisions on the network info i see....
Ive scanned through the various references guide you have mentioned.... in order to get various information I have to play around or edit parameters or command functions right?
Which .ora file would i be interested in for server side? LISTENER.ORA or TSNAMES.ora or perhaps all files?
And also How do i get to view this 'info', do i just access the .ora file or what? Eg- some command like SHOW PROFILE, OR STAT??
Thankyou for your time
Regards
Nasser
|
|
|
|
| Re: pls help- How to get various network information from server side [message #119774 is a reply to message #119753] |
Sun, 15 May 2005 09:31 |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Hi,
The internal workings of SQL*Net is one of those well-kept Oracle secrets. Your best bet is to configure client-server connectivity and use the "snoop" command to inspect the interchange and contents of network packets.
> Which .ora file would i be interested in for server side? LISTENER.ORA or TSNAMES.ora or perhaps all files?
Possibly both - in case you want to establish a connection from the server to the database.
> And also How do i get to view this 'info', do i just access the .ora file or what? Eg- some command like SHOW PROFILE, OR STAT??
You can use any OS editor to view the *.ora config files. The SELECT-statements can be executed from sqlplus.
Best regards.
Frank
|
|
|
|
|
|
|
|
|
|
| Re: pls help- How to get various network information from server side [message #119809 is a reply to message #119630] |
Mon, 16 May 2005 00:06 |
Nasser22
Messages: 15
Registered: April 2005
|
Junior Member |
|
|
Im getting a bit confused here, Let me clear a few things up!
In order to get info do i just look at the .ora files?
Okay now ive read the net references and all i see is a bunch of parameters there.....
I dont really understand which files im interested in (see my first post) can u provide a basic sumamry of wat each file provides?
And you mentioned SQL*Net statistics? Where do i find this, which file?
Plz reply asap... thankyou
|
|
|
|
| Re: pls help- How to get various network information from server side [message #119814 is a reply to message #119809] |
Mon, 16 May 2005 02:10 |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
I'm afraid you will have to do a bit of studying yourself:
The Internet is full of info about "snoop". Google and you will find it.
Also, you need to read both the Net Services Reference and the Administrators Guides. After that, play around with it and study the config files. I'm sure you will quickly figure it out yourself. Again, there is lots of info on the Net. Don't ask if you haven't tried to find it yourself.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
