Category: Articles

Oracle 12c new features

~ sqlandplsql ~ 3 Comments

Oracle 12c new features

Oracle is planning to release its latest version Oracle 12c which would be
a cloud based database management system. Please be aware that Oracle 12c has not been officially announced yet and so no decisions should be made on below features. I have consolidated it from various sources.

1. Pluggable Database
DBAs will be able create multiple pluggable databases (PDB) that sits
within a single database container. Each PDB will have its own metadata and
private data files. It will be easy to apply patches for all databases by
patching only one container database. Backup and recovery efforts are less
since DBAs can maintain each PDB separately. PDBs are ideal for creating
development and test environments.

2. VARCHAR2 length up to 32767
This one will be one of the best feature for developers who always struggle
to manage large chunk of data. Current version of databases allows only
up to 4000 bytes in a single varchar2 cell. So developers has to either use
CLOB or XML data types which are comparatively slower that varchar2
processing.

3. Default value can reference sequences
This is also for developers who struggle to maintain unique values in
Primary Key columns. While creating a table default column can be
referenced by sequence.nextval.

4. Top-N feature
As like MySQL(limit clause), Oracle 12c will allow Top-N feature in
queries. Analytical function improvements.

5. PL/SQL Unit Security
A role can be granted to a code unit, say Procedure,Function,Package etc.

6. With Clause improvement
Functions can be created with SQL having WITH clause.

7. Duplicate Indexes  
Create duplicate indexes on the same set of columns. Like in large
applications you might want two different types of index on the same data.

8. Boolean in SQL
As of Oracle 11g Boolean is not a supported data type in SQL and 12c you can
enjoy this feature.

9. Implicit Result Sets
Ref Cursors can be directly open in side program units. No need to use
Oracle collection to handle ref cursor seperately.

10. Transaction Guard
Transaction can be marked as “unknown” where transactions outcome is
not known. This will safe guard duplicate submission of successful transactions.

Few more features as bullet points. More details yet to come

  •  Asynchronous Global Index maintenance for DROP and TRUNCATE.
  •  Cascade for TRUNCATE and EXCHANGE partition.
  •  Multiple partition operations in a single DDL.
  •  Online move of a partition (without DBMS_REDEFINTIION).
  •  Interval + Reference Partitioning.
  •  Adaptive Execution/statistics Plans.
  •  STATISTICS COLLECTOR steps in the SQL Trace.
  •  Global temporary tables can have “session private statistics”.
  •  Temporary Undo for temporary tables.

Did you find any thing else ? Please feel free to add your comments.

Android vs iOS – Which is best ?

~ sqlandplsql ~ 3 Comments

Android is the mobile Google’s operating system and iOS is Apple’s operating system. Both of them are originally designed for running in mobile platforms and now running in many platforms

Which one is best ? Of course that is a million dollar question.

Android tablets

Market Share

According to Technology Research firm Gartner ( www.gartner.com ) Android has 64% and iOS has 18% market share as of 2012 Q2. Android market share is growing rapidly than any other mobile vendors.

Mobile Apps

Apple store has more than 600,000 apps available and Android has more than 350,000 apps. Also there are more than 20,000 malicious android apps. Apple has more strict rules to choose apps than Android apps.

Openness

Android is a Linux-based operating system and Google releases the Android as open source. So any hardware vendor can adapt Android under open source license. iOS is a proprietary software of Apple corporation and it is closed.

Revenue

Apple sells both software and hardware while Google does have only software. Also marginal profit is higher for hardware. Apple apps makes more revenue compare to Android apps. Only in mobile ad revenue Android has higher share.

Software Update

iOS running only in Apple products while Android runs in different systems of different vendors. So comparison is not so easy. Taking into consideration this fact Android operating systems are getting upgraded faster than Apple iOS.

Conclusion :-  Both has its own pros and cons still Android and iOS are the best mobile operating systems in the world. They outscored Nokia, Blackberry, Windows Mobile with a “huge huge” margin. So its customer choice which operating system you need.

Ubuntu Online Music Store

~ sqlandplsql ~ 1 Comment

Like iTunes,Google play, Amazon, now Ubuntu also has a online music store with Ubuntu One. Ubuntu launched it last week and users can buy music from Ubuntu one site from Desktop or Mobile. Link – Ubuntu One Music Store

Ubuntu one is available in Windows, Ubuntu, Android and iPhone.

Ubuntu music store
Ubuntu music store

Ubuntu has a promotional offer. Screenshot below. So hurry up and buy music from Ubuntu Store !

Ubuntu Music Store – Promotional Offer

Share Your comments !

Latest version of Oracle database – Oracle 12c

~ sqlandplsql ~ 27 Comments

Oracle 12c database

The latest version of Oracle’s database will be released in either December 2012 or January 2013. CEO of Oracle Larry Ellison said in an onstage interview.

In Oracle 12c, ‘c’ stands for Cloud

