Feature of our Oracle Databases – Why should we migrate to Multitenant architecture


Enjoy presentation about new Multitentant architecture offered by Oracle !
Discover prons and cons and „Why should we migrate to Multitenant architecture”

Click link below to see the presentation:


Opublikowano Oracle, Oracle DBA, Oracle DBA Zaawansowany | Otagowano , , | Skomentuj

APEX 5.1 Early Adopter 2 Available

After a long (but I’m sure well worth it) wait, Oracle just announced APEX 5.1 Early Adopter 2 is available.

Head over to https://apexea.oracle.com/ to sign up and request a Workspace.

The two big items everyone has been waiting for are

Interactive Grids

Imagine an Interactive Report. Now imagine that you can easily manipulate data simply by clicking on a cell and editing its value. That is the simple story behind this powerful new feature of Application Express 5.1. Unlock the full potential of your database, in a powerful, easy to use, highly customizable way with Interactive Grids.

Jet Charts

Charts in Application Express have been completely revamped. Powered by the all new Oracle JET charting library, these charts are beautiful, fast, highly customizable, and extremely versatile. Your data has never looked so good.

Reading through the “Additional Features in Application Express 5.1” section on the EA homepage it looks like there are lots of other interesting improvements and enhancements.

Opublikowano Oracle APEX | Otagowano , , , , | Skomentuj

What is and What is not Exadata Engineered System


Enjoy presentation about main features of Exadata, distinguishing it from others solutions on market !

Click link below to see the presentation:


Opublikowano Nieokreślona, Oracle DBA | Skomentuj

Darmowe seminaria z Exadaty

Zobacz więcej aby obejrzeć film na temat Exadaty Czytaj dalej

Opublikowano Oracle DBA, Oracle DBA Zaawansowany | Otagowano , , | Skomentuj

Running exachk when no RAC databases installed, Health Check 11109: Database node IB MTU size should be set to 65520

Does every Database Machine runs RAC databases ? No … ! Lots of consolidated databases run in single instance configuration.

Are we able to use the same tools , as for preferred by Oracle RAC configuration ?

Czytaj dalej

Opublikowano Nieokreślona, Oracle DBA | Skomentuj

Restore Production Database As Test On The Same Host When Using OMF On It

Recently I stepped on interesting issue.. I was suppose to restore database on the same host where source production database was running…

In general, not big deal…lots of procedures to follow, but what when source database uses OMF (Oracle Managed Files) ? Does situation changes then ?

Czytaj dalej

Opublikowano Oracle DBA Zaawansowany | Skomentuj

Instalacja APEX 5 na Oracle 11g XE na Windows

1. Wchodzimy na stronę


i pobieramy aktualna wersje APEX. W momencie redagowania tego posta jest to wersja 5.0.3

Czytaj dalej

Opublikowano Oracle APEX, Oracle APEX Zaawansowany | Otagowano , , , | Skomentuj

Connect by level vs recursive with (CTE) for generating values

Hi All,

Have you ever wondered what is the difference between generating records using connect by level and recursive with in CTE (available from Oracle 11R2)? I did short ora-investigation :)

Czytaj dalej

Opublikowano Oracle, Oracle DBA, Oracle DBA Podstawy, Oracle SQL, Oracle SQL Tuning | Otagowano , , , | Skomentuj

Profilowanie zawrapowanego kodu PL/SQL

Czy zastanawialiście się co stanie się, gdy spróbujcie profilować zawrapowany kod PL/SQL? Czy dowiemy się jakie nr linii kosztują nas najbardziej? Czy dowiemy się jakie funkcje i procedury uruchamia nas zawrapowany kod?

Jeśli tak – zapraszam do lektury :)

Czytaj dalej

Opublikowano Oracle, PL/SQL, PL/SQL Zaawansowany | Otagowano , , , , , | Skomentuj

Warsztaty z administracji Exadatą w Warszawie. Tablet gratis!

Warsztaty Exadata
Szkolenie potwierdzone. Tablet gratis. Zapytaj o atrakcyjną zniżkę na biuro@dataconsulting.pl Czytaj dalej

Opublikowano Oracle, Oracle DBA, Oracle DBA Zaawansowany | Otagowano , , | Skomentuj