Home
Search results “Create awr snapshot oracle”
AWR Report Generation
 
09:32
#Oracle #AWR Generating and viewing an AWR Report. (Note : Usage of AWR requires the Diagnostic Pack Licence !) Also see video "AWR with SQLDeveloper" https://youtu.be/QNICuRuBnZo For examples of interpreting an AWR report search https://hemantoracledba.blogspot.com for "AWR"
Views: 23110 Hemant K Chitale
AWR with SQLDeveloper
 
07:25
#Oracle #AWR Using SQLDeveloper (Note : Usage of AWR requires the Diagnostic Pack Licence !) For examples of interpreting an AWR report search https://hemantoracledba.blogspot.com for "AWR"
Views: 7865 Hemant K Chitale
Creating snapshots and Express Protect backup for Oracle databases
 
03:48
This video demonstrates the process to create snapshots and Express Protects for Oracle databases
Views: 2265 HPE Technology
creating snapshot standby of oracle 11g dataguard using SQL commands
 
05:12
This video discuss the steps for creating snashot standby of oracle 11g dataguard using SQL commands, in details This video is presented by Wysheid. Visit us at www.wysheid.com
Views: 4090 Wysheid Wysheid
Real-World Performance - 19 - Architecture with an AWR Report
 
21:38
Check out the entire series on the Oracle Learning Library at http://www.oracle.com/goto/oll/rwp In this video, listen and watch Graham Wood, Architect and Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as they explain and analyze the information gathered via an AWR Report from a large internet retailer and how that affects performance. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Cloning a PDB using ACFS Snapshots
 
11:35
This demonstration shows you how to create a RAC-enabled CDB stored on ACFS. Then the demonstration shows you how to quickly clone an existing PDB using the SNAPSHOT COPY capability of ACFS.
Views: 2335 Jean-Francois Verrier
oracle data guard | snapshot standby database oracle dataguard |  oracle standby database
 
11:31
This video discuss in detail about the configuartion of snapshot standby database feature in Oracle 11g
Views: 7806 Wysheid Wysheid
Performance Tuning with ASH and AWR Data
 
01:03:05
Presented by Kellyn Pot'Vin 30 August 2012 Summary: Since their introduction with Oracle 10g, AWR and ASH data has offered the Database professional enhanced performance reporting capabilities that previously were only gleamed via statspack and reporting queries. In this webinar, Kellyn Pot'Vin, Senior Technical Consultant at Enkitec, will take you through the requirements, reporting basics and differences of AWR and ASH. You will learn: - Reasons to use both reports. - A firm understanding of each report and its format. - Knowledge of the differing versions of the AWR report and when best utilized. - The power of ASH Reporting in real-time trouble-shooting. - Ability to utilize the reports at the command line and from Enterprise Manager. A live Q&A session with Kellyn Pot'Vin follows the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 112940 Redgate Videos
Learn about Flashback Database and DataGuard in Oracle Data Guard Part 2 from GogoTraining
 
21:17
http://gogotraining.com, 877-546-4446, sign up for a free account and watch all the preview videos for free! In this video from Oracle Data Guard Part 2 from GogoTraining, you will learn about using flashback database instead of apply delay, recover the database from a prior point in time, use real-time apply, and take a quiz. http://gogotraining.com, 877-546-4446, sign up for a free account and watch all the preview videos for free!
Views: 1451 GogoTraining
Oracle Database 11g Replay Workload
 
11:29
You can use Database Replay to capture a workload on the production system and replay it on a test system with the exact timing, concurrency, and transaction characteristics of the original workload. This enables you to test the effects of a system change without affecting the production system. Database Replay supports workload capture on a system running Oracle Database 10g Release 2 and newer releases. In order to capture a workload on a system running Oracle Database 10g Release 2, the database version can be 10.2.0.4 or higher. Workload replay is only supported on systems running Oracle Database 11g Release 1 and newer releases.
Views: 4567 CLEO & CUQUIN
Oracle 11g Streams:  Two-Database Replication Environment with Synchronous Captures
 
11:47
Use this configuration when you want to configure a relatively simple replication environment that only involves two databases and a small number of tables. You might also choose to use synchronous captures if you have Oracle Database 11g Standard Edition. To use capture processes, you must have Oracle Database 11g Enterprise Edition.
Views: 36918 CLEO & CUQUIN
Oracle 11g Data Guard(concepts, new dg features): A Complete Look At DG Technology Tutorial 1
 
01:42:34
In this tutorial you learn about oracle data guard concepts. You will also learn how to setup data guard features through hands-on demos.
Views: 10787 DBA Pro
How to install and use Oracle Statspack
 
02:39
This video shows how to install and use Oracle Statspack.
Views: 454 PureDBA
Oracle Automatic Workload Repository AWR And Active Session History ASH Tutorial 1
 
59:25
In this tutorial you will learn about automatic workload repository/AWR and active session history/ASH in oracle.
Views: 18246 DBA Pro
Snapshot of a session on Oracle Database Architecture at Trendz IT
 
02:46
The session is taken by Ms. Aarti Thapar at Trendz IT. She has 16+ year of experience in Oracle technologies. For more information on other training based on Oracle visit the page trendzit.net
Views: 680 Trendz IT
How to Collect STATSPACK
 
01:13
Views: 531 Ray Wong
5.Overview Switchover on Oracle Data Guard 11g
 
17:43
Hi friends today I'am going to show you overview of switchover in DATA GUARD 11g release Role conversion #DataGuard #Switchoveroverview Oracle database Unbeatable,Unbreakable Platform..
Views: 3599 Oracle World
What is a Materialized View?
 
06:10
http://zerotoprotraining.com This video explains the concept of a materialized view in a database also known as materialized query table an indexed view. Category: Databases Tags: Materialized View
Views: 108217 HandsonERP
Oracle materialized view refresh fast on commit
 
08:45
The tutorial presents how to create materialized view log and materialized view on commit refresh in Oracle. More free tutorials video, visit http://www.learn-with-video-tutorials.com
SQL Developer 3.1 - How to Create a Report
 
02:11
This demonstration will show how to create a report. This video is part of the Report Features series. Search for SQL Developer Reports to view all the videos in the series. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Oracle Data Guard - Backup Primary Database
 
05:10
Oracle Data Guard - Backup Primary Database
Views: 170 The Silent DBA
Data Pump,  Oracle DBA, export whole schema and import selected objects, 1e18
 
09:44
How to use datapump to export whole schema
Views: 30122 hammadshams
Oracle Enterprise Manager 12c: Use Real-Time ADDM
 
06:04
This demonstration shows you how to analyze your current database performance when it is hanging or running slow using real-time ADDM in Oracle Enterprise Manager Cloud Control 12c. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Oracle DB 12c - Real Time ADDM
 
08:41
Oracle DB 12c - Real Time ADDM Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
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 DBA Justin - How to create a basic Dataguard physical standby database # 1 of 3
 
21:47
How to create a basic Dataguard physical standby database # 1 of 3
Views: 57657 jbleistein11
1Z0-054 – Oracle Exam Database 11g Test Performance Questions
 
00:59
For more information on Oracle 1Z0-054 Practice Test Questions Please Visit: https://www.Pass-Guaranteed.com/1Z0-054.htm What am I going to be tested for? The 1Z0-054 Database 11g: Performance tests if you can use statistics, outlines and profiles to influence the optimizer, improve and rebuild indexes using the SQL Advisors. Also 1Z0-054 test your knowledge on the DB Replay and SQL Performance Analyzer tools. Which are some of the topics of the 1Z0-054 Tuning exam? Test Topic 1: Basic Tuning Tools Questions (Exam Coverage 15%) Test Topic 2: Identifying Oracle SQL Statements Test Questions (Exam Coverage 21%) Test Topic 3: Using Metrics and Alerts Questions (Exam Coverage 22%) Test Topic 4: Using Oracle Database Replay Questions (Exam Coverage 20%) Test Topic 5: Tuning the 1Z0-054 Shared Pool Questions (Exam Coverage 10%) Test Topic 6: Tuning PGA and Exam Temporary Space Questions (Exam Coverage 12%) Who can attend to Oracle Database 11g: Performance Tuning test? The 1Z0-054 Database 11g: Performance Tuning exam is mainly intended for Database Administrators, Support Engineer, and Technical Consultants who wish to optimize database workloads, lower IT costs and deliver a higher quality of service by enabling centralization within your Datacenter. Can you give me some in-depth information on the 1Z0-054 exam topics? • Use Enterprise Manager Monitoring • Create and manage Oracle 1Z0-054 AWR snapshots • Interpret metric views and alerts • Analyze Active Session 1Z0-054 Exam History (ASH) reports • Describe SQL statement processing test • Set up and use SQL plan baseline • 1Z0-054 SQL Tuning Advisor • Diagnose PGA memory issues and size the PGA What’s the 1Z0-054 passing score and duration? The duration of this exam is 135 minutes (80 questions) and the minimum passing score is 70%
Views: 128 Oliver Oscar
DB Snap Clone on Exadata
 
