Home
Search results “Oracle tablespace temp usage”
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: 14858 Ramkumar Swaminathan
Tablespaces in oracle database
 
08:27
This video will give you basic idea about tablespace issue. Plese find the following important query . Query to check tablespace usage ============================================== select a.TABLESPACE_NAME, a.BYTES bytes_used, b.BYTES bytes_free, b.largest, round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used from ( select TABLESPACE_NAME, sum(BYTES) BYTES from dba_data_files group by TABLESPACE_NAME ) a, ( select TABLESPACE_NAME, sum(BYTES) BYTES , max(BYTES) largest from dba_free_space group by TABLESPACE_NAME ) b where a.TABLESPACE_NAME=b.TABLESPACE_NAME order by ((a.BYTES-b.BYTES)/a.BYTES) desc; To check datafiles respective to tablespace_name. ======================================================== col tablespace_name format a30; col file_name format a40; SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES where TABLESPACE_NAME='&tablespace_name'; To check ASM disk group usage ======================================== select name, group_number, name, type, state, total_mb, free_mb from v$asm_diskgroup; Please comment , like, subscribe and reach me if you have any query. EmailId: [email protected] ================================================ Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 1066 ANKUSH THAVALI
TEMP In oracle
 
10:22
Views: 549 Sainora Annanagar
GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES
 
13:33
This video demonstrates the usage and working of GTT in oracle SQL. The video shows how internally oracle works with GTT, and also explains the working of ON COMMIT DELETE ROWS and ON COMMIT PRESERVER ROWS in oracle with easy examples.
Views: 10696 Kishan Mashru
Database Oracle Compress
 
01:21
Ini merupakan cara kompresing database oracle, video ini dibuat oleh Rony Ihsan, salah satu senior Technical Advisor Database.
Oracle Tablespace Management | Important Things Explained Under 5 Mins | Oracle DBA
 
04:39
Oracle DBA - Tablespace Management Explained Under 5 Mins.! (ASM) Managing Oracle Tablespace - Important Things Explained Under 5 Minutes - Oracle DBA Tablespace Management Important Things Explained Under 5 Minutes - Oracle DBA Thanks for Watching please Like, Subscribe and Share...
Views: 233 BoxCut Media
Oracle Administration Tutorial - Understanding Tablespaces and Datafiles (Theory).mp4
 
09:03
Oracle Administration Tutorial - Understanding Tablespaces and Datafiles
Views: 46970 maurice ford
Oracle Database Tutorial 63 : Introduction to Tablespace In Oracle Database
 
04:26
Introduction to tablespace in oracle database consist Brief intro of tablepsace, type of tablespace, Big and small file tablespace, intro of Data files in oracle By manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/tablespace-introduction-rebellionrider Previous Tutorial ► Indexes https://youtu.be/F5NrQYD4a9g ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 for E-mail address please check About section 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: 38115 Manish Sharma
Managing Schema Object - Database Oracle 10g
 
01:04:28
In this section, You will learn about Managing Schema Object in Database Oracle 10g
Views: 26 Diva Niqma
What is cursor in Oracle
 
04:13
What is cursor in Oracle
Oracle Database tutorial 67: How to create Tablespace using SQL Developer By RebellionRider
 
06:56
Learn (The easiest way)how to create tablespace in oracle database using Oracle SQL Developer GUI: SQL Developer trips and tricks tutorial ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/tablespace-using-sql-developer Previous Tutorial ► How to make SYS user Connection: http://bit.ly/how-to-create-new-connection-in-sql-developer ► Permanent tablespace https://youtu.be/vkwKZIssvfc ► Temporary Tablespace https://youtu.be/Hc_OXitKgWM ► Undo Tablespace https://youtu.be/HlSrHX7ffbI ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 for E-mail address please check About section 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: 33982 Manish Sharma
OracleTablespace Administration | Bigfile tablespace in Oracle - Creation and Management
 
08:42
This video is the part of Oracle Database Self learn Kit From Wysheid. In this video we discuss about the creation and management of bigfile tablespaces in an Oracle database
Views: 2452 Wysheid Wysheid
Temporary Table in Oracle  |GlobalTemporary Table in Sql|Advantages of Global Temporary Table in Sql
 
