view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Log buffer space

Introduction
Log buffer space is a simple, yet frequently misunderstood wait event. The main reason for that is probably its name. It sounds as if it points immediately to the answer: if space in the log buffer is the issue, then increasing it surely should resolve it. Well, unfortunately even though log buffer space is simple, it’s not that simple.

Oracle OpenWorld Unwrapped (Part II)

Last week I talked about many of the non technical facets of OOW.  This week I want to focus on some of the technical aspects of Open World.  Before I talk about the event itself and those announcements let me tell you about two ‘new’  tech things that are causing  disruption in their markets. The first […]

Around the World in Nine Photos

Do you love stories from around the world? Check out the work of the following nine photographers on WordPress.com and allow your imagination to take you away…

Oracle E-Business Suite Updates From OpenWorld 2014

Oracle OpenWorld has always been my most exciting conference to attend. I always see high energy levels everywhere, and it kind of revs me up to tackle new upcoming technologies. This year I concentrated on attending mostly Oracle E-Business Suite release 12.2 and Oracle 12c Database-related sessions.

Let the Data Guard Broker control LOG_ARCHIVE_* parameters!

When using the Data Guard Broker, you don’t need to set any LOG_ARCHIVE_* parameter for the databases that are part of your Data Guard configuration. The broker is doing that for you. Forget about what you may have heard about VALID_FOR – you don’t need that with the broker. Actually, setting any of the LOG_ARCHIVE_* parameters with an enabled broker configuration might even confuse the broker and lead to warning or error messages. Let’s look at a typical example about the redo log transport mode.

Apex substitution strings in reports, not always replaced with their values, guess why?

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

It's amazing to you find out how easy is to take for granted certain features of Apex for the simple fact that you have been using them for a long time without paying too much attention to certain specific details.

This morning I ran a report that I rarely use in an application and to

Exadata and Virtual Private Database: will it offload my query?

During one of the classes I taught about Exadata optimisations I had an interesting question:

If I am using VPD, will Exadata still offload the query?

Background is that we discussed function offloading, and the meta-view v$sqlfn_metadata. It turned out that SYS_CONTEXT() is not offloadable in 11.2.0.4.

How I measure Oracle index fragmentation

At Oracle Open World 2014, or rather the Oaktable World, Chris Antognini has presented 'Indexes: Structure, Splits and Free Space Management Internals'. It's not something new, but it's still something that is not always well understood: how index space is managed, block splits, fragmentation, coalesce and rebuilds. Kyle Hailey has made a video of it available here.
For me, it is the occasion to share the script I use to see if an index is fragmented or not.

Add Gmail, Calendar, and Drive to Your Site

The content you publish on your site is the result of a lot of behind-the-scenes activity — and we’re not talking only about drafting posts and pages. Emails, meetings and events, documents and spreadsheets: as business owners and publishers you have a lot to juggle.

We’re excited to announce that we’ve teamed up with Google to offer our users the incredible power of Google Apps for Work right in their WordPress.com dashboards.

Everybody is writing, few people actually reading

When I started this blog, almost 6 years ago I had a clear purpose: give back. I had extracted so much useful information from the internet and in early 2009 it was time to give back. Publish my tricks, secrets, tips, etc. I then moved into Oracle and now I can’t disclose everything I know. […]

view counter