Performance monitoring or tuning tool for SQL query taking long time using various tools like explain plan,sql monitor,awrsqrpt,sqlhc

Performance monitoring or tuning tool for SQL query taking long time using various tools   In that post,I will explain using various method or tool to investigate performance problem of particular sql query. Let me create a test case first   create table test_c(id number,name char(100),address char(100),create_date date); create table test_p(id number,name char(100)); declare v_mContinue reading Performance monitoring or tuning tool for SQL query taking long time using various tools like explain plan,sql monitor,awrsqrpt,sqlhc