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

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:
asrblogger.com/
Join Telegram : t.me/asrBlogger
Scripts from Github : github.com/anishs10/db-scripts
#oracledatabase #oracledatabasetutorial #performancetuning #databasetuning #performanceoptimization #asrblogger #asrbloggerdba

[@cityofjoy8830]

What about slow uploading of files.

[@Daily-digital]

your videos are good enough, keep up the good work

[@Dancewithsaigite]

Nice one sir expecting more videos

[@surendraroy1758]

Is there any class your side conducting for performance tuning ?

[@abhishekgarg9536]

Thank you sir . So beautifully explained..

[@GauravSingh-bp8nw]

Nice one

[@wbtopg]

Just wow

[@balajichandramohan9707]

Hi there, good one. How would you tune a select query. Do you use sql tuning advisor or explain plan.