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.Creating table with long nameTable Name Column size 30In 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 ...继续阅读 (9)

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 onThe syntax of HISTORY command as bellowSQL> help histor ...继续阅读 (14)

Oracle Database 18c was available on Oracle Cloud. Now everybody can download Oracle Database 18c On-Premises for Linux (LINUX.X64_180000_db_home.zip)Oracle change a little on installation file.OUI does not copy files to Oracle HomeYou just extractthe zipfile to Oracle Home directly and OUI only linking binaries.I installed Oracle Database 18c on Linux 7.1. Before installation, I set Oracle environments such as (ORACLE_HOME, ORACLE_BASE). You can add these settings in oracle user .bash_profile.You can watch my little installation video:You can also read all about the new features in the18c doc ...继续阅读 (10)

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.Creating table with long nameTable Name Column size 30In 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 ...继续阅读 (9)

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 usedrlwrap 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*Plushistorycommand 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 onThe syntax of HISTORY command as bellowSQL> help historyHI ...继续阅读 (8)

OTN EMEA Tour 2017took place.Our city Baku also included this tour this year also. We (board ofAzerbaijan Oracle User Group) organized the biggest event at Baku (Park in Hotel) by sponsoredAzercellTelecommunication Company. This year 3 Oracle ACE Director Bjorn Rost(Germany), Gurcan Orhan(Turkey),Heli Helskyaho (Finland) and an Oracle ACERene Antunez(Mexica) are our guests. Attendees of our event listened very interesting Oracle technical topics at the event.Here is agenda of our eventI want to share some photos from event: Keynote Speach by Oracle ACED Kamran Ageyev A. (Azerbaijan)Oracle ...继续阅读 (7)

OTN EMEA Tour 2017took place.Our city Baku also included this tour this year also. We (board ofAzerbaijan Oracle User Group) organized the biggest event at Baku (Park in Hotel) by sponsoredAzercellTelecommunication Company. This year 3 Oracle ACE Director Bjorn Rost(Germany), Gurcan Orhan(Turkey),Heli Helskyaho (Finland) and an Oracle ACERene Antunez(Mexica) are our guests. Attendees of our event listened very interesting Oracle technical topics at the event.Here is agenda of our eventI want to share some photos from event: Keynote Speach by Oracle ACED Kamran Ageyev A. (Azerbaijan)Oracle ...继续阅读 (6)

Local Oracle User Groups from theEMEAregion are cooperating for the fourth year in a row to organize a tour of the region. TheOTN EMEA Tourbrings 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 isNew Features of Oracle Database 12c Release 2 for DBAs and Developers.Here is about all speakers of OTN EMEA Tour 20 ...继续阅读 (19)

Local Oracle User Groups from theEMEAregion are cooperating for the fourth year in a row to organize a tour of the region. TheOTN EMEA Tourbrings 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 isNew Features of Oracle Database 12c Release 2 for DBAs and Developers.Here is about all speakers of OTN EMEA Tour 20 ...继续阅读 (4)

Today is OTN Appreciation day. In this reason Oracle bloggers share a blog post about himself favorite Oracle feature. This great idea coming fromTim Hall(@oraclebase). I also want share my favorite feature of Oracle Database.Here’s my contribution to theOTN 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 ...继续阅读 (7)

This is my little blogpost for part of OTN Appreciation day. For this reason Oracle bloggers share a blog post about himself favorite Oracle feature.  This great idea coming from Tim (@oraclebase).I want share my favorite feature of Oracle Database.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_M ...继续阅读 (27)

As you know,Oracle Open World 2016 conferencescontinue 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 documentationThere 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 Or ...继续阅读 (14)

As you know,Oracle Open World 2016 conferencescontinue 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 documentationThere 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 ...继续阅读 (8)