05:34
Temporary Table in Oracle | Global Temporary Table in Sql| Advantages of Global Temporary Table in Sql --------------------------------------------------------------------------------------------------------- use of global temporary table in oracle,advantages of global temporary table in oracle,local temporary table in oracle,how to use global temporary table in oracle procedure,create global temporary table in oracle,temporary, table, tables, global, oracle, sql, delete, create global temporary table, temporary tables, oracle sql, global temporary table in oracle, preserve, on commit, drop global temporary table, oracle pl/sql, global temporary table, sql insert data into temp table, difference between temporary table and global temporary table in oracle,limitations of global temporary table in oracle,oracle create temp table on the fly, sql tutorials for beginners, sql expert, sql expert tutorials, database, oracle, table, online training,insert into oracle,oracle insert into multiple rows,create table oracle,oracle 12c alter table add identity column,oracle create table default value sysdate,collections in oracle pl sql with examples,Oracle 12c, database, oracle database (software), sql, sql developer, sql tutorials, how to create database using dbca, how to create database in oracle,oracle cloud, database 12c, dba genesis,database services, database, create, 11g, dba, db, beginner, Please Subscribe My Channel
How to Check Tablespace Size in SQL Developer | Oracle SQL Developer Tips and Tricks
 
02:08
How to Check Tablespace Size in SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial for Beginners Oracle Tutorial How to Check Tablespace Size in SQL Developer How to Check Tablespace Size in Oracle SQL Developer How to Monitor Tablespace Size in Oracle SQL Developer How to Monitor Tablespace Size in SQL Developer how to check tablespace in oracle sql developer how to check tablespace size in oracle 12c how to check particular tablespace size in oracle how to check tablespace size in gb in oracle how to check tablespace name in oracle how to check freespace in tablespace in oracle 11g how to check tablespace size in oracle 11g how to check freespace in oracle database How to Check Storage of Tablespace Size in SQL Developer How to Check Storage of Tablespace Size in Oracle SQL Developer how to check tablespace in oracle how to check tablespace size in oracle 12c what is tablespace in oracle how to check tablespace in oracle sql oracle list tablespaces in schema how to find tablespace used by a user in oracle how to check particular tablespace size in oracle oracle create tablespace
Views: 1291 Oracle PL/SQL World
Creating Tablespace using Oracle Enterprise Manager
 
05:02
STEPS: 1. Login into Enterprise manager 2. click on server tab - tablespace 3. inside tablespace window you can found default tablespace Example Sysaux System Temp Undo Users Now we going to create our own table-space, To create a new tablespace just click create button on right hand side 4. Now enter Tablespace name, Select extent management type as: Local Type: you can select permanent , temp, undo NOTE: Permanent tablespace:- Data persistent beyond duration of a session or transcation, objects in permanent tablespaces are stored in datafile. Temporary tablespace:- It contain objects only for a session or transcation, objects are stored in temp files Undo tablespacee:- It store data permanently, it important role is to provide read consistency for SELECT statement. the ability to rollback a transcation if it is failed to commit. Status: read,write mode 5. Click on add button to add datafile give name for datafile, size then give ok Thank you for watching Blog:- http://ramprasath91.blogspot.in/
Views: 4434 TechWizard
Global Temporary Tables (GTT) in Oracle
 
02:27
This video shows how global temporary tables (GTT) can improve the performance of DML against tables holding temporary data. For more information see: https://oracle-base.com/articles/misc/temporary-tables PS. My PhD kind-of involved the sexual habits of cabbages, hence the vicious rumour spread my uncle Martin! Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Martin Widlake (my crazy uncle) Blog: https://mwidlake.wordpress.com/ Twitter: https://twitter.com/MDWidlake Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 7784 ORACLE-BASE.com
Using RMAN: backup - disaster - recovery demonstration
 
19:33
Demonstrates a simple usage of Recovery Manager in Oracle. Plan: 1. Backup a database. 2. Simulate a disaster. 3. Restore and recover the database. For more details please go to http://dba-presents.com/index.php/oracle/11-simple-disaster-recovery-scenario-with-rman-video
Views: 4369 DBA presents
DB2 Tips n Tricks Part 90 - How Classic Table Reorganization using Temp Tablespace cannot be stopped
 
