Home
Search results “Oracle segment shrinking”
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: 7256 BhagyaRaj Katta
How to Shrink table in Oracle..
 
11:52
this video will help how to reclaim space from the table.
Views: 1925 oracdb
Shrink Space
 
06:33
#Oracle #ShrinkSpace
Views: 1922 Hemant K Chitale
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/
SCPT 46:Oracle Storage Termininology:  High Water Mark and Free Lists
 
15:31
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 18469 Oresoft LWC
UNDO MANAGEMENT - MONITORING UNDO DATA
 
11:21
Hello friends in this video i am going to explain you to that how to administer the undo for retain the old values and help in recovery time. #UNDOMANAGEMENT #MONITORINGUNDODATA Oracle database Unbeatable,Unbreakable Platform..
Views: 3470 Oracle World
Quickfix: Tablespace full to resize tablespace
 
02:11
Quickfix is a demonstration on how to fix a spesific database issue. In this video we detect that a tablespace is full and go through the steps to resize the tablespace.
Views: 1896 dbWatch As
WHAT IS AN UNDO TABLESPACE - Oracle database Administration
 
04:28
Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator. Website: https://newayitsolutions.com Subscribe: https://newayitsolutions.com/page Enroll: https://newayitsolutions.com/enroll Youtube: newayitsolutions ------------------------------------------------------------------------------------------------------------------------------------------------------------- Follow on Facebook: https://www.facebook.com/newayitsolutions/ Follow on Twitter: https://twitter.com/Theoracledbaguy Follow on Instagram: https://www.instagram.com/oracledbatrainer/ Financing Available: https://newayitsolutions.com/loan-application School Locations: Atlanta, Maryland, Virginia ------------------------------------------------------------------------------------------------------------------------------------------------------------- Office Contact: 1-866-569-0205 Mobile Contact: 240-244-9935
Views: 3999 NewayITSolutions LLC
DBA | Oracle DBA | Tablespace | Temp Basics
 
00:41
DBA concepts
Views: 43 iTubers
【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: 66 崔旭
Frgmentation in oracle database
 
34:54
Fragmentation in oracle database,find and defragmentation
Views: 4130 Sainora Annanagar
09 06 Monitoring Index Usage
 
04:27
ORACLE
Views: 141 oracle ocm
Chained rows? Migrated rows?
 
10:37
Understanding the basics of what happens when rows are just too damn big. blog: https://connor-mcdonald.com Highlights from the June DBA Office Hours session. Subscribe as new tech videos come every week!
Views: 682 Connor McDonald
How do I find the Overall Database size ?
 
13:58
Hi friend in my today scenario you learn how to find the total database size ? Oracle database Unbeatable,Unbreakable Platform.. #Databasesize
Views: 3128 Oracle World
How to work with Tablespaces in Real-Time? Tablespace Administration
 
01:00:59
https://dbagenesis.com/p/oracle-11g-advanced-dba Oracle tablespace administration - Learn how to work on tablespaces in real-time. - Tablespace management tasks - Tablespace utilization - Add space to tablespace - Add new tablespace - Tablespace best practices - Drop tablespace A tablespace is constructed by Oracle from one or more operating system files through the use of the CREATE TABLESPACE command. Every Oracle database consists of at least one tablespace, called SYSTEM.
Views: 15915 DBA Genesis
Honey, I Shrunk... Carl Winslow?!? (Family Matters)
 
03:38
Steve shrinks himself and Carl. Oops! Scene from Family Matters S7 episode: Little Big Guy Subscribe today for more clips, TV theme songs, and other treats from Warner Bros.' Warner Archive Collection! ------ 2,000+ Rare films, TV movies, and series on DVD and Blu-ray direct from Warner Bros. Studio. http://www.warnerbros.com/warnerarchive
Views: 599440 warnerarchive
Oracle High Water Mark
 
02:31
A Brief video about Oracle's Table High Water Mark and How to resolve issues associated with it Music: https://www.bensound.com
Views: 345 ORA-600
21. Alter Tablespace in Oracle
 
06:33
In this video you will learn how to learn tablespace to add new datafile,or add existing datafile in tablespace. You will also learn how to list available tablespace and datafile in oracle database engine. At the end you will learn how to drop tablespace. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 26883 ITORIAN
Oracle Database 10g: New Features for Administrators
 
