AUTOTRACE STATISTICS

Scripts Diversos para o Oracle SQL*Plus. (Relacionado a ferramenta Oracle SQL*Plus, para questões de SQL, usar o forum SQL)
Responder
gokden
Rank: DBA Pleno
Rank: DBA Pleno
Mensagens: 264
Registrado em: Dom, 19 Ago 2007 8:18 pm
Localização: Ribeirão Preto - SP
Lucas de Souza

OCA Developer
Analista de sistemas

pessoal, eu tava meio que estudando como melhorar as consultas com hints
ai apareceu isso:

Selecionar tudo

Statistics
---------------------------------------------------
          0  recursive calls
          0  db block gets
       4598  consistent gets
          0  physical reads
          0  redo size
   25246689  bytes sent via SQL*Net to client
      44503  bytes received via SQL*Net from client
       4017  SQL*Net roundtrips to/from client
          2  sorts (memory)
          0  sorts (disk)
      60239  rows processed
até ai nada de errado, mais alguém sabe o que cada item desse significa ??
e tem mesmo alguma melhora usando hints ??

ps: o unico item qui eu intendo ali é o rows processed =D coitado do banco =x
Avatar do usuário
dr_gori
Moderador
Moderador
Mensagens: 5024
Registrado em: Seg, 03 Mai 2004 3:08 pm
Localização: Portland, OR USA
Contato:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Aí vai:
http://docs.oracle.com/cd/B10500_01/ser ... totrac.htm

recursive calls
Number of recursive calls generated at both the user and system level. Oracle maintains tables used for internal processing. When Oracle needs to make a change to these tables, it internally generates an internal SQL statement, which in turn generates a recursive call.

db block gets
Number of times a CURRENT block was requested.

consistent gets
Number of times a consistent read was requested for a block.

physical reads
Total number of data blocks read from disk. This number equals the value of "physical reads direct" plus all reads into buffer cache.

redo size
Total amount of redo generated in bytes.

bytes sent via SQL*Net to client
Total number of bytes sent to the client from the foreground processes.

bytes received via SQL*Net from client
Total number of bytes received from the client over Oracle Net.

SQL*Net roundtrips to/from client
Total number of Oracle Net messages sent to and received from the client.

sorts (memory)
Number of sort operations that were performed completely in memory and did not require any disk writes.

sorts (disk)
Number of sort operations that required at least one disk write.

rows processed
Number of rows processed during the operation.
Responder
  • Informação
  • Quem está online

    Usuários navegando neste fórum: Nenhum usuário registrado e 3 visitantes