Videos uploaded by user “Anindya Das”
ORACLE TKPROF fundamentals Part 1 -  Introduction to SQL Tracing & TKPROF
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: 32790 Anindya Das
DBMS_PROFILER - A Key to Identify PL/SQL Performance Bottleneck
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: 29634 Anindya Das
ORACLE TKPROF fundamentals Part 2 - Interpret TKPROF Report
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: 20964 Anindya Das
Oracle  AUTOTRACE Fundamentals to Analyze & Tune SQL
This Tutorial will explain fundamentals of Oracle AUTOTRACE. Set up & Use AUTOTRACE. Review PLAN & Statistics generated by AUTOTRACE. Understanding Statistics details.
Views: 23721 Anindya Das
Tune Query without Changing Code using DBMS_ADVANCED_REWRITE
Tune Query without modifying SQL using DBMS ADVANCED REWRITE
Views: 9847 Anindya Das
Oracle 11g Installation on Solaris 10
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: 15204 Anindya Das
BULK COLLECT and FORALL-A PL/SQL Performance Booster
In this Video Tutorial, I have covered 2 great feature in Oracle PL/SQL - BULK COLLECT and FORALL with some demos.
Views: 56546 Anindya Das
B*Tree Index Fundamentals(Indexes in Oracle-1)
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: 50084 Anindya Das
Review Actual Plan using DBMS_XPLAN.DISPLAY_CURSOR PART -1
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: 7132 Anindya Das
Oracle 11g Hints Overview
In this Video tutorial we will discuss about Optimizer hints in Oracle. What is optimizer hint, when & why its needed. Different Category of hints. Description of mostly used hints. Demonstrate how query plan can change with the influence of hint.
Views: 54592 Anindya Das
B*Tree Index Types (Indexes in Oracle-2)
This video will cover different types of B-tree indexes: Descending index,Reverse key index,Key Compressed Index B-tree cluster index,Index Organized Table(IOT):
Views: 15616 Anindya Das
Gurudongmar Lake -A Paradise @17100 feet
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: 1127 Anindya Das
This video shows installing Oracle 11g on windows platform.
Views: 125942 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: 4940 Anindya Das
Solaris 10 Installation in Oracle VirtualBox VM
This session will cover step by step installation of Solaris 10 in Oracle VM VirtualBox.
Views: 28955 Anindya Das
Using B*Tree Indexes-When to use B*Tree Indexes(Indexes in Oracle-3)
 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: 13482 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: 164978 Anindya Das
Yumthang & Yumesamdong (Zero Point) Tour- An Amazing Experience
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: 9909 Anindya Das
Rafting at Teesta
Rafting at Teesta
Views: 627 Anindya Das