Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What should I be looking for if sql*net session is very slow

User_XYoci6Jun 4 2022

I have a goldengate classic replicat running remotely and updating a 12.1c Solaris. For all intentions and purpose, Goldengate is not that relevant as it is just an sql application especially a classic replicat. I have been getting 8000 ops per sec and is now down to 1.
I ran this query select sid,event, total_waits, time_waited*10 tw_ms, average_wait*10 aw_ms, max_wait*10 mw_msfrom v$session_eventwhere sid in (select sid from v$session where username = 'GG_USER');
There are 9 sessions altogether,the session that is doing the SQL shows
Total Waited Average Max
SID Waited for Waits for (ms) Wait (ms) Wait (ms)
---------- ------------------------------ -------- --------------- ----------- -----------
498 Disk file operations I/O 29 180.00 6.10 30.00
498 control file sequential read 67 40.00 .60 .00
498 latch: cache buffers chains 110 20.00 .20 .00
498 buffer busy waits 6 .00 .00 .00
498 db file sequential read 35,392 18,660.00 .50 10.00
498 db file scattered read 70,635 199,480.00 2.80 30.00
498 latch: shared pool 1 .00 .70 .00
498 SQL*Net message to client 129,181 570.00 .00 .00
498 SQL*Net message from client 129,180 1,140,410.00 8.80 10,020.00
498 SQL*Net break/reset to client 2 .00 .10 .00

                   Total     Waited   Average     Max  
SID Waited for            Waits    for (ms)  Wait (ms)  Wait (ms)  

---------- ------------------------------ -------- --------------- ----------- -----------
498 events in waitclass Other 1 .00 .00 .00
That seems like a crazy high value. Another session belonging to the same user shows
Total Waited Average Max
SID Waited for Waits for (ms) Wait (ms) Wait (ms)
---------- ------------------------------ -------- --------------- ----------- -----------
498 db file sequential read 35,392 18,660.00 .50 10.00
498 db file scattered read 70,635 199,480.00 2.80 30.00
498 latch: shared pool 1 .00 .70 .00
498 SQL*Net message to client 129,201 570.00 .00 .00
498 SQL*Net message from client 129,200 1,340,710.00 10.40 10,020.00
Yet another shows
Total Waited Average Max
SID Waited for Waits for (ms) Wait (ms) Wait (ms)
---------- ------------------------------ -------- --------------- ----------- -----------
15 SQL*Net message from client 124,233 163,353,360.00 1,314.90 53,840.00
15 SQL*Net break/reset to client 2 .00 .10 .00
Question is, does this point to a comms issue or not necessarily so? And should I get the network techs to run a tcpip trace?

Comments

Post Details

Added on Jun 4 2022
1 comment
304 views