tag:blogger.com,1999:blog-15574215.post115583965599023767..comments2023-03-30T11:32:15.820+03:00Comments on Oracle Today: DBA vs. DeveloperYasin Baskanhttp://www.blogger.com/profile/07642821755164831104noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-15574215.post-80595818988428199522009-05-11T21:02:00.000+03:002009-05-11T21:02:00.000+03:00Please let me know your email ad...i need help fro...Please let me know your email ad...i need help from you.....Sunilhttps://www.blogger.com/profile/11956031719264646769noreply@blogger.comtag:blogger.com,1999:blog-15574215.post-66970966577207253972009-02-05T09:00:00.000+02:002009-02-05T09:00:00.000+02:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15574215.post-83122819147587948512007-12-31T07:03:00.000+02:002007-12-31T07:03:00.000+02:00Hi currently i am working as a Application develop...Hi currently i am working as a Application developer in php and perl and i want to switch the job to Oracle filed so please suggest me which one is better field Oracle DBA or Oracle Application Developer for 10g.And what is the role of Oracle DBA and what is the role of Oracle Application developer in an organization.Prashanthttps://www.blogger.com/profile/13756125145860584090noreply@blogger.comtag:blogger.com,1999:blog-15574215.post-57956390012034782712007-08-08T10:56:00.000+03:002007-08-08T10:56:00.000+03:00I agree with you that DBA should know programming ...I agree with you that DBA should know programming stuff and vise versa .. pls read my 1st blog in the same issue but very simple.<BR/>http://ahmed-dba.blogspot.com/Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15574215.post-1174378206876978782007-03-20T11:10:00.000+02:002007-03-20T11:10:00.000+02:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15574215.post-1160448743535219372006-10-10T05:52:00.000+03:002006-10-10T05:52:00.000+03:00This is one of the best blogs I had ever read...- ...This is one of the best blogs I had ever read...<BR/><BR/>- Vamsi chikkamVamsi Chikkamhttps://www.blogger.com/profile/04823039630914103422noreply@blogger.comtag:blogger.com,1999:blog-15574215.post-1158470390552661362006-09-17T08:19:00.000+03:002006-09-17T08:19:00.000+03:00To estimate the storage requirement for a table yo...To estimate the storage requirement for a table you try to find out how many rows are expected in that table, look at the datatypes of the columns and calculate the size based on that. <BR/><BR/>If this is not a new table then you can query the AVG_ROW_LEN column from DBA_TABLES to see the average row size for the table if you have gathered statistics.<BR/><BR/>If you are using the cost based optimizer than it is possible that query plans will change when number of rows changes. You must make these changes on your test system and test your application in order to see the effect of the data change.Yasin Baskanhttps://www.blogger.com/profile/07642821755164831104noreply@blogger.comtag:blogger.com,1999:blog-15574215.post-1158429597601910912006-09-16T20:59:00.000+03:002006-09-16T20:59:00.000+03:00hi brother, nice blog to follow. i l...hi brother,<BR/> nice blog to follow. i like the caption u choosed. BTW, I was asked by Application Team to estimate the storage requirements for holding addtional 500K records for 11 tables. also the performance impact on the existing system. Until that point of time I never thougt Capacity Planning is such complicated thing and deserves so much expereince. Yet to complete the report. My questions are :<BR/><BR/>What is the best way of estimating the storage requirements for new tables.<BR/><BR/>How to estimate the Transaction Load?<BR/><BR/>How to estimate the Performance Impact?<BR/><BR/>Is there any scale which guides us that this much Memory can support this many transactions per hour?<BR/><BR/><BR/>ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-15574215.post-1155891437744258812006-08-18T11:57:00.000+03:002006-08-18T11:57:00.000+03:00I asked that question to tom kyte last year.my sum...I asked that question to tom kyte last year.<BR/>my summary :<BR/><A HREF="http://laurentschneider.blogspot.com/2005/12/tom-kyte-day-2.html" REL="nofollow">http://laurentschneider.blogspot.com/2005/12/tom-kyte-day-2.html</A>Laurent Schneiderhttps://www.blogger.com/profile/13833048234373264017noreply@blogger.com