Home
Search results “Row chaining oracle”
Chained rows? Migrated rows?
 
10:37
Understanding the basics of what happens when rows are just too damn big. blog: https://connor-mcdonald.com Highlights from the June DBA Office Hours session. Subscribe as new tech videos come every week!
Views: 705 Connor McDonald
Row chaining and Row Migration Management
 
14:00
Hi guys today i will give you introduction about row chaining and row migration managing block space. #Rowchaining #RowMigration Oracle database Unbeatable,Unbreakable Platform..
Views: 2321 Oracle World
Space Management in Extents and Segments - DBArch Video 31 / DBPerf Video 13
 
13:00
In this video you will understand about the following - Dictionary managed Vs Locally Managed Tablespaces - Manual Vs Automatic Segment Space Management - PCTFREE and PCTUSED - Row Migration and Row Chaining . 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: 10301 Ramkumar Swaminathan
Oracle Midlands #3: Row Chaining and Row Migration Internals - Christian Antognini
 
01:01:12
The second talk from Oracle Midlands #3 (20th May 2014) was Christian Antognini talking about row chaining and migration internals; how to detect them, why you should care and how to prevent them. Christian kindly gave permission for me to share the video here. The second edition of his book, Troubleshooting Oracle Performance, is out next week. Be sure to check it out: http://www.amazon.co.uk/gp/product/143025758X/ref=as_li_qf_sp_asin_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=143025758X&linkCode=as2&tag=oraclmidla01-21 The PDF and scripts are available at https://www.dropbox.com/sh/dhe7dv9ztejtfxe/AAC1niC43hFBElWF9CZO8EICa This event was sponsored by Red Gate (http://www.red-gate.com/). The Oracle ACE programme was also kind enough to support Christian in visiting us. 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: 2384 Oracle Midlands
Pack Rows Tightly setting PCTFREE correctly - With Demo - DBPerf Video 14
 
04:36
In this video you will understanding about setting PCTFREE correctly and its impact in I/O and Memory / SGA utilization. At the end there is a demo to show you 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: 1876 Ramkumar Swaminathan
Frgmentation in oracle database
 
34:54
Fragmentation in oracle database,find and defragmentation
Views: 4184 Sainora Annanagar
Differences between Shared and Exclusive Lock in oracle database
 
09:31
Hello friends in this video we learn how the lock occur in database automatically when multiple user modified the same transaction in their session. #SharedandExclusiveLock Oracle database Unbeatable,Unbreakable Platform..
Views: 10744 Oracle World
Oracle Database Tutorial 56:Data Pump impdp table and Duplicate (Remap_table ) table
 
06:03
In this oracle database tutorial you will learn How to import table using impdp data pump import utility. And how to rename table using REMAP_TABLE in impdp Data Pump import. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/oracle-data-pump-impdp-import-and-duplicate-table-remap-table Previous Tutorial Tut 55 expdp table- http://youtu.be/5mdmCqGuok8 Tut 54 expdp Schema - http://youtu.be/t8TSLDGN5gg Tut 53 expdp Tablespace - http://youtu.be/-hXBZd-FCjs Tut 54 expdp Full Database - http://youtu.be/K8_PjUksT54 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 24699 Manish Sharma
What is the HASH PARTITION in Oracle ?
 
06:39
Hi guys in my today scenario I'm going to explain with you What is the HASH PARTITION in Oracle, Oracle database Unbeatable,Unbreakable Platform.. #WhatisHASHPARTITION
Views: 7649 Oracle World
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 7412 BhagyaRaj Katta
Examples on Oracle Database Auditing |  Oracle Database Security | auditing in oracle 11g
 
21:15
This is the part of the series "Oracle DBA Videos" on Oracle Database Security. The following topics are covered in practical -- General idea about database auditing -- Statement level auditing -- Privilege level auditing -- Object level auditing
Views: 13347 Wysheid Wysheid
How to corrupt a block and how to recover it
 
11:34
In this session i'm going to discus with you How to corrupt a block and how to recover it step by step
Views: 3339 OCP Technology
when checkpoint will occur in oracle database
 
14:13
How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 3902 Praveen Biyyapu
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: 5905 Ramkumar Swaminathan
What is High Water Mark(HVM) in oracle and how it effects the performance of queries?
 
