SQLNet Other Waits SQLNet Waits Host Machine SQLPlus

  • Slides: 17
Download presentation
SQL*Net & Other Waits

SQL*Net & Other Waits

SQL*Net Waits Host Machine SQL*Plus OCI SQL*Forms SGA Log Library Buffer Cache Log Buffer

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

#. 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

#. 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

#. 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 Ø

#. 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 Ø

#. 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

#. 9 UNDO/RBS WAITS Copyright 2006 Kyle Hailey

#. 10 Wait for a undo record Ø #34 Ø First in 9 i

#. 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

#. 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

#. 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

#. 13 Other Waits Copyright 2006 Kyle Hailey

#. 15 io done Ø #15 Ø IO slave processes (oracle. IXXX) Ø Non-Idle:

#. 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

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

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

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

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

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

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

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

Sysdba sqlplus as sysdba SQLPLUS NOLOG SQLPLUS NOLOGSysdba sqlplus as sysdba SQLPLUS NOLOG SQLPLUS NOLOG
ORACLE 1 SQLPlus Environment What is SQLPlus nORACLE 1 SQLPlus Environment What is SQLPlus n
SQLPlus Oracle ISQL ISQLOracle Contents ISQL Oracle SQLPlusSQLPlus Oracle ISQL ISQLOracle Contents ISQL Oracle SQLPlus
SQLPLUS SQLPLUS n l exit quit n lSQLPLUS SQLPLUS n l exit quit n l
SQLPlus Oracle SQLPlus u An Oracle commandline utilitySQLPlus Oracle SQLPlus u An Oracle commandline utility
http www oracle comtechnetworkindexesdownloadsindex htmldatabase SQLPLUS sqlplus nologhttp www oracle comtechnetworkindexesdownloadsindex htmldatabase SQLPLUS sqlplus nolog
Basic SQLPlus edit and execute commands SQLPlus bufferBasic SQLPlus edit and execute commands SQLPlus buffer
Shared Pool Waits 2 Shared Pool Waits LibraryShared Pool Waits 2 Shared Pool Waits Library
Buffer Cache Waits 2 Buffer Cache Waits HotBuffer Cache Waits 2 Buffer Cache Waits Hot
Enqueue Waits Locks Wait Tree Locks Waits BufferEnqueue Waits Locks Wait Tree Locks Waits Buffer
IO Waits Kyle Hailey Kylehaileyhotmail com 2 WaitsIO Waits Kyle Hailey Kylehaileyhotmail com 2 Waits
Tom Waits Thomas Alan Waits is an AmericanTom Waits Thomas Alan Waits is an American
HOST DEFENSE Host Defenses Host defenses that protectHOST DEFENSE Host Defenses Host defenses that protect
Host Parasite Relationship Host Parasite Relationship Human hostHost Parasite Relationship Host Parasite Relationship Human host
SQLNET Wizards Course OSI Overview Matching the modelSQLNET Wizards Course OSI Overview Matching the model
Listener Client Server Listener tnsnames ora sqlnet oraListener Client Server Listener tnsnames ora sqlnet ora