tag:blogger.com,1999:blog-19771507.post116478906198181779..comments2024-03-12T04:35:02.979-07:00Comments on Jaffar's (Mr RAC) Oracle blog: New Job - New Responsibilities.The Human Flyhttp://www.blogger.com/profile/03489518270084955004noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-19771507.post-1167048624097216252006-12-25T04:10:00.000-08:002006-12-25T04:10:00.000-08:00There is no thump rule for calculating SGA. In fac...There is no thump rule for calculating SGA. In fact, you shouldn't go for any.<BR/>There are couple of good mealink notes available on metalink site.<BR/>Note:1008866.6 - How to determine SGA from (7-10).<BR/>It also depends on your application and db type. i.e. OLTP database or DATAWAREHOUE DB.<BR/><BR/>In my opinion, you should start with the an optimal value and increase gradually upon demand.<BR/><BR/>From 9i onwards, oracle also help in dynamic sga, where you can set the upperlimit memory size for the sga, using parameter sga_max_size.<BR/><BR/>In 10g, setting a single sga parameter, sga_target, Orale automatically calculates the optimal value for db_cache_size & shared_pool. It increase and decreases the values upon demand.<BR/><BR/>JaffarThe Human Flyhttps://www.blogger.com/profile/03489518270084955004noreply@blogger.comtag:blogger.com,1999:blog-19771507.post-1167042312489497172006-12-25T02:25:00.000-08:002006-12-25T02:25:00.000-08:00Iam learning database, HOw to calculate SGA.Can u ...Iam learning database, <BR/><BR/>HOw to calculate SGA.<BR/><BR/>Can u classify it with system <BR/>resources. such as Available Physical Ram, No. of CPU's etc.<BR/><BR/>thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-19771507.post-1167042286522103812006-12-25T02:24:00.000-08:002006-12-25T02:24:00.000-08:00Iam learning database, HOw to calculate SGA.Can u ...Iam learning database, <BR/><BR/>HOw to calculate SGA.<BR/><BR/>Can u classify it with system <BR/>resources. such as Available Physical Ram, No. of CPU's etc.<BR/><BR/>thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-19771507.post-1164981136539684782006-12-01T05:52:00.000-08:002006-12-01T05:52:00.000-08:00Hi Jaffar,You maybe need to turn on the word verif...Hi Jaffar,<BR/>You maybe need to turn on the word verification function to avoid blogspam.<BR/>Good luck in your new job,<BR/>Best regards,Nicolas Gasparottohttps://www.blogger.com/profile/06634519580752248909noreply@blogger.comtag:blogger.com,1999:blog-19771507.post-1164969706431495122006-12-01T02:41:00.000-08:002006-12-01T02:41:00.000-08:00Friend, I don't exactly know who you are and what ...Friend, I don't exactly know who you are and what you are.<BR/>Please do not post add without my knowledge.<BR/>Thanks for comments.<BR/><BR/>JaffarThe Human Flyhttps://www.blogger.com/profile/03489518270084955004noreply@blogger.comtag:blogger.com,1999:blog-19771507.post-1164848158273918372006-11-29T16:55:00.000-08:002006-11-29T16:55:00.000-08:00Hi man! Thanks for the site! louis vuitton repli...Hi man! Thanks for the site! <BR/> <BR/> <BR/><A HREF="http://aboutlouisvuittonreplica.blogspot.com" REL="nofollow">louis vuitton replica</A> <BR/> <BR/><A HREF="http://paycheck-cash-advance.zaxswq.com/paycheck-cash-advance-online.html" REL="nofollow">paycheck cash advance online</A> <BR/> <BR/><A HREF="http://quick-payday-loan.opiytr.com/quick-payday-cash-advance.html" REL="nofollow">quick payday cash advance</A> <BR/> <BR/><A HREF="http://loan-personal-quick.biperq.com/application-loan-online-personal-quick.html" REL="nofollow">application loan online personal quick</A> <BR/> <BR/><A HREF="http://quick-loan-approval.opiytr.com/approval-home-loan-quick.html" REL="nofollow">approval home loan quick</A> <BR/> <BR/><A HREF="http://payday-paycheck-loan.biperq.com/payday-paycheck-loan-cash-loan.html" REL="nofollow">payday paycheck loan cash loan</A> <BR/> <BR/><A HREF="http://advance-online-payday.zaxswq.com/index.html" REL="nofollow">Index Page</A> <BR/> <BR/><A HREF="http://payday-loan-lender.biperq.com/lender-loan-online-payday.html" REL="nofollow">lender loan online payday</A> <BR/> <BR/><A HREF="http://emergency-loan-payday.biperq.com/cash-emergency-fast-loan-loan-loan-payday-quick.html" REL="nofollow">cash emergency fast loan loan loan payday quick</A> <BR/> <BR/><A HREF="http://home-loan-calculation.opiytr.com/home-loan-calculation.html" REL="nofollow">home loan calculation</A> <BR/> <BR/><A HREF="http://free-credit-report-and-score.zaxswq.com/free-equifax-credit-report-score.html" REL="nofollow">free equifax credit report score</A> <BR/> <BR/>Bye!Anonymousnoreply@blogger.com