Home
Search results “Oracle partition move compress”
exchange Partition , Move partition in oracle
 
08:42
exchange Partition , Move partition in oracle Possible operations with partitions SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial Add Drop Rename Split Move ( Moving from Tablespace to tablespace) Exchange (Table to Table(non Partitioned table)) not partitioned only exchanging data (p)
Views: 833 TechLake
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: 2734 SkillBuilders
How to move Partitions ONLINE  and make them READ ONLY
 
03:46
The clip demonstrates how to move (compressing) Partitions ONLINE and how to make them READ ONLY. Both are 12c New Features. Text version is here: https://uhesse.com/2017/01/05/how-to-move-partitions-online-and-make-them-read-only-in-oracle-12c/
How to Move Object from one Table Space to Another Table Space? | How to Rebuild the Index ?
 
05:03
This Video will teach you How to Move Object one Table Space to Another | How to Rebuild the Index ? move table from one tablespace to another in oracle 11g oracle move schema to another tablespace oracle how to move objects to another tablespace oracle 11g move schema to another tablespace alter table move tablespace oracle 8i oracle move table script oracle move cluster to new tablespace oracle move table example rebuild index oracle script alter index rebuild online parallel oracle rebuild all indexes oracle index rebuild online vs offline oracle rebuild partitioned index index rebuild oracle best practice index rebuild script in oracle 11g
Views: 752 Oracle PL/SQL 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: 6338 BhagyaRaj Katta
Oracle Advance Compression
 
05:34
Oracle Advance Compression
Views: 425 BD2 Proyecto
Composite Partitioning in Oracle
 
12:14
This video is the 6th Video in the series partitioning in oracle. It explains the different composite partitioning approaches and in what scenario they should be used with real project use case explanations.
Views: 1761 Tech Coach
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/
Oracle Database 12c: Partitioning Improvements with Tom Kyte
 
08:08
Tom Kyte introduces the new partitioning improvements in Oracle Database 12c, followed by a demo of global index maintenance. For more information: "Asynchronous Global Index Maintenance for Dropping and Truncating Partitions" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14107 "Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14100 "ALTER INDEX COALESCE Clause" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF52782 "DBMS_PART.CLEANUP_GIDX Procedure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ARPLS74409
Views: 12496 OracleDBVision
DB2 9.7 Compression
 
04:28
This screencast demonstrates compression technology and its enhancements in DB2 9.7.
Views: 1288 channeldb2
SQL Server Backup Compression
 
03:22
Detailed Article for "SQL Server Backup Compression" is available at : http://sqlserver-training.com/backup-compression-sql-server-2008 Follow us at more Updates at ----------------------------------------- Website : http://sqlserver-training.com/ Twitter : http://twitter.com/dbatag/ Facebook : http://facebook.com/dbatag/ Linked In : http://in.linkedin.com/in/dbatag/ ================================ Backup compression was introduced in SQL Server 2008 Enterprise, which reduces the size of backups and the time that it takes to create them. Using backup compression is a simple process. Transact-SQL—WITH COMPRESSION in the BACKUP statement, BACKUP DATABASE AdventureWorks2008 TO DISK = 'C:\AWBackupCompressed.bak' WITH COMPRESSION By default, no backups are compressed. You can change this default setting by using sp_configure to set the value of the backup_compression_default setting as shown in the following code example. Alternatively, you can change the default setting by selecting the option in the Server Properties dialog box. USE master Go EXEC sys.sp_configure N'backup compression default', N'1' GO RECONFIGURE WITH OVERRIDE GO Although compressed backups require less disk space to store them and less time to create, there is a tradeoff. The compression is a CPU-intensive operation that can impact other operations that occur on your servers. To avoid such contention, you can use Resource Governor to limit the CPU usage for a backup operation. Note: Compression and transparent data encryption are mutually exclusive. Creating a backup with compression is supported only in SQL Server 2008 Enterprise Edition; all SQL Server 2008 editions can restore a compressed backup. Visit the following link for more details and SQL Server Tutorials http://sqlserver-training.com/ http://sqlserver-training.com/how-many-dmv-are-available-in-sql-server-2008 http://sqlserver-training.com/how-to-move-tempdb-files-to-a-new-drive-video http://sqlserver-training.com/featured-articles http://sqlserver-training.com/complete-list-of-sql-server-versions-builds http://sqlserver-training.com/cumulative-update-package-3-for-sql-server-2008-r2-is-released-now http://sqlserver-training.com/video-tutorials http://sqlserver-training.com/how-to-optimizing-tempdb http://sqlserver-training.com/dbcc-check-db-uses-parallelism-how-it-works http://sqlserver-training.com/sql-server-2008-upgrade-tools-and-approaches http://sqlserver-training.com/migrating-sql-server-2000-to-sql-server-2008 http://sqlserver-training.com/new-features-of-sql-server-2008-2 http://sqlserver-training.com/extensible-key-management-ekm-sql-server-2008 http://sqlserver-training.com/database-mirroring-enhancements-in-sql-server-2008-from-2005/ http://sqlserver-training.com/data-compression-table-level-compression-video-tutorials/ http://sqlserver-training.com/sql-server-2008-hot-add-cpu/ http://sqlserver-training.com/sql-server-migration-assistant-for-mysql/ http://sqlserver-training.com/microsoft-sql-server-migration-assistant-for-sybase/ http://sqlserver-training.com/sql-server-migration-assistant-for-oracle/ http://sqlserver-training.com/sql-server-migration-assistant-for-access/ http://sqlserver-training.com/database-size-growth-chart-report-graphically/ http://sqlserver-training.com/introduction-to-microsoft-sql-server-2008-r2/ http://sqlserver-training.com/sql-server-2008-workshop-in-chennai-august-02-to-august-05-2010/ http://sqlserver-training.com/new-features-of-sql-server-2008/ http://sqlserver-training.com/sql-server-2008-star-join-query-optimization/ http://sqlserver-training.com/sql-server-monitoring-management-pack-6-1-314-36/ http://sqlserver-training.com/sql-azure-database-video-tutorial/ http://sqlserver-training.com/can-we-call-dll-from-sql-server/ http://sqlserver-training.com/master-data-services-mds-sql-server-2008-video-tutorial/
Views: 6404 DBATAG
Oracle Database 12c demos: In-Memory Column Store Compression
 
11:42
The demonstration illustrates how inmemory compression of inmemory objects populated in the IM column store can influence either query performance or storage savings in IM column store.
Oracle Database 12c New Features Tutorial - Enhanced Online Move Capabilities
 
09:26
Learn the new features in Oracle Database 12c. In this free tutorial, watch Oracle Certified Master demonstrate the enhanced Online Move capabilities in Oracle 12c - Moving Tablespaces and Datafiles Online! (via dbms_redefinition). See all free tutorials in SkillBuilders 12c series at SkillBuilders.com/OracleTutorials.
Views: 3491 SkillBuilders
Exploring Oracle 12c's Automatic Database Optimization (ADO) Features:
 
45:36
Oracle Database Release 12cR1's new Automatic Database Optimization (ADO) features now make it possible to automatically locate data within the most appropriate storage tier and at the appropriate compression level based on its usage patterns. Join Oracle Ace Director Jim Czuprynski as he discusses how to take advantage of these features to save crucial Tier 0 and Tier 1 storage space ... and perhaps even improve query and DML performance.
Views: 5269 Database Community
Partitioning Basics: Treating your tables like Lego
 
01:03:29
Do you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you! With partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations. We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll look at how partitioning affects things under the hood. Finally you'll see some cool demos/tricks around index maintenance and data movement. At the end of this session you’ll have a firm understanding of how partitioning works and know how to make decisions on how and when to implement. You'll learn… • The components of table partitioning and how they fit together • How to make your index maintenance partition aware • How Partition elimination can help your queries • How to split different parts of tables over different storage tiers • How to manage partitions. We'll demo this by implementing the sliding window technique. Brandon Leach is a senior DBA with SurveyMonkey in Palo Alto, CA. He is a frequent speaker at events such as SQLSaturdays, user groups, and more recently the PASS Summit. When not working or at events he can be found spending time with his family and tinkering in his home lab.
Views: 1256 DBAFundamentals
Why Won't Oracle Use My Index - 12c Attribute Clustering - Lesson 1
 
01:46
Sometimes a poor clustering factor is the cause when Oracle Database cost based optimizer does not choose to use an index. With Oracle 12c (12.1.0.2 EE) offers a new feature that can really help - "Atrribute Clustering". This is implemented with a new keyword on CREATE TABLE - "CLUSTERING BY LINEAR ORDER". In this Free Tutorial from SkillBuilders and Oracle Certified Master DBA John Watson, you'll get a brief refresher on clustering factor and a demonstration of CREATE TABLE - "CLUSTERING BY LINEAR ORDER" - so the CBO will use your index! In this first lesson, John will provide a brief review of clustering factor. See all 6 lessons - FREE - at http://www.skillbuilders.com/12c-attribute-clustering
Views: 346 SkillBuilders
SQL Server 2008 Partitioned Table and Parallelism
 
