Database Performance Issue - Basic Guidelines and OS Analysis [top, vmstat, free, iostat,sar] - PT 1

Подписаться 21 тыс.

Просмотров 28 тыс.

50% 1

Hello Friends,
Here with one more topic on.
Database Performance Issue - Basic Guidelines and OS Analysis [top, vmstat, free, iostat,sar] - PT 1:
===================================================================================
 What is a DB performance issue:
• CPU high?
• Out of Memory?
• I/O slow?
• High wait event?
• Hang?
 General Tuning Guidelines
 Detecting Performance Problems:
 Database Tuning Methodology:
 Workload Characteristics
 Wait Events
OS Analyis
==========
top analysis
vmstat analysis
memory analysis
iostat analysis
sar analysis
#PerformanceTuning #PT #top #vmstat #iostat #free #sar #RAC #exadata #oracle #oracledatabase #oracledba #database #databaseadministration #databases
Please do follow me and support me on,
Blog: mallik034.blogspot.com/
LinkedIn: / mallikarjun-ramadurg-3...
twitter: / mallik034
instagram: / mallik034
RU-vid: / @mallik034
Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: mallik034.blogspot.com/
LinkedIn: / mallikarjun-ramadurg-3...
twitter: / mallik034
Instagram: / mallik034
RU-vid: / @mallik034

Опубликовано:

28 июн 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 59

@nikhilingale9636 2 года назад

One of the best video. Amazing brother. You're awesome. This video gives much clarity and helpful for each one of us here to understand the basics of performance tuning here.

@Ulta-Fulta Год назад

Excellent explanation.

@mayurrahate Год назад

Thanks for the detail explanation

@Prakashsv-dh9ej 2 месяца назад

Great work bro, im becoming fan of yours. Thanks for doing this type of videos....

@prasadd1324 2 года назад

GREAT EXPLANATION MAN. I USED TO ALWAYS CHECK INSIDE HEREAFTER I WILL CHECK THESE FIRST.... THANKS A LOT👌👌👌👌

@Mallik034 2 года назад

Happy to help

@DeviL_07s 2 года назад

Very well explained

@maqsorix 10 месяцев назад

Awesome

@anikjonina6498 3 года назад

Very well explained. Thanks for the session

@Mallik034 3 года назад

You are welcome

@akashkokate8048 2 года назад

Nice explanation ❤

@sanjeevvellaisamy6282 4 года назад

Excellent video.. keep update

@Mallik034 4 года назад

Thanks Sanjeev

@NerdDrummer 2 года назад

Very nicely explained. Only thing that could have been better is the volume of voice.

@lucian1094 4 года назад

Very usefull video! Good job!

@Mallik034 4 года назад

Thank you.

@vinny_vlogs4262 3 года назад

Looking more videos on wait events,SQL tuning, sorting, Joins, Baseline, SQL profile. Pls

@muhammadisrar6057 3 года назад

MashaAllah brother. very nice info.

@Mallik034 3 года назад

Thanks

@rohanmahadik4222 3 года назад

Excellent explanation

@Mallik034 3 года назад

Glad it was helpful!

@Haider_Ain Месяц назад

Thank you for the explanation but lower the NI value (nice value) higher the priority and higher the NI value lower the priority.

@BHARARHROYAL 4 года назад

Great session sir

@Mallik034 4 года назад

Thank you.

@kids-kh1ij 4 года назад

Very nicely explained 👍

@Mallik034 4 года назад

Thank you.

@eswar6311 2 года назад

Hi Mallik thankful for your support Eswar from Vizag

@Mallik034 2 года назад

Always welcome

@santoshramadurga4336 4 года назад

Nice explained

@Mallik034 4 года назад

Thanks brother

@meghakaradi 4 года назад

Good explanation

@Mallik034 4 года назад

Thank you dear.

@BabitaSingh-rn4ol 4 месяца назад

Please make more videos

@rameshvattikuti9865 4 года назад

Excellent Session Mallik. Could you please take a session on SQL Profiler and SQL BASELINE

@Mallik034 4 года назад

Thank you Ramesh, My next session will be on SQL profile and SQL baseline including SPM package.

@SujeetKumar-nz5pl 3 года назад

Nice video

@Mallik034 3 года назад

Thanks

@alykebe5114 4 года назад

Hi Mallik Thank you so much . Your tutorial is very clear. Could you add one more topic about debgugging by using Toad or oracle developer. Thanks again

@Mallik034 4 года назад

Sure Aly Kebe, I will show you how to debug using toad or SQL developer. Its much easier than SQL command prompt if you toad or sql developer.

@Abdulhafeezkalsekar 3 года назад

Good Job Brother !!

@Mallik034 3 года назад

Thanks ✌

@sairamakrishna5995 3 года назад

Excellent explain please upload all da main topic

@Mallik034 3 года назад

Sure noted

@sahaniarunitm 4 года назад

nice

@Mallik034 3 года назад

Thank you Arun. Please so share with you friends and colleagues

@rajeshkunda6704 3 года назад

Very nice sir

@Mallik034 3 года назад

Thanks and welcome

@RaviManam 4 года назад

Hi Mallik I can see my Swap memory usage even we have physical memory free, is it good or bad and why it is using swap memory

@Mallik034 4 года назад

1. Swap is Disk memory which is slower than Physical memory (RAM) 2. Your DB or application should not use any swap memory if you have free memory. 3. Swap memory should be used only when you exhaust complete physical memory that not longer time. 4. If you are seeing swap memory usage regularly then you need to either increase your physical memory or tune your database by restricting memory limits. 5. If you see swap memory usage even thought there is free physical memory then some settings miss config in server. /etc/sysctl.conf check for swappiness. Also check for linux memory configuration and tune your linux server accordingly.

@RaviManam 4 года назад

@@Mallik034is there any way to allocate swap memory to database? Generally we will allocate memory to database that will take from physical memory and that is not swappable memory and it will not go beyond that memory Can you please tell me if it needs more memory than allocated one it will use from swap?

@Mallik034 4 года назад

SGA will take from RAM and it will not go more than what defined. But PGA will go more than what allocated in 11g. To avoid that starting from 12c new parameter PGA_agregate_limit parameter introduced

@bharathkumar-ds8cd 4 года назад

@@Mallik034 only some situations we are facing huse swap usage issues, that time I am informing to application team then kill the session.mostly it's happens peak business hours. So how to pro actively fix?

@reresha191 3 года назад

Can you put your previous session link here pls

@Mallik034 3 года назад

I am sharing all the session documents and everything on our DBA group in Telegram. Join our DBA gtoup @mallik034 on Telegram

@prasaddba6848 3 года назад

Hi Mallik ,how to identified zombie ,stopped process ,can you please let me know where i have look.

@prasaddba6848 3 года назад

i am able to see zombie ,stopped process .how to resolve in database level

@Mallik034 3 года назад

Okay, I will take on session on the handling these zombie process and OS wait events. 1. Ideally we need to kill those zombie process 2. For the OS wait events we need to check further why those are waiting, waiting for resource or waiting for CPU or waiting for client process and then we need to take appropriate action

@ashishgupta3788 3 года назад

Mallik Sir - please correct your words. ni is Nice. As you said higher nice higher priority and less nice less priority. It should be Less nice value (-20) higher priority and more nice (+20) less priority.

@Mallik034 3 года назад

There are more videos in clearing your doubts on my channel. Check them if still did not clear then i will take one live webinar on these topics for live discussion. Stay tuned