Du -sk * | sort-n ( unix Comnad) Press command in any directory you will get highest occupied process. He is explaining very low level. L1 level can understand quickly
Thanks, It would be very helpful if you could show and do the things practically on a server instead of orally......so that we can be understood easily....
Thanks sir, Can you suggest me how can i get data within a second when selecting a particular column and not created index for it .Normally table takes 4 min to get data . Table contained 14 lakhs of data . query: SELECT DISTINCT COLUMN1 FROM TABLE1 WHERE COLUMN1 IS NOT NULL; how can i resolve this problem without index because column selections are dynamic hance we can't add index for each column.
Bhai 1 Query ki Performance aaj bhut slow hai and last week aachi thi uska kya solu hai ? Uski Performance Increase k liye kya kregeee ? kya hum old paln value ka use kr skte hai
check statistics of tables used in the query, if stats are stale then gather the same.. check execution plan of the query, if possible fix best execution plan. execute tuning advisor for that particular query. check what types of wait events occurs while execution.. work on that waits
How to check standard io for database and how can we identify io based slow SQL Sometimes query previous day works fine but suddenly working slow please guide me
Hi ankush, Well and lucid explained for performs tuning. it's really valuable. I need to suggest one technique we also resize redo group to enhance database performance..