I'm speaking at AZEROUG (Azerbaijan Oracle Users Group) Meeting February 27th, 2016 at Qafqaz University/ Baku, Azerbaijan. I'll speak about amazing Oracle Database option In-Memory.See you !Update: Feb 27th, 2016Best RegardsMahir ...继续阅读 (11)

I attendedTROUG Days 2016 Istanbulwhich 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: I used following slides at my session:Oracle Database In-Memory & Multitenant - TROUG Days'16 Istanbul fromMahir M. QuluzadeSee you my friends at next events and conferences.Best RegardsMahir M. Quluzade ...继续阅读 (10)

I attendedTROUG Days 2016 Istanbulwhich 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: See you my friends at next events and conferences.Best RegardsMahir M. Quluzade ...继续阅读 (19)

Oracle Technology Network Latinastarted publish our new article series about Oracle Database 11g: Client Failover with Standby DatabaseIn Spanish language: http://www.oracle.com/technetwork/es/articles/database-performance/client-failover-standby-database-2660858-esa.htmlIn Portuguese Language: http://www.oracle.com/technetwork/pt/articles/database-performance/clientfailover-em-standby-databases-3002075-ptb.htmlIt is my first article published on OTN Latina after awarded Oracle ACE. My special thanks to my friend Oracle ACED Joel Perez (Venezuela) for all supports. Also you can watch video t ...继续阅读 (5)

Oracle Technology Networkcontinue publish our article. My next article published OTN Latina in Spanish language.You can read this article at : OTN LatinaOracle Database 12c: "Colección automática de estadísticas para cargas masivas"http://www.oracle.com/technetwork/es/articles/database-performance/coleccion-estadisticas-bulkloads-2995165-esa.htmlYou can read this article also in English :http://otechmag.com/magazine/2015/winter/mahir-m.-quluzade.htmlMy special thanks my friends Joel and Sebastian ! Best RegardsMahir M. Quluzade ...继续阅读 (7)

Oracle Technology Networkcontinue publish our article. My next article published OTN Latina in Spanish language.You can read this article at : OTN LatinaOracle Database 12c: "Colección automática de estadísticas para cargas masivas"http://www.oracle.com/technetwork/es/articles/database-performance/coleccion-estadisticas-bulkloads-2995165-esa.htmlYou can read this article also in English :http://otechmag.com/magazine/2015/winter/mahir-m.-quluzade.htmlMy special thanks my friends Joel and Sebastian ! Best RegardsMahir M. Quluzade ...继续阅读 (68)

TROUG Days Istanbul 2016 Agenda now online, published at http://www.troug.org/wp-content/uploads/2016/02/Agenda.pdfI'll speaking at TROUG Days Istanbul 2016, Apr 28th, 14:30 Hall A, ITU Teknokent.My topic isOracle In-Memory with Multitenant.See you at TROUG Days Istanbul 2016!Best RegardsMahir ...继续阅读 (7)

TROUG Days Istanbul 2016 Agenda now online, published at http://www.troug.org/wp-content/uploads/2016/02/Agenda.pdfI'll speaking at TROUG Days Istanbul 2016, Apr 28th, 14:30 Hall A, ITU Teknokent.My topic isOracle In-Memory with Multitenant.See you at TROUG Days Istanbul 2016!Best RegardsMahir ...继续阅读 (5)

I'm speaking at AZEROUG (Azerbaijan Oracle Users Group) Meeting February 27th, 2016 at Qafqaz University/ Baku, Azerbaijan. I'll speak about amazing Oracle Database option In-Memory.See you !Best RegardsMahir  ...继续阅读 (14)

OTech Magazine issue Winter 2015is the tenth – and last – issue of OTech Magazine – the independent Oracle technology magazine. In this last issue of OTech Magazine we offer you 10 highly technical articles on Oracle technology.My "Automatic Gather Statistics for Bulk Loads" article also published in this issue. Automatically gathering statistics enhanced within Oracle Database 12c Release 1. My article covers this feature of Oracle Database 12c Release 1 with examples of automatically collect statistics of objects when bulk load operations.You can read my article from:http://otechmag.com/maga ...继续阅读 (16)

