Home
Search results “Ss contention oracle”
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: 7420 BhagyaRaj Katta
Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans
 
12:33
In this video I describe how you can use Oracle's DBMS_XPLAN.DISPLAY_CURSOR to examine the execution plan for a SQL statement that has recently been executed and determine if that plan is optimal or not and where you might be able to optimize it.
Views: 11080 Maria Colgan
Oracle Database Cloning via RMAN Restore Recover Method
 
23:58
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, a remote server will a different file structure or the local server with a different file structure. Cloning the database on the remote host requires two servers. Both servers should have Oracle Software installed on them.
Views: 6782 DBA Genesis
Coldplay - A Sky Full of Stars (Lyrics)
 
04:25
Lyric video: A Sky Full of Stars by Coldplay. Coldplay - A Sky Full of Stars Coldplay - A Sky Full of Stars Coldplay - A Sky Full of Stars (Lyrics) I hope you like it!! :D I recently started a new skyrim series! Please have a look at the first video: https://youtu.be/2mdIza-RptM This is the download link for the background https://free4kwallpapers.com/wallpaper/anime/anime-scenic-sky-bird-starry-sky/M1NO All credit and all rights belong to Coldplay and their respective partners. I do not own this song, nor do i claim to do so. Don't forget to like, subscribe and comment. And follow me on Twitter. https://twitter.com/AdamMoore053
Views: 36415920 AnimeOracle
Evolution of Music - Pentatonix
 
04:29
TICKETS TO THE FIRST LEG OF ‘PENTATONIX: THE WORLD TOUR' ON SALE NOW http://www.ptxofficial.com/tour 5/11/2019 - Oracle Arena - Oakland, CA 5/14/2019 - Save Mart Center - Fresno, CA 5/16/2019 - The Forum - Inglewood, CA 5/19/2019 - Pepsi Center - Denver, CO 5/21/2019 - BOK Center - Tulsa, OK 5/23/2019 - AT&T Center - San Antonio, TX 5/25/2019 - Von Braun Center - Huntsville, AL 5/26/2019 - KFC Yum! Center - Louisville, KY 5/30/2019 - Greensboro Coliseum Complex - Greensboro, NC 6/1/2019 - Amway Center - Orlando, FL 6/2/2019 - James Brown Arena - Augusta, GA 6/4/2019 - PPL Center - Allentown, PA 6/6/2019 - Madison Square Garden - New York, NY 6/8/2019 - DCU Center - Worcester, MA 6/9/2019 - Mark G Etess Arena - Atlantic City, NJ 6/11/2019 - Centre Bell - Montreal, Canada 6/13/2019 - Mohegan Sun Arena - Uncasville, CT 6/15/2019 - Van Andel Arena - Grand Rapids, MI 6/16/2019 - Nationwide Arena - Columbus, OH 6/18/2019 - Fiserv Forum - Milwaukee, WI 6/20/2019 - Bridgestone Arena - Nashville, TN 6/22/2019 - Taxslayer Center - Moline, IL 6/23/2019 - Resch Center - Green Bay, WI 6/25/2019 - Xcel Energy Center - St. Paul, MN 6/26/2019 - Fargodome - Fargo, ND 6/28/2019 - Scotiabank Saddledome - Calgary, Canada 6/30/2019 - Rogers Place - Edmonton, Canada 7/2/2019 - Rogers Arena - Vancouver, Canada 7/3/2019 - Tacoma Dome - Tacoma, WA 7/6/2019 - Mandalay Bay Events Center - Las Vegas, NV 7/7/2019 - Lake Tahoe Outdoor Arena at Harveys - Stateline, NV 8/11/2019 - Hollywood Casino Amphitheatre - Maryland Heights, MO 8/13/2019 - Starlight Theatre - Kansas City, MO 8/14/2019 - Illinois State Fair - Springfield, IL 8/15/2019 - Ravinia Festival - Highland Park, IL 8/17/2019 - Iowa State Fair - Des Moines, IA 8/19/2019 - Brandon Amphitheater - Brandon, MS 8/20/2019 - Amphitheater at the Wharf - Orange Beach, AL 8/22/2019 - Tuscaloosa Amphitheater - Tuscaloosa, AL 8/24/2019 - Daily's Place - Jacksonville, FL 8/26/2019 - Merriweather Post Pavillion - Columbia, MD 8/27/2019 - Constellation Brands – Marvin Sands Performing Arts Center (CMAC) - Canandaigua, NY 8/29/2019 - Bank of New Hampshire Pavilion - Gilford, NH 8/31/2019 - Bethel Woods Center for the Arts - Bethel, NY 9/1/2019 - Canfield Fair – Canfield, OH GET ‘THE SOUND OF SILENCE' NOW! http://smarturl.it/TS0Sptx?IQid=yt iTunes - http://smarturl.it/TS0Sptx/itunes?IQid=yt Apple Music - http://smarturl.it/TS0Sptx/applemusic?IQid=yt Spotify - http://smarturl.it/TS0Sptx/spotify?IQid=yt Amazon - http://smarturl.it/TS0Sptx/az?IQid=yt Google Play - http://smarturl.it/TS0Sptx/googleplay?IQid=yt Join our Patreon Fan Page!! http://www.patreon.com/pentatonix BUY CHRISTMAS IS HERE! http://smarturl.it/pTXmasIsHere?IQid=yt BUY PTX PRESENTS: TOP POP, VOL. http://smarturl.it/PTXTPV1?IQid=yt BUY PENTATONIX THE ALBUM http://smarturl.it/PTXalbum?IQid=yt BUY PTX VOL. 4 - CLASSICS EP http://smarturl.it/PTXVol4iT?IQid=yt BUY PTX VOL III http://smarturl.it/PTXVol3?IQId=yt BUY PTX VOL II http://smarturl.it/PTXVolume2?IQid=yt BUY PTX VOL I http://smarturl.it/PTXVol1?IQid=yt BUY A PENTATONIX CHRISTMAS (DELUXE) http://smarturl.it/APTXmasDlxD?IQid=yt BUY THAT'S CHRISTMAS TO ME (DELUXE) http://smarturl.it/TCTMDlxiT?IQid=yt BUY PTXMAS http://smarturl.it/PTXmas?IQId=yt STREAM CHRISTMAS IS HERE! http://smarturl.it/pTXmasIsHere?IQid=yt STREAM PTX PRESENTS: TOP POP, VOL. http://smarturl.it/PTXTPV1?IQid=yt STREAM PENTATONIX THE ALBUM http://smarturl.it/PTXalbumS?IQid=yt STREAM PTX VOL. 4 - CLASSICS EP http://smarturl.it/StreamPTXVol4?IQid=yt STREAM PTX VOL III http://smarturl.it/PTXVol3Spot?IQid=yt STREAM PTX VOL II http://smarturl.it/PTXV2Spotify?IQid=yt STREAM PTX VOL I http://smarturl.it/PTXV1Spotify?IQid=yt STREAM A PENTATONIX CHRISTMAS (DELUXE) http://smarturl.it/APTXmasDlxD/spotif... STREAM THAT'S CHRISTMAS TO ME (DELUXE) http://smarturl.it/TCTMDlxS?IQid=yt STREAM PTXMAS http://smarturl.it/PTXmas1Sp?IQid=yt ON MY WAY HOME THE DOCUMENTARY | AVAILABLE NOW! ITUNES: http://smarturl.it/PTXOMWHi?IQid=yt AMAZON: http://smarturl.it/PTXOMWHDVD?IQid=yt http://www.ptxofficial.com http://www.twitter.com/ptxofficial @ptxofficial http://www.facebook.com/Pentatonix http://www.instagram.com/ptxofficial @ptxofficial http://www.snapchat.com/add/PTXsnap
Views: 126382969 PTXofficial
Implementing MAC Example
 
02:36
This video is part of the Udacity course "Intro to Information Security". Watch the full course at https://www.udacity.com/course/ud459
Views: 1387 Udacity
Apostle Johnson Suleman in "OLOLUFEMI"
 
05:19
THIS A LOVE SONG BY GOD'S SERVANT APOSTLE JOHNSON SULEMAN FT HIS BEAUTIFUL WIFE " LIZZY JOHNSON SULEMAN.
Ôn Tập Truyền dữ liệu - Bài 1
 
01:46:54
ĐÀO TẠO TRỰC TUYẾN CỬ NHÂN CÔNG NGHỆ THÔNG TIN Ngành Mạng Máy tính & Truyền thông. TRƯỜNG ĐẠI HỌC CÔNG NGHỆ THÔNG TIN NƠI ĐÀO TẠO CHUYÊN SÂU VỀ CÔNG NGHỆ THÔNG TIN THUỘC ĐẠI HỌC QUỐC GIA THÀNH PHỐ HỒ CHÍ MINH. Liên hệ: Văn phòng lầu 5 cao ốc 133G Nguyễn Chí Thanh, phường 9, quận 5, Tp.HCM - Điện thoại: (08) 39.574.779 - 0978.21.15.15
Views: 2523 Trung tam CITD
Ayyo Ayyo Full Video Song HD | Nagarjuna | Karthi | Tamannaah | Gopi Sundar
 
03:35
Oopiri is a family drama acted by King Nagarjuna, Karthi, Thamanna, Directed by Vamsi Paidipally and Music by Gopi Sundar. Enjoy and stay connected with us!! ►Subscribe us on YouTube: ►Like us: http://on.fb.me/1JM72Nf ►Follow us: http://bit.ly/1jkVDxg ►Circle us: http://bit.ly/1N5n48y SUBSCRIBE Junglee Music Channels for unlimited entertainment: ►For Kannada Songs & Videos : http://bit.ly/1WmC9H2 ►For Tamil Songs & Videos: http://bit.ly/1Z2vfsO ►For South Devotional Songs: http://bit.ly/1VD5kc0 © 2015 Times Music.I created thisideo Editor (http://www.youtube.com/editor) video with the YouTube V
Views: 4477214 Times Music South
En Nenjil Oru Poo Poothathu Video Song - YouTube
 
04:41
En Nenjil Oru Poo Poothathu - Baana Kaathadi Film
Views: 152426 P Vijayakanth
How to Schedule Programs to  Run Automatically Telugu
 
02:57
How to Schedule Programs to Run Automatically Telugu,ms office 2013 in telugu,excel 2013 in telugu,ms excel 2007 tutorial in telugu,ms word 2007 tutorial in telugu,c language tutorial for beginners in telugu, excel 2007 tutorial in telugu, vlookup in excel 2007 with example in telugu,ms office 2007 tutorials in telugu,,ms access 2007 tutorial in telugu, tally erp 9 full tutorial in telugu,anu script telugu typing tutorial,photoshop in telugu,ms powerpoint 2007 tutorial in telugu, pagemaker tutorial in telugu,adobe photoshop tutorial in telugu, hardware and networking tutorials in telugu,excel tutorial in telugu,ms-excel 2007 tutorial in telugu, excel in telugu, telugu excel tutorial,adobe Photoshop in telugu,ms word 2007 in telugu , ms word 2007 tutorial in telugu, C basis in telugu, hardware in telugu, web designing in telugu,html in telugu, dreamweaver in telugu, c++ in telugu, autocad in telugu, computer tips in telugu, computer basics in telugu, hacking in telugu, computer tips in telugu,java in telugu,oracle in telugu,hardware in telugu,web designing in telugu,java script in telugu,php in telugu,spoken hindi through telugu,spoken English through telugu -~-~~-~~~-~~-~- Please watch: "Best Useful software For Windows Telugu" https://www.youtube.com/watch?v=puGZTRTSoVA -~-~~-~~~-~~-~- #telugutechtuts #hafiztime
Views: 13394 Telugu TechTuts
Danda Nacha ( 2017 )
 
15:56
2017 Danda Dance For a budget mobile for yourself, you click : http://amzn.to/2gAmU3c To Sub : https://www.youtube.com/user/msisir1?sub_confirmation=1 -~-~~-~~~-~~-~- Please watch: "Group Dance || Odia Jagannath Bhajan And Raja Doli Song Mix || ( 2018 )" https://www.youtube.com/watch?v=zitt40f-3wY -~-~~-~~~-~~-~- Preparing For UPSC, SSC, BANK jobs ??? Preparing For Engineering, Medical Admissions ??? Practice Mocks and get ready .... at home... Register at http://govexamsonline.in
Views: 73444 Dreams2tell
Telugu Comedy Scenes - Shakuni Walking In lake With Krishnaveni - Babu Mohan, Priyanka Trivedi
 
02:19
Telugu Comedy Scenes - Shakuni Walking In lake With Krishnaveni Movie: H2O Cast: Upendra, Priyanka Upendra, Prabhu Deva, Babu Mohan, Sadhu Kokila Director: Loknath, Rajaram, Music: Sadhu Kokila, Producer: B N Sridhar. Songs: 1. Priyana Ninu Veedobona 2. Dilleka Lovva 3. Puvva Puvva 4. Kuch Kuch Sweet 5. Oke Oka 6. I Want See My Plot: H2O makes you believe that the story could be true. Uday (Upendra) is from Honnur village in Karnataka and is a chap who believes in an egalitarian society. Muthu (Prabhu Deva) is from the village Chennur across the river in Tamilnadu, who is US returned and wants to convert his place into a Singapore. Cauvery (Priyanka) is the bone of contention between these two youths who are madly in love with her. Cauvery is born to a Kannadiga-Tamil couple killed in riots. A saint brings her up as she shuttles between the border villages, as she is a Naturopathy doctor. Kirik (Babu Mohan) is a local politician and acts like a ‘sutradhar’, out to create tension between the villages. Watch More Comedy Scenes @ https://www.youtube.com/channel/UCasOSKWb0hUSdKlybiCMgkg/videos?view_as=public
Views: 7618 Telugu Comedy Club
BLUE SPAN IMMORTAL RANKED DOTA 2 STREAM
 
05:18:27
Hello friends, this is (probably) high level Dota 2 play with Blue Span. Please be respectful in chat and we will be friends thank you. Daily stream around 0730 PST/2100 WIB/2200 GMT+8/1930PM IST Hero ranking/stat https://www.opendota.com/players/80467654/rankings Help support me! Come become a patron at https://www.patreon.com/bluespan Donate here https://youtube.streamlabs.com/bluespan Play free games which help me out here https://platform.gawkbox.com/BlueSpan PLAYLISTS RAP https://goo.gl/a7UttU KOREAN RAP https://goo.gl/Eukvcj POP https://goo.gl/h83npA NINTENDO https://bit.ly/2HSXVoW PERMANENT STREAM LINK TO BOOKMARK: https://gaming.youtube.com/c/BlueSpan/live LIKE US? JOIN US AT OUR DISCORD https://discord.gg/2nhPhsN Chat Rules: 1: No racism/hate/harassing. 2: Don't advertise your channel / beg for subscribers or shout outs. 3: English ONLY. 4: No backseat gaming (i.e. telling Blue Span what to do). Things I like: compliments, donations, encouragement and support, and friendly and nice people :-) Not looking for friend list adds or parties sry. PC SPECS: i7-8700K 16GB DDR4 2666 MHZ RAM GTX 1080 TI 512GB SAMSUNG 850 PRO SSD GEAR: LOGITECH G502 MOUSE RAZER BLACKWIDOW 2016 LOGITECH C922 CAMERA BLUE YETI MICROPHONE SENNHEISER CX 686 G / BOSE QC 35-2 ALIENWARE AW2518H 240HZ MONITOR TOBII EYE TRACKER 4C Follow my social media! Instant notifications for LIVE STREAMS/VIDS, ask me anything any time! Facebook: https://www.facebook.com/bluespandota Twitter: https://twitter.com/bluespangaming Instagram: http://www.instagram.com/bluespangaming Twitch: http://www.twitch.tv/bluespantwitch Dotabuff: http://www.dotabuff.com/players/80467654 #Dota2 #Live #Youtube #Discord #BlueSpan
Views: 6272 Blue Span