05:45
Detailed Article for "Partitioned Table and Parallelism" is available at : http://sqlserver-training.com/sql-server-2008-partitioned-table-parallelism-concept-video Follow us at more Updates at ----------------------------------------- Website : http://sqlserver-training.com/ Twitter : http://twitter.com/dbatag/ Facebook : http://facebook.com/dbatag/ Linked In : http://in.linkedin.com/in/dbatag/ ================================ SQL Server 2008 has removed the bottleneck of single-thread per partition over partitioned tables, which was found in SQL Server 2005. The previous bottleneck can cause performance problems under certain circumstances: On systems with many CPUs, if the table schema has less partitions than there are CPUs, then not all the CPUs will be used to process the query. Some examples: On a 32-way box, a query over a 12-partition table (e.g. a sales table partitioned by month) will only use 12 threads (one on each of 12 CPUs). This means 20 CPUs are potentially idle. On a 4-way box, a query over a 12-partition table only accesses a single partition so will only use one thread (on one CPU). This means 3 CPUs are potentially idle. On tables that have skewed data such that one partition is much larger than another, the length of time the query takes to complete will be bounded by the single thread processing the largest partition. As part of the set of improvements in SQL Server 2008 for data warehousing there will be an option to change the threading behavior for queries over partitioned tables. The new, alternative model is that all available threads process part of each partition and then move into the next partition. This allows all available CPUs to take part in processing the query, which should lead to a drop in the query completion time. The Following video shows, SQL Server 2008 -- Partitioned Table & Parallelism feature and shows graphically, how SQL Server 2008 has improved performance of Partitioned Tables. Visit the following link for more details and SQL Server Tutorials http://sqlserver-training.com/sql-server-2008-partitioned-table-parallelism-concept-video
Views: 17678 DBATAG
Oracle Edition-Based Redefinition in 5 minutes
 
05:16
Visit my blog for more Oracle database related posts and presentations: http://db-oriented.com
Views: 2348 Oren Nakdimon
PL/SQL tutorial 75: PL/SQL Bulk Collect with LIMIT clause in Oracle Database
 
07:37
RebellionRider.com presents the 4th tutorial in Bulk Collect series. Watch and learn how to use Bulk Collect with LIMIT clause to enhance the query performance in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-4 Previous Tutorial ► Bulk Collect with Explicit Cursor https://youtu.be/PSA8HigCcRs ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the 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: 5773 Manish Sharma
Demartek Evaluation - Improving Oracle Database Response Times
 
03:17
Demartek has evaluated the All-flash HP 3PAR StoreServ 7450c storage system supporting an Oracle database application and analyzed the I/O response time improvements offered by both 16Gb FC technology and 8Gb Express Writes to an Oracle workload.
Views: 88 Demartek
Checkpoint Revalidate
 
02:28
The REVALIDATE option regenerates the table headers for a partitioned table or uncompressed join index and optionally verifies and corrects the row partitioning for a table (but not for a join index) if you specify the WITH DELETE or WITH INSERT null partition handling options. You can specify the REVALIDATE option for unpartitioned tables and join indexes without also specifying PRIMARY INDEX. This makes revalidation applicable whether or not the table or join index has a primary index. You must specify the REVALIDATE option without also specifying PRIMARY INDEX for NoPI tables and column‑partitioned tables and join indexes. Otherwise, Teradata Database aborts the request and returns an error to the requestor. The REVALIDATE option also provides the ability to revalidate some data dictionary columns. REVALIDATE requests do not verify the column partitioning of a column‑partitioned table or join index. If partitioning errors are detected for a table (but not a join index), an ALTER TABLE REVALIDATE request corrects them. REVALIDATE also revalidates the following Data Dictionary table columns. wave web technology was established in 2012, and has a dynamic team of professional web developers, web designers, SEO experts and customer support . website : www.wavewebtech.com https://www.facebook.com/wavewebtechnologies https://twitter.com/wavewebtechnolo https://plus.google.com/collections/
Views: 5 vikas verma
Linux Backup with TAR and Cron Jobs
 
35:33
Info Level: Intermediate Presenter: Eli the Computer Guy Date Created: September 21, 2010 Length of Class: 35 Minutes Tracks Linux Prerequisites Introduction to Linux Installing Linux Basic Linux Tasks VIM for File Editing Navigation in Linux Users, Groups and Permissions in Linux Purpose of Class This class teaches students how to backup directories using TAR, and demonstrates how to schedule tasks using Cron Jobs. Topics Covered Backing Up Directories with TAR Recovering Directories with TAR Setting Up Cron Jobs for Scheduled Tasks Class Notes Backup Using TAR Backup = sudo tar --cvpzf backup.taz.gz --exclude/=directory (recursive) PATH --c = create new file (overwrites old file) --v = verbose --p = preserve permissions --z = compress --f = filename (very important) --exclude=DIRCECTORY is Recursive Naming Files with time = filename-$(date +%F-%T) Recover Files from a TAR File Recover = sudo tar --xvpzf FILE --C /DIRECTORY Capital -C = change to directory -x = extract Cron Jobs To Edit the Crontab File = sudo cron --e (first time it will ask you your default editor) Format = minute (0-59), hour (0-23, 0 = midnight), day (1-31), month (1-12), weekday (0-6, 0 = Sunday), command * Wildcard for Every Minute/Day/Hour/Month?Day of Week Example to Backup Entire Server for 1am Every Morning = 0 1 * * * sudo tar -cvpzf /backup.tar.gz --exclude=/mnt /
Views: 179791 Eli the Computer Guy
IO6: Querying Files with the External Table Feature
 
