Month: August 2018

This Week in Data With Colin Charles 51: Debates Emerging on the Relicensing of OSS

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. There has been a lot of talk around licenses in open source software, and it has hit the database world in the past weeks. Redis Labs relicensed some AGPL software to the Commons Clause (in […]

The post This Week in Data With Colin Charles 51: Debates Emerging on the Relicensing of OSS appeared first on Percona Database Performance Blog.

Webinar Wed 9/5: Choosing the Right Open Source Database

open source database

Please join Percona’s CEO, Peter Zaitsev as he presents Choosing the Right Open Source Database on Wednesday, September 5th, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).   Register Now   The world of open-source databases is overwhelming. There are dozens of types of databases – relational DBMS, time-series, graph, document, etc. – not to […]

The post Webinar Wed 9/5: Choosing the Right Open Source Database appeared first on Percona Database Performance Blog.

Tuning PostgreSQL Database Parameters to Optimize Performance

PostgreSQL parameters for database performance tuning

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. Default values are set to ensure that PostgreSQL runs everywhere, with the least resources it can consume and so that it doesn’t cause any vulnerabilities. It has default settings for all of the database parameters. It is primarily the responsibility […]

The post Tuning PostgreSQL Database Parameters to Optimize Performance appeared first on Percona Database Performance Blog.

Is It a Read Intensive or a Write Intensive Workload?

innodb row operations featured

One of the common ways to classify database workloads is whether it is  “read intensive” or “write intensive”. In other words, whether the workload is dominated by reads or writes. Why should you care? Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as […]

The post Is It a Read Intensive or a Write Intensive Workload? appeared first on Percona Database Performance Blog.

Scaling IO-Bound Workloads for MySQL in the Cloud

InnoDB / MyRocks throughput on IO1

Is increasing GP2 volumes size or increasing IOPS for IO1 volumes a valid method for scaling IO-Bound workloads? In this post I’ll focus on one question: how much can we improve performance if we use faster cloud volumes? This post is a continuance of previous cloud research posts: Saving With MyRocks in The Cloud Percona […]

The post Scaling IO-Bound Workloads for MySQL in the Cloud appeared first on Percona Database Performance Blog.

Tune Linux Kernel Parameters For PostgreSQL Optimization

Linux parameters for PostgreSQL performance tuning

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are configured according to the database server and its workload. In this post, we will discuss some important kernel parameters that can […]

The post Tune Linux Kernel Parameters For PostgreSQL Optimization appeared first on Percona Database Performance Blog.

The Secret to Choosing the Best Oracle DBA Certification for You

Have you tried navigating the Oracle Certification labyrinth lately? If so, you may have come away with your head spinning! While there are many offerings in many layers of technology for a wide and diverse audience, it may be difficult knowing where to start. 

The Oracle Certification program began with Oracle Database 7.3. Candidates chose either the Database Administrator or the Developer track. Much has changed in a couple of decades! The program is now anchored by both our core Oracle Database and our Java certifications, but hundreds of implementation certifications have also been added.

This is good news for non-database professionals who wish to certify on one of the numerous Oracle technologies outside of Database, but this makes it more difficult for some to choose the correct certification track. 

Matthew Morris, experienced DBA and developer, multiple Oracle certification holder, and respected author and blogger published an article on in 2015 that stands the test of time by helping candidates navigate this winding river of Oracle Certification options – More than Just Database: A Beginner’s Guide to Oracle Certification. While some of the credentials and exams referenced by the article may be outdated, the content stands the test of time.

If your certification interest is laser focused on Oracle Database, we can help. Check the decision-making diagram above.

Scroll further down for more in depth information on each step in the decision making process, and to see where you can go after you’ve earned the OCA and OCP levels of certification.

I. First, start with your job role – Database Administrator, Developer or Implementer.

Database Administrators: Skill set and job role may vary depending on whether you are a “development” or “architect” DBA or more of a “production” DBA. Skill set may include installation, patching, configuration, security, backup and recovery, migration, capacity planning, logical and physical data modeling, database design, performance management, SQL Tuning and troubleshooting in the Oracle Cloud, on premises or both.  Including High Availably, Disaster Recovery and aspects of OS administration.