05:41
This video tutorial is to understand the concept of a High Water Mark or HVM of a oracle table, also it states the various changes in the HVM when we perform a insert, delete and Truncate operation on the table, and the video also informs why is the truncate operation more advisable and optimized then the delete operation.
Views: 4063 Kishan Mashru
Oracle I:O Architecture
 
03:21
Oracle I/O Architecture watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
Reorganizing Tables in Oracle
 
07:45
The clip explains why reorganizing of tables may or may not be required and how to do it. Text version is here: https://uhesse.com/2010/08/23/reorganizing-tables-in-oracle-is-it-worth-the-effort/
Understanding And Resolving Oracle CBC Wait/Latch Contention - Introduction
 
07:10
Understanding And Resolving Oracle CBC Wait/Latch Contention When a server process needs to access a buffer it must access the cache buffer chain (CBC) structure to determine if the buffer is already in the buffer cache. With just the right workload mix, performance can be a problem. Learning about the relevant Oracle internals and how to diagnose and solve CBC performance problems is what this seminar is all about. For more information go to www.orapub.com
Views: 1126 OraPub, Inc.
Hints and Tips - Queries running whilst exchanging partitions - part 1
 
01:44
Even when you rip out a partition from a table, queries can still execute successfully. ========================================­­­­============== Copyright © 2015 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: 958 Connor McDonald
Which row in which datafile?
 
08:40
Oracle Database 11g, Rowid, datafile
Views: 596 Mahir M. Quluzade
Oracle Internals  A Close Look at the CBO Trace
 
31:15
Oracle 10053 Trace, Cost-based Optimizer Trace Review
Views: 818 Dan Hotka
Managing Oracle Database In-Memory
 
31:15
In this second of three presentations, Maria Colgan explains how to control which objects get populated into the column store and how to monitor the performance of queries against the column store.
Heat Map in Oracle Database 12c
 
06:24
Heat Map is a new feature in Oracle Database 12c. It allows you to track data access at the segment level and data modification at the row and segment level, so you can identify the busy segments of the system
Views: 202 Koenig Solutions
[오라클 기초 강좌] 14 - 테이블 관리 및 활용 - 테이블 생성/변경/제거, 칼럼 제거, Row Chain, Row Migration, PCTFREE, PCTUSED
 
29:02
강의 자료(PDF) 다운로드: https://goo.gl/VZovDV 칼럼 제거 - 칼럼 제거 시 SET UNUSED COLUMN은 해당 칼럼의 데이터를 물리적으로 삭제하는 것이 아니라 사용하지 않는 칼럼으로 Marking 하는 것이다. DROP UNUSED COLUMNS는 UNUSED로 Marking 된 모든 칼럼들을 DROP 한다. Row Chain & Row Migration - Row Chaining이란 Data Block 하나에 전부 입력할 수 없는 Row가 여러 Block에 걸쳐서 입력되는 것을 말한다. - Row Chain이 발생 하면 Chain이 발생한 Row를 조회 시 하나 이상의 Block에 대해 I/O가 발생하므로 성능을 저하 시키는 요인이 된다. - 이러한 Row Chaining 현상은 해결하기 위해 Row Migration이라는 기법을 이용한다. (일부 저장 용량의 손실을 감수 하더라도...) - Row Migration이란 Block 하나에 전부 입력할 수 없는 Row를 다른 Block으로 옮겨서 입력하는 것을 말한다.
Views: 1693 최용진
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: 11363 Oracle Midlands
8.How to expdp/impdp Data_only in oracle
 
07:03
Hi guys today i explain how to take exported backup of data_only and how to import into other schema. #Data_only #expdp/impdp Oracle database Unbeatable,Unbreakable Platform..
Views: 1899 Oracle World
pct free, oracle storage,dba videos from cpisolution.com
 
02:30
understand pct free...what is pct used etc...used in dictionary managed tabelsapce and when segment management is manual..in locally managed tablespace.. oracle dba block and storage
Oracle High Water Mark
 
02:31
A Brief video about Oracle's Table High Water Mark and How to resolve issues associated with it Music: https://www.bensound.com
Views: 369 ORA-600
Oracle Database Administration Online Training
 