11:36
The external table feature of Oracle Database allows you apply SQL SELECT operations to the contents of files. Download my demo.zip from v.gd/sfdemo to access and run all referenced scripts. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
Feeling the Storage Squeeze?
 
01:58
Oracle Advanced Compression
Views: 7282 Oracle Video
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
 
07:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- 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: 70915 Manish Sharma
Oracle Database 12c demos: In-Memory Column Store Columns
 
05:19
The demonstration illustrates how columns are handled by in-memory objects in the IM column store.
Oracle Database 12c demos: In-Memory Column Store and Oracle Data Pump
 
05:07
The demonstration illustrates how Oracle Data Pump behaves while exporting and importing in-memory objects and their attributes.
New Features in Oracle Database 12.2
 
02:26
SQL Developer Evangelist Chris Saxon devotes his fourth 2 Minute Tech Tip to an exploration of new features in Oracle Database 12.2.
【VDEDU】Unusable indexes use
 
06:29
Unusable indexes in Oracle, DML statements are not use the index to its maintenance, at the same time the optimizer will not use the index. Unusable indexes no segment exists. Unavailable index index becomes available methods are: 1. Place the index can not be truncate operation corresponding table; 2.rebuild index; In addition, the query optimizer can use conversion method expand table so that the SQL statement has encountered unusable index partition table to generate better execution plans.
Views: 56 崔旭
Oracle 12c Data Archiving: Building a Data Time Machine
 
49:33
With Oracle 12c and Flashback Archiving, building an evolutionary trail of your data is now easier. Regulatory compliance has mandated a history of data changes related to certain information, resulting in organizations creating their own methods for archiving data and purging obsolete data. Most often these methods have to be complimented with business applications and processes, which can be costly over time. During this presentation, you will learn how to take advantage of the new data archiving features to manage historical data and provide a timeline of the data lifecycle. Presented by Arman Rawls, Senior Oracle Database Architect at Neovera.
Views: 842 Neovera
Using VPD Types with Oracle Database 12c
 
04:55
This video shows how the type of a VPD policy affects its execution. For learning purposes it first shows an incorrect use of a policy type, which is then corrected. Prerequisite video: "Using Virtual Private Database with Oracle Database 12c" which contains the setup of the test case Next video: "Troubleshooting a VPD policy in Oracle Database 12c" 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 12c R2 new features (miscellaneous)
 
06:14
In this video , I have discussed miscellaneous new features in oracle 12.2.
Views: 606 AK CLOUD
Trailer for SQL 2012 Developer tutorial: Partitions
 
01:43
Trailer for SQL 2012 Developer tutorial: Partitions with Expert Instructor -- Frank Tillinghast. Get full course details @ http://bit.ly/12bB9bP In this course we'll explore partitioning, and specifically how it's implemented using SQL Server 2012. Partitioning is a way to manage large amounts of data, and while certainly not a new concept, SQL Server has made improvements over the years that make your job as a database architect and developer easier. We'll start off by discussing the evolution of partitioning in SQL Server. You'll learn about partition keys, schemas and functions and how they affect tables, indexes, and the organization of your data. Once you have an understanding of the basics, we'll move on to discuss methods for querying partitions. As time goes on, it may be necessary to make adjustments to your partitions. Next you'll learn how to merge or split partitions, switch out partitions, and make modifications to partition schemes. The course then concludes with some tips on how performance tuning.
Views: 314 LearnNowOnline
[High Pass Guarantee] 2017 Latest Oracle 1Z0-062 Dumps Questions And Answers Free Try
 
01:01
http://www.passitexams.com/1z0-062.html The best and most updated Oracle 1Z0-062 dumps exam training materials in PDF format, download one of the many PDF readers that are available for free. Exams: QUESTION 1 You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data? A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data. B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group. C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data. D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data. E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group. F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data. Correct Answer: ACF QUESTION 2 In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required. Which three statements are true about this requirement? A. The partitions can be moved online to new tablespaces. B. Global indexes must be rebuilt manually after moving the partitions. C. The partitions can be compressed in the same tablespaces. D. The partitions can be compressed in the new tablespaces. E. Local indexes must be rebuilt manually after moving the partitions. Correct Answer: ACD Red more: https://youtu.be/aLx6RnhvXTU
Views: 44 exam dumps
Moving data to DB2 with BLU Acceleration Skill Builder
 
14:32
This skill builder video discusses the DB2 tools that can be used to move data to BLU Acceleration, column organized tables. The use of InfoSphere Optim Query Workload Tuner for selecting tables to convert to BLU Acceleration based on performance improvement is demonstrated. Related courses: Implementation and Use of DB2 BLU Acceleration (CL450) http://www.ibm.com/services/learning/ites.wss/zz/en?pageType=tp_search_results_new&noOfResultsPerPage=20&rowStart=0&searchString=CL450 DB2 10.5 for LUW Advanced Database Administration with DB2 BLU Acceleration (CL463) http://www.ibm.com/services/learning/ites.wss/zz/en?pageType=tp_search_results_new&noOfResultsPerPage=20&rowStart=0&searchString=CL463 Useful links: Training Paths: http://www.ibm.com/services/learning/ites.wss/zz/en?pageType=page&c=a0007973 Certification Program: http://www.ibm.com/software/data/education/certification.html IBM Certified Database Administrator - DB2 10.5 DBA for LUW Upgrade from DB2 10.1 http://www.ibm.com/certify/certs/08002108.shtml IM Certification and Skills : http://www.ibm.com/software/data/education
[CertQueen release 1Z0-595 dumps] Pass Oracle Spatial 11g Essentials test
 
02:41
We certqueen just updated thisx 1Z0-595 Oracle Spatial 11g Essentials today. In our update version, all the new questions could be found. We guarantee you 100% pass this Oracle Database 1Z0-595 exam. Objectives covered in the Oracle Database Exam (1Z0-595): Oracle Spatial Concepts and Data Structures Loading and Validating Spatial Data Indexing Spatial Data Performing Spatial Queries Performing Spatial Processing Oracle Fusion Middleware MapViewer Geocoding, Routing, Spatial Analysis and Mining Web Services Advanced Indexing (Partitioning, Parallelism, Function-Based Indexes) Using Linear Referencing and Network and Topology Models GeoRaster Managing 3D and Lidar Data Performance and Tuning / Exadata Workspace Manager Subscribe us and send the screenshot to [email protected] 1. You can enjoy 20% discount. Coupon code: ytb20off 2. You can get $10 Voucher 3. Money back guarantee More information about Oracle Spatial 11g Essentials, please go to our 1Z0-595 website page https://www.certqueen.com/1Z0-595.html We will be always at your service. 1Z0-595,1Z0-595 exam questions, 1Z0-595 dumps, 1Z0-595 questions and answers, 1Z0-595 practice test, 1Z0-595 study guide, Oracle Database, 1Z0-595 training material, Oracle Spatial 11g Essentials
Views: 5 CertQueen
The Complete Red Hat Linux Course: Beginner to RHCSA!
 
13:35:58
Get The Complete Linux Administration Course Bundle! https://josephdelgadillo.com/product/linux-course-bundle/ Preview the courses! A Beginner’s Guide to Linux System Administration! https://bit.ly/2LZ7cfN CentOS and Red Hat Linux to Certified System Administrator! https://bit.ly/2OJtZLp BASH Programming Course: Master the Linux Command Line! https://bit.ly/2ACzXuv The Complete Wireshark Course: Go from Beginner to Advanced! https://bit.ly/2MinlKr If you want to become a Red Hat Certified System Administrator, you will LOVE this course! Whether you have no experience with Red Hat Linux or any other type of Linux operating system, you can count on this course to get you started with the basics and show you what to do all the way into the advanced material. You get to see immediately why Linux is worth learning and using. Learn the basics of CentOS and Red Hat Linux! Prepare and pass the RedHat certified system administrator (RHCSA) exam! https://josephdelgadillo.com/product/linux-course-bundle/ Time Stamps 01:05 Introduction 09:57 Why is Linux worth learning? 24:40 VirtualBox installation/setup 37:02 RedHat virtual machine setup pt.1 55:07 RedHat virtual machine setup pt.2 1:09:44 RedHat virtual machine setup pt.3 1:27:24 RedHat dual boot setup pt.1 1:46:06 RedHat dual boot setup pt.2 1:53:18 Linux GUI essentials pt.1 2:04:26 Linux GUI essentials pt.2 2:18:03 File system navigation ls, cd, pwd pt.1 2:34:18 File system navigation ls, cd, pwd, pt.2 2:48:26 Finding files commands find, locate, upadtedb, man 3:08:12 File & folder ownership commands chown, chmod pt.1 3:22:12 File & folder ownership commands chown, chmod, pt.2 3:31:00 Move, delete, and copy file commands mv, rm, cp 3:43:58 Commands grep, pipe, echo, cat 4:02:54 YUM package manager pt.1 4:22:43 YUM package manager pt.2 4:37:10 RPM package manager 4:44:50 Redhat Certified System Administration Exam 5:01:22 Globbing (wildcards) pt.1 5:12:37 Globbing pt.2 5:27:51 IORedirection pt.1 5:38:37 IORedirection pt.2 5:51:50 IORedirection pt.3 6:00:21 Vim text editor pt.1 6:08:56 Vim text editor pt.2 6:20:46 Vim text editor pt.3 6:28:21 Vim text editor pt.4 6:36:41 Vim text editor pt.5 6:47:44 Linux file system 7:06:26 Links 7:14:33 Backups and compression pt.1 7:33:20 Backups and compression pt.2 7:42:40 Backups and compression pt.3 7:52:39 Automating tasks with cron pt.1 7:60:43 Automating tasks with cron pt.2 8:18:49 Automating tasks with cron pt.3 8:32:43 Automating tasks with cron pt.4 8:42:44 User properties and where they are stored in the system 8:55:17 Creating a user 9:12:24 Creating groups and assigning users to them 9:33:17 Intro to network interfaces 9:44:29 Network manager and configuration pt.1 10:03:00 Network manager and configuration pt.2 + trouble shooting tools 10:22:51 Installing and configuring SSH server pt.1 10:42:57 Installing and configuring SSH server pt.2 10:57:44 SSH passwordless and SCP (secure copying of files between hosts) 11:14:18 Partitioning and file systems 11:23:34 Partitioning a new disk 11:40:07 Formatting a partition using xfs file system 11:47:37 Mounting the partitions 12:01:06 Linux volume management (LVM) pt.1 12:20:10 Linux volume management (LVM) pt.2 12:36:35 Linux volume management (LVM) pt.3 12:49:06 Linux volume management (LVM) pt.4 12:56:52 Linux volume management (LVM) pt.5 13:05:23 LUKS pt.1 13:19:19 LUKS pt.2
Views: 421932 Joseph Delgadillo
DOAG@Talk: Oracle Partitioning: Hilfreiche Funktionen für DBAs und Entwickler
 
