Oracle VM Consulting
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.

ODA 12.1.X.X.X - add a multiplexed control file under ACFS

Since version 12, ODA stores databases on ACFS volumes instead of ASM directly. This slightly changed the way the files are managed and administer. This articles presents how to multiplex your control files on ACFS.

Extra session at OUG Ireland – Oracle Lego.

I’m now doing a second session at OUG Ireland 2015. {This is because one of the accepted speakers had to drop out – it sometimes happens that, despite your best intentions, you can’t make the conference and it is better to let them know as soon as you can, as they did}.

Venturing into bulk insert a SQL Server error log and data order

Have you ever attempted to bulk import a SQL Server error log in order to use the information inside a report for example? If yes, you have probably wondered how to keep data in the correct order in a query because you cannot refer to any column from the table. In such case you can notice that you may have many records with the same date. Of course, there exists some workarounds but this is not the subject of this blog.

Automatic Analytics is So main stream. Not something new.

Everyone is doing advanced analytics. Right? Hmm Everyone is talking about advanced analytics? Yes that is true. Everyone is an expert in advanced analytics? This is so not true. Watch out for these Great Pretenders. You know what I mean! You know who I mean! Maybe you know some of them already? If not, watch out for these Great Pretenders!!!

Perth Breakfast Meeting - APEX5 + JSON + Food

Do you live in Perth, Western Australia?
Do you use Oracle Application Express?
Are you interested in seeing how easy it is to extend the product?
Keen to see APEX 5 in action?

Please tell me you're free for breakfast on Tuesday March 24. You'll be out by 9am feeling glad you came. Visit the event details page for the abstract, it's inspired by a book I'm currently writing ;p

Tablespace growth history

Recently we had a tablespace space run out and ended up in an application failure.  I have questioned my DBA and he just plainly blamed the application team members who loaded large number records without a prior notice.  A convincing answer, but you can’t really fool Oracle.
Oracle introduced a new DBA_TABLESPACE_USAGE_METRICS view from 10g onwards to report the space usage with in a tablespace.  I created a new tablespace and immediately space usage was reported in the view.

Dbvisit Standby Part 1 – Recover to specific SCN or TIMESTAMP

While busy testing the latest Dbvisit Standby version 7.0.36 I realized again that apart from the core functions of the product, there are many additional features available which a lot of people are not aware off. The development team has done an amazing job at including these additional features into the product, and so in […]

Flashback Logging

One of the waits that is specific to ASSM (automatic segment space management) is the “enq: FB – contention” wait. You find that the “FB” enqueue has the following description and wait information when you query v$lock_type, and v$event_name:

Adjusting Interactive Reports - learning from mistakes

Sometimes I come across code where it's obvious someone has taught themselves APEX, then worked through a problem to come up with a solution - but they went a long way.

Today's situation required data in an interactive report to not wrap the output. I thought it'd be worth sharing because a few lessons might be demonstrated along the way for newer developers.

Here is the long way:

1) Add this to the Page Load property
$('td').attr("style","white-space:nowrap");

Apply Jdeveloper Patch

This blog post will show you how to apply Patch on Jdeveloper :-

  • Download the latest version of Opatch from http://support.oracle.com
  • Unzip the Patch Folder.
  • Set/export ORACLE_HOME to Jdeveloper hope depend on Operating system
  • Finally Opatch Apply to Jdeveloper Home.

If you faced any error with opatch commad try the below :-

view counter