Why Oracle 10046 cannot track event tracking program execution of SQL???????-CodePudding

I carried out among the query of the page, and then stop the 10046 event tracking, but the generated files without the query the corresponding SQL statement

CodePudding user response:

You this is to enable 10046 trace of this session, you use other session execute SQL, it certainly won't be able to trace,

CodePudding user response:

reference 1st floor lhdz_bj response:

you this 10046 trace is enabled in this session, you use other session execute SQL, it certainly won't be able to trace,

I tried to enable the system is not tracking,,

CodePudding user response:

Since this is the test environment, check recently executed SQL directly bai
The select sql_text, last_load_time from v $SQL order by last_load_time desc;

CodePudding user response:

reference 3/f freedom and responsibility response:

since this is test environment, check recently executed SQL directly bai
The select sql_text, last_load_time from v $SQL order by last_load_time desc;

oh, formal environment

CodePudding user response:

refer to the 2nd floor broken a sunshine reply:

Quote: refer to 1st floor lhdz_bj response:

You this is to enable 10046 trace of this session, you use other session execute SQL, it certainly won't be able to trace,

I tried to enable the system is not tracking,,

System level should be able to,

CodePudding user response:

reference 3/f freedom and responsibility response:

since this is test environment, check recently executed SQL directly bai
The select sql_text, last_load_time from v $SQL order by last_load_time desc;

If the system on the session, the best correlation v $session view, which is so easy to identify target session,

CodePudding user response:

reference 5 floor lhdz_bj reply:

Quote: refer to the 2nd floor broken a sunshine reply:

Quote: refer to 1st floor lhdz_bj response:

You this is to enable 10046 trace of this session, you use other session execute SQL, it certainly won't be able to trace,

I tried to enable the system is not tracking,,

System level should be able to,

system level is not tracking,,,,