I am having performance problems. In my AWR I see enq: ST Contention. What could be the problem?
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.