Category Archives: Database Administration

Important New Features of Oracle Database 12c

ora12cIn Oracle Open World 2012 took place in San Francisco, Larry Ellison announced that oracle database  also be cloud enabled in coming edition. Let discuss some of the important new feature of Oracle Database 12c.

  • Pluggable database means you have ability to create container database which consists all of the oracle level data and data dictionary. On the other end user can create pluggable database which contains user related data and data dictionary. The actual trump card is that you can unplug pluggable database from one container database and plugged into another just by updating data dictionary in the target container database.

Data warehousing

  • Can create duplicate index on the same set of columns which would be beneficial specially in the data warehouse environment.
  • More control over PL/SQL code access as role can be granted to code section.
  • Streamline data access by implicit result sets.
  • Can create Ref partition to relate several tables with same partition.
  • Huge enhancement on SQL WITH Clause to improve performance of PL/SQL code.
  • INDENTITY columns for auto numbering to catchup with MYSQL.
  • Support for 32k VARCHAR2, means values stored like a CLOB.

Hope there are many more features to come, now just wait for the official announcement from Oracle.

Oracle Vs. Microsoft SQL Server

OracleMicrosoftChoice between Oracle and Microsoft Sql Server has always been on the discussion while organization decides on database platform. Running Microsoft Sql Server costs much less than running Oracle because companies who have implemented Oracle spending millions of dollars every year compared to thousands of dollars for Microsoft Sql Server. Even though cost of maintaining Oracle database is higher than Microsoft Sql Server, it is still leading the market of database world. Let’s discuss some the facts that why Oracle is more preferred than Microsoft Sql Server.

Microsoft Sql Server is easy to administrator and works well where sizes of the database are less than few hundred of gigabytes and if it grows faster then there will be performance issue arises on the surface. In contrast Oracle can run multi terabyte database without any performance issue with the help of larger number of tuning options and features available along with software.

Database Services

Microsoft Sql server only offers vertical scalability so you can add more memory and CPU to the server to address vertical scalability. In contrast Oracle can offer you the same but once threshold is reached then we can upgrade to Real Application Cluster technology to address the horizontal scalability.

Microsoft Sql Server ties to Windows operating system which makes it a weak contender as Oracle works well on Windows and UNIX both. Most business considers UNIX operating system as it is more robust, stable and reliable compare to Windows which prone to crashes.

So It is up to organization to decide whether they want to go for Oracle or Microsoft Sql Server.