Tuesday 11 June 2024

Monday 29 May 2023

PGA_AGGREGATE_TARGET

 PGA_AGGREGATE_LIMIT can be set to 0 either in a parameter file or dynamically after startup. If a value of 0 is specified, it means there is no limit to the aggregate PGA memory consumed by the instance.

Thursday 23 February 2023

How to install oracle 19c in silent mode? This is useful to overcome the Xterm issue

 ./runInstaller -silent -ignorePrereqFailure -waitforcompletion -responseFile /u01/app/oracle/soft/install/response/db_install.rsp -debug

Wednesday 11 January 2023

How to shrink datafiles, when you need to rebuild tables/indexes, or move LOBs around

 Below are 2 links with very good explanations, thanks to Jonathan Lewis!!!


https://jonathanlewis.wordpress.com/tablespace-hwm/


https://jonathanlewis.wordpress.com/2010/02/06/shrink-tablespace/


These help when you get:

ORA-03297: file contains used data beyond requested RESIZE value

but there is a lot of free space in the datafile, just not compacted.

Tuesday 13 December 2022