Top 60 Oracle Blogs

Recent comments

Franck Pachot

TypePostAuthorRepliesLast updated
feedpageOracle literal vs bind-variable in partition pruning and Top-N queries Franck Pachot02 days 5 hours ago
feedpageOracle global vs. partition level statistics CBO usage Franck Pachot02 days 5 hours ago
feedpageIndex Only access with Oracle, MySQL, PostgreSQL, and Microsoft SQL Server Franck Pachot02 days 5 hours ago
feedpageYou don’t need the PLAN_TABLE table Franck Pachot02 days 5 hours ago
feedpageUUID (aka GUID) vs. Oracle sequence number Franck Pachot02 days 5 hours ago
feedpageSYS.STATS_TARGET$ Franck Pachot02 days 5 hours ago
feedpageOracle listener static service hi-jacking Franck Pachot02 days 5 hours ago
feedpageOracle — Table lock modes Franck Pachot02 days 5 hours ago
feedpageData Guard gap history Franck Pachot02 days 5 hours ago
feedpageWe still need partitions and indexes, and I will continue to commute by train even when… Franck Pachot02 days 15 hours ago
feedpageOracle VPD as a safeguard for DML Franck Pachot03 days 14 hours ago
feedpageCPU Capacity planning from OEM metrics Franck Pachot01 week 2 days ago
feedpageMinimal Oracle installation (and Docker image) Franck Pachot01 week 5 days ago
feedpageSee you in OBUG Tech Days Belgium Franck Pachot01 week 6 days ago
feedpageOracle Index compression for range scan on file names Franck Pachot02 weeks 10 hours ago
feedpageOracle Adaptive Plan info in OTHER_XML Franck Pachot02 weeks 1 day ago
feedpageOracle LIKE predicate and cardinality estimations Franck Pachot02 weeks 6 days ago
feedpageWhat’s new in Oracle Database 19c and other #OOW18 feedback Franck Pachot03 weeks 4 days ago
feedpageA new blog post on the Databases at CERN blog about the new 18.3 installation with .rpm: Franck Pachot04 weeks 1 day ago
feedpageODC Appreciation Day: Reduce CPU usage by running the business logic in the Oracle Database Franck Pachot04 weeks 6 days ago
feedpageUnindexed Foreign Keys in Oracle and PostgreSQL Franck Pachot05 weeks 2 days ago
feedpageEfficient query on DBA_EXTENTS for access by FILE_ID / BLOCK_ID Franck Pachot05 weeks 5 days ago
feedpageOracle write consistency, bug, and scalable multi-thread de-queuing Franck Pachot06 weeks 2 days ago
feedpageUpload large files to Oracle Cloud with the Object Storage REST API Franck Pachot06 weeks 6 days ago
feedpageStart/Stop your Autonomous Databases Franck Pachot07 weeks 5 days ago