Home
Search results “Oracle db scattered read”
Oracle Database - Wait Event - Sequential Read Vs Scattered Read
 
06:26
In this video you will learn about what is Sequential read and how is it different from Scattered read in an Oracle Database. The entire course can be purchased at https://www.udemy.com/oracle-database-troubleshooting-and-tuning Use Coupon Code - YOUTUBETT Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 2821 Ramkumar Swaminathan
Lunch n Learn   Important Oracle Wait Events
 
09:56
Oracle Wait Events DB File Scattered Read and DB FIle Sequential Read...tips and techniques...
Views: 5169 Dan Hotka
Oracle Midlands #13: Interpreting AWR Reports - Franck Pachot
 
57:30
Timestamps: 2:30 - Database load 10:30 - Top 10 Foreground Events 16:30 - db file sequential read 23:39 - DB CPU 32:30 - log file sync 37:16 - enq: TX - row lock contention 39:47 - Findings summary & recommendations 42:38 - Quantifying the gain 47:15 - Q&A Franck walks his way through an AWR report, explaining his observations and thought process as he goes. The slides are available at: Google: https://drive.google.com/folderview?id=0B0DLaAfeW6uKZmJ3TXE0WGtLYlE Dropbox: https://www.dropbox.com/sh/9koxoemak8ts7j6/AADozVVYLoK_FdDZbQGC6TYta This event was sponsored by Red Stack Technology (http://redstacktechnology.com/). See more events at http://OracleMidlands.com/ Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. "Fair Dealing" under UK Copyright, Designs and Patents Act 1988.
Views: 11530 Oracle Midlands
AskTOM TV - Direct path read
 
04:59
A video to help you understand the "thought process" behind answering AskTom questions. In this episode, we look at direct path reads and how they interact with objects that may already have changed buffers in the buffer cache blog: https://connor-mcdonald.com
Views: 622 Connor McDonald
Oracle Wait Events  (From  Performance Tuning Training Videos)
 
02:38
Small excerpt from "Oracle performance Tuning-DBA Track" Course. http://www.dbvidya.com/course/performance-tuning-for-dba/ [email protected] +91 991 2323 000 Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tuning-advanced/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-performance-tuning-videos/ Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-awr/ Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-tool/ ER Data Modeling Course : http://www.dbvidya.com/course/er-modeling/ Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensional-modeling/ Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 599 DbVidya
Oracle Instance Startup - DBArch Video 13
 
03:38
In this video you will learn the various steps involved in starting an Oracle Database Instance. You get introduced to the different states of an Instance - IDLE, NOMOUNT, MOUNT and OPEN and what happens in each of these states. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 12500 Ramkumar Swaminathan
Oracle 11g Database &grid Instalation
 
14:59
taller 1 y 2 asignatura taller de base de datos
Views: 11 jorge casanova
Oracle Database Background Processes
 
12:10
https://dbagenesis.com/
Views: 980 DBA Genesis
AskTOM TV - helping you understand the process
 
01:13
blog: https://connor-mcdonald.com Get more than just the solution to questions on AskTom. We're now giving insight into the *how* of problem solving as well. ========================================­­­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 625 Connor McDonald
What's Inside Oracle Data Block?
 
19:53
Join the biggest Oracle community online: https://dbagenesis.com/ Oracle manages the storage space in the datafiles of a database in units called data blocks. A data block is the smallest unit of data used by a database. In contrast, at the physical, operating system level, all data is stored in bytes. Each operating system has a block size. Oracle requests data in multiples of Oracle data blocks, not operating system blocks.
Views: 953 DBA Genesis
Oracle full table scans, direct path reads, object level checkpoints, ORA 8103s (old videos)
 
02:19:18
As the name says, in this hacking session I'll demo how full table scans (and full segment scans) work and related stuff too, like direct path read checkpoints and ORA-8103 errors.  It's an old video from 2011 so not with the best recording resolution, but should still be fun. As direct path reads go, some things have changed and should be clarified, perhaps the best explanation is here: https://blogs.oracle.com/smartscan-deep-dive/when-bloggers-get-it-wrong-part-1 https://blogs.oracle.com/smartscan-deep-dive/when-bloggers-get-it-wrong-part-2
Views: 902 Tanel Poder
Troubleshooting a Complex Oracle Performance Issue
 
01:28:00
In this session Tanel will walk you through troubleshooting a yet another complex performance issue that he has faced in past. Again, the initial symptoms point to a different direction than the actual root cause, so a systematic approach was needed.
Views: 4585 Tanel Poder
How Many Hours Do You Need To Become An Oracle DBA
 
02:18
Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator. New classes start during the following times:- March 2nd : Atlanta Branch March 25th: College Park MD Branch March 6th: Springfield VA Branch Hands on training available Online/Remote classes available 24x7 Call now to reserve your seats: Office: 1-866-569-0205 Office Mobile: 240-244-9935 Website: https://newayitsolutions.com Student portal: https://training.newayitsolutions.com New Oracle 12C concepts taught in all 3 locations.
Performance Troubleshooting Using Wait Statistics
 
01:43:14
One of the first things you should check when investigating performance issues are wait statistics - as these can often point you in the direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem - what is often called 'knee-jerk performance tuning'. In this session, you will learn what waits are, how to analyze them, and potential solutions to common problem patterns. Paul Randal is a Microsoft SQL Server MVP and a Microsoft Regional Director. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine. In 2007 Paul left Microsoft to co-own and run SQLskills.com, and is a world-renowned author, consultant, and top-rated speaker on SQL Server performance tuning, administration, internals, and HA/DR. When he's not tweeting, blogging, or helping someone recover from a disaster, he's likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp.
Views: 2029 DBAFundamentals
Formation Oracle Database 11g DBA 1 1Z0-052 : 06.04 Demarrage et arret
 
57:55
Cette vidéo/tutorial fait partie de la Formation Oracle Database 11g DBA 1 (1Z0-052). Voici le plan de cette vidéo/tutorial : Module 1: Installation de Oracle 11g Module 2: Architecture d'une instance Oracle Module 3: architecture d'une base de données Oracle Module 4: Les outils d'administration Module 5: Création d'une base de données Module 6: Gérer une instance Oracle Module 7: Gérer une instance ASM Module 8: Configurer Oracle Net Module 9: Gérer les structures de stockage de base de données Module 10: Gérer la sécurité utilisateur Module 11: Gérer les accès concurrents Module 12: Gérer les données d'annulation (UNDO) Module 13: Implémenter l'audit de la base de données Oracle Module 14: Maintenance de la base de données Oracle Module 15: Gestion des performances Module 16: Sauvegarde/restauration Module 17: Transfert de données Module 18: Aide et support Bonne formation.
Views: 133 Formations Tech
Oracle Database and Instance Components - DBArch Video 3
 
10:09
In this video you will learn about the Relationship between and Oracle Instance and an Oracle Database. You will know about the various components of an Instance ( SGA and Background Processes) and the various files of the Database and how they interact. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 44994 Ramkumar Swaminathan
Oracle Enterprise Manager - Introduction - EM 01
 
03:59
This video introduces Oracle Enterprise Manager Architecture Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 2653 Ramkumar Swaminathan
I/O TUNING – Options
 
12:54
I/O TUNING – Options watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
Oracle Database Tuning Introduction - Session 1
 
35:46
This is the first lecture of the Oracle Database Troubleshooting and Tuning Class. The Full course is available on Udemy at https://www.udemy.com/oracle-database-troubleshooting-and-tuning You can use Coupon Code YOUTUBETT for discount Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 3590 Ramkumar Swaminathan
Oracle Wait Interface Training
 
05:54
EXEM Co., Ltd. Oracle Internal Structure Training, Oracle Wait Interface understanding Very Helpful to understand Oracle Wait Event
Views: 259 JUNG MO LIM
Oracle Database Instance Memory Structures - DBArch Video 4
 
08:23
Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 35456 Ramkumar Swaminathan
0606 How Oracle Manages Concurrency
 
02:45
ORACLE
Views: 186 oracle ocm
What are the different types of Tablespaces in an Oracle Database - DBArch Video 23
 
08:22
In this video you will understand about the different types of tablespaces and their use/purpose. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 15636 Ramkumar Swaminathan
01 03 Block Structure
 
06:23
PL/SQL is a procedural extension of SQL, making it extremely simple to write procedural code that includes SQL as if it were a single language. In comparison, most other programming languages require mapping data types, preparing statements and processing result sets, all of which require knowledge of specific APIs. The data types in PL/SQL are a super-set of those in the database, so you rarely need to perform data type conversions when using PL/SQL. Ask your average Java or .NET programmer how they find handling date values coming from a database. They can only wish for the simplicity of PL/SQL. When coding business logic in middle tier applications, a single business transaction may be made up of multiple interactions between the application server and the database. This adds a significant overhead associated with network traffic. In comparison, building all the business logic as PL/SQL in the database means client code needs only a single database call per transaction, reducing the network overhead significantly.
SCAN Explained - SCAN Part 3 - RAC 05
 
