2019-07-26 Oracle & Postgres JDBC Fetch Size
2019-07-21 Running pgBench on YugaByteDB 1.3
2019-07-20 Oracle DBA_SQL_PLAN_BASELINE SQL_ID and PLAN_HASH_VALUE
2019-07-16 Passwordless Data Pump 19c
2019-07-16 No risk to activate Active Data Guard by mistake with SQL Developer SQLcl
2019-07-15 Ideas for Event Sourcing in Oracle
2019-07-12 Oracle Heterogeneous Services
2019-07-09 Hi Tuyen, as this removes lot of files from the Oracle Home, many features will not work.
2019-07-05 strace -k (build with libunwind)
2019-07-02 Oracle Refresh Group consistency with nested materialized views.
2019-06-28 Hi Vivek,
2019-06-28 Hi Gg,
2019-06-26 Oracle Materialized View Refresh Group atomicity— How to prove transactional consistency with…
2019-06-22 Oracle ATP: MEDIUM and HIGH services are not for OLTP
2019-06-20 Oracle/Hibernate de-queuing
2019-06-16 A Jupyter notebook on Google Collab to connect to the Oracle Cloud ATP
2019-06-05 Hibernate for Oracle DBAs
2019-06-03 When Oracle Statistic Gathering times out.
2019-05-27 PostgreSQL: measuring query activity(WAL size generated, shared buffer reads, filesystem reads,…)
2019-05-20 Generate your Oracle Secure External Password Store wallet from your tnsnames.ora
2019-05-19 Hi GG, this approach(pathfinder) can be used with GTT.
2019-05-19 Do you know what you are measuring with pgbench?
2019-05-16 I ‘fixed’ execution plan regression with optimizer_features_enable, what to do next?
2019-05-12 Did you forget to allocate Huge Pages on your PostgreSQL server?
2019-05-10 Easy Oracle Cloud wallet location in the JDBC connection string
2019-05-05 #VDC19 Voxxed Days CERN 2019
2019-05-04 Hi Piotr, Bug 29534218 : WITH THE NEW MULTIHOST EZCONNECT METHOD GET WRONG OUTPUTS is in status 16…
2019-04-28 PostgreSQL and Jupyter notebook
2019-04-26 Avoid compound hints for better Hint Reporting in 19c
2019-04-23 Thanks for your feedback Rafael.
2019-04-22 You should set OCSID.CLIENTID
2019-04-07 19c EM Express (aka Oracle Cloud Database Express)
2019-04-06 zHeap: PostgreSQL with UNDO
2019-04-04 Adding JDBC driver property in SQL Developer connecting to MySQL
2019-04-04 19c EZCONNECT and Wallet (Easy Connect and External Password File)
2019-03-18 High CPU usage in docker-proxy with chatty database application? Disable userland-proxy!
2019-03-17 SQL, PL/SQL and JavaScript running in the Database Server (Oracle MLE)
2019-03-15 Oracle Multi-Lingual Engine
2019-03-14 Oracle stored procedure compilation errors displayed for humans
2019-03-10 SQL prevents database corruption and injection, except in the ridiculous movie’s hacker scenes.
2019-03-06 Oracle 19c Data Guard sandbox created by DBCA -createDuplicateDB
2019-03-06 19c Observe-Only Data Guard FSFO: no split-brain risk in manual failover
2019-03-05 My next Conferences in 2019
2019-02-27 /proc/meminfo formatted for humans
2019-02-25 19c Auto Index: the dictionary views
2019-02-23 19c Easy Connect
2019-02-20 19c DG Broker export/import configuration
2019-02-18 Oracle 19c Hint Usage reporting
2019-02-14 Network troubleshooting with tcpdump and strace
2019-01-27 Where to check Data Guard gap?
2019-01-24 Oracle numbers in K/M/G/T/P/E
2019-01-18 Oracle — Table lock modes
2019-01-18 Ok, good to know.
2019-01-16 SYS.STATS_TARGET$
2019-01-10 You don’t need the PLAN_TABLE table
2019-01-08 Oracle global vs. partition level statistics CBO usage
2019-01-07 Oracle literal vs bind-variable in partition pruning and Top-N queries
2019-01-06 Data Guard gap history
2019-01-05 Oracle listener static service hi-jacking
2018-12-31 UUID (aka GUID) vs. Oracle sequence number
2018-12-26 Index Only access with Oracle, MySQL, PostgreSQL, and Microsoft SQL Server
2018-12-22 We still need partitions and indexes, and I will continue to commute by train even when…
2018-12-17 Oracle VPD as a safeguard for DML
2018-12-14 CPU Capacity planning from OEM metrics
2018-12-11 Minimal Oracle installation (and Docker image)
2018-12-07 See you in OBUG Tech Days Belgium
2018-12-01 Oracle Index compression for range scan on file names
2018-11-27 Oracle Adaptive Plan info in OTHER_XML
2018-11-11 Oracle LIKE predicate and cardinality estimations
2018-10-28 What’s new in Oracle Database 19c and other #OOW18 feedback
2018-10-20 A new blog post on the Databases at CERN blog about the new 18.3 installation with .rpm:
2018-10-11 ODC Appreciation Day: Reduce CPU usage by running the business logic in the Oracle Database
2018-10-02 Unindexed Foreign Keys in Oracle and PostgreSQL
2018-09-28 Efficient query on DBA_EXTENTS for access by FILE_ID / BLOCK_ID
2018-09-27 Oracle write consistency, bug, and scalable multi-thread de-queuing
2018-09-26 Upload large files to Oracle Cloud with the Object Storage REST API
2018-09-18 Start/Stop your Autonomous Databases
2018-09-14 How to gather Oracle optimizer statistics with minimal risks of regression
2018-09-09 Recursive queries on IM_DOMAIN$ at each cursor execution
2018-09-02 ASM Filter Driver — simple test on filtering
2018-08-31 Download your SR content from MOS
2018-07-20 Installing ZFS on OEL7 UEK4
2018-07-20 Conferences 2018
2018-07-13 Oracle: connection rate to the listener
2018-07-07 Stays One Step Ahead With Certification
2018-07-06 strace the current Oracle session process
2018-07-06 Oracle archivelog deletion policy