Posts

Showing posts with the label Oracle Database 12c

I'm speaking at OTN EMEA Tour 2017 Baku

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

OTN Appreciation Day: DBMS_MONITOR

Image
Today is OTN Appreciation day. In this reason Oracle bloggers share a blog post about himself favorite Oracle feature. This great idea coming from Tim Hall (@oraclebase). I also want share my favorite feature of Oracle Database. Here’s my contribution to the OTN Appreciation Day . How to Oracle working? - this question is interesting all of persons which is using Oracle database. Oracle trace files is very helpful for learn working mechanism of oracle processes. Each server and background process writes to a trace file. When a process detects an internal error, it writes information about the error to its trace file. DBMS_MONITOR is very good package for trace database, session, application, module... etc You can found your trace files in default folder : $ORACLE_BASE/diag/rdbms/SID/INSTANCE_NAME/trace Trace file is not more readable, you can use TKPROF for generate readable, text based file from trace files (*.trc) Read more about Application tracing https://docs....

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

Image
As you know, Oracle Open World 2016 conferences continue at San Francisco (September 18-22, 2016). At keynote Session, Larry Ellison (CTO of Oracle Corporation) annoucemented the Oracle Database Exadata Express Cloud Service on new database version 12.2. Here is released cloud documentation There have very interesting little guide for new features of Oracle Database 12c Release 2. Why littel , because it is not all features of Oracle Database 12c Release 2, have more interesting features will come with new version, I know. (I attended #OOW15) :) I want share something about released new feature of Oracle Database 12.2. Application Development Oracle Application Express is (first name is HTMLDB 2.0, I used it at 2005 year) very interesting tool for developers. This tool for helping to create applications very rapidly. Oracle Application Express 5.0.4 is latest version, released on July 12, 2016 and Application Express 5.1 Early Adopter 2  now available. O...

TROUG Days 2016 Istanbul

Image
I attended TROUG Days 2016 Istanbul which is organized Turkish Oracle Users Group as a speaker. It is very amazing conference. I meet my friends during conference. I talked about In-Memory & Multitenant features of Oracle Database 12c.  I want thank to organizers of  TROUG Days and attenders. I want share some my photos from conference: 

OTN Article: Oracle Database 12c: "Colección automática de estadísticas para cargas masivas"

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

TROUG Days Istanbul 2016 Agenda is online!

Image
TROUG Days Istanbul 2016  Agenda now online, published at  http://www.troug.org/wp-content/uploads/2016/02/Agenda.pdf I'll speaking at TROUG Days Istanbul 2016, Apr 28th, 14:30 Hall A, ITU Teknokent. My topic is Oracle In-Memory with Multitenant. See you at TROUG Days Istanbul 2016! Best Regards Mahir

First meeting of AZEROUG in 2016 year!

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

OTech Magazine Winter 2015 Released

Image
OTech Magazine issue Winter 2015 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. My "Automatic Gather Statistics for Bulk Loads" article also published in this issue. Automatically gathering statistics enhanced within Oracle Database 12c Release 1. My article covers this feature of Oracle Database 12c Release 1 with examples of automatically collect statistics of objects when bulk load operations. You can read my article from: http://otechmag.com/magazine/2015/winter/mahir-m.-quluzade.html My special thanks to my friend Douwe Pieter van den Bos (owner of OTech Magazine) for all efforts. Best Regards Mahir M. Quluzade

OTN Article: Oracle Database 11g: “Client Failover” en “Standby Databases” (in Spanish Language)

Image
Oracle Technology Network Latina started publish our new article series about Oracle Database 11g: Client Failover with  Standby Database In Spanish  language:  http://www.oracle.com/technetwork/es/articles/database-performance/client-failover-standby-database-2660858-esa.html In Portuguese Language:  http://www.oracle.com/technetwork/pt/articles/database-performance/clientfailover-em-standby-databases-3002075-ptb.html It is my first article published on OTN Latina after awarded Oracle ACE.  My special thanks to my friend Oracle ACED Joel Perez (Venezuela) for all supports.  Also you can watch video tutorial in this topic: Best Regards Mahir M. Quluzade

OTN Article: Oracle Database 12c In-Memory (Part I, II - Spanish / Portuguese)

Image
Oracle Technology Network Latina started publish our new article series about Oracle Database In-Memory. This articles is first about In-Memory in OTN Latina articles. First and Second parts of Oracle Database In-Memory article series published in 2 language (Spanish/Portuguese) same time. In Spanish Language Part I:  http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-in-memory-2595521-esa.html Part II:  http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-in-memory-part2-2595866-esa.html In Portuguese Language Part I;  http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-database-12c-in-memory-2595527-ptb.html Part II:  http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-database-in-memory-part2-2595874-ptb.html My special thanks to Joel Perez (Venezuela), Flavio Soares (Brazil) and Sebastián D'Alessandro (Argentina). Regards Mahir...

Oracle Database 12c: Statistics created as the data was loaded

Image
As you know, Oracle Magazine July/Aug 2015 issue released. You can free subscribe to Oracle Magazine digital edition and you can read here or you can read technical  articles here . I subscribed Oracle Magazine, in current issue have very interesting articles. One of interesting article of Oracle Expert Tomas Kyte (as known AskTom) with title: On Learning from Mistakes 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.    Tom wrote: 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 do...

Database Schema as a Service - Oracle Cloud

Image
Cloud computing is known for many things: cost effectiveness, flexibility, scalability. Oracle Cloud provides several Oracle Database offerings. Choose between a single schema based service, or a virtual machine with a fully configured running Oracle Database Instance, or Exadata Service with all the database features, options, and workloads. Oracle Cloud Provide Database schema Service as:  1 Schema on Oracle Database 11g I don't know, can we request on Oracle Database 12c Release 1. But I think in the future can provide on 12c version   Choice of 5, 20, and 50 GB database storage (1GB for trial account)   I subscribed to Oracle Database Cloud Service.  After completed my order, my Oracle Database Cloud Service - S20 activated 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  Data access u...

OTech Magazine Summer 2015 Issue #8 Released!

Image
Independent Oracle Technology Magazine OTech Magazine Summer 2015 Issue Released. Second part of my Oracle Database In-Memory article series published in this issue. You can read my article here   I want thank to all author for all efforts. My special thanks to Douwe! Regards Mahir M. Quluzade

Oracle Database 12c - Active Duplication with RMAN (in Spanish Language)

Image
Oracle Technology Network - OTN Latina  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. 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 here   Oracle Database 12c: Active Duplication con RMAN + 10 casos practicos Caso 1: Duplicando CDB - Usando Backup Sets para ejecutar una "Active Database Duplication" Caso 2: Duplicando CDB - Usando Backup Sets comprimidos para ejecutar una "Active Database Duplication"  Caso 3: Duplicando CDB - Creando Backup Sets en paralelo durante una "Active Database Duplication" Caso 4: Duplicando CDB - "Push-Based Active Database Duplication" de una CDB Caso 5: Duplicando PDBs - Duplication de una sola ...

Oracle Database 12c - Active Duplication with RMAN (in Portuguese Language)

Image
Oracle Technology Network - OTN Latina  published our new article series this month in Portuguese Language. 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. 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 here   Oracle Database 12c: Duplicate em modo ativo com RMAN Caso 1: Duplicando CDB - Usando Backup Sets para executar um Active Database Duplication (Parte II)   Caso 2: Duplicando CDB - Usando Backup Sets comprimidos para executar um Active Database Duplication (Parte III) Caso 3: Duplicando CDB - Criando Backup Sets em paralelo durante o Active Database Duplication (Parte IV) Caso 4: Duplicando CDB - Push-Based Active Database Duplication para o CDB (Parte V) Caso 5: Duplicando PDBs - Duplicando database ativo com método Pull-Based de apenas...

OTech Magazine Winter 2014 Issue Released!

Image
OTech Magazine Winter 2014 Issue 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. You can download the Winter 2014 issue of OTech Magazine here My special thanks to Oracle ACED Douwe Pieter van den Bos for all efforts.  Best Regards Mahir M. Quluzade

OTN Article Series: Oracle Data Guard 12c - Redo Gap Resolutions

Image
OTN - Oracle Technology Network Latina America 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 I , II )  written by Joel Perez (Oracle ACED) , Mahir M. Quluzade (OCE). This article series consists of two parts. You can read articles from following links in Portuguese Language.   Oracle Database 12c – Resolução de Redo Gap (Part I)   Oracle Database 12c – Resolução de Redo Gap (Part II)   Thanks to my friend Joel for all effort, and OTN Latina. Regards Mahir M. Quluzade

OTN Articles: Oracle Database 12c: “Nuevas Características para Desarrolladores”

Image
OTN - Oracle Technology Network Latina America published our next technical articles series. This article series cover new features of Oracle Database 12c for developers, entitled in Spanish language as Oracle Database 12c: “Nuevas Características para Desarrolladores”  written by Joel Perez (Oracle ACED) , Mahir M. Quluzade (OCE). This article series consists of three parts. You can see very useful examples for every new feature in this article series. So, Part I of this article series, covers "Invisible Columns", "Identity Columns", "Default Values Using Sequences",   Part II   covers "Extended Data Types","Multiple Index on same Columns", "Online DDLs", "Limitations of Row Set". Part III covers  "Online Moving Partitions", " New types of compression for tables", "Granted Roles of a Program Units","Enhanced in Clause 'WITH'".  You  can r...

OTN Article: Oracle Database 12c: Que sucede en un CDB cuando uno de los PDB obtiene un problema? (in Spanish Language)

Image
OTN - Oracle Technology Network Latina America  continue publish our articles. Our 8th technical article published on OTN in Spanish Language at 28th August. This article entitled :  Oracle Database 12c: ¿Que sucede en un CDB cuando uno de los PDB obtiene un problema? written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Bruno Nuñez (OCE). It is a link of article:  http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-cdb-problem-pdb-2279196-esa.html Thanks to my friends, Joel and Bruno, for their all efforts and thanks to OTN.  Regards Mahir M. Quluzade

OTN Article : Oracle Database 12c, O que acontece em um CDB quando um PDB tem ser recuperado (in Portuguese Language)

Image
OTN - Oracle Technology Network Latina America continue publish our articles. Our 7th technical article published on OTN in Portuguese Language  at 20th August. This article entitled : Oracle Database 12c, O que acontece em um CDB quando um PDB tem ser recuperado  written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Rodrigo Mufalini (Oracle ACE) . It is a link of article: http://www.oracle.com/technetwork/pt/articles/database-performance/cdb-quando-pdb-tem-ser-recuperado-2270042-ptb.html Thanks to my friends, Joel and Rodrigo, for their all efforts and thanks to OTN.  Regards Mahir M. Quluzade