1 2 Previous Next 15 Replies Latest reply: May 5, 2013 5:16 PM by 1005890 RSS

    sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs

    507581
      sqlplus select hangs for one table only

      sqlplus client 11.1.0.6.0 32bit (on windowas 2003 32bit)

      can not connect to
      oracle 11.2.0.1.0
      os : linux centos


      table has just 36 rows with 58 coulmns

      getting the same issue with toad it also hangs
        • 1. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
          Osama_Mustafa
          Is there any error ?
          Did you check alert log ?

          Also Did you try to enable trace ?
          • 2. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
            507581
            Thanks for the reply.
            I will trace and paste the tkprof and alert errors tomorrow.
            • 3. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
              EdStevens
              Aj wrote:
              sqlplus select hangs for one table only

              sqlplus client 11.1.0.6.0 32bit (on windowas 2003 32bit)

              can not connect to
              oracle 11.2.0.1.0
              os : linux centos


              table has just 36 rows with 58 coulmns

              getting the same issue with toad it also hangs
              you say you cannot connect, but you also say the select hangs. If you can't connect, you can't issue a SELECT. Which problem are we dealing with?
              • 4. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
                507581
                Correction
                ======


                sqlplus select hangs for one table only
                sqlplus client 11.1.0.6.0 32bit (on windows 2003 32bit)

                can not select data from some tables
                its connects fine . get data from other tables.
                getting problem with this table only :

                oracle 11.2.0.1.0
                os : linux centos
                table has just 36 rows with 58 coulmns
                getting the same issue with toad it also hangs

                you say you cannot connect, but you also say the select hangs. If you can't connect, you can't issue a SELECT. Which problem are we dealing with?
                this particular tables select hangs with toad / sqlplus.

                Please suggest.

                Do I need to apply some patch.
                Is it not compatible with oracle 11.2.0.1.0@ linux centos

                Thanks for help
                • 5. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
                  EdStevens
                  Aj wrote:
                  Correction
                  ======


                  sqlplus select hangs for one table only
                  sqlplus client 11.1.0.6.0 32bit (on windows 2003 32bit)

                  can not select data from some tables
                  its connects fine . get data from other tables.
                  getting problem with this table only :

                  oracle 11.2.0.1.0
                  os : linux centos
                  table has just 36 rows with 58 coulmns
                  getting the same issue with toad it also hangs

                  you say you cannot connect, but you also say the select hangs. If you can't connect, you can't issue a SELECT. Which problem are we dealing with?
                  this particular tables select hangs with toad / sqlplus.

                  Please suggest.

                  Do I need to apply some patch.
                  Is it not compatible with oracle 11.2.0.1.0@ linux centos

                  Thanks for help
                  Any questions about compatibility with a particular OS are easily answered by checking the "software requirements" section of the relevant Installation Guide. You mention oracle 11.1 in the subject, but 11.2 in this message, And you mention Windows in the subject, but Centos in this message, so it is still not clear what you are doing with what. But just to cover both bases ...

                  No, I started to give you the link directly, but this something you need to learn to do yourself. So ..
                  1) go to tahiti.oracle.com
                  2) locate the link for whatever version of Oracle you are dealing with. That link will take you to the complete documentation set for the selected product and version.
                  3) Once at the version-specific documentation, locate the Installation Guide for your class of operating systems (Linux, Windows, etc.)
                  4) Once you have opened the correct Installation Guide, read the section on Software Requirements. Pay close attention to the "Operating System Requirements". Do you see your specific operating system and version listed there?

                  That said (and you really must do the above), I'd not expect running on an unsupported OS to cause a problem with a select on one specific table and no others. But you've given us nothing else. How about starting by showing us the actual query that is 'hanging'. PLEASE copy and paste it and PLEASE enclose it in the \
                   tags.
                  
                  Edited by: EdStevens on Feb 25, 2013 1:24 PM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
                  • 6. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
                    507581
                    server
                    ===
                    oracle *11.2.0.1.0 64 bit*
                    os : linux centos

                    no issue at server

                    client
                    ===
                    issue here

                    sqlplus client 11.1.0.6.0 32bit --hangs for this table
                    os windows 2003 32bit
                    toad 9.5 --hangs for this table
                    toad 9.0 --hangs for this table



                    sqlplus select hangs for one table only

                    table has just 36 rows with 58 coulmns

                    can not select data from some tables
                    its connects fine . get data from other tables.



                    Thanks for all information and guidance
                    • 7. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
                      sb92075
                      How do I ask a question on the forums?
                      SQL and PL/SQL FAQ


                      is COPY & PASTE broken for you?
                      • 8. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
                        EdStevens
                        Aj wrote:
                        server
                        ===
                        oracle *11.2.0.1.0 64 bit*
                        os : linux centos

                        no issue at server
                        Well, other than the fact that centos is not a supported OS -- Oracle does NOT certify their products to run on Centos.

                        Can you connect with sqlplus on the server and issue the SELECT? What happens?

                        client
                        ===
                        issue here

                        sqlplus client 11.1.0.6.0 32bit --hangs for this table
                        os windows 2003 32bit
                        toad 9.5 --hangs for this table
                        toad 9.0 --hangs for this table



                        sqlplus select hangs for one table only

                        table has just 36 rows with 58 coulmns

                        can not select data from some tables
                        its connects fine . get data from other tables.



                        Thanks for all information and guidance
                        Please use sqlplus to connect to the databse from the specified client machine. Issue a DESCRIBE on the problem table. Issue a 'SELECT SYSDATE FROM DUAL;' . Issue a SELECT against the problem table. Copy the entire session and paste it into your next post, surrounded by the \
                         tags.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                        • 9. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
                          507581
                          Hi,

                          I am seeing many spid for one session


                          I have connected to oracle (linux) from a sqlplus (windows).

                          from this idle session I get sid and serial#;

                          now I logged in oracle server (linux) and see that there are 1 process to the one session ( in v$session)


                          Is something wrong in this:
                          STATUS          SID        PID    SERIAL#     AUDSID USERNAME                       OSUSER                         MACHINE                                                          TERMINAL                PROCESS                  SPID                     PROGRAM                                      EVENT
                          -------- ---------- ---------- ---------- ---------- ------------------------------ ------------------------------ ----------------------------------- ------------------------------ ------------------------ ------------------------ ------------------------------------------------ ----------------------------------------------------------------
                          INACTIVE         81         85      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AHOA                176:2144                 7787                 sqlplus.exe                               SQL*Net message from client
                          
                          1 row selected.
                          Please use sqlplus to connect to the databse from the specified client machine. Issue a DESCRIBE on the problem table. Issue a 'SELECT SYSDATE FROM DUAL;' . Issue a SELECT against the problem table.
                          sysdate from dual is coming fine.

                          when i did desc schema.problem_table;
                          its hangs......


                          I have logged in server centos linux

                          INACTIVE         81         47      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 32369                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         48      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 32373                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         49      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 29887                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         50      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 32383                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         51      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 32388                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         52      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 32392                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         53      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 32401                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         54      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 32408                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         55      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 32413                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         56      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 32417                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         57      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 14879                sqlplus.exe                               SQL*Net message from client
                          
                          STATUS          SID        PID    SERIAL#     AUDSID USERNAME                       OSUSER                         MACHINE      TERMINAL                        PROCESS                  SPID                     PROGRAM                                      EVENT
                          -------- ---------- ---------- ---------- ---------- ------------------------------ ------------------------------ ---------------------------------------------------------------- ------------------------------ ------------------------ ------------------------ ------------------------------------------------ ----------------------------------------------------------------
                          INACTIVE         81         98      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 14669                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81         99      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 14767                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81        100      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 14863                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81        101      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 16087                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81        102      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 14933                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81        103      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 16704                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81        104      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 14908                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81        105      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 14914                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81        106      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 16823                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81        107      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 14944                sqlplus.exe                               SQL*Net message from client
                          INACTIVE         81        108      40127     290541 SYSTEM                         Administrator                  AAHOA                                               AAHOA                176:2144                 16825                sqlplus.exe                               SQL*Net message from client
                          
                          108 rows selected
                          Thanks

                          Edited by: Aj on Feb 26, 2013 9:07 PM
                          • 10. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
                            Osama_Mustafa
                            Why you duplicate your thread, you asked This question before and open two threads for the same question please mark the new as answered and don't duplicate your thread.
                            • 12. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
                              Osama_Mustafa
                              Check tom reply about inactive session
                              http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:914029001168
                              • 13. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
                                Dave Rabone
                                Does .../rdbms/admin/utllockt.sql

                                tell you anything?
                                • 14. Re: sqlplus 11.1.0.6.0 32bit (on windowas 2003 32bit) can not select it hangs
                                  507581
                                  Table created.
                                  0 rows created.
                                  Commit complete.
                                  Table dropped.
                                  0 rows created.
                                  Commit complete.
                                  no rows selected
                                  Table dropped.
                                  It does not show any locks

                                  I have enable support trace on listener
                                  I have run trcasst on the trace file

                                  output which I do not understand and need help to get information out of it

                                  I am getting this issue is on windows 2003 32bit having oracle 11.1.0.6.0 is installed

                                  Other windows 2003 32bit having oracle 11.1.0.6.0 (with same configuration) I am able to connect to oraclee 11gr2 11.2.0.1.0 64 bit on linux. This issue is specific to one machine only.

                                  one windows machine work other dont

                                  How to trouble shoot this
                                  i tried to trace the session

                                  but session hangs on desribing the table and on server no trace file generated and its remains inactive.


                                  Fatal NI connect error 12170.
                                  
                                    VERSION INFORMATION:
                                  TNS for Linux: Version 11.2.0.1.0 - Production
                                  Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
                                  TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
                                    Time: 04-MAR-2013 00:57:26
                                    Tracing not turned on.
                                    Tns error struct:
                                      ns main err code: 12535
                                  
                                  TNS-12535: TNS:operation timed out
                                      ns secondary err code: 12560
                                      nt main err code: 505
                                  
                                  TNS-00505: Operation timed out
                                      nt secondary err code: 110
                                      nt OS err code: 0
                                    Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=1558))
                                  trcasst
                                  <--- Received 242 bytes - Connect packet  timestamp=013-03-04 18:11:25.383431
                                  Current NS version number is: 314.
                                  Lowest NS version number can accommodate is: 300.
                                  Global options for the connection: 
                                       Can receive attention
                                       No attention processing
                                       Don't care
                                       Maximum SDU size: 8192
                                       Maximum TDU size: 32767
                                       NT protocol characteristics:
                                            Test for more data
                                            Test operation
                                            Full duplex I/O
                                            Urgent data support
                                            Generate SIGURG signal
                                            Generate SIGPIPE signal
                                            Generate SIGIO signal
                                            Handoff connection to another
                                       Line turnaround value: 0
                                       Connect data length: 184
                                       Connect data offset: 58
                                       Connect data maximum size: 2048
                                            Native Services wanted
                                            NAU doing O3LOGON - DH key foldedin
                                            Native Services wanted
                                            NAU doing O3LOGON - DH key foldedin
                                      (DESCRIPTION=(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=moddb)(CID=
                                      (PROGRAM=oracle)(HOST=localhost.localdomain)(USER=oracle)))(ADDRESS=(P
                                      ROTOCOL=TCP)(HOST=x.x.x.x)(PORT=1521)))
                                  
                                  ---> Send 8 bytes - Resend packet  timestamp=013-03-04 18:11:25.433727
                                  
                                  <--- Received 606 bytes - Data packet  timestamp=013-03-04 18:11:25.977941
                                  
                                  ---> Send 306 bytes - Data packet  timestamp=013-03-04 18:11:25.981375
                                  
                                  <--- Received 172 bytes - Connect packet  timestamp=013-03-04 18:11:28.465221
                                  Current NS version number is: 308.
                                  Lowest NS version number can accommodate is: 300.
                                       Maximum SDU size: 2048
                                       Maximum TDU size: 32767
                                       NT protocol characteristics:
                                            Test for more data
                                            Spawner is running
                                            Hang on to Listener connection
                                            Test operation
                                            Full duplex I/O
                                            Urgent data support
                                            Generate SIGURG signal
                                            Handoff connection to another
                                       Line turnaround value: 0
                                       Connect data length: 138
                                       Connect data offset: 34
                                       Connect data maximum size: 0
                                            Native Services wanted
                                            Native Services wanted
                                      (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=moddb)(CID=(PROGRAM=)(HOST=__
                                      jdbc__)(USER=)))(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
                                  
                                  ---> Send 8 bytes - Resend packet  timestamp=013-03-04 18:11:28.514796
                                  
                                  <--- Received 574 bytes - Data packet  timestamp=013-03-04 18:11:28.984241
                                  
                                  ---> Send 306 bytes - Data packet  timestamp=013-03-04 18:11:28.987703
                                  
                                  <--- Received 172 bytes - Connect packet  timestamp=013-03-04 18:11:33.315852
                                  Current NS version number is: 308.
                                  Lowest NS version number can accommodate is: 300.
                                       Maximum SDU size: 2048
                                       Maximum TDU size: 32767
                                       NT protocol characteristics:
                                            Test for more data
                                            Spawner is running
                                            Hang on to Listener connection
                                            Test operation
                                            Full duplex I/O
                                            Urgent data support
                                            Generate SIGURG signal
                                            Handoff connection to another
                                       Line turnaround value: 0
                                       Connect data length: 138
                                       Connect data offset: 34
                                       Connect data maximum size: 0
                                            Native Services wanted
                                            Native Services wanted
                                      (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=moddb)(CID=(PROGRAM=)(HOST=__
                                      jdbc__)(USER=)))(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
                                  
                                  ---> Send 8 bytes - Resend packet  timestamp=013-03-04 18:11:33.367504
                                  
                                  <--- Received 574 bytes - Data packet  timestamp=013-03-04 18:11:46.987076
                                  
                                  ---> Send 306 bytes - Data packet  timestamp=013-03-04 18:11:46.990562
                                  
                                  <--- Received 606 bytes - Data packet  timestamp=013-03-04 18:11:52.992999
                                  
                                  ---> Send 306 bytes - Data packet  timestamp=013-03-04 18:11:52.996629
                                  
                                  <--- Received 606 bytes - Data packet  timestamp=013-03-04 18:12:26.001644
                                  
                                  ---> Send 306 bytes - Data packet  timestamp=013-03-04 18:12:26.005209
                                  
                                  <--- Received 172 bytes - Connect packet  timestamp=013-03-04 18:12:38.480857
                                  Current NS version number is: 308.
                                  Lowest NS version number can accommodate is: 300.
                                       Maximum SDU size: 2048
                                       Maximum TDU size: 32767
                                       NT protocol characteristics:
                                            Test for more data
                                            Spawner is running
                                            Hang on to Listener connection
                                            Test operation
                                            Full duplex I/O
                                            Urgent data support
                                            Generate SIGURG signal
                                            Handoff connection to another
                                       Line turnaround value: 0
                                       Connect data length: 138
                                       Connect data offset: 34
                                       Connect data maximum size: 0
                                            Native Services wanted
                                            Native Services wanted
                                      (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=moddb)(CID=(PROGRAM=)(HOST=__
                                      jdbc__)(USER=)))(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
                                  
                                  ---> Send 8 bytes - Resend packet  timestamp=013-03-04 18:12:38.530679
                                  
                                  <--- Received 172 bytes - Connect packet  timestamp=013-03-04 18:12:56.146698
                                  Current NS version number is: 308.
                                  Lowest NS version number can accommodate is: 300.
                                       Maximum SDU size: 2048
                                       Maximum TDU size: 32767
                                       NT protocol characteristics:
                                            Test for more data
                                            Spawner is running
                                            Hang on to Listener connection
                                            Test operation
                                            Full duplex I/O
                                            Urgent data support
                                            Generate SIGURG signal
                                            Handoff connection to another
                                       Line turnaround value: 0
                                       Connect data length: 138
                                       Connect data offset: 34
                                       Connect data maximum size: 0
                                            Native Services wanted
                                            Native Services wanted
                                      (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=moddb)(CID=(PROGRAM=)(HOST=__
                                      jdbc__)(USER=)))(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
                                  
                                  ---> Send 8 bytes - Resend packet  timestamp=013-03-04 18:12:56.196038
                                  
                                  <--- Received 172 bytes - Connect packet  timestamp=013-03-04 18:13:03.005880
                                  Current NS version number is: 308.
                                  Lowest NS version number can accommodate is: 300.
                                       Maximum SDU size: 2048
                                       Maximum TDU size: 32767
                                       NT protocol characteristics:
                                            Test for more data
                                            Spawner is running
                                            Hang on to Listener connection
                                            Test operation
                                            Full duplex I/O
                                            Urgent data support
                                            Generate SIGURG signal
                                            Handoff connection to another
                                       Line turnaround value: 0
                                       Connect data length: 138
                                       Connect data offset: 34
                                       Connect data maximum size: 0
                                            Native Services wanted
                                            Native Services wanted
                                      (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=moddb)(CID=(PROGRAM=)(HOST=__
                                      jdbc__)(USER=)))(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
                                  
                                  ---> Send 8 bytes - Resend packet  timestamp=013-03-04 18:13:03.058374
                                  
                                  <--- Received 172 bytes - Connect packet  timestamp=013-03-04 18:13:30.505227
                                  Current NS version number is: 308.
                                  Lowest NS version number can accommodate is: 300.
                                       Maximum SDU size: 2048
                                       Maximum TDU size: 32767
                                       NT protocol characteristics:
                                            Test for more data
                                            Spawner is running
                                            Hang on to Listener connection
                                            Test operation
                                            Full duplex I/O
                                            Urgent data support
                                            Generate SIGURG signal
                                            Handoff connection to another
                                       Line turnaround value: 0
                                       Connect data length: 138
                                       Connect data offset: 34
                                       Connect data maximum size: 0
                                            Native Services wanted
                                            Native Services wanted
                                      (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=moddb)(CID=(PROGRAM=)(HOST=__
                                      jdbc__)(USER=)))(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
                                  
                                  ---> Send 8 bytes - Resend packet  timestamp=013-03-04 18:13:30.554600
                                  
                                  
                                  <--- Received 242 bytes - Connect packet  timestamp=013-03-04 18:36:26.013277
                                  Current NS version number is: 314.
                                  Lowest NS version number can accommodate is: 300.
                                  Global options for the connection: 
                                       Can receive attention
                                       No attention processing
                                       Don't care
                                       Maximum SDU size: 8192
                                       Maximum TDU size: 32767
                                       NT protocol characteristics:
                                            Test for more data
                                            Test operation
                                            Full duplex I/O
                                            Urgent data support
                                            Generate SIGURG signal
                                            Generate SIGPIPE signal
                                            Generate SIGIO signal
                                            Handoff connection to another
                                       Line turnaround value: 0
                                       Connect data length: 184
                                       Connect data offset: 58
                                       Connect data maximum size: 2048
                                            Native Services wanted
                                            NAU doing O3LOGON - DH key foldedin
                                            Native Services wanted
                                            NAU doing O3LOGON - DH key foldedin
                                      (DESCRIPTION=(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=moddb)(CID=
                                      (PROGRAM=oracle)(HOST=localhost.localdomain)(USER=oracle)))(ADDRESS=(P
                                      ROTOCOL=TCP)(HOST=x.x.x.x)(PORT=1521)))
                                  
                                  ---> Send 8 bytes - Resend packet  timestamp=013-03-04 18:36:26.045169
                                  
                                  <--- Received 606 bytes - Data packet  timestamp=013-03-04 18:36:26.371515
                                  
                                  ---> Send 306 bytes - Data packet  timestamp=013-03-04 18:36:26.374891
                                  
                                  <--- Received 574 bytes - Data packet  timestamp=013-03-04 18:36:29.375683
                                  
                                  ---> Send 306 bytes - Data packet  timestamp=013-03-04 18:36:29.378977
                                  
                                  <--- Received 172 bytes - Connect packet  timestamp=013-03-04 18:36:32.541821
                                  Current NS version number is: 308.
                                  Lowest NS version number can accommodate is: 300.
                                       Maximum SDU size: 2048
                                       Maximum TDU size: 32767
                                       NT protocol characteristics:
                                            Test for more data
                                            Spawner is running
                                            Hang on to Listener connection
                                            Test operation
                                            Full duplex I/O
                                            Urgent data support
                                            Generate SIGURG signal
                                            Handoff connection to another
                                       Line turnaround value: 0
                                       Connect data length: 138
                                       Connect data offset: 34
                                       Connect data maximum size: 0
                                            Native Services wanted
                                            Native Services wanted
                                      (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=moddb)(CID=(PROGRAM=)(HOST=__
                                      jdbc__)(USER=)))(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
                                  
                                  ---> Send 8 bytes - Resend packet  timestamp=013-03-04 18:36:32.590810
                                  
                                  
                                  
                                  ----------------------
                                  Trace File Statistics:
                                  ----------------------
                                  Start Timestamp : 013-03-01 11:40:08.536977
                                  End Timestamp   : 013-03-04 18:39:01.522213
                                  Total number of Sessions: 22255
                                  
                                  DATABASE:
                                    Operation Count:    0 OPENS,     0 PARSES,     0 EXECUTES,     0 FETCHES
                                  
                                  
                                  ORACLE NET SERVICES:
                                    Total Calls  :     27675 sent,      27732 received,           0 oci
                                    Total Bytes  :   1867283 sent,    7200264 received
                                      Average Bytes:        67 sent per packet,        259 received per packet
                                      Maximum Bytes:      2433 sent,       2506 received
                                  
                                    Grand Total Packets:  27675  sent,   27732 received
                                  
                                  
                                      *************************************************************************
                                      *                    Trace Assistant has completed                      *
                                      *************************************************************************
                                  1 2 Previous Next