06:04
How Classic Table Reorganization using Temporary Tablespace cannot be stopped.
Views: 735 DB2-LUW-ACADEMY
How to solve SQL Server Low Disk Space Issue in few minutes
 
07:24
Disk space issues are some of the most common issues that SQL Server DBAs have to face. The video shows how with SQL CheckUp the DBA can use the set up alerts, monitor disk space, drill down to the disk database files, see the files total and used space and find the quickest way to free the disk space under the time pressure. To understand why the disk space was used up so rapidly the DBA can jump to see the recent or historical performance counters for the drive, drill to the list of top IO consuming queries of the timeframes when the drive was experiencing the high activity. Also the DBA can see the charts of the drive and each drive database space usage trends.
Views: 20071 VgSQL
Oracle tutorial : Global Temporary Table In Oracle PL SQL
 
08:49
Oracle tutorial : Global Temporary Table In Oracle PL SQL create temp table sql This video will explain to you how to create Temporary Tables in Oracle Oracle tutorial : Global Temporary Table In Oracle 1)The data in such a table is stored only as long as the session or transaction lasts and is private for each session. 2)The definition is visible to all sessions. 3)After commit or disconnection, the data is lost but the definition of the table remains. 4)Indexes created on a temporary. 5)Scope of TRUNCATE command is a single database session. There is no effect of TRUNCATE on other sessions. 6)Foreign key constraints are not applicable in case of Temporary tables 7)Temporary tables cannot contain column of persistent collection type Syntax : CREATE GLOBAL TEMPORARY TABLE table_name ( column_name column_data_type … … ) ON COMMIT DELETE ROWS; CREATE GLOBAL TEMPORARY TABLE Emp ( id number(5) NOT NULL, name varchar2(50) NOT NULL, city varchar2(50) NOT NULL ) ON COMMIT DELETE ROWS INSERT INTO Emp VALUES (1, ‘Test1’, ‘city1’); INSERT INTO Emp VALUES (2, ‘Test2’, ‘city2’); INSERT INTO Emp VALUES (3, ‘Test3’, ‘city3’); SELECT COUNT(*) FROM emp; Result = 3 rows COMMIT; SELECT COUNT(*) FROM emp; Result = 0 rows For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond oracle temporary table create temporary table sql temp table
Views: 4233 Tech Query Pond
UNDO MANAGEMENT - MONITORING UNDO DATA
 
11:21
Hello friends in this video i am going to explain you to that how to administer the undo for retain the old values and help in recovery time. #UNDOMANAGEMENT #MONITORINGUNDODATA Oracle database Unbeatable,Unbreakable Platform..
Views: 3513 Oracle World
Créer Tablespace est Fichier de données
 
03:01
tablespace tablespace in oracle tablespace does not exist tablespace size in oracle tablespace usage in oracle tablespace is missing for table tablespace postgres tablespace encryption tablespace free space tablespace in db2 alter tablespace add datafile tablespace in oracle oracle tablespace management drop tablespace including contents ora-01950: no privileges on tablespace users grant unlimited tablespace to user create tablespace example create tablespace oracle ora-25153: temporary tablespace is empty drop tablespace oracle tablespace in oracle tablespace management in oracle 11g tablespace in db2 tablespace management tablespace encryption in oracle 11gr2 tablespace pgadmin tablespace in sql developer tablespace in oracle tutorial tablespace postgres tablespace point in time recovery step by step what is a tablespace how do you create a oracle tablespace how do you monitor the tablespace is 80 percent fu what is the difference between tablespace and a ta why do you take tablespace in backup mode when a user creates an object without a tablespace what is the minimum size for dictionary managed ta the data file belonging to the system tablespace i in db2 is there any way of checking to see what th tablespace tablespace usage tablespace oracle tablespace users tablespace size tablespace full tablespace fragmentation tablespace management tablespace definition tablespace report tablespace quota tablespace growth tablespace sysaux
Views: 123 Info technologie
Manage Oracle Tablespaces with Oracle Enterprise Manager 12C
 
03:37
Video tutorials on how Manage Oracle Tablespaces using Oracle Enterprise Manager 12C For more Database Administration articles and scripts go to www.aodba.com More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 7995 AO DBA
Shared Server Configuration in Oracle Database - DBArch Video 18
 
08:06
You will learn about the concept of Shared Servers and Dispatchers in an Oracle Database. This is a method of optimizing resources on the Database Server side when a user is connecting from a Thick Client ( application installed on a desktop). 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: 9468 Ramkumar Swaminathan
Create table space in Oracle 10g using toad
 
04:34
Creating table space in Oracle 10g using toad
Views: 11333 R.N.A. Creation
Simplified DBA-024-Password file
 
06:57
orapwd file=orapwSID password=welcome1 entries=5 what is use of password file.
Difference between shutdown normal shutdown immediate and shutdown abort
 
14:19
Difference between shutdown normal shutdown immediate and shutdown abort
Views: 3186 Wysheid Wysheid
DB2 Tips n Tricks Part 76  - How DMS Temporary Tablespace reduces concurrency of Reorganization
 
05:21
How DMS Temporary Tablespace reduces concurrency of Reorganization Solution: Use SMS Temporary Tablespace for Reorganization Do not use option USE in REORG Command Happy Learning & Sharing
Views: 869 DB2-LUW-ACADEMY
Create a New Tablespace with EM Express 12c
 
01:39
This video shows you how to create a test tablespace with Oracle Enterprise Manager Database Express 12c. Copyright © 2013 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.
HOW TO DISABLE USER PASSWORD SENSITIVITY IN ORACLE 11G
 
04:55
HOW TO DISABLE USER PASSWORD SENSITIVITY IN ORACLE 11G ======================================================= show parameter sec_case_sensitive_logon alter system set sec_case_sensitive_logon=false; create user pavan identified by pavan; grant connect,resource to pavan;
Views: 332 Praveen Biyyapu
Oracle 11g DBA Bangla Tutorial |Ch9_1-Managing Schema Objects | Database Management System |Training
 
27:03
See the Description for required source code and links Oracle DBA Tutorial Source Code of Oracle Database Training: https://drive.google.com/open?id=0Bz0MNaVyRm3lOFBQdE9EOWJFSnc Chapter-9 : Managing Schema Objects. In this chapter, you will know about oracle data types, types of constraints, create and modify table, create and modify index, temporary tables, customer database schema and schema object. The constraint, index and customer database schema is a important in oracle. Oracle DBA training including database design is special computer training designed online courses on Database Management System. It is fully bangla tutorial of Oracle 11g database administration. It will be much helpful for every database programmer and administrator. Subscribe this channel to watch my all tutorials on PHP, MYSQL, Javascript, Linux, Networking, Access Programming & Microsoft Office, C++, HTML, CSS. Oracle Database Administration PDF eBook Link : https://drive.google.com/open?id=0Bz0MNaVyRm3la2dYR1A1SlRiVlk All Source Codes & Required Documents together are found in the link: https://drive.google.com/open?id=0Bz0MNaVyRm3ldTUwaTd4cjVka0k Oracle DBA Tutorials: https://www.youtube.com/playlist?list=PLUYY2piVmub6bRM0ScQMNnbyH66yrh1cf Oracle - SQL Tutorial link: https://www.youtube.com/playlist?list=PLUYY2piVmub7QL0ET2_eg4D_SV3AOsPHT Channel Link: http://www.youtube.com/channel/UCT_fWLNX67sDH3W3FZ1wxLg?sub_confirmation=1 Required Document Link : https://drive.google.com/open?id=0Bz0MNaVyRm3lTWNhMURIbFV1MjA FB Page: https://www.facebook.com/BanglaTutorial24 FB Group: https://www.facebook.com/groups/banglatutorial24/ N.B: In the video tutorial, I have tried to describe steps to create index, customer database schema, schema object, constraint, tables in oracle database. [SQL TUTORIAL, DATABASE MANAGEMENT SYSTEM, BANGLA TUTORIAL, TRAINING, DATABASE, ORACLE DBA]
Views: 281 MD. SHARIFUL ALAM
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: 126 Dynamic Study
how to create a role in oracle programming language
 
05:56
cursor in oracle plsql programming language
Views: 187 Vijay dubey
LAB6.2 RMAN  Restore Recover from Loss of control and datafile
 
31:09
RMAN -Restore Recover from Loss of control and datafile
Views: 268 PishonTech
Oracle Database 10g: New Features for Administrators
 
01:41
This course introduces students to the new features in Oracle Database 10g - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves. Course Objectives: Implement improved manageability features to simplify database management Utilize database advisors to provide proactive database monitoring Increase data availability through Oracle Database 10g features that offer improved point in time recovery Assist developers using Oracle Database 10g features in their applications ________________________________________ Course Topics: Introduction How DBAs Spend Their Time Oracle Database 10g Manageability Goals Oracle Database 10g Solution: Self-Managing Database Grid Computing Oracle Database 10g: The Database for the Grid Installation Installation Performance Enhancements Installation New Feature Support Automatic pre & post install validations CD pack contents Server Configuration Database Features Usage Tracking Automatic Enterprise Manager Configuration Simplified Initialization Parameters Simplified Database Install Load and Unload Data Cross-platform Transportable Tablespaces External Tables Unload DataPump Export and Import Utilities Automatic Management Automatic Checkpoint Tuning Automatic Database Diagnostic Monitor Automatic Shared Memory Tuning Automatic Optimizer Statistics Collection Automatic Undo Retention Manageability Infrastructure Advisory Framework Automatic Routine Administration Tasks Server-generated Alerts / Threshold-based Alerts Automatic Workload Repository Application Management and Availability SQL Access Advisor SQL Tuning Advisor New performance overview charts in EM Rule-based optimization (RBO) obsolescence SQL Support for Analytical Applications MERGE Command Enhancements Partitioned Outer Join Integrating Interrow Calculations in SQL Summary Management Enhancements System Resource Management Setting Idle Timeouts Switching Back to the Initial Consumer Group at End of Call Database Resource Manager - Adaptive Consumer Group Mapping Monitoring the Resource Manager The Scheduler Core Scheduler Features Privileges for Scheduler Components Calendaring Expressions Advanced Scheduler Concepts Space Management Segment Advisor New Segment Resource Estimation Online Segment Shrink Proactive Tablespace Management Undo Advisor Sorted Hash Clusters Improved VLDB Support Bigfile Tablespace Enhanced Partition Management in Enterprise Manager Global Partitioned Indexes - Hash Partitioning Local Partitioned Indexes Manageability Improvements Temporary tablespace groups RMAN Enhancements Flash Backup and Recovery Backup Compression Drop Database Automatic Channel Failover for Backup & Restore Incrementally Updated Backups Simplified Recovery Through Resetlogs Flashback Any Error Flashback Database Flashback Table Flashback Versions Query Flashback Transaction Query Flashback Drop General Storage Management Rename Tablespace Redo Logfile Sizing Advisor SYSAUX Tablespace Copying Files using the Database Server Automatic Storage Management Data mirroring with ASM ASM Dynamic Rebalancing ASM Striping ASM General Architecture ASM Disk Groups Failure Groups Maintain Software Oracle Database 10g Upgrade Paths Easy Upgrade (key DBUA features / one script upgrade) Upgrade Information Tools (pre/post) Security Enhancements VPD Static and Dynamic Policies Column-level VPD Uniform Audit Trail Miscellaneous New Features Transaction Monitoring End-to-End Tracing Logminer Enhancements Resumable Space Allocation Enhancements Regular Expression functions
Views: 10166 critiquemusicale
Oracle Enterprise Manager 12c: Use Active Session History (ASH) Analytics
 
03:33
This demonstration shows you how to monitor your database using Active Session History (ASH) Analytics 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.
Configuring Oracle Tablespace Monitoring for PATROL | TrueSight Operations Management
 
06:07
See how to configure Oracle Tablespace Monitoring in a BMC PATROL environment. For more information, see: https://docs.bmc.com/docs/display/public/POK95/Home
Views: 124 BMCdocs
LAB6.3 RMAN   Restore Recover from Loss of control and datafile
 
16:04
Restore Recover from Loss of control and datafile
Views: 153 PishonTech
Oracle Data Guard Tutorial - Open the Standby Read Only (Part 2 of 4)
 
