Database - RAC/Scalability (MOSC)

MOSC Banner

DFS Lock handle

edited Mar 20, 2015 10:02AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

My db getted very much EVENT "DFS Lock handle" . And so I Kill the problem session.

My db sequence's ddl.

CREATE SEQUENCE CSSADM.SQ_PI_CSSI_EVNT_LOG_1 

INCREMENT BY 1 START WITH 2309607073

MAXVALUE 999999999999999

MINVALUE 1 NOCYCLE CACHE 2000 ORDER ;

 

GRANT SELECT ON CSSADM.SQ_PI_CSSI_EVNT_LOG_1 TO RL_CSS_ALL;

GRANT SELECT ON CSSADM.SQ_PI_CSSI_EVNT_LOG_1 TO RL_CSS_SEL;

GRANT SELECT ON CSSADM.SQ_PI_CSSI_EVNT_LOG_1 TO RL_CSS_MPS;

GRANT SELECT ON CSSADM.SQ_PI_CSSI_EVNT_LOG_1 TO RL_CM_ALL;

GRANT SELECT ON CSSADM.SQ_PI_CSSI_EVNT_LOG_1 TO RL_AUTH_ALL;

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