01:41
This course introduces students to the new features in Oracle Database 10g - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves. Course Objectives: Implement improved manageability features to simplify database management Utilize database advisors to provide proactive database monitoring Increase data availability through Oracle Database 10g features that offer improved point in time recovery Assist developers using Oracle Database 10g features in their applications ________________________________________ Course Topics: Introduction How DBAs Spend Their Time Oracle Database 10g Manageability Goals Oracle Database 10g Solution: Self-Managing Database Grid Computing Oracle Database 10g: The Database for the Grid Installation Installation Performance Enhancements Installation New Feature Support Automatic pre & post install validations CD pack contents Server Configuration Database Features Usage Tracking Automatic Enterprise Manager Configuration Simplified Initialization Parameters Simplified Database Install Load and Unload Data Cross-platform Transportable Tablespaces External Tables Unload DataPump Export and Import Utilities Automatic Management Automatic Checkpoint Tuning Automatic Database Diagnostic Monitor Automatic Shared Memory Tuning Automatic Optimizer Statistics Collection Automatic Undo Retention Manageability Infrastructure Advisory Framework Automatic Routine Administration Tasks Server-generated Alerts / Threshold-based Alerts Automatic Workload Repository Application Management and Availability SQL Access Advisor SQL Tuning Advisor New performance overview charts in EM Rule-based optimization (RBO) obsolescence SQL Support for Analytical Applications MERGE Command Enhancements Partitioned Outer Join Integrating Interrow Calculations in SQL Summary Management Enhancements System Resource Management Setting Idle Timeouts Switching Back to the Initial Consumer Group at End of Call Database Resource Manager - Adaptive Consumer Group Mapping Monitoring the Resource Manager The Scheduler Core Scheduler Features Privileges for Scheduler Components Calendaring Expressions Advanced Scheduler Concepts Space Management Segment Advisor New Segment Resource Estimation Online Segment Shrink Proactive Tablespace Management Undo Advisor Sorted Hash Clusters Improved VLDB Support Bigfile Tablespace Enhanced Partition Management in Enterprise Manager Global Partitioned Indexes - Hash Partitioning Local Partitioned Indexes Manageability Improvements Temporary tablespace groups RMAN Enhancements Flash Backup and Recovery Backup Compression Drop Database Automatic Channel Failover for Backup & Restore Incrementally Updated Backups Simplified Recovery Through Resetlogs Flashback Any Error Flashback Database Flashback Table Flashback Versions Query Flashback Transaction Query Flashback Drop General Storage Management Rename Tablespace Redo Logfile Sizing Advisor SYSAUX Tablespace Copying Files using the Database Server Automatic Storage Management Data mirroring with ASM ASM Dynamic Rebalancing ASM Striping ASM General Architecture ASM Disk Groups Failure Groups Maintain Software Oracle Database 10g Upgrade Paths Easy Upgrade (key DBUA features / one script upgrade) Upgrade Information Tools (pre/post) Security Enhancements VPD Static and Dynamic Policies Column-level VPD Uniform Audit Trail Miscellaneous New Features Transaction Monitoring End-to-End Tracing Logminer Enhancements Resumable Space Allocation Enhancements Regular Expression functions
Views: 10161 critiquemusicale
SQL Server Quickie #2 - Extents
 
14:53
In this video we are talking about Extent Management in SQL Server.
Views: 8320 SQLpassion
Reclaiming free space from innodb tables
 
06:05
Reclaiming free space from innodb tables
Views: 178 Ask Guru
how to find FULL DATABASE SIZE in  ORACLE
 
05:09
while we are taking FULL DATABASE BACKUPS , first we need to know the SIZE OF OUR DATABASE. so that if we know the size we can make that much of space available for the backup. so, this video explains how to find the FULL DATABASE SIZE.
Views: 4082 P-Square Technologies
Oracle CEO: AI is integrated into our autonomous database
 
03:46
Oracle CEO Mark Hurd on the company's investment in its NetSuite division, the app market, cloud computing and the use of artificial intelligence in its database. FOX Business Network (FBN) is a financial news channel delivering real-time information across all platforms that impact both Main Street and Wall Street. Headquartered in New York — the business capital of the world — FBN launched in October 2007 and is the leading business network on television, topping CNBC in Business Day viewers for the second consecutive year. The network is available in more than 80 million homes in all markets across the United States. Owned by FOX, FBN has bureaus in Chicago, Los Angeles, Washington, D.C. and London. Subscribe to Fox Business! https://bit.ly/2D9Cdse Watch more Fox Business Video: https://video.foxbusiness.com Watch Fox Business Network Live: http://www.foxnewsgo.com/ Watch full episodes of FBN Primetime shows Lou Dobbs Tonight: https://video.foxbusiness.com/playlist/longform-lou-dobbs-tonight Trish Regan Primetime: https://video.foxbusiness.com/playlist/longform-trish-regan-primetime Kennedy: https://video.foxbusiness.com/playlist/longform-kennedy Follow Fox Business on Facebook: https://www.facebook.com/FoxBusiness Follow Fox Business on Twitter: https://twitter.com/foxbusiness Follow Fox Business on Instagram: https://www.instagram.com/foxbusiness
Views: 2704 Fox Business
Oracle Database: Embrace New Features, But Don't Forget the Basics
 
06:41
Of course it's important to stay on top of changes and new features in Oracle Database and the other technologies with which you regularly work. "But it's always good to go back and buckle up on some of the basics and reinforce the things you might have known but forgot that you knew," says Mark Williams, principal consultant at Cintra Software and Services. In this interview recorded at ODTUG Kscope 2018 Mark also discusses how cloud computing and other changes are shrinking the divide between DBAs and developers. Check it out! https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 71 Oracle Developers
TABLESPACE MANAGEMENT DATAFILE SIZE ENABLE DISABLE AUTOEXTEND ON
 
02:50
HOW TO ENABLE/DISABLE AUTOEXTEND ON FOR A DATAFILE ================================================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\GOODKING01.DBF' autoextend on; HOW TO FIND THE SIZE OF A DATAFILE ================================== SELECT SUBSTR (df.NAME, 1, 50) file_name, df.bytes / 1024 / 1024 allocated_mb, ((df.bytes / 1024 / 1024) - NVL (SUM (dfs.bytes) / 1024 / 1024, 0)) used_mb, NVL (SUM (dfs.bytes) / 1024 / 1024, 0) free_space_mb FROM v$datafile df, dba_free_space dfs WHERE df.file# = dfs.file_id(+) GROUP BY dfs.file_id, df.NAME, df.file#, df.bytes ORDER BY file_name; set lines 180 pages 200 col tablespace_name for a20 col file_name for a55 select tablespace_name,file_name,autoextensible from dba_data_files;
Views: 1291 Praveen Biyyapu
Ingrowing - Fragmented Oracle
 
02:57
Czech death metal/grindcore band Ingrowing. Song is Fragmented Oracle from their album Sunrape (2003). Hang out with us at: https://www.facebook.com/GrindOverMatter1
Views: 385 Grind Over Matter
How to Perform Resumable Space Allocation in Oracle. /* Step By Step /*
 
19:56
We can perform Resumable space allocation on Tables. Resumable space allocation, introduced in Oracle 9i, is for all tablespaces at the session level. Database operations are suspended when an out-of-space condition is encountered. These suspended operations automatically resume when the error condition disappears. This feature is very easy to understand. And easy to Implement on any tables.
Views: 738 Parag Mahalle
Oracle Advisor Framework: Database Advisors Concepts And Hands-On Demos 1
 
43:04
In this tutorial you will learn about the oracle advisor framework, concepts and hands-on demos for different database advisors.
Views: 989 DBA Pro
How to See Schema Size, Used Space, Remaining Space, Tables, Table Sizes Using SQL
 
08:02
How to See Schema Size, Used Space, Remaining Space, Tables, Table Sizes Using SQL
Views: 892 Raihan Shafique
SEGMENT SPACE MANAGEMENT
 
26:19
SEGMENT SPACE MANAGEMENT/SPACE PARAMETER
Views: 697 Sainora Annanagar
Table Compression Enhancement in Oracle Database 11g R2
 
05:00
Table Compression: Overview Oracle Database supports three methods of table compression: 1.Basic table compression 2.OLTP table compression Oracle Corporation recommends to compress all data to reduce storage costs. The Oracle database can use table compression to eliminate duplicate values in a data block. For tables with highly redundant data, compression saves disk space and reduces memory use in the database buffer cache. Table compression is transparent to database applications. The table_compression clause is valid only for heap-organized tables. The COMPRESS keyword enables table compression. The NOCOMPRESS keyword disables table compression. NOCOMPRESS is the default. With basic compression, the Oracle database compresses data at the time of performing bulk load using operations such as direct loads or CREATE TABLE AS SELECT. With COMPRESS FOR OLTP, the Oracle database compresses data during all DML operations on the table.
Views: 2493 Saurabh Joshi
Oracle LOBS
 
31:33
Oracle LOBS
Views: 2085 The Silent DBA
20. Tablespace and Datafile in Oracle
 
04:34
In this video you will learn about Tablespaces and Datafiles in detail. We are going to cover something theoretically here because you will be using it frequently in next videos so it is good to watch this before proceeding. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 31515 ITORIAN
Oracle Database Files -  DBArch Video 5
 
09:07
In this video you learn about the storage components in an Oracle Database. You learn about the different files , Data files, Control Files and Redo log files and their purpose in an Oracle Database Architecture. learn Oracle, learn Oracle database. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 21011 Ramkumar Swaminathan
Manage Compression with Enterprise Manager Cloud Control 12c
 
05:10
This video shows you how to access ADO in an Oracle Database 12c managed target, how to use the heatmap to gain a graphical overview over data access, including drilling down to tablespace and segment level, and how to add a Automatic Data Optimization policy to a table. Note that the Cloud Control 12c features depicted here are only applicable to Oracle Database 12c managed targets. Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement. Note that the Cloud Control 12c features depicted here are only applicable to Oracle Database 12c managed targets.
Table size ,Number of records,Disk usage in SQL Database,clear logs,cache
 
06:51
This clip will show you how to check each Table size, Number of records, Disk usage in SQL Database. You can see how to write the query to get details of all tables in terms of size, records, space utilization and free space on disk for tables. http://daynamicsaxaptatutorials.blogspot.com This is axapta ERP blog for Technical and functional fields and includes Microsoft Dynamics Axapta tutorials and Dynamics Axapta Coverage. This blog also contains x++ code help for Ax developer and solution of technical and functional daily issues. This blog is specific for Microsoft dynamics programming. Enterprise portal, SharePoint services, business connectors and Enterprise Resource Planning applications and sql database.It will help to get Microsoft Business Solutions. SQL subpart, SQL remainder, SQL language, SQL unit, SQL making, SQL portion, SQL auto, SQL part, SQL addition, SQL picture, SQL element, SQL supplement, SQL heating, SQL element, SQL hardware, SQL constituent, SQL factor, SQL constituent, SQL part, SQL residue, SQL unit, SQL butt, SQL basis, SQL appurtenance, SQL landside, SQL module, SQL crystal, SQL spare, SQL part,SQL section, SQL ingredient, SQL base, SQL balance, SQL residuum, SQL meronymy, SQL portion, SQL item, SQL substance, SQL part, SQL to, SQL whole, SQL relation, SQL spark, SQL gap, SQL car, SQL part, SQL pel, SQL audio, SQL computer, SQL hardware, SQL element, SQL pixel, SQL improver, SQL spare, SQL retrofit, SQL ingredient, SQL add-on, SQL input, SQL accessory,division, SQL point, SQL constituent, SQL part, SQL be-all, SQL and, SQL end-all, SQL plot, SQL element, SQL be, SQL all, SQL and, SQL end, SQL all, SQL element, SQL detail, SQL component, SQL part, SQL member, SQL rest, SQL linguistic, SQL unit, SQL relation, SQL particular, SQL residual, SQL part,
Views: 996 Santosh kumar Singh
Complete guide to file system shrinking and reducing the size of the underlying logical volume.
 
13:31
The Complete guide to ext2, ext3 and ext4 file system shrinking and reducing the size of the underlying logical volume in Linux. Red Hat Enterprise Linux v7 - RHCSA EX200 exam task: reduce the size of a file system. If you will be shrinking the size of the file system in your production Environment in work there are two things which you have to consider: 1) file system type musts support shrinking - XFS which is default file system in Red Hat Enterprise Linux 7 does not support shrinking at all. 2) ext2, ext3 and ext4 file systems don't support on-line shrinking so they must be unmounted during shrinking. Also best practice is to have up to date backup before you perform file system shrinking. So our given task is to shrink file system /u03 to 1GB. --- 1) First we will run "df -h" command to find out current size of our /u03 file system. 2) We will run "mount | grep u03" command to find out what is the type of the file system. 3) ext2, ext3 and ext4 file systems don't support on-line shrinking so we will unmount the file system with command: unmount /u03 4) Before we will shrink file system we will perform file system check with command: e2fsck -f /dev/datavg/lv_u03 where: -f option will force checking even if the file system seems clean. NOTE: you can use both /dev/mapper/datavg-lv_u03 or /dev/datavg/lv_u03 as parameter to command e2fsck and commands which we will use later because both of /dev/mapper/datavg-lv_u03 and /dev/datavg/lv_u03 are symbolic links to /dev/dm-4 in our case. 5) Now we can shrink file system with command: resize2fs -p /dev/datavg/lv_u03 1G where: -p option prints out a percentage completion bars for each resize2fs operation, so we can track what the program is doing. 1G : will set the size of the file system to 1GB - you can use M for Megabytes or K for kilobytes. 6) We can use output of resize2fs command to calculate new exact size of the logical volume. Size of the Logical Volume should be the same as size of a file system. It is not efficient but logical volume size can be a little bit bigger then size of the file system - we can then for example extend file system size to match logical volume size, but size of the logical volume can not be smaller then size of the file system. 7) Reduce the size of logical volume to 1GB: lvreduce -L 1048576K /dev/datavg/lv_u03 where: -L 1048576K : will set the size of the logical volume to 1GB you can use M for Megabytes or G for gigabytes and so on … NOTE: you can use also below alternatives to lvreduce command in our scenario: lvreduce -L -3145728K /dev/datavg/lv_u03 where: -3145728K means that current size of logical volume will be reduced by 3145728K or lvreduce -l 256 /dev/datavg/lv_u03 where: -l 256: means that size of the logical volume will be set to 256 logical extents which is 1GB in our scenario because size of logical extent is 4MB in our case or lvreduce -l -768 /dev/datavg/lv_u03 where: -l -768 means that size of the logical volume will be reduced by 768 logical extents which is 3GB in our scenario because the size of the logical extent is 4MB in our case. NOTE: You can find out size of the logical extent by running “vgdisplay datavg”. 8) Now we will check file system once again with command: e2fsck -f /dev/datavg/lv_u03 where: -f option will force checking even if the file system seems clean. 9) We will mount file system mount /u03 10) We will verify the NEW size of the file system with command: df -h /u03 --- File system shrinking and reducing the size of the underlying logical volume with only one command. In this case we will shrink /u02 file system from 4GB to 1 GB again. 1) First we will run "df -h" command to find out current size of our /u02 file system. 2) Shrink file system and reduce the size of underlying logical volume: lvresize -L 1G -r /dev/mapper/datavg-lv_u02 where: -L 1G : will set the size of the logical volume to 1GB. You can use M for Megabytes or K for kilobytes and so on ... -r option will re-size the file system together with the logical volume. Command "lvresize -L 1G -r /dev/mapper/datavg-lv_u02" performed all tasks which we had to do manually before: - unmounted our file system - performed file system check - shrank file system to 1GB - and also reduced the size of logical volume to 1GB as well. 3) We will confirm new size of the file system with "df -h /u02" command. --- Please remember that - first you have to shrink size of the file system - and only after size of the file system has been successfully reduced then you can reduce size of the underlying logical volume. --- Related Video Tutorials: RHCSA Fast Track course: Reset forgotten root password in Redhat 7: https://youtu.be/cUG16kdYCxE Shrink ext2 ext3 and ext4 file system and reduce the size of a logical volume with only one command. https://youtu.be/tTpStv6cfeQ === I am currently working on: Shrink ext2 ext3 and ext4 file system and recreate underlying disk partition with smaller size.
How to shrink and create a new partition
 
00:52
See how to shrink and create a new partition. For discussions visit http://computertipsforum.com/
Views: 47 Srikanth Valluri
Oracle Data Storage
 
09:58
CAPTIONS AVAILABLE - Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. How Oracle stores your tables, how they grow, and how they can go bump.
Views: 8239 roughsealtd
TEMP In oracle
 
10:22
Views: 538 Sainora Annanagar
Database 12c Managing Space
 
15:42
Oracle DB 12c Managing Space
Views: 104 Ora Tube
dbms advisor package   After 5.00 dbms_sql.quick_tune at  8,20
 
09:19
Please ignore from 3.00 to 5.00 sound mixing issues. Understand different advisor like undo advisor ,segment advisor ,acess advisor ,memory advisor, acess advisor shall tell you where you need to add a index,etc Using oem we are seeing the various advisor at 3.27 At 5.00 we are actually using dbms_advisor package dbms_advisor oracle dbms_advisor
Tablespace management II
 
20:18
In this vedio how to create big datafile,how to create temp tablespace,default tablespace and some important views in tablespace management II .....thanks you for watching...
Views: 53 Adam Mulla
Day 1 Wrap | Oracle OpenWorld 2013
 
12:23
Oracle OpenWorld 2013 (#oow13) is in full swing this week. theCUBE hosts Dave Vellante, Jeff Kelly, and Stu Miniman sat down after day one at Oracle OpenWorld to discuss Larry Ellison's opening keynote, what they expected to see and hear at Oracle OpenWorld this year, and everything in between. Oracle's messaging is marching to the beat of a new drum, putting the key value in storage, NoSQL databases, filtering in Hadoop and bringing data into analytics systems. "Oracle has become a Big Data company," shares Vellante in theCUBE's Intro segment at the start of our live broadcast from OpenWorld. According to Vellante, it seems Oracle's recognized the trend trend developing towards Big Data, seeing how much data and analytics have changed the way business is done. Oracle has a game plan for such trends, integrating systems to make Big Data much simpler and more accessible for its customers in the cloud. Lets recap the other top stories out of Oracle OpenWorld 2013 so far: Ellison Keynote Highlights : Oracle's Answer to SAP HANA + More A big part of Oracle CEO Larry Ellison's keynote was about Oracle's SAP HANA competitor, debuting Oracle's answer to its rival. Dubbed simply as the "In-memory option," it is the latest upgrade to Oracle's database product, designed to target both transactional and analytical workloads, and promises to deliver "ungodly" improvements to performance. It is Oracle's response to SAP's HANA In-memory database in hopes of preventing customers from jumping ship from Oracle to SAP. Oracle's main concern is that many of its customers use SAP software alongside what Oracle is offering. Oracle's packaging more into its stack to provide better IaaS and SaaS. QLogic + Oracle Launch Protocol-Independent Universal HBA | #oow13 David Ard, OEM Marketing at QLogic, discussed the newly launched Oracle Sun Storage Universal HBA and the ongoing fibre-ethernet protocol debate with theCUBE co-hosts Dave Vellante and Stu Miniman, live at Oracle OpenWorld 2013. Longtime partners QLogic and Oracle announced the new Oracle Sun Storage 16 Gb Universal HBA which according to Ard, helps companies "make an investment into a server and their storage interconnects" in this solution. Flash: Real-Time Solution for "Shrinking Infrastructure" Says Fusion-IO | #oow13 Gary Orenstein, the EVP at Fusion-io, discussed flash and storage market trends with theCUBE co-hosts Dave Floyer and Dave Vellante, live from the 2013 edition of Oracle OpenWorld. What are flash's biggest benefits in real-time? Answer: transforming applications and innovating in open source. Host David Floyer mentioned that when it comes to real time or near-real time analytics, the requirement for flash is very important. Orenstein then explained that real time is achievable with flash technology, which runs in the server. "There really is no room for something that's not real-time in this day and age." Fusion-io believes that the open source arena is going to continue to provide the innovation that is needed to showcase what is possible with these new technologies, flash included. Day 1 Wrap, Oracle OpenWorld 2013 with John Furrier and Dave Vellante @thecube #oow13
Change Undo Tablespace in Oracle
 
05:17
Si te gusto dale me gusta y suscribete !!
Views: 154 FULL-ORACLE
MasterCard Morning Brew: World Shrinks; Cashless Generation Unites
 
02:38
Carlos Menendez visits MasterCard headquarters in Purchase, NY from London, England. He talks about the similarities of 20somethings everywhere and how that's impacting the payments industry. In fact, specific to that segment, only 35% of transactions are still done in cash and check in the U.S.
Views: 312 Mastercard News

Science museum los angeles ca
Bike rental bend oregon
Embassy suites orlando international drive south
Chicago rain totals
Urban planning jobs detroit