16:49
This tutorial provides a quick review of what Data Guard is, and then goes on to show how you can extract value from Data Guard in every-day usage: how you can use it to enhance performance, and to reduce (yes, reduce!) your need for Oracle licences. Opening the standby database read-only. This has in fact been possible since the automation of redo transport and redo apply when it was first introduced in release 8i. Redo is received on the standby database but is not applied. So the redo is written to the RFS, slave to standby logs, archive to standby logs into archive logs but there's no apply done. So recoverability is not compromised. There's still no danger being lots of data. You're still receiving. The thing is open read-only. What does that mean? It means you can run queries against it. You can offload all your heavyweight queries from the primary to the standby. When I say all of them, even queries that require vast massive temporary space, those horrendous queries, those doing hash joins between multi gigabyte tables, they'll be generating many gigabytes of temporary data. You can write temporary data. Provided that you're using proper temporary tablespaces which you're certain you should be, you can run any query no matter how big, no matter how much temporary data it needs. You can also write audit data and this is important because with version 11, there's quite a lot of auditing enabled by default. By default, that auditing goes to the database, writing database tables. And you can't write to a database table in a read-only database. That we can configure for automatic switching and direct the audit records to the operating system or the trail instead. The queries you run, why is this such a good facility? First, you're taking stress off the primary. I'm sure that we're all DBAs here and we all know how difficult it is to tune your database or a concurrent workload that includes both high volume DML and includes heavyweight queries. Basically, you can't tune that way at all. Offloading the queries to the physical standby will reduce a lot of stress from the primary. So your DML should run significantly better and you can even do a certain amount of tuning on the standby to tune for optimal query performance. The most obvious tuning one would do, would be the memory parameters. No one could for example give the primary a massive PGA aggregate target and the much smaller SGA target or use indeed automatic memory management, perhaps cell tuning. One can adjust many parameters to do with tuning the optimizer to drive the optimizer to a certain execution plan, to exploit the environments. All that can be done on an open read-only database. How does one do it? It really couldn't be simpler. If we look at my physical standby here, this thing database role, physical standby - and if we select the open mode from v$ database, we find this in mount mode. How do we actually open at read-only? First off, we have to stop the recovery process because remember redo is received but no applied. You have to cancel the recovery. So "alter database recover managed standby database cancel." That will give us a read consistent version of the database. The command is intelligent enough to know that there might be incomplete transactions. Long-run transactions could've been partially received. We will end up with a read consistent version. To cancel it, all we do is alter database open read-only. It is that simple.
Views: 3164 SkillBuilders
Oracle DBA Lite: an introduction to Oracle administration, part 3
 
12:50
CAPTIONS AVAILABLE - Tablespace and datafile management in an Oracle database.
Views: 9408 roughsealtd
How do you know what minimum size for shrink your tempdb
 
05:51
RiCo技術農場 https://dotblogs.com.tw/ricochen/1 How do you know what minimum size for shrink your tempdb Imporant: 1.reduce tempdb size without restart sql server 2.never use database auto shrink
Views: 309 RiCo技術農場
06.04.07_Oracle_10gR2_RAC_6.4.7 Relocate OCR Files to Original_20120206.flv
 
