Demantra Solutions - EBS (MOSC)

MOSC Banner

I am having performance problems. In my AWR I see enq: ST Contention. What could be the problem?

edited Jan 27, 2015 9:09AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered ✓

The Oracle RDBMS provides several ways to manage allocation of disk space.  For Demantra, we recommend the following:

1. "enq: ST - contention" this is probably caused by datafiles configured to autoextend.  You can eliminate that by making enough free space in the

   relevant tablespace before running the engine so the database will not have to allocate space during runtime.

2. Make sure all relevant tablespaces, the ones Demantra objects resides on are Locally Managed Tablespace, LMS.

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

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center