tag:blogger.com,1999:blog-4096575.post5154048563302687959..comments2024-03-18T02:14:37.994-04:00Comments on The Arup Nanda Blog: 100 Things You Probably Didn't Know About Oracle DatabaseArup Nandahttp://www.blogger.com/profile/03392706779349258765noreply@blogger.comBlogger67125tag:blogger.com,1999:blog-4096575.post-28856222881721645742023-06-15T12:59:21.223-04:002023-06-15T12:59:21.223-04:00Arup Nanda is a successful author and an accomplis...Arup Nanda is a successful author and an accomplished speaker. He has written a number of books on Oracle Database, including SQL for Dummies and Oracle Database 12c: The Complete Reference.<br /><br />Arup Nanda shares his personal opinions on what should be the next big thing in database technology.Take my online course for mehttps://startmyonlinecourses.com/take-my-online-course/noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-62527994783433703792022-04-27T05:20:10.038-04:002022-04-27T05:20:10.038-04:00Thank you for sharing such an Amazing Post. Lookin...Thank you for sharing such an Amazing Post. Looking Forward to more.<br /><a href="https://poschcare.com/collections/face-mists/products/vitamin-c-mist" rel="nofollow">face shiner spray</a><br /><br />David Smithhttps://poschcare.com/collections/face-mists/products/vitamin-c-mistnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-41208156891428494022022-01-28T01:43:39.564-05:002022-01-28T01:43:39.564-05:00I have read your post this is a very informational...I have read your post this is a very informational website. I appreciate your kindness and look forward to hearing from you. Thank you so much for your information.<br /><br />Change AT&T Email Passwordhttps://sites.google.com/view/qwikaid/blogs/change-att-email-passwordnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-92207162889889183722022-01-16T10:49:46.291-05:002022-01-16T10:49:46.291-05:00Your blogs are authentic. I love them .Are you als...Your blogs are authentic. I love them .Are you also searching for <a href="www.cheapassignmentwriters.com/essay-help" rel="nofollow">essay help?</a> we are the best solution for you. We are best known for delivering quality essay help.Cheap Assignment Writershttps://www.blogger.com/profile/02624422805026883949noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-55699234394320238042022-01-16T10:49:27.243-05:002022-01-16T10:49:27.243-05:00Your blogs are authentic and great. Are you also s...Your blogs are authentic and great. Are you also searching for <a href="www.cheapassignmentwriters.com/cheap-nursing-writing-company" rel="nofollow">cheap nursing writing company?</a> we are the best solution for you. We are best known for delivering quality essay writing services to students without having to break the bankcheap nursing writing companyhttp://www.cheapassignmentwriters.com/cheap-nursing-writing-companynoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-47014863100223219262021-06-18T10:17:49.896-04:002021-06-18T10:17:49.896-04:00I think this is the best blog for you.
คาสิโนออนไล...I think this is the best blog for you.<br /><a href="https://massufabet.com/%e0%b8%ab%e0%b8%a7%e0%b8%a2%e0%b8%a2%e0%b8%b5%e0%b9%88%e0%b8%81%e0%b8%b5-%e0%b9%80%e0%b8%a5%e0%b9%88%e0%b8%99%e0%b8%a2%e0%b8%b1%e0%b8%87%e0%b9%84%e0%b8%87/" rel="nofollow">คาสิโนออนไลน์ ได้เงินจริง แจกเครดิตฟรี 2020</a><br /><a href="https://tangball2005.com/%e0%b8%9b%e0%b9%8a%e0%b8%ad%e0%b8%81%e0%b9%80%e0%b8%94%e0%b9%89%e0%b8%87%e0%b8%ad%e0%b8%ad%e0%b8%99%e0%b9%84%e0%b8%a5%e0%b8%99%e0%b9%8c-3/" rel="nofollow">แทงบอล 888</a><br /><a href="https://ufabethel.com/%e0%b8%aa%e0%b8%a5%e0%b9%87%e0%b8%ad%e0%b8%95%e0%b8%ad%e0%b8%ad%e0%b8%99%e0%b9%84%e0%b8%a5%e0%b8%99%e0%b9%8c-%e0%b9%80%e0%b8%a5%e0%b9%88%e0%b8%99%e0%b8%a2%e0%b8%b1%e0%b8%87%e0%b9%84%e0%b8%87/" rel="nofollow">ราคาแทงบอล</a><br /><a href="https://ufabethere.com/%e0%b9%80%e0%b8%81%e0%b8%a1%e0%b9%84%e0%b8%9e%e0%b9%88%e0%b8%9b%e0%b9%8a%e0%b8%ad%e0%b8%81%e0%b9%80%e0%b8%94%e0%b9%89%e0%b8%87/" rel="nofollow">แทงบอลขั้นต่ำ</a><br /><a href="https://publicufabet.com/%e0%b8%9e%e0%b8%99%e0%b8%b1%e0%b8%99%e0%b8%9a%e0%b8%ad%e0%b8%a5%e0%b8%ad%e0%b8%ad%e0%b8%99%e0%b9%84%e0%b8%a5%e0%b8%99%e0%b9%8c/" rel="nofollow">คาสิโนออนไลน์มือถือ</a><br /><a href="https://quantumufabet.com/%e0%b8%84%e0%b8%b2%e0%b8%aa%e0%b8%b4%e0%b9%82%e0%b8%99%e0%b8%ad%e0%b8%ad%e0%b8%99%e0%b9%84%e0%b8%a5%e0%b8%99%e0%b9%8c-%e0%b8%aa%e0%b8%a1%e0%b8%b1%e0%b8%84%e0%b8%a3%e0%b8%9f%e0%b8%a3%e0%b8%b5/" rel="nofollow">เว็บคาสิโนออนไลน์</a><br /><a href="https://ufabetokener.com/%e0%b8%9b%e0%b9%8a%e0%b8%ad%e0%b8%81%e0%b9%80%e0%b8%94%e0%b9%89%e0%b8%87%e0%b8%ad%e0%b8%ad%e0%b8%99%e0%b9%84%e0%b8%a5%e0%b8%99%e0%b9%8c-2/" rel="nofollow">เล่นบาคาร่าออนไลน์ฟรี</a><br /><a href="https://logicufabet.com/%e0%b8%ab%e0%b8%a7%e0%b8%a2%e0%b8%ae%e0%b8%b2%e0%b8%99%e0%b8%ad%e0%b8%a2-2/" rel="nofollow">บาคาร่า พันทิป</a><br /><a href="http://luckyufabet.com/%e0%b9%82%e0%b8%9b%e0%b9%8a%e0%b8%81%e0%b9%80%e0%b8%81%e0%b8%ad%e0%b8%a3%e0%b9%8c%e0%b8%ad%e0%b8%ad%e0%b8%99%e0%b9%84%e0%b8%a5%e0%b8%99%e0%b9%8c/" rel="nofollow">โหลดบาคาร่าออนไลน์</a><br /><a href="http://luxuryufabet.com/%e0%b9%80%e0%b8%81%e0%b8%a1%e0%b8%aa%e0%b8%a5%e0%b9%87%e0%b8%ad%e0%b8%95-%e0%b8%a1%e0%b8%b7%e0%b8%ad%e0%b8%96%e0%b8%b7%e0%b8%ad/" rel="nofollow">สล็อตออนไลน์ มือถือ</a>chaneehttps://www.blogger.com/profile/04169657015356889907noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-31272110743209715002021-01-17T03:30:22.701-05:002021-01-17T03:30:22.701-05:00Awesome !! I would like to know on Oracle 19c as w...Awesome !! I would like to know on Oracle 19c as well<br /><br />https://isqlplus.com/oracle/oracle-monitoring/<br />https://momboleh.com/12-tips-for-a-working-mom/<br />https://medxjobs.com/taking-back-your-time/Tanveer Ahmedhttps://www.blogger.com/profile/06530250171727407372noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-20661919068528148712020-09-23T15:42:16.278-04:002020-09-23T15:42:16.278-04:00our experts will understand better what you requir...our experts will understand better what you require. Afterward, pay and we’ll select an assistant to work on your paper. <a href="https://www.gethomeworkonline.com/do-my-college-homework" rel="nofollow">Do My College Assignment For Me</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-34096527016463868652020-08-07T19:46:36.983-04:002020-08-07T19:46:36.983-04:00I can't believe I can earn money weekly from t...I can't believe I can earn money weekly from trading , this is amazing , and all this is from the effort of a company called skylink technology whom I met online and help me out in trading and gave me good tips about trading physiology... indeed skylink technology is a bitcoin/binary forex experts and company and I won't stop thanking them and sharing my testimony until am fully satisfied...... Interested traders should free free to contact mail: skylinktechnes@yahoo.com or whatsapp/telegram: +1(213)785-1553 Anonymoushttps://www.blogger.com/profile/01804304680311897628noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-39351538686135290142013-04-25T22:38:35.336-04:002013-04-25T22:38:35.336-04:00Thank you, Rob.Thank you, Rob.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-42347470085139653852013-04-25T06:27:45.283-04:002013-04-25T06:27:45.283-04:00Hi Arup,
Thanks for taking the time to write an E...Hi Arup,<br /><br />Thanks for taking the time to write an EXCELLENT article - you described this technical process very well in an easy-to-understand language. <br /><br />This article was particularly helpful in understanding some of the root causes behind "Checkpoint not complete" errors in my DB's alert log.<br /><br />Thank you for taking the time to make this excellent blog posting! I will check your other blog postings as well. Rob Knoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-66119929190016422432013-02-24T15:05:58.704-05:002013-02-24T15:05:58.704-05:00Arup,
Thanks a lot.It is really helpfull informati...Arup,<br />Thanks a lot.It is really helpfull information.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-16025063661024736992013-01-18T13:47:45.794-05:002013-01-18T13:47:45.794-05:00@sakhtee - which specific portion of the text are ...@sakhtee - which specific portion of the text are you referring to? <br /><br />If I made a change to 2000 from 1000, did NOT commit and leave, after 24 hours what values would someone see - that was the question. The answer depends on "where" you check.<br /><br />(a) if you check the database by <b>logging on to a session</b>, then you will see 1000 (the pre-change value). Since the change was not committed, the users will be shown the pre-change value as a part of read consistency.<br /><br />(b) if you check in the <b>datafile</b>, you will see 2000; since the datafile will have been updated by DBWn process already.<br /><br />SMON has no role to play here.<br /><br />Hope this helps.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-5216581610873108982013-01-17T20:01:33.244-05:002013-01-17T20:01:33.244-05:00Arup,
In the scenario 2, u said u will not commit...Arup,<br /><br />In the scenario 2, u said u will not commit the updated value i.e., 2000 and leave. Log in after a day and you still see the value as '2000'. That means the value will roll backward only if SMON comes into picture? won't the reports or the new value available to other users will be inconsistent?<br /><br />Regards,<br />SakthiSaktheehttps://www.blogger.com/profile/18015464744469457242noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-23884077465661335752012-09-05T04:26:07.005-04:002012-09-05T04:26:07.005-04:00Simply Superb... Hatss off...Keep it up...Simply Superb... Hatss off...Keep it up...Unknownhttps://www.blogger.com/profile/14104283250140623342noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-9767180178242399962012-07-16T07:42:18.256-04:002012-07-16T07:42:18.256-04:00Thanks for your reply, Flado.
That was my origina...Thanks for your reply, Flado.<br /><br />That was my original understanding too, but based on this article I was beginning to wonder if a checkpoint didn't always flush relevent redo to the logs.<br /><br />Arup - could you possibly comment on what circumstances you see scenario 3 being possible?<br /><br />Regards.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-8719404438078401492012-07-13T05:34:18.893-04:002012-07-13T05:34:18.893-04:00Anon,
Scenario 3 still cannot happen. The checkpo...Anon,<br /><br />Scenario 3 still cannot happen. The checkpoint at step 2 will flush the redo before flushing the data block buffer.<br />Rolling back requires rolling forward of the undo tablespace and then using it to roll the uncommitted transactions back. Instance (and media) recovery can only roll <i>forward</i>, ergo no datafile may get ahead of the redo stream on disk.<br />Cheers,<br /><br />FladoFladohttps://www.blogger.com/profile/04901763101139511192noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-46357727731539365082012-07-13T04:53:45.435-04:002012-07-13T04:53:45.435-04:00Hi,
Thanks for a great article.
One question tho...Hi,<br /><br />Thanks for a great article.<br /><br />One question though. Following on from Flado's comment, I'm a little unclear how scenario 3 would arise and how Oracle would handle it in the event of an instance failure.<br /><br />The only possible cause of events I can think of that might cause it is:<br />1. Make a data change without commiting<br />2. Issue an explicit checkpoint<br />3. Immediate instance failure<br /><br />On recovery of the instance how is the datafile rolled back?<br />Presumably the undo associated with the change was also written to the datafiles as part of the checkpoint.<br />Does Oracle look at the SCN of the datafile header, realise it's greater than the last SCN in the log files and somehow work out the uncommited data with their associated undo and roll it back?<br /><br />Many thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-7155723026004384052012-07-04T01:10:25.096-04:002012-07-04T01:10:25.096-04:00awesome explanation, thank youawesome explanation, thank youSwapnaVenkateshhttps://www.blogger.com/profile/09986593321422292021noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-37150877607093720632012-06-19T00:21:11.303-04:002012-06-19T00:21:11.303-04:00Thanks Arup for your well balanced explanation, it...Thanks Arup for your well balanced explanation, it really helps me a lot.saurabh.sharmahttps://www.blogger.com/profile/09136062959432821416noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-7187799639994383732012-06-12T04:16:00.649-04:002012-06-12T04:16:00.649-04:00Hello Sir,
Thank you so much for this wonderful ex...Hello Sir,<br />Thank you so much for this wonderful explanation.<br /><br />Regards<br />Ajay.Unknownhttps://www.blogger.com/profile/14585793080670264132noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-81669959521652996622012-06-05T01:22:43.446-04:002012-06-05T01:22:43.446-04:00Hey saw your post today Brian & I must say you...Hey saw your post today Brian & I must say you have done a great job in understanding the basics of this topic & working on the updates. I am looking forward to more articles from you on the same topic.Jacob Naylorhttp://www.diskdoctors.com/data-recovery-los-angeles.aspnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-83160721760280379802012-05-10T02:32:16.906-04:002012-05-10T02:32:16.906-04:00awesome post got lots of satisfaction to read this...awesome post got lots of satisfaction to read this article.Rajnish Pandey's Blogshttps://www.blogger.com/profile/04983060534790364847noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-51139957433634408262012-04-26T13:04:15.033-04:002012-04-26T13:04:15.033-04:00@Ravikanth - the uncimmited data will be in the bu...@Ravikanth - the uncimmited data will be in the buffer cache.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-73659120100005062682012-04-26T02:51:20.888-04:002012-04-26T02:51:20.888-04:00Thanks for teh nice post Arup.
Can you tell me wh...Thanks for teh nice post Arup.<br /><br />Can you tell me where would the un-committed data be stored before writing to redo log buffer or data file i.e your scenario 1 of the table? Would it be in SGA or PGA and module holding it?Ravikanthhttps://www.blogger.com/profile/17625077592868197066noreply@blogger.com