CODEWITHSUNDEEP
oracle-databasesessiontracealter
Andrew Klimov
Andrew Klimov

Reputation: 124

trace session in Oracle (events 10046)

respective all! My database version is Oracle 12.2.

My question is - what if I include

alter session set events '10046 trace name context forever...'

at the top of session but do not include "counterpart"

alter session set events '10046 trace name context off'

at the bottom of session?

Will Oracle terminate tracing automatically when the session ends? And will it terminate tracing in case of erroneous end of the session?

TIA, Andrew.

Upvotes: 0

Views: 604

Answers (1)

Sayan Malakshinov
Sayan Malakshinov

Reputation: 8655

Will Oracle terminate tracing automatically when the session ends? And will it terminate tracing in case of erroneous end of the session?

Yes, of course, since you enabled it for your session only.

BTW, there is special parameter MAX_DUMP_FILE_SIZE that allows you to set max trace file size limit: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/MAX_DUMP_FILE_SIZE.html

Upvotes: 2

Related Questions