Showing posts with label Tracing. Show all posts
Showing posts with label Tracing. Show all posts
Thursday, November 23, 2023

How to use strace to figure out what files are being accessed by a shell script

›
I had a situation where an ebs-supplied script adstrtal.sh would not start - it kept throwing error ORA-12541: TNS:no listener Although ...
Friday, August 4, 2023

How to trace the dbca tool

›
These notes are taken directly from MOS, and jotted down here so I have it readily available for the future. To trace the DBCA, we need ...
Monday, April 19, 2021

trcsess utility arguments

›
trcsess [output=output_file_name] [session=session_id] [clientid=client_id] [service=service_name] [a...

tkprof arguments

›
From Oracle Support note 29012.1 print=integer List only the first 'integer' SQL statements. insert=filename List SQL stat...
Friday, June 19, 2020

How to run RMAN with debug information

›
Tested with Oracle 12.2 For example, to trace a duplicate database session, I have put the following into a file called "run_duplica...
Tuesday, May 12, 2020

How to avoid the error Can't locate Data/Dumper.pm in @INC during installation of AHF

›
During installation of ahf, I received the following error: Extracting AHF to /u01/ahf/oracle.ahf Can't locate Data/Dumper.pm in @IN...
Thursday, February 14, 2019

What is the 100046 trace event anyway?

›
The 100046 event is a Process Trace event. These trace certain system operations continuously until the tracing is canceled. The results ar...
Thursday, January 31, 2019

How to solve SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled

›
Logged in as the user owning the objects, you are getting the following error when trying to use the autotrace feature: SP2-0618: Cannot ...
Monday, February 26, 2018

How to set up End-to-End tracing

›
Based on Performing Application Tracing in Oracle Database 12.1 SQL Tuning Guide Add the following to your application code: ALTER SES...
Monday, August 8, 2016

How to find the default trace file for the session

›
Use the v$diag_info view, which "describes the state of Automatic Diagnostic Repository (ADR) functionality" SELECT value FROM ...
Monday, August 25, 2014

How to use trace event 10046

›
ALTER SESSION SET max_dump_file_size = unlimited; ALTER SESSION SET tracefile_identifier = 'normal_run_with_trace_10046'; ALTER SES...
Wednesday, June 11, 2014

How to disable an event parameter in the database

›
During an Upgrade from 11.2.0.3 to 11.2.0.4 I had to remove an event-parameter in the database. The syntax for this is: alter system set ...
Thursday, October 31, 2013

How to enable tracing for a session

›
To enable trace for a session: execute dbms_monitor.session_trace_enable(session_id => 127, serial_nu...
Saturday, October 19, 2013

How to name a trace file to find it more easily

›
alter session set tracefile_identifier = 'your string for easy recognition here'; For example: alter session set tracefile_ident...