04:21
Feel free to contact Call : +91-8870903864 Or E-mail [email protected] Oracle Database Adminstration INTRODUCTION TO ORACLE DBA What is DBA ? • Why a Company needs a DBA? • Roles & Responsibilities of DBA • Oracle Architecture • Physical and Logical Phase of Database • Types of files(Control file, Redolog file and Datafile) • Different types of Datafiles • Instance • SGA(System Global Area) and Background Process • DATABASE CREATION • Different Startup Modes • Different Shutdown Modes • Types of Database Creation • Manual Method of Creation • TABLESPACE MANAGEMENT Introduction to Table space • Types of Table space(BIG & SMALL) • Temporary Table space • Altering/Renaming a Table space • Renaming a data file • Temporary Groups • Table space Encryption(11g) • STORAGE PARAMETERS • What are segments? • What are extents? • What is Blocks? • Oracle Blocks • Estimation of Extents • Dictionary Managed Table space • Locally Managed Table space • Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease) • USER MANAGEMENT • Who are Database Users? • Why to create a User? • Creation of Users • Assigning Privileges • Creating and granting Roles • Allocating table space Quotas to Users • Assigning default table space for the Users • Setting Profiles for the Users • Levels of Authentication • Schema Management(11g) • Security(11g) • UNDO MANAGEMENT • What is Undo? • Why Undo required? • Pending offline status • Brief idea about Rollback segments • Flashback Features • Flashback Table • Flashback query • Flashback Version query • What is spfile? • Difference between spfile and pfile • Advantages of spfile • What is OMF? • Advantages of OMF • Files conventions of OMF • NETWORKING IN ORACLE • Introduction to Oracle Networking • Network default location • Editing Network file • Tnsnames.ora Introduction to Database Links • Types of Database Links • Introduction to Materialized views • Advantages of Materialized view • Refresh Modes • REDO-LOG & CONTROLFILE MANAGEMENT Introduction to Redo log • Status of Redo logs • Multiplexing the Redo log files • Re-creation of Control file • Renaming the Database • Multiplexing the Control file • LOGICAL BACKUP What is a logical backup • Why it is required • Export/import Utility • Data Pump • Difference between Data Pump and Traditional Export/import • Impdp/expdp • Transportable Table spaces • PHYSICAL BACKUP Introduction to Physical backup • Types of Physical backup • Cold & Hot backup • Recovery scenarios • RMAN backup • RMAN Point in time recovery • RMAN 11g new features • PEFORMANCE TUNING What is Performance Tuning? • Why Tuning required? • Types of Tuning • Database Tuning • Tuning • SQL Tuning • Memory Tuning Network Tuning • Partitioning and Indexes • Partitioning Enhancements • AWR/ASH/ASMM/ADDM • RAT(Real Application Testing)(11g) • SQL Performance Analyses (11g) • Row chaining and Row migration • Resemble Table spaces Oracle Database Adminstration training online, Oracle Database Adminstration training material, IBM Websphere Application Server training cost, Oracle Database Adminstration training pdf, Websphere Application Server training in USA uae India, Oracle Database Adminstration training, online Corporate training malaysia Singapore, Oracle Database Adminstration software, Oracle Database Adminstration training in bangalore, Oracle Database Adminstration training institutes in hyderabad, Oracle Database Adminstration training in chennai, Oracle Database Adminstration training in hyderabad, Delhi, Mumbai, Pune, Oracle Database Adminstration, IBM Websphere ApplicationServer webinar, online training singapore, Oracle Database Adminstration eam, Oracle Database Adminstration as a service,Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training maximo scheduler, Oracle Database Adminstration (consumer product) Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training Oracle Database Adminstration online Training , Post Training Support
Views: 11 Trainers Online
Oracle Midlands #2: ASH Architecture and Advanced Usage - Graham Wood
 
01:00:59
The first talk from Oracle Midlands #2 (25th March 2014) was Graham Wood talking about ASH and it's usefulness in diagnosing performance problems. Graham kindly gave permission for me to share the video here. The PDF is available at https://www.dropbox.com/sh/z0jbvfqdv2tc1yq/3a6Hwpsp-P This event was sponsored by Red Gate (http://www.red-gate.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: 3462 Oracle Midlands
7.Convert Dumpfile into SQLfile EXPDP & IMPDP
 
