ALL POSTS

What it’s Like to Intern at Pythian

About eight months ago I started working as a Global Talent Acquisition Intern here at Pythian. It was my first co-op work placement, and my first experience in a professional work setting. I had never done anything like it before and was definitely nervous yet excited for the opportunity. As any eager but nervous person, I researched…

Watch: Riak vs. Oracle

Every data platform has its value, and deciding which one will work best for your big data objectives can be tricky—Alex Gorbachev, Oracle ACE Director, Cloudera Champion of Big Data, and Chief Technology Officer at Pythian, has recorded a series of videos comparing the various big data platforms and presents use cases to help you…

Calculating Business Days in HiveQL

One of the common tasks in data processing is to calculate the number of days between two given dates. You can easily achieve this by using Hive DATEDIFF function. You can also get weekday number by using this more obscure function: SELECT FROM_UNIXTIME(your_date,’u’) FROM some_table; This will return 1 for Monday, 7 for Sunday and…

How to Migrate a Database Using GoldenGate

There are many ways to migrate a database from A server to B server like Datapump, RMAN,etc. Using the combination of datapump and GoldenGate to migrate your database on cross-platform will minimize your down-time to even three minutes. This method can be used for any size database from MB to TB level. Here is a…

Merging Apps Patches in Oracle EBS R12.2

It’s public knowledge that the traditional patching tool in Oracle EBS “adpatch” is replaced with “adop” utility. It’s also known that adop utility automatically merges patches when more than one patch is specified in the command line arguments. So whats the need for blog post on merging patches when its taken care automatically? This blog…

Watch: HBase vs. Cassandra

Every data platform has its value, and deciding which one will work best for your big data objectives can be tricky—Alex Gorbachev, Oracle ACE Director, Cloudera Champion of Big Data, and Chief Technology Officer at Pythian, has recorded a series of videos comparing the various big data platforms and presents use cases to help you…

Performance Issues with the Sequence NEXTVAL Call

Is SELECTing from a sequence your Oracle Performance Problem? The answer to that question is: it might be! You wouldn’t expect a sequence select to be a significant problem but recently we saw that it was—and in two different ways. The issue came to light when investigating a report performance issue on an Oracle 11.2.0.4…

Page 12 of 285« First Page...1011121314...20...Last Page »