"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.
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 eMarcel.com.
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!
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.
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.
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:
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:
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 :-)
Configure and administer Grid Infrastructure can be done using the 2 main provided tools: “crsctl” and “srvctl”.
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.
Creating ASM disk groups is a easy task. You have several ways of doing it, like:
Practice all of them.
Path do Documentation: