2018-05-24 Postgres, the fsync() issue, and 'pgio' (the SLOB method for PostgreSQL)

2018-05-24 ADWC - System and session settings (DWCS lockdown profile)

2018-05-15 12c upuserxt.lst, upobjxt.lst & Oracle Maintained objects/users

2018-05-14 ADWC - connect from your premises

2018-05-10 SQL Developer Web on the Oracle Cloud

2018-05-08 Some ideas about Oracle Database on Docker

2018-05-04 ADWC - the hidden gem: Zepplin Notebook

2018-05-03 ADWC - a Docker container to start/stop Oracle Cloud services

2018-05-02 ADWC: start/stop with PSM Command Line Interface

2018-05-01 ADWC: Creation of Autonomous Data Warehouse Cloud service

2018-04-27 IOUG Collaborate 18

2018-04-13 Covering indexes in Oracle, and branch size

2018-04-01 After IoT, IoP makes its way to the database

2018-03-31 Docker: efficiently building images for large software

2018-03-29 Docker-CE on Oracle Enterprise Linux 7

2018-03-18 Result cache invalidation caused by DML locks

2018-03-11 18c PDB switchover

2018-03-09 Enabled, Accepted, Fixed SQL Plan Baselines

2018-03-04 18c new Lost Write Protection

2018-02-27 18c dbms_xplan note about failed SQL Plan Baseline

2018-02-26 A free persistent Google Cloud service with Oracle XE

2018-02-26 18c, Cloud First and Cloud Only features: think differently

2018-02-25 PDB upgrade from 12c to 18c

2018-02-23 ODA Lite: What is this 'odacli' repository?

2018-02-18 18c Read Only Oracle Home

2018-02-15 (DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=YES)(LOAD_BALANCE=NO)

2018-02-14 Full page logging in Postgres and Oracle

2018-02-12 V$MYSTAT delta values

2018-02-10 Server process name in Postgres and Oracle

2018-02-07 12cR2 PDB archive

2018-02-06 JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU

2018-02-05 Multitenant, PDB, 'save state', services and standby databases

2018-01-29 Result Cache: when *not* to use it

2018-01-28 Testing Oracle SQL online

2018-01-24 Explain Plan format

2018-01-21 Unplug an Encrypted PDB (ORA-46680: master keys of the container database must be exported)

2018-01-14 Spectre and Meltdown on Oracle Public Cloud UEK - LIO

2018-01-13 Spectre/Meltdown on Oracle Public Cloud UEK - PIO

2018-01-09 Spectre and Meltdown, Oracle Database, AWS, SLOB

2018-01-05 Keep your orapw password file secure

2017-12-30 12c Multitenant internals: PDB_PLUG_IN_VIOLATIONS

2017-12-30 12c Multitenant internals: PDB replay DDL for common users

2017-12-25 Drop PDB including datafiles may keep files open

2017-12-21 12cR2 Subquery Elimination

2017-12-15 Oracle docker image from docker store

2017-12-08 #UKOUG_TECH17

2017-11-28 impdp logtime=all metrics=y and 12cR2 parallel metadata

2017-11-25 #DOAG2017

2017-11-22 12c Multitenant Internals: compiling system package from PDB

2017-11-18 Unstructured vs. structured

2017-11-17 CBO, FIRST_ROWS and VIEW misestimate

2017-11-14 Dynamic Sampling vs. Extended Statistics

2017-11-05 Multitenant internals: INT$ and INT$INT$ views

2017-11-05 Multitenant dictionary: what is consolidated and what is not

2017-11-02 Quick history on database growth

2017-10-31 Dbvisit replicate - SQL Developer chart

2017-10-26 Max PDBs in Standard Edition

2017-10-22 Database is more than persistence. It is shared. My thoughts about Microservice Database.

2017-10-22 Archivelog deletion policy on Data Guard configuration

2017-10-21 VirtualBox 5.2 exports the VM to the Oracle Cloud

2017-10-11 Oracle Database Multilingual Engine (MLE)

2017-10-10 ODC Appreciation Day : Javascript in the database

2017-10-08 Autonomous Database

2017-10-03 Oracle 18c RU and RUR for pioneers and followers

2017-10-03 ODA X7

2017-09-29 "_suppress_identifiers_on_dupkey" - the SAP workaround for bad design

2017-09-26 When deterministic function is not

2017-09-24 Am I a DBA 3.0 or just an SQL*DBA?

2017-09-23 Wrong result with multitenant, dba_contraints and current_schema

2017-09-16 Active Data Guard services in Multitenant

2017-09-10 12c Access Control Lists

2017-09-08 Create constraints in your datawarehouse - why and how

2017-09-06 impdp content=metadata_only locks the stats

2017-09-05 12c dbms_stats.gather_table_stats on GTT do not commit

2017-09-03 When PDB name conflicts with CDB name

2017-08-26 Postgres vs. Oracle access paths XI - Sample Scan

2017-08-24 Postgres vs. Oracle access paths X - Update

2017-08-23 Postgres vs. Oracle access paths IX - Tid Scan

2017-08-23 Improving Statspack Experience

2017-08-23 Bequeath connect to PDB: set container in logon trigger?

2017-08-20 Postgres vs. Oracle access paths VIII - Index Scan and Filter

2017-08-20 Get trace file from server to client

2017-08-14 ODA X6 2S 2M 2L HA: Small Medium Large and High Availability

2017-08-09 Postgres vs. Oracle access paths VI - Index Scan

2017-08-08 Postgres vs. Oracle access paths V - FIRST ROWS and MIN/MAX

2017-08-05 Postgres vs. Oracle access paths IV - Order By and Index

2017-08-05 Encryption of shell scripts

2017-08-05 Documentum - Using DA with Self-Signed SSL Certificate

2017-08-05 Documentum - Unable to install xCP 2.3 on a CS 7.3

2017-08-04 Exadata Capacity on Demand and Elastic Rack

2017-08-04 Developer GUI tools for PostgreSQL

2017-08-03 Postgres vs. Oracle access paths III - Partial Index

2017-08-02 Postgres vs. Oracle access paths II - Index Only Scan

2017-08-02 Oracle Cloud: script to stop all PaaS services

2017-08-01 PostgreSQL on Cygwin

2017-08-01 Postgres vs. Oracle access paths I - Seq Scan

2017-08-01 Postgres vs. Oracle access paths - intro

2017-08-01 Postgres unique constraint

2017-08-01 Display Data Guard configuration in SQL Developer

2017-07-31 Postgres vs. Oracle access paths VII - Bitmap Index Scan

2017-06-28 ODA X6 installation: re-image

2017-06-27 12c Multitenant Internals: VPD for V$ views

2017-06-19 12cR2 Application Containers and Foreign Keys

2017-06-15 12c NSSn process for Data Guard SYNC transport

2017-06-12 12cR2 PDB refresh as a poor-man standby?

2017-06-04 12cR2 auditing all users with a role granted

2017-05-30 New release model for JUL17 (or Oracle 17.3): RU and RUR

2017-05-29 Which privilege for CREATE PLUGGABLE DATABASE from DB LINK?

2017-05-29 Oracle 12cR2: exchange partition deferred invalidation

2017-05-26 12cR2 needs to connect with password for Cross-PDB DML

2017-05-16 random "ORA-01017: invalid username/password" in 12cR2

2017-05-13 12cR2 Cross-container DML - insert into container()

2017-05-08 What is in a transportable tablespace dumpfile?

2017-05-07 Can you open PDB$SEED read write?

2017-05-03 12c nologging and Data Guard

2017-05-01 12cR2 partial PDB backup

2017-04-25 Listener and Virtual IP

2017-04-23 12cR2 RMAN> REPAIR

2017-04-22 Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c

2017-04-21 SecureFiles on multi-datafiles tablespaces

2017-04-16 SQLcl on Bash on Ubuntu on Windows

2017-04-08 Service "696c6f76656d756c746974656e616e74" has 1 instance(s).

2017-04-06 12cR2 DML monitoring and Statistics Advisor

2017-04-03 12cR2 DBCA, Automatic Memory Management, and -databaseType

2017-04-02 When automatic reoptimization plan is less efficient

2017-03-27 JAN17 Proactive Bundle Patch + Adaptive Statistics control

2017-03-19 Purging Unified Audit Trail in 12cR2

2017-03-18 How many members for standby redo logs?

2017-03-16 Oracle 12cR2 on Windows: Virtual Accounts

2017-03-12 Google Cloud Platform instances and Oracle Database

2017-03-10 12cR2: TNS_ADMIN in env.ora

2017-03-09 Oracle 12cR2, RAC, Cloud, ACFS, PDB thin clones and asmadmin

2017-03-07 Oracle 12cR2: changes for login.sql

2017-03-06 Misleading wait event names clarified in V$EVENT_NAME

2017-03-04 Purging Unified Audit Trail in 12cR1

2017-02-26 Oracle 12cR2: Online tablespace encryption

2017-02-26 12cR2: Recover nonlogged blocks after NOLOGGING in Data Guard

2017-02-23 12c Unified Auditing and AUDIT_TRAIL=DB in mixed mode

2017-02-21 12cR2: lockdown profiles and ORA-01219

2017-02-17 12cR2 real-time materialized view (on query computation)

2017-02-12 12cR2 DBCA can create a standby database

2017-02-10 Oracle Public Cloud: LIOPS with 4 OCPU in PaaS

2017-02-08 Oracle Public Cloud: 2 OCPU for 1 proc. license

2017-02-06 Exadata Express Cloud Service: SQL and Optimizer trace

2017-02-05 Oracle Public Cloud 12cR2: TDE is not an option

2017-02-04 Exadata Express Cloud Service: MAX_PDB_STORAGE

2017-02-04 CBO parse time - matching time with transformation

2017-02-01 Running SLOB on Exadata Express Cloud Service

2017-02-01 Amazon AWS instances and Oracle database performance

2017-01-30 Oracle Core factor and Oracle or non-Oracle Cloud

2017-01-28 Oracle 12c - How to Prevent License Violation with Active Data Guard

2017-01-24 Exadata Express Cloud Service: PDB_ADMIN privileges

2017-01-05 12cR2: no cardinality feedback for small queries

2017-01-04 NLS defaults for LANGUAGE and TERRITORY

2016-12-19 Oracle 12cR2: AWR views in multitenant

2016-12-18 RMAN> TRANSPORT TABLESPACE

2016-12-15 Oracle Database 12c Release 2 Multitenant (Oracle Press)

2016-12-07 Oracle 12cR2: Statistics Advisor

2016-12-05 Multitenant internals - Summary

2016-11-30 Histograms on character strings between 11.2.0.3 and 11.2.0.4

2016-11-29 Encryption in Oracle Public Cloud

2016-11-25 #DOAG2016

2016-11-24 Observing DML restarts caused by invalidations

2016-11-23 12cR2: Upgrade by remote clone with TDE in DBaaS

2016-11-20 12cR2: Upgrade by remote clone - workaround ORA-17630 in DBaaS

2016-11-20 12cR2: How long to upgrade a PDB?

2016-11-19 12cR2: Upgrade by unplug/plug in the Oracle Cloud Service

2016-11-16 12cR2: CREATE_FILE_DEST for PDB isolation

2016-11-14 12cR2 Single-Tenant: Multitenant Features for All Editions

2016-11-13 12cR2 new index usage tracking

2016-11-11 Oracle 12cR2: Pluggable database relocation

2016-11-11 Oracle 12cR2: MAX_PDBS

2016-11-11 12cR2 has new SQL*Plus features

2016-11-08 Oracle 12cR2 PL/SQL new feature: TNSPING from the database

2016-11-08 Oracle 12cR2 multitenant: Local UNDO

2016-11-08 12cR2 multitenant containers in SQL_TRACE

2016-11-07 Oracle Public Cloud: create a database from command line

2016-11-03 Dbvisit replicate when you flashback the target

2016-11-02 12c online move datafile in same filesystem.

2016-10-27 12c GTT private statistics and cursor invalidation

2016-10-21 2 x ODA X6-2S + Dbvisit Standby: Easy DR in SE

2016-10-19 Feedback on my session at Oracle Open World 2016

2016-10-19 Datawarehouse ODS load is fast and easy in Enterprise Edition

2016-10-17 CDB resource plan: shares and utilization_limit

2016-10-11 OTN Appreciation Day : Transportable tablespaces

2016-10-02 Oracle 12cR2: DDL deferred invalidation

2016-09-25 Oracle 12cR2: IS_ROLLING_INVALID in V$SQL

2016-09-25 Modern software architecture - what is a database?

2016-09-22 OOW 2016: nouveautés base de donnée

2016-09-21 Ravello

2016-09-20 Oracle 12cR2 Optimizer Adaptive Statistics

2016-09-20 Oracle 12cR2 Long Identifiers

2016-09-19 Oracle Database 12.2 - PDBaaS

2016-09-19 Oracle 12cR2 SQL new feature: LISTAGG overflow

2016-09-18 Le programme Oracle ACE

2016-09-13 Result cache side effects on number of calls

2016-09-06 Multitenant thin provisioning: PDB snapshots on ACFS

2016-09-03 Adaptive Plans and cost of inactive branches

2016-08-30 Rolling Invalidate Window Exceeded

2016-08-29 ODA X6 database classes and shapes

2016-08-29 Filenames in AWR reports

2016-08-27 ODA X6 command line and Web Console

2016-08-23 AUDIT_SYS_OPERATIONS and top-level operation

2016-08-15 Unplugged pluggable databases

2016-08-07 Multitenant internals: object links on fixed tables

2016-08-07 Multitenant internals: how object links are parsed/executed

2016-07-31 Oracle serializable is not serializable

2016-07-31 Exadata X-5 Bare Metal vs. OVM load testing

2016-07-29 Exadata X-5 Bare Metal vs. OVM performance

2016-07-27 Large Pages and MEMORY_TARGET on Windows

2016-07-22 Redo log block size on ODA X6 all flash

2016-07-21 ODA X-6 log file sync with NVMe flash

2016-07-16 AMM and ASMM derived parameters

2016-07-13 Oracle Public Cloud patch conflict

2016-07-12 Nulls in composite keys

2016-07-10 Oracle Multitenant feature name

2016-07-05 Compare source and target in a Dbvisit replication

2016-07-04 Script to suggest FK indexes

2016-06-28 Statspack Idle Events

2016-06-23 Question is: upgrade now to 12.1.0.2 or wait for 12.2 ?

2016-06-21 ORA-01775: looping chain of synonyms

2016-06-21 ODA X6-2S and ODA X6-2M for EE and SE2

2016-06-21 Adaptive Plans and SQL Baselines

2016-06-20 When changing CURSOR_SHARING takes effect?

2016-06-20 ASM iostats

2016-06-18 12c online datafile move and resize

2016-06-17 CPU_COUNT

2016-06-16 Large Pages on Windows

2016-06-12 Instance Caging and multitenant: do the right setting

2016-06-10 Oracle on Windows Server Core

2016-05-30 Where is the ASM SPFILE?

2016-05-28 Learning and troubleshooting: Follow the path

2016-05-27 Extended clusters and asm_preferred_read_failure_groups

2016-05-26 DB_FLASHBACK_RETENTION_TARGET may hang your database

2016-05-24 Which patchset for 12.1.0.2 ?

2016-05-21 SYS password on Oracle Cloud Service managed database

2016-05-20 Data Guard as a Service

2016-05-17 Multitenant dictionary: what is stored only in CDB$ROOT?

