tag:blogger.com,1999:blog-19771507.post7137567087220646860..comments2024-03-12T04:35:02.979-07:00Comments on Jaffar's (Mr RAC) Oracle blog: Scientific methods vs Bullet MethodsThe Human Flyhttp://www.blogger.com/profile/03489518270084955004noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-19771507.post-75019020972145233942008-10-29T09:54:00.000-07:002008-10-29T09:54:00.000-07:00Hi JaffarI really liked your blog and your dedicat...Hi Jaffar<BR/>I really liked your blog and your dedication to oracle. Well i will be in touch with you. Ok byeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-19771507.post-36282068857628618532008-10-18T20:36:00.000-07:002008-10-18T20:36:00.000-07:00Dear Jaffar,Hearty congratulations on getting OCM....Dear Jaffar,<BR/><BR/>Hearty congratulations on getting OCM......Can you suggest us on how to go about OCM preparation after finishing our OCP......Can you give details on what all books you read to become an OCM......Apart from Oracle online docs what else did you read......If you feel free to discuss on OCM exam experience at test centre it will be of help to us...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-19771507.post-15845684456827470772008-10-10T02:58:00.000-07:002008-10-10T02:58:00.000-07:00Hi Jaffar, First of all congratulations on getting...Hi Jaffar, <BR/>First of all congratulations on getting OCM. My experiences are really wierd. Although not working on Oracle (I miss it really) for the past 9 months. Here in my company we have just upgraded to sql 2005 and following are the best (worst) practices which we follow:<BR/>- Don't use transactions!<BR/>- Use a caching API created by the architect, which caches all of the data as objects in java. <BR/>- Move all the logic out from the database into middle layer. <BR/>- Whenever any query performs slow turn that code into caching code instead of tuning the query or rewriting it<BR/>- Databases are good for processing large sets of data (millions of records) so use them only for bulk processing and for oltp systems use java cache, use database as just a datastore. <BR/>- There is a plan now to create an asynchronous processing of transactions using java cache. <BR/><BR/>If these guys had read the basics of database...............<BR/><BR/>Regards, <BR/>AhmedAnonymousnoreply@blogger.com