Oracle VM Site Review - Oracle VM Health Check
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.

It Isn’t The Index

"If you want sense, you'll have to make it yourself."
- Norton Juster, The Phantom Tollbooth

One of the more confusing statistics in Oracle is, apparently, one called the clustering factor. Associated with an index (as evidenced by the columns in DBA_INDEXES) it’s actually dependent on the table data, more specifically the distance between ‘jumps’ for a given index key. Let’s define a ‘jump’ to be the number of blocks between rows containing the given index key starting with the first block found containing that key.

Around the world flight 7 – Faro to Gibraltar

We are going to enjoy a leisurely flight along the Portuguese Coast before flying through the Straits of Gibraltar and landing at the iconic Gibraltar airport. Gibraltar is a British Overseas Territory located on the southern end of the Iberian Peninsula at the entrance of the Mediterranean. It has an area of 6.0 km2 and […]
The post Around the world flight 7 – Faro to Gibraltar appeared first on

August in Blogging U: Blogging 101

Have you just started blogging (welcome!), or are you looking to breathe new life into a blogging habit that’s fallen by the wayside? Blogging U. is a great way to get on track, with bite-size assignments, a supportive community, and staff to support you. This August, we’re offering Blogging 101— and registration is now open!

Database Rankings July 2015

Here is an interesting Database rankings survey on the db-engines site, which measures the general interest in the different databases, based on the criteria below. This provides some insight into the trend in the adoption of these databases. Database Rankings Criteria •Number of mentions of the system on websites – From Google and Bing. •General […]
The post Database Rankings July 2015 appeared first on VitalSoftTech.

Power BI General Availability

In the last months I’ve been keeping an eye on the Power BI Preview, the new version of the Power BI cloud solution that was completely revamped compared to the first Power BI v1.
This last Friday, July 24th, Power BI was finally released to the public and it is now available globally. The best part? Now they have a FREE version, so you can start playing with it right now and get insights from your data.

Charting Number of R Packages over time (Part 3)

This is the third and final blog post on analysing the number of new R packages that have been submitted over time. Check out the previous blog posts:

  • Blog Post 1 : Getting, some basic analysis and graph
  • Blog Post 2 : Aggregating the data and create a number of more useful graphs.

In this blog post I will show you how you can perform Forecasting on our data to make some predictions on the possible number of new packages over the next 12 months. There are 2 important points to note here:

Multiple invisible indexes on the same column in #Oracle 12c

After invisible indexes got introduced in 11g, they have now been enhanced in 12c: You can have multiple indexes on the same set of columns with that feature. Why would you want to use that? Actually, this is always the first question I ask when I see a new feature – sometimes it’s really hard to answer :-)

OCM 11g Preparation – Start, stop, configure and administer Oracle Grid Infrastructure

Configure and administer Grid Infrastructure can be done using the 2 main provided tools: “crsctl” and “srvctl”.

OCM 11g Preparation – Implement ASM failure groups

Failure groups is a way to implement some kind of RAID protection in your diskgroups. Its very useful when you want to guarantee an extra protection and turn on hot swap of your disks without an extra cost of an storage system.
Honestly, every company that I’ve worked avoided this protection as we had this implemented at the storage layer.
Practice here:

OCM 11g Preparation – Create ASM Disk Groups

Creating ASM disk groups is a easy task. You have several ways of doing it, like:

  • asmca (Preferable)
  • sqlplus
  • asmcmd
  • Enterprise Manager (Yes, don’t forget him!)

Practice all of them.
Path do Documentation:

view counter