Oracle XE 18c is available for download

We’ve been waiting a very long time but finally it is:
New version of Oracle XE: Oracle XE 18c is available fordownload (only for Linux now).

What is even more important:
– limits are extended to 12GB of user data, 2GB of RAM and 2 cores
– a lot of new options disabled in 11g XE are now available for example: compression, spatial, partitioning, multitenant/pluggable databases, advanced analytics

Don’t wait and download Oracle XE 18c now

Opublikowano Oracle, Oracle DBA | Otagowano , , , | Możliwość komentowania Oracle XE 18c is available for download została wyłączona

Oracle APEX 18.2c is available for download

Oracle APEX 18.2c is available for download. Check this link: https://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

There are great new features like REST Enabled SQL, JET charts improvements, Interactive Grid improvements, JavaScript API documentation for widgets, better master-detail, improvements if APEX Font and App Builder interface. See new features at https://docs.oracle.com/database/apex-18.2/HTMRN/toc.htm#HTMRN-GUID-D6D545CB-3ECD-468A-9E7F-8CC09F7F478B and all features at: https://apex.oracle.com/en/platform/features/

Opublikowano Oracle APEX | Otagowano , , , , , | Możliwość komentowania Oracle APEX 18.2c is available for download została wyłączona

New Oracle APEX 5.2 for Christmas!

There is APEX 5.2 Early Adopter available on https://apexea.oracle.com. Release 5.2 brings a suite of new features including REST enabled SQL, improvements to REST Service Consumption, an all new Create App Wizard, new chart types, APEX Spotlight Search, and a whole lot more

Opublikowano Oracle APEX | Otagowano , , | Skomentuj

Free Oracle APEX training course materials

Here you can find free APEX training for download and self learning. Package of files contains:

  • Presentations with detailed comments
  • Hands-on Lab Guide with description of workshops
  • APEX source files, SQL files and data files for preparing of environment

You may use these materials in your training courses or curriculum.

Free Oracle APEX training

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

What Developers Should Know … Part 3

If you have read Part 1 and Part 2 of this series, you are now ready to observe parsing (soft and hard), bind peeking, influence them, and observe how Adaptive Cursor Sharing tries to fix it.

Literals vs Bind Variables

We can say, that variables used inside PLSQL block are „Automatic Bind Variables”. So it means they are considered as bind variable and are not causing parse operations. That it is better to run stored PLSQL block then a lot of single SQL queries from application (from database point of view)
Czytaj dalej

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

What Developers Should Know … Part 2

Up to now, we talked about

  • Selectivity / Cardinality
  • Skewed Data / Histograms
  • Displaying Execution Plans with Explain Plan, dbms_xplan package, autotrace feature
  • Introduced bind variables

I believe, that for most of you it was quite familiar..

But I also stronlgy believe, that we should talk about the process of executing SQL query and components of Oracle Database that take part in it…
Czytaj dalej

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

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

Czytaj dalej

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

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 😉

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

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

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

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

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