bug

Resource manager session_pga_limit has it’s own limits

Recently we hit an issue with a complex SQL statement (formatted was 44,000 lines, maybe subject of a separate blog post), causing the CBO to struggle consuming large amounts of PGA memory, and the host to start swapping memory and impacting other database users. The pga_aggregate_limit parameter did not appear to be kicking in (maybe …

Resource manager session_pga_limit has it’s own limits Read More »

12.2 controlfile backup never gets marked as obsolete

I’ve blogged about this bug in passing, but I thought would be worthwhile to document my testcase.    Basically backups of controlfiles never get marked as obsolete. The issue reproduces for both image copies and backupsets, my test-case uses the latter for simplicity. RMAN> show all; RMAN configuration parameters for database with db_unique_name PVJTEST are: CONFIGURE …

12.2 controlfile backup never gets marked as obsolete Read More »