07:25
Oracle Partitioning ist wohl eine der am meisten benutzten Optionen der Datenbank. Wie und von welchen Funktionen können Datenbankadministratoren und Entwickler besonders profitieren? Hermann Baer, Director Product Management Data Warehousing bei Oracle, steht im Interview mit Matthias Mann, stellvertretender DOAG-Themenverantwortlicher Datenbankadministration, Rede und Antwort und stellt dabei einige der Funktionen vor.
Views: 94 doagtv
how to install oracle database - learn oracle sql onlne
 
04:58
in this video i will show you how to install oracle database in window 10, you can also visit our group for more detail in facebook link:https://www.facebook.com/groups/242999206136244/ 2.1.1 Hardware Component Requirements for Windows 32-Bit The following table lists the hardware components that are required for Oracle Database on Windows 32-Bit. Windows 32-Bit Hardware Requirements Requirement Value Physical memory (RAM) 1 GB minimum Virtual memory Double the amount of RAM Disk space Total: 4.76 GB See Table 2-3 for details. Processor 550 MHz minimum (On Windows Vista, 800 MHz minimum) Video adapter 256 colors See Also: "Configuring Disk Storage for Oracle Data Files and Recovery Files" "Creating Directories for Oracle Data Files or Recovery Files" "Preparing Disk Groups for an Automatic Storage Management Installation" "Installing with Minimum Memory Requirements" 2.1.2 Hardware Component Requirements for Windows x64 The following table lists the hardware components that are required for Oracle Database on Windows x64. Windows x64 Hardware Requirements Requirement Value Physical memory (RAM) 1 GB minimum Virtual memory Double the amount of RAM Disk space Total: 5.22 GB See for details. Processor AMD64, or Intel Extended memory (EM64T) Video adapter 256 colors 2.1.3 Hard Disk Space Requirements for Windows 32-Bit This section lists system requirements for Windows platforms that use the NT File System (NTFS). Oracle recommends installing Oracle components on NTFS. NTFS allows for strong security of database files, trace files, incident data, and so on, stored in the Oracle home. The NTFS system requirements listed in this section are more accurate than the hard disk values reported by the Oracle Universal Installer Summary window. The Summary window does not include accurate values for disk space, the space required to create a database, or the size of compressed files that are expanded on the hard drive. The hard disk requirements for Oracle Database components include 32 MB required to install Java Runtime Environment (JRE) and Oracle Universal Installer on the partition where the operating system is installed. If sufficient space is not detected, installation fails and an error message appears. .----------------------------------------------------------------------------------------------------------. video courses- list of playlist : tips and trics link► https://www.youtube.com/playlist?list=PLOfLYVXrwqXrI5jvwUEi6N13QR4xCj2k2 command prompt commands: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXobXGUdGk6JhzyQ216dNiQL oracle sql: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXqoUWCoh4cARGDW13SofDO- c programming: link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXrZ_Ub8EXeLY7YP1YxhoJzf .-----------------------------------------------------------------------------------------------------------. watch more videos: learn oracle sql online overview tutorail : https://www.youtube.com/watch?v=Dfesgj4w8QA&t=8s how to fix or repair a corrupted usb flash drive or cd card using command prompt: https://www.youtube.com/edit?video_id... how to copy a folder using cmd: https://www.youtube.com/watch?v=Lblhb... how to move a folder using cmd: https://www.youtube.com/watch?v=YFfHZ... how to dell files in cmd: https://www.youtube.com/watch?v=3-lqg... how to make and remove directory: https://www.youtube.com/edit?video_id... how to change color and title in cmd: https://www.youtube.com/edit?video_id... how to change directory in command prompt: https://www.youtube.com/watch?v=SmLYx... .-----------------------------------------------------------------------------------------------------------. social media links: join our group: ► https://www.facebook.com/groups/24299... ► Follow on Google+: http://[email protected] ► Follow on Twitter: https://twitter.com/@rananavi4766669 :
Views: 30 The Learning Tree
Migrating to Shared Storage Pool (SSP3) & then LPM
 
18:00
"You will be Assimilated!" We can quickly and online adopt a VIOS into a Shared Storage Pool and then all the VIOS client LPARs move to SSP disks using migratepv on AIX (or mirrors on Linux / IBM i) and then immediately Live Partition Mobility (LPM) the LPARs to another machine. This is really good way to clean up and consolidate older LPAR configurations and go "pure virtual". You can then decommission or re-purpose older machines. All live with zero downtime. If you Like this video, click "Like"
Views: 1267 Nigel Griffiths
Linux Administrer le système - Sauvegarde et restauration - compression, archivage, décompression
 
08:17
Retrouvez toute la formation : http://bit.ly/1dxblDa Ces vidéos sur l'administration d'un système Linux s'adressent à toute personne qui souhaite assurer l'administration d'une machine Linux, en gérer les comptes d'utilisateurs, les permissions, les sauvegardes, les imprimantes et plus généralement toutes les tâches liées à l'administration d'un système d'exploitation.
Views: 1406 Editions ENI
What can cause performance issues in DB2 for LUW - Performance 101 part 1 of 3
 
06:19
In part 1 of the 3-part series, Jeff Sullivan gives an overview of what can cause performance issues in DB2 for LUW
Santhosh on DB2's GOT TALENT 2016
 
11:51
Santhosh talks about DB2 LUW 10.1 and 10.5 compression and offers his insights and tips. DB2's GOT TALENT 2016 1st and 2nd place winners will be determined by the number of LIKES on contestant videos, so if you find this presentation to be helpful, please vote for it by giving it a thumbs up!
Views: 242 DB2NightShow
Oracle Database 12c Standard Edition - Key Features
 
01:05:03
As you may know, Oracle has continued to add and update great features with their latest database, Oracle 12c, but are you up-to-date with what is now offered as part of Standard Edition (SE)? Whether you are interested in upgrading or are already using 12c, the Dbvisit team is here to educate you on the following key features that are now available: Flashback Data Archive RMAN New Features Multitenancy Support (PDBs) As well as a few others exciting elements! Come meet up with Anton Els and Mike Donovan for this 29 minute webinar and familiarise yourself with the exciting new world of Oracle Database 12c Standard Edition.
Views: 793 Dbvisit Software
Virtual Box: Add a Swap Drive
 
05:14
This video shows how to create additional hard drive space in Virtual Box for moving the pagefile (swap file). It can also be used to create more hard drives for anything else you wish.
Views: 2449 midfingr
Create new database (name: ACMEDW), unlock OWBSYS use and apply password-123456 in Oracle 11g
 
20:18
Creating the database We can install a new database using Database Configuration Assistant 1. The first step is to specify what action to take. Since we do not have a database created, we'll select the Create a Database option in Step 1. 2. This step will offer the following three options for a database template to select:  General Purpose or Transaction Processing  Custom Database  Data Warehouse We are going to choose the Data Warehouse option for our purposes 3. This step of the database creation will ask for a database name. Since we're creating this database for the data warehouse of ACME Toys and Gizmos Company, we'll choose a name that reflects this—ACME for the company name and DW for data warehouse, resulting in a database name of ACMEDW. As the database name is typed in, the SID (or Oracle System Identifier) is automatically filled in to match it. 4. This step of the database creation process asks whether we want to configure Enterprise Manager. The box is checked by default and leave it as is. 5. On this screen (step 5) we can set the database passwords on the system accounts using a different one for each account, or by choosing one password for all four. We're going to set a single password on all four, but for added security in a production environment, it is a good idea to make a different password for each. Click on the option to Use the Same Administrative Password for All Accounts and enter a password. 6. This step is about storage. We'll leave it at the default of File System for storage management. The other two options are for more advanced installations that have greater storage needs. 7. This step is for specifying the locations where database files are to be created. This can be left at the default for simplicity 8. The next screen is for configuring recovery options. We're up to step 8 now. If we were installing a production database, we would want to make sure to use the Flash Recovery option and to Enable 22 WE-IT TUTORILAS PHNO:8097071144/55 Archiving. Flash Recovery is a feature Oracle has implemented in its database to provide a location that is managed by the database. It stores backups and files needed to recover a database in the event of disk failure. With Flash Recovery Area specified, we can recover data that would otherwise be lost in a system failure. 9. 9. This step is where we can have the installation program create some sample schemas in the database for our reference, and specify any custom scripts to run. The text on the screen can be read to decide whether they are needed or not. We don't need either of these for this book, so it doesn't matter which option we choose. 10. The next screen is for Initialization Parameters. These are the settings that are put in place to define various options for the database such as Memory options. 11. The next screen is for security settings. For the purposes of this book and its examples, we'll check the box to Revert to pre-11g security settings since we don't need the additional features. However, for a production environment, it is a good idea to leave the default checked to use Oracle's more advanced security features. 12. This step is automatic maintenance and we'll deselect that option and move on, since we don't need that additional functionality. Automatic Maintenance Tasks are tasks that run in predefined maintenance windows of time to perform various preconfigured maintenance operations on the database. 13. The next step (step 13 of 14) is the Database Storage screen referred to earlier. Here the locations of the pre-built data and control files can be changed if needed. They should be left set to the default for simplicity since this won't be a production database. For a production environment, we would want to consider storing datafiles on separate partitions for performance reasons, and to minimize the impact of disk failures on the running database if something goes wrong. 14. The final step has the following three options, and any or all can be selected for creating the database:  Create the database directly  Save the creation options as a template for later use  Save database creation scripts that can be used later to create the database The Next button is grayed out since this is the last screen. So click on the Finish button to begin creating the database using the selections we've just chosen. It will display a summary screen showing what options it will be using to install with.
Views: 134 DOit...!!!!
Key differences between Oracle Exadata & Netezza examined
 
01:05
Netezza has produced a series of videos (http://netezza.com/compare) to help you better understand our "secret sauce" -- and why our appliance-based approach to data warehouse analytics differs in basic and important ways from that of Oracle Exadata. The differences between the two are so stark, in fact -- in terms of simplicity, speed, scaleablity and smarts - that Netezza is able to introduce our customers to entirely new ways of thinking about data analytics and the ways they do business.
Views: 12579 NetezzaCorp
How To Use Find and Locate commands to Search for Files on Linux
 
06:46
How To Use Find and Locate commands to Search for Files on Linux One problem users run into when first dealing with a Linux machine is how to find the files they are looking for. This video will cover how to use the find command. This will help you search for files using a variety of filters and parameters. We will also briefly cover the locate command, which can be used to search also for files using its own database. 🌸 Support channel & make donation : https://www.paypal.me/aminenina/5 🌸 Subscribe for more videos : Youtube: https://www.youtube.com/user/aminosni... 🌸 Follow me On Social Media Facebook : https://www.facebook.com/aminosninatos/ *********************************************************************** 🌸 How To Check Bad Blocks Or Bad Sectors On a Hard Disk In Linux https://www.youtube.com/watch?v=jE-I9... 🌸 Linux How To Partition a Hard Drive Using the Parted Command https://www.youtube.com/watch?v=2IoEW... 🌸 Checking or Repairing a File System using fsck in Linux https://www.youtube.com/watch?v=CcV_M... 🌸 How To Monitor the Health of Your Hard Drive in Linux using SMART https://www.youtube.com/watch?v=z1z9R... 🌸 Linux iotop: Monitor your disk Input/Output https://www.youtube.com/watch?v=pWG4v... 🌸 How To use the “du” (Disk Usage) Command in Linux https://www.youtube.com/watch?v=RA4bM... 🌸 How To View Manipulate System Logs In Linux Using Journalctl Command https://www.youtube.com/watch?v=NE-fT-Fwvgw&t=3s 🌸 How To Sync And Backup Files In Linux Using Rsync Command https://www.youtube.com/watch?v=aIMbg7vG6Rg&t=10s 🌸 Linux cURL Command Tips and Tricks https://www.youtube.com/watch?v=hA3BAALWFJI 🌸 Linux tail and multitail commands https://www.youtube.com/watch?v=QnPyWNyCn-U 🌸 Linux How To view Log Files https://www.youtube.com/watch?v=CEYhs_9L01M&t=2s 🌸 How To use the History Command On Linux https://www.youtube.com/watch?v=RkxIWlypB-s 🌸 Tips and Tricks How To manipulate Text Files on Linux https://www.youtube.com/watch?v=Zk9M1w55XO0 🌸 How to Archive, Compress and Extract Files Using the tar Command on Linux https://www.youtube.com/watch?v=8j-ZzOfbclM&t=2s 🌸 Linux - How to split larger files into smaller parts https://www.youtube.com/watch?v=DaC5AWjmQXk 🌸 Linux commands : Top https://www.youtube.com/watch?v=RM7ck63mcHQ ***********************************************************************
Views: 1121 Amine Nina
PL/SQL tutorial 72: Introduction to PL/SQL Bulk Collect in Oracle Database
 
04:39
Learn what is PL/SQL Bulk Collect and why do we need it in Oracle Database by Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-1 Previous Tutorial ►Sys_RefCursor: http://bit.ly/ref-cursor-5 ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the 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: 9334 Manish Sharma