Ishii.
kidrodrigoConfigurei o arquivo sqlnet.ora para criar o trace do client
TRACE_UNIQUE_CLIENT = ON
TRACE_LEVEL_CLIENT = 16
TRACE_DIRECTORY_CLIENT = C:
TRACE_FILE_CLIENT = SQLNetTrace
TRACE_TIMESTAMP_CLIENT = ON
abaixo coloqui um segmento do trace
(1852) [05-SEP-2011 15:07:59:242] nspsend: 49 4E 53 45 52 54 20 49 |INSERT.I|
(1852) [05-SEP-2011 15:07:59:242] nspsend: 4E 54 4F 20 47 45 4E 45 |NTO.GENE|
(1852) [05-SEP-2011 15:07:59:242] nspsend: 52 49 43 4F 2E 43 4F 4E |RICO.CON|
(1852) [05-SEP-2011 15:07:59:242] nspsend: 45 58 41 4F 5F 4F 52 41 |EXAO_ORA|
(1852) [05-SEP-2011 15:07:59:242] nspsend: 43 4C 45 20 28 44 54 41 |CLE.(DTA|
(1852) [05-SEP-2011 15:07:59:242] nspsend: 5F 48 4F 52 5F 43 4F 4E |_HOR_CON|
(1852) [05-SEP-2011 15:07:59:242] nspsend: 45 58 41 4F 20 20 20 20 |EXAO….|
Nele tem inserts, selects etc,. Depois executo o tkprod para o trace
C:oraclebin>tkprof C:sqlnettrace_1852_1.trc c:out.txt
TKPROF: Release 10.2.0.3.0 – Production on Mon Sep 5 15:10:38 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
C:oraclebin>
O problema é que tem selects, inserts etc., para o resultado do tkprod não mostra:
TKPROF: Release 10.2.0.3.0 – Production on Mon Sep 5 15:10:38 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Trace file: C:sqlnettrace_1852_1.trc
Sort options: default
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: C:sqlnettrace_1852_1.trc
Trace file compatibility: 10.01.00
Sort options: default
0 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
17111 lines in trace file.
0 elapsed seconds in trace file.
Qual o problema sera?
IshiiOlá,
Realmente é estranho, mas tente com as seguintes opções:
tkprof explain=/ sys=no sort=exeela
Com isso o tkprof vai fazer a análise com o usuário do explain, sem as tabelas do SYS (a não ser que você queira – útil no caso de sequences!!) e ordenado pelo tempo de execução (do maior para o menor)
[]s Ishii
ps: na dúvida digite apenas o comando tkprof que o help demonstra mais opções…