Co nowego w Oracle 12.2 – Identyfikatory powyżej 30 znaków?

Posted on 9 November 2016 by Rafal Stryjek

“The maximum length of identifiers is increased to 128 bytes for most identifiers, up from 30 bytes in previous releases”

Brzmi ciekawie 😉

Posted in Oracle, Oracle DBA, Oracle DBA Basic, Oracle SQL, Oracle SQL Zaawansowany | Tagged , | Leave a comment

Oracle 12.2 – dokumentacja

Posted on 8 November 2016 by Rafal Stryjek

Ukazała się dokumentacja do Oracle 12.2. Możemy zapoznać się między innymi z nowymi cechami 12.2, dzięki “What’s new”.

http://docs.oracle.com/database/122/index.htm

Posted in Oracle, Oracle SQL, PL/SQL | Tagged , | Leave a comment

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

Posted on 24 September 2016 by Radosław Cisz

Hi,

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:

multitenant_architecture_pros_and_cons

Posted in Oracle, Oracle DBA, Oracle DBA Advanced | Tagged , , | Leave a comment

APEX 5.1 Early Adopter 2 Available

Posted on 23 September 2016 by Przemysław Kantyka

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.

Posted in Oracle APEX | Tagged , , , , | 2 Comments

What is and What is not Exadata Engineered System

Posted on 8 June 2016 by Radosław Cisz

Hi,

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

Click link below to see the presentation:

What_is_and_what_is_not_exadata_db_machine

Posted in Nieokreślona, Oracle DBA | Leave a comment

Darmowe seminaria z Exadaty

Posted on 21 May 2016 by Przemysław Kantyka


Zobacz więcej aby obejrzeć film na temat Exadaty Continue reading →

Posted in Oracle DBA, Oracle DBA Advanced | Tagged , , | 1 Comment

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

Posted on 9 May 2016 by Radosław Cisz

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 ?

Continue reading →

Posted in Nieokreślona, Oracle DBA | Leave a comment

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

Posted on 26 April 2016 by Radosław Cisz

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 ?

Continue reading →

Posted in Oracle DBA Advanced | Leave a comment

Instalacja APEX 5 na Oracle 11g XE na Windows

Posted on 17 April 2016 by kosma

1. Wchodzimy na stronę

http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

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

Continue reading →

Posted in Oracle APEX, Oracle APEX Advanced | Tagged , , , | Leave a comment

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

Posted on 10 April 2016 by Rafal Stryjek

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 🙂

Continue reading →

Posted in Oracle, Oracle DBA, Oracle DBA Basic, Oracle SQL, Oracle SQL Tuning | Tagged , , , | Leave a comment