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

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

33.152 Lượt nghe
Database Performance Issue - Basic Guidelines and OS Analysis [top, vmstat, free, iostat,sar] - PT 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: https://mallik034.blogspot.com/ LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a twitter: https://twitter.com/mallik034 instagram: https://www.instagram.com/mallik034/ YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA Regards, Mallikarjun Ramadurg Mobile: +966 543796525 WhatsApp: +91 9880616848 Blog: https://mallik034.blogspot.com/ LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a twitter:https://twitter.com/mallik034 Instagram:https://www.instagram.com/mallik034/ YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA