@oramajo.bsky.social
Helped a customer with a performance problem related to a pretty simple sql, delete of a row based on a primary key column.
I hope sharing it, might help others
I hope sharing it, might help others
Performance problems with Index Fast Full Scan
I came across an interesting issue helping a customer with his database.The main issue was to analyse why a tablespace has grown rapidly latelly.But when starting to work, the server (Windows) was peeking at 90-100% cpu. We do not have Oracle diagnostic pack on the server, but I have installedstatspack. So I took out a report from statspack for the duration of 30 minutes.
magnusjohanssontuning.wordpress.com
February 19, 2025 at 10:54 AM
Helped a customer with a performance problem related to a pretty simple sql, delete of a row based on a primary key column.
I hope sharing it, might help others
I hope sharing it, might help others