08:57
In this screenwatch you’ll learn how to create a read only test master of a non-pluggable database, and then use that test master to create a snap or thin clone of the database. The Snap Clone resides on Exadata storage just like the pluggable database, thus allowing it to take full advantage of all the unique innovations of Exadata, such as smart scan and hybrid columnar compression.
Hot cloning and refreshing PDBs in Oracle 12cR2
 
08:13
The clip explains and demonstrates two 12cR2 New Features: Hot Cloning of a PDB and refeshing a PDB. A text version is here:
Oracle Analytical Queries
 
00:09
Oracle Analytics
Views: 927 Ritesh Raj Singh
Create a standby snapshot database: step 2
 
04:38
Step 2 to create and configure a standby snapshot database
Views: 209 Tamal Chatterjee
Oracle 11g Data Guard(fal_server,fal_client): A Complete Look At DG Technology Tutorial 5
 
50:05
In this tutorial you will learn about the fal-server and fal-client parameters. you will also learn about processes, procedures, components for primary database, physical standby, snapshot standby and logical standby databases.
Views: 1505 DBA Pro
Streamline Cloning Oracle Databases for Development and Testing
 
14:25
For DBAs looking to streamline the process of cloning a database for development and test efforts, the Oracle Snap Management Utility (SMU) for Oracle Database may help solve that need. The SMU software coordinates storage cloning from the Oracle ZFS Storage Appliance with the process to mount the new clone to a database host from a single interface. Take cloning for development databases from weeks to minutes and accelerate dev/test with SMU. Scott Ledbetter, Oracle Application Integration Engineer, shows how to easily clone an Oracle database instance using the Oracle Snap Manager Utility for Oracle Database. To learn more and obtain a free trial, go to http://oracle.com/storage/nas/snap/index.html. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Oracle DBA Lite: an introduction to Oracle administration, part 6
 
14:19
CAPTIONS AVAILABLE - Disaster recovery.
Views: 7310 roughsealtd
Active data guard in Oracle 11g | Read only standby database |  Real time queries
 
05:00
This video discuss in detail about the active dataguard feature of Oracle 11g
Views: 5387 Wysheid Wysheid
New Oracle DBA Career: 1. Introduction
 
10:16
I don't know everything about being an Oracle DBA, but I do know how to get your foot in the door. This channel is dedicated to helping people who want to become an Oracle DBA. This is the intro video. Just some links I thought was interesting about Oracle DBA http://money.cnn.com/magazines/moneymag/bestjobs/2010/snapshots/7.html http://www.itcareerfinder.com/brain-food/it-salaries/database-administrator-salary-range.html http://www.cse.psu.edu/~groenvel/dba.html https://www.onlinedbaacademy.com
Views: 17898 Online DBA Academy
ACFS Snapshot
 
09:01
ACFS Snapshot
Views: 2238 Ritesh Raj Singh
Oracle Exadata X6: Technical Deep Dive - Architecture and Internals
 
01:02:37
Oracle Exadata X6: Technical Deep Dive - Architecture and Internals Take a plunge into the technical details of the latest Oracle Exadata X6. This session describes what has been done to enhance Oracle Exadata and its integrated database architecture, and how to take maximum advantage of some of the new capabilities. This session examines in detail Oracle Exadata hardware and software architecture, database extensions for Oracle Exadata, I/O resource management, Oracle Exadata's Smart Scan and Smart Flash Cache features, as well as snapshot and virtualization capabilities.
Views: 17399 Drs. Albert Spijkers
How to Easily Identifying Oracle Locks
 
02:10
How to Easily Identifying Oracle Locks. For more information, please go to: http://www.embarcadero.com/products/dbartisan-xe
Views: 2074 DBPowerStudio
Oracle Data Guard Tutorial - Advanced Techniques (Part 4 of 4)
 
07:19
Part 4 of SkillBuilders Tutorial "Beyond Data Guard". In this segment Oracle Certified Master DBA John Watson discusses and demonstrates The Read Mostly Database and using Data Guard to enhance performance by using the Standby Database for Query and directing DML to the Primary. For more see www.SkillBuilders.com/DataGuard. John: Now, the last topic. I've just got time to dealing with this. The last topic I want to look at is - I'd like to call it the read mostly database. This is a very nice technique. We're getting even more value out of your physical standby because remember what I've talked about before? When you open your database read-only you can write a very limited amount of data, basically only temporary data. Opening it read-write to the snapshot standby, yes, it's read-write but then you're not applying the redo so it's no longer valid as a real time data warehouse. The read mostly database is a compromise between the two. So it adds even more value ideally to Active Data Guard. It would function without Active Data Guard license but Active Data Guard is where you're going to get most benefits of this. This is where we've come to that low balancing question we had earlier. If you have say two applications, perhaps one application is your standard OLTP application. The other application is your query application. Maybe you've got business objects or discoverer. Business objects applications, discover applications, they're read intensive. They run massive queries. But they also do an occasional bit of DML. Not much, but they do enough to mean you cannot run them against read-only database in many circumstances. So what we need to do is redirect the small amount of DML to the primary while running all heavy weight queries against the standby. In a way, that means your application doesn't even know it's happening. How can I do that? I can do it like this. On my primary, as we see on the slide, send them some database links. So, on my primary which is Madrid, I'll begin by creating a user. I do need to start manage recovery here. So I cancelled recovery, I opened a database, let apply going. I'm about to connect to a user I haven't even created.
Views: 2702 SkillBuilders
Oracle DB 12c - SQL Enhancements
 
17:34
Oracle DB 12c - SQL Enhancements Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
6.Overview Failover on Oracle Data Guard 11g
 
20:03
Hi guys today we learn how to perform automatic Failover in data guard broker configuration using DGMGRL. #DataGuard #Failover Oracle database Unbeatable,Unbreakable Platform..
Views: 3453 Oracle World
Oracle Performance Monitoring in less than 12 minutes 20 part 2/2
 
06:41
CAPTIONS AVAILABLE - Part 2 - How to install the (free) statspack utility and how some web resources can help you generate the reports you need for proactive monitoring.
Views: 11437 roughsealtd
Oracle SQL Tuning - Explain Plan Lies?
 
08:20
Do you use EXPLAIN PLAN to tune Oracle SQL? Does it always "tell the truth", or does it "lie". (Maybe it's not the whole truth!) In this free tutorial from SkillBuilders' Oracle Certified Master John Watson, you will learn why the execution plan generated by EXPLAIN PLAN can be misleading and what to do about it. After a brief lecture, John demonstrates exactly why. You'll hear about dynamic sampling, adaptive cursor sharing (11g), adaptive execution plans (12c) and of course, bind variables. John demonstrates how bind variables cause misleading execution plans using dbms_xplan.display and dbms_xplan.display_cursor. To get the most from this tutorial, you should have some understanding of hard parse, soft parse, cardinality, histograms. See all SkillBuilders FREE Oracle Database tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3474 SkillBuilders
switchover role primary to standby and vice versa in Oracle 11g R2 | Part-6
 
08:59
In this tutorial i'm going to show you how to switch-over role primary to standby and vice versa in Oracle 11g R2 #dataguard #switchover #primary #standby #oracle11gR2 website:- www.ocptechnology.com
Views: 7942 OCP Technology
Learn about Using Grid to Create a Logical Database in Oracle Data Guard Part 1 from GogoTraining
 
21:13
http://gogotraining.com, 877-546-4446, sign up for a free account and watch all the preview videos for free! In this video from Oracle Data Guard Part 1 from GogoTraining, you will learn how to set up the logical standby database, configure the logical standby database, create the standby database with grid, and take a quiz. http://gogotraining.com, 877-546-4446, sign up for a free account and watch all the preview videos for free!
Views: 360 GogoTraining
Step by Step guide to build dataguard in Oracle 11g
 
01:18:25
Step by Step guide to build dataguard in Oracle 11g
Views: 12018 sadia appsdba
Oracle DB 12c - Automatic Diagnostic Repository
 
09:44
Oracle DB 12c - Automatic Diagnostic Repository Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited