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: 1163 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: 3146 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/
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: 6770 BhagyaRaj Katta
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: 13273 OracleDBVision
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 Advance Compression
 
05:34
Oracle Advance Compression
Views: 440 BD2 Proyecto
Reclaiming free space from innodb tables
 
06:05
Reclaiming free space from innodb tables
Views: 138 Ask Guru
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 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 Edition-Based Redefinition in 5 minutes
 
05:16
Visit my blog for more Oracle database related posts and presentations: http://db-oriented.com
Views: 2733 Oren Nakdimon
DB2 9.7 Compression
 
04:28
This screencast demonstrates compression technology and its enhancements in DB2 9.7.
Views: 1294 channeldb2
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: 1441 DBAFundamentals
Hints and Tips - Queries running whilst exchanging partitions - part 2
 
01:26
Even when you rip out a partition from a table, queries can still execute successfully. ========================================­­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 999 Connor McDonald
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: 17795 DBATAG
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: 6599 DBATAG
【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: 65 崔旭
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: 3522 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: 5424 Database Community
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: 75369 Manish Sharma
Oracle Database 18c Express Edition Installation on Oracle Linux 6.10 | Oracle Database 18c XE
 
33:15
In this video we are going to demonstrate how to install Oracle Database 18c Express Edition in Oracle Linux 6.10. Oracle Database 18c Express Edition installation in Oracle Linux 6 Platform is very easy. This video guides step by step installation of oracle 18c includes kernel parameters configuration, dependencies installation, oracle database installation, oracle listener configuration after installation and finally access oracle enterprise manager 18c in browser. Hardware Requirements : Minimum 2 GB RAM, 2 CPU Cores and Enough Hard disk Space. Software Requirements : Oracle Enterprise Linux 6 with dependencies for oracle database 18c installed and Kernel Parameters configured. Important Note: To avoid Port already in use error I will be configuring hostname at the end of installation. Installation method : Offline, Oracle Database 18c XE RPM file for linux downloaded and installed. Oracle Database 18c XE Features ############################### Oracle Multitenant - # of PDBs SQLJ Microsoft Distributed Transaction Coordinator support Native .NET Data Provider—ODP.NET .NET Stored Procedures Online index rebuild Online table organization Online table redefinition Trial recovery Fast-start fault recovery Flashback Table Flashback Database Cross-platform Backup and Recovery Sharded Queues Network Compression Client Side Query Cache Query Results Cache PL/SQL Function Result Cache Adaptive Execution Plans In-Memory Column Store In-Memory Aggregation Attribute Clustering Column-Level Encryption Tablespace Encryption Oracle Advanced Security Oracle Database Vault Oracle Label Security Centrally Managed Users Fine-grained auditing Privilege Analysis Real Application Security Redaction Transparent Sensitive Data Protection Virtual Private Database Oracle Spatial and Graph Property Graph and RDF Graph Technologies (RDF/OWL) Partitioned spatial indexes Oracle Partitioning Oracle Advanced Analytics Oracle Advanced Compression Advanced Index Compression Prefix Compression (also called Key Compression) Basic Table Compression Deferred Segment Creation Bitmapped index, bitmapped join index, and bitmap plan conversions Transportable tablespaces, including cross-platform and full transportable export and import Summary management—Materialized View Query Rewrite
Views: 104 java frm
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: 11892 Manish Sharma
How to split dumpfiles into multiple files and multiple directories. /* step By Step */
 
10:44
When you Export full database and your database size is big ( like 20gb – 30gb ). So, How to break dumpfile in two or more pieces. And Your Export backup are store in these Hard disk (directory) and these HDD has less space (5gb) and your backup size is (10gb). That time we can export these backup in 2 HDD (directories). First backup piece is store in default directory and next backup piece is store in another HDD (directory).
Views: 812 Parag Mahalle
Oracle 12c R2 new features (miscellaneous)
 
06:14
In this video , I have discussed miscellaneous new features in oracle 12.2.
Views: 659 AAKASH MEHNDIRATTA
Apache Hive - Load data from local file system and HDFS to Hive table
 
14:27
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/itversityin https://twitter.com/itversity
Views: 16231 itversity
Microsoft SQL Server Table Partitioning
 
01:53
Denny Cherry talks about SQL Server Table Partitioning features which can improve query performance and reduce downtime when loading and pruning data. Denny is an independent consultant with over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny's specialties include system architecture, performance tuning, replication, and troubleshooting. He is a Microsoft Certified Master as well a Microsoft MVP, and is the principal consultant at Denny Cherry & Associates. "At SQL Saturday Silicon Valley I was talking about table partitioning and how to implement it and why do you want to implement it. It is technology that a lot of people aren't familiar with because it is an enterprise only feature so they really do not get exposed to it until they actually land at that big shop that really needs it and even once they get in to those larger shops they may not necessarily really know when to apply it and when isn't a good time to apply it and what some of the best practices are around implementing it so it is one of the things that is used for really, really large datasets so doing it wrong is really expensive because fixing it is even more expensive because we are usually talking about moving 100s of billions of [rows] may be trillions of [rows] and I mean it just takes forever to move that amount of information so having a good foundation to start on when you are doing your research is really important so that is kind of what I covered in this session today and I did some quick demos on how to actually do it, how to move data, how to truncate data quickly in a partition table and stuff like that. There is a lot of really good information on Google that you can use to learn about table partitioning. One of the nice things about partitioning is because so many few people are using it there is not a lot of bad information out there. There are a lot of videos available from PASS and from Vconference.com and various other websites that are going to give you a lot of really good information and of course you get a lot of SQL Saturday where you will find somebody talking about table partitioning in some way so you can get some good information from them as well."
Views: 1297 DesignMind
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: 318 LearnNowOnline
How To Change Temporary Files Location in Windows
 
02:22
How to change the location of your temporary files and folders in Windows 7, Windows 8 & 8.1, and Windows 10. This will be useful if your C: drive is a smaller SSD that fills up quickly. Moving your temporary file storage to another hard drive allows more freedom for your apps to take up space and do what they need to do - this is important for programs like 7Zip and WinRAR. The tabbed file browser that I use is called Clover: https://goo.gl/vajVWt Edited w/ Premiere Pro CC: https://goo.gl/rJwkQj Thanks for watching! ------------------------- ▼ Support Us! ▼ ► Patreon: http://goo.gl/XJlpSx ► StreamTip: http://goo.gl/z9E7Pg ----- ★ GEEK! - My YouTube Network ★ ✖ GEEK Network: http://goo.gl/KQXvNI ✖ GEEK Channel: http://goo.gl/KoGFxw ----- ►► Follow Us! ◄◄ ✔ Live Stream: http://goo.gl/rDirXJ ✔ Twitter: http://goo.gl/UHDmHV ✔ Facebook: http://goo.gl/aVGqKh ✔ Instagram: http://goo.gl/ppMlh9 ✔ Vlog Channel: http://goo.gl/cQfmP6 ✔ Co-Op Gaming Channel: http://goo.gl/AX5n0E ✔ Gaming Channel: http://goo.gl/5NkxkH ✔ Pokemon TCG Channel: http://goo.gl/IbdcOC ✔ Google Plus: http://goo.gl/DklBf3 ✔ Website: http://goo.gl/GK38OW ----- ✖ Sponsors & Affiliates ✖ ★ Amazon Affiliate Link: http://goo.gl/bYwmGs ★ Lynda 10-day Trial: http://goo.gl/tfuu2t ★ GreenManGaming: http://goo.gl/csfruw ★ 1Up Box: http://goo.gl/nXGcro ★ VideoBlocks: http://goo.gl/EtExb1 ----- ◆ Special thanks to Catghost for doing the art for our faces! ◆ Check her out! ◆ ✘ Catghost: http://goo.gl/ZfGAEs ✘ Midorea: http://goo.gl/Rbligj Any links to products or services may be affiliate links that give me a small kickback at no cost to you, with no influence on the content. Free #Tech_Education here! Or, #Techucation - #EposVox delivers it!
Views: 31571 EposVox
RenameDG or Add Disk to existing Disk Group
 
08:33
RenameDG or Add Disk to existing Disk Group
Views: 3000 Ritesh Raj Singh
[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
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: 879 Neovera
Solaris 11 Network Configuration with ipadm
 
07:43
More videos like this online at http://www.theurbanpenguin.com With Solaris 11 we can use ipadm to configure the IP Address of an interface at the command line and this becomes persistent after a reboot. See how this is managed in this video
Views: 16544 theurbanpenguin
how to download oracle database
 
03:08
in this video i will show you to download oracle sql plus software from internet 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: 74 The Learning Tree
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: 33 The Learning Tree
I want to shrink my database.mp4
 
04:50
Just another day in the Sql Super Hero's Cave of Best Practices. This guy wants to shrink his database.
Views: 1119 gleinjaxfl
Hands on Lab - Using Oracle Solaris ZFS
 
16:34
This Hands on Lab by Pavel Anni steps users through using the Oracle Solaris ZFS file system.
Views: 14727 Oracle Solaris
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: 153 DOit...!!!!
Resume Business Faster with Engineered Database Recovery
 
02:36
Minimize risk to your business with better protection for your critical Oracle Databases - Oracle’s Zero Data Loss Recovery Appliance, the only backup and recovery system designed by the Oracle Database team for Oracle Database protection.
Views: 2527 Oracle
Apache Hive - Create Hive External Table
 
20:40
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/itversityin https://twitter.com/itversity
Views: 8949 itversity
Accelerating query processing with materialized views in Apache Hive
 
40:32
Over the last few years, the Apache Hive community has been working on advancements to enable a full new range of use cases for the project, moving from its batch processing roots towards a SQL interactive query answering platform. Traditionally, one of the most powerful techniques used to accelerate query processing in data warehouses is the precomputation of relevant summaries or materialized views. This talk presents our work on introducing materialized views and automatic query rewriting based on those materializations in Apache Hive. In particular, materialized views can be stored natively in Hive or in other systems such as Druid using custom storage handlers, and they can seamlessly exploit new exciting Hive features such as LLAP acceleration. Then the optimizer relies in Apache Calcite to automatically produce full and partial rewritings for a large set of query expressions comprising projections, filters, join, and aggregation operations. We shall describe the current coverage of the rewriting algorithm, how Hive controls important aspects of the life cycle of the materialized views such as the freshness of their data, and outline interesting directions for future improvements. We include an experimental evaluation highlighting the benefits that the usage of materialized views can bring to the execution of Hive workloads. Speaker: Jesus Camacho Rodriquez, Member of Technical Staff, Hortonworks
Views: 359 DataWorks Summit
Convert your existing Windows System into a Virtual Machine
 
05:01
Convert your existing Windows System into a Virtual Machine If your looking to create a virtual machine of your operating system the your currently using, then this video is for you. In this video we will take a look at making a copy of our current OS and use virtualbox to run our Virtual Machine http://technet.microsoft.com/en-gb/sysinternals/ee656415.aspx Disk2vhd is a utility that creates VHD (Virtual Hard Disk - Microsoft's Virtual Machine disk format) versions of physical disks for use in Microsoft Virtual PC or Microsoft Hyper-V virtual machines (VMs). VMware vCenter Converter Standalone Paragon Hard Disk Manager 12 Suite http://www.briteccomputers.co.uk
Views: 125416 Britec09
Folder Access Denied: How to delete any folder in Windows 10
 
02:20
This is a tutorial on how to delete folders in Windows 10 which can not be deleted due to a "Access denied" error. This video shows you how to take ownership of the folder to delete the folder. Steps have also been listed in this pastebin: https://pastebin.com/fPtsJP50 --- Clouds by Joakim Karud http://soundcloud.com/joakimkarud Music provided by Audio Library https://youtu.be/YrvBTBmqVPE ---
Views: 41598 Max Mustermann
How To Backup A Virtual Machine On Linux With VirtualBox
 
04:57
Linux is often used for virtualization, and one of the most popular virtualization tools that people use is Oracle’s VirtualBox. It’s a great tool that makes it very easy to virtualize all different types of operating systems. In this article today, we’ll cover all of the ways users can backup a virtual machine. More info at https://www.addictivetips.com/ubuntu-linux-tips/backup-a-virtual-machine-on-linux-with-virtualbox/
Views: 227 AddictiveTipsTV
Solaris 11 Upgrade TEXT to GUI
 
09:54
More videos like this online at http://www.theurbanpenguin.com In this video we look at taking a text only intsall of Oracle Solaris 11 and adding the GUI to it. We will do this safely using Boot Enviorments so if we have issues with the GUI we can roll back to our saved BE. This is easy within Solaris 11 and we can make use of the ZFS filesystem that goes way beyond the capabilities of what you may expect. So first we will create an new BE with BEADM create and then mount the BE to a temporary directory and install the GUI to that BE, or snapshot of our system. We will now have two BE that we can choose to boot to, the original Solaris image and now our new GUI. When we want to test the GUI we activate the GUI BE and if that is ok we can delete or "destroy" the old BE.
Views: 9011 theurbanpenguin
World class compression for optimizing your growing data warehouse - IBM InfoSphere Warehouse
 
00:58
Todays data storage demands can have a painful effect on application performance. The Deep Compression capabilities of IBM InfoSphere Warehouse make it possible to manage your data assets and storage more intelligently. See how InfoSphere Warehouse will help you do more with less.
Views: 170 Lawrence Weber
How to Delete Files That Cannot Be Deleted - Windows 10,8,7,XP (Compress to RAR file)
 
02:47
How to Delete Files That Cannot Be Deleted Methods:Windows 10, 8,7,XP. Download and install winrar it is completely free Watch my video. Winrar : http://www.rarlab.com/download.htm .......................................................................................... Watch my other video: (1)How to make bootable pendrive using windows USB/DVD tool https://youtu.be/YC1w53BgGSc (2) How to disable windows 10 update - 100% working https://youtu.be/x-SYkK4Cc0s ..................................................................................................... Description : If you're trying to delete a file and your computer isn't letting you, it's most likely because another program is currently trying to use the file. This can occur even if you don't see any programs running. Deleting these files is usually a matter of forcing the program that's using the file to close. Be careful when doing this; deleting the wrong file can have nasty effects on your system. ............................. How to delete or rename a file in use | How to delete a corrupt file or a locked file in Windows ............................................. Every experienced PC user is familiar with error messages along the lines of "This file is still in use". Unfortunately, while Windows is quite keen on educating users on their lack of access, it doesn't always tell which program is to blame. Here's how to successfully deal with locked files, and rename or delete them. ......................................... FAQ How to delete or rename a file in use in Windows, How to Delete Files That Cannot Be Deleted, How To Delete A Folder That Won't Delete, Cannot delete file or folder, Item Not Found error, How to Delete Undeletable File, Deleting folders which cannot be deleted, how to delete folder using cmd, how to delete folder access denied, How to Delete Files That Cannot Be Deleted, could not find this item, this is no longer located in C, location and try again, ALL SOLVED. ........................................................................................................ Subscribe AAK It's free : https://bit.ly/2xYvQYp Subscribe AAK VLOGS It's free too: https://bit.ly/2oNHQoe Like My Official Facebook Page The AAK https://bit.ly/2H56xmN Like My Official Facebook Page AAK VLOGS : https://www.facebook.com/AakVlogs Follow me On Instagram : https://www.instagram.com/aak_vlogs/ Follow me On Twitter : https://twitter.com/Aak_Vlogs ShopAAK https://www.facebook.com/ClickShopAAK/ Join AAK Global Group https://www.facebook.com/groups/AAKVLOGS THANKS FOR WATCHING...........!
Views: 191812 Aak Vlogs
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: 247 DB2NightShow
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: 1612 Editions ENI