Database Developers: Skill set may include SQL, SQL*PLUS, SQLCL, PL/SQ, Java, Application Express, database design, logical and physical modeling, and SQL tuning.

Implementers: Typically have a strong technical background in the product area on which they are certified and are responsible for implementing or installing this software or certain aspects of the software.

Related: Build a DBA Career to Last

II. Next, determine which certification path to start.

Database Administrators, your next step is to determine which version of certification you wish to pursue. Some considerations are:

  • The version or versions of Oracle Database that your company uses if you are employed.
  • The version or versions of Oracle Database most often specified in job descriptions if you are job hunting.
  • Have you already completed an Oracle Database training course  for a specific version? This is very important. Oracle Certified Professional (OCP) certification requires training on the version that matches your certification or a on later version. e.g. If you have had Oracle training for Oracle Database 11g, you should pursue 11g certification and then upgrade to 12c when appropriate.
  • Training is not required to upgrade to a later version of Oracle Database Administrator Certified Professional once you already hold a DBA OCP certification.
  • If you are certified on an Oracle Database release that is newer than that which is used by your company,  you can help define the strategy for the adoption of new features and functions
  • When an older version of Oracle Database is de-supported,  you will be required to upgrade your certification to match a supported version of Oracle Database to keep your certification active. Read the Recertification Policy.
  • Oracle recommends keeping your skills current by attending the latest training courses and maintaining your certification.

If you choose Oracle Database 12c R2 (recommended), start here:

If you choose Oracle Database 12c, start here:

If you choose Oracle Database 11g, start here:

Database Developers will all start in the same place for certification – Oracle PL/SQL Developer Certified Associate. From there, you can decide whether to move to the advanced certification. When you get to this point, the same considerations listed above apply.

Database Developers start here:

Implementers: Candidates pursuing an Implementation role have options under the Oracle Database 12c product. An Implementer’s product focus area might vary somewhat compared to a Database Administrator or Developer. Implementation Specialist certifications are available to all candidates but are geared toward Oracle’s partner employees.

Some considerations:

  • If you work for or wish to work for an Oracle partner, the partner may have product area requirements.

  • If you are seeking this certification on your own, use some of the same considerations listed above to decide in which direction to go.

  • You can also review exam topics to discover the skills required of someone who holds a particular certification.

Start here:

III. Further considerations for Database Administrators and Developers

*An important consideration for both the DBA and Developer paths is that both a SQL exam and an Associate-level exam must be passed to earn the Associate-level certification.

Here are the options for the SQL exam:

  • Oracle Database 12c SQL | 1Z0-071: This is a proctored exam that must be taken in a test center. Passing this exam earns you the Oracle Database SQL Certified Associate credential. This exam better fits the defined job role.
  • Oracle Database 12c: SQL Fundamentals | 1Z0-061: This is a non-proctored exam that can be taken online at your own location. Passing this exam fulfills the SQL requirement, but does not result in a certification on its own. It must be paired with the next exam in your path in order to earn a certification. Vouchers for this exam will no longer be sold after May 31,2019. Candidates will have 6 months to use those vouchers to register for an exam at Pearson VUE. This exam will no longer be offered at Pearson VUE or an Oracle Testing Center after November 30, 2019.

Related:  Navigate Oracle SQL Certification: Quickly and Easily

IV. Now that you’ve earned your Database Administrator or Developer credential, where can you go from here?

Database Administrators can pursue the Oracle Certified Professional (OCP) level of certification by completing a relevant training course and passing the appropriate OCP exam. 

After earning an OCP certification, DBAs can dive a little deeper into a more specific technology by earning an Oracle Certified Expert (OCE) certification or joining the elite ranks of Oracle Certified Masters. The diagram below shows these options.

Related: 7 Reasons OCM Deiby Gomez Thinks Oracle Certifications Are Worth The Effort

Some OCE certifications can be earned by completing training as an alternative to a prerequisite OCP certification.  

Oracle Certified Expert Certification Paths:

Oracle Certified Master Certification Paths:

Armed with a better understanding of Oracle Database Certification offerings, you should now have what you need to start building a sustainable career path. Get started today!

TEL/電話+86 13764045638
QQ 47079569