What Oracle Developers Should Know … Part 1

Quite often, as Database Administrators we are faced the case,  when our attitude to SQLs, our knowledge of topic, is in contraty to what Developers know..

It all comes from fact, that Developers, do not have some information, and look at application from functional point of view…

In this series of posts, I will try to build a bridge between DBAs and DEVs…

So, let’s go to the point..

Subjects that this series will raise:

  • Selectivity / Cardinality and Histograms
  • How to read execution plans (Explain Plan – sometimes lies ?)
  • What is Shared pool – why Devs should know it ?
  • Bind variables vs Literals
  • Variable Bind Peeking
  • Adaptive Cursor Sharing – selectivity cubes
  • Access Paths and Join Methods
  • Result Set Cache
  • Adaptive Optimizations in 12c

Continue reading

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

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

“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

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

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

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

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


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

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

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

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