-
Recent Posts
- BEGIN; in Snowflake SQL vs BEGIN END; in Snowflake Scripting – Snowflake Scripting and transactions
- Working with Snowflake using the Vertex AI platform
- Oracle CDC to Snowlake Data Cloud using Amazon DMS and Snowpipe
- 3 ways how to connect Oracle to Snowflake – the technical overview
- APEX Connect 2021
Recent Comments
Categories
Tags
- 18c
- ajax
- amazon
- analiza
- apex
- aplikacja
- application express
- aws
- cloud
- darmowy kurs sql online
- dba
- download
- etykieta
- exadata
- excel
- exit
- gis
- goto
- jquery
- kurs online
- kurs Oracle
- Kurs Oracle SQL
- kurs sql
- null
- odbc
- Oracle
- Oracle 11
- Oracle 11g
- Oracle 12c
- oracle apex
- Oracle SQL
- Oracle SQL 11g
- pivot
- PL/SQL
- postgis
- postgresql
- RMAN
- simple checkbox
- Snowflake
- sql
- sql tuning
- tabele przestawne
- tablice zewnetrzne
- web service
- xml
Archives
- November 2022
- October 2022
- September 2022
- June 2021
- May 2021
- March 2021
- October 2020
- October 2019
- September 2019
- August 2019
- May 2019
- April 2019
- March 2019
- October 2018
- September 2018
- December 2017
- May 2017
- January 2017
- November 2016
- September 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- January 2016
- December 2015
- June 2015
- May 2015
- April 2015
- September 2013
- May 2013
- April 2013
- February 2013
- January 2013
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
Logowanie | RSS
Author Archives: 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 adaptive cursor sharing, bind variables, parsing, sql tuning
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 library cache, shared pool, sql parsing, sql tuning
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 cursor sharing, database, dba, Oracle, plan, sql tuning
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 Multitenant Architecture, Oracle. Multitenant, Singletenant
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 dba, obciążenie, Oracle, rozliczenie, wizualizacja, www
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 KATALOG ODTWARZANIA, RECOVERY CATALOG, RMAN, RMAN PERFORMANCE, WYDAJNOŚĆ
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 CATALOG, ORACLE BACKUP, RMAN, RMAN CATALOG
Leave a comment