19:47
Hi friends today its very important topic in oracle how to convert .DMP file into .SQL format and modified it and used that file. #DumpfileintoSQLfile #EXPDP&IMPDP Oracle database Unbeatable,Unbreakable Platform..
Views: 2312 Oracle World
Module 1- Introduction to Oracle Database
 
13:39
Hello viewers, We are starting our section on professional courses and for which we are starting our course material which is based on the Oracle Database, Please refer to the description below for knowing which topics will be covered in Oracle DBA Installation Module 1 – Introduction to Database • Introduction to Database • How ORACLE DB does it • Unix kernal Module 2 – Physical Database Structure • Physical Database Structure • Control files • Key information of files • Redo log files Module 3 – Oracle Storage structures • Oracle Storage structures • Table statement • How to check “create table” • Schemas and schema objects • Data blocks • Extents • Segments Module 4 – Memory & Process Architecture • Memory & Process Architecture • Instance/Memory structures • Shared pool • Buffer Cache • Redo Log Buffer • Process Architecture • Background process Module 5 – Background Process, Alert & Trace files • Background Process, Alert & Trace files • Alert • Trace files Module 6 – Database Startup & Serving User Requests • Database Startup & Serving User Requests • Offline backup • Standby Database Module 12 – Oracle Recovery Manager (RMAN) • Oracle Recovery Manager (RMAN) • Data pump export & import • SQL loader • External table Module 13 – Data dictionary & Dynamic Performance Tables • Data dictionary & Dynamic Performance Tables • Dynamic performance Tables • Typical day ORACLE DBA Module 14 – Introduction to Database Tuning • Introduction to Database Tuning • Monitor space usage • Monitor SQL scripts • Data base tuning • SQL tuning • Table Statistics • Index statistics • Index Selectivity • Chained Rows • Locks Module 15 – Introduction to Database Tuning Continued • Introduction to Database Tuning Continued • Tuning Shared pool • Data dictionary performance • Data dictionary tuning • PL/SQL code • Code reuse • Data base Buffer • Buffer cache hit Ratio • Code reuse • Database Startup • User process, Server process Module 7 – Database Security • Database Security • Process of “Create User” • Alter & Drop User • Resource Limits & profiles • Auditing Module 8 – Schema Objects • Schema Objects • Types of schema objects • How table data is stored • Temporary Tables • External Tables Module 9 – Schema Object Continued • Schema Object Continued • Materialized View • Sequence Generator • Indexes • B-Tree index structure • Cluster/Hash Cluster • Data concurrency & consistency • Locking • Deadlocks Module 10 – Oracle Network Environment • Oracle Network Environment • How to connect your database • Network environment of ORACLE • Database link Module 11 – Oracle Backup & Recovery Concepts • Oracle Backup & Recovery Concepts • Standby database • Testing • Media recovery options so in today's video, we will be discussing Module -1 The Introduction to Oracle Database. ----------------------------------------------------------------------------------------------------------- For downloading notes in PDF format please visit my Blog https://thedynamicstudy.blogspot.com/ ---------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------- Please go through the video and don't forget to share your views and subscribe the channel to keep the content open and reachable to students. ---------------------------------------------------------------------------------------------------- keep on watching, keep on learning! #dynamicstudy -~-~~-~~~-~~-~- Please watch: "OCTAPACE - Detailed Explanation in Hindi" https://www.youtube.com/watch?v=f_4WET6y49c -~-~~-~~~-~~-~-
Views: 124 Dynamic Study
Oracle Database Administration-  UNDO MANAGEMENT
 
01:43:46
Oracle Database Administration- UNDO MANAGEMENT
Views: 97 SooCloudy
Histograms Pre-12c and now
 
43:45
Anju Garg is an Oracle Ace Associate with over 12 years of experience in IT Industry in various roles. Since 2010, she has been involved in teaching and has trained more than a hundred DBAs from across the world in various core DBA technologies like RAC, Data guard, Performance Tuning, SQL statement tuning, Database Administration etc. She is a regular speaker at Sangam and OTNYathra.  She also writes articles for All Things Oracle. She is passionate about learning and has keen interest in RAC and Performance Tuning. She shares her knowledge via her technical blog at http://oracleinaction.com/ ABSTRACT--- To improve optimizer estimates in case of skewed data distribution , histograms can be created. Prior to 12c frequency and height balanced histograms could be created.  if no. of buckets >= NDV, frequency histogram is created and the optimizer makes correct estimates. If no. of buckets < NDV, height balanced histogram is created and accuracy of optimizer estimates depends on whether a key value is an endpoint or not. The problem of optimizer misestimates in case of height balanced histograms is resolved to a large extent in Oracle Database 12c by introducing top-frequency and hybrid histograms which are created if no. of buckets < NDV. This webinar explores Pre as well post 12c histograms while highlighting the top-frequency and hybrid histograms introduced in Oracle Database 12c.
8.oracle world-FLASHBACK Guaranteed Restore Point
 
