Database Performance Tuning Steps | Oracle Performance Tuning

Database #tuning aims to maximize use of system resources to perform work as efficiently and rapidly as possible. Most systems are designed to manage their use of system resources, but there is still much room to improve their efficiency by customizing their settings and #configuration for the #database and the #DBMS.

00:00 Performance issue in database
00:35 Business Logic
06:23 Data Design
07:48 Application design
10:38 Change Database structure (Indexes)
11:30 Tuning the SQL
11:55 What do mean by effective SQL
16:58 Access Path-Change the indexes
22:39 Instance tuning (RAM)
24:58 Tune the I/O-Physical storage
30:04 Tune resources-Locks
31:31 Tune the server

[suriyag]

Hi,
Very Good Work. Please continue.
Thanks
Surya

[Karmihir]

Hi, on my work I'm dealing with large Records. Sometimes my join orders are bad which queries went long run. Please provide some knowledge about Oracle internal joins and index and how to use them during multiple join operations.

[navin]

Yes...arun....can we have a video on patching

[Nani-mbnc]

Hi, I have a question, i have a batch in my application which will.process billions of records on daily basis. Some time jobs will complete faster in case of less data. But data is huge it will take more time, can you pls.let me.know wht the things I need to check to find the long running queries or wht are the other facts making my job running long

[nayemalaboni]

I sincerely apologize for this question do you mean our main backup schedule?

[cryptosurfer]

Learn solidarity or sql which is easier quicker

[SanjayKumar-ngzp]

contents are good ...but getting advertisements very frequently ..
creates distraction while learning

[JK-vnje]

Thanks for ur video. But letters are invisible.