Diagnosing performance problems
Hi,
From last week, every day at the same time I have been suffering with performance problems.
Today I was analyzing, and after some time I find some information, and I am suspicious of the following procedure
begin dbms_feature_usage_internal.exec_db_usage_sampling (: bind1); end; 05s9358mm6vrr 1174193661 0 440 0 2016-03-04 / 15: 29: 03/04/2016 43/15: 29: 43
That is exactly the time that the slow starts
- Also occur ORA-1652 events: unable to extend temp segment by 128 in tablespace TEMP
And I could not identify the session occupying the entire tablespace temp
I'm thinking of disabling this job, that performs this procedure, but could not find what job call this. You know how to disable this schedule or other suggestions?