09:06
HI friends today i give you a brief scenario how to create flashback guaranteed restore point for TABLE-LEVEL RECOVERY. #GuaranteedRestorePoint #FLASHBACK Oracle database Unbeatable,Unbreakable Platform..
Views: 3601 Oracle World
How to Convert a Non-Partitioned Table to Partitioned using Oracle Database 12c R2
 
05:02
Oracle Database 12c Release 2 New Feature! Learn how to convert a non-partitioned table to a partitioned table - Online! This new method - using ALTER TABLE MODIFY - is much simpler than DBMS_REDEFINITION. In this free tutorial from SkillBuilders and Oracle Certified Master DBA John Watson you'll see a demonstration of converting the table and the impact on the underlying table and indexes. See all our free Oracle Database Tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3704 SkillBuilders
18c XE will blow your mind
 
03:38
Highlights from the June DBA Office Hours session. blog: https://connor-mcdonald.com - Subscribe as new tech videos come every week!
Views: 2993 Connor McDonald
Oracle Data Guard part2: Configuring Data Guard Broker and Switching over to Standby Database
 
17:01
Data Guard Broker can simplify the management of Oracle Data Guard Configuration. There few simple steps to configure the DG Broker. In this Video I have demonstrated switching over from primary ro standby and standby to primary database back and forth.
Views: 674 Oracle Testlab
Best SQL Enhancement, Worst Database, Improved Skills
 
05:55
SQL Developer Advocate Chris Saxon talks about the best SQL enhancement in 20 years, discusses fixing the worst database in the world, and shares details on a new, free SQL course for developers, available at https://devgym.oracle.com Also see: https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 142 Oracle Developers
Oracle 11g Pro Performance Tuning Ls 4: Pctfree parameter
 
19:47
In this tutorial you will learn how to improve oracle 11g performance by using PCTFREE parameter.
Views: 711 DBA Pro
Effect of Oracle Block Space Utilization on Performance
 
13:14
Demonstrates the effect of Oracle block space utilization parameters on bulk query operations - a higher PCTFREE spreads the data out over more blocks, thereby making bulk reads slower.
Views: 3581 Stephen Frein
What is a HashTable Data Structure - Introduction to Hash Tables , Part 0
 
07:37
This tutorial is an introduction to hash tables. A hash table is a data structure that is used to implement an associative array. This video explains some of the basic concepts regarding hash tables, and also discusses one method (chaining) that can be used to avoid collisions. Wan't to learn C++? I highly recommend this book http://amzn.to/1PftaSt Donate http://bit.ly/17vCDFx STILL NEED MORE HELP? Connect one-on-one with a Programming Tutor. Click the link below: https://trk.justanswer.com/aff_c?offer_id=2&aff_id=8012&url_id=238 :)
Views: 812638 Paul Programming
Hints and Tips - Avoiding never ending locks - part 2
 
03:57
Row locking is a critical component of ensuring the integrity of your data inside the database. But locks of extended duration can easily create system-wide problems in your applications. This quick tip gives you some ideas for handling locks better. ====================================================== Copyright © 2015 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: 808 Connor McDonald
7.ORACLE WORLD- FLASHBACK TRANSACTION QUERY
 
14:43
Hi guys today we will learn how to perform flashback transaction query to find out the DDL that performed by users. #FLASHBACKTRANSACTIONQUERY Oracle database Unbeatable,Unbreakable Platform..
Views: 1622 Oracle World
Memories from Sangam18 Conference | aioug
 
06:17
#aioug #sangam18 #oracle Largest Independent Oracle Users Group Conference in India We're hosting this year's Sangam (Sangam18 - 10th Annual Oracle Users Group Conference) in The Oterra on Friday 7th & Saturday 8th December 2018
Views: 191 AI OUG
oracle 12c admin training | oracle 12c administration online training | oracle rac tutorial
 
