Database Administration (MOSC)

MOSC Banner

Diagnosing performance problems

edited Mar 14, 2016 10:35AM in Database Administration (MOSC) 9 commentsAnswered

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center