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?