Oracle Database - SQL*Net Statistics

Card Puncher Data Processing

About

The SQL*Net Statistics are a part of the autotrace statistics and you can find three parts on it :

How to minimize

You can't really influence the first statistics.

the data sent to you ?

  • by selecting only the columns that are relevant to you. No select * from.

the number of round-trips ?





Discover More
Card Puncher Data Processing
Oracle Database - bytes sent via SQL*Net to client

bytes sent via SQLNet to client is a which is a part of the autotrace statistics and means: How much the server send to you Just by selecting only the columns that are relevant to you.
Sql Developer Autotrace
Oracle Database - Autotrace

Autotrace is: a system variable of sql plus can also be found in SQL Developer AUTOTRACE provides you: an execution plan (such as explain plan) and some important regarding its actual execution....
Card Puncher Data Processing
Oracle Database - Optimizer Statistics

Optimizer statistic in Oracle You can collect exact or estimated statistics physical storage characteristics and data distribution in these schema objects by using the DBMS_STATS...
Card Puncher Data Processing
Oracle Database - Session Statistics (V$SESSTAT)

The second part of the autotrace output are a part of the session statistics. V recursive_calls : Number of SQL...



Share this page:
Follow us:
Task Runner