Search

Top 60 Oracle Blogs

Recent comments

July 2013

Temporary undo

Back in Oracle 8i the Global Temporary Table was introduced to reduce the overhead of storing temporary data inside the database. A Global Temporary Table stores its data in a Temporary Tablespace where the data is retained for the duration of either a single transaction or the lifetime of a session. Performing DML on a […]

Fedora 19 : Upgrade from Fedora 18…

I finally got round to upgrading my desktop machine to Fedora 19. The experience was pretty similar to upgrade from Fedora 17 to Fedora 18.

This time I had to remove FireFox, as it was holding on to Fedora 18 packages. Once I removed and re-added it I could complete a “yum update”. Things seem to be OK.

The DropBox repository is lagging behind again…

I still think it’s better to do clean installations, but I don’t have time to do that now. Perhaps when I get back from South America I’ll do it properly.

Cheers

Tim…

 

 

Oracle Database File System (DBFS) Enhancements in Oracle 12c

Oracle 12c includes a really neat feature I first mentioned after Oracle OpenWorld 2012. You can now access your DBFS file systems over HTTP/HTTPS, FTP or WebDAV. I’ve been having a play with it over the last couple of days, so I thought I would write it up here.

This should be quite a welcome addition for those people on platforms other than Linux, who don’t get to use FUSE.

As mentioned in the article, WebDAV support under Windows 7 broken. Even the Oracle manual has a screen shot from Windows XP. I can’t believe Windows 7 has been out all this time and Microsoft have not bothered to fix it…

Cheers

How to quickly build standby database and setup DataGuard configuration using Oracle 12c

With every release of Oracle database there are new possibilities to build a required solution (ex. standby database) faster and with fewer steps. This is not official guide but rather a mix of Oracle 12c functionality used to build DataGuard configuration using RMAN and DataGuard Broker.

Assumptions:
  • There is a database which will be used as primary.
  • New listener will be added to support standby traffic

Steps to run on primary database

Listener configuration

LISTENER_DG =

How to quickly build standby database and setup DataGuard configuration using Oracle 12c

With every release of Oracle database there are new possibilities to build a required solution (ex. standby database) faster and with fewer steps. This is not official guide but rather a mix of Oracle 12c functionality used to build DataGuard configuration using RMAN and DataGuard Broker.

Assumptions:
  • There is a database which will be used as primary.
  • New listener will be added to support standby traffic

Steps to run on primary database

Listener configuration

LISTENER_DG =

Clustering_factor

The clustering_factor is one of the most important numbers (if not the most important number) affecting the optimizer’s choice of execution plan – it’s the thing that has the most significant effect on the optimizer’s decision on whether to choose a table scan or an index, and on which index to choose.

Keyword DETERMINISTIC is anything but…

According TheFreeDictionary.com, the word “deterministic” means…

deterministic
de·termin·istic adj. an inevitable consequence of antecedent sufficient causes

According to Wikipedia, the explanation of deterministic algorithm is…

Install the Oracle Client on a Synology DiskStation DS1813+ or DS412+ for Nagios to Monitor Databases

July 26, 2013 (Back to the Previous Post in the Series) In the previous article of this series I provided steps to install and run the Nagios network monitoring utility on either a Synology DiskStation DS1813+ or a DS412+ for the purpose of pinging network devices to verify that the devices respond to ping requests.  […]