01:46
Website : https://www.abhijja.com Email [email protected] Phone + 91 9710018997 Oracle 12c Admin Online Training Concepts : Introduction Oracle Database Architecture Oracle Database Architecture: Overview Oracle Database Instance Configurations Connecting to the Oracle Database Instance Oracle Database Memory Structures Process Architecture Process Structures Process Startup Sequence Database Storage Architecture Managing the Database Instance Introducing Oracle Database Management Tools Understanding the Enterprise Manager Management Framework Logging in to Oracle Enterprise Manager Database Express Using the Enterprise Manager Database Express Home Page Using Enterprise Manager Cloud Control Using SQL*Plus Using SQL Developer Initialization Parameter Files Configuring the Oracle Network Environment Oracle Net Services Overview Oracle Net Listener Overview Establishing Oracle Network Connections Tools for Configuring and Managing the Oracle Network Using the Listener Control Utility Using Oracle Net Configuration Assistant Using Oracle Net Manager Using Enterprise Manager Cloud Control Managing Database Storage Structures Understanding Storage of Data Database Block Contents Exploring the Storage Structure Creating a New Tablespace Overview of Tablespaces Created by Default Managing Tablespaces Viewing Tablespace Information Using Oracle Managed Files Administering User Security Database User Accounts Predefined Administrative Accounts Creating a User Authentication Unlocking a User Account and Resetting the Password Privileges Roles Profiles Managing Data Concurrency Overview of Locks Locking Mechanism Data Concurrency DML Locks Enqueue Mechanism Lock Conflicts Managing Undo Data Undo Data Overview Transactions and Undo Data Storing Undo Information Comparing Undo Data and Redo Data Managing Undo Configuring Undo Retention Guaranteeing Undo Retention Changing an Undo Tablespace to a Fixed Size Implementing Oracle Database Auditing Separation of Responsibilities Database Security Monitoring for Compliance Standard Database Auditing Unified Audit Data Trail Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles) Configuring the Audit trail Specifying Audit Options Performing Database Maintenance Database Maintenance Viewing the Alert History Terminology Automatic Workload Repository (AWR) Statistic Levels Automatic Database Diagnostic Monitor (ADDM) Advisory Framework Enterprise Manager and Advisors Managing Performance Performance Monitoring Tuning Activities Performance Planning Instance Tuning Performance Tuning Methodology Performance Tuning Data Monitoring Performance Managing Memory Managing Performance: SQL Tuning SQL Tuning Oracle Optimizer SQL Plan Directives Adaptive Execution Plans SQL Advisors Automatic SQL Tuning Results Implement Automatic Tuning Recommendations SQL Tuning Advisor Simplifying Management Tasks Understanding a Simple Job Core Components Basic Work Flow Persistent Lightweight Jobs Using a Time-Based or Event-Based Schedule Creating a Time-Based Job Creating an Event-Based Schedule Managing Space Space Management Overview Block Space Management Row Chaining and Migration Free Space Management Within Segments Types of Segments Allocating Extents Allocating Space Creating Tables Without Segments Backup and Recovery Concepts Categories of Failures Flashback Technology Understanding Instance Recovery Phases of Instance Recovery Tuning Instance Recovery Using the MTTR Advisor Media Failure Configuring for Recoverability Moving Data Moving Data: General Architecture Oracle Data Pump SQL*Loader External Tables Working with Oracle Support Researching an Issue Logging Service Requests Managing Patches Applying a Patch Release oracle 12c admin training,oracle 12c administration training, oracle weblogic 12c administration training, oracle rac tutorial,how to configure oracle rac, how to setup oracle rac, how to convert to oracle rac, oracle rac training in pune, oracle data gard training in pune, oracle oca training in pune, oracle dba 12c training, 12c oracle rac, how to migrate to oracle rac, oracle real application clusters, oracle rac, oracle asm concepts, automatic storage management, oracle database 12c, oracle 12c webinar, 12c
Views: 274 Today Courses
Public and Private Synonyms
 
03:56
What are private and public synonyms and how do they work? And what privileges do they convey onto the objects that are referenced by them? Highlights from my Office Hours session blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week music: bensound.com
Views: 421 Connor McDonald