2016-05-04 Adaptive Plan: How much can STATISTICS COLLECTOR buffer?

2016-05-03 When a query has read 350TB after 73K nested loops

2016-04-28 Testing Oracle on exoscale.ch

2016-04-28 Can you become a PaaS provider for an Oracle Database service?

2016-04-26 I/O Performance predictability in the Cloud

2016-04-16 A short glance at Attunity replicate

2016-04-12 Transparently externalize BLOB to BFILE

2016-04-09 Single-Tenant vs. non-CDB: no reason to refuse it

2016-04-04 Fixed table automatic statistic gathering in 12c

2016-04-03 Lost in the Cloud? My Cloud vs. My Services

2016-04-03 Créer une base Oracle sur le Cloud en quelques clicks

2016-03-31 Cloning a PDB to the Oracle Cloud Service

2016-03-27 How to check Multitenant Option feature usage

2016-03-20 RAC to RON then RON to RAC and singleton service

2016-03-17 RMAN 12c Push and Pull duplicate explained

2016-03-16 The privileges to connect to a container

2016-03-16 12c Multitenant: PDB spfile parameters for standby database

2016-03-13 12c Multitenant internals: AWR tables and views

2016-03-12 Conversion to Flex ASM with asmca takes 5 minutes

2016-03-12 12c multitenant: Cursor sharing in CDB

2016-03-10 Resource Manager plan from OEM vs. command line

2016-03-10 Any reason to change the C## common user prefix?

2016-03-08 Easy transport of SQL Tuning Sets with OEM

2016-03-07 GTT in Exadata are eligible to SmartScan

2016-02-26 Standard Edition 2 testing the 16 thread limitation

2016-02-21 The taboo of 'underscore parameters'

2016-02-12 12c online datafile move and ongoing changes

2016-02-04 SQL Plan Directives strikes again

2016-01-27 awrrpt and spreport in multitenant

2016-01-21 OFE - Optimizer Features Enable

2016-01-21 Execution Plan with ASH

2016-01-18 DataPump 'Processing object type' misleading messages

2016-01-10 log file sync / user commits

2016-01-02 PDB Snapshot using dbms_dnfs.clonedb_renamefile

2016-01-02 Flashback table after multiple drop

2016-01-01 PDB snapshot copy for continuous integration testing

2015-12-27 Phantom session environment in multitenant?

2015-12-21 OCM 12c preparation: restore Voting disks, OCR and ASM spfile

2015-12-20 OCM 12c preparation: RAT in multitenant

2015-12-19 OCM 12c preparation: Data Guard with OEM

2015-12-18 OCM 12c preparation: documentation

2015-12-17 OCM 12c preparation: Explain fast refresh

2015-12-15 OCM 12c preparation: Transportable Tablespaces

2015-12-03 SQL Plan Directive: disabling usage and column groups

2015-11-30 OCM 12c preparation: Manage PDB

2015-11-30 OCM 12c preparation: Create CDB in command line

2015-11-24 Trying AppDynamix - monitoring application from user to database

2015-11-21 Real life audience vs. Twitter audience

2015-11-15 In-Memory synchronous population with hidden parameters

2015-11-13 Cloud Control 12c on your laptop

2015-11-11 Interested in a deep dive of logical replication?

2015-11-11 set "_rowsets_enabled"=false

2015-11-05 RMAN channels in RAC

2015-11-05 AWR when ASH CPU >> DB CPU

2015-11-03 Dbvisit replicate allows DDL replication even when source and destination have different structure

2015-10-31 IBM Bluemix Database Cloud Service - My first trial

2015-10-29 OOW15 - Day 5 - Blogger Meetup

2015-10-29 OOW15 - Day 4 - you can auto evolve SPM without Tuning Pack

2015-10-28 OOW15 - Day 3 - thoughts from DemoGrounds about SIZE AUTO

2015-10-27 OOW15 - Day 2- Oracle Database 12cR2 designed for the Cloud

2015-10-26 OOW15 - Day 1- No fog on Golden Gate brige but Cloud everywhere at Moscone center

2015-10-24 DBA, turkeys and NoSQL hype

2015-10-21 SQL> alter database switchover to ...

2015-10-18 You are in Standard Edition, when to worry?

2015-10-18 Oracle Cloud Service - my first outage

2015-10-16 11.2.0.4 support? Don't worry until 2017

2015-10-13 Mapping In-memory CU to values: IMCU pruning

2015-10-11 Mapping In-memory Column Store to datafile Row Store extents

2015-10-10 In-memory trickle repopulation

2015-10-07 Dbvisit replicate CDC without old values

2015-10-06 Oracle In-Memory Column Store for Business Intelligence at #swissbiday

2015-10-04 Result Cache and 12c 'fetch first n rows'

2015-10-04 Oracle and Analytic Queries before In-Memory option

2015-09-30 Query V$UNDOSTAT for relevant time window

2015-09-29 Nothing in feature usage statistics since 12c?

2015-09-25 Do you use SQL Plan Baselines?

2015-09-19 You are in Standard Edition One? Don't worry.

2015-09-14 Invisible indexes: it's online in 12c - even in Standard Edition

2015-09-13 Waiting for row lock. But which row is locked?

2015-09-13 DataBase Cloud Service performance – Network

2015-09-07 Windows 10 - I tried and came back

2015-09-07 Measuring IOPS on XtremIO

2015-09-07 dbi services at DOAG 2015

2015-09-06 set state=apply-off and datafile consistency

2015-09-02 Oracle Standard Edition Two

2015-08-30 DataBase Cloud Service performance – CPU

2015-08-29 DataBase Cloud Service performance - IOPS

2015-08-28 SLOB in the Cloud: how to check Cloud Services performance

2015-08-27 SCN synchronization in distributed transactions

2015-08-27 Oracle Cloud Services DBaaS and dbi services best practices

2015-08-26 Oracle CDC for Datawarehouse, Dbvisit replicate as an alternative

2015-08-25 Oracle Database Cloud Service – DBaaS

2015-08-23 OCM 12c preparation: Materialized View explain_rewrite

2015-08-23 DataGuard broker properties – Part II: log shipping parameters

2015-08-23 DataGuard broker properties - Part I: imported parameters

2015-08-23 Configure the Resource Manager with SQL Developer

2015-08-20 Rendez-vous à Paris le 4 septembre

2015-07-05 RESULT_CACHE hint expiration options

2015-06-30 Multitenant vs. schema based consolidation

2015-06-28 Oracle Log Writer and Write-Ahead-Logging

2015-06-27 Oracle Database Cloud Service - My first trial

2015-06-25 RAC buffer states: XCUR, SCUR, PI, CI

2015-06-24 Multithreaded 12c and 'connect / as sysdba'

2015-06-23 Does the block size matter?

2015-06-23 Buffer pool advisory in AWR

2015-06-23 2 ways to move archivelogs - both need RMAN

2015-06-17 DOAG Database 2015

2015-06-12 Show the Top 10 events from latest AWR snapshot

2015-06-12 Parallel DML in 12c

2015-06-12 Oracle memory advisors: how relevant ?

2015-06-12 How to import SQL Plan Directives

2015-06-12 How to disable a SQL Plan Directive permanently

2015-06-12 Flame Graph for quick identification of Oracle bug

2015-06-12 DBA_SQL_PLAN_DIRECTIVE.LAST_USED

2015-06-12 Convert a snapshot standby to a new database

2015-06-12 Can you have pending system statistics?

2015-06-12 An alternative to DBA_EXTENTS optimized for LMT

2015-06-12 12c Dynamic Sampling and Standard Edition

2015-05-20 List all RMAN backups that are needed to recover

2015-05-18 Variations on 1M rows insert(2): commit write

2015-05-18 Variations on 1M rows insert (5): using 'perf'