04:40
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 6. Administering Voting Disk and OCR File 6.1 Overview - () 6.2 Example Configuration - (Video) 6.3 Create RAW devices on all nodes - (Video) 6.3.1 Stop the RAC cluster and CRS - (Video) 6.3.2 Create logical (iSCSI) volumes - (Video) 6.3.3 Create iSCSI Targets - (Video) 6.3.4 Discover all available targets - (Video) 6.3.5 Manually Log In to iSCSI Targets - (Video) 6.3.6 Configure Automatic Log in - (Video) 6.3.7 Verify Persistent Local SCSI Device Names - (Video) 6.3.8 Create Partitions on iSCSI Volumes - (Video) 6.3.9 Re-scan the SCSI bus - (Video) 6.3.10 Bind the Clusterware component devices to RAW devices - (Video) 6.3.11 Check the RAW devices - (Video) 6.3.12 Zero out the RAW devices - (Video) 6.3.13 Restart the RAC cluster and CRS - (Video) 6.4 Administering the OCR File - (Video) 6.4.1 View OCR Configuration Information - (Video) 6.4.2 Usage of ocrconfig command - () 6.4.3 Remove an OCR File - (Video) 6.4.4 Add an OCR File - (Video) 6.4.5 Relocate an OCR File - (Video) 6.4.6 Repair an OCR File on a Local Node - (Video) 6.4.7 Relocate OCR Files to Original - (Video) 6.5 Backup the OCR File - (Video) 6.6 Recover the OCR File - (Video) 6.6.1 Recover OCR from Valid OCR Mirror - () 6.6.2 Recover OCR from Automatically Generated Physical Backup - (Video) 6.6.3 Recover OCR from an OCR Export File - (Video) 6.7 Administering the Voting Disk - (Video) 6.7.1 View Voting Disk Configuration Information - () 6.7.2 Usage of crsctl command - () 6.7.3 Overview of Adding or Remvoing a voting disk - () 6.7.4 Remove a Voting Disk - (Video) 6.7.5 Add a Voting Disk - (Video) 6.7.6 Relocate a Voting Disk - (Video) 6.7.7 Get Voting Disk to Original - (Video) 6.8 Backup the Voting Disk - (Video) 6.9 Recover the Voting Disk - (Video) 6.10 Remove RAW devices on all nodes - (Video) 6.11 Recover Corrupt/Missing OCR with No Backup - (Video) Step 1: Simulate Corrupt/Missing OCR - (Video) Step 2: Shutdown Oracle Clusterware on All Nodes - (Video) Step 3: Execute rootdelete.sh from All Nodes - (Video) Step 4: Run rootdeinstall.sh from the Primary Node - (Video) Step 5: Run root.sh from the Primary Node. (same node as above) - (Video) Step 6: Run root.sh from All Remaining Nodes - (Video) Step 7: Configure Server-Side ONS using racgons - (Video) Step 8: Configure Network Interfaces for Clusterware - (Video) Step 9: Add TNS Listener using NETCA - (Video) Step 10: Add all Resources Back to OCR using srvctl - (Video) Step 11: Verify the New OCR/Voting Disk - (Video) 6.12 Recover Corrupt/Missing OCR and Voting Disk with No Backup - (Video) Step 1: Simulate Corrupt/Missing OCR and Voting Disk - (Video) Step 2: Shutdown Oracle Clusterware on All Nodes - (Video) Step 3: Execute rootdelete.sh from All Nodes - (Video) Step 4: Run rootdeinstall.sh from the Primary Node - (Video) Step 5: Run root.sh from the Primary Node. (same node as above) - (Video) Step 6: Run root.sh from All Remaining Nodes - (Video) Step 7: Configure Server-Side ONS using racgons - (Video) Step 8: Configure Network Interfaces for Clusterware - (Video) Step 9: Add TNS Listener using NETCA - (Video) Step 10: Add all Resources Back to OCR using srvctl - (Video) Step 11: Verify the New OCR/Voting Disk - (Video)
Views: 171 Yongcheng Lai
Oracle Enterprise Manager 12c: Incident Management: Use Incident Rule Sets Part 1
 
09:27
This demonstration shows you how to create Incident Rule Sets in Oracle Enterprise Manager Cloud Control 12c. This demonstration is part 1 of a two part 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.
Expert Stored Procedure Monitoring and Analysis (Silent Demo)
 
06:57
Stored procedures are becoming a programming standard across today's enterprise applications. Monitoring and analyzing their performance is a critical investment to ensure the return on investment on their usage. Discover how to expose and analyze performance issues that lie deep within stored procedures through this powerful new capability of IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS. Resources: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS http://www-142.ibm.com/software/products/us/en/tivoliomegamonxefordb2performanceexpertonzos/ IBM Performance Solutions for DB2 for z/OS and IMS http://www-01.ibm.com/software/data/db2imstools/solutions/performance-mgmt.html
06.04.03_Oracle_10gR2_RAC_6.4.3 Remove an OCR File_20120206.flv
 
