Author Archives: Radosław Cisz

About Radosław Cisz

:)

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

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

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

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

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

Posted in Oracle DBA, 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

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

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 ?

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

Posted in Oracle DBA Advanced | Leave a comment

Rozliczenie obciążenia serwera Oracle

Ostatnio w jednej z firm dostałem zagadnienie do przemyślenia… Odkąd spółki należące do jednej korporacji zaczęły rozliczać się między sobą i działami za korzystanie z usług powstał problem jak X spółek pracujących na jednej bazie, jednym serwerze obciążyć sprawiedliwie za … Continue reading

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

Monitorowanie wydajności backupów RMAN

Jak większość z nas wie RMAN (Recovery Manager) pozwala nam w sposób elastyczny oraz automatyzujący zadania wykonywać kopie zapasowe naszych baz. Współpracuje z katalogiem metadanych o wykonanych kopiach , obrazach plików czy też całych baz, oraz kopiach logów powtórzeń. Katalog … Continue reading

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

Przenoszenie recovery catalogu nowa funkcjonalność 11G

Do wersji 11GR2 aby przenieść schemat zawierający recovery catalog, byliśmy zmuszeni używać narzędzi EXP/IMP lub zestawu narzędzi DATA PUMP EXPDP/IMPDP, będac zdanymi na szereg błędów, które były następstwem eksportu oraz importu schematu. Przykładowa procedura przenoszenia schematu do innej bazy, lub … Continue reading

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