German Oracle User Group (DOAG) Conference 2015

November 30, 2015 by Leave a comment 

Kirill Loifman is DOAG 2015 conference speaker dadbm.comThe 28th edition of DOAG 2015 annual Conference + Exhibition was held November 17 – 20, 2015 in Nuremberg Conference Center. Participants had the opportunity to attend the exibition and daily lecture programs with more than 500 talks and international top speakers, plus a wide choice of workshops,  and community activities.
Interseting key notes including one with Andrew Mendelsohn, Executive Senior Vice President at Oracle, who shared the information about new developments in Oracle database 12c.
This was a great opportunity for everyone to expand the knowledge and benefit from the know-how of the Oracle community.

Thanks for all the organizers and participants.

I was speaking there also with a database related topic called:

Reduce planned database down time with Oracle technology smart

Official Abstract of my DOAG presentation:
How to design an Oracle database system to minimize planned interruptions? That depends on the requirements, goals, SLAs etc. The presentation will follow top-down approach. First we will describe major types of planned maintenance, prioritize those and then based on the system availability requirements find the best cost-effective technics to address those. A bit of planning, strategy and of course modern OS and database technics including latest Oracle 12c features will follow.


Timelines and location: Thursday, 2015-11-19, room Shanghai

The presentation consists of 3 major parts including Linux and SQL code examples:

– System downtimes and high availability basics
– Reducing planned downtime approach and methodology
– Technical part: system configurations, technics, new Oracle 12c features

See the slightly adjusted presentation material below:
– Presentation: Reduce planned database down time with Oracle technology
– Scripts: will follow

Please share your ideas, expririence or ask questions in the Comments to this post below.

You can also review my previouse DOAG 2014 presentation including live demo: Live adventure – From my PC to Oracle remote database

Some a few photos below… Read more »

From my PC to Oracle remote database at DOAG 2014

November 17, 2014 by Leave a comment 

DOAG2014 Kirill Loifman is a conference speakerI’ll be speaking at German Oracle User Group (DOAG) Conference 2014 this week. The database related presentation with following title will be held in English:

Live adventure – from my PC to Oracle Remote Database

Official Abstract:
Best practices and live demo on remote database connection techniques including remote database connection setup, troubleshooting and undocumented tricks. Together with the audience we bypass a firewall, establish SSH RSA server authentication and receive DB access without an obvious user. Connect without passwords to any server this is our final goal!

Timelines and location: 19.11.2014 12:00, room Seoul

During my presentation in the interesting manner of a live demo I’ll try to explore how a trivial topic of Oracle database connection can have so many problematic areas in terms of  security, troubleshooting and user usability.

See the relevant documents below:
– Presentation: Live adventure – From my PC to Oracle remote database
– Demos: on DaDBMan YouTube channel

In case of questions please use comments below in this post.

Looking forward to seeing you all at CCN East, Nuremberg Trade Fair, 18th-20th November 2014!

..Oh yes, one more thing I forgot. In scope of the conference I was interviewed with a few questions by a DOAG representative. It was great to see myself with that interview in the DOAG Conference brochure together with the other big names of Oracle community. You can read it here in German: Die Datenbank hacken

Oracle DBaaS in Private Database Cloud workshop

April 28, 2014 by Leave a comment 

Designing Database as a Service (DBaaS) in own Database Cloud is very comprehensive topic and it requires a lot of things: clear concept and strategy, solid planning, important architecture decisions, considerable involvement of different stakeholders, extra budget, etc. To start talking about this topic I’ll give my own definition of DBaaS which is a managed database service, hosted and offered by DBaaS provider on pay-per-usage basis, which provides access to own database resource with flexible on-demand system scaling capabilities. DBaaS on high level consists of three major pillars: Business, Operation and Technology and you cannot start with the most interesting one, which is certainly Technology (at least for me :).

Oracle DBaaS in Private Database Cloud workshop

DBaaS workshop in Munich with Ralf Durben and Manual Hossfeld

Last week being a part of exclusive Oracle Database Day workshop I learned and discussed the possibilities of building a DBaaS based on Private Database Cloud with best Oracle Germany experts in Munich. This time we talked exactly about DBaaS Technology and specifically about Oracle Cloud Management capabilities. With help of Oracle Enterprise Manager (OEM) 12c Cloud Control and OEM Self Service Portal you can establish a framework for end-users to provision own DBaaS components with a few mouse clicks. In Oracle terms these DBaaS components can be the following:
Read more »

Oracle performance tuning with Real World Performance Group

February 24, 2014 by Leave a comment 

Oracle Real World Performance Tour seminar in Munich

Oracle Real World Performance Tour seminar in Munich

I was a part of a unique Oracle training seminar that happened in Munich, Germany last week.
This is a Day of Real World Performance Tour seminar given by: Andrew Holdsworth, Tom Kyte, Graham Wood. These 3 well known Oracle experts are key members of the Real World Performance Team that consist of about 25 database experts who focus on Oracle database performance tuning, creating live demos and teaching customers how Oracle perform and how they should write the optimal code.

The format of this Oracle event is very unique. The entire seminar day Andrew, Tom and Graham are continuously on stage sharing in the conversational format very unique technical material debating (sometimes in a funny form) with each other and the audience. There are three screens in the seminar room and every instructor drives his own projector. They show the quite interesting live demos loading terabytes of data and manipulating with billions of rows in just several minutes on their own Exadata systems.

Interesting enough that these guys consider performance tuning aspects of the same problem from different angels sometimes contradicting each other but finally giving concrete solutions and best practices to follow. After those tests and lessons learned you definitely change your mind in terms of database and application performance tuning.

This training seminar makes interesting not only the unique technical material but also all three very different personalities of the instructors and their backgrounds. Tom has never been a DBA but he represents mainly Read more »

Oracle Exadata X4 database machine – software insights

December 6, 2013 by Leave a comment 

The newest Oracle Exadata Database Machine X4 is available for ordering! After I reviewed in my last article some hardware insights of Oracle Exadata X4, let’s talk about the software options, improvements and new features that will be available soon in the new Exadata.

If you order an Oracle Exadat X4 system you can choose between two Oracle database versions: 11g or 12c.  The relevant database version will be pre-installed by Oracle Advanced Customer Support (ACS) Services with additional Grid infrastructure software including Oracle ASM and RAC. Prerequisite is that you have enough database and RAC licenses.

Oracle Exadata X4 Machine will be delivered with the new Exadata software version 11.2.3.3.0 that provides the following major capabilities:

– Automatic Flash compression on X3 and X4 systems
– Improved support for consolidation of multiple databases
– Many management improvements
– Many robustness and availability improvements

See below some major new Exadata software featurues that are going to be incorporated to the new X4 machines.
Read more »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email