SQLNet Other Waits SQLNet Waits Host Machine SQLPlus

SQL*Net & Other Waits

SQL*Net Waits Host Machine SQL*Plus OCI SQL*Forms SGA Log Library Buffer Cache Log Buffer etc Session Shadow Copyright 2006 Kyle Hailey #. 2

#. 4 SQL*Net more data from client Ø # 6 Top Wait Ø Client sends information that spans packets Ø Shadow recieves first packet Ø Responds Ø Waits for more data from client Waiting Session Shadow Copyright 2006 Kyle Hailey

#. 5 SQL*Net more data to client Ø Shadow is sending data to client that spans packets Ø Sends first packet then waits for shadow to respond, so it can send more Waiting Session Shadow Copyright 2006 Kyle Hailey

#. 6 SQL*Net more data from dblink Ø #21 Waiting Session dblink Shadow Copyright 2006 Kyle Hailey

#. 7 SQL*Net break/reset to client Ø #14 Ø Error in sql statement Ø Control C Ø Usually highlights and error in application Waiting Error Session Shadow Copyright 2006 Kyle Hailey

#. 8 SQL*Net break/reset to dblink Ø #32 Ø Error in sql statement Ø Control C Ø Usually highlights and error in application Waiting error Session dblink Shadow Copyright 2006 Kyle Hailey

#. 9 UNDO/RBS WAITS Copyright 2006 Kyle Hailey

#. 10 Wait for a undo record Ø #34 Ø First in 9 i Copyright 2006 Kyle Hailey

#. 11 undo segment extension Ø #36 Ø Waiting for a RBS to extend Ø RBS too small ? Copyright 2006 Kyle Hailey

#. 12 undo segment tx slot Ø #37 Ø Waiting for the RBS Header TX slot Ø Not enough RBS? Copyright 2006 Kyle Hailey

#. 13 Other Waits Copyright 2006 Kyle Hailey

#. 15 io done Ø #15 Ø IO slave processes (oracle. IXXX) Ø Non-Idle: Wait for a I/O completion Ø Idle : Waiting for work Copyright 2006 Kyle Hailey

#. 16 unread message Ø #28 Ø 8. 1. 6 & 8. 1. 7 only Copyright 2006 Kyle Hailey

#. 17 process startup Ø #27 Copyright 2006 Kyle Hailey

#. 18 pipe put Ø #30 Copyright 2006 Kyle Hailey

#. 19 summary Ø sort segment request : SMON occupied? Copyright 2006 Kyle Hailey