Keeping the DB running smoothly :Tips and Tricks for addressing Slowness & Long Running Transactions

Опубликовано: 20 Октябрь 2023
на канале: Anish kumar

3,057

107

The most common causes of slow performance are as Excessive round-trips from the application server to the database.
The main difference between that simple SELECT statement and database slowness is that the latter is a chronic ailment of your databases. Slowness can be attributed to multiple factors such as: - network problems. - missing indexes.

Long-running transactions are open transactions with no activity (that is, no new Logical Change Records (LCRs), rollbacks, or commits) for an extended period (20 minutes). A large transaction is an open transaction with a large number of LCRs.
The v$session_longops view allows the Oracle professional contract the amount of time that is used by long-running DLL and DML statements. You can view any SQL statement that executes for more than 6 absolute seconds (the "long running" threshold) using the v$session_longops view.

For more information visit:
https://asrblogger.com/

Join Telegram : https://t.me/asrBlogger
Scripts from Github : https://github.com/anishs10/db-scripts

#oracledatabase #oracledatabasetutorial #performancetuning #databasetuning #performanceoptimization #asrblogger #asrbloggerdba