Oracle in putting more effort on Cloud systems these days. Oracle already released Oracle Enterprise Manager 12c in earlier this year. Now Oracle has the latest database a Oracle 11g release 2. Oracle not release any other information about Oracle 12c, but sure that it will be more ‘cloud’ based than Oracle 11g.

Oracle 12c new features

Oracle is the leading RDBMS available in the market. (www.oracle.com). According to Technology research firm Gartner, Oracle revenue share is higher than 45% in database.

Oracle Corporation   IT server world is curiously waiting to see the power of Oracle database machine supported by SUN hardware systems ( Oracle acquired Sun in 2010 )

Share you comment !

Memory test for Browsers in Ubuntu 12.04

~ sqlandplsql ~ 2 Comments

Memory test for Browsers in Ubuntu 12.04

Today I have done an exercise to check how much memory each browser consume in Ubuntu 12.04.

I have tested 3 popular browsers by opening 10 sites in each tab

1. Google.com
2. Yahoo.com
3. BBC.com
4. WordPress.com
5. Gmail.com
6. CNN.com
7. Youtube.com
8. Mashable.com
9. Wikipedia.org
10. Bing.com

Opened above 10 tabs in each browser and verified the memory by using System Monitor

1. Mozilla Firefox – Version 14.0.1

Firefox memory consumption

2. Google Chrome – Version 21.0.1180.89

Chrome memory consumption

3. Opera – Version 12.01

Opera Memory Consumption

Firefox – 655 MB

Chrome – 652 MB

Opera – 318 MB

Firefox and Chrome consumes almost same amount of memory while Opera use just around half of others. So Opera is the absolute winner!!!!

So we must give 100% credits to opera. I am running my Ubuntu12.04 in a laptop with 2 GB ram. So if I open 10 tabs in firefox or chrome it will use more than 30% memory !!.

Share your thoughts

Force quit Ubuntu 12.04 – System Monitor

~ sqlandplsql ~ Leave a comment

How to forcefully quit or kill an application or program.

In Ubuntu 11.10 we have an application “Force Quit” which is not available in Ubuntu 12.04 ( If you need it in Ubuntu 12.04 you can download and install manually using the link –> Force Quit )

So what is the alternative. Use system monitor.

System Monitor

Open System monitor and click Process tab. Locate your application and click “end process” ( This is almost similar to Microsoft windows task manager )

System Monitor Screenshot

Notepad++ – Tips and Tricks

~ sqlandplsql ~ 7 Comments

Notepad++ arguably one of the best free text editor. Now you can install it in Ubuntu too

( Read – Install Notepad++ in Ubuntu ).

There are many features available in Notepad++.  Few of them are explained here.

( Version — V6.1.5 )

1. Style configuration – Font, Background Color, Syntax highlighting, Font color etc

In the menu click Settings –> Style Configurator

Notepad++ style configurator

There are many options for Setting style as your favourite language, default style,font etc.

Global style is applicable for all files. You can set each language different style.

See below example for an SQL and C program file Syntax highlighting

abc.sql

Notepad++ syntax highlighting

abc.c

Notepad++ syntax highlighting

 

 

 

 

 

 

 

 

 

2. Column editing ( Vertical editing )

Column editing feature is very useful. I think many of the modern text editors lack this feature.

Keyboard Shortcuts –  press Alt+Mouse or Alt+Shift+Down Arrow Key

Menu – Edit –> Column mode

Notepad++ column mode

This is very useful when you have many line items with similar text items.

3. Clipboard History

Clipboard History shows all text copied recently.

Menu — Edit –> Clipboard History

Clipboard History

4. ASCII Chart

Many developers like ASCII Chart handy. Notepad++ has it.

Menu — Edit –> Character Panel

5. Multiple Tabs

Can open files in different tabs

Menu —  View –>

Move/Clone Current Document

6. Google search integration

Suppose I need some help on a keyword  “stdio.h”. No need to open a browser separately and Notepad++ will do it for you. Just highlight the word you want to google and click Run –> Google Search or press Alt+F2.

Also you have many other features in Run menu. Wikipedia Search, Open in many browsers etc.

7. Bookmarks

You can set bookmarks and go through bookmarks.

Menu – Search –> Bookmark –>

8. Find in files

This is an operating system command tool. You can find files in a directory for a word or something

Menu — Search –> Search in Files

Keyboard — Ctrl+Shift+F

9. Upper-case and Lower-case

Menu — Edit –> Convert Case to

Upper-Case – Ctrl+Shift+U

Lower-Case – Shift+U

10. Zoom (Increase/Decrease the Font size dynamically )

Zoom up and down using

Mouse — Ctrl+Mouse+Wheel Up and Don

Keyboard — Ctrl+Num+/-

Menu — View –> Zoom –>

Note :-If you are running Notepad++ in Ubuntu, some of the features may not work as in Windows.