1. Enable tracing for the appropriate period of time needed to capture enough data.
LSNRCTL> set trc_level ADMIN
2. Disable tracing.
LSNRCTL> set trc_level OFF
3. View trace file (optional) - the trace file can be viewed although it is very cryptic. The file can be located by using the show command along with trc_directory and again with trc_file. The following is an example of the raw trace file.
LSNRCTL> set trc_level ADMIN
Con este comando activamos el trace al listener, este genera un archivo en la ruta que le demos al
parametro trc_file
En este caso lo dejaermos por default:
Por otra parte Oracle posee un herramienta para hacer debugg del trace al igual que tkprof, este es trcasst.
-bash-4.1$ trcasst svr_8875.trc
Trace File Statistics:
----------------------
Start Timestamp : 16-JUN-2016 12:02:25:596
End Timestamp : 16-JUN-2016 13:30:09:296
Total number of Sessions: 1
DATABASE:
Operation Count: 9 OPENS, 129 PARSES, 131 EXECUTES, 46 FETCHES
Parse Counts:
72 PL/SQL, 47 SELECT, 0 INSERT, 0 UPDATE, 0 DELETE,
0 LOCK, 0 TRANSACT, 2 DEFINE, 0 SECURE, 8 OTHER
Execute counts with SQL data:
72 PL/SQL, 44 SELECT, 0 INSERT, 0 UPDATE, 0 DELETE,
0 LOCK, 0 TRANSACT, 2 DEFINE, 0 SECURE, 0 OTHER
Operation Ratio: 14.333333333333334 PARSES per OPEN, 1.0155038759689923 EXECUTES per PARSE
Packet Ratio: 1.3129770992366412 packets sent per operation
Currently opened Cursors: 0
Maximum opened Cursors : 9
ORACLE NET SERVICES:
Total Calls : 172 sent, 172 received, 275 oci
Total Bytes : 52407 sent, 93168 received
Average Bytes: 304 sent per packet, 541 received per packet
Maximum Bytes: 2969 sent, 5297 received
Grand Total Packets: 172 sent, 172 received
Trace File Statistics:
----------------------
Start Timestamp : 16-JUN-2016 12:02:25:596
End Timestamp : 16-JUN-2016 13:30:09:296
Total number of Sessions: 1
DATABASE:
Operation Count: 9 OPENS, 129 PARSES, 131 EXECUTES, 46 FETCHES
Parse Counts:
72 PL/SQL, 47 SELECT, 0 INSERT, 0 UPDATE, 0 DELETE,
0 LOCK, 0 TRANSACT, 2 DEFINE, 0 SECURE, 8 OTHER
Execute counts with SQL data:
72 PL/SQL, 44 SELECT, 0 INSERT, 0 UPDATE, 0 DELETE,
0 LOCK, 0 TRANSACT, 2 DEFINE, 0 SECURE, 0 OTHER
Operation Ratio: 14.333333333333334 PARSES per OPEN, 1.0155038759689923 EXECUTES per PARSE
Packet Ratio: 1.3129770992366412 packets sent per operation
Currently opened Cursors: 0
Maximum opened Cursors : 9
ORACLE NET SERVICES:
Total Calls : 172 sent, 172 received, 275 oci
Total Bytes : 52407 sent, 93168 received
Average Bytes: 304 sent per packet, 541 received per packet
Maximum Bytes: 2969 sent, 5297 received
Grand Total Packets: 172 sent, 172 received
No hay comentarios.:
Publicar un comentario