This post video provide you basic method how oracle calculate cost from explain plan it derives
-
debasis maity in General Performance tuning
Oracle Optimizer Cost Calculation from explain plan
Leave a Comment
Related Post
-
Monitor real time active session statistics by ORAPUB tool
The tool was devised by Craig from ORAPUB which is excellent to monitor what happens…
-
Cache buffer chain CBC latch simple query to investigate
For deep understanding on CBC,please refer to below links:- //www.proligence.com/pres/ioug14/2014_431_Nanda_ppr.pdf and Video tutorial from ORAPUB.…
-
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 …