Franck Pachot

TypePostAuthorRepliesLast updated
feedpageOracle Connection Manager (CMAN) quick reporting script Franck Pachot01 day 10 hours ago
feedpageOGB Appreciation Day : “_query_on_physical” (again) Franck Pachot01 day 10 hours ago
feedpagepgbench retry for repeatable read transactions — first (re)tries Franck Pachot01 day 10 hours ago
feedpageAn Oracle Auto Index function to drop secondary indexes - what is a “secondary” index? Franck Pachot01 day 10 hours ago
feedpageTruncate AWR tables (unsupported) Franck Pachot01 day 10 hours ago
feedpageHow to drop an index created by Oracle 19c Auto Indexing? Franck Pachot01 day 10 hours ago
feedpage19c High-Frequency statistics gathering and Real-Time Statistics Franck Pachot01 day 10 hours ago
feedpageHow 19c Auto Indexes are named? Franck Pachot01 day 10 hours ago
feedpageThe Oracle Cloud Free Tier Franck Pachot01 day 10 hours ago
feedpagePostgreSQL subtransactions, savepoints, and exception blocks Franck Pachot01 day 10 hours ago
feedpageMVCC in Oracle vs. Postgres, and a little no-bloat beauty Franck Pachot01 week 4 days ago
feedpagePostgreSQL transaction management in procedures Franck Pachot04 weeks 6 days ago
feedpageTransaction management in PostgreSQL and what is different from Oracle Franck Pachot05 weeks 4 days ago
feedpageIs a datafile OMF or not? Franck Pachot06 weeks 3 days ago
feedpageOracle RMAN Backup Optimization ON and backup archivelog command. Franck Pachot07 weeks 4 days ago
feedpagePostgreSQL “bind variable peeking” Franck Pachot07 weeks 6 days ago
feedpageOracle & Postgres JDBC Fetch Size Franck Pachot09 weeks 3 days ago
feedpageRunning pgBench on YugaByteDB 1.3 Franck Pachot09 weeks 5 days ago
feedpageOracle DBA_SQL_PLAN_BASELINE SQL_ID and PLAN_HASH_VALUE Franck Pachot09 weeks 6 days ago
feedpageNo risk to activate Active Data Guard by mistake with SQL Developer SQLcl Franck Pachot09 weeks 6 days ago
feedpagePasswordless Data Pump 19c Franck Pachot011 weeks 2 days ago
feedpageOracle Heterogeneous Services Franck Pachot011 weeks 3 days ago
feedpageIdeas for Event Sourcing in Oracle Franck Pachot011 weeks 3 days ago
feedpageHi Tuyen, as this removes lot of files from the Oracle Home, many features will not work. Franck Pachot011 weeks 6 days ago
feedpagestrace -k (build with libunwind) Franck Pachot012 weeks 1 day ago
To prevent automated spam submissions leave this field empty.