ALL POSTS

Linux HugePages for Oracle on Amazon EC2

One of the optimizations available to us when running Oracle on Linux is huge page support. This feature of the Linux kernel enables processes to allocate memory pages of size 2M (instead of 4k). In addition, memory allocated using hugepages is pinned in physical memory. It cannot be swapped out. It is now common practice…

Simple and Quick Way to Get SQL_ID of Query in Oracle

If you need to get SQL_ID of a query from a busy system, which has similar queries scattered all around, it becomes a hassle to get what you are looking for. If the query for which you are getting SQL_ID is big, or contains lots of apostrophes or other not-so-nice characters, then it becomes more…

Log Buffer #340, A Carnival of the Vanities for DBAs

Education is everything. Education can pull you out of poverty, it can propel you into upper echelons. Education can make you see what’s truly important in the life. Education can enable you to appreciate the people. Blogging is all about education. This Log Buffer brings education about database arena from the blogs.

In-Place Upgrade failure from SQL Server 2008 SP1 to SQL Server 2008 R2

Recently I was trying to upgrade SQL Server 2008 to SQL Server 2008 R2. The upgrade failed with error message below.   TITLE: Message Details —————————— The Instance ID ‘MSSQLSERVER’ is already in use by SQL Server instance ‘MSSQLSERVER.INACTIVE’. To continue, specify a unique Instance ID. —————————— BUTTONS: OK ——————————     Brief Background of…

Silent Installation of RAC 12c database

Nowadays everyone is installing #db12c in different variants, posting screenshots, talking about a better tool to run GUI through. However I could not find posts about silent installation of GI and RDBMS. Yes, installation without sleek graphical interfaces, just pure command line in terminal. Thinking about RAC Attack at OOW13 I decided to install a…

Log Buffer #339, A Carnival of the Vanities for DBAs

Tablogs are the blogs written, read, and managed on tablets. They are not only growing in numbers, but the volume of content is also immense. So much ease and so much power through touches ensure that you only spend time creating and learning. This Log Buffer edition appreciates that.

Getting ready to install EBS 12.2 Vision: Quickstart notes

Getting ready for the next big thing In the wake of last week’s announcement of the general availability of Oracle E-Business Suite Release 12.2, I’ve started spinning up a 12.2 Vision instance, so I can start getting familiar with the product. Learning about the changes has been pretty fun so far, and you’ll be seeing…

Page 30 of 257« First...1020...2829303132...405060...Last »