tag:blogger.com,1999:blog-5603459235786069906.comments2017-03-18T00:11:20.962-07:00Thilina's BloggerAnonymoushttp://www.blogger.com/profile/12561824492329016321noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-5603459235786069906.post-5554453440203468292017-03-18T00:11:20.962-07:002017-03-18T00:11:20.962-07:00It was really a nice article and i was really impr...It was really a nice article and i was really impressed by reading this article We are giving Oracle financials Course Online Training.The oracle Online Training is one of the leading Online Training institute.<br /><a href="www.calfre.com/Hyderabad/l/r/ERPTREE-Pvt-Ltd-/4991/details?cod=3964644" rel="nofollow">Oracle fusion financials training</a>oraclehcmhttps://www.blogger.com/profile/05456168233537750400noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-28757266254854876542015-01-31T01:15:17.835-08:002015-01-31T01:15:17.835-08:00Website Design & Beverly Hills SEO for Dental ...Website Design & <a href="http://www.losangelesseoguru.com/beverly-hills.html" rel="nofollow">Beverly Hills SEO</a> for Dental Community. Our unique approach, philosophy, and ethic of work have proven their efficiency throughout hundreds of projects.Abdul barihttps://www.blogger.com/profile/02394126800848561337noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-16001542182240626982013-01-31T04:13:55.881-08:002013-01-31T04:13:55.881-08:00Planning a dinner and need a reminder of how to se...<br />Planning a dinner and need a reminder of how to set a table and where the cutlery should be placed around the tableware? It's easy to forget how to set a table and the proper place setting of tableware and cutlery. <a href="http://birevbirmutfak.com" rel="nofollow">pasabahçe</a><br />Sammyhttps://www.blogger.com/profile/13182526765240519199noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-16017715775649234762012-05-31T05:01:00.232-07:002012-05-31T05:01:00.232-07:00This comment has been removed by the author.RoshniHhttps://www.blogger.com/profile/05056661800566796883noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-47751448340110903132010-02-03T01:18:57.304-08:002010-02-03T01:18:57.304-08:00If mysql command not working for a user other than...If mysql command not working for a user other than root, then try this<br /><br />cp /usr/local/mysql/bin/mysql /usr/bin/Anonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-33362359554858027952008-05-20T07:51:00.000-07:002008-05-20T07:51:00.000-07:00If you want to avoid printing any logs in the logs...If you want to avoid printing any logs in the logs files, add folowing to the log4j.xml<BR/><BR/> <category name="org.hibernate"><BR/> <priority value="error"/><BR/> </category>Anonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-60312030956990034152008-04-03T05:06:00.000-07:002008-04-03T05:06:00.000-07:00Hello. This post is likeable, and your blog is ver...Hello. This post is likeable, and your blog is very interesting, congratulations :-). I will add in my blogroll =). If possible gives a last there on my blog, it is about the <A HREF="http://toner-brasil.blogspot.com" REL="nofollow">Toner</A>, I hope you enjoy. The address is http://toner-brasil.blogspot.com. A hug.<A HREF="6832301644" REL="nofollow"></A>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-83827851453331961772007-07-12T22:51:00.000-07:002007-07-12T22:51:00.000-07:00We have 3 areas to consider when developing Data W...We have 3 areas to consider when developing Data Warehouse (with regard<BR/>to Database)<BR/>1) Populating the event tables (using a ETL process)<BR/>2) Populating summary tables from event tables (using a stored<BR/>procedure)<BR/>3) Query the summary tables for reports (BO reporting)<BR/><BR/>* for 1) It would be better to have Innodb tables<BR/>* and for 2) and 3) we can have Myisam tables<BR/><BR/><BR/>1) We have to find out what is the best 'engine' out of INNODB and<BR/>MYISAM for above cases.<BR/>2) INNODB is transactional<BR/>3) myisam is having the best query performance,but it is not<BR/>transactional. (that means make table locks)<BR/>4) Best thing is use INNODB for event tables. They only make row level<BR/>locks<BR/>5) If server crashed for big myisam tables, u will have to manually<BR/>repair and it takes hours<BR/>6) Any innodb table auto recover, if server crashed happen.<BR/>7) If u can use myisam for summary table or daily cache table it is good<BR/>8) myisam backup also very easy and can do online backup and just<BR/>copying table files only.<BR/>9) There ar some disadvantages keeping both the engine types. because<BR/>you need to set parameters separately for both. for example, INNODB<BR/>memory usage you have to increase BUFFER_POOL_SIZE, for MYISAM its<BR/>key_buffer have to increase. Also FOREIGN KEY keeping issue is there,<BR/>only inoodb provides the foreign keys.<BR/>10) You will get additional advantage from myisam. If there is an IO<BR/>performance issue, for example, if you try to get a DB dump to same disk<BR/>or big IO operation related insert running in partition, all the inserts<BR/>will be slow. innodb is having the above issues. But still you can work<BR/>with myisam without any issue and using myisam we can avoid above issue.<BR/>11) Design level optimization - There are ways it can be avoided in<BR/>table design level, or dumping things in to separate partition and<BR/>create several data files.<BR/>12) Best thing is to to create daily cache table (Myisam tables), and u<BR/>can do any indexing when u do that to fast the query, because indexing<BR/>big table is always slow. huge table like VOICE_CALL_SUMMARY running in<BR/>live table it takes 2 hours to index, but in daily cache table it is 20<BR/>secs<BR/>13) innodb is fast when inserting or loading data to table, but in<BR/>querying myisam is still fast <BR/>14) Anyway myisam is very fast without indexing, comparing to INNODB.<BR/>because without indexing INNODB always does full table scanning<BR/>15) Anyway in summary, for event things we must go for INNODB. Otherwise<BR/>big issue comes when do purging using deleted<BR/>16) If u ar planning to use files per table, that IO issues will not<BR/>come, but performance is relatively slow for normal queries, but bottle<BR/>necks will never come<BR/>17) Also consider primary keys for tables, use bigint as data type. Also<BR/>plan backup and purgingAnonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-47322499090876010262007-07-05T22:20:00.000-07:002007-07-05T22:20:00.000-07:00Log into the Oracle prompt------------------------...Log into the Oracle prompt<BR/>---------------------------<BR/>1) Log as oracle user<BR/>2) sqlplus system/password@db_name<BR/><BR/>Describe the table schema<BR/>-------------------------<BR/>1. Log into oracle prompt<BR/>2. Execute desc table_name;Anonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-37417707744869606572007-06-18T22:35:00.000-07:002007-06-18T22:35:00.000-07:00Usefull oracle guide see...http://www.lc.leidenuni...Usefull oracle guide see...<BR/><BR/>http://www.lc.leidenuniv.nl/awcourse/oracle/nav/docindex.htmAnonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-2145682384365515062007-06-18T21:38:00.000-07:002007-06-18T21:38:00.000-07:00Oracle views see...http://www.psoug.org/reference/...Oracle views see...<BR/><BR/>http://www.psoug.org/reference/views.htmlAnonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-16260775594857202182007-06-18T05:51:00.000-07:002007-06-18T05:51:00.000-07:00If you get "ORA-27123: unable to attach to shared ...If you get "ORA-27123: unable to attach to shared memory segment" <BR/><BR/>ORA-27123: unable to attach to shared memory segment.<BR/>I temporarely increased the shmmax setting for the kernel by executing the following command:<BR/><BR/>$ su - root<BR/># cat /proc/sys/kernel/shmmax<BR/>33554432<BR/># echo `expr 1024 \* 1024 \* 1024` > /proc/sys/kernel/shmmax<BR/># cat /proc/sys/kernel/shmmax<BR/>1073741824<BR/>It is recommended to increase the shmmax setting permanently for Oracle. For more information, see Setting Shared Memory.Anonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-25005707951688502792007-06-18T05:31:00.000-07:002007-06-18T05:31:00.000-07:00Database creation procedure as follows;Create the ...Database creation procedure as follows;<BR/><BR/>Create the table space under the Database. Use 'oemapp dbastudio' and create the table space under the created database. <BR/><BR/>Then log into Oracle prompt as follows;<BR/><BR/>sqlplus oracle_username/password@db_name<BR/><BR/>eg: sqlplus system/beyondm@suntel<BR/><BR/>Then create a user with following commands;<BR/><BR/>drop user @db.users.owner.username@ cascade;<BR/>create user @db.users.owner.username@<BR/>identified by @db.users.owner.password@<BR/>default tablespace @db.tablespace.default@<BR/>temporary tablespace @db.tablespace.temporary@;<BR/><BR/>grant connect, resource to @db.users.owner.username@;<BR/>grant query rewrite to @db.users.owner.username@;Anonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-10431487779044107462007-05-29T22:33:00.000-07:002007-05-29T22:33:00.000-07:00Appending a text (say "Once upon a tim") to each l...Appending a text (say "Once upon a tim") to each line of the file (eg: y.txt)<BR/><BR/><BR/>sed -i 's/\(.*\)/Once upon a tim \1/g' y.txtAnonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.com