Link for ORACLE TKPROF fundamentals Part-2 (Interpret TKPROF Report) https://www.youtube.com/watch?v=OiVu6vFq28w ORACLE TKPROF fundamentals For SQL TUNING Part-1 covers 1. Introduction to SQL Tracing. 2. Set up SQL_Trace &TKPROF. 3. Generate TKPROF Report. ---------------------------------------------------------------------------------------------------------------------- ORACLE TKPROF fundamentals For TUNING SQL Part-2 covers 1. Interpreting TKPROF Report.
Views: 32001 Anindya Das
This video tutorial explains PL/SQL performance analysis with DBMS_PROFILER. This video tutorial explains DBMS_PROFILER package,Profiler tables,how to use profiler. It demonstrates Setting up DBMS_PROFILER, Profiling for a PL/SQL procedure and Analyzing the Profiler data.
Views: 28540 Anindya Das
Review Actual Query Execution Plan Using DBMS_XPLAN.DISPLAY_CURSOR PART-1 covers What is execution plan Various methods to view execution plan. Problems with Explain Plan & Autotrace & a demo on it. Overview on DBMS_XPLAN.DISPLAY_CURSOR.
Views: 7017 Anindya Das
This Tutorial will explain fundamentals of Oracle AUTOTRACE. Set up & Use AUTOTRACE. Review PLAN & Statistics generated by AUTOTRACE. Understanding Statistics details.
Views: 23263 Anindya Das
ORACLE TKPROF fundamentals Part 2 video will cover interpretation of TKPROF Report. Video Part 1 will be in this url -- http://www.youtube.com/watch?v=8CQO2mEJg0s Part 1 will cover 1. Introduction to SQL Tracing.,2. Set up SQL_Trace &TKPROF, 3 Generate TKPROF Report.
Views: 20506 Anindya Das
Tune Query without modifying SQL using DBMS ADVANCED REWRITE
Views: 9690 Anindya Das
In this Video Tutorial, I have covered 2 great feature in Oracle PL/SQL - BULK COLLECT and FORALL with some demos.
Views: 55227 Anindya Das
This video will demonstrate step by step Installation of Oracle database 11g R2 on Solaris 10 64 bit OS on Oracle Virtual Box. The purpose of the tutorial is to help beginners to learn installation of oracle database on Solaris environment.
Views: 14864 Anindya Das
Part -1 : Introduction to Indexes, B*Tree Indexes, Index scan methods. Part -2 : B*Tree Index Types(different types of B*Tree indexes) Part -3: Using B*Tree Indexes(When use B*Tree indexes, factors related to B*Tree Access) Part -4 : Index Organized Table Part -5 : Bitmap Indexes Part -6: Partitioned Indexes Part- 7: Other type of Indexes based on characteristics & use. Part -8: Managing Indexes
Views: 49574 Anindya Das
This video will cover When B*Tree Index should be used. We will try to understand some of the situations when the optimizer will use B*Tree Index. Index Clustering Factor . Influence of parameter Optimizer_Mode and Optimizer_index_cost_adj on using B*Tree Index.
Views: 13389 Anindya Das
Review Actual Query Execution Plan Using DBMS_XPLAN.DISPLAY_CURSOR PART-2 covers Set up & view execution plan using Display_Cursor. Overview on Execution Plan shown by Display_Cursor, understand estimated & actual row source execution statistics, IO stats, memory stats, usage of temp.
Views: 4882 Anindya Das
This Tutorial will explain basics of Oracle 11g EXPLAIN Plan by using this ppt & some hands-on in Oracle 11g R2 Database.This tutorial will include below topics. Understanding EXPLAIN plan. Set up & Use EXPLAIN Plan. Explain PLAN_TABLE & related scripts & DBMS_XPLAN.DISPLAY. Generate & View EXPLAIN Plan. Read & Interpret basics of EXPLAIN Plan. EXPLAIN PLAN limitations.
Views: 162696 Anindya Das
Gurudongmar Lake is one of the highest lakes in the world,And 2nd highest lake in India, located at an altitude of 17,100 ft (5,210 m). It lies in the district of North Sikkim in the state of Sikkim in India, only some 5 kilometers (3.1 mi) south of Chinese border. The lake can be reached by road from Lachen via Thangu.
Views: 1067 Anindya Das
Yumthang Valley is is popularly known as 'Valley of Flowers'situated in Himalayan Ranges of North Sikkim district of Sikkim, India. It is at an elevation of 3,564 metres (11,800) and situated at a distance of 150 km from the state capital Gangtok. Yumesamdong (Zero Point) is situated at an altitude of 15,800 ft & very close to the Chinese border. Its 26 km from Yumthang. While traveling to Yumesamdong you can see Amazing beauty of snow covered peaks n Himalayan range. Yumesamdong stays covered by snow almost all months in year.
Views: 9656 Anindya Das