Oracle Database 12c Release 2 - Long Identifiers

Prior to Oracle Database 12c Release 2 have a problem with long identifier name, for example, in 11.2 version you cannot create long name (max 30 Bytes) tables.  As you see, from screenshots length of table name column is maximum 30.

In Oracle Database 12c Release 2 changed the length of identifier names, and this change depends on the COMPATIBLE initialization parameter. Documentation says:

If COMPATIBLE is set to a value of 12.2 or higher, then names must be from 1 to 128 bytes long with these exceptions: Names of databases are limited to 8 bytes. Names of disk groups, pluggable databases (PDBs), rollback segments, tablespaces, and tablespace sets are limited to 30 bytes. If an identifier includes multiple parts separated by periods, then each attribute can be up to 128 bytes long. Each period separator, as well as any surrounding double quotation marks, counts as one byte. For example, suppose you identify a column like this: "schema"."table"."column" …

Oracle Database 12c Release 2 - SQL*Plus History Command

As you know that we can repeat our previous SQL*Plus commands in Windows CMD. But in UNIX based systems not supported command line history of SQL*PLus.  For this reason in UNIX and Linux, we used rlwrap utility to see the SQL*Plus command line history and quickly recall previous SQL*Plus commands.

With seconds release of Oracle Database 12c coming SQL*Plus history command for the history of the command line in Linux.

I want to share some example for this command:

Before using History we must enable history command as below:

SQL> set history on
The syntax of HISTORY command as bellow

SQL> help history HISTORY ------- Stores, lists, executes, edits of the commands entered during the current SQL*Plus session. HIST[ORY] [N {RUN | EDIT | DEL[ETE]}] | [CLEAR] N is the entry number listed in the history list. Use this number to recall, edit or delete the command. Example: HIST 3 RUN - will run the 3rd entry from the list. HIST[ORY] without any option will list all entri…

OTN EMEA Tour 2017 Baku

OTN EMEA Tour 2017 took place.

Our city Baku also included this tour this year also. We (board of Azerbaijan Oracle User Group) organized the biggest event at Baku  (Park in Hotel) by sponsored Azercell Telecommunication Company. This year 3 Oracle ACE Director  Bjorn Rost (Germany), Gurcan Orhan (Turkey), Heli Helskyaho (Finland) and an Oracle ACE Rene Antunez (Mexica)  are our guests. Attendees of our event listened very interesting Oracle technical topics at the event.

Here is agenda of our event

I want to share some photos  from event: 

See you next year at Baku. 
Best Regards Mahir M. Quluzade

I'm speaking at OTN EMEA Tour 2017 Baku

Local Oracle User Groups from the EMEA region are cooperating for the fourth year in a row to organize a tour of the region. The OTN EMEA Tour brings a star-studded cast, consisting of some of the world’s best Oracle ACEs, ACE Directors and Rock Star Speakers to the region. Azerbaijan Oracle User Group (AZEROUG) also joined EMEA Tour since last year (2016). This year also will be organize OTN EMEA Tour 2017 Baku (20th, May 2017). I'm  speaking at OTN  EMEA Tour 2017 Baku, my topic is New Features of Oracle Database 12c Release 2 for DBAs and Developers.

Here is about all speakers of OTN EMEA Tour 2017 

See you at event soon. 
Best Regards Mahir

OTN Appreciation Day: DBMS_MONITOR

Today is OTN Appreciation day. In this reason Oracle bloggers share a blog post about himself favorite Oracle feature. This great idea coming from Tim Hall (@oraclebase). I also want share my favorite feature of Oracle Database.

Here’s my contribution to the OTN Appreciation Day.
How to Oracle working? - this question is interesting all of persons which is using Oracle database.
Oracle trace files is very helpful for learn working mechanism of oracle processes.

Each server and background process writes to a trace file. When a process detects an internal error, it writes information about the error to its trace file.

DBMS_MONITOR is very good package for trace database, session, application, module... etc

You can found your trace files in default folder :

Trace file is not more readable, you can use TKPROF for generate readable, text based file from trace files (*.trc)

Read more about Application tracing…

Oracle Database 12.2 New Features (Part I) - Application Express

As you know, Oracle Open World 2016 conferences continue at San Francisco (September 18-22, 2016).

At keynote Session, Larry Ellison (CTO of Oracle Corporation) annoucemented the Oracle Database Exadata Express Cloud Service on new database version 12.2. Here is released cloud documentation

There have very interesting little guide for new features of Oracle Database 12c Release 2.
Why littel , because it is not all features of Oracle Database 12c Release 2, have more interesting features will come with new version, I know. (I attended #OOW15) :)

I want share something about released new feature of Oracle Database 12.2.

Application Development

Oracle Application Express is (first name is HTMLDB 2.0, I used it at 2005 year) very interesting tool for developers. This tool for helping to create applications very rapidly.

Oracle Application Express 5.0.4 is latest version, released on July 12, 2016 and Application Express 5.1 Early Adopter 2 now available.

Oracle JET integrated with Oracle Ap…

TROUG Days 2016 Istanbul

I attended TROUG Days 2016 Istanbul which is organized Turkish Oracle Users Group as a speaker. It is very amazing conference. I meet my friends during conference.

I talked about In-Memory & Multitenant features of Oracle Database 12c.  I want thank to organizers of  TROUG Days and attenders. I want share some my photos from conference: