Home
Videos uploaded by user “Anindya Das”
ORACLE TKPROF fundamentals Part 1 -  Introduction to SQL Tracing & TKPROF
 
11:44
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: 30746 Anindya Das
DBMS_PROFILER - A Key to Identify PL/SQL Performance Bottleneck
 
14:02
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: 26824 Anindya Das
Oracle  AUTOTRACE Fundamentals to Analyze & Tune SQL
 
20:43
This Tutorial will explain fundamentals of Oracle AUTOTRACE. Set up & Use AUTOTRACE. Review PLAN & Statistics generated by AUTOTRACE. Understanding Statistics details.
Views: 22455 Anindya Das
ORACLE TKPROF fundamentals Part 2 - Interpret TKPROF Report
 
29:03
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: 19725 Anindya Das
Tune Query without Changing Code using DBMS_ADVANCED_REWRITE
 
14:10
Tune Query without modifying SQL using DBMS ADVANCED REWRITE
Views: 9378 Anindya Das
BULK COLLECT and FORALL-A PL/SQL Performance Booster
 
25:07
In this Video Tutorial, I have covered 2 great feature in Oracle PL/SQL - BULK COLLECT and FORALL with some demos.
Views: 53191 Anindya Das
B*Tree Index Types (Indexes in Oracle-2)
 
33:58
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: 15278 Anindya Das
Review Actual Plan using DBMS_XPLAN.DISPLAY_CURSOR PART -1
 
20:04
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: 6769 Anindya Das
Oracle 11g Installation on Solaris 10
 
17:29
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: 14350 Anindya Das
Using B*Tree Indexes-When to use B*Tree Indexes(Indexes in Oracle-3)
 
31:14
 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: 13209 Anindya Das
B*Tree Index Fundamentals(Indexes in Oracle-1)
 
17:42
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: 48653 Anindya Das
Review Actual Plan with DBMS_XPLAN.DISPLAY_CURSOR PART-2
 
23:41
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: 4750 Anindya Das
Oracle 11g Hints Overview
 
42:56
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: 50904 Anindya Das
ORACLE 11G INSTALLATION ON WINDOWS
 
10:34
This video shows installing Oracle 11g on windows platform.
Views: 123528 Anindya Das
Solaris 10 Installation in Oracle VirtualBox VM
 
30:50
This session will cover step by step installation of Solaris 10 in Oracle VM VirtualBox.
Views: 27154 Anindya Das
ORACLE EXPLAIN PLAN FUNDAMENTALS
 
36:14
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: 158438 Anindya Das
Yumthang & Yumesamdong (Zero Point) Tour- An Amazing Experience
 
03:35
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: 9333 Anindya Das
Rafting at Teesta
 
02:42
Rafting at Teesta
Views: 578 Anindya Das
Gurudongmar Lake -A Paradise @17100 feet
 
03:13
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: 1035 Anindya Das

Lco newsletter formats
Inter cover letter
144 eme newsletter formats
Vet cover letters examples
Cna cover letter examples for resumes