2015-05-18 Variations on 1M rows insert (4): IN MEMORY

2015-05-18 Variations on 1M rows insert (4): APPEND_VALUES

2015-05-18 Variations on 1M rows insert (3): TimesTen

2015-05-18 Variations on 1M rows insert (1): bulk insert

2015-05-18 Variations on 1M insert (6): CPU Flame Graph

2015-05-18 SQL Monitor report little improvement in 12c

2015-05-18 Rebuilt index on increasing values after deletes?

2015-05-18 Matching SQL Plan Directives and queries using it

2015-05-18 Matching SQL Plan Directives and extended stats

2015-05-18 List listeners and services from the instance

2015-05-18 C15LV: Nothing to BLOG About - Think Again

2015-05-18 ALTER TABLE INMEMORY

2015-05-18 A migration pitfall with ALL COLUMN SIZE AUTO

2015-04-14 Yesterday's AWR Straight to the Goal

2015-04-13 Cloning a PDB from a standby database

2015-04-12 RAC Attack! was another great success at C15LV

2015-04-09 Dbvisit replicate REDO_READ_METHOD

2015-04-08 DataGuard wait events have changed in 12c

2015-04-01 Oracle tuning silver bullet: add an order by to make your query faster

2015-03-27 Index on SUBSTR(string,1,n) - do you still need old index?

2015-03-25 Standard Edition on Oracle Database Appliance

2015-03-16 12c: shutdown abort a PDB?

2015-03-15 Index on trunc(date) - do you still need old index?

2015-03-06 Oracle compression, availability and licensing

2015-03-03 RAC Attack! next month 12c in Las Vegas

2015-03-03 Generic query for multicriteria search - part II: BIND_AWARE (Adaptive Cursor Sharing)

2015-03-03 Generic query for multicriteria search - part I: USE_CONCAT (OR Expansion)

2015-03-02 Query the Enterprise Manager collected metrics

2015-02-21 How to set NLS for SQL Developer

2015-02-21 12c online statistics gathering and startup restrict

2015-02-16 Is CDB stable after one patchset and two PSU?

2015-02-15 OracleText: inserts and fragmentation

2015-02-15 OracleText: deletes and garbage

2015-02-09 Never gather WORKLOAD stats on Exadata...

2015-02-08 Oracle multitenant dictionary: rowcache

2015-02-03 IOUG Collaborate #C15LV

2015-01-29 Flush one SQL statement to hard parse it again

2015-01-28 Stay with non-CDB or go to CDB?

2015-01-23 When to gather workload system statistics?

2015-01-15 NLS_LANG on Windows in Europe: WE8MSWIN1252 or WE8PC850?

2015-01-12 SOUG-Romand: Journée performance le 21 mai

2015-01-09 Insert into GTT: bulk with APPEND_VALUES

2015-01-09 Flashback logging overhead: 'db file sequential read' on UNDO tablespace

2015-01-05 Oracle multitenant dictionary: upgrade

2015-01-05 Oracle multitenant dictionary: metadata links

2014-12-31 Happy New Year 27, 104, 2015 and 2558

2014-12-29 Oracle multitenant dictionary: object links

2014-12-28 Creating a schema synonym in Oracle - an unsupported feature

2014-12-15 Oracle lateral inline view, cursor expression and 12c implicit statement result

2014-12-15 Oracle 12c: Can we disable logging for DML?

2014-12-08 SQL*Plus COPY Command is back as BRIDGE

2014-12-01 Oracle 12c: comparing TTS with noncdb_to_pdb

2014-11-29 When Oracle resets session statistics

2014-11-26 Oracle 12c privilege analysis rocks

2014-11-17 Oracle locks: Identifiying blocking sessions

2014-11-17 My planning for DOAG 2014

2014-11-16 12c SQL Plan Directive: state has changed between 12.1.0.1 and 12.1.0.2

2014-11-11 AWR does not store explain plan predicates

2014-11-11 12.1.0.2 CDB views are now using CONTAINERS()

2014-11-08 Oracle SQL Profile: why multiple OPT_ESTIMATE?

2014-11-07 Oracle SQL Profiles: Check what they do before accepting them blindly

2014-11-06 Using tmux for semi-interactive demos

2014-11-05 The future of SQL*Plus and some oddities

2014-11-04 How to disable all database links

2014-10-29 Oracle cloud control / SQL Details / Statistics

2014-10-26 Oracle: an unexpected lock behavior with rollback

2014-10-24 From 8.0 extended rowid to 12c pluggable db: Why Oracle Database is still a great software

2014-10-20 What about ALTER INDEX ... SHRINK SPACE ?

2014-10-16 Oracle IOT: when to use Index Organized Tables

2014-10-15 Oracle system statistics: Display AUX_STATS$ with calculated values and formulas

2014-10-13 How to measure Oracle index fragmentation

2014-10-04 OOW14 Day 5 - not only Oracle OpenWorld

2014-10-02 OOW14 Day 4 - Internals of the 12c Multitenant Architecture by Vit Spinka

2014-10-01 Solving customer issues at OOW14: Dbvisit Replicate can replicate tables without primary key

2014-10-01 OOW14 Day 3 - 12c Adaptive Bitmap Pruning

2014-10-01 OOW14 Day 2 - Delphix #cloneattack

2014-09-30 OOW14 Day 1 - Dbvisit #repattack

2014-09-23 How to measure Exadata SmartScan efficiency

2014-09-16 Thinking about downgrading from Oracle Enterprise to Standard Edition?

2014-09-10 Oracle: How to move OMF datafiles in 11g and 12c

2014-09-08 Resize your Oracle datafiles down to the minimum without ORA-03297

2014-09-04 What's the consequence of NOLOGGING loads?

2014-08-21 Oracle 12.1.0.2.1 Set to Join Conversion

2014-08-04 Oracle 12.1.0.2: Wait event histograms in μs

2014-07-28 PDB media failure may cause the whole CDB to crash

2014-07-25 SQL monitoring 12.1.0.2 shows adaptive plans

2014-07-22 Beyond In-Memory, what's new in 12.1.0.2 ?

2014-07-18 Oracle EM agent 12c thread leak on RAC

2014-07-18 Drilling down V$RECOVERY_AREA_USAGE

2014-07-14 Partial Join Evaluation in Oracle 12c

2014-06-26 Oracle Parallel Query: Did you use MapReduce for years without knowing it?

2014-06-18 Linux: how to monitor the nofile limit

2014-06-10 Linux: how to monitor the nproc limit

2014-06-05 How to list all Oracle system schemas

2014-05-28 Oracle Exadata - poor optimization for FIRST_ROWS

2014-05-23 Oracle 12c extended datatypes better than CLOB?

2014-05-15 Oracle SQL Monitoring reports in flash, html, text

2014-05-12 Exploring Oracle SE & EE performance statistics with Orachrome Lighty

2014-05-05 Oracle: ROWNUM vs ROW_NUMBER() and 12c fetch first

2014-04-30 Oracle 12c CDB - metadata & object links internals

2014-04-11 Oracle 12c Adaptive Plan & inflection point

2014-04-08 Best practice for the sending of an Oracle execution plan

2014-03-23 The consequences of NOLOGGING in Oracle

2014-03-14 Investigating Oracle lock issues with event 10704

2014-03-04 Oracle 12c In-Memory option: waiting for 12.1.0.2

2014-02-21 Oracle Partitioned Sequences - a future new feature in 12c?

2014-02-13 Oracle et Dbvisit Replicate pour migrer sans arrêt de service... et sans stress

2014-02-07 Oracle is hanging? Don't forget hanganalyze and systemstate!

2014-01-28 Archivelog deletion policy for Standby Database in Oracle Data Guard

2014-01-13 Sockets, Cores, Virtual CPU, Logical CPU, Hyper-Threading: What is a CPU nowadays?