OTech Magazine issue Winter 2015is the tenth – and last – issue of OTech Magazine – the independent Oracle technology magazine. In this last issue of OTech Magazine we offer you 10 highly technical articles on Oracle technology.My "Automatic Gather Statistics for Bulk Loads" article also published in this issue. Automatically gathering statistics enhanced within Oracle Database 12c Release 1. My article covers this feature of Oracle Database 12c Release 1 with examples of automatically collect statistics of objects when bulk load operations.You can read my article from:http://otechmag.com/maga ...继续阅读 (6)

Oracle Technology Network Latinastarted publish our new article series about Oracle Database 11g: Client Failover with  Standby DatabasePart I: http://www.oracle.com/technetwork/es/articles/database-performance/client-failover-standby-database-2660858-esa.htmlIt is my first article published on OTN Latina after awarded Oracle ACE. My special thanks to my friend Oracle ACED Joel Perez (Venezuela) for all supports. Also you can watch video tutorial in this topic:Best RegardsMahir M. Quluzade ...继续阅读 (29)

As you know, Oracle Magazine July/Aug 2015 issue released. You can free subscribe to Oracle Magazine digital edition and you can readhereor you can read technical articleshere.I subscribed Oracle Magazine, in current issue have very interesting articles.One of interesting article of Oracle Expert Tomas Kyte (as known AskTom) with title:On Learning from MistakesIn this article Tom talks about Cost Based Optimizer and shown how optimizer learning from mistakes. I don't want review this article, but there have about interesting new feature of Oracle Database 12c. Tom wrote:The fact that the NO ...继续阅读 (10)

Oracle Technology Network Latinastarted publish our new article series about Oracle Database In-Memory. This articles is first about In-Memory in OTN Latina articles.First and Second parts of Oracle Database In-Memory article series published in 2 language (Spanish/Portuguese) same time.In Spanish LanguagePart I: http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-in-memory-2595521-esa.htmlPart II: http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-in-memory-part2-2595866-esa.htmlIn Portuguese LanguagePart I; http://www.oracle. ...继续阅读 (8)

As you know, Oracle Magazine July/Aug 2015 issue released. You can free subscribe to Oracle Magazine digital edition and you can readhereor you can read technical articleshere.I subscribed Oracle Magazine, in current issue have very interesting articles.One of interesting article of Oracle Expert Tomas Kyte (as known AskTom) with title:On Learning from MistakesIn this article Tom talks about Cost Based Optimizer and shown how optimizer learning from mistakes. I don't want review this article, but there have about interesting new feature of Oracle Database 12c. Tom wrote:The fact that the NO ...继续阅读 (34)

Cloud computing is known for many things: cost effectiveness, flexibility, scalability.Oracle Cloud provides several Oracle Database offerings. Choose between a single schema based service, or a virtual machine with a fully configured running Oracle Database Instance, or Exadata Service with all the database features, options, and workloads.Oracle Cloud Provide Database schema Service as: 1 Schema on Oracle Database 11gI don't know, can we request on Oracle Database 12c Release 1. But I think in the future can provide on 12c version Choice of 5, 20, and 50 GB database storage (1GB for trial a ...继续阅读 (14)

Cloud computing is known for many things: cost effectiveness, flexibility, scalability.Oracle Cloud provides several Oracle Database offerings. Choose between a single schema based service, or a virtual machine with a fully configured running Oracle Database Instance, or Exadata Service with all the database features, options, and workloads.Oracle Cloud Provide Database schema Service as: 1 Schema on Oracle Database 11gI don't know, can we request on Oracle Database 12c Release 1. But I think in the future can provide on 12c version Choice of 5, 20, and 50 GB database storage (1GB for trial a ...继续阅读 (36)