2016/10/11

OTN Appreciation Day: DBMS_MONITOR


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

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

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

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

You can found your trace files in default folder :
$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.com/database/121/TGSQL/tgsql_trace.htm#TGSQL791

#ThanksOTN


Best regards
Mahir M. Quluzade

2016/09/22

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

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

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

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

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

Application Development



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

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

Oracle JET integrated with Oracle Appplication Express 5.1.

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)

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
Oracle Application Express              5.0.2.00.01   APEX_050000 VALID


16 rows selected.

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.

If you want start cloud development, start from learn Oracle Application Express 5.0.


Best Regards
Mahir M. Quluzade

2016/04/30

TROUG Days 2016 Istanbul

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

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



2016/03/02

TROUG Days Istanbul 2016 Agenda is online!

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