09:11
In this video, the last in the series about SCAN, you will understand how SCAN helps in a Cluster with server pools to enable applications to connect easily to Database Services. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 13120 Ramkumar Swaminathan
Structure of Data Blocks - DBArch Video 29
 
05:35
In this video you will understand about the contents of a Data Block. You will learn about Block Header, Transaction slots, Row Directory and space for Data / rows. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 6221 Ramkumar Swaminathan
Read Consistency -  Introduction - DBArch Video 24
 
03:29
In this video you will understand how Oracle Database implements Concurrency and Consistency when Multiple users access the data. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 6166 Ramkumar Swaminathan
Generate ASH (Active session history) report in Oracle Manually in 11g
 
03:56
Why and How we generate ASH Report in Oracle 11g
Views: 2793 Athar Fahad
What is DB Time - DBPerf Video 12
 
03:56
In this video you will understand what is DB TIme in an Oracle Database. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 2751 Ramkumar Swaminathan
SQL Tuning with Oracle Database 12c Histograms
 
09:20
Learn the new 12c options for creating histograms. See all free video tutorials at http://www.skillbuilders.com/free-oracle-tutorials. In this free tutorial, Oracle Certified Master DBA John Watson demonstrates what histograms do (provide correct cardinality), the difference between histogram types (Frequency and Height Balanced). You will also learn the importance of the auto sample size algorithm in 12c and the new "Hybrid" and "Top Frequency" type histograms.
Views: 3922 SkillBuilders
Global Temporary Tables in Oracle Database - DBArch Video 21
 
16:02
Learn about Global Temporary Tables in Oracle Database. You will learn the internals of Global Temporary tables in Oracle database, and also a demo for the same. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 7982 Ramkumar Swaminathan
Ders 7 - Oracle 12c Data Export ve Import using DataPump exp and imp
 
18:09
Ders 7 - Oracle 12c Data Export ve Import using DataPump exp and imp
Views: 92 Şafak ÇAKIR
Wait Event
 
00:59
Views: 444 Easy Media Suite
Export and Import - Backup&Reco Video 9
 
04:20
In this video you will understand about the Export and Import utilities in Oracle Database Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 3313 Ramkumar Swaminathan
Trace It, Log It, Format It - Part 3
 
01:06:47
This part 3 of 4 from - Oracle Performance Tuning - Logging and Tracing in Oracle. In part 3, I have explained the TRCSESS utility for consolidating scattered Oracle trace files and how to read a RAW trace file.
Views: 1277 Satish Lodam
Oracle X$TRACE, Wait Event Internals and Background Process Communication
 
01:48:41
In this session we will look into some internals of Oracle background process communication and also some special types of wait events that most people aren’t aware of. We will use some exotic tracing for internals research and fun and some of this stuff is actually useful in real life too! I’m not going to reveal everything upfront, as this is a secret internals hacking session after all ;-) We will use various techniques to research what the “reliable message” wait event is about and how reliable background process communication is orchestrated in Oracle. This is a hacking session, not formal structured training, so I’ll just do free form demos and talk (probably no slides, just hacking stuff on the command line). Also, check out my full-week Advanced Oracle Troubleshooting online training at https://blog.tanelpoder.com/seminar
Views: 3579 Tanel Poder
How to reduce Buffer Busy Waits using Hash Partitioned Indexes
 
08:29
The clip explains how Buffer Busy Waits are being caused and how they can be reduced with Hash Partitioned Indexes. A text version is here: https://uhesse.com/2016/12/02/how-to-reduce-buffer-busy-waits-with-hash-partitioned-indexes-in-oracle/
Instance Recovery in an Oracle Database - DBArch Video 10
 
06:00
This video explains how Instance recovery happens in an Oracle Database. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 19972 Ramkumar Swaminathan
How To Analyze And Solve Oracle Direct Path Read Problems - Introduction
 
00:59
How To Analyze And Solve Direct Path Read Problems - Introduction Oracle Direct reads of all kinds tell a special and unique performance story. But this uniqueness can result in unexpected performance issues. In this webinar I will use an AWR report and live demonstrations showing how Direct Path Reads work, why they are used, why they are awesome and also how they can beat your IO subsystem to death! I hope can join me as we explore an increasingly popular data retrieval method. If you would like to view the webinar - go to www.orapub.com/webinars For more information on OraPub or on Oracle Ace, Craig Shallahamer, go to www.orapub.com
Views: 129 OraPub, Inc.
What kind of Jobs do not go away? Arup Nanda talks about Job Security at #sangam18
 
04:46
Arup Nanda has been an Oracle DBA for over 20 years with experience spanning all aspects from Modeling to performance tuning and Exadata. He speaks frequently, has authored about 300 articles, co-authored 5 books, blogs at arup.blogspot.com and mentors new and seasoned DBAs. He won Oracle's DBA of the Year in 2003, Enterprise Architect of the Year in 2012, is an ACE Director and a member of Oak Table Network.
Views: 346 AI OUG
04 03 Contention and Latch Waits
 
10:08
ORACLE
Views: 429 oracle ocm
Oracle Tuning - Diagnosticando e corrigindo lentidão - LOG FILE SYNC
 
05:31
Oracle Tuning - Diagnosticando e corrigindo lentidão - LOG FILE SYNC
Views: 1418 Nerv
Oracle Disk Manager (ODM) and Cached ODM
 
05:11
This video describes Oracle Disk Manager (ODM) and Cached ODM (CODM) and how Storage Foundation uses these.
Server Pools in Oracle Grid Infrastructure - SCAN part 2 - RAC 04
 
15:58
In this video you will understand the concept of Server pools, how you configure them... and how nodes automatically move between sever pool based on your configuration parameters for the server pools. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 14898 Ramkumar Swaminathan
Oracle SQL Tuning Advisor Example
 
08:10
Tuning SQL with SQL Developer using "SQL Tuning Advisor" in oracle 12c. Oracle SQL Tuning Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:125 Oracle DBA Performance Tuning https://dbvidya.talentlms.com/catalog/info/id:128 Dimensional Modeling Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:131 Erwin Tool Training Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:130 SQL Tuning - Developer Track - Course Contents https://dbvidya.talentlms.com/catalog/info/id:125 Oracle performance Tuning DBA Track- course Contents: https://dbvidya.talentlms.com/catalog/info/id:128 https://dbvidya.talentlms.com/catalog/info/id:128 Oracle SQL Performance Tuning Training Online for Developers : http://www.dbvidya.com/course/sql-tuning-advanced/ Oracle Performance Tuning Online Training for DBAs : http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle Performance Tuning Interview Questions Developers DBA : http://www.dbvidya.com/oracle-performance-tuning-interview-questions-developers-dbas/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-performance-tuning-videos/ Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-... Dimensional Modeling Training Online: http://www.dbvidya.com/course/dimensional-modeling/ Entity Relationship(ER) Modeling Trianing Online http://www.dbvidya.com/course/er-modeling/ ERwin Tool http://www.dbvidya.com/course/erwin-tool/ Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 100 DbVidya
Histograms and Bind Peeking
 
20:45
Histograms and Bind Peeking watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
Huge Pages in Operating System
 
02:02
In this video you will understand what are Huge Pages The entire course on Interpreting an AWR report is available at udemy https://www.udemy.com/oracle-database-troubleshooting-and-tuning You can use Coupon Code YOUTUBETT for discount Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 2084 Ramkumar Swaminathan
Oracle Automatic Workload Repository AWR And Active Session History ASH Tutorial 2
 
44:13
In this tutorial you will learn about automatic workload repository/AWR and active session history/ASH in oracle.
Views: 3877 DBA Pro
Overview of Initial Load, Change Capture and Change Delivery in Oracle GoldenGate - GG Video 7
 
03:51
In this video, you will learn about the overall picture of performing and Initial Load, Change capture and Change delivery using Oracle GoldenGate Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 4446 Ramkumar Swaminathan
How to convert an Oracle Database to a 12c Pluggable Database (PDB) - Lesson 1
 
01:20
Learn how to convert a Non-Container Oracle Database (CDB) to a Pluggable Database, i.e. how to plug in an existing Oracle database into a 12c CDB. In this lesson (lesson 1 of 4), Oracle certified Master John Watson provides the agenda for the tutorial. To see all FREE lessons in this tutorial, visit http://www.skillbuilders.com/how-to-convert-to-12c-multitenant-cdb. This is the second in the series of 12c Multitenant database - see http://www.skillbuilders.com/what-is-12c-multi-tenant-cdb-pdb-database for the first tutorial in the series.
Views: 717 SkillBuilders