tag:blogger.com,1999:blog-15651452841950066972024-03-10T06:46:08.948+04:00Mahir M. Quluzade | Oracle BlogMahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.comBlogger98125tag:blogger.com,1999:blog-1565145284195006697.post-21661510187524140022018-07-27T10:47:00.000+04:002018-07-27T15:33:32.639+04:00Oracle Database 18c - Install On-Premises for Linux<div dir="ltr" style="text-align: left;" trbidi="on">
Oracle Database 18c was available on Oracle Cloud. Now everybody can download Oracle Database 18c On-Premises for Linux (<b><a href="https://download.oracle.com/otn/linux/oracle18c/180000/LINUX.X64_180000_db_home.zip">LINUX.X64_180000_db_home.zip</a>)</b><br />
<b><br />
</b> Oracle change a little on installation file.<br />
<ul style="text-align: left;">
<li>OUI does not copy files to Oracle Home</li>
</ul>
<div>
You just extract <a class="" href="https://download.oracle.com/otn/linux/oracle18c/180000/LINUX.X64_180000_db_home.zip" target="_blank">the zip</a> file to Oracle Home directly and OUI only linking binaries.</div>
<div>
<br /></div>
<div>
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.<br />
<br /></div>
<div>
You can watch my little installation video:</div>
<div>
<div style="text-align: center;">
<br /></div>
</div>
<div>
<div style="text-align: center;">
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/gyADrFrlxA4" width="480"></iframe><br /></div>
</div>
<div style="text-align: center;">
<br />
<br /></div>
You can also read all about the new features in the <a href="https://docs.oracle.com/en/database/oracle/oracle-database/18/index.html">18c documentation </a><br />
<br />
Best Regards<br />
<b>Mahir M. Quluzade</b><br />
Oracle ACE</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215770699999986 49.544368900000045 40.602752699999989 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-54272274899907912902017-05-27T16:34:00.001+04:002018-09-04T13:42:58.649+04:00Oracle Database 12c Release 2 - Long Identifiers<div dir="ltr" style="text-align: left;" trbidi="on">
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 <b>table name </b>column is maximum 30.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyH3ynPqQOqgWrIV3pS-kMFbx47pGcR_8_dyvXcsxzZjGZQmEh_Jm5S6VQ5RKVycKfhMurJHi41Lcreu7fDdRSQsqraMZC8r64qDwvsSH4gUDuYbY2M2hUq8F6Io7nDXxGWyz70uQAGIQ/s1600/CreateTable+With+Long+Identifiers112.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="116" data-original-width="670" height="110" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyH3ynPqQOqgWrIV3pS-kMFbx47pGcR_8_dyvXcsxzZjGZQmEh_Jm5S6VQ5RKVycKfhMurJHi41Lcreu7fDdRSQsqraMZC8r64qDwvsSH4gUDuYbY2M2hUq8F6Io7nDXxGWyz70uQAGIQ/s640/CreateTable+With+Long+Identifiers112.PNG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="font-size: 12.8px;">Creating table with long name</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3Jwp-wkC8DsTB0ko7iYl0hPSYEcCw7PC45MtNBvGP9aJbQfQyPtDJB_cWDx9Ehgw731GZbzbPVapXzZj6V1qptH6DLK5QW3QfpETuwgvB7CxUqk_WvhqMLC4-GG6qJMsDTZ9GcyPaJ1E/s1600/dbatables112.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="347" data-original-width="669" height="330" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3Jwp-wkC8DsTB0ko7iYl0hPSYEcCw7PC45MtNBvGP9aJbQfQyPtDJB_cWDx9Ehgw731GZbzbPVapXzZj6V1qptH6DLK5QW3QfpETuwgvB7CxUqk_WvhqMLC4-GG6qJMsDTZ9GcyPaJ1E/s640/dbatables112.PNG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="font-size: 12.8px;">Table Name Column size 30</td></tr>
</tbody></table>
<br />
In Oracle Database 12c Release 2 changed the length of identifier names, and this change depends on the COMPATIBLE initialization parameter. Documentation says:<br />
<br />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" . The schema name can be 128 bytes, the table name can be 128 bytes, and the column name can be 128 bytes. Each of the quotation marks and periods is a single-byte character, so the total length of the identifier in this example can be up to 392 bytes. <a href="http://docs.oracle.com/database/122/SQLRF/Database-Object-Names-and-Qualifiers.htm#SQLRF51129">read more</a><br />
<div>
<br /></div>
<div>
I created long name table, as below</div>
<div>
<br /></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsz5WOcyFGWNh_hs257yj_54n_Rh3F4aX650T22ZwW6TO6w0wr5ajt_oZJ2YMgjSzxl1NqadOY0a_nhpfO4cNIc88CFnIqjjSFTb1cFvjPscTaraMBmWayg8AO03Iebl-cfWbwApRwqzI/s1600/CreateTable+With+Long+Identifiers.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="492" data-original-width="749" height="418" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsz5WOcyFGWNh_hs257yj_54n_Rh3F4aX650T22ZwW6TO6w0wr5ajt_oZJ2YMgjSzxl1NqadOY0a_nhpfO4cNIc88CFnIqjjSFTb1cFvjPscTaraMBmWayg8AO03Iebl-cfWbwApRwqzI/s640/CreateTable+With+Long+Identifiers.PNG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="font-size: 12.8px;">Create Table with long name</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNV9g7ZWsqR6N5cmxxVBgQk5aUXLK6acc88MPRGWYWQm0RkaXIG__vCiZm3ie7nMzKzV-tus_A74AkEYE0yIGx98bAOVl2BIepeOWRFem0bd-Re4kVogcEtfWzKFsJzCGSvKDIEmKZ95A/s1600/UserTables.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="506" data-original-width="910" height="354" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNV9g7ZWsqR6N5cmxxVBgQk5aUXLK6acc88MPRGWYWQm0RkaXIG__vCiZm3ie7nMzKzV-tus_A74AkEYE0yIGx98bAOVl2BIepeOWRFem0bd-Re4kVogcEtfWzKFsJzCGSvKDIEmKZ95A/s640/UserTables.PNG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="font-size: 12.8px;">Shows in user tables view</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjn24JmVSWPWBJkDJJddoWU9N3lZU9uHpgd4v2xtdqgjWbCVdK7z_7dKcAAXaOsFWX7z0aLczXGQsmcweZ7XEbkkqcnbyRoFQx8KxGbEA05byTeW_dYowU1i557sssQPTGE4oPqS4x8J2k/s1600/dbatables122.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="448" data-original-width="805" height="356" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjn24JmVSWPWBJkDJJddoWU9N3lZU9uHpgd4v2xtdqgjWbCVdK7z_7dKcAAXaOsFWX7z0aLczXGQsmcweZ7XEbkkqcnbyRoFQx8KxGbEA05byTeW_dYowU1i557sssQPTGE4oPqS4x8J2k/s640/dbatables122.PNG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="font-size: 12.8px;">Maximum length of table is 128 bytes</td></tr>
</tbody></table>
<div>
If you set COMPATIBLE initialization parameter to lower value 12.2, then you will get the error about ORA-00972: identifier is long<br />
<br />
Best Regards<br />
Mahir M. Quluzade<br />
<br /></div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215770699999986 49.544368900000045 40.602752699999989 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-40310591351150409672017-05-27T14:32:00.001+04:002018-09-04T13:41:55.931+04:00Oracle Database 12c Release 2 - SQL*Plus History Command<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
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 <b class="">rlwrap</b> utility to see the SQL*Plus command line history and quickly recall previous SQL*Plus commands.<br />
<br />
With seconds release of Oracle Database 12c coming SQL*Plus <b>history</b> command for the history of the command line in Linux.<br />
<br />
I want to share some example for this command:<br />
<br />
Before using History we must enable history command as below:<br />
<br />
<pre><b>SQL> set history on </b>
</pre>
<br />
The syntax of HISTORY command as bellow<br />
<br />
<pre><b>SQL> help history</b>
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 entries in the list.
</pre>
<br />
<br />
As you seen from syntax, we can edit, delete, clear list items in history.<br />
<br />
<pre><b>SQL> set history on </b>
SQL>
SQL>
SQL> select name from v$database;
NAME
---------
DB122
SQL> select name, database_role from v$database;
NAME DATABASE_ROLE
--------- ----------------
DB122 PRIMARY
SQL>
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production
SQL>
SQL>
<b>SQL> hist list</b>
1 select name from v$database;
2 select name, database_role from v$database;
3 select banner from v$version;
SQL>
SQL>
<b>SQL> hist 1 run</b>
NAME
---------
DB122
SQL> hist 3 run
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production
SQL>
SQL>
<b>SQL> hist clear</b>
SQL>
SQL> hist list
SP2-1651: History list is empty.
SQL>
SQL>
SQL> select name from v$database;
NAME
---------
DB122
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
db122
SQL>
SQL>
<b>SQL> hist list</b>
1 select name from v$database;
2 select banner from v$version;
3 select instance_name from v$instance;
SQL>
SQL>
SQL> hist 2 edit
</pre>
<br />
Oracle SQL*Plus using vi editor for editing of history command line.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-SsSKYe-HDNA/WSlUzGdXEOI/AAAAAAAAC_g/J09tdLfQf1QYj2RPtp1QdDcvw5AAeM0WwCLcB/s1600/Edit%2Bon%2BHistory%2BCommand%2Bline.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="373" data-original-width="655" height="363" src="https://3.bp.blogspot.com/-SsSKYe-HDNA/WSlUzGdXEOI/AAAAAAAAC_g/J09tdLfQf1QYj2RPtp1QdDcvw5AAeM0WwCLcB/s640/Edit%2Bon%2BHistory%2BCommand%2Bline.PNG" width="640" /></a></div>
<br />
<br />
<pre>SQL>
SQL> hist list
1 select name from v$database;
2 select banner from v$version;
3 select instance_name from v$instance;
4 select banner from v$version
where rownum <=1;
SQL> hist 4 run
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL>
SQL>
SQL> hist clear
SQL>
SQL> set history off
SQL>
SQL>
SQL> hist list
SP2-1650: History is off, use "SET HIST[ORY] ON" to enable History.
SQL>
</pre>
<br />
<br />
Please watch for a video tutorial on Youtube:<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/ATLy7vwt51c" width="560"></iframe><br />
<br />
Best Regards<br />
Mahir M. Quluzade</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0tag:blogger.com,1999:blog-1565145284195006697.post-15286560635874732662017-05-27T13:57:00.001+04:002017-05-27T14:06:59.931+04:00OTN EMEA Tour 2017 Baku <div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://otnemea.com/" target="_blank">OTN EMEA Tour 2017</a> took place.<br />
<br />
Our city Baku also included this tour this year also. We (board of <a href="https://twitter.com/AzerbaijanOUG" target="_blank">Azerbaijan Oracle User Group</a>) organized the biggest event at Baku (Park in Hotel) by sponsored <a href="http://www.azercell.com/az/" target="_blank">Azercell</a> Telecommunication Company. This year 3 Oracle ACE Director <a href="https://twitter.com/brost" target="_blank">Bjorn Rost</a> (Germany), <a href="https://twitter.com/gurcan_orhan" target="_blank">Gurcan Orhan</a> (Turkey), <a href="https://twitter.com/HeliFromFinland" target="_blank">Heli Helskyaho</a> (Finland) and an Oracle ACE <a href="https://twitter.com/rene_ace" target="_blank">Rene Antunez </a>(Mexica) are our guests. Attendees of our event listened very interesting Oracle technical topics at the event.<br />
<br />
Here is agenda of our event<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-ld5FZDLfBqE/WSlKriKx-_I/AAAAAAAAC-U/xjUzcYJfGtgiAWQFyHtI6W3-n9Ru_i-bQCLcB/s1600/IMG_6407.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1440" data-original-width="720" height="640" src="https://2.bp.blogspot.com/-ld5FZDLfBqE/WSlKriKx-_I/AAAAAAAAC-U/xjUzcYJfGtgiAWQFyHtI6W3-n9Ru_i-bQCLcB/s640/IMG_6407.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
I want to share some photos from event: </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbtrJ57j5axPKpjIZAz9dBuldJON5mGbcwmOcZntQTr259X32HaxgBBttQF9wl_7wFcVbH9pCqD8eGhSAxRuaki17RWBNoNibvUG7zH4dmRzrfHToEIXNtwYy2bM7rAa9fxyo5DuuX5U0/s1600/IMG_6439.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1200" data-original-width="1600" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbtrJ57j5axPKpjIZAz9dBuldJON5mGbcwmOcZntQTr259X32HaxgBBttQF9wl_7wFcVbH9pCqD8eGhSAxRuaki17RWBNoNibvUG7zH4dmRzrfHToEIXNtwYy2bM7rAa9fxyo5DuuX5U0/s640/IMG_6439.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Keynote Speach by Oracle ACED Kamran Ageyev A. (Azerbaijan)</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjx2b0kd-qGzRFhPp20gJjR-k2M9FezxeekUrAvmk0hoR4QD3ygz7HGEiRT-jsF2-iIq04r7TefXazmZ3sj5ud10c-BIoqo-lnN5gYthxj_8HHVyvaICE-v0nr8Ym6hiQ8t5S-jGgm9MKU/s1600/IMG_6442.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1200" data-original-width="1600" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjx2b0kd-qGzRFhPp20gJjR-k2M9FezxeekUrAvmk0hoR4QD3ygz7HGEiRT-jsF2-iIq04r7TefXazmZ3sj5ud10c-BIoqo-lnN5gYthxj_8HHVyvaICE-v0nr8Ym6hiQ8t5S-jGgm9MKU/s640/IMG_6442.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Oracle ACE Director Heli Helskyaho (Finland) </td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT2u035f3YS2IiSxY7NhYu8NIH-wJmJXjviUO5tQtn_fNnuLGFp7C_GnT5AWVxjJS81sMevszMtgwxL0dqulLQ5_zeLLa6BnE6ut_9x_mnLhJVp-O3UjyNsbuub1Oi5Yt9Qp17S8z3tDo/s1600/IMG_6456.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1200" data-original-width="1600" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT2u035f3YS2IiSxY7NhYu8NIH-wJmJXjviUO5tQtn_fNnuLGFp7C_GnT5AWVxjJS81sMevszMtgwxL0dqulLQ5_zeLLa6BnE6ut_9x_mnLhJVp-O3UjyNsbuub1Oi5Yt9Qp17S8z3tDo/s640/IMG_6456.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Oracle ACE Director Bjorn Rost (Germany)</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhebsqXWWAEhHoV56EYgpBPsJxBUxLGZzh8U2wQjIMr6MJLrOzdA7QkvargbVHihiAHYUfdoSWgYxmcZFyXlKNUtcu-31qqUDOZxd3MDvbNEzLNwxhgOfNig70vI6GxByx4BLsVNn3nYiY/s1600/IMG_6501.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1200" data-original-width="1600" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhebsqXWWAEhHoV56EYgpBPsJxBUxLGZzh8U2wQjIMr6MJLrOzdA7QkvargbVHihiAHYUfdoSWgYxmcZFyXlKNUtcu-31qqUDOZxd3MDvbNEzLNwxhgOfNig70vI6GxByx4BLsVNn3nYiY/s640/IMG_6501.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Oracle ACE Mahir M. Quluzade (Azerbaijan)</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://4.bp.blogspot.com/-Rkz1ReQ39oQ/WSlMWHXSb0I/AAAAAAAAC_M/0b_3ZEmR6g8y-HlxtXhKCDxyEQukClCDACEw/s1600/IMG_6507.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1200" data-original-width="1600" height="480" src="https://4.bp.blogspot.com/-Rkz1ReQ39oQ/WSlMWHXSb0I/AAAAAAAAC_M/0b_3ZEmR6g8y-HlxtXhKCDxyEQukClCDACEw/s640/IMG_6507.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Oracle ACE Mahir M. Quluzade (Azerbaijan)</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZIdLa8P2CNEVBJrbK-PDimqOH5X4daeyY3psgujmWIeOq7ewSw-EwBQjkJ6JhGPzFpOn5cyj1ApQTQfruquMZfB9nsn5veNbt9napzBgfqmkGF30lrFTa5gA0Knq9vieQAIfZlLnT2uQ/s1600/IMG_6508.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1200" data-original-width="1600" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZIdLa8P2CNEVBJrbK-PDimqOH5X4daeyY3psgujmWIeOq7ewSw-EwBQjkJ6JhGPzFpOn5cyj1ApQTQfruquMZfB9nsn5veNbt9napzBgfqmkGF30lrFTa5gA0Knq9vieQAIfZlLnT2uQ/s640/IMG_6508.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Oracle ACE Director Gurcan Orhan (Turkey)</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiro0gHoJkdulM2BQu4PWHjBDfo38tpu4Ng7-UCmWDYCPc9Jmb_NqXffBY1miGhRgrBg3xwc0GWuq8TXBJdzZBZuz0Yc89_mxi9MYVJb6VLbrHZOjldlK8KBSr1ticUJXV_ntCVZgwsg1I/s1600/IMG_6533.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1200" data-original-width="1600" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiro0gHoJkdulM2BQu4PWHjBDfo38tpu4Ng7-UCmWDYCPc9Jmb_NqXffBY1miGhRgrBg3xwc0GWuq8TXBJdzZBZuz0Yc89_mxi9MYVJb6VLbrHZOjldlK8KBSr1ticUJXV_ntCVZgwsg1I/s640/IMG_6533.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Oracle ACE Rene Antunez (Mexica)</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif7U8CR-rNHISHWKc-8se1hi9v_RXhHaPj6n-ZPfXp51InujFYC_87JIxirPDkNDUixEBRVw0os4mU3XorzjIU7HcP8dk0LfI6SHJ7glO2J2qqYYzZV4nqD9rYgJna6ZCnVc8Wsr29hOo/s1600/IMG_6542.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1200" data-original-width="1600" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif7U8CR-rNHISHWKc-8se1hi9v_RXhHaPj6n-ZPfXp51InujFYC_87JIxirPDkNDUixEBRVw0os4mU3XorzjIU7HcP8dk0LfI6SHJ7glO2J2qqYYzZV4nqD9rYgJna6ZCnVc8Wsr29hOo/s640/IMG_6542.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Speakers</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://1.bp.blogspot.com/-z9TINkakrBM/WSlNIrfiAdI/AAAAAAAAC_Q/Z65AkoJTlzcU9RtI929aHnNuAmSCXZpwwCLcB/s1600/IMG_6553.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1200" data-original-width="1600" height="480" src="https://1.bp.blogspot.com/-z9TINkakrBM/WSlNIrfiAdI/AAAAAAAAC_Q/Z65AkoJTlzcU9RtI929aHnNuAmSCXZpwwCLcB/s640/IMG_6553.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Speaker's dinner</td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
See you next year at Baku. </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Best Regards</div>
<div class="separator" style="clear: both; text-align: left;">
Mahir M. Quluzade</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215770699999986 49.544368900000045 40.602752699999989 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-83463358966188977592017-05-04T09:57:00.001+04:002017-05-11T17:57:25.557+04:00I'm speaking at OTN EMEA Tour 2017 Baku<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjf7_xC5ZduPk2xjnTPKaPvBNoppCi49LhiVvuaz2FENQJztLt652TD0I-nm5pcr7PsJpEd4tD9sY1WOaYddBM3gMVJmiLR6bvgwdkT1IeU63RyNPZigOZpNEuPS2D1h-h1wC9MKl44eyI/s1600/otnemea_2017-255x300.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjf7_xC5ZduPk2xjnTPKaPvBNoppCi49LhiVvuaz2FENQJztLt652TD0I-nm5pcr7PsJpEd4tD9sY1WOaYddBM3gMVJmiLR6bvgwdkT1IeU63RyNPZigOZpNEuPS2D1h-h1wC9MKl44eyI/s1600/otnemea_2017-255x300.png" /></a></div>
<br />
<br />
Local Oracle User Groups from the <a href="http://otnemea.com/" target="_blank">EMEA</a> region are cooperating for the fourth year in a row to organize a tour of the region. The <a href="http://otnemea.com/" target="_blank">OTN EMEA Tour</a> 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 <b>New Features of Oracle Database 12c Release 2 for DBAs and Developers.</b><br />
<div>
<b><br /></b></div>
<div>
<div>
<div>
<b><br /></b></div>
<div class="separator" style="clear: both; text-align: center;">
<img border="0" height="275" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwra9fcTcQrjd_AsTkgrTbwm8ESHErgIvNMI8ZKAxzcfHmv3GlJf9HnixvMzw7KRAmyUBlrpTVV-SePFAOKc07loObR6WP16DeOYQ94nDOpQm6PRdMFCWsRuhhkptbV0WTwhm7Ynk7r9s/s640/OTN+EMEA+Tour+2017.PNG" width="640" /></div>
<div>
<b><br /></b>
<b><br /></b>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-X83rCimAphM/WRRtmzliBoI/AAAAAAAAC9U/sMRLXrBkUSk4tJp-qK1lqxdhI40DXjhPACLcB/s1600/%2523OTNEMEABaku2017.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="359" src="https://1.bp.blogspot.com/-X83rCimAphM/WRRtmzliBoI/AAAAAAAAC9U/sMRLXrBkUSk4tJp-qK1lqxdhI40DXjhPACLcB/s640/%2523OTNEMEABaku2017.jpg" width="640" /></a></div>
<b><br /></b>
<b><br /></b></div>
<div>
<a href="http://otnemea.com/speakers-2017/" target="_blank">Here is about all speakers of OTN EMEA Tour 2017 </a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
See you at event soon. </div>
<div>
<br /></div>
<div>
Best Regards</div>
<div>
Mahir</div>
<div>
<br /></div>
<div>
</div>
<div>
<br />
<div>
<div>
<br /></div>
<div>
<br /></div>
</div>
</div>
</div>
</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215770699999986 49.544368900000045 40.602752699999989 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-91920780193696638972016-10-11T23:49:00.000+04:002016-10-12T10:25:21.517+04:00OTN Appreciation Day: DBMS_MONITOR<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHqXKOJBSx6G24dISs1LCLUnH41vuI56mx2RtKpqrGRumk2tnM7LgCMp3w1ZTuOiquw_BU2qXYNHifi-gIN4lKO_Ja-z_ihXG0Gdr5i0p32OBhIOlrSjyyGcq66tJZewobrUfUwGSsVbw/s1600/thanksotn.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="111" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHqXKOJBSx6G24dISs1LCLUnH41vuI56mx2RtKpqrGRumk2tnM7LgCMp3w1ZTuOiquw_BU2qXYNHifi-gIN4lKO_Ja-z_ihXG0Gdr5i0p32OBhIOlrSjyyGcq66tJZewobrUfUwGSsVbw/s320/thanksotn.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Today is OTN Appreciation day. In this reason Oracle bloggers share a blog post about himself favorite Oracle feature. This great idea coming from <a href="https://oracle-base.com/blog/" target="_blank">Tim Hall </a>(@oraclebase). I also want share my favorite feature of Oracle Database.<br />
<br />
Here’s my contribution to the <a href="https://oracle-base.com/blog/2016/09/28/otn-appreciation-day/">OTN Appreciation Day</a>.<br />
How to Oracle working? - this question is interesting all of persons which is using Oracle database.<br />
Oracle trace files is very helpful for learn working mechanism of oracle processes.<br />
<br />
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.<br />
<br />
DBMS_MONITOR is very good package for trace database, session, application, module... etc<br />
<br />
You can found your trace files in default folder :<br />
$ORACLE_BASE/diag/rdbms/SID/INSTANCE_NAME/trace<br />
<br />
Trace file is not more readable, you can use TKPROF for generate readable, text based file from trace files (*.trc)<br />
<br />
Read more about Application tracing<br />
<a href="https://docs.oracle.com/database/121/TGSQL/tgsql_trace.htm#TGSQL791" target="_blank">https://docs.oracle.com/database/121/TGSQL/tgsql_trace.htm#TGSQL791</a><br />
<br />
#ThanksOTN<br />
<div>
<br /></div>
<div>
<br /></div>
<div>
Best regards</div>
<div>
Mahir M. Quluzade</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0tag:blogger.com,1999:blog-1565145284195006697.post-37244870814187570882016-09-22T09:39:00.000+04:002016-09-22T14:37:37.560+04:00Oracle Database 12.2 New Features (Part I) - Application Express<div dir="ltr" style="text-align: left;" trbidi="on">
As you know, <a href="https://www.oracle.com/openworld/index.html" target="_blank">Oracle Open World 2016 conferences</a> continue at San Francisco (September 18-22, 2016).<br />
<br />
At keynote Session, Larry Ellison (CTO of Oracle Corporation) annoucemented the Oracle Database Exadata Express Cloud Service on new database version 12.2.<a href="http://docs.oracle.com/cloud/latest/exadataexpress-cloud/index.html" target="_blank"> Here is released cloud documentation</a><br />
<br />
There have very interesting little guide for new features of Oracle Database 12c Release 2.<br />
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) :)<br />
<br />
I want share something about released new feature of Oracle Database 12.2.<br />
<br />
<b>Application Development</b><br />
<b><br />
</b> <br />
<div class="separator" style="clear: both; text-align: center;">
<b></b></div>
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBAnie1k8rOISiCen_Yrm2xmzqX46Vu6l7KhF_49BgIbVugSwcMH1miQT-y7Srmzk0e0wzagRqaF80_RmAl7jtqkcK4WNBqh5B7ClZwsHpBwrgex1XdGDsCbq3QYXWEBYzabZaJmL3yR4/s1600/oracleapex50.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBAnie1k8rOISiCen_Yrm2xmzqX46Vu6l7KhF_49BgIbVugSwcMH1miQT-y7Srmzk0e0wzagRqaF80_RmAl7jtqkcK4WNBqh5B7ClZwsHpBwrgex1XdGDsCbq3QYXWEBYzabZaJmL3yR4/s1600/oracleapex50.png" /></a>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.<br />
<br />
<a href="http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html" target="_blank">Oracle Application Express 5.0.4 </a>is latest version, released on July 12, 2016 and <a href="https://apexea.oracle.com/" target="_blank">Application Express 5.1 Early Adopter 2</a> now available.<br />
<br />
<a href="http://www.oracle.com/webfolder/technetwork/jet/index.html" target="_blank">Oracle JET</a> integrated with Oracle Appplication Express 5.1.<br />
<br />
We can install Oracle Application Express 5.0 to another versions of Oracle Database. Application Express 5.0.2 come with Oracle Database 12.2 default. (4.2 version is default in 12.1.0.2)<br />
<br />
<pre>SQL> select comp_name, version, schema, status from dba_registry;
COMP_NAME VERSION SCHEMA STATUS
---------------------------------------------------------------------------------------
Oracle Database Catalog Views 12.2.0.0.0 SYS VALID
Oracle Database Packages and Types 12.2.0.0.0 SYS VALID
JServer JAVA Virtual Machine 12.2.0.0.0 SYS VALID
Oracle XDK 12.2.0.0.0 SYS VALID
Oracle Database Java Packages 12.2.0.0.0 SYS VALID
OLAP Analytic Workspace 12.2.0.0.0 SYS VALID
Oracle Real Application Clusters 12.2.0.0.0 SYS OPTION OFF
Oracle XML Database 12.2.0.0.0 XDB VALID
Oracle Workspace Manager 12.2.0.0.0 WMSYS VALID
Oracle Text 12.2.0.0.0 CTXSYS VALID
Oracle Multimedia 12.2.0.0.0 ORDSYS VALID
Spatial 12.2.0.0.0 MDSYS VALID
Oracle OLAP API 12.2.0.0.0 OLAPSYS VALID
Oracle Database Vault 12.2.0.0.0 DVSYS VALID
Oracle Label Security 12.2.0.0.0 LBACSYS VALID
<b>Oracle Application Express 5.0.2.00.01 APEX_050000 VALID</b>
16 rows selected.
</pre>
<br />
Oracle using Application Express in Oracle cloud also. So, you can use schema as service in Oracle Cloud, Oracle give this service with Oracle Application Express.<br />
<br />
If you want start cloud development, start from learn Oracle Application Express 5.0.<br />
<br />
<br />
Best Regards<br />
Mahir M. Quluzade<br />
<br /></div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215770699999986 49.544368900000045 40.602752699999989 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-62566489227654143382016-04-30T16:11:00.000+04:002016-09-22T09:40:13.222+04:00TROUG Days 2016 Istanbul<div dir="ltr" style="text-align: left;" trbidi="on">
I attended <a href="http://www.troug.org/haberler/troug-days-istanbul-2016/" target="_blank">TROUG Days 2016 Istanbul</a> which is organized Turkish Oracle Users Group as a speaker. It is very amazing conference. I meet my friends during conference.<br />
<div>
<br /></div>
<div>
I talked about In-Memory & Multitenant features of Oracle Database 12c. </div>
<div>
I want thank to organizers of TROUG Days and attenders. I want share some my photos from conference: </div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHirBKlsdEp0Bib8YjLVkGHU5K0L3rsb1hhqsSrRn973ivmIpyCiGQSN3oaktCiYQ-ZySrwWxD7tB7Q-_PiikwCcrj2RoqEF_Ni61R_4oiKHEK0nC8jYm7FCQbcYaWW7JRWUkLRzwZXfw/s1600/IMG_1731.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHirBKlsdEp0Bib8YjLVkGHU5K0L3rsb1hhqsSrRn973ivmIpyCiGQSN3oaktCiYQ-ZySrwWxD7tB7Q-_PiikwCcrj2RoqEF_Ni61R_4oiKHEK0nC8jYm7FCQbcYaWW7JRWUkLRzwZXfw/s640/IMG_1731.JPG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEix-rXdyEc4aV9wPlzu3rqBUST8jLZL_-19voGN4NObZPPKl7ftNaRtVqYmkL9GzCKk21depSEtJ-xxfszy1tMEl0UBYPPjNRYcHmQEcHyDBakgVRrDoKoXCj7SuBAycLrtoObNQQ91m5M/s1600/IMG_1736.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEix-rXdyEc4aV9wPlzu3rqBUST8jLZL_-19voGN4NObZPPKl7ftNaRtVqYmkL9GzCKk21depSEtJ-xxfszy1tMEl0UBYPPjNRYcHmQEcHyDBakgVRrDoKoXCj7SuBAycLrtoObNQQ91m5M/s400/IMG_1736.JPG" width="400" /></a></div>
<br />
<a name='more'></a><br /><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzfpNhDzj-1BFxvzCxDuwK7MnPNN0vEJf2NZbdoWpzQ0F9KFECbj9kBR5GPzdnseNapo4fVxKaX6Sr4Sg40PmgEyC1q7dwIxxeOAkAIz1tOGea6a9r9ZdVo5HOxqaQ_qArPok47ZvLiak/s1600/IMG_1734.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzfpNhDzj-1BFxvzCxDuwK7MnPNN0vEJf2NZbdoWpzQ0F9KFECbj9kBR5GPzdnseNapo4fVxKaX6Sr4Sg40PmgEyC1q7dwIxxeOAkAIz1tOGea6a9r9ZdVo5HOxqaQ_qArPok47ZvLiak/s400/IMG_1734.JPG" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-MSMtrjVXyVw/VyczBV-dt0I/AAAAAAAACf8/xqPqTHFXg-Iv380mGdSphsAQxb6t60TaQCKgB/s1600/IMG_1701.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://3.bp.blogspot.com/-MSMtrjVXyVw/VyczBV-dt0I/AAAAAAAACf8/xqPqTHFXg-Iv380mGdSphsAQxb6t60TaQCKgB/s400/IMG_1701.JPG" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy96-Fmnr6U26bM0kG9iPe0yBDuVuq3uk20uCgg6WXZU5_Gruj0ywaYirs7Y-2AQzy3Yx5fpz8xu0IyBs78Kvy2x2j9_u9bzYZfNmzNDhOZyB4UmdLAJmLRzNgi_JG8muW9zBjVbqs1b4/s1600/IMG_1696.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy96-Fmnr6U26bM0kG9iPe0yBDuVuq3uk20uCgg6WXZU5_Gruj0ywaYirs7Y-2AQzy3Yx5fpz8xu0IyBs78Kvy2x2j9_u9bzYZfNmzNDhOZyB4UmdLAJmLRzNgi_JG8muW9zBjVbqs1b4/s400/IMG_1696.JPG" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjutxs6u1LhrxSkztMfaZ7DR7LUd1J6sVDMpO-hE-aHxo3SI03iDkc9JlHN1Jgux5caIc12ubVKY2ov459CUTq1CqZOhEEMBd7smY9M71K7nH0lDe5inYZ27R49VVZo1pSef9Aj7imgJzc/s1600/IMG_1702.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjutxs6u1LhrxSkztMfaZ7DR7LUd1J6sVDMpO-hE-aHxo3SI03iDkc9JlHN1Jgux5caIc12ubVKY2ov459CUTq1CqZOhEEMBd7smY9M71K7nH0lDe5inYZ27R49VVZo1pSef9Aj7imgJzc/s400/IMG_1702.JPG" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-2HgU7ys625U/VyczF8q8IUI/AAAAAAAACgE/kKK2dH2fdKsghXJLdv8ItqmRpKs3RkqHgCKgB/s1600/IMG_1743.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://2.bp.blogspot.com/-2HgU7ys625U/VyczF8q8IUI/AAAAAAAACgE/kKK2dH2fdKsghXJLdv8ItqmRpKs3RkqHgCKgB/s400/IMG_1743.JPG" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-Sr0Yp19ttaI/VyczFo_zY-I/AAAAAAAACgE/V9etNiq-Y-Qi5A4g6v5HqslHyeSYhrODQCKgB/s1600/IMG_1747.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://2.bp.blogspot.com/-Sr0Yp19ttaI/VyczFo_zY-I/AAAAAAAACgE/V9etNiq-Y-Qi5A4g6v5HqslHyeSYhrODQCKgB/s400/IMG_1747.JPG" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-OiHbju6tU5HkRHJo9fj1_JCFXyrj7iUpGI12xJjvT_yfxe5LhglWWYt7wAQJOiog30fAXee9-z6counp44Q4gQJjT2LOw4pZHc1l1D93IJXI2WCqbDPmql5ZRhol5wDlJXAbgXh7NQM/s1600/IMG_1791.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-OiHbju6tU5HkRHJo9fj1_JCFXyrj7iUpGI12xJjvT_yfxe5LhglWWYt7wAQJOiog30fAXee9-z6counp44Q4gQJjT2LOw4pZHc1l1D93IJXI2WCqbDPmql5ZRhol5wDlJXAbgXh7NQM/s400/IMG_1791.JPG" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIx_OBUKUf0vlWuUeVLwEgFiAd9LjRw8U1n71oaBt5npSLwHaEr3968o2lzhyphenhyphen11H1mnZ4wfyZlE8AEoVoE53oJitQVR4aOEAQajAUzPPwSeJeYPXP48fZfpJejH5ZE2K9N7qtSQqP95Bc/s1600/IMG_1801.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIx_OBUKUf0vlWuUeVLwEgFiAd9LjRw8U1n71oaBt5npSLwHaEr3968o2lzhyphenhyphen11H1mnZ4wfyZlE8AEoVoE53oJitQVR4aOEAQajAUzPPwSeJeYPXP48fZfpJejH5ZE2K9N7qtSQqP95Bc/s400/IMG_1801.JPG" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-bxZRX4p9oUI/VyczKGcbFzI/AAAAAAAACgE/4pSRtEqT4lMPUwybjgx9andcfEDVkRsBACKgB/s1600/IMG_1826.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://3.bp.blogspot.com/-bxZRX4p9oUI/VyczKGcbFzI/AAAAAAAACgE/4pSRtEqT4lMPUwybjgx9andcfEDVkRsBACKgB/s400/IMG_1826.JPG" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyK_vNBY5ux2rrerKHBintDO3CKgDE8nCTT7vEXZKZr-a_zyVODzktURg-pCyOQkAX3e1TqY0_o7IlCSlP2-pQwSAIEdCXhyphenhyphennQlbOLu-38L0bb93AiiBwebEFCZRl7RX-DCTa81SvReOQ/s1600/IMG_1777.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyK_vNBY5ux2rrerKHBintDO3CKgDE8nCTT7vEXZKZr-a_zyVODzktURg-pCyOQkAX3e1TqY0_o7IlCSlP2-pQwSAIEdCXhyphenhyphennQlbOLu-38L0bb93AiiBwebEFCZRl7RX-DCTa81SvReOQ/s640/IMG_1777.JPG" width="640" /></a></div>
<div>
<br /></div>
<div>
<br />
I used following slides at my session: <br />
<br />
<br />
<div style="text-align: center;">
<iframe allowfullscreen="" frameborder="0" height="485" marginheight="0" marginwidth="0" scrolling="no" src="//www.slideshare.net/slideshow/embed_code/key/DQeZIoCyCnjBuf" style="border-width: 1px; border: 1px solid #ccc; margin-bottom: 5px; max-width: 100%;" width="595"> </iframe> </div>
<div style="margin-bottom: 5px;">
<div style="text-align: center;">
<strong> <a href="https://www.slideshare.net/mahirquluzade/oracle-database-inmememory-multitenant-troug-days16-istanbul" target="_blank" title="Oracle Database In-Mememory & Multitenant - TROUG Days'16 Istanbul">Oracle Database In-Memory & Multitenant - TROUG Days'16 Istanbul</a> </strong> from <strong><a href="https://www.slideshare.net/mahirquluzade" target="_blank">Mahir M. Quluzade</a></strong> </div>
<br />
<br /></div>
See you my friends at next events and conferences.<br />
<br />
Best Regards<br />
Mahir M. Quluzade</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0İstanbul, Turkey41.0082376 28.97835889999998940.6247881 28.332911899999988 41.3916871 29.62380589999999tag:blogger.com,1999:blog-1565145284195006697.post-49657921022297479742016-04-21T15:17:00.001+04:002016-04-21T15:19:37.597+04:00OTN Article: Oracle Database 12c: "Colección automática de estadísticas para cargas masivas"<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://www.oracle.com/technetwork/es/articles" target="_blank">Oracle Technology Network</a> continue publish our article. My next article published OTN Latina in Spanish language.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjQtbwqctEjzHprNYcjiLSZyhj6Cye4I9BprrS1slXR-efC_zGhVhuA_lsd2CXh7FtVrqgxYqe9QEOk2TxMtrR39PZRyOEchGqSPa0xwWCVWweRcfEiFfosU-PZajXu2s74pdKW1V-SQQ/s1600/Article0416-01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="138" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjQtbwqctEjzHprNYcjiLSZyhj6Cye4I9BprrS1slXR-efC_zGhVhuA_lsd2CXh7FtVrqgxYqe9QEOk2TxMtrR39PZRyOEchGqSPa0xwWCVWweRcfEiFfosU-PZajXu2s74pdKW1V-SQQ/s400/Article0416-01.png" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmFZcFvHH9EWdFx2VEQyyskMb2jsm8v4psG-IuvsD7trzoF-XkNoq9YaxiCUUfW31yhp8cFosFHilOb4oBGM4fsrd_3IS_w6T8jtMjIUdUBY4GpDyiS9owoOpK-5_-IJTJu5W4mms9ToY/s1600/Article0416-02.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="188" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmFZcFvHH9EWdFx2VEQyyskMb2jsm8v4psG-IuvsD7trzoF-XkNoq9YaxiCUUfW31yhp8cFosFHilOb4oBGM4fsrd_3IS_w6T8jtMjIUdUBY4GpDyiS9owoOpK-5_-IJTJu5W4mms9ToY/s400/Article0416-02.png" width="400" /></a></div>
<div>
<br /></div>
You can read this article at : OTN Latina<br />
<a href="http://www.oracle.com/technetwork/es/articles/database-performance/coleccion-estadisticas-bulkloads-2995165-esa.html" target="_blank">Oracle Database 12c: "Colección automática de estadísticas para cargas masivas"</a><br />
<div>
<a href="http://www.oracle.com/technetwork/es/articles/database-performance/coleccion-estadisticas-bulkloads-2995165-esa.html">http://www.oracle.com/technetwork/es/articles/database-performance/coleccion-estadisticas-bulkloads-2995165-esa.html</a></div>
<div>
<br /></div>
<br />
You can read this article also in English : <a href="http://otechmag.com/magazine/2015/winter/mahir-m.-quluzade.html">http://otechmag.com/magazine/2015/winter/mahir-m.-quluzade.html</a><br />
<div>
<br /></div>
<div>
<br /></div>
<div>
My special thanks my friends Joel and Sebastian ! </div>
<div>
<br /></div>
<div>
Best Regards</div>
<div>
Mahir M. Quluzade</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215770699999986 49.544368900000045 40.602752699999989 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-9084705473534259922016-03-02T12:13:00.000+04:002016-03-02T12:16:00.083+04:00TROUG Days Istanbul 2016 Agenda is online!<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://www.troug.org/haberler/troug-days-istanbul-2016/" target="_blank">TROUG Days Istanbul 2016</a> Agenda now online, published at <a href="http://www.troug.org/haberler/troug-days-istanbul-2016/">http://www.troug.org/wp-content/uploads/2016/02/Agenda.pdf</a><br />
<br />
I'll speaking at TROUG Days Istanbul 2016, Apr 28th, 14:30 Hall A, ITU Teknokent. <br />My topic is <b>Oracle In-Memory with Multitenant. </b><br />
<div>
<b><br /></b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEin7UJzwUpV_Lk_Cj5B93iXOwr1JnD8hFs-tEw6c3sSpmoMwYwYeipWdOxjK3EnAgAn-_y__PaMaY0TZ7nFqK4mY9W6xHzyxnLIWpL9G0Lhcp6XTomn0U-EgsOqpMEpau4B0BtmhjatjS8/s1600/day1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="364" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEin7UJzwUpV_Lk_Cj5B93iXOwr1JnD8hFs-tEw6c3sSpmoMwYwYeipWdOxjK3EnAgAn-_y__PaMaY0TZ7nFqK4mY9W6xHzyxnLIWpL9G0Lhcp6XTomn0U-EgsOqpMEpau4B0BtmhjatjS8/s640/day1.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-IZQG1pICfFY/VtagIgr6tsI/AAAAAAAACO8/tfiDCJ0ZPe8/s1600/day2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="360" src="https://3.bp.blogspot.com/-IZQG1pICfFY/VtagIgr6tsI/AAAAAAAACO8/tfiDCJ0ZPe8/s640/day2.png" width="640" /></a></div>
<div>
<b><br /></b></div>
<br />
<br />
See you at TROUG Days Istanbul 2016! <br />
<br />
Best Regards <br />
Mahir<br />
<div>
<b><br /></b></div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215770699999986 49.544368900000045 40.602752699999989 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-27329060974283652552016-02-22T15:58:00.003+04:002016-09-22T09:56:40.392+04:00First meeting of AZEROUG in 2016 year! <div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiYRehBnKaZZ9Lur-jhi7pbqZGeZtsaUqMlyTXCIEbQdaOYxJXmLqFAMjIcfdVgIbsd-Mevgwt-2ow-D2w6T4muc9rVK8SWbiXj3tQ4GEmu3dHmmyCuTSXZXBSPmFihetVQI3M1pEhdd4/s1600/azeroug+meeting.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="398" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiYRehBnKaZZ9Lur-jhi7pbqZGeZtsaUqMlyTXCIEbQdaOYxJXmLqFAMjIcfdVgIbsd-Mevgwt-2ow-D2w6T4muc9rVK8SWbiXj3tQ4GEmu3dHmmyCuTSXZXBSPmFihetVQI3M1pEhdd4/s640/azeroug+meeting.jpg" width="640" /></a></div>
<br />
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.<br />
<br />
See you !<br />
<br />
<br />
<b>Update: Feb 27th, 2016</b><br />
<b><br /></b>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-GyhWhZGmlZY/VtPneN37YnI/AAAAAAAACOg/W7YJ5A4OCDw/s1600/IMG_1170.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="640" src="https://2.bp.blogspot.com/-GyhWhZGmlZY/VtPneN37YnI/AAAAAAAACOg/W7YJ5A4OCDw/s640/IMG_1170.JPG" width="480" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-5VPlmkO6ZaI/VtPneLlFiYI/AAAAAAAACOg/NizM9GG1Qr4/s1600/IMG_1172.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://2.bp.blogspot.com/-5VPlmkO6ZaI/VtPneLlFiYI/AAAAAAAACOg/NizM9GG1Qr4/s320/IMG_1172.JPG" width="240" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIHtH6PiSapcw5xwEf61bYm_RuZH6pNjwd0CMcASbuveJLmzXGVbau9qtCWoBd0T4xWqek9IMeW26AxOkc7EDUM3rx1EIZZzO0jn1APamyoxX5-lpU2WqeSgJj3DUowVrv049srmHiesI/s1600/IMG_1182.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIHtH6PiSapcw5xwEf61bYm_RuZH6pNjwd0CMcASbuveJLmzXGVbau9qtCWoBd0T4xWqek9IMeW26AxOkc7EDUM3rx1EIZZzO0jn1APamyoxX5-lpU2WqeSgJj3DUowVrv049srmHiesI/s320/IMG_1182.JPG" width="240" /></a></div>
<br />
<a name='more'></a><br /><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEga8fim36et9QaC2TYX45HxV0ZnRqOx2gVavOYP2dwmkAgbqCXWw5HeKcWkI97wgGqpSXN_sISvKKq6NOCQxlAEjp0T6Xq71iI0fG73F-PEQ94APdyptItDYu1yHeo6e7kQ60Wyt9MnnN0/s1600/IMG_1185.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEga8fim36et9QaC2TYX45HxV0ZnRqOx2gVavOYP2dwmkAgbqCXWw5HeKcWkI97wgGqpSXN_sISvKKq6NOCQxlAEjp0T6Xq71iI0fG73F-PEQ94APdyptItDYu1yHeo6e7kQ60Wyt9MnnN0/s320/IMG_1185.JPG" width="240" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-HpwKEa80qdE/VtPnp_Cwr-I/AAAAAAAACOo/6YjuPNKXW8M/s1600/IMG_1192.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://1.bp.blogspot.com/-HpwKEa80qdE/VtPnp_Cwr-I/AAAAAAAACOo/6YjuPNKXW8M/s320/IMG_1192.JPG" width="240" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkj3jiCSa0dox5rUxEpWoHiHE9cRaFCyP4O2c8V6R666XyjCWD_q6uM47MgIk0r_RaKLs49BupOr7_6EayjXUakLiOm_zvjoaWtd30v5ABbsfT6uGZsvt3ZUt5fKkS4VcCj8EOYn_pP7Q/s1600/IMG_1193.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkj3jiCSa0dox5rUxEpWoHiHE9cRaFCyP4O2c8V6R666XyjCWD_q6uM47MgIk0r_RaKLs49BupOr7_6EayjXUakLiOm_zvjoaWtd30v5ABbsfT6uGZsvt3ZUt5fKkS4VcCj8EOYn_pP7Q/s640/IMG_1193.JPG" width="480" /></a></div>
<b><br /></b>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Best Regards<br />
Mahir </div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215770699999986 49.544368900000045 40.602752699999989 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-78627667123032178532016-01-01T23:30:00.000+04:002016-01-05T16:59:34.181+04:00OTech Magazine Winter 2015 Released <div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://www.otechmag.com/2015/otech-magazine-winter-2015/" target="_blank">OTech Magazine issue Winter 2015</a> is 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.<br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3IAv6jnb-GY7C-UorIJokM-oQjdYTEOPJQQFzAMD8MNbt2AhDe8Bo6dM2sF61VcV5fwFp1zxeH6yoel-8IFkadfOZvdZr9gNe_smPU0Iwf-mMdZ06Lb2E-k6h1u5IwWbzyEEdG9xQAvo/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="361" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3IAv6jnb-GY7C-UorIJokM-oQjdYTEOPJQQFzAMD8MNbt2AhDe8Bo6dM2sF61VcV5fwFp1zxeH6yoel-8IFkadfOZvdZr9gNe_smPU0Iwf-mMdZ06Lb2E-k6h1u5IwWbzyEEdG9xQAvo/s640/1.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<br /></div>
<div>
<br />
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. <br />
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkQcxEuaGij2Vfte_8ERt7jk-rvzPOeALczQzN-nuNUdDlDRPW0gy0wzTfjDTbxuBLN3p7DZcFMjUqiWoIZ1rCCpehpQGX84vQJwKRzv3aj1L4v004_q7xiNyDauDVhZFOSRf-bUjjibE/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="608" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkQcxEuaGij2Vfte_8ERt7jk-rvzPOeALczQzN-nuNUdDlDRPW0gy0wzTfjDTbxuBLN3p7DZcFMjUqiWoIZ1rCCpehpQGX84vQJwKRzv3aj1L4v004_q7xiNyDauDVhZFOSRf-bUjjibE/s640/2.png" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
You can read my article from: <a href="http://otechmag.com/magazine/2015/winter/mahir-m.-quluzade.html">http://otechmag.com/magazine/2015/winter/mahir-m.-quluzade.html</a><br />
<br />
My special thanks to my friend <b>Douwe Pieter van den Bos </b>(owner of OTech Magazine) for all efforts.<br />
<div>
<br />
<div>
Best Regards</div>
<div>
Mahir M. Quluzade<br />
<div>
<br /></div>
<div>
<br /></div>
</div>
</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215770699999986 49.544368900000045 40.602752699999989 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-80171767891127503782015-09-09T09:04:00.001+05:002016-05-02T16:05:51.059+04:00OTN Article: Oracle Database 11g: “Client Failover” en “Standby Databases” (in Spanish Language)<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://www.oracle.com/technetwork/es/index.html">Oracle Technology Network Latina</a> started publish our new article series about Oracle Database 11g: Client Failover with Standby Database<br />
<br />
In Spanish language:<a href="http://www.oracle.com/technetwork/es/articles/database-performance/client-failover-standby-database-2660858-esa.html" target="_blank"> http://www.oracle.com/technetwork/es/articles/database-performance/client-failover-standby-database-2660858-esa.html</a><br />
<div>
<br />
In Portuguese Language: <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/clientfailover-em-standby-databases-3002075-ptb.html">http://www.oracle.com/technetwork/pt/articles/database-performance/clientfailover-em-standby-databases-3002075-ptb.html</a><br />
<br />
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7fAhIjqmZlsjhA5gqLWamy9xyWVPxqK55Yr9Zz-adAItaYd-4yHcfv9gNRIoDWcg49VS15gKGiCBESGWh1GN7lQdkBkpaNZ00tMZTHkJt6rz9UaGSVVzgEhbhZCGx-KQhmwglwM4gspI/s1600/Article3500.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="143" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7fAhIjqmZlsjhA5gqLWamy9xyWVPxqK55Yr9Zz-adAItaYd-4yHcfv9gNRIoDWcg49VS15gKGiCBESGWh1GN7lQdkBkpaNZ00tMZTHkJt6rz9UaGSVVzgEhbhZCGx-KQhmwglwM4gspI/s400/Article3500.png" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWU05P1TPZEVvm8sO-3xpNd9xDawoVJ6wdHBYlz9VQEuKT8vssXmu9X34oyx_I0cPQVs1ECqknNHasXvShCOh0OJz8ui3-kxq2YVwDe0Zv1mLNpzDWVsN6hRal2Pnsm3iz4QpPaZNUYNw/s1600/Article3501.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWU05P1TPZEVvm8sO-3xpNd9xDawoVJ6wdHBYlz9VQEuKT8vssXmu9X34oyx_I0cPQVs1ECqknNHasXvShCOh0OJz8ui3-kxq2YVwDe0Zv1mLNpzDWVsN6hRal2Pnsm3iz4QpPaZNUYNw/s400/Article3501.png" width="400" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br />
It is my first article published on OTN Latina after awarded Oracle ACE. </div>
<div>
My special thanks to my friend Oracle ACED Joel Perez (Venezuela) for all supports. </div>
<div>
<br />
Also you can watch video tutorial in this topic:<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="360" src="https://www.youtube.com/embed/VvYoz9trVnI?rel=0" width="640"></iframe><br /></div>
<div>
<br /></div>
<div>
Best Regards</div>
<div>
Mahir M. Quluzade</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215772699999988 49.544368900000045 40.602750699999987 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-86828209396766212042015-08-11T11:26:00.000+05:002015-08-11T11:28:47.596+05:00OTN Article: Oracle Database 12c In-Memory (Part I, II - Spanish / Portuguese) <div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: left;">
<a href="http://www.oracle.com/technetwork/es/index.html">Oracle Technology Network Latina</a> started publish our new article series about Oracle Database In-Memory. This articles is first about In-Memory in OTN Latina articles.</div>
<br />
First and Second parts of Oracle Database In-Memory article series published in 2 language (Spanish/Portuguese) same time. <br />
<br />
In Spanish Language<br />
<br />
Part I: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-in-memory-2595521-esa.html">http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-in-memory-2595521-esa.html</a><br />
Part II: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-in-memory-part2-2595866-esa.html">http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-in-memory-part2-2595866-esa.html</a><br />
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig7OazfJ01WyHzLzfAOY9h3Uf0J8veo_Uf5SB7H42GDNNY-MBck1l16cenO_NBh8P2huGeRT29BzOrXQNW3SHZgzwD6cD42l8r_dvJv6m0BJUhrppdeGjMb529Q_F6jkpFFVKoz2am3Eo/s1600/Article2301.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="196" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig7OazfJ01WyHzLzfAOY9h3Uf0J8veo_Uf5SB7H42GDNNY-MBck1l16cenO_NBh8P2huGeRT29BzOrXQNW3SHZgzwD6cD42l8r_dvJv6m0BJUhrppdeGjMb529Q_F6jkpFFVKoz2am3Eo/s400/Article2301.png" width="400" /></a><br />
<br />
<br />
In Portuguese Language<br />
<br />
Part I; <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-database-12c-in-memory-2595527-ptb.html">http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-database-12c-in-memory-2595527-ptb.html</a><br />
Part II: <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-database-in-memory-part2-2595874-ptb.html">http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-database-in-memory-part2-2595874-ptb.html</a><br />
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhIEwplDVDjS66eHyFHOOztTUVqJqvaqzxVVlrz_BMvnN6XgXIUcoIzgbsJbOA9obrJ9jKDlC_Rkzbia1J8F_dbNeaRPzmLSsEUxQFc53M3rmZ4sY_AXosw2cer_uRM3vM5joMSRy-Alk/s1600/Article2302.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="203" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhIEwplDVDjS66eHyFHOOztTUVqJqvaqzxVVlrz_BMvnN6XgXIUcoIzgbsJbOA9obrJ9jKDlC_Rkzbia1J8F_dbNeaRPzmLSsEUxQFc53M3rmZ4sY_AXosw2cer_uRM3vM5joMSRy-Alk/s400/Article2302.png" width="400" /></a><br />
<br />
<br />
My special thanks to Joel Perez (Venezuela), Flavio Soares (Brazil) and Sebastián D'Alessandro (Argentina). <br />
<br />
Regards<br />
Mahir M. Quluzade</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215772699999988 49.544368900000045 40.602750699999987 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-11412180461669216422015-08-04T18:17:00.001+05:002015-08-17T12:45:16.650+05:00Oracle Database 12c: Statistics created as the data was loaded <div dir="ltr" style="text-align: left;" trbidi="on">
As you know, Oracle Magazine July/Aug 2015 issue released. You can free subscribe to Oracle Magazine digital edition and you can read <a href="http://www.oraclemagazine-digital.com/oraclemagazine/july_august_2015#pg2" target="_blank">here</a> or you can read technical articles <a href="http://www.oracle.com/technetwork/oramag/magazine/current-issue/index.html" target="_blank">here</a>.<br />
<br />
I subscribed Oracle Magazine, in current issue have very interesting articles.<br />
<br />
One of interesting article of Oracle Expert Tomas Kyte (as known AskTom) with title: <a href="http://www.oracle.com/technetwork/issue-archive/2015/15-jul/o45asktom-2606896.html" target="_blank">On Learning from Mistakes</a><br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-DTKZYCD1yes/VcCsfMY5koI/AAAAAAAACBY/8Pp-6w2IqLU/s1600/AskTomJulAug2015.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="313" src="http://3.bp.blogspot.com/-DTKZYCD1yes/VcCsfMY5koI/AAAAAAAACBY/8Pp-6w2IqLU/s400/AskTomJulAug2015.png" width="400" /></a></div>
<div>
<br /></div>
<div>
In 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. </div>
<div>
<br />
Tom wrote: <br />
<br />
<i> The fact that the NOW column of the query against USER_TABLES is the same as the LAST_ANALYZED column shows that statistics were created as the data was loaded—this is a new feature of Oracle Database 12c. Since Oracle Database 10g, the database has been computing statistics automatically for indexes when you create or rebuild them. With Oracle Database 12c, the database does the same for tables. Further, as you can see in the example in Listing 1, there are basic statistics on the columns in the table as well.</i><br />
<br />
I want share my test environments outputs with you:<br />
<br />
<br />
<pre>[oracle@oel62-ora12c2 Desktop]$ export ORACLE_SID=prmcdb
[oracle@oel62-ora12c2 Desktop]$ sqlplus "/ as sysdba"
SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 4 17:32:00 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
<a name='more'></a>
SQL> select name,cdb from v$database;
NAME CDB
--------- ---
PRMCDB YES
SQL> select name, open_mode from v$pdbs
2 ;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PRMPDB01 MOUNTED
PRMPDB02 READ WRITE
PRMPDB03 READ WRITE
SQL> conn mahir/mahir@prmpdb02
Connected.
SQL> select table_name, to_char(last_analyzed,'dd.mm.yyyy hh24:mi:ss') as last_analyzed from user_tables;
no rows selected
SQL> select index_name, to_char(last_analyzed,'dd.mm.yyyy hh24:mi:ss') as last_analyzed from user_indexes;
no rows selected
</pre>
<br />
Not any table or index created. I will try create a table with index and check last analyzed column in user_tables and user_indexes tables. <br />
<br />
<pre>SQL> create table t (n number, v varchar2(100));
Table created.
SQL> insert into t select level, 'Num :'||level from dual connect by level<1e6;
999999 rows created.
SQL> commit;
Commit complete.
SQL> select table_name, to_char(last_analyzed,'dd.mm.yyyy hh24:mi:ss') as last_analyzed, num_rows from user_tables;
TABLE_NAME LAST_ANALYZED NUM_ROWS
------------------------ ------------------- ----------
T
SQL> select index_name, to_char(last_analyzed,'dd.mm.yyyy hh24:mi:ss') as last_analyzed from user_indexes;
no rows selected
SQL> alter table t add primary key (n);
Table altered.
SQL> select index_name, to_char(last_analyzed,'dd.mm.yyyy hh24:mi:ss') as last_analyzed from user_indexes;
INDEX_NAME LAST_ANALYZED
------------------------ -------------------
<b>SYS_C009994 04.08.2015 17:45:27</b>
SQL> insert into t select n + 1e6, 'Num:'||to_char(n+1e6) from t;
999999 rows created.
SQL> commit;
Commit complete.
SQL> alter index SYS_C009994 rebuild;
Index altered.
SQL> select index_name, to_char(last_analyzed,'dd.mm.yyyy hh24:mi:ss') as last_analyzed from user_indexes;
INDEX_NAME LAST_ANALYZED
----------------------- -------------------
<b>SYS_C009994 04.08.2015 17:50:10</b>
</pre>
<br />
Load a table <br />
<br />
<pre>SQL> select table_name, to_char(last_analyzed,'dd.mm.yyyy hh24:mi:ss') as last_analyzed, num_rows from user_tables;
TABLE_NAME LAST_ANALYZED NUM_ROWS
------------------------ ------------------- ----------
T
<b>SQL> create table T1 as select * from t;</b>
Table created.
SQL> select table_name, to_char(last_analyzed,'dd.mm.yyyy hh24:mi:ss') as last_analyzed, num_rows from user_tables;
TABLE_NAME LAST_ANALYZED NUM_ROWS
------------------------ ------------------- ----------
T
<b>T1 04.08.2015 17:52:11 1999998</b>
SQL> create index idx_t1n on t1(n);
Index created.
SQL> select index_name, to_char(last_analyzed,'dd.mm.yyyy hh24:mi:ss') as last_analyzed from user_indexes;
INDEX_NAME LAST_ANALYZED
------------------------ -------------------
SYS_C009994 04.08.2015 17:50:10
IDX_T1N 04.08.2015 17:54:37
</pre>
<br />
<br />
<b>Conclusion </b><br />
<br />
Gathering table statistics automatically as the table data was loaded in Oracle Database 12c.<br />
<div>
<br />
<br />
Regards<br />
Mahir M. Quluzade<br />
<br />
<br />
<br /></div>
</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215772699999988 49.544368900000045 40.602750699999987 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-81878716311605831862015-07-28T15:53:00.003+05:002015-07-29T17:27:38.944+05:00Database Schema as a Service - Oracle Cloud<div dir="ltr" style="text-align: left;" trbidi="on">
Cloud computing is known for many things: cost effectiveness, flexibility, scalability.<br />
<br />
<div style="text-align: left;">
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.</div>
<div style="text-align: left;">
Oracle Cloud Provide Database schema Service as: </div>
<div style="text-align: left;">
<ul>
<li><b><i>1 Schema on Oracle Database 11g</i></b></li>
</ul>
<div>
I don't know, can we request on Oracle Database 12c Release 1. But I think in the future can provide on 12c version </div>
<ul>
<li><b><i>Choice of 5, 20, and 50 GB database storage (1GB for trial account)</i> </b></li>
</ul>
<div>
<div>
I subscribed to Oracle Database Cloud Service. </div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicA0TVahpeyn796ePCUzN-hnIfhZRqOndtUfq676bZ4vdgOx9ZHbLMHqorBPvx3wjSb4fnm4_klvJL5u_Kw2DuWRfYJliyyCJL75U2L6qWQUIBgLq8LYb05eJIsvpFAetG-WUWIW367X4/s1600/Cloud0.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="397" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicA0TVahpeyn796ePCUzN-hnIfhZRqOndtUfq676bZ4vdgOx9ZHbLMHqorBPvx3wjSb4fnm4_klvJL5u_Kw2DuWRfYJliyyCJL75U2L6qWQUIBgLq8LYb05eJIsvpFAetG-WUWIW367X4/s400/Cloud0.png" width="400" /></a></div>
<div>
<br /></div>
<div>
After completed my order, my Oracle Database Cloud Service - S20 activated</div>
</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQjPNr-Tjc16exuHQKsnTr74juVE8dA9uRXAfJRRVV3F5Oa6caTz87_UBXGoE7uFav3-YHmarTkqqr9EhtJDrS6TnwvOa5n6H1nxR13f7INTIuwE-v-XnCiikCoSj8ENM1Qw2p8gqX4Uw/s1600/Cloud1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="361" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQjPNr-Tjc16exuHQKsnTr74juVE8dA9uRXAfJRRVV3F5Oa6caTz87_UBXGoE7uFav3-YHmarTkqqr9EhtJDrS6TnwvOa5n6H1nxR13f7INTIuwE-v-XnCiikCoSj8ENM1Qw2p8gqX4Uw/s640/Cloud1.png" width="640" /></a></div>
<div>
<br /></div>
<div>
<b><br /></b></div>
<ul>
<li><b><i>Includes Oracle Application Express (APEX), version 4.2.6, a highly productive browser based application development framework for creating responsive applications with SQL and PL/SQL </i></b></li>
</ul>
<ul>
<li><b><i>Data access using RESTful Web Services </i></b></li>
</ul>
<div>
<br />
I'm using Oracle APEX since 2003 year (<i>HTMLDB2 - </i><i>first name of APEX</i><i>),</i> it is my favorite rapid Database Development tool included into Oracle Database. You can use RESTFul Web Services after 4.2 version of Oracle APEX. </div>
<div>
<br />
<br />
<a name='more'></a><br /><br />
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
1. You must connect cloud service, using "My Service URL"</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-l6XanBH9Ugs/VbdYke26MQI/AAAAAAAACAQ/YXJobOjFxyE/s1600/Cloud2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="http://3.bp.blogspot.com/-l6XanBH9Ugs/VbdYke26MQI/AAAAAAAACAQ/YXJobOjFxyE/s400/Cloud2.png" width="400" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
2. Open service Console </div>
<div>
<br /></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-Ic_J2rF7rpE/VbdYkYB8ciI/AAAAAAAACAY/wVhNat1_haM/s1600/Cloud3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="188" src="http://1.bp.blogspot.com/-Ic_J2rF7rpE/VbdYkYB8ciI/AAAAAAAACAY/wVhNat1_haM/s640/Cloud3.png" width="640" /></a></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6iLnTiBXaEmESdKkRtM119fMPuCqFkPynCeqmBbExUiF_pnszRaUC4KRvuYgBwdYoPtqKwkWUc67gG7wuLS9WMjioctFvFZcIHaALHNlTZNUd_iu417vuDu-kaoX7Rjhk3jTPGLbbDOI/s1600/Cloud4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="307" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6iLnTiBXaEmESdKkRtM119fMPuCqFkPynCeqmBbExUiF_pnszRaUC4KRvuYgBwdYoPtqKwkWUc67gG7wuLS9WMjioctFvFZcIHaALHNlTZNUd_iu417vuDu-kaoX7Rjhk3jTPGLbbDOI/s640/Cloud4.png" width="640" /></a></div>
<div>
<br /></div>
<ul>
<li><i><b>No SQL*Net access </b></i></li>
</ul>
<div>
You cannot connect Database Cloud Service via SQL*Plus or other tools, which is using SQL*Net. But You can connect Cloud Database Schema with SQL Developer. </div>
<div>
<br /></div>
<div>
1. Create new connection on Cloud Connection </div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-JblyyLxFsJ4/VbdbHMKyYKI/AAAAAAAACAs/VsJ5Bff2wpA/s1600/Cloud6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="360" src="http://2.bp.blogspot.com/-JblyyLxFsJ4/VbdbHMKyYKI/AAAAAAAACAs/VsJ5Bff2wpA/s640/Cloud6.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4QoH90wBQhMVaQqEHQCXF8ng1tVwMPWe2lehdAPICkdxykSo5DhyNOoRvwEVRvAa3X0KYy0Y24zXad6KkOQMtWACeCiWSioDIMGpPoMMKDHfKHyKJS2Y-UJLsRrlZRgW0ngFPjNTpeU0/s1600/Cloud7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="382" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4QoH90wBQhMVaQqEHQCXF8ng1tVwMPWe2lehdAPICkdxykSo5DhyNOoRvwEVRvAa3X0KYy0Y24zXad6KkOQMtWACeCiWSioDIMGpPoMMKDHfKHyKJS2Y-UJLsRrlZRgW0ngFPjNTpeU0/s400/Cloud7.png" width="400" /></a></div>
<div>
<br /></div>
<div>
2. You can create any types objects in this schema now. </div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-J5B4v2LzlwI/VbdbtSIm_DI/AAAAAAAACA8/ZG_55Q1LNik/s1600/Cloud8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="227" src="http://4.bp.blogspot.com/-J5B4v2LzlwI/VbdbtSIm_DI/AAAAAAAACA8/ZG_55Q1LNik/s400/Cloud8.png" width="400" /></a></div>
<div>
<br />
You can load your data with SQL Developer to Cloud Database. Please check following tutorial.<br />
<a href="http://data%20loading%20and%20the%20oracle%20database%20cloud%20service/" target="_blank">Data Loading and the Oracle Database Cloud Service</a><br />
<br />
Note: you can use SQL Workshop in Oracle APEX, but I think SQL Developer very easy for developers. Oracle Database Cloud Service fully managed by Oracle - no DBA necessary. </div>
<div>
<br /></div>
<ul>
<li><a href="https://myaccount.cloud.oracle.com/mycloud/faces/trialsignup.jspx?serviceType=APEX">30 day Free Trial available!</a></li>
</ul>
<div>
<br />
Related post: <a href="https://blogs.oracle.com/dbaas/entry/connecting_to_a_database_cloud" target="_blank">Connecting to a Database Cloud Service with SQL Developer and SSH</a><br />
<br />
Regards</div>
<div>
Mahir M. Quluzade</div>
</div>
<div>
<br /></div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215772699999988 49.544368900000045 40.602750699999987 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-47786288454230550272015-06-29T11:17:00.000+05:002015-06-29T11:18:26.157+05:00OTech Magazine Summer 2015 Issue #8 Released!<div dir="ltr" style="text-align: left;" trbidi="on">
Independent Oracle Technology Magazine <a href="http://www.otechmag.com/2015/otech-magazine-summer-2015/">OTech Magazine</a> Summer 2015 Issue Released. Second part of my Oracle Database In-Memory article series published in this issue.<br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-SfBZxvvpQhE/VZDHcM_XXNI/AAAAAAAAB9s/1R2HIeEvOog/s1600/OtechMagSummer2015-01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="390" src="http://2.bp.blogspot.com/-SfBZxvvpQhE/VZDHcM_XXNI/AAAAAAAAB9s/1R2HIeEvOog/s400/OtechMagSummer2015-01.png" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh25vlfVkMtM0Eta1LzIMgoVjo6fELWmdM_FDIxSUxHA3XXCuZB2nZJqqQ9DH03CpkGPbfSBAoVKnZlotXxLHPEU_LWKQdU3yPBr3ffZ4o3Yl177x43IwNSqImo8T8-S7DlgJ2_ng3rUz4/s1600/OtechMagSummer2015-02.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh25vlfVkMtM0Eta1LzIMgoVjo6fELWmdM_FDIxSUxHA3XXCuZB2nZJqqQ9DH03CpkGPbfSBAoVKnZlotXxLHPEU_LWKQdU3yPBr3ffZ4o3Yl177x43IwNSqImo8T8-S7DlgJ2_ng3rUz4/s400/OtechMagSummer2015-02.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
You can read my article <b><a href="http://otechmag.com/magazine/2015/summer/mahir-m.-quluzade.html" target="_blank">here</a></b> </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
I want thank to all author for all efforts. My special thanks to Douwe!</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Regards</div>
<div class="separator" style="clear: both; text-align: left;">
Mahir M. Quluzade</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div>
<br /></div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215772699999988 49.544368900000045 40.602750699999987 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-67484935256048652532015-05-27T11:33:00.004+05:002015-05-27T11:45:59.659+05:00Oracle Database 12c - Active Duplication with RMAN (in Spanish Language)<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: left;">
<a href="http://www.oracle.com/technetwork/pt/index.html">Oracle Technology Network - OTN Latina</a> published our "Pull-Based Active Duplication with RMAN" article series this month in Spanish Language. This article series covers new option of duplication with RMAN on Oracle Database 12c Release 1 (12.1.0.1) in 11 parts.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoYpXU57v2cOZ5eGOP6FvpvRfBjj1R1HHJsbWq4McfdtzEpmyCZjRFAc-HllEkY0tIPmp1P0gmvRM9e5lQdAf2OdZrMeE8GAA7y1YvyoRFmhCO_h-B-lD7BKyQQnOxY08Piw73gBz_RqE/s1600/Article2001.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoYpXU57v2cOZ5eGOP6FvpvRfBjj1R1HHJsbWq4McfdtzEpmyCZjRFAc-HllEkY0tIPmp1P0gmvRM9e5lQdAf2OdZrMeE8GAA7y1YvyoRFmhCO_h-B-lD7BKyQQnOxY08Piw73gBz_RqE/s400/Article2001.png" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuKJtG3ZpfoXVn8JY7jZ96MDUzF8FbRWcv1mJ3xvBRk_gZ-vj9DgQvKVZ9_c70l1n4mdCh2x8bgCCjW0WprIMz2yvuc_fzGGaYpdMPb8R28iibnA3smTfqRHduovq1WpiyqddoBy6eMdA/s1600/Article2002.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuKJtG3ZpfoXVn8JY7jZ96MDUzF8FbRWcv1mJ3xvBRk_gZ-vj9DgQvKVZ9_c70l1n4mdCh2x8bgCCjW0WprIMz2yvuc_fzGGaYpdMPb8R28iibnA3smTfqRHduovq1WpiyqddoBy6eMdA/s400/Article2002.png" width="400" /></a></div>
<br />
First part of article series described "how to duplicate database" and other parts showed different cases of CDB and PDBs duplication.You can read articles <a href="http://www.oracle.com/technetwork/es/articles/database-performance/active-duplication-rman-2549972-esa.html" target="_blank">here</a><br />
<span style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px;"></span><a href="https://www.blogger.com/goog_2090196496" style="background-color: white; color: #e90400; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px; text-decoration: none;"><br /></a><span style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px;"></span><a href="https://www.blogger.com/goog_2090196496" style="background-color: white; color: #e90400; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px; text-decoration: none;"><br /></a><span style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px;"></span><img src="https://s2.googleusercontent.com/s2/favicons?domain=www.oracle.com&alt=p" style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px;" /><span style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px;"> </span><a href="http://www.oracle.com/technetwork/es/articles/database-performance/active-duplication-rman-2549972-esa.html" style="background-color: white; color: #e90400; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px; text-decoration: none;" target="_blank">Oracle Database 12c: Active Duplication con RMAN + 10 casos practicos</a><br />
<ul style="text-align: left;">
<li>Caso 1: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/duplicando-cdb-backup-sets-2549975-esa.html">Duplicando CDB - Usando Backup Sets para ejecutar una "Active Database Duplication"</a></li>
<li>Caso 2: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/duplicando-cdb-compressed-backup-2549976-esa.html">Duplicando CDB - Usando Backup Sets comprimidos para ejecutar una "Active Database Duplication" </a></li>
<li>Caso 3: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/duplicando-cdb-creando-backup-sets-2549977-esa.html">Duplicando CDB - Creando Backup Sets en paralelo durante una "Active Database Duplication"</a></li>
<li>Caso 4: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/push-based-active-db-duplication-2549979-esa.html">Duplicando CDB - "Push-Based Active Database Duplication" de una CDB</a></li>
<li>Caso 5: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/duplicando-una-pluggable-database-2549980-esa.html">Duplicando PDBs - Duplication de una sola "Pluggable Database"</a></li>
<li>Caso 6: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/duplicando-dos-pluggable-databases-2549981-esa.html">Duplicando PDBs - Duplicación de dos "Pluggable Databases"</a></li>
<li>Caso 7: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/duplicando-dos-pdb-omitiendo-una-2549982-esa.html">Duplicando PDBs - Duplicación de dos "Pluggable Databases" omitiendo una PDB </a></li>
<li>Caso 8: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/duplicando-tablespaces-de-una-pdb-2549983-esa.html">Duplicando PDBs - Duplicación los tablespaces de una PDB </a></li>
<li>Caso 9: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/duplicando-distintos-pdbs-2549984-esa.html">Duplicando PDBs – Duplicación al mismo tiempo de una PDB y un tablespaces en otra PDB</a></li>
<li>Caso10: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/duplicando-cdb-omitiendo-un-pdb-2549985-esa.html">Duplicando PDBs - Duplicación de una CDB omitiendo tablespaces de una PDB</a></li>
</ul>
<div>
<br /></div>
<div>
You can read this article series also in English and Portuguese Languages from following links:</div>
<div>
<br />
<br style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px;" />
<img src="https://s2.googleusercontent.com/s2/favicons?domain=www.oracle.com&alt=p" style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px;" /><span style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px;"> </span><a href="http://goo.gl/wkJuJc" style="background-color: white; color: #e90400; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px; text-decoration: none;" target="_blank">Oracle Database 12c: Active Duplication with RMAN (in English Language) </a><br />
<img src="https://s2.googleusercontent.com/s2/favicons?domain=www.oracle.com&alt=p" style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px;" /><span style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px;"> </span><a href="http://www.mahir-quluzade.com/2015/03/oracle-database-12c-active-duplication.html" style="background-color: white; color: #e90400; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13.8599996566772px; line-height: 19.4039993286133px; text-decoration: none;" target="_blank">Oracle Database 12c: Active Duplication with RMAN (in Portuguese Language) </a><br />
<br />
<br />
Regards<br />
Mahir M. Quluzade</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215772699999988 49.544368900000045 40.602750699999987 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-59687979804976168262015-03-29T11:48:00.003+05:002015-05-27T11:35:38.229+05:00Oracle Database 12c - Active Duplication with RMAN (in Portuguese Language)<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://www.oracle.com/technetwork/pt/index.html" target="_blank">Oracle Technology Network - OTN Latina</a> published our new article series this month in Portuguese Language.<br />
<br />
This article series covers new option of duplication: Pull-Based Active Duplication with RMAN on Oracle Database 12c Release 1 (12.1.0.1) in 11 parts.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwXiTDUddARa8IINFHrc0LO50xC5lISXj7-SUo6YKYNkJnGLBGW9LIwM2Yjudbe4TzEWKGSgJ0CHguAkAsJhJwwTRAQE0P_LBgnZZG5WJ9w2sMWDfIFh1YLeUHCsbYHQafUSUT5CeBnJs/s1600/Article1301.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwXiTDUddARa8IINFHrc0LO50xC5lISXj7-SUo6YKYNkJnGLBGW9LIwM2Yjudbe4TzEWKGSgJ0CHguAkAsJhJwwTRAQE0P_LBgnZZG5WJ9w2sMWDfIFh1YLeUHCsbYHQafUSUT5CeBnJs/s1600/Article1301.png" width="400" /></a></div>
<br />
<br />
<br />
First part of article series described "how to duplicate database" and other parts showed different cases of CDB and PDBs duplication.You can read articles <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/duplicate-modo-ativo-oracle-rman-2489691-ptb.html" target="_blank">here</a><br />
<a href="https://www.blogger.com/goog_2090196496"><br /></a>
<a href="https://www.blogger.com/goog_2090196496"><br /></a>
<a href="https://www.blogger.com/goog_2090196496"><br /></a>
<img src="https://s2.googleusercontent.com/s2/favicons?domain=www.oracle.com&alt=p" /> <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/duplicate-modo-ativo-oracle-rman-2489691-ptb.html" target="_blank">Oracle Database 12c: Duplicate em modo ativo com RMAN</a><br />
<ul>
<li><span style="font-family: inherit; font-size: small;"><a href="http://www.oracle.com/technetwork/pt/articles/database-performance/duplicando-cdb-backup-sets-rman-2489696-ptb.html" target="_blank">Caso 1: Duplicando CDB - Usando Backup Sets para executar um Active Database Duplication (Parte II)</a> </span></li>
<li><a href="http://www.oracle.com/technetwork/pt/articles/database-performance/caso2-duplicando-cdb-backup-sets-2489697-ptb.html" target="_blank"><span style="font-family: inherit; font-size: small;">Caso 2: Duplicando CDB - Usando Backup Sets comprimidos para executar um Active Database Duplication (Parte III)</span></a></li>
<li><a href="http://www.oracle.com/technetwork/pt/articles/database-performance/caso3-duplicando-cdb-criando-backup-2489698-ptb.html" target="_blank"><span style="font-family: inherit; font-size: small;">Caso 3: Duplicando CDB - Criando Backup Sets em paralelo durante o Active Database Duplication (Parte IV)</span></a></li>
<li><a href="http://www.oracle.com/technetwork/pt/articles/database-performance/caso4-duplicando-cdb-push-based-2489700-ptb.html" target="_blank"><span style="font-family: inherit; font-size: small;">Caso 4: Duplicando CDB - Push-Based Active Database Duplication para o CDB (Parte V)</span></a></li>
<li><a href="http://www.oracle.com/technetwork/pt/articles/database-performance/caso5-duplicando-pdbs-pull-based-2489701-ptb.html" target="_blank"><span style="font-family: inherit; font-size: small;">Caso 5: Duplicando PDBs - Duplicando database ativo com método Pull-Based de apenas um Pluggable Database (Parte VI)</span></a></li>
<li><a href="http://www.oracle.com/technetwork/pt/articles/database-performance/caso6-duplicando-dois-pdbs-2489704-ptb.html" target="_blank"><span style="font-family: inherit; font-size: small;">Caso 6: Duplicando PDBs - Duplicando database ativo com método Pull-Based de dois Pluggable Databases (Parte VII)</span></a></li>
<li><a href="http://www.oracle.com/technetwork/pt/articles/database-performance/caso7-duplicando-pdbs-com-um-skip-2489707-ptb.html" target="_blank"><span style="font-family: inherit; font-size: small;">Caso 7: Duplicando PDBs - Duplicando database ativo com método Pull-Based de dois PDBs com skip de um PDB (Parte VIII)</span></a></li>
<li><a href="http://www.oracle.com/technetwork/pt/articles/database-performance/caso8-duplicando-tablespaces-pdbs-2489708-ptb.html" target="_blank"><span style="font-family: inherit; font-size: small;">Caso 8: Duplicando PDBs – Duplicando os tablespaces de um PDBs (Parte IX)</span></a></li>
<li><a href="http://www.oracle.com/technetwork/pt/articles/database-performance/caso9-duplicando-pdba-tablespace-2489710-ptb.html" target="_blank"><span style="font-family: inherit; font-size: small;">Caso 9: Duplicando PDBs – Duplicando de um PDBA e um tablespace em outro PDB (Parte X)</span></a></li>
<li><a href="http://www.oracle.com/technetwork/pt/articles/database-performance/caso10-duplicando-cdb-skip-pdb-2489711-ptb.html" target="_blank"><span style="font-family: inherit; font-size: small;">Caso 10: Duplicando PDBs –Duplicando o CDB com SKIP tablespaces de um PDB (Parte XI)</span></a></li>
<ul style="-webkit-font-smoothing: antialiased; background-color: white; font-family: arial, helvetica, sans-serif; font-size: 12px; list-style: none; margin: 0px 0px 12px; padding: 0px;"></ul>
</ul>
<a href="https://www.blogger.com/goog_2090196496"></a><br />
You can read this article series in English Language from following files:<br />
<br />
<img src="https://s2.googleusercontent.com/s2/favicons?domain=www.oracle.com&alt=p" /> <a href="http://goo.gl/wkJuJc" target="_blank">Oracle Database 12c: Active Duplication with RMAN (in English Language) </a><br />
<br />
<br />
Regards<br />
Mahir M. Quluzade<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.409261699999988 49.86709240000004740.215772699999988 49.544368900000045 40.602750699999987 50.189815900000049tag:blogger.com,1999:blog-1565145284195006697.post-21535431810486254512014-12-23T23:31:00.000+04:002014-12-23T23:34:11.670+04:00OTech Magazine Winter 2014 Issue Released!<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://www.otechmag.com/2014/otech-magazine-winter-2014-2/" target="_blank">OTech Magazine Winter 2014 Issue</a> is a more than one hundred page independent Oracle technology magazine especially designed for the holidays. First part of my Oracle Database In-Memory article series also published in this issue.<br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipkBLGXhucjViwKWaZ0clrEyEQOBuhay6szG2vSe0zPMCEgOkAeAwU2jbgQEH9Bjb2DTEiNvr988Nh5bMlvxTV41_u6TyztXfACSAuPsYFv9NhrZR1mQg4K76HJ5YSjyF48f4bi1t66VA/s1600/OTech+Magazine+-+Winter+2014.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipkBLGXhucjViwKWaZ0clrEyEQOBuhay6szG2vSe0zPMCEgOkAeAwU2jbgQEH9Bjb2DTEiNvr988Nh5bMlvxTV41_u6TyztXfACSAuPsYFv9NhrZR1mQg4K76HJ5YSjyF48f4bi1t66VA/s1600/OTech+Magazine+-+Winter+2014.png" height="266" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp6GIN1tYxV9o-jjdhTx29ugOnC-8OW9hNkv2-nmcxOdME5SJsSeNiumUmGL3P7ewSrqDtuRNKIocvRIUS0VAroe2X3kij21o8MqNG6-25VjH1SDIyaWavbsJrJcr8FMn0eT5r5MzOdec/s1600/Mahir+-Oracle+Database+In-Memory.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp6GIN1tYxV9o-jjdhTx29ugOnC-8OW9hNkv2-nmcxOdME5SJsSeNiumUmGL3P7ewSrqDtuRNKIocvRIUS0VAroe2X3kij21o8MqNG6-25VjH1SDIyaWavbsJrJcr8FMn0eT5r5MzOdec/s1600/Mahir+-Oracle+Database+In-Memory.png" height="232" width="400" /></a></div>
<div>
<br /></div>
<a href="http://otechmag.com/magazine/2014/winter2/OTech%20Magazine%20-%20Winter%202014.pdf" target="_blank">You can download the Winter 2014 issue of OTech Magazine here</a><br />
<div>
<br /></div>
<div>
My special thanks to Oracle ACED Douwe Pieter van den Bos for all efforts. </div>
<div>
<br /></div>
<div>
Best Regards</div>
<div>
Mahir M. Quluzade</div>
<div>
<br /></div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Ankara, Turkey39.92077 32.85410999999999139.53098 32.208662999999994 40.310559999999995 33.499556999999989tag:blogger.com,1999:blog-1565145284195006697.post-3546208496844541322014-12-23T23:06:00.000+04:002014-12-23T23:17:17.196+04:00OTN Article Series: Oracle Data Guard 12c - Redo Gap Resolutions<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: left;">
<a href="http://www.oracle.com/technetwork/es/articles">OTN - Oracle Technology Network Latina America</a> published our next technical articles series. This article series cover Redo Gap Resolutions in Oracle Data Guard 12c entitled in Portuguese language as Oracle Database 12c – Resolução de Redo Gap (Part <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/resolucao-de-redo-gap-2354062-ptb.html" target="_blank">I</a>, <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/resolucao-redo-gap-part2-2396294-ptb.html" target="_blank">II</a>) written by<a href="http://ocmacedjoelperez.blogspot.com/"> Joel Perez (Oracle ACED)</a>, Mahir M. Quluzade (OCE).</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeK1PTvwMhU7eFS9TmhwL2zFic6Dqzux9KzygAuyPYaSF3zw47YZ5YisIb74nH48zvZfeB-oMk6C1ZjPHcEL863vhI2afMIBWI768YsNY22rpQBPkpgxL8dpVU5uScrLTMg5APK63E8Og/s1600/Article130.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeK1PTvwMhU7eFS9TmhwL2zFic6Dqzux9KzygAuyPYaSF3zw47YZ5YisIb74nH48zvZfeB-oMk6C1ZjPHcEL863vhI2afMIBWI768YsNY22rpQBPkpgxL8dpVU5uScrLTMg5APK63E8Og/s1600/Article130.png" height="256" width="400" /></a></div>
<div>
<br /></div>
This article series consists of two parts. You can read articles from following links in Portuguese Language. <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMJGOzO7xZ8zw1yb13NcXDzWZH3dxYz9vt1Sd1lOGWYwMk722uGDTa3c41AU14-fHE4dmeqK7I_IQRNEoCAvK6QrbK8ZV0fNB7hAxer4iD0ovqlOg0KhPXuQmdZkl81rns_jeAP-MiQfU/s1600/Article131.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMJGOzO7xZ8zw1yb13NcXDzWZH3dxYz9vt1Sd1lOGWYwMk722uGDTa3c41AU14-fHE4dmeqK7I_IQRNEoCAvK6QrbK8ZV0fNB7hAxer4iD0ovqlOg0KhPXuQmdZkl81rns_jeAP-MiQfU/s1600/Article131.png" height="150" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-RmrMyCh-PNA/VJm8ucvrU4I/AAAAAAAAB1o/-Tn00N8Z-og/s1600/Article132.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-RmrMyCh-PNA/VJm8ucvrU4I/AAAAAAAAB1o/-Tn00N8Z-og/s1600/Article132.png" height="157" width="320" /></a></div>
<br />
<br />
<img src="https://s2.googleusercontent.com/s2/favicons?domain=www.oracle.com&alt=p" /> <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/resolucao-de-redo-gap-2354062-ptb.html" target="_blank">Oracle Database 12c – Resolução de Redo Gap (Part I)</a><br />
<img src="https://s2.googleusercontent.com/s2/favicons?domain=www.oracle.com&alt=p" /> <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/resolucao-redo-gap-part2-2396294-ptb.html" target="_blank">Oracle Database 12c – Resolução de Redo Gap (Part II)</a> <br />
<br />
<br />
Thanks to my friend Joel for all effort, and OTN Latina.<br />
<br />
<br />
<br />
Regards<br />
Mahir M. Quluzade</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Ankara, Turkey39.92077 32.85410999999999139.53098 32.208662999999994 40.310559999999995 33.499556999999989tag:blogger.com,1999:blog-1565145284195006697.post-62072020414487429332014-10-09T10:00:00.003+05:002014-10-09T10:34:11.092+05:00OTN Articles: Oracle Database 12c: “Nuevas Características para Desarrolladores”<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://www.oracle.com/technetwork/es/articles">OTN - Oracle Technology Network Latina America</a> published our next technical articles series. This article series cover new features of Oracle Database 12c for developers, entitled in Spanish language as <a href="http://www.oracle.com/technetwork/es/articles/database-performance/nuevas-caracteristicas-12c-parte3-2330966-esa.html">Oracle Database 12c: “Nuevas Características para Desarrolladores”</a> written by<a href="http://ocmacedjoelperez.blogspot.com/" target="_blank"> Joel Perez (Oracle ACED)</a>, Mahir M. Quluzade (OCE).<br />
<div>
<br /></div>
<div>
This article series consists of three parts.<br />
<div>
<br /></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-wuodQt60mTg/VDYQmtv1v3I/AAAAAAAAByk/lGFmvwzgo1A/s1600/Article110.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-wuodQt60mTg/VDYQmtv1v3I/AAAAAAAAByk/lGFmvwzgo1A/s1600/Article110.png" height="233" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<br /></div>
<div>
You can see very useful examples for every new feature in this article series. So, <b><a href="http://www.oracle.com/technetwork/es/articles/database-performance/nuevas-caracteristicas-12c-parte1-2312384-esa.html" target="_blank">Part I</a></b> of this article series, covers "Invisible Columns", "Identity Columns", "Default Values Using Sequences", <b><a href="http://www.oracle.com/technetwork/es/articles/database-performance/nuevas-caracteristicas-12c-parte2-2321781-esa.html" target="_blank">Part II</a> </b>covers "Extended Data Types","Multiple Index on same Columns", "Online DDLs", "Limitations of Row Set". <b><a href="http://www.oracle.com/technetwork/es/articles/database-performance/nuevas-caracteristicas-12c-parte3-2330966-esa.html" target="_blank">Part III</a> </b>covers "Online Moving Partitions", " New types of compression for tables", "Granted Roles of a Program Units","Enhanced in Clause 'WITH'". </div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-gotSF902ng4/VDYQzJPbTbI/AAAAAAAABys/qAvbfdA6Olg/s1600/Article112.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-gotSF902ng4/VDYQzJPbTbI/AAAAAAAABys/qAvbfdA6Olg/s1600/Article112.png" height="190" width="400" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
You can read articles from following links in Spanish Language. </div>
<div>
<br /></div>
<div>
<img src="https://s2.googleusercontent.com/s2/favicons?domain=www.oracle.com&alt=p" style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; line-height: 19.4039993286133px;" /><span style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; line-height: 19.4039993286133px;"> </span><a href="http://www.oracle.com/technetwork/es/articles/database-performance/nuevas-caracteristicas-12c-parte1-2312384-esa.html" style="background-color: white; color: #e90400; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; line-height: 19.4039993286133px; text-decoration: none;" target="_blank">Oracle Database 12c: “Nuevas Características para Desarrolladores” ( Parte I )</a></div>
<div>
<img src="https://s2.googleusercontent.com/s2/favicons?domain=www.oracle.com&alt=p" style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; line-height: 19.4039993286133px;" /><span style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; line-height: 19.4039993286133px;"> </span><a href="http://www.oracle.com/technetwork/es/articles/database-performance/nuevas-caracteristicas-12c-parte2-2321781-esa.html" style="background-color: white; color: #e90400; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; line-height: 19.4039993286133px; text-decoration: none;" target="_blank">Oracle Database 12c: “Nuevas Características para Desarrolladores” ( Parte II)</a></div>
<div>
<img src="https://s2.googleusercontent.com/s2/favicons?domain=www.oracle.com&alt=p" style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; line-height: 19.4039993286133px;" /><span style="background-color: white; color: #737373; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; line-height: 19.4039993286133px;"> </span><a href="http://www.oracle.com/technetwork/es/articles/database-performance/nuevas-caracteristicas-12c-parte3-2330966-esa.html" style="background-color: white; color: #e90400; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; line-height: 19.4039993286133px; text-decoration: none;" target="_blank">Oracle Database 12c: “Nuevas Características para Desarrolladores” ( Parte III)</a></div>
<div>
</div>
<div>
<br />
Thanks to my friend Joel for all effort, and OTN Latina.<br />
<br />
<br /></div>
<div>
Regards</div>
<div>
Mahir M. Quluzade<br />
<br />
<br /></div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.3936363 49.8630521999999740.2001473 49.540328699999968 40.5871253 50.185775699999972tag:blogger.com,1999:blog-1565145284195006697.post-28136871671093267392014-08-28T09:27:00.000+05:002014-09-10T11:15:36.973+05:00OTN Article: Oracle Database 12c: Que sucede en un CDB cuando uno de los PDB obtiene un problema? (in Spanish Language)<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://www.oracle.com/technetwork/es/articles" target="_blank">OTN - Oracle Technology Network Latina America</a> continue publish our articles. Our 8th technical article published on OTN in <b>Spanish </b>Language at 28th August. This article entitled : <a href="http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-cdb-problem-pdb-2279196-esa.html">Oracle Database 12c: ¿Que sucede en un CDB cuando uno de los PDB obtiene un problema?</a> written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Bruno Nuñez (OCE).<br />
<br />
It is a link of article: <a href="http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-cdb-problem-pdb-2279196-esa.html">http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-cdb-problem-pdb-2279196-esa.html</a><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-MCYj57mw0dc/U_6vWOP1wnI/AAAAAAAABwY/1UD1DXnI9OY/s1600/Article8-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-MCYj57mw0dc/U_6vWOP1wnI/AAAAAAAABwY/1UD1DXnI9OY/s1600/Article8-1.png" height="160" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-RKM7fCcUfZ0/U_6vVw2VgfI/AAAAAAAABwU/io8fcEHSOI0/s1600/Article8-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-RKM7fCcUfZ0/U_6vVw2VgfI/AAAAAAAABwU/io8fcEHSOI0/s1600/Article8-3.png" height="117" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-DdR6MJlUyXE/U_6vVnysqLI/AAAAAAAABwQ/x0vPaCgc9SA/s1600/Article8-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-DdR6MJlUyXE/U_6vVnysqLI/AAAAAAAABwQ/x0vPaCgc9SA/s1600/Article8-2.png" height="143" width="320" /></a></div>
<br />
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
Thanks to my friends, Joel and Bruno, for their all efforts and thanks to OTN. </div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
Regards</div>
<div class="separator" style="clear: both;">
Mahir M. Quluzade</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.4349504 49.86762320000002540.2414614 49.544899700000023 40.6284394 50.190346700000028tag:blogger.com,1999:blog-1565145284195006697.post-83208348402413001302014-08-21T09:56:00.004+05:002014-09-10T11:15:20.413+05:00OTN Article : Oracle Database 12c, O que acontece em um CDB quando um PDB tem ser recuperado (in Portuguese Language)<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<a href="http://www.oracle.com/technetwork/pt/articles/database-performance/cdb-quando-pdb-tem-ser-recuperado-2270042-ptb.html" target="_blank">OTN - Oracle Technology Network Latina America</a> continue publish our articles. Our 7th technical article published on OTN <b>in Portuguese Language</b> at 20th August. This article entitled : <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/cdb-quando-pdb-tem-ser-recuperado-2270042-ptb.html">Oracle Database 12c, O que acontece em um CDB quando um PDB tem ser recuperado</a> written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Rodrigo Mufalini (Oracle ACE) .<br />
<br />
<br />
It is a link of article: <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/cdb-quando-pdb-tem-ser-recuperado-2270042-ptb.html">http://www.oracle.com/technetwork/pt/articles/database-performance/cdb-quando-pdb-tem-ser-recuperado-2270042-ptb.html</a><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-Ufr2tGF_Aek/U_V6PjoRW4I/AAAAAAAABvI/_d4QkXYkrjI/s1600/Article7-0.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-Ufr2tGF_Aek/U_V6PjoRW4I/AAAAAAAABvI/_d4QkXYkrjI/s1600/Article7-0.png" height="164" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-kHbxzR1n0Wk/U_V6PY4TWDI/AAAAAAAABvE/zzu8l7qRD_c/s1600/Article7-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-kHbxzR1n0Wk/U_V6PY4TWDI/AAAAAAAABvE/zzu8l7qRD_c/s1600/Article7-1.png" height="107" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRuIIMaASfbslkcUrWLJ3x6JoJpS2APgXiTvT-sfPm-1ahx2QWh72NO8NdiJkjMO6p0ReuG5vagq18AVP1wk8X8diZknqf78_Az0e9oOM_LEtIBkBPPSah1FQVb2eInKzeB7QihMWK0bY/s1600/Article7-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRuIIMaASfbslkcUrWLJ3x6JoJpS2APgXiTvT-sfPm-1ahx2QWh72NO8NdiJkjMO6p0ReuG5vagq18AVP1wk8X8diZknqf78_Az0e9oOM_LEtIBkBPPSah1FQVb2eInKzeB7QihMWK0bY/s1600/Article7-2.png" height="142" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Thanks to my friends, Joel and Rodrigo, for their all efforts and thanks to OTN. </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Regards</div>
<div class="separator" style="clear: both; text-align: left;">
Mahir M. Quluzade</div>
</div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.4349504 49.86762320000002540.2414614 49.544899700000023 40.6284394 50.190346700000028tag:blogger.com,1999:blog-1565145284195006697.post-58425474057806707522014-08-20T10:09:00.000+05:002014-08-22T12:43:09.571+05:00OTech Magazine Issue #4: Summer 2014 Published<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<a href="http://www.otechmag.com/" target="_blank">OTech Magazine </a>- The independent magazine for Oracle professionals. Yesterday <a href="http://otechmag.com/magazine/2014/summer/OTech%20Magazine%20-%20Summer%202014.pdf" target="_blank">fourth issue</a> of the OTech Magazine published.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-EOHNh0_s9GA/U_QhYC3Ge2I/AAAAAAAABu0/yw6gHKLv7s8/s1600/OTechMag-Summer2014-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-EOHNh0_s9GA/U_QhYC3Ge2I/AAAAAAAABu0/yw6gHKLv7s8/s1600/OTechMag-Summer2014-1.png" height="282" width="400" /></a></div>
<br />
<br />
In this issue also included my article: <b>Oracle Database 12c: Cross Platform Transport non-CDB to PDB using RMAN Backup Sets</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj02kEVVYl5K84Ww2E4_-PjUYCmAxb4qSwxMpVTL2jJAT0ZV8ZndPNGPhSryzF0zIAQua5t86OXTcrhoh4u0VM43CDopZlRbh9OeSMLIO2E58wulg11JgZOyq4oTVhc6b84WZlzymZaOxs/s1600/OTechMag-Summer2014-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj02kEVVYl5K84Ww2E4_-PjUYCmAxb4qSwxMpVTL2jJAT0ZV8ZndPNGPhSryzF0zIAQua5t86OXTcrhoh4u0VM43CDopZlRbh9OeSMLIO2E58wulg11JgZOyq4oTVhc6b84WZlzymZaOxs/s1600/OTechMag-Summer2014-2.png" height="225" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtmSIJVkgZgGtRwMJFGKsoUAkUq26Tq5TCGLSwr-SvmUphsYIe2CZtpQ7_2-sQmOK6lfKkC232OUiO4s4shiFC6sX8ge_LCpTeaS9FlBBS_cydtQsZVHa8fGROWNa0T1RbbYr-L_Fo-0w/s1600/OTechMag-Summer2014-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtmSIJVkgZgGtRwMJFGKsoUAkUq26Tq5TCGLSwr-SvmUphsYIe2CZtpQ7_2-sQmOK6lfKkC232OUiO4s4shiFC6sX8ge_LCpTeaS9FlBBS_cydtQsZVHa8fGROWNa0T1RbbYr-L_Fo-0w/s1600/OTechMag-Summer2014-3.png" height="188" width="320" /></a></div>
<br />
<br />
You can download online <a href="http://otechmag.com/magazine/2014/summer/OTech%20Magazine%20-%20Summer%202014.pdf" target="_blank">OTech Magazine #4 Isssue - Summer 2014</a><br />
<div style="text-align: left;">
<b><br /></b></div>
<div style="text-align: left;">
<b>Summary of article</b></div>
<br />
We can create a PDB using upgraded database (non-CDB) and can be adopt the 12.1 non-CDB into a CDB as a PDB. This article covers steps for cross-platform data transport of non-CDB to other platform and adopt the transported non-CDB into a CDB as a PDB. If 12.1 non-CDB and CDB running on same platform, then easily plug-in the non-CDB into a CDB as a PDB so, there is no need for any conversion of platform on non-CDB. If platforms are different, then we need cross-platform data transport of non-CDB with RMAN. Prior to Oracle Database 12c (12.1) RMAN only used image copies for cross-platform data transport. After 12.1 RMAN can be use backup sets for cross-platform data transport of databases. So RMAN allows following methods to cross-platform transport of databases with Oracle Database 12c (12.1):<br />
<br />
<ul style="text-align: left;">
<li>Transport database using image copies</li>
<li>Transport database using backup sets</li>
</ul>
<br />
In this article I used method <i>Transport database using RMAN backup sets. </i>You can read more about Cross - Platform Database Transport from my articles on OTN (<a href="http://www.oracle.com/technetwork/pt/articles/database-performance/data-guard12c-cross-platform-2098313-ptb.html" target="_blank">Part 1</a>, <a href="http://www.oracle.com/technetwork/pt/articles/database-performance/data-guard12c-cross-platform-parte2-2100280-ptb.html" target="_blank">Part 2</a> - in Portugalese Language)<br />
<br />
<i><b>Note: </b>Oracle Database 12c Release 1 (12.1.0.1) used for this article. </i><br />
<br />
<b>Updates related this article:</b><br />
<br />
If you are using Oracle Database 12c Release 1 (12.1.0.2) then you can use new feature of multitenant - PDB Remote Clone. So,the new release of Oracle Multitenant fully supports remote full and snapshot clones over a database link. A non-multitenant container database (CDB) can be adopted as a pluggable database (PDB) simply by cloning it over a database link. You can read about this new feature in <a href="http://www.mahir-quluzade.com/2014/07/oracle-multitenant-12c-pdb-clone-partII.html" target="_blank">here</a><br />
<br />
<br />
You can download online <a href="http://otechmag.com/magazine/2014/summer/OTech%20Magazine%20-%20Summer%202014.pdf" target="_blank">OTech Magazine #4 Isssue - Summer 2014</a><br />
<br />
My special thanks to organizer of OTech Magazine <b>Douwe Pieter van den Bos </b>for all efforts. <br />
<br />
Regards<br />
Mahir M. Quluzade.<br />
<br />
<br /></div>
Mahir M. Quluzadehttp://www.blogger.com/profile/18093992492396019441noreply@blogger.com0Baku, Azerbaijan40.4349504 49.86762320000002540.2414614 49.544899700000023 40.6284394 50.190346700000028