Archiwum kategorii: Oracle DBA

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 … 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 … 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 … 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

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

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

Opublikowano Nieokreślona, Oracle DBA | Skomentuj

Darmowe seminaria z Exadaty

Zobacz więcej aby obejrzeć film na temat Exadaty

Opublikowano Oracle DBA, Oracle DBA Zaawansowany | Otagowano , , | 1 komentarz

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 ?

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 … Czytaj dalej

Opublikowano Oracle DBA Zaawansowany | 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 🙂

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