00:54
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 6. Administering Voting Disk and OCR File 6.1 Overview - () 6.2 Example Configuration - (Video) 6.3 Create RAW devices on all nodes - (Video) 6.3.1 Stop the RAC cluster and CRS - (Video) 6.3.2 Create logical (iSCSI) volumes - (Video) 6.3.3 Create iSCSI Targets - (Video) 6.3.4 Discover all available targets - (Video) 6.3.5 Manually Log In to iSCSI Targets - (Video) 6.3.6 Configure Automatic Log in - (Video) 6.3.7 Verify Persistent Local SCSI Device Names - (Video) 6.3.8 Create Partitions on iSCSI Volumes - (Video) 6.3.9 Re-scan the SCSI bus - (Video) 6.3.10 Bind the Clusterware component devices to RAW devices - (Video) 6.3.11 Check the RAW devices - (Video) 6.3.12 Zero out the RAW devices - (Video) 6.3.13 Restart the RAC cluster and CRS - (Video) 6.4 Administering the OCR File - (Video) 6.4.1 View OCR Configuration Information - (Video) 6.4.2 Usage of ocrconfig command - () 6.4.3 Remove an OCR File - (Video) 6.4.4 Add an OCR File - (Video) 6.4.5 Relocate an OCR File - (Video) 6.4.6 Repair an OCR File on a Local Node - (Video) 6.4.7 Relocate OCR Files to Original - (Video) 6.5 Backup the OCR File - (Video) 6.6 Recover the OCR File - (Video) 6.6.1 Recover OCR from Valid OCR Mirror - () 6.6.2 Recover OCR from Automatically Generated Physical Backup - (Video) 6.6.3 Recover OCR from an OCR Export File - (Video) 6.7 Administering the Voting Disk - (Video) 6.7.1 View Voting Disk Configuration Information - () 6.7.2 Usage of crsctl command - () 6.7.3 Overview of Adding or Remvoing a voting disk - () 6.7.4 Remove a Voting Disk - (Video) 6.7.5 Add a Voting Disk - (Video) 6.7.6 Relocate a Voting Disk - (Video) 6.7.7 Get Voting Disk to Original - (Video) 6.8 Backup the Voting Disk - (Video) 6.9 Recover the Voting Disk - (Video) 6.10 Remove RAW devices on all nodes - (Video) 6.11 Recover Corrupt/Missing OCR with No Backup - (Video) Step 1: Simulate Corrupt/Missing OCR - (Video) Step 2: Shutdown Oracle Clusterware on All Nodes - (Video) Step 3: Execute rootdelete.sh from All Nodes - (Video) Step 4: Run rootdeinstall.sh from the Primary Node - (Video) Step 5: Run root.sh from the Primary Node. (same node as above) - (Video) Step 6: Run root.sh from All Remaining Nodes - (Video) Step 7: Configure Server-Side ONS using racgons - (Video) Step 8: Configure Network Interfaces for Clusterware - (Video) Step 9: Add TNS Listener using NETCA - (Video) Step 10: Add all Resources Back to OCR using srvctl - (Video) Step 11: Verify the New OCR/Voting Disk - (Video) 6.12 Recover Corrupt/Missing OCR and Voting Disk with No Backup - (Video) Step 1: Simulate Corrupt/Missing OCR and Voting Disk - (Video) Step 2: Shutdown Oracle Clusterware on All Nodes - (Video) Step 3: Execute rootdelete.sh from All Nodes - (Video) Step 4: Run rootdeinstall.sh from the Primary Node - (Video) Step 5: Run root.sh from the Primary Node. (same node as above) - (Video) Step 6: Run root.sh from All Remaining Nodes - (Video) Step 7: Configure Server-Side ONS using racgons - (Video) Step 8: Configure Network Interfaces for Clusterware - (Video) Step 9: Add TNS Listener using NETCA - (Video) Step 10: Add all Resources Back to OCR using srvctl - (Video) Step 11: Verify the New OCR/Voting Disk - (Video)
Views: 126 Yongcheng Lai
Recovering from noncritical Losses, recovery from loss of control file, data file
 
14:44
Performing Backup and Recovery - Recovering from noncritical Losses, recovery from loss of control file, data file For Students of B.Tech, B.E, MCA, BCA, B.Sc., M.Sc., Courses - As Per IP University Syllabus and Other Engineering Courses
How to run system reports
 
04:31
Reports • Log into Helm control panel as a reseller. • Click Reports icon. The reports page where several types of reports are available. • Click Customer Bandwidth Usage Report link. In the next window, you can see amount of bandwidth being used by all our customers. Set the date range. • Click Re-Query button to generate new report. • Similarly, you can have a look at the other available reports. You can also view Customer Invoice Report to view customer invoices and reporting by specific dates.
Views: 10 kvchosting