Log Buffer’s collection of blogs from across the world of various databases is all about nifty features, cool tricks, pragmatic tips, real world war stories, and much more.

Oracle:

Ops Center uses an Oracle Database to store product data. Normally you’ll use the Ops Center UI and won’t access the database directly, but it can occasionally be useful to see the database contents directly.

The “Oracle Fusion Financials 11g General Ledger Certified Implementation Specialist” certification is designed for implementation consultants who possess a strong foundation and expertise implementing and configuring the Fusion General Ledger application.

In …

Can’t find what you want or need? Do you have a tip or trick to share? Do you want to lament over a technical woe? If yes, then blog and send it to us for the Log Buffer, just as this one contains tips, tricks, and woes.
Oracle:

Fahd Mirza and Tanel Poder throw the spotlight on the v$cell_thread_history view with respect to the Exadata.

Mark W. Farnham‘s rightsizing goes on with a roar, as he declares that he is pretty much a green sneaker, tree …

The red carpet has been laid down at this Log Buffer Edition, and you can witness and cheer the cat-walking blog posts from Oracle, SQL Server, and MySQL. Every one of them is chic, elegant, and sensual in its own right. Enjoy.
Oracle:

Create colored heat maps in SQL*Plus with Kyle Hailey.

Here’s a quick and dirty script to create a procedure (in the SYS schema – so be careful) to check the Hakan Factor for an object.

Connor has a good post about default null for collection parameter.

This is yet another blogpost on …

This week again, the Log Buffer Edition covers the exciting and ever-evolving galaxies of Oracle, MySQL and SQL Server.

Oracle:

When does an Oracle process know it’s on Exadata?

MobaXterm 6.3 has been released. You can find the download and changelog in the usual place.

A new major release (version 3.0) of Randolf’s XPLAN_ASH tool is available for download.

Important !! Clustering Factor Calculation Improvement

…

News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL.

Oracle:

There is a significant update SLOB 2, Kevin Closson informs.

Charles Hooper is grouping Data Sets by Week Number of the Month.

Chris Antognini has shared a script that is used to demo ITL deadlocks.

As …

Reminders are an inevitable part of our personal and professional lives. Keep reminding of oneself about goals, priorities, and milestones is key to stay on top of things. This Log Buffer Edition is a reminder about all those not-to-be-missed blogs out there.

Oracle:

One of the developers was performing a delete using a nested subquery, which was throwing out ORA-00600 errors. The ORA-00600 Lookup Tool on MOS suggested it was caused by a bug, Tim Hall reports.

The healthcare sector has a clear opportunity to modernize care delivery by adopting new data interchange standards and EHR systems. Kyle opines.

…

Just as information has become an integral part of technology, blogging has become an inseparable part of technology too. Database technologies are no exception and blogging in that arena is booming. This Log Buffer Edition is booming with some bombastic blog posts.

Oracle:

Arup Nanda asks. Application Design is the only Reason for Deadlocks? Think Again.

It’s time that businesses took a good, hard look at the way they manage their cloned database environments, Kyle Opines.

Randolf touches the interesting topic of ASM AU Size And LMT AUTOALLOCATE.

…

Like in love there is no precondition, there are no limits held when it comes to the labor of love called as blogging. Lovingly this Log Buffer edition brings you some more roses from database arena.

Oracle:

Marco Vigelini shares as how to duplicate a production database on a different server mantaining the same SID and directory structures with ‘duplicate’ RMAN command and how to resynchronize a duplicated remote database using RMAN backups.

…

It is an industry norm, supported by analyst researches that blogs are the best informal medium to share the information.  This unique medium provides readers with increased leverage in negotiating the hard turns in their technological lives. Log Buffer makes that leverage more powerful.

Oracle:

Alan Gardner is deploying Cloudera Impala on EC2 with Example Live Demo.

If you want to follow the real news and insight into the online learning revolution, then e-Literate has always been the blog to follow.

Tuula Fai wants to do things, and when he cannot he reverts to a little help.

…

The answers to the questions like whether to patch now or wait a little? What quirks are there in that stunning new features? What are the limitations of that fancy index type, any working examples of a particular add-on, are best found in the blogs. This Log Buffer Edition provides you a window to those blogs out there.

Oracle:

Scott Wesley is dishing out the reasons you should upgrade your APEX environment.

In case you haven’t already noticed, PeopleTools 9.2 is out and available for download!

Since two thirds of sensitive data in most organizations resides in databases, consolidation onto private clouds represent an opportunity to improve information security and …